Contrats octroyés Les données sur les Contrats octroyés sont des renseignements sur les contrats attribués par Travaux publics et Services gouvernementaux Canada (TPSGC) depuis janvier 2009, au nom des ministères et organismes fédéraux. Les fichiers CSV sont mis à jour mensuellement, et sont organisés par années fiscales. Le fichier complet, saisissant des données de 2009 à aujourd’hui, est également téléchargeable à partir de cette page. Pour plus de renseignements sur les contrats octroyés, visitez la page "À propos des Contrats octroyés": https://achatsetventes.gc.ca/donnees-sur-l-approvisionnement/contrats-octroyes/a-propos-des-contrats-octroyes. Le dictionnaire des données sur l'approvisionnement offre une définition de chaque champ de données utilisé dans les fichiers Contracts octroyés, ainsi que dans autres jeux de données publiés sur Achatsetventes.gc.ca. Ce fichier XML sert de guide pour comprendre les différents champs de données. Il est mis à jour au besoin pour refléter les changements apportés aux champs de données sur Achatsetventes.gc.ca. 2013-03-08 2017-03-16 Services publics et Approvisionnement Canada open-ouvert@tbs-sct.gc.ca Économie et industriecontratsappels d'offresSEAOGavisfournisseuroffre à commandesarrangements en matière d'approvisionnementNIBSbiensservicesconstruction Dictionnaire des données sur l'approvisionnementXML https://buyandsell.gc.ca/cds/public/datadictionary/tpsgc-pwgsc_dd.xml Fichier complet : 2009 à aujourd’huiCSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_tous-all.csv 2009 janvier - marsCSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_Jan-Mar-09.csv Exercice financier 2009-2010CSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_EF-FY-09-10.csv Exercice financier 2010-2011CSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_EF-FY-10-11.csv Exercice financier 2011-2012CSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_EF-FY-11-12.csv Exercice financier 2012-2013CSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_EF-FY-12-13.csv Exercice financier 2013-2014CSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_EF-FY-13-14.csv Exercice financier 2014-2015CSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_EF-FY-14-15.csv Exercice financier 2015-2016CSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_EF-FY-15-16.csv Exercice financier 2016-2017CSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_EF-FY-16-17.csv

Contrats octroyés

Les données sur les Contrats octroyés sont des renseignements sur les contrats attribués par Travaux publics et Services gouvernementaux Canada (TPSGC) depuis janvier 2009, au nom des ministères et organismes fédéraux.

Les fichiers CSV sont mis à jour mensuellement, et sont organisés par années fiscales. Le fichier complet, saisissant des données de 2009 à aujourd’hui, est également téléchargeable à partir de cette page. Pour plus de renseignements sur les contrats octroyés, visitez la page "À propos des Contrats octroyés": https://achatsetventes.gc.ca/donnees-sur-l-approvisionnement/contrats-octroyes/a-propos-des-contrats-octroyes.

Le dictionnaire des données sur l'approvisionnement offre une définition de chaque champ de données utilisé dans les fichiers Contracts octroyés, ainsi que dans autres jeux de données publiés sur Achatsetventes.gc.ca. Ce fichier XML sert de guide pour comprendre les différents champs de données. Il est mis à jour au besoin pour refléter les changements apportés aux champs de données sur Achatsetventes.gc.ca.

  • Éditeur - Nom actuel de l’organisation: Services publics et Approvisionnement Canada
  • Organisation - Titre lors de la publication: Travaux publics et Services gouvernementaux Canada
  • Licence: Licence du gouvernement ouvert - Canada

Ressources

Nom de la ressource Type de ressource Format Langue Liens
Dictionnaire des données sur l'approvisionnement Guide XML Anglais
Français
Accès
Fichier complet : 2009 à aujourd’hui Jeu de données CSV Anglais
Français
Accès
2009 janvier - mars Jeu de données CSV Anglais
Français
Accès
Exercice financier 2009-2010 Jeu de données CSV Anglais
Français
Accès
Exercice financier 2010-2011 Jeu de données CSV Anglais
Français
Accès
Exercice financier 2011-2012 Jeu de données CSV Anglais
Français
Accès
Exercice financier 2012-2013 Jeu de données CSV Anglais
Français
Accès
Exercice financier 2013-2014 Jeu de données CSV Anglais
Français
Accès
Exercice financier 2014-2015 Jeu de données CSV Anglais
Français
Accès
Exercice financier 2015-2016 Jeu de données CSV Anglais
Français
Accès
Exercice financier 2016-2017 Jeu de données CSV Anglais
Français
Accès

