reports_ksan

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:31

Rows: 73,288; across released Tables
Tables: 1; released
Columns: 34; reports_ksan
Version: —; reports_ksan

Data preview

reports_ksan

Preview rows for reports_ksan
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
KSAN	2020-01-01T08:51:00.000000Z	METAR	2020-01-01	50.00	42.00	74.15	270.00	3.00	—	30.080	1018.60	CLR	—	—	—	—	—	—	—
KSAN	2020-01-01T09:51:00.000000Z	METAR	2020-01-01	50.00	43.00	76.76	0.00	0.00	—	30.060	1017.90	CLR	—	—	—	—	—	—	—
KSAN	2020-01-01T10:51:00.000000Z	METAR	2020-01-01	50.00	41.00	71.07	0.00	0.00	—	30.080	1018.40	CLR	—	—	—	—	—	—	—
KSAN	2020-01-01T11:51:00.000000Z	METAR	2020-01-01	48.00	41.00	76.58	0.00	0.00	—	30.090	1018.90	CLR	—	—	—	—	—	—	—
KSAN	2020-01-01T12:51:00.000000Z	METAR	2020-01-01	46.00	39.00	76.40	360.00	3.00	—	30.080	1018.60	CLR	—	—	—	—	—	—	—
KSAN	2020-01-01T13:51:00.000000Z	METAR	2020-01-01	47.00	38.00	70.73	0.00	0.00	—	30.080	1018.50	FEW	25000.00	—	—	—	—	—	—
KSAN	2020-01-01T14:51:00.000000Z	METAR	2020-01-01	52.00	34.00	50.12	0.00	0.00	—	30.100	1019.10	FEW	2000.00	BKN	16000.00	—	—	—	—
KSAN	2020-01-01T15:51:00.000000Z	METAR	2020-01-01	53.00	37.00	54.21	0.00	0.00	—	30.100	1019.10	SCT	16000.00	—	—	—	—	—	—
KSAN	2020-01-01T16:51:00.000000Z	METAR	2020-01-01	59.00	39.00	47.35	—	4.00	—	30.110	1019.50	SCT	16000.00	BKN	25000.00	—	—	—	—
KSAN	2020-01-01T17:51:00.000000Z	METAR	2020-01-01	63.00	34.00	33.72	160.00	4.00	—	30.080	1018.70	SCT	16000.00	BKN	25000.00	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

34 columns

Verified column analytics for reports_ksan
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	KSAN100% Top: KSAN	—
event_time_utc	timestamp_utc	—	0.0%0 values	73,288100.0%	2020-01-01 08:51:00+000% 2020-01-01 09:51:00+000% 2020-01-01 10:51:00+000% Other (73,276) Top: 2020-01-01 08:51:00+00 · 73,276 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	METAR80% SPECI20% Top: METAR	—
local_standard_date	date	—	0.0%0 values	2,4433.3%	2021-12-140% 2024-01-220% 2024-12-190% Other (2,431) Top: 2021-12-14 · 72,489 more values	—
temp_f	decimal	—	<0.1%4 values	820.1%	63.005% 62.005% 61.005% Other (70) Top: 63.00 · 31,003 more values	Median 64.00P25 59.00 · P75 69.00
dewpoint_f	decimal	—	<0.1%4 values	1100.2%	55.005% 54.005% 56.005% Other (98) Top: 55.00 · 32,251 more values	Median 55.00P25 50.00 · P75 60.00
relative_humidity_pct	decimal	—	<0.1%4 values	3,2614.4%	100.001% 77.720% 81.270% Other (3,249) Top: 100.00 · 69,156 more values	Median 75.03P25 65.56 · P75 83.67
wind_direction_degrees	decimal	—	6.7%4,937 values	37<0.1%	0.0024% 300.009% 290.007% Other (25) Top: 0.00 · 19,147 more values	Median 220.00P25 10.00 · P75 300.00
wind_speed_kt	decimal	—	<0.1%27 values	26<0.1%	0.0023% 3.0015% 4.0014% Other (14) Top: 0.00 · 785 more values	Median 4.00P25 3.00 · P75 7.00
wind_gust_kt	decimal	—	93.7%68,673 values	260.6%	17.0015% 18.0015% 16.0014% Other (14) Top: 17.00 · 269 more values	Median 18.00P25 17.00 · P75 20.00
altimeter_inhg	decimal	—	<0.1%7 values	970.1%	29.9604% 29.9704% 29.9804% Other (85) Top: 29.960 · 39,708 more values	Median 29.990P25 29.930 · P75 30.070
sea_level_pressure_hpa	decimal	—	20.0%14,687 values	2860.5%	1014.501% 1014.701% 1014.601% Other (274) Top: 1014.50 · 49,891 more values	Median 1015.50P25 1013.40 · P75 1018.10
sky_cover_1	string	—	<0.1%11 values	6<0.1%	FEW35% BKN21% SCT18% Top: FEW	—
sky_base_1_ft	decimal	—	8.7%6,369 values	830.1%	25000.007% 1000.006% 1500.006% Other (71) Top: 25000.00 · 30,855 more values	Median 1500.00P25 1000.00 · P75 2500.00
sky_cover_2	string	—	60.4%44,257 values	4<0.1%	BKN49% SCT24% FEW16% Top: BKN	—
sky_base_2_ft	decimal	—	60.4%44,257 values	780.3%	25000.0023% 20000.008% 5000.006% Other (66) Top: 25000.00 · 12,644 more values	Median 6000.00P25 3000.00 · P75 22000.00
sky_cover_3	string	—	86.8%63,615 values	4<0.1%	BKN56% OVC27% SCT16% Top: BKN	—
sky_base_3_ft	decimal	—	86.8%63,615 values	720.7%	25000.0020% 20000.0011% 6000.004% Other (60) Top: 25000.00 · 4,050 more values	Median 8000.00P25 4300.00 · P75 20000.00
sky_cover_4	string	—	99.7%73,039 values	31.2%	BKN65% SCT30% OVC5% Top: BKN	—
sky_base_4_ft	decimal	—	99.7%73,039 values	114.4%	25000.0065% 20000.0021% 15000.005% Top: 25000.00	Median 25000.00P25 20000.00 · P75 25000.00

