reports_lemd

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:39

Rows: 118,771; across released Tables
Tables: 1; released
Columns: 37; reports_lemd
Version: —; reports_lemd

Data preview

reports_lemd

Preview rows for reports_lemd
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
LEMD	2020-01-01T00:00:00.000000Z	METAR	2020-01-01	33.80	1.0	32.00	93.03	350.00	2.00	—	30.470	—	NSC	—	—	—	—	—	—
LEMD	2020-01-01T00:30:00.000000Z	SPECI	2020-01-01	33.80	1.0	32.00	93.03	360.00	3.00	—	30.470	—	NSC	—	—	—	—	—	—
LEMD	2020-01-01T01:00:00.000000Z	METAR	2020-01-01	33.80	1.0	32.00	93.03	360.00	3.00	—	30.470	—	NSC	—	—	—	—	—	—
LEMD	2020-01-01T01:30:00.000000Z	SPECI	2020-01-01	32.00	0.0	30.20	92.97	10.00	1.00	—	30.450	—	NSC	—	—	—	—	—	—
LEMD	2020-01-01T02:00:00.000000Z	METAR	2020-01-01	32.00	0.0	30.20	92.97	360.00	3.00	—	30.470	—	NSC	—	—	—	—	—	—
LEMD	2020-01-01T02:30:00.000000Z	SPECI	2020-01-01	30.20	-1.0	30.20	100.00	350.00	3.00	—	30.470	—	NSC	—	—	—	—	—	—
LEMD	2020-01-01T03:00:00.000000Z	METAR	2020-01-01	30.20	-1.0	30.20	100.00	340.00	2.00	—	30.470	—	NSC	—	—	—	—	—	—
LEMD	2020-01-01T03:30:00.000000Z	SPECI	2020-01-01	30.20	-1.0	28.40	92.92	10.00	2.00	—	30.470	—	NSC	—	—	—	—	—	—
LEMD	2020-01-01T04:00:00.000000Z	METAR	2020-01-01	30.20	-1.0	28.40	92.92	360.00	3.00	—	30.450	—	NSC	—	—	—	—	—	—
LEMD	2020-01-01T04:30:00.000000Z	SPECI	2020-01-01	28.40	-2.0	28.40	100.00	360.00	2.00	—	30.450	—	NSC	—	—	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

37 columns

Verified column analytics for reports_lemd
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	LEMD100% Top: LEMD	—
event_time_utc	timestamp_utc	—	0.0%0 values	118,771100.0%	2020-01-01 00:00:00+000% 2020-01-01 00:30:00+000% 2020-01-01 01:00:00+000% Other (118,759) Top: 2020-01-01 00:00:00+00 · 118,759 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	SPECI51% METAR49% Top: SPECI	—
local_standard_date	date	—	0.0%0 values	2,4442.1%	2025-05-020% 2024-01-150% 2023-11-020% Other (2,432) Top: 2025-05-02 · 118,043 more values	—
temp_f	decimal	—	0.0%0 values	57<0.1%	51.805% 50.004% 53.604% Other (45) Top: 51.80 · 62,457 more values	Median 59.00P25 48.20 · P75 73.40
temp_c	decimal	—	0.0%0 values	57<0.1%	11.05% 10.04% 12.04% Other (45) Top: 11.0 · 62,457 more values	Median 15.0P25 9.0 · P75 23.0
dewpoint_f	decimal	—	0.0%0 values	40<0.1%	46.408% 44.608% 42.808% Other (28) Top: 46.40 · 26,003 more values	Median 44.60P25 37.40 · P75 50.00
relative_humidity_pct	decimal	—	0.0%0 values	1,5551.3%	100.005% 93.451% 93.501% Other (1,543) Top: 100.00 · 104,683 more values	Median 59.50P25 37.92 · P75 81.61
wind_direction_degrees	decimal	—	13.9%16,510 values	37<0.1%	360.008% 0.007% 350.007% Other (25) Top: 360.00 · 44,980 more values	Median 210.00P25 120.00 · P75 310.00
wind_speed_kt	decimal	—	<0.1%4 values	35<0.1%	3.0016% 2.0016% 4.0011% Other (23) Top: 3.00 · 9,503 more values	Median 4.00P25 2.00 · P75 7.00
wind_gust_kt	decimal	—	95.6%113,557 values	360.7%	20.009% 21.008% 18.008% Other (24) Top: 20.00 · 1,153 more values	Median 22.00P25 19.00 · P75 26.00
altimeter_inhg	decimal	—	0.0%0 values	54<0.1%	30.0308% 30.0008% 30.0607% Other (42) Top: 30.030 · 35,082 more values	Median 30.060P25 29.940 · P75 30.180
sea_level_pressure_hpa	decimal	—	100.0%118,771 values	00.0%	No distribution published No distribution published	—
sky_cover_1	string	—	58.4%69,322 values	6<0.1%	FEW52% SCT28% BKN12% Top: FEW	—
sky_base_1_ft	decimal	—	60.0%71,250 values	900.2%	5000.009% 6000.008% 7000.006% Other (78) Top: 5000.00 · 19,622 more values	Median 4000.00P25 2000.00 · P75 6000.00
sky_cover_2	string	—	81.5%96,799 values	4<0.1%	BKN53% SCT38% OVC7% Top: BKN	—
sky_base_2_ft	decimal	—	81.5%96,799 values	850.4%	6000.0010% 5000.0010% 7000.009% Other (73) Top: 6000.00 · 7,487 more values	Median 5000.00P25 2800.00 · P75 6000.00
sky_cover_3	string	—	95.5%113,399 values	4<0.1%	BKN83% OVC14% SCT2% Top: BKN	—
sky_base_3_ft	decimal	—	95.5%113,399 values	781.5%	7000.0011% 6000.0011% 5000.0010% Other (66) Top: 7000.00 · 1,417 more values	Median 5000.00P25 3500.00 · P75 6800.00
sky_cover_4	string	—	100.0%118,751 values	210.0%	BKN95% OVC5% Top: BKN	—

