USGS Stream Gauges (15-minute)

15-minute discharge (ft3/s) and gage height (ft) at USGS gauges, with coordinates on every row.

USGSHydrology 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: gauge x parameter x statistic x 15-minute reading; 15-minute 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 (event_time, location_id, parameter_code, statistic_id) before aggregating.
Analysis rules: Filter one parameter_code (00060 discharge, 00065 gage height); include time_series_id where a site has two sensors.

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/usgs_water_continuous/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

14 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`location_id`	`LowCardinality(String)`
`parameter_code`	`LowCardinality(String)`
`statistic_id`	`LowCardinality(String)`
`value`	`Nullable(Float64)`
`unit_of_measure`	`Nullable(String)`
`approval_status`	`Nullable(String)`
`qualifier`	`Nullable(String)`
`time_series_id`	`Nullable(String)`
`observation_id`	`Nullable(String)`
`latitude`	`Nullable(Float64)`
`longitude`	`Nullable(Float64)`
`last_modified`	`DateTime64(6, 'UTC')`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	location_id	parameter_code	statistic_id	value	unit_of_measure	approval_status	qualifier	time_series_id	observation_id	latitude	longitude	last_modified	ingested_at
2026-11-03 07:50:00.000000	USGS-14372300	00065	00011	3.83	ft	Provisional	∅	5178b67527214eebba93b00e20b86310	0bd76772-98eb-4814-bdac-74ebd6b424e7	42.59277777777778	-124.062	2026-11-03 07:58:17.247692	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14372300	00060	00011	1550	ft^3/s	Provisional	∅	137532650ef04886bd7d45db1b128f32	01168c11-9f4d-4ae9-8e5c-d26135ffca34	42.59277777777778	-124.062	2026-11-03 07:58:13.980645	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14369500	00065	00011	2.18	ft	Provisional	∅	16917cfc338e46a083a17bd13c42c8ca	1d4645a1-8585-41f0-8ba2-661025b9de9d	42.3540058135007	-123.406727581687	2026-11-03 07:57:20.196313	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14369500	00060	00011	190	ft^3/s	Provisional	∅	fdbaf99f93864c4b98a49a109955d75f	ddef2547-2801-4068-87a9-e92c22405981	42.3540058135007	-123.406727581687	2026-11-03 07:57:17.478417	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14366000	00065	00011	1.12	ft	Provisional	∅	e65b48fc9cc246099dc72e92917513b0	06ee67db-d610-464c-a97d-89645acfe50e	42.2415112977177	-123.140048480701	2026-11-03 07:56:22.698613	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14366000	00060	00011	132	ft^3/s	Provisional	∅	b869564d18014cad99d7f4c93768bdfe	decd1cad-6f02-4781-ba25-1f70c99c4515	42.2415112977177	-123.140048480701	2026-11-03 07:56:20.063573	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14361600	00065	00011	4.79	ft	Provisional	∅	d1fb00c5b6b948e1897c2e99f16067bb	309cbf39-d48d-4c00-9e73-1f49c58dae0d	42.0040833333333	-123.148694444444	2026-11-03 07:56:22.521929	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14361500	00065	00011	1.11	ft	Provisional	∅	a9e43ae1791843e1b519ce5c48f482eb	f6f9a806-14f5-4abb-b753-1d093534258a	42.4303960655558	-123.317836466831	2026-11-03 07:56:19.356039	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14361500	00060	00011	1210	ft^3/s	Provisional	∅	ad8a6946dae0456e8c711022b03bda3e	b9e5f31b-a379-4f96-a4e3-7b194a707911	42.4303960655558	-123.317836466831	2026-11-03 07:56:14.556453	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14359000	00065	00011	0.85	ft	Provisional	∅	ce65d1d3125f4f67acf979e54555671b	7802ae4b-ad52-49ef-86e9-67f724d4dd07	42.4373459696809	-122.987267808388	2026-11-03 07:58:15.204388	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14359000	00060	00011	1180	ft^3/s	Provisional	∅	56a73da50db249909b23ee3d7ca01188	db109e2a-6ad0-4325-9537-65b81128e39c	42.4373459696809	-122.987267808388	2026-11-03 07:58:16.926589	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14339000	00065	00011	3	ft	Provisional	∅	a49d723a774a4761aa6a83916d525ee4	861df3fd-ac42-481a-a567-88bef5713c97	42.5248471084891	-122.842820258394	2026-11-03 07:56:15.400051	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14339000	00060	00011	1190	ft^3/s	Provisional	∅	935ea1ea8c924301bb803f7c01ff9f76	3a607293-e0e1-4def-a5d8-af3de01306ef	42.5248471084891	-122.842820258394	2026-11-03 07:56:19.291678	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14338000	00065	00011	4.22	ft	Provisional	∅	1cdb7411d9c049679597c4210e41bc6e	55e25144-47e6-4f18-a3df-4348b383072e	42.6787364239436	-122.741986705027	2026-11-03 07:56:18.779817	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14338000	00060	00011	92.6	ft^3/s	Provisional	∅	5cdd2249fa974c5a9e0cffb61d2a8b8f	b0b84b11-b69a-4298-a908-3a816ef03894	42.6787364239436	-122.741986705027	2026-11-03 07:56:20.893939	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14337600	00065	00011	1.74	ft	Provisional	∅	6cf4cf66b39747c5a5453372978f3f2c	436a0784-ab66-4069-ae5d-1e1cc86688de	42.6554035422131	-122.715040824291	2026-11-03 07:56:20.864101	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14337600	00060	00011	1080	ft^3/s	Provisional	∅	3528078a266f453886688e23700861ec	ee06cf08-8220-4162-ab13-79f852423817	42.6554035422131	-122.715040824291	2026-11-03 07:56:21.995524	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14337500	00065	00011	2.82	ft	Provisional	∅	d9df86faaa2646f6a58352ff22d6b2c2	a33c5ed8-bae9-4753-aeb7-b2dc21a5e6af	42.6512371979792	-122.69142881941	2026-11-03 07:56:18.193117	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14337500	00060	00011	64.7	ft^3/s	Provisional	∅	b43b86a0f4d54f308c3bf120b5d8eb17	ac589e5a-1401-4bbb-9799-1aec70d62214	42.6512371979792	-122.69142881941	2026-11-03 07:56:15.398234	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14335072	00065	00011	1.68	ft	Provisional	∅	711d2faf1c844680854feb7e2089848a	7d5658c8-fbb7-4ff4-9e1e-56203271d4c4	42.6658333333333	-122.686388888889	2026-11-03 07:56:18.067362	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14335072	00060	00011	709	ft^3/s	Provisional	∅	e980751dcc344efcb4f222c495e45048	bed1abf7-1730-4bcf-9d10-c6b70cb985d3	42.6658333333333	-122.686388888889	2026-11-03 07:56:18.496468	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14330000	00065	00011	1.23	ft	Provisional	∅	9b2fae2bddcd41f596f272711a2a7a94	fcf22147-3001-4b82-bc86-135d4edf3787	42.7295718711378	-122.516146965948	2026-11-03 07:56:14.824622	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14330000	00060	00011	555	ft^3/s	Provisional	∅	59c52497033b4710b2decc9f8063f22a	cfe3e3ad-c3fe-4c30-b897-5985cd3fac9e	42.7295718711378	-122.516146965948	2026-11-03 07:56:19.086206	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14299800	00065	00011	3.89	ft	Provisional	∅	9beaaac5177649f2b16184c2a4490ae2	efd62bb4-8353-4e6d-89f9-42ff30fee7a6	45.8070558557861	-123.283172182797	2026-11-03 07:58:17.302067	2026-11-03 08:01:13.839658
2026-11-03 07:50:00.000000	USGS-14299800	00060	00011	9.92	ft^3/s	Provisional	∅	68c69ba54ed04e6ba09db459a6eb164c	c36d83d8-0b7d-40fe-9d00-58cb818e3d2b	45.8070558557861	-123.283172182797	2026-11-03 07:59:16.409708	2026-11-03 08:01:13.839658

Coverage

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

Show coverage history

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

2026

gaplessmore

Related data

Related hydrology data
Dataset	Description
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.
CONAGUA Hydrometric and Climate StationsCONAGUA · catalog snapshot	CONAGUA's catalogs of reservoirs, river gauges and weather stations across Mexico, with name, coordinates, altitude, state and municipality.
ECCC Daily Mean Hydrometric (Columbia)ECCC · daily	HYDAT daily mean level and discharge for Canadian Columbia basin gauges and reservoirs, back to 1903.