US Weather Reports and Daily Highs in 20 Cities

Public

reports_khou

Release V4 publication snapshot

Current data

Latest passing release for each Table

Updated 4 Sept 2026, 09:28
Rows
70,682
across released Tables
Tables
1
released
Columns
32
reports_khou
Version
V4 publication snapshot
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_ftvisibility_milesweather_codesprecipitation_in_1hpeak_wind_gust_ktpeak_wind_direction_degreespeak_wind_timesnow_depth_inchesraw_metarcli_productcli_high_fcli_low_fcli_report_type
KHOU2020-01-01T00:53:00.000000ZMETAR2019-12-3155.0027.0033.790.000.0030.1601021.80SCT7000.00BKN25000.0010.000.000KHOU 010053Z 00000KT 10SM SCT070 BKN250 13/M03 A3016 RMK AO2 SLP218 T01281028
KHOU2020-01-01T01:53:00.000000ZMETAR2019-12-3154.0030.0039.63220.004.0030.1701022.00FEW7500.00BKN25000.0010.000.000KHOU 010153Z 22004KT 10SM FEW075 BKN250 12/M01 A3017 RMK AO2 SLP220 T01221011
KHOU2020-01-01T02:53:00.000000ZMETAR2019-12-3153.0033.0046.42210.005.0030.1701022.00SCT7000.00BKN25000.0010.000.000KHOU 010253Z 21005KT 10SM SCT070 BKN250 12/01 A3017 RMK AO2 SLP220 T01170006 52002
KHOU2020-01-01T03:53:00.000000ZMETAR2019-12-3153.0035.0050.28220.004.0030.1701022.00BKN6500.00BKN25000.0010.000.000KHOU 010353Z 22004KT 10SM BKN065 BKN250 12/02 A3017 RMK AO2 SLP220 T01170017
KHOU2020-01-01T04:53:00.000000ZMETAR2019-12-3153.0036.0052.11240.003.0030.1701022.00BKN6500.00BKN25000.0010.000.000KHOU 010453Z 24003KT 10SM BKN065 BKN250 12/02 A3017 RMK AO2 SLP220 T01170022
KHOU2020-01-01T05:53:00.000000ZMETAR2019-12-3153.0038.0056.170.000.0030.1401021.10BKN6500.00BKN25000.0010.000.000KHOU 010553Z 00000KT 10SM BKN065 BKN250 12/03 A3014 RMK AO2 SLP211 T01170033 10144 20111 401610044 58009
KHOU2020-01-01T06:53:00.000000ZMETAR2020-01-0153.0037.0054.21230.003.0030.1301020.80BKN6000.00BKN25000.0010.000.000KHOU 010653Z 23003KT 10SM BKN060 BKN250 12/03 A3013 RMK AO2 SLP208 T01170028CLIHOU6152final
KHOU2020-01-01T07:53:00.000000ZMETAR2020-01-0153.0039.0058.64190.003.0030.1101020.10BKN6000.00OVC25000.008.000.000KHOU 010753Z 19003KT 8SM BKN060 OVC250 12/04 A3011 RMK AO2 SLP201 T01170039CLIHOU6152final
KHOU2020-01-01T08:53:00.000000ZMETAR2020-01-0154.0036.0050.420.000.0030.1201020.30BKN6000.00OVC25000.009.000.000KHOU 010853Z 00000KT 9SM BKN060 OVC250 12/02 A3012 RMK AO2 SLP203 T01220022 55009CLIHOU6152final
KHOU2020-01-01T09:53:00.000000ZMETAR2020-01-0153.0039.0058.64330.004.0030.1201020.30BKN6000.00OVC25000.008.000.000KHOU 010953Z 33004KT 8SM BKN060 OVC250 12/04 A3012 RMK AO2 SLP203 T01170039CLIHOU6152final
A bounded preview of the immutable release.

Columns

Schema, units, meaning, and verified release profile

32 columns
Verified column analytics for reports_khou
ColumnTypeUnitMissingDistinctDistributionSummary
station0 source inputs · 4 transformationsstring0.0%0 values1<0.1%
  • KHOU100%

Top: KHOU

event_time_utc0 source inputs · 4 transformationstimestamp_utc0.0%0 values70,680100.0%
Timeline per year: 2020-01-01, 10,945; 2021-01-01, 10,877; 2022-01-01, 10,256; 2023-01-01, 10,535; 2024-01-01, 11,073; 2025-01-01, 10,155; 2026-01-01, 6,841
2020-01-012026-01-01

