Singapore weather reports and daily highs since 2020

Public

reports_wsss

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:36
Rows
118,585
across released Tables
Tables
1
released
Columns
37
reports_wsss
Version
reports_wsss

Data preview

reports_wsss
Preview rows for reports_wsss
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
WSSS2020-01-01T00:00:00.000000ZMETAR2020-01-0178.8026.075.2088.75350.003.0029.910FEW2000.00BKN16000.00
WSSS2020-01-01T00:30:00.000000ZSPECI2020-01-0178.8026.075.2088.75340.003.0029.940FEW2000.00BKN16000.00
WSSS2020-01-01T01:00:00.000000ZMETAR2020-01-0180.6027.075.2083.66340.003.0029.940FEW1800.00SCT16000.00BKN30000.00
WSSS2020-01-01T01:30:00.000000ZSPECI2020-01-0182.4028.075.2078.9010.003.0029.940FEW1800.00SCT16000.00BKN30000.00
WSSS2020-01-01T02:00:00.000000ZMETAR2020-01-0184.2029.075.2074.4420.006.0029.940FEW1800.00BKN30000.00
WSSS2020-01-01T02:30:00.000000ZSPECI2020-01-0186.0030.073.4066.1540.007.0029.940FEW1800.00BKN30000.00
WSSS2020-01-01T03:00:00.000000ZMETAR2020-01-0186.0030.075.2070.2730.007.0029.940FEW1800.00FEW2000.00BKN30000.00
WSSS2020-01-01T03:30:00.000000ZSPECI2020-01-0186.0030.071.6062.2530.009.0029.940FEW1800.00FEW2000.00BKN30000.00
WSSS2020-01-01T04:00:00.000000ZMETAR2020-01-0186.0030.073.4066.1540.0010.0029.940FEW1800.00SCT2000.00BKN30000.00
WSSS2020-01-01T04:30:00.000000ZSPECI2020-01-0187.8031.073.4062.4740.0013.0029.940FEW1800.00SCT2000.00BKN30000.00
A bounded preview of the immutable release.

Columns

Schema, units, meaning, and verified release profile

37 columns
Verified column analytics for reports_wsss
ColumnTypeUnitMissingDistinctDistributionSummary
stationstring0.0%0 values1<0.1%
  • WSSS100%

Top: WSSS

event_time_utctimestamp_utc0.0%0 values118,585100.0%
  • 2020-01-01 00:00:00+000%
  • 2020-01-01 00:30:00+000%
  • 2020-01-01 01:00:00+000%
  • Other (118,573)

Top: 2020-01-01 00:00:00+00 · 118,573 more values

observation_typestring0.0%0 values2<0.1%
  • SPECI51%
  • METAR49%

Top: SPECI

local_standard_datedate0.0%0 values2,4442.1%
  • 2023-12-250%
  • 2025-01-120%
  • 2026-02-170%
  • Other (2,432)

Top: 2023-12-25 · 117,916 more values

temp_fdecimal<0.1%1 values16<0.1%
  • 78.8017%
  • 80.6016%
  • 82.4016%
  • Other (4)

Top: 78.80 · 51 more values

Median 82.40P25 78.80 · P75 86.00
temp_cdecimal<0.1%1 values16<0.1%
  • 26.017%
  • 27.016%
  • 28.016%
  • Other (4)

Top: 26.0 · 51 more values

Median 28.0P25 26.0 · P75 30.0
dewpoint_fdecimal<0.1%1 values14<0.1%
  • 75.2036%
  • 77.0032%
  • 73.4017%
  • Other (2)

Top: 75.20 · 2 more values

Median 75.20P25 75.20 · P75 77.00
relative_humidity_pctdecimal<0.1%1 values1840.2%
  • 88.757%
  • 83.665%
  • 83.775%
  • Other (172)

Top: 88.75 · 58,669 more values

Median 83.55P25 74.44 · P75 88.75
wind_direction_degreesdecimal12.9%15,297 values38<0.1%
  • 340.009%
  • 360.008%
  • 350.008%
  • Other (26)

Top: 340.00 · 38,177 more values

Median 180.00P25 120.00 · P75 330.00
wind_speed_ktdecimal0.0%0 values24<0.1%
  • 3.0012%
  • 5.0012%
  • 4.0012%
  • Other (12)

Top: 3.00 · 6,420 more values

Median 5.00P25 3.00 · P75 8.00
wind_gust_ktdecimal99.4%117,904 values213.1%
  • 17.0015%
  • 18.0013%
  • 19.0011%
  • Other (9)

Top: 17.00 · 58 more values

Median 19.00P25 17.00 · P75 22.00
altimeter_inhgdecimal<0.1%4 values25<0.1%
  • 29.80021%
  • 29.83021%
  • 29.85016%
  • Other (13)

Top: 29.800 · 137 more values

