reports_ksea

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:31

Rows: 72,412; across released Tables
Tables: 1; released
Columns: 34; reports_ksea
Version: —; reports_ksea

Data preview

reports_ksea

Preview rows for reports_ksea
station	event_time_utc	observation_type	local_standard_date	temp_f	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	sky_base_4_ft
KSEA	2020-01-01T08:12:00.000000Z	SPECI	2020-01-01	53.00	48.00	82.76	210.00	15.00	25.00	29.660	—	OVC	1500.00	—	—	—	—	—	—
KSEA	2020-01-01T08:53:00.000000Z	METAR	2020-01-01	53.00	48.00	82.76	220.00	24.00	29.00	29.660	1005.10	BKN	1500.00	—	—	—	—	—	—
KSEA	2020-01-01T09:53:00.000000Z	METAR	2020-01-01	52.00	47.00	82.68	220.00	15.00	24.00	29.680	1005.60	OVC	1500.00	—	—	—	—	—	—
KSEA	2020-01-01T10:53:00.000000Z	METAR	2020-01-01	52.00	47.00	82.68	220.00	16.00	26.00	29.660	1005.10	BKN	1500.00	BKN	12000.00	—	—	—	—
KSEA	2020-01-01T11:53:00.000000Z	METAR	2020-01-01	51.00	46.00	82.62	220.00	12.00	22.00	29.680	1005.70	BKN	1500.00	—	—	—	—	—	—
KSEA	2020-01-01T12:53:00.000000Z	METAR	2020-01-01	51.00	46.00	82.62	230.00	13.00	22.00	29.680	1005.80	BKN	1500.00	—	—	—	—	—	—
KSEA	2020-01-01T13:53:00.000000Z	METAR	2020-01-01	50.00	45.00	82.86	210.00	14.00	20.00	29.690	1006.20	BKN	1500.00	—	—	—	—	—	—
KSEA	2020-01-01T14:31:00.000000Z	SPECI	2020-01-01	51.00	45.00	79.54	230.00	9.00	17.00	29.710	—	SCT	1500.00	BKN	16000.00	—	—	—	—
KSEA	2020-01-01T14:53:00.000000Z	METAR	2020-01-01	51.00	44.00	76.86	240.00	11.00	18.00	29.720	1007.00	FEW	1500.00	BKN	7000.00	BKN	16000.00	—	—
KSEA	2020-01-01T15:45:00.000000Z	SPECI	2020-01-01	49.00	44.00	83.42	240.00	7.00	—	29.750	—	SCT	1100.00	BKN	1600.00	OVC	9500.00	—	—

Columns

Schema, units, meaning, and verified release profile

34 columns

Verified column analytics for reports_ksea
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	KSEA100% Top: KSEA	—
event_time_utc	timestamp_utc	—	0.0%0 values	72,410100.0%	2024-11-18 11:00:00+000% 2025-09-07 05:30:00+000% 2020-01-01 08:12:00+000% Other (72,398) Top: 2024-11-18 11:00:00+00 · 72,398 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	METAR81% SPECI19% Top: METAR	—
local_standard_date	date	—	0.0%0 values	2,4433.4%	2023-12-120% 2021-10-280% 2022-01-150% Other (2,431) Top: 2023-12-12 · 71,723 more values	—
temp_f	decimal	—	<0.1%24 values	1370.2%	47.004% 46.004% 50.004% Other (125) Top: 47.00 · 43,136 more values	Median 51.00P25 44.00 · P75 59.00
dewpoint_f	decimal	—	<0.1%29 values	1210.2%	39.004% 43.004% 41.004% Other (109) Top: 39.00 · 39,049 more values	Median 44.00P25 37.00 · P75 50.00
relative_humidity_pct	decimal	—	<0.1%29 values	3,3214.6%	100.002% 89.200% 85.770% Other (3,309) Top: 100.00 · 67,819 more values	Median 79.19P25 63.87 · P75 88.84
wind_direction_degrees	decimal	—	2.8%2,047 values	37<0.1%	0.008% 200.008% 210.007% Other (25) Top: 0.00 · 27,497 more values	Median 190.00P25 110.00 · P75 230.00
wind_speed_kt	decimal	—	0.2%118 values	30<0.1%	5.0012% 6.0012% 7.0011% Other (18) Top: 5.00 · 4,246 more values	Median 6.00P25 4.00 · P75 9.00
wind_gust_kt	decimal	—	91.8%66,488 values	340.6%	21.0010% 20.0010% 22.0010% Other (22) Top: 21.00 · 1,084 more values	Median 22.00P25 19.00 · P75 25.00
altimeter_inhg	decimal	—	<0.1%19 values	1770.2%	30.0603% 30.0702% 30.0502% Other (165) Top: 30.060 · 52,537 more values	Median 30.050P25 29.930 · P75 30.170
sea_level_pressure_hpa	decimal	—	19.5%14,124 values	5480.9%	1018.801% 1018.401% 1019.001% Other (536) Top: 1018.80 · 53,018 more values	Median 1018.30P25 1014.20 · P75 1022.30
sky_cover_1	string	—	<0.1%16 values	6<0.1%	FEW37% BKN21% SCT21% Top: FEW	—
sky_base_1_ft	decimal	—	8.0%5,811 values	790.1%	25000.006% 3000.004% 1500.004% Other (67) Top: 25000.00 · 40,394 more values	Median 2400.00P25 1100.00 · P75 4800.00
sky_cover_2	string	—	38.8%28,115 values	4<0.1%	BKN46% OVC26% SCT21% Top: BKN	—
sky_base_2_ft	decimal	—	38.8%28,115 values	800.2%	25000.009% 6000.004% 5000.004% Other (68) Top: 25000.00 · 27,146 more values	Median 4700.00P25 2500.00 · P75 10000.00
sky_cover_3	string	—	72.0%52,108 values	4<0.1%	OVC50% BKN42% SCT7% Top: OVC	—
sky_base_3_ft	decimal	—	72.0%52,108 values	830.4%	25000.0010% 20000.007% 6000.005% Other (71) Top: 25000.00 · 10,159 more values	Median 7000.00P25 4100.00 · P75 15000.00
sky_cover_4	string	—	98.5%71,351 values	30.3%	BKN82% OVC15% SCT3% Top: BKN	—
sky_base_4_ft	decimal	—	98.5%71,351 values	161.5%	25000.0031% 20000.0025% 22000.008% Other (4) Top: 25000.00 · 27 more values	Median 20000.00P25 19000.00 · P75 25000.00

