Ask the Grid

NWRFC Short-Range River Forecasts

Official NWRFC short-range (about ten-day, six-hourly) forecasts of inflow, outflow, forebay and stage at Columbia Basin hydro projects, every issuance kept.

NWRFCHydrology dataBPA market
Open in Data (opens in a new tab) Ask the agent
One row per
lid x pe x element x dur_code x ts_code x extremum_code x issued_at x event_time
Hourly cadence
Evidence
Forecast data
Forward-looking values with an explicit issue time
Time basis
Point-in-time records
UTC · event_time

Overview

Query contract
Preserve one canonical row per (lid, pe, element, dur_code, ts_code, extremum_code, issued_at, event_time) before aggregating.
Analysis rules
Filter one lid and element, then select one issued_at available at the cutoff. Report issuance and actual target horizon, not a presumed ten or fourteen days. River inflow is not turbine flow, dam generation, or a price forecast.

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

Schema

12 columns
ColumnType
event_timeDateTime64(6, 'UTC')
issued_atDateTime64(6, 'UTC')
lidLowCardinality(String)
peLowCardinality(String)
dur_codeLowCardinality(String)
ts_codeLowCardinality(String)
extremum_codeLowCardinality(String)
elementLowCardinality(String)
valueNullable(Float64)
unitsLowCardinality(String)
station_nameNullable(String)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timeissued_atlidpedur_codets_codeextremum_codeelementvalueunitsstation_nameingested_at
2026-11-12 12:00:00.0000002026-11-02 16:13:00.000000ANAW1HG0FZZdischarge12844cubic feet per secondSNAKE - NEAR ANATONE2026-11-02 16:23:18.968762
2026-11-12 12:00:00.0000002026-11-02 16:33:00.000000ANAW1HG0FZZdischarge12844cubic feet per secondSNAKE - NEAR ANATONE2026-11-02 17:23:09.535690
2026-11-12 12:00:00.0000002026-11-02 16:11:00.000000KERM8QI0FZZinflow4005.05cubic feet per secondFLATHEAD - SELI’Š KSANKA QLISPE’ DAM2026-11-02 16:22:59.345740
2026-11-12 12:00:00.0000002026-11-02 16:12:00.000000BRNI1QI0FZZinflow9924.91cubic feet per secondSNAKE - BROWNLEE DAM2026-11-02 16:23:13.063624
2026-11-12 12:00:00.0000002026-11-02 16:13:00.000000ANAW1HG0FZZstage3.22feetSNAKE - NEAR ANATONE2026-11-02 16:23:18.968762
2026-11-12 12:00:00.0000002026-11-02 16:42:00.000000BONO3QI0FZZinflow121504.04cubic feet per secondCOLUMBIA - BONNEVILLE DAM2026-11-02 17:23:25.888284
2026-11-12 12:00:00.0000002026-11-02 18:28:00.000000JDAO3QI0FZZinflow117286.11cubic feet per secondCOLUMBIA - JOHN DAY DAM2026-11-02 19:23:28.199851
2026-11-12 12:00:00.0000002026-11-02 16:12:00.000000BRNI1QR0FZZdischarge8499.89cubic feet per secondSNAKE - BROWNLEE DAM2026-11-02 16:23:13.748504
2026-11-12 12:00:00.0000002026-11-02 16:42:00.000000JDAO3QI0FZZinflow117298.1cubic feet per secondCOLUMBIA - JOHN DAY DAM2026-11-02 17:23:23.218359
2026-11-12 12:00:00.0000002026-11-02 16:27:00.000000ARDQ2HF0FZZforebay_elevation1430.66feetCOLUMBIA - ARROW LAKES (HUGH KEENLEYSIDE DAM)2026-11-02 17:22:47.322219
2026-11-12 12:00:00.0000002026-11-02 16:27:00.000000ARDQ2QI0FZZinflow27023.35cubic feet per secondCOLUMBIA - ARROW LAKES (HUGH KEENLEYSIDE DAM)2026-11-02 17:22:45.625435
2026-11-12 12:00:00.0000002026-11-02 16:33:00.000000IHDW1QI0FZZinflow16206.47cubic feet per secondSNAKE - ICE HARBOR DAM2026-11-02 17:23:19.052330
2026-11-12 12:00:00.0000002026-11-02 16:13:00.000000IHDW1QI0FZZinflow16206.47cubic feet per secondSNAKE - ICE HARBOR DAM2026-11-02 16:23:31.103389
2026-11-12 12:00:00.0000002026-11-02 16:12:00.000000DWRI1HF0FZZforebay_elevation1513.24feetNF CLEARWATER - DWORSHAK DAM2026-11-02 16:23:21.341842
2026-11-12 12:00:00.0000002026-11-02 16:11:00.000000DCDQ2HF0FZZforebay_elevation1872.24feetDUNCAN - DUNCAN DAM2026-11-02 16:22:54.392023
2026-11-12 12:00:00.0000002026-11-02 16:33:00.000000ANAW1HG0FZZstage3.22feetSNAKE - NEAR ANATONE2026-11-02 17:23:09.535690
2026-11-12 12:00:00.0000002026-11-02 16:27:00.000000ARDQ2QR0FZZdischarge37999.53cubic feet per secondCOLUMBIA - ARROW LAKES (HUGH KEENLEYSIDE DAM)2026-11-02 17:22:46.425739
2026-11-12 12:00:00.0000002026-11-02 16:14:00.000000BFEI1HG0FZZstage46.01feetKOOTENAI - AT BONNERS FERRY2026-11-02 16:22:56.497374
2026-11-12 12:00:00.0000002026-11-02 16:42:00.000000CHJW1QI0FZZinflow92305.73cubic feet per secondCOLUMBIA - CHIEF JOSEPH DAM2026-11-02 17:22:56.103090
2026-11-12 12:00:00.0000002026-11-02 18:28:00.000000CHJW1QI0FZZinflow92305.73cubic feet per secondCOLUMBIA - CHIEF JOSEPH DAM2026-11-02 19:22:58.392638
2026-11-12 12:00:00.0000002026-11-02 16:12:00.000000DWRI1QI0FZZinflow993.01cubic feet per secondNF CLEARWATER - DWORSHAK DAM2026-11-02 16:23:20.050658
2026-11-12 12:00:00.0000002026-11-02 16:11:00.000000HHWM8QI0FZZinflow710.26cubic feet per secondSF FLATHEAD - HUNGRY HORSE DAM2026-11-02 16:22:57.336904
2026-11-12 12:00:00.0000002026-11-02 18:28:00.000000BONO3QI0FZZinflow121492.13cubic feet per secondCOLUMBIA - BONNEVILLE DAM2026-11-02 19:23:30.546299
2026-11-12 12:00:00.0000002026-11-02 16:12:00.000000HCDI1HG0FZZdischarge8500cubic feet per secondSNAKE - AT HELLS CANYON DAM2026-11-02 16:23:15.578513
2026-11-12 12:00:00.0000002026-11-02 16:27:00.000000GCDW1QI0FZZinflow73635.2cubic feet per secondCOLUMBIA - GRAND COULEE DAM2026-11-02 17:22:54.557865

Coverage

Complete
100.0%
Gap days
0
Days with data
55
Show coverage history
Coverage: 100.0%Days with data: 55Gaps: 0
2026
gaplessmore