Ask the 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
Open in Data (opens in a new tab) Ask the agent
One row per
series 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 (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

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_ferc714_hourly_load/query
Full history
Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

8 columns
ColumnType
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

Complete
96.4%
Gap days
364
Days with data
9,864
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