Ask the Grid
Open live grid

BPA Tri-Cities Monitoring

BPA's Tri-Cities area monitoring charts: area load, import and generation (MW), Hanford bus frequency (Hz), Ashe and Benton bus voltages (kV).

BPALoad dataBPA market
Query with the agent
Native record
chart x series x 5-minute instant
5-minute publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · event_time

Overview

Seven days rolling from BPA; history accrues from collection.

Query contract

Preserve one canonical row per (report_id, series, event_time) before aggregating.

Analysis rules

  • Units follow the series; never sum across series.

Interpretation

  • BPA prints Pacific prevailing time; event_time is UTC, resolved in file order across daylight-saving changes.

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.

BPA MCP API reference
HTTP endpoint
POST /api/v1/datasets/bpa_monitoring_5m/query

Schema7

Column
Type
event_timeDateTime64(6, 'UTC')
report_idLowCardinality(String)
seriesLowCardinality(String)
point_idNullable(String)
valueFloat64
source_fileString
ingested_atDateTime64(6, 'UTC')

Sample data

event_timereport_idseriespoint_idvaluesource_fileingested_at
2026-09-19 04:55:00.000000triCitiesGeneration98220107.8102triCities.txt2026-09-19 04:58:51.756450
2026-09-19 04:55:00.000000GRAN_HORS_KVGrandview13491118.3289GRAN_HORS_KV.txt2026-09-19 04:58:49.179225
2026-09-19 04:55:00.000000GRAN_HORS_KVHorse Heaven15629118.9912GRAN_HORS_KV.txt2026-09-19 04:58:49.179225
2026-09-19 04:55:00.000000asheAshe 230kV Main Bus Voltage2022240.0879ashe.txt2026-09-19 04:58:46.064931
2026-09-19 04:55:00.000000bentonBenton 115kV Main Bus Voltage3497119.0609benton.txt2026-09-19 04:58:47.894566
2026-09-19 04:55:00.000000hanfordHanford Frequency14243960.005hanford.txt2026-09-19 04:58:50.455970
2026-09-19 04:55:00.000000triCitiesImport98222460.7358triCities.txt2026-09-19 04:58:51.756450
2026-09-19 04:55:00.000000triCitiesLoad98223568.546triCities.txt2026-09-19 04:58:51.756450
2026-09-19 04:50:00.000000hanfordHanford Frequency14243959.995hanford.txt2026-09-19 04:58:50.455970
2026-09-19 04:50:00.000000triCitiesImport98222465.2881triCities.txt2026-09-19 04:58:51.756450
2026-09-19 04:50:00.000000triCitiesLoad98223572.4067triCities.txt2026-09-19 04:58:51.756450
2026-09-19 04:50:00.000000bentonBenton 115kV Main Bus Voltage3497118.8284benton.txt2026-09-19 04:58:47.894566
2026-09-19 04:50:00.000000GRAN_HORS_KVGrandview13491118.1177GRAN_HORS_KV.txt2026-09-19 04:58:49.179225
2026-09-19 04:50:00.000000asheAshe 230kV Main Bus Voltage2022239.5834ashe.txt2026-09-19 04:58:46.064931
2026-09-19 04:50:00.000000GRAN_HORS_KVHorse Heaven15629118.8585GRAN_HORS_KV.txt2026-09-19 04:58:49.179225
2026-09-19 04:50:00.000000triCitiesGeneration98220107.1186triCities.txt2026-09-19 04:58:51.756450
2026-09-19 04:45:00.000000triCitiesImport98222464.7735triCities.txt2026-09-19 04:58:51.756450
2026-09-19 04:45:00.000000triCitiesLoad98223571.3201triCities.txt2026-09-19 04:58:51.756450
2026-09-19 04:45:00.000000hanfordHanford Frequency14243960.01hanford.txt2026-09-19 04:58:50.455970
2026-09-19 04:45:00.000000bentonBenton 115kV Main Bus Voltage3497118.8048benton.txt2026-09-19 04:58:47.894566
2026-09-19 04:45:00.000000asheAshe 230kV Main Bus Voltage2022239.4908ashe.txt2026-09-19 04:58:46.064931
2026-09-19 04:45:00.000000triCitiesGeneration98220106.5466triCities.txt2026-09-19 04:58:51.756450
2026-09-19 04:45:00.000000GRAN_HORS_KVHorse Heaven15629118.8686GRAN_HORS_KV.txt2026-09-19 04:58:49.179225
2026-09-19 04:45:00.000000GRAN_HORS_KVGrandview13491118.1206GRAN_HORS_KV.txt2026-09-19 04:58:49.179225
2026-09-19 04:40:00.000000hanfordHanford Frequency14243960.021hanford.txt2026-09-19 04:58:50.455970

Coverage

100.0% complete0 gap days8 days with data
Show coverage history
Coverage: 100.0%Days with data: 8Gaps: 0
2026
gaplessmore