reports_nzwn

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:38

Rows: 117,183; across released Tables
Tables: 1; released
Columns: 37; reports_nzwn
Version: —; reports_nzwn

Data preview

reports_nzwn

Preview rows for reports_nzwn
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
NZWN	2020-01-01T00:00:00.000000Z	METAR	2020-01-01	66.20	19.0	57.20	72.74	10.00	23.00	—	29.970	—	BKN	1800.00	—	—	—	—	—
NZWN	2020-01-01T00:30:00.000000Z	SPECI	2020-01-01	68.00	20.0	57.20	68.35	360.00	28.00	—	29.940	—	BKN	1900.00	—	—	—	—	—
NZWN	2020-01-01T01:00:00.000000Z	METAR	2020-01-01	68.00	20.0	57.20	68.35	10.00	26.00	—	29.940	—	SCT	2100.00	—	—	—	—	—
NZWN	2020-01-01T01:30:00.000000Z	SPECI	2020-01-01	68.00	20.0	59.00	72.92	10.00	24.00	—	29.940	—	FEW	2000.00	—	—	—	—	—
NZWN	2020-01-01T02:00:00.000000Z	METAR	2020-01-01	68.00	20.0	59.00	72.92	10.00	26.00	—	29.940	—	SCT	1900.00	—	—	—	—	—
NZWN	2020-01-01T02:30:00.000000Z	SPECI	2020-01-01	66.20	19.0	57.20	72.74	10.00	26.00	—	29.940	—	BKN	1800.00	—	—	—	—	—
NZWN	2020-01-01T03:00:00.000000Z	METAR	2020-01-01	68.00	20.0	59.00	72.92	360.00	25.00	—	29.940	—	BKN	1800.00	—	—	—	—	—
NZWN	2020-01-01T03:30:00.000000Z	SPECI	2020-01-01	66.20	19.0	57.20	72.74	360.00	25.00	—	29.940	—	BKN	1800.00	—	—	—	—	—
NZWN	2020-01-01T04:00:00.000000Z	METAR	2020-01-01	64.40	18.0	57.20	77.45	360.00	25.00	—	29.940	—	BKN	1800.00	—	—	—	—	—
NZWN	2020-01-01T04:30:00.000000Z	SPECI	2020-01-01	64.40	18.0	57.20	77.45	360.00	24.00	—	29.940	—	BKN	1800.00	—	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

37 columns

Verified column analytics for reports_nzwn
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	NZWN100% Top: NZWN	—
event_time_utc	timestamp_utc	—	0.0%0 values	117,183100.0%	2020-01-01 00:00:00+000% 2020-01-01 00:30:00+000% 2020-01-01 01:00:00+000% Other (117,171) Top: 2020-01-01 00:00:00+00 · 117,171 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%	2020-01-020% 2020-01-030% 2020-01-040% Other (2,432) Top: 2020-01-02 · 116,607 more values	—
temp_f	decimal	—	<0.1%26 values	28<0.1%	57.2011% 59.0010% 55.4010% Other (16) Top: 57.20 · 11,992 more values	Median 57.20P25 53.60 · P75 62.60
temp_c	decimal	—	<0.1%26 values	28<0.1%	14.011% 15.010% 13.010% Other (16) Top: 14.0 · 11,992 more values	Median 14.0P25 12.0 · P75 17.0
dewpoint_f	decimal	—	<0.1%26 values	26<0.1%	50.0010% 51.8010% 48.2010% Other (14) Top: 50.00 · 11,495 more values	Median 50.00P25 46.40 · P75 55.40
relative_humidity_pct	decimal	—	<0.1%26 values	5120.4%	100.003% 76.822% 82.122% Other (500) Top: 100.00 · 94,741 more values	Median 77.15P25 70.67 · P75 87.28
wind_direction_degrees	decimal	—	<0.1%1 values	37<0.1%	360.0013% 10.0012% 350.009% Other (25) Top: 360.00 · 18,221 more values	Median 180.00P25 30.00 · P75 340.00
wind_speed_kt	decimal	—	<0.1%1 values	53<0.1%	17.006% 10.005% 14.005% Other (41) Top: 17.00 · 49,331 more values	Median 13.00P25 8.00 · P75 18.00
wind_gust_kt	decimal	—	87.5%102,570 values	560.4%	31.008% 33.007% 30.006% Other (44) Top: 31.00 · 4,670 more values	Median 33.00P25 29.00 · P75 38.00
altimeter_inhg	decimal	—	<0.1%1 values	68<0.1%	29.9704% 30.1204% 30.0004% Other (56) Top: 29.970 · 60,442 more values	Median 30.000P25 29.800 · P75 30.180
sea_level_pressure_hpa	decimal	—	100.0%117,183 values	00.0%	No distribution published No distribution published	—
sky_cover_1	string	—	<0.1%111 values	7<0.1%	NCD35% BKN24% FEW19% Top: NCD	—
sky_base_1_ft	decimal	—	35.0%40,987 values	60<0.1%	1900.004% 2000.004% 2100.004% Other (48) Top: 1900.00 · 42,169 more values	Median 2300.00P25 1700.00 · P75 3300.00
sky_cover_2	string	—	71.1%83,334 values	4<0.1%	BKN65% OVC19% SCT16% Top: BKN	—
sky_base_2_ft	decimal	—	71.1%83,336 values	550.2%	2600.004% 2900.004% 6000.004% Other (43) Top: 2600.00 · 20,581 more values	Median 3300.00P25 2500.00 · P75 4700.00
sky_cover_3	string	—	88.0%103,160 values	3<0.1%	BKN55% OVC45% ///0% Top: BKN	—
sky_base_3_ft	decimal	—	88.0%103,168 values	500.4%	6000.007% 5500.006% 5000.006% Other (38) Top: 6000.00 · 7,441 more values	Median 4600.00P25 3500.00 · P75 6000.00
sky_cover_4	string	—	100.0%117,167 values	16.3%	///100% Top: ///	—

