Day-Ahead Binding Constraints

Transmission constraints binding in SPP's day-ahead market, published hourly for the delivery day with the opaque constraint ID, constraint type, NERC flowgate ID where present, binding state, source-published monitored and contingent facilities, contingency name, and the E/W interconnect marker.

Congestion & Constraints data

Download data

Native record

event_time x constraint_name x interconnect x constraint_type x nerc_id x monitored_facility x contingent_facility x contingency_name

Hourly (Day-Ahead) publication cadence

Evidence

Cleared day-ahead market

A market outcome, not a physical observation

Time basis

Point-in-time records

UTC · event_time

Overview

Pairs with the real-time table to compare which exact source identities the day-ahead market anticipated. This feed does not publish direction, flow, or limits, and its facility labels are source context rather than physical topology matches.

Query contract

Preserve one canonical row per (event_time, constraint_name, interconnect, constraint_type, nerc_id, monitored_facility, contingent_facility, contingency_name) before aggregating.

Analysis rules

Group only after preserving the declared grain: event_time, constraint_name, interconnect, constraint_type, nerc_id, monitored_facility, contingent_facility, contingency_name.

Schema21

Column

Type

event_timeDateTime64(6, 'UTC')

constraint_nameLowCardinality(String)

shadow_priceNullable(Float64)

directionNullable(String)

limit_mwNullable(Float64)

flow_mwNullable(Float64)

ingested_atDateTime64(6, 'UTC')

source_intervalNullable(String)

source_gmt_interval_endNullable(String)

constraint_typeNullable(String)

nerc_idNullable(String)

tlr_levelNullable(String)

binding_statusNullable(String)

monitored_facilityNullable(String)

contingent_facilityNullable(String)

contingency_nameNullable(String)

source_limit_mwNullable(Float64)

effective_limit_mwNullable(Float64)

initial_limit_mwNullable(Float64)

interconnectNullable(String)

source_fileNullable(String)

Sample data

