Loading dataset
Data viewTableSummary
Data viewTableSummary
Updated

4.1 MB across 83 parts, newest sealed 8 November 2026 at 23:13 UTC.

The last refresh rewrote 83 parts and added 3 rows.

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.

  • KDCA100%
Valid
73,392 · 100%
Missing
0 · 0%
Distinct
1 · 0% of valid

event_time_utc

timestamp_utc

Report time in UTC.

  • 2024-12-29 03:50:00+000%
  • 2025-05-28 11:50:00+000%
  • 2020-01-01 00:52:00+000%
  • Other (73,378)
Valid
73,392 · 100%
Missing
0 · 0%
Distinct
73,390 · 100% of valid

observation_type

string

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

  • METAR82%
  • SPECI18%
Valid
73,392 · 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.

  • 2022-12-310%
  • 2025-01-060%
  • 2024-12-100%
  • Other (2,493)
Valid
73,392 · 100%
Missing
0 · 0%
Distinct
2,505 · 3.4% of valid

temp_f

decimal

Air temperature, degrees Fahrenheit.

  • 76.003%
  • 75.002%
  • 74.002%
  • Other (129)
Valid
73,383 · 100%
Missing
9 · 0%
Distinct
141 · 0.2% of valid
Min
9.00
25%
47.00
Median
61.00
75%
74.00
Max
103.00

dewpoint_f

decimal

Dew-point temperature, degrees Fahrenheit.

  • 70.002%
  • 71.002%
  • 69.002%
  • Other (128)
Valid
73,378 · 100%
Missing
14 · 0%
Distinct
140 · 0.2% of valid
Min
-14.00
25%
34.00
Median
50.00
75%
64.00
Max
80.00

relative_humidity_pct

decimal

Relative humidity, percent.

  • 100.000%
  • 90.400%
  • 87.240%
  • Other (4,570)
Valid
73,378 · 100%
Missing
14 · 0%
Distinct
4,582 · 6.2% of valid
Min
12.30
25%
50.61
Median
68.96
75%
84.52
Max
100.00

wind_direction_degrees

decimal

Wind direction clockwise from true north, degrees.

  • 0.008%
  • 190.007%
  • 180.006%
  • Other (26)
Valid
72,197 · 98.4%
Missing
1,195 · 1.6%
Distinct
38 · 0.1% of valid
Min
0.00
25%
70.00
Median
180.00
75%
290.00
Max
360.00

wind_speed_kt

decimal

Sustained wind speed, knots.

  • 6.0010%
  • 5.0010%
  • 7.0010%
  • Other (26)
Valid
73,320 · 99.9%
Missing
72 · 0.1%
Distinct
38 · 0.1% of valid
Min
0.00
25%
4.00
Median
7.00
75%
10.00
Max
41.00

wind_gust_kt

decimal

Reported wind gust, knots.

  • 21.009%
  • 19.008%
  • 20.008%
  • Other (32)
Valid
9,867 · 13.4%
Missing
63,525 · 86.6%
Distinct
44 · 0.4% of valid
Min
13.00
25%
19.00
Median
22.00
75%
26.00
Max
60.00

altimeter_inhg

decimal

Altimeter setting, inches of mercury.

  • 29.9602%
  • 29.9802%
  • 30.0302%
  • Other (180)
Valid
73,383 · 100%
Missing
9 · 0%
Distinct
192 · 0.3% of valid
Min
28.980
25%
29.890
Median
30.030
75%
30.170
Max
30.930

sea_level_pressure_hpa

decimal

Sea-level pressure, hectopascals.

  • 1015.801%
  • 1015.901%
  • 1014.701%
  • Other (553)
Valid
59,910 · 81.6%
Missing
13,482 · 18.4%
Distinct
565 · 0.9% of valid
Min
981.40
25%
1012.80
Median
1017.20
75%
1022.00
Max
1047.40

sky_cover_1

string

First sky-cover layer code.

  • FEW37%
  • BKN21%
  • SCT20%
Valid
73,390 · 100%
Missing
2 · 0%
Distinct
6 · 0% of valid

sky_base_1_ft

decimal

First sky-layer base, feet above ground.

  • 25000.0013%
  • 6000.005%
  • 5000.005%
  • Other (65)
Valid
68,151 · 92.9%
Missing
5,241 · 7.1%
Distinct
77 · 0.1% of valid
Min
0.00
25%
1700.00
Median
5000.00
75%
11000.00
Max
25000.00

sky_cover_2

string

Second sky-cover layer code.

  • BKN44%
  • OVC23%
  • SCT20%
Valid
41,001 · 55.9%
Missing
32,391 · 44.1%
Distinct
4 · 0% of valid

sky_base_2_ft

decimal

Second sky-layer base, feet above ground.

  • 25000.0026%
  • 10000.004%
  • 11000.003%
  • Other (67)
Valid
41,001 · 55.9%
Missing
32,391 · 44.1%
Distinct
79 · 0.2% of valid
Min
200.00
25%
4500.00
Median
10000.00
75%
25000.00
Max
28000.00

sky_cover_3

string

Third sky-cover layer code.

  • OVC47%
  • BKN42%
  • SCT10%
Valid
17,212 · 23.5%
Missing
56,180 · 76.5%
Distinct
4 · 0% of valid

sky_base_3_ft

decimal

Third sky-layer base, feet above ground.

  • 25000.0030%
  • 11000.007%
  • 10000.004%
  • Other (55)
Valid
17,212 · 23.5%
Missing
56,180 · 76.5%
Distinct
67 · 0.4% of valid
Min
1000.00
25%
7000.00
Median
12000.00
75%
25000.00
Max
26000.00

