Frankfurt weather reports and daily highs since 2020

Public

reports_eddf

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:33
Rows
117,227
across released Tables
Tables
1
released
Columns
37
reports_eddf
Version
reports_eddf

Data preview

reports_eddf
Preview rows for reports_eddf
stationevent_time_utcobservation_typelocal_standard_datetemp_ftemp_cdewpoint_frelative_humidity_pctwind_direction_degreeswind_speed_ktwind_gust_ktaltimeter_inhgsea_level_pressure_hpasky_cover_1sky_base_1_ftsky_cover_2sky_base_2_ftsky_cover_3sky_base_3_ftsky_cover_4
EDDF2020-01-01T00:20:00.000000ZSPECI2020-01-0132.000.030.2092.9710.007.0030.560FEW100.00SCT2000.00
EDDF2020-01-01T00:50:00.000000ZMETAR2020-01-0132.000.030.2092.9760.003.0030.560FEW100.00SCT2000.00
EDDF2020-01-01T01:20:00.000000ZSPECI2020-01-0132.000.028.4086.3950.005.0030.560FEW100.00SCT2000.00
EDDF2020-01-01T01:50:00.000000ZMETAR2020-01-0130.20-1.028.4092.9250.005.0030.560FEW100.00SCT1800.00
EDDF2020-01-01T02:20:00.000000ZSPECI2020-01-0132.000.028.4086.3970.004.0030.560SCT1600.00
EDDF2020-01-01T02:50:00.000000ZMETAR2020-01-0132.000.030.2092.9790.004.0030.530BKN1400.00
EDDF2020-01-01T03:20:00.000000ZSPECI2020-01-0132.000.030.2092.9740.005.0030.530BKN1500.00
EDDF2020-01-01T03:50:00.000000ZMETAR2020-01-0132.000.030.2092.9740.003.0030.530BKN1500.00
EDDF2020-01-01T04:20:00.000000ZSPECI2020-01-0130.20-1.028.4092.9230.004.0030.530SCT1500.00
EDDF2020-01-01T04:50:00.000000ZMETAR2020-01-0128.40-2.026.6092.8660.005.0030.530FEW1500.00
A bounded preview of the immutable release.

Columns

Schema, units, meaning, and verified release profile

37 columns
Verified column analytics for reports_eddf
ColumnTypeUnitMissingDistinctDistributionSummary
stationstring0.0%0 values1<0.1%
  • EDDF100%

Top: EDDF

event_time_utctimestamp_utc0.0%0 values117,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_typestring0.0%0 values2<0.1%
  • SPECI50%
  • METAR50%

Top: SPECI

local_standard_datedate0.0%0 values2,4432.1%
  • 2020-01-020%
  • 2020-01-030%
  • 2020-01-040%
  • Other (2,431)

Top: 2020-01-02 · 116,651 more values

temp_fdecimal<0.1%4 values53<0.1%
  • 50.005%
  • 44.604%
  • 48.204%
  • Other (41)

Top: 50.00 · 58,056 more values

Median 53.60P25 42.80 · P75 64.40
temp_cdecimal<0.1%4 values53<0.1%
  • 10.05%
  • 7.04%
  • 9.04%
  • Other (41)

Top: 10.0 · 58,056 more values

Median 12.0P25 6.0 · P75 18.0
dewpoint_fdecimal<0.1%4 values42<0.1%
  • 44.606%
  • 42.806%
  • 46.406%
  • Other (30)

Top: 44.60 · 42,230 more values

Median 44.60P25 35.60 · P75 51.80
relative_humidity_pctdecimal<0.1%4 values1,3591.2%
  • 100.006%
  • 93.351%
  • 93.451%
  • Other (1,347)

Top: 100.00 · 99,551 more values

Median 75.50P25 57.26 · P75 87.47
wind_direction_degreesdecimal12.4%14,514 values37<0.1%
  • 200.008%
  • 190.007%
  • 210.007%
  • Other (25)

Top: 200.00 · 37,608 more values

Median 190.00P25 60.00 · P75 230.00
wind_speed_ktdecimal<0.1%1 values36<0.1%
  • 5.0011%
  • 6.0010%
  • 4.0010%
  • Other (24)

Top: 5.00 · 11,322 more values

Median 6.00P25 4.00 · P75 9.00
wind_gust_ktdecimal98.5%115,455 values382.1%
  • 28.007%
  • 21.006%
  • 25.006%
  • Other (26)

Top: 28.00 · 634 more values

Median 25.00P25 21.00 · P75 30.00
altimeter_inhgdecimal<0.1%4 values73<0.1%
  • 30.0305%
  • 30.0605%
  • 30.0005%
  • Other (61)

Top: 30.030 · 52,330 more values

Median 30.030P25 29.850 · P75 30.180
sea_level_pressure_hpadecimal100.0%117,227 values00.0%

No distribution published

No distribution published

sky_cover_1string47.4%55,589 values7<0.1%
  • FEW55%
  • BKN17%
  • SCT14%

