Name: RainfallSorocaba
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

RainfallSorocaba

Source

from http://www.inmet.gov.br/portal/index.php?r=estacoes/estacoesautomaticas

Atmospheric data from Automatic station in sorocaba-SP-BR. 2006-2018 It has all usuals temperature, umidity, pressure, preciptation...

Direto do InMET, dados completos da estação automatica de Sorocaba/SP

Dados crus, como vem do datalogger, nao esqueça de citar o InMET e eu! @yurisa2

Tables

Completo

@kaggle.yurisa2_rainfallsorocaba.completo

2.4 MB
4,332 rows
399 columns

CREATE TABLE completo (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "temp_ar_c" DOUBLE,
  "temp_ar_c_1" DOUBLE,
  "temp_ar_c_2" DOUBLE,
  "temp_ar_c_3" DOUBLE,
  "temp_ar_c_4" DOUBLE,
  "temp_ar_c_5" DOUBLE,
  "temp_ar_c_6" DOUBLE,
  "temp_ar_c_7" DOUBLE,
  "temp_ar_c_8" DOUBLE,
  "temp_ar_c_9" DOUBLE,
  "temp_ar_c_10" DOUBLE,
  "temp_ar_c_11" DOUBLE,
  "temp_ar_c_12" DOUBLE,
  "temp_ar_c_13" DOUBLE,
  "temp_ar_c_14" DOUBLE,
  "temp_ar_c_15" DOUBLE,
  "temp_ar_c_16" DOUBLE,
  "temp_ar_c_17" DOUBLE,
  "temp_ar_c_18" DOUBLE,
  "temp_ar_c_19" DOUBLE,
  "temp_ar_c_20" DOUBLE,
  "temp_ar_c_21" DOUBLE,
  "temp_ar_c_22" DOUBLE,
  "temp_ar_c_23" DOUBLE,
  "umid_tel_ar_percent" DOUBLE,
  "umid_tel_ar_percent_1" DOUBLE,
  "umid_tel_ar_percent_2" DOUBLE,
  "umid_tel_ar_percent_3" DOUBLE,
  "umid_tel_ar_percent_4" DOUBLE,
  "umid_tel_ar_percent_5" DOUBLE,
  "umid_tel_ar_percent_6" DOUBLE,
  "umid_tel_ar_percent_7" DOUBLE,
  "umid_tel_ar_percent_8" DOUBLE,
  "umid_tel_ar_percent_9" DOUBLE,
  "umid_tel_ar_percent_10" DOUBLE,
  "umid_tel_ar_percent_11" DOUBLE,
  "umid_tel_ar_percent_12" DOUBLE,
  "umid_tel_ar_percent_13" DOUBLE,
  "umid_tel_ar_percent_14" DOUBLE,
  "umid_tel_ar_percent_15" DOUBLE,
  "umid_tel_ar_percent_16" DOUBLE,
  "umid_tel_ar_percent_17" DOUBLE,
  "umid_tel_ar_percent_18" DOUBLE,
  "umid_tel_ar_percent_19" DOUBLE,
  "umid_tel_ar_percent_20" DOUBLE,
  "umid_tel_ar_percent_21" DOUBLE,
  "umid_tel_ar_percent_22" DOUBLE,
  "umid_tel_ar_percent_23" DOUBLE,
  "temp_pto_orvalho_c" DOUBLE,
  "temp_pto_orvalho_c_1" DOUBLE,
  "temp_pto_orvalho_c_2" DOUBLE,
  "temp_pto_orvalho_c_3" DOUBLE,
  "temp_pto_orvalho_c_4" DOUBLE,
  "temp_pto_orvalho_c_5" DOUBLE,
  "temp_pto_orvalho_c_6" DOUBLE,
  "temp_pto_orvalho_c_7" DOUBLE,
  "temp_pto_orvalho_c_8" DOUBLE,
  "temp_pto_orvalho_c_9" DOUBLE,
  "temp_pto_orvalho_c_10" DOUBLE,
  "temp_pto_orvalho_c_11" DOUBLE,
  "temp_pto_orvalho_c_12" DOUBLE,
  "temp_pto_orvalho_c_13" DOUBLE,
  "temp_pto_orvalho_c_14" DOUBLE,
  "temp_pto_orvalho_c_15" DOUBLE,
  "temp_pto_orvalho_c_16" DOUBLE,
  "temp_pto_orvalho_c_17" DOUBLE,
  "temp_pto_orvalho_c_18" DOUBLE,
  "temp_pto_orvalho_c_19" DOUBLE,
  "temp_pto_orvalho_c_20" DOUBLE,
  "temp_pto_orvalho_c_21" DOUBLE,
  "temp_pto_orvalho_c_22" DOUBLE,
  "temp_pto_orvalho_c_23" DOUBLE,
  "temp_max_c" DOUBLE,
  "temp_max_c_1" DOUBLE,
  "temp_max_c_2" DOUBLE,
  "temp_max_c_3" DOUBLE,
  "temp_max_c_4" DOUBLE,
  "temp_max_c_5" DOUBLE,
  "temp_max_c_6" DOUBLE,
  "temp_max_c_7" DOUBLE,
  "temp_max_c_8" DOUBLE,
  "temp_max_c_9" DOUBLE,
  "temp_max_c_10" DOUBLE,
  "temp_max_c_11" DOUBLE,
  "temp_max_c_12" DOUBLE,
  "temp_max_c_13" DOUBLE,
  "temp_max_c_14" DOUBLE,
  "temp_max_c_15" DOUBLE,
  "temp_max_c_16" DOUBLE,
  "temp_max_c_17" DOUBLE,
  "temp_max_c_18" DOUBLE,
  "temp_max_c_19" DOUBLE,
  "temp_max_c_20" DOUBLE,
  "temp_max_c_21" DOUBLE,
  "temp_max_c_22" DOUBLE,
  "temp_max_c_23" DOUBLE,
  "temp_min_c" DOUBLE,
  "temp_min_c_1" DOUBLE,
  "temp_min_c_2" DOUBLE
);

Dias Horas Full

@kaggle.yurisa2_rainfallsorocaba.dias_horas_full

2.73 MB
103,944 rows
20 columns

CREATE TABLE dias_horas_full (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "dia" TIMESTAMP,
  "hora" BIGINT,
  "temp_ar_c" DOUBLE,
  "umid_tel_ar_percent" DOUBLE,
  "temp_pto_orvalho_c" DOUBLE,
  "temp_max_c" DOUBLE,
  "temp_min_c" DOUBLE,
  "tem_max_pto_orvalho_c" DOUBLE,
  "tempo_min_pto_orvalho_c" DOUBLE,
  "umid_rel_ar_max_pctg" DOUBLE,
  "umid_rel_ar_min_pctg" DOUBLE,
  "pressao_hpa" DOUBLE,
  "vento_vel_ms" DOUBLE,
  "vento_dir_graus" DOUBLE,
  "radiacao_global_kjm2" DOUBLE,
  "precipitacao_mm" DOUBLE,
  "vento_raj_max_ms" DOUBLE,
  "pressao_atmosferica_max_hpa" DOUBLE,
  "pressao_atmosferica_min_hpa" DOUBLE
);