out_ferc1__yearly_all_plants
Annual time series of plants reported in the steam, small generators, hydro, and pumped storage tables.
- 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 (Schedules 402, 404, 406 and 408)
- Primary key:
record_id
Usage Warnings
Not all columns are originally reported in all of the input plant tables. Expect nulls.
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.
Additional Details
This table is a concatenation of the following plant tables:
core_ferc1__yearly_steam_plants_sched402
core_ferc1__yearly_hydroelectric_plants_sched406
core_ferc1__yearly_small_plants_sched410
core_ferc1__yearly_pumped_storage_plants_sched408
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).
Derived from MCOE, a unit level value. Average fuel cost per MWh of heat content in nominal USD.
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).
Production expenses: maintenance of electric plant (USD).
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.
Average fuel cost per MMBTU of heat content in nominal USD.
Type of fuel.
FERC issued operating license ID for the facility, if available. This value is extracted from the original plant name where possible.
Production expenses: Maintenance (USD).
Total production expenses, excluding fuel (USD).
Cost of plant: reservoirs, dams, and waterways (USD).
Cost of plant: roads, railroads, and bridges (USD).
Net plant capability under the least favorable operating conditions, in megawatts.
Net plant capability under the most favorable operating conditions, in megawatts.
Production expenses: maintenance of reservoirs, dams, and waterways (USD).
Production expenses: miscellaneous power generation expenses (USD).
Production expenses: hydraulic expenses (USD).
Production expenses: maintenance of miscellaneous hydraulic plant (USD).
Production expenses: water for power (USD).
The FERC license ID of a project.
Cost of plant: accessory electric equipment (USD).
Cost of plant: miscellaneous power plant equipment (USD).
Cost of plant: water wheels, turbines, and generators (USD).
Energy used for pumping, in megawatt-hours.
Net output for load (net generation - energy used for pumping) in megawatt-hours.
Total production expenses before pumping (USD).
Production expenses: pumped storage (USD).
Production expenses: We are here to PUMP YOU UP! (USD).