reports_opkc

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:41

Rows: 115,138; across released Tables
Tables: 1; released
Columns: 37; reports_opkc
Version: —; reports_opkc

Data preview

reports_opkc

Preview rows for reports_opkc
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
OPKC	2020-01-01T00:30:00.000000Z	SPECI	2020-01-01	48.20	9.0	37.40	66.05	60.00	9.00	—	30.060	—	NSC	—	—	—	—	—	—
OPKC	2020-01-01T01:00:00.000000Z	METAR	2020-01-01	48.20	9.0	37.40	66.05	50.00	10.00	—	30.060	—	NSC	—	—	—	—	—	—
OPKC	2020-01-01T01:30:00.000000Z	SPECI	2020-01-01	48.20	9.0	37.40	66.05	60.00	10.00	—	30.060	—	NSC	—	—	—	—	—	—
OPKC	2020-01-01T02:00:00.000000Z	METAR	2020-01-01	48.20	9.0	37.40	66.05	70.00	12.00	—	30.090	—	NSC	—	—	—	—	—	—
OPKC	2020-01-01T03:00:00.000000Z	METAR	2020-01-01	50.00	10.0	37.40	61.76	60.00	12.00	—	30.120	—	NSC	—	—	—	—	—	—
OPKC	2020-01-01T03:30:00.000000Z	SPECI	2020-01-01	50.00	10.0	37.40	61.76	50.00	13.00	—	30.120	—	NSC	—	—	—	—	—	—
OPKC	2020-01-01T03:55:00.000000Z	SPECI	2020-01-01	51.80	11.0	37.40	57.77	60.00	10.00	—	30.150	—	NSC	—	—	—	—	—	—
OPKC	2020-01-01T04:55:00.000000Z	SPECI	2020-01-01	55.40	13.0	33.80	43.90	50.00	22.00	—	30.150	—	NSC	—	—	—	—	—	—
OPKC	2020-01-01T05:25:00.000000Z	SPECI	2020-01-01	57.20	14.0	30.20	35.57	40.00	24.00	—	30.150	—	NSC	—	—	—	—	—	—
OPKC	2020-01-01T05:55:00.000000Z	SPECI	2020-01-01	59.00	15.0	28.40	30.98	30.00	25.00	—	30.150	—	NSC	—	—	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

37 columns

Verified column analytics for reports_opkc
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	OPKC100% Top: OPKC	—
event_time_utc	timestamp_utc	—	0.0%0 values	115,138100.0%	2020-01-01 00:30:00+000% 2020-01-01 01:00:00+000% 2020-01-01 01:30:00+000% Other (115,126) Top: 2020-01-01 00:30:00+00 · 115,126 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	SPECI58% METAR42% Top: SPECI	—
local_standard_date	date	—	0.0%0 values	2,4442.1%	2021-02-020% 2021-07-120% 2021-09-010% Other (2,432) Top: 2021-02-02 · 114,540 more values	—
temp_f	decimal	—	0.3%296 values	40<0.1%	86.0010% 84.209% 82.409% Other (28) Top: 86.00 · 31,929 more values	Median 82.40P25 75.20 · P75 87.80
temp_c	decimal	—	0.3%296 values	40<0.1%	30.010% 29.09% 28.09% Other (28) Top: 30.0 · 31,929 more values	Median 28.0P25 24.0 · P75 31.0
dewpoint_f	decimal	—	0.3%306 values	55<0.1%	75.2012% 73.4011% 77.009% Other (43) Top: 75.20 · 40,461 more values	Median 68.00P25 50.00 · P75 75.20
relative_humidity_pct	decimal	—	0.3%308 values	1,7591.5%	78.902% 74.612% 74.442% Other (1,747) Top: 78.90 · 97,977 more values	Median 60.21P25 43.01 · P75 74.51
wind_direction_degrees	decimal	—	0.6%655 values	76<0.1%	240.0018% 250.0012% 270.008% Other (64) Top: 240.00 · 24,832 more values	Median 240.00P25 80.00 · P75 260.00
wind_speed_kt	decimal	—	<0.1%48 values	71<0.1%	4.0012% 10.0010% 6.0010% Other (59) Top: 4.00 · 16,689 more values	Median 8.00P25 4.00 · P75 11.00
wind_gust_kt	decimal	—	100.0%115,109 values	1137.9%	25.0045% 27.0010% 21.007% Top: 25.00	Median 25.00P25 25.00 · P75 28.00
altimeter_inhg	decimal	—	0.3%344 values	64<0.1%	29.9405% 30.0005% 29.9705% Other (52) Top: 29.940 · 50,075 more values	Median 29.800P25 29.620 · P75 29.940
sea_level_pressure_hpa	decimal	—	100.0%115,138 values	00.0%	No distribution published No distribution published	—
sky_cover_1	string	—	0.4%415 values	7<0.1%	NSC50% SCT26% FEW14% Top: NSC	—
sky_base_1_ft	decimal	—	50.6%58,312 values	25<0.1%	2000.0055% 3000.0031% 2500.006% Other (13) Top: 2000.00 · 34 more values	Median 2000.00P25 2000.00 · P75 3000.00
sky_cover_2	string	—	81.3%93,572 values	5<0.1%	BKN68% SCT29% OVC2% Top: BKN	—
sky_base_2_ft	decimal	—	81.3%93,582 values	220.1%	3000.0053% 10000.0030% 2500.007% Other (10) Top: 3000.00 · 19 more values	Median 3000.00P25 3000.00 · P75 10000.00
sky_cover_3	string	—	97.4%112,163 values	40.1%	BKN54% OVC44% SCT2% Top: BKN	—
sky_base_3_ft	decimal	—	97.4%112,164 values	90.3%	8000.0042% 10000.0025% 9000.0019% Top: 8000.00	Median 8000.00P25 8000.00 · P75 10000.00
sky_cover_4	string	—	99.7%114,820 values	30.9%	OVC95% BKN4% SCT1% Top: OVC	—

