out_eia__yearly_assn_plant_parts_plant_gen

package: pudl
Log in or sign up to preview / export as CSV Download full table as Parquet

Annual 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
record_id_eia

Identifier for EIA plant parts analysis records.

record_id_eia_plant_gen

Identifier for EIA plant parts analysis records which is at the plant_part level of plant_gen - meaning each record pertains to one generator.

report_date

Date reported.

plant_id_eia

The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration.

utility_id_eia

The EIA Utility Identification number.

ownership_record_type

Whether each generator record is for one owner or represents a total of all ownerships.

generator_id_plant_gen

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!

energy_source_code_1_plant_gen

Code representing the most predominant type of energy that fuels the record_id_eia_plant_gen's generator.

prime_mover_code_plant_gen

Code for the type of prime mover (e.g. CT, CG) associated with the record_id_eia_plant_gen.

unit_id_pudl_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.

technology_description_plant_gen

High level description of the technology used by the record_id_eia_plant_gen's generator to produce electricity.

ferc_acct_name_plant_gen

Name of FERC account, derived from technology description and prime mover code. This name is associated with the record_id_eia_plant_gen record.

ferc1_generator_agg_id_plant_gen

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.

generator_operating_year_plant_gen

The year an associated plant_gen's generator went into service.

operational_status_pudl_plant_gen

The operating status of the asset using PUDL categories of the record_id_eia_plant_gen record .

generators_number

The number of generators associated with each record_id_eia.