core_ferc1__yearly_energy_sources_sched401
Annual time series of sources of electric energy generated or purchased, exchanged and wheeled.
- 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_source_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, sources only. Schedule 401a. Amount of electricity the utility obtained from each of several sources.
Columns
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.
Four-digit year in which the data was reported.
Type of energy source reported in the core_ferc1__yearly_energy_sources_sched401 table. There are three groups of energy sources: generation, power exchanges and transmission.
Indicates whether the value reported in the row is calculated, or uniquely reported within the table.
Sources and uses of energy in MWh.
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.