reports_ksfo

Release V4 publication snapshot

Current data

Latest passing release for each Table

Updated 4 Sept 2026, 09:28

Rows: 65,150; across released Tables
Tables: 1; released
Columns: 32; reports_ksfo
Version: V4 publication snapshot; 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	visibility_miles	weather_codes	precipitation_in_1h	peak_wind_gust_kt	peak_wind_direction_degrees	peak_wind_time	snow_depth_inches	raw_metar	cli_product	cli_high_f	cli_low_f	cli_report_type
KSFO	2020-01-01T00:00:00.000000Z	SPECI	2019-12-31	56.00	49.00	77.29	100.00	4.00	—	—	1019.50	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	METAR SFO 010000Z AUTO 10004KT 13/09 RMK AO2 SLP195 T01330094 IEM_GHCNH	—	—	—	—
KSFO	2020-01-01T00:56:00.000000Z	METAR	2019-12-31	55.00	44.00	66.61	320.00	3.00	—	30.120	1019.80	FEW	17000.00	SCT	20000.00	—	—	—	—	10.00	—	0.000	—	—	—	—	KSFO 010056Z 32003KT 10SM FEW170 SCT200 13/07 A3012 RMK AO2 SLP198 T01280067	—	—	—	—
KSFO	2020-01-01T01:56:00.000000Z	METAR	2019-12-31	54.00	49.00	82.82	290.00	7.00	—	30.120	1020.10	FEW	6000.00	SCT	20000.00	—	—	—	—	10.00	—	0.000	—	—	—	—	KSFO 010156Z 29007KT 10SM FEW060 SCT200 12/09 A3012 RMK AO2 SLP201 T01220094	—	—	—	—
KSFO	2020-01-01T02:56:00.000000Z	METAR	2019-12-31	53.00	48.00	82.76	280.00	8.00	—	30.120	1020.00	FEW	17000.00	SCT	20000.00	—	—	—	—	9.00	—	0.000	—	—	—	—	KSFO 010256Z 28008KT 9SM FEW170 SCT200 12/09 A3012 RMK AO2 SLP200 T01170089 51005	—	—	—	—
KSFO	2020-01-01T03:56:00.000000Z	METAR	2019-12-31	53.00	47.00	79.40	290.00	9.00	—	30.140	1020.60	FEW	18000.00	SCT	20000.00	—	—	—	—	9.00	—	0.000	—	—	—	—	KSFO 010356Z 29009KT 9SM FEW180 SCT200 12/08 A3014 RMK AO2 SLP206 T01170083	—	—	—	—
KSFO	2020-01-01T04:56:00.000000Z	METAR	2019-12-31	53.00	49.00	85.59	260.00	10.00	—	30.140	1020.70	FEW	18000.00	SCT	20000.00	—	—	—	—	9.00	—	0.000	—	—	—	—	KSFO 010456Z 26010KT 9SM FEW180 SCT200 12/09 A3014 RMK AO2 SLP207 T01170094	—	—	—	—
KSFO	2020-01-01T05:56:00.000000Z	METAR	2019-12-31	54.00	49.00	82.82	290.00	9.00	—	30.160	1021.20	FEW	1000.00	SCT	20000.00	—	—	—	—	9.00	—	0.000	—	—	—	—	KSFO 010556Z 29009KT 9SM FEW010 SCT200 12/09 A3016 RMK AO2 SLP212 T01220094 10139 20111 51011	—	—	—	—
KSFO	2020-01-01T06:56:00.000000Z	METAR	2019-12-31	51.00	47.00	85.48	160.00	5.00	—	30.140	1020.60	FEW	800.00	SCT	20000.00	—	—	—	—	10.00	—	0.000	—	—	—	—	KSFO 010656Z 16005KT 10SM FEW008 SCT200 11/08 A3014 RMK AO2 SLP206 T01060083	—	—	—	—
KSFO	2020-01-01T07:56:00.000000Z	METAR	2019-12-31	52.00	47.00	82.68	290.00	7.00	—	30.150	1021.10	FEW	800.00	FEW	20000.00	—	—	—	—	10.00	—	0.000	—	—	—	—	KSFO 010756Z 29007KT 10SM FEW008 FEW200 11/08 A3015 RMK AO2 SLP211 T01110083 401390050	—	—	—	—
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	—	—	9.00	—	0.000	—	—	—	—	KSFO 010856Z 27008KT 9SM FEW008 FEW016 SCT200 11/09 A3016 RMK AO2 SLP213 T01110089 53002	CLISFO	59	47	final

Columns

Schema, units, meaning, and verified release profile

32 columns

