reports_fact

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:40

Rows: 84,120; across released Tables
Tables: 1; released
Columns: 37; reports_fact
Version: —; reports_fact

Data preview

reports_fact

Preview rows for reports_fact
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
FACT	2020-01-01T00:00:00.000000Z	METAR	2020-01-01	66.20	19.0	55.40	68.15	190.00	16.00	—	29.910	—	FEW	3000.00	—	—	—	—	—
FACT	2020-01-01T01:00:00.000000Z	METAR	2020-01-01	66.20	19.0	55.40	68.15	190.00	14.00	—	29.880	—	FEW	3000.00	—	—	—	—	—
FACT	2020-01-01T02:00:00.000000Z	METAR	2020-01-01	66.20	19.0	55.40	68.15	190.00	12.00	—	29.880	—	FEW	3000.00	—	—	—	—	—
FACT	2020-01-01T03:00:00.000000Z	METAR	2020-01-01	66.20	19.0	55.40	68.15	200.00	11.00	—	29.880	—	FEW	3000.00	—	—	—	—	—
FACT	2020-01-01T04:00:00.000000Z	METAR	2020-01-01	64.40	18.0	55.40	72.56	200.00	12.00	—	29.910	—	FEW	3000.00	—	—	—	—	—
FACT	2020-01-01T05:00:00.000000Z	METAR	2020-01-01	68.00	20.0	55.40	64.04	190.00	14.00	—	29.910	—	FEW	3000.00	—	—	—	—	—
FACT	2020-01-01T06:00:00.000000Z	METAR	2020-01-01	69.80	21.0	55.40	60.21	180.00	14.00	—	29.910	—	FEW	3000.00	—	—	—	—	—
FACT	2020-01-01T06:57:00.000000Z	SPECI	2020-01-01	73.40	23.0	55.40	53.29	190.00	14.00	—	29.910	—	FEW	3000.00	—	—	—	—	—
FACT	2020-01-01T07:00:00.000000Z	METAR	2020-01-01	73.40	23.0	55.40	53.29	190.00	14.00	—	29.910	—	FEW	3000.00	—	—	—	—	—
FACT	2020-01-01T08:00:00.000000Z	METAR	2020-01-01	73.40	23.0	55.40	53.29	190.00	16.00	—	29.940	—	FEW	3000.00	—	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

37 columns

Verified column analytics for reports_fact
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	FACT100% Top: FACT	—
event_time_utc	timestamp_utc	—	0.0%0 values	84,120100.0%	2020-01-01 00:00:00+000% 2020-01-01 01:00:00+000% 2020-01-01 02:00:00+000% Other (84,108) Top: 2020-01-01 00:00:00+00 · 84,108 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	METAR68% SPECI32% Top: METAR	—
local_standard_date	date	—	0.0%0 values	2,4202.9%	2024-04-180% 2024-04-230% 2024-05-280% Other (2,408) Top: 2024-04-18 · 81,539 more values	—
temp_f	decimal	—	<0.1%7 values	40<0.1%	57.209% 59.009% 55.408% Other (28) Top: 57.20 · 17,465 more values	Median 60.80P25 55.40 · P75 66.20
temp_c	decimal	—	<0.1%7 values	40<0.1%	14.09% 15.09% 13.08% Other (28) Top: 14.0 · 17,465 more values	Median 16.0P25 13.0 · P75 19.0
dewpoint_f	decimal	—	<0.1%7 values	28<0.1%	53.6011% 55.4011% 57.2010% Other (16) Top: 53.60 · 7,941 more values	Median 53.60P25 50.00 · P75 57.20
relative_humidity_pct	decimal	—	<0.1%7 values	8621.0%	100.009% 93.653% 93.692% Other (850) Top: 100.00 · 61,227 more values	Median 81.74P25 64.04 · P75 93.50
wind_direction_degrees	decimal	—	10.8%9,114 values	37<0.1%	180.008% 190.008% 170.006% Other (25) Top: 180.00 · 26,334 more values	Median 200.00P25 160.00 · P75 310.00
wind_speed_kt	decimal	—	<0.1%6 values	39<0.1%	3.007% 4.007% 5.007% Other (27) Top: 3.00 · 23,058 more values	Median 9.00P25 5.00 · P75 13.00
wind_gust_kt	decimal	—	96.5%81,194 values	381.3%	32.009% 31.008% 33.008% Other (26) Top: 32.00 · 782 more values	Median 32.00P25 28.00 · P75 35.00
altimeter_inhg	decimal	—	<0.1%10 values	47<0.1%	29.9108% 30.0007% 29.9407% Other (35) Top: 29.910 · 21,245 more values	Median 30.000P25 29.910 · P75 30.120
sea_level_pressure_hpa	decimal	—	100.0%84,120 values	00.0%	No distribution published No distribution published	—
sky_cover_1	string	—	41.2%34,663 values	7<0.1%	FEW45% BKN24% SCT19% Top: FEW	—
sky_base_1_ft	decimal	—	46.2%38,888 values	590.1%	3000.0013% 3500.0012% 2000.009% Other (47) Top: 3000.00 · 10,617 more values	Median 2000.00P25 1000.00 · P75 3500.00
sky_cover_2	string	—	81.1%68,205 values	4<0.1%	BKN70% OVC16% SCT13% Top: BKN	—
sky_base_2_ft	decimal	—	81.1%68,205 values	540.3%	3500.0015% 4000.0014% 3000.0014% Other (42) Top: 3500.00 · 2,992 more values	Median 3000.00P25 2100.00 · P75 4000.00
sky_cover_3	string	—	98.9%83,182 values	40.4%	BKN68% OVC18% FEW12% Top: BKN	—
sky_base_3_ft	decimal	—	98.9%83,182 values	414.4%	4000.0019% 3000.0014% 3500.008% Other (29) Top: 4000.00 · 233 more values	Median 3500.00P25 3000.00 · P75 4000.00
sky_cover_4	string	—	100.0%84,111 values	222.2%	FEW89% OVC11% Top: FEW	—

