Baselight

Sri Lanka Weather Dataset

Rainfall, temperature and relative humidity from 2012 to 2018.

@kaggle.ivantha_sri_lanka_weather_dataset

Colombo T 2012–2018
@kaggle.ivantha_sri_lanka_weather_dataset.colombo_t_2012_2018

  • 10.13 KB
  • 3673 rows
  • 7 columns
station_id

Station Id

station_name

Station Name

element_name

Element Name

year

Year

month

Month

day

Day

obs_val

Obs Val

43466COLOMBOTMPMAX20121130.1
43466COLOMBOTMPMAX20121230.7
43466COLOMBOTMPMAX20121331.6
43466COLOMBOTMPMAX20121430.4
43466COLOMBOTMPMAX20121532.3
43466COLOMBOTMPMAX20121633.1
43466COLOMBOTMPMAX20121731
43466COLOMBOTMPMAX20121830.6
43466COLOMBOTMPMAX20121930.8
43466COLOMBOTMPMAX201211029.9

CREATE TABLE colombo_t_2012_2018 (
  "station_id" BIGINT,
  "station_name" VARCHAR,
  "element_name" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "obs_val" DOUBLE
);