18 Sept 2026

Hourly rainfall and gauge history, U.S. cities, 2000–2026

Back to data

Updated 18 Sept 2026

3.4 MB across 1 part, newest sealed 18 September 2026 at 20:45 UTC.

The last refresh changed nothing.

STATION_HOUR_UNIQUE passed.

ROWS_PRESENT passed.

NONNEGATIVE_PRECIPITATION passed.

station_id

string

Current canonical station identifier; historical aliases resolve to this station.

KNYC100%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 1 · 0% of valid

city

string

City associated with the observation station.

New York City100%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 1 · 0% of valid

state

string

U.S. state abbreviation.

NY100%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 1 · 0% of valid

ghcn_id

string

NOAA GHCN station identifier.

USW00094728100%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 1 · 0% of valid

hour_utc

timestamp_utc

UTC hour bucket containing the selected report time.

2000-01-01 05:00:00+000%
2000-01-01 06:00:00+000%
2000-01-01 07:00:00+000%
Other (232,059)

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 232,071 · 100% of valid

observed_at

timestamp_utc

Selected report timestamp converted from local standard time to UTC.

2000-01-01 05:00:00+000%
2000-01-01 06:00:00+000%
2000-01-01 07:00:00+000%
Other (232,059)

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 232,071 · 100% of valid

reported_local_standard_time

string

Original NOAA report time in local standard time without daylight saving adjustments.

2000-01-01 00:00:000%
2000-01-01 01:00:000%
2000-01-01 02:00:000%
Other (232,059)

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 232,071 · 100% of valid

report_type

string

SODHP hourly summary preferred; FM-15 routine METAR fallback.

FM-1597%
SODHP3%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 2 · 0% of valid

report_source

string

NOAA source code.

34380%
33518%
2232%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 4 · 0% of valid

precipitation_raw

string

Original HourlyPrecipitation token, preserving trace and quality flags.

0.089%
T3%
0.32%
Other (132)

Valid: 227,072 · 97.8%
Missing: 4,999 · 2.2%
Distinct: 144 · 0.1% of valid

precipitation_mm

decimal

Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.

0.000092%
0.30002%
0.50001%
Other (131)

Valid: 219,525 · 94.6%
Missing: 12,546 · 5.4%
Distinct: 143 · 0.1% of valid
Min: 0.0000
25%: 0.0000
Median: 0.0000
75%: 0.0000
Max: 88.1000

is_trace

boolean

True for source trace token T.

false97%
true3%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 2 · 0% of valid

quality_status

string

Missing, trace, numeric, suspect, or unparsed source value.

numeric95%
trace3%
missing2%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 3 · 0% of valid

interval_basis

string

Summary hourly interval or preceding rolling hour of a routine METAR.

rolling_hour_metar_fallback97%
summary_hourly3%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 2 · 0% of valid

is_latest

boolean

True for the most recent report hour available for this station.

false100%
true0%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 2 · 0% of valid

source_url

string

NOAA acquisition URL for the source time slice.

https://www.ncei.noaa.gov/access/services/data/v1?dataset=local-climatological-data-v2&stations=USW00094728&startDate=2018-01-01&endDate=2020-12-31&dataTypes=HourlyPrecipitation&format=csv&units=metric11%
https://www.ncei.noaa.gov/access/services/data/v1?dataset=local-climatological-data-v2&stations=USW00094728&startDate=2006-01-01&endDate=2008-12-31&dataTypes=HourlyPrecipitation&format=csv&units=metric11%
https://www.ncei.noaa.gov/access/services/data/v1?dataset=local-climatological-data-v2&stations=USW00094728&startDate=2009-01-01&endDate=2011-12-31&dataTypes=HourlyPrecipitation&format=csv&units=metric11%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 9 · 0% of valid

snapshot_date

date

Date this archived source snapshot was requested.

2026-09-14100%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 1 · 0% of valid

latitude

decimal

Station latitude effective on the local report date; approximate gauge location.

40.7789800100%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 1 · 0% of valid
Min: 40.7789800
25%: 40.7789800
Median: 40.7789800
75%: 40.7789800
Max: 40.7789800

longitude

decimal

Station longitude effective on the local report date; approximate gauge location.

-73.9692500100%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 1 · 0% of valid
Min: -73.9692500
25%: -73.9692500
Median: -73.9692500
75%: -73.9692500
Max: -73.9692500

coordinate_precision

string

Published precision code for the historical coordinate.

DDddddd100%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 1 · 0% of valid

coordinate_datum

string

Published horizontal datum.

No distribution published

Valid: 0 · 0%
Missing: 232,071 · 100%
Distinct: 0 · 0% of valid

coordinate_source

string

Published coordinate evidence source.

USGS TOPOGRAPHICAL MAP100%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 1 · 0% of valid

location_valid_from

date

Start of the matched location effective period.

1961-01-01100%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 1 · 0% of valid

location_valid_to

date

End of the matched period; null for Present.

No distribution published

Valid: 0 · 0%
Missing: 232,071 · 100%
Distinct: 0 · 0% of valid

metadata_source_url

string

NOAA HOMR station-history source.

https://www.ncei.noaa.gov/access/homr/services/station/20019453?date=all&definitions=false100%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 1 · 0% of valid

equipment_types

string

Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.

AWPAG83%
TB14%
UNIV3%

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 5 · 0% of valid

equipment_record_count

integer

Number of active precipitation equipment history records, including overlapping observation programs.

Valid: 232,071 · 100%
Missing: 0 · 0%
Distinct: 2 · 0% of valid
Min: 2
25%: 2
Median: 2
75%: 2
Max: 4