reports_kmdw

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:27

Rows: 68,124; across released Tables
Tables: 1; released
Columns: 34; reports_kmdw
Version: —; reports_kmdw

Data preview

reports_kmdw

Preview rows for reports_kmdw
station	event_time_utc	observation_type	local_standard_date	temp_f	dewpoint_f	relative_humidity_pct	wind_direction_degrees	wind_speed_kt	wind_gust_kt	altimeter_inhg	sea_level_pressure_hpa	sky_cover_1	sky_base_1_ft	sky_cover_2	sky_base_2_ft	sky_cover_3	sky_base_3_ft	sky_cover_4	sky_base_4_ft
KMDW	2020-01-01T06:34:00.000000Z	SPECI	2020-01-01	27.00	21.90	80.83	270.00	7.00	—	29.820	—	BKN	1600.00	—	—	—	—	—	—
KMDW	2020-01-01T06:53:00.000000Z	METAR	2020-01-01	27.00	21.90	80.83	260.00	8.00	—	29.810	1011.00	BKN	1400.00	—	—	—	—	—	—
KMDW	2020-01-01T07:41:00.000000Z	SPECI	2020-01-01	26.10	21.00	80.75	270.00	8.00	—	29.810	—	SCT	1400.00	—	—	—	—	—	—
KMDW	2020-01-01T07:53:00.000000Z	METAR	2020-01-01	26.10	21.00	80.75	270.00	7.00	—	29.810	1011.00	SCT	1400.00	—	—	—	—	—	—
KMDW	2020-01-01T08:53:00.000000Z	METAR	2020-01-01	24.10	19.90	83.75	250.00	7.00	—	29.830	1011.40	FEW	1400.00	—	—	—	—	—	—
KMDW	2020-01-01T09:53:00.000000Z	METAR	2020-01-01	24.10	19.90	83.75	250.00	6.00	—	29.820	1011.20	FEW	1400.00	—	—	—	—	—	—
KMDW	2020-01-01T10:53:00.000000Z	METAR	2020-01-01	23.00	19.90	87.70	240.00	8.00	—	29.820	1011.00	FEW	1400.00	—	—	—	—	—	—
KMDW	2020-01-01T11:53:00.000000Z	METAR	2020-01-01	23.00	19.00	84.39	240.00	6.00	—	29.810	1011.00	FEW	1400.00	—	—	—	—	—	—
KMDW	2020-01-01T12:53:00.000000Z	METAR	2020-01-01	23.00	19.00	84.39	240.00	8.00	—	29.810	1010.90	FEW	1500.00	—	—	—	—	—	—
KMDW	2020-01-01T13:53:00.000000Z	METAR	2020-01-01	23.00	19.90	87.70	220.00	7.00	—	29.810	1010.80	CLR	—	—	—	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

34 columns

Verified column analytics for reports_kmdw
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	KMDW100% Top: KMDW	—
event_time_utc	timestamp_utc	—	0.0%0 values	68,122100.0%	2024-03-30 17:55:00+000% 2026-04-29 14:50:00+000% 2020-01-01 06:34:00+000% Other (68,110) Top: 2024-03-30 17:55:00+00 · 68,110 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	METAR86% SPECI14% Top: METAR	—
local_standard_date	date	—	0.0%0 values	2,4433.6%	2023-01-030% 2023-10-310% 2020-05-170% Other (2,431) Top: 2023-01-03 · 67,462 more values	—
temp_f	decimal	—	<0.1%3 values	1640.2%	73.002% 72.002% 71.002% Other (152) Top: 73.00 · 52,229 more values	Median 54.00P25 37.00 · P75 71.00
dewpoint_f	decimal	—	<0.1%4 values	1600.2%	30.002% 32.002% 28.002% Other (148) Top: 30.00 · 52,428 more values	Median 41.00P25 27.00 · P75 57.00
relative_humidity_pct	decimal	—	<0.1%4 values	4,6656.8%	100.001% 75.750% 75.560% Other (4,653) Top: 100.00 · 66,246 more values	Median 66.08P25 52.39 · P75 78.74
wind_direction_degrees	decimal	—	1.0%666 values	37<0.1%	210.005% 200.005% 0.005% Other (25) Top: 210.00 · 36,754 more values	Median 200.00P25 90.00 · P75 270.00
wind_speed_kt	decimal	—	<0.1%14 values	35<0.1%	8.009% 7.009% 6.009% Other (23) Top: 8.00 · 10,024 more values	Median 8.00P25 6.00 · P75 12.00
wind_gust_kt	decimal	—	77.1%52,497 values	490.3%	21.0010% 22.009% 20.009% Other (37) Top: 21.00 · 3,087 more values	Median 23.00P25 20.00 · P75 26.00
altimeter_inhg	decimal	—	<0.1%2 values	1860.3%	29.9902% 30.0102% 30.0002% Other (174) Top: 29.990 · 51,790 more values	Median 30.000P25 29.860 · P75 30.130
sea_level_pressure_hpa	decimal	—	14.1%9,604 values	5961.0%	1014.901% 1016.901% 1014.101% Other (584) Top: 1014.90 · 54,166 more values	Median 1016.00P25 1011.50 · P75 1020.90
sky_cover_1	string	—	<0.1%2 values	6<0.1%	FEW39% BKN20% SCT15% Top: FEW	—
sky_base_1_ft	decimal	—	9.4%6,383 values	790.1%	25000.0011% 6000.003% 5000.003% Other (67) Top: 25000.00 · 37,804 more values	Median 3800.00P25 1700.00 · P75 9000.00
sky_cover_2	string	—	45.1%30,704 values	4<0.1%	BKN44% OVC22% SCT17% Top: BKN	—
sky_base_2_ft	decimal	—	45.1%30,704 values	770.2%	25000.0023% 20000.004% 15000.004% Other (65) Top: 25000.00 · 17,587 more values	Median 9000.00P25 3600.00 · P75 20000.00
sky_cover_3	string	—	73.7%50,187 values	4<0.1%	BKN46% OVC41% SCT10% Top: BKN	—
sky_base_3_ft	decimal	—	73.7%50,187 values	690.4%	25000.0033% 11000.005% 20000.005% Other (57) Top: 25000.00 · 5,847 more values	Median 14000.00P25 6500.00 · P75 25000.00
sky_cover_4	string	—	94.2%64,190 values	40.1%	BKN64% OVC32% SCT4% Top: BKN	—
sky_base_4_ft	decimal	—	94.2%64,190 values	140.4%	25000.0067% 20000.009% 15000.008% Other (2) Top: 25000.00 · 19 more values	Median 25000.00P25 20000.00 · P75 25000.00