sky_cover_4

string

Fourth sky-cover layer code.

  • BKN67%
  • OVC30%
  • SCT3%
Valid
2,586 · 3.5%
Missing
70,806 · 96.5%
Distinct
3 · 0.1% of valid

sky_base_4_ft

decimal

Fourth sky-layer base, feet above ground.

  • 25000.0068%
  • 20000.008%
  • 15000.006%
  • Other (2)
Valid
2,586 · 3.5%
Missing
70,806 · 96.5%
Distinct
14 · 0.5% of valid
Min
12000.00
25%
20000.00
Median
25000.00
75%
25000.00
Max
25000.00

visibility_miles

decimal

Horizontal visibility, statute miles.

  • 10.0081%
  • 9.002%
  • 4.002%
  • Other (8)
Valid
73,387 · 100%
Missing
5 · 0%
Distinct
20 · 0% of valid
Min
0.06
25%
10.00
Median
10.00
75%
10.00
Max
56.00

weather_codes

string

Present-weather codes from the report.

  • -RA24%
  • -RA BR15%
  • BR10%
  • Other (137)
Valid
14,860 · 20.2%
Missing
58,532 · 79.8%
Distinct
149 · 1% of valid

precipitation_in_1h

decimal

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

  • 0.00087%
  • 0.0104%
  • 0.0202%
  • Other (109)
Valid
66,303 · 90.3%
Missing
7,089 · 9.7%
Distinct
121 · 0.2% of valid
Min
0.000
25%
0.000
Median
0.000
75%
0.000
Max
2.260

peak_wind_gust_kt

decimal

Peak-wind gust from report remarks, knots.

  • 26.0015%
  • 27.0013%
  • 28.0011%
  • Other (20)
Valid
4,969 · 6.8%
Missing
68,423 · 93.2%
Distinct
32 · 0.6% of valid
Min
26.00
25%
27.00
Median
30.00
75%
34.00
Max
60.00

peak_wind_direction_degrees

decimal

Peak-wind direction from report remarks, degrees.

  • 320.0013%
  • 330.0012%
  • 290.009%
  • Other (24)
Valid
4,969 · 6.8%
Missing
68,423 · 93.2%
Distinct
36 · 0.7% of valid
Min
10.00
25%
240.00
Median
300.00
75%
320.00
Max
360.00

peak_wind_time

string

Peak-wind time as reported.

  • 2021-07-02 01:060%
  • 2021-07-01 19:070%
  • 2020-07-22 19:540%
  • Other (3,993)
Valid
4,969 · 6.8%
Missing
68,423 · 93.2%
Distinct
4,005 · 80.6% of valid

snow_depth_inches

decimal

Reported snow depth, inches.

  • 2.0021%
  • 3.0020%
  • 1.0018%
Valid
179 · 0.2%
Missing
73,213 · 99.8%
Distinct
7 · 3.9% of valid
Min
1.00
25%
2.00
Median
3.00
75%
5.00
Max
7.00

raw_metar

string

Original METAR or SPECI report text.

  • KDCA 010000Z 00000KT 10SM TS SCT025CB BKN070 31/24 A2983 RMK AO2 LTG DSNT E-SW TSB2356 OCNL LTGICCC E AND S TS E AND S MOV E T03110244 $0%
  • KDCA 010000Z 01009KT 4SM -SNPL BR SCT008 OVC012 M01/M02 A3002 RMK AO2 PLB58 P0000 T100610170%
  • KDCA 010000Z 32010G21KT 2 1/2SM TSRA BKN032CB BKN050 OVC090 19/16 A2960 RMK AO2 WSHFT 2339 OCNL LTGIC ALQDS TS ALQDS MOV NE P0006 T018901610%
  • Other (73,380)
Valid
73,392 · 100%
Missing
0 · 0%
Distinct
73,392 · 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.

  • 2024-12-29 03:500%
  • 2025-05-28 11:500%
  • 2020-01-01 00:520%
  • Other (73,378)
Valid
73,392 · 100%
Missing
0 · 0%
Distinct
73,390 · 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.

  • CLIDCA100%
Valid
73,387 · 100%
Missing
5 · 0%
Distinct
1 · 0% of valid

cli_high_f

integer

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

Histogram: 21 to 31.375, 671; 31.375 to 41.75, 3,924; 41.75 to 52.125, 9,727; 52.125 to 62.5, 11,959; 62.5 to 72.875, 12,604; 72.875 to 83.25, 15,688; 83.25 to 93.625, 15,681; 93.625 to 104, 2,941
21104
Valid
73,195 · 99.7%
Missing
197 · 0.3%
Distinct
83 · 0.1% of valid
Min
21
25%
56
Median
71
75%
84
Max
104

cli_low_f

integer

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

Histogram: 9 to 18.375, 772; 18.375 to 27.75, 2,869; 27.75 to 37.125, 12,203; 37.125 to 46.5, 12,068; 46.5 to 55.875, 11,925; 55.875 to 65.25, 12,732; 65.25 to 74.625, 15,633; 74.625 to 84, 4,993
984
Valid
73,195 · 99.7%
Missing
197 · 0.3%
Distinct
74 · 0.1% of valid
Min
9
25%
40
Median
53
75%
67
Max
84

cli_report_type

string

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

  • final99%
  • correction1%
  • preliminary0%
Valid
73,387 · 100%
Missing
5 · 0%
Distinct
3 · 0% of valid

Support

Talk to Mostly Right

Loading chat…