SPP logo

Short-Term Load Forecast (STLF)

SPP's short-term load forecast in MW.

One row per
event_time x publish_time x baa
5-minute, frequent vintages 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 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.

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

Schema

5 columns
ColumnType
event_timeDateTime64(6, 'UTC')
publish_timeDateTime64(6, 'UTC')
baaLowCardinality(String)
stlf_mwNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timepublish_timebaastlf_mwingested_at
2026-11-04 04:55:00.0000002026-11-04 04:55:00.000000SWPW30392026-11-04 05:38:48.235678
2026-11-04 04:55:00.0000002026-11-04 04:55:00.000000SPP297892026-11-04 05:38:48.235678
2026-11-04 04:55:00.0000002026-11-04 04:55:00.000000SWPW30392026-11-04 05:33:56.554116
2026-11-04 04:55:00.0000002026-11-04 04:55:00.000000SPP297892026-11-04 05:33:56.554116
2026-11-04 04:55:00.0000002026-11-04 04:55:00.000000SWPW30392026-11-04 05:28:44.244939
2026-11-04 04:55:00.0000002026-11-04 04:55:00.000000SPP297892026-11-04 05:28:44.244939
2026-11-04 04:55:00.0000002026-11-04 04:55:00.000000SWPW30392026-11-04 05:23:44.686554
2026-11-04 04:55:00.0000002026-11-04 04:55:00.000000SPP297892026-11-04 05:23:44.686554
2026-11-04 04:50:00.0000002026-11-04 04:55:00.000000SWPW30502026-11-04 05:38:48.235678
2026-11-04 04:50:00.0000002026-11-04 04:55:00.000000SPP299092026-11-04 05:38:48.235678
2026-11-04 04:50:00.0000002026-11-04 04:50:00.000000SWPW30502026-11-04 05:38:48.235678
2026-11-04 04:50:00.0000002026-11-04 04:50:00.000000SPP299092026-11-04 05:38:48.235678
2026-11-04 04:50:00.0000002026-11-04 04:55:00.000000SWPW30502026-11-04 05:33:56.554116
2026-11-04 04:50:00.0000002026-11-04 04:55:00.000000SPP299092026-11-04 05:33:56.554116
2026-11-04 04:50:00.0000002026-11-04 04:50:00.000000SWPW30502026-11-04 05:33:56.554116
2026-11-04 04:50:00.0000002026-11-04 04:50:00.000000SPP299092026-11-04 05:33:56.554116
2026-11-04 04:50:00.0000002026-11-04 04:55:00.000000SWPW30502026-11-04 05:28:44.244939
2026-11-04 04:50:00.0000002026-11-04 04:55:00.000000SPP299092026-11-04 05:28:44.244939
2026-11-04 04:50:00.0000002026-11-04 04:50:00.000000SWPW30502026-11-04 05:28:44.244939
2026-11-04 04:50:00.0000002026-11-04 04:50:00.000000SPP299092026-11-04 05:28:44.244939
2026-11-04 04:50:00.0000002026-11-04 04:55:00.000000SWPW30502026-11-04 05:23:44.686554
2026-11-04 04:50:00.0000002026-11-04 04:55:00.000000SPP299092026-11-04 05:23:44.686554
2026-11-04 04:50:00.0000002026-11-04 04:50:00.000000SWPW30502026-11-04 05:23:44.686554
2026-11-04 04:50:00.0000002026-11-04 04:50:00.000000SPP299092026-11-04 05:23:44.686554
2026-11-04 04:45:00.0000002026-11-04 04:55:00.000000SWPW30572026-11-04 05:38:48.235678

Coverage

Complete
99.9%
Gap days
2
Days with data
3,593
Show coverage history
Coverage: 99.9%Days with data: 3,593Gaps: 2
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
gaplessmore