Geneva weather reports and daily highs since 2020

• Window: 2020-01-01 to the most recent completed day, refreshed each morning. Report times are UTC. The calendar date is on Central European Time (UTC+1) all year, no daylight saving shift, so each calendar day spans 24 hours.
• Grain: one row per report. 117,213 reports over 2,443 days from 2020-01-01 to 2026-09-08 at the first build. Routine METAR reports arrive about hourly. Special SPECI reports arrive when conditions change. A typical month holds 1,295 to 1,583 rows.
• Cadence: one new day of reports each morning. Reported daily highs and lows are final after the last report for each calendar date.
• Station: Geneva Airport, ICAO code LSGG, the station whose reports settle daily temperature questions for Geneva.

• station: the ICAO code of the reporting station, always LSGG.
• event_time_utc: the report time in UTC.
• observation_type: METAR for a routine report, SPECI for a special report.
• local_standard_date: the calendar date on Central European Time.
• temp_f, dewpoint_f: air temperature and dew point, degrees Fahrenheit. temp_c: air temperature, degrees Celsius.
• relative_humidity_pct: relative humidity, percent.
• wind_direction_degrees, wind_speed_kt, wind_gust_kt: wind direction clockwise from true north, sustained speed and gust, knots.
• altimeter_inhg, sea_level_pressure_hpa: altimeter setting in inches of mercury and sea-level pressure in hectopascals.
• sky_cover_1 to sky_cover_4, sky_base_1_ft to sky_base_4_ft: up to four sky-cover layers with each base height in feet.
• visibility_miles: horizontal visibility, statute miles.
• weather_codes: present-weather codes such as RA, SN, FG, TS.
• precipitation_in_1h: one-hour precipitation, inches.
• peak_wind_gust_kt, peak_wind_direction_degrees, peak_wind_time: peak wind from the report remarks.
• snow_depth_inches: snow depth, inches.
• raw_metar: the original report text.
• metar_high_f, metar_low_f, metar_high_c, metar_low_c: highest and lowest temperature on the row's calendar date, in Fahrenheit and Celsius, calculated from all reports for that date.
• cli_high_f, cli_low_f, cli_product, cli_report_type: always null: no National Weather Service climate report exists outside the United States. Kept so every city table shares one schema.

Absent fields are null, never zero. A trace of precipitation is null. Unreported sky layers are null. The derived daily range is null only on a day with no parsable temperature.

• Reading the day's highest and lowest reported temperature at LSGG for any date since 2020, in Fahrenheit and Celsius.
• Reconstructing Geneva conditions at any hour since 2020.
• Building daily temperature, wind and precipitation series for Geneva Airport.
• Checking what LSGG reported around a settlement time or a forecast.

METAR observations come from Geneva Airport through the WMO Global Telecommunication System. Iowa Environmental Mesonet (IEM) at Iowa State University archives the reports and requests attribution. No open licence is asserted for data from the originating meteorological service.