reports_kmdw

Release V4 publication snapshot

Current data

Latest passing release for each Table

Updated 4 Sept 2026, 09:28

Rows: 67,983; across released Tables
Tables: 1; released
Columns: 32; reports_kmdw
Version: V4 publication snapshot; 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	visibility_miles	weather_codes	peak_wind_gust_kt	peak_wind_direction_degrees	peak_wind_time	snow_depth_inches	raw_metar	cli_product	cli_high_f	cli_low_f	cli_report_type
KMDW	2020-01-01T00:53:00.000000Z	METAR	2019-12-31	28.90	21.00	71.96	280.00	13.00	—	29.820	1011.00	BKN	2100.00	—	—	—	—	—	—	10.00	—	—	—	—	—	KMDW 010053Z 28013KT 10SM BKN021 M02/M06 A2982 RMK AO2 SLP110 T10171061 $	—	—	—	—
KMDW	2020-01-01T01:53:00.000000Z	METAR	2019-12-31	28.90	21.90	74.76	270.00	11.00	—	29.830	1011.30	OVC	2000.00	—	—	—	—	—	—	10.00	—	—	—	—	—	KMDW 010153Z 27011KT 10SM OVC020 M02/M06 A2983 RMK AO2 SLP113 T10171056 $	—	—	—	—
KMDW	2020-01-01T02:29:00.000000Z	SPECI	2019-12-31	28.90	21.00	71.96	270.00	10.00	—	29.830	—	SCT	2000.00	—	—	—	—	—	—	10.00	—	—	—	—	—	KMDW 010229Z 27010KT 10SM SCT020 M02/M06 A2983 RMK AO2 T10171061 $	—	—	—	—
KMDW	2020-01-01T02:53:00.000000Z	METAR	2019-12-31	28.90	21.90	74.76	260.00	15.00	23.00	29.820	1011.10	SCT	2000.00	—	—	—	—	—	—	10.00	—	—	—	—	—	KMDW 010253Z 26015G23KT 10SM SCT020 M02/M06 A2982 RMK AO2 SLP111 T10171056 50003 $	—	—	—	—
KMDW	2020-01-01T03:37:00.000000Z	SPECI	2019-12-31	28.90	21.90	74.76	260.00	10.00	—	29.820	—	BKN	2000.00	—	—	—	—	—	—	10.00	—	—	—	—	—	KMDW 010337Z 26010KT 10SM BKN020 M02/M06 A2982 RMK AO2 T10171056 $	—	—	—	—
KMDW	2020-01-01T03:53:00.000000Z	METAR	2019-12-31	28.90	21.90	74.76	270.00	8.00	—	29.820	1011.10	BKN	1900.00	—	—	—	—	—	—	10.00	—	—	—	—	—	KMDW 010353Z 27008KT 10SM BKN019 M02/M06 A2982 RMK AO2 SLP111 T10171056 $	—	—	—	—
KMDW	2020-01-01T04:53:00.000000Z	METAR	2019-12-31	28.90	21.90	74.76	270.00	15.00	—	29.820	1011.20	BKN	1800.00	—	—	—	—	—	—	10.00	—	—	—	—	—	KMDW 010453Z 27015KT 10SM BKN018 M02/M06 A2982 RMK AO2 SLP112 T10171056 $	—	—	—	—
KMDW	2020-01-01T05:53:00.000000Z	METAR	2019-12-31	27.00	21.90	80.83	260.00	7.00	—	29.810	1010.90	SCT	1600.00	—	—	—	—	—	—	10.00	—	—	—	—	—	KMDW 010553Z 26007KT 10SM SCT016 M03/M06 A2981 RMK AO2 SLP109 4/001 T10281056 11011 21028 410111033 58003 $	—	—	—	—
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	—	—	—	—	—	—	9.00	—	—	—	—	—	KMDW 010634Z 27007KT 9SM BKN016 M03/M06 A2982 RMK AO2 T10281056 $	CLIMDW	43	22	final
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	—	—	—	—	—	—	9.00	—	—	—	—	—	KMDW 010653Z 26008KT 9SM BKN014 M03/M06 A2981 RMK AO2 SLP110 T10281056 $	CLIMDW	43	22	final

Columns

Schema, units, meaning, and verified release profile

32 columns

