Minneapolis weather reports and daily highs since 2020

Each row is one METAR or SPECI weather report from Minneapolis (KMSP), since January 2020, via Iowa Environmental Mesonet. 71,576 reports of temperature, wind, pressure, visibility with the day's official NWS high and low.

Coverage

• Window: 2020-01-01 to the most recent completed day, refreshed each morning after the National Weather Service issues its daily climate report. Report times are UTC; the calendar date is on Central Standard Time (UTC-6) all year, no daylight saving shift, matching the day the official high and low cover.
• Grain: one row per report; 2,443 days from 2020-01-01 to 2026-09-08 at the first build. Routine METAR reports arrive about hourly; special SPECI reports arrive when conditions change. A typical month holds 791 to 966 rows.
• Cadence: one new day of reports each morning; the official high and low land on that day's rows once published, usually the next morning.
• Station: Minneapolis-Saint Paul International Airport, ICAO code KMSP, the station whose reports settle daily temperature questions for Minneapolis.

Columns

• station — the ICAO code of the reporting station, always KMSP.
• event_time_utc — the report time in UTC.
• observation_type — METAR for a routine report, SPECI for a special report.
• local_standard_date — the calendar date on Central Standard Time.
• temp_f, dewpoint_f — air temperature and dew point, degrees Fahrenheit.
• relative_humidity_pct — relative humidity, percent.
• wind_direction_degrees, wind_speed_kt, wind_gust_kt — wind direction clockwise from true north, sustained speed and gust, knots.
• altimeter_inhg, sea_level_pressure_hpa — altimeter setting in inches of mercury and sea-level pressure in hectopascals.
• sky_cover_1 to sky_cover_4, sky_base_1_ft to sky_base_4_ft — up to four sky-cover layers with their base height in feet.
• visibility_miles — horizontal visibility, statute miles.
• weather_codes — present-weather codes such as RA, SN, FG, TS.
• precipitation_in_1h — one-hour precipitation, inches.
• peak_wind_gust_kt, peak_wind_direction_degrees, peak_wind_time — peak wind from the report remarks.
• snow_depth_inches — snow depth, inches.
• raw_metar — the original report text.
• cli_high_f, cli_low_f — the official National Weather Service daily maximum and minimum temperature for the climate date, degrees Fahrenheit.
• cli_product, cli_report_type — the climate report the official values came from and whether it was the preliminary, final or corrected issue.
• metar_high_f, metar_low_f — the highest and lowest temperature in any report on the same climate date, degrees Fahrenheit, derived from the rows.

Missing values

Absent fields are null, never zero. A trace of precipitation is null. Sky layers beyond those reported are null. The official high and low are null on the most recent day until the National Weather Service issues its report, and on the rare day no report was archived. The derived daily range is null only on a day with no parsable temperature.

Suitable for

• Comparing the official daily high with the highest hourly report on the same day. They agree on 1,069 of 2,442 days; the hourly maximum sits below the official high on 1,331 days and above it on 42, because the official value is a continuous maximum and the reports are point readings.
• Reconstructing Minneapolis conditions at any hour since 2020.
• Building daily temperature, wind and precipitation series for Minneapolis-Saint Paul International Airport.
• Checking what KMSP reported around a settlement time or a forecast.

Source and rights

Reports are National Weather Service ASOS observations redistributed by the Iowa Environmental Mesonet (IEM) at Iowa State University, which asks for attribution. Official daily values are NWS Climatological Report (Daily) products for KMSP. Both are United States Government works in the public domain.