Utility Characteristics

EIA-861 utility data: each utility's ownership type, NERC regions, RTO participation and lines of business.

EIAInfrastructure data

Download data

Native record

event_time x utility_number x state x duplicate_index

annual (report year) publication cadence

Evidence

Observed market data

Published observations from the named source

Time basis

Point-in-time records

UTC · event_time

Overview

Utility_Data, one row per utility and state. The region, RTO and activity columns hold EIA's Y/N flags as published. event_time is 1 January of the report year. release is final or early_release: EIA posts an early release of a year in August and replaces it with the final file in the autumn, and the mirror keeps the newest row per key. A key cell EIA leaves blank is '' or 0, and duplicate_index numbers rows that still share a key, in workbook order.

Query contract

Preserve one canonical row per (event_time, utility_number, state, duplicate_index) before aggregating.

Analysis rules

Group only after preserving the declared grain: event_time, utility_number, state, duplicate_index.

Schema36

Column

Type

event_timeDateTime64(6, 'UTC')

utility_numberInt64

utility_nameLowCardinality(Nullable(String))

stateLowCardinality(String)

ownership_typeLowCardinality(Nullable(String))

nerc_regionLowCardinality(Nullable(String))

also_operating_in_other_nerc_regions_treLowCardinality(Nullable(String))

also_operating_in_other_nerc_regions_frccLowCardinality(Nullable(String))

also_operating_in_other_nerc_regions_mroLowCardinality(Nullable(String))

also_operating_in_other_nerc_regions_npccLowCardinality(Nullable(String))

also_operating_in_other_nerc_regions_rfcLowCardinality(Nullable(String))

also_operating_in_other_nerc_regions_sercLowCardinality(Nullable(String))

also_operating_in_other_nerc_regions_sppLowCardinality(Nullable(String))

also_operating_in_other_nerc_regions_weccLowCardinality(Nullable(String))

operating_in_these_rtos_caisoLowCardinality(Nullable(String))

operating_in_these_rtos_ercotLowCardinality(Nullable(String))

operating_in_these_rtos_pjmLowCardinality(Nullable(String))

operating_in_these_rtos_nyisoLowCardinality(Nullable(String))

operating_in_these_rtos_sppLowCardinality(Nullable(String))

operating_in_these_rtos_misoLowCardinality(Nullable(String))

operating_in_these_rtos_isoneLowCardinality(Nullable(String))

operating_in_these_rtos_otherLowCardinality(Nullable(String))

other_activities_generationLowCardinality(Nullable(String))

other_activities_transmissionLowCardinality(Nullable(String))

other_activities_buying_transmissionLowCardinality(Nullable(String))

other_activities_distributionLowCardinality(Nullable(String))

other_activities_buying_distributionLowCardinality(Nullable(String))

other_activities_wholesale_marketingLowCardinality(Nullable(String))

other_activities_retail_marketingLowCardinality(Nullable(String))

other_activities_bundledLowCardinality(Nullable(String))

other_activities_alt_fuel_vehicleLowCardinality(Nullable(String))

other_activities_alt_fuel_vehicle_2LowCardinality(Nullable(String))

short_formLowCardinality(Nullable(String))

duplicate_indexInt64

