RA Master Resource Database: Resources

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.

CPUCGeneration data

Download data

Native record

event_time x source_time x resource_id x hybrid_sub_id x duplicate_index

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 (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.

Query contract

Preserve one canonical row per (event_time, source_time, resource_id, hybrid_sub_id, duplicate_index) before aggregating.

Analysis rules

Group only after preserving the declared grain: event_time, source_time, resource_id, hybrid_sub_id, duplicate_index.

Schema43

Column

Type

event_timeDateTime64(6, 'UTC')

source_timeDateTime64(6, 'UTC')

compliance_yearNullable(Int64)

resource_idLowCardinality(String)

hybrid_sub_idLowCardinality(String)

duplicate_indexInt64

allows_grid_chargingNullable(Bool)

baaLowCardinality(Nullable(String))

battery_efficiencyNullable(Float64)

colocated_resource_idsLowCardinality(Nullable(String))

commentsLowCardinality(Nullable(String))

daily_storage_cyclesNullable(Float64)

deliverabilityLowCardinality(Nullable(String))

deliverability_mwLowCardinality(Nullable(String))

disadvantaged_communityLowCardinality(Nullable(String))

dispatchabilityLowCardinality(Nullable(String))

energy_per_cycle_mwhNullable(Float64)

first_available_heNullable(Float64)

flex_category_draftLowCardinality(Nullable(String))

fuelLowCardinality(Nullable(String))

generator_nameLowCardinality(Nullable(String))

hours_continuous_durationNullable(Float64)

interconnection_limit_mwNullable(Float64)

last_available_heNullable(Float64)

local_areaLowCardinality(Nullable(String))

max_continuous_energy_mwhNullable(Float64)

max_daily_mwhNullable(Float64)

max_daily_run_hoursNullable(Float64)

nameplate_mwNullable(Float64)

path_designationLowCardinality(Nullable(String))

pmax_ndc_mwNullable(Float64)

resource_typeLowCardinality(Nullable(String))

sept_efc_draft_mwNullable(Float64)

specified_import_statusLowCardinality(Nullable(String))

sub_local_areaLowCardinality(Nullable(String))

technologyLowCardinality(Nullable(String))

min_qualified_categoryLowCardinality(Nullable(String))

drpLowCardinality(Nullable(String))

tacLowCardinality(Nullable(String))

categoryLowCardinality(Nullable(String))

regionLowCardinality(Nullable(String))

source_sheetLowCardinality(Nullable(String))

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	source_time	compliance_year	resource_id	allows_grid_charging	baa	battery_efficiency	colocated_resource_ids	comments	daily_storage_cycles	deliverability	deliverability_mw	disadvantaged_community	dispatchability	energy_per_cycle_mwh	first_available_he	flex_category_draft	fuel	generator_name	hours_continuous_duration	interconnection_limit_mw	last_available_he	local_area	max_continuous_energy_mwh	max_daily_mwh	max_daily_run_hours	nameplate_mw	path_designation	pmax_ndc_mw	resource_type	sept_efc_draft_mw	specified_import_status	sub_local_area	technology	min_qualified_category	drp	tac	category	region	source_sheet	ingested_at
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	ZOND_6_UNIT	∅	CISO	∅	∅	∅	∅	FC	∅	∅	N	∅	1	∅	WIND	ZOND WINDSYSTEMS INC.	∅	∅	24	Bay Area	∅	∅	24	21.87	North	17.1	Wind	∅	N	Contra Costa	WIND	∅	∅	∅	Wind	Norcal	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	YUBACT_6_UNITA1	∅	CISO	∅	∅	∅	∅	FC	∅	∅	Y	∅	1	1	NATURAL GAS	Yuba City Energy Center (Calpine)	∅	∅	24	Sierra	∅	∅	24	49.9	North	47.16	Peaker	47.16	N	Pease, Drum-Rio Oso	COMBUSTION TURBINE	∅	∅	∅	∅	∅	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	YUBACT_1_SUNSWT	∅	CISO	∅	∅	∅	∅	FC	∅	∅	Y	∅	1	1	NATURAL GAS	YUBA CITY COGEN	∅	∅	24	Sierra	∅	∅	24	49	North	49.97	CHP	0	N	Pease, Drum-Rio Oso	COMBUSTION TURBINE	∅	∅	∅	∅	∅	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	YELPIN_2_YP2SR3	∅	CISO	∅	YELPIN_2_YP2BT3	Q1341 - Group name YELLOW_PINE_1341_3 - Max to grid 65 MW. 65 MW solar. Max 33 MW NQC. (Normal FC) At CPUC - hourly FC - Waiting for Lugo Victorville CRAS - Co-located with 32 MW battery YELP_2_YP2BT3.	∅	ID	1	∅	N	∅	1	∅	SUN	Yellow Pine 2 B PV	∅	65	24	CAISO System	∅	∅	24	65	South	65	Paired_Solar_1Axis	∅	N	∅	PHOTO VOLTAIC	∅	∅	∅	Solar Tracking	Socal	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	YELPIN_2_YP2SR2	∅	CISO	∅	YELPIN_2_YP2BT2	Q1341 - Group name YELLOW_PINE_1341_2 - Max to grid 60 MW. 60 MW solar. Max 7 MW NQC. (Normal FC) At CPUC - hourly FC - Waiting for Lugo Victorville CRAS - Co-located with YELP_2_YP2BT2.	∅	ID	1	∅	N	∅	1	∅	SUN	Yellow Pine 2 A PV	∅	85	24	CAISO System	∅	∅	24	60	South	60	Paired_Solar_1Axis	∅	N	∅	PHOTO VOLTAIC	∅	∅	∅	Solar Tracking	Socal	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	YELPIN_2_YP2SR1	∅	CISO	∅	YELPIN_2_YP2BT1	Q1341 - Group name YELLOW_PINE_1341_1 - Max to grid 125 MW. 125 MW solar. Max 60 MW NQC. (Normal FC) At CPUC - hourly FC - Waiting for Lugo-Victorville CRAS - Co-located with 65 MW battery YELPIN_2_YP2BT1	∅	ID	1	∅	N	∅	1	∅	SUN	Yellow Pine 2	∅	125	24	CAISO System	∅	∅	24	125	South	125	Paired_Solar_1Axis	∅	N	∅	PHOTO VOLTAIC	∅	∅	∅	Solar Tracking	Socal	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	YELPIN_2_YP2BT3	true	CISO	0.859	YELPIN_2_YP2SR3	Q1341 - Group name YELLOW_PINE_1341_3 - Max to grid 65 MW. 32 MW 128 MWh battery FC. Waiting for Lugo Victorville CRAS - Co-located with 65 MW solar YELP_2_YP2SR3.	1	ID	1	∅	Y	128	1	2	LESR	Yellow Pine 2 B BESS	4	65	24	CAISO System	∅	128	4	32	South	32	Paired_BattStorage	64	N	∅	OTHER	∅	∅	∅	∅	∅	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	YELPIN_2_YP2BT2	false	CISO	0.875	YELPIN_2_YP2SR2	Q1341 - Group name YELLOW_PINE_1341_2 - Max to grid 60 MW. 53 MW 212 MWh battery FC. Waiting for Lugo Victorville CRAS and possibly other (25 MW del. transferred from later Q possition.) - Co-located with 60 MW solar YELP_2_YP2SR2.	1	ID	1	∅	Y	212	1	2	LESR	Yellow Pine 2 A BESS	4	60	24	CAISO System	∅	212	4	53	South	53	Paired_BattStorage	106	N	∅	OTHER	∅	∅	∅	∅	∅	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	YELPIN_2_YP2BT1	false	CISO	0.865	YELPIN_2_YP2SR1	Q1341 - Group name YELLOW_PINE_1341_1 - Max to grid 125 MW. 65 MW 260 MWs battery FC. Waiting for Lugo-Victorville CRAS - Co-located with 125 MW solar YELPIN_2_YP2SR1	1	ID	1	∅	Y	260	1	1	LESR	Yellow Pine 2 BESS	4	125	24	CAISO System	∅	260	4	65	South	65	Paired_BattStorage	130	N	∅	OTHER	∅	∅	∅	∅	∅	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	WSTWND_2_SBSBT3	true	CISO	0.8	∅	∅	1	FC	∅	∅	Y	236	1	2	LESR	Sagebrush Solar 2 ESS 59	4	∅	24	CAISO System	∅	236	4	59	South	59	Battery Storage	118	N	∅	OTHER	∅	∅	∅	∅	∅	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	WSTWND_2_SBSBT2	true	CISO	0.8	∅	∅	1	FC	∅	∅	Y	160	1	2	LESR	Sagebrush Solar 2 ESS 40	4	∅	24	CAISO System	∅	160	4	40	South	40	Battery Storage	80	N	∅	OTHER	∅	∅	∅	∅	∅	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	WSTWND_2_SBSBT1	true	CISO	0.8	∅	∅	1	FC	∅	∅	Y	319	1	1	LESR	Sagebrush Solar 2	3.9875	∅	24	CAISO System	∅	319	4	80	South	80	Battery Storage	160	N	∅	OTHER	∅	∅	∅	∅	∅	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	WSTWND_2_M90WD2	∅	CISO	∅	∅	∅	∅	FC	∅	∅	N	∅	1	∅	WIND	Mojave 90	∅	∅	24	CAISO System	∅	∅	24	64.9	South	64.82	Wind	∅	N	∅	WIND	∅	∅	∅	Wind	Socal	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	WSTWND_2_M89WD2	∅	CISO	∅	WSTWND_2_M89BT2	Group name: MOJAVE89_0041CONV - Max to grid 82.65 MW.	∅	FC	∅	∅	N	∅	1	∅	WIND	Mojave 89 Wind	∅	82.65	24	CAISO System	∅	∅	24	82.7	South	58.3	Wind	∅	N	∅	WIND	∅	∅	∅	Wind	Socal	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	WSTWND_2_M89BT2	false	CISO	0.8	WSTWND_2_M89WD2	Group name: MOJAVE89_0041CONV - Max to grid 82.65 MW. Transfer from partial retirement of Mojave 89 Wind	1	PD	11.69	∅	Y	46.76	1	1	LESR	Mojave 89 BESS 2B	0.6623229461756375	82.65	24	CAISO System	∅	46.76	4	70.6	South	70.6	Paired_BattStorage	82.29	N	∅	OTHER	∅	∅	∅	∅	∅	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	WSNR_5_TRCYDYN	∅	BANC	∅	∅	∅	∅	∅	∅	∅	∅	∅	1	∅	WATER	Central Valley Tracy	∅	∅	24	Import	∅	∅	24	0	North	10	Hydro	∅	Y	∅	HYDRO	∅	∅	∅	∅	∅	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	WSNR_2_TESLADYN	∅	BANC	∅	∅	∅	∅	∅	∅	∅	∅	∅	1	∅	WATER	Central Valley Tesla	∅	∅	24	Import	∅	∅	24	0	North	10	Hydro	∅	Y	∅	HYDRO	∅	∅	∅	∅	∅	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	WSNR_2_CVPDYN	∅	BANC	∅	∅	∅	∅	∅	∅	∅	∅	∅	1	∅	WATER	Central Valley 1	∅	∅	24	Import	∅	∅	24	0	North	10	Hydro	∅	Y	∅	HYDRO	∅	∅	∅	∅	∅	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	WSENGY_1_UNIT 1	∅	CISO	∅	∅	∅	∅	FC	∅	∅	N	∅	1	∅	BIOMASS	Wheelabrator Shasta	∅	∅	24	CAISO System	∅	∅	24	50	North	50	Biomass/Wood	∅	N	∅	STEAM	∅	∅	∅	∅	∅	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	WRGTSR_2_WSFSR1	∅	CISO	∅	∅	∅	∅	FC	∅	Y	N	∅	1	∅	SUN	Wright Solar Freeman	∅	∅	24	CAISO System	∅	∅	24	200	North	200	Solar_Fixed	∅	N	∅	PHOTO VOLTAIC	∅	∅	∅	Solar Fixed	Norcal	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	WOODWR_1_HYDRO	∅	CISO	∅	∅	∅	∅	EO	∅	∅	N	∅	1	∅	WATER	Quinten Luallen	∅	∅	24	Fresno	∅	∅	24	7.3	North	7.3	Hydro	∅	N	Herndon	HYDRO	∅	∅	∅	∅	∅	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	WOLFSK_1_UNITA1	∅	CISO	∅	∅	∅	∅	FC	∅	Y	Y	∅	1	1	NATURAL GAS	Wolfskill Energy Center	∅	∅	24	CAISO System	∅	∅	24	49.9	North	48.68	Peaker	46.9	N	∅	COMBUSTION TURBINE	∅	∅	∅	∅	∅	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	WNDSTR_2_WIND	∅	CISO	∅	∅	∅	∅	FC	∅	∅	N	∅	1	∅	WIND	Windstar	∅	∅	24	CAISO System	∅	∅	24	0	South	120	Wind	∅	N	∅	WIND	∅	∅	∅	Wind	Socal	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	WNDMAS_2_UNIT 1	∅	CISO	∅	∅	∅	∅	FC	∅	∅	N	∅	1	∅	WIND	BUENA VISTA ENERGY, LLC	∅	∅	24	Bay Area	∅	∅	24	36	North	38	Wind	∅	N	Contra Costa	WIND	∅	∅	∅	Wind	Norcal	MRD	2026-09-29 02:30:13.144110
2027-01-01 00:00:00.000000	2026-08-18 21:57:54.000000	2027	WLDWD_1_SOLAR2	∅	CISO	∅	∅	∅	∅	FC	∅	Y	N	∅	1	∅	SUN	Wildwood Solar 2	∅	∅	24	CAISO System	∅	∅	24	15	North	15	Solar_1Axis	∅	N	∅	PHOTO VOLTAIC	∅	∅	∅	Solar Tracking	Norcal	MRD	2026-09-29 02:30:13.144110

Coverage

0.4% complete728 gap days3 days with data

Show coverage history

Coverage: 0.4%Days with data: 3Gaps: 728

2027

2026

2025

gaplessmore

Related generation data

Related generation data
Dataset	Description
RA Master Resource Database: Exceedance and Load-Impact ProfilesCPUC · each posting (checked weekly)	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. 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.
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: 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.