core_ferc1__yearly_plant_in_service_sched204
Annual time series of utilities' balances and changes to FERC Electric Plant in Service accounts.
- 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 204)
- Primary key:
utility_id_ferc1, report_year, ferc_account_label
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
Account numbers correspond to the FERC Uniform System of Accounts for Electric Plant, which is defined in Code of Federal Regulations (CFR) Title 18, Chapter I, Subchapter C, Part 101. (See e.g. https://www.law.cornell.edu/cfr/text/18/part-101). Each FERC respondent reports starting and ending balances for each account annually. Balances are organization wide, and are not broken down on a per-plant basis. End of year balance should equal beginning year balance plus the sum of additions, retirements, adjustments, and transfers.
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.
Long FERC account identifier derived from values reported in the XBRL taxonomies. May also refer to aggregations of individual FERC accounts.
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting.
Indicates whether the value reported in the row is calculated, or uniquely reported within the table.
Account balance at beginning of year.
Cost of acquisition of items classified within the account.
Cost of disposal of items classified within the account.
Cost of adjustments to the account.
Cost of transfers into (out of) the account.
Account balance at end of year.
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.
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.
Utility plant financial status (in service, future, leased, total).