procurement_coverage_cells: 75
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 |