reports_ksfo

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:31

Rows: 65,297; across released Tables
Tables: 1; released
Columns: 34; reports_ksfo
Version: —; reports_ksfo

Data preview

reports_ksfo

Preview rows for reports_ksfo
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
KSFO	2020-01-01T08:56:00.000000Z	METAR	2020-01-01	52.00	48.00	86.17	270.00	8.00	—	30.160	1021.30	FEW	800.00	FEW	1600.00	SCT	20000.00	—	—
KSFO	2020-01-01T09:56:00.000000Z	METAR	2020-01-01	50.00	48.00	92.80	280.00	9.00	—	30.170	1021.70	FEW	800.00	SCT	20000.00	—	—	—	—
KSFO	2020-01-01T10:56:00.000000Z	METAR	2020-01-01	49.00	47.00	92.77	200.00	5.00	—	30.140	1020.50	BKN	800.00	BKN	20000.00	—	—	—	—
KSFO	2020-01-01T11:41:00.000000Z	SPECI	2020-01-01	50.00	47.00	89.04	130.00	6.00	—	30.140	—	FEW	800.00	BKN	20000.00	—	—	—	—
KSFO	2020-01-01T11:56:00.000000Z	METAR	2020-01-01	50.00	47.00	89.04	120.00	5.00	—	30.130	1020.40	FEW	800.00	BKN	20000.00	—	—	—	—
KSFO	2020-01-01T12:56:00.000000Z	METAR	2020-01-01	50.00	45.00	82.86	190.00	4.00	—	30.140	1020.60	FEW	800.00	SCT	20000.00	—	—	—	—
KSFO	2020-01-01T13:56:00.000000Z	METAR	2020-01-01	47.00	45.00	93.06	290.00	3.00	—	30.140	1020.50	FEW	800.00	FEW	20000.00	—	—	—	—
KSFO	2020-01-01T14:35:00.000000Z	SPECI	2020-01-01	50.00	46.00	86.06	260.00	6.00	—	30.160	—	FEW	600.00	BKN	1100.00	—	—	—	—
KSFO	2020-01-01T14:44:00.000000Z	SPECI	2020-01-01	52.00	48.00	86.17	260.00	5.00	—	30.160	—	FEW	600.00	SCT	1100.00	BKN	20000.00	—	—
KSFO	2020-01-01T14:56:00.000000Z	METAR	2020-01-01	53.00	49.00	85.59	280.00	10.00	—	30.160	1021.30	FEW	600.00	SCT	1100.00	BKN	20000.00	—	—

Columns

Schema, units, meaning, and verified release profile

34 columns

Verified column analytics for reports_ksfo
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	KSFO100% Top: KSFO	—
event_time_utc	timestamp_utc	—	0.0%0 values	65,297100.0%	2020-01-01 08:56:00+000% 2020-01-01 09:56:00+000% 2020-01-01 10:56:00+000% Other (65,285) Top: 2020-01-01 08:56:00+00 · 65,285 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	METAR90% SPECI10% Top: METAR	—
local_standard_date	date	—	0.0%0 values	2,4433.7%	2025-01-060% 2020-01-250% 2022-01-040% Other (2,431) Top: 2025-01-06 · 64,733 more values	—
temp_f	decimal	—	<0.1%7 values	810.1%	56.006% 58.006% 55.006% Other (69) Top: 56.00 · 23,703 more values	Median 57.20P25 53.00 · P75 62.00
dewpoint_f	decimal	—	<0.1%7 values	750.1%	54.007% 53.007% 52.007% Other (63) Top: 54.00 · 19,684 more values	Median 50.00P25 45.00 · P75 54.00
relative_humidity_pct	decimal	—	<0.1%7 values	2,4853.8%	100.001% 86.291% 83.201% Other (2,473) Top: 100.00 · 60,561 more values	Median 76.67P25 65.35 · P75 83.59
wind_direction_degrees	decimal	—	0.8%525 values	37<0.1%	290.0013% 300.0011% 280.0011% Other (25) Top: 290.00 · 18,105 more values	Median 270.00P25 150.00 · P75 290.00
wind_speed_kt	decimal	—	<0.1%19 values	42<0.1%	0.009% 3.008% 4.008% Other (30) Top: 0.00 · 15,167 more values	Median 8.00P25 4.00 · P75 13.00
wind_gust_kt	decimal	—	88.1%57,497 values	480.6%	24.007% 26.007% 25.007% Other (36) Top: 24.00 · 2,134 more values	Median 25.00P25 22.00 · P75 29.00
altimeter_inhg	decimal	—	<0.1%10 values	1370.2%	30.0003% 29.9603% 29.9903% Other (125) Top: 30.000 · 42,353 more values	Median 30.010P25 29.920 · P75 30.110
sea_level_pressure_hpa	decimal	—	10.3%6,718 values	3880.7%	1015.801% 1015.401% 1014.501% Other (376) Top: 1015.80 · 52,026 more values	Median 1016.20P25 1013.30 · P75 1019.70
sky_cover_1	string	—	<0.1%12 values	6<0.1%	FEW71% CLR12% BKN7% Top: FEW	—
sky_base_1_ft	decimal	—	12.2%7,987 values	800.1%	600.0012% 20000.0010% 800.009% Other (68) Top: 600.00 · 17,251 more values	Median 900.00P25 600.00 · P75 2700.00
sky_cover_2	string	—	45.9%29,965 values	4<0.1%	BKN46% SCT28% FEW18% Top: BKN	—
sky_base_2_ft	decimal	—	45.9%29,965 values	770.2%	20000.0016% 18000.005% 1200.004% Other (65) Top: 20000.00 · 16,623 more values	Median 2600.00P25 1300.00 · P75 14000.00
sky_cover_3	string	—	79.2%51,745 values	4<0.1%	BKN53% OVC37% SCT10% Top: BKN	—
sky_base_3_ft	decimal	—	79.2%51,745 values	760.6%	20000.0019% 18000.007% 15000.004% Other (64) Top: 20000.00 · 6,742 more values	Median 6000.00P25 3000.00 · P75 18000.00
sky_cover_4	string	—	99.4%64,898 values	30.8%	BKN74% OVC22% SCT4% Top: BKN	—
sky_base_4_ft	decimal	—	99.4%64,898 values	61.5%	18000.0034% 20000.0032% 15000.0030% Top: 18000.00	Median 18000.00P25 15000.00 · P75 20000.00

