Name: Brazil Weather, Conventional Stations (1961-2019)
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

Brazil Weather, Conventional Stations (1961-2019)

Context

Meteorological data observed in conventional meteorological stations of the National Institute of Meteorology - INMET distributed in the Brazilian territory from 1961 to 2019.

Content

Estacao - Weather station code
Data - Date (dd/MM/YYYY)
Hora - Hour (%H%M)
Precipitacao - Precipitation (mm)
TempBulboSeco - Dry bulb temperature (ºC)
TempBulboUmido - Wet bulb temperature(ºC)
TempMaxima - Maximum temperature (ºC)
TempMinima - Minimum temperature (ºC)
UmidadeRelativa - Relative humidity (%)
PressaoAtmEstacao - Station Atmospheric Pressure (mbar)
PressaoAtmMar - Atmospheric pressure at sea level (mbar)
DirecaoVento - Wind Direction (tabela)
VelocidadeVento - Wind speed(m/s)
Insolacao - Insolation (hs)
Nebulosidade - Cloudiness (tenths)
Evaporacao Piche - Piche Evaporation (mm)
Temp Comp Media - Average Compensated Temperature (ºC)
Umidade Relativa Media - Average Relative Humidity (%)
Velocidade do Vento Media - Average Wind Speed (mps)

Tables

Conventional Weather Stations Inmet Brazil 1961–2019

@kaggle.saraivaufc_conventional_weather_stations_brazil.conventional_weather_stations_inmet_brazil_1961_2019

140.73 MB
12251335 rows
20 columns


CREATE TABLE conventional_weather_stations_inmet_brazil_1961_2019 (
  "estacao" BIGINT,
  "data" TIMESTAMP,
  "hora" BIGINT,
  "precipitacao" DOUBLE,
  "tempbulboseco" DOUBLE,
  "tempbulboumido" DOUBLE,
  "tempmaxima" DOUBLE,
  "tempminima" DOUBLE,
  "umidaderelativa" DOUBLE,
  "pressaoatmestacao" DOUBLE,
  "pressaoatmmar" DOUBLE,
  "direcaovento" DOUBLE,
  "velocidadevento" DOUBLE,
  "insolacao" DOUBLE,
  "nebulosidade" DOUBLE,
  "evaporacao_piche" DOUBLE,
  "temp_comp_media" DOUBLE,
  "umidade_relativa_media" DOUBLE,
  "velocidade_do_vento_media" DOUBLE,
  "unnamed_19" VARCHAR
);

Weather Stations Codes

@kaggle.saraivaufc_conventional_weather_stations_brazil.weather_stations_codes

17.07 KB
265 rows
7 columns


CREATE TABLE weather_stations_codes (
  "nome" VARCHAR,
  "c_digo" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "altitude" DOUBLE,
  "status_da_opera_o" VARCHAR,
  "n__nicio_da_opera_o" TIMESTAMP
);

Wind Directions Codes

@kaggle.saraivaufc_conventional_weather_stations_brazil.wind_directions_codes

3.05 KB
37 rows
3 columns


CREATE TABLE wind_directions_codes (
  "id" BIGINT,
  "descri_o" VARCHAR,
  "s_mbolo" VARCHAR
);