Mid-Term Load Forecast (MTLF)

SPP's mid-term load forecast in MW, running roughly seven days ahead, carried alongside the realized actual for the same interval so forecast error can be computed within the table.

Load data SPP market

Open in Data Ask the agent

One row per: event_time x publish_time x baa; Hourly, out ~7 days cadence
Evidence: Forecast data; Forward-looking values with an explicit issue time
Time basis: Point-in-time records; UTC · event_time

Overview

Bitemporal: each row records the delivery interval and the vintage the forecast was published at, retaining every successive forecast for a given hour.

Query contract: Preserve one canonical row per (event_time, publish_time, baa) before aggregating.
Analysis rules: Group only after preserving the declared grain: event_time, publish_time, baa.

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

Schema

6 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`publish_time`	`DateTime64(6, 'UTC')`
`baa`	`LowCardinality(String)`
`mtlf_mw`	`Nullable(Float64)`
`actual_mw`	`Nullable(Float64)`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	publish_time	baa	mtlf_mw	actual_mw	ingested_at
2026-11-11 04:00:00.000000	2026-11-04 04:00:00.000000	SWPW	2725	∅	2026-11-04 05:01:42.944215
2026-11-11 04:00:00.000000	2026-11-04 04:00:00.000000	SPP	30785	∅	2026-11-04 05:01:42.944215
2026-11-11 03:00:00.000000	2026-11-04 04:00:00.000000	SWPW	2780	∅	2026-11-04 05:01:42.944215
2026-11-11 03:00:00.000000	2026-11-04 04:00:00.000000	SPP	31570	∅	2026-11-04 05:01:42.944215
2026-11-11 03:00:00.000000	2026-11-04 03:00:00.000000	SWPW	2780	∅	2026-11-04 05:01:42.944215
2026-11-11 03:00:00.000000	2026-11-04 03:00:00.000000	SPP	31691	∅	2026-11-04 05:01:42.944215
2026-11-11 03:00:00.000000	2026-11-04 03:00:00.000000	SWPW	2780	∅	2026-11-04 04:01:40.558222
2026-11-11 03:00:00.000000	2026-11-04 03:00:00.000000	SPP	31691	∅	2026-11-04 04:01:40.558222
2026-11-11 02:00:00.000000	2026-11-04 04:00:00.000000	SWPW	2832	∅	2026-11-04 05:01:42.944215
2026-11-11 02:00:00.000000	2026-11-04 04:00:00.000000	SPP	31640	∅	2026-11-04 05:01:42.944215
2026-11-11 02:00:00.000000	2026-11-04 03:00:00.000000	SWPW	2836	∅	2026-11-04 05:01:42.944215
2026-11-11 02:00:00.000000	2026-11-04 03:00:00.000000	SPP	31825	∅	2026-11-04 05:01:42.944215
2026-11-11 02:00:00.000000	2026-11-04 02:00:00.000000	SWPW	2837	∅	2026-11-04 05:01:42.944215
2026-11-11 02:00:00.000000	2026-11-04 02:00:00.000000	SPP	31690	∅	2026-11-04 05:01:42.944215
2026-11-11 02:00:00.000000	2026-11-04 03:00:00.000000	SWPW	2836	∅	2026-11-04 04:01:40.558222
2026-11-11 02:00:00.000000	2026-11-04 03:00:00.000000	SPP	31825	∅	2026-11-04 04:01:40.558222
2026-11-11 02:00:00.000000	2026-11-04 02:00:00.000000	SWPW	2837	∅	2026-11-04 04:01:40.558222
2026-11-11 02:00:00.000000	2026-11-04 02:00:00.000000	SPP	31690	∅	2026-11-04 04:01:40.558222
2026-11-11 01:00:00.000000	2026-11-04 04:00:00.000000	SWPW	2788	∅	2026-11-04 05:01:42.944215
2026-11-11 01:00:00.000000	2026-11-04 04:00:00.000000	SPP	31962	∅	2026-11-04 05:01:42.944215
2026-11-11 01:00:00.000000	2026-11-04 03:00:00.000000	SWPW	2785	∅	2026-11-04 05:01:42.944215
2026-11-11 01:00:00.000000	2026-11-04 03:00:00.000000	SPP	32041	∅	2026-11-04 05:01:42.944215
2026-11-11 01:00:00.000000	2026-11-04 02:00:00.000000	SWPW	2784	∅	2026-11-04 05:01:42.944215
2026-11-11 01:00:00.000000	2026-11-04 02:00:00.000000	SPP	31933	∅	2026-11-04 05:01:42.944215
2026-11-11 01:00:00.000000	2026-11-04 01:00:00.000000	SWPW	2783	∅	2026-11-04 05:01:42.944215

Coverage

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

Show coverage history

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

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

gaplessmore

Related data

Related load data
Dataset	Description
Actual System LoadSPP · 5-minute	SPP's realized system-wide demand in MW at five-minute resolution, the actual-load counterpart to the short-term and mid-term load forecasts. Note that the feed republishes the same event_time on successive polls with a fresh ingested_at, so a read should collapse repeats on ingested_at before use.
Short-Term Load Forecast (STLF)SPP · 5-minute, frequent vintages	SPP's short-term load forecast in MW. Bitemporal: each row carries both the delivery interval (event_time) and the vintage the forecast was issued at (publish_time), so successive forecasts for the same interval are retained rather than overwritten. That makes the table usable for forecast-error and forecast-convergence analysis, not only for the latest view.
SPP Hourly Actual LoadSPP · hourly	Actual hourly electricity demand in SPP, one row per hour and balancing area: event_time, baa ('SPP' for the RTO East footprint, 'SWPW' for RTO West from 2026-04), system_mw and source. 140k rows, 2011-01 to now. Two feeds build it and `source` says which: 'zonal_hourly' rows (2011 to 2016, plus fallback hours later) are the sum of 17 load-zone columns (okge_mw, wfec_mw, wr_mw, waue_mw, les_mw, ede_mw, seci_mw, kacy_mw, mps_mw, csws_mw, sprm_mw, indn_mw, sps_mw, oppd_mw, kcpl_mw, nppd_mw, grda_mw); 'system_5m' rows (2017 on) average SPP's complete five-minute actuals and carry no zones.
SPP Load ForecastSPP · reissued per vintage; two products at different resolutions	SPP's demand forecast in long form: issued_at (when SPP published it), event_time (the hour or interval being forecast), horizon, baa (SPP East or SWPW West), and forecast_mw. History reaches 2017, with named East/West footprints available around the 2026 expansion; older blank BAA rows have unknown footprint. Targets run out to seven days ahead. The horizon column separates SPP's two published products: 'short_term' (STLF, five-minute targets) and 'mid_term' (MTLF, hourly targets out seven days). They are different forecasts at different resolutions and must never be mixed in one series. Issue time and target time are separate columns, so this table supports both 'what does SPP expect' and 'what did SPP expect N hours out'.