The plant_index table contains one row per plant with flat, searchable columns. This powers the search page, explore page, and all list views. It corresponds to the PlantIndex TypeScript interface.
Identification
plant_idnumbervia EIA-860M
Unique EIA plant identifier. Primary key. Stable across monthly refreshes.
plant_namestringvia EIA-860M
Official plant name from EIA. May differ from the name used by the owner or in permits.
wikidata_qidstring?via Wikidata
Wikidata entity QID (e.g., Q12345) if a match was found for this plant.
Location
statestring?via EIA-860M
Two-letter US state code (e.g., "CA", "TX").
countystring?via EIA-860M
County name within the state.
latnumber?via EIA-860M
Latitude in decimal degrees (WGS84).
lonnumber?via EIA-860M
Longitude in decimal degrees (WGS84).
Fuel and technology
primary_fuelstring?via EIA-860M
EIA fuel code for the dominant fuel type (e.g., "SUN", "WND", "NG", "NUC"). Determined by the fuel with the most nameplate capacity.
fuel_typesstring[]via EIA-860M
Array of all unique EIA fuel codes across the plant's generators.
technologiesstring[]via EIA-860M
Array of all unique technology descriptions (e.g., "Photovoltaic", "Onshore Wind Turbine").
is_hybridbooleanvia Derived
True if the plant has generators with more than one fuel type.
Capacity and generators
total_capacity_mwnumber?via EIA-860M
Sum of nameplate capacity (MW) across all generators at this plant.
n_generatorsnumbervia EIA-860M
Count of generators at this plant.
Ownership
utility_eia_namestring?via EIA-860M
Name of the EIA-registered utility operating this plant.
gem_parent_namestring?via GEM
Ultimate parent company name from the Global Energy Monitor tracker. Often reveals the real owner behind SPV structures.
When
utility_eia_name and gem_parent_name differ, the EIA name is often an SPV shell company. See the Known Gaps page for details on SPV name masking.Status and timing
operating_yearnumber?via EIA-860M
Year the plant (or its earliest generator) began operating.
statusstring?via EIA-860M
Aggregated plant status. Values include "Operating", "Planned", "Retired", and others derived from EIA status codes.
Rankings
rank_statenumber?via Derived
Capacity rank within the plant's state (1 = largest).
rank_nationalnumber?via Derived
Capacity rank nationally across all plants (1 = largest).
total_in_statenumber?via Derived
Total number of plants in the same state (denominator for state rank).
total_in_nationnumber?via Derived
Total number of plants nationally (denominator for national rank).