Municipal Procurement ESG Compliance Records
This dataset provides detailed records of ESG (Environmental, Social, Governance) compliance for municipal procurement contracts, including supplier scores, transparency gaps, and violation tracking. It enables governments and public sector teams to audit, benchmark, and enforce sustainable sourcing policies, supporting risk management and improved transparency in public procurement.
Sample rows
preview · 8 of 60 rows · all 21 columns| contract_idstring | policy_enforcement_statusstring | esg_violations_countinteger | transparency_gap_flagboolean | department_namestring | contract_titlestring | municipality_namestring | contract_start_datedate | contract_end_datedate | supplier_idstring | supplier_namestring | supplier_countrystring | esg_compliance_scorefloat | environmental_scorefloat | social_scorefloat | governance_scorefloat | last_esg_audit_datedate | esg_violation_typesstring | risk_levelstring | notesstring | transparency_gap_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CT2024001 | enforced | 0 | false | Sustainability | Solar Panel Installation - City Hall | Greenfield | 2023-02-15 | 2025-02-14 | SUP-101 | Eco Solutions Ltd. | Canada | 0.89 | 0.96 | 0.85 | 0.87 | 2024-02-10 | blank | low | Model project for renewable energy adoption. | blank |
| CT2024002 | partial | 1 | false | Public Works | Recycling Collection Services | Lakeshore | 2023-07-01 | 2026-06-30 | SUP-102 | WasteWise Inc. | United States | 0.73 | 0.7 | 0.74 | 0.77 | 2023-12-12 | environmental | medium | blank | blank |
| CT2024003 | enforced | 0 | false | Infrastructure | LED Street Lighting Retrofit | Riverbend | 2022-11-01 | 2025-10-31 | SUP-103 | BrightCity Technologies | UK | 0.81 | 0.85 | 0.8 | 0.78 | 2023-11-15 | blank | low | blank | blank |
| CT2024004 | not_enforced | 2 | true | Community Development | Community Center Renovation | Springfield | 2024-01-10 | 2025-08-15 | SUP-104 | UrbanBuild Corp. | Canada | 0.62 | 0.68 | 0.6 | 0.57 | 2024-03-20 | social, governance | high | Pending follow-up audit. | Social compliance reporting incomplete for Q1. |
| CT2024005 | enforced | 0 | false | Transportation | Fleet Electrification Phase I | Urbanview | 2023-09-20 | 2026-09-19 | SUP-105 | ElectroFleet Partners | Germany | 0.93 | 0.97 | 0.91 | 0.92 | 2024-04-22 | blank | low | Zero violations since contract start. | blank |
| CT2024006 | not_enforced | 3 | true | Parks & Recreation | Park Maintenance Services | Hillside | 2022-05-01 | 2024-04-30 | SUP-106 | GreenScape Solutions | United States | 0.57 | 0.55 | 0.6 | 0.58 | 2023-07-18 | environmental | high | Supplier on performance watch list. | Missing environmental impact disclosures. |
| CT2024007 | enforced | 0 | false | Procurement | Procurement of Biodegradable Supplies | Newport | 2023-03-15 | 2024-03-14 | SUP-101 | Eco Solutions Ltd. | Canada | 0.85 | 0.91 | 0.78 | 0.86 | 2024-01-08 | blank | low | Preferred green supplier. | blank |
| CT2024008 | partial | 1 | true | Information Technology | IT Hardware Refresh | Mapleton | 2023-05-01 | 2025-04-30 | SUP-107 | TechNova Solutions | India | 0.67 | 0.7 | 0.66 | 0.64 | 2024-02-26 | governance | medium | blank | Governance documentation not updated in Q4. |
| CT2024009 | enforced | 0 | false | Housing | Affordable Housing Construction | Hillcrest | 2022-08-01 | 2025-07-31 | SUP-108 | BlueSky Developments | United States | 0.79 | 0.77 | 0.81 | 0.8 | 2023-10-15 | blank | low | Affordable housing initiative. | blank |
| CT2024010 | enforced | 0 | false | Transportation | EV Charging Station Deployment | Brookside | 2023-06-01 | 2024-12-31 | SUP-105 | ElectroFleet Partners | Germany | 0.91 | 0.95 | 0.89 | 0.88 | 2024-03-15 | blank | low | Supporting municipal EV transition. | blank |
| CT2024011 | partial | 1 | false | Utilities | Smart Water Meters | Clearwater | 2022-10-01 | 2025-09-30 | SUP-109 | WaterTech Global | Denmark | 0.76 | 0.8 | 0.74 | 0.73 | 2023-11-10 | social | medium | Supplier improved social compliance after warning. | blank |
| CT2024012 | not_enforced | 2 | true | Information Technology | Public WiFi Expansion | Lakeshore | 2023-04-10 | 2024-10-09 | SUP-110 | NetConnect Services | United States | 0.59 | 0.6 | 0.55 | 0.62 | 2023-12-05 | governance | high | blank | Incomplete governance records for Q2. |
| CT2024013 | enforced | 0 | false | Transportation | Low-Emissions Transit Buses | Greenfield | 2023-08-01 | 2026-07-31 | SUP-111 | CleanMove Transport | Sweden | 0.87 | 0.92 | 0.9 | 0.8 | 2024-03-20 | blank | low | Fully compliant with Euro 7 standards. | blank |
| CT2024014 | partial | 1 | true | Parks & Recreation | Tree Planting Initiative | Willowbrook | 2023-03-01 | 2024-02-29 | SUP-106 | GreenScape Solutions | United States | 0.66 | 0.7 | 0.65 | 0.63 | 2023-09-10 | environmental | medium | blank | Environmental reporting delayed for Q2. |
| CT2024015 | enforced | 0 | false | Procurement | Sustainable Office Supplies | Brookside | 2023-07-15 | 2024-07-14 | SUP-101 | Eco Solutions Ltd. | Canada | 0.88 | 0.9 | 0.89 | 0.85 | 2024-02-02 | blank | low | blank | blank |
| CT2024016 | partial | 1 | false | Public Works | Stormwater Management Upgrade | Ridgefield | 2022-12-01 | 2025-11-30 | SUP-112 | HydroMax Group | France | 0.71 | 0.74 | 0.7 | 0.69 | 2023-10-20 | environmental | medium | blank | blank |
| CT2024017 | enforced | 0 | false | blank | Public Library Solar Panels | Mapleton | 2023-06-01 | 2024-12-31 | SUP-101 | Eco Solutions Ltd. | Canada | 0.92 | 0.98 | 0.91 | 0.87 | 2024-03-10 | blank | low | Library is now energy independent. | blank |
| CT2024018 | enforced | 0 | false | Information Technology | Municipal Website Accessibility Upgrade | Hillcrest | 2023-11-01 | 2024-10-31 | SUP-107 | TechNova Solutions | India | 0.83 | 0.8 | 0.88 | 0.81 | 2024-03-01 | blank | low | Project improved digital inclusion. | blank |
| CT2024019 | enforced | 0 | false | Facilities Management | Energy-Efficient HVAC Systems | Springfield | 2022-09-01 | 2024-08-31 | SUP-113 | CoolTech Engineering | United States | 0.77 | 0.81 | 0.75 | 0.74 | 2023-10-10 | blank | low | blank | blank |
| CT2024020 | enforced | 0 | false | Parks & Recreation | Inclusive Playground Equipment | Urbanview | 2023-04-01 | 2024-09-30 | SUP-114 | PlayAccess Ltd. | Canada | 0.88 | 0.9 | 0.93 | 0.81 | 2024-01-19 | blank | low | Fully accessible installation. | blank |
What the 60 rows show
from the 60-row sampleEnforced (policy enforcement status) stands out: mean esg_
- 22%transparency_
gap_ flag = true - 0median esg_
violations_ count - 3risk levels
- 10supplier countries
- 0.80median esg_
compliance_ score - 0.81median environmental_
score
Median 0, from 0 to 3.
- string 12
- integer 1
- float 4
- date 3
- boolean 1
Columns
21 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
contract_id | string | Unique identifier for the procurement contract.unique | CT2024001 |
contract_title | string | Title or short description of the procurement contract. | IT Hardware Refresh |
municipality_name | string | Name of the municipality issuing the contract. | Greenfield |
department_name | string | Name of the municipal department responsible for the contract.optional | Sustainability |
supplier_id | string | Unique identifier for the supplier. | SUP-101 |
supplier_name | string | Legal name of the supplier organization. | Eco Solutions Ltd. |
supplier_country | string | Country where the supplier is registered.10 countries · optional | Canada |
transparency_gap_description | string | Description of any identified transparency gaps in ESG reporting.optional | Social compliance reporti… |
esg_violation_types | string | Comma-separated list of ESG violation types (e.g., 'environmental, social').7 typeses · optional | environmental |
risk_level | string | Risk level associated with the supplier's ESG compliance for this contract.low · medium · high · optional | low |
policy_enforcement_status | string | Status of ESG policy enforcement for this contract.enforced · not_enforced · partial · optional | enforced |
notes | string | Additional notes or comments regarding ESG compliance for this contract.optional | Pending follow-up audit. |
| Numbers 5 columns | |||
esg_compliance_score | float | Overall ESG compliance score for the supplier in this contract (0.0 to 1.0).0 to 1 | 0.89 |
environmental_score | float | Supplier's environmental compliance score for this contract (0.0 to 1.0).0 to 1 · optional | 0.96 |
social_score | float | Supplier's social compliance score for this contract (0.0 to 1.0).0 to 1 · optional | 0.85 |
governance_score | float | Supplier's governance compliance score for this contract (0.0 to 1.0).0 to 1 · optional | 0.87 |
esg_violations_count | integer | Number of recorded ESG violations for this contract.0 or more · optional | 0 |
| Dates and times 3 columns | |||
contract_start_date | date | Date when the contract becomes effective. | 2023-02-15 |
contract_end_date | date | Date when the contract expires or is expected to end.optional | 2025-02-14 |
last_esg_audit_date | date | Date of the most recent ESG compliance audit for this contract.optional | 2024-02-10 |
| True or false 1 column | |||
transparency_gap_flag | boolean | Indicates if there are transparency gaps in ESG reporting for this contract. | false |
Use it for
A government dashboard
The transparency_
gap_ flag rate, esg_ violations_ count by policy_ enforcement_ status and a breakdown of department_ name. Excel, Power BI or Tableau. Why do the 39 enforced rows have a mean esg_
violations_ count of 0.0? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Contracts60CT20240010enforcedCT20240042not_enfo…CT20240063not_enfo…
A software demo
Believable contracts with contract_
title, municipality_ name and department_ name to fill a screen in front of a buyer.
This dataset60 rows21 columns
Yours1,000 rows21 columnssupplier_country: UK only
blueprint · municipal-procurement-esg-compliance-records
Behind this dataset
Same schema. As many rows as you need.
These 60 rows came out of a blueprint — 21 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 row represents a unique procurement contract with a public entity.
- Must include supplier name, contract value, ESG compliance status, and audit date.
- Flag contracts with missing or outdated ESG disclosures.
- Highlight suppliers rated below minimum ESG score thresholds.
- Categorize procurement by type (goods/services/construction/IT).
Open the blueprint in Data Factory
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- municipal-procurement-esg-compliance-records