reports_kphl

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:30

Rows: 74,249; across released Tables
Tables: 1; released
Columns: 34; reports_kphl
Version: —; reports_kphl

Data preview

reports_kphl

Preview rows for reports_kphl
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
KPHL	2020-01-01T05:54:00.000000Z	METAR	2020-01-01	42.00	24.10	48.56	280.00	9.00	18.00	29.710	1006.10	BKN	6000.00	BKN	8000.00	—	—	—	—
KPHL	2020-01-01T06:54:00.000000Z	METAR	2020-01-01	41.00	24.10	50.67	270.00	12.00	—	29.720	1006.40	SCT	6000.00	OVC	8500.00	—	—	—	—
KPHL	2020-01-01T07:54:00.000000Z	METAR	2020-01-01	41.00	24.10	50.67	270.00	10.00	—	29.740	1006.90	FEW	6000.00	OVC	8500.00	—	—	—	—
KPHL	2020-01-01T08:54:00.000000Z	METAR	2020-01-01	41.00	24.10	50.67	290.00	10.00	—	29.750	1007.30	BKN	4300.00	BKN	5000.00	OVC	8000.00	—	—
KPHL	2020-01-01T09:54:00.000000Z	METAR	2020-01-01	39.00	25.00	56.86	310.00	10.00	—	29.760	1007.70	OVC	4900.00	—	—	—	—	—	—
KPHL	2020-01-01T10:54:00.000000Z	METAR	2020-01-01	38.00	26.10	62.14	280.00	7.00	—	29.770	1008.00	FEW	4300.00	OVC	6000.00	—	—	—	—
KPHL	2020-01-01T11:54:00.000000Z	METAR	2020-01-01	38.00	25.00	59.36	290.00	9.00	—	29.780	1008.50	FEW	4000.00	OVC	5500.00	—	—	—	—
KPHL	2020-01-01T12:54:00.000000Z	METAR	2020-01-01	38.00	25.00	59.36	280.00	10.00	—	29.800	1008.90	OVC	4000.00	—	—	—	—	—	—
KPHL	2020-01-01T13:54:00.000000Z	METAR	2020-01-01	38.00	24.10	57.18	290.00	10.00	—	29.820	1009.70	OVC	5500.00	—	—	—	—	—	—
KPHL	2020-01-01T14:54:00.000000Z	METAR	2020-01-01	38.00	24.10	57.18	290.00	11.00	18.00	29.840	1010.60	OVC	6000.00	—	—	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

34 columns

Verified column analytics for reports_kphl
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	KPHL100% Top: KPHL	—
event_time_utc	timestamp_utc	—	0.0%0 values	74,249100.0%	2020-01-01 05:54:00+000% 2020-01-01 06:54:00+000% 2020-01-01 07:54:00+000% Other (74,237) Top: 2020-01-01 05:54:00+00 · 74,237 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,4433.3%	2024-04-030% 2020-08-040% 2025-05-140% Other (2,431) Top: 2024-04-03 · 73,400 more values	—
temp_f	decimal	—	<0.1%12 values	1410.2%	75.002% 73.002% 76.002% Other (129) Top: 75.00 · 55,778 more values	Median 59.00P25 45.00 · P75 73.00
dewpoint_f	decimal	—	<0.1%13 values	1460.2%	70.002% 68.002% 61.002% Other (134) Top: 70.00 · 57,120 more values	Median 48.00P25 32.00 · P75 62.00
relative_humidity_pct	decimal	—	<0.1%13 values	4,6836.3%	100.002% 90.400% 92.770% Other (4,671) Top: 100.00 · 71,289 more values	Median 69.82P25 50.14 · P75 87.05
wind_direction_degrees	decimal	—	2.2%1,652 values	37<0.1%	0.008% 230.005% 200.004% Other (25) Top: 0.00 · 38,249 more values	Median 200.00P25 70.00 · P75 280.00
wind_speed_kt	decimal	—	<0.1%47 values	40<0.1%	6.0010% 5.0010% 4.009% Other (28) Top: 6.00 · 8,347 more values	Median 7.00P25 4.00 · P75 10.00
wind_gust_kt	decimal	—	86.4%64,128 values	450.4%	21.009% 22.008% 20.008% Other (33) Top: 21.00 · 2,207 more values	Median 22.00P25 19.00 · P75 26.00
altimeter_inhg	decimal	—	<0.1%16 values	2000.3%	29.9702% 30.0102% 30.0002% Other (188) Top: 29.970 · 56,570 more values	Median 30.010P25 29.870 · P75 30.160
sea_level_pressure_hpa	decimal	—	21.1%15,650 values	5871.0%	1014.801% 1016.701% 1014.901% Other (575) Top: 1014.80 · 54,199 more values	Median 1016.70P25 1012.30 · P75 1021.80
sky_cover_1	string	—	<0.1%21 values	6<0.1%	FEW31% BKN24% SCT23% Top: FEW	—
sky_base_1_ft	decimal	—	8.4%6,258 values	940.1%	25000.005% 5000.004% 6000.004% Other (82) Top: 25000.00 · 42,297 more values	Median 4500.00P25 1400.00 · P75 8500.00
sky_cover_2	string	—	42.3%31,440 values	4<0.1%	BKN48% OVC23% SCT22% Top: BKN	—
sky_base_2_ft	decimal	—	42.3%31,440 values	900.2%	25000.008% 10000.004% 28000.004% Other (78) Top: 25000.00 · 25,792 more values	Median 8500.00P25 3600.00 · P75 20000.00
sky_cover_3	string	—	72.5%53,866 values	4<0.1%	OVC45% BKN45% SCT10% Top: OVC	—
sky_base_3_ft	decimal	—	72.5%53,866 values	840.4%	25000.0011% 26000.005% 11000.005% Other (72) Top: 25000.00 · 10,139 more values	Median 12000.00P25 6500.00 · P75 25000.00
sky_cover_4	string	—	95.0%70,556 values	3<0.1%	BKN68% OVC29% SCT4% Top: BKN	—
sky_base_4_ft	decimal	—	95.0%70,556 values	230.6%	25000.0023% 26000.0014% 13000.008% Other (11) Top: 25000.00 · 552 more values	Median 25000.00P25 20000.00 · P75 26000.00

