Beijing weather reports and daily highs since 2020

Public

reports_zbaa

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:35
Rows
117,896
across released Tables
Tables
1
released
Columns
37
reports_zbaa
Version
reports_zbaa

Data preview

reports_zbaa
Preview rows for reports_zbaa
stationevent_time_utcobservation_typelocal_standard_datetemp_ftemp_cdewpoint_frelative_humidity_pctwind_direction_degreeswind_speed_ktwind_gust_ktaltimeter_inhgsea_level_pressure_hpasky_cover_1sky_base_1_ftsky_cover_2sky_base_2_ftsky_cover_3sky_base_3_ftsky_cover_4
ZBAA2020-01-01T00:00:00.000000ZMETAR2020-01-0112.20-11.0-0.4056.30330.005.8330.500
ZBAA2020-01-01T00:30:00.000000ZSPECI2020-01-0114.00-10.03.2061.51350.005.8330.500
ZBAA2020-01-01T01:00:00.000000ZMETAR2020-01-0115.80-9.03.2056.86360.005.8330.500
ZBAA2020-01-01T01:30:00.000000ZSPECI2020-01-0119.40-7.03.2048.69330.005.8330.500
ZBAA2020-01-01T02:00:00.000000ZMETAR2020-01-0119.40-7.03.2048.69320.003.8930.530
ZBAA2020-01-01T02:30:00.000000ZSPECI2020-01-0123.00-5.01.4038.45330.005.8330.530
ZBAA2020-01-01T03:00:00.000000ZMETAR2020-01-0124.80-4.01.4035.66310.003.8930.500
ZBAA2020-01-01T03:30:00.000000ZSPECI2020-01-0126.60-3.0-0.4030.42320.003.8930.500
ZBAA2020-01-01T04:00:00.000000ZMETAR2020-01-0128.40-2.0-2.2025.95330.003.8930.470
ZBAA2020-01-01T04:30:00.000000ZSPECI2020-01-0128.40-2.0-2.2025.951.9430.470
A bounded preview of the immutable release.

Columns

Schema, units, meaning, and verified release profile

37 columns
Verified column analytics for reports_zbaa
ColumnTypeUnitMissingDistinctDistributionSummary
stationstring0.0%0 values1<0.1%
  • ZBAA100%

Top: ZBAA

event_time_utctimestamp_utc0.0%0 values117,896100.0%
  • 2020-01-01 00:00:00+000%
  • 2020-01-01 00:30:00+000%
  • 2020-01-01 01:00:00+000%
  • Other (117,884)

Top: 2020-01-01 00:00:00+00 · 117,884 more values

observation_typestring0.0%0 values2<0.1%
  • SPECI50%
  • METAR50%

Top: SPECI

local_standard_datedate0.0%0 values2,4442.1%
  • 2024-11-020%
  • 2024-11-010%
  • 2026-08-030%
  • Other (2,432)

Top: 2024-11-02 · 117,173 more values

temp_fdecimal0.0%0 values66<0.1%
  • 73.404%
  • 75.204%
  • 77.003%
  • Other (54)

Top: 73.40 · 74,948 more values

Median 59.00P25 37.40 · P75 75.20
temp_cdecimal0.0%0 values66<0.1%
  • 23.04%
  • 24.04%
  • 25.03%
  • Other (54)

Top: 23.0 · 74,948 more values

Median 15.0P25 3.0 · P75 24.0
dewpoint_fdecimal0.0%0 values69<0.1%
  • 69.803%
  • 68.003%
  • 66.203%
  • Other (57)

Top: 69.80 · 80,893 more values

Median 39.20P25 15.80 · P75 62.60
relative_humidity_pctdecimal0.0%0 values2,6002.2%
  • 100.004%
  • 94.100%
  • 94.060%
  • Other (2,588)

Top: 100.00 · 109,113 more values

Median 57.60P25 33.08 · P75 79.77
wind_direction_degreesdecimal22.5%26,531 values37<0.1%
  • 360.006%
  • 350.006%
  • 340.005%
  • Other (25)

Top: 360.00 · 44,089 more values

Median 170.00P25 90.00 · P75 310.00
wind_speed_ktdecimal0.0%0 values22<0.1%
  • 1.9429%
  • 3.8928%
  • 5.8316%
  • Other (10)

Top: 1.94 · 595 more values

Median 3.89P25 1.94 · P75 5.83
wind_gust_ktdecimal97.4%114,833 values250.8%
  • 23.3311%
  • 21.3811%
  • 27.2110%
  • Other (13)

