EIA Form 861 – Annual Electric Power Industry Report#
Source URL |
|
---|---|
Source Description |
EIA Form 861 Annual Electric Power Industry Report, detailed data files. |
Source Years |
1990-2021 |
Download Size |
82 MB |
Years Liberated |
2001-2021 |
PUDL Code |
|
Issues |
Open EIA Form 861 – Annual Electric Power Industry Report issues |
PUDL Database Tables#
We’ve segmented the processed data into the following normalized data tables. Clicking on the links will show you a description of the table as well as the names and descriptions of each of its fields.
Background#
EIA Form EIA-861 (and the short form EIA-861S) make up the Annual Electric Power Industry Report, collecting data from distribution utilities and power marketers. It is a census of all United States electric utilities. As of 2023 PUDL only incorporates the annual data, but there’s also a less detailed monthly Form EIA-861M.
There are more than 20 different spreadsheets included in the annual zipfiles. For details, see the official EIA-861 page
Download the following files for further context:
How much of the data is accessible through PUDL?#
Who is required to fill out the form?#
What does the original data look like?#
Notable Irregularities#
In 2012-2013 the EIA-861 was overhauled. Several tables were discontinued, and many more were added. Similar kinds of information reported in the two regimes may not be directly comparable.
Most of the EIA-861 data that’s available in the PUDL DB has not yet been fully normalized, meaning it contains many duplicate copies of the same information, which may not always be internally consistent.
We also have not yet integrated the Balancing Authority and Utility IDs reported in the EIA-861 into our entity tables, so for the moment we don’t have any foreign key constraints enabled on the EIA-861 tables.
PUDL Data Transformations#
The PUDL transformation process cleans the input data so that it is adjusted for uniformity, corrected for errors, and ready for bulk programmatic use.
To see the transformations applied to the data in each table, you can read the
doc-strings for pudl.transform.eia861
created for each tables’ respective
transform function.