Balancing Authority Generation by Fuel

EIA-930 hourly net generation by energy source for every reporting balancing authority, one wide row per (ba, hour).

EIAGeneration data ERCOT market NYISO market CAISO market PJM market MISO market ISO-NE market SPP market

One row per: balancing authority x hour, wide by EIA energy source; Hourly cadence
Evidence: Observed market data; Published observations from the named source
Time basis: Interval-end records; UTC · event_time

Overview

5.2M rows, 83 BAs, 2019-01 to now. Each EIA source code is its own additive column: coal, gas, oil, nuclear, hydro, pumped storage, wind, wind with storage, solar, solar with storage, battery, other and unknown storage, geothermal, other and unknown.

Query contract: One row per (ba, event_time) is already the latest EIA submission; read it plainly.
Analysis rules: Filter ba to your scope's code with a direct WHERE; search_data returns the allowed value. One ba per query keeps a region's rows from mixing with another's.Total generation is the sum of the non-NULL fuel columns in one row. Storage columns can be negative when charging.
Interpretation: event_time is EIA-930's HOUR-ENDING stamp: the row at 18:00 UTC is the 17:00-18:00 hour. To compare with an ISO's interval-start table, match this row at t with the ISO row at t - 1 hour.Net generation inside the balancing area; it excludes imports and is not a statement of how demand was served.

Access

Download: Query it in SQL, download it, or read it with an API key. Download data
MCP: Connect an MCP client and load the contract with describe_data before calling query_data.ERCOT MCP CAISO MCP NYISO MCP PJM MCP SPP MCP MISO MCP ISO-NE MCP BPA MCP API reference
HTTP endpoint: POST /api/v1/datasets/ba_generation_mix/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

18 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`ba`	`LowCardinality(String)`
`coal_mw`	`Nullable(Float64)`
`gas_mw`	`Nullable(Float64)`
`oil_mw`	`Nullable(Float64)`
`nuclear_mw`	`Nullable(Float64)`
`hydro_mw`	`Nullable(Float64)`
`pumped_storage_mw`	`Nullable(Float64)`
`wind_mw`	`Nullable(Float64)`
`wind_storage_mw`	`Nullable(Float64)`
`solar_mw`	`Nullable(Float64)`
`solar_storage_mw`	`Nullable(Float64)`
`battery_mw`	`Nullable(Float64)`
`other_storage_mw`	`Nullable(Float64)`
`unknown_storage_mw`	`Nullable(Float64)`
`geothermal_mw`	`Nullable(Float64)`
`other_mw`	`Nullable(Float64)`
`unknown_mw`	`Nullable(Float64)`

Sample data

