reports_ltfm

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:34

Rows: 117,184; across released Tables
Tables: 1; released
Columns: 37; reports_ltfm
Version: —; reports_ltfm

Data preview

reports_ltfm

Preview rows for reports_ltfm
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
LTFM	2020-01-01T00:20:00.000000Z	SPECI	2020-01-01	37.40	3.0	32.00	80.65	210.00	8.00	—	30.150	—	FEW	3000.00	BKN	10000.00	—	—	—
LTFM	2020-01-01T00:50:00.000000Z	METAR	2020-01-01	37.40	3.0	30.20	74.98	250.00	8.00	—	30.180	—	FEW	3000.00	BKN	10000.00	—	—	—
LTFM	2020-01-01T01:20:00.000000Z	SPECI	2020-01-01	39.20	4.0	26.60	60.29	280.00	7.00	—	30.150	—	FEW	3000.00	BKN	10000.00	—	—	—
LTFM	2020-01-01T01:50:00.000000Z	METAR	2020-01-01	37.40	3.0	28.40	69.67	280.00	5.00	—	30.150	—	FEW	3000.00	BKN	10000.00	—	—	—
LTFM	2020-01-01T02:20:00.000000Z	SPECI	2020-01-01	39.20	4.0	28.40	64.93	290.00	6.00	—	30.180	—	SCT	3000.00	BKN	9000.00	—	—	—
LTFM	2020-01-01T02:50:00.000000Z	METAR	2020-01-01	39.20	4.0	26.60	60.29	310.00	8.00	—	30.150	—	SCT	2700.00	BKN	9000.00	—	—	—
LTFM	2020-01-01T03:20:00.000000Z	SPECI	2020-01-01	41.00	5.0	30.20	65.16	310.00	6.00	—	30.150	—	SCT	2600.00	BKN	9000.00	—	—	—
LTFM	2020-01-01T03:50:00.000000Z	METAR	2020-01-01	41.00	5.0	33.80	75.33	310.00	5.00	—	30.150	—	BKN	2500.00	BKN	8000.00	—	—	—
LTFM	2020-01-01T04:20:00.000000Z	SPECI	2020-01-01	42.80	6.0	35.60	75.50	320.00	6.00	—	30.150	—	BKN	2500.00	BKN	8000.00	—	—	—
LTFM	2020-01-01T04:50:00.000000Z	METAR	2020-01-01	41.00	5.0	35.60	80.93	320.00	3.00	—	30.180	—	FEW	1500.00	BKN	2500.00	—	—	—

Columns

Schema, units, meaning, and verified release profile

37 columns

Verified column analytics for reports_ltfm
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	LTFM100% Top: LTFM	—
event_time_utc	timestamp_utc	—	0.0%0 values	117,184100.0%	2020-01-01 00:20:00+000% 2020-01-01 00:50:00+000% 2020-01-01 01:20:00+000% Other (117,172) Top: 2020-01-01 00:20:00+00 · 117,172 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%	2020-01-020% 2020-01-030% 2020-01-040% Other (2,432) Top: 2020-01-02 · 116,608 more values	—
temp_f	decimal	—	<0.1%2 values	49<0.1%	77.005% 75.205% 73.405% Other (37) Top: 77.00 · 54,460 more values	Median 59.00P25 48.20 · P75 73.40
temp_c	decimal	—	<0.1%2 values	49<0.1%	25.05% 24.05% 23.05% Other (37) Top: 25.0 · 54,460 more values	Median 15.0P25 9.0 · P75 23.0
dewpoint_f	decimal	—	<0.1%2 values	39<0.1%	44.606% 46.406% 48.206% Other (27) Top: 44.60 · 48,244 more values	Median 50.00P25 42.80 · P75 60.80
relative_humidity_pct	decimal	—	<0.1%2 values	1,1491.0%	100.002% 93.401% 93.451% Other (1,137) Top: 100.00 · 103,846 more values	Median 73.78P25 62.70 · P75 83.32
wind_direction_degrees	decimal	—	2.7%3,165 values	37<0.1%	50.009% 40.008% 60.008% Other (25) Top: 50.00 · 31,364 more values	Median 80.00P25 40.00 · P75 220.00
wind_speed_kt	decimal	—	<0.1%2 values	45<0.1%	8.008% 10.007% 6.007% Other (33) Top: 8.00 · 32,154 more values	Median 11.00P25 7.00 · P75 15.00
wind_gust_kt	decimal	—	98.7%115,664 values	453.0%	18.006% 20.006% 19.006% Other (33) Top: 18.00 · 679 more values	Median 25.00P25 19.00 · P75 34.00
altimeter_inhg	decimal	—	0.0%0 values	64<0.1%	29.9707% 30.0307% 30.0007% Other (52) Top: 29.970 · 38,520 more values	Median 30.000P25 29.880 · P75 30.120
sea_level_pressure_hpa	decimal	—	100.0%117,184 values	00.0%	No distribution published No distribution published	—
sky_cover_1	string	—	31.4%36,814 values	6<0.1%	SCT44% FEW27% BKN27% Top: SCT	—
sky_base_1_ft	decimal	—	32.3%37,902 values	47<0.1%	3500.0010% 2500.0010% 3000.006% Other (35) Top: 3500.00 · 27,517 more values	Median 2000.00P25 1100.00 · P75 3000.00
sky_cover_2	string	—	62.9%73,723 values	4<0.1%	BKN84% SCT14% FEW2% Top: BKN	—
sky_base_2_ft	decimal	—	62.9%73,723 values	530.1%	2200.0017% 2500.0015% 10000.0014% Other (41) Top: 2200.00 · 4,404 more values	Median 2500.00P25 2200.00 · P75 9000.00
sky_cover_3	string	—	95.8%112,208 values	3<0.1%	BKN98% OVC2% SCT0% Top: BKN	—
sky_base_3_ft	decimal	—	95.8%112,208 values	210.4%	8000.0030% 9000.0019% 10000.0012% Other (9) Top: 8000.00 · 115 more values	Median 8000.00P25 7000.00 · P75 9000.00
sky_cover_4	string	—	100.0%117,168 values	16.3%	BKN100% Top: BKN	—

