reports_knyc

Release V4 publication snapshot

Current data

Latest passing release for each Table

Updated 4 Sept 2026, 09:28

Rows: 74,043; across released Tables
Tables: 1; released
Columns: 32; reports_knyc
Version: V4 publication snapshot; reports_knyc

Data preview

reports_knyc

Preview rows for reports_knyc
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
KNYC	2020-01-01T00:51:00.000000Z	METAR	2019-12-31	44.00	36.00	72.99	200.00	7.00	—	29.640	1002.80	BKN	4900.00	OVC	6000.00	—	—	—	—	10.00	—	0.000	—	—	—	—	KNYC 010051Z AUTO 20007KT 10SM BKN049 OVC060 07/02 A2964 RMK AO2 SLP028 T00670022 $	—	—	—	—
KNYC	2020-01-01T01:51:00.000000Z	METAR	2019-12-31	43.00	35.00	73.45	280.00	12.00	20.00	29.660	1003.50	SCT	2400.00	BKN	3100.00	OVC	4600.00	—	—	9.00	-RA	0.020	—	—	—	—	KNYC 010151Z AUTO 28012G20KT 260V320 9SM -RA SCT024 BKN031 OVC046 06/02 A2966 RMK AO2 RAB07 SLP035 P0002 T00610017 $	—	—	—	—
KNYC	2020-01-01T02:51:00.000000Z	METAR	2019-12-31	43.00	33.00	67.82	280.00	7.00	—	29.650	1003.30	OVC	5500.00	—	—	—	—	—	—	10.00	-RA	—	—	—	—	—	KNYC 010251Z AUTO 28007KT 10SM -RA OVC055 06/01 A2965 RMK AO2 RAE12B47 SLP033 P0000 60002 T00610006 53 001 $	—	—	—	—
KNYC	2020-01-01T03:51:00.000000Z	METAR	2019-12-31	42.00	30.00	61.94	270.00	7.00	15.00	29.650	1003.40	BKN	6500.00	BKN	8000.00	OVC	9500.00	—	—	10.00	—	—	—	—	—	—	KNYC 010351Z AUTO 27007G15KT 10SM BKN065 BKN080 OVC095 06/M01 A2965 RMK AO2 RAE00 SLP034 P0000 T00561011 $	—	—	—	—
KNYC	2020-01-01T04:51:00.000000Z	METAR	2019-12-31	41.00	28.00	59.55	270.00	9.00	17.00	29.660	1003.50	OVC	6000.00	—	—	—	—	—	—	10.00	—	0.000	—	—	—	—	KNYC 010451Z AUTO 27009G17KT 240V310 10SM OVC060 05/M02 A2966 RMK AO2 SLP035 T00501022 400720022 $	—	—	—	—
KNYC	2020-01-01T05:51:00.000000Z	METAR	2020-01-01	40.00	26.10	57.47	270.00	7.00	—	29.660	1003.70	BKN	8000.00	OVC	10000.00	—	—	—	—	10.00	—	0.000	—	—	—	—	KNYC 010551Z AUTO 27007KT 210V290 10SM BKN080 OVC100 04/M03 A2966 RMK AO2 SLP037 60002 T00441033 10072 20044 53004 $	CLINYC	41	34	final
KNYC	2020-01-01T06:51:00.000000Z	METAR	2020-01-01	39.00	27.00	61.78	280.00	7.00	15.00	29.670	1004.00	BKN	7000.00	OVC	10000.00	—	—	—	—	10.00	—	0.000	—	—	—	—	KNYC 010651Z AUTO 28007G15KT 10SM BKN070 OVC100 04/M03 A2967 RMK AO2 SLP040 T00391028 $	CLINYC	41	34	final
KNYC	2020-01-01T07:51:00.000000Z	METAR	2020-01-01	39.00	26.10	59.52	260.00	12.00	20.00	29.680	1004.30	FEW	7000.00	OVC	9000.00	—	—	—	—	10.00	—	0.000	—	—	—	—	KNYC 010751Z AUTO 26012G20KT 10SM FEW070 OVC090 04/M03 A2968 RMK AO2 SLP043 T00391033 $	CLINYC	41	34	final
KNYC	2020-01-01T08:51:00.000000Z	METAR	2020-01-01	39.00	24.10	54.77	250.00	10.00	20.00	29.700	1004.80	OVC	7500.00	—	—	—	—	—	—	10.00	—	0.000	—	—	—	—	KNYC 010851Z AUTO 25010G20KT 10SM OVC075 04/M04 A2970 RMK AO2 SLP048 T00391044 53010 $	CLINYC	41	34	final
KNYC	2020-01-01T09:51:00.000000Z	METAR	2020-01-01	38.00	23.00	54.60	—	5.00	17.00	29.700	1004.80	OVC	6500.00	—	—	—	—	—	—	10.00	—	0.000	—	—	—	—	KNYC 010951Z AUTO VRB05G17KT 10SM OVC065 03/M05 A2970 RMK AO2 SLP048 T00331050 $	CLINYC	41	34	final

Columns

Schema, units, meaning, and verified release profile

32 columns

