Library

# Load packages
library(here)        # relative filepaths for reproducibility
library(tidyverse)   # data wrangling
library(stringi)     # string wrangling
library(stringr)
library(kableExtra)  # table formatting
library(tidycensus)  # census data
library(purrr)

API Key and Variable Import

# Load API key, assign to TidyCensus Package
source(here::here("analysis/password.R"))
census_api_key(census_api_key)

import::here("author", "census_division", "fips_region_assignment",
             "rank_variables", "svi_theme_variables", "svi_theme_flags",
             .from = here::here("analysis/project_data_steps_gregorio.R"),
             .character_only = TRUE)

#Data

# Load SVI data sets
svi_2010 <- readRDS(here::here("data/raw/Census_Data_SVI/svi_2010_trt10.rds"))
svi_2020 <- readRDS(here::here("data/raw/Census_Data_SVI/svi_2020_trt10.rds"))

svi_2010 %>% colnames()

##  [1] "GEOID_2010_trt"         "E_TOTPOP_10"            "E_HU_10"               
##  [4] "E_HH_10"                "E_POV150_10"            "ET_POVSTATUS_10"       
##  [7] "EP_POV150_10"           "EPL_POV150_10"          "E_UNEMP_10"            
## [10] "ET_EMPSTATUS_10"        "EP_UNEMP_10"            "EPL_UNEMP_10"          
## [13] "E_HBURD_OWN_10"         "ET_HOUSINGCOST_OWN_10"  "EP_HBURD_OWN_10"       
## [16] "EPL_HBURD_OWN_10"       "E_HBURD_RENT_10"        "ET_HOUSINGCOST_RENT_10"
## [19] "EP_HBURD_RENT_10"       "EPL_HBURD_RENT_10"      "E_HBURD_10"            
## [22] "ET_HOUSINGCOST_10"      "EP_HBURD_10"            "EPL_HBURD_10"          
## [25] "E_NOHSDP_10"            "ET_EDSTATUS_10"         "EP_NOHSDP_10"          
## [28] "EPL_NOHSDP_10"          "E_UNINSUR_12"           "ET_INSURSTATUS_12"     
## [31] "EP_UNINSUR_12"          "EPL_UNINSUR_12"         "E_AGE65_10"            
## [34] "EP_AGE65_10"            "EPL_AGE65_10"           "E_AGE17_10"            
## [37] "EP_AGE17_10"            "EPL_AGE17_10"           "E_DISABL_12"           
## [40] "ET_DISABLSTATUS_12"     "EP_DISABL_12"           "EPL_DISABL_12"         
## [43] "E_SNGPNT_10"            "ET_FAMILIES_10"         "EP_SNGPNT_10"          
## [46] "EPL_SNGPNT_10"          "E_LIMENG_10"            "ET_POPAGE5UP_10"       
## [49] "EP_LIMENG_10"           "EPL_LIMENG_10"          "E_MINRTY_10"           
## [52] "ET_POPETHRACE_10"       "EP_MINRTY_10"           "EPL_MINRTY_10"         
## [55] "E_STRHU_10"             "E_MUNIT_10"             "EP_MUNIT_10"           
## [58] "EPL_MUNIT_10"           "E_MOBILE_10"            "EP_MOBILE_10"          
## [61] "EPL_MOBILE_10"          "E_CROWD_10"             "ET_OCCUPANTS_10"       
## [64] "EP_CROWD_10"            "EPL_CROWD_10"           "E_NOVEH_10"            
## [67] "ET_KNOWNVEH_10"         "EP_NOVEH_10"            "EPL_NOVEH_10"          
## [70] "E_GROUPQ_10"            "ET_HHTYPE_10"           "EP_GROUPQ_10"          
## [73] "EPL_GROUPQ_10"

svi_2010 %>% head() %>% kbl() %>% kable_styling() %>% scroll_box(width = "100%")
GEOID_2010_trt E_TOTPOP_10 E_HU_10 E_HH_10 E_POV150_10 ET_POVSTATUS_10 EP_POV150_10 EPL_POV150_10 E_UNEMP_10 ET_EMPSTATUS_10 EP_UNEMP_10 EPL_UNEMP_10 E_HBURD_OWN_10 ET_HOUSINGCOST_OWN_10 EP_HBURD_OWN_10 EPL_HBURD_OWN_10 E_HBURD_RENT_10 ET_HOUSINGCOST_RENT_10 EP_HBURD_RENT_10 EPL_HBURD_RENT_10 E_HBURD_10 ET_HOUSINGCOST_10 EP_HBURD_10 EPL_HBURD_10 E_NOHSDP_10 ET_EDSTATUS_10 EP_NOHSDP_10 EPL_NOHSDP_10 E_UNINSUR_12 ET_INSURSTATUS_12 EP_UNINSUR_12 EPL_UNINSUR_12 E_AGE65_10 EP_AGE65_10 EPL_AGE65_10 E_AGE17_10 EP_AGE17_10 EPL_AGE17_10 E_DISABL_12 ET_DISABLSTATUS_12 EP_DISABL_12 EPL_DISABL_12 E_SNGPNT_10 ET_FAMILIES_10 EP_SNGPNT_10 EPL_SNGPNT_10 E_LIMENG_10 ET_POPAGE5UP_10 EP_LIMENG_10 EPL_LIMENG_10 E_MINRTY_10 ET_POPETHRACE_10 EP_MINRTY_10 EPL_MINRTY_10 E_STRHU_10 E_MUNIT_10 EP_MUNIT_10 EPL_MUNIT_10 E_MOBILE_10 EP_MOBILE_10 EPL_MOBILE_10 E_CROWD_10 ET_OCCUPANTS_10 EP_CROWD_10 EPL_CROWD_10 E_NOVEH_10 ET_KNOWNVEH_10 EP_NOVEH_10 EPL_NOVEH_10 E_GROUPQ_10 ET_HHTYPE_10 EP_GROUPQ_10 EPL_GROUPQ_10
01001020100 1809 771 696 297 1809 16.41791 NA 36 889 4.049494 NA 127 598 21.23746 NA 47 98 47.95918 NA 174 696 25.00000 NA 196 1242 15.780998 NA 186 1759 10.574190 NA 222 12.271973 NA 445 24.59923 NA 298 1335 22.32210 NA 27 545 4.954128 NA 36 1705 2.1114370 NA 385 1809 21.282477 NA 771 0 0.0000000 NA 92 11.9325551 NA 0 696 0.0000000 NA 50 696 7.183908 NA 0 1809 0 NA
01001020200 2020 816 730 495 1992 24.84940 NA 68 834 8.153477 NA 49 439 11.16173 NA 105 291 36.08247 NA 154 730 21.09589 NA 339 1265 26.798419 NA 313 2012 15.556660 NA 204 10.099010 NA 597 29.55446 NA 359 1515 23.69637 NA 132 456 28.947368 NA 15 1890 0.7936508 NA 1243 2020 61.534653 NA 816 0 0.0000000 NA 34 4.1666667 NA 13 730 1.7808219 NA 115 730 15.753425 NA 0 2020 0 NA
01001020300 3543 1403 1287 656 3533 18.56779 NA 93 1552 5.992268 NA 273 957 28.52665 NA 178 330 53.93939 NA 451 1287 35.04274 NA 346 2260 15.309734 NA 252 3102 8.123791 NA 487 13.745413 NA 998 28.16822 NA 371 2224 16.68165 NA 126 913 13.800657 NA 0 3365 0.0000000 NA 637 3543 17.979114 NA 1403 10 0.7127584 NA 2 0.1425517 NA 0 1287 0.0000000 NA 101 1287 7.847708 NA 0 3543 0 NA
01001020400 4840 1957 1839 501 4840 10.35124 NA 101 2129 4.744011 NA 310 1549 20.01291 NA 89 290 30.68966 NA 399 1839 21.69657 NA 274 3280 8.353658 NA 399 4293 9.294200 NA 955 19.731405 NA 1195 24.69008 NA 625 3328 18.78005 NA 152 1374 11.062591 NA 10 4537 0.2204100 NA 297 4840 6.136364 NA 1957 33 1.6862545 NA 25 1.2774655 NA 14 1839 0.7612833 NA 19 1839 1.033170 NA 0 4840 0 NA
01001020500 9938 3969 3741 1096 9938 11.02838 NA 188 4937 3.807981 NA 426 2406 17.70574 NA 528 1335 39.55056 NA 954 3741 25.50120 NA 293 5983 4.897209 NA 740 10110 7.319486 NA 837 8.422218 NA 3012 30.30791 NA 759 7155 10.60797 NA 476 2529 18.821669 NA 78 9297 0.8389803 NA 1970 9938 19.822902 NA 3969 306 7.7097506 NA 0 0.0000000 NA 7 3741 0.1871157 NA 223 3741 5.960973 NA 0 9938 0 NA
01001020600 3402 1456 1308 735 3402 21.60494 NA 134 1720 7.790698 NA 242 1032 23.44961 NA 62 276 22.46377 NA 304 1308 23.24159 NA 301 2151 13.993491 NA 355 3445 10.304790 NA 386 11.346267 NA 931 27.36626 NA 440 2439 18.04018 NA 143 924 15.476190 NA 4 3254 0.1229256 NA 723 3402 21.252205 NA 1456 18 1.2362637 NA 433 29.7390110 NA 16 1308 1.2232416 NA 28 1308 2.140673 NA 0 3402 0 NA 
svi_2010 %>% nrow()

## [1] 73057

svi_2020 %>% colnames()

##  [1] "GEOID_2010_trt"         "E_TOTPOP_20"            "E_HU_20"               
##  [4] "E_HH_20"                "E_POV150_20"            "ET_POVSTATUS_20"       
##  [7] "EP_POV150_20"           "EPL_POV150_20"          "E_UNEMP_20"            
## [10] "ET_EMPSTATUS_20"        "EP_UNEMP_20"            "EPL_UNEMP_20"          
## [13] "E_HBURD_OWN_20"         "ET_HOUSINGCOST_OWN_20"  "EP_HBURD_OWN_20"       
## [16] "EPL_HBURD_OWN_20"       "E_HBURD_RENT_20"        "ET_HOUSINGCOST_RENT_20"
## [19] "EP_HBURD_RENT_20"       "EPL_HBURD_RENT_20"      "E_HBURD_20"            
## [22] "ET_HOUSINGCOST_20"      "EP_HBURD_20"            "EPL_HBURD_20"          
## [25] "E_NOHSDP_20"            "ET_EDSTATUS_20"         "EP_NOHSDP_20"          
## [28] "EPL_NOHSDP_20"          "E_UNINSUR_20"           "ET_INSURSTATUS_20"     
## [31] "EP_UNINSUR_20"          "EPL_UNINSUR_20"         "E_AGE65_20"            
## [34] "EP_AGE65_20"            "EPL_AGE65_20"           "E_AGE17_20"            
## [37] "EP_AGE17_20"            "EPL_AGE17_20"           "E_DISABL_20"           
## [40] "ET_DISABLSTATUS_20"     "EP_DISABL_20"           "EPL_DISABL_20"         
## [43] "E_SNGPNT_20"            "ET_FAMILIES_20"         "EP_SNGPNT_20"          
## [46] "EPL_SNGPNT_20"          "E_LIMENG_20"            "ET_POPAGE5UP_20"       
## [49] "EP_LIMENG_20"           "EPL_LIMENG_20"          "E_MINRTY_20"           
## [52] "ET_POPETHRACE_20"       "EP_MINRTY_20"           "EPL_MINRTY_20"         
## [55] "E_STRHU_20"             "E_MUNIT_20"             "EP_MUNIT_20"           
## [58] "EPL_MUNIT_20"           "E_MOBILE_20"            "EP_MOBILE_20"          
## [61] "EPL_MOBILE_20"          "E_CROWD_20"             "ET_OCCUPANTS_20"       
## [64] "EP_CROWD_20"            "EPL_CROWD_20"           "E_NOVEH_20"            
## [67] "ET_KNOWNVEH_20"         "EP_NOVEH_20"            "EPL_NOVEH_20"          
## [70] "E_GROUPQ_20"            "ET_HHTYPE_20"           "EP_GROUPQ_20"          
## [73] "EPL_GROUPQ_20"

