Major U.S. river discharge, daily mean (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.

Daily mean streamflow discharge in cubic feet per second for 15 major-river USGS gaging stations (Potomac, Delaware, Susquehanna, Hudson, James, Apalachicola, Missouri, Mississippi x3, Ohio x2, Yellowstone, Columbia, Willamette), trailing 365 days, refreshed daily. Provenance: USGS Water Services Daily Values web service (https://waterservices.usgs.gov/nwis/dv/, parameter 00060, stat code 00003 = daily mean), U.S. public domain - please credit the U.S. Geological Survey. Coverage: 15 fixed gages across the eastern, midwestern and western United States, trailing 365 days from the refresh date; the most recent 1-2 days are typically absent (daily means are computed after the day closes). Values flagged provisional ('P') are subject to USGS revision; revised values surface as new snapshots. Primary key: (site_no, date). Join keys: site_no (USGS station number), date (ISO). Nullability: discharge_cfs may be null when the service publishes no value for a day. Sample use: filter site_no='07010000' for the Mississippi at St. Louis hydrograph.

Source: USGS Earthquake Hazards Program
Rows: 5,414
Columns: 7
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 together with date.
station_name	string	USGS station name from the service's sourceInfo (e.g. 'POTOMAC RIVER NEAR WASH, DC LITTLE FALLS PUMP STA').
latitude	float	Gage latitude (the service's geogLocation, EPSG:4326). (unit: degrees)
longitude	float	Gage longitude (the service's geogLocation, EPSG:4326). (unit: degrees)
date	string	Observation date (the daily value's dateTime, gage-local date).
discharge_cfs	float	Daily mean streamflow discharge (USGS parameter 00060, stat code 00003). Null when the service publishes no value for the day; never interpolated. (unit: ft3/s)
data_status	string	USGS qualifier roll-up for the day: '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	date	discharge_cfs	data_status
01358000	HUDSON RIVER AT GREEN ISLAND NY	42.752	-73.689	2025-09-25	9,360	approved
01358000	HUDSON RIVER AT GREEN ISLAND NY	42.752	-73.689	2025-09-26	8,730	approved
01358000	HUDSON RIVER AT GREEN ISLAND NY	42.752	-73.689	2025-09-27	8,980	approved
01358000	HUDSON RIVER AT GREEN ISLAND NY	42.752	-73.689	2025-09-28	6,790	approved
01358000	HUDSON RIVER AT GREEN ISLAND NY	42.752	-73.689	2025-09-29	6,060	approved
01358000	HUDSON RIVER AT GREEN ISLAND NY	42.752	-73.689	2025-09-30	5,660	approved
01358000	HUDSON RIVER AT GREEN ISLAND NY	42.752	-73.689	2025-10-01	5,540	approved
01358000	HUDSON RIVER AT GREEN ISLAND NY	42.752	-73.689	2025-10-02	4,890	approved
01358000	HUDSON RIVER AT GREEN ISLAND NY	42.752	-73.689	2025-10-03	3,950	approved
01358000	HUDSON RIVER AT GREEN ISLAND NY	42.752	-73.689	2025-10-04	4,570	approved

Profiled Sep 25, 2026 from snapshot 20260925T193329Z-7d975b877ed2

Measured

Completeness: 100%
Rows: 5,414
Columns: 7
Columns with gaps: 0

Rows per yeardate · 2025–2026 · 2 years

20252026

Column	Missing	Distinct	Range	Distribution
site_novarchar	0%	17	—	01358000365 01578310365 01646500365
station_namevarchar	0%	16	—	COLUMBIA RIVER AT THE DALLES, OR365 HUDSON RIVER AT GREEN ISLAND NY365 MISSISSIPPI RIVER AT MEMPHIS, TN365
latitudedouble	0%	12	29.59 → 47.68median 38.71
longitudedouble	0%	16	-122.67 → -73.69median -86.71
datevarchar	0%	587	—	2025-09-2515 2025-09-2615 2025-09-2715
discharge_cfsdouble	0%	1,820	832 → 841,000median 27,200	109 outside 1st–99th percentile
data_statusvarchar	0%	2	—	provisional3,692 approved1,722

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_discharge_daily" | jq '{title, rows, columns_count, license}'

Python

import requests

ds = requests.get("https://datazimuts.com/v1/datasets/usgs/usgs_river_discharge_daily").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_discharge_daily

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

Cite this snapshot

Pinned to snapshot 20260925T193329Z-7d975b877ed2 and its content hash, so readers get exactly the data you used.

APA

USGS Earthquake Hazards Program. (2026). Major U.S. river discharge, daily mean (15 gages) [Data set, snapshot 20260925T193329Z-7d975b877ed2, sha256 7d975b877ed2]. Datazimuts. Retrieved 2026-09-25, from https://datazimuts.com/en/datasets/usgs/usgs_river_discharge_daily?snapshot=20260925T193329Z-7d975b877ed2

BibTeX

@misc{dz_usgs_usgs_river_discharge_daily_7d975b87,
  title        = {{Major U.S. river discharge, daily mean (15 gages)}},
  author       = {{USGS Earthquake Hazards Program}},
  year         = {2026},
  publisher    = {Datazimuts},
  howpublished = {\url{https://datazimuts.com/en/datasets/usgs/usgs_river_discharge_daily?snapshot=20260925T193329Z-7d975b877ed2}},
  note         = {Snapshot 20260925T193329Z-7d975b877ed2, sha256 7d975b877ed2035c27f56352318c471dc6461924827c9b27984af1c172a691fa; 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_discharge_daily&lang=en&theme=auto&snapshot=20260925T193329Z-7d975b877ed2&x=date&y=latitude&agg=avg" title="Major U.S. river discharge, daily mean (15 gages)" width="100%" height="380" style="border:0" loading="lazy"></iframe>

Major U.S. river discharge, daily mean (15 gages)

Follow this dataset

Cite this snapshot

Embed a table or a chart

Use your own AI key