reports_lsgg

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:34

Rows: 117,213; across released Tables
Tables: 1; released
Columns: 37; reports_lsgg
Version: —; reports_lsgg

Data preview

reports_lsgg

Preview rows for reports_lsgg
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
LSGG	2020-01-01T00:20:00.000000Z	SPECI	2020-01-01	35.60	2.0	33.80	93.08	—	2.00	—	30.470	—	SCT	600.00	SCT	700.00	BKN	800.00	—
LSGG	2020-01-01T00:50:00.000000Z	METAR	2020-01-01	35.60	2.0	33.80	93.08	—	2.00	—	30.470	—	FEW	700.00	BKN	900.00	—	—	—
LSGG	2020-01-01T01:20:00.000000Z	SPECI	2020-01-01	35.60	2.0	33.80	93.08	—	1.00	—	30.470	—	BKN	800.00	—	—	—	—	—
LSGG	2020-01-01T01:50:00.000000Z	METAR	2020-01-01	35.60	2.0	33.80	93.08	—	2.00	—	30.470	—	BKN	800.00	—	—	—	—	—
LSGG	2020-01-01T02:20:00.000000Z	SPECI	2020-01-01	35.60	2.0	32.00	86.59	—	2.00	—	30.470	—	OVC	700.00	—	—	—	—	—
LSGG	2020-01-01T02:50:00.000000Z	METAR	2020-01-01	35.60	2.0	32.00	86.59	—	1.00	—	30.470	—	OVC	700.00	—	—	—	—	—
LSGG	2020-01-01T03:20:00.000000Z	SPECI	2020-01-01	33.80	1.0	32.00	93.03	—	1.00	—	30.470	—	OVC	700.00	—	—	—	—	—
LSGG	2020-01-01T03:50:00.000000Z	METAR	2020-01-01	33.80	1.0	32.00	93.03	—	1.00	—	30.470	—	BKN	600.00	—	—	—	—	—
LSGG	2020-01-01T04:20:00.000000Z	SPECI	2020-01-01	33.80	1.0	32.00	93.03	80.00	2.00	—	30.470	—	BKN	600.00	—	—	—	—	—
LSGG	2020-01-01T04:50:00.000000Z	METAR	2020-01-01	35.60	2.0	33.80	93.08	—	1.00	—	30.470	—	FEW	400.00	BKN	600.00	—	—	—

Columns

Schema, units, meaning, and verified release profile

37 columns

Verified column analytics for reports_lsgg
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	LSGG100% Top: LSGG	—
event_time_utc	timestamp_utc	—	0.0%0 values	117,213100.0%	2020-01-01 00:20:00+000% 2020-01-01 00:50:00+000% 2020-01-01 01:20:00+000% Other (117,201) Top: 2020-01-01 00:20:00+00 · 117,201 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,4432.1%	2020-04-030% 2021-03-200% 2024-07-260% Other (2,431) Top: 2020-04-03 · 116,631 more values	—
temp_f	decimal	—	<0.1%10 values	57<0.1%	51.805% 50.004% 48.204% Other (45) Top: 51.80 · 59,424 more values	Median 53.60P25 42.80 · P75 64.40
temp_c	decimal	—	<0.1%10 values	57<0.1%	11.05% 10.04% 9.04% Other (45) Top: 11.0 · 59,424 more values	Median 12.0P25 6.0 · P75 18.0
dewpoint_f	decimal	—	<0.1%10 values	50<0.1%	53.606% 51.805% 55.405% Other (38) Top: 53.60 · 44,640 more values	Median 44.60P25 35.60 · P75 53.60
relative_humidity_pct	decimal	—	<0.1%10 values	1,2081.0%	100.006% 93.351% 93.081% Other (1,196) Top: 100.00 · 100,552 more values	Median 74.63P25 57.12 · P75 87.28
wind_direction_degrees	decimal	—	35.2%41,303 values	37<0.1%	40.008% 240.007% 230.007% Other (25) Top: 40.00 · 25,176 more values	Median 200.00P25 50.00 · P75 240.00
wind_speed_kt	decimal	—	<0.1%9 values	31<0.1%	2.0020% 1.0019% 3.0012% Other (19) Top: 2.00 · 7,414 more values	Median 3.00P25 2.00 · P75 7.00
wind_gust_kt	decimal	—	99.3%116,339 values	364.1%	28.009% 27.008% 26.008% Other (24) Top: 28.00 · 243 more values	Median 27.00P25 23.00 · P75 30.00
altimeter_inhg	decimal	—	<0.1%15 values	61<0.1%	30.0307% 30.0907% 30.0607% Other (49) Top: 30.030 · 40,733 more values	Median 30.060P25 29.940 · P75 30.180
sea_level_pressure_hpa	decimal	—	100.0%117,206 values	7100.0%	1014.7014% 1015.0014% 1016.0014% Top: 1014.70	Median 1017.00P25 1015.00 · P75 1021.10
sky_cover_1	string	—	28.9%33,865 values	8<0.1%	FEW57% BKN15% SCT11% Top: FEW	—
sky_base_1_ft	decimal	—	36.2%42,426 values	1030.1%	5000.006% 3500.005% 4000.005% Other (91) Top: 5000.00 · 39,471 more values	Median 3500.00P25 1800.00 · P75 5000.00
sky_cover_2	string	—	71.2%83,476 values	5<0.1%	BKN54% SCT36% FEW6% Top: BKN	—
sky_base_2_ft	decimal	—	72.1%84,489 values	1070.3%	5000.009% 4000.006% 6000.006% Other (95) Top: 5000.00 · 14,373 more values	Median 5000.00P25 3500.00 · P75 6600.00
sky_cover_3	string	—	93.2%109,298 values	5<0.1%	BKN77% OVC9% FEW9% Top: BKN	—
sky_base_3_ft	decimal	—	93.8%110,002 values	981.4%	5000.0015% 6000.0010% 8000.009% Other (86) Top: 5000.00 · 1,354 more values	Median 5500.00P25 4300.00 · P75 7500.00
sky_cover_4	string	—	99.9%117,040 values	52.9%	BKN77% FEW10% OVC6% Top: BKN	—