Show 14 more columns

Verified column analytics for reports_ksea
visibility_miles	decimal	—	<0.1%18 values	20<0.1%	10.0078% 7.004% 6.002% Other (8) Top: 10.00 · 1,799 more values	Median 10.00P25 10.00 · P75 10.00
weather_codes	string	—	77.4%56,065 values	660.4%	-RA35% -RA BR23% BR15% Other (54) Top: -RA · 755 more values	—
precipitation_in_1h	decimal	—	9.4%6,803 values	39<0.1%	0.00086% 0.0105% 0.0203% Other (27) Top: 0.000 · 456 more values	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt	decimal	—	96.5%69,870 values	261.0%	26.0019% 27.0016% 28.0012% Other (14) Top: 26.00 · 151 more values	Median 29.00P25 27.00 · P75 32.00
peak_wind_direction_degrees	decimal	—	96.5%69,870 values	321.3%	210.0020% 200.0018% 220.0014% Other (20) Top: 210.00 · 234 more values	Median 200.00P25 190.00 · P75 220.00
peak_wind_time	string	—	96.5%69,870 values	2,09282.3%	2023-02-26 06:580% 2020-02-08 02:350% 2021-02-02 20:540% Other (2,080) Top: 2023-02-26 06:58 · 2,493 more values	—
snow_depth_inches	decimal	—	99.9%72,341 values	811.3%	1.0031% 2.0025% 3.0023% Top: 1.00	Median 2.00P25 1.00 · P75 3.00
raw_metar	string	—	0.0%0 values	72,412100.0%	KSEA 010000Z 18011G21KT 10SM SCT070 BKN090 OVC100 19/04 A2967 RMK AO2 WSHFT 2340 RAE2358 P0000 T018900440% KSEA 010005Z 36009KT 10SM FEW047 SCT065 BKN085 17/08 A2999 RMK AO2 WSHFT 2345 T017200830% KSEA 010013Z 11004KT 5SM -RA BKN026 OVC035 06/01 A2979 RMK AO2 P0001 T005600110% Other (72,400) Top: KSEA 010000Z 18011G21KT 10SM SCT070 BKN090 OVC100 19/04 A2967 RMK AO2 WSHFT 2340 RAE2358 P0000 T01890044 · 72,400 more values	—
cli_product	string	—	<0.1%63 values	1<0.1%	CLISEA100% Top: CLISEA	—
cli_high_f	integer	—	0.2%127 values	740.1%	22108 All-row histogram	Median 58P25 50 · P75 70
cli_low_f	integer	—	0.2%163 values	56<0.1%	1573 All-row histogram	Median 46P25 39 · P75 53
cli_report_type	string	—	<0.1%63 values	2<0.1%	final99% correction1% Top: final	—
metar_high_f	decimal	—	0.0%0 values	810.1%	50.005% 51.004% 49.004% Other (69) Top: 50.00 · 44,151 more values	Median 57.00P25 49.00 · P75 70.00
metar_low_f	decimal	—	0.0%0 values	780.1%	42.004% 41.004% 51.004% Other (66) Top: 42.00 · 40,293 more values	Median 46.00P25 39.00 · P75 54.00

Release status

Facts from the current passing release

Release: Passing
Rows: 72,412
Columns: 34
Published: 9 Sept 2026, 06:31
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_ksea

reports_ksea

# Current release — the complete Parquet file
curl -sS -o reports-ksea.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/bf090b93-e7d2-4d6f-878d-b3d870368acd/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/bf090b93-e7d2-4d6f-878d-b3d870368acd/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/bf090b93-e7d2-4d6f-878d-b3d870368acd/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

Seattle weather reports and daily highs since 2020

reports_ksea

Release status