Global City Daily Weather & Climate Dataset — 50 Cities, 18,300 Observations (2024)

About this data

Comprehensive daily weather observations for 50 major cities across all 6 inhabited continents throughout 2024. Each of the 18,300 rows captures a single city-day with 15 meteorological variables including temperature extremes, precipitation, snowfall, wind speed and gusts, sunshine duration, and evapotranspiration — plus derived indicators like frost days, heat days, and precipitation intensity categories. **Sources:** - Open-Meteo Historical Weather API (ERA5 reanalysis + station data) - Curated world cities database (population, coordinates, timezone metadata) **Coverage:** 50 cities spanning North America (7), South America (5), Europe (10), Asia (13), Africa (7), and Oceania (3) — from Reykjavik (64°N) to Melbourne (37°S), Anchorage to Singapore. **Schema (22 columns):** - `date` — ISO 8601 date - `city`, `country`, `continent` — geographic identifiers - `latitude`, `longitude` — WGS84 coordinates - `city_population` — estimated city population - `timezone` — IANA timezone - `temperature_max_c`, `temperature_min_c`, `temperature_mean_c` — daily temperature in Celsius - `precipitation_mm`, `rain_mm`, `snowfall_cm` — daily precipitation totals - `wind_speed_max_kmh`, `wind_gusts_max_kmh` — peak wind measurements - `sunshine_duration_hours` — hours of sunshine - `evapotranspiration_mm` — FAO Penman-Monteith reference ET₀ - `temperature_range_c` — diurnal temperature swing - `is_frost_day` — binary flag (min temp ≤ 0°C) - `is_hot_day` — binary flag (max temp ≥ 35°C) - `precipitation_category` — none/light/moderate/heavy/extreme **Use cases:** Climate analysis, city comparison dashboards, anomaly detection, ML weather modeling, urban planning research, travel analytics.

Schema

Sample Data

Preview a sample of the data before downloading.