Show 14 more columns

Verified column analytics for reports_kmdw
visibility_miles	decimal	—	<0.1%4 values	18<0.1%	10.0079% 9.003% 8.002% Other (6) Top: 10.00 · 1,604 more values	Median 10.00P25 10.00 · P75 10.00
weather_codes	string	—	79.7%54,286 values	1160.8%	-SN BR17% -RA15% BR13% Other (104) Top: -SN BR · 1,769 more values	—
precipitation_in_1h	decimal	—	13.0%8,853 values	990.2%	0.00091% 0.0103% 0.0201% Other (87) Top: 0.000 · 996 more values	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt	decimal	—	89.0%60,606 values	370.5%	26.0017% 27.0014% 28.0012% Other (25) Top: 26.00 · 696 more values	Median 29.00P25 27.00 · P75 33.00
peak_wind_direction_degrees	decimal	—	89.0%60,606 values	360.5%	210.009% 270.006% 260.006% Other (24) Top: 210.00 · 2,830 more values	Median 230.00P25 180.00 · P75 280.00
peak_wind_time	string	—	89.0%60,606 values	6,42085.4%	2021-02-04 18:570% 2022-11-19 18:590% 2020-04-28 22:580% Other (6,408) Top: 2021-02-04 18:57 · 7,447 more values	—
snow_depth_inches	decimal	—	99.0%67,468 values	253.8%	1.0043% 2.0017% 4.0010% Other (13) Top: 1.00 · 36 more values	Median 2.00P25 1.00 · P75 4.00
raw_metar	string	—	0.0%0 values	68,124100.0%	KMDW 010006Z VRB04KT 4SM BR FEW008 OVC011 08/05 A2962 RMK AO2 T007800500% KMDW 010012Z 30010G19KT 9SM -SN FEW008 BKN013 OVC023 01/M02 A3016 RMK AO2 P0000 T00111022 $0% KMDW 010026Z 02013G22KT 2 1/2SM -SN BR BKN008 OVC015 00/M02 A3004 RMK AO2 DRSN P0000 T000010220% Other (68,112) Top: KMDW 010006Z VRB04KT 4SM BR FEW008 OVC011 08/05 A2962 RMK AO2 T00780050 · 68,112 more values	—
cli_product	string	—	<0.1%12 values	1<0.1%	CLIMDW100% Top: CLIMDW	—
cli_high_f	integer	—	<0.1%41 values	980.1%	-1101 All-row histogram	Median 63P25 44 · P75 80
cli_low_f	integer	—	<0.1%41 values	880.1%	-983 All-row histogram	Median 45P25 32 · P75 63
cli_report_type	string	—	<0.1%12 values	3<0.1%	final99% correction1% preliminary0% Top: final	—
metar_high_f	decimal	—	0.0%0 values	1180.2%	83.003% 81.002% 79.002% Other (106) Top: 83.00 · 51,520 more values	Median 63.00P25 43.00 · P75 79.00
metar_low_f	decimal	—	0.0%0 values	1170.2%	70.003% 32.003% 34.003% Other (105) Top: 70.00 · 49,123 more values	Median 45.00P25 32.00 · P75 63.00

Release status

Facts from the current passing release

Release: Passing
Rows: 68,124
Columns: 34
Published: 9 Sept 2026, 06:27
Analytics: Verified across all rows

Use dataset

Query this dataset with the API, connect an AI tool with MCP, or download a Parquet file.

cURL · reports_kmdw

reports_kmdw

# Current release — the complete Parquet file
curl -sS -o reports-kmdw.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/d6ee549a-2627-42db-a0cf-1cbda28f6339/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/d6ee549a-2627-42db-a0cf-1cbda28f6339/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/d6ee549a-2627-42db-a0cf-1cbda28f6339/query" \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  -H "content-type: application/json" \
  --data '{"columns": ["station","event_time_utc"], "limit": 100}'

MOSTLYRIGHT_API_KEY requires an mr_use_ API key from a workspace that has added this dataset. An mr_live_ key will not work here. 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

Chicago weather reports and daily highs since 2020

reports_kmdw

Release status