Ask the Grid
Open live grid

PG&E Feeder and Substation Load Profiles

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.

PG&ELoad dataCAISO market
Query with the agent
Native record
event_time x level x facility_id x month x hour
weekly snapshot publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · event_time

Overview

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

Query contract

Preserve one canonical row per (event_time, level, facility_id, month, hour) before aggregating.

Analysis rules

  • Group only after preserving the declared grain: event_time, level, facility_id, month, hour.

Access

Query from your own tools

Use the guarded HTTP endpoint directly, or connect an MCP client and load the dataset contract with describe_data before calling query_data.

CAISO MCP API reference
HTTP endpoint
POST /api/v1/datasets/pge_grip_load_profiles/query

Schema12

Column
Type
event_timeDateTime64(6, 'UTC')
observed_atNullable(DateTime64(6, 'UTC'))
levelLowCardinality(String)
facility_idString
facility_nameNullable(String)
divisionLowCardinality(Nullable(String))
monthInt64
hourInt64
low_kwNullable(Float64)
high_kwNullable(Float64)
map_updated_atNullable(DateTime64(6, 'UTC'))
ingested_atDateTime64(6, 'UTC')

Sample data

event_timeobserved_atlevelfacility_idfacility_namedivisionmonthhourlow_kwhigh_kwmap_updated_atingested_at
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco47294238212025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco46279933342025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco45267129842025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco44261929132025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco43260328932025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco42266429722025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco41272330842025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco40283732772025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco323312137552025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco322337639912025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco321357741302025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco320366842862025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco319366643582025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco318358443682025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco317345244912025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco316324243702025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco315326543702025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco314318243562025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco313323645552025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco312318344012025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco311323145252025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco310325244412025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco39321544362025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco38314941912025-06-02 01:00:25.0000002026-09-25 20:50:10.160656
2026-09-11 17:47:23.3090002026-09-25 20:47:06.269385feeder022011124∅San Francisco37295338512025-06-02 01:00:25.0000002026-09-25 20:50:10.160656

Coverage

100.0% complete0 gap days1 days with data
Show coverage history
Coverage: 100.0%Days with data: 1Gaps: 0
2026
gaplessmore