reports_kmsp

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:29

Rows: 71,576; across released Tables
Tables: 1; released
Columns: 34; reports_kmsp
Version: —; reports_kmsp

Data preview

reports_kmsp

Preview rows for reports_kmsp
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
KMSP	2020-01-01T06:53:00.000000Z	METAR	2020-01-01	15.10	10.00	79.84	190.00	6.00	—	29.680	1006.60	FEW	25000.00	—	—	—	—	—	—
KMSP	2020-01-01T07:53:00.000000Z	METAR	2020-01-01	16.00	10.00	76.77	190.00	5.00	—	29.650	1005.40	BKN	25000.00	—	—	—	—	—	—
KMSP	2020-01-01T08:53:00.000000Z	METAR	2020-01-01	14.00	9.00	80.10	120.00	6.00	—	29.630	1004.70	BKN	22000.00	—	—	—	—	—	—
KMSP	2020-01-01T09:53:00.000000Z	METAR	2020-01-01	14.00	10.00	83.77	150.00	5.00	—	29.590	1003.40	SCT	22000.00	—	—	—	—	—	—
KMSP	2020-01-01T10:53:00.000000Z	METAR	2020-01-01	15.10	10.00	79.84	130.00	5.00	—	29.550	1002.10	BKN	17000.00	—	—	—	—	—	—
KMSP	2020-01-01T11:53:00.000000Z	METAR	2020-01-01	17.10	12.90	83.25	150.00	7.00	—	29.510	1000.90	OVC	17000.00	—	—	—	—	—	—
KMSP	2020-01-01T12:53:00.000000Z	METAR	2020-01-01	18.00	12.90	80.09	160.00	6.00	—	29.490	1000.00	SCT	16000.00	BKN	23000.00	—	—	—	—
KMSP	2020-01-01T13:53:00.000000Z	METAR	2020-01-01	18.00	14.00	84.05	150.00	7.00	—	29.460	999.10	SCT	12000.00	—	—	—	—	—	—
KMSP	2020-01-01T14:53:00.000000Z	METAR	2020-01-01	18.00	14.00	84.05	160.00	5.00	—	29.460	998.90	SCT	23000.00	—	—	—	—	—	—
KMSP	2020-01-01T15:53:00.000000Z	METAR	2020-01-01	23.00	17.10	77.77	170.00	4.00	—	29.440	998.20	BKN	15000.00	OVC	23000.00	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

34 columns

Verified column analytics for reports_kmsp
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	KMSP100% Top: KMSP	—
event_time_utc	timestamp_utc	—	0.0%0 values	71,573100.0%	2023-01-04 17:50:00+000% 2024-06-04 23:55:00+000% 2025-08-19 13:15:00+000% Other (71,561) Top: 2023-01-04 17:50:00+00 · 71,561 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	METAR82% SPECI18% Top: METAR	—
local_standard_date	date	—	0.0%0 values	2,4433.4%	2023-01-040% 2026-02-180% 2022-12-150% Other (2,431) Top: 2023-01-04 · 70,738 more values	—
temp_f	decimal	—	<0.1%3 values	1860.3%	32.003% 33.002% 34.002% Other (174) Top: 32.00 · 55,488 more values	Median 48.00P25 30.90 · P75 68.00
dewpoint_f	decimal	—	<0.1%3 values	1800.3%	27.002% 28.002% 30.002% Other (168) Top: 27.00 · 55,309 more values	Median 35.00P25 21.90 · P75 55.00
relative_humidity_pct	decimal	—	<0.1%3 values	4,9877.0%	100.001% 91.510% 88.170% Other (4,975) Top: 100.00 · 69,390 more values	Median 68.90P25 54.09 · P75 82.07
wind_direction_degrees	decimal	—	2.3%1,642 values	37<0.1%	0.006% 140.005% 310.004% Other (25) Top: 0.00 · 36,563 more values	Median 190.00P25 120.00 · P75 290.00
wind_speed_kt	decimal	—	<0.1%52 values	36<0.1%	6.0010% 7.009% 5.009% Other (24) Top: 6.00 · 9,352 more values	Median 8.00P25 5.00 · P75 11.00
wind_gust_kt	decimal	—	78.8%56,373 values	430.3%	20.008% 19.007% 21.007% Other (31) Top: 20.00 · 3,917 more values	Median 23.00P25 20.00 · P75 28.00
altimeter_inhg	decimal	—	0.0%0 values	1920.3%	30.0002% 30.0102% 29.9502% Other (180) Top: 30.000 · 55,562 more values	Median 29.970P25 29.830 · P75 30.110
sea_level_pressure_hpa	decimal	—	18.3%13,075 values	6161.1%	1013.601% 1016.101% 1016.001% Other (604) Top: 1013.60 · 54,466 more values	Median 1015.70P25 1010.80 · P75 1020.70
sky_cover_1	string	—	<0.1%1 values	6<0.1%	FEW31% OVC19% BKN18% Top: FEW	—
sky_base_1_ft	decimal	—	14.8%10,577 values	890.1%	25000.0011% 6000.003% 5000.003% Other (77) Top: 25000.00 · 37,644 more values	Median 4300.00P25 1700.00 · P75 11000.00
sky_cover_2	string	—	59.6%42,682 values	4<0.1%	BKN41% OVC28% SCT20% Top: BKN	—
sky_base_2_ft	decimal	—	59.6%42,682 values	770.3%	25000.0019% 20000.005% 10000.003% Other (65) Top: 25000.00 · 14,386 more values	Median 8000.00P25 3500.00 · P75 20000.00
sky_cover_3	string	—	84.6%60,530 values	4<0.1%	OVC50% BKN38% SCT10% Top: OVC	—
sky_base_3_ft	decimal	—	84.6%60,530 values	660.6%	25000.0023% 11000.006% 10000.005% Other (54) Top: 25000.00 · 4,128 more values	Median 10000.00P25 5500.00 · P75 20000.00
sky_cover_4	string	—	97.5%69,757 values	40.2%	BKN58% OVC35% SCT7% Top: BKN	—
sky_base_4_ft	decimal	—	97.5%69,757 values	150.8%	25000.0048% 20000.0018% 15000.0010% Other (3) Top: 25000.00 · 12 more values	Median 22000.00P25 17000.00 · P75 25000.00

