Loading dataset
Data viewTableSummary
Data viewTableSummary
Updated

3.9 MB across 83 parts, newest sealed 8 November 2026 at 22:11 UTC.

The last refresh rewrote 83 parts and added 1 row.

ONE_ROW_PER_REPORT passed.

TEMP_IN_PLAUSIBLE_RANGE passed.

OFFICIAL_HIGH_MOSTLY_PRESENT passed.

YEARS_OF_REPORTS passed.

station

string

ICAO code of the reporting station.

  • KOKC100%
Valid
69,617 · 100%
Missing
0 · 0%
Distinct
1 · 0% of valid

event_time_utc

timestamp_utc

Report time in UTC.

  • 2023-02-27 01:35:00+000%
  • 2023-11-26 01:50:00+000%
  • 2020-01-01 00:52:00+000%
  • Other (69,603)
Valid
69,617 · 100%
Missing
0 · 0%
Distinct
69,615 · 100% of valid

observation_type

string

METAR for a routine report, SPECI for a special report.

  • METAR86%
  • SPECI14%
Valid
69,617 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

local_standard_date

date

Climate date on the station's fixed standard-time offset; daylight saving time is not applied.

  • 2026-01-240%
  • 2025-01-090%
  • 2021-05-310%
  • Other (2,493)
Valid
69,617 · 100%
Missing
0 · 0%
Distinct
2,505 · 3.6% of valid

temp_f

decimal

Air temperature, degrees Fahrenheit.

  • 73.002%
  • 68.002%
  • 72.002%
  • Other (169)
Valid
69,608 · 100%
Missing
9 · 0%
Distinct
181 · 0.3% of valid
Min
-11.00
25%
48.00
Median
63.00
75%
75.00
Max
110.00

dewpoint_f

decimal

Dew-point temperature, degrees Fahrenheit.

  • 68.003%
  • 67.003%
  • 66.003%
  • Other (142)
Valid
69,607 · 100%
Missing
10 · 0%
Distinct
154 · 0.2% of valid
Min
-18.00
25%
34.00
Median
52.00
75%
64.00
Max
81.00

relative_humidity_pct

decimal

Relative humidity, percent.

  • 100.004%
  • 93.320%
  • 93.290%
  • Other (4,959)
Valid
69,607 · 100%
Missing
10 · 0%
Distinct
4,971 · 7.1% of valid
Min
8.98
25%
51.08
Median
69.62
75%
86.11
Max
100.00

wind_direction_degrees

decimal

Wind direction clockwise from true north, degrees.

  • 170.0010%
  • 160.009%
  • 180.008%
  • Other (27)
Valid
68,566 · 98.5%
Missing
1,051 · 1.5%
Distinct
39 · 0.1% of valid
Min
0.00
25%
110.00
Median
170.00
75%
210.00
Max
360.00

wind_speed_kt

decimal

Sustained wind speed, knots.

  • 7.009%
  • 6.008%
  • 8.008%
  • Other (32)
Valid
69,543 · 99.9%
Missing
74 · 0.1%
Distinct
44 · 0.1% of valid
Min
0.00
25%
6.00
Median
9.00
75%
13.00
Max
52.00

wind_gust_kt

decimal

Reported wind gust, knots.

  • 24.008%
  • 23.008%
  • 22.008%
  • Other (38)
Valid
13,362 · 19.2%
Missing
56,255 · 80.8%
Distinct
50 · 0.4% of valid
Min
11.00
25%
21.00
Median
25.00
75%
28.00
Max
65.00

altimeter_inhg

decimal

Altimeter setting, inches of mercury.

  • 29.9803%
  • 29.9902%
  • 29.9602%
  • Other (136)
Valid
69,616 · 100%
Missing
1 · 0%
Distinct
148 · 0.2% of valid
Min
29.250
25%
29.890
Median
30.000
75%
30.120
Max
30.730

sea_level_pressure_hpa

decimal

