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.

Licence:

Dataset Resources

Resource Name Format Language Link
Procurement Data Dictionary XML Bilingual (English and French) Download
Complete file: 2009 to today CSV Bilingual (English and French) Download
2009 January - March CSV Bilingual (English and French) Download
2009-2010 fiscal year CSV Bilingual (English and French) Download
2010-2011 fiscal year CSV Bilingual (English and French) Download
2011-2012 fiscal year CSV Bilingual (English and French) Download
2012-2013 fiscal year CSV Bilingual (English and French) Download
2013-2014 fiscal year CSV Bilingual (English and French) Download
2014-2015 fiscal year CSV Bilingual (English and French) Download
2015-2016 fiscal year CSV Bilingual (English and French) Download
2016-2017 fiscal year CSV Bilingual (English and French) Download

Developer Tools

  • The information on this page (the dataset metadata) is also available in JSON format
    Link to JSON format

Comments

  • Keith

    2014-06-04

    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?

  • open-ouvert

    2014-06-05

    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.

  • Jessica H

    2014-12-04

    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?

  • Terrence

    2014-09-30

    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?

  • Buyandsell.gc.ca

    2014-10-14

    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.

  • Public Works and Government Services Canada

    2015-01-26

    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.

  • Patches

    2015-02-05

    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

  • Patches

    2015-02-17

    why is there no response?

  • Jennifer

    2015-02-08

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

  • Jennifer

    2015-02-18

    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!

  • Public Works and Government Services Canada

    2015-02-19

    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).

  • Public Works and Government Services Canada

    2015-02-19

    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

  • Patches

    2015-03-02

    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

  • Public Works and Government Services Canada

    2015-03-23

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

  • Lucy

    2015-03-09

    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.

  • Lucy

    2015-03-09

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

  • Lucy

    2015-03-09

    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?

  • Lucy

    2015-03-21

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

  • open-ouvert

    2015-03-23

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

  • Public Works and Government Services Canada

    2015-03-25

    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.

  • Public Works and Government Services Canada

    2015-03-25

    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.

  • Public Works and Government Services Canada

    2015-03-25

    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.

  • Public Works and Government Services Canada

    2015-03-31

    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

  • Lucy

    2015-05-03

    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?

  • Public Works and Government Services Canada

    2015-05-20

    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.

  • Creig Lamb

    2016-03-03

    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

  • Public Works and Government Services Canada

    2016-03-04

    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

  • Public Works and Government Services Canada

    2016-06-23

    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.