US Weather Reports and Daily Highs in 20 Cities

Public

reports_kokc

Release V4 publication snapshot

Current data

Latest passing release for each Table

Updated 4 Sept 2026, 09:28
Rows
67,777
across released Tables
Tables
1
released
Columns
32
reports_kokc
Version
V4 publication snapshot
reports_kokc

Data preview

reports_kokc
Preview rows for reports_kokc
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
KOKC2020-01-01T00:52:00.000000ZMETAR2019-12-3137.0019.9049.61220.004.0030.0801019.60CLR10.000.000KOKC 010052Z 22004KT 10SM CLR 03/M07 A3008 RMK AO2 SLP196 T00281067 $
KOKC2020-01-01T01:52:00.000000ZMETAR2019-12-3137.0019.9049.61220.004.0030.0701019.20CLR10.000.000KOKC 010152Z 22004KT 10SM CLR 03/M07 A3007 RMK AO2 SLP192 T00281067 $
KOKC2020-01-01T02:52:00.000000ZMETAR2019-12-3134.0021.0058.56200.006.0030.0601018.80CLR10.000.000KOKC 010252Z 20006KT 10SM CLR 01/M06 A3006 RMK AO2 SLP188 T00111061 58008 $
KOKC2020-01-01T03:52:00.000000ZMETAR2019-12-3132.0021.9065.92190.006.0030.0501018.50CLR10.000.000KOKC 010352Z 19006KT 10SM CLR 00/M06 A3005 RMK AO2 SLP185 T00001056 $
KOKC2020-01-01T04:52:00.000000ZMETAR2019-12-3132.0021.9065.92180.005.0030.0501018.20CLR10.000.000KOKC 010452Z 18005KT 10SM CLR 00/M06 A3005 RMK AO2 SLP182 T00001056 $
KOKC2020-01-01T05:52:00.000000ZMETAR2019-12-3132.0023.0069.04170.007.0030.0201017.10FEW25000.0010.000.000KOKC 010552Z 17007KT 10SM FEW250 00/M05 A3002 RMK AO2 SLP171 T00001050 10044 20000 401061050 58012 $
KOKC2020-01-01T06:52:00.000000ZMETAR2020-01-0132.0023.0069.04170.007.0030.0001016.20FEW25000.0010.000.000KOKC 010652Z 17007KT 10SM FEW250 00/M05 A3000 RMK AO2 SLP162 T00001050 $CLIOKC5630final
KOKC2020-01-01T07:52:00.000000ZMETAR2020-01-0132.0023.0069.04180.007.0029.9801015.50FEW25000.0010.000.000KOKC 010752Z 18007KT 10SM FEW250 00/M05 A2998 RMK AO2 SLP155 T00001050 $CLIOKC5630final
KOKC2020-01-01T08:52:00.000000ZMETAR2020-01-0130.0023.0074.87180.0010.0029.9601014.90FEW25000.0010.000.000KOKC 010852Z 18010KT 10SM FEW250 M01/M05 A2996 RMK AO2 SLP149 T10111050 56020 $CLIOKC5630final
KOKC2020-01-01T09:52:00.000000ZMETAR2020-01-0134.0023.0063.72170.007.0029.9501014.40FEW25000.0010.000.000KOKC 010952Z 17007KT 10SM FEW250 01/M05 A2995 RMK AO2 SLP144 T00111050 $CLIOKC5630final
A bounded preview of the immutable release.

Columns

Schema, units, meaning, and verified release profile

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

Top: KOKC

event_time_utc0 source inputs · 4 transformationstimestamp_utc0.0%0 values67,775100.0%
Timeline per year: 2020-01-01, 10,476; 2021-01-01, 10,343; 2022-01-01, 9,975; 2023-01-01, 10,035; 2024-01-01, 10,132; 2025-01-01, 10,200; 2026-01-01, 6,616
2020-01-012026-01-01

per year

All rows, per year

observation_type0 source inputs · 4 transformationsstring0.0%0 values2<0.1%
  • METAR86%
  • SPECI14%