Sea-level pressure, hectopascals.

  • 1014.501%
  • 1013.701%
  • 1013.501%
  • Other (502)
Valid
59,753 · 85.8%
Missing
9,864 · 14.2%
Distinct
514 · 0.9% of valid
Min
989.60
25%
1011.10
Median
1015.00
75%
1019.70
Max
1042.40

sky_cover_1

string

First sky-cover layer code.

  • FEW37%
  • SCT18%
  • CLR17%
Valid
69,613 · 100%
Missing
4 · 0%
Distinct
6 · 0% of valid

sky_base_1_ft

decimal

First sky-layer base, feet above ground.

  • 25000.0022%
  • 20000.005%
  • 15000.003%
  • Other (69)
Valid
57,900 · 83.2%
Missing
11,717 · 16.8%
Distinct
81 · 0.1% of valid
Min
0.00
25%
1800.00
Median
6000.00
75%
20000.00
Max
30000.00

sky_cover_2

string

Second sky-cover layer code.

  • BKN40%
  • SCT26%
  • OVC18%
Valid
29,710 · 42.7%
Missing
39,907 · 57.3%
Distinct
4 · 0% of valid

sky_base_2_ft

decimal

Second sky-layer base, feet above ground.

  • 25000.0033%
  • 20000.006%
  • 15000.005%
  • Other (69)
Valid
29,710 · 42.7%
Missing
39,907 · 57.3%
Distinct
81 · 0.3% of valid
Min
100.00
25%
4700.00
Median
15000.00
75%
25000.00
Max
30000.00

sky_cover_3

string

Third sky-cover layer code.

  • BKN46%
  • OVC37%
  • SCT14%
Valid
12,384 · 17.8%
Missing
57,233 · 82.2%
Distinct
4 · 0% of valid

sky_base_3_ft

decimal

Third sky-layer base, feet above ground.

  • 25000.0038%
  • 20000.007%
  • 11000.005%
  • Other (61)
Valid
12,384 · 17.8%
Missing
57,233 · 82.2%
Distinct
73 · 0.6% of valid
Min
1000.00
25%
8000.00
Median
18000.00
75%
25000.00
Max
30000.00

sky_cover_4

string

Fourth sky-cover layer code.

  • BKN63%
  • OVC32%
  • SCT5%
Valid
2,238 · 3.2%
Missing
67,379 · 96.8%
Distinct
4 · 0.2% of valid

sky_base_4_ft

decimal

Fourth sky-layer base, feet above ground.

  • 25000.0062%
  • 20000.0012%
  • 13000.009%
  • Other (3)
Valid
2,238 · 3.2%
Missing
67,379 · 96.8%
Distinct
15 · 0.7% of valid
Min
13000.00
25%
20000.00
Median
25000.00
75%
25000.00
Max
30000.00

visibility_miles

decimal

Horizontal visibility, statute miles.

  • 10.0084%
  • 9.002%
  • 8.002%
  • Other (8)
Valid
69,610 · 100%
Missing
7 · 0%
Distinct
20 · 0% of valid
Min
0.00
25%
10.00
Median
10.00
75%
10.00
Max
10.00

weather_codes

string

Present-weather codes from the report.

  • BR21%
  • -RA13%
  • -DZ BR7%
  • Other (129)
Valid
10,610 · 15.2%
Missing
59,007 · 84.8%
Distinct
141 · 1.3% of valid

precipitation_in_1h

decimal

Reported one-hour precipitation accumulation, inches; intervals can overlap.

  • 0.00093%
  • 0.0102%
  • 0.0201%
  • Other (111)
Valid
65,022 · 93.4%
Missing
4,595 · 6.6%
Distinct
123 · 0.2% of valid
Min
0.000
25%
0.000
Median
0.000
75%
0.000
Max
2.680

peak_wind_gust_kt

decimal

Peak-wind gust from report remarks, knots.

  • 26.0015%
  • 27.0013%
  • 28.0012%
  • Other (25)
