PG&E Seven-Day PSPS Forecast

PG&E's daily seven-day Public Safety Power Shutoff outlook: for each `issued_date` and `forecast_date`, the counties at `elevated`, `watch` or `warning`, or `none` with a blank county when no county is at risk.

Native record
issued_date x forecast_date x level x county
daily publication cadence
Evidence
Forecast data
Forward-looking values with an explicit issue time
In Ask the Grid
Grid events on the CAISO map
Values for the live grid surface

Overview

A later issue supersedes an earlier one for the same forecast date. Read with FINAL.

Query contract

Preserve one canonical row per (issued_date, forecast_date, level, county) before aggregating.

Analysis rules

  • Group only after preserving the declared grain: issued_date, forecast_date, level, county.

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.

HTTP endpoint
POST /api/v1/datasets/pge_psps_forecast/query

Schema8

Column
Type
event_timeDateTime64(6, 'UTC')
observed_atNullable(DateTime64(6, 'UTC'))
issued_dateDate32
forecast_dateDate32
day_indexNullable(Int64)
levelLowCardinality(String)
countyLowCardinality(String)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timeobserved_atissued_dateforecast_dateday_indexlevelcountyingested_at
2026-10-01 00:00:00.0000002026-09-26 03:07:52.7874052026-09-252026-10-016none2026-09-26 03:07:53.215383
2026-10-01 00:00:00.0000002026-09-26 04:07:54.4885992026-09-252026-10-016none2026-09-26 04:07:55.012937
2026-10-01 00:00:00.0000002026-09-26 05:07:52.5812372026-09-252026-10-016none2026-09-26 05:07:52.982092
2026-09-30 00:00:00.0000002026-09-26 03:07:52.7874052026-09-252026-09-305none2026-09-26 03:07:53.215383
2026-09-30 00:00:00.0000002026-09-26 04:07:54.4885992026-09-252026-09-305none2026-09-26 04:07:55.012937
2026-09-30 00:00:00.0000002026-09-26 05:07:52.5812372026-09-252026-09-305none2026-09-26 05:07:52.982092
2026-09-29 00:00:00.0000002026-09-26 03:07:52.7874052026-09-252026-09-294none2026-09-26 03:07:53.215383
2026-09-29 00:00:00.0000002026-09-26 04:07:54.4885992026-09-252026-09-294none2026-09-26 04:07:55.012937
2026-09-29 00:00:00.0000002026-09-26 05:07:52.5812372026-09-252026-09-294none2026-09-26 05:07:52.982092
2026-09-28 00:00:00.0000002026-09-26 03:07:52.7874052026-09-252026-09-283none2026-09-26 03:07:53.215383
2026-09-28 00:00:00.0000002026-09-26 04:07:54.4885992026-09-252026-09-283none2026-09-26 04:07:55.012937
2026-09-28 00:00:00.0000002026-09-26 05:07:52.5812372026-09-252026-09-283none2026-09-26 05:07:52.982092
2026-09-27 00:00:00.0000002026-09-26 03:07:52.7874052026-09-252026-09-272none2026-09-26 03:07:53.215383
2026-09-27 00:00:00.0000002026-09-26 04:07:54.4885992026-09-252026-09-272none2026-09-26 04:07:55.012937
2026-09-27 00:00:00.0000002026-09-26 05:07:52.5812372026-09-252026-09-272none2026-09-26 05:07:52.982092
2026-09-26 00:00:00.0000002026-09-26 03:07:52.7874052026-09-252026-09-261none2026-09-26 03:07:53.215383
2026-09-26 00:00:00.0000002026-09-26 04:07:54.4885992026-09-252026-09-261none2026-09-26 04:07:55.012937
2026-09-26 00:00:00.0000002026-09-26 05:07:52.5812372026-09-252026-09-261none2026-09-26 05:07:52.982092
2026-09-25 00:00:00.0000002026-09-26 03:07:52.7874052026-09-252026-09-250none2026-09-26 03:07:53.215383
2026-09-25 00:00:00.0000002026-09-26 04:07:54.4885992026-09-252026-09-250none2026-09-26 04:07:55.012937
2026-09-25 00:00:00.0000002026-09-26 05:07:52.5812372026-09-252026-09-250none2026-09-26 05:07:52.982092

Coverage

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