reports_zggg

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 07:22

Rows: 119,027; across released Tables
Tables: 1; released
Columns: 37; reports_zggg
Version: —; reports_zggg

Data preview

reports_zggg

Preview rows for reports_zggg
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
ZGGG	2020-01-01T00:00:00.000000Z	METAR	2020-01-01	57.20	14.0	48.20	71.83	50.00	5.83	—	30.360	—	FEW	4000.00	—	—	—	—	—
ZGGG	2020-01-01T00:30:00.000000Z	SPECI	2020-01-01	59.00	15.0	48.20	67.33	60.00	5.83	—	30.360	—	BKN	3300.00	—	—	—	—	—
ZGGG	2020-01-01T01:00:00.000000Z	METAR	2020-01-01	59.00	15.0	48.20	67.33	50.00	5.83	—	30.360	—	BKN	3300.00	—	—	—	—	—
ZGGG	2020-01-01T01:30:00.000000Z	SPECI	2020-01-01	60.80	16.0	48.20	63.15	40.00	5.83	—	30.390	—	BKN	3300.00	—	—	—	—	—
ZGGG	2020-01-01T02:00:00.000000Z	METAR	2020-01-01	62.60	17.0	50.00	63.38	60.00	7.78	—	30.390	—	BKN	3300.00	—	—	—	—	—
ZGGG	2020-01-01T02:30:00.000000Z	SPECI	2020-01-01	62.60	17.0	50.00	63.38	60.00	5.83	—	30.390	—	BKN	3300.00	—	—	—	—	—
ZGGG	2020-01-01T03:00:00.000000Z	METAR	2020-01-01	62.60	17.0	50.00	63.38	70.00	5.83	—	30.390	—	BKN	3000.00	—	—	—	—	—
ZGGG	2020-01-01T03:30:00.000000Z	SPECI	2020-01-01	64.40	18.0	50.00	59.50	50.00	5.83	—	30.360	—	BKN	2600.00	—	—	—	—	—
ZGGG	2020-01-01T04:00:00.000000Z	METAR	2020-01-01	64.40	18.0	50.00	59.50	30.00	5.83	—	30.360	—	BKN	3300.00	—	—	—	—	—
ZGGG	2020-01-01T04:30:00.000000Z	SPECI	2020-01-01	64.40	18.0	50.00	59.50	30.00	3.89	—	30.330	—	BKN	3300.00	—	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

37 columns

Verified column analytics for reports_zggg
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	ZGGG100% Top: ZGGG	—
event_time_utc	timestamp_utc	—	0.0%0 values	119,027100.0%	2020-01-01 00:00:00+000% 2020-01-01 00:30:00+000% 2020-01-01 01:00:00+000% Other (119,015) Top: 2020-01-01 00:00:00+00 · 119,015 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	SPECI51% METAR49% Top: SPECI	—
local_standard_date	date	—	0.0%0 values	2,4442.1%	2024-04-200% 2024-04-270% 2026-08-140% Other (2,432) Top: 2024-04-20 · 118,240 more values	—
temp_f	decimal	—	0.0%0 values	38<0.1%	80.608% 78.807% 82.407% Other (26) Top: 80.60 · 42,809 more values	Median 77.00P25 68.00 · P75 84.20
temp_c	decimal	—	0.0%0 values	38<0.1%	27.08% 26.07% 28.07% Other (26) Top: 27.0 · 42,809 more values	Median 25.0P25 20.0 · P75 29.0
dewpoint_f	decimal	—	0.0%0 values	47<0.1%	77.0012% 78.8010% 75.209% Other (35) Top: 77.00 · 39,472 more values	Median 69.80P25 55.40 · P75 77.00
relative_humidity_pct	decimal	—	0.0%0 values	1,2501.1%	100.005% 88.901% 94.231% Other (1,238) Top: 100.00 · 100,650 more values	Median 73.61P25 59.24 · P75 83.99
wind_direction_degrees	decimal	—	13.7%16,249 values	37<0.1%	10.008% 80.007% 60.006% Other (25) Top: 10.00 · 40,334 more values	Median 110.00P25 60.00 · P75 190.00
wind_speed_kt	decimal	—	0.0%0 values	18<0.1%	3.8931% 5.8320% 1.9416% Other (6) Top: 3.89 · 71 more values	Median 5.83P25 3.89 · P75 7.78
wind_gust_kt	decimal	—	99.3%118,253 values	192.5%	25.2712% 13.6111% 15.5511% Other (7) Top: 25.27 · 30 more values	Median 21.38P25 17.49 · P75 27.21
altimeter_inhg	decimal	—	0.0%0 values	52<0.1%	29.7706% 29.7406% 29.7105% Other (40) Top: 29.770 · 51,448 more values	Median 29.880P25 29.740 · P75 30.060
sea_level_pressure_hpa	decimal	—	100.0%119,027 values	00.0%	No distribution published No distribution published	—
sky_cover_1	string	—	29.0%34,551 values	6<0.1%	BKN30% SCT27% FEW27% Top: BKN	—
sky_base_1_ft	decimal	—	32.1%38,189 values	47<0.1%	3300.0013% 4000.0010% 2600.0010% Other (35) Top: 3300.00 · 16,455 more values	Median 3300.00P25 2000.00 · P75 4000.00
sky_cover_2	string	—	79.9%95,088 values	4<0.1%	BKN33% OVC33% SCT21% Top: BKN	—
sky_base_2_ft	decimal	—	79.9%95,088 values	360.2%	3300.0016% 2600.0016% 4000.0012% Other (24) Top: 3300.00 · 1,504 more values	Median 3300.00P25 2600.00 · P75 4000.00
sky_cover_3	string	—	96.1%114,439 values	4<0.1%	BKN76% OVC16% SCT6% Top: BKN	—
sky_base_3_ft	decimal	—	96.1%114,439 values	170.4%	3300.0026% 2600.0016% 4000.0014% Other (5) Top: 3300.00 · 65 more values	Median 3300.00P25 2600.00 · P75 4000.00
sky_cover_4	string	—	99.9%118,940 values	33.4%	BKN97% SCT2% OVC1% Top: BKN	—

