core_ferc1__yearly_steam_plants_fuel_sched402

package: pudl

Annual time series of fuel cost and quantity for steam plants with a capacity of 25+ MW, internal combustion and gas-turbine plants of 10+ MW, and all nuclear plants.

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 402)

Primary key:

This table has no primary key.

Usage Warnings

  • The fuel_type_code_pudl is inferred from a free-form string field.

  • 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 is a subset of the steam plant table reported on page 402 of FERC Form 1.

Columns
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.

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.

report_year

Four-digit year in which the data was reported.

plant_name_ferc1

Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant.

fuel_type_code_pudl

Simplified fuel type code used in PUDL

fuel_units

Reported unit of measure for fuel.

fuel_consumed_units

Consumption of the fuel type in physical unit. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production.

fuel_mmbtu_per_unit

Heat content of the fuel in millions of Btus per physical unit.

fuel_cost_per_unit_burned

Average cost of fuel consumed in the report year per reported fuel unit (USD).

fuel_cost_per_unit_delivered

Average cost of fuel delivered in the report year per reported fuel unit (USD).

fuel_cost_per_mmbtu

Average fuel cost per MMBTU of heat content in nominal USD.