18 Sept 2026

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

Name: philadelphia_hourly
Creator: Mostly Right
Published: 2026-09-14T21:16:48.070Z
License: https://creativecommons.org/publicdomain/zero/1.0/

Updated 18 Sept 2026

station_id	city	state	ghcn_id	hour_utc	observed_at	reported_local_standard_time	report_type	report_source	precipitation_raw	precipitation_mm	is_trace	quality_status	interval_basis	is_latest	snapshot_date	latitude	longitude	coordinate_precision	coordinate_datum	coordinate_source	location_valid_from	location_valid_to	metadata_source_url	equipment_types	equipment_record_count
KPHL	Philadelphia	PA	USW00013739	2000-01-01T05:00:00.000000Z	2000-01-01T05:54:00.000000Z	2000-01-01 00:54:00	FM-15	335	∅	∅	false	missing	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-01T06:00:00.000000Z	2000-01-01T06:54:00.000000Z	2000-01-01 01:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-01T07:00:00.000000Z	2000-01-01T07:54:00.000000Z	2000-01-01 02:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-01T08:00:00.000000Z	2000-01-01T08:54:00.000000Z	2000-01-01 03:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-01T09:00:00.000000Z	2000-01-01T09:54:00.000000Z	2000-01-01 04:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-01T10:00:00.000000Z	2000-01-01T10:54:00.000000Z	2000-01-01 05:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-01T11:00:00.000000Z	2000-01-01T11:54:00.000000Z	2000-01-01 06:54:00	FM-15	335	∅	∅	false	missing	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-01T12:00:00.000000Z	2000-01-01T12:54:00.000000Z	2000-01-01 07:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-01T13:00:00.000000Z	2000-01-01T13:54:00.000000Z	2000-01-01 08:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-01T14:00:00.000000Z	2000-01-01T14:54:00.000000Z	2000-01-01 09:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-01T15:00:00.000000Z	2000-01-01T15:54:00.000000Z	2000-01-01 10:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-01T16:00:00.000000Z	2000-01-01T16:54:00.000000Z	2000-01-01 11:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-01T17:00:00.000000Z	2000-01-01T17:54:00.000000Z	2000-01-01 12:54:00	FM-15	335	∅	∅	false	missing	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-01T18:00:00.000000Z	2000-01-01T18:54:00.000000Z	2000-01-01 13:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-01T19:00:00.000000Z	2000-01-01T19:54:00.000000Z	2000-01-01 14:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-01T20:00:00.000000Z	2000-01-01T20:54:00.000000Z	2000-01-01 15:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-01T21:00:00.000000Z	2000-01-01T21:54:00.000000Z	2000-01-01 16:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-01T22:00:00.000000Z	2000-01-01T22:54:00.000000Z	2000-01-01 17:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-01T23:00:00.000000Z	2000-01-01T23:54:00.000000Z	2000-01-01 18:54:00	FM-15	335	∅	∅	false	missing	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T00:00:00.000000Z	2000-01-02T00:54:00.000000Z	2000-01-01 19:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T01:00:00.000000Z	2000-01-02T01:54:00.000000Z	2000-01-01 20:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T02:00:00.000000Z	2000-01-02T02:54:00.000000Z	2000-01-01 21:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T03:00:00.000000Z	2000-01-02T03:54:00.000000Z	2000-01-01 22:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T04:00:00.000000Z	2000-01-02T04:54:00.000000Z	2000-01-01 23:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T05:00:00.000000Z	2000-01-02T05:54:00.000000Z	2000-01-02 00:54:00	FM-15	335	∅	∅	false	missing	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T06:00:00.000000Z	2000-01-02T06:54:00.000000Z	2000-01-02 01:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T07:00:00.000000Z	2000-01-02T07:54:00.000000Z	2000-01-02 02:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T08:00:00.000000Z	2000-01-02T08:54:00.000000Z	2000-01-02 03:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T09:00:00.000000Z	2000-01-02T09:54:00.000000Z	2000-01-02 04:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T10:00:00.000000Z	2000-01-02T10:54:00.000000Z	2000-01-02 05:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T11:00:00.000000Z	2000-01-02T11:54:00.000000Z	2000-01-02 06:54:00	FM-15	335	∅	∅	false	missing	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T12:00:00.000000Z	2000-01-02T12:54:00.000000Z	2000-01-02 07:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T13:00:00.000000Z	2000-01-02T13:54:00.000000Z	2000-01-02 08:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T14:00:00.000000Z	2000-01-02T14:54:00.000000Z	2000-01-02 09:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T15:00:00.000000Z	2000-01-02T15:54:00.000000Z	2000-01-02 10:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T16:00:00.000000Z	2000-01-02T16:54:00.000000Z	2000-01-02 11:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T17:00:00.000000Z	2000-01-02T17:54:00.000000Z	2000-01-02 12:54:00	FM-15	335	∅	∅	false	missing	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T18:00:00.000000Z	2000-01-02T18:54:00.000000Z	2000-01-02 13:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T19:00:00.000000Z	2000-01-02T19:54:00.000000Z	2000-01-02 14:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T20:00:00.000000Z	2000-01-02T20:54:00.000000Z	2000-01-02 15:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T22:00:00.000000Z	2000-01-02T22:00:00.000000Z	2000-01-02 17:00:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-02T23:00:00.000000Z	2000-01-02T23:00:00.000000Z	2000-01-02 18:00:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-03T00:00:00.000000Z	2000-01-03T00:00:00.000000Z	2000-01-02 19:00:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-03T01:00:00.000000Z	2000-01-03T01:54:00.000000Z	2000-01-02 20:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-03T02:00:00.000000Z	2000-01-03T02:54:00.000000Z	2000-01-02 21:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-03T03:00:00.000000Z	2000-01-03T03:54:00.000000Z	2000-01-02 22:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-03T04:00:00.000000Z	2000-01-03T04:54:00.000000Z	2000-01-02 23:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-03T05:00:00.000000Z	2000-01-03T05:54:00.000000Z	2000-01-03 00:54:00	FM-15	335	∅	∅	false	missing	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-03T06:00:00.000000Z	2000-01-03T06:54:00.000000Z	2000-01-03 01:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2
KPHL	Philadelphia	PA	USW00013739	2000-01-03T07:00:00.000000Z	2000-01-03T07:54:00.000000Z	2000-01-03 02:54:00	FM-15	335	0.0	0	false	numeric	rolling_hour_metar_fallback	false	2026-09-14	39.8732600	-75.2268100	DDddddd	WGS84	ASOS CM	1995-12-01	∅	https://www.ncei.noaa.gov/access/homr/services/station/10010044?date=all&definitions=false	UNIV	2

50 of 232,877 rows loaded