EPA emissions dashboard
The EPA publishes facility-level greenhouse gas data one year at a time, in files that do not quite line up. This joins eleven of them into one model you can actually explore.
The data
The EPA's Greenhouse Gas Reporting Program publishes emissions for large US facilities, released per year. Across 2010 to 2021 that's more than 500,000 rows, and the yearly files differ enough in structure that loading them naively gets you eleven tables instead of one dataset.
Consolidation
Python ingestion scripts handle the per-year differences and normalise the sources before they reach the model, and Power Query and DAX carry the modelling from there, so filters propagate across the full period instead of staying stuck inside a single year's table. Facility-level geography stays intact throughout, which is what makes the map view worth having: emissions are extremely unevenly distributed, and an aggregate hides that completely.
Explore it
The report below is the live published version. It's interactive: filter it, drill into a state, or select a facility.
- Role
- Data ingestion, modelling and report design
- Source
- EPA Greenhouse Gas Reporting Program
- Period
- 2010–2021
- Scale
- 500,000+ rows
- Stack
- Power BI, DAX, Power Query, Python