Weather.csv
data of weather in Albania for last three years
@kaggle.gucci1337_weather_of_albania_last_three_years
Table List
- 33 tables(564.73 KB)
- Elbasan2021
- Elbasan2022
- Elbasan2023
- Gramsh2021
- Gramsh2022
- Gramsh2023
- Himare2021
- Himare2022
- Himare2023
- Kavaje2021
- Kavaje2022
- Kavaje2023
- Korce2021
- Korce2022
- Korce2023
- Kruje2021
- Kruje2022
- Kruje2023
- Kukes2021
- Kukes2022
- Kukes2023
- Lezhe2021
- Lezhe2022
- Lezhe2023
- Sarande2021
- Sarande2022
- Sarande2023
- Tirana2021
- Tirana2022
- Tirana2023
- Vlore2021
- Vlore2022
- Vlore2023
Kruje2023
@kaggle.gucci1337_weather_of_albania_last_three_years.kruje2023
- 17.15 KB
- 365 rows
- 11 columns
dateDate | tavgTavg | tminTmin | tmaxTmax | prcpPrcp | snowSnow | wdirWdir | wspdWspd | wpgtWpgt | presPres | tsunTsun |
|---|---|---|---|---|---|---|---|---|---|---|
| Sun Jan 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | 12.3 | 8.2 | 18.4 | 48 | 2.1 | 1030.9 | ||||
| Mon Jan 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | 11.9 | 7.2 | 17.4 | 53 | 3.1 | 1030.3 | ||||
| Tue Jan 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | 11.7 | 8 | 17.8 | 46 | 2.7 | 1028.8 | ||||
| Wed Jan 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | 11.3 | 7.5 | 16.2 | 52 | 2.8 | 1026.7 | ||||
| Thu Jan 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | 10.5 | 7 | 16.8 | 77 | 2.9 | 1023.6 | ||||
| Fri Jan 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | 10.7 | 5.6 | 17.2 | 44 | 2.9 | 1023.1 | ||||
| Sat Jan 07 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | 9.5 | 4.7 | 16.8 | 46 | 2.8 | 1023 | ||||
| Sun Jan 08 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | 10 | 5.6 | 16.8 | 116 | 4 | 1021.8 | ||||
| Mon Jan 09 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | 12.1 | 8.4 | 15.4 | 20.2 | 135 | 12.8 | 1014.9 | |||
| Tue Jan 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | 9.8 | 6 | 14.8 | 16.9 | 107 | 8.4 | 1007.3 |
CREATE TABLE kruje2023 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" BIGINT,
"wspd" DOUBLE,
"wpgt" VARCHAR,
"pres" DOUBLE,
"tsun" VARCHAR
);