Show 17 more columns

Verified column analytics for reports_ltfm
sky_base_4_ft	decimal	—	100.0%117,168 values	318.8%	8000.0050% 9000.0038% 7000.0013% Top: 8000.00	Median 8000.00P25 8000.00 · P75 9000.00
visibility_miles	decimal	—	0.0%0 values	60<0.1%	6.2190% 4.972% 3.732% Other (48) Top: 6.21 · 2,042 more values	Median 6.21P25 6.21 · P75 6.21
weather_codes	string	—	85.8%100,590 values	800.5%	-SHRA44% -RA13% BR9% Other (68) Top: -SHRA · 1,659 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,184 values	00.0%	No distribution published No distribution published	—
peak_wind_direction_degrees	decimal	—	100.0%117,184 values	00.0%	No distribution published No distribution published	—
peak_wind_time	string	—	100.0%117,184 values	00.0%	No distribution published No distribution published	—
snow_depth_inches	decimal	—	100.0%117,184 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	117,184100.0%	COR LTFM 010050Z 34019KT 9999 -SHRA BKN025 12/08 Q1018 NOSIG0% COR LTFM 010220Z 09008KT 060V120 9999 SCT030 24/17 Q1014 NOSIG RMK RWY17L 07010KT RWY34L 06009KT RWY16R 06010KT RWY36 10005KT 030V150 RWY18 08009KT0% COR LTFM 010220Z 35008KT 310V010 9999 -SHRA FEW017TCU BKN032 BKN090 10/08 Q1015 NOSIG RMK RWY17L 01006KT RWY34L 34006KT RWY16R 02004KT RWY36 01007KT RWY18 36008KT0% Other (117,172) Top: COR LTFM 010050Z 34019KT 9999 -SHRA BKN025 12/08 Q1018 NOSIG · 117,172 more values	—
cli_product	string	—	100.0%117,184 values	00.0%	No distribution published No distribution published	—
cli_high_f	integer	—	100.0%117,184 values	00.0%	No distribution published All-row histogram	—
cli_low_f	integer	—	100.0%117,184 values	00.0%	No distribution published All-row histogram	—
cli_report_type	string	—	100.0%117,184 values	00.0%	No distribution published No distribution published	—
metar_high_f	decimal	—	0.0%0 values	40<0.1%	80.606% 78.806% 82.406% Other (28) Top: 80.60 · 51,027 more values	Median 64.40P25 53.60 · P75 78.80
metar_low_f	decimal	—	0.0%0 values	35<0.1%	73.405% 46.405% 71.605% Other (23) Top: 73.40 · 51,624 more values	Median 53.60P25 44.60 · P75 66.20
metar_high_c	decimal	—	0.0%0 values	40<0.1%	27.06% 26.06% 28.06% Other (28) Top: 27.0 · 51,027 more values	Median 18.0P25 12.0 · P75 26.0
metar_low_c	decimal	—	0.0%0 values	35<0.1%	23.05% 8.05% 22.05% Other (23) Top: 23.0 · 51,624 more values	Median 12.0P25 7.0 · P75 19.0

Release status

Facts from the current passing release

Release: Passing
Rows: 117,184
Columns: 37
Published: 9 Sept 2026, 06:34
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_ltfm

reports_ltfm

# Current release — the complete Parquet file
curl -sS -o reports-ltfm.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/e9b108be-8ce9-40f5-ae53-b2d65adbbe4a/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/e9b108be-8ce9-40f5-ae53-b2d65adbbe4a/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/e9b108be-8ce9-40f5-ae53-b2d65adbbe4a/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

Istanbul weather reports and daily highs since 2020

reports_ltfm

Release status