home / portal / procurement_vendor_strings

procurement_vendor_strings: 59

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
59 ALTONY PAINTING AND LANDSCAPING, JOSEPH SCHULTERBRANDT LANDSCAPING, Julio Landscaping and Maintenance, Edge 2 Edge Landscaping, KING'S LANDSCAPING & MAINTENANCE SERVICE, SANCHEZ LANDSCAPING, GARDENING & MAINTENCE CO., GREAT GROUNDS ENTERPRISES, LLC, HIGH GRADE CLEANING SERVICES, SIMPLICITY LANDSCAPING, PAINTING, & CLEANING SERVICES, LLC, O.R.D. INC., FRANKLIN SCHULTERBRANDT LANDSCAPING, Gringo's Landcaping & Trash Removal, Rijo Consultant, Repairs & Maintenance, LLC, FABIEN'S TRUCKING, LLC, GOTTI'S CLEANING & MAINTENANCE SERVICES, LLC ALTONY PAINTING AND LANDSCAPING JOSEPH SCHULTERBRANDT LANDSCAPING JULIO LANDSCAPING AND MAINTENANCE EDGE 2 EDGE LANDSCAPING KING S LANDSCAPING & MAINTENANCE SERVICE SANCHEZ LANDSCAPING GARDENING & MAINTENCE GREAT GROUNDS ENTERPRISES HIGH GRADE CLEANING SIMPLICITY LANDSCAPING PAINTING & CLEANING O R D FRANKLIN SCHULTERBRANDT LANDSCAPING GRINGO S LANDCAPING & TRASH REMOVAL RIJO CONSULTANT REPAIRS & MAINTENANCE FABIEN S TRUCKING GOTTI S CLEANING & MAINTENANCE multi-vendor-list Names 15 parties: ALTONY PAINTING AND LANDSCAPING; JOSEPH SCHULTERBRANDT LANDSCAPING; Julio Landscaping and Maintenance; Edge 2 Edge Landscaping; KING'S LANDSCAPING & MAINTENANCE SERVICE; SANCHEZ LANDSCAPING, GARDENING & MAINTENCE CO.; GREAT GROUNDS ENTERPRISES, LLC; HIGH GRADE CLEANING SERVICES; SIMPLICITY LANDSCAPING, PAINTING, & CLEANING SERVICES, LLC; O.R.D. INC.; FRANKLIN SCHULTERBRANDT LANDSCAPING; Gringo's Landcaping & Trash Removal; Rijo Consultant, Repairs & Maintenance, LLC; FABIEN'S TRUCKING, LLC; GOTTI'S CLEANING & MAINTENANCE SERVICES, LLC. Its 14 boundaries were read: 8 from both sides appearing separately as vendor strings in this same data, 6 from a completed legal form followed by more name. Every part is either recorded separately as a vendor string in this same data or ends in its own legal form, so the count as well as the boundaries is supported. 0 0 1 0 L4 L4 — no checkbook vendor of this name at L1 or L2. This is where 1,155 of the 1,976 procurement vendor strings sit, 58.5% of them.   0 over-stripped-suffix: normalize() stripped CO, INC, LLC from inside the name (SUFFIX_RE is word-bounded but not end-anchored) and stripped SERVICES, an ordinary word on the suffix list rather than a legal form, leaving the key 'ALTONY PAINTING AND LANDSCAPING JOSEPH SCHULTERBRANDT LANDSCAPING JULIO LANDSCAPING AND MAINTENANCE EDGE 2 EDGE LANDSCAPING KING S LANDSCAPING & MAINTENANCE SERVICE SANCHEZ LANDSCAPING GARDENING & MAINTENCE GREAT GROUNDS ENTERPRISES HIGH GRADE CLEANING SIMPLICITY LANDSCAPING PAINTING & CLEANING O R D FRANKLIN SCHULTERBRANDT LANDSCAPING GRINGO S LANDCAPING & TRASH REMOVAL RIJO CONSULTANT REPAIRS & MAINTENANCE FABIEN S TRUCKING GOTTI S CLEANING & MAINTENANCE' 0 2026-11-21T22:36:21Z pv-c6b0d6196bc9
Powered by Datasette · Queries took 1.576ms