home / portal / procurement_coverage_cells

procurement_coverage_cells: 32

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
32 gvibuy_purchase_orders GVIBuy purchase orders unclassified Identifier unreadable, no record kind assigned no-fy-in-record PARTIAL 3 3 identifier-unreadable This cell carries the rows in GVIBuy's purchase-order list that no record kind could be read from. They are returned by none of the type walks GVIBuy's own filters produced, and their identifiers carry no pattern to read a kind from. No kind is guessed for them. The cell is published rather than dropped because the 4,393-row denominator carries this qualification everywhere it is used. The year here is the year inside the identifier. It is a numbering year, not a spending year, so this cell counts RECORDS by when they were numbered and never when money moved. MEASURED SELECT COUNT(*) FROM procurement_po_classification WHERE record_kind IS NULL AND COALESCE(identifier_fy, 'no-fy-in-record') = 'no-fy-in-record'       0 /procurement/chain?source=gvibuy_purchase_orders&kind=unclassified&fy=no-fy-in-record 2026-11-21T22:40:46Z 2026-11-21T22:36:15Z
Powered by Datasette · Queries took 1.52ms