out_eia861__yearly_utility_service_territory

package: pudl

Annual time series of counties in utility service territories.

Most-recent data:

2024

Processing:

Data is ready for use in analyses, but for practical reasons has not been denormalized and remains in narrow format.

Source:

EIA Form 861 -- Annual Electric Power Industry Report

Primary key:

utility_id_eia, report_date, county_id_fips

Additional Details

Contains additional information about counties.

Columns
county_id_fips

County ID from the Federal Information Processing Standard Publication 6-4.

county_name_census

County name as specified in Census DP1 Data.

population

County population, sourced from Census DP1 data.

area_km2

County area in km2.

report_date

Date reported.

utility_id_eia

The EIA Utility Identification number.

state

Two letter US state abbreviation.

county

County name.

state_id_fips

Two digit state FIPS code.

out_eia861__yearly_balancing_authority_service_territory

package: pudl

Annual time series of counties in balancing authority service territories.

Most-recent data:

2024

Processing:

Data is ready for use in analyses, but for practical reasons has not been denormalized and remains in narrow format.

Source:

EIA Form 861 -- Annual Electric Power Industry Report

Primary key:

balancing_authority_id_eia, report_date, county_id_fips, county

Columns
county_id_fips

County ID from the Federal Information Processing Standard Publication 6-4.

county_name_census

County name as specified in Census DP1 Data.

population

County population, sourced from Census DP1 data.

area_km2

County area in km2.

report_date

Date reported.

balancing_authority_id_eia

EIA balancing authority ID. This is often (but not always!) the same as the utility ID associated with the same legal entity.

state

Two letter US state abbreviation.

county

County name.

state_id_fips

Two digit state FIPS code.

core_eia861__assn_utility

package: pudl

Association table providing connections between utility and state in a given year.

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

Primary key:

report_date, utility_id_eia, state

Columns
report_date

Date reported.

utility_id_eia

The EIA Utility Identification number.

state

Two letter US state abbreviation.

core_eia861__yearly_mergers

package: pudl

Annual time series of utility mergers and acquisitions.

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

Primary key:

This table has no primary key.

Columns
entity_type

Entity type of principal owner.

merge_address

Address of new parent company.

merge_city

City of new parent company.

merge_company

Name of the company merged with or acquired.

merge_date

Date of merger or acquisition.

merge_state

Two letter US state abbreviations and three letter ISO-3166-1 country codes for international mines.

new_parent

Name of the new parent company post merger.

report_date

Date reported.

state

Two letter US state abbreviation.

utility_id_eia

The EIA Utility Identification number.

utility_name_eia

The name of the utility.

zip_code

Five digit US Zip Code.

zip_code_4

Four digit US Zip Code suffix.

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.

core_eia861__yearly_reliability

package: pudl

Annual time series of electricity system reliability and outage impacts.

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 (Schedules 3B and 3C)

Primary key:

utility_id_eia, state, report_date, standard

Note: standard is included because while respondents are asked to only fill out one of parts B or C, sometimes they fill out both.

Additional Details

Contains information on non-momentary electrical interruptions. Includes the system average interruption duration index (SAIDI), system average interruption frequency index (SAIFI), and customer average interruption duration index (CAIDI) aka SAIDI/SAIFI with and without major event days and loss of service. Includes the standard (IEEE/other) and other relevant information.

SAIDI is measured in minutes, and represents the sum over the year of all customers interrupted times the number of minutes they experienced an interruption, divided by total number of customers.

SAIFI is measured in customers, and represents the sum over the year of the total number of customers that experienced an interruption, divided by the total number of customers.

The IEEE standards which can be used to calculate SAIDI and SAIFI include IEEE 1366-2003 and IEEE 1366-2012. These standards define momentary interruptions as having a duration of five minutes or less. If one of these IEEE standards is used, respondents fill out part B and are required to specify:

  • SAIDI major event days minus loss of supply

  • SAIFI major event days minus loss of supply

SAIDI and SAIFI major event days minus loss of supply excludes events where the reliability event resulted from an event on the distribution system, not from the high-voltage system. The voltage that distinguishes the distribution system from the supply system is given in highest_distribution_voltage_kv.

If a method other than these IEEE standards is used for calculating SAIDI and SAIFI indexes, respondents fill out part C and are required to specify:

  • whether inactive accounts are included

  • how they define a momentary interruption (less than 1 minute, less than or equal to 5 minutes, or other)

In this table, column standard is "ieee_standard" for respondents who have filled out part B, and "other_standard" for respondents who have filled out part C.

Columns
caidi_w_major_event_days_minus_loss_of_service_minutes

Average number of minutes per interruption (SAIDI/SAIFI) including major event days and excluding reliability events caused by a loss of supply.

caidi_w_major_event_days_minutes

Average number of minutes per interruption (SAIDI/SAIFI) including major event days.

caidi_wo_major_event_days_minutes

Average number of minutes per interruption (SAIDI/SAIFI) excluding major event days.

customers

Number of customers.

entity_type

Entity type of principal owner.

highest_distribution_voltage_kv

