reports_kphx

Release V4 publication snapshot

Current data

Latest passing release for each Table

Updated 4 Sept 2026, 09:28

Rows: 60,487; across released Tables
Tables: 1; released
Columns: 32; reports_kphx
Version: V4 publication snapshot; reports_kphx

Data preview

reports_kphx

Preview rows for reports_kphx
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	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
KPHX	2020-01-01T00:51:00.000000Z	METAR	2019-12-31	56.00	34.00	43.46	90.00	5.00	—	30.000	1015.30	FEW	5500.00	FEW	7000.00	FEW	11000.00	SCT	20000.00	10.00	—	—	—	—	—	KPHX 010051Z 09005KT 10SM FEW055 FEW070 FEW110 SCT200 BKN270 13/01 A3000 RMK AO2 SLP153 T01330011	—	—	—	—
KPHX	2020-01-01T01:51:00.000000Z	METAR	2019-12-31	56.00	32.00	40.10	0.00	0.00	—	30.010	1015.60	FEW	11000.00	—	—	—	—	—	—	10.00	—	—	—	—	—	KPHX 010151Z 00000KT 10SM FEW110 13/00 A3001 RMK AO2 SLP156 T01330000	—	—	—	—
KPHX	2020-01-01T02:51:00.000000Z	METAR	2019-12-31	54.00	33.00	44.92	70.00	3.00	—	30.030	1016.50	FEW	20000.00	—	—	—	—	—	—	10.00	—	—	—	—	—	KPHX 010251Z 07003KT 10SM FEW200 12/01 A3003 RMK AO2 SLP165 T01220006 53015	—	—	—	—
KPHX	2020-01-01T03:51:00.000000Z	METAR	2019-12-31	51.00	35.00	54.13	120.00	3.00	—	30.030	1016.50	CLR	—	—	—	—	—	—	—	10.00	—	—	—	—	—	KPHX 010351Z 12003KT 10SM CLR 11/02 A3003 RMK AO2 SLP165 T01060017	—	—	—	—
KPHX	2020-01-01T04:51:00.000000Z	METAR	2019-12-31	51.00	34.00	51.81	0.00	0.00	—	30.050	1017.10	CLR	—	—	—	—	—	—	—	10.00	—	—	—	—	—	KPHX 010451Z 00000KT 10SM CLR 11/01 A3005 RMK AO2 SLP171 T01060011	—	—	—	—
KPHX	2020-01-01T05:51:00.000000Z	METAR	2019-12-31	49.00	33.00	54.24	0.00	0.00	—	30.060	1017.40	CLR	—	—	—	—	—	—	—	10.00	—	—	—	—	—	KPHX 010551Z 00000KT 10SM CLR 09/01 A3006 RMK AO2 SLP174 T00940006 10150 20089 53009	—	—	—	—
KPHX	2020-01-01T06:51:00.000000Z	METAR	2019-12-31	46.00	36.00	67.90	90.00	6.00	—	30.070	1017.60	CLR	—	—	—	—	—	—	—	10.00	—	—	—	—	—	KPHX 010651Z 09006KT 10SM CLR 08/02 A3007 RMK AO2 SLP176 T00780022 401500072	—	—	—	—
KPHX	2020-01-01T07:51:00.000000Z	METAR	2020-01-01	46.00	34.00	62.71	0.00	0.00	—	30.060	1017.30	CLR	—	—	—	—	—	—	—	10.00	—	—	—	—	—	KPHX 010751Z 00000KT 10SM CLR 08/01 A3006 RMK AO2 SLP173 T00780011	CLIPHX	60	40	final
KPHX	2020-01-01T08:51:00.000000Z	METAR	2020-01-01	45.00	34.00	65.13	0.00	0.00	—	30.050	1017.00	CLR	—	—	—	—	—	—	—	10.00	—	—	—	—	—	KPHX 010851Z 00000KT 10SM CLR 07/01 A3005 RMK AO2 SLP170 T00720011 58004	CLIPHX	60	40	final
KPHX	2020-01-01T09:51:00.000000Z	METAR	2020-01-01	46.00	33.00	60.49	140.00	3.00	—	30.040	1016.70	CLR	—	—	—	—	—	—	—	9.00	—	—	—	—	—	KPHX 010951Z 14003KT 9SM CLR 08/01 A3004 RMK AO2 SLP167 T00780006	CLIPHX	60	40	final

Columns

Schema, units, meaning, and verified release profile

32 columns

