US Weather Reports and Daily Highs in 20 Cities

Public

reports_klax

Release V4 publication snapshot

Current data

Latest passing release for each Table

Updated 4 Sept 2026, 09:28
Rows
68,659
across released Tables
Tables
1
released
Columns
32
reports_klax
Version
V4 publication snapshot
reports_klax

Data preview

reports_klax
Preview rows for reports_klax
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
KLAX2020-01-01T00:00:00.000000ZSPECI2019-12-3172.0032.0022.820.000.001015.50METAR LAX 010000Z AUTO 00000KT 22/00 RMK AO2 SLP155 T02220000 IEM_GHCNH
KLAX2020-01-01T00:53:00.000000ZMETAR2019-12-3171.0032.0023.52320.008.0015.0030.0001015.80FEW15000.00FEW25000.0010.000.000KLAX 010053Z 32008G15KT 10SM FEW150 FEW250 22/00 A3000 RMK AO2 SLP158 T02170000
KLAX2020-01-01T01:53:00.000000ZMETAR2019-12-3167.0030.9025.98340.006.0030.0101016.30FEW25000.0010.000.000KLAX 010153Z 34006KT 10SM FEW250 19/M01 A3001 RMK AO2 SLP163 T01941006
KLAX2020-01-01T02:53:00.000000ZMETAR2019-12-3165.0030.9027.85340.008.0030.0201016.60CLR10.000.000KLAX 010253Z 34008KT 10SM CLR 18/M01 A3002 RMK AO2 SLP166 T01831006 51010
KLAX2020-01-01T03:53:00.000000ZMETAR2019-12-3164.0030.9028.7420.007.0030.0401017.10CLR10.000.000KLAX 010353Z 02007KT 10SM CLR 18/M01 A3004 RMK AO2 SLP171 T01781006
KLAX2020-01-01T04:53:00.000000ZMETAR2019-12-3162.0030.9030.73360.005.0030.0601017.60CLR10.000.000KLAX 010453Z 36005KT 10SM CLR 17/M01 A3006 RMK AO2 SLP176 T01671006
KLAX2020-01-01T05:53:00.000000ZMETAR2019-12-3161.0032.0033.404.0030.0601017.80CLR10.000.000KLAX 010553Z VRB04KT 10SM CLR 16/00 A3006 RMK AO2 SLP178 T01610000 10228 20161 51013
KLAX2020-01-01T06:53:00.000000ZMETAR2019-12-3161.0032.0033.40340.006.0030.0901018.50CLR10.000.000KLAX 010653Z 34006KT 10SM CLR 16/00 A3009 RMK AO2 SLP185 T01610000
KLAX2020-01-01T07:53:00.000000ZMETAR2019-12-3157.0033.0040.2880.005.0030.0501017.50CLR10.000.000KLAX 010753Z 08005KT 10SM CLR 14/01 A3005 RMK AO2 SLP175 T01390006 402280106
KLAX2020-01-01T08:53:00.000000ZMETAR2020-01-0159.0033.0037.4920.006.0030.0501017.20CLR10.000.000KLAX 010853Z 02006KT 10SM CLR 15/01 A3005 RMK AO2 SLP172 T01500006 58005CLILAX6750final
A bounded preview of the immutable release.

Columns

Schema, units, meaning, and verified release profile

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

Top: KLAX

event_time_utc0 source inputs · 4 transformationstimestamp_utc0.0%0 values68,658100.0%
Timeline per year: 2020-01-01, 10,038; 2021-01-01, 10,345; 2022-01-01, 9,853; 2023-01-01, 10,401; 2024-01-01, 10,581; 2025-01-01, 10,682; 2026-01-01, 6,759
2020-01-012026-01-01

per year

All rows, per year

observation_type0 source inputs · 4 transformationsstring0.0%0 values2<0.1%
  • METAR85%
  • SPECI15%

Top: METAR

