Public-Report Publication Receipts

Incoming parsing/upload receipts, including failed publications.

Infrastructure data SPP market

Query with the agent

Native record

publication attempt × report × snapshot

source publication publication cadence

Evidence

Reference data

Stable context used to interpret other datasets

Time basis

Point-in-time records

UTC · static reference

Overview

Complete acknowledges incoming rows; independently verify the mirrored FINAL source-row count before claiming warehouse-visible coverage. Missing or failed receipts mean unknown, not absent physical events.

Query contract

Incoming parsing/upload receipts, including failed publications. Complete acknowledges incoming rows; independently verify the mirrored FINAL source-row count before claiming warehouse-visible coverage. Missing or failed receipts mean unknown, not absent physical events.

Analysis rules

Keep SPP East and SWPW West separate. Never combine a published Total with its footprint components.
Do not sum model rows, publication attempts, repeated forecast vintages or duplicate weekly report entries as physical capacity.

Interpretation

Incoming parsing/upload receipts, including failed publications. Complete acknowledges incoming rows; independently verify the mirrored FINAL source-row count before claiming warehouse-visible coverage. Missing or failed receipts mean unknown, not absent physical events.
Model identities are not authoritative physical asset IDs, coordinates, outage attribution or nodal sensitivities.

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

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

Schema11

Column

Type

event_timeDateTime64(6, 'UTC')

reportString

snapshot_idString

source_fileString

content_hashString

published_atDateTime64(6, 'UTC')

source_rowsInt64

loaded_rowsInt64

statusString