per year

All rows, per year

observation_type0 source inputs · 4 transformationsstring0.0%0 values2<0.1%
  • METAR83%
  • SPECI17%

Top: METAR

local_standard_date0 source inputs · 4 transformationsdate0.0%0 values2,4383.4%
Timeline per year: 2019-01-01, 6; 2020-01-01, 10,950; 2021-01-01, 10,874; 2022-01-01, 10,254; 2023-01-01, 10,536; 2024-01-01, 11,072; 2025-01-01, 10,155; 2026-01-01, 6,835
2019-01-012026-01-01

per year

All rows, per year

temp_f0 source inputs · 4 transformationsdecimal<0.1%28 values1440.2%
Histogram: 15.1 to 26.712499999999999, 125; 26.712499999999999 to 38.325000000000003, 790; 38.325000000000003 to 49.937500000000007, 3,664; 49.937500000000007 to 61.550000000000004, 9,023; 61.550000000000004 to 73.162499999999994, 18,619; 73.162499999999994 to 84.775000000000006, 27,055; 84.775000000000006 to 96.387500000000003, 10,799; 96.387500000000003 to 108, 579
15.10108.00

All-row histogram

Median 75.00P25 65.00 · P75 82.00
dewpoint_f0 source inputs · 4 transformationsdecimal<0.1%30 values1330.2%
Histogram: -0.90000000000000002 to 9.4625000000000004, 72; 9.4625000000000004 to 19.824999999999999, 450; 19.824999999999999 to 30.1875, 2,121; 30.1875 to 40.549999999999997, 5,011; 40.549999999999997 to 50.912500000000001, 6,416; 50.912500000000001 to 61.274999999999999, 10,678; 61.274999999999999 to 71.637500000000003, 24,519; 71.637500000000003 to 82, 21,385
-0.9082.00

All-row histogram

Median 67.00P25 55.00 · P75 73.00
relative_humidity_pct0 source inputs · 4 transformationsdecimal<0.1%30 values4,1765.9%
Histogram: 9.3499999999999996 to 20.681249999999999, 329; 20.681249999999999 to 32.012500000000003, 1,868; 32.012500000000003 to 43.343750000000007, 3,761; 43.343750000000007 to 54.675000000000004, 7,221; 54.675000000000004 to 66.006249999999994, 10,054; 66.006249999999994 to 77.337500000000006, 12,787; 77.337500000000006 to 88.668750000000003, 20,977; 88.668750000000003 to 100, 13,655
9.35100.00

All-row histogram

Median 76.86P25 60.07 · P75 87.26
wind_direction_degrees0 source inputs · 4 transformationsdecimal2.0%1,382 values40<0.1%
Histogram: 0 to 45, 11,411; 45 to 90, 5,571; 90 to 135, 10,570; 135 to 180, 16,014; 180 to 225, 12,691; 225 to 270, 2,632; 270 to 315, 2,897; 315 to 360, 7,514
0.00360.00

All-row histogram

Median 160.00P25 90.00 · P75 200.00
wind_speed_kt0 source inputs · 4 transformationsdecimal0.2%129 values780.1%
Histogram: 0 to 14, 62,510; 14 to 28, 7,983; 28 to 42, 49; 42 to 56, 7; 56 to 70, 2; 70 to 84, 0; 84 to 98, 0; 98 to 112, 2
0.00112.00

All-row histogram

Median 7.00P25 5.00 · P75 11.00
wind_gust_kt0 source inputs · 4 transformationsdecimal86.5%61,107 values790.8%
Histogram: 14 to 21.375, 4,232; 21.375 to 28.75, 4,393; 28.75 to 36.125, 757; 36.125 to 43.5, 138; 43.5 to 50.875, 30; 50.875 to 58.25, 12; 58.25 to 65.625, 7; 65.625 to 73, 6
14.0073.00

All-row histogram

