core_ferc1__yearly_operating_revenues_sched300
Return to SearchAnnual time series of utilities' electric operating revenues.
- 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 300)
- Primary key:
utility_id_ferc1, report_year, revenue_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
This table includes only the structured part of schedule 300. There are a number of revenue_type's that do not have sales_mwh,or avg_customers_per_month provided, in which case these columnswill be NULL.
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.
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.
Label describing types of revenues.
Dollar value of reported income, expense, asset, or liability.
Quantity of electricity sold in MWh.
Average number of customers per month.
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.
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.
Indicates whether the value reported in the row is calculated, or uniquely reported within the table.