Day-Ahead Binding Constraints

The named transmission constraints that bound in MISO's day-ahead market, one row per constraint per operating hour, with the signed shadow price in dollars per MWh.

Congestion & Constraints data

Open in Data

One row per: event_time x constraint_id x branch_name; Hourly (day-ahead) cadence
Evidence: Cleared day-ahead market; A market outcome, not a physical observation
Time basis: Point-in-time records; UTC · event_time

Overview

constraint_name describes the flowgate as a monitored element under a contingency; branch_name is the monitored element itself, with branch_type LN for a line and XF for a transformer, and from_ca and to_ca its control areas. A row establishes that the constraint bound in the cleared day-ahead solution for that hour and its marginal system cost. It does not, by itself, identify which pricing node the constraint affected or whether it also bound in real time; those claims require shift-factor or direct attribution evidence. Distinct from miso.binding_constraint, which counts real-time binding constraints and names none of them. MISO restates this history, so read the latest load per constraint and hour.

Query contract: Preserve one canonical row per (event_time, constraint_id, branch_name) before aggregating.
Analysis rules: Group only after preserving the declared grain: event_time, constraint_id, branch_name.

Access

Download: Query it in SQL, download it, or read it with an API key. Download data
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

13 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`market_date`	`Date32`
`constraint_id`	`LowCardinality(String)`
`constraint_name`	`String`
`branch_name`	`String`
`branch_type`	`LowCardinality(String)`
`from_ca`	`LowCardinality(String)`
`to_ca`	`LowCardinality(String)`
`contingency`	`String`
`shadow_price`	`Nullable(Float64)`
`constraint_description`	`String`
`curve_type`	`LowCardinality(String)`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	market_date	constraint_id	constraint_name	branch_name	branch_type	from_ca	to_ca	contingency	shadow_price	curve_type	ingested_at
2026-11-03 04:00:00.000000	2026-11-02	77127	TEKAMAH-RAUN FLO FORT CALHOUN-RAUN	RAUN RAUNTEKAM16_1 1 (LN/MEC/OPPD)	LN	MEC	OPPD	FORT CALHOUN - RAUN 345	-93.79	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	61697	PVLYGRE-BYRON2 FLO BYRON-PLEASNTVLY	PVLYGRE PVLYGBYRO_16_1 1 (LN/GRE/NSP)	LN	GRE	NSP	BYRON-PLEASANT VALLEY 345	-65.97	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	563471	LELANDO LELANSTANT23_1 1 GREDC1M					COAL CREEK-DICKINSON HVDC BIPOLE	4.53	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	563015	GOODLAND-CARPEN_T FLO PAXTON-GIFFORD 138	GOODLAND 6966 A (LN/NIPS/NIPS)	LN	NIPS	NIPS	PAXTON - GIFFORD 138	-36.25	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	562815	TILTONEC WTLT_TEC_1644 A AMICIN01					KANSAS - SUGAR CREEK 345	-1.51	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	562490	JOCM-STFR FLO ASTER-COMMODORE 345 (4513)	JOCM JOCM_STFR_2 A (LN/AMMO/AMMO)	LN	AMMO	AMMO	ASTER - COMMODORE 345 (4513)	-107	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	561827	MONETT-AURORA FLO BLACKBRY-JASPER	MONETT 11337 A (LN/EDE/EDE)	LN	EDE	EDE	BLACKBERRY - JASPER 345	-649.46	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	560625	GARYAVE-CHICAGO FLO BURNHAM-MUNSTER	GARYAVE 138104 A (LN/NIPS/NIPS)	LN	NIPS	NIPS	BURNHAM-MUNSTER 345 (34504)	-147.25	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	558168	AUR1241-RDSPG5 FLO TABLE ROCK-NIXA	AUR1241 11335 A (LN/EDE/EDE)	LN	EDE	EDE	TABLE ROCK - NIXA 161	-0.08	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	551576	BELMONT6-MANY_7 FLO FISHR7-BELMONT6	BELMONT6 BELMNT-MANY A (LN/CLEC/CLEC)	LN	CLEC	CLEC	FISHERS - BELMONT 230	-43.35	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	521	MORRISOT-GRANTCO FLO FERGUS FALL-WAHPETO	MORRISOT MORRIGRANT11_1 1 (LN/OTP/OTP)	LN	OTP	OTP	FERGUS FALLS-WAHPETON 230	-6.28	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	485476	08OKLND-FRANCSCO FLO GIBSON -DOUGLAS	08OKLND 08OKLFRANC13_1 1 (LN/CIN/SIGE)	LN	CIN	SIGE	GIBSON - DOUGLAS 345	-73.61	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	481449	GOODLAND XFMR 1 FLO GOODLAND XFMR 2	GOODLAND B NO_1_XFMR (XF/NIPS/*)	XF	NIPS	*	GOODLAND 138/69 T2	-43.35	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	455839	WARDWA-BISMARK2 FLO NAPOLEON-WISHEK	WARDWA WARDWBISMA23_1 1 (LN/WAUE/WAUE)	LN	WAUE	WAUE	NAPOLEON - WISHEK 230	-2.99	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	454379	HANNAIPL-16FRANKL FLO STOUT TR	HANNAIPL 132-30 1 (LN/IPL/IPL)	LN	IPL	IPL	STOUT 345/138 TR	-47.05	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	430648	COYOTEM-BEULH7TH FLO CENTER2-SQBUTTEW	BEULH7TH BEUL7COYOT11_1 1 (LN/MDU/MDU)	LN	MDU	MDU	CENTER-SQUARE BUTTE WEST 230	-28.16	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	417922	MCHENRY TR1 FLO MCHENRY VELVA MAGIC CTY	MCHENRY TR1 TR11 (XF/GRE/*)	XF	GRE	*	MCHENRY-VELVA-MAGIC CITY 115	-46.78	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	398584	SSWF WEED_SSWF_1420 A BASE					ACTUAL	-0.79	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	387471	RUGBY230 TR1 TR12 FLO RUGBY TR2	RUGBY230 TR1 TR12 (XF/OTP/*)	XF	OTP	*	RUGBY 230/115 TR2	-40.01	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	365427	HOWL HOWL_SCWO_1589 A BASE					ACTUAL	-17.24	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	364608	RISING-BONDVIL FLO RISING-SIDNEY	RISING RISN_BONV_1642 A (LN/AMIL/AMIL)	LN	AMIL	AMIL	RISING-SIDNEY 345 (4567)	-11.45	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	359280	DRESSER-08SCRK_M FLO CAYUGA-CAYUGA CT	DRESSER DRESS08SCR34_1 1 (LN/CIN/CIN)	LN	CIN	CIN	CAYUGA - CAYUGA CT 345 (34533)	-50.27	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	345472	FENOCH INTF	FENTON TR5 TR5 (XF/NSP/); CHARAMB CHARAELSBO11_1 1 (LN/NSP/NSP); NOBLES TR9 TR9_2 (XF/NSP/); NOBLES TR10 TR10_2 (XF/NSP/*); CHARAMB CHARAPIPES11_1 1 (LN/NSP/NSP)	LN	NSP	NSP	ACTUAL	-7.1	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	345082	ESTBMRK-BISMARK 2 FLO MANDAN-WARDWA	ESTBMRK ESTBMBISMA11_1 1 (LN/MDU/WAUE)	LN	MDU	WAUE	MANDAN-WARDWA 230	-112.3	PERCENT	2026-11-02 12:47:25.125421
2026-11-03 04:00:00.000000	2026-11-02	332620	DOUD2-BNEJCT FLO STORYCO-MTOWN WMAIN	DOUD2 DOUD2BNE_J16_1 1 (LN/ALTW/ALTW)	LN	ALTW	ALTW	STORY CO-MARSHALTOWN WEST MAIN 161	-31.18	PERCENT	2026-11-02 12:47:25.125421

Coverage

Complete: 100.0%
Gap days: 0
Days with data: 63

Show coverage history

Coverage: 100.0%Days with data: 63Gaps: 0

2026

gaplessmore

Related data

Related congestion & constraints data
Dataset	Description
Annual real-time constraint historyMISO · year publication	MISO's Annual real-time constraint history. Each row preserves a publisher record, workbook row, or report document with its source member and row index. Source timestamps, units, geographic scope, and revision qualifiers are retained in record_json; event_time is collection time; completed_at is when the entire document became available.
Constraint Shift Factor RunsMISO · nightly (one row per completed run)	One row per COMPLETED nightly estimation of MISO constraint shift factors, and the only record that a run finished. Resolve the latest usable run here — computed_at = (SELECT max(computed_at) FROM atg.miso_constraint_sensitivity_runs) — and never off max(computed_at) of the sensitivities themselves, because a run writes its rows in blocks that all carry the new timestamp and an unfinished or abandoned run would otherwise look like the newest one. Each row also carries how much evidence that run had: interval_coverage is the fraction of published dispatch intervals that survived admission, intervals_refused_unexplained counts intervals showing congestion with no constraint recorded as binding (an unobserved binding set), constraint_feed_lag_minutes is how far the constraint feed trailed the price feed, and constraints_seen / constraints_in_fit / constraints_reported show how many constraints bound, how many were good enough to control for, and how many earned a published estimate.
Constraint Shift Factors (Estimated)MISO · nightly (60-day rolling estimation window)	Estimated sensitivity of every MISO pricing location's price to every binding transmission constraint: one row per constraint, contingency, and location, recomputed nightly over a rolling 60-day window. This is what answers 'which nodes drive this constraint' and 'which constraints is this node exposed to'. Covers MISO's binding real-time constraints over its hub and zone roll-up of roughly 325 pricing locations, so the answers are coarser than a full nodal set. MISO publishes no contingency or terminal names, so contingency_name, from_station and to_station are always empty. shift_factor is in the ISO's orientation — POSITIVE means an incremental MW injected at that node increases loading on the constraint and the node is paid below system lambda while it binds; NEGATIVE means generation there relieves the constraint and earns a premium. These are ESTIMATES recovered from the price identity LMP = energy - sum(shift_factor x shadow_price), not a published PTDF matrix. They are measured RELATIVE TO THE MARKET'S REFERENCE — the identity yields SF(node) - SF(reference), so a single absolute value should be quoted as 'relative to the system reference' rather than as the node's PTDF, while DIFFERENCES between nodes are exact because the reference term cancels. Three further differences from a published matrix: they describe a NODE (a generator at that node inherits its location's value, and two units at one node are indistinguishable), they reflect the topology actually in effect across the window including outages rather than a stated base case, and each row with estimation_status='estimated' carries a std_error from a 200-draw block bootstrap that resamples whole days. Read std_error before quoting shift_factor: an estimate whose absolute value is not at least twice its standard error is not distinguishable from zero. estimation_status says why a row has no number — 'thin_support' (in the fit, so it is controlled for, but under 12 binding intervals or under 3 distinct binding days), 'no_support' (under 3 binding intervals; not a regressor), or 'collinear' (it bound in lockstep with another constraint, so the two cannot be separated). Where from_station and to_station are populated they identify the monitored element and are NOT the constrained direction — the sign of shift_factor is what says which way. Every read must pin computed_at to one run, and must resolve that run through the companion atg.<iso>_constraint_sensitivity_runs ledger rather than off max(computed_at) here — rows are written in blocks that all carry the new timestamp, so an unfinished or abandoned run would otherwise look like the newest. Mixing runs averages a node across different network topologies.
Daily day-ahead binding constraintsMISO · day publication	MISO's Daily day-ahead binding constraints. Each row preserves a publisher record, workbook row, or report document with its source member and row index. Source timestamps, units, geographic scope, and revision qualifiers are retained in record_json; event_time is collection time; completed_at is when the entire document became available.