River Gauge Registry (Flood Thresholds)

The reference record for every NWS river gauge, refreshed daily: whether its flood thresholds are rated on stage or flow, the action, minor, moderate, and major thresholds, the low-water line, the USGS site number where USGS runs the gauge, whether it is an official forecast point, and the county, state, and River Forecast Center.

NOAA NWPSInfrastructure data ERCOT market NYISO market CAISO market PJM market MISO market ISO-NE market SPP market

Open in Data Ask the agent

One row per: river gauge x daily registry snapshot; Daily cadence
Evidence: Reference data; Stable context used to interpret other datasets
Time basis: Point-in-time records; UTC · source_time

Overview

Join it to the gauge snapshots on lid to express a reading as distance from flood stage, and use the USGS site number to reach 15-minute discharge history. Source: NOAA National Water Prediction Service.

Query contract: Take the newest source_time per lid before joining thresholds to readings.
Analysis rules: Join to nwps.gauges on lid; express a reading as stage_ft minus the threshold of the same gauge.usgs_id prefixed with 'USGS-' is usgs_water location_id.
Interpretation: A flow-rated gauge (rated_on = 'flow') has flow thresholds only.

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.ERCOT MCP CAISO MCP NYISO MCP PJM MCP SPP MCP MISO MCP ISO-NE MCP BPA MCP API reference
HTTP endpoint: POST /api/v1/datasets/nwps_gauge_registry/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

25 columns

Column	Type
`lid`	`LowCardinality(String)`
`source_time`	`DateTime64(6, 'UTC')`
`name`	`String`
`usgs_id`	`Nullable(String)`
`reach_id`	`Nullable(String)`
`state`	`LowCardinality(Nullable(String))`
`county`	`Nullable(String)`
`rfc`	`LowCardinality(Nullable(String))`
`wfo`	`LowCardinality(Nullable(String))`
`time_zone`	`LowCardinality(Nullable(String))`
`latitude`	`Nullable(Float64)`
`longitude`	`Nullable(Float64)`
`in_service`	`Nullable(Bool)`
`rated_on`	`LowCardinality(Nullable(String))`
`action_stage_ft`	`Nullable(Float64)`
`minor_stage_ft`	`Nullable(Float64)`
`moderate_stage_ft`	`Nullable(Float64)`
`major_stage_ft`	`Nullable(Float64)`
`action_flow_cfs`	`Nullable(Float64)`
`minor_flow_cfs`	`Nullable(Float64)`
`moderate_flow_cfs`	`Nullable(Float64)`
`major_flow_cfs`	`Nullable(Float64)`
`low_water_ft`	`Nullable(Float64)`
`forecast_status`	`Nullable(String)`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