Top: METAR

local_standard_date0 source inputs · 4 transformationsdate0.0%0 values2,4383.6%
Timeline per year: 2019-01-01, 6; 2020-01-01, 10,486; 2021-01-01, 10,334; 2022-01-01, 9,974; 2023-01-01, 10,036; 2024-01-01, 10,131; 2025-01-01, 10,200; 2026-01-01, 6,610
2019-01-012026-01-01

per year

All rows, per year

temp_f0 source inputs · 4 transformationsdecimal<0.1%9 values1810.3%
Histogram: -11 to 4.125, 155; 4.125 to 19.25, 1,240; 19.25 to 34.375, 5,248; 34.375 to 49.5, 12,267; 49.5 to 64.625, 16,755; 64.625 to 79.75, 21,007; 79.75 to 94.875, 9,915; 94.875 to 110, 1,181
-11.00110.00

All-row histogram

Median 63.00P25 48.00 · P75 75.00
dewpoint_f0 source inputs · 4 transformationsdecimal<0.1%10 values1540.2%
Histogram: -18 to -5.625, 94; -5.625 to 6.75, 853; 6.75 to 19.125, 3,273; 19.125 to 31.5, 9,983; 31.5 to 43.875, 11,902; 43.875 to 56.25, 12,487; 56.25 to 68.625, 21,462; 68.625 to 81, 7,713
-18.0081.00

All-row histogram

Median 52.00P25 34.00 · P75 64.00
relative_humidity_pct0 source inputs · 4 transformationsdecimal<0.1%10 values4,9577.3%
Histogram: 8.9800000000000004 to 20.357500000000002, 527; 20.357500000000002 to 31.734999999999999, 3,454; 31.734999999999999 to 43.112499999999997, 6,724; 43.112499999999997 to 54.489999999999995, 9,062; 54.489999999999995 to 65.867499999999993, 10,397; 65.867499999999993 to 77.245000000000005, 11,468; 77.245000000000005 to 88.622500000000002, 11,955; 88.622500000000002 to 100, 14,180
8.98100.00

All-row histogram

Median 69.63P25 51.10 · P75 86.06
wind_direction_degrees0 source inputs · 4 transformationsdecimal1.5%1,015 values39<0.1%
Histogram: 0 to 45, 9,966; 45 to 90, 4,546; 90 to 135, 5,776; 135 to 180, 18,322; 180 to 225, 13,583; 225 to 270, 1,910; 270 to 315, 2,324; 315 to 360, 10,335
0.00360.00

All-row histogram

Median 170.00P25 110.00 · P75 210.00
wind_speed_kt0 source inputs · 4 transformationsdecimal0.1%73 values44<0.1%
Histogram: 0 to 6.5, 19,806; 6.5 to 13, 28,974; 13 to 19.5, 15,230; 19.5 to 26, 3,115; 26 to 32.5, 516; 32.5 to 39, 48; 39 to 45.5, 13; 45.5 to 52, 2
0.0052.00

All-row histogram

Median 9.00P25 6.00 · P75 13.00
wind_gust_kt0 source inputs · 4 transformationsdecimal80.7%54,708 values500.4%
Histogram: 11 to 17.75, 792; 17.75 to 24.5, 5,668; 24.5 to 31.25, 4,979; 31.25 to 38, 1,196; 38 to 44.75, 333; 44.75 to 51.5, 69; 51.5 to 58.25, 19; 58.25 to 65, 13
11.0065.00

All-row histogram

Median 25.00P25 21.00 · P75 28.00
altimeter_inhg0 source inputs · 4 transformationsdecimal<0.1%1 values1480.2%
Histogram: 29.25 to 29.434999999999999, 187; 29.434999999999999 to 29.620000000000001, 1,476; 29.620000000000001 to 29.805, 7,800; 29.805 to 29.990000000000002, 23,468; 29.990000000000002 to 30.175000000000001, 23,315; 30.175000000000001 to 30.359999999999999, 8,615; 30.359999999999999 to 30.545000000000002, 2,475; 30.545000000000002 to 30.73, 440
29.25030.730

