PG&E Supply and Demand Plan

Every posting of PG&E's Pipe Ranger plan: feed supplydemand carries the same fields as pge_cgt.daily_operations for Yesterday-2 through Today+3, so it is PG&E's own three-day forecast of demand (including electric generation), receipts by interconnect and system inventory.

PG&ELoad data CAISO market

Open in Data Ask the agent

One row per: posting x feed x gas day x field; Every posting (several a day) cadence
Evidence: Observed market data; Published observations from the named source
Time basis: Date-labelled records; UTC · event_time

Overview

day_label is Today, Today+1, … relative to posted_at, and plan_number is PG&E's plan revision (F is final). Read the newest posted_at. Published by PG&E.

Query contract: Preserve one canonical row per (feed, posted_at, gas_day, field) before aggregating.
Analysis rules: Select the newest posted_at per (feed, gas_day, field) before reading.Use feed = 'supplydemand' for PG&E's forecast; day_label Today+N is a forecast, Yesterday is settled.
Interpretation: One utility's own system, not California-wide: PG&E and SoCalGas are separate systems, and neither includes the other's demand.Published by PG&E; attribute it to PG&E whenever it is reported.

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.CAISO MCP API reference
HTTP endpoint: POST /api/v1/datasets/pge_cgt_plan_snapshots/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

12 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`observed_at`	`Nullable(DateTime64(6, 'UTC'))`
`posted_at`	`DateTime64(6, 'UTC')`
`feed`	`LowCardinality(String)`
`gas_day`	`Date32`
`day_label`	`LowCardinality(Nullable(String))`
`plan_number`	`LowCardinality(Nullable(String))`
`field`	`LowCardinality(String)`
`value`	`Nullable(Float64)`
`value_text`	`Nullable(String)`
`unit`	`LowCardinality(Nullable(String))`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	observed_at	posted_at	feed	gas_day	day_label	plan_number	field	value	value_text	unit	ingested_at
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	El_Paso_Phys	975	975	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	Epng	440	440	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	F_Luaf	29	29	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	From_KRGT_Kj_Phys	282	282	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	GRS_LLC_Inj	39	39	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	GRS_LLC_WD	33	33	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	GillRanch_Inj	6	6	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	GillRanch_WD	0	0	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	IMB_Data_6pts	0	0	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	PGE_Base_Gas_in_Storage	117745	117,745	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	Inv_Begin	4110	4,110	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	Inv_End	4008	4,008	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	Inv_Target	∅	n/a	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	KRGT_Daggett_Phys	375	375	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	KRS_SoCal	101	101	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	Kj_In	0	0	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	Kj_out	79	79	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	Injection	0	0	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	Net_Injection	0	0	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	Krgt	0	0	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	NonCore_Elec_Gen	1060	1,060	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	NonCore_Elec_Gen_Forecast	∅	n/a	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	Net_Withdrawa	4	4	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	NonCore_Industrial	635	635	MMcf/d	2026-10-30 22:40:54.789015
2026-11-02 00:00:00.000000	2026-10-30 22:40:53.320374	2026-10-30 20:13:14.000000	systeminventorysummary	2026-11-02	Today+3	2	NonCore_Industrial_Forecast	∅	n/a	MMcf/d	2026-10-30 22:40:54.789015

Coverage

Complete: 100.0%
Gap days: 0
Days with data: 50

Show coverage history

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

2026

gaplessmore

Related data

Related load data
Dataset	Description
PG&E Distribution Planning Forecast ValuesPG&E · weekly snapshot	The yearly values behind each planning facility, long form: `measure` and `year`. `deficiencymw` is forecast load beyond a facility's rating, `facilityloadingmw` its forecast loading, and the `der_forecast_circuit` measures PG&E's forecast of electrification (`fs`), electric vehicles (`ev`), solar (`photovoltaicmw`), storage and energy efficiency, in MW. Join to `pge_grip.planning_facilities` on (`dataset`, `object_id`, `event_time`). Read one version at a time: `event_time = (SELECT max(event_time) FROM pge_grip.planning_values)`, with FINAL.
PG&E Feeder and Substation Load ProfilesPG&E · weekly snapshot	The load profile PG&E publishes (12 months x 24 hours) for each feeder and substation: the low and high load in kW for each month and hour. `level` is `feeder` or `substation` and `facility_id` the feeder or substation id. Read one version at a time: `event_time = (SELECT max(event_time) FROM pge_grip.load_profiles)`, with FINAL.
PG&E Load Service RequestsPG&E · weekly snapshot	Requests for new or increased load service on PG&E's distribution grid, per circuit: the queue, load type, category, status and expected MW. A request is an application, not load that exists. Read one version at a time: `event_time = (SELECT max(event_time) FROM pge_grip.load_requests)`, with FINAL.
PG&E Peak Day Pricing and SmartRate Event DaysPG&E · daily	The days PG&E called a Peak Day Pricing or SmartRate event, when enrolled customers pay more for power in the event hours. `event_date` is a Pacific calendar date. PG&E calls them on the days it expects the most strain on the grid, so they mark hot, tight days in its territory. Read with FINAL.