reports_mpto

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 07:20

Rows: 60,770; across released Tables
Tables: 1; released
Columns: 37; reports_mpto
Version: —; reports_mpto

Data preview

reports_mpto

Preview rows for reports_mpto
station	event_time_utc	observation_type	local_standard_date	temp_f	temp_c	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
MPTO	2020-01-01T05:00:00.000000Z	METAR	2020-01-01	75.20	24.0	71.60	88.59	270.00	3.00	—	29.880	—	FEW	1800.00	—	—	—	—	—
MPTO	2020-01-01T06:00:00.000000Z	METAR	2020-01-01	77.00	25.0	73.40	88.67	290.00	5.00	—	29.850	—	FEW	1800.00	—	—	—	—	—
MPTO	2020-01-01T07:00:00.000000Z	METAR	2020-01-01	75.20	24.0	71.60	88.59	250.00	3.00	—	29.850	—	FEW	1800.00	—	—	—	—	—
MPTO	2020-01-01T08:00:00.000000Z	METAR	2020-01-01	73.40	23.0	71.60	94.10	—	2.00	—	29.830	—	FEW	1800.00	—	—	—	—	—
MPTO	2020-01-01T09:00:00.000000Z	METAR	2020-01-01	73.40	23.0	71.60	94.10	350.00	3.00	—	29.830	—	FEW	1800.00	—	—	—	—	—
MPTO	2020-01-01T10:00:00.000000Z	METAR	2020-01-01	73.40	23.0	71.60	94.10	—	2.00	—	29.830	—	FEW	1800.00	—	—	—	—	—
MPTO	2020-01-01T11:00:00.000000Z	METAR	2020-01-01	75.20	24.0	71.60	88.59	300.00	4.00	—	29.830	—	SCT	1800.00	—	—	—	—	—
MPTO	2020-01-01T12:00:00.000000Z	METAR	2020-01-01	77.00	25.0	73.40	88.67	300.00	5.00	—	29.830	—	SCT	1800.00	SCT	9000.00	—	—	—
MPTO	2020-01-01T13:00:00.000000Z	METAR	2020-01-01	78.80	26.0	73.40	83.55	300.00	8.00	—	29.850	—	SCT	1800.00	SCT	9000.00	—	—	—
MPTO	2020-01-01T14:00:00.000000Z	METAR	2020-01-01	78.80	26.0	73.40	83.55	290.00	7.00	—	29.850	—	SCT	2000.00	SCT	8000.00	—	—	—

Columns

Schema, units, meaning, and verified release profile

37 columns

Verified column analytics for reports_mpto
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	MPTO100% Top: MPTO	—
event_time_utc	timestamp_utc	—	0.0%0 values	60,770100.0%	2020-01-01 05:00:00+000% 2020-01-01 06:00:00+000% 2020-01-01 07:00:00+000% Other (60,758) Top: 2020-01-01 05:00:00+00 · 60,758 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	METAR95% SPECI5% Top: METAR	—
local_standard_date	date	—	0.0%0 values	2,4384.0%	2020-05-060% 2020-05-010% 2020-05-310% Other (2,426) Top: 2020-05-06 · 60,183 more values	—
temp_f	decimal	—	<0.1%16 values	22<0.1%	77.0017% 78.8014% 75.2011% Other (10) Top: 77.00 · 1,402 more values	Median 78.80P25 77.00 · P75 84.20
temp_c	decimal	—	<0.1%16 values	22<0.1%	25.017% 26.014% 24.011% Other (10) Top: 25.0 · 1,402 more values	Median 26.0P25 25.0 · P75 29.0
dewpoint_f	decimal	—	<0.1%22 values	20<0.1%	75.2028% 77.0019% 73.4019% Other (8) Top: 75.20 · 31 more values	Median 75.20P25 71.60 · P75 77.00
relative_humidity_pct	decimal	—	<0.1%22 values	2900.5%	100.008% 94.197% 94.145% Other (278) Top: 100.00 · 35,136 more values	Median 83.82P25 74.28 · P75 94.14
wind_direction_degrees	decimal	—	20.0%12,126 values	43<0.1%	0.0010% 280.006% 270.005% Other (31) Top: 0.00 · 22,628 more values	Median 180.00P25 50.00 · P75 280.00
wind_speed_kt	decimal	—	<0.1%41 values	27<0.1%	3.0017% 2.0016% 4.0012% Other (15) Top: 3.00 · 2,987 more values	Median 4.00P25 2.00 · P75 7.00
wind_gust_kt	decimal	—	99.4%60,390 values	246.3%	22.0012% 20.0010% 25.0010% Other (12) Top: 22.00 · 54 more values	Median 22.00P25 19.00 · P75 25.00
altimeter_inhg	decimal	—	<0.1%15 values	26<0.1%	29.83022% 29.85020% 29.80018% Other (14) Top: 29.830 · 47 more values	Median 29.830P25 29.800 · P75 29.850
sea_level_pressure_hpa	decimal	—	100.0%60,770 values	00.0%	No distribution published No distribution published	—
sky_cover_1	string	—	4.4%2,648 values	7<0.1%	SCT61% FEW38% BKN1% Top: SCT	—
sky_base_1_ft	decimal	—	4.9%2,982 values	54<0.1%	1800.0051% 2000.0014% 1600.0013% Other (42) Top: 1800.00 · 768 more values	Median 1800.00P25 1600.00 · P75 1800.00
sky_cover_2	string	—	54.2%32,958 values	4<0.1%	SCT79% BKN20% OVC0% Top: SCT	—
sky_base_2_ft	decimal	—	54.2%32,958 values	490.2%	9000.0048% 8000.0020% 1600.0016% Other (37) Top: 9000.00 · 409 more values	Median 8000.00P25 1700.00 · P75 9000.00
sky_cover_3	string	—	90.7%55,113 values	3<0.1%	BKN75% SCT20% OVC5% Top: BKN	—
sky_base_3_ft	decimal	—	90.7%55,114 values	410.7%	8000.0048% 9000.0034% 7000.009% Other (29) Top: 8000.00 · 110 more values	Median 8000.00P25 8000.00 · P75 9000.00
sky_cover_4	string	—	100.0%60,770 values	00.0%	No distribution published No distribution published	—

