Major U.S. river latest conditions (15 gages)

Commercial use OKFresh

The full snapshot isn't published yet — check back after the next refresh.Download sample CSV Download sample JSONSample rows only (up to 20) — not the complete dataset.

Latest instantaneous river conditions for the same 15 major-river USGS gaging stations as the daily discharge dataset: discharge in cubic feet per second (parameter 00060) and gage height in feet (parameter 00065), each with its observation timestamp (UTC). One row per gage, refreshed daily. Provenance: USGS Water Services Instantaneous Values web service (https://waterservices.usgs.gov/nwis/iv/), U.S. public domain - please credit the U.S. Geological Survey. Observation times differ per gage (telemetry schedules vary); values are provisional and subject to revision. A gage missing a parameter reports null for it, never an invented value. Primary key: site_no. Sample use: order by discharge_cfs desc for today's highest-flowing monitored rivers.

Source: USGS Earthquake Hazards Program
Rows: 15
Columns: 9
Source cadence: Daily
Last refreshed: Sep 25, 2026
Theme: environment

Column	Type	Description
site_no	string	USGS station number (the service's siteCode); stable primary key.
station_name	string	USGS station name from the service's sourceInfo.
latitude	float	Gage latitude (the service's geogLocation, EPSG:4326). (unit: degrees)
longitude	float	Gage longitude (the service's geogLocation, EPSG:4326). (unit: degrees)
discharge_cfs	float	Latest instantaneous streamflow discharge (USGS parameter 00060). Null when the gage does not report it. (unit: ft3/s)
discharge_observed_at	string	Timestamp of the latest discharge observation, converted to UTC ISO 8601.
gage_height_ft	float	Latest instantaneous gage height (USGS parameter 00065). Null when the gage does not report it. (unit: ft)
gage_height_observed_at	string	Timestamp of the latest gage-height observation, converted to UTC ISO 8601.
data_status	string	USGS qualifier roll-up for the latest observations: 'provisional' (qualifier P - subject to revision), 'approved' (qualifier A), or 'unknown'.

First 10 sample rows — a preview, not the complete dataset.

site_no	station_name	latitude	longitude	discharge_cfs	discharge_observed_at	gage_height_ft	gage_height_observed_at	data_status
01358000	HUDSON RIVER AT GREEN ISLAND NY	42.752	-73.689	2,320	2026-09-25T19:15:00+00:00	16.19	2026-09-25T19:15:00+00:00	provisional
01463500	Delaware River at Trenton NJ	40.222	-74.778	4,740	2026-09-25T19:15:00+00:00	8.9	2026-09-25T19:15:00+00:00	provisional
01578310	SUSQUEHANNA RIVER AT CONOWINGO, MD	39.658	-76.174	48,400	2026-09-25T18:35:00+00:00	14.18	2026-09-25T18:35:00+00:00	provisional
01646500	POTOMAC RIVER NEAR WASH, DC LITTLE FALLS PUMP STA	38.95	-77.128	3,570	2026-09-25T18:50:00+00:00	3.13	2026-09-25T18:50:00+00:00	provisional
02037500	JAMES RIVER NEAR RICHMOND, VA	37.563	-77.547	1,570	2026-09-25T17:30:00+00:00	3.58	2026-09-25T17:30:00+00:00	provisional
02323500	SUWANNEE RIVER NEAR WILCOX, FLA.	29.59	-82.937	2,880	2026-09-25T18:30:00+00:00	3.07	2026-09-25T18:30:00+00:00	provisional
03294500	OHIO RIVER AT LOUISVILLE, KY	38.28	-85.799	210,000	2026-09-25T18:45:00+00:00	29.87	2026-09-25T19:00:00+00:00	provisional
03303280	OHIO RIVER AT CANNELTON DAM AT CANNELTON, IN	37.9	-86.706	246,000	2026-09-25T18:00:00+00:00	24.82	2026-09-25T19:00:00+00:00	provisional
06329500	Yellowstone River near Sidney MT	47.677	-104.155	6,700	2026-09-25T19:00:00+00:00	2.9	2026-09-25T19:00:00+00:00	provisional
06934500	Missouri River at Hermann, MO	38.71	-91.439	63,900	2026-09-25T18:30:00+00:00	7.65	2026-09-25T18:30:00+00:00	provisional

Profiled Sep 25, 2026 from snapshot 20260925T193337Z-416f90eb0948

Measured

Completeness: 98.5%
Rows: 15
Columns: 9
Columns with gaps: 2

Column	Missing	Distinct	Range	Distribution
site_novarchar	0%	17	—	013580001 014635001 015783101
station_namevarchar	0%	16	—	COLUMBIA RIVER AT THE DALLES, OR1 Delaware River at Trenton NJ1 HUDSON RIVER AT GREEN ISLAND NY1
latitudedouble	0%	12	29.59 → 47.68median 38.71	2 outside 1st–99th percentile
longitudedouble	0%	16	-122.67 → -73.69median -86.71	2 outside 1st–99th percentile
discharge_cfsdouble	0%	16	1,570 → 325,000median 48,400	2 outside 1st–99th percentile
discharge_observed_atvarchar	0%	9	—	2026-09-25T19:15:00+00:004 2026-09-25T19:00:00+00:003 2026-09-25T18:30:00+00:002
gage_height_ftdouble	6.7%	16	0.93 → 76.12median 8.28	2 outside 1st–99th percentile
gage_height_observed_atvarchar	6.7%	6	—	2026-09-25T19:15:00+00:005 2026-09-25T19:00:00+00:004 2026-09-25T18:30:00+00:002
data_statusvarchar	0%	1	—	provisional15

Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).

cURL

curl "https://datazimuts.com/v1/datasets/usgs/usgs_river_conditions_latest" | jq '{title, rows, columns_count, license}'

Python

import requests

ds = requests.get("https://datazimuts.com/v1/datasets/usgs/usgs_river_conditions_latest").json()
print(ds["title"], ds["rows"], "rows")

# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
    print(row)

API endpoint: https://datazimuts.com/v1/datasets/usgs/usgs_river_conditions_latest

Tip: fetch /llms.txt for the full machine-readable catalog.

Cite this snapshot

Pinned to snapshot 20260925T193337Z-416f90eb0948 and its content hash, so readers get exactly the data you used.

APA

USGS Earthquake Hazards Program. (2026). Major U.S. river latest conditions (15 gages) [Data set, snapshot 20260925T193337Z-416f90eb0948, sha256 416f90eb0948]. Datazimuts. Retrieved 2026-09-25, from https://datazimuts.com/en/datasets/usgs/usgs_river_conditions_latest?snapshot=20260925T193337Z-416f90eb0948

BibTeX

@misc{dz_usgs_usgs_river_conditions_latest_416f90eb,
  title        = {{Major U.S. river latest conditions (15 gages)}},
  author       = {{USGS Earthquake Hazards Program}},
  year         = {2026},
  publisher    = {Datazimuts},
  howpublished = {\url{https://datazimuts.com/en/datasets/usgs/usgs_river_conditions_latest?snapshot=20260925T193337Z-416f90eb0948}},
  note         = {Snapshot 20260925T193337Z-416f90eb0948, sha256 416f90eb0948c61f77419b661709c08ae70448590a54966daf602a6ffc019366; accessed 2026-09-25}
}

Embed a table or a chart

Paste this into any page. The embed is pinned to the same snapshot, follows the reader's light or dark setting, and always shows the source, license and a link back.

Type

X axis

Value

Aggregate

Theme

HTML

<iframe src="https://datazimuts.com/embed/chart?dataset=usgs%2Fusgs_river_conditions_latest&lang=en&theme=auto&snapshot=20260925T193337Z-416f90eb0948&x=site_no&y=latitude&agg=avg" title="Major U.S. river latest conditions (15 gages)" width="100%" height="380" style="border:0" loading="lazy"></iframe>

Major U.S. river latest conditions (15 gages)

Follow this dataset

Cite this snapshot

Embed a table or a chart

Use your own AI key