releaseLowCardinality(Nullable(String))

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	utility_number	utility_name	state	ownership_type	nerc_region	also_operating_in_other_nerc_regions_tre	also_operating_in_other_nerc_regions_frcc	also_operating_in_other_nerc_regions_mro	also_operating_in_other_nerc_regions_npcc	also_operating_in_other_nerc_regions_rfc	also_operating_in_other_nerc_regions_serc	also_operating_in_other_nerc_regions_spp	also_operating_in_other_nerc_regions_wecc	operating_in_these_rtos_caiso	operating_in_these_rtos_ercot	operating_in_these_rtos_pjm	operating_in_these_rtos_nyiso	operating_in_these_rtos_spp	operating_in_these_rtos_miso	operating_in_these_rtos_isone	operating_in_these_rtos_other	other_activities_generation	other_activities_transmission	other_activities_buying_transmission	other_activities_distribution	other_activities_buying_distribution	other_activities_wholesale_marketing	other_activities_retail_marketing	other_activities_bundled	other_activities_alt_fuel_vehicle	other_activities_alt_fuel_vehicle_2	short_form	duplicate_index	release	ingested_at
2025-01-01 00:00:00.000000	88888	Withheld	TX	Retail Power Marketer	TRE	Y	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	∅	N	∅	∅	∅	∅	N	Y	∅	∅	∅	∅	2	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	88888	Withheld	TX	Retail Power Marketer	∅	N	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	1	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	88888	Withheld	TX	Retail Power Marketer	TRE	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	Y	∅	∅	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67807	Energy Prepay VIII, LLC	NY	Wholesale Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	Y	∅	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67806	Energy Prepay VI, LLC	NY	Wholesale Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	Y	∅	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67805	Energy Prepay IV, LLC	NY	Wholesale Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	Y	∅	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67804	Energy Prepay III, LLC	NY	Wholesale Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	Y	∅	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67803	Energy Prepay I, LLC	NY	Wholesale Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	Y	∅	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67788	Pacific Summit Energy LLC	CA	Wholesale Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	Y	Y	Y	∅	∅	Y	∅	∅	∅	∅	∅	∅	Y	∅	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67693	Abundance Energy, LLC	TX	Retail Power Marketer	∅	Y	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67636	Trinita Power, Inc	TX	Retail Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67635	Alchemy Muse, Inc	TX	Retail Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67589	Great American Gas & Electric, LLC	NY	Retail Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	Y	∅	∅	Y	∅	∅	∅	∅	∅	∅	Y	Y	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67360	Green USA, LLC	FL	Retail Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67251	GridLiance Heartland LLC	FL	Transmission	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	Y	∅	∅	∅	∅	∅	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67188	Digital Power USA, Inc.	NY	Retail Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	Y	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67122	Selfserve Energy Corp.	TX	Retail Power Marketer	∅	Y	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67114	DRW Energy Trading	IL	Wholesale Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	Y	∅	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67113	Morongo Transmission LLC	CA	Transmission	∅	∅	∅	∅	∅	∅	∅	∅	Y	Y	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67112	Keystone Appalachian Transmission Company	OH	Transmission	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67099	Energy Prepay II, LLC	NY	Wholesale Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	Y	∅	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67076	FlowX, LLC	TX	Retail Power Marketer	∅	Y	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	67055	Mitsui & Co. Energy Marketing and Services	TX	Wholesale Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	Y	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	66923	DCR Transmission, LLC	CT	Transmission	∅	∅	∅	∅	∅	∅	∅	∅	Y	Y	∅	∅	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375
2025-01-01 00:00:00.000000	66909	AEP Ohio Transmission Company, Inc.	OH	Transmission	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	∅	Y	∅	∅	∅	∅	∅	∅	N	∅	∅	0	early_release	2026-09-29 00:39:36.350375

Coverage

0.3% complete4,736 gap days14 days with data

Show coverage history

Coverage: 0.3%Days with data: 14Gaps: 4,736

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

gaplessmore

Related infrastructure data

Related infrastructure data
Dataset	Description
Advanced MetersEIA · annual (report year)	EIA-861 advanced metering: AMR, AMI and other meter counts, AMI energy served and customer access, by utility and customer class. Advanced_Meters, one row per utility, state, balancing authority and customer class. customer_class is residential, commercial, industrial, transportation (direct_connected in the distributed generation tables) or EIA's own total, so summing classes without excluding total counts everything twice. event_time is 1 January of the report year. release is final or early_release: EIA posts an early release of a year in August and replaces it with the final file in the autumn, and the mirror keeps the newest row per key. A key cell EIA leaves blank is '' or 0, and duplicate_index numbers rows that still share a key, in workbook order.
Distribution SystemsEIA · annual (report year)	EIA-861 distribution systems: distribution circuit counts and circuits with voltage optimization, by utility. Distribution_Systems, 2013 on. event_time is 1 January of the report year. release is final or early_release: EIA posts an early release of a year in August and replaces it with the final file in the autumn, and the mirror keeps the newest row per key. A key cell EIA leaves blank is '' or 0, and duplicate_index numbers rows that still share a key, in workbook order.
Operating GeneratorsEIA · monthly + annual (snapshot)	A generator-level inventory of every operable utility-scale electric generator in the United States, drawn from EIA Form 860. Each record describes one generating unit, including its nameplate capacity, technology and prime mover, primary energy source, operating status, owner or operator, balancing authority, and the latitude and longitude of its plant. It is the standard reference for understanding what physical generation exists on the grid, where it sits, and how it is fueled. Annual final filings give the authoritative year-end picture, while the monthly EIA-860M updates track newly proposed, added, and retired units between annual releases, making it useful for tracking the fleet's evolving capacity mix and the buildout of new resources.
Solar GeneratorsEIA · monthly + annual (snapshot)	This is the utility-scale solar slice of the EIA-860 generator inventory, listing every operating solar generating unit along with its plant, location, owner, nameplate and net capacity, and in-service dates. It adds solar-specific attributes such as panel tracking type (fixed, single-axis, or dual-axis) and tilt angle. Researchers and analysts can use it to map where solar capacity sits on the grid, gauge how design choices shape generation profiles, and track the buildout of utility-scale solar over time. The source is the EIA-860 annual survey, with the inventory refreshed monthly between full annual snapshots.