reports_yssy

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:36

Rows: 125,851; across released Tables
Tables: 1; released
Columns: 37; reports_yssy
Version: —; reports_yssy

Data preview

reports_yssy

Preview rows for reports_yssy
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
YSSY	2020-01-01T00:00:00.000000Z	METAR	2020-01-01	71.60	22.0	59.00	64.48	180.00	10.00	—	29.940	—	FEW	2000.00	BKN	2100.00	—	—	—
YSSY	2020-01-01T00:30:00.000000Z	SPECI	2020-01-01	71.60	22.0	59.00	64.48	170.00	10.00	—	29.940	—	FEW	1800.00	BKN	2100.00	—	—	—
YSSY	2020-01-01T01:00:00.000000Z	METAR	2020-01-01	71.60	22.0	59.00	64.48	170.00	11.00	—	29.940	—	FEW	2000.00	SCT	2400.00	—	—	—
YSSY	2020-01-01T01:30:00.000000Z	SPECI	2020-01-01	73.40	23.0	60.80	64.69	160.00	10.00	—	29.910	—	SCT	2400.00	—	—	—	—	—
YSSY	2020-01-01T02:00:00.000000Z	METAR	2020-01-01	75.20	24.0	59.00	57.12	130.00	13.00	—	29.910	—	SCT	2800.00	—	—	—	—	—
YSSY	2020-01-01T02:30:00.000000Z	SPECI	2020-01-01	77.00	25.0	62.60	61.13	120.00	14.00	—	29.910	—	SCT	2800.00	—	—	—	—	—
YSSY	2020-01-01T03:00:00.000000Z	METAR	2020-01-01	77.00	25.0	62.60	61.13	140.00	13.00	—	29.910	—	SCT	2500.00	SCT	3000.00	—	—	—
YSSY	2020-01-01T03:30:00.000000Z	SPECI	2020-01-01	78.80	26.0	62.60	57.60	130.00	15.00	—	29.910	—	FEW	2500.00	BKN	3000.00	—	—	—
YSSY	2020-01-01T04:00:00.000000Z	METAR	2020-01-01	75.20	24.0	60.80	60.90	130.00	15.00	—	29.910	—	SCT	2400.00	BKN	3000.00	—	—	—
YSSY	2020-01-01T04:30:00.000000Z	SPECI	2020-01-01	75.20	24.0	62.60	64.91	130.00	16.00	—	29.910	—	SCT	2200.00	BKN	2500.00	—	—	—

Columns

Schema, units, meaning, and verified release profile

37 columns

Verified column analytics for reports_yssy
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	YSSY100% Top: YSSY	—
event_time_utc	timestamp_utc	—	0.0%0 values	125,851100.0%	2020-01-01 00:00:00+000% 2020-01-01 00:30:00+000% 2020-01-01 01:00:00+000% Other (125,839) Top: 2020-01-01 00:00:00+00 · 125,839 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	SPECI54% METAR46% Top: SPECI	—
local_standard_date	date	—	0.0%0 values	2,4441.9%	2024-09-260% 2025-01-170% 2025-03-300% Other (2,432) Top: 2024-09-26 · 124,764 more values	—
temp_f	decimal	—	<0.1%22 values	39<0.1%	69.808% 68.008% 66.208% Other (27) Top: 69.80 · 27,637 more values	Median 66.20P25 59.00 · P75 71.60
temp_c	decimal	—	<0.1%22 values	39<0.1%	21.08% 20.08% 19.08% Other (27) Top: 21.0 · 27,637 more values	Median 19.0P25 15.0 · P75 22.0
dewpoint_f	decimal	—	<0.1%24 values	37<0.1%	60.807% 59.007% 57.206% Other (25) Top: 60.80 · 36,778 more values	Median 55.40P25 46.40 · P75 62.60
relative_humidity_pct	decimal	—	<0.1%24 values	1,2581.0%	100.001% 93.651% 93.741% Other (1,246) Top: 100.00 · 112,195 more values	Median 72.38P25 58.02 · P75 83.21
wind_direction_degrees	decimal	—	<0.1%68 values	37<0.1%	30.005% 170.005% 310.005% Other (25) Top: 30.00 · 67,468 more values	Median 190.00P25 110.00 · P75 290.00
wind_speed_kt	decimal	—	<0.1%61 values	45<0.1%	7.0010% 6.008% 5.008% Other (33) Top: 7.00 · 31,594 more values	Median 10.00P25 7.00 · P75 15.00
wind_gust_kt	decimal	—	95.7%120,483 values	420.8%	29.008% 30.008% 31.008% Other (30) Top: 29.00 · 1,291 more values	Median 31.00P25 28.00 · P75 35.00
altimeter_inhg	decimal	—	<0.1%31 values	65<0.1%	30.0005% 30.0305% 30.0605% Other (53) Top: 30.000 · 54,823 more values	Median 30.030P25 29.880 · P75 30.180
sea_level_pressure_hpa	decimal	—	100.0%125,851 values	00.0%	No distribution published No distribution published	—
sky_cover_1	string	—	26.4%33,174 values	6<0.1%	FEW55% SCT18% NCD15% Top: FEW	—
sky_base_1_ft	decimal	—	38.1%47,954 values	1130.1%	3000.0010% 2500.007% 2000.007% Other (101) Top: 3000.00 · 30,286 more values	Median 2500.00P25 1500.00 · P75 3500.00
sky_cover_2	string	—	56.1%70,582 values	4<0.1%	BKN49% SCT45% OVC6% Top: BKN	—
sky_base_2_ft	decimal	—	56.1%70,582 values	1410.3%	3000.005% 2500.005% 2000.004% Other (129) Top: 3000.00 · 29,817 more values	Median 4000.00P25 2500.00 · P75 6400.00
sky_cover_3	string	—	77.2%97,133 values	4<0.1%	BKN88% OVC10% FEW2% Top: BKN	—
sky_base_3_ft	decimal	—	77.2%97,133 values	1310.5%	4000.006% 3000.006% 5000.006% Other (119) Top: 4000.00 · 14,991 more values	Median 5000.00P25 3500.00 · P75 8000.00
sky_cover_4	string	—	99.1%124,773 values	30.3%	FEW85% SCT14% BKN1% Top: FEW	—

