search

singularity-energy / open-grid-emissions

Tools for producing high-quality hourly generation and emissions data for U.S. electric grids
MIT License
72 stars 5 forks source link

Improve coverage of `ba_reference` table #66

Closed grgmiller closed 2 years ago

grgmiller commented 2 years ago

The table data/manual/ba_reference.csv lists all of the ba codes and relevant metadata about each BA for the pipeline. This file was created based on the BAs that exist in the EIA-930 reference tables (https://www.eia.gov/electricity/930-content/EIA930_Reference_Tables.xlsx). However, my understanding is that this data starts as of 2015, so BAs that retired before then might not be represented.

However, FERC maintains a spreadsheet of "Allowable Entries for Balancing Authorities and Hubs" on its EQR website which seems to be a more complete list. We should use this to improve the coverage of our ba_reference spreadsheet. We will have to manually identify the local time zone for each BA in this spreadsheet.

grgmiller commented 2 years ago

Also double check coverage based on EIA-861 ba list