event_time	ba	coal_mw	gas_mw	oil_mw	nuclear_mw	hydro_mw	pumped_storage_mw	wind_mw	wind_storage_mw	solar_mw	solar_storage_mw	battery_mw	other_storage_mw	unknown_storage_mw	geothermal_mw	other_mw	unknown_mw
2026-11-03 07:00:00.000000	IID	∅	136	0	∅	8	∅	∅	∅	0	1	100	∅	∅	442	∅	∅
2026-11-03 07:00:00.000000	GRID	0	855	∅	∅	∅	∅	253	∅	-1	∅	∅	∅	∅	∅	∅	∅
2026-11-03 07:00:00.000000	DOPD	∅	∅	∅	∅	194	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅
2026-11-03 07:00:00.000000	CHPD	∅	∅	∅	∅	387	∅	2	∅	∅	∅	∅	∅	∅	∅	∅	∅
2026-11-03 07:00:00.000000	IPCO	∅	304	0	∅	587	∅	97	∅	0	∅	7	∅	∅	31	21	∅
2026-11-03 07:00:00.000000	PGE	0	969	∅	∅	105	∅	0	∅	∅	∅	-6	∅	∅	∅	0	∅
2026-11-03 07:00:00.000000	PACW	∅	683	∅	∅	115	∅	30	∅	0	∅	∅	∅	∅	∅	34	∅
2026-11-03 07:00:00.000000	GCPD	∅	∅	∅	∅	1119	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅
2026-11-03 07:00:00.000000	TIDC	∅	201	∅	∅	0	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅
2026-11-03 07:00:00.000000	BPAT	∅	1063	∅	1146	4939	∅	95	∅	-3	3	∅	∅	∅	∅	114	∅
2026-11-03 07:00:00.000000	LDWP	∅	829	∅	∅	94	0	251	∅	0	0	0	∅	∅	∅	253	∅
2026-11-03 07:00:00.000000	BANC	∅	1110	∅	∅	341	∅	∅	∅	1	∅	∅	∅	∅	∅	12	∅
2026-11-03 07:00:00.000000	NEVP	80	2299	0	∅	2	∅	53	∅	-1	∅	0	∅	∅	∅	295	∅
2026-11-03 07:00:00.000000	SCL	∅	∅	∅	∅	708	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅
2026-11-03 07:00:00.000000	CAL	5	12309	46	1101	2145	0	2112	∅	-56	1	100	∅	∅	1155	3644	∅
2026-11-03 07:00:00.000000	AVA	∅	410	∅	∅	291	∅	84	∅	0	∅	∅	∅	∅	∅	46	∅
2026-11-03 07:00:00.000000	AVRN	∅	528	∅	∅	0	∅	130	∅	0	∅	∅	∅	∅	∅	∅	∅
2026-11-03 07:00:00.000000	TPWR	∅	∅	∅	∅	242	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅
2026-11-03 07:00:00.000000	CAR	2142	6023	0	10416	68	-1278	∅	∅	-6	-33	-76	∅	∅	∅	636	∅
2026-11-03 07:00:00.000000	CISO	5	10033	46	1101	1702	∅	1861	∅	-57	∅	∅	∅	∅	713	3379	∅
2026-11-03 06:00:00.000000	AZPS	-28	1276	0	0	0	∅	236	∅	1	∅	1213	∅	-13	∅	28	∅
2026-11-03 06:00:00.000000	GCPD	∅	∅	∅	∅	1033	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅
2026-11-03 06:00:00.000000	DEAA	∅	527	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅	∅
2026-11-03 06:00:00.000000	AVRN	∅	527	∅	∅	0	∅	112	∅	0	∅	∅	∅	∅	∅	∅	∅
2026-11-03 06:00:00.000000	CHPD	∅	∅	∅	∅	585	∅	2	∅	∅	∅	∅	∅	∅	∅	∅	∅

Coverage

Complete: 100.0%
Gap days: 0
Days with data: 2,864

Show coverage history

Coverage: 100.0%Days with data: 2,864Gaps: 0

2026

2025

2024

2023

2022

2021

2020

2019

gaplessmore

Related data

Related generation data
Dataset	Description
Dispersed GenerationEIA · annual (report year)	EIA-861 dispersed generation capacity by technology and utility, 2012 to 2015. Dispersed sheets of the discontinued distributed_generation file. 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.
Distributed GenerationEIA · annual (report year)	EIA-861 distributed generation capacity by technology and utility, 2012 to 2015. Distributed sheets of the discontinued distributed_generation file, succeeded by net_metering and non_net_metering_distributed. 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.
Net MeteringEIA · annual (report year)	EIA-861 net metering: net-metered capacity, installations and energy sold back by technology, utility and customer class. Net_Metering, the utility-level sheets. Columns follow EIA's own labels across its renames: customers counts run to 2020 and installations from 2021, storage paired with PV is photovoltaic_storage_* to 2022 and battery_* from 2023, and 2012 counted meters. Capacity in MW, energy in MWh. 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.
Net Metering by StateEIA · annual (report year)	EIA-861 net metering state totals, by technology and customer class, 2023 on. The State Level sheet of Net_Metering, as EIA totals it. 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.