Dynamic Pricing Enrollment

EIA-861 dynamic pricing: customers enrolled in time-of-use, real-time, variable peak and critical peak programs, by utility and customer class.

EIALoad data

Download data

Native record

event_time 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

Dynamic_Pricing, 2013 on. The program columns hold EIA's Y/N flags. 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, utility_number, state, ba_code, customer_class, duplicate_index) before aggregating.

Analysis rules

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

Schema16

Column

Type

event_timeDateTime64(6, 'UTC')

customer_classLowCardinality(String)

utility_numberInt64

utility_nameLowCardinality(Nullable(String))

short_formLowCardinality(Nullable(String))

stateLowCardinality(String)

ba_codeLowCardinality(String)

number_of_customers_enrolledNullable(Float64)

types_of_program_time_of_use_pricingLowCardinality(Nullable(String))

types_of_program_real_time_pricingLowCardinality(Nullable(String))

types_of_program_variable_peak_pricingLowCardinality(Nullable(String))

types_of_program_critical_peak_pricingLowCardinality(Nullable(String))

types_of_program_critical_peak_rebateLowCardinality(Nullable(String))

duplicate_indexInt64

releaseLowCardinality(Nullable(String))

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	customer_class	utility_number	utility_name	short_form	state	ba_code	number_of_customers_enrolled	types_of_program_time_of_use_pricing	types_of_program_real_time_pricing	types_of_program_variable_peak_pricing	types_of_program_critical_peak_pricing	types_of_program_critical_peak_rebate	duplicate_index	release	ingested_at
2025-01-01 00:00:00.000000	transportation	88888	Withheld	∅	TX	ERCO	∅	∅	∅	∅	∅	∅	2	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	transportation	88888	Withheld	∅	TX	ERCO	∅	∅	∅	∅	∅	∅	1	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	transportation	88888	Withheld	∅	TX	ERCO	∅	∅	∅	∅	∅	∅	0	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	total	88888	Withheld	∅	TX	ERCO	11	∅	∅	∅	∅	∅	2	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	total	88888	Withheld	∅	TX	ERCO	2	∅	∅	∅	∅	∅	1	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	total	88888	Withheld	∅	TX	ERCO	14	∅	∅	∅	∅	∅	0	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	residential	88888	Withheld	∅	TX	ERCO	∅	∅	∅	∅	∅	∅	2	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	residential	88888	Withheld	∅	TX	ERCO	∅	∅	∅	∅	∅	∅	1	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	residential	88888	Withheld	∅	TX	ERCO	∅	∅	∅	∅	∅	∅	0	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	industrial	88888	Withheld	∅	TX	ERCO	11	∅	Y	∅	∅	∅	2	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	industrial	88888	Withheld	∅	TX	ERCO	2	∅	∅	Y	∅	∅	1	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	industrial	88888	Withheld	∅	TX	ERCO	14	∅	Y	∅	∅	∅	0	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	commercial	88888	Withheld	∅	TX	ERCO	∅	∅	∅	∅	∅	∅	2	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	commercial	88888	Withheld	∅	TX	ERCO	∅	∅	∅	∅	∅	∅	1	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	commercial	88888	Withheld	∅	TX	ERCO	∅	∅	∅	∅	∅	∅	0	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	transportation	66867	David Energy Supply LLC	∅	TX	ERCO	0	∅	∅	∅	∅	∅	0	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	total	66867	David Energy Supply LLC	∅	TX	ERCO	65	∅	∅	∅	∅	∅	0	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	residential	66867	David Energy Supply LLC	∅	TX	ERCO	0	∅	∅	∅	∅	∅	0	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	industrial	66867	David Energy Supply LLC	∅	TX	ERCO	0	∅	∅	∅	∅	∅	0	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	commercial	66867	David Energy Supply LLC	∅	TX	ERCO	65	∅	Y	∅	∅	∅	0	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	transportation	66867	David Energy Supply LLC	∅	NY	NYIS	0	∅	∅	∅	∅	∅	0	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	total	66867	David Energy Supply LLC	∅	NY	NYIS	199	∅	∅	∅	∅	∅	0	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	residential	66867	David Energy Supply LLC	∅	NY	NYIS	0	∅	∅	∅	∅	∅	0	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	industrial	66867	David Energy Supply LLC	∅	NY	NYIS	0	∅	∅	∅	∅	∅	0	early_release	2026-09-29 00:39:37.351736
2025-01-01 00:00:00.000000	commercial	66867	David Energy Supply LLC	∅	NY	NYIS	199	∅	Y	∅	∅	∅	0	early_release	2026-09-29 00:39:37.351736

Coverage

0.3% complete4,371 gap days13 days with data

Show coverage history

Coverage: 0.3%Days with data: 13Gaps: 4,371

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

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.