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
This dataset contains the weather data scross several weather stations in Sri Lanka from 2012 to 2018.
Articles: The ownership of the data belongs to Sri Lankan Meteorology Department.
*Dataset image: https://weather.com/health/allergy/news/thunderstorm-asthma
If you use this data in any research work / publication, please cite this dataset as,
Oshan Mudannayake. (2023). Sri Lanka Weather Dataset [Data set]. Kaggle. https://doi.org/10.34740/KAGGLE/DSV/4890846
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.