out_ferc1__yearly_pumped_storage_plants_sched408
Return to SearchAnnual time series of plant statistics for hydroelectric pumped storage plants with an installed nameplate capacity of 10+ MW.
- Most-recent data:
2024
- 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 408)
- 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.
Additional Details
As reported in Schedule 408 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.
Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same 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.
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.
Cost of plant: accessory electric equipment (USD).
Cost of plant: miscellaneous power plant equipment (USD).
Cost of plant: reservoirs, dams, and waterways (USD).
Cost of plant: land and land rights (USD).
Cost of plant per megawatt of installed (nameplate) capacity. Nominal USD.
Cost of plant: roads, railroads, and bridges (USD).
Cost of plant: structures and improvements (USD).
Total cost of plant (USD).
Cost of plant: water wheels, turbines, and generators (USD).
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.
Energy used for pumping, in megawatt-hours.
Year the plant's most recently built unit was installed.
Net electricity generation for the specified period in megawatt-hours (MWh).
Net output for load (net generation - energy used for pumping) in megawatt-hours.
Production expenses: maintenance of reservoirs, dams, and waterways (USD).
Production expenses: electric expenses (USD).
Production expenses: maintenance, supervision, and engineering (USD).
Production expenses: miscellaneous power generation expenses (USD).
Production expenses: maintenance of miscellaneous hydraulic plant (USD).
Production expenses: operations, supervision, and engineering (USD).
Total production expenses (USD per MWh generated).
Production expenses: maintenance of electric plant (USD).
Total production expenses before pumping (USD).
Production expenses: pumped storage (USD).
Production expenses: We are here to PUMP YOU UP! (USD).
Production expenses: rents (USD).
Production expenses: maintenance of structures (USD).
Total production expenses, excluding fuel (USD).
Total production expenses, excluding fuel (USD).
Production expenses: water for power (USD).
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.
A manually assigned PUDL plant ID. May not be constant over time.
FERC Licensed Project Number.