The highest voltage that's part of the distribution system.

inactive_accounts_included

Whether the respondent includes inactive accounts in its definition of customers used to determine SAIDI and SAIFI.

momentary_interruption_definition

How the respondent defines momentary service interruptions: less than 1 min, equal to or less than 5 min, or some other way.

outages_recorded_automatically

Whether the information about customer outages is recorded automatically.

report_date

Date reported.

saidi_w_major_event_days_minus_loss_of_service_minutes

Cumulative duration (minutes) of interruption for the average customer during the report year including major event days and excluding reliability events caused by a loss of supply.

saidi_w_major_event_days_minutes

Cumulative duration (minutes) of interruption for the average customer during the report year including major event days.

saidi_wo_major_event_days_minutes

Cumulative duration (minutes) of interruption for the average customer during the report year excluding major event days.

saifi_w_major_event_days_customers

Average number of times a customer experienced a sustained interruption (over 5 minutes) during the report year including major event days.

saifi_w_major_event_days_minus_loss_of_service_customers

Average number of times a customer experienced a sustained interruption (over 5 minutes) during the report year including major event days and excluding reliability events caused by a loss of supply.

saifi_wo_major_event_days_customers

Average number of times a customer experienced a sustained interruption (over 5 minutes) during the report year excluding major event days.

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.

standard

Whether the respondent calculates SAIDI/SAIFI, and major event days according to the IEEE or an Other standard.

state

Two letter US state abbreviation.

utility_id_eia

The EIA Utility Identification number.

utility_name_eia

The name of the utility.

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.

core_eia861__yearly_sales

package: pudl

Annual time series of electricity sales to ultimate customers by utility, balancing authority, state, and customer class.

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

Primary key:

utility_id_eia, state, report_date, balancing_authority_code_eia, customer_class, business_model, service_type

Columns
utility_id_eia

The EIA Utility Identification number.

state

Two letter US state abbreviation.

report_date

Date reported.

balancing_authority_code_eia

EIA short code identifying a balancing authority. May include Canadian and Mexican BAs.

customer_class

High level categorization of customer type (e.g., commercial, residential).

business_model

Business model.

data_observed

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

entity_type

Entity type of principal owner.

service_type

The type of service the respondent provides to a given customer class.Bundled: both energy and delivery; energy: just the energy consumed; delivery: just the billing and energy delivery services.

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.

utility_name_eia

The name of the utility.

customers

Number of customers.

sales_mwh

Quantity of electricity sold in MWh.

sales_revenue

Revenue from electricity sold.

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.

core_eia861__assn_balancing_authority

package: pudl

Association table providing connections between state, balancing authority, and utility in a given year.

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

Primary key:

report_date, balancing_authority_id_eia, utility_id_eia, state

Columns
report_date

Date reported.

balancing_authority_id_eia

EIA balancing authority ID. This is often (but not always!) the same as the utility ID associated with the same legal entity.

utility_id_eia

The EIA Utility Identification number.

state

Two letter US state abbreviation.

core_eia861__yearly_balancing_authority

package: pudl

Annual time series of balancing authorities.

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

Primary key:

report_date, balancing_authority_id_eia

Columns
report_date

Date reported.

balancing_authority_id_eia

EIA balancing authority ID. This is often (but not always!) the same as the utility ID associated with the same legal entity.

balancing_authority_code_eia

EIA short code identifying a balancing authority. May include Canadian and Mexican BAs.

balancing_authority_name_eia

Name of the balancing authority.

core_eia861__yearly_demand_response

package: pudl

Annual time series of demand response programs by state, sector, and balancing authority.

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

Primary key:

balancing_authority_code_eia, customer_class, report_date, state, utility_id_eia

Additional Details

The EIA861 demand-side management (DSM) table (split into three normalized tables in PUDL) contain data through 2012. The form changed in 2013 and split the contents of the DSM table into energy efficiency and demand response tables. Though similar, the information collected before and after 2012 are not comparable enough to combine into a singular, continuous table. We were discouraged from doing so after contacting a representative from EIA.

Columns
actual_peak_demand_savings_mw

Demand reduction actually achieved by demand response activities. Measured at the time of the company's annual system peak hour.

balancing_authority_code_eia

EIA short code identifying a balancing authority. May include Canadian and Mexican BAs.

customer_class

High level categorization of customer type (e.g., commercial, residential).

customer_incentives_cost

Total cost of customer incentives in a given report year. Customer incentives are the total financial value provided to a customer for program participation, whether, for example, cash payment, or lowered tariff rates relative to non-participants, in-kind services (e.g. design work), or other benefits directly provided to the customer for their program participation.

customers

Number of customers.

energy_savings_mwh

The energy savings incurred in a given reporting year by participation in demand response programs.

other_costs

Additional costs.

potential_peak_demand_savings_mw

The total demand savings that could occur at the time of the system peak hour assuming all demand response is called.

report_date

Date reported.

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.

utility_id_eia

The EIA Utility Identification number.

utility_name_eia

The name of the utility.

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.

