reports_kden

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:27

Rows: 67,933; across released Tables
Tables: 1; released
Columns: 34; reports_kden
Version: —; reports_kden

Data preview

reports_kden

Preview rows for reports_kden
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
KDEN	2020-01-01T07:53:00.000000Z	METAR	2020-01-01	28.00	12.00	50.56	210.00	6.00	—	29.680	1005.00	FEW	15000.00	SCT	22000.00	—	—	—	—
KDEN	2020-01-01T08:53:00.000000Z	METAR	2020-01-01	32.00	12.90	44.70	230.00	8.00	—	29.660	1003.50	FEW	15000.00	FEW	22000.00	—	—	—	—
KDEN	2020-01-01T09:53:00.000000Z	METAR	2020-01-01	30.00	14.00	50.88	230.00	9.00	—	29.640	1002.90	FEW	15000.00	FEW	22000.00	—	—	—	—
KDEN	2020-01-01T10:53:00.000000Z	METAR	2020-01-01	33.00	15.10	47.10	210.00	13.00	—	29.570	1000.60	FEW	22000.00	—	—	—	—	—	—
KDEN	2020-01-01T11:53:00.000000Z	METAR	2020-01-01	32.00	16.00	51.20	210.00	11.00	—	29.580	1000.70	SCT	22000.00	—	—	—	—	—	—
KDEN	2020-01-01T12:53:00.000000Z	METAR	2020-01-01	36.00	18.00	47.58	200.00	12.00	—	29.560	1000.40	SCT	15000.00	BKN	22000.00	—	—	—	—
KDEN	2020-01-01T13:53:00.000000Z	METAR	2020-01-01	36.00	21.90	56.18	200.00	9.00	—	29.550	1000.60	SCT	13000.00	BKN	20000.00	—	—	—	—
KDEN	2020-01-01T14:53:00.000000Z	METAR	2020-01-01	38.00	21.90	52.13	200.00	7.00	—	29.520	999.30	SCT	13000.00	BKN	20000.00	—	—	—	—
KDEN	2020-01-01T15:53:00.000000Z	METAR	2020-01-01	37.00	23.00	56.57	220.00	7.00	—	29.540	1000.00	FEW	13000.00	BKN	20000.00	—	—	—	—
KDEN	2020-01-01T16:53:00.000000Z	METAR	2020-01-01	45.00	26.10	47.23	220.00	5.00	—	29.520	998.40	FEW	13000.00	FEW	15000.00	SCT	20000.00	—	—

Columns

Schema, units, meaning, and verified release profile

34 columns

Verified column analytics for reports_kden
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	KDEN100% Top: KDEN	—
event_time_utc	timestamp_utc	—	0.0%0 values	67,931100.0%	2024-02-15 17:50:00+000% 2024-04-01 12:50:00+000% 2020-01-01 07:53:00+000% Other (67,919) Top: 2024-02-15 17:50:00+00 · 67,919 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	METAR86% SPECI14% Top: METAR	—
local_standard_date	date	—	0.0%0 values	2,4433.6%	2025-04-180% 2023-06-040% 2024-04-200% Other (2,431) Top: 2025-04-18 · 67,178 more values	—
temp_f	decimal	—	<0.1%3 values	1850.3%	32.002% 63.002% 64.002% Other (173) Top: 32.00 · 54,215 more values	Median 52.00P25 35.00 · P75 67.00
dewpoint_f	decimal	—	<0.1%5 values	1570.2%	23.003% 18.003% 21.002% Other (145) Top: 23.00 · 49,806 more values	Median 29.00P25 19.00 · P75 43.00
relative_humidity_pct	decimal	—	<0.1%5 values	5,7538.5%	100.001% 92.150% 92.190% Other (5,741) Top: 100.00 · 66,223 more values	Median 49.39P25 29.91 · P75 74.06
wind_direction_degrees	decimal	—	3.9%2,650 values	37<0.1%	220.005% 210.005% 230.005% Other (25) Top: 220.00 · 36,104 more values	Median 190.00P25 90.00 · P75 250.00
wind_speed_kt	decimal	—	0.2%152 values	41<0.1%	7.0010% 8.0010% 6.009% Other (29) Top: 7.00 · 9,723 more values	Median 8.00P25 6.00 · P75 11.00
wind_gust_kt	decimal	—	86.6%58,839 values	450.5%	21.006% 24.006% 23.006% Other (33) Top: 21.00 · 3,254 more values	Median 24.00P25 20.00 · P75 29.00
altimeter_inhg	decimal	—	<0.1%1 values	1500.2%	30.0902% 30.1102% 30.1502% Other (138) Top: 30.090 · 49,671 more values	Median 30.070P25 29.920 · P75 30.180
sea_level_pressure_hpa	decimal	—	13.9%9,454 values	5520.9%	1013.401% 1011.901% 1012.001% Other (540) Top: 1013.40 · 54,048 more values	Median 1013.30P25 1008.80 · P75 1018.40
sky_cover_1	string	—	<0.1%5 values	6<0.1%	FEW55% SCT16% BKN12% Top: FEW	—
sky_base_1_ft	decimal	—	10.6%7,198 values	800.1%	10000.0011% 22000.009% 9000.008% Other (68) Top: 10000.00 · 23,016 more values	Median 9000.00P25 4000.00 · P75 12000.00
sky_cover_2	string	—	36.2%24,605 values	4<0.1%	BKN37% SCT28% FEW25% Top: BKN	—
sky_base_2_ft	decimal	—	36.2%24,605 values	760.2%	22000.0019% 15000.0011% 14000.0010% Other (64) Top: 22000.00 · 11,268 more values	Median 14000.00P25 8500.00 · P75 20000.00
sky_cover_3	string	—	66.3%45,060 values	4<0.1%	BKN60% SCT19% OVC15% Top: BKN	—
sky_base_3_ft	decimal	—	66.3%45,060 values	700.3%	22000.0043% 20000.0017% 15000.004% Other (58) Top: 22000.00 · 3,694 more values	Median 20000.00P25 13000.00 · P75 22000.00
sky_cover_4	string	—	96.5%65,586 values	40.2%	BKN88% OVC6% SCT5% Top: BKN	—
sky_base_4_ft	decimal	—	96.5%65,586 values	140.6%	22000.0049% 20000.0034% 18000.004% Other (2) Top: 22000.00 · 5 more values	Median 22000.00P25 20000.00 · P75 22000.00