Verified column analytics for reports_kmdw
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station0 source inputs · 4 transformations	string	—	0.0%0 values	1<0.1%	KMDW100% Top: KMDW	—
event_time_utc0 source inputs · 4 transformations	timestamp_utc	—	0.0%0 values	67,981100.0%	2020-01-012026-01-01 per year All rows, per year	—
observation_type0 source inputs · 4 transformations	string	—	0.0%0 values	2<0.1%	METAR86% SPECI14% Top: METAR	—
local_standard_date0 source inputs · 4 transformations	date	—	0.0%0 values	2,4383.6%	2019-01-012026-01-01 per year All rows, per year	—
temp_f0 source inputs · 4 transformations	decimal	—	<0.1%3 values	1640.2%	-9.00101.00 All-row histogram	Median 53.00P25 37.00 · P75 71.00
dewpoint_f0 source inputs · 4 transformations	decimal	—	<0.1%4 values	1600.2%	-27.0080.00 All-row histogram	Median 41.00P25 27.00 · P75 57.00
relative_humidity_pct0 source inputs · 4 transformations	decimal	—	<0.1%4 values	4,6656.9%	13.84100.00 All-row histogram	Median 66.08P25 52.38 · P75 78.76
wind_direction_degrees0 source inputs · 4 transformations	decimal	—	1.0%663 values	37<0.1%	0.00360.00 All-row histogram	Median 200.00P25 90.00 · P75 270.00
wind_speed_kt0 source inputs · 4 transformations	decimal	—	<0.1%14 values	35<0.1%	0.0037.00 All-row histogram	Median 8.00P25 6.00 · P75 12.00
wind_gust_kt0 source inputs · 4 transformations	decimal	—	77.0%52,373 values	490.3%	14.0069.00 All-row histogram	Median 23.00P25 20.00 · P75 26.00
altimeter_inhg0 source inputs · 4 transformations	decimal	—	<0.1%2 values	1860.3%	28.95030.810 All-row histogram	Median 30.000P25 29.860 · P75 30.130
sea_level_pressure_hpa0 source inputs · 4 transformations	decimal	—	14.1%9,595 values	5961.0%	981.101045.10 All-row histogram	Median 1016.00P25 1011.50 · P75 1021.00
sky_cover_10 source inputs · 4 transformations	string	—	<0.1%2 values	6<0.1%	FEW39% BKN20% SCT15% Top: FEW	—
sky_base_1_ft0 source inputs · 4 transformations	decimal	—	9.4%6,376 values	790.1%	0.0030000.00 All-row histogram	Median 3800.00P25 1700.00 · P75 9000.00
sky_cover_20 source inputs · 4 transformations	string	—	45.1%30,651 values	4<0.1%	BKN44% OVC22% SCT17% Top: BKN	—
sky_base_2_ft0 source inputs · 4 transformations	decimal	—	45.1%30,651 values	770.2%	500.0035000.00 All-row histogram	Median 9000.00P25 3600.00 · P75 20000.00
sky_cover_30 source inputs · 4 transformations	string	—	73.7%50,084 values	4<0.1%	BKN46% OVC41% SCT10% Top: BKN	—
sky_base_3_ft0 source inputs · 4 transformations	decimal	—	73.7%50,084 values	690.4%	1200.0035000.00 All-row histogram	Median 14000.00P25 6500.00 · P75 25000.00
sky_cover_40 source inputs · 4 transformations	string	—	94.2%64,055 values	40.1%	BKN64% OVC32% SCT4% Top: BKN	—
sky_base_4_ft0 source inputs · 4 transformations	decimal	—	94.2%64,055 values	140.4%	13000.0030000.00 All-row histogram	Median 25000.00P25 20000.00 · P75 25000.00

Show 12 more columns

Verified column analytics for reports_kmdw
visibility_miles0 source inputs · 4 transformations	decimal	—	<0.1%4 values	18<0.1%	0.1210.00 All-row histogram	Median 10.00P25 10.00 · P75 10.00
weather_codes0 source inputs · 4 transformations	string	—	79.6%54,145 values	1160.8%	-SN BR17% -RA15% BR13% Other (104) Top: -SN BR · 1,769 more values	—
precipitation_in_1h0 source inputs · 4 transformations	decimal	—	13.0%8,850 values	990.2%	0.0002.010 All-row histogram	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt0 source inputs · 4 transformations	decimal	—	88.9%60,469 values	370.5%	26.0069.00 All-row histogram	Median 29.00P25 27.00 · P75 33.00
peak_wind_direction_degrees0 source inputs · 4 transformations	decimal	—	88.9%60,469 values	360.5%	10.00360.00 All-row histogram	Median 230.00P25 180.00 · P75 280.00
peak_wind_time0 source inputs · 4 transformations	string	—	88.9%60,469 values	6,41785.4%	6,417 distinct values, no chart No shape worth drawing · 7,514 more values	—
snow_depth_inches0 source inputs · 4 transformations	decimal	—	99.0%67,327 values	253.8%	1.0025.00 All-row histogram	Median 2.00P25 1.00 · P75 4.00
raw_metar0 source inputs · 4 transformations	string	—	0.0%0 values	67,983100.0%	67,983 distinct values, no chart No shape worth drawing · 67,983 more values	—
cli_product0 source inputs · 4 transformations	string	—	<0.1%8 values	1<0.1%	CLIMDW100% Top: CLIMDW	—
cli_high_f0 source inputs · 4 transformations	integer	—	<0.1%37 values	980.1%	-1101 All-row histogram	Median 63P25 44 · P75 80
cli_low_f0 source inputs · 4 transformations	integer	—	<0.1%37 values	880.1%	-983 All-row histogram	Median 45P25 32 · P75 63
cli_report_type0 source inputs · 4 transformations	string	—	<0.1%8 values	3<0.1%	final99% correction1% preliminary0% Top: final	—

Release status

Facts from the current passing release

Release: V4 publication snapshot
Rows: 67,983
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_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/1933e0be-5f4a-47e9-9085-f95a898a64fa/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/1933e0be-5f4a-47e9-9085-f95a898a64fa/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/1933e0be-5f4a-47e9-9085-f95a898a64fa/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

US Weather Reports and Daily Highs in 20 Cities

reports_kmdw

Release status