Show 17 more columns

Verified column analytics for reports_lemd
sky_base_4_ft	decimal	—	100.0%118,751 values	1050.0%	7000.0030% 5500.0015% 4500.0010% Top: 7000.00	Median 5500.00P25 4500.00 · P75 7000.00
visibility_miles	decimal	—	<0.1%1 values	60<0.1%	6.2192% 5.592% 4.971% Other (48) Top: 6.21 · 1,009 more values	Median 6.21P25 6.21 · P75 6.21
weather_codes	string	—	92.1%109,362 values	1281.4%	-RA23% BR15% -DZ9% Other (116) Top: -RA · 1,747 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%118,771 values	00.0%	No distribution published No distribution published	—
peak_wind_direction_degrees	decimal	—	100.0%118,771 values	00.0%	No distribution published No distribution published	—
peak_wind_time	string	—	100.0%118,771 values	00.0%	No distribution published No distribution published	—
snow_depth_inches	decimal	—	100.0%118,771 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	118,758100.0%	LEMD 060630Z VRB02KT CAVOK 24/11 Q1020 NOSIG0% LEMD 060700Z VRB01KT CAVOK 25/12 Q1020 NOSIG0% LEMD 060700Z VRB02KT CAVOK 18/10 Q1019 NOSIG0% Other (118,746) Top: LEMD 060630Z VRB02KT CAVOK 24/11 Q1020 NOSIG · 118,747 more values	—
cli_product	string	—	100.0%118,771 values	00.0%	No distribution published No distribution published	—
cli_high_f	integer	—	100.0%118,771 values	00.0%	No distribution published All-row histogram	—
cli_low_f	integer	—	100.0%118,771 values	00.0%	No distribution published All-row histogram	—
cli_report_type	string	—	100.0%118,771 values	00.0%	No distribution published No distribution published	—
metar_high_f	decimal	—	0.0%0 values	43<0.1%	53.605% 62.604% 55.404% Other (31) Top: 53.60 · 63,045 more values	Median 69.80P25 59.00 · P75 87.80
metar_low_f	decimal	—	0.0%0 values	39<0.1%	46.406% 48.205% 50.005% Other (27) Top: 46.40 · 55,062 more values	Median 48.20P25 39.20 · P75 60.80
metar_high_c	decimal	—	0.0%0 values	43<0.1%	12.05% 17.04% 13.04% Other (31) Top: 12.0 · 63,045 more values	Median 21.0P25 15.0 · P75 31.0
metar_low_c	decimal	—	0.0%0 values	39<0.1%	8.06% 9.05% 10.05% Other (27) Top: 8.0 · 55,062 more values	Median 9.0P25 4.0 · P75 16.0

Release status

Facts from the current passing release

Release: Passing
Rows: 118,771
Columns: 37
Published: 9 Sept 2026, 06:39
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_lemd

reports_lemd

# Current release — the complete Parquet file
curl -sS -o reports-lemd.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/25bd9041-6e21-43dd-9d68-f480b433c0a4/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/25bd9041-6e21-43dd-9d68-f480b433c0a4/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/25bd9041-6e21-43dd-9d68-f480b433c0a4/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

Madrid weather reports and daily highs since 2020

reports_lemd

Release status