local_standard_date0 source inputs · 4 transformationsdate0.0%0 values2,4383.6%
Timeline per year: 2019-01-01, 9; 2020-01-01, 10,038; 2021-01-01, 10,345; 2022-01-01, 9,862; 2023-01-01, 10,392; 2024-01-01, 10,581; 2025-01-01, 10,684; 2026-01-01, 6,748
2019-01-012026-01-01

per year

All rows, per year

temp_f0 source inputs · 4 transformationsdecimal<0.1%4 values780.1%
Histogram: 40 to 47.625, 688; 47.625 to 55.25, 9,692; 55.25 to 62.875, 24,076; 62.875 to 70.5, 25,223; 70.5 to 78.125, 7,829; 78.125 to 85.75, 987; 85.75 to 93.375, 141; 93.375 to 101, 19
40.00101.00

All-row histogram

Median 62.00P25 58.00 · P75 67.00
dewpoint_f0 source inputs · 4 transformationsdecimal<0.1%8 values1090.2%
Histogram: -5 to 4.75, 10; 4.75 to 14.5, 269; 14.5 to 24.25, 1,311; 24.25 to 34, 2,753; 34 to 43.75, 4,933; 43.75 to 53.5, 20,941; 53.5 to 63.25, 33,727; 63.25 to 73, 4,707
-5.0073.00

All-row histogram

Median 55.00P25 49.00 · P75 59.00
relative_humidity_pct0 source inputs · 4 transformationsdecimal<0.1%8 values3,3634.9%
Histogram: 5.6600000000000001 to 17.452500000000001, 858; 17.452500000000001 to 29.245000000000001, 2,037; 29.245000000000001 to 41.037499999999994, 2,453; 41.037499999999994 to 52.829999999999998, 3,108; 52.829999999999998 to 64.622500000000002, 8,098; 64.622500000000002 to 76.414999999999992, 16,853; 76.414999999999992 to 88.207499999999996, 23,167; 88.207499999999996 to 100, 12,077
5.66100.00

All-row histogram

Median 77.38P25 65.35 · P75 86.45
wind_direction_degrees0 source inputs · 4 transformationsdecimal5.1%3,475 values37<0.1%
Histogram: 0 to 45, 10,429; 45 to 90, 4,499; 90 to 135, 7,032; 135 to 180, 2,362; 180 to 225, 3,120; 225 to 270, 27,136; 270 to 315, 8,544; 315 to 360, 2,062
0.00360.00

All-row histogram

Median 240.00P25 90.00 · P75 260.00
wind_speed_kt0 source inputs · 4 transformationsdecimal<0.1%30 values35<0.1%
Histogram: 0 to 4.5, 25,927; 4.5 to 9, 22,785; 9 to 13.5, 16,616; 13.5 to 18, 2,560; 18 to 22.5, 534; 22.5 to 27, 147; 27 to 31.5, 51; 31.5 to 36, 9
0.0036.00

All-row histogram

Median 6.00P25 4.00 · P75 9.00
wind_gust_kt0 source inputs · 4 transformationsdecimal96.6%66,330 values291.2%
Histogram: 14 to 17.625, 446; 17.625 to 21.25, 969; 21.25 to 24.875, 386; 24.875 to 28.5, 271; 28.5 to 32.125, 131; 32.125 to 35.75, 71; 35.75 to 39.375, 48; 39.375 to 43, 7
14.0043.00

All-row histogram

Median 20.00P25 18.00 · P75 24.00
altimeter_inhg0 source inputs · 4 transformationsdecimal<0.1%11 values990.1%
Histogram: 29.440000000000001 to 29.565000000000001, 34; 29.565000000000001 to 29.690000000000001, 118; 29.690000000000001 to 29.815000000000001, 2,759; 29.815000000000001 to 29.940000000000001, 21,690; 29.940000000000001 to 30.065000000000001, 29,772; 30.065000000000001 to 30.190000000000001, 11,391; 30.190000000000001 to 30.315000000000001, 2,770; 30.315000000000001 to 30.440000000000001, 114
29.44030.440

