Green Pricing Programs

EIA-861 green pricing, 2012 only: revenue, MWh and customers of green pricing programs, by customer class.

EIALoad data

Download data

Native record

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

The discontinued green pricing file. 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, customer_class, duplicate_index) before aggregating.

Analysis rules

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

Schema11

Column

Type

event_timeDateTime64(6, 'UTC')

customer_classLowCardinality(String)

utility_numberInt64

utility_nameLowCardinality(Nullable(String))

stateLowCardinality(String)

revenues_thousand_dollarsNullable(Float64)

sales_mwhNullable(Float64)

customersNullable(Float64)

duplicate_indexInt64

releaseLowCardinality(Nullable(String))

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	customer_class	utility_number	utility_name	state	revenues_thousand_dollars	sales_mwh	customers	release	ingested_at
2012-01-01 00:00:00.000000	transportation	58162	Viridian Energy PA LLC	PA	0	0	0	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	total	58162	Viridian Energy PA LLC	PA	85.03	5668.92	644	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	residential	58162	Viridian Energy PA LLC	PA	72.95	4863.69	592	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	industrial	58162	Viridian Energy PA LLC	PA	0	0	0	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	commercial	58162	Viridian Energy PA LLC	PA	12.08	805.24	52	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	transportation	58162	Viridian Energy PA LLC	NJ	0	0	0	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	total	58162	Viridian Energy PA LLC	NJ	310.29	20686.02	2311	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	residential	58162	Viridian Energy PA LLC	NJ	306.67	20444.93	2294	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	industrial	58162	Viridian Energy PA LLC	NJ	0	0	0	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	commercial	58162	Viridian Energy PA LLC	NJ	3.62	241.09	17	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	transportation	58162	Viridian Energy PA LLC	MD	0	0	0	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	total	58162	Viridian Energy PA LLC	MD	157.73	10515.41	894	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	residential	58162	Viridian Energy PA LLC	MD	143.11	9540.37	845	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	industrial	58162	Viridian Energy PA LLC	MD	0	0	0	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	commercial	58162	Viridian Energy PA LLC	MD	14.63	975.04	49	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	transportation	58162	Viridian Energy PA LLC	IL	0	0	0	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	total	58162	Viridian Energy PA LLC	IL	95.07	6337.86	752	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	residential	58162	Viridian Energy PA LLC	IL	80.73	5382.2	706	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	industrial	58162	Viridian Energy PA LLC	IL	0	0	0	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	commercial	58162	Viridian Energy PA LLC	IL	14.34	955.66	46	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	transportation	58161	Viridian Energy LLC	MA	0	0	0	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	total	58161	Viridian Energy LLC	MA	14.62	974.89	267	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	residential	58161	Viridian Energy LLC	MA	13.46	897.33	250	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	industrial	58161	Viridian Energy LLC	MA	0	0	0	final	2026-09-29 00:38:23.667641
2012-01-01 00:00:00.000000	commercial	58161	Viridian Energy LLC	MA	1.16	77.56	17	final	2026-09-29 00:38:23.667641

Coverage

100.0% complete0 gap days1 days with data

Show coverage history

Coverage: 100.0%Days with data: 1Gaps: 0

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.