plants
Canonical EIA power plant dimension. One row per plant (deduplicated to the most recent year per plant_code). Primary key is plant_code (EIA integer plant ID). Source is EIA Form 860. County_id may be null where county name matching failed.
tier aadmin_record
overview
overview
~10,000 utility-scale power plants in the US as of the most recent EIA Form 860 filing.
current vintage — Most recent EIA Form 860 year per plant
history — Historical plant attributes available in energy_generators_county; this table is a snapshot of the latest year per plant
provenance
source & licensing
authority
U.S. Energy Information Administration
dataset
EIA Form 860 — Annual Electric Generator Report
license
Public domain (U.S. Federal Government work)
citation
U.S. Energy Information Administration, Form EIA-860, Annual Electric Generator Report.
schema
fields
| name | type | definition |
|---|---|---|
| country_id | string | ISO alpha-2 country code (always 'US' for domestic tables). |
| county_id | string | 5-character FIPS code identifying the county.Joins dim.counties on county_id. |
| county_name | string | Human-readable county name corresponding to county_id. |
| plant_codekey | int64 | EIA-assigned integer identifier for a power plant. Primary key for this table.Joins dim.plants on plant_code. |
| plant_name | string | Name of the power plant as reported by the owner on EIA Form 860. |
| sector_name | string | EIA sector classification describing the plant's regulatory and ownership category (e.g. 'Electric utility', 'Independent power producer', 'Combined heat and power'). |
| state_abbr | string | Two-letter USPS postal abbreviation for the U.S. state in which the plant is located. |
| state_id | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| utility_id | string | EIA-assigned identifier for the utility that owns or operates the plant. Foreign key to dim.utilities.Joins dim.utilities on utility_id. |
| utility_name | string | Name of the utility that owns or operates the plant, as reported on EIA Form 860. |
relationships
joins
primary key
plant_code
common joins
energy_generators_county on plant_code
dim.utilities on utility_id
dim.counties on county_id
usage
how to use this table
do not use for
Capacity or generation data — use energy_generators_county or energy_generation_state for those
last updated · May 5, 2026