out_ferc1__yearly_small_plants_sched410
Return to SearchAnnual time series of plant statistics for internal combustion plants, gas turbine-plants, conventional hydro plants, and pumped storage plants with less than 10 MW installed nameplate capacity and steam plants with less than 25 MW installed nameplate capacity.
- 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 410)
- 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 on FERC Form 1 Schedule 410 (pages 410-411) and extracted from the FERC Visual FoxPro and XBRL. See our pudl.extract.ferc1.TABLE_NAME_MAP_FERC1 for links to the raw tables.
The raw version of this table is more like a digitized PDF than an actual data table. The rows contain lots of information in addition to what the columns might suggest. For instance, a single column may contain header rows, note rows, and total rows. This extraneous information is useful, but it prevents proper analysis when mixed in with the rest of the values data in the column. We employ a couple of data transformations to extract these rows from the data and preserve some of the information they contain (fuel type, plant type, FERC license, or general notes about the plant) in separate columns.
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.
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.
Total installed (nameplate) capacity, in megawatts.
Cost of plant per megawatt of installed (nameplate) capacity. Nominal USD.
Total cost of plant (USD).
Year the plant's oldest still operational unit was built.
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.
Net electricity generation for the specified period in megawatt-hours (MWh).
Production expenses: fuel (USD).
Production expenses: Maintenance (USD).
Production expenses: operations, supervision, and engineering (USD).
Total production expenses, excluding fuel (USD).
Total production expenses, excluding fuel (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.
Type of plant.