Name: Brazilian Dams And Brumadinho Households
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

About this Dataset

Brazilian Dams And Brumadinho Households

Context

This data set relates to every Brazilian dam that holds some type of ore.

After Brumadinho's dam disruption on January 25 of 2019, I came up with the idea to help Brazilians to have a better and more clear view about the risks that we face when we live close to some dam like Brumadinho.

Content

This database is an open data provided by Brazilian organs like ANM (National Agency of Mining) and IBGE (Brazilian Institute of Geography and Statistics).
ANM database has all the latest dams location, latitude, longitude, risk of disruption and risk of damage.
IBGE database has some households locations from the 2017 Brazilian census, which can be used to check how close a household is to a dam.

Acknowledgements

This database was cleaned and prepared previously with some of my colleagues at Cappra Data Science community. and at the DataScience4Industry community.

Inspiration

Would you like to contribute with a data4good analysis in this data set and help Brazilians to understand what risks can be around them and save lifes? I hope so... so join us in this good cause journey!

Tables

Belohorizonte Meteorological Daliydata From 2015until2 Ab2a1d77

@kaggle.edumagalhaes_brazilian_dams_and_brumadinho_households.belohorizonte_meteorological_daliydata_from_2015until2_ab2a1d77

38.81 kB
2,984 rows
11 columns

CREATE TABLE belohorizonte_meteorological_daliydata_from_2015until2_ab2a1d77 (
  "weather_station" BIGINT,
  "date" VARCHAR,
  "hour" VARCHAR,
  "preciptation" DOUBLE,
  "max_temperature" DOUBLE,
  "min_temperature" DOUBLE,
  "insolacao" DOUBLE,
  "evaporation" DOUBLE,
  "average_temperature" DOUBLE,
  "average_relative_humidity" DOUBLE,
  "average_wind_speed" DOUBLE
);

Belohorizonte Meteorological Data From 2015until2019

@kaggle.edumagalhaes_brazilian_dams_and_brumadinho_households.belohorizonte_meteorological_data_from_2015until2019

48.3 kB
4,476 rows
10 columns

CREATE TABLE belohorizonte_meteorological_data_from_2015until2019 (
  "weather_station" BIGINT,
  "date" VARCHAR,
  "hour" VARCHAR,
  "dry_bulb_temperature" DOUBLE,
  "wet_bulb_temperature" DOUBLE,
  "relative_humidity" DOUBLE,
  "atmospheric_pressure_inthe_station" DOUBLE,
  "wind_direction" DOUBLE,
  "wind_speed" DOUBLE,
  "cloudiness" DOUBLE
);

Database Versao Latlongdecimal Fonteanm 23–01–2019

@kaggle.edumagalhaes_brazilian_dams_and_brumadinho_households.database_versao_latlongdecimal_fonteanm_23_01_2019

53.78 kB
714 rows
15 columns

