Loading dataset
Back to data
Updated

6.8 MB across 1 part, newest sealed 18 September 2026 at 20:46 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.

  • KHOU50%
  • KIAH50%
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

city

string

City associated with the observation station.

  • Houston100%
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
1 · 0% of valid

state

string

U.S. state abbreviation.

  • TX100%
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
1 · 0% of valid

ghcn_id

string

NOAA GHCN station identifier.

  • USW0001291850%
  • USW0001296050%
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

hour_utc

timestamp_utc

UTC hour bucket containing the selected report time.

  • 2000-01-01 06:00:00+000%
  • 2000-01-01 07:00:00+000%
  • 2000-01-01 08:00:00+000%
  • Other (233,426)
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
233,438 · 50.1% of valid

observed_at

timestamp_utc

Selected report timestamp converted from local standard time to UTC.

  • 2000-01-01 06:53:00+000%
  • 2000-01-01 07:53:00+000%
  • 2000-01-01 08:53:00+000%
  • Other (234,167)
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
234,179 · 50.2% of valid

reported_local_standard_time

string

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

  • 2000-01-01 00:53:000%
  • 2000-01-01 01:53:000%
  • 2000-01-01 02:53:000%
  • Other (234,167)
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
234,179 · 50.2% of valid

report_type

string

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

  • FM-1598%
  • SODHP2%
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

report_source

string

NOAA source code.

  • 34380%
  • 33519%
  • 2231%
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
4 · 0% of valid

precipitation_raw

string

Original HourlyPrecipitation token, preserving trace and quality flags.

  • 0.090%
  • T5%
  • 0.31%
  • Other (225)
Valid
451,550 · 96.9%
Missing
14,512 · 3.1%
Distinct
237 · 0.1% of valid

precipitation_mm

decimal

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

  • 0.000095%
  • 0.30001%
  • 0.50001%
  • Other (224)
Valid
429,693 · 92.2%
Missing
36,369 · 7.8%
Distinct
236 · 0.1% of valid
Min
0.0000
25%
0.0000
Median
0.0000
75%
0.0000
Max
104.4000

is_trace

boolean

True for source trace token T.

  • false95%
  • true5%
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

quality_status

string

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

  • numeric92%
  • trace5%
  • missing3%
Valid
466,062 · 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_fallback98%
  • summary_hourly2%
Valid
466,062 · 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
466,062 · 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=USW00012918&startDate=2012-01-01&endDate=2014-12-31&dataTypes=HourlyPrecipitation&format=csv&units=metric6%
  • https://www.ncei.noaa.gov/access/services/data/v1?dataset=local-climatological-data-v2&stations=USW00012918&startDate=2015-01-01&endDate=2017-12-31&dataTypes=HourlyPrecipitation&format=csv&units=metric6%
  • https://www.ncei.noaa.gov/access/services/data/v1?dataset=local-climatological-data-v2&stations=USW00012918&startDate=2018-01-01&endDate=2020-12-31&dataTypes=HourlyPrecipitation&format=csv&units=metric6%
  • Other (6)
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
18 · 0% of valid

snapshot_date

date

Date this archived source snapshot was requested.

  • 2026-09-14100%
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
1 · 0% of valid

latitude

decimal

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

  • 29.980000037%
  • 29.638060036%
  • 29.64586009%
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
6 · 0% of valid
Min
29.6380600
25%
29.6380600
Median
29.6458600
75%
29.9800000
Max
29.9925000

longitude

decimal

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

  • -95.360000037%
  • -95.281940036%
  • -95.28212009%
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
6 · 0% of valid
Min
-95.3638900
25%
-95.3600000
Median
-95.2821200
75%
-95.2819400
Max
-95.2786100

coordinate_precision

string

Published precision code for the historical coordinate.

  • DDMMSS82%
  • DDddddd18%
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

coordinate_datum

string

Published horizontal datum.

  • NAD8380%
  • WGS8420%
Valid
422,798 · 90.7%
Missing
43,264 · 9.3%
Distinct
2 · 0% of valid

coordinate_source

string

Published coordinate evidence source.

  • GPS - GARMIN MODEL III41%
  • ASOS SITE SURVEY40%
  • ASOS CM20%
Valid
422,798 · 90.7%
Missing
43,264 · 9.3%
Distinct
3 · 0% of valid

location_valid_from

date

Start of the matched location effective period.

  • 2002-04-1837%
  • 2002-10-0136%
  • 2021-11-2218%
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
6 · 0% of valid

location_valid_to

date

End of the matched period; null for Present.

  • 2021-11-2289%
  • 2002-10-016%
  • 2002-04-015%
Valid
382,470 · 82.1%
Missing
83,592 · 17.9%
Distinct
4 · 0% of valid

metadata_source_url

string

NOAA HOMR station-history source.

  • https://www.ncei.noaa.gov/access/homr/services/station/20024452?date=all&definitions=false50%
  • https://www.ncei.noaa.gov/access/homr/services/station/20024558?date=all&definitions=false50%
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

equipment_types

string

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

  • AHTB95%
  • TB5%
  • AHTB | TB0%
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
3 · 0% of valid

equipment_record_count

integer

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

Histogram: 2 to 2.6666666666666665, 465,942; 2.6666666666666665 to 3.333333333333333, 0; 3.333333333333333 to 4, 120
24
Valid
466,062 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid
Min
2
25%
2
Median
2
75%
2
Max
4