Sri Lanka Weather Dataset
Rainfall, temperature and relative humidity from 2012 to 2018.
@kaggle.ivantha_sri_lanka_weather_dataset
Rainfall, temperature and relative humidity from 2012 to 2018.
@kaggle.ivantha_sri_lanka_weather_dataset
CREATE TABLE angoda_rf_2017_2018 (
"station_id" VARCHAR,
"station_name" VARCHAR,
"element_name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"obs_val_mm" DOUBLE
);
CREATE TABLE colombo_rf_2018 (
"station_id" VARCHAR,
"station_name" VARCHAR,
"element_name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"obs_val_mm" DOUBLE
);
CREATE TABLE colombo_rh_2012_2018 (
"station_id" BIGINT,
"station_name" VARCHAR,
"element_name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"obs_val" DOUBLE
);
CREATE TABLE colombo_t_2012_2018 (
"station_id" BIGINT,
"station_name" VARCHAR,
"element_name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"obs_val" DOUBLE
);
CREATE TABLE dehiwala_rf_2012_2018 (
"station_id" VARCHAR,
"station_name" VARCHAR,
"element_name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"obs_val" DOUBLE
);
CREATE TABLE henarathgoda_rf_2017_2018 (
"station_id" VARCHAR,
"station_name" VARCHAR,
"element_name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"obs_val_mm" DOUBLE
);
CREATE TABLE homagama_rf_2012_2018 (
"station_id" VARCHAR,
"station_name" VARCHAR,
"element_name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"obs_val" DOUBLE
);
CREATE TABLE katunayake_rh_2017_2018 (
"station_id" BIGINT,
"station_name" VARCHAR,
"element_name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"obs_val" BIGINT
);
CREATE TABLE katunayake_t_2017_2018 (
"station_id" BIGINT,
"station_name" VARCHAR,
"element_name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"obs_val" DOUBLE
);
CREATE TABLE nittambuwa_rf_2017_2018 (
"station_id" VARCHAR,
"station_name" VARCHAR,
"element_name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"obs_val_mm" DOUBLE
);
CREATE TABLE ratmalana_rf_2012_2018 (
"station_id" BIGINT,
"station_name" VARCHAR,
"element_name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"obs_val" DOUBLE
);
CREATE TABLE ratmalana_rh_2012_2018 (
"station_id" BIGINT,
"station_name" VARCHAR,
"element_name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"obs_val" DOUBLE
);
CREATE TABLE ratmalana_t_2012_2018 (
"station_id" BIGINT,
"station_name" VARCHAR,
"element_name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"obs_val" DOUBLE
);
CREATE TABLE welisara_navy_rf_2017_2018 (
"station_id" VARCHAR,
"station_name" VARCHAR,
"element_name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"obs_val_mm" DOUBLE
);
Anyone who has the link will be able to view this.