Tel Aviv weather reports and daily highs since 2020

Public

reports_llbg

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:39
Rows
116,874
across released Tables
Tables
1
released
Columns
37
reports_llbg
Version
reports_llbg

Data preview

reports_llbg
Preview rows for reports_llbg
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
LLBG2020-01-01T00:20:00.000000ZSPECI2020-01-0148.209.044.6087.283.0030.090FEW3500.00
LLBG2020-01-01T00:50:00.000000ZMETAR2020-01-0150.0010.044.6081.61120.004.0030.090SCT3500.00
LLBG2020-01-01T01:20:00.000000ZSPECI2020-01-0148.209.044.6087.283.0030.090SCT4000.00
LLBG2020-01-01T01:50:00.000000ZMETAR2020-01-0148.209.044.6087.282.0030.060FEW4000.00
LLBG2020-01-01T02:20:00.000000ZSPECI2020-01-0148.209.044.6087.282.0030.060
LLBG2020-01-01T02:50:00.000000ZMETAR2020-01-0148.209.044.6087.282.0030.060
LLBG2020-01-01T03:20:00.000000ZSPECI2020-01-0148.209.044.6087.283.0030.060
LLBG2020-01-01T03:50:00.000000ZMETAR2020-01-0150.0010.044.6081.613.0030.060
LLBG2020-01-01T04:20:00.000000ZSPECI2020-01-0150.0010.044.6081.61180.004.0030.060
LLBG2020-01-01T04:50:00.000000ZMETAR2020-01-0150.0010.046.4087.37130.004.0030.060
A bounded preview of the immutable release.

Columns

Schema, units, meaning, and verified release profile

37 columns
Verified column analytics for reports_llbg
ColumnTypeUnitMissingDistinctDistributionSummary
stationstring0.0%0 values1<0.1%
  • LLBG100%

Top: LLBG

event_time_utctimestamp_utc0.0%0 values116,874100.0%
  • 2020-01-01 00:20:00+000%
  • 2020-01-01 00:50:00+000%
  • 2020-01-01 01:20:00+000%
  • Other (116,862)

Top: 2020-01-01 00:20:00+00 · 116,862 more values

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

Top: METAR

local_standard_datedate0.0%0 values2,4442.1%
  • 2020-03-060%
  • 2021-01-050%
  • 2022-04-150%
  • Other (2,432)

Top: 2020-03-06 · 116,288 more values

temp_fdecimal<0.1%6 values43<0.1%
  • 78.806%
  • 80.606%
  • 77.006%
  • Other (31)

Top: 78.80 · 48,471 more values

Median 71.60P25 62.60 · P75 80.60
temp_cdecimal<0.1%6 values43<0.1%
  • 26.06%
  • 27.06%
  • 25.06%
  • Other (31)

Top: 26.0 · 48,471 more values

Median 22.0P25 17.0 · P75 27.0
dewpoint_fdecimal<0.1%9 values40<0.1%
  • 69.807%
  • 68.006%
  • 50.006%
  • Other (28)

Top: 69.80 · 38,675 more values

Median 57.20P25 50.00 · P75 66.20
relative_humidity_pctdecimal<0.1%9 values1,3661.2%
  • 87.651%
  • 51.981%
  • 87.561%
  • Other (1,354)

Top: 87.65 · 107,735 more values

Median 65.33P25 53.03 · P75 76.83
wind_direction_degreesdecimal29.5%34,472 values45<0.1%
  • 290.007%
  • 140.006%
  • 280.006%
  • Other (33)

Top: 290.00 · 33,806 more values

Median 240.00P25 150.00 · P75 300.00
wind_speed_ktdecimal0.0%0 values42<0.1%
  • 3.0014%
  • 4.0011%
  • 2.0011%
  • Other (30)

Top: 3.00 · 6,828 more values

Median 5.00P25 3.00 · P75 9.00
wind_gust_ktdecimal99.6%116,436 values317.1%
  • 30.008%
  • 29.008%
  • 28.007%
  • Other (19)

Top: 30.00 · 117 more values

Median 29.00P25 25.00 · P75 32.00
altimeter_inhgdecimal<0.1%1 values37<0.1%
  • 29.9707%
  • 29.9407%
  • 29.8507%
  • Other (25)

Top: 29.970 · 29,691 more values

Median 29.910P25 29.800 · P75 30.000
sea_level_pressure_hpadecimal100.0%116,874 values00.0%

No distribution published

No distribution published