Median 29.800P25 29.770 · P75 29.850
sea_level_pressure_hpadecimal100.0%118,582 values3100.0%
  • 1009.7033%
  • 1010.7033%
  • 1011.3033%

Top: 1009.70

Median 1010.70P25 1009.70 · P75 1011.30
sky_cover_1string0.2%216 values3<0.1%
  • FEW93%
  • SCT7%
  • BKN0%

Top: FEW

sky_base_1_ftdecimal0.2%216 values20<0.1%
  • 1800.0046%
  • 1600.0022%
  • 2000.0013%
  • Other (8)

Top: 1800.00 · 223 more values

Median 1800.00P25 1600.00 · P75 1800.00
sky_cover_2string0.2%233 values4<0.1%
  • BKN57%
  • FEW23%
  • SCT20%

Top: BKN

sky_base_2_ftdecimal0.2%233 values39<0.1%
  • 30000.0036%
  • 16000.0011%
  • 15000.0010%
  • Other (27)

Top: 30000.00 · 11,291 more values

Median 16000.00P25 2200.00 · P75 30000.00
sky_cover_3string62.2%73,790 values4<0.1%
  • BKN65%
  • SCT22%
  • FEW12%

Top: BKN

sky_base_3_ftdecimal62.2%73,790 values37<0.1%
  • 30000.0044%
  • 15000.008%
  • 16000.008%
  • Other (25)

Top: 30000.00 · 4,348 more values

Median 27000.00P25 7000.00 · P75 30000.00
sky_cover_4string93.7%111,167 values4<0.1%
  • BKN61%
  • SCT36%
  • OVC3%

Top: BKN

Show 17 more columns
Verified column analytics for reports_wsss
sky_base_4_ftdecimal93.7%111,167 values290.4%
  • 30000.0033%
  • 15000.0016%
  • 16000.0013%
  • Other (17)

Top: 30000.00 · 289 more values

Median 16000.00P25 14000.00 · P75 30000.00
visibility_milesdecimal<0.1%5 values25<0.1%
  • 6.2184%
  • 4.974%
  • 5.594%
  • Other (13)

Top: 6.21 · 374 more values

Median 6.21P25 6.21 · P75 6.21
weather_codesstring85.7%101,577 values210.1%
  • -RA29%
  • -SHRA20%
  • VCSH12%
  • Other (9)

Top: -RA · 543 more values

precipitation_in_1hdecimal<0.1%3 values1<0.1%
  • 0.000100%

Top: 0.000

Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_ktdecimal100.0%118,585 values00.0%

No distribution published

No distribution published

peak_wind_direction_degreesdecimal100.0%118,585 values00.0%

No distribution published

No distribution published

peak_wind_timestring100.0%118,585 values00.0%

No distribution published

No distribution published

snow_depth_inchesdecimal100.0%118,585 values00.0%

No distribution published

No distribution published

raw_metarstring0.0%0 values118,49899.9%
  • WSSS 012100Z VRB02KT 9999 FEW018 BKN300 26/24 Q1009 NOSIG0%
  • WSSS 012000Z 32002KT 9999 FEW018 BKN300 26/24 Q1008 NOSIG0%
  • WSSS 012300Z VRB02KT 9999 FEW018 BKN300 25/23 Q1010 NOSIG0%
  • Other (118,486)

Top: WSSS 012100Z VRB02KT 9999 FEW018 BKN300 26/24 Q1009 NOSIG · 118,560 more values

cli_productstring100.0%118,585 values00.0%

No distribution published

No distribution published

cli_high_finteger100.0%118,585 values00.0%

No distribution published

All-row histogram

cli_low_finteger100.0%118,585 values00.0%

No distribution published

All-row histogram

cli_report_typestring100.0%118,585 values00.0%

No distribution published

No distribution published

metar_high_fdecimal0.0%0 values12<0.1%
  • 89.6031%
  • 87.8025%
  • 91.4015%

Top: 89.60

Median 87.80P25 86.00 · P75 89.60
metar_low_fdecimal0.0%0 values8<0.1%
  • 77.0033%
  • 78.8025%
  • 75.2018%

Top: 77.00

Median 77.00P25 77.00 · P75 78.80
metar_high_cdecimal0.0%0 values12<0.1%
  • 32.031%
  • 31.025%
  • 33.015%

Top: 32.0

Median 31.0P25 30.0 · P75 32.0
metar_low_cdecimal0.0%0 values8<0.1%
  • 25.033%
  • 26.025%
  • 24.018%

Top: 25.0

Median 25.0P25 25.0 · P75 26.0

Release status

Facts from the current passing release

Release
Passing
Rows
118,585
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_wsss
reports_wsss
# Current release — the complete Parquet file
curl -sS -o reports-wsss.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/f3016be6-29f4-47ba-8b50-8a272879b982/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/f3016be6-29f4-47ba-8b50-8a272879b982/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/f3016be6-29f4-47ba-8b50-8a272879b982/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