Ask the Grid
Open live grid
SPP logo

Mid-Term Wind Forecast

SPP's mid-term wind generation forecast in MW, running roughly seven days ahead with the realized actual carried for the same interval.

Generation dataSPP market
Query with the agent
Native record
event_time x publish_time
Hourly, out ~7 days publication cadence
Evidence
Forecast data
Forward-looking values with an explicit issue time
Time basis
Point-in-time records
UTC · event_time

Overview

Bitemporal, retaining each published vintage, which makes it suitable for measuring how wind forecast skill degrades with horizon across the Great Plains footprint.

Query contract

Preserve one canonical row per (event_time, publish_time) before aggregating.

Analysis rules

  • Group only after preserving the declared grain: event_time, publish_time.

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.

SPP MCP API reference
HTTP endpoint
POST /api/v1/datasets/spp_wind_forecast_mid_term/query

Schema5

Column
Type
event_timeDateTime64(6, 'UTC')
publish_timeDateTime64(6, 'UTC')
baaLowCardinality(String)
forecast_mwNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timepublish_timebaaforecast_mwingested_at
2026-09-27 00:00:00.0000002026-09-19 23:00:00.000000SWPW505.162026-09-19 23:31:24.963610
2026-09-27 00:00:00.0000002026-09-19 23:00:00.000000SPP11319.212026-09-19 23:31:24.963610
2026-09-27 00:00:00.0000002026-09-19 23:00:00.000000SWPW505.162026-09-19 23:31:07.084014
2026-09-27 00:00:00.0000002026-09-19 23:00:00.000000SPP11319.212026-09-19 23:31:07.084014
2026-09-26 23:00:00.0000002026-09-19 23:00:00.000000SWPW488.772026-09-19 23:31:24.963610
2026-09-26 23:00:00.0000002026-09-19 23:00:00.000000SPP11088.672026-09-19 23:31:24.963610
2026-09-26 23:00:00.0000002026-09-19 22:00:00.000000SWPW456.792026-09-19 23:31:24.963610
2026-09-26 23:00:00.0000002026-09-19 22:00:00.000000SPP14381.242026-09-19 23:31:24.963610
2026-09-26 23:00:00.0000002026-09-19 23:00:00.000000SWPW488.772026-09-19 23:31:07.084014
2026-09-26 23:00:00.0000002026-09-19 23:00:00.000000SPP11088.672026-09-19 23:31:07.084014
2026-09-26 23:00:00.0000002026-09-19 22:00:00.000000SWPW456.792026-09-19 23:31:07.084014
2026-09-26 23:00:00.0000002026-09-19 22:00:00.000000SPP14381.242026-09-19 23:31:07.084014
2026-09-26 23:00:00.0000002026-09-19 22:00:00.000000SWPW456.792026-09-19 22:31:32.124140
2026-09-26 23:00:00.0000002026-09-19 22:00:00.000000SPP14381.242026-09-19 22:31:32.124140
2026-09-26 22:00:00.0000002026-09-19 23:00:00.000000SWPW472.352026-09-19 23:31:24.963610
2026-09-26 22:00:00.0000002026-09-19 23:00:00.000000SPP10858.32026-09-19 23:31:24.963610
2026-09-26 22:00:00.0000002026-09-19 22:00:00.000000SWPW480.782026-09-19 23:31:24.963610
2026-09-26 22:00:00.0000002026-09-19 22:00:00.000000SPP13947.82026-09-19 23:31:24.963610
2026-09-26 22:00:00.0000002026-09-19 21:00:00.000000SWPW480.782026-09-19 23:31:24.963610
2026-09-26 22:00:00.0000002026-09-19 21:00:00.000000SPP13947.82026-09-19 23:31:24.963610
2026-09-26 22:00:00.0000002026-09-19 23:00:00.000000SWPW472.352026-09-19 23:31:07.084014
2026-09-26 22:00:00.0000002026-09-19 23:00:00.000000SPP10858.32026-09-19 23:31:07.084014
2026-09-26 22:00:00.0000002026-09-19 22:00:00.000000SWPW480.782026-09-19 23:31:07.084014
2026-09-26 22:00:00.0000002026-09-19 22:00:00.000000SPP13947.82026-09-19 23:31:07.084014
2026-09-26 22:00:00.0000002026-09-19 21:00:00.000000SWPW480.782026-09-19 23:31:07.084014

Coverage

100.0% complete0 gap days3,358 days with data
Show coverage history
Coverage: 100.0%Days with data: 3,358Gaps: 0
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
gaplessmore