Commentaires(37 )

Hi Looking at the whole dataset I unsderstood that the contract-number feature could be the primary key given that there shouldnt be any repeated contracts. However visualizing it in neo4j I noticed that the contract-number: W8482-03RF03/001/ML appears twice. Upon longer inspection it seemed that there are two different contracts for the Department of national defence. At first I thought one could be a copy, but the dates and the number of amendment differe from one another. Is the contract number wrong ??

Thank you for your comment and your interest in the Contract History dataset. Contract History is information about contracts awarded by Public Services and Procurement Canada (PSPC) on behalf of federal departments and agencies since January 2009. Contract number W8482-03RF03/001/ML has been amended 5 times since it was originally issued. As the original contract record and its amendments 001, 002 and 003 predate January 2009, they are not included in the dataset. When an amendment is issued, this is done to the latest version of the contract, and so the contract number never changes. In the case of contract number W8482-03RF03/001/ML, the contract number is correct and the dataset includes amendments 004 and 005.

Hi, thank you for your comment. We have forwarded your question to the data owner, we will provide an update once we receive a response. Momin, Open Government team.

The data provided is disappointingly incomplete. I think it would be useful if, along with the instructions for this data, PWGSC also reported the proportion of contracts awarded through PWGSC on behalf of federal departments and agencies out of all contracts awarded through federal departments and agencies. As it stands, the data is not useful for understanding federal contract activity in our industry.

D’importantes mises à jour ont été apportées â nos fichiers de données ouvertes le mercredi 22 juin 2016. La dernière rangée intitulée « End of feed » a été retirée des fichiers et une nouvelle colonne intitulée « Date de publication du fichier » a été ajoutée. Cette nouvelle colonne sert à indiquer la date (AAAA-MM-JJ) et l’heure à laquelle le fichier a été créé.

On Wednesday, June 22, 2016, important updates were made to our open data files. The "End of feed" line was removed from the data files and a “Date file published" column was added. The new “Date file published” column indicates the date (YYYY-MM-DD) and time that the data file was generated.

Le lien XML de vos documents ne pointe vers aucune base de données ce qui provoque une erreur. Merci

Nous vous remercions de nous faire part de votre commentaire et de votre intérêt au jeu de données "Contrats octroyés." Le fichier XML nommé « Dictionnaire des données sur l'approvisionnement » semble télécharger sans erreur à l’instant. Pouvez-vous nous décrire le message d’erreur apparaissant à l’écran lorsque vous tentez d’accéder au fichier XML, ainsi que l’heure à laquelle vous avez fait l’expérience de cette erreur? Cela nous aidera à résoudre le problème.

Hi PWGSC! I want to use this data set to find out how much the Government of Canada procures R&D and also break that down by firm size. Is this a valid use? If so can you recommend the indicators to look at? Creig

Nous vous remercions de nous faire part de votre commentaire et de votre intérêt au jeu de données "Contrats octroyés." Tous les achats en R & D sont classés dans le groupe "A" des codes NIBS. Veuillez noter que les ministères peuvent se procurer des biens, des services et des technologies innovants qui peuvent ne pas avoir été classés sous R & D. Nos dossiers ne comprennent pas les renseignements quant à la taille de l'entreprise car cela n’est pas saisi dans le contrat. La répartition des différentes catégories dans le cadre du groupe de R & D sont répertoriés ici: https://achatsetventes.gc.ca/donnees-sur-l-approvisionnement/numero-d-identification-des-biens-et-services/nibs/A. Vous trouverez tous les dossiers contractuels R & D dans les fichiers de données en filtrant la colonne "NIBS " pour inclure uniquement les codes qui commencent par un « A ». Alternativement, vous pouvez également trouver ces dossiers sur Achatsetventes.gc.ca en recherchant les Contrats octroyés, et en sélectionnant "A: Recherche et développement (R & D)" sous le filtre "biens et services". Ceci affinera votre recherche aux 7948 dossiers de contrats existants qui ont été émis par TPSGC depuis 2009. Voici un lien vers les résultats de la recherche : https://achatsetventes.gc.ca/donnees-sur-l-approvisionnement/search/site?f[0]=sm_facet_procurement_data%3Adata_data_ch&f[1]=sm_facet_gsin%3AS&f[2]=sm_facet_gsin%3AS-A.

