Canada: Québec: Secrétariat du Conseil du trésor

The Secrétariat du Conseil du trésor in Quebec, Canada, publishes open contracting data via their portal: Système électronique d’appel d’offres (SEAO).

The electronic tendering system was set up by the government of Quebec to comply with their Action plan promoting an Open Government 2020-2021. It serves mainly to disseminate calls for tenders from public bodies and municipalities, and the results of their contracts. The SEAO was developed for the needs of the Government of Quebec by the firm CGI which was selected following a public call for tenders by the Secretariat of the Council of treasure (TBS). CGI is the operator of SEAO.

Available formats:
JSON
Excel
CSV

Overview

Data date range:
May 2004 - Oct 2024
Update frequency:
Monthly
Main language:
French
OCID prefix:
ocds-ec9k95
License:
Creative Commons Attribution 4.0 International (CC BY 4.0)

You are free to:

  • Share — copy and redistribute the material in any medium or format
  • Adapt — remix, transform, and build upon the material for any purpose, even commercially.

The licensor cannot revoke these freedoms as long as you follow the license terms.

Under the following terms:

  • Attribution — You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
  • No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.
Publication policy:
https://www.donneesquebec.ca/recherche/dataset/systeme-electronique-dappel-doffres-seao#fiche_descriptive
Last retrieved:
Nov 2024 (retrieved monthly)
Retrieved from:
https://www.donneesquebec.ca/recherche/dataset/systeme-electronique-dappel-doffres-seao

Data available

A contracting process has several stages: tendering, awarding, contracting and implementation. You can learn about the contracting stages in this tutorial.

Parties

Count of parties:
858,491

Planning

Count of planning activities:
0

Tenders

Count of tenders:
263,142
Count of tenderers:
548,811
Count of tender items:
266,982

Awards

Count of awards:
326,039
Count of suppliers:
326,043
Count of award items:
0

Contracts

Count of contracts:
169,623
Count of contract items:
0
Count of transactions:
11,558

Documents

Count of documents:
332,329

Milestones

Count of milestones:
0

Amendments

Count of amendments:
10,213

The lots extension is used. There is a bids array and the additional fields:

  • tender/deliveryarea
  • awards/value/totalAmount and awards/value/totalamount
  • parties/details/Municipal and parties/details/municipal
  • parties/details/NEQ and parties/details/neq

Data quality

Summary

The dataset has quality issues to take into account, notably:

  • There are some duplicate release identifiers.
  • Organization identifiers are missing for buyers and appear in another object (the details object) for suppliers and tenderers.

Last reviewed: May 2021

Access data

This OCDS dataset is available for download in JSON, Excel or CSV format. You can download the data for contracting processes in a specific year or for all time.

JSON

Each contracting process is represented as one line of JSON text in the .jsonl file.

The .jsonl file is compressed using Gzip. Windows users need 7-Zip, WinRAR or WinZip to decompress the .gz file.

Excel

Each contracting process is represented as one row in the main sheet. Other sheets link to it via the _link_main column.

Excel files can have at most 1,048,576 rows. If a year is missing, it had too many rows. Download the CSV files, instead.

CSV

Each contracting process is represented as one row in the main.csv file. Other files link to it via the _link_main column.

The .csv files are archived using tar and compressed using Gzip. Windows users need 7-Zip, WinRAR or WinZip to decompress the .tar.gz file.

Do you have any questions or feedback on this dataset or any other content on this page?