reports_kttn

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:32

Rows: 73,232; across released Tables
Tables: 1; released
Columns: 34; reports_kttn
Version: —; reports_kttn

Data preview

reports_kttn

Preview rows for reports_kttn
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
KTTN	2020-01-01T05:53:00.000000Z	METAR	2020-01-01	39.00	28.90	66.79	270.00	5.00	—	29.680	1004.40	FEW	6000.00	BKN	8000.00	OVC	9000.00	—	—
KTTN	2020-01-01T06:53:00.000000Z	METAR	2020-01-01	38.00	28.00	67.20	270.00	4.00	—	29.680	1004.70	BKN	5000.00	OVC	9000.00	—	—	—	—
KTTN	2020-01-01T07:53:00.000000Z	METAR	2020-01-01	39.00	27.00	61.78	300.00	8.00	15.00	29.700	1005.40	OVC	4000.00	—	—	—	—	—	—
KTTN	2020-01-01T08:53:00.000000Z	METAR	2020-01-01	37.00	25.00	61.50	310.00	9.00	—	29.710	1005.60	SCT	3500.00	BKN	4300.00	OVC	6000.00	—	—
KTTN	2020-01-01T09:53:00.000000Z	METAR	2020-01-01	37.00	25.00	61.50	280.00	5.00	—	29.720	1006.10	SCT	4800.00	OVC	6000.00	—	—	—	—
KTTN	2020-01-01T10:53:00.000000Z	METAR	2020-01-01	37.00	24.10	59.24	270.00	6.00	—	29.730	1006.30	BKN	4800.00	OVC	6000.00	—	—	—	—
KTTN	2020-01-01T11:53:00.000000Z	METAR	2020-01-01	36.00	25.00	63.98	270.00	8.00	—	29.740	1006.70	BKN	4600.00	OVC	6000.00	—	—	—	—
KTTN	2020-01-01T12:53:00.000000Z	METAR	2020-01-01	37.00	23.00	56.57	280.00	13.00	20.00	29.760	1007.10	OVC	4700.00	—	—	—	—	—	—
KTTN	2020-01-01T13:53:00.000000Z	METAR	2020-01-01	36.00	21.90	56.18	300.00	10.00	16.00	29.790	1008.10	BKN	4200.00	OVC	5000.00	—	—	—	—
KTTN	2020-01-01T14:53:00.000000Z	METAR	2020-01-01	36.00	21.90	56.18	300.00	14.00	21.00	29.800	1008.70	OVC	4500.00	—	—	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

34 columns

Verified column analytics for reports_kttn
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	KTTN100% Top: KTTN	—
event_time_utc	timestamp_utc	—	0.0%0 values	73,224100.0%	2022-11-16 01:40:00+000% 2023-03-25 15:50:00+000% 2023-06-25 09:50:00+000% Other (73,212) Top: 2022-11-16 01:40:00+00 · 73,212 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%	2024-12-280% 2021-02-020% 2022-04-070% Other (2,431) Top: 2024-12-28 · 72,367 more values	—
temp_f	decimal	—	0.1%100 values	1480.2%	71.002% 73.002% 72.002% Other (136) Top: 71.00 · 55,551 more values	Median 56.00P25 41.00 · P75 70.00
dewpoint_f	decimal	—	0.1%101 values	1400.2%	70.002% 71.002% 61.002% Other (128) Top: 70.00 · 56,241 more values	Median 47.00P25 31.00 · P75 61.00
relative_humidity_pct	decimal	—	0.1%101 values	4,5856.3%	100.009% 96.280% 96.660% Other (4,573) Top: 100.00 · 64,108 more values	Median 75.56P25 55.07 · P75 92.86
wind_direction_degrees	decimal	—	4.1%3,013 values	38<0.1%	0.0015% 290.004% 340.004% Other (26) Top: 0.00 · 33,876 more values	Median 200.00P25 60.00 · P75 290.00
wind_speed_kt	decimal	—	0.5%369 values	34<0.1%	0.0015% 4.0013% 3.0012% Other (22) Top: 0.00 · 3,685 more values	Median 5.00P25 3.00 · P75 8.00
wind_gust_kt	decimal	—	85.2%62,419 values	400.4%	18.0010% 19.009% 20.009% Other (28) Top: 18.00 · 1,651 more values	Median 20.00P25 18.00 · P75 24.00
altimeter_inhg	decimal	—	0.1%104 values	2000.3%	30.0102% 29.9702% 30.0302% Other (188) Top: 30.010 · 56,190 more values	Median 30.000P25 29.860 · P75 30.140
sea_level_pressure_hpa	decimal	—	21.2%15,552 values	5891.0%	1014.501% 1016.001% 1016.201% Other (577) Top: 1014.50 · 53,398 more values	Median 1015.80P25 1011.20 · P75 1020.90
sky_cover_1	string	—	0.2%138 values	6<0.1%	CLR41% OVC19% BKN16% Top: CLR	—
sky_base_1_ft	decimal	—	41.3%30,272 values	620.1%	200.005% 400.004% 500.004% Other (50) Top: 200.00 · 24,305 more values	Median 2100.00P25 800.00 · P75 5000.00
sky_cover_2	string	—	75.4%55,208 values	4<0.1%	BKN44% OVC42% SCT11% Top: BKN	—
sky_base_2_ft	decimal	—	75.4%55,208 values	600.3%	6000.004% 7000.004% 11000.003% Other (48) Top: 6000.00 · 11,004 more values	Median 3600.00P25 1900.00 · P75 6500.00
sky_cover_3	string	—	89.8%65,751 values	4<0.1%	OVC82% BKN16% SCT2% Top: OVC	—
sky_base_3_ft	decimal	—	89.8%65,751 values	530.7%	11000.008% 7000.006% 6000.005% Other (41) Top: 11000.00 · 3,435 more values	Median 5500.00P25 3500.00 · P75 8500.00
sky_cover_4	string	—	100.0%73,232 values	00.0%	No distribution published No distribution published	—
sky_base_4_ft	decimal	—	100.0%73,232 values	00.0%	No distribution published No distribution published	—