Verified column analytics for reports_knyc
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station0 source inputs · 4 transformations	string	—	0.0%0 values	1<0.1%	KNYC100% Top: KNYC	—
event_time_utc0 source inputs · 4 transformations	timestamp_utc	—	0.0%0 values	74,043100.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%	METAR79% SPECI21% Top: METAR	—
local_standard_date0 source inputs · 4 transformations	date	—	0.0%0 values	2,4383.3%	2019-01-012026-01-01 per year All rows, per year	—
temp_f0 source inputs · 4 transformations	decimal	—	0.2%131 values	1420.2%	3.00100.00 All-row histogram	Median 57.00P25 44.00 · P75 71.00
dewpoint_f0 source inputs · 4 transformations	decimal	—	0.2%170 values	1520.2%	-15.0080.00 All-row histogram	Median 46.00P25 30.00 · P75 60.00
relative_humidity_pct0 source inputs · 4 transformations	decimal	—	0.2%170 values	4,8246.5%	7.20100.00 All-row histogram	Median 66.62P25 48.91 · P75 86.16
wind_direction_degrees0 source inputs · 4 transformations	decimal	—	39.0%28,853 values	38<0.1%	0.00360.00 All-row histogram	Median 60.00P25 0.00 · P75 260.00
wind_speed_kt0 source inputs · 4 transformations	decimal	—	9.1%6,740 values	28<0.1%	0.00155.51 All-row histogram	Median 4.00P25 3.00 · P75 6.00
wind_gust_kt0 source inputs · 4 transformations	decimal	—	84.0%62,202 values	310.3%	14.0046.00 All-row histogram	Median 18.00P25 16.00 · P75 21.00
altimeter_inhg0 source inputs · 4 transformations	decimal	—	0.3%229 values	2100.3%	2.98032.480 All-row histogram	Median 30.020P25 29.880 · P75 30.170
sea_level_pressure_hpa0 source inputs · 4 transformations	decimal	—	21.9%16,189 values	5971.0%	975.201112.20 All-row histogram	Median 1016.30P25 1011.60 · P75 1021.40
sky_cover_10 source inputs · 4 transformations	string	—	0.8%564 values	6<0.1%	CLR41% OVC22% BKN15% Top: CLR	—
sky_base_1_ft0 source inputs · 4 transformations	decimal	—	41.4%30,618 values	630.1%	100.0012000.00 All-row histogram	Median 2000.00P25 900.00 · P75 5000.00
sky_cover_20 source inputs · 4 transformations	string	—	76.2%56,431 values	4<0.1%	OVC44% BKN43% SCT11% Top: OVC	—
sky_base_2_ft0 source inputs · 4 transformations	decimal	—	76.2%56,432 values	590.3%	600.0020000.00 All-row histogram	Median 3700.00P25 2200.00 · P75 6500.00
sky_cover_30 source inputs · 4 transformations	string	—	90.5%67,000 values	4<0.1%	OVC80% BKN18% SCT2% Top: OVC	—
sky_base_3_ft0 source inputs · 4 transformations	decimal	—	90.5%67,000 values	530.8%	1100.0012000.00 All-row histogram	Median 6000.00P25 3700.00 · P75 9000.00
sky_cover_40 source inputs · 4 transformations	string	—	100.0%74,043 values	00.0%	0 distinct values, no chart No shape worth drawing	—
sky_base_4_ft0 source inputs · 4 transformations	decimal	—	100.0%74,043 values	00.0%	0 distinct values, no chart No shape worth drawing	—

Show 12 more columns

Verified column analytics for reports_knyc
visibility_miles0 source inputs · 4 transformations	decimal	—	0.3%238 values	18<0.1%	0.0010.00 All-row histogram	Median 10.00P25 7.00 · P75 10.00
weather_codes0 source inputs · 4 transformations	string	—	74.8%55,402 values	290.2%	-RA BR31% BR28% -RA12% Other (17) Top: -RA BR · 437 more values	—
precipitation_in_1h0 source inputs · 4 transformations	decimal	—	6.9%5,140 values	1210.2%	0.0003.150 All-row histogram	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt0 source inputs · 4 transformations	decimal	—	96.8%71,661 values	210.9%	26.0059.00 All-row histogram	Median 28.00P25 27.00 · P75 31.00
peak_wind_direction_degrees0 source inputs · 4 transformations	decimal	—	96.8%71,661 values	361.5%	10.00360.00 All-row histogram	Median 270.00P25 130.00 · P75 300.00
peak_wind_time0 source inputs · 4 transformations	string	—	96.8%71,661 values	1,96482.5%	1,964 distinct values, no chart No shape worth drawing · 2,382 more values	—
snow_depth_inches0 source inputs · 4 transformations	decimal	—	100.0%74,043 values	00.0%	0 distinct values, no chart No shape worth drawing	—
raw_metar0 source inputs · 4 transformations	string	—	0.0%0 values	74,043100.0%	74,043 distinct values, no chart No shape worth drawing · 74,043 more values	—
cli_product0 source inputs · 4 transformations	string	—	<0.1%53 values	1<0.1%	CLINYC100% Top: CLINYC	—
cli_high_f0 source inputs · 4 transformations	integer	—	<0.1%53 values	850.1%	15100 All-row histogram	Median 65P25 50 · P75 79
cli_low_f0 source inputs · 4 transformations	integer	—	<0.1%53 values	780.1%	382 All-row histogram	Median 50P25 38 · P75 65
cli_report_type0 source inputs · 4 transformations	string	—	<0.1%53 values	3<0.1%	final99% correction1% preliminary0% Top: final	—

Release status

Facts from the current passing release

Release: V4 publication snapshot
Rows: 74,043
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_knyc

reports_knyc

# Current release — the complete Parquet file
curl -sS -o reports-knyc.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/cdc8c2aa-4ccd-43da-ac53-90b2850121cb/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/cdc8c2aa-4ccd-43da-ac53-90b2850121cb/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/cdc8c2aa-4ccd-43da-ac53-90b2850121cb/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_knyc

Release status