Show 17 more columns

Verified column analytics for reports_mpto
sky_base_4_ft	decimal	—	100.0%60,770 values	00.0%	No distribution published No distribution published	—
visibility_miles	decimal	—	<0.1%32 values	630.1%	6.2176% 5.5917% 4.974% Other (51) Top: 6.21 · 307 more values	Median 6.21P25 6.21 · P75 6.21
weather_codes	string	—	85.2%51,768 values	340.4%	VCSH34% -RA30% -TSRA11% Other (22) Top: VCSH · 84 more values	—
precipitation_in_1h	decimal	—	0.0%0 values	1<0.1%	0.000100% Top: 0.000	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt	decimal	—	100.0%60,770 values	00.0%	No distribution published No distribution published	—
peak_wind_direction_degrees	decimal	—	100.0%60,770 values	00.0%	No distribution published No distribution published	—
peak_wind_time	string	—	100.0%60,770 values	00.0%	No distribution published No distribution published	—
snow_depth_inches	decimal	—	100.0%60,770 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	60,59099.7%	MPTO 010900Z 00000KT 9999 FEW018 24/24 Q1008 NOSIG0% MPTO 040700Z VRB02KT 9999 FEW018 24/22 Q1011 NOSIG0% MPTO 070900Z VRB02KT 9999 FEW018 25/24 Q1009 NOSIG0% Other (60,578) Top: MPTO 010900Z 00000KT 9999 FEW018 24/24 Q1008 NOSIG · 60,741 more values	—
cli_product	string	—	100.0%60,770 values	00.0%	No distribution published No distribution published	—
cli_high_f	integer	—	100.0%60,770 values	00.0%	No distribution published All-row histogram	—
cli_low_f	integer	—	100.0%60,770 values	00.0%	No distribution published All-row histogram	—
cli_report_type	string	—	100.0%60,770 values	00.0%	No distribution published No distribution published	—
metar_high_f	decimal	—	0.0%0 values	15<0.1%	89.6018% 87.8017% 86.0017% Other (3) Top: 89.60 · 92 more values	Median 87.80P25 86.00 · P75 91.40
metar_low_f	decimal	—	0.0%0 values	11<0.1%	75.2033% 73.4023% 77.0018% Top: 75.20	Median 75.20P25 73.40 · P75 75.20
metar_high_c	decimal	—	0.0%0 values	15<0.1%	32.018% 31.017% 30.017% Other (3) Top: 32.0 · 92 more values	Median 31.0P25 30.0 · P75 33.0
metar_low_c	decimal	—	0.0%0 values	11<0.1%	24.033% 23.023% 25.018% Top: 24.0	Median 24.0P25 23.0 · P75 24.0

Release status

Facts from the current passing release

Release: Passing
Rows: 60,770
Columns: 37
Published: 9 Sept 2026, 07:20
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_mpto

reports_mpto

# Current release — the complete Parquet file
curl -sS -o reports-mpto.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/39b7e419-1bae-44fa-a053-8eb7a47c12d0/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/39b7e419-1bae-44fa-a053-8eb7a47c12d0/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/39b7e419-1bae-44fa-a053-8eb7a47c12d0/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

Panama City weather reports and daily highs since 2020

reports_mpto

Release status