errorNullable(String)

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	report	snapshot_id	source_file	content_hash	published_at	source_rows	loaded_rows	status	error	ingested_at
2026-10-09 18:37:17.445518	transmission_outages	eddb30aa18c02d33f3c4a1870c02aa74770c50eebab9d13ab1a92208c33423e5	https://transoutage.spp.org/report.aspx?download=true&actualendgreaterthan=09%2F09%2F2026&includenulls=true	3fbec19de425f477443c0f4256ae069bcd05e1cd3b11c585f37b6314806e09a7	2026-10-09 18:37:17.445518	9012	9012	complete	∅	2026-10-09 18:37:22.432801
2026-10-09 18:39:12.142068	ace	dc68cfca7126a25455897a178a7b5e868d6ade4fc187272b288c80eab9968d1a	Operational_Data/ACE/ACE_SPP.csv	476bb0a02f972d8f90504dec0cf03018d85678df8a74da1bbaa8079c001ccce8	2026-10-09 18:38:16.283000	121	121	complete	∅	2026-10-09 18:39:13.373890
2026-10-09 18:40:11.609735	ace	d5e3a3a3b488afb7fe7e4c4d21734b41800fe470f51423da5bc437f926b25fda	Operational_Data/ACE/ACE_SWPW.csv	8532d3e948e7789662c16ee85c17b2e1858a15f2df787f3740f65e6a18ad8e1e	2026-10-09 18:39:18.066000	121	121	complete	∅	2026-10-09 18:40:11.803900
2026-10-09 18:42:37.400365	generation_mix_by_baa	44cb39c4d3d2c366381af7b3ed1ceafb250faa37eaad4baee85d4f6ba58d79e8	Operational_Data/Portal_Chart/SPP/GenMix2Hour_SPP.csv	0de41c4a4159d6084c29a6cd07d8dff3e648775aba02cee6c6e75d16abafba1b	2026-10-09 18:40:31.071000	24	24	complete	∅	2026-10-09 18:42:37.587630
2026-10-09 18:43:38.899108	generation_mix_by_baa	d700a1e39de77a4da0a35bc5c99b84137242bc92dc0f3bac0a8c16221cfb3330	Operational_Data/Portal_Chart/SWPW/GenMix2Hour_SWPW.csv	0ba45b78f9690b1effc8272a2cf378dcd2d438581afa8ae52fedea8df1565c0f	2026-10-09 18:40:33.731000	24	24	complete	∅	2026-10-09 18:43:39.095009
2026-10-09 18:45:07.236500	hourly_generation_capacity	b759b9425909030d623ebf7ab0237ad4d1cad0f37a960129359851ddf36eb67f	Operational_Data/Hourly_Gen_Cap_by_Fuel_Type/HRLY-GEN-CAP-BY-FUEL-TYPE-LATEST-INTERVAL.csv	3692c112d7838807018fae12e660c6aee69e45efef97505e51442d215b30b6c1	2026-10-09 18:00:21.838000	2	2	complete	∅	2026-10-09 18:45:07.455478
2026-10-09 18:46:53.702259	available_maintenance_margin	beadc30d70c9cdbd4255774d5d4e4cd9e6b5d6909a8e009aa8c48643205b6376	Operational_Data/Available_Outage_Maintenance_Margin/AvailableOutageMaintenanceMargin_SPP.csv	cfa8d41698aee3ce72dac0aa767b6f452b945f44bfd4ea2757d852d8f5b55be8	2026-10-09 18:30:22.280000	1704	1704	complete	∅	2026-10-09 18:46:53.936182
2026-10-09 18:48:02.236703	available_maintenance_margin	5600bfa832cc4a46c883aace5e6eb47e10e3271f0e3bfd62b41dc5ff97dcba68	Operational_Data/Available_Outage_Maintenance_Margin/AvailableOutageMaintenanceMargin_SWPW.csv	aa9b87dadce5d068757c31d7009eb9663d99445fcd5228cead6b14dfb4053255	2026-10-09 17:00:29.828000	1704	1704	complete	∅	2026-10-09 18:48:02.491364
2026-10-09 18:49:34.550652	capacity_obligation	6e936eca32da6ad112eca476a65e04251c9ebbbe919d042b28161f82a3ca1878	Operational_Data/Capacity_Obligation_SPPGO/capacity_obligation_sppgo_SPP.csv	62aa7d64741dced757466d4151ca73ff1634c37a8427cad377776dbc9421ed6a	2026-10-09 18:47:28.521000	1	1	complete	∅	2026-10-09 18:49:34.745576
2026-10-09 18:50:32.522271	capacity_obligation	13e09c44178a7fe4461e13b614cc467706db9258d96bb8f9c102020a2d6d2538	Operational_Data/Capacity_Obligation_SPPGO/capacity_obligation_sppgo_SWPW.csv	7044e7284ddc85caea45cd50cbd33e5954f6e97da8d7f7ab77c6c18f85fa2cc3	2026-10-09 18:47:28.533000	1	1	complete	∅	2026-10-09 18:50:32.670404
2026-10-09 18:57:18.170932	ace	2dc8d7a77d3bd601490c629e3f67317590565dad6c8e17da4bae5fdb0b1eab36	Operational_Data/ACE/ACE_SPP.csv	d912ecfad7c54fea4054057e2def907eadaa84a7c7bc6c22629637129e9da9e8	2026-10-09 18:56:16.993000	121	121	complete	∅	2026-10-09 18:57:18.987868
2026-10-09 18:57:20.700095	ace	2841f60a6f4e1a2522b9a929637761563eaa1e0452fdfe5f4e35917fdfb62311	Operational_Data/ACE/ACE_SWPW.csv	26c4afeb881ee4cc7dd536bef0d5c0c5cc4a708eb559180b1ab258f2bcc4dd8f	2026-10-09 18:56:21.663000	121	121	complete	∅	2026-10-09 18:57:20.860115
2026-10-09 18:57:24.152436	generation_mix_by_baa	66e0b57162e8f1abe9d68cd42e19a42e7e9fe1eba41c2c533990156257cdb56a	Operational_Data/Portal_Chart/SPP/GenMix2Hour_SPP.csv	c1549b23cc1d00884f22524e0614de4a81c45425f4f789e5cbf3ee4f00b3cd81	2026-10-09 18:55:29.831000	24	24	complete	∅	2026-10-09 18:57:24.335803
2026-10-09 18:57:26.163918	generation_mix_by_baa	27d1bb8af830d29a71ec0f4953a76dfd89ad71a20478315cabe4493269388a14	Operational_Data/Portal_Chart/SWPW/GenMix2Hour_SWPW.csv	46d896d8b652e3b55de6f49b09d7b572cb3c79e1b015b4328fb3db9494b4f256	2026-10-09 18:55:30.320000	24	24	complete	∅	2026-10-09 18:57:26.327901
2026-10-09 18:57:32.522441	capacity_obligation	7c52bc96601bc4dee7ee67fc675f4415115103e80c1f2de65a2d57f978a9ce28	Operational_Data/Capacity_Obligation_SPPGO/capacity_obligation_sppgo_SPP.csv	fc5dffcc3e168d25cf6431d6eb5d83d11478a1a4fa5a8b70adcbce75879003fa	2026-10-09 18:57:20.603000	1	1	complete	∅	2026-10-09 18:57:32.688958
2026-10-09 18:57:34.533336	capacity_obligation	265baf5c004ade04c30795af0af7b7bacd9eb3fcd50c262799f6f99c38cf638f	Operational_Data/Capacity_Obligation_SPPGO/capacity_obligation_sppgo_SWPW.csv	3eb1982f53e945d57eca4d5985f61d4e93e88e3af64d31d0b0fe2f232f7c5277	2026-10-09 18:57:20.615000	1	1	complete	∅	2026-10-09 18:57:34.690328
2026-10-09 19:06:02.395396	model_pnode_mappings	a33296dde4f9e30f6df0f971578c57863a3cb615f64825a9dfbc7318b39c1a72	Modeling_Reports/SL_to_Pnode_to_Zone_with_Area.csv	a892b71fc94091efb5f4323c19f8533112dd0b54afe88c20ceb258a5ae07ae32	2026-10-02 15:05:44.094000	297396	297396	complete	∅	2026-10-09 19:06:15.087089
2026-10-09 19:06:17.879636	model_station_mappings	c7a5a40bf25695d028d2fe19d75f5e68d8a0f27be92b9e03e91d1342d6a4cb1a	Modeling_Reports/SL_Station_BusNumber_Turbine_and_FuelType.xlsx	fb51905c06064e9c656ddfde5ce6577af4606c03a0e81c9acecb6edf7a548f1e	2026-10-02 14:34:56.269000	1196	1196	complete	∅	2026-10-09 19:06:18.181518
2026-10-09 19:06:20.763555	model_hub_members	28ddc8a44f31e02f634f14e583db4beaf5c6db4225cba11f6567dc5a2cb7b4a2	Modeling_Reports/Hub_Definitions.csv	3ec5495a5d40cf9805fc5b0d3d0da0e643d54c03cf4cab7521a9bccc971107d6	2026-10-02 15:05:22.633000	3637	3637	complete	∅	2026-10-09 19:06:20.993293
2026-10-09 19:06:24.918461	model_interface_members	6fa4fdb4d71d75a7c888d07b99a898f6b948a9ef8169afc46d29dc46c059df53	Modeling_Reports/Interface_Definitions.csv	b996a922c3492c71e96dfe4d104c3eff7a3c0a5942b03687f6487bf24e6ba47c	2026-10-02 15:05:26.564000	284425	284425	complete	∅	2026-10-09 19:06:33.525342
2026-10-09 19:06:36.172980	model_eir_mappings	849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af4	Modeling_Reports/SL_EIR_Mapping.csv	e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c	2026-10-02 15:05:21.307000	2810	2810	complete	∅	2026-10-09 19:06:36.370341
2026-10-09 19:06:39.069406	model_participant_mappings	461d4a1935049532d49c23febdf01d669447bfb1454f5e5d12e5b650f079805b	Modeling_Reports/MP_AO_TC_Mapping.csv	0cd0d80f9d846c19bd5f89f76948ffb2057f0ff6781e75b5fe1b5b266a0526d4	2026-10-02 15:05:20.678000	1127	1127	complete	∅	2026-10-09 19:06:39.262735
2026-10-09 19:06:41.839764	model_meter_agents	0aebbaf7a64da2c2c203f0619aae423a91b54b1ded21dd218f45be6fd9e32154	Modeling_Reports/Meter_Agents.csv	510b1c690c23cdaab2730f142a29ae87473f6a98c890834baacf8a1eeed05d1d	2026-10-02 15:05:22.617000	74	74	complete	∅	2026-10-09 19:06:42.033870
2026-10-09 19:07:17.802732	ace	a179a90ef5061876b38ca8d74f8f1387311e49ea665564851da30ff84dea1c89	Operational_Data/ACE/ACE_SPP.csv	5daf8093182a1718b082d6906c08c9693fdd98e91979ac3ddea778c33870de97	2026-10-09 19:06:22.220000	121	121	complete	∅	2026-10-09 19:07:18.783862
2026-10-09 19:07:20.441470	ace	c0af471c59cdbe3078119f7c613e54b3ec368a727d75aa68083590b545dc3efa	Operational_Data/ACE/ACE_SWPW.csv	c351905fa22dbd75b33491d86d7a4d93b550b65322ff17edb1cbd79b158a3c3a	2026-10-09 19:06:16.268000	121	121	complete	∅	2026-10-09 19:07:20.608474

