Ask the Grid

Overview

NYISO day-ahead limiting-constraint records for the market-clearing plan, including limiting facility, facility PTID, contingency, and constraint cost. Paired with day-ahead LBMP components, it helps explain expected congestion and transfer limits before real-time operations.

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.

Schema7

Column
Type
event_timeDateTime64(6, 'UTC')
time_zoneNullable(String)
limiting_facilityNullable(String)
facility_ptidInt64
contingencyLowCardinality(String)
constraint_costNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample rows

event_timetime_zonelimiting_facilityfacility_ptidcontingencyconstraint_costingested_at
2026-08-16 03:00:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCRIBA__-VOLNEY___345_211.712026-08-15 05:55:25.399094
2026-08-16 03:00:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCRIBA__-VOLNEY___345_211.712026-08-15 04:55:24.987354
2026-08-16 02:00:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCRIBA__-VOLNEY___345_2118.692026-08-15 05:55:25.399094
2026-08-16 02:00:00.000000EDTSCH - PJ - NY23316BASE CASE3.252026-08-15 05:55:25.399094
2026-08-16 02:00:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCRIBA__-VOLNEY___345_2118.692026-08-15 04:55:24.987354
2026-08-16 02:00:00.000000EDTSCH - PJ - NY23316BASE CASE3.252026-08-15 04:55:24.987354
2026-08-16 01:00:00.000000EDTELWOOD 69 PULASKLI 69 126610BUS:NRTHPRT 677 & PS2 & G22.792026-08-15 05:55:25.399094
2026-08-16 01:00:00.000000EDTNRTHPORT 138 PILGRIM 138 225308BUS:NPRT 672&NNC&601&602&6031.982026-08-15 05:55:25.399094
2026-08-16 01:00:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCRIBA__-VOLNEY___345_2125.382026-08-15 05:55:25.399094
2026-08-16 01:00:00.000000EDTSPRNBRK 345 UNIONHBS 345 125105BASE CASE0.022026-08-15 05:55:25.399094
2026-08-16 01:00:00.000000EDTSCH - PJ - NY23316BASE CASE2.052026-08-15 05:55:25.399094
2026-08-16 01:00:00.000000EDTHQCP ACTIVE DNI892ACTIVE DNI-2.742026-08-15 05:55:25.399094
2026-08-16 01:00:00.000000EDTELWOOD 69 PULASKLI 69 126610BUS:NRTHPRT 677 & PS2 & G22.792026-08-15 04:55:24.987354
2026-08-16 01:00:00.000000EDTNRTHPORT 138 PILGRIM 138 225308BUS:NPRT 672&NNC&601&602&6031.982026-08-15 04:55:24.987354
2026-08-16 01:00:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCRIBA__-VOLNEY___345_2125.382026-08-15 04:55:24.987354
2026-08-16 01:00:00.000000EDTSPRNBRK 345 UNIONHBS 345 125105BASE CASE0.022026-08-15 04:55:24.987354
2026-08-16 01:00:00.000000EDTSCH - PJ - NY23316BASE CASE2.052026-08-15 04:55:24.987354
2026-08-16 01:00:00.000000EDTHQCP ACTIVE DNI892ACTIVE DNI-2.742026-08-15 04:55:24.987354
2026-08-16 00:00:00.000000EDTELWOOD 69 PULASKLI 69 126610BUS:NRTHPRT 677 & PS2 & G213.452026-08-15 05:55:25.399094
2026-08-16 00:00:00.000000EDTPILGRIM 138 PILGRIM 138 125604TWR:HOLBROOK 880 & 882-0.152026-08-15 05:55:25.399094
2026-08-16 00:00:00.000000EDTNRTHPORT 138 PILGRIM 138 225308BUS:NPRT 672&NNC&601&602&6038.832026-08-15 05:55:25.399094
2026-08-16 00:00:00.000000EDTRAINEY 138 VERNON 138 125297BASE CASE-0.022026-08-15 05:55:25.399094
2026-08-16 00:00:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCRIBA__-VOLNEY___345_2130.062026-08-15 05:55:25.399094
2026-08-16 00:00:00.000000EDTSPRNBRK 345 UNIONHBS 345 125105BASE CASE0.112026-08-15 05:55:25.399094
2026-08-16 00:00:00.000000EDTELWOOD 69 PULASKLI 69 126610BUS:NRTHPRT 677 & PS2 & G213.452026-08-15 04:55:24.987354

Coverage

100.0% complete0 gap days4,246 days with data
Show coverage history ▾
Coverage: 100.0%Days with data: 4,246Gaps: 0
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016
2015
gaplessmore