
East / West Capacity and Obligation
Published East/West capacity and obligation snapshot, preserving LocalInterval as a source calendar label.
Overview
event_time and published_at are file publication, not a converted local event clock. Source numeric units are not inferred from the bare Capacity and Obligation headers. Complete views require a matching receipt and mirrored row count; empty results are unknown coverage. Raw sources retain publication history internally.
Query contract
Analysis rules
Interpretation
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.
POST /api/v1/datasets/spp_public_capacity_obligation/queryNeed the full history of this dataset in Snowflake, Databricks or your own storage? Data services delivers it on a schedule.
Schema14
event_timeDateTime64(6, 'UTC')published_atDateTime64(6, 'UTC')snapshot_timeDateTime64(6, 'UTC')snapshot_idStringrow_numberInt64baaStringsource_fileStringsource_urlStringcontent_hashStringrecord_jsonStringtarget_time_labelNullable(String)capacityNullable(Float64)obligationNullable(Float64)ingested_atDateTime64(6, 'UTC')Sample data
| event_time | published_at | snapshot_time | snapshot_id | row_number | baa | source_file | source_url | content_hash | record_json | target_time_label | capacity | obligation | ingested_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-10-10 01:17:20.509000 | 2026-10-10 01:17:20.509000 | 2026-10-10 01:19:39.838330 | c7cb665404d60d5333345d28c69cd07438b280504e0d2ebacca114cb97d1ea02 | 1 | SPP | Operational_Data/Capacity_Obligation_SPPGO/capacity_obligation_sppgo_SPP.csv | https://portal.spp.org/ | d6514d8b31828cb9c836404bad21a4f3ede6935a140adb9802c5aeddcf238136 | {"LocalInterval": "10/09/2026 20:15:00", "Capacity": "47999.8000", "Obligation": "40471.2100"} | 10/09/2026 20:15:00 | 47999.8 | 40471.21 | 2026-10-10 01:19:39.855272 |
| 2026-10-10 01:17:20.519000 | 2026-10-10 01:17:20.519000 | 2026-10-10 01:21:05.465796 | 59f2435be739e59a9eb47f8c0c18d33aa6bedc1dbd0faeaef4e8093fcc0f229c | 1 | SWPW | Operational_Data/Capacity_Obligation_SPPGO/capacity_obligation_sppgo_SWPW.csv | https://portal.spp.org/ | fae82e5bcd155bc5eb2e1d0ef37797888fb9abf5ccc2ae175e4ee67d11de26ce | {"LocalInterval": "10/09/2026 20:15:00", "Capacity": "3667.8000", "Obligation": "3060.4600"} | 10/09/2026 20:15:00 | 3667.8 | 3060.46 | 2026-10-10 01:21:05.486973 |
Coverage
No time-indexed data — coverage isn’t applicable to this dataset.