lid	source_time	name	usgs_id	reach_id	state	county	rfc	wfo	time_zone	latitude	longitude	in_service	rated_on	action_stage_ft	minor_stage_ft	moderate_stage_ft	major_stage_ft	action_flow_cfs	minor_flow_cfs	moderate_flow_cfs	major_flow_cfs	low_water_ft	forecast_status	ingested_at
PABN4	2026-11-03 08:17:05.696047	Arthur Kill at Perth Amboy (IN MLLW)	01396060	∅	NJ	Middlesex	MARFC	PHI	EST5EDT	40.5039	-74.2622	true	stage	∅	7.2	8.2	9.2	∅	∅	∅	∅	-2	Forecasts are issued routinely year-round.	2026-11-03 08:17:07.432431
PALS2	2026-11-03 08:17:05.696047	Split Rock Creek near Garretson	∅	7223064	SD	Minnehaha	MBRFC	FSD	CST6CDT	43.6756	-96.5312	true	stage	1386	1389	1392	1395	∅	∅	∅	∅	∅	Forecasts are not available. Only observed stages are available for this point.	2026-11-03 08:17:07.432431
PACG1	2026-11-03 08:17:05.696047	Parks Creek at Lyle Field Road near Jefferson	02217643	1047417	GA	Jackson	SERFC	FFC	EST5EDT	34.161944444444	-83.525	true	stage	8	9	10	13	∅	∅	∅	∅	∅	Forecasts are not available. Only observed stages are available for this point.	2026-11-03 08:17:07.432431
PACI1	2026-11-03 08:17:05.696047	Paradise Creek at HWY8 Near Moscow	13346765	23460013	ID	Latah	NWRFC	OTX	PST8PDT	46.731944444444	-117.02417	true	stage	49.66	50.86	51.66	∅	∅	∅	∅	∅	45.64	Forecasts are issued routinely year-round.	2026-11-03 08:17:07.432431
PACS2	2026-11-03 08:17:05.696047	Pactola Reservoir	∅	17533765	SD	Pennington	MBRFC	UNR	MST7MDT	44.072222222222	-103.48805555556	true	stage	4580.2	∅	∅	∅	∅	∅	∅	∅	∅	Forecasts are not available. Only observed stages are available for this point.	2026-11-03 08:17:07.432431
PACT2	2026-11-03 08:17:05.696047	Tide Gauge at Packery Channel	∅	∅	TX	Nueces	WGRFC	CRP	CST6CDT	27.6188888888889	-97.2338888888889	true	stage	1.8	1.83	2.83	3.83	∅	∅	∅	∅	∅	Graphical forecasts are not available during times of high water, forecast crest information can be found in the local WFO web page.	2026-11-03 08:17:07.432431
PACW1	2026-11-03 08:17:05.696047	Cowlitz River at Packwood	14226500	23744100	WA	Lewis	NWRFC	SEW	PST8PDT	46.613055555556	-121.67805555556	true	stage	8.2	10.5	11	12	∅	∅	∅	∅	∅	Forecasts are issued routinely year-round.	2026-11-03 08:17:07.432431
PACW4	2026-11-03 08:17:05.696047	Pacific Creek near Moran	13011500	23123373	WY	Teton	NWRFC	RIW	MST7MDT	43.85048	-110.51757	true	stage	7.5	8.5	9.5	15	∅	∅	∅	∅	∅	Forecasts are issued routinely year-round.	2026-11-03 08:17:07.432431
PADF1	2026-11-03 08:17:05.696047	Parker City Pier at Dupont Bridge (in MHHW)	∅	∅	FL	Bay	SERFC	TAE	EST5EDT	30.105537	-85.604825	true	stage	1.5	2	3	4	∅	∅	∅	∅	∅	Forecasts are not available. Only observed stages are available for this point.	2026-11-03 08:17:07.432431
PADP1	2026-11-03 08:17:05.696047	Schuylkill River at Philadelphia	01474500	4784831	PA	Philadelphia	MARFC	PHI	EST5EDT	39.967777777778	-75.188888888889	true	stage	10	11	13	15.5	∅	∅	∅	∅	∅	Forecasts are issued routinely year-round.	2026-11-03 08:17:07.432431
PAGH1	2026-11-03 08:17:05.696047	Paauau Gulch near Pahala	16770500	800008811	HI	Hawaii	APRFC	HFO	HST10	19.2077777777778	-155.477222222222	true	stage	∅	4	∅	12	∅	∅	∅	∅	∅	Forecasts are not available. Only observed stages are available for this point.	2026-11-03 08:17:07.432431
PAHC1	2026-11-03 08:17:05.696047	Pacheco Reservoir above Pacheco Reservoir	∅	∅	CA	Santa Clara	CNRFC	MTR	PST8PDT	37.0502	-121.2913	true	stage	∅	∅	∅	∅	∅	∅	∅	∅	∅	Graphical forecasts are not available during times of high water, forecast crest information can be found in the local WFO web page.	2026-11-03 08:17:07.432431
PAHI1	2026-11-03 08:17:05.696047	Pahsimeroi River at Ellis	13302005	23498759	ID	Lemhi	NWRFC	MSO	GMT0GMT	44.691666666667	-114.04694444444	true	stage	∅	∅	∅	∅	∅	∅	∅	∅	∅	Graphical forecasts are not available during times of high water, forecast crest information can be found in the local WFO web page.	2026-11-03 08:17:07.432431
PACF1	2026-11-03 08:17:05.696047	Tide Station at Panama City Marina (in MHHW)	∅	∅	FL	Bay	SERFC	TAE	CST6CDT	30.151944444444	-85.666944444444	true	stage	1	2	3.5	5	∅	∅	∅	∅	-1.9	Forecasts are not available. Only observed stages are available for this point.	2026-11-03 08:17:07.432431
PAHK2	2026-11-03 08:17:05.696047	Ohio River at Paducah	03611000	1840075	KY	McCracken	LMRFC	PAH	CST6CDT	37.089444444444	-88.594444444444	true	stage	32	39	43	52	∅	∅	∅	∅	∅	Forecasts are issued routinely year-round.	2026-11-03 08:17:07.432431
PAHS2	2026-11-03 08:17:05.696047	Keyapaha River near Keyapaha	06464100	11653122	SD	Tripp	MBRFC	UNR	CST6CDT	43.12917164	-100.1070671	true	stage	8	10	11	12	∅	∅	∅	∅	∅	Forecasts are not available. Only observed stages are available for this point.	2026-11-03 08:17:07.432431
PALN2	2026-11-03 08:17:05.696047	Humboldt River at Palisade	10322500	10782860	NV	Eureka	CNRFC	LKN	PST8PDT	40.6075	-116.200833	true	stage	6	7	8	9	∅	∅	∅	∅	∅	Forecasts are issued routinely year-round.	2026-11-03 08:17:07.432431
PALN1	2026-11-03 08:17:05.696047	Frenchman Creek at Palisade	06834000	19081429	NE	Hayes	MBRFC	LBF	CST6CDT	40.351944444444	-101.12333333333	true	stage	5.5	7	8	9	∅	∅	∅	∅	∅	Forecasts are issued as needed during times of high water, but are not routinely available.	2026-11-03 08:17:07.432431
PALM7	2026-11-03 08:17:05.696047	North River (MO) at Palmyra	05501000	2925495	MO	Marion	NCRFC	LSX	CST6CDT	39.816944444444	-91.546111111111	true	stage	11	13	16	22	∅	∅	∅	∅	∅	Forecasts are issued as needed during times of high water, but are not routinely available.	2026-11-03 08:17:07.432431
PALL1	2026-11-03 08:17:05.696047	Intracoastal Waterway at Port Allen Lock	∅	18719612	LA	West Baton Rouge	LMRFC	LIX	CST6CDT	30.431944444444	-91.210277777778	true	stage	∅	∅	∅	∅	∅	∅	∅	∅	∅	Graphical forecasts are not available during times of high water, forecast crest information can be found in the local WFO web page.	2026-11-03 08:17:07.432431
PALP1	2026-11-03 08:17:05.696047	Allegheny River at Port Allegany	03007800	8972788	PA	Mckean	OHRFC	CTP	EST5EDT	41.8186	-78.2928	true	stage	∅	∅	∅	∅	∅	∅	∅	∅	∅	Forecasts are not available. Only observed stages are available for this point.	2026-11-03 08:17:07.432431
PALI1	2026-11-03 08:17:05.696047	Snake River near Irwin	13032500	24438932	ID	Bonneville	NWRFC	PIH	MST7MDT	43.349964	-111.217386	true	stage	11	∅	∅	∅	∅	∅	∅	∅	∅	Forecasts are issued routinely year-round.	2026-11-03 08:17:07.432431
PALF1	2026-11-03 08:17:05.696047	St. Johns River at Buffalo Bluff (in MHHW)	02244040	16665219	FL	Putnam	SERFC	JAX	EST5EDT	29.5961111111111	-81.6833333333333	true	stage	1	1.5	2	3	∅	∅	∅	∅	-2.2	Forecasts are not available. Only observed stages are available for this point.	2026-11-03 08:17:07.432431
PAKI1	2026-11-03 08:17:05.696047	Pack River near Colburn	12392300	24114491	ID	Bonner	NWRFC	OTX	PST8PDT	48.42	-116.5019	false	stage	∅	∅	∅	∅	∅	∅	∅	∅	12	Forecasts are not available. Only observed stages are available for this point.	2026-11-03 08:17:07.432431
PAJC1	2026-11-03 08:17:05.696047	Pajaro River at Watsonville	11159500	17665505	CA	Santa Cruz	CNRFC	MTR	PST8PDT	36.9056111	-121.7518889	true	stage	∅	∅	∅	∅	∅	∅	∅	∅	∅	Graphical forecasts are not available during times of high water, forecast crest information can be found in the local WFO web page.	2026-11-03 08:17:07.432431

