Weather.csv
data of weather in Albania for last three years
@kaggle.gucci1337_weather_of_albania_last_three_years
data of weather in Albania for last three years
@kaggle.gucci1337_weather_of_albania_last_three_years
CREATE TABLE elbasan2021 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" DOUBLE,
"wspd" DOUBLE,
"wpgt" VARCHAR,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE elbasan2022 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" DOUBLE,
"wspd" DOUBLE,
"wpgt" VARCHAR,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE elbasan2023 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" DOUBLE,
"wspd" DOUBLE,
"wpgt" VARCHAR,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE gramsh2021 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" DOUBLE,
"wspd" DOUBLE,
"wpgt" VARCHAR,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE gramsh2022 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" DOUBLE,
"wspd" DOUBLE,
"wpgt" VARCHAR,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE gramsh2023 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" BIGINT,
"wspd" DOUBLE,
"wpgt" VARCHAR,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE himare2021 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" DOUBLE,
"wspd" DOUBLE,
"wpgt" VARCHAR,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE himare2022 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" DOUBLE,
"wspd" DOUBLE,
"wpgt" VARCHAR,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE himare2023 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" BIGINT,
"wspd" DOUBLE,
"wpgt" VARCHAR,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE kavaje2021 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" VARCHAR,
"snow" VARCHAR,
"wdir" BIGINT,
"wspd" DOUBLE,
"wpgt" DOUBLE,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE kavaje2022 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" BIGINT,
"wspd" DOUBLE,
"wpgt" DOUBLE,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE kavaje2023 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" BIGINT,
"wspd" DOUBLE,
"wpgt" DOUBLE,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE korce2021 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" DOUBLE,
"wspd" DOUBLE,
"wpgt" VARCHAR,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE korce2022 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" DOUBLE,
"wspd" DOUBLE,
"wpgt" VARCHAR,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE korce2023 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" BIGINT,
"wspd" DOUBLE,
"wpgt" VARCHAR,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE kruje2021 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" DOUBLE,
"wspd" DOUBLE,
"wpgt" VARCHAR,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE kruje2022 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" DOUBLE,
"wspd" DOUBLE,
"wpgt" VARCHAR,
"pres" DOUBLE,
"tsun" VARCHAR
);
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
);
CREATE TABLE kukes2021 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" VARCHAR,
"snow" VARCHAR,
"wdir" BIGINT,
"wspd" DOUBLE,
"wpgt" DOUBLE,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE kukes2022 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" BIGINT,
"wspd" DOUBLE,
"wpgt" DOUBLE,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE kukes2023 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" BIGINT,
"wspd" DOUBLE,
"wpgt" DOUBLE,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE lezhe2021 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" VARCHAR,
"snow" VARCHAR,
"wdir" BIGINT,
"wspd" DOUBLE,
"wpgt" DOUBLE,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE lezhe2022 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" BIGINT,
"wspd" DOUBLE,
"wpgt" DOUBLE,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE lezhe2023 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" BIGINT,
"wspd" DOUBLE,
"wpgt" DOUBLE,
"pres" DOUBLE,
"tsun" VARCHAR
);
CREATE TABLE sarande2021 (
"date" TIMESTAMP,
"tavg" DOUBLE,
"tmin" DOUBLE,
"tmax" DOUBLE,
"prcp" DOUBLE,
"snow" VARCHAR,
"wdir" DOUBLE,
"wspd" DOUBLE,
"wpgt" VARCHAR,
"pres" DOUBLE,
"tsun" VARCHAR
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
Anyone who has the link will be able to view this.