Retail Sales, Customer-Sited Deliveries

EIA-861 customer-sited sales: electricity sold by third-party owners of on-site generation to the customers hosting it, by facility and customer class.

EIALoad data

Download data

Native record

event_time x facility_number x utility_number x state x ba_code x customer_class 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

Sales_Ult_Cust_CS. From 2013 one row per facility; the 2012 file lists sellers without facilities, so facility_number is 0 there. 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.

Query contract

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

Analysis rules

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

Schema18

Column

Type

event_timeDateTime64(6, 'UTC')

customer_classLowCardinality(String)

facility_numberInt64

facility_nameLowCardinality(Nullable(String))

utility_numberInt64

utility_nameLowCardinality(Nullable(String))

stateLowCardinality(String)

ba_codeLowCardinality(String)

revenues_thousand_dollarsNullable(Float64)

sales_mwhNullable(Float64)

customers_countNullable(Float64)

partLowCardinality(Nullable(String))

service_typeLowCardinality(Nullable(String))

data_typeLowCardinality(Nullable(String))

ownershipLowCardinality(Nullable(String))

duplicate_indexInt64

releaseLowCardinality(Nullable(String))

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	customer_class	facility_number	facility_name	utility_number	utility_name	state	ba_code	revenues_thousand_dollars	sales_mwh	customers_count	part	service_type	data_type	ownership	release	ingested_at
2025-01-01 00:00:00.000000	transportation	69519	Pilot Rock Solar 2	67502	Pilot Rock Solar 2 LLC	OR	PACW	0	0	0	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	total	69519	Pilot Rock Solar 2	67502	Pilot Rock Solar 2 LLC	OR	PACW	10	111	5	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	residential	69519	Pilot Rock Solar 2	67502	Pilot Rock Solar 2 LLC	OR	PACW	0	0	0	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	industrial	69519	Pilot Rock Solar 2	67502	Pilot Rock Solar 2 LLC	OR	PACW	0	0	0	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	commercial	69519	Pilot Rock Solar 2	67502	Pilot Rock Solar 2 LLC	OR	PACW	10	111	5	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	transportation	69518	Pilot Rock Solar 1	67501	Pilot Rock Solar 1 LLC	OR	PACW	0	0	0	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	total	69518	Pilot Rock Solar 1	67501	Pilot Rock Solar 1 LLC	OR	PACW	7	82	5	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	residential	69518	Pilot Rock Solar 1	67501	Pilot Rock Solar 1 LLC	OR	PACW	0	0	0	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	industrial	69518	Pilot Rock Solar 1	67501	Pilot Rock Solar 1 LLC	OR	PACW	0	0	0	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	commercial	69518	Pilot Rock Solar 1	67501	Pilot Rock Solar 1 LLC	OR	PACW	7	82	5	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	transportation	69233	CA- US Foods- Sacramento (McClellan)	67342	USF McClellan, LLC	CA	BANC	0	0	0	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	total	69233	CA- US Foods- Sacramento (McClellan)	67342	USF McClellan, LLC	CA	BANC	124	1421	1	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	residential	69233	CA- US Foods- Sacramento (McClellan)	67342	USF McClellan, LLC	CA	BANC	0	0	0	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	industrial	69233	CA- US Foods- Sacramento (McClellan)	67342	USF McClellan, LLC	CA	BANC	0	0	0	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	commercial	69233	CA- US Foods- Sacramento (McClellan)	67342	USF McClellan, LLC	CA	BANC	124	1421	1	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	transportation	69192	AETS Old Michigan Solar LLC	66264	AETS OpCo Holdings LLC	TX	ERCO	0	0	0	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	total	69192	AETS Old Michigan Solar LLC	66264	AETS OpCo Holdings LLC	TX	ERCO	275	6893	1	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	residential	69192	AETS Old Michigan Solar LLC	66264	AETS OpCo Holdings LLC	TX	ERCO	0	0	0	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	industrial	69192	AETS Old Michigan Solar LLC	66264	AETS OpCo Holdings LLC	TX	ERCO	275	6893	1	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	commercial	69192	AETS Old Michigan Solar LLC	66264	AETS OpCo Holdings LLC	TX	ERCO	0	0	0	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	transportation	69191	GreenStruxure REP009, LLC	65849	ClearGen LLC	CA	CISO	0	0	0	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	total	69191	GreenStruxure REP009, LLC	65849	ClearGen LLC	CA	CISO	357	89	1	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	residential	69191	GreenStruxure REP009, LLC	65849	ClearGen LLC	CA	CISO	0	0	0	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	industrial	69191	GreenStruxure REP009, LLC	65849	ClearGen LLC	CA	CISO	0	0	0	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508
2025-01-01 00:00:00.000000	commercial	69191	GreenStruxure REP009, LLC	65849	ClearGen LLC	CA	CISO	357	89	1	∅	∅	∅	∅	early_release	2026-09-29 00:39:35.858508

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 load data

Related load data
Dataset	Description
Balancing Authority Day-Ahead Demand ForecastEIA · hourly	EIA-930 day-ahead demand forecast for every reporting balancing authority, keyed by ba. 4.5M rows, 71 BAs, 2019-01 through the next day. One forecast per hour, latest submission; join atg.ba_load on (ba, event_time) for forecast error.
Balancing Authority Hourly DemandEIA · hourly	Hourly actual demand for every balancing authority that reports to EIA-930, keyed by EIA's BA code in ba. 4.5M rows, 71 BAs, 2019-01 to now. The latest EIA submission for each hour. Every region reads the same columns, so comparing two areas is a filter on ba rather than a second table.
Delivery-Only Company SalesEIA · annual (report year)	EIA-861 delivery companies: revenue, MWh and customers reported by delivery-only companies, by customer class. Delivery_Companies, 2020 on, laid out like sales. 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.
Demand Response ProgramsEIA · annual (report year)	EIA-861 demand response: enrolled customers, energy and peak demand savings and program costs, by utility and customer class. Demand_Response, 2013 on. Savings in MWh and MW, costs in thousand dollars. 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.