Public Works Vendor Sustainability Scores

This dataset benchmarks sustainability performance of vendors supplying products and services for public works projects, including ESG scores, emissions, certifications, waste management, and compliance details. It empowers government procurement teams to evaluate responsible sourcing and track vendor sustainability over time, supporting transparent and data-driven decision-making.

  • last updated 24 Nov 2025
  • by GoMask
The brief that made it

Vendor sustainability benchmarking for public works procurement

Sample rows

preview · 8 of 75 rows · all 24 columns
vendor_idstringcompliance_statusstringaudit_scorefloatcertification_iso_14001booleanaddress_statestringvendor_namestringcontact_namestringcontact_emailstringaddress_streetstringaddress_citystringaddress_postal_codestringaddress_countrystringproduct_or_service_typestringesg_scorefloatemissions_scope_1floatemissions_scope_2floatemissions_scope_3floatcertification_leedbooleancertification_otherstringwaste_management_policybooleanwaste_recycling_ratefloatlast_audit_datedatepublic_works_projects_suppliedintegernotesstring
VEND-0001-ABXcompliant91.2trueWAGreenBridge SuppliesSamantha Carterscarter@greenbridge.com1200 Elm StSeattle98101USAConstruction Materials87.515.434.289falseBREEAMtrue78.22023-11-146Demonstrates leadership in sustainable sourcing.
VEND-0002-YTKcompliant76.4trueCOEcoTech EngineeringJames Leejlee@ecotecheng.com320 Lake AveDenver80202USACivil Engineering Services79.3012.547.2trueEnergy Startrue85.72022-08-223ISO 14001 certified, frequent audits.
VEND-0003-KLMpending66falseTXSunrise Lighting Co.Maria Lopezm.lopez@sunriselighting.com475 Maple RoadAustin78701USALED Lighting68.410.123.736.8trueRoHStrue70.32022-03-058Awaiting LEED renewal.
VEND-0004-QRPcompliant95.8trueCAUrbanFlow ConsultingEdward Kimekim@urbanflow.com890 Pine StSan Francisco94107USAEnvironmental Consulting92.105.337.2falseGRESBtrue98.52024-04-292Leading provider of environmental assessments.
VEND-0005-ZLMpending64.3falseORAquaPure SystemsKaren Smithksmith@aquapure.com41 River RdPortland97205USAWater Treatment Equipment74.79.82028.1falseblankfalse29.42021-11-305blank
VEND-0006-XYJcompliant88.4trueMNBlueSky RecyclingLuke Johnsonljohnson@blueskyrecycling.com665 Oak LaneMinneapolis55402USAWaste Management83.642.562.8170.1falseGreen Sealtrue93.42023-07-1811High recycling rate in Twin Cities region.
VEND-0007-WTRcompliant92.9trueAZSolarGen Inc.Daniel Wudwu@solargen.com390 Sun BlvdPhoenix85004USASolar Power Solutions90.20.93.721.5trueCradle to Cradletrue99.12022-12-024Zero landfill policy.
VEND-0008-PLMnon-compliant48.1falseILMetro ConcreteRyan Patelrpatel@metroconcrete.com1362 Industrial DrChicago60606USAReady-Mix Concrete61.4105.5210.9450.2falseblankfalse18.32021-04-1113Needs improvement in waste management.

What the 75 rows show

from the 75-row sample

Non-compliant (compliance status) stands out: mean audit_score is 41.4, against 82.3 for the rest.

  • 56%certification_iso_14001 = true
  • 81.4median audit_score
  • 2address countries
  • 78.4median esg_score
  • 44.0median emissions_scope_1
  • 36.7median emissions_scope_2
Mean audit_score by compliance_status75 rows
05010088.6compliant44 rows41.4non-compliant12 rows67.8pending19 rows
audit_score75 rows, in bands of 10
010200014549122020050100audit_score →

Median 81.4, from 27.9 to 98.7.