All-row histogram

Median 30.000P25 29.890 · P75 30.120
sea_level_pressure_hpa0 source inputs · 4 transformationsdecimal14.2%9,625 values5140.9%
Histogram: 989.60000000000002 to 996.20000000000005, 164; 996.20000000000005 to 1002.8000000000001, 1,546; 1002.8000000000001 to 1009.4000000000001, 8,339; 1009.4000000000001 to 1016, 22,846; 1016 to 1022.6, 16,480; 1022.6 to 1029.2, 6,186; 1029.2 to 1035.8000000000002, 2,220; 1035.8000000000002 to 1042.4000000000001, 371
989.601042.40

All-row histogram

Median 1015.00P25 1011.10 · P75 1019.60
sky_cover_10 source inputs · 4 transformationsstring<0.1%4 values6<0.1%
  • FEW37%
  • SCT18%
  • CLR17%

Top: FEW

sky_base_1_ft0 source inputs · 4 transformationsdecimal16.7%11,344 values810.1%
Histogram: 0 to 3750, 21,804; 3750 to 7500, 8,479; 7500 to 11250, 4,566; 11250 to 15000, 2,107; 15000 to 18750, 3,873; 18750 to 22500, 2,999; 22500 to 26250, 12,575; 26250 to 30000, 30
0.0030000.00

All-row histogram

Median 6000.00P25 1800.00 · P75 20000.00
sky_cover_20 source inputs · 4 transformationsstring57.4%38,891 values4<0.1%
  • BKN40%
  • SCT26%
  • OVC18%

Top: BKN

sky_base_2_ft0 source inputs · 4 transformationsdecimal57.4%38,891 values810.3%
Histogram: 100 to 3837.5, 6,116; 3837.5 to 7575, 3,879; 7575 to 11312.5, 2,941; 11312.5 to 15050, 2,737; 15050 to 18787.5, 1,611; 18787.5 to 22525, 1,945; 22525 to 26262.5, 9,652; 26262.5 to 30000, 5
100.0030000.00

All-row histogram

Median 15000.00P25 4700.00 · P75 25000.00
sky_cover_30 source inputs · 4 transformationsstring82.3%55,759 values4<0.1%
  • BKN46%
  • OVC37%
  • SCT14%

Top: BKN

sky_base_3_ft0 source inputs · 4 transformationsdecimal82.3%55,759 values720.6%
Histogram: 1100 to 4712.5, 1,702; 4712.5 to 8325, 1,451; 8325 to 11937.5, 1,551; 11937.5 to 15550, 1,088; 15550 to 19162.5, 663; 19162.5 to 22775, 905; 22775 to 26387.5, 4,651; 26387.5 to 30000, 7
1100.0030000.00

All-row histogram

Median 18000.00P25 8000.00 · P75 25000.00
sky_cover_40 source inputs · 4 transformationsstring96.8%65,601 values40.2%
  • BKN63%
  • OVC32%
  • SCT5%

Top: BKN

sky_base_4_ft0 source inputs · 4 transformationsdecimal96.8%65,601 values150.7%
Histogram: 13000 to 15125, 379; 15125 to 17250, 45; 17250 to 19375, 104; 19375 to 21500, 261; 21500 to 23625, 32; 23625 to 25750, 1,350; 25750 to 27875, 2; 27875 to 30000, 3
13000.0030000.00

All-row histogram

Median 25000.00P25 20000.00 · P75 25000.00
Show 12 more columns
Verified column analytics for reports_kokc
visibility_miles0 source inputs · 4 transformationsdecimal<0.1%7 values20<0.1%
Histogram: 0 to 1.25, 1,604; 1.25 to 2.5, 1,742; 2.5 to 3.75, 1,391; 3.75 to 5, 750; 5 to 6.25, 1,884; 6.25 to 7.5, 1,000; 7.5 to 8.75, 1,192; 8.75 to 10, 58,207
0.0010.00

All-row histogram

