reports_kmia

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:29

Rows: 67,420; across released Tables
Tables: 1; released
Columns: 34; reports_kmia
Version: —; reports_kmia

Data preview

reports_kmia

Preview rows for reports_kmia
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
KMIA	2020-01-01T05:53:00.000000Z	METAR	2020-01-01	63.00	50.00	62.49	0.00	0.00	—	30.040	1017.20	CLR	—	—	—	—	—	—	—
KMIA	2020-01-01T06:53:00.000000Z	METAR	2020-01-01	64.00	53.00	67.66	0.00	0.00	—	30.030	1017.00	CLR	—	—	—	—	—	—	—
KMIA	2020-01-01T07:53:00.000000Z	METAR	2020-01-01	65.00	55.00	70.28	320.00	4.00	—	30.040	1017.10	CLR	—	—	—	—	—	—	—
KMIA	2020-01-01T08:53:00.000000Z	METAR	2020-01-01	65.00	57.00	75.56	—	3.00	—	30.030	1016.80	CLR	—	—	—	—	—	—	—
KMIA	2020-01-01T09:53:00.000000Z	METAR	2020-01-01	63.00	54.00	72.42	340.00	3.00	—	30.030	1016.90	CLR	—	—	—	—	—	—	—
KMIA	2020-01-01T10:53:00.000000Z	METAR	2020-01-01	63.00	50.00	62.49	340.00	3.00	—	30.030	1017.00	CLR	—	—	—	—	—	—	—
KMIA	2020-01-01T11:53:00.000000Z	METAR	2020-01-01	62.00	50.00	64.50	340.00	4.00	—	30.050	1017.60	CLR	—	—	—	—	—	—	—
KMIA	2020-01-01T12:53:00.000000Z	METAR	2020-01-01	63.00	50.00	62.49	340.00	6.00	—	30.080	1018.40	CLR	—	—	—	—	—	—	—
KMIA	2020-01-01T13:53:00.000000Z	METAR	2020-01-01	66.00	50.00	56.27	340.00	5.00	—	30.090	1019.00	SCT	9000.00	—	—	—	—	—	—
KMIA	2020-01-01T14:53:00.000000Z	METAR	2020-01-01	70.00	49.00	47.06	350.00	5.00	—	30.100	1019.40	FEW	9000.00	—	—	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

34 columns

Verified column analytics for reports_kmia
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	KMIA100% Top: KMIA	—
event_time_utc	timestamp_utc	—	0.0%0 values	67,417100.0%	2022-09-09 17:35:00+000% 2023-04-24 16:50:00+000% 2026-05-29 02:35:00+000% Other (67,405) Top: 2022-09-09 17:35:00+00 · 67,405 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	METAR87% SPECI13% Top: METAR	—
local_standard_date	date	—	0.0%0 values	2,4433.6%	2022-11-200% 2021-06-290% 2020-05-250% Other (2,431) Top: 2022-11-20 · 66,752 more values	—
temp_f	decimal	—	<0.1%27 values	880.1%	80.006% 82.006% 79.006% Other (76) Top: 80.00 · 25,379 more values	Median 79.00P25 74.00 · P75 83.00
dewpoint_f	decimal	—	<0.1%29 values	900.1%	75.009% 74.008% 76.008% Other (78) Top: 75.00 · 19,882 more values	Median 71.00P25 65.00 · P75 75.00
relative_humidity_pct	decimal	—	<0.1%29 values	2,5593.8%	79.471% 100.001% 82.031% Other (2,547) Top: 79.47 · 62,509 more values	Median 74.33P25 64.31 · P75 84.34
wind_direction_degrees	decimal	—	5.2%3,488 values	38<0.1%	0.0013% 110.007% 100.007% Other (26) Top: 0.00 · 23,084 more values	Median 110.00P25 60.00 · P75 180.00
wind_speed_kt	decimal	—	0.1%78 values	30<0.1%	0.0012% 4.0010% 3.0010% Other (18) Top: 0.00 · 4,106 more values	Median 7.00P25 4.00 · P75 10.00
wind_gust_kt	decimal	—	81.6%55,028 values	310.3%	18.0012% 19.0012% 17.0011% Other (19) Top: 18.00 · 965 more values	Median 19.00P25 17.00 · P75 22.00
altimeter_inhg	decimal	—	<0.1%17 values	930.1%	30.0404% 30.0504% 30.0304% Other (81) Top: 30.040 · 36,147 more values	Median 30.030P25 29.960 · P75 30.090
sea_level_pressure_hpa	decimal	—	13.2%8,876 values	3010.5%	1017.401% 1016.401% 1017.001% Other (289) Top: 1017.40 · 49,813 more values	Median 1017.00P25 1014.70 · P75 1019.20
sky_cover_1	string	—	<0.1%16 values	6<0.1%	FEW49% SCT31% BKN14% Top: FEW	—
sky_base_1_ft	decimal	—	5.2%3,498 values	960.2%	2500.0012% 3000.009% 2000.006% Other (84) Top: 2500.00 · 26,529 more values	Median 2800.00P25 2200.00 · P75 3500.00
sky_cover_2	string	—	25.6%17,251 values	4<0.1%	BKN46% SCT32% FEW17% Top: BKN	—
sky_base_2_ft	decimal	—	25.6%17,251 values	890.2%	25000.0024% 5000.005% 6000.005% Other (77) Top: 25000.00 · 20,520 more values	Median 6500.00P25 4000.00 · P75 22000.00
sky_cover_3	string	—	57.5%38,770 values	4<0.1%	BKN60% OVC22% SCT16% Top: BKN	—
sky_base_3_ft	decimal	—	57.5%38,770 values	720.3%	25000.0040% 11000.005% 10000.004% Other (60) Top: 25000.00 · 7,308 more values	Median 16000.00P25 8000.00 · P75 25000.00
sky_cover_4	string	—	88.3%59,499 values	4<0.1%	BKN62% OVC35% SCT3% Top: BKN	—
sky_base_4_ft	decimal	—	88.3%59,499 values	210.3%	25000.0073% 20000.007% 13000.004% Other (9) Top: 25000.00 · 166 more values	Median 25000.00P25 24000.00 · P75 25000.00