Median 22.00P25 20.00 · P75 25.00
altimeter_inhg0 source inputs · 4 transformationsdecimal<0.1%7 values1390.2%
Histogram: 29.280000000000001 to 29.458750000000002, 19; 29.458750000000002 to 29.637500000000003, 440; 29.637500000000003 to 29.81625, 5,892; 29.81625 to 29.995000000000001, 31,025; 29.995000000000001 to 30.173750000000002, 23,568; 30.173750000000002 to 30.352499999999999, 7,475; 30.352499999999999 to 30.53125, 2,011; 30.53125 to 30.710000000000001, 245
29.28030.710

All-row histogram

Median 29.990P25 29.900 · P75 30.090
sea_level_pressure_hpa0 source inputs · 4 transformationsdecimal17.3%12,237 values4190.7%
Histogram: 991.79999999999995 to 998.66249999999991, 17; 998.66249999999991 to 1005.525, 624; 1005.525 to 1012.3875, 10,476; 1012.3875 to 1019.25, 31,668; 1019.25 to 1026.1125, 11,961; 1026.1125 to 1032.9749999999999, 3,272; 1032.9749999999999 to 1039.8375000000001, 424; 1039.8375000000001 to 1046.7, 3
991.801046.70

All-row histogram

Median 1016.00P25 1013.20 · P75 1019.60
sky_cover_10 source inputs · 4 transformationsstring<0.1%13 values6<0.1%
  • FEW33%
  • SCT26%
  • BKN19%

Top: FEW

sky_base_1_ft0 source inputs · 4 transformationsdecimal12.0%8,459 values1280.2%
Histogram: 0 to 3750, 41,348; 3750 to 7500, 10,988; 7500 to 11250, 2,008; 11250 to 15000, 695; 15000 to 18750, 1,279; 18750 to 22500, 590; 22500 to 26250, 5,076; 26250 to 30000, 239
0.0030000.00

All-row histogram

Median 2500.00P25 1400.00 · P75 4700.00
sky_cover_20 source inputs · 4 transformationsstring42.9%30,324 values4<0.1%
  • BKN43%
  • SCT29%
  • OVC17%

Top: BKN

sky_base_2_ft0 source inputs · 4 transformationsdecimal42.9%30,324 values1310.3%
Histogram: 200 to 3925, 12,776; 3925 to 7650, 8,137; 7650 to 11375, 3,455; 11375 to 15100, 2,267; 15100 to 18825, 1,597; 18825 to 22550, 1,288; 22550 to 26275, 10,367; 26275 to 30000, 471
200.0030000.00

All-row histogram

Median 7000.00P25 3198.00 · P75 25000.00
sky_cover_30 source inputs · 4 transformationsstring74.6%52,727 values4<0.1%
  • BKN51%
  • OVC35%
  • SCT14%

Top: BKN

sky_base_3_ft0 source inputs · 4 transformationsdecimal74.6%52,727 values1210.7%
Histogram: 1200 to 5425, 3,563; 5425 to 9650, 2,938; 9650 to 13875, 2,018; 13875 to 18100, 1,601; 18100 to 22325, 817; 22325 to 26550, 6,635; 26550 to 30775, 382; 30775 to 35000, 1
1200.0035000.00

All-row histogram

Median 15000.00P25 6000.00 · P75 25000.00
sky_cover_40 source inputs · 4 transformationsstring94.9%67,068 values3<0.1%
  • BKN63%
  • OVC33%
  • SCT4%

Top: BKN

sky_base_4_ft0 source inputs · 4 transformationsdecimal94.9%67,068 values200.6%
Histogram: 8000 to 35125, 3,613; 35125 to 62250, 0; 62250 to 89375, 0; 89375 to 116500, 0; 116500 to 143625, 0; 143625 to 170750, 0; 170750 to 197875, 0; 197875 to 225000, 1
8000.00225000.00

All-row histogram

Median 25000.00P25 25000.00 · P75 25000.00
Show 12 more columns
Verified column analytics for reports_khou
visibility_miles0 source inputs · 4 transformationsdecimal<0.1%26 values21<0.1%
Histogram: 0 to 1.25, 1,428; 1.25 to 2.5, 1,505; 2.5 to 3.75, 1,277; 3.75 to 5, 878; 5 to 6.25, 2,362; 6.25 to 7.5, 2,529; 7.5 to 8.75, 3,579; 8.75 to 10, 57,098
0.0010.00

All-row histogram

Median 10.00P25 10.00 · P75 10.00
weather_codes0 source inputs · 4 transformationsstring84.2%59,492 values950.8%
  • BR29%
  • -RA21%
  • -RA BR8%
  • Other (83)

