Overview

Every SPP location that carries a price, as three columns: location_id, name, and kind. 12,442 rows — bus (10,457), node (1,983), hub (2). This is the dimension the SPP price, and where applicable constraint, tables join to, and it is the one place a location's type is decided: resolve "which hubs exist", "is this a zone or a node", or "give me the readable name for this id" here rather than inferring a type from a name prefix. For SPP, name equals location_id. The same three columns exist for every market, so the equivalent question in another ISO is the same query against that ISO's table.

SPP market Ask the agent about this dataset

Schema3

Column

Type

location_idLowCardinality(String)

nameLowCardinality(String)

kindLowCardinality(String)

Sample rows

location_id	name	kind
AEC	AEC	node
AECC_CSWS	AECC_CSWS	node
AECC_ELKINS	AECC_ELKINS	node
AECC_FITZHUGH	AECC_FITZHUGH	node
AECC_FLTCREEK	AECC_FLTCREEK	node
AECC_FULTON	AECC_FULTON	node
AECC_HYDRO13	AECC_HYDRO13	node
AECC_JWTURK	AECC_JWTURK	node
AECI	AECI	node
AEPM_CSWS	AEPM_CSWS	node
AESO	AESO	node
ALTW	ALTW	node
AMRN	AMRN	node
ANTELOPE	ANTELOPE	node
AVA	AVA	node
AVRN	AVRN	node
AZPS	AZPS	node
BANC	BANC	node
BBA	BBA	node
BCA	BCA	node
BCHA	BCHA	node
BEPM.ER01.BDR	BEPM.ER01.BDR	node
BEPM.ER01.DDR	BEPM.ER01.DDR	node
BEPM.N01.DDR	BEPM.N01.DDR	node
BEPM.UM01.DDR	BEPM.UM01.DDR	node

Coverage

No time-indexed data — coverage isn’t applicable to this dataset.

More data from SPP

Actual System LoadSPP's realized system-wide demand in MW at five-minute resolution, the actual-load counterpart to the short-term and mid-term load forecasts. Note that the feed republishes the same event_time on successive polls with a fresh ingested_at, so a read should collapse repeats on ingested_at before use.Ancillary Service Market Clearing PricesCleared ancillary-service prices by SPP reserve zone for both the real-time balancing market and the day-ahead market. SPP's product set does not map onto other ISOs': regulation clears as a separate service (capacity) price and mileage price in each direction (reg_up_service, reg_up_mile, reg_dn_service, reg_dn_mile), alongside ramp up and down, spinning, supplemental, and uncertainty products. IMPORTANT: reserve_zone mixes two grains. It carries the numeric ancillary reserve zones (1 through 5 under the SPP balancing authority, 21 under the separate SWPW balancing authority) AND the two balancing-authority roll-ups, 'SPP' and 'SWPW', whose prices equal those of their member zones. Aggregating across every value of reserve_zone double-counts the market.Cleared Operating ReservesCleared ancillary-service quantities in MW by SPP reserve zone: regulation up and down, ramp up and down, spinning, supplemental, and both uncertainty products (unc_up and the short-term sts_unc_up). The quantity counterpart to the ancillary clearing prices. The same reserve_zone caveat applies: the column carries both the numeric reserve zones and the 'SPP' and 'SWPW' balancing-authority roll-ups, so aggregating across every value double-counts.Day-Ahead Binding ConstraintsTransmission constraints binding in SPP's day-ahead market, published hourly for the delivery day with the constraint name, shadow price, direction, and the monitored limit and flow in MW. Pairs with the real-time binding-constraint table to compare which constraints the day-ahead market anticipated against those that actually bound in real time. As with the real-time table, no contingency or monitored-facility name is published.