NWRFC Observed River Conditions

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

NWRFCHydrology data BPA market

Open in Data Ask the agent

One row per: lid x pe x element x dur_code x ts_code x extremum_code x event_time; 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 (lid, pe, element, dur_code, ts_code, extremum_code, event_time) before aggregating.
Analysis rules: Filter one lid and element and preserve observation time and units. These are observations, not forecasts.

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 MCP API reference
HTTP endpoint: POST /api/v1/datasets/nwrfc_river_observed/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

11 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`lid`	`LowCardinality(String)`
`pe`	`LowCardinality(String)`
`dur_code`	`LowCardinality(String)`
`ts_code`	`LowCardinality(String)`
`extremum_code`	`LowCardinality(String)`
`element`	`LowCardinality(String)`
`value`	`Nullable(Float64)`
`units`	`LowCardinality(String)`
`station_name`	`Nullable(String)`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	lid	pe	ts_code	extremum_code	element	value	units	station_name	ingested_at
2026-11-03 16:15:00.000000	KIOW1	HG	RZ	Z	discharge	1668	cubic feet per second	YAKIMA - AT KIONA	2026-11-03 16:23:16.852779
2026-11-03 16:15:00.000000	KIOW1	HG	RZ	Z	stage	4.11	feet	YAKIMA - AT KIONA	2026-11-03 16:23:16.852779
2026-11-03 16:00:00.000000	SPDI1	HG	RG	Z	stage	3.25	feet	CLEARWATER - AT SPALDING	2026-11-03 16:23:11.192384
2026-11-03 16:00:00.000000	KIOW1	HG	RZ	Z	discharge	1668	cubic feet per second	YAKIMA - AT KIONA	2026-11-03 16:23:16.852779
2026-11-03 16:00:00.000000	SPDI1	HG	RG	Z	discharge	3153	cubic feet per second	CLEARWATER - AT SPALDING	2026-11-03 16:23:11.192384
2026-11-03 16:00:00.000000	KIOW1	HG	RZ	Z	stage	4.11	feet	YAKIMA - AT KIONA	2026-11-03 16:23:16.852779
2026-11-03 15:45:00.000000	HHWM8	HP	RG	Z	forebay_elevation	3539.09	feet	SF FLATHEAD - HUNGRY HORSE DAM	2026-11-03 16:22:47.616681
2026-11-03 15:45:00.000000	KIOW1	HG	RZ	Z	stage	4.11	feet	YAKIMA - AT KIONA	2026-11-03 16:23:16.852779
2026-11-03 15:45:00.000000	KIOW1	HG	RZ	Z	discharge	1668	cubic feet per second	YAKIMA - AT KIONA	2026-11-03 16:23:16.852779
2026-11-03 15:45:00.000000	SPDI1	HG	RG	Z	discharge	3153	cubic feet per second	CLEARWATER - AT SPALDING	2026-11-03 16:23:11.192384
2026-11-03 15:45:00.000000	SPDI1	HG	RG	Z	stage	3.25	feet	CLEARWATER - AT SPALDING	2026-11-03 16:23:11.192384
2026-11-03 15:30:00.000000	HHWM8	HP	RG	Z	forebay_elevation	3539.08	feet	SF FLATHEAD - HUNGRY HORSE DAM	2026-11-03 16:22:47.616681
2026-11-03 15:30:00.000000	HCDI1	HG	RG	Z	discharge	8528	cubic feet per second	SNAKE - AT HELLS CANYON DAM	2026-11-03 16:23:00.844972
2026-11-03 15:30:00.000000	KIOW1	HG	RZ	Z	stage	4.11	feet	YAKIMA - AT KIONA	2026-11-03 16:23:16.852779
2026-11-03 15:30:00.000000	SPDI1	HG	RG	Z	stage	3.25	feet	CLEARWATER - AT SPALDING	2026-11-03 16:23:11.192384
2026-11-03 15:30:00.000000	KIOW1	HG	RG	Z	stage	4.11	feet	YAKIMA - AT KIONA	2026-11-03 16:23:16.852779
2026-11-03 15:30:00.000000	KIOW1	HG	RB	Z	stage	4.11	feet	YAKIMA - AT KIONA	2026-11-03 16:23:16.852779
2026-11-03 15:30:00.000000	KIOW1	HG	RG	Z	discharge	1668	cubic feet per second	YAKIMA - AT KIONA	2026-11-03 16:23:16.852779
2026-11-03 15:30:00.000000	KIOW1	HG	RB	Z	discharge	1668	cubic feet per second	YAKIMA - AT KIONA	2026-11-03 16:23:16.852779
2026-11-03 15:30:00.000000	KIOW1	HG	RZ	Z	discharge	1668	cubic feet per second	YAKIMA - AT KIONA	2026-11-03 16:23:16.852779
2026-11-03 15:30:00.000000	SPDI1	HG	RG	Z	discharge	3153	cubic feet per second	CLEARWATER - AT SPALDING	2026-11-03 16:23:11.192384
2026-11-03 15:30:00.000000	HCDI1	HG	RG	Z	stage	63.35	feet	SNAKE - AT HELLS CANYON DAM	2026-11-03 16:23:00.844972
2026-11-03 15:15:00.000000	BFEI1	HG	RZ	Z	stage	48.77	feet	KOOTENAI - AT BONNERS FERRY	2026-11-03 16:22:46.656450
2026-11-03 15:15:00.000000	BFEI1	HG	RG	Z	stage	48.77	feet	KOOTENAI - AT BONNERS FERRY	2026-11-03 16:22:46.656450
2026-11-03 15:15:00.000000	KIOW1	HG	RZ	Z	stage	4.11	feet	YAKIMA - AT KIONA	2026-11-03 15:23:15.738630

Coverage

Complete: 100.0%
Gap days: 0
Days with data: 56

Show coverage history

Coverage: 100.0%Days with data: 56Gaps: 0

2026

gaplessmore

Related data

Related hydrology data
Dataset	Description
NWRFC Short-Range River ForecastsNWRFC · hourly	Official NWRFC short-range (about ten-day, six-hourly) forecasts of inflow, outflow, forebay and stage at Columbia Basin hydro projects, every issuance kept.
NWRFC Water Supply ForecastsNWRFC · daily	NWRFC seasonal runoff volume forecasts at about 120 Northwest points, every exceedance level and issuance, back to water year 2005.
Columbia Fish Passage Plans and Spill-Cap ReportsUSACE · daily revision check	Columbia fish-passage plans, change forms and spill-cap reports with plan years, content revisions, URLs and PDF page/chunk references. Evidence for published requirements and stated validity.
CONAGUA Daily Reservoir, River and Climate MeasurementsCONAGUA · daily observations, refreshed four times a day in rotation	CONAGUA's daily station measurements: reservoir level, stored volume, outflow and spill; river discharge; rainfall, evaporation, temperatures, pressure and humidity. Some stations reach back to the 1920s.