core_eia861__yearly_distribution_systems

package: pudl

Annual time series of distribution circuits and circuits with voltage optimization by state.

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

Primary key:

This table has no primary key.

Columns
circuits_with_voltage_optimization

Number of distribution circuits that employ voltage/VAR optimization (VVO).

distribution_circuits

Total number of distribution circuits.

report_date

Date reported.

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.

utility_id_eia

The EIA Utility Identification number.

utility_name_eia

The name of the utility.

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.

core_eia861__yearly_dynamic_pricing

package: pudl

Annual time series of enrollment in dynamic pricing programs by state, sector, and balancing authority.

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

Primary key:

This table has no primary key.

Additional Details

Respondents check if one or more customers are enrolled in time-of-use pricing, real time pricing, variable peak pricing, critical peak pricing, and critical peak rebates.

Columns
balancing_authority_code_eia

EIA short code identifying a balancing authority. May include Canadian and Mexican BAs.

critical_peak_pricing

Whether customers are participating in critical peak pricing, a program in which rate and/or price structure is designed to encourage reduced consumption during periods of high wholesale market prices or system contingencies, by imposing a pre-specified high rate or price for a limited number of days or hours.

critical_peak_rebate

Whether customers are participating in critical peak rebates, a program in which rate and/or price structure is designed to encourage reduced consumption during periods of high wholesale market prices or system contingencies, by providing a rebate to the customer on a limited number of days and for a limited number of hours, at the request of the energy provider.

customer_class

High level categorization of customer type (e.g., commercial, residential).

customers

Number of customers.

real_time_pricing

Whether the respondent has customers participating in a real time pricing (RTP) program. RTP is a program of rate and price structure in which the retail price for electricity typically fluctuates hourly or more often, to reflect changes in the wholesale price of electricity on either a day- ahead or hour-ahead basis.

report_date

Date reported.

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.

time_of_use_pricing

Whether the respondent has customers participating in a time-of-use pricing programs (TOU). TOU is a program in which customers pay different prices at different times of the day. On-peak prices are higher and off-peak prices are lower than a “standard” rate. Price schedule is fixed and predefined, based on season, day of week, and time of day.

utility_id_eia

The EIA Utility Identification number.

utility_name_eia

The name of the utility.

variable_peak_pricing

Whether the respondent has customers participating in a variable peak pricing program (VPP). VPP is a program in which a form of TOU pricing allows customers to purchase their generation supply at prices set on a daily basis with varying on-peak and constant off-peak rates. Under the VPP program, the on-peak price for each weekday becomes available the previous day (typically late afternoon) and the customer is billed for actual consumption during the billing cycle at these prices.

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.

core_eia861__yearly_energy_efficiency

package: pudl

Annual time series of incremental energy savings, peak demand savings, weighted average life cycle, and associated costs for the reporting year and life cycle of energy efficiency programs.

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

Primary key:

This table has no primary key.

Additional Details

The EIA861 demand-side management (DSM) table (split into three normalized tables in PUDL) contain data through 2012. The form changed in 2013 and split the contents of the DSM table into energy efficiency and demand response tables. Though similar, the information collected before and after 2012 are not comparable enough to combine into a singular, continuous table. We were discouraged from doing so after contacting a representative from EIA.

Columns
balancing_authority_code_eia

EIA short code identifying a balancing authority. May include Canadian and Mexican BAs.

customer_class

High level categorization of customer type (e.g., commercial, residential).

customer_incentives_incremental_cost

The cost of customer incentives resulting from new participants in existing energy efficiency programs and all participants in new energy efficiency programs. Customer incentives are the total financial value provided to a customer for program participation, whether, for example, cash payment, or lowered tariff rates relative to non-participants, in-kind services (e.g. design work), or other benefits directly provided to the customer for their program participation.

customer_incentives_incremental_life_cycle_cost

All anticipated costs of the customer incentives including reporting year incremental costs and all future costs. Customer incentives are the total financial value provided to a customer for program participation, whether, for example, cash payment, or lowered tariff rates relative to non-participants, in-kind services (e.g. design work), or other benefits directly provided to the customer for their program participation.

customer_other_costs_incremental_life_cycle_cost

All anticipated costs other than customer incentives. Includes reporting year incremental costs and all future costs.

incremental_energy_savings_mwh

Energy savings in the given report year resulting from new participants in existing demand response programs and all participants in new demand response programs.

incremental_life_cycle_energy_savings_mwh

The estimated total changes in energy use for incremental programs and participants over the life of the programs. DSM programs have a useful life, and the net effects of these programs will diminish over time. Considers the useful life of energy efficiency technology by accounting for building demolition, equipment degradation, and program attrition.

incremental_life_cycle_peak_reduction_mw

The estimated total changes in peak load for incremental programs and participants over the life of the programs. DSM programs have a useful life, and the net effects of these programs will diminish over time. Considers the useful life of energy efficiency technology by accounting for building demolition, equipment degradation, and program attrition.

incremental_peak_reduction_mw

The peak reduction incurred in a given reporting year by new participants in existing energy efficiency programs and all participants in new energy efficiency programs.