Show 17 more columns

Verified column analytics for reports_yssy
sky_base_4_ft	decimal	—	99.1%124,773 values	373.4%	3000.0016% 5000.0013% 4000.0013% Other (25) Top: 3000.00 · 89 more values	Median 4400.00P25 3000.00 · P75 6000.00
visibility_miles	decimal	—	0.2%282 values	59<0.1%	6.2192% 3.732% 5.591% Other (47) Top: 6.21 · 752 more values	Median 6.21P25 6.21 · P75 6.21
weather_codes	string	—	79.0%99,454 values	1320.5%	-SHRA28% VCSH27% -RA11% Other (120) Top: -SHRA · 2,455 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%125,851 values	00.0%	No distribution published No distribution published	—
peak_wind_direction_degrees	decimal	—	100.0%125,851 values	00.0%	No distribution published No distribution published	—
peak_wind_time	string	—	100.0%125,851 values	00.0%	No distribution published No distribution published	—
snow_depth_inches	decimal	—	100.0%125,851 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	125,851100.0%	YSSY 010000Z 01005KT 360V060 9999 FEW034 19/09 Q1023 RF00.0/000.00% YSSY 010000Z 02013KT 9999 SCT022 25/18 Q10110% YSSY 010000Z 02014KT 9999 FEW030 27/17 Q1013 NOSIG0% Other (125,839) Top: YSSY 010000Z 01005KT 360V060 9999 FEW034 19/09 Q1023 RF00.0/000.0 · 125,839 more values	—
cli_product	string	—	100.0%125,851 values	00.0%	No distribution published No distribution published	—
cli_high_f	integer	—	100.0%125,851 values	00.0%	No distribution published All-row histogram	—
cli_low_f	integer	—	100.0%125,851 values	00.0%	No distribution published All-row histogram	—
cli_report_type	string	—	100.0%125,851 values	00.0%	No distribution published No distribution published	—
metar_high_f	decimal	—	0.0%0 values	32<0.1%	71.608% 73.407% 69.807% Other (20) Top: 71.60 · 26,047 more values	Median 71.60P25 66.20 · P75 78.80
metar_low_f	decimal	—	0.0%0 values	21<0.1%	66.208% 68.008% 64.408% Other (9) Top: 66.20 · 23,176 more values	Median 59.00P25 51.80 · P75 66.20
metar_high_c	decimal	—	0.0%0 values	32<0.1%	22.08% 23.07% 21.07% Other (20) Top: 22.0 · 26,047 more values	Median 22.0P25 19.0 · P75 26.0
metar_low_c	decimal	—	0.0%0 values	21<0.1%	19.08% 20.08% 18.08% Other (9) Top: 19.0 · 23,176 more values	Median 15.0P25 11.0 · P75 19.0

Release status

Facts from the current passing release

Release: Passing
Rows: 125,851
Columns: 37
Published: 9 Sept 2026, 06:36
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_yssy

reports_yssy

# Current release — the complete Parquet file
curl -sS -o reports-yssy.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/1da2e49c-e160-463b-8bcc-a6657e1a5b7d/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/1da2e49c-e160-463b-8bcc-a6657e1a5b7d/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/1da2e49c-e160-463b-8bcc-a6657e1a5b7d/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

Sydney weather reports and daily highs since 2020

reports_yssy

Release status