Verified column analytics for reports_kphx
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station0 source inputs · 4 transformations	string	—	0.0%0 values	1<0.1%	KPHX100% Top: KPHX	—
event_time_utc0 source inputs · 4 transformations	timestamp_utc	—	0.0%0 values	60,486100.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%	METAR97% SPECI3% Top: METAR	—
local_standard_date0 source inputs · 4 transformations	date	—	0.0%0 values	2,4384.0%	2019-01-012026-01-01 per year All rows, per year	—
temp_f0 source inputs · 4 transformations	decimal	—	<0.1%6 values	1130.2%	36.00119.00 All-row histogram	Median 78.00P25 63.00 · P75 93.00
dewpoint_f0 source inputs · 4 transformations	decimal	—	<0.1%7 values	1340.2%	-22.0075.20 All-row histogram	Median 36.00P25 28.00 · P75 49.00
relative_humidity_pct0 source inputs · 4 transformations	decimal	—	<0.1%7 values	4,9058.1%	1.78100.00 All-row histogram	Median 24.42P25 15.84 · P75 38.21
wind_direction_degrees0 source inputs · 4 transformations	decimal	—	6.6%3,990 values	37<0.1%	0.00360.00 All-row histogram	Median 130.00P25 90.00 · P75 250.00
wind_speed_kt0 source inputs · 4 transformations	decimal	—	0.5%290 values	42<0.1%	0.0048.00 All-row histogram	Median 5.00P25 3.00 · P75 8.00
wind_gust_kt0 source inputs · 4 transformations	decimal	—	90.5%54,738 values	500.9%	14.0075.00 All-row histogram	Median 20.00P25 17.00 · P75 23.00
altimeter_inhg0 source inputs · 4 transformations	decimal	—	<0.1%4 values	1100.2%	29.44030.570 All-row histogram	Median 29.890P25 29.800 · P75 29.990
sea_level_pressure_hpa0 source inputs · 4 transformations	decimal	—	3.5%2,089 values	3630.6%	995.401068.40 All-row histogram	Median 1010.40P25 1007.30 · P75 1014.70
sky_cover_10 source inputs · 4 transformations	string	—	<0.1%3 values	6<0.1%	FEW52% CLR27% SCT13% Top: FEW	—
sky_base_1_ft0 source inputs · 4 transformations	decimal	—	26.6%16,068 values	830.2%	0.0031000.00 All-row histogram	Median 12000.00P25 9000.00 · P75 20000.00
sky_cover_20 source inputs · 4 transformations	string	—	51.6%31,237 values	4<0.1%	FEW36% BKN33% SCT28% Top: FEW	—
sky_base_2_ft0 source inputs · 4 transformations	decimal	—	51.6%31,237 values	740.3%	600.0030000.00 All-row histogram	Median 18000.00P25 12000.00 · P75 25000.00
sky_cover_30 source inputs · 4 transformations	string	—	73.3%44,333 values	4<0.1%	BKN53% SCT25% FEW13% Top: BKN	—
sky_base_3_ft0 source inputs · 4 transformations	decimal	—	73.3%44,333 values	660.4%	1000.0035000.00 All-row histogram	Median 21000.00P25 15000.00 · P75 25000.00
sky_cover_40 source inputs · 4 transformations	string	—	92.0%55,623 values	4<0.1%	BKN71% SCT20% OVC10% Top: BKN	—
sky_base_4_ft0 source inputs · 4 transformations	decimal	—	92.0%55,623 values	160.3%	13000.0029000.00 All-row histogram	Median 25000.00P25 19000.00 · P75 25000.00

Show 12 more columns

Verified column analytics for reports_kphx
visibility_miles0 source inputs · 4 transformations	decimal	—	<0.1%8 values	19<0.1%	0.0010.00 All-row histogram	Median 10.00P25 10.00 · P75 10.00
weather_codes0 source inputs · 4 transformations	string	—	96.9%58,585 values	552.9%	-RA29% TS12% VCTS8% Other (43) Top: -RA · 282 more values	—
precipitation_in_1h0 source inputs · 4 transformations	decimal	—	1.7%1,014 values	50<0.1%	0.0001.090 All-row histogram	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt0 source inputs · 4 transformations	decimal	—	96.8%58,575 values	361.9%	26.0075.00 All-row histogram	Median 29.00P25 27.00 · P75 33.00
peak_wind_direction_degrees0 source inputs · 4 transformations	decimal	—	96.8%58,575 values	361.9%	10.00360.00 All-row histogram	Median 230.00P25 150.00 · P75 280.00
peak_wind_time0 source inputs · 4 transformations	string	—	96.8%58,575 values	1,56181.6%	1,561 distinct values, no chart No shape worth drawing · 1,912 more values	—
snow_depth_inches0 source inputs · 4 transformations	decimal	—	100.0%60,487 values	00.0%	0 distinct values, no chart No shape worth drawing	—
raw_metar0 source inputs · 4 transformations	string	—	0.0%0 values	60,487100.0%	60,487 distinct values, no chart No shape worth drawing · 60,487 more values	—
cli_product0 source inputs · 4 transformations	string	—	<0.1%7 values	1<0.1%	CLIPHX100% Top: CLIPHX	—
cli_high_f0 source inputs · 4 transformations	integer	—	0.1%79 values	680.1%	50119 All-row histogram	Median 91P25 75 · P75 105
cli_low_f0 source inputs · 4 transformations	integer	—	0.1%84 values	630.1%	3597 All-row histogram	Median 66P25 52 · P75 80
cli_report_type0 source inputs · 4 transformations	string	—	<0.1%7 values	2<0.1%	final99% correction1% Top: final	—

Release status

Facts from the current passing release

Release: V4 publication snapshot
Rows: 60,487
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_kphx

reports_kphx

# Current release — the complete Parquet file
curl -sS -o reports-kphx.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/77031a86-8bbb-4217-a7a0-2758ac77d561/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/77031a86-8bbb-4217-a7a0-2758ac77d561/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/77031a86-8bbb-4217-a7a0-2758ac77d561/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_kphx

Release status