u/kapnkrispy

I pulled all 1.3 million federal contract records from the Government of

Canada's open data and looked at one question: who's holding contracts that

are about to come up for renewal?

A few things surprised me.

26,240 federal contracts are currently live, worth $125B. Of the ones that

report a bidder count, 75% drew one bid or none.

And roughly 63 contracts cross into the 12-month planning window every single

week — about $19B of contract value a year.

That last number is the interesting one. Agencies typically start recompete

planning 12–18 months before a contract ends. So the moment a contract crosses

that line is the moment it becomes worth a conversation. It's all public, but

nobody was watching for it.

So I built something that does. It's free, it updates itself monthly, and it

shows you which contracts are expiring, who holds them, what they're worth,

and how contested they were last time.

No signup needed to browse it. Link in the comments.

If you bid on federal work, I'd genuinely like to know whether this is useful

or whether I've missed something obvious.

I pulled all 1.3 million federal contract records from the Government of

Canada's open data and looked at one question: who's holding contracts that

are about to come up for renewal?

A few things surprised me.

26,240 federal contracts are currently live, worth $125B. Of the ones that

report a bidder count, 75% drew one bid or none.

And roughly 63 contracts cross into the 12-month planning window every single

week — about $19B of contract value a year.

That last number is the interesting one. Agencies typically start recompete

planning 12–18 months before a contract ends. So the moment a contract crosses

that line is the moment it becomes worth a conversation. It's all public, but

nobody was watching for it.

So I built something that does. It's free, it updates itself monthly, and it

shows you which contracts are expiring, who holds them, what they're worth,

and how contested they were last time.

No signup needed to browse it. Link in the comments.

If you bid on federal work, I'd genuinely like to know whether this is useful

or whether I've missed something obvious.

I pulled all 1.3 million federal contract records from the Government of

Canada's open data and looked at one question: who's holding contracts that

are about to come up for renewal?

A few things surprised me.

26,240 federal contracts are currently live, worth $125B. Of the ones that

report a bidder count, 75% drew one bid or none.

And roughly 63 contracts cross into the 12-month planning window every single

week — about $19B of contract value a year.

That last number is the interesting one. Agencies typically start recompete

planning 12–18 months before a contract ends. So the moment a contract crosses

that line is the moment it becomes worth a conversation. It's all public, but

nobody was watching for it.

So I built something that does. It's free, it updates itself monthly, and it

shows you which contracts are expiring, who holds them, what they're worth,

and how contested they were last time.

No signup needed to browse it. Link in the comments.

If you bid on federal work, I'd genuinely like to know whether this is useful

or whether I've missed something obvious.

I pulled all 1.3 million federal contract records from the Government of

Canada's open data and looked at one question: who's holding contracts that

are about to come up for renewal?

A few things surprised me.

26,240 federal contracts are currently live, worth $125B. Of the ones that

report a bidder count, 75% drew one bid or none.

And roughly 63 contracts cross into the 12-month planning window every single

week — about $19B of contract value a year.

That last number is the interesting one. Agencies typically start recompete

planning 12–18 months before a contract ends. So the moment a contract crosses

that line is the moment it becomes worth a conversation. It's all public, but

nobody was watching for it.

So I built something that does. It's free, it updates itself monthly, and it

shows you which contracts are expiring, who holds them, what they're worth,

and how contested they were last time.

No signup needed to browse it. Link in the comments.

If you bid on federal work, I'd genuinely like to know whether this is useful

or whether I've missed something obvious.

I pulled all 1.3 million federal contract records from the Government of

Canada's open data and looked at one question: who's holding contracts that

are about to come up for renewal?

A few things surprised me.

26,240 federal contracts are currently live, worth $125B. Of the ones that

report a bidder count, 75% drew one bid or none.

And roughly 63 contracts cross into the 12-month planning window every single

week — about $19B of contract value a year.

That last number is the interesting one. Agencies typically start recompete

planning 12–18 months before a contract ends. So the moment a contract crosses

that line is the moment it becomes worth a conversation. It's all public, but

nobody was watching for it.

So I built something that does. It's free, it updates itself monthly, and it

shows you which contracts are expiring, who holds them, what they're worth,

and how contested they were last time.

No signup needed to browse it. Link in the comments.

If you bid on federal work, I'd genuinely like to know whether this is useful

or whether I've missed something obvious.

I pulled all 1.3 million federal contract records from the Government of

Canada's open data and looked at one question: who's holding contracts that

are about to come up for renewal?

A few things surprised me.

26,240 federal contracts are currently live, worth $125B. Of the ones that

report a bidder count, 75% drew one bid or none.

And roughly 63 contracts cross into the 12-month planning window every single

week, about $19B of contract value a year.

That last number is the interesting one. Agencies typically start recompete

planning 12–18 months before a contract ends. So the moment a contract crosses

that line is the moment it becomes worth a conversation. It's all public, but

nobody was watching for it.

So I built something that does. It's free, it updates itself monthly, and it

shows you which contracts are expiring, who holds them, what they're worth,

and how contested they were last time.

No signup needed to browse it. Link in the comments.

If you bid on federal work, I'd genuinely like to know whether this is useful

or whether I've missed something obvious.

I've been working with the federal tender open data feed from CanadaBuys and hit something I can't explain. The tender Status field stays "Open" well past the closing date. I pulled the "currently open" file - 893 notices - and found several with closing dates more than a year in the past. Worst one was 348 days expired, still flagged Open.

Two other things that tripped me up:

1. The dataset description on open.canada.ca and the PSPC supporting docs give two different names for the status column. The description says tenderStatus-tenderStatut-eng, the supporting docs say tenderStatus-appelOffresStatut-eng. Production uses the second one, so if you built against the first your filter silently returns nothing, no error.

2. Most notices have no URL in the data. Only the MERX-hosted ones carry a link. The CanadaBuys page slugs look like bt-<uuid> or qc20160100, so you can't construct one from any published field.

Questions for people who work with this daily:

- Is the stale status field expected behaviour, or a known issue?

- Do SEAO or BC Bid have the same problem, or is this specific to the federal feed?

- Is there a canonical way to link to a CanadaBuys notice that I'm missing?

Happy to share what I did to work around each if it's useful to anyone.