Name: Meteorological Data
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

Meteorological Data

Context

The dataset collects the meteorological data of the seven Canary Islands (Tenerife, Las Palmas, La Palma, Fuerteventura, La Gomera, Lanzarote and El Hierro).

Acknowledgements

Castellanos-Nieves, D.; Aguasca-Colomo, Ricardo; Méndez, Máximo (2021), “Meteorological Data Set of the Canary Islands”, Mendeley Data, V1, doi: 10.17632/3v37p6hxk6.1

Tables

Dataset Fuerteventura

@kaggle.saurabhshahane_meteorological_data_set.dataset_fuerteventura

6.26 MB
451,628 rows
14 columns

CREATE TABLE dataset_fuerteventura (
  "id" VARCHAR,
  "time" TIMESTAMP,
  "temp" DOUBLE,
  "wd" DOUBLE,
  "ws" DOUBLE,
  "atmos_pres" DOUBLE,
  "dew_point" DOUBLE,
  "rh" DOUBLE,
  "ceil_hgt" DOUBLE,
  "visibility" DOUBLE,
  "aa1_1" DOUBLE,
  "aa1_2" DOUBLE,
  "aa1_3" DOUBLE,
  "aa1_4" DOUBLE
);

Dataset Gc

@kaggle.saurabhshahane_meteorological_data_set.dataset_gc

12.08 MB
677,963 rows
15 columns

CREATE TABLE dataset_gc (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "time" TIMESTAMP,
  "temp" DOUBLE,
  "wd" DOUBLE,
  "ws" DOUBLE,
  "atmos_pres" DOUBLE,
  "dew_point" DOUBLE,
  "rh" DOUBLE,
  "ceil_hgt" DOUBLE,
  "visibility" DOUBLE,
  "aa1_1" DOUBLE,
  "aa1_2" DOUBLE,
  "aa1_3" DOUBLE,
  "aa1_4" DOUBLE
);

Dataset Gomera

@kaggle.saurabhshahane_meteorological_data_set.dataset_gomera

853.3 kB
38,689 rows
15 columns

CREATE TABLE dataset_gomera (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "time" TIMESTAMP,
  "temp" DOUBLE,
  "wd" DOUBLE,
  "ws" DOUBLE,
  "atmos_pres" DOUBLE,
  "dew_point" DOUBLE,
  "rh" DOUBLE,
  "ceil_hgt" DOUBLE,
  "visibility" DOUBLE,
  "aa1_1" DOUBLE,
  "aa1_2" DOUBLE,
  "aa1_3" DOUBLE,
  "aa1_4" DOUBLE
);

Dataset Hierro

@kaggle.saurabhshahane_meteorological_data_set.dataset_hierro

4.91 MB
253,836 rows
15 columns

CREATE TABLE dataset_hierro (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "time" TIMESTAMP,
  "temp" DOUBLE,
  "wd" DOUBLE,
  "ws" DOUBLE,
  "atmos_pres" DOUBLE,
  "dew_point" DOUBLE,
  "rh" DOUBLE,
  "ceil_hgt" DOUBLE,
  "visibility" DOUBLE,
  "aa1_1" DOUBLE,
  "aa1_2" DOUBLE,
  "aa1_3" DOUBLE,
  "aa1_4" DOUBLE
);

Dataset Lanzarote

@kaggle.saurabhshahane_meteorological_data_set.dataset_lanzarote

11.65 MB
489,455 rows
114 columns