svi_2020 %>% head() %>% kbl() %>% kable_styling() %>% scroll_box(width = "100%")
GEOID_2010_trt E_TOTPOP_20 E_HU_20 E_HH_20 E_POV150_20 ET_POVSTATUS_20 EP_POV150_20 EPL_POV150_20 E_UNEMP_20 ET_EMPSTATUS_20 EP_UNEMP_20 EPL_UNEMP_20 E_HBURD_OWN_20 ET_HOUSINGCOST_OWN_20 EP_HBURD_OWN_20 EPL_HBURD_OWN_20 E_HBURD_RENT_20 ET_HOUSINGCOST_RENT_20 EP_HBURD_RENT_20 EPL_HBURD_RENT_20 E_HBURD_20 ET_HOUSINGCOST_20 EP_HBURD_20 EPL_HBURD_20 E_NOHSDP_20 ET_EDSTATUS_20 EP_NOHSDP_20 EPL_NOHSDP_20 E_UNINSUR_20 ET_INSURSTATUS_20 EP_UNINSUR_20 EPL_UNINSUR_20 E_AGE65_20 EP_AGE65_20 EPL_AGE65_20 E_AGE17_20 EP_AGE17_20 EPL_AGE17_20 E_DISABL_20 ET_DISABLSTATUS_20 EP_DISABL_20 EPL_DISABL_20 E_SNGPNT_20 ET_FAMILIES_20 EP_SNGPNT_20 EPL_SNGPNT_20 E_LIMENG_20 ET_POPAGE5UP_20 EP_LIMENG_20 EPL_LIMENG_20 E_MINRTY_20 ET_POPETHRACE_20 EP_MINRTY_20 EPL_MINRTY_20 E_STRHU_20 E_MUNIT_20 EP_MUNIT_20 EPL_MUNIT_20 E_MOBILE_20 EP_MOBILE_20 EPL_MOBILE_20 E_CROWD_20 ET_OCCUPANTS_20 EP_CROWD_20 EPL_CROWD_20 E_NOVEH_20 ET_KNOWNVEH_20 EP_NOVEH_20 EPL_NOVEH_20 E_GROUPQ_20 ET_HHTYPE_20 EP_GROUPQ_20 EPL_GROUPQ_20
01001020100 1941 710 693 352 1941 18.13498 NA 18 852 2.112676 NA 81 507 15.976331 NA 63 186 33.87097 NA 144 693 20.77922 NA 187 1309 14.285714 NA 187 1941 9.634209 NA 295 15.19835 NA 415 21.38073 NA 391 1526 25.62254 NA 58 555 10.45045 NA 0 1843 0.0000000 NA 437 1941 22.51417 NA 710 0 0.0000000 NA 88 12.3943662 NA 0 693 0.0000000 NA 10 693 1.443001 NA 0 1941 0.000000 NA
01001020200 1757 720 573 384 1511 25.41363 NA 29 717 4.044630 NA 33 392 8.418367 NA 116 181 64.08840 NA 149 573 26.00349 NA 139 1313 10.586443 NA 91 1533 5.936073 NA 284 16.16392 NA 325 18.49744 NA 164 1208 13.57616 NA 42 359 11.69916 NA 0 1651 0.0000000 NA 1116 1757 63.51736 NA 720 3 0.4166667 NA 5 0.6944444 NA 9 573 1.5706806 NA 57 573 9.947644 NA 212 1757 12.066022 NA
01001020300 3694 1464 1351 842 3694 22.79372 NA 53 1994 2.657974 NA 117 967 12.099276 NA 147 384 38.28125 NA 264 1351 19.54108 NA 317 2477 12.797739 NA 127 3673 3.457664 NA 464 12.56091 NA 929 25.14889 NA 473 2744 17.23761 NA 263 975 26.97436 NA 128 3586 3.5694367 NA 1331 3694 36.03140 NA 1464 26 1.7759563 NA 14 0.9562842 NA 35 1351 2.5906736 NA 42 1351 3.108808 NA 0 3694 0.000000 NA
01001020400 3539 1741 1636 503 3539 14.21305 NA 39 1658 2.352232 NA 219 1290 16.976744 NA 74 346 21.38728 NA 293 1636 17.90954 NA 173 2775 6.234234 NA 169 3529 4.788892 NA 969 27.38062 NA 510 14.41085 NA 670 3019 22.19278 NA 148 1137 13.01671 NA 89 3409 2.6107363 NA 454 3539 12.82848 NA 1741 143 8.2136703 NA 0 0.0000000 NA 10 1636 0.6112469 NA 72 1636 4.400978 NA 0 3539 0.000000 NA
01001020500 10674 4504 4424 1626 10509 15.47245 NA 81 5048 1.604596 NA 321 2299 13.962592 NA 711 2125 33.45882 NA 1032 4424 23.32731 NA 531 6816 7.790493 NA 301 10046 2.996217 NA 1613 15.11149 NA 2765 25.90407 NA 1124 7281 15.43744 NA 342 2912 11.74451 NA 52 9920 0.5241935 NA 2603 10674 24.38636 NA 4504 703 15.6083481 NA 29 0.6438721 NA 37 4424 0.8363472 NA 207 4424 4.679023 NA 176 10674 1.648866 NA
01001020600 3536 1464 1330 1279 3523 36.30429 NA 34 1223 2.780049 NA 321 1111 28.892889 NA 67 219 30.59361 NA 388 1330 29.17293 NA 306 2380 12.857143 NA 415 3496 11.870709 NA 547 15.46946 NA 982 27.77149 NA 729 2514 28.99761 NA 95 880 10.79545 NA 0 3394 0.0000000 NA 985 3536 27.85633 NA 1464 0 0.0000000 NA 364 24.8633880 NA 0 1330 0.0000000 NA 17 1330 1.278196 NA 0 3536 0.000000 NA 
svi_2020 %>% nrow()

## [1] 73057

Data Wrangling

svi_2010 <- fips_region_assignment(svi_2010)

svi_2010 %>% head() %>% kbl() %>% kable_styling() %>% scroll_box(width = "100%")
GEOID_2010_trt FIPS_st FIPS_county FIPS_tract state state_name county region_number region division_number division E_TOTPOP_10 E_HU_10 E_HH_10 E_POV150_10 ET_POVSTATUS_10 EP_POV150_10 EPL_POV150_10 E_UNEMP_10 ET_EMPSTATUS_10 EP_UNEMP_10 EPL_UNEMP_10 E_HBURD_OWN_10 ET_HOUSINGCOST_OWN_10 EP_HBURD_OWN_10 EPL_HBURD_OWN_10 E_HBURD_RENT_10 ET_HOUSINGCOST_RENT_10 EP_HBURD_RENT_10 EPL_HBURD_RENT_10 E_HBURD_10 ET_HOUSINGCOST_10 EP_HBURD_10 EPL_HBURD_10 E_NOHSDP_10 ET_EDSTATUS_10 EP_NOHSDP_10 EPL_NOHSDP_10 E_UNINSUR_12 ET_INSURSTATUS_12 EP_UNINSUR_12 EPL_UNINSUR_12 E_AGE65_10 EP_AGE65_10 EPL_AGE65_10 E_AGE17_10 EP_AGE17_10 EPL_AGE17_10 E_DISABL_12 ET_DISABLSTATUS_12 EP_DISABL_12 EPL_DISABL_12 E_SNGPNT_10 ET_FAMILIES_10 EP_SNGPNT_10 EPL_SNGPNT_10 E_LIMENG_10 ET_POPAGE5UP_10 EP_LIMENG_10 EPL_LIMENG_10 E_MINRTY_10 ET_POPETHRACE_10 EP_MINRTY_10 EPL_MINRTY_10 E_STRHU_10 E_MUNIT_10 EP_MUNIT_10 EPL_MUNIT_10 E_MOBILE_10 EP_MOBILE_10 EPL_MOBILE_10 E_CROWD_10 ET_OCCUPANTS_10 EP_CROWD_10 EPL_CROWD_10 E_NOVEH_10 ET_KNOWNVEH_10 EP_NOVEH_10 EPL_NOVEH_10 E_GROUPQ_10 ET_HHTYPE_10 EP_GROUPQ_10 EPL_GROUPQ_10
01001020100 01 001 020100 AL Alabama Autauga County 3 South Region 6 East South Central Division 1809 771 696 297 1809 16.41791 NA 36 889 4.049494 NA 127 598 21.23746 NA 47 98 47.95918 NA 174 696 25.00000 NA 196 1242 15.780998 NA 186 1759 10.574190 NA 222 12.271973 NA 445 24.59923 NA 298 1335 22.32210 NA 27 545 4.954128 NA 36 1705 2.1114370 NA 385 1809 21.282477 NA 771 0 0.0000000 NA 92 11.9325551 NA 0 696 0.0000000 NA 50 696 7.183908 NA 0 1809 0 NA
01001020200 01 001 020200 AL Alabama Autauga County 3 South Region 6 East South Central Division 2020 816 730 495 1992 24.84940 NA 68 834 8.153477 NA 49 439 11.16173 NA 105 291 36.08247 NA 154 730 21.09589 NA 339 1265 26.798419 NA 313 2012 15.556660 NA 204 10.099010 NA 597 29.55446 NA 359 1515 23.69637 NA 132 456 28.947368 NA 15 1890 0.7936508 NA 1243 2020 61.534653 NA 816 0 0.0000000 NA 34 4.1666667 NA 13 730 1.7808219 NA 115 730 15.753425 NA 0 2020 0 NA
01001020300 01 001 020300 AL Alabama Autauga County 3 South Region 6 East South Central Division 3543 1403 1287 656 3533 18.56779 NA 93 1552 5.992268 NA 273 957 28.52665 NA 178 330 53.93939 NA 451 1287 35.04274 NA 346 2260 15.309734 NA 252 3102 8.123791 NA 487 13.745413 NA 998 28.16822 NA 371 2224 16.68165 NA 126 913 13.800657 NA 0 3365 0.0000000 NA 637 3543 17.979114 NA 1403 10 0.7127584 NA 2 0.1425517 NA 0 1287 0.0000000 NA 101 1287 7.847708 NA 0 3543 0 NA
01001020400 01 001 020400 AL Alabama Autauga County 3 South Region 6 East South Central Division 4840 1957 1839 501 4840 10.35124 NA 101 2129 4.744011 NA 310 1549 20.01291 NA 89 290 30.68966 NA 399 1839 21.69657 NA 274 3280 8.353658 NA 399 4293 9.294200 NA 955 19.731405 NA 1195 24.69008 NA 625 3328 18.78005 NA 152 1374 11.062591 NA 10 4537 0.2204100 NA 297 4840 6.136364 NA 1957 33 1.6862545 NA 25 1.2774655 NA 14 1839 0.7612833 NA 19 1839 1.033170 NA 0 4840 0 NA
01001020500 01 001 020500 AL Alabama Autauga County 3 South Region 6 East South Central Division 9938 3969 3741 1096 9938 11.02838 NA 188 4937 3.807981 NA 426 2406 17.70574 NA 528 1335 39.55056 NA 954 3741 25.50120 NA 293 5983 4.897209 NA 740 10110 7.319486 NA 837 8.422218 NA 3012 30.30791 NA 759 7155 10.60797 NA 476 2529 18.821669 NA 78 9297 0.8389803 NA 1970 9938 19.822902 NA 3969 306 7.7097506 NA 0 0.0000000 NA 7 3741 0.1871157 NA 223 3741 5.960973 NA 0 9938 0 NA
01001020600 01 001 020600 AL Alabama Autauga County 3 South Region 6 East South Central Division 3402 1456 1308 735 3402 21.60494 NA 134 1720 7.790698 NA 242 1032 23.44961 NA 62 276 22.46377 NA 304 1308 23.24159 NA 301 2151 13.993491 NA 355 3445 10.304790 NA 386 11.346267 NA 931 27.36626 NA 440 2439 18.04018 NA 143 924 15.476190 NA 4 3254 0.1229256 NA 723 3402 21.252205 NA 1456 18 1.2362637 NA 433 29.7390110 NA 16 1308 1.2232416 NA 28 1308 2.140673 NA 0 3402 0 NA 
svi_2020 <- fips_region_assignment(svi_2020)