Show 17 more columns

Verified column analytics for reports_zggg
sky_base_4_ft	decimal	—	99.9%118,940 values	78.0%	2600.0038% 3000.0029% 3300.0010% Top: 2600.00	Median 2600.00P25 2600.00 · P75 3000.00
visibility_miles	decimal	—	<0.1%1 values	49<0.1%	6.2182% 4.977% 4.353% Other (37) Top: 6.21 · 630 more values	Median 6.21P25 6.21 · P75 6.21
weather_codes	string	—	85.0%101,138 values	450.3%	-SHRA40% -RA18% BR9% Other (33) Top: -SHRA · 668 more values	—
precipitation_in_1h	decimal	—	0.0%0 values	1<0.1%	0.000100% Top: 0.000	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt	decimal	—	100.0%119,027 values	00.0%	No distribution published No distribution published	—
peak_wind_direction_degrees	decimal	—	100.0%119,027 values	00.0%	No distribution published No distribution published	—
peak_wind_time	string	—	100.0%119,027 values	00.0%	No distribution published No distribution published	—
snow_depth_inches	decimal	—	100.0%119,027 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	119,020100.0%	ZGGG 020700Z VRB02MPS CAVOK 22/10 Q1020 NOSIG0% ZGGG 031730Z 06002MPS CAVOK 27/24 Q1012 NOSIG0% ZGGG 052330Z 05002MPS CAVOK 29/26 Q1004 NOSIG0% Other (119,008) Top: ZGGG 020700Z VRB02MPS CAVOK 22/10 Q1020 NOSIG · 119,008 more values	—
cli_product	string	—	100.0%119,027 values	00.0%	No distribution published No distribution published	—
cli_high_f	integer	—	100.0%119,027 values	00.0%	No distribution published All-row histogram	—
cli_low_f	integer	—	100.0%119,027 values	00.0%	No distribution published All-row histogram	—
cli_report_type	string	—	100.0%119,027 values	00.0%	No distribution published No distribution published	—
metar_high_f	decimal	—	0.0%0 values	34<0.1%	95.008% 96.806% 86.006% Other (22) Top: 95.00 · 39,762 more values	Median 84.20P25 75.20 · P75 93.20
metar_low_f	decimal	—	0.0%0 values	29<0.1%	78.8011% 77.0010% 80.609% Other (17) Top: 78.80 · 35,610 more values	Median 71.60P25 60.80 · P75 78.80
metar_high_c	decimal	—	0.0%0 values	34<0.1%	35.08% 36.06% 30.06% Other (22) Top: 35.0 · 39,762 more values	Median 29.0P25 24.0 · P75 34.0
metar_low_c	decimal	—	0.0%0 values	29<0.1%	26.011% 25.010% 27.09% Other (17) Top: 26.0 · 35,610 more values	Median 22.0P25 16.0 · P75 26.0

Release status

Facts from the current passing release

Release: Passing
Rows: 119,027
Columns: 37
Published: 9 Sept 2026, 07:22
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_zggg

reports_zggg

# Current release — the complete Parquet file
curl -sS -o reports-zggg.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/f1b5038d-4a5f-40e5-9360-c067985d8810/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/f1b5038d-4a5f-40e5-9360-c067985d8810/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/f1b5038d-4a5f-40e5-9360-c067985d8810/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

Guangzhou weather reports and daily highs since 2020

reports_zggg

Release status