reports_kmsy

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:29

Rows: 71,606; across released Tables
Tables: 1; released
Columns: 34; reports_kmsy
Version: —; reports_kmsy

Data preview

reports_kmsy

Preview rows for reports_kmsy
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
KMSY	2020-01-01T06:53:00.000000Z	METAR	2020-01-01	52.00	37.00	56.45	350.00	4.00	—	30.140	1020.80	SCT	300.00	BKN	18000.00	—	—	—	—
KMSY	2020-01-01T07:53:00.000000Z	METAR	2020-01-01	52.00	39.00	61.06	0.00	0.00	—	30.130	1020.60	FEW	800.00	BKN	6500.00	—	—	—	—
KMSY	2020-01-01T08:53:00.000000Z	METAR	2020-01-01	55.00	38.00	52.40	20.00	4.00	—	30.130	1020.40	OVC	7000.00	—	—	—	—	—	—
KMSY	2020-01-01T09:53:00.000000Z	METAR	2020-01-01	55.00	38.00	52.40	50.00	3.00	—	30.110	1019.90	OVC	6500.00	—	—	—	—	—	—
KMSY	2020-01-01T10:53:00.000000Z	METAR	2020-01-01	51.00	41.00	68.23	0.00	0.00	—	30.130	1020.60	SCT	6000.00	BKN	24000.00	—	—	—	—
KMSY	2020-01-01T11:53:00.000000Z	METAR	2020-01-01	51.00	40.00	65.38	20.00	3.00	—	30.140	1020.80	SCT	6000.00	BKN	22000.00	—	—	—	—
KMSY	2020-01-01T12:53:00.000000Z	METAR	2020-01-01	53.00	38.00	56.17	90.00	4.00	—	30.120	1020.20	SCT	6500.00	BKN	22000.00	—	—	—	—
KMSY	2020-01-01T13:53:00.000000Z	METAR	2020-01-01	53.00	39.00	58.64	70.00	3.00	—	30.120	1020.30	SCT	6500.00	BKN	22000.00	—	—	—	—
KMSY	2020-01-01T14:53:00.000000Z	METAR	2020-01-01	56.00	36.00	47.05	70.00	6.00	—	30.150	1021.30	BKN	6500.00	BKN	22000.00	—	—	—	—
KMSY	2020-01-01T15:53:00.000000Z	METAR	2020-01-01	58.00	33.00	39.00	60.00	6.00	—	30.150	1021.30	BKN	7000.00	BKN	22000.00	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

34 columns

Verified column analytics for reports_kmsy
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	KMSY100% Top: KMSY	—
event_time_utc	timestamp_utc	—	0.0%0 values	71,606100.0%	2020-01-01 06:53:00+000% 2020-01-01 07:53:00+000% 2020-01-01 08:53:00+000% Other (71,594) Top: 2020-01-01 06:53:00+00 · 71,594 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%	2022-02-030% 2024-01-240% 2024-09-110% Other (2,431) Top: 2022-02-03 · 70,719 more values	—
temp_f	decimal	—	<0.1%8 values	1570.2%	79.004% 80.004% 78.004% Other (145) Top: 79.00 · 42,043 more values	Median 74.00P25 64.00 · P75 81.00
dewpoint_f	decimal	—	0.2%108 values	1780.2%	75.006% 76.005% 74.005% Other (166) Top: 75.00 · 35,137 more values	Median 68.00P25 56.00 · P75 74.00
relative_humidity_pct	decimal	—	0.2%108 values	3,7815.3%	100.004% 82.031% 87.581% Other (3,769) Top: 100.00 · 65,206 more values	Median 79.17P25 64.12 · P75 89.81
wind_direction_degrees	decimal	—	2.4%1,692 values	37<0.1%	0.0012% 150.004% 180.004% Other (25) Top: 0.00 · 35,339 more values	Median 140.00P25 60.00 · P75 230.00
wind_speed_kt	decimal	—	<0.1%66 values	43<0.1%	0.0011% 5.0011% 6.0010% Other (31) Top: 0.00 · 5,196 more values	Median 6.00P25 4.00 · P75 9.00
wind_gust_kt	decimal	—	85.4%61,121 values	560.5%	20.0011% 19.0011% 21.0010% Other (44) Top: 20.00 · 1,592 more values	Median 21.00P25 19.00 · P75 24.00
altimeter_inhg	decimal	—	0.0%0 values	1560.2%	30.0003% 30.0103% 30.0203% Other (144) Top: 30.000 · 44,887 more values	Median 30.020P25 29.940 · P75 30.110
sea_level_pressure_hpa	decimal	—	18.2%13,068 values	4110.7%	1016.001% 1016.401% 1015.601% Other (399) Top: 1016.00 · 51,551 more values	Median 1017.00P25 1014.40 · P75 1020.30
sky_cover_1	string	—	<0.1%2 values	6<0.1%	FEW46% SCT18% BKN15% Top: FEW	—
sky_base_1_ft	decimal	—	10.9%7,801 values	850.1%	25000.0010% 2000.007% 3000.007% Other (73) Top: 25000.00 · 30,513 more values	Median 2500.00P25 1500.00 · P75 4500.00
sky_cover_2	string	—	40.5%28,991 values	4<0.1%	BKN44% SCT26% FEW20% Top: BKN	—
sky_base_2_ft	decimal	—	40.5%28,991 values	800.2%	25000.0025% 15000.005% 6000.003% Other (68) Top: 25000.00 · 18,956 more values	Median 8500.00P25 3600.00 · P75 25000.00
sky_cover_3	string	—	68.4%48,978 values	4<0.1%	BKN53% OVC29% SCT13% Top: BKN	—
sky_base_3_ft	decimal	—	68.4%48,978 values	720.3%	25000.0036% 15000.006% 11000.005% Other (60) Top: 25000.00 · 6,645 more values	Median 15000.00P25 7500.00 · P75 25000.00
sky_cover_4	string	—	92.5%66,252 values	4<0.1%	BKN69% OVC27% SCT4% Top: BKN	—
sky_base_4_ft	decimal	—	92.5%66,252 values	190.4%	25000.0068% 15000.008% 20000.006% Other (7) Top: 25000.00 · 80 more values	Median 25000.00P25 20000.00 · P75 25000.00

