reports_zspd

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:35

Rows: 118,146; across released Tables
Tables: 1; released
Columns: 37; reports_zspd
Version: —; reports_zspd

Data preview

reports_zspd

Preview rows for reports_zspd
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
ZSPD	2020-01-01T00:00:00.000000Z	METAR	2020-01-01	39.20	4.0	30.20	69.88	20.00	7.78	17.49	30.560	—	—	—	—	—	—	—	—
ZSPD	2020-01-01T00:30:00.000000Z	SPECI	2020-01-01	42.80	6.0	30.20	60.79	50.00	5.83	—	30.560	—	—	—	—	—	—	—	—
ZSPD	2020-01-01T01:00:00.000000Z	METAR	2020-01-01	44.60	7.0	30.20	56.74	60.00	5.83	—	30.560	—	—	—	—	—	—	—	—
ZSPD	2020-01-01T01:30:00.000000Z	SPECI	2020-01-01	44.60	7.0	30.20	56.74	50.00	5.83	—	30.560	—	—	—	—	—	—	—	—
ZSPD	2020-01-01T02:00:00.000000Z	METAR	2020-01-01	44.60	7.0	30.20	56.74	80.00	5.83	—	30.560	—	—	—	—	—	—	—	—
ZSPD	2020-01-01T02:30:00.000000Z	SPECI	2020-01-01	46.40	8.0	32.00	57.00	70.00	7.78	—	30.530	—	—	—	—	—	—	—	—
ZSPD	2020-01-01T03:00:00.000000Z	METAR	2020-01-01	48.20	9.0	32.00	53.27	80.00	7.78	—	30.530	—	—	—	—	—	—	—	—
ZSPD	2020-01-01T03:30:00.000000Z	SPECI	2020-01-01	50.00	10.0	32.00	49.81	90.00	7.78	—	30.500	—	—	—	—	—	—	—	—
ZSPD	2020-01-01T04:00:00.000000Z	METAR	2020-01-01	50.00	10.0	32.00	49.81	120.00	5.83	—	30.500	—	FEW	2600.00	—	—	—	—	—
ZSPD	2020-01-01T04:30:00.000000Z	SPECI	2020-01-01	48.20	9.0	32.00	53.27	—	3.89	—	30.470	—	FEW	3300.00	—	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

37 columns

Verified column analytics for reports_zspd
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	ZSPD100% Top: ZSPD	—
event_time_utc	timestamp_utc	—	0.0%0 values	118,146100.0%	2020-01-01 00:00:00+000% 2020-01-01 00:30:00+000% 2020-01-01 01:00:00+000% Other (118,134) Top: 2020-01-01 00:00:00+00 · 118,134 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	SPECI50% METAR50% Top: SPECI	—
local_standard_date	date	—	0.0%0 values	2,4442.1%	2024-09-200% 2025-07-300% 2024-11-010% Other (2,432) Top: 2024-09-20 · 117,377 more values	—
temp_f	decimal	—	0.0%0 values	47<0.1%	82.405% 80.605% 78.804% Other (35) Top: 82.40 · 64,382 more values	Median 66.20P25 51.80 · P75 78.80
temp_c	decimal	—	0.0%0 values	47<0.1%	28.05% 27.05% 26.04% Other (35) Top: 28.0 · 64,382 more values	Median 19.0P25 11.0 · P75 26.0
dewpoint_f	decimal	—	0.0%0 values	53<0.1%	77.007% 78.807% 75.204% Other (41) Top: 77.00 · 62,811 more values	Median 57.20P25 42.80 · P75 73.40
relative_humidity_pct	decimal	—	0.0%0 values	1,4681.2%	100.008% 88.901% 88.831% Other (1,456) Top: 100.00 · 98,431 more values	Median 78.48P25 64.48 · P75 88.75
wind_direction_degrees	decimal	—	2.7%3,205 values	37<0.1%	150.005% 140.005% 170.004% Other (25) Top: 150.00 · 58,340 more values	Median 150.00P25 80.00 · P75 250.00
wind_speed_kt	decimal	—	0.0%0 values	28<0.1%	7.7818% 5.8317% 9.7217% Other (16) Top: 7.78 · 970 more values	Median 7.78P25 5.83 · P75 11.66
wind_gust_kt	decimal	—	98.2%115,964 values	281.3%	29.1613% 27.2113% 25.2712% Other (16) Top: 29.16 · 232 more values	Median 29.16P25 25.27 · P75 33.05
altimeter_inhg	decimal	—	0.0%0 values	66<0.1%	29.8004% 29.7704% 29.8304% Other (54) Top: 29.800 · 65,784 more values	Median 29.970P25 29.770 · P75 30.210
sea_level_pressure_hpa	decimal	—	100.0%118,146 values	00.0%	No distribution published No distribution published	—
sky_cover_1	string	—	48.7%57,554 values	6<0.1%	BKN45% SCT19% FEW17% Top: BKN	—
sky_base_1_ft	decimal	—	56.8%67,066 values	29<0.1%	2000.0010% 1600.0010% 3300.009% Other (17) Top: 2000.00 · 11,341 more values	Median 1600.00P25 1000.00 · P75 2600.00
sky_cover_2	string	—	93.8%110,770 values	4<0.1%	OVC65% BKN17% FEW13% Top: OVC	—
sky_base_2_ft	decimal	—	93.8%110,770 values	230.3%	3300.0039% 4000.0028% 3000.0019% Other (11) Top: 3300.00 · 71 more values	Median 3300.00P25 3000.00 · P75 4000.00
sky_cover_3	string	—	99.9%118,009 values	42.9%	BKN47% OVC46% FEW5% Top: BKN	—
sky_base_3_ft	decimal	—	99.9%118,009 values	64.4%	3300.0045% 4000.0042% 2600.005% Top: 3300.00	Median 3300.00P25 3300.00 · P75 4000.00
sky_cover_4	string	—	100.0%118,146 values	00.0%	No distribution published No distribution published	—

