Ask the Grid
Open live grid

BPA FERC 714 Hourly Load

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).

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

Overview

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).

Query contract

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

Analysis rules

  • Filter one series; they are different measures, not parts of one total.

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_ferc714_hourly_load/query

Schema8

Column
Type
event_timeDateTime64(6, 'UTC')
report_yearInt32
seriesLowCardinality(String)
load_dateDate32
hour_endingInt32
value_mwNullable(Float64)
source_fileString
ingested_atDateTime64(6, 'UTC')

Sample data

event_timereport_yearseriesload_datehour_endingvalue_mwsource_fileingested_at
2026-01-01 07:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-31247905FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2026-01-01 06:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-31238147FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2026-01-01 05:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-31228355FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2026-01-01 04:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-31218611FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2026-01-01 03:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-31208797FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2026-01-01 02:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-31198990FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2026-01-01 01:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-31189045FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2026-01-01 00:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-31178745FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2025-12-31 23:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-31168376FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2025-12-31 22:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-31158345FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2025-12-31 21:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-31148439FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2025-12-31 20:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-31138691FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2025-12-31 19:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-31129038FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2025-12-31 18:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-31119380FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2025-12-31 17:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-31109650FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2025-12-31 16:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-3199702FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2025-12-31 15:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-3189563FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2025-12-31 14:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-3179225FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2025-12-31 13:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-3168734FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2025-12-31 12:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-3158285FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2025-12-31 11:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-3148063FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2025-12-31 10:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-3137962FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2025-12-31 09:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-3127924FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2025-12-31 08:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-3117969FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794
2025-12-31 07:00:00.0000002025BPA BALANCING AUTHORITY AREA LOAD2025-12-30248115FERC714_2025_Masterx.xlsx2026-09-19 09:37:48.849794

Coverage

96.4% complete364 gap days9,864 days with data
Show coverage history
Coverage: 96.4%Days with data: 9,864Gaps: 364
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016
2015
2014
2013
2012
2011
2010
2009
2008
2007
2006
2005
2004
2003
2002
2001
2000
1999
1998
gaplessmore