Ask the Grid
Open live 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
Query with the agent
Native record
lid x pe x element x dur_code x ts_code x extremum_code x issued_at x event_time
hourly publication cadence
Evidence
Forecast data
Forward-looking values with an explicit issue time
Time basis
Point-in-time records
UTC · event_time

Overview

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

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; forecast rows hold every issuance, so pick one issued_at or the latest at or before a cutoff.

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

Schema12

Column
Type
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-09-28 12:00:00.0000002026-09-18 15:06:00.000000DCDQ2QI0FZZinflow1710.24cubic feet per secondDUNCAN - DUNCAN DAM2026-09-19 04:22:46.037492
2026-09-28 12:00:00.0000002026-09-18 15:24:00.000000SPDI1HG0FZZstage3.4feetCLEARWATER - AT SPALDING2026-09-19 04:23:45.940083
2026-09-28 12:00:00.0000002026-09-18 15:06:00.000000DCDQ2QR0FZZdischarge7019.9cubic feet per secondDUNCAN - DUNCAN DAM2026-09-19 04:22:46.529079
2026-09-28 12:00:00.0000002026-09-18 15:24:00.000000DWRI1HF0FZZforebay_elevation1519.31feetNF CLEARWATER - DWORSHAK DAM2026-09-19 04:23:28.976796
2026-09-28 12:00:00.0000002026-09-18 15:24:00.000000SPDI1HG0FZZdischarge3495cubic feet per secondCLEARWATER - AT SPALDING2026-09-19 04:23:45.940083
2026-09-28 12:00:00.0000002026-09-18 15:24:00.000000DWRI1QI0FZZinflow744.05cubic feet per secondNF CLEARWATER - DWORSHAK DAM2026-09-19 04:23:28.421126
2026-09-28 12:00:00.0000002026-09-18 15:18:00.000000GCDW1HF0FZZforebay_elevation1286.5feetCOLUMBIA - GRAND COULEE DAM2026-09-19 04:22:54.305772
2026-09-28 12:00:00.0000002026-09-18 15:47:00.000000RRHW1QI0FZZinflow57838.38cubic feet per secondCOLUMBIA - ROCKY REACH DAM2026-09-19 04:22:55.801312
2026-09-28 12:00:00.0000002026-09-18 15:18:00.000000GCDW1QI0FZZinflow67901.01cubic feet per secondCOLUMBIA - GRAND COULEE DAM2026-09-19 04:22:53.702376
2026-09-28 12:00:00.0000002026-09-18 15:36:00.000000HCDI1HG0FZZdischarge10499cubic feet per secondSNAKE - AT HELLS CANYON DAM2026-09-19 04:23:17.310382
2026-09-28 12:00:00.0000002026-09-18 15:47:00.000000RISW1QI0FZZinflow58185.76cubic feet per secondCOLUMBIA - BLO ROCK ISLAND DAM2026-09-19 04:22:56.296705
2026-09-28 12:00:00.0000002026-09-18 15:36:00.000000HCDI1HG0FZZstage64.15feetSNAKE - AT HELLS CANYON DAM2026-09-19 04:23:17.310382
2026-09-28 12:00:00.0000002026-09-18 15:01:00.000000HHWM8HP0FZZforebay_elevation3545.1feetSF FLATHEAD - HUNGRY HORSE DAM2026-09-19 04:22:50.680047
2026-09-28 12:00:00.0000002026-09-18 15:18:00.000000REVQ2QR0FZZdischarge24129.2cubic feet per secondCOLUMBIA - REVELSTOKE DAM2026-09-19 04:22:43.368421
2026-09-28 12:00:00.0000002026-09-18 15:01:00.000000HHWM8QI0FZZinflow733.54cubic feet per secondSF FLATHEAD - HUNGRY HORSE DAM2026-09-19 04:22:50.072736
2026-09-28 12:00:00.0000002026-09-18 15:43:00.000000IHDW1QI0FZZinflow18084.56cubic feet per secondSNAKE - ICE HARBOR DAM2026-09-19 04:23:47.940423
2026-09-28 12:00:00.0000002026-09-18 15:43:00.000000ANAW1HG0FZZstage3.63feetSNAKE - NEAR ANATONE2026-09-19 04:23:27.911601
2026-09-28 12:00:00.0000002026-09-18 15:47:00.000000JDAO3QI0FZZinflow78331.54cubic feet per secondCOLUMBIA - JOHN DAY DAM2026-09-19 04:24:00.557992
2026-09-28 12:00:00.0000002026-09-18 15:18:00.000000ARDQ2QR0FZZdischarge31999.6cubic feet per secondCOLUMBIA - ARROW LAKES (HUGH KEENLEYSIDE DAM)2026-09-19 04:22:44.994023
2026-09-28 12:00:00.0000002026-09-18 15:18:00.000000REVQ2HF0FZZforebay_elevation1878.68feetCOLUMBIA - REVELSTOKE DAM2026-09-19 04:22:43.984755
2026-09-28 12:00:00.0000002026-09-18 15:01:00.000000KERM8QI0FZZinflow5578.67cubic feet per secondFLATHEAD - SELI’Š KSANKA QLISPE’ DAM2026-09-19 04:22:51.079644
2026-09-28 12:00:00.0000002026-09-18 15:18:00.000000REVQ2QI0FZZinflow24129.2cubic feet per secondCOLUMBIA - REVELSTOKE DAM2026-09-19 04:22:42.871045
2026-09-28 12:00:00.0000002026-09-18 15:18:00.000000MCDQ2QI0FZZinflow10098.01cubic feet per secondCOLUMBIA - MICA DAM2026-09-19 04:22:40.669269
2026-09-28 12:00:00.0000002026-09-18 15:24:00.000000ORFI1HG0FZZdischarge1368cubic feet per secondCLEARWATER - AT OROFINO2026-09-19 04:23:37.086992
2026-09-28 12:00:00.0000002026-09-18 15:24:00.000000ORFI1HG0FZZstage2.53feetCLEARWATER - AT OROFINO2026-09-19 04:23:37.086992

Coverage

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