reports_ksat

Release V4 publication snapshot

Current data

Latest passing release for each Table

Updated 4 Sept 2026, 09:28

Rows: 70,707; across released Tables
Tables: 1; released
Columns: 32; reports_ksat
Version: V4 publication snapshot; reports_ksat

Data preview

reports_ksat

Preview rows for reports_ksat
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
KSAT	2020-01-01T00:00:00.000000Z	SPECI	2019-12-31	57.00	22.00	25.51	170.00	7.00	—	—	1020.60	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	METAR SAT 010000Z AUTO 17007KT 14/M06 RMK AO2 SLP206 T01391056 IEM_GHCNH	—	—	—	—
KSAT	2020-01-01T00:51:00.000000Z	METAR	2019-12-31	56.00	21.90	26.43	180.00	7.00	—	30.160	1020.50	OVC	5500.00	—	—	—	—	—	—	10.00	—	0.000	—	—	—	—	KSAT 010051Z 18007KT 10SM OVC055 13/M06 A3016 RMK AO2 SLP205 T01331056 $	—	—	—	—
KSAT	2020-01-01T01:51:00.000000Z	METAR	2019-12-31	55.00	21.90	27.31	180.00	5.00	—	30.170	1020.90	OVC	5500.00	—	—	—	—	—	—	10.00	—	0.000	—	—	—	—	KSAT 010151Z 18005KT 10SM OVC055 13/M06 A3017 RMK AO2 SLP209 T01281056 $	—	—	—	—
KSAT	2020-01-01T02:51:00.000000Z	METAR	2019-12-31	55.00	21.90	27.31	190.00	7.00	—	30.160	1020.50	OVC	5500.00	—	—	—	—	—	—	10.00	—	0.000	—	—	—	—	KSAT 010251Z 19007KT 10SM OVC055 13/M06 A3016 RMK AO2 SLP205 T01281056 50000 $	—	—	—	—
KSAT	2020-01-01T03:51:00.000000Z	METAR	2019-12-31	53.00	24.10	32.11	180.00	6.00	—	30.150	1020.20	BKN	5500.00	—	—	—	—	—	—	10.00	—	0.000	—	—	—	—	KSAT 010351Z 18006KT 10SM BKN055 12/M04 A3015 RMK AO2 SLP202 T01171044 $	—	—	—	—
KSAT	2020-01-01T04:51:00.000000Z	METAR	2019-12-31	51.00	25.00	35.89	160.00	5.00	—	30.150	1019.90	BKN	5500.00	BKN	23000.00	—	—	—	—	10.00	—	0.000	—	—	—	—	KSAT 010451Z 16005KT 10SM BKN055 BKN230 11/M04 A3015 RMK AO2 SLP199 T01061039 $	—	—	—	—
KSAT	2020-01-01T05:51:00.000000Z	METAR	2019-12-31	53.00	25.00	33.34	160.00	5.00	—	30.140	1019.50	BKN	5000.00	OVC	23000.00	—	—	—	—	10.00	—	0.000	—	—	—	—	KSAT 010551Z 16005KT 10SM BKN050 OVC230 12/M04 A3014 RMK AO2 SLP195 T01171039 10139 20106 401610006 58007 $	—	—	—	—
KSAT	2020-01-01T06:51:00.000000Z	METAR	2020-01-01	52.00	26.10	36.34	180.00	7.00	—	30.120	1018.80	BKN	4800.00	OVC	25000.00	—	—	—	—	10.00	—	0.000	—	—	—	—	KSAT 010651Z 18007KT 10SM BKN048 OVC250 11/M03 A3012 RMK AO2 SLP188 T01111033 $	CLISAT	53	50	final
KSAT	2020-01-01T07:51:00.000000Z	METAR	2020-01-01	52.00	25.00	34.72	180.00	4.00	—	30.100	1018.10	OVC	4600.00	—	—	—	—	—	—	10.00	—	0.000	—	—	—	—	KSAT 010751Z 18004KT 10SM OVC046 11/M04 A3010 RMK AO2 SLP181 T01111039 $	CLISAT	53	50	final
KSAT	2020-01-01T08:51:00.000000Z	METAR	2020-01-01	52.00	27.00	37.72	70.00	4.00	—	30.080	1017.50	OVC	4700.00	—	—	—	—	—	—	10.00	—	0.000	—	—	—	—	KSAT 010851Z 07004KT 10SM OVC047 11/M03 A3008 RMK AO2 SLP175 T01111028 56020 $	CLISAT	53	50	final

Columns

Schema, units, meaning, and verified release profile

32 columns

