Weather data notebook
Generated: 2026-06-16 12:43:18
This report is generated from two CSV files: locations.csv and daily_weather.csv. The notebook imports both files into SQLite, joins them by location_id, and renders tables plus SVG charts from SQL blocks inside this markdown template.
Dataset overview
locations weather_rows first_day last_day 8 2928 2024-01-01 2024-12-31
City summary
City Country Days Avg C High C Low C Rain mm Wet days Buenos Aires AR 366 17.7 36.1 -1.4 1096.8 150 Cairo EG 366 24.1 45.1 5.4 19.6 26 Istanbul TR 366 16.2 34.8 -2.5 720.7 170 London GB 366 11.7 31.2 -5.1 893.6 240 New York US 366 13 36.3 -14.9 1291.9 180 Reykjavik IS 366 3.9 16.2 -15.6 1593.6 258 Singapore SG 366 27.6 34.1 23.1 2469.1 358 Tokyo JP 366 16.7 38.8 -4.7 1721.3 197
Average temperature by city
Monthly precipitation trend
Weather condition distribution
Wettest days
Date City Country Rain mm Avg C Condition 2024-06-18 Tokyo JP 95.5 20 rain 2024-05-04 Singapore SG 92.1 26.2 rain 2024-03-20 Buenos Aires AR 67.4 23 rain 2024-06-28 Tokyo JP 64 22.1 rain 2024-03-23 New York US 63.6 5.8 rain 2024-11-02 Tokyo JP 58.1 16 rain 2024-08-16 Tokyo JP 57.3 26.2 rain 2024-08-31 Buenos Aires AR 53 11 rain 2024-05-24 Reykjavik IS 50.1 7.9 rain 2024-09-23 London GB 48.7 15.7 rain 2024-11-27 Singapore SG 48 25 rain 2024-03-13 Buenos Aires AR 47.8 23.8 rain
Join example
Date City Country Avg C Rain mm Code 2024-01-01 New York United States 3.5 0 3 2024-01-01 London United Kingdom 7.7 8.3 61 2024-01-02 New York United States 0 0 0 2024-01-02 London United Kingdom 11.1 9.6 61 2024-01-03 New York United States 1.5 0 3 2024-01-03 London United Kingdom 8.4 2.3 61 2024-01-04 New York United States 2 0 3 2024-01-04 London United Kingdom 6.8 27.7 65 2024-01-05 New York United States -1.8 0 3 2024-01-05 London United Kingdom 5.7 4.6 63 2024-01-06 New York United States -1.1 11 75 2024-01-06 London United Kingdom 4.8 0.2 51