Top: 23.33 · 196 more values

Median 25.27P25 19.44 · P75 29.16
altimeter_inhgdecimal0.0%0 values61<0.1%
  • 29.7704%
  • 29.8004%
  • 29.8303%
  • Other (49)

Top: 29.770 · 72,748 more values

Median 30.000P25 29.740 · P75 30.270
sea_level_pressure_hpadecimal100.0%117,896 values00.0%

No distribution published

No distribution published

sky_cover_1string75.4%88,878 values6<0.1%
  • NSC60%
  • FEW15%
  • SCT11%

Top: NSC

sky_base_1_ftdecimal90.3%106,431 values340.3%
  • 4000.0030%
  • 3300.0013%
  • 1000.009%
  • Other (22)

Top: 4000.00 · 1,456 more values

Median 3300.00P25 1200.00 · P75 4000.00
sky_cover_2string97.3%114,658 values40.1%
  • OVC66%
  • BKN15%
  • FEW10%

Top: OVC

sky_base_2_ftdecimal97.3%114,658 values200.6%
  • 4000.0052%
  • 3300.0029%
  • 3000.009%
  • Other (8)

Top: 4000.00 · 11 more values

Median 4000.00P25 3300.00 · P75 4000.00
sky_cover_3string99.8%117,675 values41.8%
  • FEW40%
  • BKN35%
  • SCT22%

Top: FEW

sky_base_3_ftdecimal99.8%117,675 values62.7%
  • 4000.0062%
  • 3300.0026%
  • 3000.008%

Top: 4000.00

Median 4000.00P25 3300.00 · P75 4000.00
sky_cover_4string100.0%117,896 values00.0%

No distribution published

No distribution published

Show 17 more columns
Verified column analytics for reports_zbaa
sky_base_4_ftdecimal100.0%117,896 values00.0%

No distribution published

No distribution published

visibility_milesdecimal0.0%0 values52<0.1%
  • 6.2181%
  • 4.974%
  • 3.733%
  • Other (40)

Top: 6.21 · 2,069 more values

Median 6.21P25 6.21 · P75 6.21
weather_codesstring87.3%102,884 values550.4%
  • BR40%
  • -RA16%
  • HZ12%
  • Other (43)

Top: BR · 895 more values

precipitation_in_1hdecimal0.0%0 values1<0.1%
  • 0.000100%

Top: 0.000

Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_ktdecimal100.0%117,896 values00.0%

No distribution published

No distribution published

peak_wind_direction_degreesdecimal100.0%117,896 values00.0%

No distribution published

No distribution published

peak_wind_timestring100.0%117,896 values00.0%

No distribution published

No distribution published

snow_depth_inchesdecimal100.0%117,896 values00.0%

No distribution published

No distribution published

raw_metarstring0.0%0 values117,884100.0%
  • ZBAA 070430Z VRB01MPS CAVOK 32/22 Q1005 NOSIG0%
  • ZBAA 071930Z VRB01MPS CAVOK 08/02 Q1014 NOSIG0%
  • ZBAA 090400Z VRB01MPS CAVOK 06/M11 Q1024 NOSIG0%
  • Other (117,872)

Top: ZBAA 070430Z VRB01MPS CAVOK 32/22 Q1005 NOSIG · 117,872 more values

cli_productstring100.0%117,896 values00.0%

No distribution published

No distribution published

cli_high_finteger100.0%117,896 values00.0%

No distribution published

All-row histogram

cli_low_finteger100.0%117,896 values00.0%

No distribution published

All-row histogram

cli_report_typestring100.0%117,896 values00.0%

No distribution published

No distribution published

metar_high_fdecimal0.0%0 values52<0.1%
  • 87.804%
  • 84.204%
  • 82.404%
  • Other (40)

Top: 87.80 · 68,327 more values

Median 71.60P25 50.00 · P75 86.00
metar_low_fdecimal0.0%0 values50<0.1%
  • 73.404%
  • 68.004%
  • 69.804%
  • Other (38)

Top: 73.40 · 71,967 more values

Median 46.40P25 24.80 · P75 64.40
metar_high_cdecimal0.0%0 values52<0.1%
  • 31.04%
  • 29.04%
  • 28.04%
  • Other (40)

Top: 31.0 · 68,327 more values

Median 22.0P25 10.0 · P75 30.0
metar_low_cdecimal0.0%0 values50<0.1%
  • 23.04%
  • 20.04%
  • 21.04%
  • Other (38)

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.

cURL · reports_zbaa
reports_zbaa
# 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.

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