procurement_vendor_strings: 47
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47 | AECOM Caribe, LLP | AECOM CARIBE | vendor | 0 | 0 | 0 | 1 | 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. | ["AECOM CARIBE, LLP"] | 0 | 1 | 2026-11-21T22:36:21Z | pv-c6b0d6196bc9 |