other_costs_incremental_cost

Costs resulting from new participants in existing energy efficiency programs and all participants in new energy efficiency programs that aren't directly associated with customer incentives.

report_date

Date reported.

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.

utility_id_eia

The EIA Utility Identification number.

utility_name_eia

The name of the utility.

weighted_average_life_years

The weighted average life of the respondent's portfolio of energy efficiency programs.

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.

core_eia861__yearly_green_pricing

package: pudl

Annual time series of green pricing program revenue, sales, and customer count by sector and state.

Most-recent data:

2012

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

Primary key:

This table has no primary key.

Usage Warnings

  • The original data is no longer being collected or reported in this way.

Columns
customer_class

High level categorization of customer type (e.g., commercial, residential).

customers

Number of customers.

green_pricing_revenue

The money derived from premium green pricing rate of the respondent'sprogram.

rec_revenue

Amount of revenue collected from Renewable Energy Certificates (RECs).

rec_sales_mwh

Amount of sales collected from Renewable Energy Certificates (RECs).

report_date

Date reported.

sales_mwh

Quantity of electricity sold in MWh.

state

Two letter US state abbreviation.

utility_id_eia

The EIA Utility Identification number.

utility_name_eia

The name of the utility.

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.

core_eia861__yearly_service_territory

package: pudl

Annual time series of counties in utility service territories.

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

Primary key:

report_date, utility_id_eia, county_id_fips

Columns
county

County name.

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.

utility_id_eia

The EIA Utility Identification number.

utility_name_eia

The name of the utility.

report_date

Date reported.

state_id_fips

Two digit state FIPS code.

county_id_fips

County ID from the Federal Information Processing Standard Publication 6-4.

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.

core_eia861__yearly_short_form

package: pudl

Annual time series of data from the short form (EIA-861S).

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

Primary key:

utility_id_eia, state, report_date, balancing_authority_code_eia

Usage Warnings

  • Some years are missing from the data record.

Additional Details

The data started being reported in 2012. However, the 2019 data is not available. They are expected to submit the completed Form EIA-861S to EIA by April 30th, following the end of the prior calendar year. Utilities report on Form EIA-861S if they:

  • Report less than 200,000 megawatthours on the last previous Form EIA-861.

  • Provide only bundled service (generation and distribution).

  • Are not needed to ensure acceptable quality of statistical estimates.

  • Are not part of the aggregate TVA or WPPI.

  • Do not report on Form EIA-861M.

Columns
report_date

Date reported.

utility_id_eia

The EIA Utility Identification number.

utility_name_eia

The name of the utility.

entity_type

Entity type of principal owner.

state

Two letter US state abbreviation.

balancing_authority_code_eia

EIA short code identifying a balancing authority. May include Canadian and Mexican BAs.

sales_revenue

Revenue from electricity sold.

sales_mwh

Quantity of electricity sold in MWh.

customers

Number of customers.

has_net_metering

Whether the plant has a net metering agreement in effect during the reporting year. (Only displayed for facilities that report the sun or wind as an energy source). This field was only reported up until 2015

has_demand_side_management

Whether there were strategies or measures used to control electricity demand by customers

has_time_responsive_programs

Whether the respondent operates any time-based rate programs (e.g., real-time pricing, critical peak pricing, variable peak pricing and time-of-use rates administered through a tariff).

has_green_pricing

Whether a green pricing program was associated with this utility during the reporting year.

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.

core_eia861__yearly_advanced_metering_infrastructure

package: pudl

Annual time series of advanced metering infrastructure (AMI) and automated meter reading (AMR) by state, sector, and balancing authority.

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

Primary key:

balancing_authority_code_eia, customer_class, report_date, state, utility_id_eia

Additional Details

The energy served (in MWH) for AMI systems is provided. Form EIA-861 respondents also report the number of standard meters (non AMR/AMI) in their system. Historical Changes: We started collecting the number of standard meters in 2013. The monthly survey collected these data from January 2011 to January 2017.

Columns
advanced_metering_infrastructure

Number of meters that measure and record usage data at a minimum, in hourly intervals and provide usage data at least daily to energy companies and may also provide data to consumers. Data are used for billing and other purposes. Advanced meters include basic hourly interval meters and extend to real-time meters with built-in two-way communication capable of recording and transmitting instantaneous data.

automated_meter_reading

Number of meters that collect data for billing purposes only and transmit this data one way, usually from the customer to the distribution utility.

balancing_authority_code_eia

EIA short code identifying a balancing authority. May include Canadian and Mexican BAs.

customer_class

High level categorization of customer type (e.g., commercial, residential).

daily_digital_access_customers

Number of customers able to access daily energy usage through a webportal or other electronic means.

direct_load_control_customers

Number of customers with direct load control: a A demand response activity by which the program sponsor remotely shuts down or cycles a customer’s electrical equipment (e.g. air conditioner, water heater) on short notice.

energy_served_ami_mwh

Amount of energy served through AMI meters. AMI meters can transmit data in both directions, between the delivery entity and the customer.