Show 14 more columns

Verified column analytics for reports_kden
visibility_miles	decimal	—	<0.1%4 values	19<0.1%	10.0084% 9.002% 8.001% Other (7) Top: 10.00 · 2,227 more values	Median 10.00P25 10.00 · P75 10.00
weather_codes	string	—	84.1%57,140 values	960.9%	-SN BR26% BR15% -SN14% Other (84) Top: -SN BR · 1,327 more values	—
precipitation_in_1h	decimal	—	8.3%5,667 values	640.1%	0.00094% 0.0103% 0.0201% Other (52) Top: 0.000 · 267 more values	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt	decimal	—	90.2%61,295 values	360.5%	26.0012% 27.0012% 28.0011% Other (24) Top: 26.00 · 1,068 more values	Median 30.00P25 28.00 · P75 35.00
peak_wind_direction_degrees	decimal	—	90.2%61,295 values	370.6%	10.006% 280.005% 360.005% Other (25) Top: 10.00 · 3,178 more values	Median 220.00P25 120.00 · P75 300.00
peak_wind_time	string	—	90.2%61,295 values	5,47182.4%	2026-03-15 07:550% 2020-06-06 22:010% 2022-07-14 23:580% Other (5,459) Top: 2026-03-15 07:55 · 6,570 more values	—
snow_depth_inches	decimal	—	100.0%67,933 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	67,933100.0%	KDEN 010001Z 19020G34KT 10SM -RA FEW090 SCT120 BKN160 BKN220 24/16 A3012 RMK AO2 PK WND 19034/2355 WSHFT 2342 OCNL LTGCG DSNT SE CB DSNT SE MOV E P0000 T024401560% KDEN 010004Z 34024G30KT 5SM VCTS +RA FEW047 BKN065CB BKN100 14/12 A3003 RMK AO2 PK WND 33030/0004 WSHFT 2346 LTG DSNT N AND NE TSE00 PRESFR OCNL LTGICCG VC N TS VC N MOV NE P0003 T013901170% KDEN 010008Z 20017G26KT 10SM FEW080 SCT120 BKN200 27/07 A3029 RMK AO2 PK WND 22026/0005 WSHFT 2354 LTG DSNT N AND NE T026700720% Other (67,921) Top: KDEN 010001Z 19020G34KT 10SM -RA FEW090 SCT120 BKN160 BKN220 24/16 A3012 RMK AO2 PK WND 19034/2355 WSHFT 2342 OCNL LTGCG DSNT SE CB DSNT SE MOV E P0000 T02440156 · 67,921 more values	—
cli_product	string	—	0.0%0 values	1<0.1%	CLIDEN100% Top: CLIDEN	—
cli_high_f	integer	—	0.0%0 values	1010.1%	-6103 All-row histogram	Median 68P25 50 · P75 84
cli_low_f	integer	—	0.0%0 values	900.1%	-2474 All-row histogram	Median 38P25 25 · P75 54
cli_report_type	string	—	0.0%0 values	3<0.1%	final97% correction3% preliminary0% Top: final	—
metar_high_f	decimal	—	0.0%0 values	1120.2%	90.002% 68.002% 50.002% Other (100) Top: 90.00 · 52,843 more values	Median 66.00P25 49.00 · P75 83.00
metar_low_f	decimal	—	0.0%0 values	1220.2%	59.003% 30.003% 58.002% Other (110) Top: 59.00 · 49,940 more values	Median 39.00P25 26.00 · P75 55.00

Release status

Facts from the current passing release

Release: Passing
Rows: 67,933
Columns: 34
Published: 9 Sept 2026, 06:27
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_kden

reports_kden

# Current release — the complete Parquet file
curl -sS -o reports-kden.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/f604359d-ea24-42c0-b9b0-29bcd2a3a81d/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/f604359d-ea24-42c0-b9b0-29bcd2a3a81d/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/f604359d-ea24-42c0-b9b0-29bcd2a3a81d/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

Denver weather reports and daily highs since 2020

reports_kden

Release status