SPP logo

Mid-Term Solar Forecast

SPP's mid-term solar generation forecast in MW, running roughly seven days ahead with the realized actual carried alongside.

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 against its delivery interval.

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.

HTTP endpoint
POST /api/v1/datasets/spp_solar_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-26 21:00:00.0000002026-09-19 20:00:00.000000SWPW676.982026-09-19 20:32:03.419040
2026-09-26 21:00:00.0000002026-09-19 20:00:00.000000SPP1837.782026-09-19 20:32:03.419040
2026-09-26 21:00:00.0000002026-09-19 20:00:00.000000SWPW676.982026-09-19 20:32:17.829906
2026-09-26 21:00:00.0000002026-09-19 20:00:00.000000SPP1837.782026-09-19 20:32:17.829906
2026-09-26 20:00:00.0000002026-09-19 20:00:00.000000SWPW698.852026-09-19 20:32:03.419040
2026-09-26 20:00:00.0000002026-09-19 20:00:00.000000SPP1929.22026-09-19 20:32:03.419040
2026-09-26 20:00:00.0000002026-09-19 19:00:00.000000SWPW698.852026-09-19 20:32:03.419040
2026-09-26 20:00:00.0000002026-09-19 19:00:00.000000SPP1929.22026-09-19 20:32:03.419040
2026-09-26 20:00:00.0000002026-09-19 20:00:00.000000SWPW698.852026-09-19 20:32:17.829906
2026-09-26 20:00:00.0000002026-09-19 20:00:00.000000SPP1929.22026-09-19 20:32:17.829906
2026-09-26 20:00:00.0000002026-09-19 19:00:00.000000SWPW698.852026-09-19 20:32:17.829906
2026-09-26 20:00:00.0000002026-09-19 19:00:00.000000SPP1929.22026-09-19 20:32:17.829906
2026-09-26 20:00:00.0000002026-09-19 19:00:00.000000SWPW698.852026-09-19 19:31:21.325818
2026-09-26 20:00:00.0000002026-09-19 19:00:00.000000SPP1929.22026-09-19 19:31:21.325818
2026-09-26 19:00:00.0000002026-09-19 20:00:00.000000SWPW704.232026-09-19 20:32:03.419040
2026-09-26 19:00:00.0000002026-09-19 20:00:00.000000SPP1972.532026-09-19 20:32:03.419040
2026-09-26 19:00:00.0000002026-09-19 19:00:00.000000SWPW704.232026-09-19 20:32:03.419040
2026-09-26 19:00:00.0000002026-09-19 19:00:00.000000SPP1972.532026-09-19 20:32:03.419040
2026-09-26 19:00:00.0000002026-09-19 18:00:00.000000SWPW683.552026-09-19 20:32:03.419040
2026-09-26 19:00:00.0000002026-09-19 18:00:00.000000SPP1999.682026-09-19 20:32:03.419040
2026-09-26 19:00:00.0000002026-09-19 20:00:00.000000SWPW704.232026-09-19 20:32:17.829906
2026-09-26 19:00:00.0000002026-09-19 20:00:00.000000SPP1972.532026-09-19 20:32:17.829906
2026-09-26 19:00:00.0000002026-09-19 19:00:00.000000SWPW704.232026-09-19 20:32:17.829906
2026-09-26 19:00:00.0000002026-09-19 19:00:00.000000SPP1972.532026-09-19 20:32:17.829906
2026-09-26 19:00:00.0000002026-09-19 18:00:00.000000SWPW683.552026-09-19 20:32:17.829906

Coverage

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