Name: Weather.csv
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

About this Dataset

Weather.csv

I hope this dataset will help u on your project, even it is still not-completed. If you have any idea for what to use this dataset for, that hasn't been created till now, just write me. Thanks.(P.S i have a project on my mind and im still working with data.)

UPDATE IN 2024/05/18

Added more data weather of cities in Albania.

Tables

Sarande2022

@kaggle.gucci1337_weather_of_albania_last_three_years.sarande2022

16.7 KB
365 rows
11 columns


CREATE TABLE sarande2022 (
  "date" TIMESTAMP,
  "tavg" DOUBLE,
  "tmin" DOUBLE,
  "tmax" DOUBLE,
  "prcp" DOUBLE,
  "snow" VARCHAR,
  "wdir" DOUBLE,
  "wspd" DOUBLE,
  "wpgt" VARCHAR,
  "pres" DOUBLE,
  "tsun" VARCHAR
);

Sarande2023

@kaggle.gucci1337_weather_of_albania_last_three_years.sarande2023

16.82 KB
365 rows
11 columns


CREATE TABLE sarande2023 (
  "date" TIMESTAMP,
  "tavg" DOUBLE,
  "tmin" DOUBLE,
  "tmax" DOUBLE,
  "prcp" DOUBLE,
  "snow" VARCHAR,
  "wdir" BIGINT,
  "wspd" DOUBLE,
  "wpgt" VARCHAR,
  "pres" DOUBLE,
  "tsun" VARCHAR
);

Tirana2021

@kaggle.gucci1337_weather_of_albania_last_three_years.tirana2021

17.18 KB
365 rows
11 columns


CREATE TABLE tirana2021 (
  "date" TIMESTAMP,
  "tavg" DOUBLE,
  "tmin" DOUBLE,
  "tmax" DOUBLE,
  "prcp" DOUBLE,
  "snow" VARCHAR,
  "wdir" DOUBLE,
  "wspd" DOUBLE,
  "wpgt" VARCHAR,
  "pres" DOUBLE,
  "tsun" VARCHAR
);

Tirana2022

@kaggle.gucci1337_weather_of_albania_last_three_years.tirana2022

17.16 KB
365 rows
11 columns


CREATE TABLE tirana2022 (
  "date" TIMESTAMP,
  "tavg" DOUBLE,
  "tmin" DOUBLE,
  "tmax" DOUBLE,
  "prcp" DOUBLE,
  "snow" VARCHAR,
  "wdir" DOUBLE,
  "wspd" DOUBLE,
  "wpgt" VARCHAR,
  "pres" DOUBLE,
  "tsun" VARCHAR
);

Tirana2023

@kaggle.gucci1337_weather_of_albania_last_three_years.tirana2023

17.15 KB
365 rows
11 columns


CREATE TABLE tirana2023 (
  "date" TIMESTAMP,
  "tavg" DOUBLE,
  "tmin" DOUBLE,
  "tmax" DOUBLE,
  "prcp" DOUBLE,
  "snow" VARCHAR,
  "wdir" BIGINT,
  "wspd" DOUBLE,
  "wpgt" VARCHAR,
  "pres" DOUBLE,
  "tsun" VARCHAR
);

Vlore2021

@kaggle.gucci1337_weather_of_albania_last_three_years.vlore2021

17.32 KB
365 rows
11 columns


CREATE TABLE vlore2021 (
  "date" TIMESTAMP,
  "tavg" DOUBLE,
  "tmin" DOUBLE,
  "tmax" DOUBLE,
  "prcp" DOUBLE,
  "snow" VARCHAR,
  "wdir" DOUBLE,
  "wspd" DOUBLE,
  "wpgt" VARCHAR,
  "pres" DOUBLE,
  "tsun" VARCHAR
);

Vlore2022

@kaggle.gucci1337_weather_of_albania_last_three_years.vlore2022

17.1 KB
365 rows
11 columns


CREATE TABLE vlore2022 (
  "date" TIMESTAMP,
  "tavg" DOUBLE,
  "tmin" DOUBLE,
  "tmax" DOUBLE,
  "prcp" DOUBLE,
  "snow" VARCHAR,
  "wdir" DOUBLE,
  "wspd" DOUBLE,
  "wpgt" VARCHAR,
  "pres" DOUBLE,
  "tsun" VARCHAR
);

Vlore2023

@kaggle.gucci1337_weather_of_albania_last_three_years.vlore2023

17.22 KB
365 rows
11 columns


CREATE TABLE vlore2023 (
  "date" TIMESTAMP,
  "tavg" DOUBLE,
  "tmin" DOUBLE,
  "tmax" DOUBLE,
  "prcp" DOUBLE,
  "snow" VARCHAR,
  "wdir" DOUBLE,
  "wspd" DOUBLE,
  "wpgt" VARCHAR,
  "pres" DOUBLE,
  "tsun" VARCHAR
);