Show 14 more columns

Verified column analytics for reports_ksfo
visibility_miles	decimal	—	<0.1%9 values	19<0.1%	10.0088% 9.004% 8.002% Other (7) Top: 10.00 · 350 more values	Median 10.00P25 10.00 · P75 10.00
weather_codes	string	—	92.3%60,270 values	350.7%	-RA33% BR19% -RA BR18% Other (23) Top: -RA · 105 more values	—
precipitation_in_1h	decimal	—	3.1%2,010 values	57<0.1%	0.00095% 0.0101% 0.0201% Other (45) Top: 0.000 · 373 more values	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt	decimal	—	89.0%58,112 values	400.6%	26.0018% 27.0015% 28.0013% Other (28) Top: 26.00 · 668 more values	Median 29.00P25 27.00 · P75 32.00
peak_wind_direction_degrees	decimal	—	89.0%58,112 values	360.5%	280.0024% 290.0021% 270.0014% Other (24) Top: 280.00 · 629 more values	Median 280.00P25 270.00 · P75 290.00
peak_wind_time	string	—	89.0%58,112 values	6,74593.9%	2025-12-27 00:070% 2020-01-16 16:580% 2021-11-09 07:000% Other (6,733) Top: 2025-12-27 00:07 · 7,127 more values	—
snow_depth_inches	decimal	—	100.0%65,297 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	65,297100.0%	KSFO 010001Z 30010KT 2SM RA BR SCT009 BKN013 OVC033 12/10 A2964 RMK AO2 P0001 T012201000% KSFO 010008Z 20013KT 2 1/2SM -RA BR FEW012 SCT018 OVC035 13/11 A2996 RMK AO2 P0001 T013301110% KSFO 010024Z 28014G22KT 2 1/2SM R28R/2000VP6000FT RA BR SCT009 BKN018 OVC029 12/11 A2997 RMK AO2 WSHFT 0010 P0008 T012201060% Other (65,285) Top: KSFO 010001Z 30010KT 2SM RA BR SCT009 BKN013 OVC033 12/10 A2964 RMK AO2 P0001 T01220100 · 65,285 more values	—
cli_product	string	—	0.2%110 values	1<0.1%	CLISFO100% Top: CLISFO	—
cli_high_f	integer	—	0.6%387 values	53<0.1%	47102 All-row histogram	Median 67P25 61 · P75 72
cli_low_f	integer	—	0.3%190 values	34<0.1%	3568 All-row histogram	Median 52P25 48 · P75 56
cli_report_type	string	—	0.2%110 values	2<0.1%	final99% correction1% Top: final	—
metar_high_f	decimal	—	0.0%0 values	60<0.1%	70.006% 62.005% 66.005% Other (48) Top: 70.00 · 26,992 more values	Median 66.00P25 60.00 · P75 71.00
metar_low_f	decimal	—	0.0%0 values	41<0.1%	55.009% 52.007% 58.007% Other (29) Top: 55.00 · 17,423 more values	Median 53.00P25 49.00 · P75 56.00

Release status

Facts from the current passing release

Release: Passing
Rows: 65,297
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_ksfo

reports_ksfo

# Current release — the complete Parquet file
curl -sS -o reports-ksfo.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/1b3cdb1e-256b-446b-b809-ce66260c762a/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/1b3cdb1e-256b-446b-b809-ce66260c762a/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/1b3cdb1e-256b-446b-b809-ce66260c762a/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 Francisco weather reports and daily highs since 2020

reports_ksfo

Release status