BPA Tri-Cities Monitoring

BPA's Tri-Cities area monitoring charts: area load, import and generation (MW), Hanford bus frequency (Hz), Ashe (230 kV), Benton (115 kV), and Grandview and Horse Heaven (115 kV) bus voltages; the GRAN_HORS_KV series labels omit units but readings are kV.

BPALoad data BPA market

Open in Data Ask the agent

One row per: chart x series x 5-minute instant; 5-minute 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

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 MCP API reference
HTTP endpoint: POST /api/v1/datasets/bpa_monitoring_5m/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

7 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`report_id`	`LowCardinality(String)`
`series`	`LowCardinality(String)`
`point_id`	`Nullable(String)`
`value`	`Float64`
`source_file`	`String`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	report_id	series	point_id	value	source_file	ingested_at
2026-11-01 06:55:00.000000	benton	Benton 115kV Main Bus Voltage	3497	119.0377	benton.txt	2026-11-01 06:58:49.920943
2026-11-01 06:55:00.000000	ashe	Ashe 230kV Main Bus Voltage	2022	239.5789	ashe.txt	2026-11-01 06:58:47.459750
2026-11-01 06:55:00.000000	hanford	Hanford Frequency	142439	59.994	hanford.txt	2026-11-01 06:58:52.943431
2026-11-01 06:55:00.000000	triCities	Import	98222	307.5665	triCities.txt	2026-11-01 06:58:54.625307
2026-11-01 06:55:00.000000	triCities	Generation	98220	117.4774	triCities.txt	2026-11-01 06:58:54.625307
2026-11-01 06:55:00.000000	triCities	Load	98223	425.0438	triCities.txt	2026-11-01 06:58:54.625307
2026-11-01 06:55:00.000000	GRAN_HORS_KV	Horse Heaven	15629	119.5848	GRAN_HORS_KV.txt	2026-11-01 06:58:51.377024
2026-11-01 06:55:00.000000	GRAN_HORS_KV	Grandview	13491	119.5252	GRAN_HORS_KV.txt	2026-11-01 06:58:51.377024
2026-11-01 06:50:00.000000	ashe	Ashe 230kV Main Bus Voltage	2022	239.7087	ashe.txt	2026-11-01 06:58:47.459750
2026-11-01 06:50:00.000000	benton	Benton 115kV Main Bus Voltage	3497	119.0833	benton.txt	2026-11-01 06:58:49.920943
2026-11-01 06:50:00.000000	hanford	Hanford Frequency	142439	60.001	hanford.txt	2026-11-01 06:58:52.943431
2026-11-01 06:50:00.000000	triCities	Import	98222	309.3379	triCities.txt	2026-11-01 06:58:54.625307
2026-11-01 06:50:00.000000	triCities	Generation	98220	117.7727	triCities.txt	2026-11-01 06:58:54.625307
2026-11-01 06:50:00.000000	triCities	Load	98223	427.1105	triCities.txt	2026-11-01 06:58:54.625307
2026-11-01 06:50:00.000000	GRAN_HORS_KV	Horse Heaven	15629	119.619	GRAN_HORS_KV.txt	2026-11-01 06:58:51.377024
2026-11-01 06:50:00.000000	GRAN_HORS_KV	Grandview	13491	119.5927	GRAN_HORS_KV.txt	2026-11-01 06:58:51.377024
2026-11-01 06:45:00.000000	benton	Benton 115kV Main Bus Voltage	3497	119.0507	benton.txt	2026-11-01 06:58:49.920943
2026-11-01 06:45:00.000000	ashe	Ashe 230kV Main Bus Voltage	2022	239.6244	ashe.txt	2026-11-01 06:58:47.459750
2026-11-01 06:45:00.000000	GRAN_HORS_KV	Grandview	13491	119.5782	GRAN_HORS_KV.txt	2026-11-01 06:48:57.762858
2026-11-01 06:45:00.000000	GRAN_HORS_KV	Horse Heaven	15629	119.6762	GRAN_HORS_KV.txt	2026-11-01 06:48:57.762858
2026-11-01 06:45:00.000000	hanford	Hanford Frequency	142439	60.012	hanford.txt	2026-11-01 06:58:52.943431
2026-11-01 06:45:00.000000	triCities	Import	98222	315.4539	triCities.txt	2026-11-01 06:58:54.625307
2026-11-01 06:45:00.000000	triCities	Generation	98220	116.9092	triCities.txt	2026-11-01 06:58:54.625307
2026-11-01 06:45:00.000000	triCities	Load	98223	432.3631	triCities.txt	2026-11-01 06:58:54.625307
2026-11-01 06:45:00.000000	GRAN_HORS_KV	Grandview	13491	119.5782	GRAN_HORS_KV.txt	2026-11-01 06:58:51.377024

Coverage

Complete: 100.0%
Gap days: 0
Days with data: 51

Show coverage history

Coverage: 100.0%Days with data: 51Gaps: 0

2026

gaplessmore

Related data

Related load data
Dataset	Description
BPA FERC 714 Hourly LoadBPA · hourly	Hourly BPA load from Part III Schedule 2(a) of its FERC Form 714 filings, 1998 onward, long by series as printed (system load, area load, balancing authority area load).
BPA Total Transmission System LoadBPA · hourly	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.
7-Day Load ForecastPJM · hourly (7-day horizon)	PJM's seven-day-ahead hourly load forecast by forecast area, refreshed through the day. Rows are keyed by target time (event_time) with the issue time in evaluated_at_utc; take the latest vintage per target hour via an argMax over evaluated_at_utc. Forecast areas match the very-short-term feed (utility names, RTO_COMBINED for the system total). This is the table for tomorrow's peak and the week-ahead demand outlook. Source: PJM Market Data.
Actual Demand by RegionMISO · hourly	Observed hourly MISO demand in MW for the Central, North, and South sub-regions. Region labels are normalized to uppercase; this is regional operational load, not a local-resource-zone series.