out_eia__yearly_assn_plant_parts_plant_gen
Return to SearchAnnual Association table providing connections between plant parts (identified as record_id_eia) and 'plant_gen' records (identified as record_id_eia_plant_gen) from the out_eia__yearly_plant_parts table.
- Most-recent data:
2026
- Processing:
Data is ready for use in analyses, but for practical reasons has not been denormalized and remains in narrow format.
- Source:
EIA -- Mix of multiple EIA Forms
- Primary key:
record_id_eia, record_id_eia_plant_gen
Usage Warnings
Some columns contain subtotals; use caution when choosing columns to aggregate.
Contains information from multiple raw inputs.
Additional Details
The purpose of this table is to help determine what generator records are associated with every plant part record. The plant part records have a one to many relationship to the associated 'plant_gen' records. The 'plant_gen' records are also included in the plant part records, so for these records there is a one to one relationship and the record_id_eia and the record_id_eia_plant_gen are the same.
All of the columns in this table that have a suffix of '_plant_gen' are attributes of the record_id_eia_plant_gen record.
Columns
Identifier for EIA plant parts analysis records.
Identifier for EIA plant parts analysis records which is at the plant_part level of plant_gen - meaning each record pertains to one generator.
Date reported.
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration.
The EIA Utility Identification number.
Whether each generator record is for one owner or represents a total of all ownerships.
Generator ID of the record_id_eia_plant_gen record. This is usually numeric, but sometimes includes letters. Make sure you treat it as a string!
Code representing the most predominant type of energy that fuels the record_id_eia_plant_gen's generator.
Code for the type of prime mover (e.g. CT, CG) associated with the record_id_eia_plant_gen.
Dynamically assigned PUDL unit id of the record_id_eia_plant_gen. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time.
High level description of the technology used by the record_id_eia_plant_gen's generator to produce electricity.
Name of FERC account, derived from technology description and prime mover code. This name is associated with the record_id_eia_plant_gen record.
ID dynamically assigned by PUDL to EIA records with multiple matches to a single FERC ID in the FERC-EIA manual matching process. This ID is associated with the record_id_eia_plant_gen record. It depends on ferc1_generator_agg_id, which has not been updated since 2020, but only affects a couple hundred records total across all years.
The year an associated plant_gen's generator went into service.
The operating status of the asset using PUDL categories of the record_id_eia_plant_gen record .
The number of generators associated with each record_id_eia.