reports_ksdf

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:31

Rows: 73,527; across released Tables
Tables: 1; released
Columns: 34; reports_ksdf
Version: —; reports_ksdf

Data preview

reports_ksdf

Preview rows for reports_ksdf
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
KSDF	2020-01-01T05:56:00.000000Z	METAR	2020-01-01	39.00	28.00	64.37	250.00	8.00	—	29.960	1014.70	FEW	3000.00	OVC	4800.00	—	—	—	—
KSDF	2020-01-01T06:56:00.000000Z	METAR	2020-01-01	39.00	28.00	64.37	250.00	8.00	—	29.960	1014.70	OVC	4700.00	—	—	—	—	—	—
KSDF	2020-01-01T07:56:00.000000Z	METAR	2020-01-01	39.00	28.00	64.37	240.00	8.00	—	29.960	1014.80	OVC	4700.00	—	—	—	—	—	—
KSDF	2020-01-01T08:56:00.000000Z	METAR	2020-01-01	39.00	28.90	66.79	230.00	5.00	—	29.970	1014.90	OVC	4400.00	—	—	—	—	—	—
KSDF	2020-01-01T09:56:00.000000Z	METAR	2020-01-01	39.00	28.90	66.79	240.00	5.00	—	29.960	1014.70	OVC	4100.00	—	—	—	—	—	—
KSDF	2020-01-01T10:56:00.000000Z	METAR	2020-01-01	38.00	28.00	67.20	250.00	4.00	—	29.960	1014.90	BKN	4300.00	—	—	—	—	—	—
KSDF	2020-01-01T11:56:00.000000Z	METAR	2020-01-01	36.00	28.00	72.43	220.00	5.00	—	29.980	1015.30	FEW	4300.00	—	—	—	—	—	—
KSDF	2020-01-01T12:56:00.000000Z	METAR	2020-01-01	37.00	28.00	69.63	190.00	4.00	—	29.980	1015.40	FEW	4000.00	—	—	—	—	—	—
KSDF	2020-01-01T13:56:00.000000Z	METAR	2020-01-01	38.00	28.90	69.73	190.00	7.00	—	29.990	1015.80	FEW	4000.00	—	—	—	—	—	—
KSDF	2020-01-01T14:56:00.000000Z	METAR	2020-01-01	41.00	30.00	64.63	210.00	8.00	—	30.010	1016.30	FEW	4000.00	—	—	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

34 columns

Verified column analytics for reports_ksdf
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	KSDF100% Top: KSDF	—
event_time_utc	timestamp_utc	—	0.0%0 values	73,526100.0%	2025-09-24 04:10:00+000% 2020-01-01 05:56:00+000% 2020-01-01 06:56:00+000% Other (73,514) Top: 2025-09-24 04:10:00+00 · 73,514 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%	2022-02-040% 2022-01-280% 2021-02-150% Other (2,431) Top: 2022-02-04 · 72,672 more values	—
temp_f	decimal	—	<0.1%23 values	2210.3%	73.003% 74.002% 71.002% Other (209) Top: 73.00 · 54,408 more values	Median 62.00P25 46.00 · P75 74.00
dewpoint_f	decimal	—	<0.1%23 values	1980.3%	69.003% 68.003% 70.003% Other (186) Top: 69.00 · 53,450 more values	Median 50.00P25 33.00 · P75 63.00
relative_humidity_pct	decimal	—	<0.1%23 values	4,7466.5%	100.000% 87.240% 87.140% Other (4,734) Top: 100.00 · 71,680 more values	Median 69.14P25 53.13 · P75 83.13
wind_direction_degrees	decimal	—	2.6%1,880 values	37<0.1%	0.0010% 220.004% 290.004% Other (25) Top: 0.00 · 38,314 more values	Median 190.00P25 90.00 · P75 270.00
wind_speed_kt	decimal	—	<0.1%56 values	37<0.1%	5.0011% 4.0011% 6.0010% Other (25) Top: 5.00 · 5,700 more values	Median 6.00P25 4.00 · P75 9.00
wind_gust_kt	decimal	—	87.1%64,033 values	460.5%	21.009% 20.009% 22.009% Other (34) Top: 21.00 · 1,959 more values	Median 22.00P25 19.00 · P75 26.00
altimeter_inhg	decimal	—	<0.1%38 values	1720.2%	30.0203% 30.0103% 30.0403% Other (160) Top: 30.020 · 51,967 more values	Median 30.020P25 29.920 · P75 30.140
sea_level_pressure_hpa	decimal	—	20.5%15,106 values	5250.9%	1015.901% 1014.701% 1015.701% Other (513) Top: 1015.90 · 53,023 more values	Median 1017.00P25 1013.40 · P75 1021.20
sky_cover_1	string	—	<0.1%35 values	6<0.1%	FEW38% BKN21% SCT18% Top: FEW	—
sky_base_1_ft	decimal	—	10.3%7,541 values	910.1%	25000.007% 30000.004% 5000.004% Other (79) Top: 25000.00 · 40,541 more values	Median 4000.00P25 1700.00 · P75 9000.00
sky_cover_2	string	—	43.3%31,818 values	4<0.1%	BKN45% OVC25% SCT17% Top: BKN	—
sky_base_2_ft	decimal	—	43.3%31,818 values	870.2%	25000.0011% 30000.007% 6000.004% Other (75) Top: 25000.00 · 22,292 more values	Median 7000.00P25 3300.00 · P75 18000.00
sky_cover_3	string	—	72.6%53,417 values	4<0.1%	OVC52% BKN38% SCT8% Top: OVC	—
sky_base_3_ft	decimal	—	72.6%53,417 values	780.4%	25000.0013% 30000.008% 11000.006% Other (66) Top: 25000.00 · 8,081 more values	Median 10000.00P25 5500.00 · P75 20000.00
sky_cover_4	string	—	95.0%69,864 values	50.1%	BKN61% OVC35% SCT4% Top: BKN	—
sky_base_4_ft	decimal	—	95.0%69,865 values	200.5%	25000.0031% 30000.0017% 20000.0015% Other (8) Top: 25000.00 · 119 more values	Median 24000.00P25 17000.00 · P75 25000.00

