Berlin weather reports and daily highs since 2020

Public

reports_eddb

Current published release

Current data

Latest passing release for each Table

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

Data preview

reports_eddb
Preview rows for reports_eddb
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
EDDB2020-01-01T00:20:00.000000ZSPECI2020-01-0135.602.033.8093.08270.008.0030.500BKN2200.00
EDDB2020-01-01T00:50:00.000000ZMETAR2020-01-0133.801.032.0093.03240.007.0030.500FEW900.00BKN2200.00
EDDB2020-01-01T01:20:00.000000ZSPECI2020-01-0132.000.032.00100.00270.007.0030.500FEW900.00BKN2100.00
EDDB2020-01-01T01:50:00.000000ZMETAR2020-01-0130.20-1.030.20100.00240.007.0030.500FEW900.00
EDDB2020-01-01T02:20:00.000000ZSPECI2020-01-0132.000.030.2092.97240.007.0030.500FEW1000.00
EDDB2020-01-01T02:50:00.000000ZMETAR2020-01-0132.000.030.2092.97230.006.0030.500BKN800.00
EDDB2020-01-01T03:20:00.000000ZSPECI2020-01-0133.801.032.0093.03250.006.0030.500BKN800.00
EDDB2020-01-01T03:50:00.000000ZMETAR2020-01-0135.602.033.8093.08260.007.0030.500BKN800.00
EDDB2020-01-01T04:20:00.000000ZSPECI2020-01-0137.403.035.6093.14270.007.0030.500OVC700.00
EDDB2020-01-01T04:50:00.000000ZMETAR2020-01-0137.403.035.6093.14280.008.0030.500OVC700.00
A bounded preview of the immutable release.

Columns

Schema, units, meaning, and verified release profile

37 columns
Verified column analytics for reports_eddb
ColumnTypeUnitMissingDistinctDistributionSummary
stationstring0.0%0 values1<0.1%
  • EDDB100%

Top: EDDB

event_time_utctimestamp_utc0.0%0 values117,244100.0%
  • 2020-01-01 00:20:00+000%
  • 2020-01-01 00:50:00+000%
  • 2020-01-01 01:20:00+000%
  • Other (117,232)

Top: 2020-01-01 00:20:00+00 · 117,232 more values

observation_typestring0.0%0 values2<0.1%
  • SPECI50%
  • METAR50%

Top: SPECI

local_standard_datedate0.0%0 values2,4442.1%
  • 2024-12-140%
  • 2020-01-020%
  • 2020-01-030%
  • Other (2,432)

Top: 2024-12-14 · 116,667 more values

temp_fdecimal<0.1%4 values56<0.1%
  • 42.804%
  • 41.004%
  • 48.204%
  • Other (44)

Top: 42.80 · 60,503 more values

Median 51.80P25 41.00 · P75 62.60
temp_cdecimal<0.1%4 values56<0.1%
  • 6.04%
  • 5.04%
  • 9.04%
  • Other (44)

Top: 6.0 · 60,503 more values

Median 11.0P25 5.0 · P75 17.0
dewpoint_fdecimal<0.1%5 values39<0.1%
  • 42.806%
  • 44.605%
  • 41.005%
  • Other (27)

Top: 42.80 · 44,537 more values

Median 42.80P25 33.80 · P75 51.80
relative_humidity_pctdecimal<0.1%5 values1,2961.1%
  • 100.006%
  • 93.031%
  • 93.081%
  • Other (1,284)

Top: 100.00 · 98,110 more values

Median 77.15P25 60.21 · P75 87.74
wind_direction_degreesdecimal4.9%5,760 values37<0.1%
  • 270.005%
  • 240.005%
  • 260.005%
  • Other (25)

Top: 270.00 · 53,861 more values

Median 220.00P25 110.00 · P75 270.00
wind_speed_ktdecimal<0.1%1 values43<0.1%
  • 6.0011%
  • 5.0011%
  • 7.0010%
  • Other (31)

Top: 6.00 · 14,843 more values

Median 7.00P25 5.00 · P75 10.00
wind_gust_ktdecimal98.8%115,840 values453.2%
  • 29.008%
  • 33.007%
  • 30.006%
  • Other (33)

Top: 29.00 · 487 more values

Median 30.00P25 26.00 · P75 34.00
altimeter_inhgdecimal<0.1%4 values69<0.1%
  • 30.0605%
  • 30.0305%
  • 30.0905%
  • Other (57)

Top: 30.060 · 57,520 more values

Median 30.000P25 29.830 · P75 30.150
sea_level_pressure_hpadecimal100.0%117,244 values00.0%

