Utility Frame

EIA-861 frame: every respondent and which schedules it filed, 2016 on.

EIAInfrastructure data

Download data

Native record

event_time x utility_number 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

Frame, one row per respondent. The schedule columns hold EIA's X marks. 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, duplicate_index) before aggregating.

Analysis rules

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

Schema24

Column

Type

event_timeDateTime64(6, 'UTC')

utility_numberInt64

utility_nameLowCardinality(Nullable(String))

short_formLowCardinality(Nullable(String))

ownership_codeLowCardinality(Nullable(String))

ownershipLowCardinality(Nullable(String))

monthlyLowCardinality(Nullable(String))

advanced_meteringLowCardinality(Nullable(String))

delivery_companyLowCardinality(Nullable(String))

demand_responseLowCardinality(Nullable(String))

distribution_systemsLowCardinality(Nullable(String))

dynamic_pricingLowCardinality(Nullable(String))

energy_efficiencyLowCardinality(Nullable(String))

mergersLowCardinality(Nullable(String))

net_meteringLowCardinality(Nullable(String))

non_net_metering_distributedLowCardinality(Nullable(String))

operational_dataLowCardinality(Nullable(String))

reliabilityLowCardinality(Nullable(String))

sales_to_ultimate_customersLowCardinality(Nullable(String))

service_territoryLowCardinality(Nullable(String))

utility_dataLowCardinality(Nullable(String))

duplicate_indexInt64

releaseLowCardinality(Nullable(String))

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	utility_number	utility_name	short_form	ownership_code	ownership	monthly	advanced_metering	delivery_company	demand_response	distribution_systems	dynamic_pricing	energy_efficiency	mergers	net_metering	non_net_metering_distributed	operational_data	reliability	sales_to_ultimate_customers	service_territory	utility_data	release	ingested_at
2025-01-01 00:00:00.000000	67840	GridLiance West LLC	∅	T	Transmission	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	∅	∅	∅	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67807	Energy Prepay VIII, LLC	∅	W	Wholesale Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	∅	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67806	Energy Prepay VI, LLC	∅	W	Wholesale Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	∅	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67805	Energy Prepay IV, LLC	∅	W	Wholesale Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	∅	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67804	Energy Prepay III, LLC	∅	W	Wholesale Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	∅	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67803	Energy Prepay I, LLC	∅	W	Wholesale Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	∅	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67788	Pacific Summit Energy LLC	∅	W	Wholesale Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	∅	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67751	Maven Energy, LLC	∅	R	Retail Power Marketer	X	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	X	∅	∅	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67693	Abundance Energy, LLC	∅	R	Retail Power Marketer	X	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	X	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67636	Trinita Power, Inc	∅	R	Retail Power Marketer	X	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	X	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67635	Alchemy Muse, Inc	∅	R	Retail Power Marketer	X	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	X	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67589	Great American Gas & Electric, LLC	∅	R	Retail Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	X	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67360	Green USA, LLC	∅	R	Retail Power Marketer	X	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	X	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67251	GridLiance Heartland LLC	∅	T	Transmission	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	∅	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67240	Hampshire Power Corporation	∅	R	Retail Power Marketer	X	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	X	∅	∅	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67188	Digital Power USA, Inc.	∅	R	Retail Power Marketer	X	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	X	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67122	Selfserve Energy Corp.	∅	R	Retail Power Marketer	X	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	X	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67114	DRW Energy Trading	∅	W	Wholesale Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	∅	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67113	Morongo Transmission LLC	∅	T	Transmission	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	∅	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67112	Keystone Appalachian Transmission Company	∅	T	Transmission	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	∅	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67099	Energy Prepay II, LLC	∅	W	Wholesale Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	∅	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67076	FlowX, LLC	∅	R	Retail Power Marketer	X	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	X	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	67055	Mitsui & Co. Energy Marketing and Services	∅	W	Wholesale Power Marketer	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	∅	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	66923	DCR Transmission, LLC	∅	T	Transmission	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	∅	∅	X	early_release	2026-09-29 00:39:33.676779
2025-01-01 00:00:00.000000	66909	AEP Ohio Transmission Company, Inc.	∅	T	Transmission	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	X	∅	∅	∅	X	early_release	2026-09-29 00:39:33.676779

Coverage

0.3% complete3,279 gap days10 days with data

Show coverage history

Coverage: 0.3%Days with data: 10Gaps: 3,279

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

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.