Municipal ESG Reporting Readiness Scores

This dataset benchmarks the ESG reporting readiness of municipal departments, providing detailed scores across environmental, social, and governance pillars, compliance status, and actionable recommendations. It empowers sustainability officers and digital teams to identify gaps, track progress, and drive targeted improvements in public sector ESG practices.

  • last updated 30 Jan 2026
  • by GoMask
The brief that made it

Benchmarking ESG reporting readiness across local government departments

Sample rows

preview · 8 of 42 rows · all 17 columns
department_idstringcompliance_statusstringesg_reporting_scorefloatreporting_frameworkstringdepartment_namestringmunicipality_namestringmunicipality_statestringmunicipality_countrystringenvironmental_scorefloatsocial_scorefloatgovernance_scorefloatlast_assessment_datedateidentified_gapsstringstrengthsstringrecommended_actionsstringassessment_lead_namestringassessment_lead_emailstring
env_001Compliant84.2GRIEnvironmental ServicesGreenfieldCaliforniaUSA92.18179.42024-03-14Limited supplier data integration.Advanced carbon tracking; robust community engagement.Expand supply chain reporting.Jessica Chenjessica.chen@greenfield.gov
waste_002Partially Compliant67.5SASBWaste ManagementRiverbendTexasUSA7260.270.32024-04-05Incomplete hazardous waste documentation.Efficient recycling programs.Improve hazardous waste tracking.David Leedavid.lee@riverbend.gov
transit_003Compliant76.1TCFDPublic TransitMapletonOntarioCanada78.880.469.22024-01-24Limited climate risk disclosure.Strong stakeholder communication.Enhance climate adaptation reporting.Samantha Ruizs.ruiz@mapleton.ca
parks_004Non-Compliant61.7Local StandardParks & RecreationHillcrestFloridaUSA65.270.149.82024-05-07Governance process documentation lacking.Inclusive community programs.Standardize governance procedures.Michael Turnerm.turner@hillcrest.gov
facilities_005Partially Compliant48.9OtherFacilities MaintenanceLakesideNew YorkUSA56.740.649.52024-03-28Low social data granularity.Effective energy management.Improve social metrics collection.Lauren Patell.patel@lakeside.gov
water_006Compliant71.8GRIWater ResourcesCedar GroveWashingtonUSA81.369.764.52024-02-19Limited water usage transparency.Advanced leak detection systems.Increase reporting on water consumption.Robert McCarthyrobert.mccarthy@cedargrove.gov
health_007Compliant88.3SASBPublic HealthBrightonMassachusettsUSA90.29183.62024-04-20Minor staff training gaps.Comprehensive health outreach.Expand staff ESG training.Helen Parkh.park@brighton.gov
housing_008Partially Compliant59.5TCFDHousing & Urban Dev.BrookfieldIllinoisUSA60.754.862.32024-02-08Unclear climate adaptation plan.Affordable housing initiatives.Clarify adaptation roadmap.Carlos Riverac.rivera@brookfield.gov

What the 42 rows show

from the 42-row sample

Compliant (compliance status) stands out: mean esg_reporting_score is 80.1, against 59.0 for the rest.

  • 71.0median esg_reporting_score
  • 2municipality countries
  • 71.2median environmental_score
  • 73.8median social_score
  • 69.8median governance_score
Mean esg_reporting_score by compliance_status42 rows
05010080.1Compliant22 rows62.9Partially Co…13 rows51.7Non-Compliant7 rows
esg_reporting_score42 rows, in bands of 10
06120000461011101050100esg_reporting_score →

Median 71.0, from 43.8 to 90.4.

reporting_framework42 rows · 5 values
  1. GRI11
  2. SASB9
  3. TCFD9
  4. Local Standard7
  5. Other6
17 columns by typefrom the column list below
  • string 12
  • float 4
  • date 1

Columns

17 columns in three groups
blueprint · 17 columns
columntypedescriptionexample
Text 12 columns
department_idstringUnique identifier for the municipal department being assesseduniqueenv_001
department_namestringOfficial name of the municipal departmentEnvironmental Services
municipality_namestringName of the municipality where the department operatesGreenfield
municipality_statestringState or province of the municipalityCalifornia
municipality_countrystringCountry of the municipality2 countriesUSA
reporting_frameworkstringPrimary ESG reporting framework used (e.g., GRI, SASB, TCFD, Local Standard)GRI · SASB · TCFD · Local Standard · OtherGRI
compliance_statusstringCurrent compliance status with ESG reporting standards4 valuesCompliant
identified_gapsstringSummary of key gaps or deficiencies identified during assessmentoptionalMinor data privacy gaps.
strengthsstringSummary of strengths and best practices identified during assessmentoptionalData-driven policing.
recommended_actionsstringRecommended actions to improve ESG reporting readinessoptionalExpand supply chain repor…
assessment_lead_namestringName of the person or team lead responsible for the assessmentoptionalJessica Chen
assessment_lead_emailstringEmail address of the assessment leadoptionaldavid.lee@riverbend.gov
Numbers 4 columns
esg_reporting_scorefloatOverall ESG reporting readiness score for the department (0-100 scale)0 to 10084.2
environmental_scorefloatEnvironmental reporting readiness score (0-100 scale)0 to 10092.1
social_scorefloatSocial reporting readiness score (0-100 scale)0 to 10081
governance_scorefloatGovernance reporting readiness score (0-100 scale)0 to 10079.4
Dates and times 1 column
last_assessment_datedateDate when the latest ESG readiness assessment was conducted2024-03-14

Use it for

  • median esg rep…71.042 rowsmean esg reporting sc…80.1Compli…62.9Partia…51.7Non-Co…

    A government dashboard

    Esg_reporting_score by compliance_status and a breakdown of reporting_framework. Excel, Power BI or Tableau.

  • Why do the 22 Compliant rows have a mean esg_reporting_score of 80.1?

    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 departments with department_name, municipality_name and municipality_state to fill a screen in front of a buyer.

Not quite right?

Make it yours.

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

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset42 rows17 columns
Yours10,000 rows17 columnsmunicipality_state: UK only

blueprint · municipal-esg-reporting-readiness-scores

Behind this dataset

Same schema. As many rows as you need.

These 42 rows came out of a blueprint — 17 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 municipal department or agency.
  • Scores are provided for environmental, social, and governance criteria based on standardized assessment rubrics.
  • Departments must have documented internal ESG policies to receive a non-zero score.
  • Include readiness indicators: data availability, reporting personnel, and digital tool adoption.
  • Departments without recent audits are flagged for follow-up.
Rows
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-esg-reporting-readiness-scores

What should your data show?

Preview 20 rows free
No signup. No card.