svi_2020 %>% head() %>% kbl() %>% kable_styling() %>% scroll_box(width = "100%")
GEOID_2010_trt FIPS_st FIPS_county FIPS_tract state state_name county region_number region division_number division E_TOTPOP_20 E_HU_20 E_HH_20 E_POV150_20 ET_POVSTATUS_20 EP_POV150_20 EPL_POV150_20 E_UNEMP_20 ET_EMPSTATUS_20 EP_UNEMP_20 EPL_UNEMP_20 E_HBURD_OWN_20 ET_HOUSINGCOST_OWN_20 EP_HBURD_OWN_20 EPL_HBURD_OWN_20 E_HBURD_RENT_20 ET_HOUSINGCOST_RENT_20 EP_HBURD_RENT_20 EPL_HBURD_RENT_20 E_HBURD_20 ET_HOUSINGCOST_20 EP_HBURD_20 EPL_HBURD_20 E_NOHSDP_20 ET_EDSTATUS_20 EP_NOHSDP_20 EPL_NOHSDP_20 E_UNINSUR_20 ET_INSURSTATUS_20 EP_UNINSUR_20 EPL_UNINSUR_20 E_AGE65_20 EP_AGE65_20 EPL_AGE65_20 E_AGE17_20 EP_AGE17_20 EPL_AGE17_20 E_DISABL_20 ET_DISABLSTATUS_20 EP_DISABL_20 EPL_DISABL_20 E_SNGPNT_20 ET_FAMILIES_20 EP_SNGPNT_20 EPL_SNGPNT_20 E_LIMENG_20 ET_POPAGE5UP_20 EP_LIMENG_20 EPL_LIMENG_20 E_MINRTY_20 ET_POPETHRACE_20 EP_MINRTY_20 EPL_MINRTY_20 E_STRHU_20 E_MUNIT_20 EP_MUNIT_20 EPL_MUNIT_20 E_MOBILE_20 EP_MOBILE_20 EPL_MOBILE_20 E_CROWD_20 ET_OCCUPANTS_20 EP_CROWD_20 EPL_CROWD_20 E_NOVEH_20 ET_KNOWNVEH_20 EP_NOVEH_20 EPL_NOVEH_20 E_GROUPQ_20 ET_HHTYPE_20 EP_GROUPQ_20 EPL_GROUPQ_20
01001020100 01 001 020100 AL Alabama Autauga County 3 South Region 6 East South Central Division 1941 710 693 352 1941 18.13498 NA 18 852 2.112676 NA 81 507 15.976331 NA 63 186 33.87097 NA 144 693 20.77922 NA 187 1309 14.285714 NA 187 1941 9.634209 NA 295 15.19835 NA 415 21.38073 NA 391 1526 25.62254 NA 58 555 10.45045 NA 0 1843 0.0000000 NA 437 1941 22.51417 NA 710 0 0.0000000 NA 88 12.3943662 NA 0 693 0.0000000 NA 10 693 1.443001 NA 0 1941 0.000000 NA
01001020200 01 001 020200 AL Alabama Autauga County 3 South Region 6 East South Central Division 1757 720 573 384 1511 25.41363 NA 29 717 4.044630 NA 33 392 8.418367 NA 116 181 64.08840 NA 149 573 26.00349 NA 139 1313 10.586443 NA 91 1533 5.936073 NA 284 16.16392 NA 325 18.49744 NA 164 1208 13.57616 NA 42 359 11.69916 NA 0 1651 0.0000000 NA 1116 1757 63.51736 NA 720 3 0.4166667 NA 5 0.6944444 NA 9 573 1.5706806 NA 57 573 9.947644 NA 212 1757 12.066022 NA
01001020300 01 001 020300 AL Alabama Autauga County 3 South Region 6 East South Central Division 3694 1464 1351 842 3694 22.79372 NA 53 1994 2.657974 NA 117 967 12.099276 NA 147 384 38.28125 NA 264 1351 19.54108 NA 317 2477 12.797739 NA 127 3673 3.457664 NA 464 12.56091 NA 929 25.14889 NA 473 2744 17.23761 NA 263 975 26.97436 NA 128 3586 3.5694367 NA 1331 3694 36.03140 NA 1464 26 1.7759563 NA 14 0.9562842 NA 35 1351 2.5906736 NA 42 1351 3.108808 NA 0 3694 0.000000 NA
01001020400 01 001 020400 AL Alabama Autauga County 3 South Region 6 East South Central Division 3539 1741 1636 503 3539 14.21305 NA 39 1658 2.352232 NA 219 1290 16.976744 NA 74 346 21.38728 NA 293 1636 17.90954 NA 173 2775 6.234234 NA 169 3529 4.788892 NA 969 27.38062 NA 510 14.41085 NA 670 3019 22.19278 NA 148 1137 13.01671 NA 89 3409 2.6107363 NA 454 3539 12.82848 NA 1741 143 8.2136703 NA 0 0.0000000 NA 10 1636 0.6112469 NA 72 1636 4.400978 NA 0 3539 0.000000 NA
01001020500 01 001 020500 AL Alabama Autauga County 3 South Region 6 East South Central Division 10674 4504 4424 1626 10509 15.47245 NA 81 5048 1.604596 NA 321 2299 13.962592 NA 711 2125 33.45882 NA 1032 4424 23.32731 NA 531 6816 7.790493 NA 301 10046 2.996217 NA 1613 15.11149 NA 2765 25.90407 NA 1124 7281 15.43744 NA 342 2912 11.74451 NA 52 9920 0.5241935 NA 2603 10674 24.38636 NA 4504 703 15.6083481 NA 29 0.6438721 NA 37 4424 0.8363472 NA 207 4424 4.679023 NA 176 10674 1.648866 NA
01001020600 01 001 020600 AL Alabama Autauga County 3 South Region 6 East South Central Division 3536 1464 1330 1279 3523 36.30429 NA 34 1223 2.780049 NA 321 1111 28.892889 NA 67 219 30.59361 NA 388 1330 29.17293 NA 306 2380 12.857143 NA 415 3496 11.870709 NA 547 15.46946 NA 982 27.77149 NA 729 2514 28.99761 NA 95 880 10.79545 NA 0 3394 0.0000000 NA 985 3536 27.85633 NA 1464 0 0.0000000 NA 364 24.8633880 NA 0 1330 0.0000000 NA 17 1330 1.278196 NA 0 3536 0.000000 NA 
# National
svi_2010_national <- rank_variables(svi_2010)
svi_2010_national %>% head() %>% kbl() %>% kable_styling() %>% scroll_box(width = "100%")
GEOID_2010_trt FIPS_st FIPS_county FIPS_tract state state_name county region_number region division_number division E_TOTPOP_10 E_HU_10 E_HH_10 E_POV150_10 ET_POVSTATUS_10 EP_POV150_10 EPL_POV150_10 E_UNEMP_10 ET_EMPSTATUS_10 EP_UNEMP_10 EPL_UNEMP_10 E_HBURD_OWN_10 ET_HOUSINGCOST_OWN_10 EP_HBURD_OWN_10 EPL_HBURD_OWN_10 E_HBURD_RENT_10 ET_HOUSINGCOST_RENT_10 EP_HBURD_RENT_10 EPL_HBURD_RENT_10 E_HBURD_10 ET_HOUSINGCOST_10 EP_HBURD_10 EPL_HBURD_10 E_NOHSDP_10 ET_EDSTATUS_10 EP_NOHSDP_10 EPL_NOHSDP_10 E_UNINSUR_12 ET_INSURSTATUS_12 EP_UNINSUR_12 EPL_UNINSUR_12 E_AGE65_10 EP_AGE65_10 EPL_AGE65_10 E_AGE17_10 EP_AGE17_10 EPL_AGE17_10 E_DISABL_12 ET_DISABLSTATUS_12 EP_DISABL_12 EPL_DISABL_12 E_SNGPNT_10 ET_FAMILIES_10 EP_SNGPNT_10 EPL_SNGPNT_10 E_LIMENG_10 ET_POPAGE5UP_10 EP_LIMENG_10 EPL_LIMENG_10 E_MINRTY_10 ET_POPETHRACE_10 EP_MINRTY_10 EPL_MINRTY_10 E_STRHU_10 E_MUNIT_10 EP_MUNIT_10 EPL_MUNIT_10 E_MOBILE_10 EP_MOBILE_10 EPL_MOBILE_10 E_CROWD_10 ET_OCCUPANTS_10 EP_CROWD_10 EPL_CROWD_10 E_NOVEH_10 ET_KNOWNVEH_10 EP_NOVEH_10 EPL_NOVEH_10 E_GROUPQ_10 ET_HHTYPE_10 EP_GROUPQ_10 EPL_GROUPQ_10
01001020100 01 001 020100 AL Alabama Autauga County 3 South Region 6 East South Central Division 1809 771 696 297 1809 16.41791 0.3871 36 889 4.049494 0.1790 127 598 21.23746 0.20770 47 98 47.95918 0.5767 174 696 25.00000 0.18790 196 1242 15.780998 0.6093 186 1759 10.574190 0.3790 222 12.271973 0.4876 445 24.59923 0.5473 298 1335 22.32210 0.8454 27 545 4.954128 0.09275 36 1705 2.1114370 0.59040 385 1809 21.282477 0.4524 771 0 0.0000000 0.1224 92 11.9325551 0.8005 0 696 0.0000000 0.1238 50 696 7.183908 0.6134 0 1809 0 0.364
01001020200 01 001 020200 AL Alabama Autauga County 3 South Region 6 East South Central Division 2020 816 730 495 1992 24.84940 0.5954 68 834 8.153477 0.5754 49 439 11.16173 0.02067 105 291 36.08247 0.3019 154 730 21.09589 0.09312 339 1265 26.798419 0.8392 313 2012 15.556660 0.6000 204 10.099010 0.3419 597 29.55446 0.8192 359 1515 23.69637 0.8791 132 456 28.947368 0.83510 15 1890 0.7936508 0.40130 1243 2020 61.534653 0.7781 816 0 0.0000000 0.1224 34 4.1666667 0.6664 13 730 1.7808219 0.5406 115 730 15.753425 0.8382 0 2020 0 0.364
01001020300 01 001 020300 AL Alabama Autauga County 3 South Region 6 East South Central Division 3543 1403 1287 656 3533 18.56779 0.4443 93 1552 5.992268 0.3724 273 957 28.52665 0.45780 178 330 53.93939 0.7152 451 1287 35.04274 0.49930 346 2260 15.309734 0.5950 252 3102 8.123791 0.2596 487 13.745413 0.5868 998 28.16822 0.7606 371 2224 16.68165 0.6266 126 913 13.800657 0.46350 0 3365 0.0000000 0.09298 637 3543 17.979114 0.4049 1403 10 0.7127584 0.3015 2 0.1425517 0.4407 0 1287 0.0000000 0.1238 101 1287 7.847708 0.6443 0 3543 0 0.364
01001020400 01 001 020400 AL Alabama Autauga County 3 South Region 6 East South Central Division 4840 1957 1839 501 4840 10.35124 0.2177 101 2129 4.744011 0.2447 310 1549 20.01291 0.17080 89 290 30.68966 0.2044 399 1839 21.69657 0.10540 274 3280 8.353658 0.3205 399 4293 9.294200 0.3171 955 19.731405 0.8643 1195 24.69008 0.5530 625 3328 18.78005 0.7233 152 1374 11.062591 0.34710 10 4537 0.2204100 0.22560 297 4840 6.136364 0.1647 1957 33 1.6862545 0.3843 25 1.2774655 0.5516 14 1839 0.7612833 0.3564 19 1839 1.033170 0.1127 0 4840 0 0.364
01001020500 01 001 020500 AL Alabama Autauga County 3 South Region 6 East South Central Division 9938 3969 3741 1096 9938 11.02838 0.2364 188 4937 3.807981 0.1577 426 2406 17.70574 0.11050 528 1335 39.55056 0.3753 954 3741 25.50120 0.20140 293 5983 4.897209 0.1655 740 10110 7.319486 0.2211 837 8.422218 0.2408 3012 30.30791 0.8455 759 7155 10.60797 0.2668 476 2529 18.821669 0.63540 78 9297 0.8389803 0.41110 1970 9938 19.822902 0.4330 3969 306 7.7097506 0.6153 0 0.0000000 0.2198 7 3741 0.1871157 0.2535 223 3741 5.960973 0.5483 0 9938 0 0.364
01001020600 01 001 020600 AL Alabama Autauga County 3 South Region 6 East South Central Division 3402 1456 1308 735 3402 21.60494 0.5199 134 1720 7.790698 0.5436 242 1032 23.44961 0.28010 62 276 22.46377 0.1035 304 1308 23.24159 0.14070 301 2151 13.993491 0.5510 355 3445 10.304790 0.3656 386 11.346267 0.4232 931 27.36626 0.7200 440 2439 18.04018 0.6912 143 924 15.476190 0.52900 4 3254 0.1229256 0.19840 723 3402 21.252205 0.4519 1456 18 1.2362637 0.3507 433 29.7390110 0.9468 16 1308 1.2232416 0.4493 28 1308 2.140673 0.2298 0 3402 0 0.364 
# National
svi_2020_national <- rank_variables(svi_2020)
svi_2020_national %>% head() %>% kbl() %>% kable_styling() %>% scroll_box(width = "100%")
GEOID_2010_trt FIPS_st FIPS_county FIPS_tract state state_name county region_number region division_number division E_TOTPOP_20 E_HU_20 E_HH_20 E_POV150_20 ET_POVSTATUS_20 EP_POV150_20 EPL_POV150_20 E_UNEMP_20 ET_EMPSTATUS_20 EP_UNEMP_20 EPL_UNEMP_20 E_HBURD_OWN_20 ET_HOUSINGCOST_OWN_20 EP_HBURD_OWN_20 EPL_HBURD_OWN_20 E_HBURD_RENT_20 ET_HOUSINGCOST_RENT_20 EP_HBURD_RENT_20 EPL_HBURD_RENT_20 E_HBURD_20 ET_HOUSINGCOST_20 EP_HBURD_20 EPL_HBURD_20 E_NOHSDP_20 ET_EDSTATUS_20 EP_NOHSDP_20 EPL_NOHSDP_20 E_UNINSUR_20 ET_INSURSTATUS_20 EP_UNINSUR_20 EPL_UNINSUR_20 E_AGE65_20 EP_AGE65_20 EPL_AGE65_20 E_AGE17_20 EP_AGE17_20 EPL_AGE17_20 E_DISABL_20 ET_DISABLSTATUS_20 EP_DISABL_20 EPL_DISABL_20 E_SNGPNT_20 ET_FAMILIES_20 EP_SNGPNT_20 EPL_SNGPNT_20 E_LIMENG_20 ET_POPAGE5UP_20 EP_LIMENG_20 EPL_LIMENG_20 E_MINRTY_20 ET_POPETHRACE_20 EP_MINRTY_20 EPL_MINRTY_20 E_STRHU_20 E_MUNIT_20 EP_MUNIT_20 EPL_MUNIT_20 E_MOBILE_20 EP_MOBILE_20 EPL_MOBILE_20 E_CROWD_20 ET_OCCUPANTS_20 EP_CROWD_20 EPL_CROWD_20 E_NOVEH_20 ET_KNOWNVEH_20 EP_NOVEH_20 EPL_NOVEH_20 E_GROUPQ_20 ET_HHTYPE_20 EP_GROUPQ_20 EPL_GROUPQ_20
01001020100 01 001 020100 AL Alabama Autauga County 3 South Region 6 East South Central Division 1941 710 693 352 1941 18.13498 0.4630 18 852 2.112676 0.15070 81 507 15.976331 0.26320 63 186 33.87097 0.2913 144 693 20.77922 0.2230 187 1309 14.285714 0.6928 187 1941 9.634209 0.6617 295 15.19835 0.4601 415 21.38073 0.4681 391 1526 25.62254 0.9011 58 555 10.45045 0.3451 0 1843 0.0000000 0.09479 437 1941 22.51417 0.3902 710 0 0.0000000 0.1079 88 12.3943662 0.8263 0 693 0.0000000 0.09796 10 693 1.443001 0.1643 0 1941 0.000000 0.1831
01001020200 01 001 020200 AL Alabama Autauga County 3 South Region 6 East South Central Division 1757 720 573 384 1511 25.41363 0.6427 29 717 4.044630 0.41320 33 392 8.418367 0.03542 116 181 64.08840 0.9086 149 573 26.00349 0.4041 139 1313 10.586443 0.5601 91 1533 5.936073 0.4343 284 16.16392 0.5169 325 18.49744 0.2851 164 1208 13.57616 0.4127 42 359 11.69916 0.3998 0 1651 0.0000000 0.09479 1116 1757 63.51736 0.7591 720 3 0.4166667 0.2470 5 0.6944444 0.5106 9 573 1.5706806 0.46880 57 573 9.947644 0.7317 212 1757 12.066022 0.9549
01001020300 01 001 020300 AL Alabama Autauga County 3 South Region 6 East South Central Division 3694 1464 1351 842 3694 22.79372 0.5833 53 1994 2.657974 0.22050 117 967 12.099276 0.11370 147 384 38.28125 0.3856 264 1351 19.54108 0.1827 317 2477 12.797739 0.6460 127 3673 3.457664 0.2308 464 12.56091 0.3088 929 25.14889 0.7080 473 2744 17.23761 0.6211 263 975 26.97436 0.8234 128 3586 3.5694367 0.70770 1331 3694 36.03140 0.5515 1464 26 1.7759563 0.3675 14 0.9562842 0.5389 35 1351 2.5906736 0.60550 42 1351 3.108808 0.3415 0 3694 0.000000 0.1831
01001020400 01 001 020400 AL Alabama Autauga County 3 South Region 6 East South Central Division 3539 1741 1636 503 3539 14.21305 0.3472 39 1658 2.352232 0.17990 219 1290 16.976744 0.30880 74 346 21.38728 0.1037 293 1636 17.90954 0.1333 173 2775 6.234234 0.3351 169 3529 4.788892 0.3448 969 27.38062 0.9225 510 14.41085 0.1208 670 3019 22.19278 0.8194 148 1137 13.01671 0.4541 89 3409 2.6107363 0.64690 454 3539 12.82848 0.2364 1741 143 8.2136703 0.6028 0 0.0000000 0.2186 10 1636 0.6112469 0.28340 72 1636 4.400978 0.4538 0 3539 0.000000 0.1831
01001020500 01 001 020500 AL Alabama Autauga County 3 South Region 6 East South Central Division 10674 4504 4424 1626 10509 15.47245 0.3851 81 5048 1.604596 0.09431 321 2299 13.962592 0.17970 711 2125 33.45882 0.2836 1032 4424 23.32731 0.3109 531 6816 7.790493 0.4251 301 10046 2.996217 0.1894 1613 15.11149 0.4553 2765 25.90407 0.7494 1124 7281 15.43744 0.5253 342 2912 11.74451 0.4019 52 9920 0.5241935 0.35230 2603 10674 24.38636 0.4160 4504 703 15.6083481 0.7378 29 0.6438721 0.5037 37 4424 0.8363472 0.33420 207 4424 4.679023 0.4754 176 10674 1.648866 0.7598
01001020600 01 001 020600 AL Alabama Autauga County 3 South Region 6 East South Central Division 3536 1464 1330 1279 3523 36.30429 0.8215 34 1223 2.780049 0.23780 321 1111 28.892889 0.75870 67 219 30.59361 0.2305 388 1330 29.17293 0.5075 306 2380 12.857143 0.6480 415 3496 11.870709 0.7535 547 15.46946 0.4760 982 27.77149 0.8327 729 2514 28.99761 0.9488 95 880 10.79545 0.3601 0 3394 0.0000000 0.09479 985 3536 27.85633 0.4608 1464 0 0.0000000 0.1079 364 24.8633880 0.9300 0 1330 0.0000000 0.09796 17 1330 1.278196 0.1463 0 3536 0.000000 0.1831 
# Regional
svi_2010_regional <- rank_variables(svi_2010, rank_by = "regional", location = "Midwest Region")
svi_2010_regional %>% head() %>% kbl() %>% kable_styling() %>% scroll_box(width = "100%")
GEOID_2010_trt FIPS_st FIPS_county FIPS_tract state state_name county region_number region division_number division E_TOTPOP_10 E_HU_10 E_HH_10 E_POV150_10 ET_POVSTATUS_10 EP_POV150_10 EPL_POV150_10 E_UNEMP_10 ET_EMPSTATUS_10 EP_UNEMP_10 EPL_UNEMP_10 E_HBURD_OWN_10 ET_HOUSINGCOST_OWN_10 EP_HBURD_OWN_10 EPL_HBURD_OWN_10 E_HBURD_RENT_10 ET_HOUSINGCOST_RENT_10 EP_HBURD_RENT_10 EPL_HBURD_RENT_10 E_HBURD_10 ET_HOUSINGCOST_10 EP_HBURD_10 EPL_HBURD_10 E_NOHSDP_10 ET_EDSTATUS_10 EP_NOHSDP_10 EPL_NOHSDP_10 E_UNINSUR_12 ET_INSURSTATUS_12 EP_UNINSUR_12 EPL_UNINSUR_12 E_AGE65_10 EP_AGE65_10 EPL_AGE65_10 E_AGE17_10 EP_AGE17_10 EPL_AGE17_10 E_DISABL_12 ET_DISABLSTATUS_12 EP_DISABL_12 EPL_DISABL_12 E_SNGPNT_10 ET_FAMILIES_10 EP_SNGPNT_10 EPL_SNGPNT_10 E_LIMENG_10 ET_POPAGE5UP_10 EP_LIMENG_10 EPL_LIMENG_10 E_MINRTY_10 ET_POPETHRACE_10 EP_MINRTY_10 EPL_MINRTY_10 E_STRHU_10 E_MUNIT_10 EP_MUNIT_10 EPL_MUNIT_10 E_MOBILE_10 EP_MOBILE_10 EPL_MOBILE_10 E_CROWD_10 ET_OCCUPANTS_10 EP_CROWD_10 EPL_CROWD_10 E_NOVEH_10 ET_KNOWNVEH_10 EP_NOVEH_10 EPL_NOVEH_10 E_GROUPQ_10 ET_HHTYPE_10 EP_GROUPQ_10 EPL_GROUPQ_10
17001000100 17 001 000100 IL Illinois Adams County 2 Midwest Region 3 East North Central Division 4647 2145 2129 919 4647 19.77620 0.4952 184 2312 7.958477 0.5437 247 1840 13.42391 0.04261 128 289 44.29066 0.5486 375 2129 17.61390 0.05217 251 3432 7.313520 0.28850 300 4791 6.261741 0.1976 1115 23.993975 0.9494 968 20.83064 0.2517 532 3828 13.89760 0.4409 105 1241 8.460919 0.2433 0 4388 0.0000000 0.1308 92 4647 1.979772 0.07373 2145 14 0.6526807 0.2837 107 4.988345 0.7234 0 2129 0.0000000 0.1437 98 2129 4.603100 0.4675 0 4647 0.000000 0.3446
17001000201 17 001 000201 IL Illinois Adams County 2 Midwest Region 3 East North Central Division 2198 870 843 702 2172 32.32044 0.7606 62 1122 5.525847 0.3209 110 675 16.29630 0.10180 103 168 61.30952 0.8678 213 843 25.26690 0.27500 201 1462 13.748290 0.63320 217 2021 10.737259 0.4918 362 16.469518 0.7158 520 23.65787 0.4595 382 1606 23.78580 0.8929 159 565 28.141593 0.8243 0 2043 0.0000000 0.1308 233 2198 10.600546 0.47250 870 0 0.0000000 0.1103 113 12.988506 0.8845 5 843 0.5931198 0.3857 77 843 9.134045 0.7087 69 2198 3.139217 0.8265
17001000202 17 001 000202 IL Illinois Adams County 2 Midwest Region 3 East North Central Division 3205 1136 1041 589 2573 22.89157 0.5834 79 1660 4.759036 0.2455 173 807 21.43742 0.28910 81 234 34.61538 0.3207 254 1041 24.39962 0.24080 170 1592 10.678392 0.48100 273 2767 9.866281 0.4347 276 8.611545 0.2040 556 17.34789 0.1091 265 1867 14.19389 0.4600 99 603 16.417910 0.5979 50 2925 1.7094017 0.7383 527 3205 16.443058 0.60000 1136 0 0.0000000 0.1103 6 0.528169 0.4843 0 1041 0.0000000 0.1437 32 1041 3.073967 0.3243 729 3205 22.745710 0.9748
17001000400 17 001 000400 IL Illinois Adams County 2 Midwest Region 3 East North Central Division 4525 1873 1537 2131 3831 55.62516 0.9421 255 1722 14.808362 0.8549 206 842 24.46556 0.42280 320 695 46.04317 0.5874 526 1537 34.22251 0.61930 699 3040 22.993421 0.86870 616 3657 16.844408 0.7817 992 21.922652 0.9146 998 22.05525 0.3345 597 2786 21.42857 0.8306 350 912 38.377193 0.9105 6 4268 0.1405811 0.2922 728 4525 16.088398 0.59470 1873 176 9.3966898 0.6950 68 3.630539 0.6802 62 1537 4.0338321 0.8747 212 1537 13.793103 0.8242 786 4525 17.370166 0.9659
17001000500 17 001 000500 IL Illinois Adams County 2 Midwest Region 3 East North Central Division 1766 949 735 423 1694 24.97048 0.6327 39 950 4.105263 0.1838 96 452 21.23894 0.28060 117 283 41.34276 0.4748 213 735 28.97959 0.42090 176 1123 15.672306 0.70550 180 1730 10.404624 0.4711 265 15.005662 0.6252 469 26.55719 0.6849 207 1325 15.62264 0.5561 92 440 20.909091 0.7089 0 1636 0.0000000 0.1308 245 1766 13.873160 0.55200 949 36 3.7934668 0.5110 36 3.793467 0.6855 13 735 1.7687075 0.6661 68 735 9.251701 0.7125 72 1766 4.077010 0.8572
17001000600 17 001 000600 IL Illinois Adams County 2 Midwest Region 3 East North Central Division 3739 1729 1583 660 3642 18.12191 0.4447 93 1750 5.314286 0.3012 147 1090 13.48624 0.04368 156 493 31.64300 0.2604 303 1583 19.14087 0.08114 74 2431 3.044015 0.08277 205 3706 5.531570 0.1542 559 14.950522 0.6223 988 26.42418 0.6768 331 2737 12.09353 0.3180 89 999 8.908909 0.2655 0 3372 0.0000000 0.1308 236 3739 6.311848 0.32330 1729 53 3.0653557 0.4730 0 0.000000 0.2232 0 1583 0.0000000 0.1437 56 1583 3.537587 0.3717 56 3739 1.497727 0.7458 
# Regional
svi_2020_regional <- rank_variables(svi_2020, rank_by = "regional", location = "Midwest Region")
svi_2020_regional %>% head() %>% kbl() %>% kable_styling() %>% scroll_box(width = "100%")
GEOID_2010_trt FIPS_st FIPS_county FIPS_tract state state_name county region_number region division_number division E_TOTPOP_20 E_HU_20 E_HH_20 E_POV150_20 ET_POVSTATUS_20 EP_POV150_20 EPL_POV150_20 E_UNEMP_20 ET_EMPSTATUS_20 EP_UNEMP_20 EPL_UNEMP_20 E_HBURD_OWN_20 ET_HOUSINGCOST_OWN_20 EP_HBURD_OWN_20 EPL_HBURD_OWN_20 E_HBURD_RENT_20 ET_HOUSINGCOST_RENT_20 EP_HBURD_RENT_20 EPL_HBURD_RENT_20 E_HBURD_20 ET_HOUSINGCOST_20 EP_HBURD_20 EPL_HBURD_20 E_NOHSDP_20 ET_EDSTATUS_20 EP_NOHSDP_20 EPL_NOHSDP_20 E_UNINSUR_20 ET_INSURSTATUS_20 EP_UNINSUR_20 EPL_UNINSUR_20 E_AGE65_20 EP_AGE65_20 EPL_AGE65_20 E_AGE17_20 EP_AGE17_20 EPL_AGE17_20 E_DISABL_20 ET_DISABLSTATUS_20 EP_DISABL_20 EPL_DISABL_20 E_SNGPNT_20 ET_FAMILIES_20 EP_SNGPNT_20 EPL_SNGPNT_20 E_LIMENG_20 ET_POPAGE5UP_20 EP_LIMENG_20 EPL_LIMENG_20 E_MINRTY_20 ET_POPETHRACE_20 EP_MINRTY_20 EPL_MINRTY_20 E_STRHU_20 E_MUNIT_20 EP_MUNIT_20 EPL_MUNIT_20 E_MOBILE_20 EP_MOBILE_20 EPL_MOBILE_20 E_CROWD_20 ET_OCCUPANTS_20 EP_CROWD_20 EPL_CROWD_20 E_NOVEH_20 ET_KNOWNVEH_20 EP_NOVEH_20 EPL_NOVEH_20 E_GROUPQ_20 ET_HHTYPE_20 EP_GROUPQ_20 EPL_GROUPQ_20
17001000100 17 001 000100 IL Illinois Adams County 2 Midwest Region 3 East North Central Division 4590 2389 2281 1009 4590 21.98257 0.5870 168 2314 7.260156 0.7687 167 1955 8.542200 0.047130 66 326 20.24540 0.1221 233 2281 10.21482 0.01523 319 3408 9.360329 0.5958 145 4585 3.162486 0.2405 1270 27.66885 0.9420 842 18.34423 0.2261 704 3743.465 18.80611 0.6848 207 1118.6373 18.50466 0.6509 0 4299 0.0000000 0.1426 425 4589.895 9.259471 0.3246 2389 12 0.5023022 0.2527 135 5.650900 0.7676 47 2281 2.0604998 0.6813 105 2280.685 4.603881 0.4640 19 4590 0.4139434 0.5229
17001000201 17 001 000201 IL Illinois Adams County 2 Midwest Region 3 East North Central Division 2003 892 835 391 2003 19.52072 0.5191 23 990 2.323232 0.2247 98 681 14.390602 0.291000 72 154 46.75325 0.6841 170 835 20.35928 0.32760 142 1365 10.402930 0.6495 129 2003 6.440340 0.5817 386 19.27109 0.6643 456 22.76585 0.5325 303 1547.000 19.58630 0.7211 127 534.0000 23.78277 0.7637 5 1863 0.2683843 0.4086 213 2003.000 10.634049 0.3691 892 6 0.6726457 0.2767 57 6.390135 0.7886 4 835 0.4790419 0.3248 37 835.000 4.431138 0.4500 27 2003 1.3479780 0.6817
17001000202 17 001 000202 IL Illinois Adams County 2 Midwest Region 3 East North Central Division 2391 1081 896 596 2383 25.01049 0.6592 97 1409 6.884315 0.7479 20 622 3.215434 0.005269 111 274 40.51095 0.5416 131 896 14.62054 0.09224 83 1541 5.386113 0.3214 260 2391 10.874111 0.8270 276 11.54329 0.2137 568 23.75575 0.6119 315 1823.000 17.27921 0.6046 133 523.0000 25.43021 0.7888 0 2225 0.0000000 0.1426 378 2391.000 15.809285 0.4927 1081 10 0.9250694 0.3030 15 1.387604 0.5936 0 896 0.0000000 0.1226 33 896.000 3.683036 0.3873 42 2391 1.7565872 0.7257
17001000400 17 001 000400 IL Illinois Adams County 2 Midwest Region 3 East North Central Division 3316 1642 1287 1179 3093 38.11833 0.8461 57 1356 4.203540 0.5048 165 694 23.775216 0.770500 190 593 32.04047 0.3376 355 1287 27.58353 0.62310 273 2312 11.807958 0.7130 134 3093 4.332363 0.3732 587 17.70205 0.5694 780 23.52232 0.5924 508 2312.543 21.96716 0.8128 171 682.0306 25.07219 0.7836 0 3160 0.0000000 0.1426 754 3315.648 22.740654 0.6120 1642 204 12.4238733 0.7353 35 2.131547 0.6432 9 1287 0.6993007 0.3966 285 1287.281 22.139685 0.9174 286 3316 8.6248492 0.9433
17001000500 17 001 000500 IL Illinois Adams County 2 Midwest Region 3 East North Central Division 2154 927 787 636 1867 34.06535 0.8039 31 839 3.694875 0.4346 31 461 6.724512 0.020720 210 326 64.41718 0.9398 241 787 30.62262 0.70780 162 1458 11.111111 0.6847 138 1883 7.328731 0.6495 433 20.10214 0.7085 504 23.39833 0.5829 467 1379.000 33.86512 0.9810 72 503.0000 14.31412 0.5135 10 2038 0.4906771 0.5040 356 2154.000 16.527391 0.5072 927 78 8.4142395 0.6488 19 2.049622 0.6389 11 787 1.3977128 0.5677 95 787.000 12.071156 0.7878 271 2154 12.5812442 0.9585
17001000600 17 001 000600 IL Illinois Adams County 2 Midwest Region 3 East North Central Division 4284 1914 1842 615 4228 14.54588 0.3618 144 2679 5.375140 0.6301 136 1081 12.580944 0.191800 291 761 38.23916 0.4841 427 1842 23.18132 0.45850 121 2932 4.126876 0.2239 176 4228 4.162725 0.3551 649 15.14939 0.4084 907 21.17180 0.4150 470 3350.000 14.02985 0.4044 162 1173.0000 13.81074 0.4956 0 4037 0.0000000 0.1426 355 4284.000 8.286648 0.2896 1914 12 0.6269592 0.2715 0 0.000000 0.2238 5 1842 0.2714441 0.2763 120 1842.000 6.514658 0.5921 64 4284 1.4939309 0.6985 
# Divisional
svi_2020_divisional <- rank_variables(svi_2020, rank_by = "divisional", location = "West North Central Division")
svi_2020_divisional %>% head() %>% kbl() %>% kable_styling() %>% scroll_box(width = "100%")
GEOID_2010_trt FIPS_st FIPS_county FIPS_tract state state_name county region_number region division_number division E_TOTPOP_20 E_HU_20 E_HH_20 E_POV150_20 ET_POVSTATUS_20 EP_POV150_20 EPL_POV150_20 E_UNEMP_20 ET_EMPSTATUS_20 EP_UNEMP_20 EPL_UNEMP_20 E_HBURD_OWN_20 ET_HOUSINGCOST_OWN_20 EP_HBURD_OWN_20 EPL_HBURD_OWN_20 E_HBURD_RENT_20 ET_HOUSINGCOST_RENT_20 EP_HBURD_RENT_20 EPL_HBURD_RENT_20 E_HBURD_20 ET_HOUSINGCOST_20 EP_HBURD_20 EPL_HBURD_20 E_NOHSDP_20 ET_EDSTATUS_20 EP_NOHSDP_20 EPL_NOHSDP_20 E_UNINSUR_20 ET_INSURSTATUS_20 EP_UNINSUR_20 EPL_UNINSUR_20 E_AGE65_20 EP_AGE65_20 EPL_AGE65_20 E_AGE17_20 EP_AGE17_20 EPL_AGE17_20 E_DISABL_20 ET_DISABLSTATUS_20 EP_DISABL_20 EPL_DISABL_20 E_SNGPNT_20 ET_FAMILIES_20 EP_SNGPNT_20 EPL_SNGPNT_20 E_LIMENG_20 ET_POPAGE5UP_20 EP_LIMENG_20 EPL_LIMENG_20 E_MINRTY_20 ET_POPETHRACE_20 EP_MINRTY_20 EPL_MINRTY_20 E_STRHU_20 E_MUNIT_20 EP_MUNIT_20 EPL_MUNIT_20 E_MOBILE_20 EP_MOBILE_20 EPL_MOBILE_20 E_CROWD_20 ET_OCCUPANTS_20 EP_CROWD_20 EPL_CROWD_20 E_NOVEH_20 ET_KNOWNVEH_20 EP_NOVEH_20 EPL_NOVEH_20 E_GROUPQ_20 ET_HHTYPE_20 EP_GROUPQ_20 EPL_GROUPQ_20
19001960100 19 001 960100 IA Iowa Adair County 2 Midwest Region 4 West North Central Division 2696 1321 1147 446 2620 17.02290 0.4674 57 1327 4.295403 0.6347 82 805 10.18634 0.1094 91 342 26.60819 0.27250 173 1147 15.08282 0.1312 98 1915 5.117494 0.3416 96 2634 3.644647 0.2718 470 17.43323 0.5283 681 25.25964 0.67830 468 1953.000 23.96313 0.8975 108 802.0000 13.466334 0.5180 2 2480 0.0806452 0.2987 184 2696.000 6.824926 0.25140 1321 23 1.741105 0.3456 53 4.012112 0.6591 8 1147 0.6974717 0.36640 23 1147.0000 2.0052310 0.2452 70 2696 2.5964392 0.7626
19001960200 19 001 960200 IA Iowa Adair County 2 Midwest Region 4 West North Central Division 1591 831 675 333 1586 20.99622 0.5984 73 880 8.295454 0.8994 61 552 11.05072 0.1443 23 123 18.69919 0.13460 84 675 12.44444 0.0521 55 1207 4.556752 0.2930 41 1591 2.576996 0.1604 397 24.95286 0.8937 323 20.30170 0.28690 209 1268.000 16.48265 0.6031 37 514.9999 7.184467 0.1910 0 1501 0.0000000 0.1327 70 1591.000 4.399749 0.12080 831 0 0.000000 0.0847 23 2.767750 0.5935 6 675 0.8888889 0.42290 20 674.9999 2.9629634 0.3631 0 1591 0.0000000 0.1414
19001960300 19 001 960300 IA Iowa Adair County 2 Midwest Region 4 West North Central Division 2761 1557 1395 609 2680 22.72388 0.6444 85 1424 5.969101 0.7924 149 893 16.68533 0.4990 100 502 19.92032 0.14970 249 1395 17.84946 0.2643 100 1979 5.053057 0.3352 178 2687 6.624488 0.5488 710 25.71532 0.9134 503 18.21804 0.17430 308 2184.000 14.10256 0.4324 119 701.0001 16.975747 0.6508 0 2665 0.0000000 0.1327 77 2761.000 2.788844 0.04330 1557 66 4.238921 0.4935 24 1.541426 0.5095 2 1395 0.1433692 0.21350 50 1395.0001 3.5842292 0.4306 74 2761 2.6801883 0.7695
19003950100 19 003 950100 IA Iowa Adams County 2 Midwest Region 4 West North Central Division 1616 835 704 315 1616 19.49257 0.5546 20 799 2.503129 0.3503 123 607 20.26359 0.7262 22 97 22.68041 0.19570 145 704 20.59659 0.4132 54 1146 4.712042 0.3048 172 1616 10.643564 0.7664 344 21.28713 0.7518 348 21.53465 0.38090 234 1268.000 18.45426 0.7099 45 483.0000 9.316770 0.3080 0 1486 0.0000000 0.1327 36 1616.000 2.227723 0.02773 835 0 0.000000 0.0847 48 5.748503 0.7266 4 704 0.5681818 0.31830 6 704.0000 0.8522727 0.1052 5 1616 0.3094059 0.4088
19003950200 19 003 950200 IA Iowa Adams County 2 Midwest Region 4 West North Central Division 2017 1176 923 373 1939 19.23672 0.5455 43 965 4.455959 0.6531 115 708 16.24294 0.4644 30 215 13.95349 0.07616 145 923 15.70964 0.1595 123 1504 8.178192 0.5864 64 1957 3.270312 0.2338 492 24.39266 0.8773 399 19.78185 0.25290 276 1558.000 17.71502 0.6695 44 526.0000 8.365019 0.2549 5 1932 0.2587992 0.4007 101 2017.000 5.007437 0.15670 1176 16 1.360544 0.3160 31 2.636054 0.5846 8 923 0.8667389 0.41620 60 923.0000 6.5005417 0.6597 130 2017 6.4452157 0.9140
19005960100 19 005 960100 IA Iowa Allamakee County 2 Midwest Region 4 West North Central Division 1952 1507 1006 385 1894 20.32735 0.5771 28 1021 2.742409 0.3986 268 768 34.89583 0.9800 70 237 29.53587 0.33660 338 1005 33.63184 0.8465 91 1549 5.874758 0.4071 46 1906 2.413431 0.1475 592 30.32787 0.9768 265 13.57582 0.05754 237 1641.126 14.44131 0.4573 56 570.1656 9.821708 0.3375 0 1885 0.0000000 0.1327 104 1951.984 5.327911 0.17410 1507 88 5.839416 0.5589 204 13.536828 0.9002 0 1006 0.0000000 0.09916 26 1005.8033 2.5849984 0.3196 44 1952 2.2540984 0.7328 
# Divisional
svi_2020_divisional <- rank_variables(svi_2020, rank_by = "divisional", location = "West North Central Division")
svi_2020_divisional %>% head() %>% kbl() %>% kable_styling() %>% scroll_box(width = "100%")
GEOID_2010_trt FIPS_st FIPS_county FIPS_tract state state_name county region_number region division_number division E_TOTPOP_20 E_HU_20 E_HH_20 E_POV150_20 ET_POVSTATUS_20 EP_POV150_20 EPL_POV150_20 E_UNEMP_20 ET_EMPSTATUS_20 EP_UNEMP_20 EPL_UNEMP_20 E_HBURD_OWN_20 ET_HOUSINGCOST_OWN_20 EP_HBURD_OWN_20 EPL_HBURD_OWN_20 E_HBURD_RENT_20 ET_HOUSINGCOST_RENT_20 EP_HBURD_RENT_20 EPL_HBURD_RENT_20 E_HBURD_20 ET_HOUSINGCOST_20 EP_HBURD_20 EPL_HBURD_20 E_NOHSDP_20 ET_EDSTATUS_20 EP_NOHSDP_20 EPL_NOHSDP_20 E_UNINSUR_20 ET_INSURSTATUS_20 EP_UNINSUR_20 EPL_UNINSUR_20 E_AGE65_20 EP_AGE65_20 EPL_AGE65_20 E_AGE17_20 EP_AGE17_20 EPL_AGE17_20 E_DISABL_20 ET_DISABLSTATUS_20 EP_DISABL_20 EPL_DISABL_20 E_SNGPNT_20 ET_FAMILIES_20 EP_SNGPNT_20 EPL_SNGPNT_20 E_LIMENG_20 ET_POPAGE5UP_20 EP_LIMENG_20 EPL_LIMENG_20 E_MINRTY_20 ET_POPETHRACE_20 EP_MINRTY_20 EPL_MINRTY_20 E_STRHU_20 E_MUNIT_20 EP_MUNIT_20 EPL_MUNIT_20 E_MOBILE_20 EP_MOBILE_20 EPL_MOBILE_20 E_CROWD_20 ET_OCCUPANTS_20 EP_CROWD_20 EPL_CROWD_20 E_NOVEH_20 ET_KNOWNVEH_20 EP_NOVEH_20 EPL_NOVEH_20 E_GROUPQ_20 ET_HHTYPE_20 EP_GROUPQ_20 EPL_GROUPQ_20
19001960100 19 001 960100 IA Iowa Adair County 2 Midwest Region 4 West North Central Division 2696 1321 1147 446 2620 17.02290 0.4674 57 1327 4.295403 0.6347 82 805 10.18634 0.1094 91 342 26.60819 0.27250 173 1147 15.08282 0.1312 98 1915 5.117494 0.3416 96 2634 3.644647 0.2718 470 17.43323 0.5283 681 25.25964 0.67830 468 1953.000 23.96313 0.8975 108 802.0000 13.466334 0.5180 2 2480 0.0806452 0.2987 184 2696.000 6.824926 0.25140 1321 23 1.741105 0.3456 53 4.012112 0.6591 8 1147 0.6974717 0.36640 23 1147.0000 2.0052310 0.2452 70 2696 2.5964392 0.7626
19001960200 19 001 960200 IA Iowa Adair County 2 Midwest Region 4 West North Central Division 1591 831 675 333 1586 20.99622 0.5984 73 880 8.295454 0.8994 61 552 11.05072 0.1443 23 123 18.69919 0.13460 84 675 12.44444 0.0521 55 1207 4.556752 0.2930 41 1591 2.576996 0.1604 397 24.95286 0.8937 323 20.30170 0.28690 209 1268.000 16.48265 0.6031 37 514.9999 7.184467 0.1910 0 1501 0.0000000 0.1327 70 1591.000 4.399749 0.12080 831 0 0.000000 0.0847 23 2.767750 0.5935 6 675 0.8888889 0.42290 20 674.9999 2.9629634 0.3631 0 1591 0.0000000 0.1414
19001960300 19 001 960300 IA Iowa Adair County 2 Midwest Region 4 West North Central Division 2761 1557 1395 609 2680 22.72388 0.6444 85 1424 5.969101 0.7924 149 893 16.68533 0.4990 100 502 19.92032 0.14970 249 1395 17.84946 0.2643 100 1979 5.053057 0.3352 178 2687 6.624488 0.5488 710 25.71532 0.9134 503 18.21804 0.17430 308 2184.000 14.10256 0.4324 119 701.0001 16.975747 0.6508 0 2665 0.0000000 0.1327 77 2761.000 2.788844 0.04330 1557 66 4.238921 0.4935 24 1.541426 0.5095 2 1395 0.1433692 0.21350 50 1395.0001 3.5842292 0.4306 74 2761 2.6801883 0.7695
19003950100 19 003 950100 IA Iowa Adams County 2 Midwest Region 4 West North Central Division 1616 835 704 315 1616 19.49257 0.5546 20 799 2.503129 0.3503 123 607 20.26359 0.7262 22 97 22.68041 0.19570 145 704 20.59659 0.4132 54 1146 4.712042 0.3048 172 1616 10.643564 0.7664 344 21.28713 0.7518 348 21.53465 0.38090 234 1268.000 18.45426 0.7099 45 483.0000 9.316770 0.3080 0 1486 0.0000000 0.1327 36 1616.000 2.227723 0.02773 835 0 0.000000 0.0847 48 5.748503 0.7266 4 704 0.5681818 0.31830 6 704.0000 0.8522727 0.1052 5 1616 0.3094059 0.4088
19003950200 19 003 950200 IA Iowa Adams County 2 Midwest Region 4 West North Central Division 2017 1176 923 373 1939 19.23672 0.5455 43 965 4.455959 0.6531 115 708 16.24294 0.4644 30 215 13.95349 0.07616 145 923 15.70964 0.1595 123 1504 8.178192 0.5864 64 1957 3.270312 0.2338 492 24.39266 0.8773 399 19.78185 0.25290 276 1558.000 17.71502 0.6695 44 526.0000 8.365019 0.2549 5 1932 0.2587992 0.4007 101 2017.000 5.007437 0.15670 1176 16 1.360544 0.3160 31 2.636054 0.5846 8 923 0.8667389 0.41620 60 923.0000 6.5005417 0.6597 130 2017 6.4452157 0.9140
19005960100 19 005 960100 IA Iowa Allamakee County 2 Midwest Region 4 West North Central Division 1952 1507 1006 385 1894 20.32735 0.5771 28 1021 2.742409 0.3986 268 768 34.89583 0.9800 70 237 29.53587 0.33660 338 1005 33.63184 0.8465 91 1549 5.874758 0.4071 46 1906 2.413431 0.1475 592 30.32787 0.9768 265 13.57582 0.05754 237 1641.126 14.44131 0.4573 56 570.1656 9.821708 0.3375 0 1885 0.0000000 0.1327 104 1951.984 5.327911 0.17410 1507 88 5.839416 0.5589 204 13.536828 0.9002 0 1006 0.0000000 0.09916 26 1005.8033 2.5849984 0.3196 44 1952 2.2540984 0.7328 
# State
svi_2010_state <- rank_variables(svi_2010, rank_by = "state", location = "MO")
svi_2010_state %>% head() %>% kbl() %>% kable_styling() %>% scroll_box(width = "100%")
GEOID_2010_trt FIPS_st FIPS_county FIPS_tract state state_name county region_number region division_number division E_TOTPOP_10 E_HU_10 E_HH_10 E_POV150_10 ET_POVSTATUS_10 EP_POV150_10 EPL_POV150_10 E_UNEMP_10 ET_EMPSTATUS_10 EP_UNEMP_10 EPL_UNEMP_10 E_HBURD_OWN_10 ET_HOUSINGCOST_OWN_10 EP_HBURD_OWN_10 EPL_HBURD_OWN_10 E_HBURD_RENT_10 ET_HOUSINGCOST_RENT_10 EP_HBURD_RENT_10 EPL_HBURD_RENT_10 E_HBURD_10 ET_HOUSINGCOST_10 EP_HBURD_10 EPL_HBURD_10 E_NOHSDP_10 ET_EDSTATUS_10 EP_NOHSDP_10 EPL_NOHSDP_10 E_UNINSUR_12 ET_INSURSTATUS_12 EP_UNINSUR_12 EPL_UNINSUR_12 E_AGE65_10 EP_AGE65_10 EPL_AGE65_10 E_AGE17_10 EP_AGE17_10 EPL_AGE17_10 E_DISABL_12 ET_DISABLSTATUS_12 EP_DISABL_12 EPL_DISABL_12 E_SNGPNT_10 ET_FAMILIES_10 EP_SNGPNT_10 EPL_SNGPNT_10 E_LIMENG_10 ET_POPAGE5UP_10 EP_LIMENG_10 EPL_LIMENG_10 E_MINRTY_10 ET_POPETHRACE_10 EP_MINRTY_10 EPL_MINRTY_10 E_STRHU_10 E_MUNIT_10 EP_MUNIT_10 EPL_MUNIT_10 E_MOBILE_10 EP_MOBILE_10 EPL_MOBILE_10 E_CROWD_10 ET_OCCUPANTS_10 EP_CROWD_10 EPL_CROWD_10 E_NOVEH_10 ET_KNOWNVEH_10 EP_NOVEH_10 EPL_NOVEH_10 E_GROUPQ_10 ET_HHTYPE_10 EP_GROUPQ_10 EPL_GROUPQ_10
29001950100 29 001 950100 MO Missouri Adair County 2 Midwest Region 4 West North Central Division 3538 1708 1397 992 3531 28.09402 0.6102 118 1693 6.969876 0.5122 205 1195 17.15481 0.17390 68 202 33.66337 0.3321 273 1397 19.54188 0.12610 212 2480 8.548387 0.2716 655 3540 18.50282 0.7650 446 12.605992 0.4416 878 24.81628 0.54900 416 2589 16.06798 0.4225 87 1115 7.802691 0.1573 37 3295 1.1229135 0.7536 43 3538 1.215376 0.03242 1708 2 0.117096 0.2601 231 13.524590 0.7875 20 1397 1.4316392 0.5785 75 1397 5.368647 0.5159 0 3538 0.000000 0.3278
29001950200 29 001 950200 MO Missouri Adair County 2 Midwest Region 4 West North Central Division 3209 1550 1224 833 3206 25.98253 0.5569 110 1460 7.534247 0.5627 122 1052 11.59696 0.03261 77 172 44.76744 0.6151 199 1224 16.25817 0.03746 319 2107 15.140009 0.5742 611 3164 19.31100 0.7952 501 15.612340 0.6419 932 29.04332 0.85090 548 2370 23.12236 0.7844 83 939 8.839191 0.2107 0 2966 0.0000000 0.1574 255 3209 7.946401 0.41930 1550 0 0.000000 0.1243 213 13.741936 0.7939 75 1224 6.1274510 0.9661 68 1224 5.555556 0.5360 0 3209 0.000000 0.3278
29001950300 29 001 950300 MO Missouri Adair County 2 Midwest Region 4 West North Central Division 3138 1682 1476 1837 3138 58.54047 0.9661 111 1468 7.561308 0.5670 178 607 29.32455 0.78620 546 869 62.83084 0.9110 724 1476 49.05149 0.94160 212 1611 13.159528 0.4769 484 2730 17.72894 0.7354 319 10.165711 0.2781 463 14.75462 0.07061 469 2319 20.22423 0.6698 113 688 16.424419 0.5859 0 2989 0.0000000 0.1574 199 3138 6.341619 0.35300 1682 223 13.258026 0.8163 114 6.777646 0.6455 10 1476 0.6775068 0.3833 179 1476 12.127371 0.8112 0 3138 0.000000 0.3278
29001950400 29 001 950400 MO Missouri Adair County 2 Midwest Region 4 West North Central Division 4071 1798 1725 1010 4061 24.87072 0.5259 98 1926 5.088266 0.2997 140 1167 11.99657 0.03986 274 558 49.10394 0.7156 414 1725 24.00000 0.31950 184 2675 6.878505 0.1967 459 4040 11.36139 0.3994 627 15.401621 0.6282 1038 25.49742 0.60300 566 3081 18.37066 0.5847 141 1121 12.578055 0.4221 0 3711 0.0000000 0.1574 168 4071 4.126750 0.22550 1798 92 5.116796 0.6592 49 2.725250 0.5403 4 1725 0.2318841 0.2853 125 1725 7.246377 0.6362 0 4071 0.000000 0.3278
29001950500 29 001 950500 MO Missouri Adair County 2 Midwest Region 4 West North Central Division 6522 3275 2783 2223 6173 36.01166 0.7723 207 3200 6.468750 0.4669 270 1551 17.40812 0.18260 743 1232 60.30844 0.8936 1013 2783 36.39957 0.77090 612 3912 15.644172 0.5937 757 6744 11.22479 0.3915 1056 16.191352 0.6830 1229 18.84391 0.16430 891 5204 17.12145 0.4968 182 1456 12.500000 0.4152 12 6193 0.1937672 0.3775 668 6522 10.242257 0.50790 3275 197 6.015267 0.6852 237 7.236641 0.6556 74 2783 2.6590011 0.7767 257 2783 9.234639 0.7277 436 6522 6.685066 0.9071
29001950900 29 001 950900 MO Missouri Adair County 2 Midwest Region 4 West North Central Division 2171 1173 922 1353 2171 62.32151 0.9805 42 1258 3.338633 0.1131 61 281 21.70819 0.41590 408 641 63.65055 0.9161 469 922 50.86768 0.95890 86 845 10.177515 0.3458 390 2094 18.62464 0.7686 172 7.922616 0.1484 411 18.93137 0.17070 187 1714 10.91015 0.1658 64 312 20.512821 0.7002 0 2050 0.0000000 0.1574 166 2171 7.646246 0.40710 1173 31 2.642796 0.5223 30 2.557545 0.5339 6 922 0.6507592 0.3739 105 922 11.388286 0.7939 0 2171 0.000000 0.3278 
# State
svi_2020_state <- rank_variables(svi_2020, rank_by = "state", location = "MO")
svi_2020_state %>% head() %>% kbl() %>% kable_styling() %>% scroll_box(width = "100%")
GEOID_2010_trt FIPS_st FIPS_county FIPS_tract state state_name county region_number region division_number division E_TOTPOP_20 E_HU_20 E_HH_20 E_POV150_20 ET_POVSTATUS_20 EP_POV150_20 EPL_POV150_20 E_UNEMP_20 ET_EMPSTATUS_20 EP_UNEMP_20 EPL_UNEMP_20 E_HBURD_OWN_20 ET_HOUSINGCOST_OWN_20 EP_HBURD_OWN_20 EPL_HBURD_OWN_20 E_HBURD_RENT_20 ET_HOUSINGCOST_RENT_20 EP_HBURD_RENT_20 EPL_HBURD_RENT_20 E_HBURD_20 ET_HOUSINGCOST_20 EP_HBURD_20 EPL_HBURD_20 E_NOHSDP_20 ET_EDSTATUS_20 EP_NOHSDP_20 EPL_NOHSDP_20 E_UNINSUR_20 ET_INSURSTATUS_20 EP_UNINSUR_20 EPL_UNINSUR_20 E_AGE65_20 EP_AGE65_20 EPL_AGE65_20 E_AGE17_20 EP_AGE17_20 EPL_AGE17_20 E_DISABL_20 ET_DISABLSTATUS_20 EP_DISABL_20 EPL_DISABL_20 E_SNGPNT_20 ET_FAMILIES_20 EP_SNGPNT_20 EPL_SNGPNT_20 E_LIMENG_20 ET_POPAGE5UP_20 EP_LIMENG_20 EPL_LIMENG_20 E_MINRTY_20 ET_POPETHRACE_20 EP_MINRTY_20 EPL_MINRTY_20 E_STRHU_20 E_MUNIT_20 EP_MUNIT_20 EPL_MUNIT_20 E_MOBILE_20 EP_MOBILE_20 EPL_MOBILE_20 E_CROWD_20 ET_OCCUPANTS_20 EP_CROWD_20 EPL_CROWD_20 E_NOVEH_20 ET_KNOWNVEH_20 EP_NOVEH_20 EPL_NOVEH_20 E_GROUPQ_20 ET_HHTYPE_20 EP_GROUPQ_20 EPL_GROUPQ_20
29001950100 29 001 950100 MO Missouri Adair County 2 Midwest Region 4 West North Central Division 3694 1687 1302 745 3660 20.35519 0.4536 103 1772 5.812641 0.7012 176 1191 14.777498 0.36030 3 111 2.702703 0.01587 179 1302 13.74808 0.07703 342 2393 14.291684 0.7603 460 3694 12.452626 0.6976 704 19.057932 0.65510 839 22.71251 0.50900 415 2855 14.53590 0.3290 30 946 3.171247 0.03818 0 3396 0.0000000 0.1807 220 3694 5.955604 0.2023 1687 1 0.0592768 0.2232 232 13.752223 0.8431 7 1302 0.5376344 0.3189 62 1302 4.761905 0.4867 0 3694 0.0000000 0.1681
29001950200 29 001 950200 MO Missouri Adair County 2 Midwest Region 4 West North Central Division 3024 1700 1085 844 3024 27.91005 0.6537 44 1354 3.249631 0.3996 168 939 17.891374 0.57040 36 146 24.657534 0.20240 204 1085 18.80184 0.28010 204 2048 9.960938 0.5493 383 3024 12.665344 0.7106 563 18.617725 0.62560 759 25.09921 0.70410 438 2265 19.33775 0.6048 51 797 6.398996 0.13470 9 2723 0.3305178 0.5385 245 3024 8.101852 0.3153 1700 3 0.1764706 0.2412 263 15.470588 0.8683 6 1085 0.5529954 0.3261 55 1085 5.069124 0.5076 0 3024 0.0000000 0.1681
29001950300 29 001 950300 MO Missouri Adair County 2 Midwest Region 4 West North Central Division 3247 1923 1354 1708 3197 53.42509 0.9611 40 1679 2.382370 0.2549 73 444 16.441441 0.45920 532 910 58.461539 0.91490 605 1354 44.68242 0.94460 276 1849 14.926988 0.7811 323 3174 10.176433 0.5551 406 12.503850 0.21670 378 11.64152 0.05472 676 2784 24.28161 0.8071 102 468 21.794872 0.73990 12 3097 0.3874717 0.5688 152 3247 4.681244 0.1411 1923 145 7.5403016 0.7027 181 9.412377 0.7423 17 1354 1.2555391 0.5155 181 1354 13.367799 0.8416 64 3247 1.9710502 0.7084
29001950400 29 001 950400 MO Missouri Adair County 2 Midwest Region 4 West North Central Division 3765 1864 1754 1161 3736 31.07602 0.7142 129 1825 7.068493 0.7970 310 1167 26.563839 0.89600 218 587 37.137990 0.48270 528 1754 30.10262 0.72500 113 2544 4.441824 0.2174 140 3736 3.747323 0.1469 743 19.734396 0.69110 902 23.95750 0.61770 453 2856 15.86134 0.4111 148 913 16.210296 0.56840 68 3486 1.9506598 0.8683 425 3765 11.288181 0.4399 1864 10 0.5364807 0.3031 38 2.038627 0.5385 16 1754 0.9122007 0.4327 148 1754 8.437856 0.7120 35 3765 0.9296149 0.5702
29001950500 29 001 950500 MO Missouri Adair County 2 Midwest Region 4 West North Central Division 6963 3233 2633 2114 6644 31.81818 0.7322 167 2974 5.615333 0.6890 168 1430 11.748252 0.17760 526 1203 43.724023 0.64570 694 2633 26.35777 0.61770 187 3569 5.239563 0.2664 446 6791 6.567516 0.3161 1100 15.797788 0.43630 1428 20.50840 0.33910 682 5245 13.00286 0.2491 263 1311 20.061022 0.69020 251 6547 3.8338170 0.9474 1138 6963 16.343530 0.5702 3233 156 4.8252397 0.6112 203 6.278998 0.6717 0 2633 0.0000000 0.1102 141 2633 5.355108 0.5356 476 6963 6.8361339 0.9230
29001950900 29 001 950900 MO Missouri Adair County 2 Midwest Region 4 West North Central Division 2605 1181 943 1216 2605 46.67946 0.9258 159 1344 11.830357 0.9388 26 418 6.220096 0.01877 242 525 46.095238 0.70270 268 943 28.41994 0.68250 96 1306 7.350689 0.3852 277 2605 10.633397 0.5882 235 9.021113 0.08279 462 17.73512 0.19370 353 2143 16.47224 0.4550 46 458 10.043668 0.30760 33 2506 1.3168396 0.7977 211 2605 8.099808 0.3146 1181 49 4.1490262 0.5817 0 0.000000 0.1814 9 943 0.9544008 0.4420 74 943 7.847296 0.6890 0 2605 0.0000000 0.1681 
# County
svi_2010_county <- rank_variables(svi_2010, rank_by = "county", location = "Jackson County", state_abbr = "MO")
svi_2010_county %>% head() %>% kbl() %>% kable_styling() %>% scroll_box(width = "100%")
GEOID_2010_trt FIPS_st FIPS_county FIPS_tract state state_name county region_number region division_number division E_TOTPOP_10 E_HU_10 E_HH_10 E_POV150_10 ET_POVSTATUS_10 EP_POV150_10 EPL_POV150_10 E_UNEMP_10 ET_EMPSTATUS_10 EP_UNEMP_10 EPL_UNEMP_10 E_HBURD_OWN_10 ET_HOUSINGCOST_OWN_10 EP_HBURD_OWN_10 EPL_HBURD_OWN_10 E_HBURD_RENT_10 ET_HOUSINGCOST_RENT_10 EP_HBURD_RENT_10 EPL_HBURD_RENT_10 E_HBURD_10 ET_HOUSINGCOST_10 EP_HBURD_10 EPL_HBURD_10 E_NOHSDP_10 ET_EDSTATUS_10 EP_NOHSDP_10 EPL_NOHSDP_10 E_UNINSUR_12 ET_INSURSTATUS_12 EP_UNINSUR_12 EPL_UNINSUR_12 E_AGE65_10 EP_AGE65_10 EPL_AGE65_10 E_AGE17_10 EP_AGE17_10 EPL_AGE17_10 E_DISABL_12 ET_DISABLSTATUS_12 EP_DISABL_12 EPL_DISABL_12 E_SNGPNT_10 ET_FAMILIES_10 EP_SNGPNT_10 EPL_SNGPNT_10 E_LIMENG_10 ET_POPAGE5UP_10 EP_LIMENG_10 EPL_LIMENG_10 E_MINRTY_10 ET_POPETHRACE_10 EP_MINRTY_10 EPL_MINRTY_10 E_STRHU_10 E_MUNIT_10 EP_MUNIT_10 EPL_MUNIT_10 E_MOBILE_10 EP_MOBILE_10 EPL_MOBILE_10 E_CROWD_10 ET_OCCUPANTS_10 EP_CROWD_10 EPL_CROWD_10 E_NOVEH_10 ET_KNOWNVEH_10 EP_NOVEH_10 EPL_NOVEH_10 E_GROUPQ_10 ET_HHTYPE_10 EP_GROUPQ_10 EPL_GROUPQ_10
29095000300 29 095 000300 MO Missouri Jackson County 2 Midwest Region 4 West North Central Division 1886 793 761 972 1886 51.53765 0.8557 156 831 18.772563 0.8814 20 188 10.63830 0.01546 273 573 47.64398 0.5521 293 761 38.50197 0.6134 272 1190 22.85714 0.8144 359 1832 19.59607 0.5949 230 12.195122 0.56700 545 28.89714 0.7680 197 1269 15.52403 0.4718 141 405 34.81481 0.7474 124 1727 7.180081 0.9124 1139 1886 60.39236 0.6804 793 79 9.962169 0.6082 11 1.3871375 0.8144 0 761 0.000000 0.2088 97 761 12.74639 0.6546 0 1886 0.0000000 0.3814
29095000600 29 095 000600 MO Missouri Jackson County 2 Midwest Region 4 West North Central Division 4408 1812 1488 2141 4352 49.19577 0.8247 270 1912 14.121339 0.7577 262 873 30.01145 0.64950 468 615 76.09756 0.9635 730 1488 49.05914 0.8969 1066 2625 40.60952 0.9691 1278 4025 31.75155 0.9128 352 7.985481 0.29380 1445 32.78131 0.8918 607 2670 22.73408 0.7846 267 1017 26.25369 0.5928 986 3953 24.943081 0.9897 2636 4408 59.80036 0.6701 1812 62 3.421634 0.4433 0 0.0000000 0.3325 114 1488 7.661290 0.9588 195 1488 13.10484 0.6598 0 4408 0.0000000 0.3814
29095000700 29 095 000700 MO Missouri Jackson County 2 Midwest Region 4 West North Central Division 4381 1616 1324 2137 4269 50.05856 0.8402 297 1974 15.045593 0.7990 202 739 27.33424 0.54120 275 585 47.00855 0.5365 477 1324 36.02719 0.5412 839 2455 34.17515 0.9278 979 3750 26.10667 0.8154 301 6.870577 0.19070 1511 34.48984 0.9330 405 2546 15.90731 0.4923 307 843 36.41756 0.7629 683 3921 17.419026 0.9691 3081 4381 70.32641 0.7371 1616 162 10.024752 0.6134 0 0.0000000 0.3325 116 1324 8.761329 0.9897 216 1324 16.31420 0.7371 70 4381 1.5978087 0.8093
29095000800 29 095 000800 MO Missouri Jackson County 2 Midwest Region 4 West North Central Division 4488 1650 1451 2364 4448 53.14748 0.8814 286 2202 12.988193 0.7216 276 921 29.96743 0.63920 301 530 56.79245 0.7552 577 1451 39.76568 0.6856 959 2625 36.53333 0.9485 1721 4171 41.26109 0.9897 343 7.642602 0.27320 1335 29.74599 0.8093 465 2908 15.99037 0.5077 260 1072 24.25373 0.5258 652 4104 15.886940 0.9536 3226 4488 71.88057 0.7526 1650 27 1.636364 0.3247 9 0.5454545 0.6856 81 1451 5.582357 0.9278 158 1451 10.88904 0.5876 42 4488 0.9358289 0.7732
29095000900 29 095 000900 MO Missouri Jackson County 2 Midwest Region 4 West North Central Division 3273 1578 1092 1481 3273 45.24901 0.7835 137 1833 7.474086 0.4381 89 635 14.01575 0.03608 241 457 52.73523 0.6719 330 1092 30.21978 0.3402 822 2137 38.46514 0.9588 1272 3063 41.52791 0.9949 128 3.910785 0.03093 875 26.73388 0.6031 481 2226 21.60827 0.7436 162 578 28.02768 0.6289 682 2926 23.308271 0.9845 2210 3273 67.52215 0.7216 1578 104 6.590621 0.5361 0 0.0000000 0.3325 94 1092 8.608059 0.9794 166 1092 15.20147 0.7113 0 3273 0.0000000 0.3814
29095001000 29 095 001000 MO Missouri Jackson County 2 Midwest Region 4 West North Central Division 2968 1551 1068 1888 2968 63.61186 0.9691 294 1429 20.573828 0.9021 169 402 42.03980 0.91750 340 666 51.05105 0.6042 509 1068 47.65918 0.8557 590 1758 33.56086 0.9227 885 2594 34.11719 0.9436 212 7.142857 0.22940 924 31.13208 0.8557 220 1834 11.99564 0.3077 291 598 48.66221 0.9278 379 2699 14.042238 0.9433 2167 2968 73.01213 0.7629 1551 344 22.179239 0.8247 0 0.0000000 0.3325 48 1068 4.494382 0.8814 241 1068 22.56554 0.8505 0 2968 0.0000000 0.3814 
# County
svi_2020_county <- rank_variables(svi_2020, rank_by = "county", location = "Jackson County", state = "MO")
svi_2020_county %>% head() %>% kbl() %>% kable_styling() %>% scroll_box(width = "100%")
GEOID_2010_trt FIPS_st FIPS_county FIPS_tract state state_name county region_number region division_number division E_TOTPOP_20 E_HU_20 E_HH_20 E_POV150_20 ET_POVSTATUS_20 EP_POV150_20 EPL_POV150_20 E_UNEMP_20 ET_EMPSTATUS_20 EP_UNEMP_20 EPL_UNEMP_20 E_HBURD_OWN_20 ET_HOUSINGCOST_OWN_20 EP_HBURD_OWN_20 EPL_HBURD_OWN_20 E_HBURD_RENT_20 ET_HOUSINGCOST_RENT_20 EP_HBURD_RENT_20 EPL_HBURD_RENT_20 E_HBURD_20 ET_HOUSINGCOST_20 EP_HBURD_20 EPL_HBURD_20 E_NOHSDP_20 ET_EDSTATUS_20 EP_NOHSDP_20 EPL_NOHSDP_20 E_UNINSUR_20 ET_INSURSTATUS_20 EP_UNINSUR_20 EPL_UNINSUR_20 E_AGE65_20 EP_AGE65_20 EPL_AGE65_20 E_AGE17_20 EP_AGE17_20 EPL_AGE17_20 E_DISABL_20 ET_DISABLSTATUS_20 EP_DISABL_20 EPL_DISABL_20 E_SNGPNT_20 ET_FAMILIES_20 EP_SNGPNT_20 EPL_SNGPNT_20 E_LIMENG_20 ET_POPAGE5UP_20 EP_LIMENG_20 EPL_LIMENG_20 E_MINRTY_20 ET_POPETHRACE_20 EP_MINRTY_20 EPL_MINRTY_20 E_STRHU_20 E_MUNIT_20 EP_MUNIT_20 EPL_MUNIT_20 E_MOBILE_20 EP_MOBILE_20 EPL_MOBILE_20 E_CROWD_20 ET_OCCUPANTS_20 EP_CROWD_20 EPL_CROWD_20 E_NOVEH_20 ET_KNOWNVEH_20 EP_NOVEH_20 EPL_NOVEH_20 E_GROUPQ_20 ET_HHTYPE_20 EP_GROUPQ_20 EPL_GROUPQ_20
29095000300 29 095 000300 MO Missouri Jackson County 2 Midwest Region 4 West North Central Division 1649 902 796 743 1628 45.63882 0.8673 44 892 4.932735 0.56120 15 171 8.771930 0.06154 312 625 49.92000 0.6615 327 796 41.08040 0.8418 193 1101 17.52952 0.8163 305 1649 18.496058 0.7806 217 13.159491 0.40820 392 23.77198 0.5561 243 1256.979 19.33206 0.6786 115 354.9897 32.39531 0.7857 126 1557 8.092486 0.9592 822 1648.979 49.84902 0.5918 902 173 19.179601 0.7449 4 0.4434590 0.6633 6 796 0.7537688 0.4235 129 795.9897 16.206240 0.7857 0 1649 0.0000000 0.1786
29095000600 29 095 000600 MO Missouri Jackson County 2 Midwest Region 4 West North Central Division 4900 1821 1482 1665 4857 34.28042 0.7041 94 1834 5.125409 0.58160 105 660 15.909091 0.32820 316 822 38.44282 0.3436 421 1482 28.40756 0.4337 1044 2762 37.79870 0.9949 1801 4900 36.755102 0.9898 251 5.122449 0.04082 1957 39.93878 0.9847 469 2943.000 15.93612 0.5357 220 979.0000 22.47191 0.6071 1129 4509 25.038811 1.0000 3808 4900.000 77.71429 0.8265 1821 99 5.436573 0.4847 13 0.7138935 0.7245 191 1482 12.8879892 0.9949 129 1482.0000 8.704453 0.5561 7 4900 0.1428571 0.4133
29095000700 29 095 000700 MO Missouri Jackson County 2 Midwest Region 4 West North Central Division 3513 1558 1341 1271 3417 37.19637 0.7449 27 1828 1.477024 0.14290 85 851 9.988249 0.10260 295 490 60.20408 0.8872 380 1341 28.33706 0.4286 759 2115 35.88652 0.9847 1031 3417 30.172666 0.9643 325 9.251352 0.16840 1173 33.39026 0.9337 320 2244.000 14.26025 0.3980 202 718.0000 28.13370 0.7041 694 3218 21.566190 0.9949 2212 3513.000 62.96613 0.6990 1558 114 7.317073 0.5306 0 0.0000000 0.3010 32 1341 2.3862789 0.6990 242 1341.0000 18.046234 0.8061 96 3513 2.7327071 0.8214
29095000800 29 095 000800 MO Missouri Jackson County 2 Midwest Region 4 West North Central Division 4014 1512 1352 2138 3966 53.90822 0.9439 50 1813 2.757860 0.32650 247 895 27.597765 0.81030 166 457 36.32385 0.2821 413 1352 30.54734 0.5204 507 2403 21.09863 0.8878 917 4014 22.845042 0.8980 327 8.146487 0.14290 1289 32.11261 0.9031 555 2725.000 20.36697 0.7092 174 753.0000 23.10757 0.6327 389 3610 10.775623 0.9643 2804 4014.000 69.85551 0.7551 1512 52 3.439153 0.4031 26 1.7195767 0.8878 19 1352 1.4053254 0.5510 250 1352.0000 18.491124 0.8418 15 4014 0.3736921 0.5306
29095000900 29 095 000900 MO Missouri Jackson County 2 Midwest Region 4 West North Central Division 2814 1576 1240 1249 2785 44.84740 0.8520 0 1422 0.000000 0.02296 164 596 27.516779 0.80510 180 644 27.95031 0.1641 344 1240 27.74194 0.4031 367 1886 19.45917 0.8571 662 2814 23.525231 0.9031 295 10.483298 0.22450 716 25.44421 0.6327 263 2098.000 12.53575 0.2806 191 623.0000 30.65811 0.7449 122 2696 4.525223 0.8878 1795 2814.000 63.78820 0.7092 1576 122 7.741117 0.5408 17 1.0786802 0.8061 110 1240 8.8709677 0.9643 229 1240.0000 18.467742 0.8316 11 2814 0.3909026 0.5459
29095001000 29 095 001000 MO Missouri Jackson County 2 Midwest Region 4 West North Central Division 3399 1377 1203 1891 3363 56.22956 0.9541 73 1274 5.729984 0.62240 73 374 19.518717 0.56920 276 829 33.29312 0.2308 349 1203 29.01081 0.4490 636 1920 33.12500 0.9796 322 3399 9.473375 0.4286 226 6.649014 0.09184 1316 38.71727 0.9796 450 2083.000 21.60346 0.7602 286 745.0000 38.38926 0.8673 224 2812 7.965861 0.9541 2429 3399.000 71.46219 0.7704 1377 182 13.217139 0.6582 0 0.0000000 0.3010 116 1203 9.6425603 0.9745 337 1203.0000 28.013300 0.9439 0 3399 0.0000000 0.1786 
svi_2020_national <- svi_theme_variables(svi_2020_national)
svi_2020_national %>% head() %>% kbl() %>% kable_styling() %>% scroll_box(width = "100%")
GEOID_2010_trt FIPS_st FIPS_county FIPS_tract state state_name county region_number region division_number division E_TOTPOP_20 E_HU_20 E_HH_20 E_POV150_20 ET_POVSTATUS_20 EP_POV150_20 EPL_POV150_20 E_UNEMP_20 ET_EMPSTATUS_20 EP_UNEMP_20 EPL_UNEMP_20 E_HBURD_OWN_20 ET_HOUSINGCOST_OWN_20 EP_HBURD_OWN_20 EPL_HBURD_OWN_20 E_HBURD_RENT_20 ET_HOUSINGCOST_RENT_20 EP_HBURD_RENT_20 EPL_HBURD_RENT_20 E_HBURD_20 ET_HOUSINGCOST_20 EP_HBURD_20 EPL_HBURD_20 E_NOHSDP_20 ET_EDSTATUS_20 EP_NOHSDP_20 EPL_NOHSDP_20 E_UNINSUR_20 ET_INSURSTATUS_20 EP_UNINSUR_20 EPL_UNINSUR_20 E_AGE65_20 EP_AGE65_20 EPL_AGE65_20 E_AGE17_20 EP_AGE17_20 EPL_AGE17_20 E_DISABL_20 ET_DISABLSTATUS_20 EP_DISABL_20 EPL_DISABL_20 E_SNGPNT_20 ET_FAMILIES_20 EP_SNGPNT_20 EPL_SNGPNT_20 E_LIMENG_20 ET_POPAGE5UP_20 EP_LIMENG_20 EPL_LIMENG_20 E_MINRTY_20 ET_POPETHRACE_20 EP_MINRTY_20 EPL_MINRTY_20 E_STRHU_20 E_MUNIT_20 EP_MUNIT_20 EPL_MUNIT_20 E_MOBILE_20 EP_MOBILE_20 EPL_MOBILE_20 E_CROWD_20 ET_OCCUPANTS_20 EP_CROWD_20 EPL_CROWD_20 E_NOVEH_20 ET_KNOWNVEH_20 EP_NOVEH_20 EPL_NOVEH_20 E_GROUPQ_20 ET_HHTYPE_20 EP_GROUPQ_20 EPL_GROUPQ_20 SPL_THEME1 RPL_THEME1 SPL_THEME2 RPL_THEME2 SPL_THEME3 RPL_THEME3 SPL_THEME4 RPL_THEME4 SPL_THEMES RPL_THEMES
01001020100 01 001 020100 AL Alabama Autauga County 3 South Region 6 East South Central Division 1941 710 693 352 1941 18.13498 0.4630 18 852 2.112676 0.15070 81 507 15.976331 0.26320 63 186 33.87097 0.2913 144 693 20.77922 0.2230 187 1309 14.285714 0.6928 187 1941 9.634209 0.6617 295 15.19835 0.4601 415 21.38073 0.4681 391 1526 25.62254 0.9011 58 555 10.45045 0.3451 0 1843 0.0000000 0.09479 437 1941 22.51417 0.3902 710 0 0.0000000 0.1079 88 12.3943662 0.8263 0 693 0.0000000 0.09796 10 693 1.443001 0.1643 0 1941 0.000000 0.1831 2.19120 0.4084 2.26919 0.3503 0.3902 0.3869 1.37956 0.07216 6.23015 0.2314
01001020200 01 001 020200 AL Alabama Autauga County 3 South Region 6 East South Central Division 1757 720 573 384 1511 25.41363 0.6427 29 717 4.044630 0.41320 33 392 8.418367 0.03542 116 181 64.08840 0.9086 149 573 26.00349 0.4041 139 1313 10.586443 0.5601 91 1533 5.936073 0.4343 284 16.16392 0.5169 325 18.49744 0.2851 164 1208 13.57616 0.4127 42 359 11.69916 0.3998 0 1651 0.0000000 0.09479 1116 1757 63.51736 0.7591 720 3 0.4166667 0.2470 5 0.6944444 0.5106 9 573 1.5706806 0.46880 57 573 9.947644 0.7317 212 1757 12.066022 0.9549 2.45440 0.4888 1.70929 0.1025 0.7591 0.7527 2.91300 0.68620 7.83579 0.4802
01001020300 01 001 020300 AL Alabama Autauga County 3 South Region 6 East South Central Division 3694 1464 1351 842 3694 22.79372 0.5833 53 1994 2.657974 0.22050 117 967 12.099276 0.11370 147 384 38.28125 0.3856 264 1351 19.54108 0.1827 317 2477 12.797739 0.6460 127 3673 3.457664 0.2308 464 12.56091 0.3088 929 25.14889 0.7080 473 2744 17.23761 0.6211 263 975 26.97436 0.8234 128 3586 3.5694367 0.70770 1331 3694 36.03140 0.5515 1464 26 1.7759563 0.3675 14 0.9562842 0.5389 35 1351 2.5906736 0.60550 42 1351 3.108808 0.3415 0 3694 0.000000 0.1831 1.86330 0.3063 3.16900 0.8380 0.5515 0.5468 2.03650 0.26830 7.62030 0.4460
01001020400 01 001 020400 AL Alabama Autauga County 3 South Region 6 East South Central Division 3539 1741 1636 503 3539 14.21305 0.3472 39 1658 2.352232 0.17990 219 1290 16.976744 0.30880 74 346 21.38728 0.1037 293 1636 17.90954 0.1333 173 2775 6.234234 0.3351 169 3529 4.788892 0.3448 969 27.38062 0.9225 510 14.41085 0.1208 670 3019 22.19278 0.8194 148 1137 13.01671 0.4541 89 3409 2.6107363 0.64690 454 3539 12.82848 0.2364 1741 143 8.2136703 0.6028 0 0.0000000 0.2186 10 1636 0.6112469 0.28340 72 1636 4.400978 0.4538 0 3539 0.000000 0.1831 1.34030 0.1575 2.96370 0.7496 0.2364 0.2344 1.74170 0.16270 6.28210 0.2389
01001020500 01 001 020500 AL Alabama Autauga County 3 South Region 6 East South Central Division 10674 4504 4424 1626 10509 15.47245 0.3851 81 5048 1.604596 0.09431 321 2299 13.962592 0.17970 711 2125 33.45882 0.2836 1032 4424 23.32731 0.3109 531 6816 7.790493 0.4251 301 10046 2.996217 0.1894 1613 15.11149 0.4553 2765 25.90407 0.7494 1124 7281 15.43744 0.5253 342 2912 11.74451 0.4019 52 9920 0.5241935 0.35230 2603 10674 24.38636 0.4160 4504 703 15.6083481 0.7378 29 0.6438721 0.5037 37 4424 0.8363472 0.33420 207 4424 4.679023 0.4754 176 10674 1.648866 0.7598 1.40481 0.1743 2.48420 0.4802 0.4160 0.4125 2.81090 0.63730 7.11591 0.3654
01001020600 01 001 020600 AL Alabama Autauga County 3 South Region 6 East South Central Division 3536 1464 1330 1279 3523 36.30429 0.8215 34 1223 2.780049 0.23780 321 1111 28.892889 0.75870 67 219 30.59361 0.2305 388 1330 29.17293 0.5075 306 2380 12.857143 0.6480 415 3496 11.870709 0.7535 547 15.46946 0.4760 982 27.77149 0.8327 729 2514 28.99761 0.9488 95 880 10.79545 0.3601 0 3394 0.0000000 0.09479 985 3536 27.85633 0.4608 1464 0 0.0000000 0.1079 364 24.8633880 0.9300 0 1330 0.0000000 0.09796 17 1330 1.278196 0.1463 0 3536 0.000000 0.1831 2.96830 0.6434 2.71239 0.6156 0.4608 0.4569 1.46526 0.08976 7.60675 0.4440 
svi_2020_national <- svi_theme_flags(svi_2020_national, .90)
svi_2020_national %>% arrange(desc(F_TOTAL)) %>% head() %>% kbl() %>% kable_styling() %>% scroll_box(width = "100%")
GEOID_2010_trt FIPS_st FIPS_county FIPS_tract state state_name county region_number region division_number division E_TOTPOP_20 E_HU_20 E_HH_20 E_POV150_20 ET_POVSTATUS_20 EP_POV150_20 EPL_POV150_20 F_POV150_20 E_UNEMP_20 ET_EMPSTATUS_20 EP_UNEMP_20 EPL_UNEMP_20 F_UNEMP_20 E_HBURD_OWN_20 ET_HOUSINGCOST_OWN_20 EP_HBURD_OWN_20 EPL_HBURD_OWN_20 F_HBURD_OWN_20 E_HBURD_RENT_20 ET_HOUSINGCOST_RENT_20 EP_HBURD_RENT_20 EPL_HBURD_RENT_20 F_HBURD_RENT_20 E_HBURD_20 ET_HOUSINGCOST_20 EP_HBURD_20 EPL_HBURD_20 F_HBURD_20 E_NOHSDP_20 ET_EDSTATUS_20 EP_NOHSDP_20 EPL_NOHSDP_20 F_NOHSDP_20 E_UNINSUR_20 ET_INSURSTATUS_20 EP_UNINSUR_20 EPL_UNINSUR_20 F_UNINSUR_20 E_AGE65_20 EP_AGE65_20 EPL_AGE65_20 F_AGE65_20 E_AGE17_20 EP_AGE17_20 EPL_AGE17_20 F_AGE17_20 E_DISABL_20 ET_DISABLSTATUS_20 EP_DISABL_20 EPL_DISABL_20 F_DISABL_20 E_SNGPNT_20 ET_FAMILIES_20 EP_SNGPNT_20 EPL_SNGPNT_20 F_SNGPNT_20 E_LIMENG_20 ET_POPAGE5UP_20 EP_LIMENG_20 EPL_LIMENG_20 F_LIMENG_20 E_MINRTY_20 ET_POPETHRACE_20 EP_MINRTY_20 EPL_MINRTY_20 F_MINRTY_20 E_STRHU_20 E_MUNIT_20 EP_MUNIT_20 EPL_MUNIT_20 F_MUNIT_20 E_MOBILE_20 EP_MOBILE_20 EPL_MOBILE_20 F_MOBILE_20 E_CROWD_20 ET_OCCUPANTS_20 EP_CROWD_20 EPL_CROWD_20 F_CROWD_20 E_NOVEH_20 ET_KNOWNVEH_20 EP_NOVEH_20 EPL_NOVEH_20 F_NOVEH_20 E_GROUPQ_20 ET_HHTYPE_20 EP_GROUPQ_20 EPL_GROUPQ_20 F_GROUPQ_20 SPL_THEME1 RPL_THEME1 F_THEME1 SPL_THEME2 RPL_THEME2 F_THEME2 SPL_THEME3 RPL_THEME3 F_THEME3 SPL_THEME4 RPL_THEME4 F_THEME4 SPL_THEMES RPL_THEMES F_TOTAL
48141000404 48 141 000404 TX Texas El Paso County 3 South Region 7 West South Central Division 3380 1648 1221 2390 3380 70.71006 0.9928 1 210 1268 16.56151 0.9697 1 12 154 7.792208 0.02796 0 705 1067 66.07310 0.9281 1 717 1221 58.72236 0.9772 1 745 1955 38.10742 0.9703 1 1234 3370 36.61721 0.9940 1 369 10.917160 0.22390 0 1070 31.65680 0.9356 1 664 2300 28.86957 0.9477 1 365 761 47.96321 0.9741 1 649 3025 21.45455 0.9659 1 3222 3380 95.32544 0.9478 1 1648 701 42.53641 0.9214 1 0 0 0.2186 0 130 1221 10.647011 0.9224 1 344 1221 28.17363 0.9344 1 0 3380 0.0000000 0.1831 0 4.9040 0.9886 5 4.04720 0.9848 4 0.9478 0.9398 1 3.1799 0.8000 3 13.07890 0.9859 13
06037224420 06 037 224420 CA California Los Angeles County 4 West Region 9 Pacific Division 2651 943 883 1562 2389 65.38301 0.9868 1 232 1430 16.22378 0.9672 1 13 57 22.807018 0.56500 0 584 826 70.70218 0.9614 1 597 883 67.61042 0.9949 1 894 1588 56.29723 0.9975 1 605 2651 22.82158 0.9514 1 243 9.166352 0.14720 0 543 20.48284 0.4073 0 211 1889 11.16993 0.2666 0 207 571 36.25219 0.9217 1 870 2539 34.26546 0.9937 1 2523 2651 95.17163 0.9465 1 943 540 57.26405 0.9549 1 0 0 0.2186 0 344 883 38.958097 0.9984 1 302 883 34.20159 0.9522 1 253 2651 9.5435685 0.9459 1 4.8978 0.9886 5 2.73650 0.6297 2 0.9465 0.9385 1 4.0700 0.9818 4 12.65080 0.9801 12
12086001401 12 086 001401 FL Florida Miami-Dade County 3 South Region 5 South Atlantic Division 6606 2427 2203 4080 6606 61.76203 0.9802 1 314 2673 11.74710 0.9138 1 134 300 44.666667 0.95870 1 1111 1903 58.38150 0.8314 0 1245 2203 56.51384 0.9682 1 1363 4012 33.97308 0.9551 1 1313 6606 19.87587 0.9252 1 732 11.080836 0.23160 0 1985 30.04844 0.9023 1 670 4621 14.49903 0.4697 0 606 1267 47.82952 0.9736 1 854 5756 14.83669 0.9273 1 6592 6606 99.78807 0.9954 1 2427 965 39.76102 0.9125 1 0 0 0.2186 0 378 2203 17.158420 0.9692 1 777 2203 35.27009 0.9546 1 40 6606 0.6055101 0.6241 0 4.7425 0.9867 5 3.50450 0.9317 3 0.9954 0.9870 1 3.6790 0.9403 3 12.92140 0.9845 12
27053005902 27 053 005902 MN Minnesota Hennepin County 2 Midwest Region 4 West North Central Division 3896 1173 1087 2343 3739 62.66381 0.9824 1 226 1842 12.26927 0.9232 1 21 71 29.577465 0.77560 0 521 1016 51.27953 0.6904 0 542 1087 49.86201 0.9223 1 719 1932 37.21532 0.9675 1 608 3896 15.60575 0.8581 0 87 2.233059 0.01142 0 1442 37.01232 0.9852 1 640 2440 26.22951 0.9114 1 274 583 46.99828 0.9714 1 444 3462 12.82496 0.9096 1 2911 3896 74.71766 0.8205 0 1173 721 61.46633 0.9616 1 0 0 0.2186 0 226 1087 20.791168 0.9809 1 323 1087 29.71481 0.9398 1 579 3896 14.8613963 0.9619 1 4.6535 0.9834 4 3.78902 0.9713 4 0.8205 0.8136 0 4.0628 0.9815 4 13.32582 0.9873 12
34001002400 34 001 002400 NJ New Jersey Atlantic County 1 Northeast Region 2 Middle Atlantic Division 2614 1726 1217 1579 2612 60.45176 0.9773 1 290 1171 24.76516 0.9931 1 69 127 54.330709 0.98500 1 538 1090 49.35780 0.6469 0 607 1217 49.87675 0.9224 1 697 1998 34.88488 0.9590 1 551 2614 21.07881 0.9374 1 516 19.739862 0.70560 0 503 19.24254 0.3280 0 576 2111 27.28565 0.9280 1 257 567 45.32628 0.9667 1 556 2368 23.47973 0.9732 1 2029 2614 77.62050 0.8359 0 1726 1166 67.55504 0.9693 1 0 0 0.2186 0 115 1217 9.449466 0.9062 1 673 1217 55.29992 0.9828 1 223 2614 8.5309870 0.9407 1 4.7892 0.9877 5 3.90150 0.9792 3 0.8359 0.8288 0 4.0176 0.9793 4 13.54420 0.9879 12
34039039300 34 039 039300 NJ New Jersey Union County 1 Northeast Region 2 Middle Atlantic Division 6145 1835 1727 3492 6096 57.28346 0.9684 1 350 3006 11.64338 0.9114 1 58 140 41.428571 0.94020 1 829 1587 52.23692 0.7127 0 887 1727 51.36074 0.9352 1 1367 3639 37.56527 0.9686 1 2771 6145 45.09357 0.9987 1 400 6.509357 0.06257 0 2006 32.64443 0.9503 1 443 4139 10.70307 0.2400 0 476 1178 40.40747 0.9470 1 1979 5714 34.63423 0.9941 1 5955 6145 96.90806 0.9624 1 1835 815 44.41417 0.9271 1 0 0 0.2186 0 391 1727 22.640417 0.9849 1 748 1727 43.31210 0.9692 1 114 6145 1.8551668 0.7766 0 4.7823 0.9877 5 3.19397 0.8468 3 0.9624 0.9543 1 3.8764 0.9680 3 12.81507 0.9830 12