home / portal / procurement_vendor_strings

procurement_vendor_strings: 32

The single denominator for every vendor claim on this site — one row per distinct vendor string across the four procurement-side columns, with its match rung to the checkbook. l3_would_reach is a measured flag, never a join: that rung is withheld.

This data as json

rowid vendor_string vendor_string_norm string_class string_class_note seen_in_po seen_in_blanket seen_in_bid_award seen_in_dpp rung rung_method checkbook_names_json l3_would_reach normalize_defect gets_vendor_page computed_at run_id
32 ABC Sales & Services Inc ABC SALES & vendor   1 1 1 0 L2 L2 — the string reaches a checkbook name only after build_vendor_clusters.normalize(): upper-case, strip punctuation, then strip corporate suffixes (LLC, INC, CO, SERVICES and eighteen more). A documented transformation on both sides, not an identity. ["ABC SALES & SERVICES", "ABC SALES & SERVICES, INC"] 0 over-stripped-suffix: normalize() stripped SERVICES, an ordinary word on the suffix list rather than a legal form, leaving the key 'ABC SALES &' 1 2026-11-21T22:36:21Z pv-c6b0d6196bc9
Powered by Datasette · Queries took 1.664ms