reports_rpll

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:42

Rows: 59,262; across released Tables
Tables: 1; released
Columns: 37; reports_rpll
Version: —; reports_rpll

Data preview

reports_rpll

Preview rows for reports_rpll
station	event_time_utc	observation_type	local_standard_date	temp_f	temp_c	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
RPLL	2020-01-01T00:00:00.000000Z	METAR	2020-01-01	77.00	25.0	73.40	88.67	160.00	3.00	—	30.030	—	SCT	2300.00	BKN	8000.00	—	—	—
RPLL	2020-01-01T01:00:00.000000Z	METAR	2020-01-01	78.80	26.0	73.40	83.55	10.00	3.00	—	30.030	—	FEW	2300.00	BKN	8000.00	—	—	—
RPLL	2020-01-01T02:00:00.000000Z	METAR	2020-01-01	82.40	28.0	75.20	78.90	350.00	3.00	—	30.030	—	SCT	2000.00	BKN	8000.00	—	—	—
RPLL	2020-01-01T03:00:00.000000Z	METAR	2020-01-01	82.40	28.0	73.40	74.28	290.00	7.00	—	30.000	—	SCT	2200.00	BKN	8000.00	—	—	—
RPLL	2020-01-01T04:00:00.000000Z	METAR	2020-01-01	84.20	29.0	71.60	65.95	—	2.00	—	30.000	—	SCT	2200.00	BKN	8000.00	—	—	—
RPLL	2020-01-01T05:00:00.000000Z	METAR	2020-01-01	82.40	28.0	73.40	74.28	230.00	3.00	—	29.970	—	SCT	2200.00	BKN	8000.00	—	—	—
RPLL	2020-01-01T06:00:00.000000Z	METAR	2020-01-01	82.40	28.0	75.20	78.90	270.00	6.00	—	29.940	—	SCT	2300.00	BKN	8000.00	—	—	—
RPLL	2020-01-01T06:28:00.000000Z	SPECI	2020-01-01	82.40	28.0	75.20	78.90	320.00	3.00	—	29.940	—	SCT	2200.00	BKN	8000.00	—	—	—
RPLL	2020-01-01T07:00:00.000000Z	METAR	2020-01-01	82.40	28.0	75.20	78.90	270.00	4.00	—	29.940	—	SCT	2300.00	BKN	8000.00	—	—	—
RPLL	2020-01-01T08:00:00.000000Z	METAR	2020-01-01	82.40	28.0	73.40	74.28	220.00	3.00	—	29.940	—	SCT	2300.00	BKN	8000.00	—	—	—

Columns

Schema, units, meaning, and verified release profile

37 columns

Verified column analytics for reports_rpll
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	RPLL100% Top: RPLL	—
event_time_utc	timestamp_utc	—	0.0%0 values	59,262100.0%	2020-01-01 00:00:00+000% 2020-01-01 01:00:00+000% 2020-01-01 02:00:00+000% Other (59,250) Top: 2020-01-01 00:00:00+00 · 59,250 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	METAR98% SPECI2% Top: METAR	—
local_standard_date	date	—	0.0%0 values	2,4424.1%	2023-07-280% 2026-08-080% 2025-09-260% Other (2,430) Top: 2023-07-28 · 58,902 more values	—
temp_f	decimal	—	0.2%132 values	19<0.1%	80.6016% 82.4015% 84.2014% Other (7) Top: 80.60 · 641 more values	Median 82.40P25 80.60 · P75 86.00
temp_c	decimal	—	0.2%132 values	19<0.1%	27.016% 28.015% 29.014% Other (7) Top: 27.0 · 641 more values	Median 28.0P25 27.0 · P75 30.0
dewpoint_f	decimal	—	0.2%147 values	23<0.1%	77.0024% 75.2019% 78.8017% Other (11) Top: 77.00 · 134 more values	Median 75.20P25 73.40 · P75 77.00
relative_humidity_pct	decimal	—	0.3%151 values	3800.6%	100.003% 88.833% 83.773% Other (368) Top: 100.00 · 41,176 more values	Median 74.77P25 66.55 · P75 83.88
wind_direction_degrees	decimal	—	23.3%13,831 values	45<0.1%	120.0011% 110.0011% 100.007% Other (33) Top: 120.00 · 14,885 more values	Median 120.00P25 100.00 · P75 240.00
wind_speed_kt	decimal	—	0.1%62 values	46<0.1%	2.0014% 3.0013% 4.0012% Other (34) Top: 2.00 · 3,328 more values	Median 5.00P25 3.00 · P75 7.00
wind_gust_kt	decimal	—	98.5%58,380 values	354.0%	20.0011% 21.0010% 22.008% Other (23) Top: 20.00 · 195 more values	Median 22.00P25 19.00 · P75 26.00
altimeter_inhg	decimal	—	0.2%97 values	49<0.1%	29.83016% 29.80015% 29.85013% Other (37) Top: 29.830 · 2,706 more values	Median 29.830P25 29.770 · P75 29.880
sea_level_pressure_hpa	decimal	—	100.0%59,262 values	00.0%	No distribution published No distribution published	—
sky_cover_1	string	—	0.5%281 values	7<0.1%	FEW72% SCT25% BKN2% Top: FEW	—
sky_base_1_ft	decimal	—	0.6%366 values	1220.2%	2500.0064% 2300.0021% 2200.005% Other (110) Top: 2500.00 · 1,218 more values	Median 2500.00P25 2300.00 · P75 2500.00
sky_cover_2	string	—	38.3%22,690 values	4<0.1%	BKN49% SCT35% OVC15% Top: BKN	—
sky_base_2_ft	decimal	—	38.3%22,692 values	1160.3%	10000.0058% 9000.0013% 30000.0010% Other (104) Top: 10000.00 · 1,264 more values	Median 10000.00P25 9000.00 · P75 10000.00
sky_cover_3	string	—	93.1%55,188 values	4<0.1%	BKN59% OVC33% SCT8% Top: BKN	—
sky_base_3_ft	decimal	—	93.1%55,189 values	892.2%	10000.0036% 9000.0024% 30000.0015% Other (77) Top: 10000.00 · 211 more values	Median 10000.00P25 9000.00 · P75 10000.00
sky_cover_4	string	—	100.0%59,249 values	215.4%	BKN62% OVC38% Top: BKN	—