Valid
8,848 · 12.7%
Missing
60,769 · 87.3%
Distinct
37 · 0.4% of valid
Min
26.00
25%
27.00
Median
29.00
75%
33.00
Max
65.00

peak_wind_direction_degrees

decimal

Peak-wind direction from report remarks, degrees.

  • 180.0013%
  • 170.008%
  • 190.008%
  • Other (24)
Valid
8,848 · 12.7%
Missing
60,769 · 87.3%
Distinct
36 · 0.4% of valid
Min
10.00
25%
160.00
Median
190.00
75%
320.00
Max
360.00

peak_wind_time

string

Peak-wind time as reported.

  • 2021-06-26 08:590%
  • 2021-10-15 05:130%
  • 2021-01-01 06:070%
  • Other (7,588)
Valid
8,848 · 12.7%
Missing
60,769 · 87.3%
Distinct
7,600 · 85.9% of valid

snow_depth_inches

decimal

Reported snow depth, inches.

  • 0.0027%
  • 1.0022%
  • 2.0013%
Valid
156 · 0.2%
Missing
69,461 · 99.8%
Distinct
11 · 7.1% of valid
Min
0.00
25%
0.00
Median
2.00
75%
5.00
Max
10.00

raw_metar

string

Original METAR or SPECI report text.

  • KOKC 010001Z 02007KT 10SM FEW010 SCT019 OVC200 19/17 A3004 RMK AO2 T01940172 $0%
  • KOKC 010005Z 02017KT 9SM -FZRA SCT021 OVC031 00/M03 A2987 RMK AO2 P0002 T000010280%
  • KOKC 010006Z 04011KT 1 1/2SM -DZ BR OVC003 16/15 A3006 RMK AO2 P0000 T015601500%
  • Other (69,605)
Valid
69,617 · 100%
Missing
0 · 0%
Distinct
69,617 · 100% of valid

valid

string

Report time in UTC exactly as the Iowa Environmental Mesonet publishes it (YYYY-MM-DD HH:MM); refreshes replace whole days keyed on it.

  • 2023-02-27 01:350%
  • 2023-11-26 01:500%
  • 2020-01-01 00:520%
  • Other (69,603)
Valid
69,617 · 100%
Missing
0 · 0%
Distinct
69,615 · 100% of valid

cli_product

string

NWS CLI product identifier the day's official values came from; null when no report was archived for the date.

  • CLIOKC100%
Valid
69,488 · 99.8%
Missing
129 · 0.2%
Distinct
1 · 0% of valid

cli_high_f

integer

Official NWS daily maximum temperature for the report's climate date, degrees Fahrenheit.

Histogram: 4 to 17.25, 371; 17.25 to 30.5, 997; 30.5 to 43.75, 3,545; 43.75 to 57, 9,020; 57 to 70.25, 14,851; 70.25 to 83.5, 17,156; 83.5 to 96.75, 18,967; 96.75 to 110, 4,581
4110
Valid
69,488 · 99.8%
Missing
129 · 0.2%
Distinct
98 · 0.1% of valid
Min
4
25%
61
Median
76
75%
88
Max
110

cli_low_f

integer

Official NWS daily minimum temperature for the report's climate date, degrees Fahrenheit.

Histogram: -14 to -2, 62; -2 to 10, 699; 10 to 22, 2,762; 22 to 34, 10,287; 34 to 46, 13,184; 46 to 58, 12,902; 58 to 70, 18,577; 70 to 82, 11,015
-1482
Valid
69,488 · 99.8%
Missing
129 · 0.2%
Distinct
83 · 0.1% of valid
Min
-14
25%
37
Median
53
75%
66
Max
82

cli_report_type

string

NWS report version inferred from issue time: preliminary, final, or correction.

  • final99%
  • correction1%
  • preliminary0%
Valid
69,488 · 99.8%
Missing
129 · 0.2%
Distinct
3 · 0% of valid

Support

Talk to Mostly Right

Loading chat…