reports_efhk

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 07:20

Rows: 117,190; across released Tables
Tables: 1; released
Columns: 37; reports_efhk
Version: —; reports_efhk

Data preview

reports_efhk

Preview rows for reports_efhk
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
EFHK	2020-01-01T00:20:00.000000Z	SPECI	2020-01-01	30.20	-1.0	26.60	86.28	270.00	8.00	—	29.830	—	—	—	—	—	—	—	—
EFHK	2020-01-01T00:50:00.000000Z	METAR	2020-01-01	30.20	-1.0	26.60	86.28	260.00	9.00	—	29.830	—	—	—	—	—	—	—	—
EFHK	2020-01-01T01:20:00.000000Z	SPECI	2020-01-01	30.20	-1.0	26.60	86.28	270.00	11.00	—	29.830	—	—	—	—	—	—	—	—
EFHK	2020-01-01T01:50:00.000000Z	METAR	2020-01-01	32.00	0.0	28.40	86.39	270.00	10.00	—	29.830	—	—	—	—	—	—	—	—
EFHK	2020-01-01T02:20:00.000000Z	SPECI	2020-01-01	32.00	0.0	26.60	80.22	270.00	10.00	—	29.830	—	—	—	—	—	—	—	—
EFHK	2020-01-01T02:50:00.000000Z	METAR	2020-01-01	32.00	0.0	28.40	86.39	270.00	8.00	—	29.830	—	—	—	—	—	—	—	—
EFHK	2020-01-01T03:20:00.000000Z	SPECI	2020-01-01	32.00	0.0	28.40	86.39	270.00	10.00	—	29.800	—	—	—	—	—	—	—	—
EFHK	2020-01-01T03:50:00.000000Z	METAR	2020-01-01	32.00	0.0	28.40	86.39	260.00	8.00	—	29.800	—	SCT	4600.00	—	—	—	—	—
EFHK	2020-01-01T04:20:00.000000Z	SPECI	2020-01-01	30.20	-1.0	26.60	86.28	230.00	7.00	—	29.800	—	FEW	4600.00	—	—	—	—	—
EFHK	2020-01-01T04:50:00.000000Z	METAR	2020-01-01	30.20	-1.0	26.60	86.28	230.00	7.00	—	29.800	—	FEW	4600.00	—	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

37 columns

Verified column analytics for reports_efhk
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	EFHK100% Top: EFHK	—
event_time_utc	timestamp_utc	—	0.0%0 values	117,190100.0%	2020-01-01 00:20:00+000% 2020-01-01 00:50:00+000% 2020-01-01 01:20:00+000% Other (117,178) Top: 2020-01-01 00:20:00+00 · 117,178 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	METAR50% SPECI50% Top: METAR	—
local_standard_date	date	—	0.0%0 values	2,4442.1%	2020-01-020% 2020-01-030% 2020-01-040% Other (2,432) Top: 2020-01-02 · 116,614 more values	—
temp_f	decimal	—	0.0%0 values	59<0.1%	33.805% 32.005% 35.605% Other (47) Top: 33.80 · 62,538 more values	Median 42.80P25 32.00 · P75 57.20
temp_c	decimal	—	0.0%0 values	59<0.1%	1.05% 0.05% 2.05% Other (47) Top: 1.0 · 62,538 more values	Median 6.0P25 0.0 · P75 14.0
dewpoint_f	decimal	—	0.0%0 values	52<0.1%	32.006% 33.805% 30.205% Other (40) Top: 32.00 · 57,521 more values	Median 37.40P25 26.60 · P75 50.00
relative_humidity_pct	decimal	—	0.0%0 values	1,3291.1%	100.0013% 93.082% 93.032% Other (1,317) Top: 100.00 · 88,554 more values	Median 85.73P25 68.15 · P75 93.08
wind_direction_degrees	decimal	—	4.4%5,124 values	37<0.1%	210.005% 220.005% 190.004% Other (25) Top: 210.00 · 61,782 more values	Median 210.00P25 120.00 · P75 280.00
wind_speed_kt	decimal	—	0.0%0 values	32<0.1%	6.0010% 7.0010% 8.009% Other (20) Top: 6.00 · 15,253 more values	Median 8.00P25 5.00 · P75 11.00
wind_gust_kt	decimal	—	98.8%115,816 values	322.3%	30.0010% 28.008% 27.008% Other (20) Top: 30.00 · 294 more values	Median 30.00P25 26.00 · P75 33.00
altimeter_inhg	decimal	—	0.0%0 values	92<0.1%	29.9704% 29.8804% 30.0004% Other (80) Top: 29.970 · 65,158 more values	Median 29.880P25 29.680 · P75 30.090
sea_level_pressure_hpa	decimal	—	100.0%117,190 values	00.0%	No distribution published No distribution published	—
sky_cover_1	string	—	34.0%39,827 values	7<0.1%	FEW46% BKN32% SCT12% Top: FEW	—
sky_base_1_ft	decimal	—	35.2%41,221 values	71<0.1%	400.006% 200.005% 700.005% Other (59) Top: 400.00 · 35,298 more values	Median 1300.00P25 600.00 · P75 2600.00
sky_cover_2	string	—	75.8%88,797 values	5<0.1%	BKN68% SCT15% FEW11% Top: BKN	—
sky_base_2_ft	decimal	—	75.8%88,798 values	660.2%	3000.008% 2000.006% 4000.005% Other (54) Top: 3000.00 · 13,968 more values	Median 2000.00P25 1100.00 · P75 3100.00
sky_cover_3	string	—	95.9%112,415 values	4<0.1%	BKN64% FEW23% SCT8% Top: BKN	—
sky_base_3_ft	decimal	—	95.9%112,415 values	491.0%	3000.0017% 2000.0011% 4000.008% Other (37) Top: 3000.00 · 1,746 more values	Median 3000.00P25 2000.00 · P75 3800.00
sky_cover_4	string	—	99.9%117,035 values	42.6%	BKN60% FEW34% SCT4% Top: BKN	—

