core_ferc1__yearly_energy_dispositions_sched401

package: pudl

Annual time series of dispositions of electric energy sold, exchanged, or stored.

Most-recent data:

2025

Processing:

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

Source:

FERC Form 1 -- Annual Report of Major Electric Utilities (Schedule 401a)

Primary key:

utility_id_ferc1, report_year, energy_disposition_type

Usage Warnings

  • Some columns contain subtotals; use caution when choosing columns to aggregate.

  • FERC data is notoriously difficult to extract cleanly, and often contains free-form strings, non-labeled total rows and lack of IDs. See Notable Irregularities for details.

Additional Details

Electric Energy Account, dispositions only. Schedule 401a. Electricity utilities delivered to end users, internal losses, etc.

Columns
utility_id_ferc1

PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year.

report_year

Four-digit year in which the data was reported.

energy_disposition_type

Type of energy disposition reported in the core_ferc1__yearly_energy_dispositions_sched401. Dispositions include sales to customers, re-sales of energy, energy used internally, losses, etc.

row_type_xbrl

Indicates whether the value reported in the row is calculated, or uniquely reported within the table.

energy_mwh

Sources and uses of energy in MWh.

record_id

Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped.