reports_zgsz
Current published release
Current data
Latest passing release for each Table
- Rows
- 58,608
- across released Tables
- Tables
- 1
- released
- Columns
- 37
- reports_zgsz
- Version
- —
- reports_zgsz
Data preview
reports_zgsz| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ZGSZ | 2020-01-01T00:00:00.000000Z | METAR | 2020-01-01 | 64.40 | 18.0 | 53.60 | 67.95 | 60.00 | 7.78 | — | 30.330 | — | BKN | 3200.00 | — | — | — | — | — |
| ZGSZ | 2020-01-01T01:00:00.000000Z | METAR | 2020-01-01 | 64.40 | 18.0 | 53.60 | 67.95 | 90.00 | 7.78 | — | 30.360 | — | BKN | 3300.00 | — | — | — | — | — |
| ZGSZ | 2020-01-01T02:00:00.000000Z | METAR | 2020-01-01 | 66.20 | 19.0 | 55.40 | 68.15 | 110.00 | 7.78 | — | 30.360 | — | BKN | 3000.00 | — | — | — | — | — |
| ZGSZ | 2020-01-01T03:00:00.000000Z | METAR | 2020-01-01 | 66.20 | 19.0 | 55.40 | 68.15 | 60.00 | 5.83 | 15.55 | 30.360 | — | SCT | 2000.00 | BKN | 3000.00 | — | — | — |
| ZGSZ | 2020-01-01T04:00:00.000000Z | METAR | 2020-01-01 | 66.20 | 19.0 | 55.40 | 68.15 | 30.00 | 7.78 | — | 30.330 | — | BKN | 2700.00 | — | — | — | — | — |
| ZGSZ | 2020-01-01T05:00:00.000000Z | METAR | 2020-01-01 | 68.00 | 20.0 | 55.40 | 64.04 | 60.00 | 9.72 | — | 30.300 | — | BKN | 2700.00 | — | — | — | — | — |
| ZGSZ | 2020-01-01T06:00:00.000000Z | METAR | 2020-01-01 | 66.20 | 19.0 | 53.60 | 63.82 | 30.00 | 7.78 | — | 30.300 | — | BKN | 2700.00 | — | — | — | — | — |
| ZGSZ | 2020-01-01T07:00:00.000000Z | METAR | 2020-01-01 | 66.20 | 19.0 | 55.40 | 68.15 | 20.00 | 5.83 | — | 30.270 | — | BKN | 2700.00 | — | — | — | — | — |
| ZGSZ | 2020-01-01T08:00:00.000000Z | METAR | 2020-01-01 | 66.20 | 19.0 | 55.40 | 68.15 | 70.00 | 5.83 | — | 30.270 | — | BKN | 2700.00 | — | — | — | — | — |
| ZGSZ | 2020-01-01T09:00:00.000000Z | METAR | 2020-01-01 | 66.20 | 19.0 | 53.60 | 63.82 | 60.00 | 3.89 | — | 30.270 | — | BKN | 2700.00 | — | — | — | — | — |
Columns
Schema, units, meaning, and verified release profile
| Column | Type | Unit | Missing | Distinct | Distribution | Summary |
|---|---|---|---|---|---|---|
| station | string | — | 0.0%0 values | 1<0.1% |
Top: ZGSZ | — |
| event_time_utc | timestamp_utc | — | 0.0%0 values | 58,608100.0% |
Top: 2020-01-01 00:00:00+00 · 58,596 more values | — |
| observation_type | string | — | 0.0%0 values | 2<0.1% |
Top: METAR | — |
| local_standard_date | date | — | 0.0%0 values | 2,4444.2% |
Top: 2020-01-02 · 58,320 more values | — |
| temp_f | decimal | — | 0.0%0 values | 34<0.1% |
Top: 84.20 · 15,182 more values | Median 78.80P25 68.00 · P75 84.20 |
| temp_c | decimal | — | 0.0%0 values | 34<0.1% |
Top: 29.0 · 15,182 more values | Median 26.0P25 20.0 · P75 29.0 |
| dewpoint_f | decimal | — | 0.0%0 values | 45<0.1% |
Top: 78.80 · 17,972 more values | Median 69.80P25 57.20 · P75 77.00 |
| relative_humidity_pct | decimal | — | 0.0%0 values | 1,0411.8% |
Top: 83.88 · 48,068 more values | Median 77.45P25 65.33 · P75 83.88 |
| wind_direction_degrees | decimal | — | 4.4%2,586 values | 37<0.1% |
Top: 170.00 · 19,885 more values | Median 160.00P25 60.00 · P75 190.00 |
| wind_speed_kt | decimal | — | 0.0%0 values | 18<0.1% |
Top: 5.83 · 58 more values | Median 7.78P25 5.83 · P75 9.72 |
| wind_gust_kt | decimal | — | 99.0%58,039 values | 183.2% |
Top: 19.44 · 20 more values | Median 21.38P25 17.49 · P75 27.21 |
| altimeter_inhg | decimal | — | 0.0%0 values | 49<0.1% |
Top: 29.770 · 23,559 more values | Median 29.880P25 29.740 · P75 30.030 |
| sea_level_pressure_hpa | decimal | — | 100.0%58,608 values | 00.0% | No distribution published No distribution published | — |
| sky_cover_1 | string | — | 36.7%21,509 values | 5<0.1% |
Top: FEW | — |
| sky_base_1_ft | decimal | — | 41.2%24,141 values | 470.1% |
Top: 2000.00 · 6,754 more values | Median 2600.00P25 2000.00 · P75 3600.00 |
| sky_cover_2 | string | — | 81.5%47,739 values | 4<0.1% |
Top: BKN | — |
| sky_base_2_ft | decimal | — | 81.5%47,739 values | 360.3% |
Top: 3000.00 · 591 more values | Median 3000.00P25 2600.00 · P75 4000.00 |
| sky_cover_3 | string | — | 96.5%56,552 values | 40.2% |
Top: BKN | — |
| sky_base_3_ft | decimal | — | 96.5%56,552 values | 170.8% |
Top: 4000.00 · 15 more values | Median 4000.00P25 3300.00 · P75 5000.00 |
| sky_cover_4 | string | — | 100.0%58,586 values | 14.5% |
Top: BKN | — |
Show 17 more columns
| sky_base_4_ft | decimal | — | 100.0%58,586 values | 731.8% |
Top: 3300.00 | Median 3300.00P25 3000.00 · P75 4000.00 |
|---|---|---|---|---|---|---|
| visibility_miles | decimal | — | 0.0%0 values | 54<0.1% |
Top: 6.21 · 272 more values | Median 6.21P25 6.21 · P75 6.21 |
| weather_codes | string | — | 89.4%52,395 values | 310.5% |
Top: -SHRA · 149 more values | — |
| precipitation_in_1h | decimal | — | 0.0%0 values | 1<0.1% |
Top: 0.000 | Median 0.000P25 0.000 · P75 0.000 |
| peak_wind_gust_kt | decimal | — | 100.0%58,608 values | 00.0% | No distribution published No distribution published | — |
| peak_wind_direction_degrees | decimal | — | 100.0%58,608 values | 00.0% | No distribution published No distribution published | — |
| peak_wind_time | string | — | 100.0%58,608 values | 00.0% | No distribution published No distribution published | — |
| snow_depth_inches | decimal | — | 100.0%58,608 values | 00.0% | No distribution published No distribution published | — |
| raw_metar | string | — | 0.0%0 values | 58,594100.0% |
Top: ZGSZ 021200Z 17007MPS CAVOK 30/27 Q1005 NOSIG · 58,584 more values | — |
| cli_product | string | — | 100.0%58,608 values | 00.0% | No distribution published No distribution published | — |
| cli_high_f | integer | — | 100.0%58,608 values | 00.0% | No distribution published All-row histogram | — |
| cli_low_f | integer | — | 100.0%58,608 values | 00.0% | No distribution published All-row histogram | — |
| cli_report_type | string | — | 100.0%58,608 values | 00.0% | No distribution published No distribution published | — |
| metar_high_f | decimal | — | 0.0%0 values | 29<0.1% |
Top: 89.60 · 11,961 more values | Median 82.40P25 75.20 · P75 87.80 |
| metar_low_f | decimal | — | 0.0%0 values | 27<0.1% |
Top: 82.40 · 13,365 more values | Median 75.20P25 64.40 · P75 80.60 |
| metar_high_c | decimal | — | 0.0%0 values | 29<0.1% |
Top: 32.0 · 11,961 more values | Median 28.0P25 24.0 · P75 31.0 |
| metar_low_c | decimal | — | 0.0%0 values | 27<0.1% |
Top: 28.0 · 13,365 more values | Median 24.0P25 18.0 · P75 27.0 |
Release status
Facts from the current passing release
- Release
- Passing
- Rows
- 58,608
- Columns
- 37
- Published
- 9 Sept 2026, 06:42
- Analytics
- Verified across all rows
Use dataset
Query this dataset with the API, connect an AI tool with MCP, or download a Parquet file.
# Current release — the complete Parquet file
curl -sS -o reports-zgsz.parquet \
-H "x-api-key: $MOSTLYRIGHT_API_KEY" \
"https://mostlyright.md/api/v2/public/tables/d5588d7c-5679-419f-ad3a-b561ac78b778/current"
# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/d5588d7c-5679-419f-ad3a-b561ac78b778/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/d5588d7c-5679-419f-ad3a-b561ac78b778/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.