No distribution published

No distribution published

sky_cover_1string50.7%59,434 values7<0.1%
  • FEW33%
  • BKN31%
  • SCT17%

Top: FEW

sky_base_1_ftdecimal54.0%63,279 values790.1%
  • 600.003%
  • 800.003%
  • 700.003%
  • Other (67)

Top: 600.00 · 35,605 more values

Median 2000.00P25 1000.00 · P75 3400.00
sky_cover_2string84.1%98,612 values4<0.1%
  • BKN64%
  • OVC16%
  • SCT14%

Top: BKN

sky_base_2_ftdecimal85.2%99,862 values700.4%
  • 4000.003%
  • 4500.003%
  • 1700.003%
  • Other (58)

Top: 4000.00 · 11,492 more values

Median 3000.00P25 1900.00 · P75 4000.00
sky_cover_3string95.3%111,762 values4<0.1%
  • BKN49%
  • OVC37%
  • FEW13%

Top: BKN

sky_base_3_ftdecimal96.0%112,559 values461.0%
  • 4300.005%
  • 4500.004%
  • 4600.004%
  • Other (34)

Top: 4300.00 · 2,448 more values

Median 3600.00P25 2800.00 · P75 4300.00
sky_cover_4string99.3%116,379 values30.3%
  • FEW90%
  • SCT7%
  • BKN3%

Top: FEW

Show 17 more columns
Verified column analytics for reports_eddb
sky_base_4_ftdecimal100.0%117,244 values00.0%

No distribution published

No distribution published

visibility_milesdecimal<0.1%1 values62<0.1%
  • 6.2190%
  • 3.731%
  • 4.351%
  • Other (50)

Top: 6.21 · 3,913 more values

Median 6.21P25 6.21 · P75 6.21
weather_codesstring84.3%98,872 values1060.6%
  • -RA23%
  • BR17%
  • -SHRA11%
  • Other (94)

Top: -RA · 2,047 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,244 values00.0%

No distribution published

No distribution published

peak_wind_direction_degreesdecimal100.0%117,244 values00.0%

No distribution published

No distribution published

peak_wind_timestring100.0%117,244 values00.0%

No distribution published

No distribution published

snow_depth_inchesdecimal100.0%117,244 values00.0%

No distribution published

No distribution published

raw_metarstring0.0%0 values117,244100.0%
  • COR EDDB 010050Z AUTO 01008KT CAVOK 16/14 Q1008 NOSIG0%
  • COR EDDB 010050Z AUTO 11010KT CAVOK 17/09 Q1014 NOSIG0%
  • COR EDDB 010050Z AUTO 24012KT 9999 BKN031 05/00 Q1021 NOSIG0%
  • Other (117,232)

Top: COR EDDB 010050Z AUTO 01008KT CAVOK 16/14 Q1008 NOSIG · 117,232 more values

cli_productstring100.0%117,244 values00.0%

No distribution published

No distribution published

cli_high_finteger100.0%117,244 values00.0%

No distribution published

All-row histogram

cli_low_finteger100.0%117,244 values00.0%

No distribution published

All-row histogram

cli_report_typestring100.0%117,244 values00.0%

No distribution published

No distribution published

metar_high_fdecimal0.0%0 values47<0.1%
  • 62.604%
  • 50.004%
  • 73.404%
  • Other (35)

Top: 62.60 · 63,781 more values

Median 60.80P25 48.20 · P75 73.40
metar_low_fdecimal0.0%0 values38<0.1%
  • 32.006%
  • 41.006%
  • 35.606%
  • Other (26)

Top: 32.00 · 47,517 more values

Median 42.80P25 33.80 · P75 53.60
metar_high_cdecimal0.0%0 values47<0.1%
  • 17.04%
  • 10.04%
  • 23.04%
  • Other (35)

Top: 17.0 · 63,781 more values

Median 16.0P25 9.0 · P75 23.0
metar_low_cdecimal0.0%0 values38<0.1%
  • 0.06%
  • 5.06%
  • 2.06%
  • Other (26)

Top: 0.0 · 47,517 more values

Median 6.0P25 1.0 · P75 12.0

Release status

Facts from the current passing release

Release
Passing
Rows
117,244
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_eddb
reports_eddb
# Current release — the complete Parquet file
curl -sS -o reports-eddb.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/ebe42198-b36a-41bc-ad57-d91cc623421c/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/ebe42198-b36a-41bc-ad57-d91cc623421c/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/ebe42198-b36a-41bc-ad57-d91cc623421c/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