reports_mmmx

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:37

Rows: 76,037; across released Tables
Tables: 1; released
Columns: 37; reports_mmmx
Version: —; reports_mmmx

Data preview

reports_mmmx

Preview rows for reports_mmmx
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
MMMX	2020-01-01T06:45:00.000000Z	METAR	2020-01-01	59.00	15.0	44.60	58.77	0.00	0.00	—	30.310	—	FEW	22000.00	—	—	—	—	—
MMMX	2020-01-01T07:45:00.000000Z	METAR	2020-01-01	57.20	14.0	44.60	62.69	0.00	0.00	—	30.300	—	FEW	22000.00	—	—	—	—	—
MMMX	2020-01-01T08:45:00.000000Z	METAR	2020-01-01	57.20	14.0	44.60	62.69	0.00	0.00	—	30.290	1008.20	CLR	—	—	—	—	—	—
MMMX	2020-01-01T09:45:00.000000Z	METAR	2020-01-01	57.20	14.0	46.40	67.12	130.00	3.00	—	30.270	—	CLR	—	—	—	—	—	—
MMMX	2020-01-01T10:45:00.000000Z	METAR	2020-01-01	55.40	13.0	42.80	62.46	320.00	3.00	—	30.270	—	CLR	—	—	—	—	—	—
MMMX	2020-01-01T11:50:00.000000Z	SPECI	2020-01-01	55.40	13.0	42.80	62.46	0.00	0.00	—	30.270	1007.60	CLR	—	—	—	—	—	—
MMMX	2020-01-01T12:50:00.000000Z	SPECI	2020-01-01	55.40	13.0	42.80	62.46	0.00	0.00	—	30.280	—	CLR	—	—	—	—	—	—
MMMX	2020-01-01T13:35:00.000000Z	SPECI	2020-01-01	57.20	14.0	42.80	58.52	180.00	5.00	—	30.280	—	CLR	—	—	—	—	—	—
MMMX	2020-01-01T13:45:00.000000Z	METAR	2020-01-01	57.20	14.0	42.80	58.52	150.00	6.00	—	30.280	—	CLR	—	—	—	—	—	—
MMMX	2020-01-01T14:45:00.000000Z	METAR	2020-01-01	60.80	16.0	41.00	48.00	180.00	3.00	—	30.310	1010.30	CLR	—	—	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

37 columns

Verified column analytics for reports_mmmx
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	MMMX100% Top: MMMX	—
event_time_utc	timestamp_utc	—	0.0%0 values	76,037100.0%	2020-01-01 06:45:00+000% 2020-01-01 07:45:00+000% 2020-01-01 08:45:00+000% Other (76,025) Top: 2020-01-01 06:45:00+00 · 76,025 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	METAR58% SPECI42% Top: METAR	—
local_standard_date	date	—	0.0%0 values	2,4433.2%	2024-09-130% 2023-07-100% 2023-08-310% Other (2,431) Top: 2024-09-13 · 75,452 more values	—
temp_f	decimal	—	<0.1%5 values	35<0.1%	60.8010% 62.608% 59.008% Other (23) Top: 60.80 · 16,083 more values	Median 64.40P25 59.00 · P75 71.60
temp_c	decimal	—	<0.1%5 values	35<0.1%	16.010% 17.08% 15.08% Other (23) Top: 16.0 · 16,083 more values	Median 18.0P25 15.0 · P75 22.0
dewpoint_f	decimal	—	<0.1%6 values	47<0.1%	51.809% 50.008% 53.608% Other (35) Top: 51.80 · 16,497 more values	Median 44.60P25 37.40 · P75 51.80
relative_humidity_pct	decimal	—	<0.1%6 values	1,2101.6%	87.921% 82.371% 77.141% Other (1,198) Top: 87.92 · 69,410 more values	Median 50.36P25 33.60 · P75 67.76
wind_direction_degrees	decimal	—	0.2%137 values	37<0.1%	0.0011% 60.007% 70.006% Other (25) Top: 0.00 · 33,036 more values	Median 100.00P25 50.00 · P75 250.00
wind_speed_kt	decimal	—	<0.1%6 values	42<0.1%	4.0016% 5.0013% 6.0011% Other (30) Top: 4.00 · 5,173 more values	Median 5.00P25 4.00 · P75 8.00
wind_gust_kt	decimal	—	97.6%74,178 values	301.6%	20.0034% 22.0020% 25.0011% Other (18) Top: 20.00 · 144 more values	Median 22.00P25 20.00 · P75 25.00
altimeter_inhg	decimal	—	<0.1%4 values	69<0.1%	30.3206% 30.3005% 30.3405% Other (57) Top: 30.320 · 33,699 more values	Median 30.310P25 30.250 · P75 30.360
sea_level_pressure_hpa	decimal	—	74.7%56,807 values	2921.5%	1011.201% 1009.401% 1010.301% Other (280) Top: 1011.20 · 16,625 more values	Median 1010.00P25 1007.20 · P75 1012.80
sky_cover_1	string	—	<0.1%8 values	6<0.1%	SCT29% CLR25% BKN24% Top: SCT	—
sky_base_1_ft	decimal	—	25.5%19,372 values	38<0.1%	2000.0056% 2500.008% 22000.008% Other (26) Top: 2000.00 · 959 more values	Median 2000.00P25 2000.00 · P75 3000.00
sky_cover_2	string	—	49.2%37,417 values	4<0.1%	BKN53% OVC24% SCT22% Top: BKN	—
sky_base_2_ft	decimal	—	49.2%37,418 values	30<0.1%	8000.0062% 22000.0013% 10000.006% Other (18) Top: 8000.00 · 200 more values	Median 8000.00P25 8000.00 · P75 10000.00
sky_cover_3	string	—	81.9%62,291 values	3<0.1%	BKN55% OVC42% SCT3% Top: BKN	—
sky_base_3_ft	decimal	—	81.9%62,291 values	160.1%	22000.0065% 20000.0026% 25000.003% Other (4) Top: 22000.00 · 4 more values	Median 22000.00P25 20000.00 · P75 22000.00
sky_cover_4	string	—	99.9%75,949 values	22.3%	OVC58% BKN42% Top: OVC	—