Show 17 more columns

Verified column analytics for reports_lsgg
sky_base_4_ft	decimal	—	99.9%117,061 values	1610.5%	8000.0019% 7000.0017% 5000.0016% Other (4) Top: 8000.00 · 5 more values	Median 7000.00P25 5000.00 · P75 8000.00
visibility_miles	decimal	—	<0.1%7 values	65<0.1%	6.2189% 5.592% 4.972% Other (53) Top: 6.21 · 3,581 more values	Median 6.21P25 6.21 · P75 6.21
weather_codes	string	—	80.0%93,767 values	1150.5%	-RA24% VCSH22% -SHRA14% Other (103) Top: -RA · 2,102 more values	—
precipitation_in_1h	decimal	—	<0.1%15 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,213 values	00.0%	No distribution published No distribution published	—
peak_wind_direction_degrees	decimal	—	100.0%117,213 values	00.0%	No distribution published No distribution published	—
peak_wind_time	string	—	100.0%117,213 values	00.0%	No distribution published No distribution published	—
snow_depth_inches	decimal	—	100.0%117,213 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	117,200100.0%	LSGG 042150Z AUTO VRB01KT CAVOK 18/11 Q1022 NOSIG0% LSGG 080220Z AUTO VRB01KT CAVOK 08/07 Q1022 NOSIG0% LSGG 090050Z AUTO VRB01KT CAVOK 19/15 Q1019 NOSIG0% Other (117,188) Top: LSGG 042150Z AUTO VRB01KT CAVOK 18/11 Q1022 NOSIG · 117,189 more values	—
cli_product	string	—	100.0%117,213 values	00.0%	No distribution published No distribution published	—
cli_high_f	integer	—	100.0%117,213 values	00.0%	No distribution published All-row histogram	—
cli_low_f	integer	—	100.0%117,213 values	00.0%	No distribution published All-row histogram	—
cli_report_type	string	—	100.0%117,213 values	00.0%	No distribution published No distribution published	—
metar_high_f	decimal	—	0.0%0 values	43<0.1%	53.605% 60.804% 50.004% Other (31) Top: 53.60 · 62,945 more values	Median 60.80P25 50.00 · P75 75.20
metar_low_f	decimal	—	0.0%0 values	34<0.1%	33.805% 39.205% 37.405% Other (22) Top: 33.80 · 51,189 more values	Median 46.40P25 35.60 · P75 55.40
metar_high_c	decimal	—	0.0%0 values	43<0.1%	12.05% 16.04% 10.04% Other (31) Top: 12.0 · 62,945 more values	Median 16.0P25 10.0 · P75 24.0
metar_low_c	decimal	—	0.0%0 values	34<0.1%	1.05% 4.05% 3.05% Other (22) Top: 1.0 · 51,189 more values	Median 8.0P25 2.0 · P75 13.0

Release status

Facts from the current passing release

Release: Passing
Rows: 117,213
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_lsgg

reports_lsgg

# Current release — the complete Parquet file
curl -sS -o reports-lsgg.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/3554e0db-9350-4172-a7db-077bfaebec5f/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/3554e0db-9350-4172-a7db-077bfaebec5f/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/3554e0db-9350-4172-a7db-077bfaebec5f/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

Geneva weather reports and daily highs since 2020

reports_lsgg

Release status