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
- Evidence
- Observed market data
- Time basis
- Point-in-time records
Overview
Access
Schema
| Column | Type |
|---|---|
event_ | DateTime64( |
feed | LowCardinality( |
load_ | Date32 |
hour_ | Int32 |
ttsl_ | Nullable( |
source_ | String |
ingested_ | DateTime64( |
Sample data
| event_time | feed | load_date | hour_ending | ttsl_mw | source_file | ingested_at |
|---|---|---|---|---|---|---|
| 2026-11-02 07:00:00.000000 | current_month | 2026-11-01 | 24 | 16617 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-02 06:00:00.000000 | current_month | 2026-11-01 | 23 | 17393 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-02 05:00:00.000000 | current_month | 2026-11-01 | 22 | 18189 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-02 04:00:00.000000 | current_month | 2026-11-01 | 21 | 18877 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-02 03:00:00.000000 | current_month | 2026-11-01 | 20 | 19266 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-02 02:00:00.000000 | current_month | 2026-11-01 | 19 | 19438 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-02 01:00:00.000000 | current_month | 2026-11-01 | 18 | 19379 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-02 00:00:00.000000 | current_month | 2026-11-01 | 17 | 18733 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-01 23:00:00.000000 | current_month | 2026-11-01 | 16 | 19008 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-01 22:00:00.000000 | current_month | 2026-11-01 | 15 | 19122 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-01 21:00:00.000000 | current_month | 2026-11-01 | 14 | 19611 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-01 20:00:00.000000 | current_month | 2026-11-01 | 13 | 19804 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-01 19:00:00.000000 | current_month | 2026-11-01 | 12 | 19906 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-01 18:00:00.000000 | current_month | 2026-11-01 | 11 | 20345 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-01 17:00:00.000000 | current_month | 2026-11-01 | 10 | 20293 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-01 16:00:00.000000 | current_month | 2026-11-01 | 9 | 19854 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-01 15:00:00.000000 | current_month | 2026-11-01 | 8 | 18735 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-01 14:00:00.000000 | current_month | 2026-11-01 | 7 | 17269 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-01 13:00:00.000000 | current_month | 2026-11-01 | 6 | 16315 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-01 12:00:00.000000 | current_month | 2026-11-01 | 5 | 15865 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-01 11:00:00.000000 | current_month | 2026-11-01 | 4 | 15442 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-01 10:00:00.000000 | current_month | 2026-11-01 | 3 | 15599 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-01 09:00:00.000000 | current_month | 2026-11-01 | 2 | 15639 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-01 08:00:00.000000 | current_month | 2026-11-01 | 2 | 15709 | daily.xls | 2026-11-02 18:54:31.826376 |
| 2026-11-01 07:00:00.000000 | current_month | 2026-11-01 | 1 | 15710 | daily.xls | 2026-11-02 18:54:31.826376 |
Coverage
- 100.0%
- 0
- 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