WEIM Area Demand Forecasts

CAISO's published demand forecasts for each WEIM balancing area outside CAISO's own TAC areas, keyed by ba and horizon (day_ahead, two_day, seven_day), latest vintage per hour.

Load data BPA market

Open in Data Ask the agent

One row per: WEIM area x horizon x forecast hour; Hourly cadence
Evidence: Forecast data; Forward-looking values with an explicit issue time
Time basis: Interval-start records; UTC · event_time

Overview

4.4M rows, 30 areas, 2018-01 to a week ahead.

Query contract: One row per (ba, horizon, event_time) is the latest vintage; read it plainly.
Analysis rules: Filter ba to your scope's code with a direct WHERE; search_data returns the allowed value. One ba per query keeps a region's rows from mixing with another's.Choose one horizon; do not mix day_ahead, two_day and seven_day in one series.
Interpretation: This table is a materialized MergeTree whose refresh has already collapsed source revisions. Do not add FINAL and do not re-apply argMax over ingested_at.

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

Schema

5 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`ba`	`LowCardinality(String)`
`horizon`	`LowCardinality(String)`
`forecast_mw`	`Nullable(Float64)`
`source_time`	`Nullable(DateTime64(6, 'UTC'))`

Sample data

event_time	ba	horizon	forecast_mw	source_time
2026-11-10 07:00:00.000000	AZPS	seven_day	3743.26	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	BANCRSVL	seven_day	109.97	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	BANCMID	seven_day	258.21	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	BANCSMUD	seven_day	989.7	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	BANC	seven_day	1466.26	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	LADWP	seven_day	2483.08	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	WALC	seven_day	479.09	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	TEPC	seven_day	949.85	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	AVA	seven_day	1044.14	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	BANCRDNG	seven_day	77.15	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	PNM	seven_day	1432.85	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	PGE	seven_day	2468.92	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	WALCAEPCO	seven_day	319.58	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	TIDC	seven_day	281.48	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	PACW	seven_day	2128.28	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	BHBA	seven_day	596.87	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	NWMT	seven_day	1168.88	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	EPE	seven_day	707.31	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	NEVP	seven_day	3863.67	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	IPCO	seven_day	1627.95	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	SRP	seven_day	3298.14	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	PSEI	seven_day	2506.74	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	TPWR	seven_day	466.44	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	SCL	seven_day	961.04	2026-11-03 09:46:51.000000
2026-11-10 07:00:00.000000	WALCDSW	seven_day	159.51	2026-11-03 09:46:51.000000

Coverage

Complete: 100.0%
Gap days: 0
Days with data: 3,236

Show coverage history

Coverage: 100.0%Days with data: 3,236Gaps: 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

gaplessmore

Related data

Related load data
Dataset	Description
CAISO Day-Ahead Load ForecastCAISO · hourly (day-ahead run)	CAISO's day-ahead demand forecast, one row per forecast hour with a system total and one column per TAC area. 75,727 hours, 2018-01 through the next delivery day. Column-for-column identical to CAISO Load (caiso_load) on purpose: system_mw, pge_mw, sce_mw, sdge_mw, vea_mw, mwd_mw. Forecast-versus-actual is therefore a plain join on event_time with no reshaping on either side. CAISO publishes no issue-time column for this feed, so there is no vintage axis here — this is the day-ahead market run for each hour, not a curve of successive forecasts. CAISO's other horizons (two-day, seven-day, real-time) live in caiso.load_forecast_horizons and only begin in May 2026.
CAISO Hourly Actual LoadCAISO · hourly	Actual hourly electricity demand in CAISO, one row per hour with a system total and one column per TAC area. 75,689 hours, 2018-01 to now. Columns: system_mw plus pge_mw, sce_mw, sdge_mw, vea_mw, mwd_mw. system_mw is CAISO's own CA ISO-TAC total. The five TAC areas are the CAISO balancing area's own partition. Wide rather than long, so "load right now" and "the 5 TAC area shares of it" are one row, not 6. Every market's load table in this catalog shares the system_mw column and the same hourly grain, so a cross-market demand comparison needs no reshaping.
Five-Minute Demand OutlookCAISO · 5-minute	CAISO system demand, day-ahead and hour-ahead demand forecasts, and demand response from the live demand Outlook. Every capture is retained, with Pacific snapshot date and DST ambiguity flags.
Load ActualsCAISO · hourly	Hourly actual electricity demand from CAISO OASIS, reported for the CAISO system total and TAC load areas such as PG&E, SCE, and SDG&E. This settlements-grade series is published after the operating interval rather than as a live five-minute reading. It supports forecast benchmarking, historical load shape, and aligned hourly net-load analysis. The official source is CAISO OASIS.