reports_egll

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:32

Rows: 117,227; across released Tables
Tables: 1; released
Columns: 37; reports_egll
Version: —; reports_egll

Data preview

reports_egll

Preview rows for reports_egll
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
EGLL	2020-01-01T00:20:00.000000Z	SPECI	2020-01-01	39.20	4.0	37.40	93.19	—	2.00	—	30.450	—	NCD	—	—	—	—	—	—
EGLL	2020-01-01T00:50:00.000000Z	METAR	2020-01-01	37.40	3.0	35.60	93.14	100.00	3.00	—	30.420	—	NCD	—	—	—	—	—	—
EGLL	2020-01-01T01:20:00.000000Z	SPECI	2020-01-01	39.20	4.0	37.40	93.19	140.00	4.00	—	30.420	—	BKN	1000.00	—	—	—	—	—
EGLL	2020-01-01T01:50:00.000000Z	METAR	2020-01-01	39.20	4.0	37.40	93.19	—	3.00	—	30.420	—	OVC	900.00	—	—	—	—	—
EGLL	2020-01-01T02:20:00.000000Z	SPECI	2020-01-01	39.20	4.0	39.20	100.00	70.00	4.00	—	30.420	—	BKN	1100.00	OVC	1600.00	—	—	—
EGLL	2020-01-01T02:50:00.000000Z	METAR	2020-01-01	41.00	5.0	39.20	93.24	110.00	5.00	—	30.420	—	OVC	1100.00	—	—	—	—	—
EGLL	2020-01-01T03:20:00.000000Z	SPECI	2020-01-01	39.20	4.0	39.20	100.00	120.00	6.00	—	30.420	—	BKN	800.00	OVC	1400.00	—	—	—
EGLL	2020-01-01T03:50:00.000000Z	METAR	2020-01-01	39.20	4.0	39.20	100.00	70.00	4.00	—	30.420	—	BKN	700.00	OVC	1400.00	—	—	—
EGLL	2020-01-01T04:20:00.000000Z	SPECI	2020-01-01	39.20	4.0	39.20	100.00	90.00	7.00	—	30.420	—	BKN	900.00	OVC	1300.00	—	—	—
EGLL	2020-01-01T04:50:00.000000Z	METAR	2020-01-01	39.20	4.0	39.20	100.00	100.00	7.00	—	30.420	—	OVC	1400.00	—	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

37 columns

Verified column analytics for reports_egll
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	EGLL100% Top: EGLL	—
event_time_utc	timestamp_utc	—	0.0%0 values	117,227100.0%	2020-01-01 00:20:00+000% 2020-01-01 00:50:00+000% 2020-01-01 01:20:00+000% Other (117,215) Top: 2020-01-01 00:20:00+00 · 117,215 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	METAR50% SPECI50% Top: METAR	—
local_standard_date	date	—	0.0%0 values	2,4442.1%	2025-01-280% 2020-01-010% 2020-01-020% Other (2,432) Top: 2025-01-28 · 116,650 more values	—
temp_f	decimal	—	<0.1%2 values	47<0.1%	50.007% 51.806% 53.606% Other (35) Top: 50.00 · 40,577 more values	Median 53.60P25 46.40 · P75 62.60
temp_c	decimal	—	<0.1%2 values	47<0.1%	10.07% 11.06% 12.06% Other (35) Top: 10.0 · 40,577 more values	Median 12.0P25 8.0 · P75 17.0
dewpoint_f	decimal	—	<0.1%2 values	35<0.1%	44.608% 46.408% 48.207% Other (23) Top: 44.60 · 29,529 more values	Median 46.40P25 39.20 · P75 51.80
relative_humidity_pct	decimal	—	<0.1%2 values	1,0730.9%	100.003% 87.371% 87.281% Other (1,061) Top: 100.00 · 98,749 more values	Median 76.98P25 63.62 · P75 87.37
wind_direction_degrees	decimal	—	5.8%6,791 values	37<0.1%	220.006% 210.006% 270.006% Other (25) Top: 220.00 · 49,371 more values	Median 210.00P25 110.00 · P75 260.00
wind_speed_kt	decimal	—	<0.1%6 values	39<0.1%	5.0010% 6.0010% 7.0010% Other (27) Top: 5.00 · 14,909 more values	Median 7.00P25 5.00 · P75 10.00
wind_gust_kt	decimal	—	97.8%114,594 values	381.4%	26.007% 30.006% 27.006% Other (26) Top: 26.00 · 799 more values	Median 27.00P25 23.00 · P75 31.00
altimeter_inhg	decimal	—	<0.1%6 values	101<0.1%	30.0004% 30.0604% 30.0304% Other (89) Top: 30.000 · 64,210 more values	Median 30.000P25 29.800 · P75 30.210
sea_level_pressure_hpa	decimal	—	100.0%117,227 values	00.0%	No distribution published No distribution published	—
sky_cover_1	string	—	0.2%258 values	8<0.1%	NCD46% BKN19% OVC12% Top: NCD	—
sky_base_1_ft	decimal	—	47.1%55,168 values	61<0.1%	1000.003% 700.003% 1500.003% Other (49) Top: 1000.00 · 39,468 more values	Median 2100.00P25 1200.00 · P75 3300.00
sky_cover_2	string	—	76.2%89,296 values	5<0.1%	BKN45% OVC34% SCT14% Top: BKN	—
sky_base_2_ft	decimal	—	77.9%91,268 values	530.2%	3000.004% 2000.003% 2700.003% Other (41) Top: 3000.00 · 16,678 more values	Median 2800.00P25 1900.00 · P75 3800.00
sky_cover_3	string	—	91.8%107,606 values	5<0.1%	BKN43% OVC31% ///27% Top: BKN	—
sky_base_3_ft	decimal	—	94.0%110,163 values	440.6%	3200.004% 3100.004% 3900.004% Other (32) Top: 3200.00 · 3,999 more values	Median 3500.00P25 2700.00 · P75 4200.00
sky_cover_4	string	—	98.6%115,590 values	20.1%	///100% BKN0% Top: ///	—