Top: FEW

sky_base_1_ftdecimal49.6%58,152 values600.1%
  • 2000.004%
  • 1800.003%
  • 400.003%
  • Other (48)

Top: 2000.00 · 38,637 more values

Median 2100.00P25 1100.00 · P75 3300.00
sky_cover_2string76.1%89,189 values4<0.1%
  • BKN53%
  • SCT25%
  • OVC13%

Top: BKN

sky_base_2_ftdecimal77.7%91,130 values540.2%
  • 3000.003%
  • 4000.003%
  • 4500.003%
  • Other (42)

Top: 3000.00 · 16,575 more values

Median 2900.00P25 1900.00 · P75 3900.00
sky_cover_3string91.8%107,653 values4<0.1%
  • BKN57%
  • OVC24%
  • FEW14%

Top: BKN

sky_base_3_ftdecimal93.1%109,091 values500.6%
  • 4500.006%
  • 4000.005%
  • 4800.005%
  • Other (38)

Top: 4500.00 · 4,135 more values

Median 3600.00P25 2700.00 · P75 4400.00
sky_cover_4string99.0%116,032 values30.3%
  • FEW81%
  • BKN10%
  • SCT9%

Top: FEW

Show 17 more columns
Verified column analytics for reports_eddf
sky_base_4_ftdecimal99.9%117,152 values1824.0%
  • 4500.0021%
  • 4800.0012%
  • 3500.0011%
  • Other (6)

Top: 4500.00 · 6 more values

Median 4000.00P25 3500.00 · P75 4500.00
visibility_milesdecimal0.0%0 values63<0.1%
  • 6.2193%
  • 3.731%
  • 4.351%
  • Other (51)

Top: 6.21 · 2,573 more values

Median 6.21P25 6.21 · P75 6.21
weather_codesstring82.7%96,996 values1210.6%
  • -RA24%
  • -SHRA17%
  • VCSH12%
  • Other (109)

Top: -RA · 2,317 more values

precipitation_in_1hdecimal0.0%0 values1<0.1%
  • 0.000100%

Top: 0.000

Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_ktdecimal100.0%117,227 values00.0%

No distribution published

No distribution published

peak_wind_direction_degreesdecimal100.0%117,227 values00.0%

No distribution published

No distribution published

peak_wind_timestring100.0%117,227 values00.0%

No distribution published

No distribution published

snow_depth_inchesdecimal100.0%117,227 values00.0%

No distribution published

No distribution published

raw_metarstring0.0%0 values117,227100.0%
  • COR EDDF 010020Z AUTO 17010KT 6000 RA FEW005 BKN025 BKN030 16/16 Q1003 TEMPO NSW0%
  • COR EDDF 010020Z AUTO 21006KT 9999 -RA FEW046 16/16 Q1013 RESHRA TEMPO SHRA0%
  • COR EDDF 010320Z AUTO 19006KT 9999 BKN017 16/15 Q1013 TEMPO SHRA0%
  • Other (117,215)

Top: COR EDDF 010020Z AUTO 17010KT 6000 RA FEW005 BKN025 BKN030 16/16 Q1003 TEMPO NSW · 117,215 more values

cli_productstring100.0%117,227 values00.0%

No distribution published

No distribution published

cli_high_finteger100.0%117,227 values00.0%

No distribution published

All-row histogram

cli_low_finteger100.0%117,227 values00.0%

No distribution published

All-row histogram

cli_report_typestring100.0%117,227 values00.0%

No distribution published

No distribution published

metar_high_fdecimal0.0%0 values47<0.1%
  • 51.804%
  • 53.604%
  • 57.204%
  • Other (35)

Top: 51.80 · 64,582 more values

Median 62.60P25 50.00 · P75 75.20
metar_low_fdecimal0.0%0 values37<0.1%
  • 42.806%
  • 46.406%
  • 41.005%
  • Other (25)

Top: 42.80 · 47,118 more values

Median 44.60P25 35.60 · P75 55.40
metar_high_cdecimal0.0%0 values47<0.1%
  • 11.04%
  • 12.04%
  • 14.04%
  • Other (35)

Top: 11.0 · 64,582 more values

Median 17.0P25 10.0 · P75 24.0
metar_low_cdecimal0.0%0 values37<0.1%
  • 6.06%
  • 8.06%
  • 5.05%
  • Other (25)

Top: 6.0 · 47,118 more values

Median 7.0P25 2.0 · P75 13.0

Release status

Facts from the current passing release

Release
Passing
Rows
117,227
Columns
37
Published
9 Sept 2026, 06:33
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_eddf
reports_eddf
# Current release — the complete Parquet file
curl -sS -o reports-eddf.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/dd196b7a-972a-4d99-964c-7106531ef5dd/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/dd196b7a-972a-4d99-964c-7106531ef5dd/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/dd196b7a-972a-4d99-964c-7106531ef5dd/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