Milan weather reports and daily highs since 2020

Public

reports_liml

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:39
Rows
116,260
across released Tables
Tables
1
released
Columns
37
reports_liml
Version
reports_liml

Data preview

reports_liml
Preview rows for reports_liml
stationevent_time_utcobservation_typelocal_standard_datetemp_ftemp_cdewpoint_frelative_humidity_pctwind_direction_degreeswind_speed_ktwind_gust_ktaltimeter_inhgsea_level_pressure_hpasky_cover_1sky_base_1_ftsky_cover_2sky_base_2_ftsky_cover_3sky_base_3_ftsky_cover_4
LIML2020-01-01T00:20:00.000000ZSPECI2020-01-0132.000.030.2092.971.0030.420NSC
LIML2020-01-01T00:50:00.000000ZMETAR2020-01-0130.20-1.028.4092.922.0030.420NSC
LIML2020-01-01T01:20:00.000000ZSPECI2020-01-0128.40-2.028.40100.001.0030.420NSC
LIML2020-01-01T01:50:00.000000ZMETAR2020-01-0130.20-1.028.4092.921.0030.420NSC
LIML2020-01-01T02:20:00.000000ZSPECI2020-01-0128.40-2.026.6092.86170.001.0030.420NSC
LIML2020-01-01T02:50:00.000000ZMETAR2020-01-0130.20-1.030.20100.00220.002.0030.390NSC
LIML2020-01-01T03:20:00.000000ZSPECI2020-01-0130.20-1.030.20100.00290.002.0030.390NSC
LIML2020-01-01T03:50:00.000000ZMETAR2020-01-0128.40-2.028.40100.002.0030.390NSC
LIML2020-01-01T04:20:00.000000ZSPECI2020-01-0128.40-2.026.6092.86270.002.0030.390NSC
LIML2020-01-01T04:50:00.000000ZMETAR2020-01-0128.40-2.026.6092.861.0030.390NSC
A bounded preview of the immutable release.

Columns

Schema, units, meaning, and verified release profile

37 columns
Verified column analytics for reports_liml
ColumnTypeUnitMissingDistinctDistributionSummary
stationstring0.0%0 values1<0.1%
  • LIML100%

Top: LIML

event_time_utctimestamp_utc0.0%0 values116,260100.0%
  • 2020-01-01 00:20:00+000%
  • 2020-01-01 00:50:00+000%
  • 2020-01-01 01:20:00+000%
  • Other (116,248)

Top: 2020-01-01 00:20:00+00 · 116,248 more values

observation_typestring0.0%0 values2<0.1%
  • METAR50%
  • SPECI50%

Top: METAR

local_standard_datedate0.0%0 values2,4442.1%
  • 2020-01-020%
  • 2020-01-050%
  • 2020-01-070%
  • Other (2,432)

Top: 2020-01-02 · 115,684 more values

temp_fdecimal<0.1%16 values44<0.1%
  • 48.204%
  • 46.404%
  • 44.604%
  • Other (32)

Top: 48.20 · 65,478 more values

Median 59.00P25 46.40 · P75 71.60
temp_cdecimal<0.1%16 values44<0.1%
  • 9.04%
  • 8.04%
  • 7.04%
  • Other (32)

Top: 9.0 · 65,478 more values

Median 15.0P25 8.0 · P75 22.0
dewpoint_fdecimal<0.1%17 values47<0.1%
  • 57.205%
  • 59.005%
  • 60.805%
  • Other (35)

Top: 57.20 · 49,825 more values

Median 50.00P25 39.20 · P75 59.00
relative_humidity_pctdecimal<0.1%20 values1,4191.2%
  • 100.0013%
  • 93.451%
  • 93.401%
  • Other (1,407)

Top: 100.00 · 91,704 more values

Median 74.44P25 56.13 · P75 93.03
wind_direction_degreesdecimal29.2%33,901 values44<0.1%
  • 260.005%
  • 250.005%
  • 80.004%
  • Other (32)

Top: 260.00 · 43,721 more values

Median 170.00P25 90.00 · P75 250.00
wind_speed_ktdecimal<0.1%6 values31<0.1%
  • 2.0020%
  • 3.0020%
  • 4.0016%
  • Other (19)

Top: 2.00 · 1,620 more values

Median 3.00P25 2.00 · P75 5.00
wind_gust_ktdecimal99.7%115,912 values329.2%
  • 27.008%
  • 24.007%
  • 26.007%
  • Other (20)

Top: 27.00 · 105 more values

Median 26.00P25 23.00 · P75 30.00
altimeter_inhgdecimal<0.1%10 values77<0.1%
  • 30.0007%
  • 29.9706%
  • 30.0306%
  • Other (65)

Top: 30.000 · 45,981 more values