CREATE TABLE dataset_lanzarote (
  "id" VARCHAR,
  "time" TIMESTAMP,
  "temp" DOUBLE,
  "wd" DOUBLE,
  "ws" DOUBLE,
  "atmos_pres" DOUBLE,
  "dew_point" DOUBLE,
  "rh" DOUBLE,
  "ceil_hgt" DOUBLE,
  "visibility" DOUBLE,
  "aa1_1" DOUBLE,
  "aa1_2" DOUBLE,
  "aa1_3" DOUBLE,
  "aa1_4" DOUBLE,
  "ac1_1" DOUBLE,
  "ac1_2" DOUBLE,
  "ac1_3" DOUBLE,
  "ag1_1" DOUBLE,
  "ag1_2" DOUBLE,
  "aj1_1" DOUBLE,
  "aj1_2" DOUBLE,
  "aj1_3" DOUBLE,
  "aj1_4" DOUBLE,
  "aj1_5" DOUBLE,
  "aj1_6" DOUBLE,
  "aw1_1" DOUBLE,
  "aw1_2" DOUBLE,
  "ay1_1" DOUBLE,
  "ay1_2" DOUBLE,
  "ay1_3" DOUBLE,
  "ay1_4" DOUBLE,
  "az1_1" DOUBLE,
  "az1_2" DOUBLE,
  "az1_3" DOUBLE,
  "az1_4" DOUBLE,
  "ed1_1" DOUBLE,
  "ed1_2" VARCHAR,
  "ed1_3" DOUBLE,
  "ed1_4" DOUBLE,
  "ga1_1" DOUBLE,
  "ga1_2" DOUBLE,
  "ga1_3" DOUBLE,
  "ga1_4" DOUBLE,
  "ga1_5" DOUBLE,
  "ga1_6" DOUBLE,
  "gf1_1" DOUBLE,
  "gf1_2" DOUBLE,
  "gf1_3" DOUBLE,
  "gf1_4" DOUBLE,
  "gf1_5" DOUBLE,
  "gf1_6" DOUBLE,
  "gf1_7" DOUBLE,
  "gf1_8" DOUBLE,
  "gf1_9" DOUBLE,
  "gf1_10" DOUBLE,
  "gf1_11" DOUBLE,
  "gf1_12" DOUBLE,
  "gf1_13" DOUBLE,
  "gj1_1" DOUBLE,
  "gj1_2" DOUBLE,
  "hl1_1" VARCHAR,
  "hl1_2" VARCHAR,
  "ia1_1" DOUBLE,
  "ia1_2" DOUBLE,
  "ia2_1" DOUBLE,
  "ia2_2" DOUBLE,
  "ia2_3" DOUBLE,
  "ka1_1" DOUBLE,
  "ka1_2" VARCHAR,
  "ka1_3" DOUBLE,
  "ka1_4" DOUBLE,
  "ma1_1" DOUBLE,
  "ma1_2" DOUBLE,
  "ma1_3" DOUBLE,
  "ma1_4" DOUBLE,
  "md1_1" DOUBLE,
  "md1_2" DOUBLE,
  "md1_3" DOUBLE,
  "md1_4" DOUBLE,
  "md1_5" DOUBLE,
  "md1_6" DOUBLE,
  "me1_1" DOUBLE,
  "me1_2" DOUBLE,
  "me1_3" DOUBLE,
  "mw1_1" DOUBLE,
  "mw1_2" DOUBLE,
  "oa1_1" DOUBLE,
  "oa1_2" DOUBLE,
  "oa1_3" DOUBLE,
  "oa1_4" DOUBLE,
  "oc1_1" DOUBLE,
  "oc1_2" DOUBLE,
  "sa1_1" DOUBLE,
  "sa1_2" DOUBLE,
  "ua1_1" VARCHAR,
  "ua1_2" DOUBLE,
  "ua1_3" DOUBLE,
  "ua1_4" DOUBLE,
  "ua1_5" DOUBLE,
  "ua1_6" DOUBLE
);

Dataset Lapalma

@kaggle.saurabhshahane_meteorological_data_set.dataset_lapalma

6.92 MB
373,063 rows
15 columns

CREATE TABLE dataset_lapalma (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "time" TIMESTAMP,
  "temp" DOUBLE,
  "wd" DOUBLE,
  "ws" DOUBLE,
  "atmos_pres" DOUBLE,
  "dew_point" DOUBLE,
  "rh" DOUBLE,
  "ceil_hgt" DOUBLE,
  "visibility" DOUBLE,
  "aa1_1" DOUBLE,
  "aa1_2" DOUBLE,
  "aa1_3" DOUBLE,
  "aa1_4" DOUBLE
);

Dataset Tfn

@kaggle.saurabhshahane_meteorological_data_set.dataset_tfn

1.08 MB
16,769 rows
16 columns

CREATE TABLE dataset_tfn (
  "year" TIMESTAMP,
  "month" BIGINT,
  "day" BIGINT,
  "temp_max" BIGINT,
  "temp_avg" BIGINT,
  "temp_min" BIGINT,
  "prec" BIGINT,
  "wd" BIGINT,
  "ws" BIGINT,
  "ws_max" BIGINT,
  "atmos_pres_avg" BIGINT,
  "atmos_pres_min" BIGINT,
  "atmos_pres_max" BIGINT,
  "rh" BIGINT,
  "ceil_hgt" BIGINT,
  "visibility" BIGINT
);