London Weather Data

Historical London weather data from 1979 to 2021

@kaggle.emmanuelfwerr_london_weather_data

Table List

1 table(226.58 KB)

London Weather

@kaggle.emmanuelfwerr_london_weather_data.london_weather

226.58 KB
15341 rows
10 columns

date Date	cloud_cover Cloud Cover	sunshine Sunshine	global_radiation Global Radiation	max_temp Max Temp	mean_temp Mean Temp	min_temp Min Temp	precipitation Precipitation	pressure Pressure	snow_depth Snow Depth
19790101	2	7	52	2.3	-4.1	-7.5	0.4	101900	9
19790102	6	1.7	27	1.6	-2.6	-7.5		102530	8
19790103	5		13	1.3	-2.8	-7.2		102050	4
19790104	8		13	-0.3	-2.6	-6.5		100840	2
19790105	6	2	29	5.6	-0.8	-1.4		102250	1
19790106	5	3.8	39	8.3	-0.5	-6.6	0.7	102780	1
19790107	8		13	8.5	1.5	-5.3	5.2	102520
19790108	8	0.1	15	5.8	6.9	5.3	0.8	101870
19790109	4	5.8	50	5.2	3.7	1.6	7.2	101170
19790110	7	1.9	30	4.9	3.3	1.4	2.1	98700


CREATE TABLE london_weather (
  "date" BIGINT,
  "cloud_cover" DOUBLE,
  "sunshine" DOUBLE,
  "global_radiation" DOUBLE,
  "max_temp" DOUBLE,
  "mean_temp" DOUBLE,
  "min_temp" DOUBLE,
  "precipitation" DOUBLE,
  "pressure" DOUBLE,
  "snow_depth" DOUBLE
);