Ask the Grid

Overview

MISO's current and forecast system demand, committed and available capacity, plus next-day short-term reserve requirements. Filter record_type before aggregating: supply_demand and next_day_short_term_reserve are distinct grains.

Use with MCP

This table is available through the signed-in, read-only Ask the Grid MCP server. Connect a market below, then use search_data or describe_data to load its query contract before calling query_data.

Schema15

Column
Type
event_timeDateTime64(6, 'UTC')
record_typeLowCardinality(String)
raw_idLowCardinality(String)
raw_time_estLowCardinality(String)
regionLowCardinality(String)
forecast_created_timeNullable(String)
demand_mwNullable(Float64)
committed_capacity_mwNullable(Float64)
demand_forecast_mwNullable(Float64)
committed_capacity_forecast_mwNullable(Float64)
available_capacity_mwNullable(Float64)
short_term_reserve_requirement_mwNullable(Float64)
short_term_reserve_overwrite_mwNullable(Float64)
raw_record_jsonString
ingested_atDateTime64(6, 'UTC')

Sample rows

event_timerecord_typeraw_idraw_time_estregionforecast_created_timedemand_mwcommitted_capacity_mwdemand_forecast_mwcommitted_capacity_forecast_mwavailable_capacity_mwshort_term_reserve_requirement_mwshort_term_reserve_overwrite_mwraw_record_jsoningested_at
2026-08-14 21:00:00.000000next_day_short_term_reserve2026-08-14T16:00:00North/Central2026-08-13T07:05:5800{"forecastCreatedTime":"2026-08-13T07:05:58","forecastPeakHourEst":"2026-08-14T16:00:00","region":"North/Central","strOverwrite":0,"strReq":0}2026-08-13 18:26:09.238816
2026-08-14 21:00:00.000000next_day_short_term_reserve2026-08-14T16:00:00Systemwide2026-08-13T07:05:5800{"forecastCreatedTime":"2026-08-13T07:05:58","forecastPeakHourEst":"2026-08-14T16:00:00","region":"Systemwide","strOverwrite":0,"strReq":0}2026-08-13 18:26:09.238816
2026-08-14 21:00:00.000000next_day_short_term_reserve2026-08-14T16:00:00South2026-08-13T07:05:5800{"forecastCreatedTime":"2026-08-13T07:05:58","forecastPeakHourEst":"2026-08-14T16:00:00","region":"South","strOverwrite":0,"strReq":0}2026-08-13 18:26:09.238816
2026-08-14 21:00:00.000000next_day_short_term_reserve2026-08-14T16:00:00Systemwide2026-08-13T07:05:5800{"forecastCreatedTime":"2026-08-13T07:05:58","forecastPeakHourEst":"2026-08-14T16:00:00","region":"Systemwide","strOverwrite":0,"strReq":0}2026-08-13 18:29:08.916472
2026-08-14 21:00:00.000000next_day_short_term_reserve2026-08-14T16:00:00North/Central2026-08-13T07:05:5800{"forecastCreatedTime":"2026-08-13T07:05:58","forecastPeakHourEst":"2026-08-14T16:00:00","region":"North/Central","strOverwrite":0,"strReq":0}2026-08-13 18:29:08.916472
2026-08-14 21:00:00.000000next_day_short_term_reserve2026-08-14T16:00:00South2026-08-13T07:05:5800{"forecastCreatedTime":"2026-08-13T07:05:58","forecastPeakHourEst":"2026-08-14T16:00:00","region":"South","strOverwrite":0,"strReq":0}2026-08-13 18:29:08.916472
2026-08-14 21:00:00.000000next_day_short_term_reserve2026-08-14T16:00:00Systemwide2026-08-13T07:05:5800{"forecastCreatedTime":"2026-08-13T07:05:58","forecastPeakHourEst":"2026-08-14T16:00:00","region":"Systemwide","strOverwrite":0,"strReq":0}2026-08-13 18:28:09.870967
2026-08-14 21:00:00.000000next_day_short_term_reserve2026-08-14T16:00:00North/Central2026-08-13T07:05:5800{"forecastCreatedTime":"2026-08-13T07:05:58","forecastPeakHourEst":"2026-08-14T16:00:00","region":"North/Central","strOverwrite":0,"strReq":0}2026-08-13 18:28:09.870967
2026-08-14 21:00:00.000000next_day_short_term_reserve2026-08-14T16:00:00South2026-08-13T07:05:5800{"forecastCreatedTime":"2026-08-13T07:05:58","forecastPeakHourEst":"2026-08-14T16:00:00","region":"South","strOverwrite":0,"strReq":0}2026-08-13 18:28:09.870967
2026-08-14 21:00:00.000000next_day_short_term_reserve2026-08-14T16:00:00Systemwide2026-08-13T07:05:5800{"forecastCreatedTime":"2026-08-13T07:05:58","forecastPeakHourEst":"2026-08-14T16:00:00","region":"Systemwide","strOverwrite":0,"strReq":0}2026-08-13 18:30:11.605936
2026-08-14 21:00:00.000000next_day_short_term_reserve2026-08-14T16:00:00North/Central2026-08-13T07:05:5800{"forecastCreatedTime":"2026-08-13T07:05:58","forecastPeakHourEst":"2026-08-14T16:00:00","region":"North/Central","strOverwrite":0,"strReq":0}2026-08-13 18:30:11.605936
2026-08-14 21:00:00.000000next_day_short_term_reserve2026-08-14T16:00:00South2026-08-13T07:05:5800{"forecastCreatedTime":"2026-08-13T07:05:58","forecastPeakHourEst":"2026-08-14T16:00:00","region":"South","strOverwrite":0,"strReq":0}2026-08-13 18:30:11.605936
2026-08-14 21:00:00.000000next_day_short_term_reserve2026-08-14T16:00:00Systemwide2026-08-13T07:05:5800{"forecastCreatedTime":"2026-08-13T07:05:58","forecastPeakHourEst":"2026-08-14T16:00:00","region":"Systemwide","strOverwrite":0,"strReq":0}2026-08-13 18:27:11.611631
2026-08-14 21:00:00.000000next_day_short_term_reserve2026-08-14T16:00:00North/Central2026-08-13T07:05:5800{"forecastCreatedTime":"2026-08-13T07:05:58","forecastPeakHourEst":"2026-08-14T16:00:00","region":"North/Central","strOverwrite":0,"strReq":0}2026-08-13 18:27:11.611631
2026-08-14 21:00:00.000000next_day_short_term_reserve2026-08-14T16:00:00South2026-08-13T07:05:5800{"forecastCreatedTime":"2026-08-13T07:05:58","forecastPeakHourEst":"2026-08-14T16:00:00","region":"South","strOverwrite":0,"strReq":0}2026-08-13 18:27:11.611631
2026-08-14 04:00:00.000000supply_demand702026-08-13T23:00:0093895102523118701{"availableCapacity":118701,"committedCapacity":null,"committedCapacityForecast":102523,"demand":null,"demandForecast":93895,"id":70,"timeEst":"2026-08-13T23:00:00"}2026-08-13 18:26:09.238816
2026-08-14 04:00:00.000000supply_demand312026-08-13T23:00:0094316103355120088{"availableCapacity":120088,"committedCapacity":null,"committedCapacityForecast":103355,"demand":null,"demandForecast":94316,"id":31,"timeEst":"2026-08-13T23:00:00"}2026-08-13 05:31:08.759456
2026-08-14 04:00:00.000000supply_demand572026-08-13T23:00:0094356103186119421{"availableCapacity":119421,"committedCapacity":null,"committedCapacityForecast":103186,"demand":null,"demandForecast":94356,"id":57,"timeEst":"2026-08-13T23:00:00"}2026-08-13 13:58:09.106669
2026-08-14 04:00:00.000000supply_demand322026-08-13T23:00:0094260103375120108{"availableCapacity":120108,"committedCapacity":null,"committedCapacityForecast":103375,"demand":null,"demandForecast":94260,"id":32,"timeEst":"2026-08-13T23:00:00"}2026-08-13 05:46:11.275700
2026-08-14 04:00:00.000000supply_demand332026-08-13T23:00:0094278103346120079{"availableCapacity":120079,"committedCapacity":null,"committedCapacityForecast":103346,"demand":null,"demandForecast":94278,"id":33,"timeEst":"2026-08-13T23:00:00"}2026-08-13 06:01:10.206091
2026-08-14 04:00:00.000000supply_demand342026-08-13T23:00:0094235103510120243{"availableCapacity":120243,"committedCapacity":null,"committedCapacityForecast":103510,"demand":null,"demandForecast":94235,"id":34,"timeEst":"2026-08-13T23:00:00"}2026-08-13 06:31:12.293838
2026-08-14 04:00:00.000000supply_demand352026-08-13T23:00:0094367103407120140{"availableCapacity":120140,"committedCapacity":null,"committedCapacityForecast":103407,"demand":null,"demandForecast":94367,"id":35,"timeEst":"2026-08-13T23:00:00"}2026-08-13 06:46:09.496233
2026-08-14 04:00:00.000000supply_demand362026-08-13T23:00:0094371103372120105{"availableCapacity":120105,"committedCapacity":null,"committedCapacityForecast":103372,"demand":null,"demandForecast":94371,"id":36,"timeEst":"2026-08-13T23:00:00"}2026-08-13 07:01:09.756013
2026-08-14 04:00:00.000000supply_demand372026-08-13T23:00:0094388103390120123{"availableCapacity":120123,"committedCapacity":null,"committedCapacityForecast":103390,"demand":null,"demandForecast":94388,"id":37,"timeEst":"2026-08-13T23:00:00"}2026-08-13 07:32:11.223835
2026-08-14 04:00:00.000000supply_demand382026-08-13T23:00:0094540103384120117{"availableCapacity":120117,"committedCapacity":null,"committedCapacityForecast":103384,"demand":null,"demandForecast":94540,"id":38,"timeEst":"2026-08-13T23:00:00"}2026-08-13 07:47:09.501897

Coverage

100.0% complete0 gap days3 days with data
Show coverage history ▾
Coverage: 100.0%Days with data: 3Gaps: 0
2026
gaplessmore