out_eia__yearly_utilities
Annual time series of all EIA utility attributes.
- Most-recent data:
2026
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
EIA -- Mix of multiple EIA Forms
- 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 table inherits canonicalized values for utilities. 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.
Columns
The EIA Utility Identification number.
A manually assigned PUDL utility ID. May not be stable over time.
The name of the utility.
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.
out_eia861__yearly_utility_service_territory
Annual time series of counties in utility service territories.
- Most-recent data:
2024
- Processing:
Data is ready for use in analyses, but for practical reasons has not been denormalized and remains in narrow format.
- Source:
EIA Form 861 -- Annual Electric Power Industry Report
- Primary key:
utility_id_eia, report_date, county_id_fips
Additional Details
Contains additional information about counties.
Columns
County ID from the Federal Information Processing Standard Publication 6-4.
County name as specified in Census DP1 Data.
County population, sourced from Census DP1 data.
County area in km2.
Date reported.
The EIA Utility Identification number.
Two letter US state abbreviation.
County name.
Two digit state FIPS code.