Show 14 more columns

Verified column analytics for reports_kphl
visibility_miles	decimal	—	<0.1%12 values	21<0.1%	10.0076% 7.004% 5.003% Other (9) Top: 10.00 · 1,617 more values	Median 10.00P25 10.00 · P75 10.00
weather_codes	string	—	76.7%56,941 values	1140.7%	-RA24% BR20% -RA BR17% Other (102) Top: -RA · 2,103 more values	—
precipitation_in_1h	decimal	—	10.0%7,455 values	1180.2%	0.00087% 0.0104% 0.0202% Other (106) Top: 0.000 · 1,484 more values	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt	decimal	—	93.3%69,242 values	320.6%	26.0016% 27.0014% 28.0012% Other (20) Top: 26.00 · 473 more values	Median 29.00P25 27.00 · P75 33.00
peak_wind_direction_degrees	decimal	—	93.3%69,242 values	360.7%	280.009% 320.008% 330.008% Other (24) Top: 280.00 · 1,333 more values	Median 280.00P25 230.00 · P75 310.00
peak_wind_time	string	—	93.3%69,242 values	4,06481.2%	2023-04-01 23:020% 2025-06-19 21:290% 2025-07-08 22:020% Other (4,052) Top: 2023-04-01 23:02 · 4,925 more values	—
snow_depth_inches	decimal	—	100.0%74,249 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	74,249100.0%	KPHL 010006Z 19016G32KT 9SM BKN017 BKN023 OVC060 19/15 A2949 RMK AO2 PK WND 18032/2357 T018901500% KPHL 010008Z 13005KT 8SM -RA BKN015 OVC022 17/16 A2913 RMK AO2 RAB08 P0000 T01720156 $0% KPHL 010010Z 17012KT 7SM -RA BKN012 BKN018 OVC095 16/14 A2971 RMK AO2 P0004 T01610139 CHINO W IEM_GHCNH0% Other (74,237) Top: KPHL 010006Z 19016G32KT 9SM BKN017 BKN023 OVC060 19/15 A2949 RMK AO2 PK WND 18032/2357 T01890150 · 74,237 more values	—
cli_product	string	—	0.0%0 values	1<0.1%	CLIPHL100% Top: CLIPHL	—
cli_high_f	integer	—	0.0%0 values	830.1%	18103 All-row histogram	Median 68P25 53 · P75 82
cli_low_f	integer	—	0.0%0 values	760.1%	782 All-row histogram	Median 50P25 37 · P75 65
cli_report_type	string	—	0.0%0 values	3<0.1%	final99% correction1% preliminary0% Top: final	—
metar_high_f	decimal	—	0.0%0 values	1050.1%	82.002% 84.002% 87.002% Other (93) Top: 82.00 · 54,910 more values	Median 68.00P25 52.00 · P75 82.00
metar_low_f	decimal	—	0.0%0 values	1070.1%	70.003% 73.002% 50.002% Other (95) Top: 70.00 · 54,105 more values	Median 50.00P25 37.00 · P75 66.00

Release status

Facts from the current passing release

Release: Passing
Rows: 74,249
Columns: 34
Published: 9 Sept 2026, 06:30
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_kphl

reports_kphl

# Current release — the complete Parquet file
curl -sS -o reports-kphl.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/74906801-245c-474d-94c0-2e6ab7990458/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/74906801-245c-474d-94c0-2e6ab7990458/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/74906801-245c-474d-94c0-2e6ab7990458/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

Philadelphia weather reports and daily highs since 2020

reports_kphl

Release status