event_time	constraint_name	shadow_price	direction	limit_mw	flow_mw	ingested_at	source_interval	source_gmt_interval_end	constraint_type	nerc_id	tlr_level	binding_status	monitored_facility	contingent_facility	contingency_name	source_limit_mw	effective_limit_mw	initial_limit_mw	interconnect	source_file
2026-09-20 04:00:00.000000	TP1146_32030	-42.0438	∅	∅	∅	2026-09-19 11:15:23.598348	09/20/2026 00:00:00	09/20/2026 05:00:00	FG	32030	∅	BINDING	LN FRANKLN5 - LITC	EDE WR:RAM452 NSES:161:1:5	7054	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 04:00:00.000000	TMP994_33360	-50.5014	∅	∅	∅	2026-09-19 11:15:23.598348	09/20/2026 00:00:00	09/20/2026 05:00:00	FG	33360	∅	BINDING	LN ELRENOJ2 - ELRENO1	OKGE:CTNWD1 CRESCENT:138:1:11	12483	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 04:00:00.000000	TMP569_30562	-29.8865	∅	∅	∅	2026-09-19 11:15:23.598348	09/20/2026 00:00:00	09/20/2026 05:00:00	FG	30562	∅	BINDING	LN COMMTAP4 - BOIS_TAP	OKGE CSWS:SUNNYSDE TERRY_RD:345:2:	2909	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 04:00:00.000000	TMP436_28110	-26.5962	∅	∅	∅	2026-09-19 11:15:23.598348	09/20/2026 00:00:00	09/20/2026 05:00:00	FG	28110	∅	BINDING	LN MULGRE2 - ELLSWTP3	SECI WR:MULGRE2 CIRC:230:1:9	19149	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 04:00:00.000000	TMP336_31246	-111.4022	∅	∅	∅	2026-09-19 11:15:23.598348	09/20/2026 00:00:00	09/20/2026 05:00:00	FG	31246	∅	BINDING	XFMR DUNCAN - DUNCAN	WFEC:ANADARKO FLETCH3 COMANCH2:138	10196	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 04:00:00.000000	TMP200_25341	-24.1662	∅	∅	∅	2026-09-19 11:15:23.598348	09/20/2026 00:00:00	09/20/2026 05:00:00	FG	25341	∅	BINDING	XFMR POTTER_S - POTTER_S	SPS:HITCH MOORE_CO:230:1:10	13134	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 04:00:00.000000	TMP128_29363	-191.3837	∅	∅	∅	2026-09-19 11:15:23.598348	09/20/2026 00:00:00	09/20/2026 05:00:00	FG	29363	∅	BINDING	LN RUSSETT - SBROWN	OKGE:BROWN2 BODLE CANEY1:138:7:34	333	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 04:00:00.000000	SWIWGRWERHOY	-0.5373	∅	∅	∅	2026-09-19 11:15:23.598348	09/20/2026 00:00:00	09/20/2026 05:00:00	FG	5721	∅	BINDING	LN SWIS - W_GARDNR	WR:HOYT STRA:345:1:7	14110	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 04:00:00.000000	SOONER_SONR_SONR_PHSHFT_PS	0.8439	∅	∅	∅	2026-09-19 11:15:23.598348	09/20/2026 00:00:00	09/20/2026 05:00:00	MCE	∅	∅	BINDING	PS SOONER - SOONER	BASE	BASE	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 04:00:00.000000	OSAWEBCLESOO	-136.0383	∅	∅	∅	2026-09-19 11:15:23.598348	09/20/2026 00:00:00	09/20/2026 05:00:00	FG	5147	∅	BINDING	LN OSAGE_OG - WEBBTAP4	GRDA OKGE:CLEVLND7 WHTETAIL:345:1:	33380	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 04:00:00.000000	AUR1241_11335_A_LN	-84.2388	∅	∅	∅	2026-09-19 11:15:23.598348	09/20/2026 00:00:00	09/20/2026 05:00:00	MCE	∅	∅	BINDING	LN AUR1241 - RDSPG5	BASE	BASE	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 04:00:00.000000	8654A_LN@WHEGL<14968>	-48.3979	∅	∅	∅	2026-09-19 11:15:23.598348	09/20/2026 00:00:00	09/20/2026 05:00:00	MA	∅	∅	BINDING	LN WHEGL - OSAGE_OG	OKGE:CONEM WHEGL:138:1:6	14968	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 03:00:00.000000	TP1146_32030	-80.1068	∅	∅	∅	2026-09-19 11:15:23.598348	09/19/2026 23:00:00	09/20/2026 04:00:00	FG	32030	∅	BINDING	LN FRANKLN5 - LITC	EDE WR:RAM452 NSES:161:1:5	7054	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 03:00:00.000000	TP1121_31979	-31.2471	∅	∅	∅	2026-09-19 11:15:23.598348	09/19/2026 23:00:00	09/20/2026 04:00:00	FG	31979	∅	BINDING	LN JAY_HAWK - FRANKLN5	EDE WR:RAM452 NSES:161:1:5	7054	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 03:00:00.000000	TP1119_31984	-2.6374	∅	∅	∅	2026-09-19 11:15:23.598348	09/19/2026 23:00:00	09/20/2026 04:00:00	FG	31984	∅	BINDING	LN JAGG - PENT	WR:87TH_ST STRA:345:1:9	2241	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 03:00:00.000000	TP1100_31918	-31.3	∅	∅	∅	2026-09-19 11:15:23.598348	09/19/2026 23:00:00	09/20/2026 04:00:00	FG	31918	∅	BINDING	XFMR FTSMTH - FTSMTH	OKGE:FTSMTH XF T5_T:345 161:3:13	14462	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 03:00:00.000000	TP1010_31418	-10.652	∅	∅	∅	2026-09-19 11:15:23.598348	09/19/2026 23:00:00	09/20/2026 04:00:00	FG	31418	∅	BINDING	LN WOLFFORT - TERRY_CO	SPS:TUCO YOAKUM:345:1:14	586	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 03:00:00.000000	TMP994_33360	-71.4072	∅	∅	∅	2026-09-19 11:15:23.598348	09/19/2026 23:00:00	09/20/2026 04:00:00	FG	33360	∅	BINDING	LN ELRENOJ2 - ELRENO1	OKGE:CTNWD1 CRESCENT:138:1:11	12483	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 03:00:00.000000	TMP758_28735	-21.3317	∅	∅	∅	2026-09-19 11:15:23.598348	09/19/2026 23:00:00	09/20/2026 04:00:00	FG	28735	∅	BINDING	XFMR NSES - NSES	WR:N345 XF N345_2T:345 161 13.8:3:	11820	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 03:00:00.000000	TMP695_29668	-6.4938	∅	∅	∅	2026-09-19 11:15:23.598348	09/19/2026 23:00:00	09/20/2026 04:00:00	FG	29668	∅	BINDING	LN QUAIL - SKYLN	OKGE:KETCH OMMITCH4 NOWST1 DANFO W	2871	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 03:00:00.000000	TMP569_30562	-32.8462	∅	∅	∅	2026-09-19 11:15:23.598348	09/19/2026 23:00:00	09/20/2026 04:00:00	FG	30562	∅	BINDING	LN COMMTAP4 - BOIS_TAP	OKGE CSWS:SUNNYSDE TERRY_RD:345:2:	2909	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 03:00:00.000000	TMP541_28628	-9.419	∅	∅	∅	2026-09-19 11:15:23.598348	09/19/2026 23:00:00	09/20/2026 04:00:00	FG	28628	∅	BINDING	LN LCSWITCH - ARNEGARD	BASE	BASE	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 03:00:00.000000	TMP336_31246	-99.985	∅	∅	∅	2026-09-19 11:15:23.598348	09/19/2026 23:00:00	09/20/2026 04:00:00	FG	31246	∅	BINDING	XFMR DUNCAN - DUNCAN	WFEC:ANADARKO FLETCH3 COMANCH2:138	10196	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 03:00:00.000000	TMP200_25341	-21.8729	∅	∅	∅	2026-09-19 11:15:23.598348	09/19/2026 23:00:00	09/20/2026 04:00:00	FG	25341	∅	BINDING	XFMR POTTER_S - POTTER_S	SPS:HITCH MOORE_CO:230:1:10	13134	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv
2026-09-20 03:00:00.000000	TMP140_32620	-5.3679	∅	∅	∅	2026-09-19 11:15:23.598348	09/19/2026 23:00:00	09/20/2026 04:00:00	FG	32620	∅	BINDING	LN PENN1 - SNTFE	OKGE:PLVAL NORMHLL:138:1:8	4475	∅	∅	∅	E	/2026/09/By_Day/DA-BC-202609190100.csv

