Daily weather data, 2024

Name: Daily weather data, 2024
Creator: Open-Meteo Historical Weather API (ERA5-based reanalysis)
License: https://creativecommons.org/licenses/by/4.0/

3,660 × 8rows × columns in the file

Updated 3 November 2026. Real data: Open-Meteo Historical Weather API (ERA5-based reanalysis).

CSV XLSX JSON SQL

textnumberdateyes/no

Rows3,660in the file

Columns8with a data dictionary below

Dates2024-01-01 – 2024-12-31range in the file

LicenceCC BY 4.0credit the source

What is in it

One row per city per day for 2024: maximum, minimum and mean temperature, precipitation and maximum wind, for eight U.S. cities plus London and Tokyo, from Open-Meteo's historical weather API.

Reanalysis values for the city-centre grid cell, not a single weather station. Values and metric units are as the API returns them.

First rows

point at a column to light it up

citytext	countrytext	datedate	temp_max_cnumber	temp_min_cnumber	temp_mean_cnumber	precip_mmnumber	wind_max_kmhnumber
New York	United States	2024-01-01	7.7	-1.2	3.4	0.0	14.3
New York	United States	2024-01-02	5.7	-4.7	-0.0	0.0	12.8
New York	United States	2024-01-03	7.8	-2.3	1.5	0.0	14.4
New York	United States	2024-01-04	6.9	-3.8	1.9	0.0	26.9
New York	United States	2024-01-05	3.1	-5.4	-1.8	0.0	18.5
New York	United States	2024-01-06	2.8	-5.2	-0.9	11.8	29.1
New York	United States	2024-01-07	2.5	-0.7	1.4	6.5	27.0
New York	United States	2024-01-08	6.4	-3.7	1.3	0.0	20.1
New York	United States	2024-01-09	13.1	-4.6	3.9	38.0	57.3
New York	United States	2024-01-10	13.8	4.3	8.9	21.7	42.2

Average temperature by city, 2024

deg C, mean of daily means

Show as a table

city	value
Miami	25.0
Phoenix	24.0
Houston	21.8
Los Angeles	17.4
Tokyo	16.7
New York	13.0
Chicago	11.8
London	11.7
Seattle	11.3
Denver	10.6

Source: Open-Meteo Historical Weather API (ERA5-based reanalysis).

Data dictionary

Column	Type	Meaning
city	text	City
country	text	Country
date	date	Local date
temp_max_c	decimal	Daily maximum air temperature at 2 m, deg C
temp_min_c	decimal	Daily minimum, deg C
temp_mean_c	decimal	Daily mean, deg C
precip_mm	decimal	Total precipitation (rain + snow water), mm
wind_max_kmh	decimal	Maximum wind speed at 10 m, km/h

Practice questions

answers checked in SQL and in Python

Average 2024 temperature (mean of daily means) by city?

Miami 25.0 °C; Phoenix 24.0 °C; Houston 21.8 °C; Los Angeles 17.4 °C; Tokyo 16.7 °C; New York 13.0 °C; Chicago 11.8 °C; London 11.7 °C; Seattle 11.3 °C; Denver 10.6 °C

Excel

=AVERAGEIF(A:A,"Phoenix",F:F)

SQL

SELECT city, ROUND(AVG(temp_mean_c),1) AS t FROM daily_weather_y2024 GROUP BY city ORDER BY t DESC

File: daily-weather-2024

Hottest day in the file?

Phoenix, 2024-07-05, 46.8 °C

SQL

SELECT city, date, temp_max_c FROM daily_weather_y2024 ORDER BY temp_max_c DESC, city LIMIT 1

File: daily-weather-2024

Total 2024 precipitation by city (mm)?

Houston 2,103.0; Tokyo 1,721.3; Miami 1,700.8; New York 1,295.3; Seattle 1,162.1; Chicago 1,030.7; London 893.6; Los Angeles 523.2; Denver 385.3; Phoenix 176.0

SQL

SELECT city, ROUND(SUM(precip_mm),1) AS p FROM daily_weather_y2024 GROUP BY city ORDER BY p DESC

File: daily-weather-2024