reports_ksat

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:30

Rows: 70,854; across released Tables
Tables: 1; released
Columns: 34; reports_ksat
Version: —; 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
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	—	—	—	—
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	—	—	—	—	—	—
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	—	—	—	—	—	—
KSAT	2020-01-01T09:51:00.000000Z	METAR	2020-01-01	52.00	28.00	39.30	0.00	0.00	—	30.050	1016.60	OVC	4200.00	—	—	—	—	—	—
KSAT	2020-01-01T10:51:00.000000Z	METAR	2020-01-01	52.00	27.00	37.72	0.00	0.00	—	30.050	1016.30	OVC	4000.00	—	—	—	—	—	—
KSAT	2020-01-01T11:51:00.000000Z	METAR	2020-01-01	51.00	28.90	42.16	0.00	0.00	—	30.050	1016.40	OVC	4000.00	—	—	—	—	—	—
KSAT	2020-01-01T12:51:00.000000Z	METAR	2020-01-01	51.00	30.00	44.09	0.00	0.00	—	30.040	1016.10	OVC	3900.00	—	—	—	—	—	—
KSAT	2020-01-01T13:51:00.000000Z	METAR	2020-01-01	52.00	28.90	40.78	0.00	0.00	—	30.030	1015.80	BKN	3200.00	OVC	4500.00	—	—	—	—
KSAT	2020-01-01T14:51:00.000000Z	METAR	2020-01-01	52.00	28.00	39.30	0.00	0.00	—	30.030	1016.00	OVC	3100.00	—	—	—	—	—	—
KSAT	2020-01-01T15:49:00.000000Z	SPECI	2020-01-01	53.60	30.20	40.54	270.00	4.00	—	30.080	—	BKN	2700.00	OVC	4500.00	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

34 columns

Verified column analytics for reports_ksat
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	KSAT100% Top: KSAT	—
event_time_utc	timestamp_utc	—	0.0%0 values	70,852100.0%	2022-11-22 23:50:00+000% 2025-10-25 05:50:00+000% 2020-01-01 06:51:00+000% Other (70,840) Top: 2022-11-22 23:50:00+00 · 70,840 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	METAR83% SPECI17% Top: METAR	—
local_standard_date	date	—	0.0%0 values	2,4433.4%	2024-05-300% 2024-12-040% 2021-04-300% Other (2,431) Top: 2024-05-30 · 70,220 more values	—
temp_f	decimal	—	<0.1%6 values	1450.2%	79.004% 78.004% 80.003% Other (133) Top: 79.00 · 45,892 more values	Median 73.00P25 62.00 · P75 81.00
dewpoint_f	decimal	—	<0.1%7 values	1290.2%	72.005% 73.004% 71.004% Other (117) Top: 72.00 · 37,534 more values	Median 63.00P25 49.00 · P75 70.00
relative_humidity_pct	decimal	—	<0.1%7 values	4,8126.8%	100.001% 90.400% 81.890% Other (4,800) Top: 100.00 · 67,436 more values	Median 71.64P25 50.75 · P75 84.69
wind_direction_degrees	decimal	—	3.6%2,573 values	37<0.1%	0.008% 160.008% 150.007% Other (25) Top: 0.00 · 26,262 more values	Median 140.00P25 80.00 · P75 180.00
wind_speed_kt	decimal	—	<0.1%52 values	32<0.1%	6.0010% 5.009% 4.009% Other (20) Top: 6.00 · 6,579 more values	Median 7.00P25 4.00 · P75 10.00
wind_gust_kt	decimal	—	82.3%58,346 values	410.3%	20.0010% 19.0010% 21.009% Other (29) Top: 20.00 · 1,765 more values	Median 21.00P25 18.00 · P75 24.00
altimeter_inhg	decimal	—	0.1%75 values	1350.2%	29.9703% 30.0103% 30.0003% Other (123) Top: 29.970 · 46,462 more values	Median 30.000P25 29.910 · P75 30.100
sea_level_pressure_hpa	decimal	—	17.8%12,598 values	4400.8%	1012.601% 1013.001% 1013.201% Other (428) Top: 1012.60 · 52,123 more values	Median 1014.20P25 1011.10 · P75 1018.10
sky_cover_1	string	—	<0.1%14 values	6<0.1%	BKN28% FEW27% SCT18% Top: BKN	—
sky_base_1_ft	decimal	—	13.0%9,181 values	800.1%	25000.0014% 1500.004% 5000.003% Other (68) Top: 25000.00 · 33,460 more values	Median 2900.00P25 1400.00 · P75 7000.00
sky_cover_2	string	—	50.2%35,569 values	4<0.1%	BKN49% OVC26% SCT15% Top: BKN	—
sky_base_2_ft	decimal	—	50.2%35,569 values	780.2%	25000.0039% 6000.002% 12000.002% Other (66) Top: 25000.00 · 14,510 more values	Median 11000.00P25 3500.00 · P75 25000.00
sky_cover_3	string	—	85.7%60,696 values	4<0.1%	BKN51% OVC44% SCT4% Top: BKN	—
sky_base_3_ft	decimal	—	85.7%60,696 values	680.7%	25000.0059% 11000.003% 10000.002% Other (56) Top: 25000.00 · 2,287 more values	Median 25000.00P25 10000.00 · P75 25000.00
sky_cover_4	string	—	99.7%70,658 values	21.0%	BKN53% OVC47% Top: BKN	—
sky_base_4_ft	decimal	—	99.7%70,658 values	94.6%	25000.0084% 13000.005% 20000.004% Top: 25000.00	Median 25000.00P25 25000.00 · P75 25000.00

