RA Master Resource Database: Exceedance and Load-Impact Profiles

The CPUC's hourly exceedance profiles for wind and solar and load impact profiles for demand response, by month and hour, as posted with each MRD.

CPUCGeneration data

Download data

Native record

event_time x source_time x kind x profile x area x month x hour_ending

each posting (checked weekly) publication cadence

Evidence

Observed market data

Published observations from the named source

Time basis

Point-in-time records

UTC · event_time

Overview

One row per (kind, profile, area, month, hour ending, vintage). `kind` is `ver_exceedance` (profile a technology, area a region) or `dr_lip` (profile the demand response provider, area its TAC). Every posting of the MRD is a vintage: `source_time` is when the file was last modified on the CPUC server, and `compliance_year` the RA year it is for. Energy Division reposts each compliance year's MRD every month or so, so read the current values as the newest `source_time` per compliance year, and a past showing against the vintage in force on its date.

Query contract

Preserve one canonical row per (event_time, source_time, kind, profile, area, month, hour_ending) before aggregating.

Analysis rules

Group only after preserving the declared grain: event_time, source_time, kind, profile, area, month, hour_ending.

Schema10

Column

Type

event_timeDateTime64(6, 'UTC')

source_timeDateTime64(6, 'UTC')

compliance_yearNullable(Int64)

kindLowCardinality(String)

profileLowCardinality(String)

areaLowCardinality(String)

monthInt64

hour_endingInt64

valueNullable(Float64)

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	source_time	compliance_year	kind	profile	area	month	hour_ending	value	ingested_at
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	24	0.11	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	23	0.09	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	22	0.09	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	21	0.09	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	20	0.09	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	19	0.07	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	18	0.09	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	17	0.09	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	16	0.07	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	15	0.07	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	14	0.07	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	13	0.07	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	12	0.07	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	11	0.09	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	10	0.08	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	9	0.07	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	8	0.07	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	7	0.08	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	6	0.08	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	5	0.09	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	4	0.10500000000000001	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	3	0.13	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	2	0.125	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	WA/OR	12	1	0.11	2026-09-29 02:30:13.870301
2027-12-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ver_exceedance	Wind	Socal	12	24	0.07231716524281151	2026-09-29 02:30:13.870301

Coverage

3.4% complete1,029 gap days36 days with data

Show coverage history

Coverage: 3.4%Days with data: 36Gaps: 1,029

2027

2026

2025

gaplessmore

Related generation data

Related generation data
Dataset	Description
RA Master Resource Database: Monthly Qualifying CapacityCPUC · each posting (checked weekly)	Each RA resource's qualifying capacity in each month of the compliance year, with its effective flexible capacity. One row per (month, vintage, resource, hybrid sub-ID). `qc_mw` is the monthly QC from the MRD sheet (from the DR Hourly QC sheet for demand response the MRD sheet does not list); `efc_mw` is the Monthly EFC sheet's effective flexible capacity where the resource has one. `event_time` is the first of the month. Every posting of the MRD is a vintage: `source_time` is when the file was last modified on the CPUC server, and `compliance_year` the RA year it is for. Energy Division reposts each compliance year's MRD every month or so, so read the current values as the newest `source_time` per compliance year, and a past showing against the vintage in force on its date.
RA Master Resource Database: ResourcesCPUC · each posting (checked weekly)	Every resource eligible to sell RA in CAISO with the characteristics a slice-of-day showing is checked against: Pmax, storage energy and efficiency, availability window, grid charging, deliverability and local area. One row per (compliance year, vintage, resource, hybrid sub-ID), from the MRD sheet of the CPUC Master Resource Database. Storage carries its round-trip `battery_efficiency`, its energy (`max_continuous_energy_mwh`, which the 2027 MRD calls `energy_per_cycle_mwh` and supplements with `hours_continuous_duration`), `max_daily_mwh` and `daily_storage_cycles`; every resource its availability window in hours ending. `deliverability` is CAISO's status (FC full capacity, PD partial, ID interim, EO energy only) and `deliverability_mw` is posted as either MW or a share ("83.58%"), so it is text. `resource_id` is the CAISO resource ID, the key into `caiso.generating_capability` and `grid.plant_nodes`. Demand response rows carry `drp` and `tac`. Every posting of the MRD is a vintage: `source_time` is when the file was last modified on the CPUC server, and `compliance_year` the RA year it is for. Energy Division reposts each compliance year's MRD every month or so, so read the current values as the newest `source_time` per compliance year, and a past showing against the vintage in force on its date.
RA Master Resource Database: Slice-of-Day Qualifying CapacityCPUC · each posting (checked weekly)	Slice-of-day qualifying capacity: each wind, solar and demand response resource's QC in each hour of each month of the compliance year. One row per (month, hour ending, vintage, resource, hybrid sub-ID), from the VER Hourly QC and DR Hourly QC sheets (`kind` VER or DR). These are the 24 slices x 12 months a variable resource can be shown in under the CPUC's slice-of-day RA framework. A blank cell is not stored: no QC shown for that slice is not a QC of zero. `event_time` is the first of the month. Every posting of the MRD is a vintage: `source_time` is when the file was last modified on the CPUC server, and `compliance_year` the RA year it is for. Energy Division reposts each compliance year's MRD every month or so, so read the current values as the newest `source_time` per compliance year, and a past showing against the vintage in force on its date.
Balancing Authority Generation by FuelEIA · hourly	EIA-930 hourly net generation by energy source for every reporting balancing authority, one wide row per (ba, hour). 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.