Show 17 more columns

Verified column analytics for reports_efhk
sky_base_4_ft	decimal	—	99.9%117,035 values	2918.7%	3000.0019% 4000.0012% 2000.008% Other (17) Top: 3000.00 · 36 more values	Median 3500.00P25 3000.00 · P75 4000.00
visibility_miles	decimal	—	<0.1%1 values	62<0.1%	6.2186% 4.352% 3.731% Other (50) Top: 6.21 · 3,974 more values	Median 6.21P25 6.21 · P75 6.21
weather_codes	string	—	73.8%86,461 values	1700.6%	-SN21% -RA14% VCSH10% Other (158) Top: -SN · 6,866 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%117,190 values	00.0%	No distribution published No distribution published	—
peak_wind_direction_degrees	decimal	—	100.0%117,190 values	00.0%	No distribution published No distribution published	—
peak_wind_time	string	—	100.0%117,190 values	00.0%	No distribution published No distribution published	—
snow_depth_inches	decimal	—	100.0%117,190 values	00.0%	No distribution published No distribution published	—
raw_metar	string	—	0.0%0 values	117,189100.0%	EFHK 162320Z VRB02KT CAVOK 11/10 Q1015 NOSIG0% COR EFHK 010420Z 12003KT 9999 FEW021 SCT035 03/03 Q1012 NOSIG0% COR EFHK 011020Z 13008KT 1800 -RA BR BKN002 01/01 Q1011 BECMG 14000% Other (117,177) Top: EFHK 162320Z VRB02KT CAVOK 11/10 Q1015 NOSIG · 117,177 more values	—
cli_product	string	—	100.0%117,190 values	00.0%	No distribution published No distribution published	—
cli_high_f	integer	—	100.0%117,190 values	00.0%	No distribution published All-row histogram	—
cli_low_f	integer	—	100.0%117,190 values	00.0%	No distribution published All-row histogram	—
cli_report_type	string	—	100.0%117,190 values	00.0%	No distribution published No distribution published	—
metar_high_f	decimal	—	0.0%0 values	52<0.1%	35.605% 39.204% 68.004% Other (40) Top: 35.60 · 65,238 more values	Median 50.00P25 37.40 · P75 66.20
metar_low_f	decimal	—	0.0%0 values	48<0.1%	32.007% 33.806% 30.205% Other (36) Top: 32.00 · 53,166 more values	Median 35.60P25 28.40 · P75 48.20
metar_high_c	decimal	—	0.0%0 values	52<0.1%	2.05% 4.04% 20.04% Other (40) Top: 2.0 · 65,238 more values	Median 10.0P25 3.0 · P75 19.0
metar_low_c	decimal	—	0.0%0 values	48<0.1%	0.07% 1.06% -1.05% Other (36) Top: 0.0 · 53,166 more values	Median 2.0P25 -2.0 · P75 9.0

Release status

Facts from the current passing release

Release: Passing
Rows: 117,190
Columns: 37
Published: 9 Sept 2026, 07:20
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_efhk

reports_efhk

# Current release — the complete Parquet file
curl -sS -o reports-efhk.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/b1cd06cd-6309-4584-9222-c55e78f4daf1/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/b1cd06cd-6309-4584-9222-c55e78f4daf1/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/b1cd06cd-6309-4584-9222-c55e78f4daf1/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

Helsinki weather reports and daily highs since 2020

reports_efhk

Release status