reports_knyc

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:25

Rows: 74,218; across released Tables
Tables: 1; released
Columns: 34; reports_knyc
Version: —; 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
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	—	—	—	—
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	—	—	—	—
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	—	—	—	—
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	—	—	—	—	—	—
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	—	—	—	—	—	—
KNYC	2020-01-01T10:51:00.000000Z	METAR	2020-01-01	37.00	21.90	54.01	—	3.00	18.00	29.710	1005.30	OVC	6000.00	—	—	—	—	—	—
KNYC	2020-01-01T11:51:00.000000Z	METAR	2020-01-01	37.00	25.00	61.50	260.00	7.00	—	29.720	1005.60	OVC	6500.00	—	—	—	—	—	—
KNYC	2020-01-01T12:51:00.000000Z	METAR	2020-01-01	37.40	24.80	60.04	270.00	7.00	15.00	29.730	—	OVC	6000.00	—	—	—	—	—	—
KNYC	2020-01-01T13:51:00.000000Z	METAR	2020-01-01	37.00	21.90	54.01	270.00	10.00	20.00	29.760	1006.80	OVC	6000.00	—	—	—	—	—	—
KNYC	2020-01-01T14:51:00.000000Z	METAR	2020-01-01	38.00	21.90	52.13	—	5.00	—	29.780	1007.60	OVC	6000.00	—	—	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

34 columns

Verified column analytics for reports_knyc
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	KNYC100% Top: KNYC	—
event_time_utc	timestamp_utc	—	0.0%0 values	74,218100.0%	2020-01-01 05:51:00+000% 2020-01-01 06:51:00+000% 2020-01-01 07:51:00+000% Other (74,206) Top: 2020-01-01 05:51:00+00 · 74,206 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	METAR79% SPECI21% Top: METAR	—
local_standard_date	date	—	0.0%0 values	2,4443.3%	2024-08-180% 2023-09-180% 2024-12-280% Other (2,432) Top: 2024-08-18 · 73,296 more values	—
temp_f	decimal	—	0.2%131 values	1420.2%	73.003% 72.002% 74.002% Other (130) Top: 73.00 · 54,826 more values	Median 57.20P25 44.00 · P75 71.00
dewpoint_f	decimal	—	0.2%170 values	1520.2%	70.002% 59.002% 69.002% Other (140) Top: 70.00 · 57,225 more values	Median 46.00P25 30.00 · P75 60.00
relative_humidity_pct	decimal	—	0.2%170 values	4,8246.5%	100.001% 93.430% 93.290% Other (4,812) Top: 100.00 · 70,935 more values	Median 66.62P25 48.95 · P75 86.17
wind_direction_degrees	decimal	—	39.0%28,929 values	38<0.1%	0.0032% 60.006% 300.006% Other (26) Top: 0.00 · 10,991 more values	Median 60.00P25 0.00 · P75 260.00
wind_speed_kt	decimal	—	9.1%6,747 values	28<0.1%	0.0022% 3.0018% 4.0016% Other (16) Top: 0.00 · 635 more values	Median 4.00P25 3.00 · P75 6.00
wind_gust_kt	decimal	—	84.0%62,375 values	310.3%	16.0013% 17.0013% 15.0013% Other (19) Top: 16.00 · 953 more values	Median 18.00P25 16.00 · P75 21.00
altimeter_inhg	decimal	—	0.3%229 values	2100.3%	29.9902% 30.0302% 30.0402% Other (198) Top: 29.990 · 57,254 more values	Median 30.020P25 29.880 · P75 30.170
sea_level_pressure_hpa	decimal	—	21.9%16,219 values	5971.0%	1015.901% 1016.101% 1016.201% Other (585) Top: 1015.90 · 53,832 more values	Median 1016.30P25 1011.60 · P75 1021.40
sky_cover_1	string	—	0.8%564 values	6<0.1%	CLR41% OVC22% BKN15% Top: CLR	—
sky_base_1_ft	decimal	—	41.4%30,699 values	630.1%	900.005% 800.004% 500.004% Other (51) Top: 900.00 · 25,610 more values	Median 2000.00P25 900.00 · P75 5000.00
sky_cover_2	string	—	76.2%56,569 values	4<0.1%	OVC44% BKN43% SCT11% Top: OVC	—
sky_base_2_ft	decimal	—	76.2%56,570 values	590.3%	6000.004% 7000.004% 5000.004% Other (47) Top: 6000.00 · 11,104 more values	Median 3700.00P25 2200.00 · P75 6500.00
sky_cover_3	string	—	90.5%67,158 values	4<0.1%	OVC80% BKN18% SCT2% Top: OVC	—
sky_base_3_ft	decimal	—	90.5%67,158 values	530.8%	11000.008% 10000.006% 7000.006% Other (41) Top: 11000.00 · 3,050 more values	Median 6000.00P25 3700.00 · P75 9000.00
sky_cover_4	string	—	100.0%74,218 values	00.0%	No distribution published No distribution published	—
sky_base_4_ft	decimal	—	100.0%74,218 values	00.0%	No distribution published No distribution published	—

