Constraint Identity Quality

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.

Congestion & Constraints data SPP market

Query with the agent

Native record

known_at x build_id

Per identity build publication cadence

Evidence

Observed market data

Published observations from the named source

Time basis

Point-in-time records

UTC · known_at

Overview

This reports the evidence boundary rather than inflating resolution with text or geographic guesses.

Query contract

Preserve one canonical row per (known_at, build_id) before aggregating.

Analysis rules

Group only after preserving the declared grain: known_at, build_id.

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.

SPP MCP API reference

HTTP endpoint

POST /api/v1/datasets/spp_constraint_identity_quality/query

Need the full history of this dataset in Snowflake, Databricks or your own storage? Data services delivers it on a schedule.

Schema16

Column

Type

known_atDateTime64(6, 'UTC')

build_idString

observed_rowsInt64

distinct_raw_idsInt64

resolved_countInt64

partial_countInt64

unresolved_countInt64

contradictory_countInt64

rejected_countInt64

resolution_rateFloat64

stale_reviewed_mapping_countInt64

one_to_many_countInt64

missing_interconnect_countInt64

east_west_ambiguity_countInt64

source_key_loss_countInt64

ingested_atDateTime64(6, 'UTC')

Sample data

known_at	build_id	observed_rows	distinct_raw_ids	resolved_count	partial_count	contradictory_count	resolution_rate	one_to_many_count	missing_interconnect_count	ingested_at
2026-10-17 12:30:18.229567	20261017T123018229567Z-2b669caba51e	1333	245	991	342	0	0.7434358589647412	59	0	2026-10-17 12:30:34.245584
2026-10-16 12:30:18.411375	20261016T123018411375Z-524ebf93c1d8	1414	267	1043	371	0	0.7376237623762376	58	0	2026-10-16 12:30:36.198679
2026-10-15 12:30:18.448540	20261015T123018448540Z-3c7213062e73	1386	255	1004	382	0	0.7243867243867244	55	0	2026-10-15 12:30:40.438501
2026-10-14 12:30:16.703532	20261014T123016703532Z-d50a31120b33	1422	239	984	438	0	0.6919831223628692	52	0	2026-10-14 12:30:36.587766
2026-10-13 12:30:16.939076	20261013T123016939076Z-ba03c7d2e80b	1427	226	944	483	0	0.6615276804484933	51	0	2026-10-13 12:30:41.094926
2026-10-12 12:30:17.288946	20261012T123017288946Z-a9475b3b9db0	1303	220	836	467	0	0.6415963161933999	45	0	2026-10-12 12:30:34.691174
2026-10-11 12:30:17.023848	20261011T123017023848Z-28e1f2a3a5ec	1169	205	744	425	0	0.6364414029084687	42	0	2026-10-11 12:30:35.673929
2026-10-10 12:30:15.158048	20261010T123015158048Z-0b550513c55d	143661	3842	109867	33220	574	0.7647656636108617	1309	95340	2026-10-10 12:31:04.452311

Coverage

100.0% complete0 gap days8 days with data

Show coverage history

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

2026

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.
Day-Ahead Binding ConstraintsSPP · Hourly (Day-Ahead)	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. 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.
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. Inspect the current measured time coverage. 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.