#rm(list=ls()) ## Diret?rio: #setwd(“C:/Users/eveli/OneDrive/UFMT/Extens?o/Laborat?rio2020/Renato_arquivos”)
#Ano UF Cod_UF tx_latrc raz_2020 raz_1040 tx_pres gini_ibge perc_jov (1) perc_hom pbf densidade urbana (1) densidade urbana (2) taxa de casamentos perc_jov (2) Taxa de desligamentos
# pacotes:
require(DT) #para a fun??o datatable## Loading required package: DTrequire(tidyverse)## Loading required package: tidyverse## -- Attaching packages --------------------------------------- tidyverse 1.3.0 --## v ggplot2 3.3.2 v purrr 0.3.4
## v tibble 3.0.3 v dplyr 1.0.2
## v tidyr 1.1.2 v stringr 1.4.0
## v readr 1.3.1 v forcats 0.5.0## -- Conflicts ------------------------------------------ tidyverse_conflicts() --
## x dplyr::filter() masks stats::filter()
## x dplyr::lag() masks stats::lag()#devtools::install_github("tidymodels/broom")
#install.packages("mice")
require(mice)## Loading required package: mice## Warning: package 'mice' was built under R version 4.0.3##
## Attaching package: 'mice'## The following objects are masked from 'package:base':
##
## cbind, rbind#install.packages("broom")
#install.packages("broom.mixed")
require(broom.mixed)## Loading required package: broom.mixed## Warning: package 'broom.mixed' was built under R version 4.0.3## Registered S3 method overwritten by 'broom.mixed':
## method from
## tidy.gamlss broomrequire(broom)## Loading required package: broomrequire(lme4)## Loading required package: lme4## Loading required package: Matrix##
## Attaching package: 'Matrix'## The following objects are masked from 'package:tidyr':
##
## expand, pack, unpackrequire(readxl)## Loading required package: readxl## Warning: package 'readxl' was built under R version 4.0.3require(tidyr)#####Importar Conjunto de Dados Planilha de dados
dados=read_excel("dados_renato.xlsx",sheet=1)
names(dados)=c("Ano","UF","Cod_UF","tx_latrc","tx_pres","gini_ibge","perc_jov_15_24","perc_hom","pbf","densidade_urbana1","densidade_urbana2","taxa_casamentos","Taxa_desligamentos","raz_2020","raz_1040")
datatable(dados,options = list(pageLength = 5))Verificamos que há um padrão de missing - o missing não é aleatorio! tx_latrc => 16 missing tx_pres => 2 missing gini_ibge => 27 missing perc_jov_15_24 => 27 missing perc_hom => 27 missing densidade_urbana2 => 27 missing raz_2020 => 54 missing raz_1040 => 54 missing
Porém, pensando somente nas variáveis que vão entrar no modelo: tx_pres + perc_jov_15_24 + densidade_urbana1 + raz_1040, podemos contornar o problema completando os missing? -> verificar sobre
summary(dados)## Ano UF Cod_UF tx_latrc
## Min. :2005 Length:297 Min. : 1 Min. :0.03206
## 1st Qu.:2007 Class :character 1st Qu.: 7 1st Qu.:0.64466
## Median :2010 Mode :character Median :14 Median :0.94540
## Mean :2010 Mean :14 Mean :1.09195
## 3rd Qu.:2013 3rd Qu.:21 3rd Qu.:1.35786
## Max. :2015 Max. :27 Max. :5.42341
## NA's :16
## tx_pres gini_ibge perc_jov_15_24 perc_hom
## Min. : 51.71 Min. :0.4190 Min. : 9.711 Min. :46.80
## 1st Qu.:156.22 1st Qu.:0.4783 1st Qu.:16.774 1st Qu.:48.40
## Median :228.64 Median :0.5025 Median :18.242 Median :49.00
## Mean :252.51 Mean :0.5055 Mean :18.076 Mean :49.06
## 3rd Qu.:337.17 3rd Qu.:0.5272 3rd Qu.:19.500 3rd Qu.:49.80
## Max. :634.53 Max. :0.6150 Max. :23.500 Max. :52.40
## NA's :2 NA's :27 NA's :27 NA's :27
## pbf densidade_urbana1 densidade_urbana2 taxa_casamentos
## Min. : 22.04 Min. : 34.29 Min. : 26.95 Min. :0.001847
## 1st Qu.: 79.91 1st Qu.: 45.06 1st Qu.: 38.80 1st Qu.:0.003916
## Median :137.69 Median : 63.79 Median : 53.12 Median :0.004859
## Mean :159.97 Mean : 73.50 Mean : 57.94 Mean :0.004876
## 3rd Qu.:231.84 3rd Qu.: 97.48 3rd Qu.: 75.40 3rd Qu.:0.005605
## Max. :423.79 Max. :160.29 Max. :131.26 Max. :0.008422
## NA's :27
## Taxa_desligamentos raz_2020 raz_1040
## Min. :0.01196 Min. : 9.034 Min. : 8.349
## 1st Qu.:0.03625 1st Qu.:14.177 1st Qu.:13.053
## Median :0.05304 Median :16.047 Median :14.912
## Mean :0.06777 Mean :16.825 Mean :15.515
## 3rd Qu.:0.09978 3rd Qu.:18.717 3rd Qu.:17.426
## Max. :0.17911 Max. :32.329 Max. :27.742
## NA's :54 NA's :54https://tidyr.tidyverse.org/reference/pivot_wider.html
dados_wide = dados %>%
pivot_wider(names_from = Ano, values_from =c(tx_latrc,tx_pres,gini_ibge,perc_jov_15_24,perc_hom,pbf,densidade_urbana1,densidade_urbana2,taxa_casamentos,Taxa_desligamentos,raz_2020,raz_1040))N=10
imp <- mice(dados_wide, m = N, print = FALSE)## Warning: Number of logged events: 569imp## Class: mids
## Number of multiple imputations: 10
## Imputation methods:
## UF Cod_UF tx_latrc_2005
## "" "" ""
## tx_latrc_2006 tx_latrc_2007 tx_latrc_2008
## "pmm" "pmm" ""
## tx_latrc_2009 tx_latrc_2010 tx_latrc_2011
## "" "" "pmm"
## tx_latrc_2012 tx_latrc_2013 tx_latrc_2014
## "" "" ""
## tx_latrc_2015 tx_pres_2005 tx_pres_2006
## "" "" ""
## tx_pres_2007 tx_pres_2008 tx_pres_2009
## "" "" ""
## tx_pres_2010 tx_pres_2011 tx_pres_2012
## "" "" "pmm"
## tx_pres_2013 tx_pres_2014 tx_pres_2015
## "" "pmm" ""
## gini_ibge_2005 gini_ibge_2006 gini_ibge_2007
## "" "" ""
## gini_ibge_2008 gini_ibge_2009 gini_ibge_2010
## "" "" ""
## gini_ibge_2011 gini_ibge_2012 gini_ibge_2013
## "" "" ""
## gini_ibge_2014 gini_ibge_2015 perc_jov_15_24_2005
## "" "" ""
## perc_jov_15_24_2006 perc_jov_15_24_2007 perc_jov_15_24_2008
## "" "" ""
## perc_jov_15_24_2009 perc_jov_15_24_2010 perc_jov_15_24_2011
## "" "" ""
## perc_jov_15_24_2012 perc_jov_15_24_2013 perc_jov_15_24_2014
## "" "" ""
## perc_jov_15_24_2015 perc_hom_2005 perc_hom_2006
## "" "" ""
## perc_hom_2007 perc_hom_2008 perc_hom_2009
## "" "" ""
## perc_hom_2010 perc_hom_2011 perc_hom_2012
## "" "" ""
## perc_hom_2013 perc_hom_2014 perc_hom_2015
## "" "" ""
## pbf_2005 pbf_2006 pbf_2007
## "" "" ""
## pbf_2008 pbf_2009 pbf_2010
## "" "" ""
## pbf_2011 pbf_2012 pbf_2013
## "" "" ""
## pbf_2014 pbf_2015 densidade_urbana1_2005
## "" "" ""
## densidade_urbana1_2006 densidade_urbana1_2007 densidade_urbana1_2008
## "" "" ""
## densidade_urbana1_2009 densidade_urbana1_2010 densidade_urbana1_2011
## "" "" ""
## densidade_urbana1_2012 densidade_urbana1_2013 densidade_urbana1_2014
## "" "" ""
## densidade_urbana1_2015 densidade_urbana2_2005 densidade_urbana2_2006
## "" "" ""
## densidade_urbana2_2007 densidade_urbana2_2008 densidade_urbana2_2009
## "" "" ""
## densidade_urbana2_2010 densidade_urbana2_2011 densidade_urbana2_2012
## "" "" ""
## densidade_urbana2_2013 densidade_urbana2_2014 densidade_urbana2_2015
## "" "" ""
## taxa_casamentos_2005 taxa_casamentos_2006 taxa_casamentos_2007
## "" "" ""
## taxa_casamentos_2008 taxa_casamentos_2009 taxa_casamentos_2010
## "" "" ""
## taxa_casamentos_2011 taxa_casamentos_2012 taxa_casamentos_2013
## "" "" ""
## taxa_casamentos_2014 taxa_casamentos_2015 Taxa_desligamentos_2005
## "" "" ""
## Taxa_desligamentos_2006 Taxa_desligamentos_2007 Taxa_desligamentos_2008
## "" "" ""
## Taxa_desligamentos_2009 Taxa_desligamentos_2010 Taxa_desligamentos_2011
## "" "" ""
## Taxa_desligamentos_2012 Taxa_desligamentos_2013 Taxa_desligamentos_2014
## "" "" ""
## Taxa_desligamentos_2015 raz_2020_2005 raz_2020_2006
## "" "" ""
## raz_2020_2007 raz_2020_2008 raz_2020_2009
## "" "" ""
## raz_2020_2010 raz_2020_2011 raz_2020_2012
## "" "" ""
## raz_2020_2013 raz_2020_2014 raz_2020_2015
## "" "" ""
## raz_1040_2005 raz_1040_2006 raz_1040_2007
## "" "" ""
## raz_1040_2008 raz_1040_2009 raz_1040_2010
## "" "" ""
## raz_1040_2011 raz_1040_2012 raz_1040_2013
## "" "" ""
## raz_1040_2014 raz_1040_2015
## "" ""
## PredictorMatrix:
## UF Cod_UF tx_latrc_2005 tx_latrc_2006 tx_latrc_2007 tx_latrc_2008
## UF 0 1 1 1 1 1
## Cod_UF 0 0 1 1 1 1
## tx_latrc_2005 0 1 0 1 1 1
## tx_latrc_2006 0 1 1 0 1 1
## tx_latrc_2007 0 1 1 1 0 1
## tx_latrc_2008 0 1 1 1 1 0
## tx_latrc_2009 tx_latrc_2010 tx_latrc_2011 tx_latrc_2012
## UF 1 1 1 1
## Cod_UF 1 1 1 1
## tx_latrc_2005 1 1 1 1
## tx_latrc_2006 1 1 1 1
## tx_latrc_2007 1 1 1 1
## tx_latrc_2008 1 1 1 1
## tx_latrc_2013 tx_latrc_2014 tx_latrc_2015 tx_pres_2005
## UF 1 1 1 1
## Cod_UF 1 1 1 1
## tx_latrc_2005 1 1 1 1
## tx_latrc_2006 1 1 1 1
## tx_latrc_2007 1 1 1 1
## tx_latrc_2008 1 1 1 1
## tx_pres_2006 tx_pres_2007 tx_pres_2008 tx_pres_2009 tx_pres_2010
## UF 1 1 1 1 1
## Cod_UF 1 1 1 1 1
## tx_latrc_2005 1 1 1 1 1
## tx_latrc_2006 1 1 1 1 1
## tx_latrc_2007 1 1 1 1 1
## tx_latrc_2008 1 1 1 1 1
## tx_pres_2011 tx_pres_2012 tx_pres_2013 tx_pres_2014 tx_pres_2015
## UF 1 1 1 1 1
## Cod_UF 1 1 1 1 1
## tx_latrc_2005 1 1 1 1 1
## tx_latrc_2006 1 1 1 1 1
## tx_latrc_2007 1 1 1 1 1
## tx_latrc_2008 1 1 1 1 1
## gini_ibge_2005 gini_ibge_2006 gini_ibge_2007 gini_ibge_2008
## UF 1 1 1 1
## Cod_UF 1 1 1 1
## tx_latrc_2005 1 1 1 1
## tx_latrc_2006 1 1 1 1
## tx_latrc_2007 1 1 1 1
## tx_latrc_2008 1 1 1 1
## gini_ibge_2009 gini_ibge_2010 gini_ibge_2011 gini_ibge_2012
## UF 1 0 1 1
## Cod_UF 1 0 1 1
## tx_latrc_2005 1 0 1 1
## tx_latrc_2006 1 0 1 1
## tx_latrc_2007 1 0 1 1
## tx_latrc_2008 1 0 1 1
## gini_ibge_2013 gini_ibge_2014 gini_ibge_2015 perc_jov_15_24_2005
## UF 1 1 1 1
## Cod_UF 1 1 1 1
## tx_latrc_2005 1 1 1 1
## tx_latrc_2006 1 1 1 1
## tx_latrc_2007 1 1 1 1
## tx_latrc_2008 1 1 1 1
## perc_jov_15_24_2006 perc_jov_15_24_2007 perc_jov_15_24_2008
## UF 1 1 1
## Cod_UF 1 1 1
## tx_latrc_2005 1 1 1
## tx_latrc_2006 1 1 1
## tx_latrc_2007 1 1 1
## tx_latrc_2008 1 1 1
## perc_jov_15_24_2009 perc_jov_15_24_2010 perc_jov_15_24_2011
## UF 1 0 1
## Cod_UF 1 0 1
## tx_latrc_2005 1 0 1
## tx_latrc_2006 1 0 1
## tx_latrc_2007 1 0 1
## tx_latrc_2008 1 0 1
## perc_jov_15_24_2012 perc_jov_15_24_2013 perc_jov_15_24_2014
## UF 1 1 1
## Cod_UF 1 1 1
## tx_latrc_2005 1 1 1
## tx_latrc_2006 1 1 1
## tx_latrc_2007 1 1 1
## tx_latrc_2008 1 1 1
## perc_jov_15_24_2015 perc_hom_2005 perc_hom_2006 perc_hom_2007
## UF 1 1 1 1
## Cod_UF 1 1 1 1
## tx_latrc_2005 1 1 1 1
## tx_latrc_2006 1 1 1 1
## tx_latrc_2007 1 1 1 1
## tx_latrc_2008 1 1 1 1
## perc_hom_2008 perc_hom_2009 perc_hom_2010 perc_hom_2011
## UF 1 1 0 1
## Cod_UF 1 1 0 1
## tx_latrc_2005 1 1 0 1
## tx_latrc_2006 1 1 0 1
## tx_latrc_2007 1 1 0 1
## tx_latrc_2008 1 1 0 1
## perc_hom_2012 perc_hom_2013 perc_hom_2014 perc_hom_2015 pbf_2005
## UF 1 1 1 1 1
## Cod_UF 1 1 1 1 1
## tx_latrc_2005 1 1 1 1 1
## tx_latrc_2006 1 1 1 1 1
## tx_latrc_2007 1 1 1 1 1
## tx_latrc_2008 1 1 1 1 1
## pbf_2006 pbf_2007 pbf_2008 pbf_2009 pbf_2010 pbf_2011 pbf_2012
## UF 1 1 1 1 1 1 1
## Cod_UF 1 1 1 1 1 1 1
## tx_latrc_2005 1 1 1 1 1 1 1
## tx_latrc_2006 1 1 1 1 1 1 1
## tx_latrc_2007 1 1 1 1 1 1 1
## tx_latrc_2008 1 1 1 1 1 1 1
## pbf_2013 pbf_2014 pbf_2015 densidade_urbana1_2005
## UF 1 1 0 1
## Cod_UF 1 1 0 1
## tx_latrc_2005 1 1 0 1
## tx_latrc_2006 1 1 0 1
## tx_latrc_2007 1 1 0 1
## tx_latrc_2008 1 1 0 1
## densidade_urbana1_2006 densidade_urbana1_2007
## UF 0 1
## Cod_UF 0 1
## tx_latrc_2005 0 1
## tx_latrc_2006 0 1
## tx_latrc_2007 0 1
## tx_latrc_2008 0 1
## densidade_urbana1_2008 densidade_urbana1_2009
## UF 0 0
## Cod_UF 0 0
## tx_latrc_2005 0 0
## tx_latrc_2006 0 0
## tx_latrc_2007 0 0
## tx_latrc_2008 0 0
## densidade_urbana1_2010 densidade_urbana1_2011
## UF 1 0
## Cod_UF 1 0
## tx_latrc_2005 1 0
## tx_latrc_2006 1 0
## tx_latrc_2007 1 0
## tx_latrc_2008 1 0
## densidade_urbana1_2012 densidade_urbana1_2013
## UF 0 1
## Cod_UF 0 1
## tx_latrc_2005 0 1
## tx_latrc_2006 0 1
## tx_latrc_2007 0 1
## tx_latrc_2008 0 1
## densidade_urbana1_2014 densidade_urbana1_2015
## UF 0 1
## Cod_UF 0 1
## tx_latrc_2005 0 1
## tx_latrc_2006 0 1
## tx_latrc_2007 0 1
## tx_latrc_2008 0 1
## densidade_urbana2_2005 densidade_urbana2_2006
## UF 1 0
## Cod_UF 1 0
## tx_latrc_2005 1 0
## tx_latrc_2006 1 0
## tx_latrc_2007 1 0
## tx_latrc_2008 1 0
## densidade_urbana2_2007 densidade_urbana2_2008
## UF 1 1
## Cod_UF 1 1
## tx_latrc_2005 1 1
## tx_latrc_2006 1 1
## tx_latrc_2007 1 1
## tx_latrc_2008 1 1
## densidade_urbana2_2009 densidade_urbana2_2010
## UF 0 0
## Cod_UF 0 0
## tx_latrc_2005 0 0
## tx_latrc_2006 0 0
## tx_latrc_2007 0 0
## tx_latrc_2008 0 0
## densidade_urbana2_2011 densidade_urbana2_2012
## UF 1 1
## Cod_UF 1 1
## tx_latrc_2005 1 1
## tx_latrc_2006 1 1
## tx_latrc_2007 1 1
## tx_latrc_2008 1 1
## densidade_urbana2_2013 densidade_urbana2_2014
## UF 1 1
## Cod_UF 1 1
## tx_latrc_2005 1 1
## tx_latrc_2006 1 1
## tx_latrc_2007 1 1
## tx_latrc_2008 1 1
## densidade_urbana2_2015 taxa_casamentos_2005 taxa_casamentos_2006
## UF 1 1 1
## Cod_UF 1 1 1
## tx_latrc_2005 1 1 1
## tx_latrc_2006 1 1 1
## tx_latrc_2007 1 1 1
## tx_latrc_2008 1 1 1
## taxa_casamentos_2007 taxa_casamentos_2008 taxa_casamentos_2009
## UF 1 1 1
## Cod_UF 1 1 1
## tx_latrc_2005 1 1 1
## tx_latrc_2006 1 1 1
## tx_latrc_2007 1 1 1
## tx_latrc_2008 1 1 1
## taxa_casamentos_2010 taxa_casamentos_2011 taxa_casamentos_2012
## UF 1 1 1
## Cod_UF 1 1 1
## tx_latrc_2005 1 1 1
## tx_latrc_2006 1 1 1
## tx_latrc_2007 1 1 1
## tx_latrc_2008 1 1 1
## taxa_casamentos_2013 taxa_casamentos_2014 taxa_casamentos_2015
## UF 1 1 1
## Cod_UF 1 1 1
## tx_latrc_2005 1 1 1
## tx_latrc_2006 1 1 1
## tx_latrc_2007 1 1 1
## tx_latrc_2008 1 1 1
## Taxa_desligamentos_2005 Taxa_desligamentos_2006
## UF 1 1
## Cod_UF 1 1
## tx_latrc_2005 1 1
## tx_latrc_2006 1 1
## tx_latrc_2007 1 1
## tx_latrc_2008 1 1
## Taxa_desligamentos_2007 Taxa_desligamentos_2008
## UF 1 1
## Cod_UF 1 1
## tx_latrc_2005 1 1
## tx_latrc_2006 1 1
## tx_latrc_2007 1 1
## tx_latrc_2008 1 1
## Taxa_desligamentos_2009 Taxa_desligamentos_2010
## UF 1 1
## Cod_UF 1 1
## tx_latrc_2005 1 1
## tx_latrc_2006 1 1
## tx_latrc_2007 1 1
## tx_latrc_2008 1 1
## Taxa_desligamentos_2011 Taxa_desligamentos_2012
## UF 0 1
## Cod_UF 0 1
## tx_latrc_2005 0 1
## tx_latrc_2006 0 1
## tx_latrc_2007 0 1
## tx_latrc_2008 0 1
## Taxa_desligamentos_2013 Taxa_desligamentos_2014
## UF 1 1
## Cod_UF 1 1
## tx_latrc_2005 1 1
## tx_latrc_2006 1 1
## tx_latrc_2007 1 1
## tx_latrc_2008 1 1
## Taxa_desligamentos_2015 raz_2020_2005 raz_2020_2006 raz_2020_2007
## UF 1 1 1 1
## Cod_UF 1 1 1 1
## tx_latrc_2005 1 1 1 1
## tx_latrc_2006 1 1 1 1
## tx_latrc_2007 1 1 1 1
## tx_latrc_2008 1 1 1 1
## raz_2020_2008 raz_2020_2009 raz_2020_2010 raz_2020_2011
## UF 1 1 0 1
## Cod_UF 1 1 0 1
## tx_latrc_2005 1 1 0 1
## tx_latrc_2006 1 1 0 1
## tx_latrc_2007 1 1 0 1
## tx_latrc_2008 1 1 0 1
## raz_2020_2012 raz_2020_2013 raz_2020_2014 raz_2020_2015
## UF 1 1 1 0
## Cod_UF 1 1 1 0
## tx_latrc_2005 1 1 1 0
## tx_latrc_2006 1 1 1 0
## tx_latrc_2007 1 1 1 0
## tx_latrc_2008 1 1 1 0
## raz_1040_2005 raz_1040_2006 raz_1040_2007 raz_1040_2008
## UF 1 1 1 1
## Cod_UF 1 1 1 1
## tx_latrc_2005 1 1 1 1
## tx_latrc_2006 1 1 1 1
## tx_latrc_2007 1 1 1 1
## tx_latrc_2008 1 1 1 1
## raz_1040_2009 raz_1040_2010 raz_1040_2011 raz_1040_2012
## UF 1 0 1 1
## Cod_UF 1 0 1 1
## tx_latrc_2005 1 0 1 1
## tx_latrc_2006 1 0 1 1
## tx_latrc_2007 1 0 1 1
## tx_latrc_2008 1 0 1 1
## raz_1040_2013 raz_1040_2014 raz_1040_2015
## UF 1 1 0
## Cod_UF 1 1 0
## tx_latrc_2005 1 1 0
## tx_latrc_2006 1 1 0
## tx_latrc_2007 1 1 0
## tx_latrc_2008 1 1 0
## Number of logged events: 569
## it im dep meth out
## 1 0 0 constant UF
## 2 0 0 constant gini_ibge_2010
## 3 0 0 constant perc_jov_15_24_2010
## 4 0 0 constant perc_hom_2010
## 5 0 0 constant densidade_urbana2_2010
## 6 0 0 constant raz_2020_2010imp_comp <- mice::complete(imp, "all")
imp_comp[[1]]## UF Cod_UF tx_latrc_2005 tx_latrc_2006 tx_latrc_2007
## 1 Rondônia 1 1.3032763 1.6000850 1.5133214
## 2 Acre 2 0.1493126 0.4351646 0.1525821
## 3 Amazonas 3 0.6187487 0.5441658 0.7448928
## 4 Roraima 4 0.2555473 1.2952400 0.2527007
## 5 Pará 5 2.0227855 0.4329898 3.4250584
## 6 Amapá 6 0.6727359 0.4351646 0.8513377
## 7 Tocantins 7 0.9190275 0.3188847 0.9649195
## 8 Maranhão 8 0.8519943 1.3600000 1.0132383
## 9 Piauí 9 0.2327991 1.6000850 0.0659536
## 10 Ceará 10 1.2349832 0.4351646 1.5393543
## 11 Rio Grande do Norte 11 0.7325795 0.3188847 1.2940731
## 12 Paraíba 12 0.8064772 0.4351646 0.8787836
## 13 Pernambuco 13 4.7898680 2.1169988 1.2843720
## 14 Alagoas 14 0.9284091 1.6000850 0.8560429
## 15 Sergipe 15 0.5081841 0.4351646 0.6187398
## 16 Bahia 16 1.0000000 0.8000000 0.7900000
## 17 Minas Gerais 17 0.7797291 0.5441658 0.4254539
## 18 Espírito Santo 18 0.2053771 0.4329898 0.2983588
## 19 Rio de Janeiro 19 1.3900000 1.3600000 1.2400000
## 20 São Paulo 20 0.8000000 0.7000000 0.5289000
## 21 Paraná 21 0.9257585 1.3600000 0.0659536
## 22 Santa Catarina 22 0.4772808 0.3188847 0.4943333
## 23 Rio Grande do Sul 23 1.2540241 1.2952400 1.1244569
## 24 Mato Grosso do Sul 24 0.4416048 0.4351646 0.9709539
## 25 Mato Grosso 25 1.7122836 1.1900599 1.5063185
## 26 Goiás 26 1.1743946 1.2563794 1.0093793
## 27 Distrito Federal 27 2.2287867 2.3492061 1.9951928
## tx_latrc_2008 tx_latrc_2009 tx_latrc_2010 tx_latrc_2011 tx_latrc_2012
## 1 1.13821552 0.9973882 1.66613158 0.7612016 0.8804971
## 2 0.14704304 1.7362819 1.91049860 1.4737683 1.3178946
## 3 0.83804835 0.8251387 1.32148327 1.2152430 1.1139005
## 4 0.24225804 0.4744970 0.66485383 0.2173134 0.8519266
## 5 2.82729219 2.1262222 2.93296054 1.8208793 1.6939232
## 6 3.58794711 2.7130156 0.14954635 0.1273752 1.0020011
## 7 0.54665762 1.0061522 0.36141452 1.1421294 0.5642967
## 8 1.01498064 0.9894555 0.41097873 1.4746242 0.8042519
## 9 0.09616319 0.1907593 0.03206140 0.1273752 0.6327616
## 10 1.05318875 0.9827080 0.56817812 0.8909568 1.1735991
## 11 0.70820846 0.6055698 0.41033631 0.5314731 0.2787933
## 12 1.01533530 0.7161847 0.45130738 0.7121540 0.5504340
## 13 1.45405518 1.2712457 1.38698904 0.8798740 0.9405412
## 14 1.31092735 0.9505378 1.15350528 1.1452626 2.7484053
## 15 0.75023482 1.3368461 0.96710349 1.1484248 1.7054604
## 16 0.83000000 0.8300000 0.30000000 0.8900000 1.2300000
## 17 0.31737920 0.1747059 0.09696198 0.4561882 0.6446631
## 18 0.57909781 0.7742604 0.45549371 0.6202328 1.2856104
## 19 1.50000000 1.4000000 0.98000000 0.7300000 0.8700000
## 20 0.63860000 0.7201000 0.59550000 0.7368000 0.7948000
## 21 0.47213600 0.4211020 0.96746993 0.8371107 0.3970597
## 22 0.64435257 0.9479071 0.65603338 0.6015462 0.7989615
## 23 0.76460952 0.6047208 0.71992679 0.7826308 0.8541769
## 24 1.24140753 0.6354591 0.53075501 0.7668891 1.1177252
## 25 1.89334260 1.8322999 1.54911468 1.5930110 1.2839707
## 26 0.87254123 1.0124361 0.48300771 0.7400444 1.3647450
## 27 2.34635482 1.9947178 5.42341033 1.6858250 1.7745679
## tx_latrc_2013 tx_latrc_2014 tx_latrc_2015 tx_pres_2005 tx_pres_2006
## 1 0.5786320 0.9722447 0.8483184 297.66831 271.63043
## 2 1.6742588 0.8859627 1.2445349 382.98673 319.37575
## 3 0.9453978 1.1616672 1.8535747 113.63320 97.03941
## 4 0.6146634 0.6036995 1.7798345 254.78065 261.56333
## 5 1.9574250 2.2293992 2.3363591 104.69708 141.84726
## 6 1.2244965 1.9975710 2.9999517 266.40340 466.12475
## 7 1.3530298 0.9352787 0.5940100 90.44763 132.91395
## 8 0.9272477 1.0509593 1.6946106 84.47851 90.32203
## 9 0.9107565 1.0955584 1.4669035 59.36376 60.63321
## 10 1.2188765 0.8481485 0.7299714 137.45363 142.87305
## 11 0.4742203 1.8189766 1.6849812 126.13687 153.56007
## 12 0.7153037 0.4817585 1.2083978 170.13888 211.16605
## 13 0.7927415 0.8730587 1.2412825 217.71911 185.56670
## 14 2.3932613 1.8363925 1.6462472 88.56359 70.11616
## 15 1.5940523 1.4867718 2.0954668 138.83588 111.35891
## 16 1.0100000 1.3200000 1.3600000 51.71066 92.40764
## 17 0.4078985 0.3038473 0.5845963 121.16991 178.82008
## 18 0.9116088 1.2869851 0.9414971 206.96140 211.81860
## 19 0.9000000 0.9200000 0.8000000 180.42167 183.20597
## 20 0.8703000 0.8743000 0.8019000 341.50953 351.79008
## 21 0.4182782 0.9475087 1.0481037 182.37442 258.72747
## 22 0.8290307 0.8473130 1.0411794 172.29835 161.64099
## 23 1.1823674 1.3027254 1.2802308 208.58293 217.21722
## 24 1.0049206 1.6032633 1.3578578 383.88708 480.42173
## 25 1.4141547 1.6127246 1.8067755 257.59166 263.84328
## 26 1.9272470 2.5600846 2.3598174 174.41539 172.75217
## 27 1.0395156 1.7529270 1.5781366 312.84450 309.04646
## tx_pres_2007 tx_pres_2008 tx_pres_2009 tx_pres_2010 tx_pres_2011
## 1 353.63569 400.25014 464.51692 475.87281 402.10472
## 2 366.65471 446.42266 495.70849 513.78766 511.66555
## 3 112.35467 124.59983 136.61939 156.10739 181.86253
## 4 328.76366 368.71673 393.59524 375.64242 373.12703
## 5 123.61347 120.86333 138.46013 127.31416 158.75466
## 6 318.40030 343.13821 289.17555 272.47345 267.13078
## 7 155.35205 144.47380 149.76189 155.76966 165.82292
## 8 86.61553 73.91914 82.01487 83.97665 79.81027
## 9 86.86089 72.34677 82.37623 87.01465 94.70348
## 10 148.87755 160.46337 152.49522 179.93491 198.74199
## 11 98.74774 127.31657 132.65165 193.26840 208.96270
## 12 222.55195 238.25644 226.10218 213.76042 216.54756
## 13 221.94890 226.78681 238.82393 271.99765 291.59926
## 14 58.93526 69.31928 75.37765 99.13737 119.26637
## 15 159.32549 151.84753 154.97512 166.19673 170.25398
## 16 98.85183 96.14844 97.62004 125.77175 98.36472
## 17 193.80982 217.21836 231.84475 236.24532 243.84271
## 18 258.31906 283.29465 307.20931 307.54366 351.61564
## 19 171.99887 160.90863 166.46025 159.52648 182.88704
## 20 384.29545 377.20027 396.08265 414.32012 432.96754
## 21 280.53859 344.21547 350.35687 344.50550 319.49091
## 22 186.05683 204.25977 218.01864 232.66784 237.04087
## 23 241.91886 254.58733 263.42004 293.42159 271.24680
## 24 479.43056 545.91966 459.39459 444.97683 461.14254
## 25 323.75338 362.74416 368.49217 377.22590 363.62915
## 26 170.42572 181.40303 187.60441 197.21704 198.21679
## 27 319.55659 304.32222 315.74082 350.21965 395.59417
## tx_pres_2012 tx_pres_2013 tx_pres_2014 tx_pres_2015 gini_ibge_2005
## 1 468.42443 434.03190 537.14652 583.3037 0.544
## 2 467.19365 558.04333 537.14652 578.5843 0.542
## 3 216.51441 221.56447 228.92587 269.3269 0.459
## 4 431.86188 337.04044 323.78415 441.3989 0.505
## 5 151.50347 156.34305 156.33043 157.0987 0.495
## 6 292.72748 379.32179 354.63543 337.2989 0.497
## 7 177.61238 203.96925 385.60205 216.6816 0.520
## 8 80.67838 87.79417 97.84139 114.3066 0.507
## 9 92.60466 101.15679 99.60191 116.1039 0.586
## 10 216.34893 236.24561 244.80959 387.3565 0.558
## 11 221.20700 192.41490 224.67295 225.4389 0.580
## 12 228.63982 235.87141 264.96716 265.1426 0.566
## 13 322.12417 349.49042 288.96086 339.8974 0.555
## 14 145.76025 161.07557 178.22039 200.6326 0.521
## 15 195.65420 209.73173 209.63482 231.5714 0.530
## 16 92.44928 100.49762 103.20387 100.0859 0.523
## 17 259.86974 277.91488 296.09199 314.7572 0.525
## 18 413.35168 391.70530 429.69857 476.1940 0.538
## 19 208.39899 225.59470 244.82459 335.6611 0.530
## 20 467.03892 480.22762 499.66727 524.9672 0.521
## 21 296.01744 195.22681 252.70509 471.2704 0.534
## 22 260.41446 266.91773 250.15058 270.8679 0.481
## 23 271.50755 252.65041 250.95309 273.0626 0.517
## 24 485.81128 634.53008 531.17641 595.4583 0.523
## 25 340.66951 334.11761 314.41928 273.9255 0.493
## 26 196.79948 190.98397 238.74705 218.2529 0.543
## 27 431.86188 444.41083 505.01828 494.8831 0.588
## gini_ibge_2006 gini_ibge_2007 gini_ibge_2008 gini_ibge_2009 gini_ibge_2010
## 1 0.537 0.472 0.478 0.490 NA
## 2 0.556 0.558 0.517 0.566 NA
## 3 0.471 0.475 0.473 0.481 NA
## 4 0.556 0.502 0.529 0.509 NA
## 5 0.500 0.506 0.488 0.484 NA
## 6 0.442 0.471 0.433 0.484 NA
## 7 0.510 0.530 0.530 0.513 NA
## 8 0.584 0.519 0.496 0.514 NA
## 9 0.604 0.595 0.576 0.555 NA
## 10 0.533 0.520 0.529 0.525 NA
## 11 0.545 0.546 0.540 0.545 NA
## 12 0.555 0.577 0.565 0.560 NA
## 13 0.552 0.519 0.533 0.519 NA
## 14 0.590 0.565 0.540 0.528 NA
## 15 0.538 0.519 0.518 0.550 NA
## 16 0.533 0.521 0.530 0.529 NA
## 17 0.522 0.502 0.502 0.501 NA
## 18 0.522 0.508 0.507 0.503 NA
## 19 0.533 0.523 0.519 0.520 NA
## 20 0.516 0.493 0.486 0.479 NA
## 21 0.521 0.528 0.500 0.492 NA
## 22 0.483 0.467 0.471 0.468 NA
## 23 0.507 0.494 0.498 0.490 NA
## 24 0.528 0.556 0.525 0.514 NA
## 25 0.515 0.486 0.536 0.485 NA
## 26 0.507 0.509 0.506 0.504 NA
## 27 0.587 0.601 0.615 0.605 NA
## gini_ibge_2011 gini_ibge_2012 gini_ibge_2013 gini_ibge_2014 gini_ibge_2015
## 1 0.474 0.470 0.451 0.451 0.452
## 2 0.500 0.496 0.465 0.501 0.500
## 3 0.488 0.469 0.494 0.490 0.476
## 4 0.517 0.504 0.500 0.495 0.500
## 5 0.512 0.482 0.478 0.468 0.459
## 6 0.476 0.493 0.476 0.449 0.457
## 7 0.504 0.509 0.501 0.501 0.504
## 8 0.504 0.577 0.515 0.493 0.506
## 9 0.513 0.546 0.516 0.494 0.505
## 10 0.502 0.501 0.478 0.475 0.453
## 11 0.532 0.525 0.524 0.486 0.487
## 12 0.525 0.514 0.508 0.501 0.510
## 13 0.480 0.473 0.466 0.473 0.492
## 14 0.475 0.461 0.466 0.459 0.438
## 15 0.542 0.532 0.554 0.484 0.470
## 16 0.520 0.516 0.537 0.506 0.481
## 17 0.483 0.485 0.479 0.473 0.478
## 18 0.491 0.480 0.466 0.480 0.471
## 19 0.505 0.499 0.503 0.502 0.503
## 20 0.468 0.474 0.472 0.476 0.460
## 21 0.469 0.479 0.464 0.450 0.465
## 22 0.443 0.433 0.438 0.429 0.419
## 23 0.479 0.470 0.463 0.469 0.454
## 24 0.510 0.484 0.498 0.491 0.479
## 25 0.483 0.515 0.479 0.458 0.445
## 26 0.473 0.470 0.469 0.447 0.436
## 27 0.596 0.572 0.570 0.565 0.555
## perc_jov_15_24_2005 perc_jov_15_24_2006 perc_jov_15_24_2007
## 1 19.7 20.2 19.7
## 2 19.2 20.4 20.4
## 3 18.9 19.7 20.2
## 4 23.5 20.3 21.5
## 5 20.6 20.1 20.2
## 6 23.0 21.9 20.5
## 7 20.4 19.8 20.3
## 8 22.2 20.9 20.3
## 9 20.7 20.8 19.4
## 10 20.2 19.7 19.6
## 11 19.4 20.4 19.8
## 12 21.0 20.1 19.2
## 13 20.1 19.0 19.2
## 14 20.2 19.3 19.5
## 15 20.5 19.6 19.8
## 16 21.2 20.4 19.4
## 17 18.7 18.3 17.3
## 18 20.0 19.0 17.5
## 19 16.6 16.3 15.7
## 20 18.3 17.6 16.9
## 21 17.4 17.7 17.1
## 22 18.0 18.1 17.9
## 23 17.1 16.6 16.0
## 24 19.3 18.6 18.2
## 25 20.2 19.5 18.1
## 26 18.7 18.8 18.3
## 27 20.3 19.9 18.9
## perc_jov_15_24_2008 perc_jov_15_24_2009 perc_jov_15_24_2010
## 1 19.1 19.6 NA
## 2 20.4 18.7 NA
## 3 20.1 19.3 NA
## 4 19.8 17.9 NA
## 5 19.4 19.2 NA
## 6 18.1 20.4 NA
## 7 19.8 18.1 NA
## 8 19.6 19.3 NA
## 9 20.1 18.3 NA
## 10 19.9 19.3 NA
## 11 18.8 20.0 NA
## 12 18.1 18.5 NA
## 13 18.3 18.1 NA
## 14 18.4 20.1 NA
## 15 19.7 20.2 NA
## 16 19.2 18.3 NA
## 17 17.2 17.2 NA
## 18 18.1 16.7 NA
## 19 15.4 15.2 NA
## 20 16.7 16.4 NA
## 21 16.5 16.6 NA
## 22 17.2 17.5 NA
## 23 16.3 16.3 NA
## 24 17.1 17.4 NA
## 25 18.9 17.8 NA
## 26 17.3 17.5 NA
## 27 17.6 18.7 NA
## perc_jov_15_24_2011 perc_jov_15_24_2012 perc_jov_15_24_2013
## 1 18.8 18.921252 18.17416
## 2 19.6 20.078995 19.97765
## 3 18.9 18.692887 19.44252
## 4 19.2 20.747178 19.22660
## 5 19.6 18.776322 18.37978
## 6 20.4 20.521067 20.72664
## 7 18.7 17.359447 18.44510
## 8 19.2 18.356600 18.28479
## 9 17.3 18.494449 17.45351
## 10 18.4 18.545711 18.99085
## 11 18.0 18.758255 17.62036
## 12 17.5 17.545464 17.16502
## 13 17.5 16.588935 16.97851
## 14 18.8 18.719314 18.54972
## 15 17.8 18.650329 17.70406
## 16 17.0 17.345933 16.45377
## 17 16.8 16.567973 16.51747
## 18 16.6 15.802204 16.32774
## 19 15.4 15.021151 15.17740
## 20 15.7 15.349541 15.37068
## 21 17.1 16.561524 16.25832
## 22 16.9 16.821487 16.22141
## 23 15.6 12.025261 15.10029
## 24 17.1 11.248166 16.53232
## 25 18.4 9.939921 17.72524
## 26 16.7 11.442171 16.76537
## 27 17.2 9.711132 16.71830
## perc_jov_15_24_2014 perc_jov_15_24_2015 perc_hom_2005 perc_hom_2006
## 1 17.3 17.3 49.6 50.7
## 2 19.2 20.4 49.6 50.6
## 3 19.0 19.2 50.3 51.1
## 4 19.6 18.7 51.9 51.3
## 5 18.2 18.2 49.1 50.0
## 6 20.5 19.3 49.4 49.8
## 7 16.6 16.4 51.2 49.9
## 8 18.5 17.8 49.6 49.7
## 9 18.1 17.5 47.9 48.6
## 10 17.7 17.6 48.4 48.5
## 11 18.3 17.2 49.0 48.9
## 12 17.3 16.7 48.7 49.0
## 13 16.3 16.7 48.6 47.9
## 14 19.5 17.3 48.5 49.3
## 15 17.7 18.2 49.1 49.4
## 16 16.8 16.6 49.5 49.5
## 17 16.2 15.9 49.1 48.4
## 18 15.6 14.4 49.0 49.5
## 19 14.9 14.9 47.4 47.0
## 20 15.4 15.4 48.4 48.5
## 21 15.7 15.8 49.0 48.5
## 22 15.6 15.0 48.6 49.0
## 23 15.2 14.7 48.6 48.4
## 24 15.5 16.4 48.9 49.8
## 25 16.0 15.8 50.6 50.7
## 26 16.7 16.0 48.5 49.4
## 27 16.6 17.0 47.3 47.3
## perc_hom_2007 perc_hom_2008 perc_hom_2009 perc_hom_2010 perc_hom_2011
## 1 49.7 50.2 49.9 NA 50.3
## 2 50.0 50.3 50.3 NA 49.7
## 3 50.1 49.6 49.8 NA 49.9
## 4 50.6 52.4 49.8 NA 50.6
## 5 50.3 50.2 49.9 NA 50.2
## 6 49.3 51.0 50.6 NA 50.1
## 7 49.8 50.6 50.9 NA 50.2
## 8 49.1 49.9 49.1 NA 49.1
## 9 48.7 49.2 48.3 NA 48.9
## 10 48.5 48.7 48.1 NA 48.2
## 11 49.6 49.2 49.5 NA 48.1
## 12 48.4 48.2 48.6 NA 47.4
## 13 48.4 48.4 47.9 NA 47.9
## 14 48.7 48.5 48.6 NA 48.3
## 15 47.7 47.7 48.3 NA 48.2
## 16 49.4 49.4 49.3 NA 48.3
## 17 49.1 48.6 48.6 NA 48.7
## 18 48.6 48.8 49.2 NA 48.5
## 19 47.5 47.0 47.0 NA 46.8
## 20 48.4 48.3 48.7 NA 48.5
## 21 48.9 48.5 48.5 NA 49.0
## 22 49.6 49.1 49.7 NA 49.5
## 23 48.7 48.6 48.7 NA 48.3
## 24 49.6 48.8 49.6 NA 48.9
## 25 51.0 51.0 50.2 NA 50.8
## 26 49.7 49.5 48.9 NA 48.4
## 27 47.6 47.0 47.4 NA 47.5
## perc_hom_2012 perc_hom_2013 perc_hom_2014 perc_hom_2015 pbf_2005 pbf_2006
## 1 50.78329 50.68820 50.2 50.4 62.69023 84.59089
## 2 50.52159 49.74302 50.1 50.2 83.38666 115.65642
## 3 50.46752 50.20349 49.8 50.5 67.97436 95.31140
## 4 50.46768 50.41561 49.6 50.2 69.61835 112.17704
## 5 50.44752 50.17248 50.3 50.4 74.47358 107.18628
## 6 49.08259 50.00000 50.0 49.8 32.60650 49.73516
## 7 49.57763 49.07852 49.9 50.6 79.91227 109.16040
## 8 49.77807 49.52535 47.8 49.4 129.78198 179.82782
## 9 47.86411 48.64092 48.4 49.0 142.15712 180.41265
## 10 48.21746 48.43884 48.6 49.1 136.01077 163.07936
## 11 49.32722 49.26993 48.0 47.8 115.06349 140.01765
## 12 47.52163 47.55132 48.1 47.6 141.59215 170.72324
## 13 47.86844 47.48008 47.7 47.8 111.49360 145.12309
## 14 48.32046 47.48215 48.3 47.8 132.11640 160.45205
## 15 47.82650 49.46625 48.9 48.2 112.02497 143.51149
## 16 48.75733 48.49641 48.2 48.3 115.30229 148.50701
## 17 49.17400 48.73649 48.8 49.2 68.21532 79.48905
## 18 49.34657 48.98323 48.6 48.0 61.15566 72.46231
## 19 47.48482 46.81923 46.9 47.1 24.87688 35.80480
## 20 48.08016 48.48110 48.1 47.8 27.38120 33.75702
## 21 48.89623 48.84306 48.8 49.1 49.95021 57.34327
## 22 48.91151 48.88687 48.8 49.4 29.26110 32.05743
## 23 48.66489 48.38961 48.0 48.3 45.75049 54.61730
## 24 49.69001 49.45472 49.4 49.4 37.58935 61.91026
## 25 50.54807 49.98601 50.7 50.4 51.95374 62.86481
## 26 49.19704 49.97618 49.3 48.7 40.22207 53.56115
## 27 47.69933 46.86465 48.7 47.4 22.03578 40.12812
## pbf_2007 pbf_2008 pbf_2009 pbf_2010 pbf_2011 pbf_2012 pbf_2013
## 1 109.63714 118.59663 139.43921 145.34356 152.58021 171.10406 165.14128
## 2 143.23709 165.45912 182.02002 179.55349 189.53399 259.69458 323.46858
## 3 118.52181 135.07872 156.64318 176.49802 203.13245 247.71077 270.25464
## 4 144.09976 167.14767 203.53253 206.22164 237.14175 262.25980 270.37877
## 5 135.28636 150.19176 171.55597 191.55119 219.88616 264.85227 295.37683
## 6 99.74058 132.51637 149.76717 152.47208 181.10820 208.88600 220.63995
## 7 137.28438 149.92582 166.47641 176.39252 197.02872 231.84321 249.29474
## 8 214.95833 236.35010 264.58431 280.55208 309.33772 354.98828 409.78576
## 9 209.01240 225.17351 245.72722 268.41017 297.40992 338.12300 402.64678
## 10 181.27388 196.07841 210.50943 235.26295 259.19743 293.50058 319.17889
## 11 159.99661 172.50535 188.19211 204.98563 222.05758 252.59364 268.29393
## 12 192.85603 208.82315 225.88215 238.10925 265.00050 304.49889 341.41917
## 13 173.64474 192.44355 215.33343 233.96028 262.33478 290.19714 308.55808
## 14 188.49144 208.92758 236.42167 261.88909 289.79327 324.66288 344.62311
## 15 167.56226 178.49177 201.55157 223.11466 250.92577 290.14154 304.86421
## 16 169.30739 182.31239 202.81551 234.03036 254.48243 290.80494 307.35006
## 17 85.09160 87.72782 93.23144 102.73814 115.70790 132.19094 135.41893
## 18 83.16995 86.89120 92.26865 95.53942 107.98942 120.72277 116.94939
## 19 46.33595 55.00945 68.81453 78.68253 89.89560 107.47604 121.64452
## 20 39.41898 41.26541 45.53561 46.98502 56.97384 63.97008 68.38122
## 21 59.43514 58.37380 67.63640 75.54550 83.13034 90.10566 87.38025
## 22 33.76685 33.58041 38.03211 39.69922 43.64674 50.33406 51.29769
## 23 59.88261 61.24340 69.57499 76.61176 84.50163 94.86768 96.22485
## 24 72.97327 77.65506 88.23124 94.98001 110.58628 127.72694 135.00941
## 25 69.25635 71.87550 86.31472 98.36381 112.31646 130.55484 137.68789
## 26 65.34584 70.58263 81.80147 93.97253 108.85046 122.87067 123.19437
## 27 47.98970 47.45687 50.94785 49.33823 60.10765 66.75207 69.64423
## pbf_2014 pbf_2015 densidade_urbana1_2005 densidade_urbana1_2006
## 1 160.08443 135.73957 43.24927 43.20221
## 2 357.77723 336.35136 57.32704 57.80404
## 3 288.76314 267.50912 81.51353 82.36733
## 4 276.15173 254.66013 35.05144 35.30184
## 5 313.36496 289.56786 80.92045 80.74976
## 6 223.49144 212.34078 55.24020 55.92715
## 7 250.71292 222.55342 46.68229 45.85887
## 8 423.79286 390.49260 88.26797 87.42808
## 9 413.31140 381.47924 95.17570 93.78830
## 10 319.73980 288.10098 128.88353 127.47145
## 11 271.36182 246.02324 141.92197 137.52350
## 12 358.86160 334.38334 119.25727 117.42668
## 13 312.06195 284.69179 145.53441 144.41170
## 14 349.96548 315.77439 143.78260 138.64566
## 15 309.96154 278.21101 160.28656 154.79042
## 16 310.50731 286.38982 116.54929 115.24808
## 17 134.21037 120.40359 71.72269 71.01649
## 18 114.59751 102.87884 67.53067 67.59783
## 19 125.53637 115.29997 78.90156 78.82688
## 20 70.72419 68.12809 64.47201 65.00793
## 21 83.90607 74.11634 53.15402 53.09599
## 22 49.29602 43.27983 39.82699 39.61325
## 23 94.46256 83.29711 58.08312 57.95840
## 24 139.50273 123.50797 44.74578 44.62115
## 25 140.26635 124.13484 42.92342 41.83402
## 26 121.57090 106.89818 45.02593 45.06077
## 27 69.02521 62.00759 47.82998 48.46935
## densidade_urbana1_2007 densidade_urbana1_2008 densidade_urbana1_2009
## 1 39.15716 39.51491 38.82355
## 2 54.03063 55.06340 54.72202
## 3 77.78464 79.11369 79.31904
## 4 34.29033 34.63070 34.99454
## 5 76.77589 76.73650 76.25687
## 6 52.24913 52.84626 53.40962
## 7 40.99631 41.11349 39.96297
## 8 84.28211 84.64331 83.32601
## 9 91.83354 91.05975 88.98825
## 10 122.24084 121.78290 120.86138
## 11 133.20135 130.11280 126.69878
## 12 115.90284 116.18093 113.15133
## 13 141.33635 142.75644 141.12560
## 14 134.63291 135.45988 133.98264
## 15 135.12163 129.53546 124.61145
## 16 111.77250 112.28445 110.33034
## 17 68.57017 70.37967 68.09121
## 18 63.78596 65.76518 64.56617
## 19 76.60002 78.85820 78.90246
## 20 61.42742 63.24349 61.87855
## 21 51.60912 53.11372 52.10075
## 22 38.12840 39.32133 38.20026
## 23 54.93453 56.34244 55.27222
## 24 43.12628 44.24093 43.03212
## 25 39.87989 39.95051 38.99282
## 26 43.17291 43.73653 43.13119
## 27 48.85827 49.86001 50.02820
## densidade_urbana1_2010 densidade_urbana1_2011 densidade_urbana1_2012
## 1 39.40739 38.99623 38.55710
## 2 56.84724 56.64946 56.61849
## 3 80.26353 80.46326 80.75979
## 4 36.10838 36.11409 36.35655
## 5 75.96648 74.58978 73.81520
## 6 56.66261 57.04472 57.13474
## 7 41.65216 41.29480 41.00446
## 8 83.89031 82.74075 81.69818
## 9 85.93096 84.39795 83.30337
## 10 116.94943 114.50835 112.54125
## 11 123.28351 118.57560 114.39266
## 12 109.42950 107.30308 105.17644
## 13 133.80803 130.96574 127.18762
## 14 127.28312 124.72081 121.42725
## 15 122.43027 118.48237 115.71060
## 16 103.17440 101.18635 99.63248
## 17 64.97904 63.83604 62.96899
## 18 63.52941 63.26901 62.78185
## 19 76.13808 75.50210 75.13579
## 20 60.71074 60.40857 60.01366
## 21 49.49541 48.54978 47.70761
## 22 38.01703 37.71820 37.23291
## 23 53.18595 52.52630 51.63320
## 24 42.87782 41.87263 41.18586
## 25 38.49503 38.00558 37.38706
## 26 42.46184 42.07264 41.81277
## 27 48.29449 48.51707 48.94502
## densidade_urbana1_2013 densidade_urbana1_2014 densidade_urbana1_2015
## 1 40.69527 40.41890 39.84184
## 2 56.22261 56.25943 56.48102
## 3 84.24480 85.24081 86.25539
## 4 37.17077 37.84558 38.50932
## 5 72.87899 71.47395 70.12241
## 6 58.37220 58.50112 59.37838
## 7 41.25439 40.29367 38.57117
## 8 80.31299 78.67270 77.31470
## 9 80.99295 79.06494 76.88420
## 10 110.98775 108.45380 106.34993
## 11 112.19947 108.57864 105.39640
## 12 102.73472 99.71863 96.89342
## 13 125.50851 119.60674 114.26973
## 14 121.59535 117.08616 110.48184
## 15 112.45424 107.80638 103.64731
## 16 100.46416 97.47933 93.55012
## 17 62.80277 61.93018 61.22458
## 18 65.60017 65.48891 65.12424
## 19 74.60050 73.59948 72.88052
## 20 61.26378 60.81770 60.37299
## 21 48.23949 47.33969 46.68032
## 22 37.93397 37.57425 37.43023
## 23 52.40875 51.72773 51.26933
## 24 41.39261 40.63424 39.94150
## 25 36.79790 36.15544 35.39281
## 26 42.05453 41.40923 41.04114
## 27 50.50185 50.77927 51.24638
## densidade_urbana2_2005 densidade_urbana2_2006 densidade_urbana2_2007
## 1 29.19082 29.45744 26.94931
## 2 39.53326 40.20569 37.87542
## 3 62.89954 63.93821 60.74719
## 4 28.51698 29.06528 28.54595
## 5 59.74564 60.72594 58.71625
## 6 51.33974 52.40594 49.35360
## 7 33.19794 33.97153 30.13513
## 8 57.58843 58.58940 57.03742
## 9 58.83685 56.93977 57.07096
## 10 97.54760 97.39480 93.43149
## 11 101.91603 99.58397 96.80712
## 12 92.40601 89.63874 90.82140
## 13 110.91612 110.97945 107.08648
## 14 93.72020 93.47202 92.47991
## 15 131.26307 127.25144 110.45693
## 16 77.54516 77.67818 75.76469
## 17 60.66941 60.12905 58.22624
## 18 56.17197 55.54940 52.42611
## 19 76.20503 76.36244 74.05361
## 20 60.72434 61.46636 58.03736
## 21 44.57184 44.86226 43.71064
## 22 32.81449 32.67191 31.56205
## 23 47.17704 47.25879 44.63503
## 24 37.93790 37.81329 37.02697
## 25 32.98115 32.05571 30.27083
## 26 39.41450 39.91242 38.65038
## 27 45.29829 45.57148 46.04284
## densidade_urbana2_2008 densidade_urbana2_2009 densidade_urbana2_2010
## 1 28.62821 28.23362 NA
## 2 43.37863 43.13627 NA
## 3 65.80645 65.88344 NA
## 4 29.45210 29.65725 NA
## 5 57.63521 57.27860 NA
## 6 51.89813 52.21827 NA
## 7 30.73821 29.72301 NA
## 8 58.38071 57.93471 NA
## 9 57.19483 55.09069 NA
## 10 93.71002 93.41040 NA
## 11 93.65590 91.89313 NA
## 12 90.91322 88.03269 NA
## 13 109.06866 109.09916 NA
## 14 92.06921 91.09769 NA
## 15 108.00435 103.30976 NA
## 16 77.37902 76.75830 NA
## 17 60.27521 58.35113 NA
## 18 54.05097 53.33825 NA
## 19 76.27234 76.21613 NA
## 20 59.60821 58.49606 NA
## 21 45.05361 44.35209 NA
## 22 32.47396 31.35409 NA
## 23 45.86171 45.30940 NA
## 24 37.81840 36.83929 NA
## 25 31.90717 31.95229 NA
## 26 39.25919 38.48405 NA
## 27 46.98803 47.09853 NA
## densidade_urbana2_2011 densidade_urbana2_2012 densidade_urbana2_2013
## 1 28.67783 28.38405 29.91559
## 2 43.61442 41.46218 40.01542
## 3 64.74879 67.66965 70.06492
## 4 30.24555 30.65403 31.03161
## 5 51.88465 51.56236 50.18733
## 6 55.22499 50.62284 52.53498
## 7 36.87626 31.77364 31.32573
## 8 64.17373 48.14007 46.78427
## 9 50.79068 55.81108 55.40022
## 10 76.11370 82.71409 81.00643
## 11 86.59576 91.05850 88.22314
## 12 84.40460 84.75754 81.79590
## 13 106.55373 103.24446 102.38240
## 14 102.81984 86.75211 86.92698
## 15 85.25991 84.89463 82.31377
## 16 74.27078 73.64999 74.30544
## 17 47.05354 53.20135 53.04111
## 18 53.46231 54.17779 56.41790
## 19 64.32779 73.07094 72.34511
## 20 58.81379 57.86233 59.09819
## 21 46.98648 41.42987 42.19384
## 22 32.74317 31.34759 32.20280
## 23 43.87522 43.42579 44.03342
## 24 35.34050 36.66097 37.12055
## 25 34.03400 31.20971 30.36805
## 26 35.52193 38.28965 38.51921
## 27 44.70363 46.79335 48.23598
## densidade_urbana2_2014 densidade_urbana2_2015 taxa_casamentos_2005
## 1 30.83962 30.47901 0.004832549
## 2 41.68824 40.15801 0.005408101
## 3 71.34656 72.45453 0.004078791
## 4 31.48752 32.42484 0.002808465
## 5 50.10324 48.03385 0.002554448
## 6 52.41700 51.48106 0.002196483
## 7 31.63053 30.23980 0.004648748
## 8 46.57424 46.07956 0.002835994
## 9 53.36883 51.58930 0.003762033
## 10 79.71354 77.10370 0.003716065
## 11 83.06266 81.26062 0.003523041
## 12 81.37040 77.51473 0.004829964
## 13 97.00107 91.18725 0.004588408
## 14 83.95078 81.64608 0.004661608
## 15 77.51279 73.48594 0.003381457
## 16 73.20698 69.32064 0.003547363
## 17 52.39293 51.42865 0.005075933
## 18 55.33813 55.35560 0.005700974
## 19 71.61229 70.98563 0.004316989
## 20 58.74990 58.32031 0.005640461
## 21 41.42223 40.79860 0.005374369
## 22 31.59994 31.32910 0.004215582
## 23 43.96857 43.57893 0.003305091
## 24 36.24574 35.62782 0.003588481
## 25 29.93670 28.91593 0.003996042
## 26 38.17931 37.59368 0.005328371
## 27 48.54499 48.83780 0.005895141
## taxa_casamentos_2006 taxa_casamentos_2007 taxa_casamentos_2008
## 1 0.004776574 0.005346839 0.005502268
## 2 0.006220036 0.006902813 0.007741816
## 3 0.004695523 0.003615834 0.004001980
## 4 0.003091654 0.003755133 0.004244361
## 5 0.002580000 0.002892334 0.003112890
## 6 0.003790715 0.002107912 0.003388979
## 7 0.004824979 0.004601862 0.005240104
## 8 0.003555803 0.003701425 0.003207973
## 9 0.003707485 0.003564792 0.003409305
## 10 0.004339130 0.004617819 0.005227248
## 11 0.004060767 0.004098562 0.004523199
## 12 0.005180206 0.005010165 0.004941744
## 13 0.004827110 0.004988077 0.005109115
## 14 0.004591477 0.004877140 0.004509590
## 15 0.003677143 0.003870733 0.003732168
## 16 0.003713868 0.004072533 0.004033904
## 17 0.005116237 0.005409387 0.005315044
## 18 0.006219177 0.006762004 0.007182840
## 19 0.004626288 0.004823724 0.005051485
## 20 0.005725144 0.006144871 0.006232451
## 21 0.005487140 0.005589964 0.005472245
## 22 0.004502988 0.004817193 0.004816783
## 23 0.003207999 0.003295037 0.003489936
## 24 0.005650612 0.005761729 0.005605169
## 25 0.004935949 0.003878595 0.003993939
## 26 0.005498230 0.005966317 0.006116001
## 27 0.005915804 0.006044620 0.006140802
## taxa_casamentos_2009 taxa_casamentos_2010 taxa_casamentos_2011
## 1 0.005876611 0.006919573 0.007327199
## 2 0.007299619 0.005390335 0.004121192
## 3 0.003634146 0.003915612 0.004745383
## 4 0.004977473 0.004851217 0.004463616
## 5 0.003277208 0.003598335 0.003988116
## 6 0.004991949 0.001846897 0.002596780
## 7 0.005657671 0.004722965 0.004724133
## 8 0.003357081 0.003201372 0.003538948
## 9 0.003276927 0.003717520 0.004088108
## 10 0.004591118 0.005454155 0.005486184
## 11 0.004047437 0.004316107 0.004582548
## 12 0.004858916 0.005178354 0.005099814
## 13 0.004933909 0.005396183 0.005513426
## 14 0.004399723 0.004555705 0.005004479
## 15 0.003394104 0.003630023 0.003753914
## 16 0.003911633 0.003996026 0.004403607
## 17 0.005185472 0.005605015 0.005766573
## 18 0.006559993 0.006715970 0.006606326
## 19 0.004533795 0.004992565 0.005233332
## 20 0.005963459 0.006116092 0.006361143
## 21 0.005247586 0.005629430 0.005546524
## 22 0.004552242 0.004635596 0.004678605
## 23 0.003432798 0.003558589 0.003722434
## 24 0.005714048 0.005604365 0.005710095
## 25 0.005102456 0.004266657 0.005505966
## 26 0.006066180 0.006578898 0.006513049
## 27 0.006257276 0.006739855 0.006880848
## taxa_casamentos_2012 taxa_casamentos_2013 taxa_casamentos_2014
## 1 0.008010636 0.007569664 0.008030741
## 2 0.004349052 0.003535262 0.004757620
## 3 0.004513246 0.004551040 0.004571031
## 4 0.004904968 0.005263568 0.005099248
## 5 0.003852649 0.003885865 0.004014281
## 6 0.003323781 0.002658518 0.002837882
## 7 0.005116055 0.004977797 0.004903533
## 8 0.003368326 0.003894146 0.003481449
## 9 0.003834219 0.004201100 0.003839463
## 10 0.005802576 0.005212007 0.005470106
## 11 0.004894991 0.004243087 0.004528078
## 12 0.005387439 0.004991287 0.005207302
## 13 0.005247884 0.005209289 0.005696007
## 14 0.005223866 0.004861956 0.005283391
## 15 0.003773331 0.003717330 0.003962923
## 16 0.003962444 0.003642881 0.003939742
## 17 0.005853742 0.005538777 0.005709822
## 18 0.007057162 0.006517482 0.006764908
## 19 0.005387224 0.005378156 0.005698500
## 20 0.006475134 0.006419914 0.006755421
## 21 0.005591357 0.005545914 0.005780706
## 22 0.004759618 0.004726681 0.004819576
## 23 0.003766177 0.003694988 0.003699651
## 24 0.005668863 0.005421547 0.005865653
## 25 0.004595331 0.004815668 0.004995415
## 26 0.006752888 0.006443067 0.006652234
## 27 0.006917417 0.006523139 0.006488635
## taxa_casamentos_2015 Taxa_desligamentos_2005 Taxa_desligamentos_2006
## 1 0.008422105 0.04223071 0.04158813
## 2 0.006526341 0.01882384 0.02388401
## 3 0.004666946 0.03463879 0.03945001
## 4 0.005092304 0.01728777 0.01802184
## 5 0.003898906 0.02735523 0.02816792
## 6 0.003005169 0.02232306 0.02253965
## 7 0.004938203 0.03168271 0.03157288
## 8 0.003744800 0.01195610 0.01303299
## 9 0.003862950 0.01581670 0.01721937
## 10 0.005344513 0.02590526 0.02841409
## 11 0.004678437 0.03977341 0.04324454
## 12 0.004776696 0.01914549 0.01973827
## 13 0.005448695 0.03227206 0.03465750
## 14 0.005402385 0.03253808 0.03212428
## 15 0.003674200 0.02875814 0.03137392
## 16 0.003948912 0.02942679 0.03212318
## 17 0.005760334 0.07404677 0.07976203
## 18 0.007216194 0.07358220 0.08149330
## 19 0.006408812 0.05824991 0.05983073
## 20 0.006878720 0.08254397 0.08774173
## 21 0.005846448 0.08055044 0.08150392
## 22 0.004864067 0.10712515 0.11234023
## 23 0.003682086 0.07777208 0.07563572
## 24 0.006570523 0.07015113 0.07143445
## 25 0.004999868 0.08781018 0.07801543
## 26 0.006493280 0.06201800 0.06370995
## 27 0.006826813 0.07307077 0.07851131
## Taxa_desligamentos_2007 Taxa_desligamentos_2008 Taxa_desligamentos_2009
## 1 0.04883970 0.06009242 0.06718008
## 2 0.02498379 0.03036292 0.03157284
## 3 0.04313426 0.05274437 0.04865018
## 4 0.02067092 0.03010541 0.02942593
## 5 0.03045839 0.03600536 0.03331844
## 6 0.02781661 0.03213985 0.03229765
## 7 0.03621182 0.04592314 0.04237139
## 8 0.01562103 0.01988648 0.02236939
## 9 0.01776988 0.02004554 0.02122611
## 10 0.03128933 0.03597610 0.03682441
## 11 0.04359367 0.04778282 0.04679779
## 12 0.02214068 0.02499088 0.02542403
## 13 0.03624745 0.04067095 0.04461698
## 14 0.03611118 0.03741099 0.03588249
## 15 0.03462004 0.03824797 0.03895520
## 16 0.03355884 0.03928806 0.03848897
## 17 0.08572154 0.09766705 0.09481999
## 18 0.09383594 0.10448980 0.10081816
## 19 0.06640513 0.07602718 0.07899426
## 20 0.10102871 0.11837670 0.11534969
## 21 0.09188786 0.10759460 0.10542148
## 22 0.12725333 0.14474786 0.14339252
## 23 0.08427521 0.09865600 0.09602233
## 24 0.08031422 0.09977792 0.09171200
## 25 0.08557886 0.10282203 0.10618944
## 26 0.07323436 0.08527020 0.08595093
## 27 0.08167057 0.09007852 0.10299687
## Taxa_desligamentos_2010 Taxa_desligamentos_2011 Taxa_desligamentos_2012
## 1 0.08758021 0.09903042 0.09604399
## 2 0.03648097 0.04095870 0.03749806
## 3 0.05142983 0.05452174 0.05439427
## 4 0.03329366 0.03966621 0.04003842
## 5 0.03413624 0.03878668 0.04173313
## 6 0.03115200 0.03761605 0.04058677
## 7 0.04595675 0.04858833 0.04667016
## 8 0.02315896 0.02719403 0.02896513
## 9 0.02716627 0.03038186 0.03107397
## 10 0.04443792 0.05203798 0.05244454
## 11 0.04971887 0.05474016 0.05494149
## 12 0.02910959 0.03336705 0.03665760
## 13 0.05186862 0.06009562 0.06357174
## 14 0.04009713 0.04482749 0.04704196
## 15 0.04333833 0.04866307 0.05397829
## 16 0.04710917 0.05313036 0.05334404
## 17 0.10566784 0.11503702 0.11654351
## 18 0.10978252 0.11658799 0.12084123
## 19 0.08716396 0.09728252 0.10279487
## 20 0.13054955 0.14374208 0.14383610
## 21 0.12079619 0.13256143 0.13882152
## 22 0.15957532 0.17103210 0.17529968
## 23 0.11399209 0.12610856 0.13025408
## 24 0.09443275 0.10442325 0.10542105
## 25 0.11194496 0.12238714 0.13046297
## 26 0.09613003 0.10694135 0.10912144
## 27 0.11474337 0.12237596 0.12325998
## Taxa_desligamentos_2013 Taxa_desligamentos_2014 Taxa_desligamentos_2015
## 1 0.08775013 0.08523555 0.07929458
## 2 0.03539769 0.03642699 0.03607160
## 3 0.05303944 0.05340468 0.04783137
## 4 0.04651773 0.04653718 0.04773121
## 5 0.04382010 0.04634723 0.04401872
## 6 0.04366418 0.04428082 0.03580508
## 7 0.04615997 0.05258471 0.05171253
## 8 0.02911764 0.02981732 0.02773918
## 9 0.03258404 0.03502218 0.03679774
## 10 0.05443468 0.05633448 0.05586931
## 11 0.05485929 0.05725962 0.05108282
## 12 0.03870534 0.04055088 0.03967069
## 13 0.06328716 0.06526577 0.05778834
## 14 0.04486850 0.04292041 0.03971586
## 15 0.05278135 0.05387836 0.04932283
## 16 0.05044849 0.05095770 0.04753783
## 17 0.11458142 0.11202484 0.09792453
## 18 0.11734463 0.11609120 0.10146769
## 19 0.10825198 0.10836749 0.10050674
## 20 0.14073815 0.14065535 0.12494591
## 21 0.13764763 0.13724177 0.11927930
## 22 0.17503626 0.17911335 0.15833831
## 23 0.13088206 0.13260281 0.11407479
## 24 0.10805680 0.11074274 0.09921753
## 25 0.13709287 0.14334300 0.12940310
## 26 0.11014559 0.11145428 0.09839410
## 27 0.12483077 0.12754507 0.10639454
## raz_2020_2005 raz_2020_2006 raz_2020_2007 raz_2020_2008 raz_2020_2009
## 1 19.09342 17.39353 15.20173 14.88750 15.87740
## 2 22.16901 23.76250 32.32947 19.94808 29.03962
## 3 13.64827 15.00330 20.77269 16.38562 14.29203
## 4 18.67128 16.98218 15.47026 17.24119 16.49136
## 5 14.17800 13.30141 14.39384 12.93464 13.96045
## 6 15.34015 11.65251 16.75950 10.19189 14.87962
## 7 16.73348 15.12096 18.74254 17.27740 16.04743
## 8 16.44215 23.43942 25.67802 16.95965 19.37815
## 9 23.03308 24.88993 24.54302 22.07213 18.70961
## 10 21.89729 18.91900 19.64836 16.30116 18.44784
## 11 21.94234 18.19442 21.12404 19.19883 18.06521
## 12 18.99995 18.43183 21.86940 20.97006 21.27536
## 13 22.13824 21.07909 20.45578 19.89518 19.97093
## 14 19.92789 26.87854 25.41954 22.26123 22.77433
## 15 17.89844 17.93438 18.72419 17.37411 21.00644
## 16 18.05977 18.65554 18.14507 19.56007 19.51414
## 17 15.76427 15.66887 15.23376 15.08734 14.91703
## 18 19.64082 16.64182 16.15980 15.80457 16.69536
## 19 18.12795 18.03158 17.92315 16.68223 16.77348
## 20 16.61395 15.64116 14.54484 13.64078 13.10480
## 21 17.29051 15.42311 16.01254 14.24445 13.90593
## 22 11.12217 11.12417 10.74988 11.39825 10.99858
## 23 16.07478 15.65997 15.34801 14.51818 14.16086
## 24 16.48709 15.57696 17.85927 15.33603 14.17605
## 25 15.82339 15.53206 14.38721 16.69227 14.65909
## 26 17.08011 13.69412 15.14429 14.20680 14.14300
## 27 31.47856 29.55933 30.85315 31.39970 29.67417
## raz_2020_2010 raz_2020_2011 raz_2020_2012 raz_2020_2013 raz_2020_2014
## 1 NA 14.61255 13.451869 13.061486 11.964049
## 2 NA 19.42420 20.325063 16.678759 18.001050
## 3 NA 19.43400 15.467018 19.450026 15.757312
## 4 NA 16.26074 17.213296 15.588158 13.351550
## 5 NA 16.98652 14.109005 14.468952 12.966488
## 6 NA 16.90157 16.587804 16.676728 11.073630
## 7 NA 15.71435 15.820999 15.757142 15.682940
## 8 NA 21.04451 26.164171 25.437959 17.189226
## 9 NA 14.58931 15.954112 14.427615 14.435413
## 10 NA 19.05276 17.233485 16.588981 14.820375
## 11 NA 18.89838 16.288181 17.356765 13.570982
## 12 NA 16.49016 15.482365 15.800001 15.004157
## 13 NA 18.11182 15.278767 15.427452 14.991232
## 14 NA 17.22276 14.142427 17.895917 14.933248
## 15 NA 17.12710 16.259370 17.111972 11.929826
## 16 NA 20.72045 18.826497 19.674030 15.878203
## 17 NA 13.53943 13.587785 12.974134 12.744215
## 18 NA 14.13704 13.341448 14.672564 13.275208
## 19 NA 15.77057 16.310109 16.506243 14.638977
## 20 NA 12.44010 12.680071 13.158411 12.627955
## 21 NA 11.66312 12.407622 11.599344 10.611545
## 22 NA 10.55101 9.034296 9.930552 9.080553
## 23 NA 13.17218 12.331950 12.626588 12.297588
## 24 NA 13.56852 12.734071 13.036302 11.594559
## 25 NA 11.82839 14.339934 14.420348 10.547686
## 26 NA 12.47655 11.829874 12.287442 10.319159
## 27 NA 27.43321 25.111951 23.759046 22.637547
## raz_2020_2015 raz_1040_2005 raz_1040_2006 raz_1040_2007 raz_1040_2008
## 1 NA 18.81129 16.36066 13.39028 12.93757
## 2 NA 20.91488 22.16999 26.10554 18.11686
## 3 NA 13.60694 13.73870 17.43225 14.05479
## 4 NA 16.48602 18.01158 13.60747 16.24708
## 5 NA 13.89771 13.13086 14.35546 12.54157
## 6 NA 15.21573 10.98602 13.57277 10.02988
## 7 NA 15.57023 14.34487 16.84083 16.45759
## 8 NA 14.41655 21.91953 18.19803 14.46146
## 9 NA 21.77367 22.67201 22.52199 19.73396
## 10 NA 20.24214 17.09536 17.25161 16.05978
## 11 NA 21.85830 18.15666 18.44572 17.39436
## 12 NA 19.77355 18.19946 21.75230 20.67778
## 13 NA 20.68511 20.33786 18.10097 18.61174
## 14 NA 18.69454 25.58230 23.09397 20.82636
## 15 NA 17.53285 17.85962 16.68224 16.23722
## 16 NA 17.39902 17.70460 17.41970 18.03419
## 17 NA 15.03117 14.97358 14.16004 13.99209
## 18 NA 17.88079 15.70205 14.96127 14.50483
## 19 NA 17.52575 17.39917 16.81303 15.97065
## 20 NA 15.43135 14.69370 13.25748 12.59799
## 21 NA 16.06132 14.26137 14.90561 12.93950
## 22 NA 10.33394 10.42043 10.31693 10.51227
## 23 NA 14.51026 14.11186 13.39399 13.20218
## 24 NA 15.32649 15.32040 18.15231 14.96459
## 25 NA 14.49239 14.94800 13.92365 16.17864
## 26 NA 17.25644 13.51363 14.56876 13.59654
## 27 NA 26.53044 25.86598 26.75580 27.65100
## raz_1040_2009 raz_1040_2010 raz_1040_2011 raz_1040_2012 raz_1040_2013
## 1 13.81045 NA 12.68129 12.026364 11.410312
## 2 25.46317 NA 17.14072 17.508675 15.148104
## 3 13.43168 NA 16.56083 13.848512 16.600964
## 4 14.41813 NA 14.91217 16.220030 14.851454
## 5 13.52698 NA 15.87012 13.050355 12.980587
## 6 14.31745 NA 14.41785 15.793859 14.554859
## 7 14.62061 NA 14.60431 14.836875 14.412712
## 8 16.04810 NA 16.47717 23.192158 18.964210
## 9 17.64398 NA 13.55235 16.366363 14.009388
## 10 16.77406 NA 16.35076 15.159255 14.150598
## 11 17.85428 NA 18.00611 15.257711 16.311285
## 12 21.31068 NA 15.91947 15.008759 14.849412
## 13 17.48520 NA 15.22005 13.493253 13.251377
## 14 19.52290 NA 14.82215 12.644655 15.105207
## 15 20.16547 NA 17.58846 15.991912 17.654706
## 16 17.84594 NA 17.74950 16.976937 17.896214
## 17 13.72063 NA 12.80896 12.785283 12.145894
## 18 15.40811 NA 12.69085 12.630268 12.656094
## 19 16.09960 NA 15.34813 15.144736 15.260317
## 20 12.04506 NA 11.73842 12.204234 12.243255
## 21 12.66801 NA 10.86631 11.529201 10.734714
## 22 10.13191 NA 9.39286 8.481676 8.944251
## 23 12.90563 NA 11.83706 11.236404 11.300454
## 24 14.25132 NA 13.67323 11.876088 12.515159
## 25 13.14916 NA 11.37055 14.300197 12.949251
## 26 13.45150 NA 11.68700 11.465708 11.717627
## 27 27.74246 NA 24.31935 22.038495 20.809719
## raz_1040_2014 raz_1040_2015
## 1 10.949300 NA
## 2 16.470546 NA
## 3 15.224282 NA
## 4 12.839091 NA
## 5 12.010693 NA
## 6 10.494529 NA
## 7 14.011762 NA
## 8 15.355137 NA
## 9 13.003729 NA
## 10 13.462433 NA
## 11 12.664317 NA
## 12 13.849238 NA
## 13 13.540734 NA
## 14 13.055146 NA
## 15 11.931450 NA
## 16 15.003238 NA
## 17 11.861639 NA
## 18 12.310697 NA
## 19 14.600014 NA
## 20 12.261895 NA
## 21 9.889635 NA
## 22 8.349361 NA
## 23 11.159088 NA
## 24 11.833984 NA
## 25 10.235310 NA
## 26 9.750386 NA
## 27 20.849703 NAteste = imp_comp[[1]] %>%
pivot_longer(
cols = tx_latrc_2005:perc_hom_2008,
values_to = "Ano")
who %>% pivot_longer(
cols = new_sp_m014:newrel_f65,
names_to = c("diagnosis", "gender", "age"),
names_pattern = "new_?(.*)_(.)(.*)",
values_to = "count"
)## # A tibble: 405,440 x 8
## country iso2 iso3 year diagnosis gender age count
## <chr> <chr> <chr> <int> <chr> <chr> <chr> <int>
## 1 Afghanistan AF AFG 1980 sp m 014 NA
## 2 Afghanistan AF AFG 1980 sp m 1524 NA
## 3 Afghanistan AF AFG 1980 sp m 2534 NA
## 4 Afghanistan AF AFG 1980 sp m 3544 NA
## 5 Afghanistan AF AFG 1980 sp m 4554 NA
## 6 Afghanistan AF AFG 1980 sp m 5564 NA
## 7 Afghanistan AF AFG 1980 sp m 65 NA
## 8 Afghanistan AF AFG 1980 sp f 014 NA
## 9 Afghanistan AF AFG 1980 sp f 1524 NA
## 10 Afghanistan AF AFG 1980 sp f 2534 NA
## # ... with 405,430 more rows