entity_type

Entity type of principal owner.

home_area_network

Number of AMI meters with home area network (HAN) gateway enabled.

non_amr_ami

Number of non-AMR/AMI meters. Usually electromechanical or solid state meters measuring aggregated kWh where data are manually retrieved over monthly billing cycles for billing purposes only. Standard meters may also include functions to measure time-of-use and/or demand with data manually retrieved over monthly billing cycles.

report_date

Date reported.

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.

utility_id_eia

The EIA Utility Identification number.

utility_name_eia

The name of the utility.

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.

core_eia861__yearly_distributed_generation_fuel

package: pudl

Annual time series of the energy sources used for utility or customer-owned distributed generation capacity.

Most-recent data:

2015

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

Primary key:

This table has no primary key.

Usage Warnings

  • The original data is no longer being collected or reported in this way.

Additional Details

From 2016 on, there's no great match for the data found in this table. You may be able to compute an analog for fuel percents using the capacity and tech class figures in core_eia861__yearly_non_net_metering_customer_fuel_class, but no corresponding consumption or generation information is available in the new format.

The raw EIA861 distributed generation (DG) table (split into three normalized tables in PUDL) was renamed in 2016 to Non-Net Metering to prevent double counting. The data in the Non-Net Metering table (2016+) are split by sector, contain fuel cell information, and convert capacity reported in DC units to AC units.

Columns
estimated_or_actual_fuel_data

Whether the reported fuel data is estimated or actual.

fuel_class

Fuel types specific to EIA 861 distributed generation table: ['gas', 'oil', 'other', 'renewable', 'water', 'wind', 'wood']

fuel_pct

Percent of fuel

report_date

Date reported.

state

Two letter US state abbreviation.

utility_id_eia

The EIA Utility Identification number.

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.

core_eia861__yearly_distributed_generation_misc

package: pudl

Annual time series of the capacity and quantity of utility or customer-owned distributed generation.

Most-recent data:

2015

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

Primary key:

This table has no primary key.

Usage Warnings

  • The original data is no longer being collected or reported in this way.

Additional Details

From 2016 on, data similar to that found in this table can be found in core_eia861__yearly_non_net_metering_misc.

The raw EIA861 distributed generation (DG) table (split into three normalized tables in PUDL) was renamed in 2016 to Non-Net Metering to prevent double counting. The data in the Non-Net Metering table (2016+) are split by sector, contain fuel cell information, and convert capacity reported in DC units to AC units.

Columns
backup_capacity_mw

The total nameplate capacity of generators that are used only for emergency backup service.

distributed_generation_owned_capacity_mw

Amount of distributed generation capacity owned by the respondent.

estimated_or_actual_capacity_data

Whether the reported capacity data is estimated or actual.

generators_num_less_1_mw

Total number of generators less than 1 MW.

generators_number

Total number of generators

report_date

Date reported.

state

Two letter US state abbreviation.

total_capacity_less_1_mw

The total amount of capacity from generators with less than 1 MW of nameplate capacity.

utility_id_eia

The EIA Utility Identification number.

utility_name_eia

The name of the utility.

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.

core_eia861__yearly_distributed_generation_tech

package: pudl

Annual time series of the technology used for utility or customer-owned distributed generation.

Most-recent data:

2015

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

Primary key:

This table has no primary key.

Usage Warnings

  • The original data is no longer being collected or reported in this way.

Additional Details

From 2016 on, data similar to that found in this table can be found in core_eia861__yearly_non_net_metering_customer_fuel_class.

The raw EIA861 distributed generation (DG) table (split into three normalized tables in PUDL) was renamed in 2016 to Non-Net Metering to prevent double counting. The data in the Non-Net Metering table (2016+) are split by sector, contain fuel cell information, and convert capacity reported in DC units to AC units.

Columns
capacity_mw

Total installed (nameplate) capacity, in megawatts.

estimated_or_actual_tech_data

Whether the reported technology data is estimated or actual.

report_date

Date reported.

state

Two letter US state abbreviation.

tech_class

Type of technology specific to EIA 861 distributed generation and net generation tables: ['backup', 'chp_cogen', 'combustion_turbine', 'fuel_cell', 'hydro', 'internal_combustion', 'other', 'pv', 'steam', 'storage_pv', 'storage_nonpv', 'all_storage', 'total', 'virtual_pv', 'virtual_pv_under_1mw', 'virtual_pv_over_1mw', 'wind'].

utility_id_eia

The EIA Utility Identification number.

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.

core_eia861__yearly_net_metering_misc

package: pudl

Annual time series of PV current flow type for net metered capacity.

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

Primary key:

This table has no primary key.

Columns
balancing_authority_code_eia

EIA short code identifying a balancing authority. May include Canadian and Mexican BAs.

pv_current_flow_type

Current flow type for photovoltaics: AC or DC

report_date

Date reported.

state

Two letter US state abbreviation.

utility_id_eia

The EIA Utility Identification number.

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.

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.

core_eia861__yearly_operational_data_revenue

