reports_zsqd

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:42

Rows: 58,606; across released Tables
Tables: 1; released
Columns: 37; reports_zsqd
Version: —; reports_zsqd

Data preview

reports_zsqd

Preview rows for reports_zsqd
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
ZSQD	2020-01-01T00:00:00.000000Z	METAR	2020-01-01	24.80	-4.0	17.60	73.70	100.00	1.94	—	30.530	—	—	—	—	—	—	—	—
ZSQD	2020-01-01T01:00:00.000000Z	METAR	2020-01-01	32.00	0.0	17.60	54.87	—	1.94	—	30.560	—	—	—	—	—	—	—	—
ZSQD	2020-01-01T02:00:00.000000Z	METAR	2020-01-01	33.80	1.0	15.80	47.22	—	1.94	—	30.560	—	—	—	—	—	—	—	—
ZSQD	2020-01-01T03:00:00.000000Z	METAR	2020-01-01	35.60	2.0	15.80	43.95	220.00	3.89	—	30.530	—	—	—	—	—	—	—	—
ZSQD	2020-01-01T04:00:00.000000Z	METAR	2020-01-01	37.40	3.0	17.60	44.25	250.00	5.83	—	30.500	—	—	—	—	—	—	—	—
ZSQD	2020-01-01T05:00:00.000000Z	METAR	2020-01-01	39.20	4.0	14.00	35.26	230.00	5.83	—	30.470	—	—	—	—	—	—	—	—
ZSQD	2020-01-01T06:00:00.000000Z	METAR	2020-01-01	39.20	4.0	15.80	38.15	210.00	5.83	—	30.450	—	—	—	—	—	—	—	—
ZSQD	2020-01-01T07:00:00.000000Z	METAR	2020-01-01	39.20	4.0	15.80	38.15	230.00	5.83	—	30.450	—	—	—	—	—	—	—	—
ZSQD	2020-01-01T08:00:00.000000Z	METAR	2020-01-01	39.20	4.0	21.20	48.10	170.00	5.83	—	30.450	—	—	—	—	—	—	—	—
ZSQD	2020-01-01T09:00:00.000000Z	METAR	2020-01-01	33.80	1.0	24.80	69.25	170.00	5.83	—	30.450	—	—	—	—	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

37 columns

Verified column analytics for reports_zsqd
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	ZSQD100% Top: ZSQD	—
event_time_utc	timestamp_utc	—	0.0%0 values	58,606100.0%	2020-01-01 00:00:00+000% 2020-01-01 01:00:00+000% 2020-01-01 02:00:00+000% Other (58,594) Top: 2020-01-01 00:00:00+00 · 58,594 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	METAR100% SPECI0% Top: METAR	—
local_standard_date	date	—	0.0%0 values	2,4444.2%	2020-01-020% 2020-01-030% 2020-01-040% Other (2,432) Top: 2020-01-02 · 58,318 more values	—
temp_f	decimal	—	<0.1%1 values	58<0.1%	71.604% 73.404% 77.004% Other (46) Top: 71.60 · 35,459 more values	Median 59.00P25 42.80 · P75 73.40
temp_c	decimal	—	<0.1%1 values	58<0.1%	22.04% 23.04% 25.04% Other (46) Top: 22.0 · 35,459 more values	Median 15.0P25 6.0 · P75 23.0
dewpoint_f	decimal	—	<0.1%1 values	58<0.1%	69.803% 71.603% 68.003% Other (46) Top: 69.80 · 38,329 more values	Median 46.40P25 28.40 · P75 66.20
relative_humidity_pct	decimal	—	<0.1%1 values	1,8273.1%	100.009% 94.061% 94.011% Other (1,815) Top: 100.00 · 50,495 more values	Median 71.45P25 52.73 · P75 87.65
wind_direction_degrees	decimal	—	9.0%5,269 values	37<0.1%	160.0011% 150.009% 170.007% Other (25) Top: 160.00 · 19,921 more values	Median 170.00P25 140.00 · P75 300.00
wind_speed_kt	decimal	—	<0.1%1 values	19<0.1%	3.8919% 5.8318% 7.7815% Other (7) Top: 3.89 · 229 more values	Median 5.83P25 3.89 · P75 9.72
wind_gust_kt	decimal	—	98.8%57,917 values	162.3%	25.2716% 27.2115% 29.1613% Other (4) Top: 25.27 · 20 more values	Median 25.27P25 23.33 · P75 29.16
altimeter_inhg	decimal	—	0.0%0 values	58<0.1%	29.8004% 29.8304% 29.7704% Other (46) Top: 29.800 · 34,652 more values	Median 30.000P25 29.770 · P75 30.240
sea_level_pressure_hpa	decimal	—	100.0%58,606 values	00.0%	No distribution published No distribution published	—
sky_cover_1	string	—	51.1%29,968 values	6<0.1%	NSC41% BKN21% SCT18% Top: NSC	—
sky_base_1_ft	decimal	—	71.0%41,635 values	390.2%	2000.0010% 4000.009% 3000.009% Other (27) Top: 2000.00 · 4,575 more values	Median 2000.00P25 1000.00 · P75 3300.00
sky_cover_2	string	—	92.2%54,015 values	4<0.1%	OVC57% BKN35% SCT6% Top: OVC	—
sky_base_2_ft	decimal	—	92.2%54,015 values	340.7%	2000.0026% 3000.0012% 3300.0012% Other (22) Top: 2000.00 · 173 more values	Median 2600.00P25 2000.00 · P75 3300.00
sky_cover_3	string	—	99.7%58,452 values	42.6%	OVC42% FEW26% BKN24% Top: OVC	—
sky_base_3_ft	decimal	—	99.7%58,452 values	95.8%	4000.0027% 3000.0023% 3300.0018% Top: 4000.00	Median 3300.00P25 3000.00 · P75 4000.00
sky_cover_4	string	—	100.0%58,606 values	00.0%	No distribution published No distribution published	—

