home / portal / procurement_coverage_cells

procurement_coverage_cells: 76

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
76 dpp_contracts DPP contract register (dpp.vi.gov) contract-amount The dollar value of a DPP contract not-applicable NOT HELD 0 0 dpp-amounts-broken-code Populated on 0 of 2,596 register rows. The amounts are expected inside the contract PDFs, 2,382 of which are already downloaded to this machine, and our parser has never been able to open one - it fails against this schema before it reads anything. We have NOT verified that those PDFs contain extractable amounts, so probed_for_publication is 0. Broken code is not absent data, and no amount is published from an empty column. MEASURED SELECT COUNT(*) FROM dpp_contracts WHERE contract_amount IS NOT NULL     0 0 /procurement/coverage#why-dpp-amounts-broken-code 2026-11-21T22:40:46Z 2026-11-21T22:36:15Z
Powered by Datasette · Queries took 1.771ms