EIA Form 861 – Annual Electric Power Industry Report#

Source URL

https://www.eia.gov/electricity/data/eia861

Source Description

EIA Form 861 Annual Electric Power Industry Report, detailed data files.

Download Size

87 MB

Temporal Coverage

2001-2022

PUDL Code

eia861

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.

Data Dictionary

Browse Online

core_eia861__assn_balancing_authority

https://data.catalyst.coop/pudl/core_eia861__assn_balancing_authority

core_eia861__assn_utility

https://data.catalyst.coop/pudl/core_eia861__assn_utility

core_eia861__yearly_advanced_metering_infrastructure

https://data.catalyst.coop/pudl/core_eia861__yearly_advanced_metering_infrastructure

core_eia861__yearly_balancing_authority

https://data.catalyst.coop/pudl/core_eia861__yearly_balancing_authority

core_eia861__yearly_demand_response

https://data.catalyst.coop/pudl/core_eia861__yearly_demand_response

core_eia861__yearly_demand_response_water_heater

https://data.catalyst.coop/pudl/core_eia861__yearly_demand_response_water_heater

core_eia861__yearly_demand_side_management_ee_dr

https://data.catalyst.coop/pudl/core_eia861__yearly_demand_side_management_ee_dr

core_eia861__yearly_demand_side_management_misc

https://data.catalyst.coop/pudl/core_eia861__yearly_demand_side_management_misc

core_eia861__yearly_demand_side_management_sales

https://data.catalyst.coop/pudl/core_eia861__yearly_demand_side_management_sales

core_eia861__yearly_distributed_generation_fuel

https://data.catalyst.coop/pudl/core_eia861__yearly_distributed_generation_fuel

core_eia861__yearly_distributed_generation_misc

https://data.catalyst.coop/pudl/core_eia861__yearly_distributed_generation_misc

core_eia861__yearly_distributed_generation_tech

https://data.catalyst.coop/pudl/core_eia861__yearly_distributed_generation_tech

core_eia861__yearly_distribution_systems

https://data.catalyst.coop/pudl/core_eia861__yearly_distribution_systems

core_eia861__yearly_dynamic_pricing

https://data.catalyst.coop/pudl/core_eia861__yearly_dynamic_pricing

core_eia861__yearly_energy_efficiency

https://data.catalyst.coop/pudl/core_eia861__yearly_energy_efficiency

core_eia861__yearly_green_pricing

https://data.catalyst.coop/pudl/core_eia861__yearly_green_pricing

core_eia861__yearly_mergers

https://data.catalyst.coop/pudl/core_eia861__yearly_mergers

core_eia861__yearly_net_metering_customer_fuel_class

https://data.catalyst.coop/pudl/core_eia861__yearly_net_metering_customer_fuel_class

core_eia861__yearly_net_metering_misc

https://data.catalyst.coop/pudl/core_eia861__yearly_net_metering_misc

core_eia861__yearly_non_net_metering_customer_fuel_class

https://data.catalyst.coop/pudl/core_eia861__yearly_non_net_metering_customer_fuel_class

core_eia861__yearly_non_net_metering_misc

https://data.catalyst.coop/pudl/core_eia861__yearly_non_net_metering_misc

core_eia861__yearly_operational_data_misc

https://data.catalyst.coop/pudl/core_eia861__yearly_operational_data_misc

core_eia861__yearly_operational_data_revenue

https://data.catalyst.coop/pudl/core_eia861__yearly_operational_data_revenue

core_eia861__yearly_reliability

https://data.catalyst.coop/pudl/core_eia861__yearly_reliability

core_eia861__yearly_sales

https://data.catalyst.coop/pudl/core_eia861__yearly_sales

core_eia861__yearly_service_territory

https://data.catalyst.coop/pudl/core_eia861__yearly_service_territory

core_eia861__yearly_utility_data_misc

https://data.catalyst.coop/pudl/core_eia861__yearly_utility_data_misc

core_eia861__yearly_utility_data_nerc

https://data.catalyst.coop/pudl/core_eia861__yearly_utility_data_nerc

core_eia861__yearly_utility_data_rto

https://data.catalyst.coop/pudl/core_eia861__yearly_utility_data_rto

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.