Thank you for your comment and your interest in the “Contract History” dataset. All R&D procurements are classified under the group “A” GSIN codes. Please note that departments may procure innovative goods, services, and technology that may not have been classified under R&D. Our records do not include details as to the size of the firm as this is not captured under contracting. The breakdown of the various categories under the R&D group are listed here: https://buyandsell.gc.ca/procurement-data/goods-and-services-identification-number/gsin/A. You may find all the R&D contract records in the data files by filtering the “GSIN” column to include only the codes that start with an “A”. Alternatively, you may also find these records on Buyandsell.gc.ca by searching for Contract History, and selecting “A: Research and Development (R&D)” under the “Goods and Services” filter. This will narrow your results to the existing 7948 contract records that have been issued by PWGSC since 2009. Here is a link to the search results: https://buyandsell.gc.ca/procurement-data/search/site?f[0]=sm_facet_procurement_data%3Adata_data_ch&f[1]=sm_facet_gsin%3AS&f[2]=sm_facet_gsin%3AS-A

In the latest Complete file, the cumulative total value of a contract appears to equal the contract value. Is this an error or will the file no longer have the cumulative total value of a contract?

Thank you for your comment and your interest in the “Contract History” dataset. The "total-contract-value" field equalling the “contract-value” field is not an error. If the total contract value is paid out to the supplier in one single payment/transaction, the "total-contract-value" will equal the “contract-value”. Please note that the current Complete file also contains records where the "total-contract-value" does not equal the “contract-value” field. For more information on Contract History data, please visit https://buyandsell.gc.ca/procurement-data/contract-history.

Le 1er avril 2015, Travaux publics et Services gouvernementaux Canada (TPSGC) apportera des changements à sa présence sur le Portail de données ouvertes du gouvernement du Canada. Ces changements ne toucheront nullement les données appartenant aux jeux de données Appels d'offres, Contrats octroyés, Numéro d'identification des biens et services, et Offres à commandes et arrangements en matière d'approvisionnement de TPSGC. Néanmoins, nous supprimerons certains fichiers et modifierons le Dictionnaire des données sur l’approvisionnement trouvées sur le Portail des données ouvertes du gouvernement du Canada. La liste complète des changements qui prendront effet le 1er avril 2015 est affichée sur Achatsetventes.gc.ca : https://achatsetventes.gc.ca/changements-aux-donnees-sur-l-approvisionnement-que-tpsgc-diffuse-sur-le-portail-des-donnees-ouvertes

On April 1, 2015, Public Works and Government Services Canada will update its presence on the Government of Canada’s Open Data portal. None of the changes will impact the data in PWGSC’s Tender Notices, Contract History, Goods and Services Identification Number, and Standing Offers and Supply Arrangements datasets found at the Government of Canada Open Data Portal. Nevertheless, we will remove some files and update the Procurement Data Dictionary. A complete list of the changes coming April 1, 2015 is available on Buyandsell.gc.ca: https://buyandsell.gc.ca/updates-to-pwgsc-procurement-data-on-the-open-data-portal

Thank you for your comment and your interest in the “Contract History” dataset. The appearance of contracts with expiry dates in advance of award dates is the result of data generation issues with the source system. We are currently looking into a solution for this inconsistency.

Thank you for your comment and your interest in the “Contract History” dataset. Data published in the tpsgc-pwgsc_ocama-sosa file relates to standing offers and supply arrangements (SOSA). Standing offers and supply arrangements are not contracts and therefore will not be found in the Contract History file. For more information on the Government of Canada’s procurement process, including the different methods of supply, such as contracts, standing offers and supply arrangements, please visit: https://buyandsell.gc.ca/for-businesses/selling-to-the-government-of-canada/the-procurement-process.

Thank you for your comment and your interest in the “Contract History” dataset. PWGSC Contract History data is generally updated monthly. Note that we are currently experiencing delays in generating a complete Contract History file. An updated file should be posted shortly.

