docs/dimension/utilities

utilities

Canonical EIA electric utility dimension. One row per utility (deduplicated to the most recent year per utility_id). Primary key is utility_id. Source is EIA Form 860. State_id reflects the state of the most-recently-reported plant for that utility.

tier aadmin_record

grain

utility

years

—

cadence

Annual

overview

~3,000 electric utilities operating in the US as of the most recent EIA Form 860 filing.

current vintage — Most recent EIA Form 860 year per utility

history — Historical utility-plant relationships in energy_generators_county; this table is a snapshot of the latest year per utility

provenance

source & licensing

authority

U.S. Energy Information Administration

dataset

EIA Form 860 — Annual Electric Generator Report

source url

https://www.eia.gov/electricity/data/eia860/

methodology

https://www.eia.gov/survey/form/eia_860/instructions.pdf

license

Public domain (U.S. Federal Government work)

citation

U.S. Energy Information Administration, Form EIA-860, Annual Electric Generator Report.

schema

fields

name	type	definition
country_id	string	ISO alpha-2 country code (always 'US' for domestic tables).
state_id	string	2-character FIPS code identifying the state.Joins dim.states on state_id.
utility_idkey	string	EIA-assigned identifier string for an electric utility, as reported on EIA Form 860. Serves as the primary key for this dimension table.Joins dim.utilities on utility_id.
utility_name	string	Legal or trade name of the electric utility as self-reported on EIA Form 860.

relationships

joins

primary key

utility_id

common joins

dim.plants on utility_id

energy_generators_county on utility_id

usage

how to use this table

do not use for

Multi-state utility geographic analysis; state_id reflects only the state of the most-recently-reported plant

← previousdimension.states next →us_demographics.demographics_age_sex_race_county_year

last updated · May 5, 2026