Merced River

96 readings, oldest first. Sorting and paging need JavaScript; every row is already here.

Download the data

Download all readings for this stream (CSV) 1.0 MB

This is the complete record for Merced River as one CSV file, rebuilt by the publisher on every build. The archive copy of the same readings may be split into yearly segments; this file is not a link to a segment and always has the same name.

What is in the file

One row per reading, plus a header row that is always there: UTF-8 without a byte-order mark, LF line endings, and RFC 4180 quoting, so a field is quoted only when it holds a comma, a quote, or a line break. Rows are in a fixed order — gage, then measurement, then time — which is what lets two versions of the file be compared line by line to find what changed. Values are the exact numbers the site stores, not rounded for display; the unit each one is in travels with it in the row, in unit_metric, unit_imperial, and raw_unit. Both observed_at_utc and ingested_at_utc are ISO-8601 in UTC with a trailing Z and whole seconds, so a timestamp is never ambiguous across the daylight-saving change; the local times in the table above are those same instants read in the gage's time zone.

stream_slug

Which stream the reading belongs to. Every row of this file is the same stream.

gage_slug

Which gage on that stream took it — a stream can have more than one.

logger_sn

The data logger's serial number, recorded with the reading and never rewritten.

sensor_sn

The sensor's serial number, so swapping a sensor later cannot move an old reading's provenance.

measurement_type

What was measured, as a code — the same codes this page labels in its own column headings.

observed_at_utc

When the reading was taken, as ISO-8601 UTC with a trailing Z, whole seconds: 2026-09-14T21:45:00Z.

value_metric

The value in metric units, exactly as the site stores it.

unit_metric

The unit value_metric is in, written in each row beside it.

value_imperial

The same value in US units, converted with the unit registry's factor and rounded to its precision plus two places.

unit_imperial

The unit value_imperial is in.

raw_value

The value as the logger reported it, before any conversion.

raw_unit

The unit raw_value is in, as the logger reported it.

source

Which ingest path produced the row, so a change of instrument is visible in the data.

ingested_at_utc

When the site stored the reading, in ISO-8601 UTC with a trailing Z — when it arrived, not when it was measured.

Attribution: data from LI-COR Cloud gages, published by Water Audit California. Please keep the gage and the observation time with any value you reuse, so it can be checked.

License: the readings are published under the MIT/X Consortium License.