core_ferc1__yearly_income_statements_sched114
Return to SearchAnnual time series of utility income statements.
- 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:
FERC Form 1 -- Annual Report of Major Electric Utilities (Schedule 114)
- Primary key:
utility_id_ferc1, report_year, utility_type, income_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.
Columns
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.
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.
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.
Type of income reported in core_ferc1__yearly_income_statements_sched114 table.
Dollar value of reported income, expense, asset, or liability.
Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy.
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.