out_ferc1__yearly_steam_plants_fuel_sched402
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 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 402)
- Primary key:
record_id
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
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.
FERC-assigned respondent_id from DBF reporting years, identifying the reporting entity. Stable from year to year.
FERC-assigned entity_id from XBRL reporting years, identifying the reporting entity. Stable from year to year.
A manually assigned PUDL utility ID. May not be stable over time.
Name of the responding utility, as it is reported in FERC Form 1. For human readability only.
A manually assigned PUDL plant ID. May not be constant over time.
Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant.
Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production.
Total cost of consumed fuel.
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.
Average fuel cost per MMBTU of heat content in nominal USD.
Average cost of fuel consumed in the report year per reported fuel unit (USD).
Average cost of fuel delivered in the report year per reported fuel unit (USD).
Heat content of the fuel in millions of Btus per physical unit.
Simplified fuel type code used in PUDL
Reported unit of measure for fuel.
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.
out_ferc1__yearly_steam_plants_fuel_by_plant_sched402
Annual time series of FERC fuel data by plant.
- 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 402)
- Primary key:
report_year, utility_id_ferc1, plant_name_ferc1
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
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.
FERC-assigned respondent_id from DBF reporting years, identifying the reporting entity. Stable from year to year.
FERC-assigned entity_id from XBRL reporting years, identifying the reporting entity. Stable from year to year.
A manually assigned PUDL utility ID. May not be stable over time.
Name of the responding utility, as it is reported in FERC Form 1. For human readability only.
A manually assigned PUDL plant ID. May not be constant over time.
Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant.
Coal cost as a percentage of overall fuel cost.
Coal heat content as a percentage of overall fuel heat content (MMBTU).
Total fuel cost for plant (in $USD).
Total heat content for plant (in MMBTU).
Natural gas cost as a percentage of overall fuel cost.
Natural gas heat content as a percentage of overall fuel heat content (MMBTU).
Nuclear cost as a percentage of overall fuel cost.
Nuclear heat content as a percentage of overall fuel heat content (MMBTU).
Oil cost as a percentage of overall fuel cost.
Oil heat content as a percentage of overall fuel heat content (MMBTU).
Primary fuel for plant as a percentage of cost.
Primary fuel for plant as a percentage of heat content.
Waste-heat cost as a percentage of overall fuel cost.
Waste-heat heat content as a percentage of overall fuel heat content (MMBTU).