Houston weather reports and daily highs since 2020

Public

reports_khou

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:28
Rows
70,825
across released Tables
Tables
1
released
Columns
34
reports_khou
Version
reports_khou

Data preview

reports_khou
Preview rows for reports_khou
stationevent_time_utcobservation_typelocal_standard_datetemp_fdewpoint_frelative_humidity_pctwind_direction_degreeswind_speed_ktwind_gust_ktaltimeter_inhgsea_level_pressure_hpasky_cover_1sky_base_1_ftsky_cover_2sky_base_2_ftsky_cover_3sky_base_3_ftsky_cover_4sky_base_4_ft
KHOU2020-01-01T06:53:00.000000ZMETAR2020-01-0153.0037.0054.21230.003.0030.1301020.80BKN6000.00BKN25000.00
KHOU2020-01-01T07:53:00.000000ZMETAR2020-01-0153.0039.0058.64190.003.0030.1101020.10BKN6000.00OVC25000.00
KHOU2020-01-01T08:53:00.000000ZMETAR2020-01-0154.0036.0050.420.000.0030.1201020.30BKN6000.00OVC25000.00
KHOU2020-01-01T09:53:00.000000ZMETAR2020-01-0153.0039.0058.64330.004.0030.1201020.30BKN6000.00OVC25000.00
KHOU2020-01-01T10:53:00.000000ZMETAR2020-01-0154.0038.0054.340.000.0030.0801019.20BKN5500.00OVC25000.00
KHOU2020-01-01T11:53:00.000000ZMETAR2020-01-0153.0039.0058.64120.005.0030.0501018.20BKN5500.00OVC25000.00
KHOU2020-01-01T12:53:00.000000ZMETAR2020-01-0154.0037.0052.4560.004.0030.0701018.60OVC5000.00
KHOU2020-01-01T13:53:00.000000ZMETAR2020-01-0155.0036.0048.6290.006.0030.0601018.40OVC5000.00
KHOU2020-01-01T14:53:00.000000ZMETAR2020-01-0156.0038.0050.7190.005.0030.0601018.50OVC5000.00
KHOU2020-01-01T15:53:00.000000ZMETAR2020-01-0157.0038.0048.7390.006.0030.0901019.20OVC5000.00
A bounded preview of the immutable release.

Columns

Schema, units, meaning, and verified release profile

34 columns
Verified column analytics for reports_khou
ColumnTypeUnitMissingDistinctDistributionSummary
stationstring0.0%0 values1<0.1%
  • KHOU100%

Top: KHOU

event_time_utctimestamp_utc0.0%0 values70,823100.0%
  • 2023-11-30 09:50:00+000%
  • 2025-03-10 04:10:00+000%
  • 2020-01-01 06:53:00+000%
  • Other (70,811)

Top: 2023-11-30 09:50:00+00 · 70,811 more values

observation_typestring0.0%0 values2<0.1%
  • METAR83%
  • SPECI17%

Top: METAR

local_standard_datedate0.0%0 values2,4433.4%
  • 2020-09-220%
  • 2020-09-210%
  • 2023-10-030%
  • Other (2,431)

Top: 2020-09-22 · 70,076 more values

temp_fdecimal<0.1%28 values1440.2%
  • 80.004%
  • 81.004%
  • 79.004%
  • Other (132)

Top: 80.00 · 42,363 more values

Median 75.00P25 65.00 · P75 82.00
dewpoint_fdecimal<0.1%30 values1330.2%
  • 75.006%
  • 74.005%
  • 73.005%
  • Other (121)

Top: 75.00 · 34,305 more values

Median 67.00P25 55.00 · P75 73.00
relative_humidity_pctdecimal<0.1%30 values4,1765.9%
  • 100.001%
  • 82.031%
  • 87.581%
  • Other (4,164)

Top: 100.00 · 66,390 more values

