Contract History Contract History is information about contracts awarded by Public Works and Government Services Canada (PWGSC) since January 2009, on behalf of federal departments and agencies. The Contract History CSV files are updated monthly, and are organized by fiscal year. A complete Contract History file, containing contracts from 2009 to today is also available for download on this page. Visit the "About Contract History" page to learn more: https://buyandsell.gc.ca/procurement-data/contract-history/about-contract-history. The Procurement Data Dictionary offers a description of each data field contained in the Contract History file, as well as other datasets published on Buyandsell.gc.ca. The XML file is meant to be used as a guide for understanding the various data elements. It is updated on an “as needed” frequency to reflect changes to data elements on Buyandsell.gc.ca. 2013-03-08 2017-07-28 Public Services and Procurement Canada open-ouvert@tbs-sct.gc.ca Economics and IndustrycontractstendersGETSnoticessupplierstanding offerssupply arrangementsvendorGSINgoodsservicesconstruction Procurement Data DictionaryXML https://buyandsell.gc.ca/cds/public/datadictionary/tpsgc-pwgsc_dd.xml Complete file: 2009 to todayCSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_tous-all.csv 2009 January - MarchCSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_Jan-Mar-09.csv 2009-2010 fiscal yearCSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_EF-FY-09-10.csv 2010-2011 fiscal yearCSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_EF-FY-10-11.csv 2011-2012 fiscal yearCSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_EF-FY-11-12.csv 2012-2013 fiscal yearCSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_EF-FY-12-13.csv 2013-2014 fiscal yearCSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_EF-FY-13-14.csv 2014-2015 fiscal yearCSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_EF-FY-14-15.csv 2015-2016 fiscal year CSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_EF-FY-15-16.csv 2016-2017 fiscal year CSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_EF-FY-16-17.csv 2017-2018 fiscal yearCSV https://buyandsell.gc.ca/cds/public/contracts/tpsgc-pwgsc_co-ch_EF-FY-17-18.csv

Contract History

Contract History is information about contracts awarded by Public Works and Government Services Canada (PWGSC) since January 2009, on behalf of federal departments and agencies.

The Contract History CSV files are updated monthly, and are organized by fiscal year. A complete Contract History file, containing contracts from 2009 to today is also available for download on this page. Visit the "About Contract History" page to learn more: https://buyandsell.gc.ca/procurement-data/contract-history/about-contract-history.

The Procurement Data Dictionary offers a description of each data field contained in the Contract History file, as well as other datasets published on Buyandsell.gc.ca. The XML file is meant to be used as a guide for understanding the various data elements. It is updated on an “as needed” frequency to reflect changes to data elements on Buyandsell.gc.ca.

  • Publisher - Current Organization Name: Public Services and Procurement Canada
  • Publisher - Organization Name at Publication: Public Works and Government Services Canada
  • Licence: Open Government Licence - Canada

Resources

Resource Name Resource Type Format Language Links
Procurement Data Dictionary Guide XML English
French
Access
Complete file: 2009 to today Dataset CSV English
French
Access
2009 January - March Dataset CSV English
French
Access
2009-2010 fiscal year Dataset CSV English
French
Access
2010-2011 fiscal year Dataset CSV English
French
Access
2011-2012 fiscal year Dataset CSV English
French
Access
2012-2013 fiscal year Dataset CSV English
French
Access
2013-2014 fiscal year Dataset CSV English
French
Access
2014-2015 fiscal year Dataset CSV English
French
Access
2015-2016 fiscal year Dataset CSV English
French
Access
2016-2017 fiscal year Dataset CSV English
French
Access
2017-2018 fiscal year Dataset CSV English
French
Access

Comments (39)

When will Q1 FY 17-18 contract history be available?

Thank you for your comment and your interest in the Contract History dataset. The separate file for fiscal year 2017-2018 is now available. Please note that the complete dataset with the latest data may also be accessed in the file "Complete file: 2009 to today".

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 ??

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.

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.

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

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

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.

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.