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 aTier A: annual electric utility census.
overview
overview
7,388 utilities, deduped to most recent year per utility_id.
current vintage — 2023
provenance
source & licensing
authority
U.S. Energy Information Administration
dataset
EIA Form 860
license
Public domain (U.S. Federal Government work)
citation
U.S. Energy Information Administration, Form EIA-860, 2023.
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 utility identifier string, assigned on EIA Form 860. Primary key; one row per utility, deduplicated to the most recently reported year.Part of primary key. Joins dim.utilities on utility_id. |
| utility_name | string | Name of the electric utility as reported on EIA Form 860. |
relationships
joins
primary key
utility_id
common joins
not provided
usage
how to use this table
method
Deduped EIA-860 to latest year per utility_id; state_id from most-recent plant.
do not use for
Precise service territory (state_id = most-recent plant only).
last updated · Jul 7, 2026