Government Infrastructure Carbon Footprint
This dataset provides annual, asset-level carbon footprint data for public sector infrastructure, including detailed emissions by scope, energy consumption, and ESG compliance indicators. It enables governments to track sustainability performance, benchmark assets, and support strategic planning for decarbonization and regulatory compliance.
Sample rows
preview · 8 of 121 rows · all 23 columns| asset_idstring | asset_typestring | total_emissions_tco2efloat | location_statestring | asset_namestring | departmentstring | location_street_addressstring | location_citystring | location_postal_codestring | location_countrystring | yearinteger | scope_1_emissions_tco2efloat | scope_2_emissions_tco2efloat | scope_3_emissions_tco2efloat | emission_intensityfloat | intensity_unitstring | energy_consumption_mwhfloat | renewable_energy_percentagefloat | certificationstring | esg_compliance_statusstring | last_audit_datedate | data_sourcestring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| B001 | building | 167 | NY | Brooklyn Admin Building | Public Works Division | 1454 Court Street | Brooklyn | 11201 | USA | 2022 | 38.2 | 112.7 | 16.1 | 1.01 | tCO2e/m2 | 1425.6 | 72.2 | LEED Gold | compliant | 2023-03-28 | metered | Major energy retrofit completed 2022. |
| PL001 | plant | 14052.1 | NJ | Harrison Waste Plant | Sanitation Board | 193 Industrial Ave | Harrison | 07029 | USA | 2018 | 10230.5 | 3701.2 | 120.4 | 6.02 | tCO2e/unit | 80250 | 8 | None | non-compliant | 2018-11-12 | metered | Planned modernization for 2025; high baseline. |
| F001 | facility | 134.8 | MA | Boston Central Facility | Operations Center Office | 240 Beacon St | Boston | 02116 | USA | 2021 | 51.4 | 69.2 | 14.2 | 1.52 | tCO2e/employee | 1283.5 | 65.5 | LEED Silver | compliant | 2022-06-04 | metered | Facility runs hybrid; staff reduction since 2020. |
| BR001 | bridge | 7.2 | IL | Morris Bridge Crossing | Infrastructure Board | 575 River Road | Morris | 60450 | USA | 2004 | 0 | 7.2 | blank | blank | blank | blank | blank | None | not-applicable | 2005-10-23 | estimated | Passive structure; minimal emissions, legacy data. |
| R001 | road | 0 | AL | Jefferson County Rd 12 | Roadways Maintenance | NA | Birmingham | 35203 | USA | 1998 | 0 | 0 | blank | blank | blank | blank | blank | None | not-applicable | blank | other | Unmetered; legacy road, no active emissions. |
| OT001 | other | 76.9 | CO | Civic Event Center | Recreation Office | 78 Civic Plaza | Denver | 80202 | USA | 2024 | 28.7 | 44.2 | 4 | 2.9 | tCO2e/employee | 550 | 88 | None | compliant | 2024-02-15 | metered | High renewable use, site upgraded 2023. |
| B002 | building | 112.3 | WA | Central Library North | Library District Board | 2121 Book Lane | Seattle | 98101 | USA | 2020 | 19.8 | 92.5 | 0 | 0.78 | tCO2e/m2 | 1102 | 60.7 | LEED Platinum | compliant | 2021-03-11 | metered | Solar panels installed 2020, high efficiency. |
| PL002 | plant | 13227.6 | TX | South District Water Plant | Water Management Office | 4800 Waterway Ave | Austin | 78702 | USA | 2014 | 9470 | 3554 | 203.6 | 7.1 | tCO2e/unit | 134200 | 3 | LEED Silver | pending | 2014-10-06 | third-party audit | Certification review pending; upgrades in 2025. |
| F002 | facility | 100.2 | OH | Westside Recreation Facility | Community Services Board | 1500 Main Ave | Columbus | 43215 | USA | 2023 | 23.4 | 62.8 | 14 | 1.04 | tCO2e/employee | 934 | 78 | BREEAM Excellent | compliant | 2024-01-22 | metered | Facility awarded BREEAM Excellent in 2023. |
| BR002 | bridge | 6 | NV | Sierra Ridge Bridge | Civil Engineering Dept | 2356 Ridge Blvd | Reno | 89501 | USA | 1999 | 0 | 6 | blank | blank | blank | blank | blank | None | not-applicable | blank | estimated | Passive bridge; emissions estimated, no metering. |
| R002 | road | 0 | TN | Franklin Highway 80 | Highway Operations | 89 Route 80 | Franklin | 37064 | USA | 2002 | 0 | 0 | blank | blank | blank | blank | blank | None | not-applicable | blank | other | Legacy road, no current emissions metering. |
| OT002 | other | 84.5 | CA | Downtown Expo Center | Event Management Office | 554 9th Ave | San Diego | 92101 | USA | 2025 | 31.2 | 47.7 | 5.6 | 3.8 | tCO2e/employee | 788.2 | 94.3 | None | pending | 2025-01-13 | metered | Projected compliance; new solar system planned. |
| B003 | building | 186 | IN | Westfield City Hall | City Administration | 100 City Center | Westfield | 46074 | USA | 2017 | 43.2 | 130.7 | 12.1 | 1.3 | tCO2e/m2 | 1802.3 | 55 | LEED Silver | compliant | 2019-07-19 | metered | Lighting and HVAC upgrades in 2018. |
| PL003 | plant | 15345.9 | CA | Eastside Treatment Plant | Wastewater Operations | 2000 Plant Rd | Sacramento | 95814 | USA | 2022 | 11050.2 | 4200.7 | 95 | 6.8 | tCO2e/unit | 151200 | 10 | None | pending | 2022-12-20 | metered | Efficiency upgrades scheduled for 2024. |
| F003 | facility | 76.1 | WI | Greenfield Research Lab | Environmental Research | 812 Forest Ave | Greenfield | 53220 | USA | 2016 | 17.8 | 48.9 | 9.4 | 0.97 | tCO2e/employee | 1215 | 53 | LEED Silver | compliant | 2017-07-25 | metered | New solar installation in 2017. |
| BR003 | bridge | 2.9 | WI | Elmwood Overpass | Transportation Division | 3342 Elmwood Dr | Madison | 53703 | USA | 2007 | 0 | 2.9 | blank | blank | blank | blank | blank | None | not-applicable | blank | estimated | Legacy bridge; emissions minimal, not tracked. |
| R003 | road | 1.1 | CT | Maple Road Extension | Urban Roads Division | 466 Maple Rd | Hartford | 06106 | USA | 2005 | 0 | 1.1 | blank | blank | blank | blank | blank | None | not-applicable | blank | other | No metering, passive road segment. |
| OT003 | other | 60.4 | FL | Lakeside Sports Complex | Recreation Services | 352 Lake Ave | Orlando | 32801 | USA | 2021 | 22.5 | 30.1 | 7.8 | 1.8 | tCO2e/employee | 335 | 90 | None | compliant | 2022-02-20 | metered | All field lighting upgraded to LED 2021. |
| B004 | building | 56.7 | MO | Midtown Community Center | Community Development | 500 Main St | Kansas City | 64105 | USA | 2026 | 12.9 | 38.1 | 5.7 | 0.52 | tCO2e/m2 | 900.7 | 100 | LEED Platinum | pending | 2026-02-21 | metered | Projected: New building, 100% renewable. |
| PL004 | plant | 11801.9 | PA | North Regional Plant | Region Power Authority | 299 Power Dr | Pittsburgh | 15222 | USA | 2009 | 8600 | 3201.9 | blank | 5.7 | tCO2e/unit | 131050 | 7 | None | non-compliant | 2009-05-19 | metered | High emissions; program for upgrades in 2025. |
What the 121 rows show
from the 121-row samplePlant (asset type) stands out: mean total_
- 117.6median total_
emissions_ tco2e - 3intensity units
- 4esg compliance statuses
- 4data sources
- 5certifications
- 38.1median scope_
1_ emissions_ tco2e
Median 117.6, from 0.0 to 18,110.
- string 14
- integer 1
- float 7
- date 1
Columns
23 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
asset_id | string | Unique identifier for the infrastructure assetunique | B001 |
asset_name | string | Descriptive name of the infrastructure asset | Brooklyn Admin Building |
asset_type | string | Type or category of the infrastructure asset (e.g., building, bridge, road, plant)6 values | building |
department | string | Government department or agency responsible for the asset | Public Works Division |
location_street_address | string | Street address of the assetoptional | 1454 Court Street |
location_city | string | City where the asset is locatedoptional | Brooklyn |
location_state | string | State or province where the asset is locatedoptional | NY |
location_postal_code | string | Postal code for the asset's locationoptional | 11201 |
location_country | string | Country where the asset is located | USA |
intensity_unit | string | Unit for emission intensity (e.g., tCO2e/m2, tCO2e/unit)tCO2e/m2 · tCO2e/unit · tCO2e/employee · other · optional | tCO2e/m2 |
certification | string | Sustainability or green building certification (e.g., LEED, BREEAM, None)5 certifications · optional | LEED Gold |
esg_compliance_status | string | ESG compliance status for the asset in the reporting yearcompliant · non-compliant · pending · not-applicable · optional | compliant |
data_source | string | Source of the emissions data (e.g., metered, estimated, third-party audit)metered · estimated · third-party audit · other · optional | metered |
notes | string | Additional notes or comments about the asset or emissions dataoptional | Major energy retrofit com… |
| Numbers 8 columns | |||
year | integer | Year for which the carbon footprint is reported1,990 to 2,100 | 2022 |
scope_1_emissions_tco2e | float | Direct greenhouse gas emissions (Scope 1) in metric tons of CO2 equivalent0 or more | 38.2 |
scope_2_emissions_tco2e | float | Indirect emissions from purchased energy (Scope 2) in metric tons of CO2 equivalent0 or more | 112.7 |
scope_3_emissions_tco2e | float | Other indirect emissions (Scope 3) in metric tons of CO2 equivalent0 or more · optional | 16.1 |
total_emissions_tco2e | float | Total greenhouse gas emissions (sum of Scope 1, 2, and 3) in metric tons of CO2 equivalent0 or more | 167 |
emission_intensity | float | Emission intensity (e.g., tCO2e per square meter or per unit of output)0 or more · optional | 1.01 |
energy_consumption_mwh | float | Total energy consumption of the asset in megawatt-hours (MWh) for the year0 or more · optional | 1425.6 |
renewable_energy_percentage | float | Percentage of energy consumption from renewable sources (0-100)0 to 100 · optional | 72.2 |
| Dates and times 1 column | |||
last_audit_date | date | Date of the most recent carbon/emissions audit for the assetoptional | 2023-03-28 |
Use it for
A government dashboard
Total_
emissions_ tco2e by asset_ type and a breakdown of location_ state. Excel, Power BI or Tableau. Why do the 23 plant rows have a mean total_
emissions_ tco2e of 10,075? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Assets121B001167buildingPL00114052.1plantF001134.8facility
A software demo
Believable assets with asset_
name, asset_ type and department to fill a screen in front of a buyer.
blueprint · government-infrastructure-carbon-footprint
Behind this dataset
Same schema. As many rows as you need.
These 121 rows came out of a blueprint — 23 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.
- Each infrastructure asset must have a unique identifier.
- Carbon footprint calculations are standardized using accepted emission factors.
- Monthly reporting is required for all active assets.
- Include asset type, location, energy source, and utilization details.
- Flag assets exceeding predefined emission thresholds for review.
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
- government-infrastructure-carbon-footprint