package: pudl

Annual time series of utility revenue by type of electric operating revenue.

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 2C)

Primary key:

utility_id_eia, nerc_region, report_date, revenue_class

Usage Warnings

  • Some values have been redacted.

Additional Details

A utility's revenue by type of electric operating revenue. Includes electric operating revenue from sales to ultimate customers, revenue from unbundled (delivery) customers, revenue from sales for resale, electric credits/other adjustments, revenue from transmission, other electric operating revenue, and total electric operating revenue.

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>.

Columns
nerc_region

NERC region in which the plant is located

report_date

Date reported.

revenue

Amount of revenue.

revenue_class

Source of revenue (e.g., retail sales, transmission).

state

Two letter US state abbreviation.

utility_id_eia

The EIA Utility Identification number.

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.

core_eia861__yearly_utility_data_misc

package: pudl

Annual time series of utility business activities.

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

Primary key:

This table has no primary key. The primary key would have been: utility_id_eia, state, report_date, and nerc_region, but there are nulls in the state column across several years of reporting.

Additional Details

This includes whether they operate alternative fuel vehicles, whether they provide transmission, distribution, or generation services (bundled or unbundled), and whether they engage in wholesale and/or retail markets.

Columns
alternative_fuel_vehicle_2_activity

Whether the utility plants to operate alternative-fueled vehicles this coming year.

alternative_fuel_vehicle_activity

Whether the utility operates alternative-fueled vehicles during the year.

bundled_activity

Whether a utility engaged in combined utility services (electricity plus other services such as gas, water, etc. in addition to electric services) during the year.

buying_distribution_activity

Whether a utility bought any distribution on other electrical systems during the year.

buying_transmission_activity

Whether a utility bought any transmission services on other electrical systems during the year.

distribution_activity

Whether a utility engaged in any distribution using owned/leased electrical wires during the year.

entity_type

Entity type of principal owner.

generation_activity

Whether a utility utilized generation from company owned plant during the year.

nerc_region

NERC region in which the plant is located

operates_generating_plant

Whether the respondent operated at least one generating plant during the reporting period.

report_date

Date reported.

retail_marketing_activity

Whether a utility engaged in retail power marketing during the year.

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.

transmission_activity

Whether a utility engaged in any transmission activities during the year.

utility_id_eia

The EIA Utility Identification number.

utility_name_eia

The name of the utility.

wholesale_marketing_activity

Whether a utility engages in wholesale power marketing during the year.

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.

core_eia861__yearly_utility_data_nerc

package: pudl

Annual time series of the NERC regions that utilities operate in.

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

Primary key:

This table has no primary key. The primary key would have been: utility_id_eia, state, report_date, nerc_region, and nerc_regions_of_operation, but there are nulls in the state column across several years of reporting.

Columns
nerc_region

NERC region in which the plant is located

nerc_regions_of_operation

All the regional entities within the North American Electric Reliability Corporation (NERC) in which the respodent conducts operations.

report_date

Date reported.

state

Two letter US state abbreviation.

utility_id_eia

The EIA Utility Identification number.

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.

core_eia861__yearly_utility_data_rto

package: pudl

Annual time series of the RTOs that utilities operate in.

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

Primary key:

This table has no primary key. The primary key would have been: utility_id_eia, state, report_date, nerc_region, and rtos_of_operation, but there are nulls in the state column across several years of reporting.

Columns
nerc_region

NERC region in which the plant is located

report_date

Date reported.

rtos_of_operation

The ISOs/RTOs, in which the respondent conducts operations.

state

Two letter US state abbreviation.

utility_id_eia

The EIA Utility Identification number.

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.

core_eia861__yearly_demand_response_water_heater

package: pudl

Annual time series of grid-connected water heaters enrolled in demand response programs.

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

Primary key:

balancing_authority_code_eia, report_date, state, utility_id_eia

Columns
balancing_authority_code_eia

EIA short code identifying a balancing authority. May include Canadian and Mexican BAs.

report_date

Date reported.

state

Two letter US state abbreviation.

utility_id_eia

The EIA Utility Identification number.

num_water_heaters

The number of grid-enabled water heaters added to the respondent's program this year - if the respondent has DSM program for grid-enabled water heaters (as defined by DOE’s Office of Energy Efficiency and Renewable Energy).

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.

core_eia861__yearly_demand_side_management_misc

package: pudl

Annual time series of demand-side management (DSM) program information.

Most-recent data:

2012

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

Primary key:

This table has no primary key.

Usage Warnings

  • The original data is no longer being collected or reported in this way.

Additional Details

Includes boolean fields about whether the energy savings estimates/calculations were independently verified and whether the utility runs time and or price responsive programs. Also contains information on whether any of the respondent's DSM activities are reported under another company, and if so which one.

The raw EIA861 demand-side management (DSM) table (split into three normalized tables in PUDL) contain data through 2012. The form changed in 2013 and split the contents of the DSM table into energy efficiency and demand response tables. Though similar, the information collected before and after 2012 are not comparable enough to combine into a singular, continuous table. We were discouraged from doing so after contacting a representative from EIA.