Show 17 more columns

Verified column analytics for reports_opkc
sky_base_4_ft	decimal	—	99.7%114,820 values	61.9%	8000.0063% 9000.0024% 7000.009% Top: 8000.00	Median 8000.00P25 8000.00 · P75 9000.00
visibility_miles	decimal	—	<0.1%33 values	42<0.1%	3.7332% 3.1131% 2.4921% Other (30) Top: 3.73 · 353 more values	Median 3.11P25 2.49 · P75 3.73
weather_codes	string	—	36.6%42,137 values	59<0.1%	HZ56% FU36% BR3% Other (47) Top: HZ · 289 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%115,138 values	00.0%	No distribution published No distribution published	—
peak_wind_direction_degrees	decimal	—	100.0%115,138 values	00.0%	No distribution published No distribution published	—
peak_wind_time	string	—	100.0%115,138 values	00.0%	No distribution published No distribution published	—
snow_depth_inches	decimal	—	100.0%115,138 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	115,119100.0%	OPKC 010000Z 02003KT 4000 HZ NSC 18/09 Q1014 NOSIG0% OPKC 010000Z 03003KT 3000 FU NSC 12/10 Q1019 NOSIG0% OPKC 010000Z 03004KT 6000 NSC 27/10 Q1014 NOSIG0% Other (115,107) Top: OPKC 010000Z 02003KT 4000 HZ NSC 18/09 Q1014 NOSIG · 115,114 more values	—
cli_product	string	—	100.0%115,138 values	00.0%	No distribution published No distribution published	—
cli_high_f	integer	—	100.0%115,138 values	00.0%	No distribution published All-row histogram	—
cli_low_f	integer	—	100.0%115,138 values	00.0%	No distribution published All-row histogram	—
cli_report_type	string	—	100.0%115,138 values	00.0%	No distribution published No distribution published	—
metar_high_f	decimal	—	0.0%0 values	26<0.1%	93.2013% 95.0012% 91.4010% Other (14) Top: 93.20 · 16,105 more values	Median 91.40P25 86.00 · P75 95.00
metar_low_f	decimal	—	0.0%0 values	30<0.1%	80.6011% 82.4011% 84.209% Other (18) Top: 80.60 · 34,171 more values	Median 77.00P25 62.60 · P75 82.40
metar_high_c	decimal	—	0.0%0 values	26<0.1%	34.013% 35.012% 33.010% Other (14) Top: 34.0 · 16,105 more values	Median 33.0P25 30.0 · P75 35.0
metar_low_c	decimal	—	0.0%0 values	30<0.1%	27.011% 28.011% 29.09% Other (18) Top: 27.0 · 34,171 more values	Median 25.0P25 17.0 · P75 28.0

Release status

Facts from the current passing release

Release: Passing
Rows: 115,138
Columns: 37
Published: 9 Sept 2026, 06:41
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_opkc

reports_opkc

# Current release — the complete Parquet file
curl -sS -o reports-opkc.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/6d4159cc-e9cd-4015-9821-134a51803e2f/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/6d4159cc-e9cd-4015-9821-134a51803e2f/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/6d4159cc-e9cd-4015-9821-134a51803e2f/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

Karachi weather reports and daily highs since 2020

reports_opkc

Release status