home / portal / procurement_coverage_cells

procurement_coverage_cells: 73

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
73 dpp_contracts DPP contract register (dpp.vi.gov) contract-register-entry Register entries, each linking a contract PDF FY2025 PARTIAL 55 55 dpp-register-lists-pdfs 55 register rows carrying 55 distinct contract ids - renewals and amendments are separate rows naming the same contract, which is why the two numbers differ and why these are ENTRIES and not contracts. 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 substr(n,-2) IN ('25') 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=FY2025 2026-11-21T22:40:46Z 2026-11-21T22:36:15Z
Powered by Datasette · Queries took 1.954ms