Top: BR · 1,328 more values

precipitation_in_1h0 source inputs · 4 transformationsdecimal8.3%5,892 values1410.2%
Histogram: 0 to 0.35875000000000001, 64,325; 0.35875000000000001 to 0.71750000000000003, 332; 0.71750000000000003 to 1.0762499999999999, 90; 1.0762499999999999 to 1.4350000000000001, 29; 1.4350000000000001 to 1.7937500000000002, 10; 1.7937500000000002 to 2.1524999999999999, 2; 2.1524999999999999 to 2.51125, 1; 2.51125 to 2.8700000000000001, 1
0.0002.870

All-row histogram

Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt0 source inputs · 4 transformationsdecimal94.2%66,567 values380.9%
Histogram: 26 to 31.875, 3,180; 31.875 to 37.75, 605; 37.75 to 43.625, 230; 43.625 to 49.5, 63; 49.5 to 55.375, 19; 55.375 to 61.25, 2; 61.25 to 67.125, 9; 67.125 to 73, 7
26.0073.00

All-row histogram

Median 28.00P25 27.00 · P75 31.00
peak_wind_direction_degrees0 source inputs · 4 transformationsdecimal94.2%66,567 values370.9%
Histogram: 10 to 53.75, 624; 53.75 to 97.5, 159; 97.5 to 141.25, 384; 141.25 to 185, 1,043; 185 to 228.75, 416; 228.75 to 272.5, 132; 272.5 to 316.25, 267; 316.25 to 360, 1,090
10.00360.00

All-row histogram

Median 180.00P25 130.00 · P75 320.00
peak_wind_time0 source inputs · 4 transformationsstring94.2%66,567 values3,26779.4%

3,267 distinct values, no chart

No shape worth drawing · 4,115 more values

snow_depth_inches0 source inputs · 4 transformationsdecimal100.0%70,676 values350.0%
Histogram: 1 to 1.25, 1; 1.25 to 1.5, 0; 1.5 to 1.75, 0; 1.75 to 2, 0; 2 to 2.25, 1; 2.25 to 2.5, 0; 2.5 to 2.75, 0; 2.75 to 3, 4
1.003.00

All-row histogram

Median 3.00P25 2.00 · P75 3.00
raw_metar0 source inputs · 4 transformationsstring0.0%0 values70,682100.0%

70,682 distinct values, no chart

No shape worth drawing · 70,682 more values

cli_product0 source inputs · 4 transformationsstring<0.1%57 values1<0.1%
  • CLIHOU100%

Top: CLIHOU

cli_high_f0 source inputs · 4 transformationsinteger0.2%110 values730.1%
Histogram: 28 to 38, 282; 39 to 48, 838; 49 to 58, 2,261; 59 to 68, 6,842; 69 to 79, 14,571; 80 to 89, 23,219; 90 to 99, 20,879; 100 to 109, 1,680
28109

All-row histogram

Median 84P25 75 · P75 92
cli_low_f0 source inputs · 4 transformationsinteger0.2%110 values67<0.1%
Histogram: 15 to 23, 210; 24 to 32, 800; 33 to 41, 3,291; 42 to 49, 6,796; 50 to 58, 9,410; 59 to 67, 13,838; 68 to 76, 20,249; 77 to 84, 15,978
1584

All-row histogram

Median 68P25 56 · P75 76
cli_report_type0 source inputs · 4 transformationsstring<0.1%57 values3<0.1%
  • final99%
  • correction1%
  • preliminary0%

Top: final

Release status

Facts from the current passing release

Release
V4 publication snapshot
Rows
70,682
Columns
32
Published
4 Sept 2026, 09:28
Analytics
Verified across all rows

Use dataset

Query it over the API, connect an agent over MCP, or download the current Parquet file. Everything below is copy-pastable and live.

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/9382176f-6ad8-47fe-b4b6-8c423a09ac1f/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/9382176f-6ad8-47fe-b4b6-8c423a09ac1f/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/9382176f-6ad8-47fe-b4b6-8c423a09ac1f/query" \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  -H "content-type: application/json" \
  --data '{"columns": ["station","event_time_utc"], "limit": 100}'

MOSTLYRIGHT_API_KEY takes an mr_use_ key, minted from a workspace that uses this dataset. These routes refuse an mr_live_ key. Full 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