Ask the Grid
Open live grid

NWRFC Observed River Conditions

Observed inflow, outflow, forebay and stage NWRFC prints beside its forecasts.

NWRFCHydrology dataBPA market
Query with the agent
Native record
lid x pe x element x dur_code x ts_code x extremum_code x event_time
hourly publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · event_time

Overview

Observed inflow, outflow, forebay and stage NWRFC prints beside its forecasts.

Query contract

Preserve one canonical row per (lid, pe, element, dur_code, ts_code, extremum_code, 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_observed/query

Schema11

Column
Type
event_timeDateTime64(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_timelidpedur_codets_codeextremum_codeelementvalueunitsstation_nameingested_at
2026-09-19 04:00:00.000000SPDI1HG0RGZstage3.72feetCLEARWATER - AT SPALDING2026-09-19 04:23:46.082022
2026-09-19 04:00:00.000000SPDI1HG0RGZdischarge4295cubic feet per secondCLEARWATER - AT SPALDING2026-09-19 04:23:46.082022
2026-09-19 03:45:00.000000SPDI1HG0RGZdischarge4347cubic feet per secondCLEARWATER - AT SPALDING2026-09-19 04:23:46.082022
2026-09-19 03:45:00.000000SPDI1HG0RGZstage3.74feetCLEARWATER - AT SPALDING2026-09-19 04:23:46.082022
2026-09-19 03:45:00.000000HHWM8HP0RGZforebay_elevation3547.01feetSF FLATHEAD - HUNGRY HORSE DAM2026-09-19 04:22:50.818884
2026-09-19 03:30:00.000000KIOW1HG0RBZstage4.33feetYAKIMA - AT KIONA2026-09-19 04:23:59.790054
2026-09-19 03:30:00.000000KIOW1HG0RGZdischarge1924cubic feet per secondYAKIMA - AT KIONA2026-09-19 04:23:59.790054
2026-09-19 03:30:00.000000HHWM8HP0RGZforebay_elevation3547.01feetSF FLATHEAD - HUNGRY HORSE DAM2026-09-19 04:22:50.818884
2026-09-19 03:30:00.000000KIOW1HG0RZZdischarge1900cubic feet per secondYAKIMA - AT KIONA2026-09-19 04:23:59.790054
2026-09-19 03:30:00.000000KIOW1HG0RZZstage4.31feetYAKIMA - AT KIONA2026-09-19 04:23:59.790054
2026-09-19 03:30:00.000000HCDI1HG0RGZstage65.3feetSNAKE - AT HELLS CANYON DAM2026-09-19 04:23:17.456985
2026-09-19 03:30:00.000000SPDI1HG0RGZdischarge4373cubic feet per secondCLEARWATER - AT SPALDING2026-09-19 04:23:46.082022
2026-09-19 03:30:00.000000KIOW1HG0RGZstage4.33feetYAKIMA - AT KIONA2026-09-19 04:23:59.790054
2026-09-19 03:30:00.000000KIOW1HG0RBZdischarge1924cubic feet per secondYAKIMA - AT KIONA2026-09-19 04:23:59.790054
2026-09-19 03:30:00.000000HCDI1HG0RGZdischarge13723cubic feet per secondSNAKE - AT HELLS CANYON DAM2026-09-19 04:23:17.456985
2026-09-19 03:30:00.000000SPDI1HG0RGZstage3.75feetCLEARWATER - AT SPALDING2026-09-19 04:23:46.082022
2026-09-19 03:15:00.000000HCDI1HG0RGZstage65.3feetSNAKE - AT HELLS CANYON DAM2026-09-19 04:23:17.456985
2026-09-19 03:15:00.000000PRDW1HG0RZZdischarge77540cubic feet per secondCOLUMBIA - BLO PRIEST RAPIDS DAM2026-09-19 04:23:11.852438
2026-09-19 03:15:00.000000KIOW1HG0RZZstage4.31feetYAKIMA - AT KIONA2026-09-19 04:23:59.790054
2026-09-19 03:15:00.000000ANAW1HG0RZZstage2.98feetSNAKE - NEAR ANATONE2026-09-19 04:23:28.050658
2026-09-19 03:15:00.000000ORFI1HG0RZZdischarge1427cubic feet per secondCLEARWATER - AT OROFINO2026-09-19 04:23:37.294051
2026-09-19 03:15:00.000000ORFI1HG0RGZdischarge1427cubic feet per secondCLEARWATER - AT OROFINO2026-09-19 04:23:37.294051
2026-09-19 03:15:00.000000SPDI1HG0RGZstage3.76feetCLEARWATER - AT SPALDING2026-09-19 04:23:46.082022
2026-09-19 03:15:00.000000ANAW1HG0RGZdischarge11877cubic feet per secondSNAKE - NEAR ANATONE2026-09-19 04:23:28.050658
2026-09-19 03:15:00.000000ORFI1HG0RGZstage2.58feetCLEARWATER - AT OROFINO2026-09-19 04:23:37.294051

Coverage

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