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.
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
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'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.
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.
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.
CAISO load forecasts for the system and TAC load areas. The RTM five-minute label is the rolling VSTLF forecast used for each real-time dispatch operating interval, not a day-ahead peak forecast. event_time is the delivery interval and source_time is the publication time. For an honest historical forecast comparison, select the last source_time at or before event_time; for a forward interval select the latest source_time available at the analysis cutoff. The public source is CAISO OASIS.
