Dataset: Meteorological Data

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

5.97 MB
451628 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

11.52 MB
677963 rows
15 columns


CREATE TABLE dataset_gc (
  "unnamed_0" BIGINT,
  "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

833.3 KB
38689 rows
15 columns


CREATE TABLE dataset_gomera (
  "unnamed_0" BIGINT,
  "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.68 MB
253836 rows
15 columns


CREATE TABLE dataset_hierro (
  "unnamed_0" BIGINT,
  "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.11 MB
489455 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.6 MB
373063 rows
15 columns


CREATE TABLE dataset_lapalma (
  "unnamed_0" BIGINT,
  "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.03 MB
16769 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
);