Show 14 more columns

Verified column analytics for reports_ksat
visibility_miles	decimal	—	<0.1%12 values	20<0.1%	10.0087% 8.002% 9.002% Other (8) Top: 10.00 · 1,040 more values	Median 10.00P25 10.00 · P75 10.00
weather_codes	string	—	86.5%61,286 values	660.7%	-RA23% BR18% -RA BR15% Other (54) Top: -RA · 1,248 more values	—
precipitation_in_1h	decimal	—	8.2%5,815 values	1230.2%	0.00095% 0.0102% 0.0201% Other (111) Top: 0.000 · 738 more values	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt	decimal	—	94.5%66,937 values	280.7%	26.0023% 27.0017% 28.0014% Other (16) Top: 26.00 · 215 more values	Median 28.00P25 27.00 · P75 31.00
peak_wind_direction_degrees	decimal	—	94.5%66,937 values	360.9%	140.0011% 130.009% 150.008% Other (24) Top: 140.00 · 919 more values	Median 150.00P25 120.00 · P75 320.00
peak_wind_time	string	—	94.5%66,937 values	3,37086.0%	2024-06-20 20:520% 2025-10-25 04:580% 2026-08-29 01:530% Other (3,358) Top: 2024-06-20 20:52 · 3,854 more values	—
snow_depth_inches	decimal	—	100.0%70,854 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	70,854100.0%	KSAT 010000Z 28010KT 1SM R13R/P6000FT +TSRA BR BKN010 OVC050CB 19/18 A3007 RMK AO2 LTG DSNT ALQDS PRESRR WSHFT 59 FRQ LTGICCG TS ALQDS MOVG NE P0004 T018901780% KSAT 010008Z 02023G51KT 3/4SM +TSRA SCT008 BKN018 OVC030CB 22/22 A2999 RMK AO2 PK WND 35051/0001 CONS LTGICCG TS AT AP MOV SE P0110 T02220217 RVRNO0% KSAT 010008Z 29012G17KT 1SM R13R/P6000FT +TSRA BR BKN006 BKN010 OVC050CB 19/18 A3008 RMK AO2 LTG DSNT ALQDS OCNL LTGICCG TS ALQDS MOVG NE P0008 T018901780% Other (70,842) Top: KSAT 010000Z 28010KT 1SM R13R/P6000FT +TSRA BR BKN010 OVC050CB 19/18 A3007 RMK AO2 LTG DSNT ALQDS PRESRR WSHFT 59 FRQ LTGICCG TS ALQDS MOVG NE P0004 T01890178 · 70,842 more values	—
cli_product	string	—	0.0%0 values	1<0.1%	CLISAT100% Top: CLISAT	—
cli_high_f	integer	—	<0.1%65 values	800.1%	26108 All-row histogram	Median 85P25 74 · P75 94
cli_low_f	integer	—	0.0%0 values	68<0.1%	982 All-row histogram	Median 65P25 51 · P75 74
cli_report_type	string	—	0.0%0 values	3<0.1%	final99% correction1% preliminary0% Top: final	—
metar_high_f	decimal	—	0.0%0 values	1010.1%	88.003% 93.003% 94.003% Other (89) Top: 88.00 · 45,761 more values	Median 84.00P25 74.00 · P75 93.00
metar_low_f	decimal	—	0.0%0 values	920.1%	78.006% 77.005% 75.004% Other (80) Top: 78.00 · 41,851 more values	Median 65.00P25 52.00 · P75 75.00

Release status

Facts from the current passing release

Release: Passing
Rows: 70,854
Columns: 34
Published: 9 Sept 2026, 06:30
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_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/3fd6a94f-c4ae-43ca-ac1f-5df88a82ff2e/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/3fd6a94f-c4ae-43ca-ac1f-5df88a82ff2e/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/3fd6a94f-c4ae-43ca-ac1f-5df88a82ff2e/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 Antonio weather reports and daily highs since 2020

reports_ksat

Release status