home / portal / procurement_coverage_cells

procurement_coverage_cells: 61

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
61 gvibuy_po_detail GVIBuy purchase-order detail pages detail-page-open-market Detail page held for: Open market purchase orders not-applicable PARTIAL 963 963 detail-layer-held-for-this-kind 963 of the 967 documents of this kind have a detail page fetched. Of the rest, 4 carry a document number a detail request can be built from and have not been fetched: they wait on the detail crawl, which runs separately from the weekly walk of the list. Any figure this surface reads off a detail page is computed over the 963 and never over the 967. MEASURED SELECT COUNT(*) FROM procurement_po_classification k WHERE k.record_kind = 'open-market' AND EXISTS (SELECT 1 FROM gvibuy_po_header_detail h WHERE h.po_number = k.po_number)     1 1 /procurement/chain?source=gvibuy_purchase_orders&kind=open-market&fy=not-applicable 2026-11-21T22:40:46Z 2026-11-21T22:36:15Z
Powered by Datasette · Queries took 1.45ms