home / portal / procurement_coverage_cells

procurement_coverage_cells: 77

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
77 dpp_contracts DPP contract register (dpp.vi.gov) contract-dates The start and end dates of a DPP contract not-applicable NOT HELD 139 139 dpp-dates-broken-code Populated on 139 of 2,596 register rows - and this one is squarely our fault. dpp.vi.gov's contract pages do publish Contract Start Date and Contract End Date; we fetched pages and read them there. Our scraper's label pattern cannot match those labels, so it throws them away. probed_for_publication is 1 because we probed that route and found the dates published. The only date we can show at scale is the month DPP uploaded the file, which is labelled 'posted by DPP' and is not a contract date. MEASURED SELECT COUNT(*) FROM dpp_contracts WHERE (effective_date IS NOT NULL AND effective_date <> '') OR (expiration_date IS NOT NULL AND expiration_date <> '')     1 0 /procurement/coverage#why-dpp-dates-broken-code 2026-11-21T22:40:46Z 2026-11-21T22:36:15Z
Powered by Datasette · Queries took 1.486ms