reports_zbaa
Current published release
Current data
Latest passing release for each Table
- Rows
- 117,896
- across released Tables
- Tables
- 1
- released
- Columns
- 37
- reports_zbaa
- Version
- —
- reports_zbaa
Data preview
reports_zbaa| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ZBAA | 2020-01-01T00:00:00.000000Z | METAR | 2020-01-01 | 12.20 | -11.0 | -0.40 | 56.30 | 330.00 | 5.83 | — | 30.500 | — | — | — | — | — | — | — | — |
| ZBAA | 2020-01-01T00:30:00.000000Z | SPECI | 2020-01-01 | 14.00 | -10.0 | 3.20 | 61.51 | 350.00 | 5.83 | — | 30.500 | — | — | — | — | — | — | — | — |
| ZBAA | 2020-01-01T01:00:00.000000Z | METAR | 2020-01-01 | 15.80 | -9.0 | 3.20 | 56.86 | 360.00 | 5.83 | — | 30.500 | — | — | — | — | — | — | — | — |
| ZBAA | 2020-01-01T01:30:00.000000Z | SPECI | 2020-01-01 | 19.40 | -7.0 | 3.20 | 48.69 | 330.00 | 5.83 | — | 30.500 | — | — | — | — | — | — | — | — |
| ZBAA | 2020-01-01T02:00:00.000000Z | METAR | 2020-01-01 | 19.40 | -7.0 | 3.20 | 48.69 | 320.00 | 3.89 | — | 30.530 | — | — | — | — | — | — | — | — |
| ZBAA | 2020-01-01T02:30:00.000000Z | SPECI | 2020-01-01 | 23.00 | -5.0 | 1.40 | 38.45 | 330.00 | 5.83 | — | 30.530 | — | — | — | — | — | — | — | — |
| ZBAA | 2020-01-01T03:00:00.000000Z | METAR | 2020-01-01 | 24.80 | -4.0 | 1.40 | 35.66 | 310.00 | 3.89 | — | 30.500 | — | — | — | — | — | — | — | — |
| ZBAA | 2020-01-01T03:30:00.000000Z | SPECI | 2020-01-01 | 26.60 | -3.0 | -0.40 | 30.42 | 320.00 | 3.89 | — | 30.500 | — | — | — | — | — | — | — | — |
| ZBAA | 2020-01-01T04:00:00.000000Z | METAR | 2020-01-01 | 28.40 | -2.0 | -2.20 | 25.95 | 330.00 | 3.89 | — | 30.470 | — | — | — | — | — | — | — | — |
| ZBAA | 2020-01-01T04:30:00.000000Z | SPECI | 2020-01-01 | 28.40 | -2.0 | -2.20 | 25.95 | — | 1.94 | — | 30.470 | — | — | — | — | — | — | — | — |
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: ZBAA | — |
| event_time_utc | timestamp_utc | — | 0.0%0 values | 117,896100.0% |
Top: 2020-01-01 00:00:00+00 · 117,884 more values | — |
| observation_type | string | — | 0.0%0 values | 2<0.1% |
Top: SPECI | — |
| local_standard_date | date | — | 0.0%0 values | 2,4442.1% |
Top: 2024-11-02 · 117,173 more values | — |
| temp_f | decimal | — | 0.0%0 values | 66<0.1% |
Top: 73.40 · 74,948 more values | Median 59.00P25 37.40 · P75 75.20 |
| temp_c | decimal | — | 0.0%0 values | 66<0.1% |
Top: 23.0 · 74,948 more values | Median 15.0P25 3.0 · P75 24.0 |
| dewpoint_f | decimal | — | 0.0%0 values | 69<0.1% |
Top: 69.80 · 80,893 more values | Median 39.20P25 15.80 · P75 62.60 |
| relative_humidity_pct | decimal | — | 0.0%0 values | 2,6002.2% |
Top: 100.00 · 109,113 more values | Median 57.60P25 33.08 · P75 79.77 |
| wind_direction_degrees | decimal | — | 22.5%26,531 values | 37<0.1% |
Top: 360.00 · 44,089 more values | Median 170.00P25 90.00 · P75 310.00 |
| wind_speed_kt | decimal | — | 0.0%0 values | 22<0.1% |
Top: 1.94 · 595 more values | Median 3.89P25 1.94 · P75 5.83 |
| wind_gust_kt | decimal | — | 97.4%114,833 values | 250.8% |
Top: 23.33 · 196 more values | Median 25.27P25 19.44 · P75 29.16 |
| altimeter_inhg | decimal | — | 0.0%0 values | 61<0.1% |
Top: 29.770 · 72,748 more values | Median 30.000P25 29.740 · P75 30.270 |
| sea_level_pressure_hpa | decimal | — | 100.0%117,896 values | 00.0% | No distribution published No distribution published | — |
| sky_cover_1 | string | — | 75.4%88,878 values | 6<0.1% |
Top: NSC | — |
| sky_base_1_ft | decimal | — | 90.3%106,431 values | 340.3% |
Top: 4000.00 · 1,456 more values | Median 3300.00P25 1200.00 · P75 4000.00 |
| sky_cover_2 | string | — | 97.3%114,658 values | 40.1% |
Top: OVC | — |
| sky_base_2_ft | decimal | — | 97.3%114,658 values | 200.6% |
Top: 4000.00 · 11 more values | Median 4000.00P25 3300.00 · P75 4000.00 |
| sky_cover_3 | string | — | 99.8%117,675 values | 41.8% |
Top: FEW | — |
| sky_base_3_ft | decimal | — | 99.8%117,675 values | 62.7% |
Top: 4000.00 | Median 4000.00P25 3300.00 · P75 4000.00 |
| sky_cover_4 | string | — | 100.0%117,896 values | 00.0% | No distribution published No distribution published | — |
Show 17 more columns
| sky_base_4_ft | decimal | — | 100.0%117,896 values | 00.0% | No distribution published No distribution published | — |
|---|---|---|---|---|---|---|
| visibility_miles | decimal | — | 0.0%0 values | 52<0.1% |
Top: 6.21 · 2,069 more values | Median 6.21P25 6.21 · P75 6.21 |
| weather_codes | string | — | 87.3%102,884 values | 550.4% |
Top: BR · 895 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%117,896 values | 00.0% | No distribution published No distribution published | — |
| peak_wind_direction_degrees | decimal | — | 100.0%117,896 values | 00.0% | No distribution published No distribution published | — |
| peak_wind_time | string | — | 100.0%117,896 values | 00.0% | No distribution published No distribution published | — |
| snow_depth_inches | decimal | — | 100.0%117,896 values | 00.0% | No distribution published No distribution published | — |
| raw_metar | string | — | 0.0%0 values | 117,884100.0% |
Top: ZBAA 070430Z VRB01MPS CAVOK 32/22 Q1005 NOSIG · 117,872 more values | — |
| cli_product | string | — | 100.0%117,896 values | 00.0% | No distribution published No distribution published | — |
| cli_high_f | integer | — | 100.0%117,896 values | 00.0% | No distribution published All-row histogram | — |
| cli_low_f | integer | — | 100.0%117,896 values | 00.0% | No distribution published All-row histogram | — |
| cli_report_type | string | — | 100.0%117,896 values | 00.0% | No distribution published No distribution published | — |
| metar_high_f | decimal | — | 0.0%0 values | 52<0.1% |
Top: 87.80 · 68,327 more values | Median 71.60P25 50.00 · P75 86.00 |
| metar_low_f | decimal | — | 0.0%0 values | 50<0.1% |
Top: 73.40 · 71,967 more values | Median 46.40P25 24.80 · P75 64.40 |
| metar_high_c | decimal | — | 0.0%0 values | 52<0.1% |
Top: 31.0 · 68,327 more values | Median 22.0P25 10.0 · P75 30.0 |
| metar_low_c | decimal | — | 0.0%0 values | 50<0.1% |
Top: 23.0 · 71,967 more values | Median 8.0P25 -4.0 · P75 18.0 |
Release status
Facts from the current passing release
- Release
- Passing
- Rows
- 117,896
- Columns
- 37
- Published
- 9 Sept 2026, 06:35
- 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-zbaa.parquet \
-H "x-api-key: $MOSTLYRIGHT_API_KEY" \
"https://mostlyright.md/api/v2/public/tables/17b07278-1e92-40d5-80a3-4ad03de899cb/current"
# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/17b07278-1e92-40d5-80a3-4ad03de899cb/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/17b07278-1e92-40d5-80a3-4ad03de899cb/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.