Show 14 more columns

Verified column analytics for reports_kmia
visibility_miles	decimal	—	<0.1%15 values	20<0.1%	10.0092% 7.002% 6.001% Other (8) Top: 10.00 · 441 more values	Median 10.00P25 10.00 · P75 10.00
weather_codes	string	—	87.5%58,960 values	420.5%	-RA26% TS17% -TSRA8% Other (30) Top: -RA · 889 more values	—
precipitation_in_1h	decimal	—	6.0%4,022 values	1820.3%	0.00091% 0.0102% 0.0201% Other (170) Top: 0.000 · 2,227 more values	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt	decimal	—	96.5%65,045 values	220.9%	26.0027% 27.0021% 28.0015% Other (10) Top: 26.00 · 48 more values	Median 28.00P25 26.00 · P75 30.00
peak_wind_direction_degrees	decimal	—	96.5%65,045 values	361.5%	90.0011% 80.009% 100.007% Other (24) Top: 90.00 · 696 more values	Median 110.00P25 80.00 · P75 170.00
peak_wind_time	string	—	96.5%65,045 values	1,84377.6%	2024-08-29 15:590% 2022-06-01 21:540% 2025-09-10 17:000% Other (1,831) Top: 2024-08-29 15:59 · 2,295 more values	—
snow_depth_inches	decimal	—	100.0%67,420 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	67,420100.0%	KMIA 010008Z 15009KT 10SM FEW032 SCT250 31/23 A2997 RMK AO2 CB DSNT NW T031102330% KMIA 010017Z 00000KT 7SM -TSRA SCT029CB BKN049 BKN090 OVC130 26/24 A2996 RMK AO2 RAB07 TSB17 PRESFR OCNL LTGIC OHD-NW-NE TS OHD-NW-NE MOV E P0005 T026102390% KMIA 010019Z 29014G25KT 10SM FEW023 SCT049 BKN070 13/09 A2997 RMK AO2 T01330089 $0% Other (67,408) Top: KMIA 010008Z 15009KT 10SM FEW032 SCT250 31/23 A2997 RMK AO2 CB DSNT NW T03110233 · 67,408 more values	—
cli_product	string	—	0.1%91 values	1<0.1%	CLIMIA100% Top: CLIMIA	—
cli_high_f	integer	—	0.4%303 values	43<0.1%	50100 All-row histogram	Median 86P25 82 · P75 91
cli_low_f	integer	—	0.4%276 values	46<0.1%	3584 All-row histogram	Median 74P25 69 · P75 77
cli_report_type	string	—	0.1%91 values	3<0.1%	final99% correction0% preliminary0% Top: final	—
metar_high_f	decimal	—	0.0%0 values	56<0.1%	90.007% 89.007% 85.006% Other (44) Top: 90.00 · 20,414 more values	Median 86.00P25 81.00 · P75 90.00
metar_low_f	decimal	—	0.0%0 values	58<0.1%	75.008% 78.007% 77.007% Other (46) Top: 75.00 · 21,619 more values	Median 74.00P25 69.00 · P75 78.00

Release status

Facts from the current passing release

Release: Passing
Rows: 67,420
Columns: 34
Published: 9 Sept 2026, 06:29
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_kmia

reports_kmia

# Current release — the complete Parquet file
curl -sS -o reports-kmia.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/b18ecf22-2169-4ebe-9862-155b5abb412d/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/b18ecf22-2169-4ebe-9862-155b5abb412d/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/b18ecf22-2169-4ebe-9862-155b5abb412d/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

Miami weather reports and daily highs since 2020

reports_kmia

Release status