This repo is the result of a conversation at the LF Energy forum about how it would be really nice to have easy access to data about the average carbon intensity of electricity consumption for a given country, at a fairly high temporal resolution (i.e. hourly), and at a fairly good geographic resolution (i.e. balancing authority).
We talk about electricity consumption because if you are consuming electricity from the grid, and you care about its carbon intensity, then looking at the generation figures by themselves can give misleading results.
For temporal resolution, hourly resolution allows you to see the changes in carbon intensity over a given day. It's high enough resolution to reflect the sun coming up and setting for example.
For geographic resolution, having data at a balancing authority level lets you see the impact of decisions being made by one operator of that part of the grid in terms of ramping up fossil fuel powered generation, and so on.
Currently this information is not available via the EIA API data portal, but it is available if you know to:
This project pretty much does these steps, and makes the data points available in a sqlite database that is easy to query, as well as creating parquet files that have the same data in very portable, easily queryable form.
it would be so much nicer to just have this extra datapoint in the nice new v2 of their API. I'm hoping me creating this repo can help demonstrate doing so that it would be useful to people
This repo contains a python script that will
For convenience, it includes datasette, so you can make the SQlite database avialable for easy querying.
Pull requests are very gratefully accepted
Apache 2.0