Show 14 more columns

Verified column analytics for reports_ksdf
visibility_miles	decimal	—	<0.1%18 values	20<0.1%	10.0081% 9.003% 3.002% Other (8) Top: 10.00 · 1,057 more values	Median 10.00P25 10.00 · P75 10.00
weather_codes	string	—	78.1%57,441 values	1310.8%	-RA27% -SN11% -RA BR11% Other (119) Top: -RA · 2,973 more values	—
precipitation_in_1h	decimal	—	12.3%9,010 values	1280.2%	0.00086% 0.0103% 0.0202% Other (116) Top: 0.000 · 2,088 more values	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt	decimal	—	94.4%69,400 values	360.9%	26.0016% 27.0015% 28.0013% Other (24) Top: 26.00 · 464 more values	Median 29.00P25 27.00 · P75 33.00
peak_wind_direction_degrees	decimal	—	94.4%69,400 values	360.9%	280.008% 260.008% 270.007% Other (24) Top: 280.00 · 1,185 more values	Median 250.00P25 200.00 · P75 280.00
peak_wind_time	string	—	94.4%69,400 values	3,04573.8%	2020-06-21 16:010% 2022-03-19 03:210% 2024-04-02 12:200% Other (3,033) Top: 2020-06-21 16:01 · 4,034 more values	—
snow_depth_inches	decimal	—	99.6%73,267 values	83.1%	1.0030% 3.0021% 2.0020% Top: 1.00	Median 2.00P25 1.00 · P75 4.00
raw_metar	string	—	0.0%0 values	73,527100.0%	KSDF 010001Z 31006KT 5SM -SN SCT022 OVC041 M08/M11 A3035 RMK AO2 P0000 T108311110% KSDF 010014Z 26004KT 2 1/2SM -SN BKN035 OVC043 00/M04 A3022 RMK AO2 P0000 T000010390% KSDF 010017Z 28007KT 2SM +RA FEW016 BKN023 OVC034 16/15 A2996 RMK AO2 P0007 T015601500% Other (73,515) Top: KSDF 010001Z 31006KT 5SM -SN SCT022 OVC041 M08/M11 A3035 RMK AO2 P0000 T10831111 · 73,515 more values	—
cli_product	string	—	0.1%87 values	1<0.1%	CLISDF100% Top: CLISDF	—
cli_high_f	integer	—	0.2%119 values	890.1%	7102 All-row histogram	Median 72P25 56 · P75 85
cli_low_f	integer	—	0.2%145 values	820.1%	-583 All-row histogram	Median 52P25 37 · P75 67
cli_report_type	string	—	0.1%87 values	3<0.1%	final99% correction1% preliminary0% Top: final	—
metar_high_f	decimal	—	0.0%0 values	1130.2%	83.003% 85.003% 80.003% Other (101) Top: 83.00 · 50,885 more values	Median 71.00P25 56.00 · P75 84.00
metar_low_f	decimal	—	0.0%0 values	1140.2%	71.003% 73.003% 69.003% Other (102) Top: 71.00 · 51,799 more values	Median 52.00P25 37.40 · P75 67.00

Release status

Facts from the current passing release

Release: Passing
Rows: 73,527
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_ksdf

reports_ksdf

# Current release — the complete Parquet file
curl -sS -o reports-ksdf.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/3b2d8af2-6a6c-4965-bc18-90d91a366e10/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/3b2d8af2-6a6c-4965-bc18-90d91a366e10/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/3b2d8af2-6a6c-4965-bc18-90d91a366e10/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

Louisville weather reports and daily highs since 2020

reports_ksdf

Release status