core_eia860__scd_utilities
Return to SearchSlowly changing dimension (SCD) table describing attributes of utilities which may vary from year to year. Compiled from all EIA data.
- Most-recent data:
2026
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
EIA Form 860 -- Annual Electric Generator Report
- Primary key:
utility_id_eia, report_date
Usage Warnings
Data has been drawn from several EIA sources which are not always consistent with each other, and PUDL chooses the most consistent or relevant value to facilitate cross-referencing even if that means some values will differ from the raw sources. See Harvesting for details, and see Entity Resolution Methodology for a fuller conceptual overview.
Contains information from multiple raw inputs.
Additional Details
This is one of two tables where canonical values for utilities are set. It contains values which are expected to vary slowly, while core_eia__entity_utilities contains those expected to remain fixed. EIA reports many attributes in many different tables across EIA-860 and EIA-923. In order to compile tidy, well-normalized database tables, PUDL collects all instances of these values and and chooses a canonical value. By default, PUDL chooses the most consistently reported value of a given attribute as long as it is at least 70% of the given instances reported. If an attribute was reported inconsistently across the original EIA tables, then it will show up as a null value. See /methodology/entity_resolution for a conceptual overview of this process. All tables downstream of this one inherit the canonical values established here.
Columns
The EIA Utility Identification number.
Date reported.
Physical street address.
Name of the city.
Two letter US state abbreviation.
Five digit US Zip Code.
Is the reporting entity an owner of power plants reported on Schedule 2 of the form?
Is the reporting entity an operator of power plants reported on Schedule 2 of the form?
Is the reporting entity an asset manager of power plants reported on Schedule 2 of the form?
Does the reporting entity have any other relationship to the power plants reported on Schedule 2 of the form?
Entity type of principal owner.
Mail attention name of the operator/owner.
Second line of the address.
Four digit US Zip Code suffix.
First name of utility contact 1.
Last name of utility contact 1.
Title of of utility contact 1.
Phone number for utility contact 1.
Phone extension for utility contact 1
First name of utility contact 2.
Last name of utility contact 2.
Title of utility contact 2.
Phone number for utility contact 2.
Phone extension for utility contact 2
Maturity of the source data published by EIA that is reflected in this record. EIA releases data incrementally over time, including monthly updates, annual year-to-date updates, provisional early releases of annual data, and final annual release data that is not expected to change further. Records sourced from multiple upstream EIA datasets may have no well defined data maturity. Records whose values have been inferred within PUDL will also have no data maturity.