core_ferc1__yearly_cash_flows_sched120
Return to SearchAnnual time series of utility cash flow.
- 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 120)
- Primary key:
utility_id_ferc1, report_year, amount_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.
Four-digit year in which the data was reported.
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.
Label describing the type of amount being reported. This could be a balance or a change in value.
Reported amount of dollars. This could be a balance or a change in value.
Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy.
Indicates whether the value reported in the row is calculated, or uniquely reported within the table.