Show 14 more columns

Verified column analytics for reports_kmsp
visibility_miles	decimal	—	<0.1%3 values	19<0.1%	10.0072% 9.005% 8.004% Other (7) Top: 10.00 · 1,757 more values	Median 10.00P25 9.00 · P75 10.00
weather_codes	string	—	78.6%56,294 values	1330.9%	-SN18% BR16% -SN BR15% Other (121) Top: -SN · 2,631 more values	—
precipitation_in_1h	decimal	—	11.2%7,995 values	980.2%	0.00089% 0.0104% 0.0202% Other (86) Top: 0.000 · 931 more values	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt	decimal	—	87.2%62,389 values	310.3%	26.0014% 27.0014% 28.0011% Other (19) Top: 26.00 · 782 more values	Median 30.00P25 27.00 · P75 33.00
peak_wind_direction_degrees	decimal	—	87.2%62,389 values	360.4%	270.0010% 300.007% 310.007% Other (24) Top: 270.00 · 3,238 more values	Median 260.00P25 150.00 · P75 300.00
peak_wind_time	string	—	87.2%62,389 values	7,50181.6%	2023-07-04 15:230% 2024-06-03 09:030% 2021-12-16 14:070% Other (7,489) Top: 2023-07-04 15:23 · 9,105 more values	—
snow_depth_inches	decimal	—	97.5%69,767 values	160.9%	1.0013% 4.0012% 3.0011% Other (4) Top: 1.00 · 38 more values	Median 5.00P25 3.00 · P75 7.00
raw_metar	string	—	0.0%0 values	71,576100.0%	KMSP 010000Z 29007KT 3/4SM R30L/1800VP6000FT -RA BKN048CB BKN100 BKN200 21/17 A2990 RMK AO2 VIS SW-NE 10 CB E MOV E P0006 T020601670% KMSP 010002Z COR 29008KT 10SM R30L/5000VP6000FT BKN048CB BKN100 BKN200 21/17 A2990 RMK AO2 RAE02 CB DSNT E P0006 T021101720% KMSP 010003Z 34011KT 290V020 8SM -TSRA FEW038 SCT060CB BKN100 OVC140 23/19 A2990 RMK AO2 LTG DSNT ALQDS RAB01 TSB2359 TS OHD MOV E P0000 T02280194 $0% Other (71,564) Top: KMSP 010000Z 29007KT 3/4SM R30L/1800VP6000FT -RA BKN048CB BKN100 BKN200 21/17 A2990 RMK AO2 VIS SW-NE 10 CB E MOV E P0006 T02060167 · 71,564 more values	—
cli_product	string	—	<0.1%29 values	1<0.1%	CLIMSP100% Top: CLIMSP	—
cli_high_f	integer	—	<0.1%29 values	1080.2%	-9101 All-row histogram	Median 57P25 36 · P75 78
cli_low_f	integer	—	<0.1%29 values	1030.1%	-2182 All-row histogram	Median 39P25 24 · P75 60
cli_report_type	string	—	<0.1%29 values	2<0.1%	final98% correction2% Top: final	—
metar_high_f	decimal	—	0.0%0 values	1340.2%	81.003% 36.002% 77.002% Other (122) Top: 81.00 · 54,604 more values	Median 56.00P25 36.00 · P75 78.00
metar_low_f	decimal	—	0.0%0 values	1340.2%	32.003% 63.003% 65.002% Other (122) Top: 32.00 · 53,401 more values	Median 40.00P25 25.00 · P75 60.00

Release status

Facts from the current passing release

Release: Passing
Rows: 71,576
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_kmsp

reports_kmsp

# Current release — the complete Parquet file
curl -sS -o reports-kmsp.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/232ece0b-1dcb-4584-a841-7e4dedc3a808/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/232ece0b-1dcb-4584-a841-7e4dedc3a808/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/232ece0b-1dcb-4584-a841-7e4dedc3a808/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

Minneapolis weather reports and daily highs since 2020

reports_kmsp

Release status