Ask the Grid
Open live grid

NWRFC Water Supply Forecasts

NWRFC seasonal runoff volume forecasts at about 120 Northwest points, every exceedance level and issuance, back to water year 2005.

NWRFCHydrology dataBPA market
Query with the agent
Native record
lid x flavor x water_year x period x ensemble_date
daily publication cadence
Evidence
Forecast data
Forward-looking values with an explicit issue time
Time basis
Point-in-time records
UTC · event_time

Overview

NWRFC seasonal runoff volume forecasts at about 120 Northwest points, every exceedance level and issuance, back to water year 2005.

Query contract

Preserve one canonical row per (lid, flavor, water_year, period, ensemble_date) 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_water_supply_forecast/query

Schema33

Column
Type
event_timeDateTime64(6, 'UTC')
lidLowCardinality(String)
flavorLowCardinality(String)
water_yearInt32
periodLowCardinality(String)
period_endDate32
issued_dateDate32
ensemble_dateDate32
locationNullable(String)
excmin_kafNullable(Float64)
exc90_kafNullable(Float64)
exc75_kafNullable(Float64)
exc70_kafNullable(Float64)
exc50_kafNullable(Float64)
exc30_kafNullable(Float64)
exc25_kafNullable(Float64)
exc10_kafNullable(Float64)
excmax_kafNullable(Float64)
excmin_pct_avgNullable(Float64)
exc90_pct_avgNullable(Float64)
exc75_pct_avgNullable(Float64)
exc70_pct_avgNullable(Float64)
exc50_pct_avgNullable(Float64)
exc30_pct_avgNullable(Float64)
exc25_pct_avgNullable(Float64)
exc10_pct_avgNullable(Float64)
excmax_pct_avgNullable(Float64)
period_average_kafNullable(Float64)
previous_year_runoff_kafNullable(Float64)
current_runoff_kafNullable(Float64)
current_runoff_pct_avgNullable(Float64)
source_productLowCardinality(String)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timelidflavorwater_yearperiodperiod_endissued_dateensemble_datelocationexcmin_kafexc90_kafexc75_kafexc70_kafexc50_kafexc30_kafexc25_kafexc10_kafexcmax_kafexcmin_pct_avgexc90_pct_avgexc75_pct_avgexc70_pct_avgexc50_pct_avgexc30_pct_avgexc25_pct_avgexc10_pct_avgexcmax_pct_avgperiod_average_kafprevious_year_runoff_kafcurrent_runoff_kafcurrent_runoff_pct_avgsource_productingested_at
2027-04-01 00:00:00.000000MYDW1ESP02027APR-SEP2027-09-302026-09-182026-09-18COWLITZ - MAYFIELD RESERVOIR861.491302.061449.06∅1817.05∅2110.162410.813358.87467078∅97∅1131291801864.391015.4700ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000NACW1ESP02027APR-AUG2027-08-312026-09-182026-09-18NACHES - NEAR NACHES302.16473.64550.73∅722.14∅845.61025.91517.1396171∅93∅109133196773.43467.1700ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000NACW1ESP02027APR-JUL2027-07-312026-09-182026-09-18NACHES - NEAR NACHES280.85447.24523.34∅689.97∅802.39990.621460.71386171∅94∅109134198737.25448.4800ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000NACW1ESP02027APR-SEP2027-09-302026-09-182026-09-18NACHES - NEAR NACHES318.46495.44572.01∅750.88∅889.251053.151581.37396171∅93∅110130196807.36489.4600ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000NITW1ESP02027APR-AUG2027-08-312026-09-182026-09-18SIMILKAMEEN - NEAR NIGHTHAWK330.29591.81829.15∅1136.8∅1381.771714.512265.97254462∅85∅1031281701335.1961.400ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000NITW1ESP02027APR-JUL2027-07-312026-09-182026-09-18SIMILKAMEEN - NEAR NIGHTHAWK330.29588.08805.2∅1108.73∅1348.361614.762153.22264663∅86∅1051261671286.1944.0800ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000NITW1ESP02027APR-SEP2027-09-302026-09-182026-09-18SIMILKAMEEN - NEAR NIGHTHAWK333.36606.88853.13∅1165.5∅1410.771769.42315.26244462∅85∅1031301701365.8970.1600ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000ORFI1ESP02027APR-AUG2027-08-312026-09-182026-09-18CLEARWATER - AT OROFINO2666.272928.53337.24∅4266.33∅5219.536072.288064.05596574∅94∅1151341784538.623421.7200ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000ORFI1ESP02027APR-JUL2027-07-312026-09-182026-09-18CLEARWATER - AT OROFINO2584.092834.493246.77∅4131.65∅5068.435912.477816.7596474∅94∅1151341774417.243329.4200ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000ORFI1ESP02027APR-SEP2027-09-302026-09-182026-09-18CLEARWATER - AT OROFINO2730.452998.173414.83∅4351.23∅5313.156177.778205.02596574∅94∅1151331774631.53480.1300ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000OWYO3ESP02027APR-AUG2027-08-312026-09-182026-09-18OWYHEE - OWYHEE DAM50.5195.28141.73∅254.62∅530.99697.411170.01163044∅79∅165217364321.4965.4600ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000OWYO3ESP02027APR-JUL2027-07-312026-09-182026-09-18OWYHEE - OWYHEE DAM45.7889.98132.38∅238.03∅512.51674.641139.03152943∅77∅167219370307.4856.600ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000OWYO3ESP02027APR-SEP2027-09-302026-09-182026-09-18OWYHEE - OWYHEE DAM54.05103.78150.95∅266.74∅549.2715.351198163145∅79∅164213357335.6471.700ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000PALI1ESP02027APR-AUG2027-08-312026-09-182026-09-18SNAKE - NEAR IRWIN1827.182088.022590.79∅2902.68∅4157.185169.916422.68546277∅86∅1241541913362.22445.0600ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000PALI1ESP02027APR-JUL2027-07-312026-09-182026-09-18SNAKE - NEAR IRWIN1677.781908.732372.69∅2652.76∅3768.544684.735848.41546277∅86∅1221511893096.862231.7900ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000PALI1ESP02027APR-SEP2027-09-302026-09-182026-09-18SNAKE - NEAR IRWIN1963.872240.282765.93∅3109.84∅4428.225503.866763.96556377∅87∅1241541893576.862540.900ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000PARI1ESP02027APR-AUG2027-08-312026-09-182026-09-18BOISE - NEAR PARMA248.56282.41347.79∅395.64∅589.61122.921384.82475365∅74∅111211261531.47338.8900ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000PARI1ESP02027APR-JUL2027-07-312026-09-182026-09-18BOISE - NEAR PARMA248.39282.14333.86∅350.83∅533.81067.281334.49515869∅72∅110220274486.2310.0500ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000PARI1ESP02027APR-SEP2027-09-302026-09-182026-09-18BOISE - NEAR PARMA261.85297.44365.52∅439.3∅652.051187.331445.55455163∅75∅112203248584.06363.4800ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000RIMW1ESP02027APR-AUG2027-08-312026-09-182026-09-18TIETON - AT TIETON DAM108.01143.19168.7∅195.49∅225.52257.37393.49526981∅94∅108123188208.87126.800ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000PARW1ESP02027APR-JUL2027-07-312026-09-182026-09-18YAKIMA - NEAR PARKER7741200.71452.36∅1763.76∅2006.732344.673512.09457084∅102∅1171362041721.2808.400ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000PARW1ESP02027APR-SEP2027-09-302026-09-182026-09-18YAKIMA - NEAR PARKER1054.551511.121756.16∅2026.54∅2254.322607.563929.12568092∅107∅1191372071898.74903.7800ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000PARW1ESP02027APR-AUG2027-08-312026-09-182026-09-18YAKIMA - NEAR PARKER876.171364.151614.07∅1856.27∅2126.242485.873709.49497689∅103∅1181382061803.56855.500ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000PRDW1ESP02027APR-SEP2027-09-302026-09-182026-09-18COLUMBIA - BLO PRIEST RAPIDS DAM41294.352386.955668.5∅64938∅71802.48417797647.5617782∅95∅10512314368161.955998200ws_report_csv2026-09-19 04:48:41.059435
2027-04-01 00:00:00.000000PRTI1ESP02027APR-JUL2027-07-312026-09-182026-09-18PRIEST - NEAR PRIEST RIVER294.72370.39512.63∅688.82∅784.79840.51243.23374664∅86∅98105155799.87413.3300ws_report_csv2026-09-19 04:48:41.059435

Coverage

0.1% complete8,118 gap days8 days with data
Show coverage history
Coverage: 0.1%Days with data: 8Gaps: 8,118
2027
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016
2015
2014
2013
2012
2011
2010
2009
2008
2007
2006
2005
gaplessmore