Verified column analytics for reports_ksat
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station0 source inputs · 4 transformations	string	—	0.0%0 values	1<0.1%	KSAT100% Top: KSAT	—
event_time_utc0 source inputs · 4 transformations	timestamp_utc	—	0.0%0 values	70,705100.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%	METAR83% SPECI17% Top: METAR	—
local_standard_date0 source inputs · 4 transformations	date	—	0.0%0 values	2,4383.4%	2019-01-012026-01-01 per year All rows, per year	—
temp_f0 source inputs · 4 transformations	decimal	—	<0.1%6 values	1450.2%	9.00106.00 All-row histogram	Median 73.00P25 62.00 · P75 81.00
dewpoint_f0 source inputs · 4 transformations	decimal	—	<0.1%7 values	1290.2%	-4.0080.00 All-row histogram	Median 63.00P25 49.00 · P75 70.00
relative_humidity_pct0 source inputs · 4 transformations	decimal	—	<0.1%7 values	4,8136.8%	6.69100.00 All-row histogram	Median 71.64P25 50.75 · P75 84.69
wind_direction_degrees0 source inputs · 4 transformations	decimal	—	3.6%2,557 values	37<0.1%	0.00360.00 All-row histogram	Median 140.00P25 80.00 · P75 180.00
wind_speed_kt0 source inputs · 4 transformations	decimal	—	<0.1%52 values	32<0.1%	0.0036.00 All-row histogram	Median 7.00P25 4.00 · P75 10.00
wind_gust_kt0 source inputs · 4 transformations	decimal	—	82.3%58,211 values	410.3%	14.0067.00 All-row histogram	Median 21.00P25 18.00 · P75 24.00
altimeter_inhg0 source inputs · 4 transformations	decimal	—	0.1%76 values	1350.2%	29.34030.750 All-row histogram	Median 30.000P25 29.910 · P75 30.100
sea_level_pressure_hpa0 source inputs · 4 transformations	decimal	—	17.8%12,583 values	4400.8%	991.701041.00 All-row histogram	Median 1014.20P25 1011.10 · P75 1018.10
sky_cover_10 source inputs · 4 transformations	string	—	<0.1%15 values	6<0.1%	BKN28% FEW27% SCT18% Top: BKN	—
sky_base_1_ft0 source inputs · 4 transformations	decimal	—	13.0%9,174 values	800.1%	0.0026000.00 All-row histogram	Median 2900.00P25 1400.00 · P75 7000.00
sky_cover_20 source inputs · 4 transformations	string	—	50.3%35,533 values	4<0.1%	BKN49% OVC26% SCT15% Top: BKN	—
sky_base_2_ft0 source inputs · 4 transformations	decimal	—	50.3%35,533 values	780.2%	600.0034000.00 All-row histogram	Median 11000.00P25 3500.00 · P75 25000.00
sky_cover_30 source inputs · 4 transformations	string	—	85.7%60,591 values	4<0.1%	BKN51% OVC44% SCT4% Top: BKN	—
sky_base_3_ft0 source inputs · 4 transformations	decimal	—	85.7%60,591 values	680.7%	1200.0030000.00 All-row histogram	Median 25000.00P25 10000.00 · P75 25000.00
sky_cover_40 source inputs · 4 transformations	string	—	99.7%70,511 values	21.0%	BKN53% OVC47% Top: BKN	—
sky_base_4_ft0 source inputs · 4 transformations	decimal	—	99.7%70,511 values	94.6%	13000.0025000.00 All-row histogram	Median 25000.00P25 25000.00 · P75 25000.00

Show 12 more columns

Verified column analytics for reports_ksat
visibility_miles0 source inputs · 4 transformations	decimal	—	<0.1%13 values	20<0.1%	0.0010.00 All-row histogram	Median 10.00P25 10.00 · P75 10.00
weather_codes0 source inputs · 4 transformations	string	—	86.5%61,142 values	660.7%	-RA23% BR18% -RA BR15% Other (54) Top: -RA · 1,248 more values	—
precipitation_in_1h0 source inputs · 4 transformations	decimal	—	8.2%5,812 values	1230.2%	0.0003.980 All-row histogram	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt0 source inputs · 4 transformations	decimal	—	94.5%66,795 values	280.7%	26.0057.00 All-row histogram	Median 28.00P25 27.00 · P75 31.00
peak_wind_direction_degrees0 source inputs · 4 transformations	decimal	—	94.5%66,795 values	360.9%	10.00360.00 All-row histogram	Median 150.00P25 120.00 · P75 320.00
peak_wind_time0 source inputs · 4 transformations	string	—	94.5%66,795 values	3,36586.0%	3,365 distinct values, no chart No shape worth drawing · 3,912 more values	—
snow_depth_inches0 source inputs · 4 transformations	decimal	—	100.0%70,707 values	00.0%	0 distinct values, no chart No shape worth drawing	—
raw_metar0 source inputs · 4 transformations	string	—	0.0%0 values	70,707100.0%	70,707 distinct values, no chart No shape worth drawing · 70,707 more values	—
cli_product0 source inputs · 4 transformations	string	—	<0.1%7 values	1<0.1%	CLISAT100% Top: CLISAT	—
cli_high_f0 source inputs · 4 transformations	integer	—	0.1%72 values	800.1%	26108 All-row histogram	Median 85P25 74 · P75 94
cli_low_f0 source inputs · 4 transformations	integer	—	<0.1%7 values	68<0.1%	982 All-row histogram	Median 65P25 51 · P75 74
cli_report_type0 source inputs · 4 transformations	string	—	<0.1%7 values	3<0.1%	final99% correction1% preliminary0% Top: final	—

Release status

Facts from the current passing release

Release: V4 publication snapshot
Rows: 70,707
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_ksat

reports_ksat

# Current release — the complete Parquet file
curl -sS -o reports-ksat.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/bd6885b8-9935-4cd2-bcc7-620fc83d9ff0/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/bd6885b8-9935-4cd2-bcc7-620fc83d9ff0/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/bd6885b8-9935-4cd2-bcc7-620fc83d9ff0/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_ksat

Release status