Median 76.87P25 60.11 · P75 87.26
wind_direction_degreesdecimal2.0%1,387 values40<0.1%
  • 0.008%
  • 160.008%
  • 170.006%
  • Other (28)

Top: 0.00 · 29,067 more values

Median 160.00P25 90.00 · P75 200.00
wind_speed_ktdecimal0.2%129 values780.1%
  • 6.009%
  • 5.009%
  • 7.009%
  • Other (66)

Top: 6.00 · 9,575 more values

Median 7.00P25 5.00 · P75 11.00
wind_gust_ktdecimal86.5%61,244 values790.8%
  • 21.0010%
  • 22.0010%
  • 20.009%
  • Other (67)

Top: 21.00 · 1,767 more values

Median 22.00P25 20.00 · P75 25.00
altimeter_inhgdecimal<0.1%7 values1390.2%
  • 29.9603%
  • 29.9703%
  • 29.9503%
  • Other (127)

Top: 29.960 · 45,650 more values

Median 29.990P25 29.900 · P75 30.090
sea_level_pressure_hpadecimal17.3%12,247 values4190.7%
  • 1015.301%
  • 1015.001%
  • 1015.201%
  • Other (407)

Top: 1015.30 · 51,874 more values

Median 1016.00P25 1013.20 · P75 1019.60
sky_cover_1string<0.1%13 values6<0.1%
  • FEW33%
  • SCT26%
  • BKN19%

Top: FEW

sky_base_1_ftdecimal11.9%8,461 values1280.2%
  • 25000.008%
  • 2000.006%
  • 2500.005%
  • Other (116)

Top: 25000.00 · 31,513 more values

Median 2500.00P25 1400.00 · P75 4700.00
sky_cover_2string42.8%30,345 values4<0.1%
  • BKN43%
  • SCT29%
  • OVC17%

Top: BKN

sky_base_2_ftdecimal42.8%30,345 values1310.3%
  • 25000.0025%
  • 6000.003%
  • 5000.003%
  • Other (119)

Top: 25000.00 · 18,909 more values

Median 7000.00P25 3200.00 · P75 25000.00
sky_cover_3string74.5%52,786 values4<0.1%
  • BKN51%
  • OVC35%
  • SCT14%

Top: BKN

sky_base_3_ftdecimal74.5%52,786 values1210.7%
  • 25000.0036%
  • 10000.004%
  • 11000.003%
  • Other (109)

Top: 25000.00 · 5,873 more values

Median 15000.00P25 6000.00 · P75 25000.00
sky_cover_4string94.9%67,192 values3<0.1%
  • BKN63%
  • OVC33%
  • SCT4%

Top: BKN

sky_base_4_ftdecimal94.9%67,192 values200.6%
  • 25000.0073%
  • 13000.004%
  • 20000.004%
  • Other (8)

Top: 25000.00 · 29 more values

Median 25000.00P25 25000.00 · P75 25000.00
Show 14 more columns
Verified column analytics for reports_khou
visibility_milesdecimal<0.1%26 values21<0.1%
  • 10.0077%
  • 8.005%
  • 9.004%
  • Other (9)

Top: 10.00 · 1,389 more values

Median 10.00P25 10.00 · P75 10.00
weather_codesstring84.2%59,620 values950.8%
  • BR29%
  • -RA21%
  • -RA BR8%
  • Other (83)

Top: BR · 1,334 more values

precipitation_in_1hdecimal8.3%5,900 values1420.2%
  • 0.00092%
  • 0.0102%
  • 0.0201%
  • Other (130)

Top: 0.000 · 1,472 more values

Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_ktdecimal94.2%66,708 values380.9%
  • 26.0021%
  • 27.0016%
  • 28.0015%
  • Other (26)

Top: 26.00 · 330 more values

Median 28.00P25 27.00 · P75 31.00
peak_wind_direction_degreesdecimal94.2%66,708 values370.9%
  • 160.008%
  • 350.006%
  • 180.006%
  • Other (25)

Top: 160.00 · 1,445 more values

