NYISO logo

Day-Ahead Limiting Constraints

NYISO day-ahead limiting-constraint records for the market-clearing plan, including limiting facility, facility PTID, contingency, and constraint cost.

Native record
event_time x facility_ptid x contingency
hourly (DAM) publication cadence
Evidence
Cleared day-ahead market
A market outcome, not a physical observation
Time basis
Point-in-time records
UTC · event_time

Overview

Paired with day-ahead LBMP components, it helps explain expected congestion and transfer limits before real-time operations.

Query contract

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

Analysis rules

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

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/nyiso_da_limiting_constraints/query

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 data

event_timetime_zonelimiting_facilityfacility_ptidcontingencyconstraint_costingested_at
2026-10-02 03:00:00.000000EDTFALCONER 115 MOONROAD 115 226031MOONROAD-FALCONER_115_175-44.842026-10-01 14:55:21.993753
2026-10-02 03:00:00.000000EDTRAINEY 138 VERNON 138 125297BASE CASE0.022026-10-01 14:55:21.993753
2026-10-02 03:00:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCB:SCRIBA(R935):21&FS-109.532026-10-01 14:55:21.993753
2026-10-02 03:00:00.000000EDTFALCONER 115 MOONROAD 115 226031MOONROAD-FALCONER_115_175-44.842026-10-01 13:55:21.997683
2026-10-02 03:00:00.000000EDTRAINEY 138 VERNON 138 125297BASE CASE0.022026-10-01 13:55:21.997683
2026-10-02 03:00:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCB:SCRIBA(R935):21&FS-109.532026-10-01 13:55:21.997683
2026-10-02 02:00:00.000000EDTPACKARD 230 PACKARD 115 125415SCB:NIAG_W(1414):195&AT2-0.062026-10-01 14:55:21.993753
2026-10-02 02:00:00.000000EDTRAINEY 138 VERNON 138 125297BASE CASE0.022026-10-01 14:55:21.993753
2026-10-02 02:00:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCB:SCRIBA(R935):21&FS-1024.212026-10-01 14:55:21.993753
2026-10-02 02:00:00.000000EDTPJAC ACTIVE DNI994ACTIVE DNI2.42026-10-01 14:55:21.993753
2026-10-02 02:00:00.000000EDTHQCP ACTIVE DNI892ACTIVE DNI-0.692026-10-01 14:55:21.993753
2026-10-02 02:00:00.000000EDTPACKARD 230 PACKARD 115 125415SCB:NIAG_W(1414):195&AT2-0.062026-10-01 13:55:21.997683
2026-10-02 02:00:00.000000EDTRAINEY 138 VERNON 138 125297BASE CASE0.022026-10-01 13:55:21.997683
2026-10-02 02:00:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCB:SCRIBA(R935):21&FS-1024.212026-10-01 13:55:21.997683
2026-10-02 02:00:00.000000EDTPJAC ACTIVE DNI994ACTIVE DNI2.42026-10-01 13:55:21.997683
2026-10-02 02:00:00.000000EDTHQCP ACTIVE DNI892ACTIVE DNI-0.692026-10-01 13:55:21.997683
2026-10-02 01:00:00.000000EDTPACKARD 230 PACKARD 115 125415SCB:NIAG_W(1414):195&AT2-0.052026-10-01 14:55:21.993753
2026-10-02 01:00:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCB:SCRIBA(R935):21&FS-1013.942026-10-01 14:55:21.993753
2026-10-02 01:00:00.000000EDTPACKARD 230 PACKARD 115 125415SCB:NIAG_W(1414):195&AT2-0.052026-10-01 13:55:21.997683
2026-10-02 01:00:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCB:SCRIBA(R935):21&FS-1013.942026-10-01 13:55:21.997683
2026-10-02 00:00:00.000000EDTCARLPLCE 138 STEWRTAV 138 125533BUS:VALLYSTR 291&901&BK5&BK7-0.922026-10-01 14:55:21.993753
2026-10-02 00:00:00.000000EDTPACKARD 230 PACKARD 115 125415SCB:NIAG_W(1414):195&AT2-0.062026-10-01 14:55:21.993753
2026-10-02 00:00:00.000000EDTBARRETT 138 VALLYSTR 138 225313VALLYSTR-BARRETT__138_2913.992026-10-01 14:55:21.993753
2026-10-02 00:00:00.000000EDTNEWBRDGE 138 STEWRTAV 138 325304BASE CASE14.012026-10-01 14:55:21.993753
2026-10-02 00:00:00.000000EDTSCRIBA 345 VOLNEY 345 125204SCB:SCRIBA(R935):21&FS-1025.282026-10-01 14:55:21.993753

Coverage

100.0% complete0 gap days9,194 days with data
Show coverage history
Coverage: 100.0%Days with data: 9,194Gaps: 0
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016
2015
2014
2013
2012
2011
2010
2009
2008
2007
2006
2005
2004
2003
2002
2001
gaplessmore