address_state75 rows · top 10 of 30 values
  1. CA10
  2. TX5
  3. CO4
  4. OH4
  5. MO4
  6. WA3
  7. NC3
  8. NY3
  9. NV3
  10. FL3
24 columns by typefrom the column list below
  • string 13
  • integer 1
  • float 6
  • date 1
  • boolean 3

Columns

24 columns in four groups
blueprint · 24 columns
columntypedescriptionexample
Text 13 columns
vendor_idstringUnique identifier for each vendoruniqueVEND-0001-ABX
vendor_namestringOfficial name of the vendorGreenBridge Supplies
contact_namestringPrimary contact person's full name at the vendoroptionalSamantha Carter
contact_emailstringPrimary contact email address for the vendoroptionalscarter@greenbridge.com
address_streetstringVendor's street addressoptional1200 Elm St
address_citystringVendor's cityoptionalSeattle
address_statestringVendor's state or provinceoptionalWA
address_postal_codestringVendor's postal or ZIP codeoptional98101
address_countrystringVendor's country2 countries · optionalUSA
product_or_service_typestringType of product or service supplied by the vendorConstruction Materials
certification_otherstringOther relevant sustainability certifications held by the vendor (comma-separated)optionalBREEAM
compliance_statusstringCurrent compliance status regarding sustainability regulations (e.g., compliant, non-compliant, pending)compliant · non-compliant · pendingcompliant
notesstringAdditional comments or notes about the vendor's sustainability practicesoptionalAwaiting LEED renewal.
Numbers 7 columns
esg_scorefloatOverall ESG (Environmental, Social, Governance) score assigned to the vendor (0-100 scale)0 to 10087.5
emissions_scope_1floatReported Scope 1 greenhouse gas emissions (metric tons CO2e per year)0 or more · optional15.4
emissions_scope_2floatReported Scope 2 greenhouse gas emissions (metric tons CO2e per year)0 or more · optional34.2
emissions_scope_3floatReported Scope 3 greenhouse gas emissions (metric tons CO2e per year)0 or more · optional89
waste_recycling_ratefloatPercentage of waste recycled by the vendor (0-100)0 to 100 · optional78.2
audit_scorefloatScore achieved in the most recent sustainability audit (0-100 scale)0 to 100 · optional91.2
public_works_projects_suppliedintegerNumber of public works projects supplied by the vendor in the last 12 months0 or more · optional6
Dates and times 1 column
last_audit_datedateDate of the most recent sustainability audit or assessmentoptional2023-11-14
True or false 3 columns
certification_iso_14001booleanWhether the vendor holds ISO 14001 environmental management certificationoptionaltrue
certification_leedbooleanWhether the vendor holds LEED certification (Leadership in Energy and Environmental Design)optionalfalse
waste_management_policybooleanIndicates if the vendor has a formal waste management policyoptionaltrue

Use it for

  • certification …56%42 of 75 rowsmean audit score by c…88.6compli…41.4non-co…67.8pending

    A government dashboard

    The certification_iso_14001 rate, audit_score by compliance_status and a breakdown of address_state. Excel, Power BI or Tableau.

  • Why do the 12 non-compliant rows have a mean audit_score of 41.4?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable vendors with vendor_name, contact_name and contact_email to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 24 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset75 rows24 columns
Yours1,000 rows24 columnsaddress_street: UK only

blueprint · public-works-vendor-sustainability-scores

Behind this dataset

Same schema. As many rows as you need.

These 75 rows came out of a blueprint — 24 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Each vendor is assigned a unique identifier
  • Sustainability score calculated based on emissions, certifications, and compliance
  • Vendors must provide at least one verified sustainability certification
  • Non-compliant vendors flagged for further review
  • Annual emissions data and waste management practices must be reported
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
public-works-vendor-sustainability-scores

What should your data show?

Preview 20 rows free
No signup. No card.