Show 17 more columns

Verified column analytics for reports_zsqd
sky_base_4_ft	decimal	—	100.0%58,606 values	00.0%	No distribution published No distribution published	—
visibility_miles	decimal	—	<0.1%1 values	590.1%	6.2170% 3.115% 3.735% Other (47) Top: 6.21 · 2,050 more values	Median 6.21P25 4.35 · P75 6.21
weather_codes	string	—	79.6%46,648 values	480.4%	BR58% HZ10% -RA9% Other (36) Top: BR · 658 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%58,606 values	00.0%	No distribution published No distribution published	—
peak_wind_direction_degrees	decimal	—	100.0%58,606 values	00.0%	No distribution published No distribution published	—
peak_wind_time	string	—	100.0%58,606 values	00.0%	No distribution published No distribution published	—
snow_depth_inches	decimal	—	100.0%58,606 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	58,605100.0%	ZSQD 030700Z VRB01MPS CAVOK 07/M11 Q1027 NOSIG0% COR ZSQD 010800Z 34008MPS CAVOK 22/01 Q1009 BECMG TL0930 34003MPS0% COR ZSQD 040500Z 27002MPS 240V300 9999 BKN033 25/17 Q1015 NOSIG0% Other (58,593) Top: ZSQD 030700Z VRB01MPS CAVOK 07/M11 Q1027 NOSIG · 58,593 more values	—
cli_product	string	—	100.0%58,606 values	00.0%	No distribution published No distribution published	—
cli_high_f	integer	—	100.0%58,606 values	00.0%	No distribution published All-row histogram	—
cli_low_f	integer	—	100.0%58,606 values	00.0%	No distribution published All-row histogram	—
cli_report_type	string	—	100.0%58,606 values	00.0%	No distribution published No distribution published	—
metar_high_f	decimal	—	0.0%0 values	50<0.1%	87.805% 86.005% 84.204% Other (38) Top: 87.80 · 32,905 more values	Median 69.80P25 51.80 · P75 82.40
metar_low_f	decimal	—	0.0%0 values	44<0.1%	69.804% 64.404% 68.004% Other (32) Top: 69.80 · 34,522 more values	Median 50.00P25 32.00 · P75 66.20
metar_high_c	decimal	—	0.0%0 values	50<0.1%	31.05% 30.05% 29.04% Other (38) Top: 31.0 · 32,905 more values	Median 21.0P25 11.0 · P75 28.0
metar_low_c	decimal	—	0.0%0 values	44<0.1%	21.04% 18.04% 20.04% Other (32) Top: 21.0 · 34,522 more values	Median 10.0P25 0.0 · P75 19.0

Release status

Facts from the current passing release

Release: Passing
Rows: 58,606
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.

cURL · reports_zsqd

reports_zsqd

# Current release — the complete Parquet file
curl -sS -o reports-zsqd.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/80f7fac3-0789-4cbc-a0ba-8b5485d3b6cb/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/80f7fac3-0789-4cbc-a0ba-8b5485d3b6cb/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/80f7fac3-0789-4cbc-a0ba-8b5485d3b6cb/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

Qingdao weather reports and daily highs since 2020

reports_zsqd

Release status