Verified column analytics for reports_ksfo
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station0 source inputs · 4 transformations	string	—	0.0%0 values	1<0.1%	KSFO100% Top: KSFO	—
event_time_utc0 source inputs · 4 transformations	timestamp_utc	—	0.0%0 values	65,150100.0%	2020-01-012026-01-01 per year All rows, per year	—
observation_type0 source inputs · 4 transformations	string	—	0.0%0 values	2<0.1%	METAR90% SPECI10% Top: METAR	—
local_standard_date0 source inputs · 4 transformations	date	—	0.0%0 values	2,4383.7%	2019-01-012026-01-01 per year All rows, per year	—
temp_f0 source inputs · 4 transformations	decimal	—	<0.1%7 values	810.1%	36.00102.00 All-row histogram	Median 57.00P25 53.00 · P75 62.00
dewpoint_f0 source inputs · 4 transformations	decimal	—	<0.1%7 values	750.1%	12.9068.00 All-row histogram	Median 50.00P25 45.00 · P75 54.00
relative_humidity_pct0 source inputs · 4 transformations	decimal	—	<0.1%7 values	2,4833.8%	9.22100.00 All-row histogram	Median 76.67P25 65.35 · P75 83.59
wind_direction_degrees0 source inputs · 4 transformations	decimal	—	0.8%522 values	37<0.1%	0.00360.00 All-row histogram	Median 270.00P25 150.00 · P75 290.00
wind_speed_kt0 source inputs · 4 transformations	decimal	—	<0.1%19 values	42<0.1%	0.0043.00 All-row histogram	Median 8.00P25 4.00 · P75 13.00
wind_gust_kt0 source inputs · 4 transformations	decimal	—	88.0%57,362 values	480.6%	14.0072.00 All-row histogram	Median 25.00P25 22.00 · P75 29.00
altimeter_inhg0 source inputs · 4 transformations	decimal	—	<0.1%11 values	1370.2%	29.10030.590 All-row histogram	Median 30.010P25 29.920 · P75 30.110
sea_level_pressure_hpa0 source inputs · 4 transformations	decimal	—	10.3%6,701 values	3880.7%	985.301035.90 All-row histogram	Median 1016.20P25 1013.30 · P75 1019.70
sky_cover_10 source inputs · 4 transformations	string	—	<0.1%13 values	6<0.1%	FEW71% CLR12% BKN7% Top: FEW	—
sky_base_1_ft0 source inputs · 4 transformations	decimal	—	12.2%7,966 values	800.1%	0.00104000.00 All-row histogram	Median 900.00P25 600.00 · P75 2700.00
sky_cover_20 source inputs · 4 transformations	string	—	45.9%29,910 values	4<0.1%	BKN46% SCT28% FEW18% Top: BKN	—
sky_base_2_ft0 source inputs · 4 transformations	decimal	—	45.9%29,910 values	770.2%	200.0027000.00 All-row histogram	Median 2600.00P25 1300.00 · P75 15000.00
sky_cover_30 source inputs · 4 transformations	string	—	79.3%51,635 values	4<0.1%	BKN53% OVC37% SCT10% Top: BKN	—
sky_base_3_ft0 source inputs · 4 transformations	decimal	—	79.3%51,635 values	760.6%	400.0025000.00 All-row histogram	Median 6000.00P25 3000.00 · P75 18000.00
sky_cover_40 source inputs · 4 transformations	string	—	99.4%64,754 values	30.8%	BKN74% OVC22% SCT4% Top: BKN	—
sky_base_4_ft0 source inputs · 4 transformations	decimal	—	99.4%64,754 values	61.5%	14000.0025000.00 All-row histogram	Median 18000.00P25 15000.00 · P75 20000.00

Show 12 more columns

Verified column analytics for reports_ksfo
visibility_miles0 source inputs · 4 transformations	decimal	—	<0.1%10 values	19<0.1%	0.0610.00 All-row histogram	Median 10.00P25 10.00 · P75 10.00
weather_codes0 source inputs · 4 transformations	string	—	92.3%60,127 values	350.7%	-RA33% BR19% -RA BR18% Other (23) Top: -RA · 105 more values	—
precipitation_in_1h0 source inputs · 4 transformations	decimal	—	3.1%2,004 values	57<0.1%	0.0000.880 All-row histogram	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt0 source inputs · 4 transformations	decimal	—	89.0%57,974 values	400.6%	26.0072.00 All-row histogram	Median 29.00P25 27.00 · P75 32.00
peak_wind_direction_degrees0 source inputs · 4 transformations	decimal	—	89.0%57,974 values	360.5%	10.00360.00 All-row histogram	Median 280.00P25 270.00 · P75 290.00
peak_wind_time0 source inputs · 4 transformations	string	—	89.0%57,974 values	6,73693.9%	6,736 distinct values, no chart No shape worth drawing · 7,176 more values	—
snow_depth_inches0 source inputs · 4 transformations	decimal	—	100.0%65,150 values	00.0%	0 distinct values, no chart No shape worth drawing	—
raw_metar0 source inputs · 4 transformations	string	—	0.0%0 values	65,150100.0%	65,150 distinct values, no chart No shape worth drawing · 65,150 more values	—
cli_product0 source inputs · 4 transformations	string	—	0.2%108 values	1<0.1%	CLISFO100% Top: CLISFO	—
cli_high_f0 source inputs · 4 transformations	integer	—	0.6%385 values	53<0.1%	47102 All-row histogram	Median 66P25 61 · P75 72
cli_low_f0 source inputs · 4 transformations	integer	—	0.3%188 values	34<0.1%	3568 All-row histogram	Median 52P25 48 · P75 56
cli_report_type0 source inputs · 4 transformations	string	—	0.2%108 values	2<0.1%	final99% correction1% Top: final	—

Release status

Facts from the current passing release

Release: V4 publication snapshot
Rows: 65,150
Columns: 32
Published: 4 Sept 2026, 09:28
Analytics: Verified across all rows

Use dataset

Query it over the API, connect an agent over MCP, or download the current Parquet file. Everything below is copy-pastable and live.

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/f290a279-c39c-4bc7-8e04-974e0bcd480a/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/f290a279-c39c-4bc7-8e04-974e0bcd480a/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/f290a279-c39c-4bc7-8e04-974e0bcd480a/query" \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  -H "content-type: application/json" \
  --data '{"columns": ["station","event_time_utc"], "limit": 100}'

MOSTLYRIGHT_API_KEY takes an mr_use_ key, minted from a workspace that uses this dataset. These routes refuse an mr_live_ key. Full 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

US Weather Reports and Daily Highs in 20 Cities

reports_ksfo

Release status