Contracts over $10,000
- Keep rows whose vendor postal code starts with A (Newfoundland and Labrador) and whose vendor country is Canada or blank. Two placeholder records ("Company XYZ") are dropped.
- Group rows by procurement identifier and vendor name (spelling and punctuation ignored), across departments: some Coast Guard purchase orders are reported by both Fisheries and Oceans and National Defence. Rows with no procurement identifier stay on their own.
- Keep the latest row in each group (by reporting period, then contract date). Its contract value is the running total after all amendments.
As published: 9,882 rows, $11,888,299,441. Counted once: 8,537 contracts, $2,631,274,652. "Non-competitive" means the department coded the solicitation procedure TN.
Grants and contributions
Departments report amendments two ways. Most re-report the agreement's whole value under a new reference number each time; for those the latest amendment is kept. Indigenous Services Canada and Crown-Indigenous Relations report each amendment as the change in value (their files include negative amounts); for those the amendments are added up. Agreements are grouped by department, agreement number and recipient. Values are agreement values and can span several years. As published: 35,876 rows, $11,680,096,860. Counted once: 29,465 agreements, $8,674,146,639.
CanadaBuys award notices
Grouped by reference number and supplier, latest amendment kept. The same contract can appear here and in the contracts disclosure, so notices are shown and searchable but never added to a total.