Coverage

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

Related infrastructure data

Related infrastructure data
Dataset	Description
Hub Membership and Published WeightsSPP · source model publication	Published parent/child Pnode membership and unnormalized weighting factors. The report includes resource aggregates as well as trading hubs; a HUB label does not mean one of the two trading hubs. Complete views require a matching receipt and mirrored row count; empty results are unknown coverage. Raw sources retain publication history internally.
Interface Membership and Published WeightsSPP · source model publication	Published interface settlement-location and parent/child Pnode relationships with unnormalized source weighting factors. Membership does not establish physical transmission capacity or price causation. Complete views require a matching receipt and mirrored row count; empty results are unknown coverage. Raw sources retain publication history internally.
Meter-Agent DirectorySPP · source model publication	Published meter-agent short names and long names. Blank BAA is unspecified; registration does not establish a physical asset relationship. Complete views require a matching receipt and mirrored row count; empty results are unknown coverage. Raw sources retain publication history internally.
Participant, Asset Owner and Transmission Customer MappingSPP · source model publication	Published market-participant, asset-owner and transmission-customer short-name/long-name crosswalk. It is an operator registration relationship, not evidence of physical asset ownership or dispatch. Complete views require a matching receipt and mirrored row count; empty results are unknown coverage. Raw sources retain publication history internally.