Show 14 more columns

Verified column analytics for reports_knyc
visibility_miles	decimal	—	0.3%238 values	18<0.1%	10.0069% 3.004% 9.003% Other (6) Top: 10.00 · 2,235 more values	Median 10.00P25 7.00 · P75 10.00
weather_codes	string	—	74.9%55,557 values	290.2%	-RA BR31% BR28% -RA12% Other (17) Top: -RA BR · 437 more values	—
precipitation_in_1h	decimal	—	6.9%5,146 values	1210.2%	0.00084% 0.0104% 0.0202% Other (109) Top: 0.000 · 1,913 more values	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt	decimal	—	96.8%71,836 values	210.9%	26.0021% 27.0018% 28.0014% Other (9) Top: 26.00 · 83 more values	Median 28.00P25 27.00 · P75 31.00
peak_wind_direction_degrees	decimal	—	96.8%71,836 values	361.5%	300.0013% 290.0010% 280.009% Other (24) Top: 300.00 · 610 more values	Median 270.00P25 130.00 · P75 300.00
peak_wind_time	string	—	96.8%71,836 values	1,96482.5%	2021-09-01 21:210% 2022-03-12 22:190% 2024-06-14 22:520% Other (1,952) Top: 2021-09-01 21:21 · 2,318 more values	—
snow_depth_inches	decimal	—	100.0%74,218 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	74,218100.0%	KNYC 010003Z AUTO 00000KT 10SM BKN026 OVC100 16/12 A3004 RMK AO2 T01610122 $0% KNYC 010004Z AUTO 00000KT 4SM BR CLR 23/22 A2989 RMK AO2 T02280217 $0% KNYC 010006Z AUTO 00000KT 1 1/2SM -RA BR OVC005 10/09 A2986 RMK AO2 CIG 004V008 P0000 T010000890% Other (74,206) Top: KNYC 010003Z AUTO 00000KT 10SM BKN026 OVC100 16/12 A3004 RMK AO2 T01610122 $ · 74,206 more values	—
cli_product	string	—	<0.1%49 values	1<0.1%	CLINYC100% Top: CLINYC	—
cli_high_f	integer	—	<0.1%49 values	850.1%	15100 All-row histogram	Median 65P25 50 · P75 79
cli_low_f	integer	—	<0.1%49 values	780.1%	382 All-row histogram	Median 50P25 38 · P75 65
cli_report_type	string	—	<0.1%49 values	3<0.1%	final99% correction1% preliminary0% Top: final	—
metar_high_f	decimal	—	0.0%0 values	1100.1%	80.003% 79.003% 81.003% Other (98) Top: 80.00 · 54,528 more values	Median 65.00P25 50.00 · P75 78.00
metar_low_f	decimal	—	0.0%0 values	1130.2%	69.003% 37.002% 66.002% Other (101) Top: 69.00 · 53,864 more values	Median 51.00P25 38.00 · P75 65.00

Release status

Facts from the current passing release

Release: Passing
Rows: 74,218
Columns: 34
Published: 9 Sept 2026, 06:25
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_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/da92a734-5290-4159-8ae0-037ebd8ba51a/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/da92a734-5290-4159-8ae0-037ebd8ba51a/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/da92a734-5290-4159-8ae0-037ebd8ba51a/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

New York City weather reports and daily highs since 2020

reports_knyc

Release status