Government Asset Carbon Tracking
This dataset provides detailed tracking of municipal assets, including their lifecycle stages, carbon footprint estimates for acquisition, operation, maintenance, and retirement, and key operational metadata. It enables city planners and sustainability teams to assess and optimize the environmental impact of government assets, supporting ESG reporting and strategic decision-making.
Sample rows
preview · 8 of 92 rows · all 22 columns| asset_idstring | asset_typestring | carbon_footprint_maintenancefloat | esg_certificationstring | asset_namestring | departmentstring | location_street_addressstring | location_citystring | location_statestring | location_postal_codestring | location_countrystring | acquisition_datedate | retirement_datedate | lifecycle_stagestring | carbon_footprint_acquisitionfloat | carbon_footprint_operationfloat | carbon_footprint_retirementfloat | total_carbon_footprintfloat | last_maintenance_datedate | maintenance_frequency_monthsinteger | asset_statusstring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ASSET-1001 | vehicle | 150.7 | EPA SmartWay | Hybrid Police Cruiser | Public Safety | 101 Elm St | Portsmouth | NH | 03801 | USA | 2018-05-12 | blank | active | 3200.5 | 780.2 | blank | 7154.1 | 2023-12-17 | 6 | active | Converted to hybrid in 2021 |
| ASSET-1002 | building | 2800 | LEED Silver | City Hall | Administration | 1 Government Plaza | Manchester | NH | 03101 | USA | 2005-07-21 | blank | maintenance | 85600 | 20900 | blank | 391200 | 2024-03-11 | 12 | active | Annual HVAC upgrade completed |
| ASSET-1003 | infrastructure | 2.9 | Energy Star | Solar Street Light #1 | Public Works | 200 River Rd | Concord | NH | 03301 | USA | 2021-08-29 | blank | active | 390.3 | 15.2 | blank | 434.8 | 2024-01-20 | 24 | active | Part of green corridor project |
| ASSET-1004 | equipment | 400 | blank | Water Pumping Station #2 | Utilities | 357 Main St | Keene | NH | 03431 | USA | 2012-03-16 | blank | maintenance | 11650 | 2050 | blank | 35950 | 2024-02-14 | 6 | active | Pump replaced in 2023 |
| ASSET-1005 | building | 1700 | LEED Gold | Community Recreation Center | Community Services | 18 Maple Ave | Nashua | NH | 03060 | USA | 2010-05-30 | blank | active | 42500 | 11000 | blank | 133200 | 2024-04-03 | 12 | active | Solar panels installed in 2022 |
| ASSET-1006 | vehicle | 250.1 | EPA SmartWay | Fire Engine #4 | Fire Department | 72 Lincoln Rd | Lebanon | NH | 03766 | USA | 2015-11-08 | blank | maintenance | 4900.7 | 1480.2 | blank | 19351.8 | 2024-03-15 | 4 | active | Engine overhaul completed |
| ASSET-1007 | infrastructure | 900 | blank | Bridge #7 | Public Works | Old River Crossing | Dover | NH | 03820 | USA | 2000-09-17 | blank | maintenance | 62000 | 4000 | blank | 190300 | 2023-12-05 | 24 | active | Reinforced in 2019 |
| ASSET-1008 | equipment | 45 | Energy Star | Municipal IT Server | Information Technology | 22 Tech Park Dr | Rochester | NH | 03867 | USA | 2019-06-11 | blank | maintenance | 2100 | 360 | blank | 4950 | 2024-02-10 | 3 | active | Virtualization upgrade completed |
| ASSET-1009 | vehicle | 90 | EPA SmartWay | Electric Garbage Truck | Sanitation | 89 South St | Plymouth | NH | 03264 | USA | 2022-03-29 | blank | active | 7000 | 480 | blank | 9600 | 2024-03-13 | 6 | active | Battery replaced in 2023 |
| ASSET-1010 | equipment | 20 | Energy Star | Emergency Generator | Emergency Management | 44 North Ave | Hudson | NH | 03051 | USA | 2016-10-13 | blank | active | 1600 | 230 | blank | 2900 | 2024-01-29 | 6 | active | Test run monthly |
| ASSET-1011 | infrastructure | 6 | Energy Star | Traffic Light System #3 | Transportation | Intersection of Main & High | Salem | NH | 03079 | USA | 2014-04-02 | blank | active | 870 | 40 | blank | 1406 | 2024-02-28 | 12 | active | LED bulbs installed in 2022 |
| ASSET-1012 | building | 1000 | LEED Silver | Public Library | Culture & Recreation | 15 Library Ln | Exeter | NH | 03833 | USA | 2008-02-20 | blank | maintenance | 29500 | 6200 | blank | 91900 | 2024-03-22 | 12 | active | Roof replaced in 2021 |
| ASSET-1013 | equipment | 60 | blank | Public Works Loader | Public Works | 12 Industrial Blvd | Laconia | NH | 03246 | USA | 2017-11-05 | blank | active | 2300 | 350 | blank | 3530 | 2024-03-12 | 6 | active | Routine maintenance |
| ASSET-1014 | vehicle | 190 | blank | Retired Police Cruiser | Public Safety | 101 Elm St | Portsmouth | NH | 03801 | USA | 2010-05-01 | 2023-04-18 | retired | 3400.7 | 900 | 300 | 16590.7 | 2022-11-05 | 6 | retired | Sold at auction |
| ASSET-1015 | equipment | 320 | blank | Decommissioned Water Pump | Utilities | 357 Main St | Keene | NH | 03431 | USA | 2005-03-16 | 2022-07-31 | retired | 9500 | 1700 | 250 | 27350 | 2022-06-29 | 6 | decommissioned | Replaced by newer pump |
| ASSET-1016 | vehicle | 220 | blank | Retired School Bus | Education | 110 School Dr | Berlin | NH | 03570 | USA | 2008-08-15 | 2023-09-22 | retired | 7800 | 1300 | 400 | 24400 | 2023-07-30 | 12 | retired | Retired after 15 years |
| ASSET-1017 | infrastructure | 12 | blank | Retired Traffic Light #1 | Transportation | Intersection of Main & High | Salem | NH | 03079 | USA | 2000-03-24 | 2021-10-02 | retired | 900 | 80 | 50 | 2650 | 2021-09-20 | 12 | retired | Replaced with LED system |
| ASSET-1018 | equipment | 30 | blank | Decommissioned Server | Information Technology | 22 Tech Park Dr | Rochester | NH | 03867 | USA | 2012-06-11 | 2023-02-15 | retired | 1800 | 350 | 50 | 4100 | 2022-12-10 | 6 | decommissioned | Disposed as e-waste |
| ASSET-1019 | vehicle | 200 | blank | Retired Fire Engine #2 | Fire Department | 72 Lincoln Rd | Lebanon | NH | 03766 | USA | 2007-09-12 | 2022-06-18 | retired | 5000 | 1100 | 250 | 18050 | 2022-05-10 | 6 | retired | Donated to rural department |
| ASSET-1020 | infrastructure | 700 | blank | Retired Bridge #5 | Public Works | Old River Crossing | Dover | NH | 03820 | USA | 1982-07-17 | 2020-08-10 | retired | 57000 | 4200 | 900 | 156700 | 2020-05-21 | 24 | retired | Demolished, replaced by new span |
What the 92 rows show
from the 92-row sampleBuilding (asset type) stands out: mean carbon_
- 185.0median carbon_
footprint_ maintenance - 3lifecycle stages
- 3asset statuses
- 22departments
- 24location states
- 6,800median carbon_
footprint_ acquisition
Median 185.0, from 1.0 to 2,800.
- string 13
- integer 1
- float 5
- date 3
Columns
22 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
asset_id | string | Unique identifier for the municipal assetunique | ASSET-1001 |
asset_name | string | Descriptive name of the asset | Hybrid Police Cruiser |
asset_type | string | Type/category of the asset (e.g., vehicle, building, equipment)vehicle · building · equipment · infrastructure · other | vehicle |
department | string | Government department or agency responsible for the asset | Public Safety |
location_street_address | string | Street address where the asset is locatedoptional | 101 Elm St |
location_city | string | City where the asset is locatedoptional | Portsmouth |
location_state | string | State or province where the asset is locatedoptional | NH |
location_postal_code | string | Postal code for the asset's locationoptional | 03801 |
location_country | string | Country where the asset is locatedoptional | USA |
lifecycle_stage | string | Current stage in the asset lifecycleacquired · active · maintenance · retired | active |
esg_certification | string | ESG or sustainability certification held by the asset (if any)10 certifications · optional | EPA SmartWay |
asset_status | string | Operational status of the assetactive · inactive · decommissioned · retired | active |
notes | string | Additional notes or comments about the assetoptional | Pump replaced in 2023 |
| Numbers 6 columns | |||
carbon_footprint_acquisition | float | Estimated carbon emissions (kg CO2e) from asset acquisition/manufacture0 or more | 3200.5 |
carbon_footprint_operation | float | Estimated annual carbon emissions (kg CO2e) from asset operation/use0 or more | 780.2 |
carbon_footprint_maintenance | float | Estimated annual carbon emissions (kg CO2e) from asset maintenance0 or more | 150.7 |
carbon_footprint_retirement | float | Estimated carbon emissions (kg CO2e) from asset retirement/disposal0 or more · optional | 300 |
total_carbon_footprint | float | Total estimated carbon emissions (kg CO2e) over the asset's lifecycle0 or more | 7154.1 |
maintenance_frequency_months | integer | Expected frequency of maintenance in months1 or more · optional | 6 |
| Dates and times 3 columns | |||
acquisition_date | date | Date the asset was acquired | 2018-05-12 |
retirement_date | date | Date the asset was retired from service (if applicable)optional | 2023-04-18 |
last_maintenance_date | date | Date of most recent maintenance activityoptional | 2023-12-17 |
Use it for
A government dashboard
Carbon_
footprint_ maintenance by asset_ type and a breakdown of esg_ certification. Excel, Power BI or Tableau. Why do the 23 building rows have a mean carbon_
footprint_ maintenance of 817.3? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Assets92ASSET-1001150.7vehicleASSET-10022800buildingASSET-10032.9infrastr…
A software demo
Believable assets with asset_
name, asset_ type and department to fill a screen in front of a buyer.
blueprint · government-asset-carbon-tracking
Behind this dataset
Same schema. As many rows as you need.
These 92 rows came out of a blueprint — 22 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 asset must have a unique ID and type (vehicle, building, equipment, etc.)
- Carbon footprint calculated annually based on asset use and maintenance events
- Assets assigned to departments with varying operational intensity
- Lifecycle stage determines emission factors (acquisition, operation, disposal)
- Includes status for green upgrade eligibility
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-asset-carbon-tracking