Show 14 more columns

Verified column analytics for reports_kttn
visibility_miles	decimal	—	0.3%239 values	20<0.1%	10.0073% 3.003% 9.003% Other (8) Top: 10.00 · 2,807 more values	Median 10.00P25 9.00 · P75 10.00
weather_codes	string	—	75.1%55,032 values	610.3%	BR32% -RA BR18% -RA13% Other (49) Top: BR · 1,398 more values	—
precipitation_in_1h	decimal	—	8.0%5,844 values	1100.2%	0.00087% 0.0104% 0.0202% Other (98) Top: 0.000 · 1,490 more values	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt	decimal	—	95.4%69,872 values	260.8%	26.0019% 27.0015% 28.0013% Other (14) Top: 26.00 · 219 more values	Median 29.00P25 27.00 · P75 32.00
peak_wind_direction_degrees	decimal	—	95.4%69,872 values	361.1%	300.0010% 290.008% 310.007% Other (24) Top: 300.00 · 1,066 more values	Median 280.00P25 200.00 · P75 310.00
peak_wind_time	string	—	95.4%69,872 values	2,73181.3%	2021-05-26 21:550% 2020-07-10 18:050% 2020-07-10 15:560% Other (2,719) Top: 2021-05-26 21:55 · 3,276 more values	—
snow_depth_inches	decimal	—	100.0%73,232 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	73,232100.0%	KTTN 010001Z 15014G23KT 2SM +RA BR FEW009 OVC015 15/14 A2973 RMK AO2 PRESRR P0009 T015001390% KTTN 010004Z 08003KT 10SM -RA BKN014 BKN024 OVC070 16/16 A2916 RMK AO2 P0001 T015601560% KTTN 010005Z 10010KT 4SM VCTS RA BR FEW039 SCT046 OVC060 08/06 A2966 RMK AO2 LTG DSNT SW AND W LTG DSNT SW MVG E P0005 T00830061 $0% Other (73,220) Top: KTTN 010001Z 15014G23KT 2SM +RA BR FEW009 OVC015 15/14 A2973 RMK AO2 PRESRR P0009 T01500139 · 73,220 more values	—
cli_product	string	—	<0.1%49 values	1<0.1%	CLITTN100% Top: CLITTN	—
cli_high_f	integer	—	<0.1%49 values	840.1%	14101 All-row histogram	Median 66P25 50 · P75 80
cli_low_f	integer	—	0.1%83 values	780.1%	-178 All-row histogram	Median 46P25 33 · P75 61
cli_report_type	string	—	<0.1%49 values	3<0.1%	final99% correction1% preliminary0% Top: final	—
metar_high_f	decimal	—	0.0%0 values	1150.2%	83.002% 77.002% 79.002% Other (103) Top: 83.00 · 54,638 more values	Median 65.00P25 49.00 · P75 79.00
metar_low_f	decimal	—	0.0%0 values	1120.2%	71.002% 42.002% 32.002% Other (100) Top: 71.00 · 53,807 more values	Median 46.00P25 34.00 · P75 61.00

Release status

Facts from the current passing release

Release: Passing
Rows: 73,232
Columns: 34
Published: 9 Sept 2026, 06:32
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_kttn

reports_kttn

# Current release — the complete Parquet file
curl -sS -o reports-kttn.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/2876a712-7b35-48a7-8b69-e3f26106e115/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/2876a712-7b35-48a7-8b69-e3f26106e115/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/2876a712-7b35-48a7-8b69-e3f26106e115/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

Trenton weather reports and daily highs since 2020

reports_kttn

Release status