out_ferc1__yearly_steam_plants_sched402
Annual time series of plant statistics 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 The best approximation for primary keys for this table would be: report_year, utility_id_ferc1, plant_name_ferc1. FERC does not publish plant IDs. The main identifying column is plant_name_ferc1 but that is a free-form string field and there are duplicate records.
Usage Warnings
FERC does not restrict respondents to report unique and non-duplicative plant records. There are sporadic instances of respondents reporting portions of plants and then the total plant (ex: unit 1, unit 2 and total). Use caution when aggregating.
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.
Algorithmically assigned PUDL FERC Plant ID. WARNING: NOT STABLE BETWEEN PUDL DB INITIALIZATIONS.
Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant.
Asset retirement cost (USD).
The average number of employees assigned to each plant.
Fraction of potential generation that was actually reported for a plant part. Energy generated over time period / nameplate capacity * time period (hours/years/etc.).
Total installed (nameplate) capacity, in megawatts.
Annual capital addition into capex_total.
Year-to-date capital addition into capex_total.
Annual capital addition into capex_total per kw.
Annual capital addition into capex_total per MW.
Year-to-date capital addition into capex_total per MW.
Annual capital addition into capex_total per MWh.
Year-to-date capital addition into capex_total per MWh.
Cost of plant: equipment (USD).
Cost of plant: land and land rights (USD).
Cost of plant per megawatt of installed (nameplate) capacity. Nominal USD.
Cost of plant: structures and improvements (USD).
Total cost of plant (USD).
Total cost of plant (USD) without retirements.
Type of plant construction ('outdoor', 'semioutdoor', or 'conventional'). Categorized by PUDL based on our best guess of intended value in FERC1 freeform strings.
Year the plant's oldest still operational unit was built.
Year the plant's most recently built unit was installed.
Net electricity generation for the specified period in megawatt-hours (MWh).
Plant capacity in MW when not limited by condenser water.
Allowances.
Maintenance of boiler (or reactor) plant.
Cost of coolants and water (nuclear plants only)
Production expenses: electric expenses (USD).
Production expenses: maintenance, supervision, and engineering (USD).
Production expenses: fuel (USD).
Production expenses: fuel (USD) per megawatt-hour (Mwh).
Miscellaneous steam (or nuclear) expenses.
Maintenance of miscellaneous steam (or nuclear) plant.
Investments in non-fuel production expenses per Mwh.
Production expenses: operations, supervision, and engineering (USD).
Total production expenses (USD per MWh generated).
Maintenance of electrical plant.
Total operating expenses.
Production expenses: rents (USD).
Steam expenses.
Steam from other sources.
Production expenses: maintenance of structures (USD).
Total production expenses, excluding fuel (USD).
Steam transferred (Credit).
Net peak demand for 60 minutes. Note: in some cases peak demand for other time periods may have been reported instead, if hourly peak demand was unavailable.
Net plant capability in megawatts.
Hours the plant was connected to load while generating in the report year.
Type of plant.
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.
Plant capacity in MW when limited by condenser water.
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).