reports_kphx

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:30

Rows: 60,622; across released Tables
Tables: 1; released
Columns: 34; reports_kphx
Version: —; 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
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	—	—	—	—	—	—	—
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	—	—	—	—	—	—	—
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	—	—	—	—	—	—	—
KPHX	2020-01-01T10:51:00.000000Z	METAR	2020-01-01	45.00	33.00	62.83	100.00	6.00	—	30.040	1016.70	CLR	—	—	—	—	—	—	—
KPHX	2020-01-01T11:51:00.000000Z	METAR	2020-01-01	45.00	32.00	60.11	110.00	4.00	—	30.020	1016.00	CLR	—	—	—	—	—	—	—
KPHX	2020-01-01T12:51:00.000000Z	METAR	2020-01-01	43.00	32.00	64.88	70.00	4.00	—	30.040	1016.70	CLR	—	—	—	—	—	—	—
KPHX	2020-01-01T13:51:00.000000Z	METAR	2020-01-01	42.00	32.00	67.17	90.00	4.00	—	30.050	1017.40	CLR	—	—	—	—	—	—	—
KPHX	2020-01-01T14:51:00.000000Z	METAR	2020-01-01	41.00	33.00	73.25	0.00	0.00	—	30.070	1018.00	FEW	25000.00	—	—	—	—	—	—
KPHX	2020-01-01T15:51:00.000000Z	METAR	2020-01-01	45.00	32.00	60.11	100.00	4.00	—	30.060	1017.80	FEW	25000.00	—	—	—	—	—	—
KPHX	2020-01-01T16:51:00.000000Z	METAR	2020-01-01	50.00	33.00	52.06	130.00	8.00	—	30.070	1017.80	FEW	25000.00	—	—	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

34 columns

Verified column analytics for reports_kphx
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	KPHX100% Top: KPHX	—
event_time_utc	timestamp_utc	—	0.0%0 values	60,621100.0%	2022-08-19 03:35:00+000% 2020-01-01 07:51:00+000% 2020-01-01 08:51:00+000% Other (60,609) Top: 2022-08-19 03:35:00+00 · 60,609 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	METAR97% SPECI3% Top: METAR	—
local_standard_date	date	—	0.0%0 values	2,4434.0%	2021-07-230% 2025-09-260% 2021-12-240% Other (2,431) Top: 2021-07-23 · 60,128 more values	—
temp_f	decimal	—	<0.1%7 values	1130.2%	93.002% 91.002% 92.002% Other (101) Top: 93.00 · 47,218 more values	Median 78.00P25 63.00 · P75 93.00
dewpoint_f	decimal	—	<0.1%8 values	1340.2%	33.003% 32.003% 35.003% Other (122) Top: 33.00 · 39,802 more values	Median 37.00P25 28.00 · P75 49.00
relative_humidity_pct	decimal	—	<0.1%8 values	4,9058.1%	17.800% 18.330% 26.920% Other (4,893) Top: 17.80 · 59,667 more values	Median 24.42P25 15.85 · P75 38.21
wind_direction_degrees	decimal	—	6.6%4,000 values	37<0.1%	0.0014% 100.007% 90.006% Other (25) Top: 0.00 · 20,005 more values	Median 130.00P25 90.00 · P75 250.00
wind_speed_kt	decimal	—	0.5%290 values	42<0.1%	4.0014% 0.0014% 5.0013% Other (30) Top: 4.00 · 2,726 more values	Median 5.00P25 3.00 · P75 8.00
wind_gust_kt	decimal	—	90.5%54,853 values	500.9%	19.0010% 18.009% 17.009% Other (38) Top: 19.00 · 898 more values	Median 20.00P25 17.00 · P75 23.00
altimeter_inhg	decimal	—	<0.1%4 values	1100.2%	29.8203% 29.8503% 29.8303% Other (98) Top: 29.820 · 39,281 more values	Median 29.890P25 29.800 · P75 29.990
sea_level_pressure_hpa	decimal	—	3.5%2,094 values	3630.6%	1008.701% 1009.401% 1007.801% Other (351) Top: 1008.70 · 52,522 more values	Median 1010.40P25 1007.30 · P75 1014.70
sky_cover_1	string	—	<0.1%3 values	6<0.1%	FEW52% CLR26% SCT13% Top: FEW	—
sky_base_1_ft	decimal	—	26.5%16,064 values	830.2%	25000.0018% 10000.0011% 12000.009% Other (71) Top: 25000.00 · 11,978 more values	Median 12000.00P25 9000.00 · P75 20000.00
sky_cover_2	string	—	51.5%31,245 values	4<0.1%	FEW36% BKN33% SCT28% Top: FEW	—
sky_base_2_ft	decimal	—	51.5%31,245 values	740.3%	25000.0023% 20000.007% 15000.007% Other (62) Top: 25000.00 · 7,746 more values	Median 18000.00P25 12000.00 · P75 25000.00
sky_cover_3	string	—	73.2%44,386 values	4<0.1%	BKN53% SCT25% FEW13% Top: BKN	—
sky_base_3_ft	decimal	—	73.2%44,386 values	660.4%	25000.0031% 20000.008% 18000.006% Other (54) Top: 25000.00 · 3,704 more values	Median 21000.00P25 15000.00 · P75 25000.00
sky_cover_4	string	—	91.9%55,729 values	4<0.1%	BKN71% SCT19% OVC10% Top: BKN	—
sky_base_4_ft	decimal	—	91.9%55,729 values	160.3%	25000.0036% 20000.0010% 29000.007% Other (4) Top: 25000.00 · 315 more values	Median 25000.00P25 19000.00 · P75 25000.00

