energy_generation_state
Plant-level electricity generation and fuel consumption from EIA Form 923, at state grain. One row per plant × prime_mover × fuel_type × year (2013–2026). EIA-923 does not carry county; join to energy_generators_county on plant_code to get county-level generation.
tier aadmin_record
overview
overview
186,152 plant-prime-fuel-year rows. State-grain because EIA-923 does not carry county directly.
current vintage — 2024 final + 2025 monthly + 2026 partial
history — EIA-923: 2008-present in source
provenance
source & licensing
authority
U.S. Energy Information Administration
dataset
EIA Form 923 — Power Plant Operations Report (2013–2026)
license
Public domain (U.S. Federal Government work)
citation
U.S. Energy Information Administration. Form EIA-923 - state-grain generation, 2013-2026.
schema
fields
| name | type | definition |
|---|---|---|
| balancing_authority_code | string | EIA balancing authority code for the grid region. |
| country_idkey | string | ISO 3166 alpha-2 country code. Always "US". |
| elec_fuel_mmbtu | float64 | Fuel consumed for electricity generation only (MBtu), excluding heat. |
| fuel_type | string | Reported fuel type code (AER fuel type classification). |
| naics_code | string | NAICS industry classification code for the operator. |
| net_generation_mwh | float64 | Annual net electricity generation in megawatt-hours. |
| operator_id | string | EIA operator identifier. |
| operator_name | string | Name of the plant operator. |
| plant_code | int64 | EIA plant identifier matching energy_generators_county.plant_code. |
| plant_name | string | Name of the power plant as reported by EIA. |
| prime_mover | string | Prime mover code (e.g., ST, GT, PV, WT). |
| sector_name | string | Utility sector classification. |
| state | string | Two-letter state abbreviation. |
| state_idkey | string | 2-character state FIPS code. |
| total_fuel_mmbtu | float64 | Total fuel consumed in million British thermal units. |
| total_fuel_quantity | float64 | Physical quantity of fuel consumed in original units (tons, Mcf, barrels). |
| year | int64 | Calendar year of the generation data. |
relationships
joins
primary key
state_id, country_id
common joins
energy_generators_county on plant_code
energy_scorecard_county_year on (plant_code -> county_id, year)
usage
how to use this table
method
Plant-level EIA-923 generation aggregated to plant x prime_mover x fuel x year. State assignment from plant location field.
do not use for
County-direct queries (join to energy_generators_county on plant_code); end-use sectoral consumption.
known issues
Same EIA-923 caveats. State grain limits county-level analysis.
last updated · Jul 7, 2026