sky_cover_1string46.9%54,768 values6<0.1%
  • FEW59%
  • SCT28%
  • BKN9%

Top: FEW

sky_base_1_ftdecimal49.2%57,557 values54<0.1%
  • 3000.0015%
  • 2500.0011%
  • 3500.0010%
  • Other (42)

Top: 3000.00 · 15,543 more values

Median 3000.00P25 2300.00 · P75 3500.00
sky_cover_2string91.9%107,394 values4<0.1%
  • SCT62%
  • BKN34%
  • FEW4%

Top: SCT

sky_base_2_ftdecimal91.9%107,400 values530.6%
  • 5000.0018%
  • 4000.0013%
  • 3500.0012%
  • Other (41)

Top: 5000.00 · 1,848 more values

Median 3800.00P25 3000.00 · P75 4500.00
sky_cover_3string99.6%116,409 values30.6%
  • BKN89%
  • SCT11%
  • OVC1%

Top: BKN

sky_base_3_ftdecimal99.6%116,409 values316.7%
  • 5000.0022%
  • 3500.0015%
  • 4000.0012%
  • Other (19)

Top: 5000.00 · 66 more values

Median 4000.00P25 3200.00 · P75 4800.00
sky_cover_4string100.0%116,871 values133.3%
  • BKN100%

Top: BKN

Show 17 more columns
Verified column analytics for reports_llbg
sky_base_4_ftdecimal100.0%116,871 values3100.0%
  • 3500.0033%
  • 4600.0033%
  • 5000.0033%

Top: 3500.00

Median 4600.00P25 3500.00 · P75 5000.00
visibility_milesdecimal<0.1%2 values52<0.1%
  • 6.2195%
  • 5.592%
  • 4.971%
  • Other (40)

Top: 6.21 · 130 more values

Median 6.21P25 6.21 · P75 6.21
weather_codesstring96.7%113,033 values391.0%
  • -RA44%
  • RA24%
  • DU6%
  • Other (27)

Top: -RA · 150 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%116,874 values00.0%

No distribution published

No distribution published

peak_wind_direction_degreesdecimal100.0%116,874 values00.0%

No distribution published

No distribution published

peak_wind_timestring100.0%116,874 values00.0%

No distribution published

No distribution published

snow_depth_inchesdecimal100.0%116,874 values00.0%

No distribution published

No distribution published

raw_metarstring0.0%0 values116,818100.0%
  • LLBG 011650Z 34006KT CAVOK 30/23 Q1006 NOSIG0%
  • LLBG 011820Z VRB02KT CAVOK 20/13 Q1013 NOSIG0%
  • LLBG 011820Z VRB03KT CAVOK 14/09 Q1023 NOSIG0%
  • Other (116,806)

Top: LLBG 011650Z 34006KT CAVOK 30/23 Q1006 NOSIG · 116,850 more values

cli_productstring100.0%116,874 values00.0%

No distribution published

No distribution published

cli_high_finteger100.0%116,874 values00.0%

No distribution published

All-row histogram

cli_low_finteger100.0%116,874 values00.0%

No distribution published

All-row histogram

cli_report_typestring100.0%116,874 values00.0%

No distribution published

No distribution published

metar_high_fdecimal0.0%0 values34<0.1%
  • 89.6010%
  • 87.807%
  • 91.407%
  • Other (22)

Top: 89.60 · 35,932 more values

Median 82.40P25 71.60 · P75 89.60
metar_low_fdecimal0.0%0 values28<0.1%
  • 77.008%
  • 75.208%
  • 51.807%
  • Other (16)

Top: 77.00 · 37,069 more values

Median 64.40P25 53.60 · P75 73.40
metar_high_cdecimal0.0%0 values34<0.1%
  • 32.010%
  • 31.07%
  • 33.07%
  • Other (22)

Top: 32.0 · 35,932 more values

Median 28.0P25 22.0 · P75 32.0
metar_low_cdecimal0.0%0 values28<0.1%
  • 25.08%
  • 24.08%
  • 11.07%
  • Other (16)

Top: 25.0 · 37,069 more values

Median 18.0P25 12.0 · P75 23.0

Release status

Facts from the current passing release

Release
Passing
Rows
116,874
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_llbg
reports_llbg
# Current release — the complete Parquet file
curl -sS -o reports-llbg.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/ca3fbd73-5948-4d17-9042-82306f70e5bc/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/ca3fbd73-5948-4d17-9042-82306f70e5bc/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/ca3fbd73-5948-4d17-9042-82306f70e5bc/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