All-row histogram

Median 29.970P25 29.910 · P75 30.050
sea_level_pressure_hpa0 source inputs · 4 transformationsdecimal15.0%10,288 values3020.5%
Histogram: 996.70000000000005 to 1000.975, 27; 1000.975 to 1005.25, 103; 1005.25 to 1009.5250000000001, 2,488; 1009.5250000000001 to 1013.8000000000001, 20,349; 1013.8000000000001 to 1018.075, 23,099; 1018.075 to 1022.3500000000001, 9,888; 1022.3500000000001 to 1026.625, 2,314; 1026.625 to 1030.9000000000001, 103
996.701030.90

All-row histogram

Median 1014.80P25 1012.60 · P75 1017.50
sky_cover_10 source inputs · 4 transformationsstring<0.1%12 values6<0.1%
  • FEW55%
  • SCT13%
  • CLR13%

Top: FEW

sky_base_1_ft0 source inputs · 4 transformationsdecimal12.6%8,667 values870.1%
Histogram: 0 to 4375, 48,285; 4375 to 8750, 2,192; 8750 to 13125, 1,848; 13125 to 17500, 2,000; 17500 to 21875, 2,046; 21875 to 26250, 3,134; 26250 to 30625, 471; 30625 to 35000, 16
0.0035000.00

All-row histogram

Median 1200.00P25 800.00 · P75 2500.00
sky_cover_20 source inputs · 4 transformationsstring46.4%31,830 values4<0.1%
  • FEW32%
  • BKN29%
  • SCT26%

Top: FEW

sky_base_2_ft0 source inputs · 4 transformationsdecimal46.4%31,830 values840.2%
Histogram: 100 to 20587.5, 32,082; 20587.5 to 41075, 4,746; 41075 to 61562.5, 0; 61562.5 to 82050, 0; 82050 to 102537.5, 0; 102537.5 to 123025, 0; 123025 to 143512.5, 0; 143512.5 to 164000, 1
100.00164000.00

All-row histogram

Median 3700.00P25 1600.00 · P75 15000.00
sky_cover_30 source inputs · 4 transformationsstring76.1%52,234 values4<0.1%
  • BKN42%
  • SCT35%
  • OVC22%

Top: BKN

sky_base_3_ft0 source inputs · 4 transformationsdecimal76.1%52,234 values830.5%
Histogram: 200 to 4300, 3,826; 4300 to 8400, 2,785; 8400 to 12500, 1,171; 12500 to 16600, 2,413; 16600 to 20700, 2,155; 20700 to 24800, 744; 24800 to 28900, 3,059; 28900 to 33000, 272
200.0033000.00

All-row histogram

Median 14000.00P25 4500.00 · P75 20000.00
sky_cover_40 source inputs · 4 transformationsstring95.9%65,857 values30.1%
  • BKN66%
  • SCT25%
  • OVC9%

Top: BKN

sky_base_4_ft0 source inputs · 4 transformationsdecimal95.9%65,857 values230.8%
Histogram: 7000 to 10500, 2; 10500 to 14000, 40; 14000 to 17500, 584; 17500 to 21000, 707; 21000 to 24500, 262; 24500 to 28000, 870; 28000 to 31500, 334; 31500 to 35000, 3
7000.0035000.00

All-row histogram

Median 22000.00P25 18000.00 · P75 25000.00
Show 12 more columns
Verified column analytics for reports_klax
visibility_miles0 source inputs · 4 transformationsdecimal<0.1%21 values22<0.1%
Histogram: 0 to 1.875, 2,900; 1.875 to 3.75, 3,215; 3.75 to 5.625, 2,991; 5.625 to 7.5, 4,872; 7.5 to 9.375, 7,811; 9.375 to 11.25, 46,846; 11.25 to 13.125, 1; 13.125 to 15, 2
0.0015.00