Median 180.00P25 130.00 · P75 320.00
peak_wind_timestring94.2%66,708 values3,26879.4%
  • 2021-10-27 14:080%
  • 2023-07-06 19:030%
  • 2020-04-29 10:070%
  • Other (3,256)

Top: 2021-10-27 14:08 · 4,043 more values

snow_depth_inchesdecimal100.0%70,819 values350.0%
  • 3.0067%
  • 1.0017%
  • 2.0017%

Top: 3.00

Median 3.00P25 2.00 · P75 3.00
raw_metarstring0.0%0 values70,825100.0%
  • KHOU 010013Z 09008KT 4SM +RA BR SCT013 BKN035 OVC075 14/13 A2994 RMK AO2 P0009 T014401330%
  • KHOU 010022Z 09011G17KT 4SM +RA BR BKN013 BKN035 OVC070 14/14 A2994 RMK AO2 P0013 T014401390%
  • KHOU 010024Z 12003KT 4SM BR BKN009 BKN016 OVC036 19/19 A2973 RMK AO2 RAE0023 P0000 T01940189 $0%
  • Other (70,813)

Top: KHOU 010013Z 09008KT 4SM +RA BR SCT013 BKN035 OVC075 14/13 A2994 RMK AO2 P0009 T01440133 · 70,813 more values

cli_productstring<0.1%64 values1<0.1%
  • CLIHOU100%

Top: CLIHOU

cli_high_finteger0.2%117 values730.1%
Histogram: 28 to 38.125, 282; 38.125 to 48.25, 838; 48.25 to 58.375, 2,261; 58.375 to 68.5, 6,842; 68.5 to 78.625, 12,668; 78.625 to 88.75, 23,110; 88.75 to 98.875, 22,014; 98.875 to 109, 2,693
28109

All-row histogram

Median 84P25 75 · P75 92
cli_low_finteger0.2%117 values67<0.1%
Histogram: 15 to 23.625, 210; 23.625 to 32.25, 800; 32.25 to 40.875, 2,626; 40.875 to 49.5, 7,461; 49.5 to 58.125, 9,410; 58.125 to 66.75, 11,780; 66.75 to 75.375, 19,156; 75.375 to 84, 19,265
1584

All-row histogram

Median 68P25 56 · P75 76
cli_report_typestring<0.1%64 values3<0.1%
  • final99%
  • correction1%
  • preliminary0%

Top: final

metar_high_fdecimal0.0%0 values910.1%
  • 82.004%
  • 85.004%
  • 93.004%
  • Other (79)

Top: 82.00 · 40,916 more values

Median 83.00P25 74.00 · P75 91.00
metar_low_fdecimal0.0%0 values950.1%
  • 79.005%
  • 78.005%
  • 80.004%
  • Other (83)

Top: 79.00 · 40,297 more values

Median 68.00P25 57.00 · P75 76.00

Release status

Facts from the current passing release

Release
Passing
Rows
70,825
Columns
34
Published
9 Sept 2026, 06:28
Analytics
Verified across all rows

Use dataset

Query this dataset with the API, connect an AI tool with MCP, or download a Parquet file.

cURL · reports_khou
reports_khou
# Current release — the complete Parquet file
curl -sS -o reports-khou.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/234a73b7-d760-49dd-a531-6c285e7f3910/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/234a73b7-d760-49dd-a531-6c285e7f3910/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/234a73b7-d760-49dd-a531-6c285e7f3910/query" \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  -H "content-type: application/json" \
  --data '{"columns": ["station","event_time_utc"], "limit": 100}'

MOSTLYRIGHT_API_KEY requires an mr_use_ API key from a workspace that has added this dataset. An mr_live_ key will not work here. Reference: OpenAPI · guide.

Report this Table

Build your own datasets

Create a free workspace to build and maintain data your team keeps private.

Create a free workspace

Already have an account? Log in

DocsPricingTermsPrivacyStatus