Show 17 more columns

Verified column analytics for reports_rpll
sky_base_4_ft	decimal	—	100.0%59,249 values	753.8%	30000.0031% 9000.0023% 10000.0015% Top: 30000.00	Median 10000.00P25 9000.00 · P75 30000.00
visibility_miles	decimal	—	0.2%120 values	48<0.1%	6.2182% 5.5910% 4.974% Other (36) Top: 6.21 · 73 more values	Median 6.21P25 6.21 · P75 6.21
weather_codes	string	—	88.4%52,379 values	460.7%	-RA55% -SHRA17% -TSRA6% Other (34) Top: -RA · 199 more values	—
precipitation_in_1h	decimal	—	0.0%0 values	1<0.1%	0.000100% Top: 0.000	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt	decimal	—	100.0%59,262 values	00.0%	No distribution published No distribution published	—
peak_wind_direction_degrees	decimal	—	100.0%59,262 values	00.0%	No distribution published No distribution published	—
peak_wind_time	string	—	100.0%59,262 values	00.0%	No distribution published No distribution published	—
snow_depth_inches	decimal	—	100.0%59,262 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	59,22299.9%	RPLL 172200Z VRB01KT 9999 FEW025 27/25 Q1009 NOSIG RMK A29800% RPLL 012000Z VRB02KT 9999 FEW025 27/25 Q1009 NOSIG RMK A29800% RPLL 012100Z VRB02KT 9999 FEW025 25/22 Q1015 NOSIG RMK A29970% Other (59,210) Top: RPLL 172200Z VRB01KT 9999 FEW025 27/25 Q1009 NOSIG RMK A2980 · 59,237 more values	—
cli_product	string	—	100.0%59,262 values	00.0%	No distribution published No distribution published	—
cli_high_f	integer	—	100.0%59,262 values	00.0%	No distribution published All-row histogram	—
cli_low_f	integer	—	100.0%59,262 values	00.0%	No distribution published All-row histogram	—
cli_report_type	string	—	100.0%59,262 values	00.0%	No distribution published No distribution published	—
metar_high_f	decimal	—	0.0%0 values	14<0.1%	89.6021% 91.4018% 87.8015% Other (2) Top: 89.60 · 164 more values	Median 89.60P25 87.80 · P75 93.20
metar_low_f	decimal	—	0.0%0 values	10<0.1%	78.8028% 77.0023% 80.6020% Top: 78.80	Median 78.80P25 77.00 · P75 80.60
metar_high_c	decimal	—	0.0%0 values	14<0.1%	32.021% 33.018% 31.015% Other (2) Top: 32.0 · 164 more values	Median 32.0P25 31.0 · P75 34.0
metar_low_c	decimal	—	0.0%0 values	10<0.1%	26.028% 25.023% 27.020% Top: 26.0	Median 26.0P25 25.0 · P75 27.0

Release status

Facts from the current passing release

Release: Passing
Rows: 59,262
Columns: 37
Published: 9 Sept 2026, 06:42
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_rpll

reports_rpll

# Current release — the complete Parquet file
curl -sS -o reports-rpll.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/1b106959-405a-49a6-8634-bd60e666b826/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/1b106959-405a-49a6-8634-bd60e666b826/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/1b106959-405a-49a6-8634-bd60e666b826/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

Manila weather reports and daily highs since 2020

reports_rpll

Release status