Show 14 more columns

Verified column analytics for reports_kphx
visibility_miles	decimal	—	<0.1%8 values	19<0.1%	10.0097% 9.001% 8.000% Other (7) Top: 10.00 · 78 more values	Median 10.00P25 10.00 · P75 10.00
weather_codes	string	—	96.9%58,719 values	552.9%	-RA29% TS12% VCTS8% Other (43) Top: -RA · 282 more values	—
precipitation_in_1h	decimal	—	1.7%1,020 values	50<0.1%	0.00098% 0.0100% 0.0200% Other (38) Top: 0.000 · 159 more values	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt	decimal	—	96.8%58,706 values	361.9%	26.0020% 27.0016% 28.0010% Other (24) Top: 26.00 · 256 more values	Median 29.00P25 27.00 · P75 33.00
peak_wind_direction_degrees	decimal	—	96.8%58,706 values	361.9%	270.009% 280.008% 260.005% Other (24) Top: 270.00 · 877 more values	Median 230.00P25 150.00 · P75 280.00
peak_wind_time	string	—	96.8%58,706 values	1,56581.7%	2021-08-17 05:530% 2025-09-04 03:320% 2021-09-02 02:240% Other (1,553) Top: 2021-08-17 05:53 · 1,847 more values	—
snow_depth_inches	decimal	—	100.0%60,622 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	60,622100.0%	KPHX 010000Z 29015G26KT 10SM FEW020 FEW110 FEW250 32/04 A2965 RMK AO2 PK WND 31026/2352 WSHFT 2340 FU FEW020 T031700440% KPHX 010003Z COR 19015G28KT 3SM BLDU SCT013 SCT090 BKN170 BKN230 41/15 A2978 RMK AO2 PK WND 17028/2356 BLDU SCT013 T040601500% KPHX 010051Z 00000KT 10SM FEW085 FEW190 SCT250 16/04 A3010 RMK AO2 SLP186 T01610044 $0% Other (60,610) Top: KPHX 010000Z 29015G26KT 10SM FEW020 FEW110 FEW250 32/04 A2965 RMK AO2 PK WND 31026/2352 WSHFT 2340 FU FEW020 T03170044 · 60,610 more values	—
cli_product	string	—	<0.1%12 values	1<0.1%	CLIPHX100% Top: CLIPHX	—
cli_high_f	integer	—	0.1%84 values	680.1%	50119 All-row histogram	Median 91P25 75 · P75 105
cli_low_f	integer	—	0.1%89 values	630.1%	3597 All-row histogram	Median 66P25 52 · P75 80
cli_report_type	string	—	<0.1%12 values	2<0.1%	final99% correction1% Top: final	—
metar_high_f	decimal	—	0.0%0 values	730.1%	108.003% 100.003% 104.003% Other (61) Top: 108.00 · 42,704 more values	Median 90.00P25 74.00 · P75 103.00
metar_low_f	decimal	—	0.0%0 values	710.1%	53.004% 48.002% 50.002% Other (59) Top: 53.00 · 43,372 more values	Median 67.00P25 53.00 · P75 81.00

Release status

Facts from the current passing release

Release: Passing
Rows: 60,622
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_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/6cd5de11-5626-4496-811d-fb8675ccb7ed/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/6cd5de11-5626-4496-811d-fb8675ccb7ed/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/6cd5de11-5626-4496-811d-fb8675ccb7ed/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

Phoenix weather reports and daily highs since 2020

reports_kphx

Release status