home / portal / procurement_coverage_cells

procurement_coverage_cells: 40

The coverage matrix, one row per source x record kind x fiscal year, each carrying its state, its count, why it is in that state and the SQL that produced the count. Run the evidence_sql and you get n_records back.

This data as json

rowid source_key source_label record_kind record_kind_label fy_key state n_records prev_n_records why_code why_text evidence_kind evidence_sql evidence_citation evidence_lf_id probed_for_publication is_crawl_dependent drill_url computed_at run_id
40 gvibuy_blankets GVIBuy master blanket register master-blanket Master blanket contracts in force on the snapshot date no-fy-in-record PARTIAL 109 109 blanket-survivor-register This is the live contract register on one date, not a history. 373 of the 854 contracts in it had expired on 2026-09-02 - the earliest end date is 2021-02-09 - so contracts that ended before the snapshot are absent and cannot be recovered from this source. GVIBuy's own purchase-order type filter separately calls 8,684 documents Blanket, so this register is well under half the contract population by the government's own field. The year here is the year inside the identifier. It is a numbering year, not a spending year, so this cell counts RECORDS by when they were numbered and never when money moved. MEASURED SELECT COUNT(*) FROM gvibuy_blankets WHERE CASE WHEN blanket_number LIKE 'PO-%' THEN 'FY20'||substr(blanket_number,4,2) ELSE 'no-fy-in-record' END = 'no-fy-in-record'       0 /procurement/chain?source=gvibuy_blankets&kind=master-blanket&fy=no-fy-in-record 2026-11-21T22:40:46Z 2026-11-21T22:36:15Z
Powered by Datasette · Queries took 1.881ms