Coverage

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

Show coverage history

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

2026

gaplessmore

Related data

Related infrastructure data
Dataset	Description
River Forecasts (Official Hydrographs)NOAA NWPS · hourly (as issued)	The official River Forecast Center hydrograph at every NWS forecast point, one row per issuance and valid time: forecast stage in feet and flow in cubic feet per second, typically six-hourly steps several days ahead. Every issuance is kept, so the latest issued_at at or before a moment is the forecast as it stood then, and comparing issuances shows how a crest forecast moved. Flow forecast at a gauge upstream of a dam is a forecast of the plant's water; a crest above flood stage is a forecast of riverside exposure. Source: NOAA National Water Prediction Service.
River Gauge Readings (Full Observed Series)NOAA NWPS · 15-minute	Every observed stage and flow reading at every NWS river gauge, at each gauge's own reporting interval (usually 15 minutes, 5 at some): stage in feet and flow in cubic feet per second. This is the complete observed record; the 15-minute gauge snapshots keep only the latest reading at each snapshot and miss readings from gauges that transmit in batches. Flow is the physical driver of hydroelectric output, and a gauge upstream of a dam leads the plant by the river's travel time. Stage is relative to each gauge's own datum and is not comparable between gauges; flow is. Source: NOAA National Water Prediction Service.
River Gauges (Stage, Flow, Flood Status)NOAA NWPS · 15-minute snapshot	Every river gauge the National Weather Service tracks, about 12,900 nationwide, snapshotted every 15 minutes: the latest observed stage in feet, flow in cubic feet per second, the NWS flood category (normal, action, minor, moderate, major, or low water), and, at the roughly one gauge in five that is a forecast point, the crest of the official River Forecast Center forecast with its time and flood category. Streamflow is the physical driver of hydroelectric output, low water and warm rivers constrain thermal-plant cooling, and a river at flood stage marks substation and line exposure, so the gauges are a grid signal wherever a market has hydro or riverside infrastructure. Stage is measured against each gauge's own datum and is not comparable between gauges; flow is. Source: NOAA National Water Prediction Service.
Advanced MetersEIA · annual (report year)	EIA-861 advanced metering: AMR, AMI and other meter counts, AMI energy served and customer access, by utility and customer class. Advanced_Meters, one row per utility, state, balancing authority and customer class. customer_class is residential, commercial, industrial, transportation (direct_connected in the distributed generation tables) or EIA's own total, so summing classes without excluding total counts everything twice. event_time is 1 January of the report year. release is final or early_release: EIA posts an early release of a year in August and replaces it with the final file in the autumn, and the mirror keeps the newest row per key. A key cell EIA leaves blank is '' or 0, and duplicate_index numbers rows that still share a key, in workbook order.