Columns
energy_savings_estimates_independently_verified

Whether savings estimates are based on a forecast or the report of one or more independent evaluators.

energy_savings_independently_verified

Whether reported energy savings were verified through an independent evaluation.

entity_type

Entity type of principal owner.

major_program_changes

Whether there have been any major changes to the respondent's demand-side management programs (e.g., terminated programs, new information or financing programs, or a shift to programs with dual load building objectives and energy efficiency objectives), program tracking procedures, or reporting methods that affect the comparison of demand-side management data reported on this schedule to data from previous years.

nerc_region

NERC region in which the plant is located

price_responsive_programs

Whether the respondent operates any incentive-based demand response programs (e.g., market incentives, financial incentives, direct load control, interruptible programs, demand bidding/buyback, emergency demand response, capacity market programs, and ancillary service market programs).

report_date

Date reported.

reported_as_another_company

The name of the company if a respondent's demand-side management activities are reported on Schedule 6 of another company’s form.

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.

has_time_responsive_programs

Whether the respondent operates any time-based rate programs (e.g., real-time pricing, critical peak pricing, variable peak pricing and time-of-use rates administered through a tariff).

utility_id_eia

The EIA Utility Identification number.

utility_name_eia

The name of the utility.

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.

core_eia861__yearly_demand_side_management_sales

package: pudl

Annual time series of electricity sales related to demand-side management (DSM).

Most-recent data:

2012

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

Primary key:

This table has no primary key.

Usage Warnings

  • The original data is no longer being collected or reported in this way.

Additional Details

The raw EIA861 demand-side management (DSM) table (split into three normalized tables in PUDL) contain data through 2012. The form changed in 2013 and split the contents of the DSM table into energy efficiency and demand response tables. Though similar, the information collected before and after 2012 are not comparable enough to combine into a singular, continuous table. We were discouraged from doing so after contacting a representative from EIA.

Columns
nerc_region

NERC region in which the plant is located

report_date

Date reported.

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.

sales_to_ultimate_consumers_mwh

The amount of electricity sold to customers purchasing electricity for their own use and not for resale.

state

Two letter US state abbreviation.

utility_id_eia

The EIA Utility Identification number.

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.

core_eia861__yearly_non_net_metering_misc

package: pudl

Annual time series of non-net metered distributed generation generators, pv current flow type, backup capacity and utility owned capacity.

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

Primary key:

This table has no primary key.

Additional Details

This table's data starts in 2016. For 2015 and earlier, data similar to that found in this table can be found in core_eia861__yearly_distributed_generation_misc.

The raw EIA861 distributed generation (DG) table (split into three normalized tables in PUDL) was renamed in 2016 to Non-Net Metering to prevent double counting. The data in the Non-Net Metering table (2016+) are split by sector, contain fuel cell information, and convert capacity reported in DC units to AC units.

Columns
backup_capacity_mw

The total nameplate capacity of generators that are used only for emergency backup service.

balancing_authority_code_eia

EIA short code identifying a balancing authority. May include Canadian and Mexican BAs.

generators_number

Total number of generators

pv_current_flow_type

Current flow type for photovoltaics: AC or DC

report_date

Date reported.

state

Two letter US state abbreviation.

utility_id_eia

The EIA Utility Identification number.

utility_owned_capacity_mw

Total non-net-metered capacity owned by the respondent.

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.

core_eia861__yearly_demand_side_management_ee_dr

package: pudl

Annual time series of The impact of energy efficiency and load management programs on total energy sold (MWh) and peak demand (MW) by customer class.

Most-recent data:

2012

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

Primary key:

This table has no primary key.

Usage Warnings

  • The original data is no longer being collected or reported in this way.

Additional Details

The raw EIA861 demand-side management (DSM) table (split into three normalized tables in PUDL) contain data through 2012. The form changed in 2013 and split the contents of the DSM table into energy efficiency and demand response tables. Though similar, the information collected before and after 2012 are not comparable enough to combine into a singular, continuous table. We were discouraged from doing so after contacting a representative from EIA.

Columns
annual_indirect_program_cost

Costs that have not been included in any program category, but could be meaningfully identified with operating the company’s DSM programs (e.g., Administrative, Marketing, Monitoring & Evaluation, Company-Earned Incentives, Other).

annual_total_cost

The sum of direct program costs, indirect program costs, and incentive payments associated with utility demand side management programs.

customer_class

High level categorization of customer type (e.g., commercial, residential).

energy_efficiency_annual_actual_peak_reduction_mw

The peak reduction incurred in a given reporting year by all participants in efficiency programs.

energy_efficiency_annual_direct_cost

The sum of actual direct costs (excluding incentive payments) incurred from energy efficiency programs in a given reporting year.

energy_efficiency_annual_effects_mwh

The change in energy use incurred in a given reporting year by all participants in energy efficiency programs.

energy_efficiency_annual_incentive_cost

The cost of incentive payments incurred in a given reporting year from energy efficiency programs. Incentives are the total financial value provided to a customer for program participation, whether cash payment, in-kind services (e.g. design work), or other benefits directly provided customer for their program participation.

