core_eia860__scd_utilities

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

Slowly 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
utility_id_eia

The EIA Utility Identification number.

report_date

Date reported.

street_address

Physical street address.

city

Name of the city.

state

Two letter US state abbreviation.

zip_code

Five digit US Zip Code.

plants_reported_owner

Is the reporting entity an owner of power plants reported on Schedule 2 of the form?

plants_reported_operator

Is the reporting entity an operator of power plants reported on Schedule 2 of the form?

plants_reported_asset_manager

Is the reporting entity an asset manager of power plants reported on Schedule 2 of the form?

plants_reported_other_relationship

Does the reporting entity have any other relationship to the power plants reported on Schedule 2 of the form?

entity_type

Entity type of principal owner.

attention_line

Mail attention name of the operator/owner.

address_2

Second line of the address.

zip_code_4

Four digit US Zip Code suffix.

contact_firstname

First name of utility contact 1.

contact_lastname

Last name of utility contact 1.

contact_title

Title of of utility contact 1.

phone_number

Phone number for utility contact 1.

phone_extension

Phone extension for utility contact 1

contact_firstname_2

First name of utility contact 2.

contact_lastname_2

Last name of utility contact 2.

contact_title_2

Title of utility contact 2.

phone_number_2

Phone number for utility contact 2.

phone_extension_2

Phone extension for utility contact 2

data_maturity

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.