Coverage

100.0% complete0 gap days3,550 days with data

Show coverage history

Coverage: 100.0%Days with data: 3,550Gaps: 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

gaplessmore

Related congestion & constraints data

Related congestion & constraints data
Dataset	Description
Constraint Identity EvidenceSPP · Built from daily DA/RT source evidence	Bitemporal, source-backed identities for SPP binding constraints. Each row preserves the raw operator ID and footprint, exact monitored-facility, contingent-facility, contingency and public flowgate context, evidence locator and version, observed and authoritative effective intervals, match method, confidence, review status, and resolution status. Source-exact and reviewed-exact mappings are distinguished from unresolved, contradictory, and rejected rows. The canonical constraint ID is an SPP source identity, not a physical line or substation ID.
Constraint Identity QualitySPP · Per identity build	One quality row per identity build: observed and distinct raw IDs, resolved/partial/unresolved/contradictory/rejected counts, resolution rate, stale reviewed mappings, one-to-many cases, missing footprint markers, SPP East/West ambiguity, and any source-key loss. This reports the evidence boundary rather than inflating resolution with text or geographic guesses.
Real-Time Binding ConstraintsSPP · 5-minute	Transmission constraints binding in SPP's real-time balancing market, published every five minutes with the opaque constraint ID, constraint type, NERC flowgate ID where present, TLR level, binding state, source-published monitored and contingent facilities, three limit fields, and the E/W interconnect marker. A non-zero shadow price is direct evidence that the source identity was binding and pricing congestion in that interval. SPP does not publish flow or direction in this feed, and a facility label is source context rather than a match to a physical topology entity.
SPP Day-Ahead Binding ConstraintsSPP · hourly	Which transmission facilities bound in SPP's day-ahead market and what each one cost, one row per interval and constraint. 1.11M rows, 2017-01 to the next delivery day. Columns: event_time, constraint_name, shadow_price_usd_mwh, plus constraint_type, nerc_id, binding_status, monitored_facility, contingent_facility, contingency_name, interconnect and source_file. The day-ahead feed does not publish direction, flow or limits. The shadow price is the marginal cost of the binding limit — what the market would have saved from one more megawatt of capability on that element. This is the table that answers WHY congestion appeared; a price spread between two locations shows that they separated but not which facility separated them.