Show 17 more columns

Verified column analytics for reports_mmmx
sky_base_4_ft	decimal	—	99.9%75,949 values	55.7%	22000.0060% 20000.0036% 2200.001% Top: 22000.00	Median 22000.00P25 20000.00 · P75 22000.00
visibility_miles	decimal	—	<0.1%3 values	26<0.1%	10.0021% 8.0020% 7.0017% Other (14) Top: 10.00 · 492 more values	Median 8.00P25 6.00 · P75 10.00
weather_codes	string	—	85.8%65,265 values	830.8%	-RA27% -TSRA17% VCRA11% Other (71) Top: -RA · 723 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%76,037 values	00.0%	No distribution published No distribution published	—
peak_wind_direction_degrees	decimal	—	100.0%76,037 values	00.0%	No distribution published No distribution published	—
peak_wind_time	string	—	100.0%76,037 values	00.0%	No distribution published No distribution published	—
snow_depth_inches	decimal	—	100.0%76,037 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	76,037100.0%	COR MMMX 010048Z 19012G22KT 6SM -TSRA BKN015CB OVC070 22/07 A3022 RMK 8/96/ HZY OCNL LTGICCG OVR STN0% COR MMMX 010216Z 24015KT 4SM +TSRA BKN015CB OVC070 14/13 A3043 NOSIG RMK 8/96/ HZY FRQ LTGICCG ARND RAB150% COR MMMX 010248Z 02002KT 7SM BKN020CB BKN080 OVC220 16/14 A3034 TEMPO 3SM TSRA RMK SLP122 52025 903 60045 8/363 OCNL DROPS LWR SC HZY0% Other (76,025) Top: COR MMMX 010048Z 19012G22KT 6SM -TSRA BKN015CB OVC070 22/07 A3022 RMK 8/96/ HZY OCNL LTGICCG OVR STN · 76,025 more values	—
cli_product	string	—	100.0%76,037 values	00.0%	No distribution published No distribution published	—
cli_high_f	integer	—	100.0%76,037 values	00.0%	No distribution published All-row histogram	—
cli_low_f	integer	—	100.0%76,037 values	00.0%	No distribution published All-row histogram	—
cli_report_type	string	—	100.0%76,037 values	00.0%	No distribution published No distribution published	—
metar_high_f	decimal	—	0.0%0 values	22<0.1%	75.2015% 77.0014% 78.8013% Other (10) Top: 75.20 · 3,266 more values	Median 77.00P25 73.40 · P75 80.60
metar_low_f	decimal	—	0.0%0 values	21<0.1%	57.2018% 59.0014% 55.4012% Other (9) Top: 57.20 · 3,209 more values	Median 55.40P25 50.00 · P75 57.20
metar_high_c	decimal	—	0.0%0 values	22<0.1%	24.015% 25.014% 26.013% Other (10) Top: 24.0 · 3,266 more values	Median 25.0P25 23.0 · P75 27.0
metar_low_c	decimal	—	0.0%0 values	21<0.1%	14.018% 15.014% 13.012% Other (9) Top: 14.0 · 3,209 more values	Median 13.0P25 10.0 · P75 14.0

Release status

Facts from the current passing release

Release: Passing
Rows: 76,037
Columns: 37
Published: 9 Sept 2026, 06:37
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_mmmx

reports_mmmx

# Current release — the complete Parquet file
curl -sS -o reports-mmmx.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/286ac45c-e6b9-4177-898d-65970994e813/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/286ac45c-e6b9-4177-898d-65970994e813/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/286ac45c-e6b9-4177-898d-65970994e813/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

Mexico City weather reports and daily highs since 2020

reports_mmmx

Release status