Ask the Grid
Open live grid

Overview

NYISO real-time limiting-constraint records that identify the limiting facility, facility PTID, contingency, and constraint cost shaping dispatch and price separation. Use alongside real-time LBMP components to explain congestion rather than just observing price spreads.

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.

NYISO MCP

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-15 05:10:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-78.722026-08-15 06:17:53.005253
2026-08-15 05:10:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-78.722026-08-15 05:17:54.974980
2026-08-15 05:05:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-56.172026-08-15 06:17:53.005253
2026-08-15 05:05:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-56.172026-08-15 05:17:54.974980
2026-08-15 05:00:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-67.212026-08-15 06:17:53.005253
2026-08-15 05:00:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-67.212026-08-15 05:17:54.974980
2026-08-15 04:55:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-72.342026-08-15 06:17:53.005253
2026-08-15 04:55:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-72.342026-08-15 05:17:54.974980
2026-08-15 04:50:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-82.692026-08-15 06:17:53.005253
2026-08-15 04:50:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-82.692026-08-15 05:17:54.974980
2026-08-15 04:45:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-262026-08-15 06:17:53.005253
2026-08-15 04:45:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-262026-08-15 05:17:54.974980
2026-08-15 04:40:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-26.672026-08-15 06:17:53.005253
2026-08-15 04:40:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-26.672026-08-15 05:17:54.974980
2026-08-15 04:25:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-9.612026-08-15 06:17:53.005253
2026-08-15 04:25:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-9.612026-08-15 05:17:54.974980
2026-08-15 04:00:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-36.672026-08-15 06:17:53.005253
2026-08-15 04:00:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-36.672026-08-15 05:17:54.974980
2026-08-15 03:55:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-25.622026-08-15 06:17:51.857023
2026-08-15 03:55:00.000000EDTHILLSIDE 230 E.TWANDA 230 125014HOPATCON-LACKAWAN_500_5063-25.622026-08-15 05:17:53.517469
2026-08-15 03:40:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCRIBA__-VOLNEY___345_214.052026-08-15 06:17:51.857023
2026-08-15 03:40:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCRIBA__-VOLNEY___345_214.052026-08-15 05:17:53.517469
2026-08-15 03:30:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCRIBA__-VOLNEY___345_218.112026-08-15 06:17:51.857023
2026-08-15 03:30:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCRIBA__-VOLNEY___345_218.112026-08-15 05:17:53.517469
2026-08-15 03:25:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCRIBA__-VOLNEY___345_2111.812026-08-15 06:17:51.857023

Coverage

99.9% complete3 gap days4,242 days with data
Show coverage history ▾
Coverage: 99.9%Days with data: 4,242Gaps: 3
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016
2015
gaplessmore