Median 30.000P25 29.850 · P75 30.150
sea_level_pressure_hpadecimal100.0%116,260 values00.0%

No distribution published

No distribution published

sky_cover_1string40.8%47,489 values7<0.1%
  • SCT31%
  • FEW30%
  • BKN20%

Top: SCT

sky_base_1_ftdecimal49.4%57,382 values1160.2%
  • 3000.009%
  • 4000.009%
  • 5000.009%
  • Other (104)

Top: 3000.00 · 16,353 more values

Median 3500.00P25 1500.00 · P75 6000.00
sky_cover_2string82.3%95,702 values4<0.1%
  • BKN63%
  • SCT29%
  • OVC8%

Top: BKN

sky_base_2_ftdecimal82.3%95,702 values1130.5%
  • 6000.0014%
  • 7000.0013%
  • 5000.0011%
  • Other (101)

Top: 6000.00 · 2,712 more values

Median 5000.00P25 3000.00 · P75 7000.00
sky_cover_3string99.1%115,263 values40.4%
  • BKN91%
  • OVC9%
  • FEW0%

Top: BKN

sky_base_3_ftdecimal99.1%115,263 values777.7%
  • 6000.0019%
  • 7000.0013%
  • 5000.0012%
  • Other (65)

Top: 6000.00 · 203 more values

Median 6000.00P25 4700.00 · P75 8000.00
sky_cover_4string100.0%116,260 values00.0%

No distribution published

No distribution published

Show 17 more columns
Verified column analytics for reports_liml
sky_base_4_ftdecimal100.0%116,260 values00.0%

No distribution published

No distribution published

visibility_milesdecimal<0.1%15 values64<0.1%
  • 6.2178%
  • 4.973%
  • 3.113%
  • Other (52)

Top: 6.21 · 5,266 more values

Median 6.21P25 6.21 · P75 6.21
weather_codesstring80.6%93,664 values1090.5%
  • BR33%
  • -RA14%
  • FG12%
  • Other (97)

Top: BR · 1,680 more values

precipitation_in_1hdecimal0.0%0 values1<0.1%
  • 0.000100%

Top: 0.000

Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_ktdecimal100.0%116,260 values00.0%

No distribution published

No distribution published

peak_wind_direction_degreesdecimal100.0%116,260 values00.0%

No distribution published

No distribution published

peak_wind_timestring100.0%116,260 values00.0%

No distribution published

No distribution published

snow_depth_inchesdecimal100.0%116,260 values00.0%

No distribution published

No distribution published

raw_metarstring0.0%0 values116,247100.0%
  • LIML 010550Z VRB02KT CAVOK 25/20 Q1013 NOSIG0%
  • LIML 021920Z 18003KT CAVOK 26/17 Q1015 NOSIG0%
  • LIML 030950Z VRB01KT CAVOK 10/05 Q1016 NOSIG0%
  • Other (116,235)

Top: LIML 010550Z VRB02KT CAVOK 25/20 Q1013 NOSIG · 116,236 more values

cli_productstring100.0%116,260 values00.0%

No distribution published

No distribution published

cli_high_finteger100.0%116,260 values00.0%

No distribution published

All-row histogram

cli_low_finteger100.0%116,260 values00.0%

No distribution published

All-row histogram

cli_report_typestring100.0%116,260 values00.0%

No distribution published

No distribution published

metar_high_fdecimal0.0%0 values38<0.1%
  • 86.004%
  • 87.804%
  • 60.804%
  • Other (26)

Top: 86.00 · 65,024 more values

Median 68.00P25 53.60 · P75 82.40
metar_low_fdecimal0.0%0 values33<0.1%
  • 68.005%
  • 39.205%
  • 42.805%
  • Other (21)

Top: 68.00 · 56,996 more values

Median 50.00P25 39.20 · P75 62.60
metar_high_cdecimal0.0%0 values38<0.1%
  • 30.04%
  • 31.04%
  • 16.04%
  • Other (26)

Top: 30.0 · 65,024 more values

Median 20.0P25 12.0 · P75 28.0
metar_low_cdecimal0.0%0 values33<0.1%
  • 20.05%
  • 4.05%
  • 6.05%
  • Other (21)

Top: 20.0 · 56,996 more values

Median 10.0P25 4.0 · P75 17.0

Release status

Facts from the current passing release

Release
Passing
Rows
116,260
Columns
37
Published
9 Sept 2026, 06:39
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_liml
reports_liml
# Current release — the complete Parquet file
curl -sS -o reports-liml.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/0adf8ee7-dcbf-49f6-af99-ab61c4a835bb/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/0adf8ee7-dcbf-49f6-af99-ab61c4a835bb/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/0adf8ee7-dcbf-49f6-af99-ab61c4a835bb/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