core_eia861__yearly_operational_data_misc

package: pudl

Annual time series of megawatt hours (MWH) for the sources and disposition of a utility's electricity.

Most-recent data:

2024

Processing:

Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.

Source:

EIA Form 861 -- Annual Electric Power Industry Report (Schedule 2B)

Primary key:

utility_id_eia, nerc_region, report_date

Usage Warnings

  • Some values have been redacted.

  • Contains rows where missing values were imputed.

Additional Details

Respondents are required to report this information to the EIA, but are not required to disclose utility-level data to the public. When a respondent chooses to keep its utility-level data proprietary, it files using EIA utility id 88888. For more details, see EIA-861 Notable Irregularities <eia861-notable-irregularities>.

Rows where data_observed is False were labeled as imputed in the raw EIA data. The EIA documentation does not specify what imputation applies to operational data, only net metering and non net-metering distributed data. Less than 1% of rows are labeled as imputed, all of which occur in 2004 or 2005. Imputed rows make up no more than 25% of the rows for any utility.

Columns
consumed_by_facility_mwh

The amount of electricity used by the facility.

consumed_by_respondent_without_charge_mwh

The amount of electricity used by the electric utility in its electric and other departments without charge.

data_observed

Is the value observed (True) or imputed (False).

entity_type

Entity type of principal owner.

exchange_energy_delivered_mwh

The amount of exchange energy delivered. Does not include power delivered as part of a tolling arrangement.

exchange_energy_received_mwh

The amount of exchange energy received. Does not include power received through tolling arrangements.

furnished_without_charge_mwh

The amount of electricity furnished by the electric utility without charge, such as to a municipality under a franchise agreement or for street and highway lighting.

nerc_region

NERC region in which the plant is located

net_generation_mwh

Net electricity generation for the specified period in megawatt-hours (MWh).

net_power_exchanged_mwh

The net amount of energy exchanged. Net exchange is the difference between the amount of exchange received and the amount of exchange delivered. This entry should not include wholesale energy purchased from or sold to regulated companies or unregulated companies for other systems.

net_wheeled_power_mwh

The difference between the amount of energy entering the respondent's system (wheeled received) for transmission through the respondent's system and the amount of energy leaving the respondent's system (wheeled delivered). Wheeled net represents the energy losses on the respondent's system associated with the wheeling of energy for other systems.

report_date

Date reported.

retail_sales_mwh

MWh of sales to end-use customers in areas where the customer has been given the legal right to select a power supplier other than the traditional, vertically integrated electric utility.

sales_for_resale_mwh

The amount of electricity sold for resale purposes. This entry should include sales for resale to power marketers (reported separately in previous years), full and partial requirements customers, firm power customers and nonfirm customers.

short_form

Whether the reported information comes from the short form. In the case of form EIA 861, a shorter version of the form was created in 2012 to reduce respondent burden on smaller utilities and increase our processing efficiency.

state

Two letter US state abbreviation.

summer_peak_demand_mw

The maximum hourly summer load (for the months of June through September) based on net energy for the system during the reporting year. Net energy for the system is the sum of energy an electric utility needs to satisfy their service area and includes full and partial wholesale requirements customers, and the losses experienced in delivery. The maximum hourly load is determined by the interval in which the 60-minute integrated demand is the greatest.

total_disposition_mwh

Sum of all disposition of electricity listed. Includes sales to ultimate customers, sales for resale, energy furnished without charge, energy consumed by respondent without charge and total energy losses.

total_energy_losses_mwh

The total amount of electricity lost from transmission, distribution, and/or unaccounted for. Should be expressed as a positive number.

total_sources_mwh

Sum of all sources of electricity listed. Includes net generation, purchases from electricity suppliers, net exchanges (received - delivered), net wheeled (received - delivered), transmission by others, and losses.

transmission_by_other_losses_mwh

The amount of energy losses associated with the wheeling of electricity provided to the respondent's system by other utilities. Transmission by others, losses should always be a negative value.

utility_id_eia

The EIA Utility Identification number.

utility_name_eia

The name of the utility.

wheeled_power_delivered_mwh

The total amount of energy leaving the respondent's system that was transmitted through the respondent's system for delivery to other systems. If wheeling delivered is not precisely known, the value is an estimate based on the respondent's system's known percentage of losses for wheeling transactions.

wheeled_power_received_mwh

The total amount of energy entering the respondent's system from other systems for transmission through the respondent's system (wheeling) for delivery to other systems. Does not include energy purchased or exchanged for consumption within the respondent's system, which was wheeled to the respondent by others.

wholesale_power_purchases_mwh

Purchases from electricity suppliers.

winter_peak_demand_mw

The maximum hourly winter load (for the months of January through March) based on net energy for the system during the reporting year. Net energy for the system is the sum of energy an electric utility needs to satisfy their service area and includes full and partial wholesale requirements customers, and the losses experienced in delivery. The maximum hourly load is determined by the interval in which the 60-minute integrated demand is the greatest.

data_maturity

Maturity of the source data published by EIA that is reflected in this record. EIA releases data incrementally over time, including monthly updates, annual year-to-date updates, provisional early releases of annual data, and final annual release data that is not expected to change further. Records sourced from multiple upstream EIA datasets may have no well defined data maturity. Records whose values have been inferred within PUDL will also have no data maturity.