Show 17 more columns

Verified column analytics for reports_egll
sky_base_4_ft	decimal	—	100.0%117,226 values	1100.0%	4800.00100% Top: 4800.00	Median 4800.00P25 4800.00 · P75 4800.00
visibility_miles	decimal	—	<0.1%1 values	62<0.1%	6.2192% 4.971% 5.591% Other (50) Top: 6.21 · 1,711 more values	Median 6.21P25 6.21 · P75 6.21
weather_codes	string	—	88.2%103,346 values	660.5%	-RA70% BR6% HZ3% Other (54) Top: -RA · 669 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%117,227 values	00.0%	No distribution published No distribution published	—
peak_wind_direction_degrees	decimal	—	100.0%117,227 values	00.0%	No distribution published No distribution published	—
peak_wind_time	string	—	100.0%117,227 values	00.0%	No distribution published No distribution published	—
snow_depth_inches	decimal	—	100.0%117,227 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	117,227100.0%	COR EGLL 010020Z 17004KT 9999 -RA SCT003 BKN006 11/11 Q0999 RERA REDZ TEMPO RA0% COR EGLL 010020Z AUTO 01004KT 340V050 9999 NCD M01/M02 Q1006 NOSIG0% COR EGLL 010020Z AUTO 04004KT 9999 NCD 04/02 Q1034 BECMG BKN0040% Other (117,215) Top: COR EGLL 010020Z 17004KT 9999 -RA SCT003 BKN006 11/11 Q0999 RERA REDZ TEMPO RA · 117,215 more values	—
cli_product	string	—	100.0%117,227 values	00.0%	No distribution published No distribution published	—
cli_high_f	integer	—	100.0%117,227 values	00.0%	No distribution published All-row histogram	—
cli_low_f	integer	—	100.0%117,227 values	00.0%	No distribution published All-row histogram	—
cli_report_type	string	—	100.0%117,227 values	00.0%	No distribution published No distribution published	—
metar_high_f	decimal	—	0.0%0 values	40<0.1%	55.407% 53.606% 51.805% Other (28) Top: 55.40 · 44,577 more values	Median 60.80P25 51.80 · P75 69.80
metar_low_f	decimal	—	0.0%0 values	31<0.1%	42.807% 46.407% 44.607% Other (19) Top: 42.80 · 32,298 more values	Median 48.20P25 41.00 · P75 55.40
metar_high_c	decimal	—	0.0%0 values	40<0.1%	13.07% 12.06% 11.05% Other (28) Top: 13.0 · 44,577 more values	Median 16.0P25 11.0 · P75 21.0
metar_low_c	decimal	—	0.0%0 values	31<0.1%	6.07% 8.07% 7.07% Other (19) Top: 6.0 · 32,298 more values	Median 9.0P25 5.0 · P75 13.0

Release status

Facts from the current passing release

Release: Passing
Rows: 117,227
Columns: 37
Published: 9 Sept 2026, 06:32
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_egll

reports_egll

# Current release — the complete Parquet file
curl -sS -o reports-egll.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/8a511163-8a2a-444f-86e6-0bdfb54ccfa2/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/8a511163-8a2a-444f-86e6-0bdfb54ccfa2/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/8a511163-8a2a-444f-86e6-0bdfb54ccfa2/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

London weather reports and daily highs since 2020

reports_egll

Release status