Show 14 more columns

Verified column analytics for reports_ksan
visibility_miles	decimal	—	<0.1%7 values	19<0.1%	10.0076% 9.005% 8.003% Other (7) Top: 10.00 · 1,589 more values	Median 10.00P25 10.00 · P75 10.00
weather_codes	string	—	86.2%63,173 values	340.3%	BR53% FG11% -RA BR11% Other (22) Top: BR · 67 more values	—
precipitation_in_1h	decimal	—	3.1%2,237 values	51<0.1%	0.00097% 0.0101% 0.0201% Other (39) Top: 0.000 · 353 more values	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt	decimal	—	99.2%72,719 values	173.0%	27.0026% 26.0020% 28.0013% Other (5) Top: 27.00 · 14 more values	Median 28.00P25 27.00 · P75 31.00
peak_wind_direction_degrees	decimal	—	99.2%72,719 values	305.3%	280.0013% 160.0012% 170.0012% Other (18) Top: 280.00 · 85 more values	Median 200.00P25 170.00 · P75 270.00
peak_wind_time	string	—	99.2%72,719 values	39168.7%	2021-12-14 20:532% 2021-12-14 19:042% 2021-12-14 18:101% Other (379) Top: 2021-12-14 20:53 · 491 more values	—
snow_depth_inches	decimal	—	100.0%73,288 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	73,288100.0%	KSAN 010003Z 20005KT 4SM BR BKN003 17/16 A3005 RMK AO2 VIS SW-W 1 1/2 NW 2 FG BANK SW-NW T016701560% KSAN 010004Z 24010G21KT 10SM BKN022 BKN250 19/12 A2990 RMK AO2 T018901220% KSAN 010004Z 30007KT 10SM BKN023 22/14 A2991 RMK AO2 T021701440% Other (73,276) Top: KSAN 010003Z 20005KT 4SM BR BKN003 17/16 A3005 RMK AO2 VIS SW-W 1 1/2 NW 2 FG BANK SW-NW T01670156 · 73,276 more values	—
cli_product	string	—	<0.1%38 values	1<0.1%	CLISAN100% Top: CLISAN	—
cli_high_f	integer	—	<0.1%68 values	43<0.1%	56100 All-row histogram	Median 70P25 66 · P75 75
cli_low_f	integer	—	<0.1%68 values	40<0.1%	3878 All-row histogram	Median 59P25 52 · P75 65
cli_report_type	string	—	<0.1%38 values	2<0.1%	final96% correction4% Top: final	—
metar_high_f	decimal	—	0.0%0 values	52<0.1%	66.006% 67.006% 63.005% Other (40) Top: 66.00 · 26,713 more values	Median 70.00P25 65.00 · P75 75.00
metar_low_f	decimal	—	0.0%0 values	56<0.1%	62.005% 66.005% 59.004% Other (44) Top: 62.00 · 38,436 more values	Median 59.00P25 53.00 · P75 65.00

Release status

Facts from the current passing release

Release: Passing
Rows: 73,288
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_ksan

reports_ksan

# Current release — the complete Parquet file
curl -sS -o reports-ksan.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/b30066f1-b80c-48dc-b858-3643f6fd39eb/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/b30066f1-b80c-48dc-b858-3643f6fd39eb/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/b30066f1-b80c-48dc-b858-3643f6fd39eb/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

San Diego weather reports and daily highs since 2020

reports_ksan

Release status