Can you advise when you will respond to my queries made on the 9th ... Thanks

Your request has been sent to the data provider. A follow up will be done. Thank you.

Why are there records of contracts in the tpsgc-pwgsc_ocama-sosa file e.g. 21539-130001/007/STN that are not in the contract history file?

What is the frequency of update? It appears that the last update was done 2014-10-23. Thanks

How to interpret the data when the contract expiry dates that are in advance of the contract date e.g. 01005-010324/009/WPG has contract award dates in 2009/2010/2011/2012 but the expiry date is 31/03/2008 for all records in the file.

Hi it looks like the "Microsoft" CSV files are not following the same meta ordinal schema as the "regular" csv files. Is there a reason for this? This files look like they are not being generated properly ie the data matching the columns. Thanks

The “_microsoft.csv” formatted files have been updated to match the “.csv” formatted files. The columns are now aligned.

The resource name file “Complete” (tpsgc-pwgsc_co-ch_tous-all.csv) contains information about all contracts awarded by Public Works and Government Services Canada (PWGSC) since January 2009 up until the latest monthly update. The Contract History data contained in the “Complete” file can also be visualized and searched on Buyandsell.gc.ca. To view/search this data on Buyandsell.gc.ca, go to: https://buyandsell.gc.ca/procurement-data/search/site?f%5B0%5D=sm_facet_procurement_data%3Adata_data_ch

The Contract History resources names are representative of the information contained in each file. Note that each file is published in two formats. The first file entitled “Procurement Data Dictionary” offers a description of each data field contained in the Contract History files. It is meant to be used as a guide for understanding the data. The second file entitled “Complete”/ “Complete Microsoft” contains information about all contracts awarded by Public Works and Government Services Canada (PWGSC) since January 2009 up until the latest monthly update. The remaining datasets are Contract History files sorted by fiscal year (the “Complete” file divided by fiscal year).

Typical Government taking 4 years to answer a simple comment, I was going to use this data for my CODE application, I am moving on now, really don't want to waste more time.... I don't understand the point of having 2 CSV files for the same data.... good dataset, terrible response rate!

The dataset resource names should be clear. Its hard to tell which data resource is the correct one.

Hi quick question what is contained in the csv tpsgc-pwgsc_co-ch_tous-all.csv. It appears to contain a limited range of data and hence not everything or "all". Is that a correct assumption on my part? Cheers

why is there no response?

The "total-contract-value" field specifies the final monetary value of the contract. It is the total value of the contract awarded to a specific supplier against a specific tendering opportunity. This "total-contract-value" can be paid out to the supplier in one, or more payments: each payment has a "contract-value", representing the monetary value of that transaction. This is why each contract published on Buyandsell.gc.ca features both fields. Note that the "total-contract-value" can be modified as the project advances. To know the final value of the contract, users must consult the "total-contract-value" field on the last contract awarded to the supplier against that specific opportunity. The contract number is a unique identifier that links all contracts awarded to a specific supplier against a specific opportunity on Buyandsell.gc.ca.

Contract History records may reflect the issuance of procurement instruments (methods of supply), such as standing offers or supply arrangements. A total contract value of 0.00 means that a procurement instrument was issued. If a procurement instrument is actually used, a contract record with actual dollar values will be issued.

There are a number of contract listings that have both a contract value of 0.00 and a total contract value of 0.00. Can you explain what the contracts signify if there is no monetary value attached to them?

Hello. I see that there is a column titled "contract-value" and another column titled "total-contract-value." I read in your data dictionary that "contract-value specifies the monetary value of the contract," while "total-contract-value specifies the cumulative monetary value of the contract." Can you please explain what is the difference between these two columns; I still do not understand the definitions. Which columns specifies the final value of the contract?

I see more than 5,000 entries in 2014 where the value of the contract is either zero or a negative number. What does that mean?

Hello, The following reply has been posted on behalf of Public Works and Government Services Canada: Contract amendments for the value field reflect changes to the cumulative value of the entire contract. In an amendment, anything can be modified. If the value is $0 for a contract amendment, it means the cumulative value of the contract did not change. If the value is negative, it means there was a decrease in the total contract value. Thank you.