Show 17 more columns

Verified column analytics for reports_nzwn
sky_base_4_ft	decimal	—	100.0%117,183 values	00.0%	No distribution published No distribution published	—
visibility_miles	decimal	—	<0.1%69 values	62<0.1%	6.2191% 5.591% 4.971% Other (50) Top: 6.21 · 3,049 more values	Median 6.21P25 6.21 · P75 6.21
weather_codes	string	—	87.9%102,978 values	750.5%	-RA54% -RA HZ10% -RA BR6% Other (63) Top: -RA · 779 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%117,183 values	00.0%	No distribution published No distribution published	—
peak_wind_direction_degrees	decimal	—	100.0%117,183 values	00.0%	No distribution published No distribution published	—
peak_wind_time	string	—	100.0%117,183 values	00.0%	No distribution published No distribution published	—
snow_depth_inches	decimal	—	100.0%117,183 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	117,182100.0%	NZWN 081430Z AUTO 04004KT 9999 NCD 06/05 Q10110% COR NZWN 010500Z AUTO 24003KT 9999 NCD 11/08 Q1037 BECMG FM0600 34010KT0% COR NZWN 010500Z AUTO 35022G36KT 9999 VCSH BKN027/// BKN037/// 17/13 Q0993 TEMPO 4000 +SHRA SCT020CB0% Other (117,170) Top: NZWN 081430Z AUTO 04004KT 9999 NCD 06/05 Q1011 · 117,170 more values	—
cli_product	string	—	100.0%117,183 values	00.0%	No distribution published No distribution published	—
cli_high_f	integer	—	100.0%117,183 values	00.0%	No distribution published All-row histogram	—
cli_low_f	integer	—	100.0%117,183 values	00.0%	No distribution published All-row histogram	—
cli_report_type	string	—	100.0%117,183 values	00.0%	No distribution published No distribution published	—
metar_high_f	decimal	—	0.0%0 values	22<0.1%	60.8011% 62.6011% 59.0010% Other (10) Top: 60.80 · 10,796 more values	Median 62.60P25 57.20 · P75 68.00
metar_low_f	decimal	—	0.0%0 values	20<0.1%	57.2011% 55.4010% 51.8010% Other (8) Top: 57.20 · 11,644 more values	Median 53.60P25 48.20 · P75 57.20
metar_high_c	decimal	—	0.0%0 values	22<0.1%	16.011% 17.011% 15.010% Other (10) Top: 16.0 · 10,796 more values	Median 17.0P25 14.0 · P75 20.0
metar_low_c	decimal	—	0.0%0 values	20<0.1%	14.011% 13.010% 11.010% Other (8) Top: 14.0 · 11,644 more values	Median 12.0P25 9.0 · P75 14.0

Release status

Facts from the current passing release

Release: Passing
Rows: 117,183
Columns: 37
Published: 9 Sept 2026, 06:38
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_nzwn

reports_nzwn

# Current release — the complete Parquet file
curl -sS -o reports-nzwn.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/2022acaa-44e0-410e-a65f-1f1e37002ac4/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/2022acaa-44e0-410e-a65f-1f1e37002ac4/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/2022acaa-44e0-410e-a65f-1f1e37002ac4/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

Wellington weather reports and daily highs since 2020

reports_nzwn

Release status