Median 10.00P25 10.00 · P75 10.00
weather_codes0 source inputs · 4 transformationsstring84.7%57,421 values1401.4%
  • BR21%
  • -RA13%
  • -DZ BR7%
  • Other (128)

Top: BR · 1,912 more values

precipitation_in_1h0 source inputs · 4 transformationsdecimal6.6%4,469 values1210.2%
Histogram: 0 to 0.33500000000000002, 62,929; 0.33500000000000002 to 0.67000000000000004, 269; 0.67000000000000004 to 1.0050000000000001, 74; 1.0050000000000001 to 1.3400000000000001, 21; 1.3400000000000001 to 1.675, 12; 1.675 to 2.0100000000000002, 2; 2.0100000000000002 to 2.3450000000000002, 0; 2.3450000000000002 to 2.6800000000000002, 1
0.0002.680

All-row histogram

Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt0 source inputs · 4 transformationsdecimal87.1%59,048 values370.4%
Histogram: 26 to 30.875, 5,199; 30.875 to 35.75, 2,340; 35.75 to 40.625, 721; 40.625 to 45.5, 279; 45.5 to 50.375, 104; 50.375 to 55.25, 41; 55.25 to 60.125, 22; 60.125 to 65, 23
26.0065.00

All-row histogram

Median 29.00P25 27.00 · P75 33.00
peak_wind_direction_degrees0 source inputs · 4 transformationsdecimal87.1%59,048 values360.4%
Histogram: 10 to 53.75, 964; 53.75 to 97.5, 112; 97.5 to 141.25, 273; 141.25 to 185, 2,687; 185 to 228.75, 1,516; 228.75 to 272.5, 318; 272.5 to 316.25, 413; 316.25 to 360, 2,446
10.00360.00

All-row histogram

Median 190.00P25 160.00 · P75 320.00
peak_wind_time0 source inputs · 4 transformationsstring87.1%59,048 values7,49785.9%

7,497 distinct values, no chart

No shape worth drawing · 8,729 more values

snow_depth_inches0 source inputs · 4 transformationsdecimal99.8%67,621 values117.1%
Histogram: 0 to 1.25, 77; 1.25 to 2.5, 21; 2.5 to 3.75, 12; 3.75 to 5, 6; 5 to 6.25, 26; 6.25 to 7.5, 7; 7.5 to 8.75, 1; 8.75 to 10, 6
0.0010.00

All-row histogram

Median 2.00P25 0.00 · P75 5.00
raw_metar0 source inputs · 4 transformationsstring0.0%0 values67,777100.0%

67,777 distinct values, no chart

No shape worth drawing · 67,777 more values

cli_product0 source inputs · 4 transformationsstring0.2%113 values1<0.1%
  • CLIOKC100%

Top: CLIOKC

cli_high_f0 source inputs · 4 transformationsinteger0.2%113 values980.1%
Histogram: 4 to 17, 371; 18 to 30, 997; 31 to 44, 3,891; 45 to 57, 9,624; 58 to 70, 13,533; 71 to 84, 17,932; 85 to 97, 17,874; 98 to 110, 3,442
4110

All-row histogram

Median 75P25 60 · P75 88
cli_low_f0 source inputs · 4 transformationsinteger0.2%113 values830.1%
Histogram: -14 to -2, 62; -1 to 10, 895; 11 to 22, 3,114; 23 to 34, 10,658; 35 to 46, 12,950; 47 to 58, 12,949; 59 to 70, 18,498; 71 to 82, 8,538
-1482

All-row histogram

Median 52P25 37 · P75 66
cli_report_type0 source inputs · 4 transformationsstring0.2%113 values3<0.1%
  • final99%
  • correction1%
  • preliminary0%

Top: final

Release status

Facts from the current passing release

Release
V4 publication snapshot
Rows
67,777
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_kokc
reports_kokc
# Current release — the complete Parquet file
curl -sS -o reports-kokc.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/fdfd9aee-c524-409e-b387-23a11aae653d/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/fdfd9aee-c524-409e-b387-23a11aae653d/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/fdfd9aee-c524-409e-b387-23a11aae653d/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