home / portal / procurement_coverage_cells

procurement_coverage_cells: 75

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
75 dpp_contracts DPP contract register (dpp.vi.gov) contract-register-entry Register entries, each linking a contract PDF no-fy-in-record PARTIAL 1253 1253 dpp-register-lists-pdfs This bucket holds every register row whose contract_number is not a bare legacy contract id with an FY2016-FY2026 suffix: amendment prose such as 'AMENDMENT NO 1 TO ...', parenthetical suffixes, stray numbers, and a handful of rows whose suffix falls outside that range. No fiscal year is read from any of them rather than guessing one. The register lists PDFs, not contract data: contract_amount, effective_date and expiration_date are populated on 139 of all 2,596 rows. That emptiness is our broken code and not DPP withholding, and nothing is published from those columns either way. This register and GVIBuy's are not one series: only 45 register rows name a GVIBuy purchase order at all, so a line drawn from FY2016 to FY2026 across the two would be a line through a change of system. MEASURED WITH cn AS (SELECT UPPER(TRIM(contract_number)) AS n FROM dpp_contracts) SELECT COUNT(*) FROM cn WHERE NOT (substr(n,-2) IN ('16','17','18','19','20','21','22','23','24','25','26') AND (n GLOB '[A-Z][0-9][0-9][A-Z][A-Z][TCRW][0-9][0-9]' OR n GLOB '[A-Z][0-9][0-9][A-Z][A-Z][A-Z][TCRW][0-9][0-9]' OR n GLOB '[A-Z][0-9][0-9][A-Z][A-Z][A-Z][A-Z][TCRW][0-9][0-9]' OR n GLOB '[A-Z][0-9][0-9][A-Z][A-Z][A-Z][A-Z][A-Z][TCRW][0-9][0-9]' OR n GLOB '[A-Z][0-9][0-9][0-9][A-Z][A-Z][TCRW][0-9][0-9]' OR n GLOB '[A-Z][0-9][0-9][0-9][A-Z][A-Z][A-Z][TCRW][0-9][0-9]' OR n GLOB '[A-Z][0-9][0-9][0-9][A-Z][A-Z][A-Z][A-Z][TCRW][0-9][0-9]' OR n GLOB '[A-Z][0-9][0-9][0-9][A-Z][A-Z][A-Z][A-Z][A-Z][TCRW][0-9][0-9]' OR n GLOB '[A-Z][0-9][0-9][0-9][0-9][A-Z][A-Z][TCRW][0-9][0-9]' OR n GLOB '[A-Z][0-9][0-9][0-9][0-9][A-Z][A-Z][A-Z][TCRW][0-9][0-9]' OR n GLOB '[A-Z][0-9][0-9][0-9][0-9][A-Z][A-Z][A-Z][A-Z][TCRW][0-9][0-9]' OR n GLOB '[A-Z][0-9][0-9][0-9][0-9][A-Z][A-Z][A-Z][A-Z][A-Z][TCRW][0-9][0-9]'))       0 /procurement/chain?source=dpp_contracts&kind=contract-register-entry&fy=no-fy-in-record 2026-11-21T22:40:46Z 2026-11-21T22:36:15Z
Powered by Datasette · Queries took 1.965ms