out_ferc1__yearly_operating_expenses_sched320

package: pudl

Annual time series of operating and maintenance costs associated with producing electricity.

Most-recent data:

2025

Processing:

Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.

Source:

FERC Form 1 -- Annual Report of Major Electric Utilities (Schedule 320)

Primary key:

utility_id_ferc1, report_year, expense_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
report_year

Four-digit year in which the data was reported.

utility_id_ferc1

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.

utility_id_ferc1_dbf

FERC-assigned respondent_id from DBF reporting years, identifying the reporting entity. Stable from year to year.

utility_id_ferc1_xbrl

FERC-assigned entity_id from XBRL reporting years, identifying the reporting entity. Stable from year to year.

utility_id_pudl

A manually assigned PUDL utility ID. May not be stable over time.

utility_name_ferc1

Name of the responding utility, as it is reported in FERC Form 1. For human readability only.

dollar_value

Dollar value of reported income, expense, asset, or liability.

expense_type

The type of expense.

utility_type

Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.

record_id

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.

ferc_account

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.

row_type_xbrl

Indicates whether the value reported in the row is calculated, or uniquely reported within the table.