CREATE TABLE database_versao_latlongdecimal_fonteanm_23_01_2019 (
  "nome_barragem_mineracao" VARCHAR,
  "nome_do_empreendedor" VARCHAR,
  "cpf_cnpj" VARCHAR,
  "posicionamento" VARCHAR,
  "uf" VARCHAR,
  "municipio" VARCHAR,
  "minerio_principal" VARCHAR,
  "altura_atual_metros" VARCHAR,
  "volume_atual_m3" VARCHAR,
  "categoria_de_risco" VARCHAR,
  "dano_potencial_associado" VARCHAR,
  "classe" VARCHAR,
  "inserida_na_pnsb" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Ibge 3109006 Censo2017 Brumadinho Domicilios

@kaggle.edumagalhaes_brazilian_dams_and_brumadinho_households.ibge_3109006_censo2017_brumadinho_domicilios

31.31 kB
443 rows
26 columns

CREATE TABLE ibge_3109006_censo2017_brumadinho_domicilios (
  "cod_uf" BIGINT,
  "cod_municipio" BIGINT,
  "cod_distrito" BIGINT,
  "cod_subdistrito" BIGINT,
  "situacao" BIGINT,
  "nom_tipo_seglogr" VARCHAR,
  "nom_titulo_seglogr" VARCHAR,
  "nom_seglogr" VARCHAR,
  "num_endereco" DOUBLE,
  "dsc_modificador" VARCHAR,
  "nom_comp_elem1" VARCHAR,
  "val_comp_elem1" VARCHAR,
  "nom_comp_elem2" VARCHAR,
  "val_comp_elem2" VARCHAR,
  "nom_comp_elem3" VARCHAR,
  "val_comp_elem3" VARCHAR,
  "nom_comp_elem4" VARCHAR,
  "val_comp_elem4" VARCHAR,
  "nom_comp_elem5" VARCHAR,
  "val_comp_elem5" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "altitude" DOUBLE,
  "dsc_localidade" VARCHAR,
  "cod_especie" BIGINT,
  "cep" BIGINT
);

Ibge 3140159 Censo2017 Mariocampos Domicilios

@kaggle.edumagalhaes_brazilian_dams_and_brumadinho_households.ibge_3140159_censo2017_mariocampos_domicilios

21.89 kB
140 rows
26 columns

CREATE TABLE ibge_3140159_censo2017_mariocampos_domicilios (
  "cod_uf" BIGINT,
  "cod_municipio" BIGINT,
  "cod_distrito" BIGINT,
  "cod_subdistrito" BIGINT,
  "situacao" BIGINT,
  "nom_tipo_seglogr" VARCHAR,
  "nom_titulo_seglogr" VARCHAR,
  "nom_seglogr" VARCHAR,
  "num_endereco" DOUBLE,
  "dsc_modificador" VARCHAR,
  "nom_comp_elem1" VARCHAR,
  "val_comp_elem1" VARCHAR,
  "nom_comp_elem2" VARCHAR,
  "val_comp_elem2" VARCHAR,
  "nom_comp_elem3" VARCHAR,
  "val_comp_elem3" VARCHAR,
  "nom_comp_elem4" VARCHAR,
  "val_comp_elem4" VARCHAR,
  "nom_comp_elem5" VARCHAR,
  "val_comp_elem5" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "altitude" DOUBLE,
  "dsc_localidade" VARCHAR,
  "cod_especie" BIGINT,
  "cep" BIGINT
);

Ibge 3152006 Censo2017 Pompeu Domicilios

@kaggle.edumagalhaes_brazilian_dams_and_brumadinho_households.ibge_3152006_censo2017_pompeu_domicilios

40.64 kB
815 rows
26 columns

CREATE TABLE ibge_3152006_censo2017_pompeu_domicilios (
  "cod_uf" BIGINT,
  "cod_municipio" BIGINT,
  "cod_distrito" BIGINT,
  "cod_subdistrito" BIGINT,
  "situacao" BIGINT,
  "nom_tipo_seglogr" VARCHAR,
  "nom_titulo_seglogr" VARCHAR,
  "nom_seglogr" VARCHAR,
  "num_endereco" DOUBLE,
  "dsc_modificador" VARCHAR,
  "nom_comp_elem1" VARCHAR,
  "val_comp_elem1" VARCHAR,
  "nom_comp_elem2" VARCHAR,
  "val_comp_elem2" VARCHAR,
  "nom_comp_elem3" VARCHAR,
  "val_comp_elem3" VARCHAR,
  "nom_comp_elem4" VARCHAR,
  "val_comp_elem4" VARCHAR,
  "nom_comp_elem5" VARCHAR,
  "val_comp_elem5" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "altitude" DOUBLE,
  "dsc_localidade" VARCHAR,
  "cod_especie" BIGINT,
  "cep" BIGINT
);

Ibge 3162922 Censo2017 Sao Joaquimdasbicas Domicilios

@kaggle.edumagalhaes_brazilian_dams_and_brumadinho_households.ibge_3162922_censo2017_sao_joaquimdasbicas_domicilios

21.39 kB
120 rows
26 columns

CREATE TABLE ibge_3162922_censo2017_sao_joaquimdasbicas_domicilios (
  "cod_uf" BIGINT,
  "cod_municipio" BIGINT,
  "cod_distrito" BIGINT,
  "cod_subdistrito" BIGINT,
  "situacao" BIGINT,
  "nom_tipo_seglogr" VARCHAR,
  "nom_titulo_seglogr" VARCHAR,
  "nom_seglogr" VARCHAR,
  "num_endereco" DOUBLE,
  "dsc_modificador" VARCHAR,
  "nom_comp_elem1" VARCHAR,
  "val_comp_elem1" VARCHAR,
  "nom_comp_elem2" VARCHAR,
  "val_comp_elem2" VARCHAR,
  "nom_comp_elem3" VARCHAR,
  "val_comp_elem3" VARCHAR,
  "nom_comp_elem4" VARCHAR,
  "val_comp_elem4" VARCHAR,
  "nom_comp_elem5" VARCHAR,
  "val_comp_elem5" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "altitude" DOUBLE,
  "dsc_localidade" VARCHAR,
  "cod_especie" BIGINT,
  "cep" BIGINT
);