energy_efficiency_incremental_actual_peak_reduction_mw

The peak reduction incurred in a given reporting year by new participants in existing energy efficiency programs and all participants in new energy efficiency programs.

energy_efficiency_incremental_effects_mwh

The change in energy use incurred in a given reporting year by new participants in existing energy efficiency programs and all participants in new energy efficiency programs.

load_management_annual_actual_peak_reduction_mw

The peak reduction incurred in a given reporting year by all participants in load management programs.

load_management_annual_direct_cost

The sum of actual direct costs (excluding incentive payments) incurred from load management programs in a given reporting year.

load_management_annual_effects_mwh

The change in energy use incurred in a given reporting year by all participants in load management programs.

load_management_annual_incentive_cost

The cost of incentive payments incurred in a given reporting year from load management programs. Incentives are the total financial value provided to a customer for program participation, whether cash payment, in-kind services (e.g. design work), or other benefits directly provided customer for their program participation.

load_management_annual_potential_peak_reduction_mw

The potential amount of peak reduction that could be incurred in a given reporting year by all participants in load management programs.

load_management_incremental_actual_peak_reduction_mw

The peak reduction incurred in a given reporting year by new participants in existing load management programs and all participants in new load management programs.

load_management_incremental_effects_mwh

The change in energy use incurred in a given reporting year by new participants in existing load management programs and all participants in new load management programs.

load_management_incremental_potential_peak_reduction_mw

The potential amount of peak reduction that could be incurred in a given reporting year by new participants in existing load management programs and all participants in new load management programs.

nerc_region

NERC region in which the plant is located

price_responsiveness_customers

The number of customers participating in the respondent's incentive-based demand response programs.

report_date

Date reported.

state

Two letter US state abbreviation.

time_responsiveness_customers

The number of cusomters participating in the respondent's time-based rate programs.

utility_id_eia

The EIA Utility Identification number.

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.

core_eia861__yearly_net_metering_customer_fuel_class

package: pudl

Annual time series of net metering by customer and fuel class.

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

Primary key:

This table has no primary key.

Usage Warnings

  • Some years use a slightly different data definition.

Additional Details

The amount of energy sold to back to the grid. From 2007 - 2009 the data are reported as a lump sum of total energy dispatched by sector. After 2009, the data are broken down by sector and technology type.

Columns
balancing_authority_code_eia

EIA short code identifying a balancing authority. May include Canadian and Mexican BAs.

capacity_mw

Total installed (nameplate) capacity, in megawatts.

energy_capacity_mwh

The total amount of energy which the system can supply power before recharging is necessary, in megawatt-hours.

customer_class

High level categorization of customer type (e.g., commercial, residential).

customers

Number of customers.

report_date

Date reported.

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.

sold_to_utility_mwh

The amount of electric energy sold back to the utility through the net metering application.

state

Two letter US state abbreviation.

tech_class

Type of technology specific to EIA 861 distributed generation and net generation tables: ['backup', 'chp_cogen', 'combustion_turbine', 'fuel_cell', 'hydro', 'internal_combustion', 'other', 'pv', 'steam', 'storage_pv', 'storage_nonpv', 'all_storage', 'total', 'virtual_pv', 'virtual_pv_under_1mw', 'virtual_pv_over_1mw', 'wind'].

utility_id_eia

The EIA Utility Identification number.

utility_name_eia

The name of the utility.

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.

core_eia861__yearly_non_net_metering_customer_fuel_class

package: pudl

Annual time series of non-net metered distributed generation by sector and technology type.

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

Primary key:

This table has no primary key.

Additional Details

This table's data starts in 2016. For 2015 and earlier, data similar to that found in this table can be found in core_eia861__yearly_distributed_generation_tech.

The raw EIA861 distributed generation (DG) table (split into three normalized tables in PUDL) was renamed in 2016 to Non-Net Metering to prevent double counting. The data in the Non-Net Metering table (2016+) are split by sector, contain fuel cell information, and convert capacity reported in DC units to AC units.

Columns
balancing_authority_code_eia

EIA short code identifying a balancing authority. May include Canadian and Mexican BAs.

capacity_mw

Total installed (nameplate) capacity, in megawatts.

energy_capacity_mwh

The total amount of energy which the system can supply power before recharging is necessary, in megawatt-hours.

customer_class

High level categorization of customer type (e.g., commercial, residential).

report_date

Date reported.

state

Two letter US state abbreviation.

tech_class

Type of technology specific to EIA 861 distributed generation and net generation tables: ['backup', 'chp_cogen', 'combustion_turbine', 'fuel_cell', 'hydro', 'internal_combustion', 'other', 'pv', 'steam', 'storage_pv', 'storage_nonpv', 'all_storage', 'total', 'virtual_pv', 'virtual_pv_under_1mw', 'virtual_pv_over_1mw', 'wind'].

utility_id_eia

The EIA Utility Identification number.

utility_name_eia

The name of the utility.

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.