All-row histogram

Median 10.00P25 8.00 · P75 10.00
weather_codes0 source inputs · 4 transformationsstring82.2%56,416 values520.4%
  • BR42%
  • HZ17%
  • FG12%
  • Other (40)

Top: BR · 374 more values

precipitation_in_1h0 source inputs · 4 transformationsdecimal2.0%1,400 values55<0.1%
Histogram: 0 to 0.11874999999999999, 66,835; 0.11874999999999999 to 0.23749999999999999, 307; 0.23749999999999999 to 0.35624999999999996, 77; 0.35624999999999996 to 0.47499999999999998, 23; 0.47499999999999998 to 0.59375, 7; 0.59375 to 0.71249999999999991, 7; 0.71249999999999991 to 0.83124999999999993, 1; 0.83124999999999993 to 0.94999999999999996, 2
0.0000.950

All-row histogram

Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt0 source inputs · 4 transformationsdecimal98.6%67,695 values222.3%
Histogram: 26 to 28.625, 431; 28.625 to 31.25, 244; 31.25 to 33.875, 95; 33.875 to 36.5, 102; 36.5 to 39.125, 57; 39.125 to 41.75, 18; 41.75 to 44.375, 13; 44.375 to 47, 4
26.0047.00

All-row histogram

Median 29.00P25 27.00 · P75 32.00
peak_wind_direction_degrees0 source inputs · 4 transformationsdecimal98.6%67,695 values363.7%
Histogram: 10 to 53.75, 63; 53.75 to 97.5, 18; 97.5 to 141.25, 55; 141.25 to 185, 38; 185 to 228.75, 48; 228.75 to 272.5, 545; 272.5 to 316.25, 110; 316.25 to 360, 87
10.00360.00

All-row histogram

Median 260.00P25 240.00 · P75 270.00
peak_wind_time0 source inputs · 4 transformationsstring98.6%67,695 values85788.9%

857 distinct values, no chart

No shape worth drawing · 964 more values

snow_depth_inches0 source inputs · 4 transformationsdecimal100.0%68,659 values00.0%

0 distinct values, no chart

No shape worth drawing

raw_metar0 source inputs · 4 transformationsstring0.0%0 values68,659100.0%

68,659 distinct values, no chart

No shape worth drawing · 68,659 more values

cli_product0 source inputs · 4 transformationsstring<0.1%66 values1<0.1%
  • CLILAX100%

Top: CLILAX

cli_high_f0 source inputs · 4 transformationsinteger<0.1%66 values48<0.1%
Histogram: 52 to 58, 2,171; 59 to 64, 12,802; 65 to 71, 24,506; 72 to 77, 19,673; 78 to 83, 6,632; 84 to 90, 2,270; 91 to 96, 390; 97 to 102, 149
52102

All-row histogram

Median 70P25 65 · P75 75
cli_low_f0 source inputs · 4 transformationsinteger<0.1%66 values38<0.1%
Histogram: 39 to 43, 1,071; 44 to 48, 7,587; 49 to 53, 13,932; 54 to 58, 16,023; 59 to 63, 18,301; 64 to 68, 10,062; 69 to 73, 1,516; 74 to 77, 101
3977

All-row histogram

Median 57P25 52 · P75 62
cli_report_type0 source inputs · 4 transformationsstring<0.1%66 values2<0.1%
  • final94%
  • correction6%

Top: final

Release status

Facts from the current passing release

Release
V4 publication snapshot
Rows
68,659
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_klax
reports_klax
# Current release — the complete Parquet file
curl -sS -o reports-klax.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/1d64b41d-ffdc-4b0d-b6b4-1a1a03ec8d20/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/1d64b41d-ffdc-4b0d-b6b4-1a1a03ec8d20/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/1d64b41d-ffdc-4b0d-b6b4-1a1a03ec8d20/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