Show 17 more columns

Verified column analytics for reports_zspd
sky_base_4_ft	decimal	—	100.0%118,146 values	00.0%	No distribution published No distribution published	—
visibility_miles	decimal	—	0.0%0 values	51<0.1%	6.2181% 3.114% 4.973% Other (39) Top: 6.21 · 1,325 more values	Median 6.21P25 6.21 · P75 6.21
weather_codes	string	—	82.0%96,928 values	500.2%	BR26% -SHRA24% -RA22% Other (38) Top: BR · 655 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%118,146 values	00.0%	No distribution published No distribution published	—
peak_wind_direction_degrees	decimal	—	100.0%118,146 values	00.0%	No distribution published No distribution published	—
peak_wind_time	string	—	100.0%118,146 values	00.0%	No distribution published No distribution published	—
snow_depth_inches	decimal	—	100.0%118,146 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	118,142100.0%	ZSPD 041300Z 17004MPS CAVOK 30/26 Q1007 NOSIG0% ZSPD 062100Z 20003MPS CAVOK 28/25 Q1005 NOSIG0% ZSPD 121700Z 18003MPS CAVOK 28/26 Q1005 NOSIG0% Other (118,130) Top: ZSPD 041300Z 17004MPS CAVOK 30/26 Q1007 NOSIG · 118,130 more values	—
cli_product	string	—	100.0%118,146 values	00.0%	No distribution published No distribution published	—
cli_high_f	integer	—	100.0%118,146 values	00.0%	No distribution published All-row histogram	—
cli_low_f	integer	—	100.0%118,146 values	00.0%	No distribution published All-row histogram	—
cli_report_type	string	—	100.0%118,146 values	00.0%	No distribution published No distribution published	—
metar_high_f	decimal	—	0.0%0 values	40<0.1%	69.804% 77.004% 82.404% Other (28) Top: 69.80 · 64,167 more values	Median 73.40P25 57.20 · P75 84.20
metar_low_f	decimal	—	0.0%0 values	38<0.1%	80.607% 78.805% 75.204% Other (26) Top: 80.60 · 60,572 more values	Median 59.00P25 44.60 · P75 73.40
metar_high_c	decimal	—	0.0%0 values	40<0.1%	21.04% 25.04% 28.04% Other (28) Top: 21.0 · 64,167 more values	Median 23.0P25 14.0 · P75 29.0
metar_low_c	decimal	—	0.0%0 values	38<0.1%	27.07% 26.05% 24.04% Other (26) Top: 27.0 · 60,572 more values	Median 15.0P25 7.0 · P75 23.0

Release status

Facts from the current passing release

Release: Passing
Rows: 118,146
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_zspd

reports_zspd

# Current release — the complete Parquet file
curl -sS -o reports-zspd.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/2665d6e8-179a-4373-aecb-0431101c9b67/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/2665d6e8-179a-4373-aecb-0431101c9b67/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/2665d6e8-179a-4373-aecb-0431101c9b67/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

Shanghai weather reports and daily highs since 2020

reports_zspd

Release status