Show 17 more columns

Verified column analytics for reports_fact
sky_base_4_ft	decimal	—	100.0%84,112 values	225.0%	5000.0088% 3900.0013% Top: 5000.00	Median 5000.00P25 5000.00 · P75 5000.00
visibility_miles	decimal	—	<0.1%1 values	65<0.1%	6.2182% 2.492% 4.972% Other (53) Top: 6.21 · 3,232 more values	Median 6.21P25 6.21 · P75 6.21
weather_codes	string	—	83.4%70,163 values	340.2%	-RA27% FG23% BR19% Other (22) Top: -RA · 705 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%84,120 values	00.0%	No distribution published No distribution published	—
peak_wind_direction_degrees	decimal	—	100.0%84,120 values	00.0%	No distribution published No distribution published	—
peak_wind_time	string	—	100.0%84,120 values	00.0%	No distribution published No distribution published	—
snow_depth_inches	decimal	—	100.0%84,120 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	84,115100.0%	FACT 050600Z VRB02KT CAVOK 06/05 Q1020 NOSIG0% FACT 120600Z 03010KT 9999 FEW038 SCT046 08/06 Q1031 NOSIG0% FACT 220500Z 04005KT CAVOK 09/08 Q1024 NOSIG0% Other (84,103) Top: FACT 050600Z VRB02KT CAVOK 06/05 Q1020 NOSIG · 84,103 more values	—
cli_product	string	—	100.0%84,120 values	00.0%	No distribution published No distribution published	—
cli_high_f	integer	—	100.0%84,120 values	00.0%	No distribution published All-row histogram	—
cli_low_f	integer	—	100.0%84,120 values	00.0%	No distribution published All-row histogram	—
cli_report_type	string	—	100.0%84,120 values	00.0%	No distribution published No distribution published	—
metar_high_f	decimal	—	0.0%0 values	28<0.1%	62.607% 68.007% 71.607% Other (16) Top: 62.60 · 17,372 more values	Median 71.60P25 64.40 · P75 77.00
metar_low_f	decimal	—	0.0%0 values	22<0.1%	53.609% 51.808% 62.608% Other (10) Top: 53.60 · 9,655 more values	Median 55.40P25 50.00 · P75 60.80
metar_high_c	decimal	—	0.0%0 values	28<0.1%	17.07% 20.07% 22.07% Other (16) Top: 17.0 · 17,372 more values	Median 22.0P25 18.0 · P75 25.0
metar_low_c	decimal	—	0.0%0 values	22<0.1%	12.09% 11.08% 17.08% Other (10) Top: 12.0 · 9,655 more values	Median 13.0P25 10.0 · P75 16.0

Release status

Facts from the current passing release

Release: Passing
Rows: 84,120
Columns: 37
Published: 9 Sept 2026, 06:40
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_fact

reports_fact

# Current release — the complete Parquet file
curl -sS -o reports-fact.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/2818fa33-b734-42b4-b205-86fc8756a551/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/2818fa33-b734-42b4-b205-86fc8756a551/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/2818fa33-b734-42b4-b205-86fc8756a551/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

Cape Town weather reports and daily highs since 2020

reports_fact

Release status