API reference

GET /v1

The API index for this site.

• site, name, tagline
• api_version: "v1"
• links.catalog, links.status

Example: https://api.waterdata.dev/v1

GET /v1/catalog

Every dataset published on this site.

• site
• datasets[]: id, kind, title, description, current (version), published_at, cadence, check_every, sla, discontinued
• datasets[].source: name, url, license, commercial_ok
• datasets[].coverage: start, end

Example: https://api.waterdata.dev/v1/catalog

GET /v1/status

How fresh each dataset is.

• site, generated_at, overall ("ok" or "degraded")
• datasets[]: id, status, version, checked_at, source_updated_at, sla, consecutive_failures, last_error
• status is one of ok, pending, late, stale-upstream, failing, blocked, discontinued

Example: https://api.waterdata.dev/v1/status

GET /v1/{dataset}

Metadata for one dataset: the version that answered, its coverage, source, validation and downloads.

• dataset, kind, title, description, cadence
• version, current_version, pinned, published_at
• source: id, name, publisher, url, license, commercial_ok, attribution, retrieved_at, source_updated_at
• coverage: start, end
• validation: status (pass, warn), warnings[]
• series[]: id, name; for tables also key[] and partition
• downloads[]: name, bytes, url
• links: locations, versions, this_version

Example: https://api.waterdata.dev/v1/drought-county

Errors: unknown-dataset , unknown-version , data-unavailable , and rate-limited for any endpoint.

GET /v1/{dataset}/versions

The version history.

• dataset, current, published_at
• previous[]: earlier version ids, newest first
• snapshots: month (YYYY-MM) to version id

Example: https://api.waterdata.dev/v1/drought-county/versions

Errors: unknown-dataset , and rate-limited for any endpoint.

GET /v1/{dataset}/locations

What can be requested: each series with its location ids, or for tables the partitions (under the series id "table").

• dataset, version, kind
• series[]: id, name, locations[] (ids)
• locations[]: id, name

Example: https://api.waterdata.dev/v1/drought-county/locations

Errors: unknown-dataset , unknown-version , and rate-limited for any endpoint.

GET /v1/{dataset}/{series}/{location}.json

One series at one place, ordered by date. Also .csv.

• meta: dataset, series, series_name, location, location_name, units, source, license, attribution
• data[]: one object per row, with the dataset's columns

Example: https://api.waterdata.dev/v1/drought-county/area/us-county-06037.json

Errors: unknown-file , unknown-format , and rate-limited for any endpoint.

GET /v1/{dataset}/table/{partition}.json

Rows of a table for one partition value; table/all has every row for tables up to 50,000 rows. Also .csv.

• meta: dataset, key, partition (when partitioned), rows (count), units, source, license, attribution
• rows[]: one object per row

Example: https://api.waterdata.dev/v1/stream-gages/table/all.json

Errors: unknown-file , unknown-format , and rate-limited for any endpoint.

GET /v1/{dataset}/download/{dataset}.csv

The whole dataset in one file. Also .parquet. Series downloads add series and location columns.

• CSV (text/csv) or Parquet (application/vnd.apache.parquet)
• Supports Range requests (206)

Example: https://api.waterdata.dev/v1/drought-county/download/drought-county.csv

Errors: unknown-file , and rate-limited for any endpoint.

GET /v1/{dataset}/{path}

A file of a files dataset, at its published path.

• The file, with a content type from its extension

Errors: unknown-file , and rate-limited for any endpoint.

County drought categories Time series

Id

drought-county

Updates

Weekly

Series

area

Columns

date date (YYYY-MM-DD) , none number, percent , d0 number, percent , d1 number, percent , d2 number, percent , d3 number, percent , d4 number, percent

USGS stream gages Table

Id

stream-gages

Updates

Daily

Key

site_id

Partition

region

Columns

site_id text , site_number text , name text , site_type_code text , site_type text , region text , country text , state text , county_fips text , county_name text , huc text , huc8 text , latitude number, degrees , longitude number, degrees , drainage_area number, mi^2 , contributing_drainage_area number, mi^2 , altitude number, ft , altitude_datum text , time_zone text , time_series_id text , sublocation text , daily_begin date (YYYY-MM-DD) , daily_end date (YYYY-MM-DD)

Daily streamflow Time series

Id

streamflow-daily

Updates

Daily

Series

discharge

Columns

date date (YYYY-MM-DD) , value number, ft^3/s , provisional true / false , estimated true / false , ice true / false , qualifiers text