Show 14 more columns

Verified column analytics for reports_kmsy
visibility_miles	decimal	—	<0.1%8 values	19<0.1%	10.0079% 9.003% 8.003% Other (7) Top: 10.00 · 1,649 more values	Median 10.00P25 10.00 · P75 10.00
weather_codes	string	—	81.5%58,337 values	690.5%	BR25% -RA17% TS8% Other (57) Top: BR · 1,687 more values	—
precipitation_in_1h	decimal	—	6.2%4,454 values	1670.2%	0.00091% 0.0102% 0.0201% Other (155) Top: 0.000 · 2,226 more values	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt	decimal	—	95.2%68,157 values	421.2%	26.0018% 27.0016% 28.0011% Other (30) Top: 26.00 · 295 more values	Median 29.00P25 27.00 · P75 32.00
peak_wind_direction_degrees	decimal	—	95.2%68,157 values	361.0%	150.006% 140.005% 320.005% Other (24) Top: 150.00 · 1,703 more values	Median 180.00P25 120.00 · P75 300.00
peak_wind_time	string	—	95.2%68,157 values	2,40769.8%	2024-01-09 07:080% 2024-09-04 16:010% 2024-09-11 18:580% Other (2,395) Top: 2024-01-09 07:08 · 3,361 more values	—
snow_depth_inches	decimal	—	100.0%71,596 values	660.0%	2.0040% 4.0020% 3.0010% Top: 2.00	Median 3.00P25 2.00 · P75 5.00
raw_metar	string	—	0.0%0 values	71,606100.0%	KMSY 010002Z 20009KT 10SM TS SCT042CB BKN250 32/26 A3004 RMK AO2 TSE00B02 OCNL LTGIC VC SW-W TS VC SW-W STNRY T032202610% KMSY 010007Z 02008KT 10SM -RA BKN008 BKN018 OVC110 22/21 A2986 RMK AO2 P0001 T02220206 $0% KMSY 010007Z 13012KT 10SM BKN010 BKN033 OVC055 22/20 A2976 RMK AO2 RAE04 P0000 T02170200 $0% Other (71,594) Top: KMSY 010002Z 20009KT 10SM TS SCT042CB BKN250 32/26 A3004 RMK AO2 TSE00B02 OCNL LTGIC VC SW-W TS VC SW-W STNRY T03220261 · 71,594 more values	—
cli_product	string	—	42.0%30,044 values	1<0.1%	CLIMSY100% Top: CLIMSY	—
cli_high_f	integer	—	42.0%30,073 values	640.2%	34105 All-row histogram	Median 82P25 73 · P75 90
cli_low_f	integer	—	42.0%30,044 values	610.1%	2183 All-row histogram	Median 67P25 56 · P75 75
cli_report_type	string	—	42.0%30,044 values	3<0.1%	final99% preliminary0% correction0% Top: final	—
metar_high_f	decimal	—	0.0%0 values	800.1%	83.004% 88.004% 90.004% Other (68) Top: 83.00 · 40,754 more values	Median 82.00P25 73.00 · P75 89.00
metar_low_f	decimal	—	0.0%0 values	840.1%	77.006% 76.005% 78.005% Other (72) Top: 77.00 · 39,268 more values	Median 68.00P25 57.00 · P75 76.00

Release status

Facts from the current passing release

Release: Passing
Rows: 71,606
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_kmsy

reports_kmsy

# Current release — the complete Parquet file
curl -sS -o reports-kmsy.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/3a6d3cde-9c27-453f-ba34-0e8dfe42249f/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/3a6d3cde-9c27-453f-ba34-0e8dfe42249f/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/3a6d3cde-9c27-453f-ba34-0e8dfe42249f/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

New Orleans weather reports and daily highs since 2020

reports_kmsy

Release status