BPA Total Transmission System Load

BPA Total Transmission System Load every hour since 2007: generation in the balancing area plus interchange and wheeling onto the system, the measure BPA bills monthly transmission peaks on.

One row per
feed x hour
Hourly cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · event_time

Overview

Query contract
Preserve one canonical row per (feed, event_time) before aggregating.
Analysis rules
Use by_hour for history and current_month for hours it does not yet hold.
Interpretation
TTSL is not a regulatory system-load measure.

Access

Download
Query it in SQL, download it, or read it with an API key. Download data
MCP
Connect an MCP client and load the contract with describe_data before calling query_data.BPA MCPAPI reference
HTTP endpoint
POST /api/v1/datasets/bpa_ttsl_hourly/query
Full history
Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

7 columns
ColumnType
event_timeDateTime64(6, 'UTC')
feedLowCardinality(String)
load_dateDate32
hour_endingInt32
ttsl_mwNullable(Float64)
source_fileString
ingested_atDateTime64(6, 'UTC')

Sample data

event_timefeedload_datehour_endingttsl_mwsource_fileingested_at
2026-11-02 07:00:00.000000current_month2026-11-012416617daily.xls2026-11-02 18:54:31.826376
2026-11-02 06:00:00.000000current_month2026-11-012317393daily.xls2026-11-02 18:54:31.826376
2026-11-02 05:00:00.000000current_month2026-11-012218189daily.xls2026-11-02 18:54:31.826376
2026-11-02 04:00:00.000000current_month2026-11-012118877daily.xls2026-11-02 18:54:31.826376
2026-11-02 03:00:00.000000current_month2026-11-012019266daily.xls2026-11-02 18:54:31.826376
2026-11-02 02:00:00.000000current_month2026-11-011919438daily.xls2026-11-02 18:54:31.826376
2026-11-02 01:00:00.000000current_month2026-11-011819379daily.xls2026-11-02 18:54:31.826376
2026-11-02 00:00:00.000000current_month2026-11-011718733daily.xls2026-11-02 18:54:31.826376
2026-11-01 23:00:00.000000current_month2026-11-011619008daily.xls2026-11-02 18:54:31.826376
2026-11-01 22:00:00.000000current_month2026-11-011519122daily.xls2026-11-02 18:54:31.826376
2026-11-01 21:00:00.000000current_month2026-11-011419611daily.xls2026-11-02 18:54:31.826376
2026-11-01 20:00:00.000000current_month2026-11-011319804daily.xls2026-11-02 18:54:31.826376
2026-11-01 19:00:00.000000current_month2026-11-011219906daily.xls2026-11-02 18:54:31.826376
2026-11-01 18:00:00.000000current_month2026-11-011120345daily.xls2026-11-02 18:54:31.826376
2026-11-01 17:00:00.000000current_month2026-11-011020293daily.xls2026-11-02 18:54:31.826376
2026-11-01 16:00:00.000000current_month2026-11-01919854daily.xls2026-11-02 18:54:31.826376
2026-11-01 15:00:00.000000current_month2026-11-01818735daily.xls2026-11-02 18:54:31.826376
2026-11-01 14:00:00.000000current_month2026-11-01717269daily.xls2026-11-02 18:54:31.826376
2026-11-01 13:00:00.000000current_month2026-11-01616315daily.xls2026-11-02 18:54:31.826376
2026-11-01 12:00:00.000000current_month2026-11-01515865daily.xls2026-11-02 18:54:31.826376
2026-11-01 11:00:00.000000current_month2026-11-01415442daily.xls2026-11-02 18:54:31.826376
2026-11-01 10:00:00.000000current_month2026-11-01315599daily.xls2026-11-02 18:54:31.826376
2026-11-01 09:00:00.000000current_month2026-11-01215639daily.xls2026-11-02 18:54:31.826376
2026-11-01 08:00:00.000000current_month2026-11-01215709daily.xls2026-11-02 18:54:31.826376
2026-11-01 07:00:00.000000current_month2026-11-01115710daily.xls2026-11-02 18:54:31.826376

Coverage

Complete
100.0%
Gap days
0
Days with data
7,246
Show coverage history
Coverage: 100.0%Days with data: 7,246Gaps: 0
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016
2015
2014
2013
2012
2011
2010
2009
2008
2007
gaplessmore