Social Vulnerability Index

SVI SUMMARY INTRO

NOTE: Values below are duplicates from Middle Atlantic Division and serve solely as an example

Library

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

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",
              "region",
              "state",
              "county",
              "fips_region_assignment",
              "rank_variables",
              "svi_theme_variables",
              "svi_theme_flags",
             # notice the use of here::here() that points to the .R file
             # where all these R objects are created
             .from = here::here("analysis/project_data_steps_sparky.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	ET_HHTYPE_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	1809	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	2020	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	3543	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	4840	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	9938	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	3402	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	ET_HHTYPE_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	1809	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	2020	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	3543	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	4840	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	9938	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	3402	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	ET_HHTYPE_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	1809	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	2020	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	3543	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	4840	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	9938	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	3402	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 = 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
09001010101	09	001	010101	CT	Connecticut	Fairfield County	1	Northeast Region	1	New England Division	4053	1608	1416	242	3851	6.284082	0.16010	52	1511	3.441429	0.1265	429	1240	34.59677	0.5194	24	176	13.63636	0.03745	453	1416	31.99153	0.29440	234	2778	8.423326	0.35790	150	3851	3.895092	0.17230	959	23.66149	0.9384	1115	27.51049	0.8155	252	2898	8.695652	0.1725	32	1041	3.073967	0.05352	96	3821	2.5124313	0.6127	175	4053	4.317789	0.1678	1608	46	2.8606965	0.38610	0	0.0000000	0.3204	11	1416	0.7768362	0.4311	43	1416	3.036723	0.22200	202	4053	4.983962	0.8725
09001010102	09	001	010102	CT	Connecticut	Fairfield County	1	Northeast Region	1	New England Division	4833	1538	1430	205	4815	4.257529	0.08309	78	1799	4.335742	0.2178	478	1352	35.35503	0.5437	37	78	47.43590	0.54680	515	1430	36.01399	0.42400	66	3159	2.089269	0.04865	156	4544	3.433099	0.14220	750	15.51831	0.6469	1419	29.36065	0.8840	290	3345	8.669656	0.1708	28	1235	2.267206	0.03553	131	4538	2.8867342	0.6395	1176	4833	24.332713	0.5919	1538	0	0.0000000	0.09502	0	0.0000000	0.3204	0	1430	0.0000000	0.1525	101	1430	7.062937	0.46710	237	4833	4.903786	0.8706
09001010201	09	001	010201	CT	Connecticut	Fairfield County	1	Northeast Region	1	New England Division	3550	1091	948	108	3346	3.227735	0.05048	53	950	5.578947	0.3654	246	903	27.24252	0.2833	8	45	17.77778	0.05548	254	948	26.79325	0.14380	99	2117	4.676429	0.15780	49	3217	1.523158	0.04121	672	18.92958	0.8255	1282	36.11268	0.9778	244	2146	11.369991	0.3628	71	894	7.941834	0.26130	25	3422	0.7305669	0.3653	300	3550	8.450704	0.3187	1091	0	0.0000000	0.09502	0	0.0000000	0.3204	0	948	0.0000000	0.1525	0	948	0.000000	0.01141	204	3550	5.746479	0.8862
09001010202	09	001	010202	CT	Connecticut	Fairfield County	1	Northeast Region	1	New England Division	4839	1928	1729	215	4826	4.455035	0.08982	79	2116	3.733459	0.1528	335	1413	23.70842	0.1771	64	316	20.25316	0.06942	399	1729	23.07692	0.06555	149	3374	4.416123	0.14510	92	5430	1.694291	0.04860	693	14.32114	0.5654	1304	26.94772	0.7899	332	3969	8.364827	0.1531	71	1323	5.366591	0.13510	123	4514	2.7248560	0.6284	837	4839	17.296962	0.5062	1928	9	0.4668050	0.20820	10	0.5186722	0.6707	0	1729	0.0000000	0.1525	10	1729	0.578369	0.03255	0	4839	0.000000	0.3433
09001010300	09	001	010300	CT	Connecticut	Fairfield County	1	Northeast Region	1	New England Division	3847	1632	1421	218	3847	5.666753	0.13480	106	1463	7.245386	0.5540	398	1125	35.37778	0.5447	116	296	39.18919	0.34300	514	1421	36.17171	0.42800	101	2762	3.656770	0.10950	215	3910	5.498721	0.28470	732	19.02781	0.8296	961	24.98050	0.6777	219	2898	7.556936	0.1061	24	1076	2.230483	0.03478	16	3668	0.4362050	0.2769	536	3847	13.932935	0.4482	1632	8	0.4901961	0.21090	0	0.0000000	0.3204	0	1421	0.0000000	0.1525	26	1421	1.829697	0.11950	0	3847	0.000000	0.3433
09001010400	09	001	010400	CT	Connecticut	Fairfield County	1	Northeast Region	1	New England Division	5181	2250	2108	365	5181	7.044972	0.18980	102	2379	4.287516	0.2118	764	1600	47.75000	0.8269	275	508	54.13386	0.70890	1039	2108	49.28842	0.79620	301	3682	8.174905	0.34450	473	5252	9.006093	0.52990	1035	19.97684	0.8601	1333	25.72862	0.7257	661	4151	15.923874	0.6668	197	1357	14.517318	0.55450	67	4767	1.4054961	0.4895	595	5181	11.484269	0.3994	2250	123	5.4666667	0.49320	10	0.4444444	0.6594	26	2108	1.2333966	0.5267	63	2108	2.988615	0.21810	0	5181	0.000000	0.3433

# Regional
svi_2020_regional <- rank_variables(svi_2020, rank_by = "regional", location = 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
09001010101	09	001	010101	CT	Connecticut	Fairfield County	1	Northeast Region	1	New England Division	4192	1591	1347	241	3922	6.144824	0.144600	76	1947	3.903441	0.3806	554	1108	50.00000	0.9397	86	239	35.98326	0.29250	640	1347	47.51299	0.8415	93	3061	3.038223	0.14930	7	3922	0.1784804	0.014040	1238	29.53244	0.9500	908	21.66031	0.6033	259	3014.000	8.593232	0.15340	65	1033.000	6.2923524	0.20440	63	4022	1.5663849	0.50770	453	4192.000	10.80630	0.2732	1591	25	1.5713388	0.29150	0	0.000000	0.3172	25	1347	1.8559762	0.5608	33	1347.000	2.4498886	0.17820	275	4192	6.5601145	0.9107
09001010102	09	001	010102	CT	Connecticut	Fairfield County	1	Northeast Region	1	New England Division	4419	1602	1362	60	4419	1.357773	0.007698	67	2032	3.297244	0.2916	363	1231	29.48822	0.6387	29	131	22.13740	0.08811	392	1362	28.78120	0.3840	33	2827	1.167315	0.03804	4	4419	0.0905182	0.011050	828	18.73727	0.6218	1208	27.33650	0.8876	239	3211.000	7.443164	0.09654	8	1255.000	0.6374502	0.01594	17	4186	0.4061156	0.27980	539	4419.000	12.19733	0.3037	1602	0	0.0000000	0.08313	0	0.000000	0.3172	9	1362	0.6607930	0.3515	17	1362.000	1.2481645	0.08452	20	4419	0.4525911	0.5565
09001010201	09	001	010201	CT	Connecticut	Fairfield County	1	Northeast Region	1	New England Division	3429	1255	1119	181	3277	5.523345	0.120100	76	1201	6.328060	0.6691	255	978	26.07362	0.5312	24	141	17.02128	0.05272	279	1119	24.93298	0.2590	44	2207	1.993656	0.07981	0	3277	0.0000000	0.004705	741	21.60980	0.7671	964	28.11315	0.9053	158	2313.000	6.830955	0.07420	21	871.000	2.4110218	0.04849	10	3218	0.3107520	0.24640	561	3429.000	16.36045	0.3846	1255	24	1.9123506	0.31520	0	0.000000	0.3172	0	1119	0.0000000	0.1244	24	1119.000	2.1447721	0.15360	251	3429	7.3199183	0.9178
09001010202	09	001	010202	CT	Connecticut	Fairfield County	1	Northeast Region	1	New England Division	5262	1917	1811	647	5245	12.335558	0.390800	169	2620	6.450382	0.6798	346	1294	26.73879	0.5524	272	517	52.61122	0.68900	618	1811	34.12479	0.5544	175	3433	5.097582	0.29890	83	5263	1.5770473	0.158300	883	16.78069	0.5027	1550	29.45648	0.9311	383	3713.163	10.314657	0.26320	136	1483.018	9.1704909	0.34670	157	5042	3.1138437	0.64660	1339	5261.892	25.44712	0.5154	1917	7	0.3651539	0.18520	0	0.000000	0.3172	0	1811	0.0000000	0.1244	42	1811.390	2.3186617	0.16720	8	5262	0.1520334	0.3711
09001010300	09	001	010300	CT	Connecticut	Fairfield County	1	Northeast Region	1	New England Division	3815	1664	1457	89	3810	2.335958	0.020850	81	1839	4.404568	0.4541	293	1038	28.22736	0.6002	75	419	17.89976	0.05786	368	1457	25.25738	0.2693	35	2698	1.297257	0.04371	38	3809	0.9976372	0.083710	742	19.44954	0.6605	881	23.09305	0.6986	124	2928.576	4.234140	0.01599	31	1164.582	2.6618993	0.05612	0	3612	0.0000000	0.07348	502	3815.450	13.15703	0.3245	1664	51	3.0649038	0.37610	13	0.781250	0.7117	13	1457	0.8922443	0.4053	13	1456.744	0.8924009	0.05999	58	3815	1.5203145	0.7278
09001010400	09	001	010400	CT	Connecticut	Fairfield County	1	Northeast Region	1	New England Division	5846	2131	1978	352	5846	6.021211	0.139600	171	3470	4.927954	0.5229	259	1285	20.15564	0.3169	339	693	48.91775	0.59620	598	1978	30.23256	0.4314	169	4282	3.946754	0.21520	342	5846	5.8501540	0.656600	948	16.21622	0.4662	1144	19.56894	0.4424	590	4702.000	12.547852	0.41400	187	1561.000	11.9795003	0.47280	72	5567	1.2933357	0.47110	946	5846.000	16.18200	0.3817	2131	92	4.3172220	0.42850	23	1.079306	0.7367	76	1978	3.8422649	0.7360	15	1978.000	0.7583418	0.04981	23	5846	0.3934314	0.5304

# Divisional
svi_2010_divisional <- rank_variables(svi_2010, rank_by = "divisional", location = census_division)
svi_2010_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_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
34001000100	34	001	000100	NJ	New Jersey	Atlantic County	1	Northeast Region	2	Middle Atlantic Division	2907	1088	983	1127	2907	38.76849	0.8482	144	1433	10.048849	0.7544	280	435	64.36782	0.9529	204	548	37.22628	0.2998	484	983	49.23703	0.7813	468	1759	26.60603	0.8634	532	2543	20.92017	0.8978	250	8.599931	0.1777	944	32.47334	0.94170	186	1851	10.04862	0.2706	266	678	39.233038	0.8981	177	2611	6.779012	0.7778	1928	2907	66.32267	0.7743	1088	113	10.386029	0.6229	9	0.8272059	0.7223	80	983	8.138352	0.8657	265	983	26.95829	0.7354	0	2907	0.000000	0.3512
34001000200	34	001	000200	NJ	New Jersey	Atlantic County	1	Northeast Region	2	Middle Atlantic Division	3189	2217	1473	519	3189	16.27469	0.4806	109	1558	6.996149	0.5179	573	955	60.00000	0.9323	199	518	38.41699	0.3261	772	1473	52.41005	0.8418	405	2579	15.70376	0.6491	484	3547	13.64533	0.7154	847	26.560050	0.9629	436	13.67200	0.08181	608	3005	20.23295	0.8466	42	857	4.900817	0.1204	422	3072	13.736979	0.8799	1792	3189	56.19316	0.7390	2217	901	40.640505	0.8693	0	0.0000000	0.3251	48	1473	3.258656	0.7064	250	1473	16.97217	0.6444	0	3189	0.000000	0.3512
34001000300	34	001	000300	NJ	New Jersey	Atlantic County	1	Northeast Region	2	Middle Atlantic Division	3997	1823	1357	1401	3968	35.30746	0.8164	382	2238	17.068811	0.9376	176	329	53.49544	0.8855	604	1028	58.75486	0.7947	780	1357	57.47973	0.9165	920	2677	34.36683	0.9346	1351	4149	32.56206	0.9811	314	7.855892	0.1437	937	23.44258	0.55900	319	3054	10.44532	0.3000	187	782	23.913044	0.7498	1080	3671	29.419777	0.9742	3357	3997	83.98799	0.8419	1823	363	19.912233	0.7535	0	0.0000000	0.3251	150	1357	11.053795	0.9136	651	1357	47.97347	0.8585	0	3997	0.000000	0.3512
34001000400	34	001	000400	NJ	New Jersey	Atlantic County	1	Northeast Region	2	Middle Atlantic Division	2902	2683	1401	1172	2902	40.38594	0.8615	190	1389	13.678906	0.8811	364	707	51.48515	0.8627	507	694	73.05476	0.9503	871	1401	62.16988	0.9572	481	1981	24.28067	0.8339	674	3204	21.03620	0.8998	434	14.955203	0.6083	596	20.53756	0.33980	426	2607	16.34062	0.6886	111	652	17.024540	0.6204	215	2736	7.858187	0.8008	1792	2902	61.75052	0.7584	2683	2049	76.369735	0.9401	0	0.0000000	0.3251	69	1401	4.925053	0.7847	511	1401	36.47395	0.7992	72	2902	2.481048	0.8114
34001000500	34	001	000500	NJ	New Jersey	Atlantic County	1	Northeast Region	2	Middle Atlantic Division	3483	1241	1027	1938	3483	55.64169	0.9533	124	1630	7.607362	0.5830	227	446	50.89686	0.8549	478	581	82.27194	0.9799	705	1027	68.64654	0.9863	733	2077	35.29129	0.9396	727	3258	22.31430	0.9149	377	10.824002	0.3081	1055	30.28998	0.90140	268	2401	11.16202	0.3549	209	763	27.391874	0.7940	911	3077	29.606760	0.9746	3036	3483	87.16624	0.8550	1241	52	4.190169	0.4505	4	0.3223207	0.6567	113	1027	11.002921	0.9128	422	1027	41.09056	0.8250	0	3483	0.000000	0.3512
34001001100	34	001	001100	NJ	New Jersey	Atlantic County	1	Northeast Region	2	Middle Atlantic Division	2204	1204	1204	1185	2204	53.76588	0.9457	219	927	23.624596	0.9830	97	172	56.39535	0.9094	462	1032	44.76744	0.4746	559	1204	46.42857	0.7197	346	1440	24.02778	0.8306	469	1942	24.15036	0.9360	363	16.470054	0.7020	578	26.22505	0.74410	442	1558	28.36970	0.9675	247	396	62.373737	0.9898	104	2051	5.070697	0.7260	2118	2204	96.09800	0.9204	1204	570	47.342193	0.8858	0	0.0000000	0.3251	14	1204	1.162791	0.4877	817	1204	67.85714	0.9413	0	2204	0.000000	0.3512

# Divisional
svi_2020_divisional <- rank_variables(svi_2020, rank_by = "divisional", location = census_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
34001000100	34	001	000100	NJ	New Jersey	Atlantic County	1	Northeast Region	2	Middle Atlantic Division	2157	941	784	1182	2157	54.79833	0.9571	242	1058	22.873346	0.9922	215	342	62.86550	0.9780	316	442	71.49321	0.9481	531	784	67.72959	0.9893	396	1274	31.08320	0.9497	266	2157	12.331943	0.9041	185	8.576727	0.09430	552	25.59110	0.8128	297	1605	18.504673	0.74880	83	510	16.27451	0.6090	251	2020	12.425743	0.8710	1852	2157	85.85999	0.8476	941	118	12.5398512	0.6385	0	0.0000000	0.3216	67	784	8.545918	0.8657	212	784	27.04082	0.7502	0	2157	0.0000000	0.1517
34001000200	34	001	000200	NJ	New Jersey	Atlantic County	1	Northeast Region	2	Middle Atlantic Division	3510	2046	1353	1021	3510	29.08832	0.7682	121	1852	6.533477	0.6717	343	696	49.28161	0.9273	416	657	63.31811	0.8696	759	1353	56.09756	0.9321	553	2338	23.65269	0.8871	354	3510	10.085470	0.8530	643	18.319088	0.60310	1002	28.54701	0.9055	450	2508	17.942584	0.72330	237	786	30.15267	0.8539	534	3375	15.822222	0.9062	2534	3510	72.19373	0.7818	2046	906	44.2815249	0.8690	0	0.0000000	0.3216	119	1353	8.795270	0.8711	324	1353	23.94678	0.7255	0	3510	0.0000000	0.1517
34001000300	34	001	000300	NJ	New Jersey	Atlantic County	1	Northeast Region	2	Middle Atlantic Division	3801	1640	1226	1857	3801	48.85556	0.9333	226	1800	12.555556	0.9267	111	280	39.64286	0.8339	608	946	64.27061	0.8842	719	1226	58.64600	0.9528	650	2275	28.57143	0.9337	1027	3801	27.019206	0.9914	380	9.997369	0.14040	1223	32.17574	0.9607	219	2578	8.494957	0.15680	268	909	29.48295	0.8456	940	3400	27.647059	0.9728	3318	3801	87.29282	0.8579	1640	262	15.9756098	0.6917	0	0.0000000	0.3216	124	1226	10.114192	0.8955	477	1226	38.90701	0.8258	0	3801	0.0000000	0.1517
34001000400	34	001	000400	NJ	New Jersey	Atlantic County	1	Northeast Region	2	Middle Atlantic Division	3178	2264	1390	1508	3176	47.48111	0.9246	172	1804	9.534368	0.8460	205	468	43.80342	0.8858	622	922	67.46204	0.9192	827	1390	59.49640	0.9587	364	2076	17.53372	0.8013	476	3178	14.977974	0.9390	483	15.198238	0.41220	539	16.96035	0.2484	319	2639	12.087912	0.38790	101	565	17.87611	0.6539	583	3022	19.291860	0.9349	2186	3178	68.78540	0.7658	2264	1609	71.0689046	0.9266	15	0.6625442	0.7078	226	1390	16.258993	0.9567	599	1390	43.09353	0.8474	20	3178	0.6293266	0.6292
34001000500	34	001	000500	NJ	New Jersey	Atlantic County	1	Northeast Region	2	Middle Atlantic Division	3385	1185	945	1682	3364	50.00000	0.9391	72	1577	4.565631	0.4586	185	468	39.52991	0.8332	362	477	75.89099	0.9703	547	945	57.88360	0.9477	592	1983	29.85376	0.9422	738	3385	21.802068	0.9817	240	7.090103	0.05988	1129	33.35303	0.9689	135	2256	5.984043	0.04817	110	717	15.34170	0.5822	721	3076	23.439532	0.9569	3029	3385	89.48301	0.8727	1185	9	0.7594937	0.2382	0	0.0000000	0.3216	103	945	10.899471	0.9072	263	945	27.83069	0.7560	0	3385	0.0000000	0.1517
34001001100	34	001	001100	NJ	New Jersey	Atlantic County	1	Northeast Region	2	Middle Atlantic Division	1950	1267	1096	1131	1950	58.00000	0.9678	66	706	9.348442	0.8395	42	101	41.58416	0.8612	309	995	31.05528	0.1959	351	1096	32.02555	0.4782	510	1379	36.98332	0.9763	155	1950	7.948718	0.7660	392	20.102564	0.69880	447	22.92308	0.6712	570	1503	37.924152	0.99200	143	374	38.23529	0.9167	109	1841	5.920695	0.7464	1909	1950	97.89744	0.9529	1267	479	37.8058406	0.8464	0	0.0000000	0.3216	33	1096	3.010949	0.6446	743	1096	67.79197	0.9414	0	1950	0.0000000	0.1517

# State
svi_2010_state <- rank_variables(svi_2010, rank_by = "state", location = state)
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	ET_HHTYPE_10	EPL_GROUPQ_10
42001030101	42	001	030101	PA	Pennsylvania	Adams County	1	Northeast Region	2	Middle Atlantic Division	2597	993	915	230	2597	8.856373	0.1950	51	1399	3.645461	0.14870	279	840	33.21429	0.7852	27	75	36.00000	0.3706	306	915	33.44262	0.6063	185	1784	10.36996	0.4372	172	2580	6.666667	0.3133	280	10.781671	0.1947	694	26.72314	0.8216	281	1963	14.31482	0.4013	36	808	4.455445	0.09445	16	2481	0.6449012	0.5528	120	2597	4.620716	0.3091	993	0	0.000000	0.1312	55	5.538771	0.7558	5	915	0.5464481	0.4989	9	915	0.9836066	0.06514	2597	0.3334
42001030102	42	001	030102	PA	Pennsylvania	Adams County	1	Northeast Region	2	Middle Atlantic Division	5709	2415	2220	675	5709	11.823437	0.2920	236	3176	7.430731	0.59030	595	1894	31.41499	0.7163	131	326	40.18405	0.4772	726	2220	32.70270	0.5744	645	3990	16.16541	0.7281	326	5717	5.702291	0.2461	703	12.313890	0.2850	1332	23.33158	0.6116	674	4490	15.01114	0.4460	185	1727	10.712218	0.41920	95	5461	1.7396081	0.7700	370	5709	6.480995	0.3994	2415	0	0.000000	0.1312	261	10.807453	0.8497	61	2220	2.7477477	0.8804	62	2220	2.7927928	0.21860	5709	0.3334
42001030200	42	001	030200	PA	Pennsylvania	Adams County	1	Northeast Region	2	Middle Atlantic Division	5656	2180	2111	983	5588	17.591267	0.4964	161	3170	5.078864	0.30640	481	1677	28.68217	0.6106	154	434	35.48387	0.3586	635	2111	30.08053	0.4666	771	3785	20.36988	0.8475	877	5471	16.029976	0.8743	664	11.739745	0.2453	1428	25.24752	0.7469	630	4135	15.23579	0.4586	247	1594	15.495608	0.61690	193	5363	3.5987321	0.8791	866	5656	15.311174	0.6466	2180	0	0.000000	0.1312	302	13.853211	0.8982	70	2111	3.3159640	0.9126	85	2111	4.0265277	0.31290	5656	0.3334
42001030300	42	001	030300	PA	Pennsylvania	Adams County	1	Northeast Region	2	Middle Atlantic Division	3932	1561	1438	522	3913	13.340148	0.3424	103	2127	4.842501	0.27670	357	1097	32.54330	0.7606	89	341	26.09971	0.1637	446	1438	31.01530	0.5089	452	2560	17.65625	0.7828	634	4125	15.369697	0.8549	380	9.664293	0.1431	1059	26.93286	0.8306	369	3011	12.25506	0.2787	176	1125	15.644444	0.62220	190	3617	5.2529721	0.9178	673	3932	17.115972	0.6756	1561	0	0.000000	0.1312	90	5.765535	0.7592	67	1438	4.6592490	0.9511	6	1438	0.4172462	0.03038	3932	0.3334
42001030400	42	001	030400	PA	Pennsylvania	Adams County	1	Northeast Region	2	Middle Atlantic Division	5661	2359	2218	765	5658	13.520679	0.3512	74	3122	2.370275	0.05383	577	1766	32.67271	0.7653	221	452	48.89381	0.6877	798	2218	35.97836	0.6846	520	3886	13.38137	0.5988	697	5692	12.245256	0.7295	688	12.153330	0.2731	1423	25.13690	0.7381	694	4338	15.99816	0.5052	320	1633	19.595836	0.71700	29	5276	0.5496588	0.5116	644	5661	11.376082	0.5712	2359	77	3.264095	0.5131	224	9.495549	0.8303	22	2218	0.9918846	0.6427	141	2218	6.3570784	0.47170	5661	0.3334
42001030500	42	001	030500	PA	Pennsylvania	Adams County	1	Northeast Region	2	Middle Atlantic Division	3676	1585	1541	568	3670	15.476839	0.4235	96	1952	4.918033	0.28480	275	1214	22.65239	0.2979	142	327	43.42508	0.5586	417	1541	27.06035	0.3301	477	2622	18.19222	0.7978	565	3711	15.225007	0.8483	631	17.165397	0.6422	737	20.04897	0.3312	566	3026	18.70456	0.6753	116	1013	11.451135	0.45280	87	3464	2.5115473	0.8356	500	3676	13.601741	0.6162	1585	39	2.460568	0.4703	160	10.094637	0.8406	22	1541	1.4276444	0.7285	59	1541	3.8286827	0.29970	3676	0.3334

# State
svi_2020_state <- rank_variables(svi_2020, rank_by = "state", location = state)
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
42001030101	42	001	030101	PA	Pennsylvania	Adams County	1	Northeast Region	2	Middle Atlantic Division	2651	1160	1058	246	2651	9.279517	0.2243	12	1433	0.837404	0.02914	200	940	21.27660	0.6030	33	118	27.96610	0.20760	233	1058	22.02268	0.3198	167	1930	8.65285	0.5666	182	2652	6.862745	0.7413	521	19.65296	0.5860	601	22.67069	0.6889	262	2050.964	12.77448	0.2721	33	760.4212	4.339700	0.09897	42	2495	1.683367	0.7392	397	2650.619	14.977633	0.5194	1160	0	0.000000	0.1113	50	4.310345	0.7433	21	1058	1.984877	0.7410	8	1057.939	0.7561874	0.04917	0	2651	0.0000000	0.1546
42001030102	42	001	030102	PA	Pennsylvania	Adams County	1	Northeast Region	2	Middle Atlantic Division	5873	2397	2211	591	5837	10.125064	0.2547	138	3182	4.336895	0.46080	296	2028	14.59566	0.2304	75	183	40.98361	0.51510	371	2211	16.77974	0.1063	455	4273	10.64826	0.6904	337	5873	5.738124	0.6508	1256	21.38600	0.6876	1286	21.89682	0.6345	751	4587.000	16.37236	0.4975	130	1733.0000	7.501443	0.24150	0	5729	0.000000	0.1334	280	5873.000	4.767581	0.1981	2397	0	0.000000	0.1113	341	14.226116	0.9282	25	2211	1.130710	0.6043	33	2211.000	1.4925373	0.10300	0	5873	0.0000000	0.1546
42001030200	42	001	030200	PA	Pennsylvania	Adams County	1	Northeast Region	2	Middle Atlantic Division	5824	2189	2044	1054	5816	18.122421	0.5288	170	2876	5.910988	0.64130	341	1574	21.66455	0.6237	206	470	43.82979	0.59050	547	2044	26.76125	0.5394	718	4007	17.91864	0.8949	756	5808	13.016529	0.9439	976	16.75824	0.4081	1432	24.58791	0.7930	609	4376.036	13.91670	0.3447	130	1572.5788	8.266676	0.28590	266	5495	4.840764	0.8937	1357	5824.381	23.298614	0.6566	2189	0	0.000000	0.1113	393	17.953403	0.9602	55	2044	2.690802	0.8172	59	2044.061	2.8864106	0.22300	7	5824	0.1201923	0.3637
42001030300	42	001	030300	PA	Pennsylvania	Adams County	1	Northeast Region	2	Middle Atlantic Division	4306	1763	1620	324	4298	7.538390	0.1620	57	2528	2.254747	0.16040	245	1358	18.04124	0.4282	53	262	20.22901	0.09642	298	1620	18.39506	0.1703	359	3137	11.44405	0.7264	310	4299	7.210979	0.7670	666	15.46679	0.3333	824	19.13609	0.4109	473	3475.000	13.61151	0.3262	20	1173.0000	1.705030	0.02443	151	4119	3.665938	0.8624	813	4306.000	18.880632	0.5894	1763	0	0.000000	0.1113	182	10.323313	0.8665	59	1620	3.641975	0.8786	32	1620.000	1.9753086	0.14030	87	4306	2.0204366	0.7477
42001030400	42	001	030400	PA	Pennsylvania	Adams County	1	Northeast Region	2	Middle Atlantic Division	5798	2614	2271	967	5697	16.973846	0.4937	69	2979	2.316213	0.16920	444	1839	24.14356	0.7325	138	432	31.94444	0.28360	582	2271	25.62748	0.4917	696	4198	16.57932	0.8705	549	5697	9.636651	0.8697	1196	20.62780	0.6426	1192	20.55881	0.5253	871	4505.000	19.33407	0.6741	220	1721.0000	12.783266	0.49800	135	5437	2.482987	0.8093	513	5798.000	8.847879	0.3531	2614	61	2.333588	0.4313	283	10.826320	0.8752	91	2271	4.007045	0.8990	210	2271.000	9.2470277	0.60570	139	5798	2.3973784	0.7745
42001030500	42	001	030500	PA	Pennsylvania	Adams County	1	Northeast Region	2	Middle Atlantic Division	3879	1675	1531	771	3879	19.876257	0.5852	110	2120	5.188679	0.56360	189	1173	16.11253	0.3112	161	358	44.97207	0.61870	350	1531	22.86088	0.3590	418	2743	15.23879	0.8458	263	3879	6.780098	0.7376	815	21.01057	0.6679	796	20.52075	0.5235	513	3083.000	16.63964	0.5125	137	1139.0000	12.028095	0.46350	131	3667	3.572402	0.8587	831	3879.000	21.423047	0.6300	1675	28	1.671642	0.3824	147	8.776119	0.8404	23	1531	1.502286	0.6736	35	1531.000	2.2860875	0.16500	12	3879	0.3093581	0.5109

# County
svi_2010_county <- rank_variables(svi_2010, rank_by = "county", location = county, state_abbr = state)
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
42017100102	42	017	100102	PA	Pennsylvania	Bucks County	1	Northeast Region	2	Middle Atlantic Division	2520	1559	1255	501	2484	20.16908	0.9437	110	1281	8.587041	0.8732	179	415	43.13253	0.9366	387	840	46.07143	0.4648	566	1255	45.09960	0.9014	233	1952	11.936475	0.7606	209	2770	7.545126	0.6549	455	18.055556	0.8169	429	17.02381	0.08451	466	2391	19.48975	0.8873	102	575	17.739130	0.8803	38	2373	1.6013485	0.6972	361	2520	14.32540	0.7606	1559	366	23.476588	0.9014	25	1.603592	0.8310	29	1255	2.310757	0.9296	41	1255	3.266932	0.5986	0	2520	0.0000000	0.3275
42017100103	42	017	100103	PA	Pennsylvania	Bucks County	1	Northeast Region	2	Middle Atlantic Division	2677	1134	1009	303	2136	14.18539	0.7535	64	1204	5.315615	0.4225	219	570	38.42105	0.8310	172	439	39.17995	0.3521	391	1009	38.75124	0.6972	202	1568	12.882653	0.7958	190	2161	8.792226	0.7535	400	14.942099	0.6549	709	26.48487	0.78870	388	1880	20.63830	0.9648	52	571	9.106830	0.5070	22	2545	0.8644401	0.4648	972	2677	36.30930	0.9366	1134	185	16.313933	0.8310	0	0.000000	0.3451	0	1009	0.000000	0.2535	78	1009	7.730426	0.8662	541	2677	20.2091894	0.9789
42017100104	42	017	100104	PA	Pennsylvania	Bucks County	1	Northeast Region	2	Middle Atlantic Division	4613	2052	1830	1091	4613	23.65055	0.9648	158	2492	6.340289	0.5634	211	611	34.53355	0.5845	672	1219	55.12715	0.7254	883	1830	48.25137	0.9577	447	3271	13.665546	0.8239	469	4441	10.560685	0.8521	590	12.789941	0.4296	788	17.08216	0.09859	637	3631	17.54338	0.8028	135	1175	11.489362	0.6761	365	4357	8.3773238	0.9859	1846	4613	40.01734	0.9718	2052	549	26.754386	0.9225	0	0.000000	0.3451	0	1830	0.000000	0.2535	270	1830	14.754098	0.9648	0	4613	0.0000000	0.3275
42017100105	42	017	100105	PA	Pennsylvania	Bucks County	1	Northeast Region	2	Middle Atlantic Division	3457	1324	1242	444	3457	12.84351	0.7042	225	1719	13.089005	0.9859	334	982	34.01222	0.5352	139	260	53.46154	0.7042	473	1242	38.08374	0.6620	452	2418	18.693135	0.9507	385	3593	10.715280	0.8732	528	15.273358	0.6901	752	21.75296	0.42250	490	2896	16.91989	0.7606	57	886	6.433409	0.3099	150	3288	4.5620438	0.9437	458	3457	13.24848	0.7254	1324	21	1.586103	0.3873	0	0.000000	0.3451	50	1242	4.025765	0.9718	61	1242	4.911433	0.7113	34	3457	0.9835117	0.7535
42017100201	42	017	100201	PA	Pennsylvania	Bucks County	1	Northeast Region	2	Middle Atlantic Division	4127	1789	1605	576	4127	13.95687	0.7394	159	2197	7.237142	0.7042	521	1376	37.86337	0.8169	89	229	38.86463	0.3451	610	1605	38.00623	0.6479	457	2990	15.284281	0.8944	557	4264	13.062852	0.9577	601	14.562636	0.5915	839	20.32954	0.28170	429	3380	12.69231	0.6197	62	1165	5.321888	0.2183	135	3825	3.5294118	0.8803	887	4127	21.49261	0.8521	1789	0	0.000000	0.1444	244	13.638904	0.9648	37	1605	2.305296	0.9225	76	1605	4.735202	0.6901	0	4127	0.0000000	0.3275
42017100206	42	017	100206	PA	Pennsylvania	Bucks County	1	Northeast Region	2	Middle Atlantic Division	4815	2086	1828	860	4786	17.96908	0.8944	194	2661	7.290492	0.7254	426	1103	38.62194	0.8451	370	725	51.03448	0.6338	796	1828	43.54486	0.8592	237	3392	6.987028	0.5000	439	4765	9.213012	0.7887	452	9.387331	0.1620	1097	22.78297	0.50700	421	3746	11.23865	0.4507	180	1392	12.931035	0.7500	50	4570	1.0940919	0.5634	1095	4815	22.74143	0.8803	2086	189	9.060403	0.7042	25	1.198466	0.7887	0	1828	0.000000	0.2535	53	1828	2.899344	0.5563	34	4815	0.7061267	0.7113

# County
svi_2020_county <- rank_variables(svi_2020, rank_by = "county", location = county, state = state)
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
42017100102	42	017	100102	PA	Pennsylvania	Bucks County	1	Northeast Region	2	Middle Atlantic Division	2595	1375	1223	547	2595	21.078998	0.9366	162	1515	10.693069	0.9648	125	348	35.91954	0.9577	337	875	38.51429	0.3873	462	1223	37.77596	0.8803	179	2043	8.761625	0.8028	148	2595	5.703276	0.7465	545	21.001927	0.6690	311	11.98459	0.05634	342	2284	14.973730	0.7465	104	711	14.627285	0.7254	25	2493	1.002808	0.4648	480	2595	18.49711	0.6831	1375	422	30.69091	0.9366	25	1.818182	0.8451	58	1223	4.742437	0.9366	86	1223	7.031889	0.7324	0	2595	0.0000000	0.2042
42017100103	42	017	100103	PA	Pennsylvania	Bucks County	1	Northeast Region	2	Middle Atlantic Division	2375	1029	952	479	2375	20.168421	0.8803	50	1383	3.615329	0.4789	76	449	16.92650	0.1479	143	503	28.42942	0.2183	219	952	23.00420	0.2113	148	1688	8.767772	0.8099	143	2375	6.021053	0.7676	221	9.305263	0.0493	561	23.62105	0.79580	490	1814	27.012128	0.9930	197	612	32.189543	0.9789	71	2199	3.228740	0.8521	662	2375	27.87368	0.8592	1029	225	21.86589	0.8451	0	0.000000	0.3310	67	952	7.037815	0.9718	99	952	10.399160	0.8944	10	2375	0.4210526	0.6549
42017100104	42	017	100104	PA	Pennsylvania	Bucks County	1	Northeast Region	2	Middle Atlantic Division	5242	2034	1982	1733	5238	33.085147	0.9930	156	2950	5.288136	0.6972	130	611	21.27660	0.3239	721	1371	52.58935	0.7183	851	1982	42.93643	0.9648	610	3491	17.473503	1.0000	821	5238	15.673921	1.0000	609	11.617703	0.1479	1102	21.02251	0.60560	837	4138	20.227163	0.9296	236	1373	17.188638	0.7887	745	4776	15.598828	1.0000	3082	5242	58.79435	1.0000	2034	600	29.49853	0.9225	0	0.000000	0.3310	161	1982	8.123108	0.9930	444	1982	22.401615	1.0000	4	5242	0.0763068	0.4085
42017100105	42	017	100105	PA	Pennsylvania	Bucks County	1	Northeast Region	2	Middle Atlantic Division	3022	1259	1199	397	2942	13.494222	0.7746	137	1985	6.901763	0.8662	312	953	32.73872	0.9225	74	246	30.08130	0.2606	386	1199	32.19349	0.6972	95	2276	4.173990	0.4507	167	2957	5.647616	0.7324	420	13.898081	0.2817	468	15.48643	0.18310	241	2543	9.476996	0.2958	51	677	7.533235	0.4507	60	2882	2.081888	0.7465	362	3022	11.97882	0.4366	1259	163	12.94678	0.7042	0	0.000000	0.3310	0	1199	0.000000	0.2254	106	1199	8.840701	0.8451	176	3022	5.8239576	0.9366
42017100201	42	017	100201	PA	Pennsylvania	Bucks County	1	Northeast Region	2	Middle Atlantic Division	5061	1903	1836	444	4940	8.987854	0.5634	160	2803	5.708170	0.7676	513	1683	30.48128	0.8732	75	153	49.01961	0.6408	588	1836	32.02614	0.6761	440	3602	12.215436	0.9437	321	5061	6.342620	0.7958	645	12.744517	0.1901	935	18.47461	0.35920	503	4126	12.190984	0.5634	171	1277	13.390760	0.6690	280	4838	5.787515	0.9366	1638	5061	32.36515	0.9085	1903	0	0.00000	0.1232	211	11.087756	0.9718	29	1836	1.579521	0.7465	58	1836	3.159041	0.4507	5	5061	0.0987947	0.4296
42017100206	42	017	100206	PA	Pennsylvania	Bucks County	1	Northeast Region	2	Middle Atlantic Division	5333	2093	2011	449	5323	8.435093	0.5070	239	3326	7.185809	0.8873	304	1095	27.76256	0.7042	490	916	53.49345	0.7535	794	2011	39.48284	0.9085	499	3895	12.811296	0.9648	452	5302	8.525085	0.8944	646	12.113257	0.1620	942	17.66360	0.28170	682	4360	15.642202	0.7817	202	1549	13.040671	0.6620	276	5098	5.413888	0.9296	1970	5333	36.93981	0.9225	2093	555	26.51696	0.8873	0	0.000000	0.3310	91	2011	4.525112	0.9225	138	2011	6.862258	0.7254	0	5333	0.0000000	0.2042

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	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	EPL_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	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.2186	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	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.2186	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	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.2186	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	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.2186	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	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.2186	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	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.2186	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

Analysis: CDC SVI Index

As we previously discussed in the introduction, the CDC Social Vulnerability Index is a measure that allows us to identify areas of the United States that are particularly susceptible to difficulties during national disasters due to a lack of community resources and large amounts of disparities across social, physical, and economic factors:

Theme 1 is Socioeconomic Status
Theme 2 is Household Characteristics
Theme 3 is Racial & Ethnic Minority Status
Theme 4 is Housing Type & Transportation

Cupcake ipsum dolor sit amet cotton candy. Lollipop tiramisu cotton candy topping biscuit wafer jelly gingerbread danish. Pastry tart powder fruitcake brownie sweet shortbread. Muffin shortbread soufflé brownie liquorice topping gummies.

Tart cupcake cheesecake tart toffee cake jelly beans sweet roll. Sweet chocolate toffee dragée fruitcake gummies marshmallow lemon drops. Gummi bears sweet roll lemon drops jelly-o gummi bears halvah tiramisu gingerbread croissant. Caramels liquorice jujubes pastry sesame snaps cotton candy jelly-o icing.

National Analysis

Nationally, we find that the most & least vulnerable tracts by THEME1, THEME2, THEME3, THEME4, OVERALL for 2020 and 2010 are the following:

EXAMPLE RESPONSE:

# Calculate national SVI variables and flags for 2010
svi_2010_national <- svi_theme_variables(svi_2010_national)
svi_2010_national <- svi_theme_flags(svi_2010_national, .90)

# Find most vulnerable tracts in 2010 for THEME 1 - SES
svi_2010_national %>% filter(!is.na(F_THEME1)) %>% filter(E_TOTPOP_10 > 100) %>% arrange(desc(RPL_THEME1)) %>% head(10) %>% 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	F_POV150_10	E_UNEMP_10	ET_EMPSTATUS_10	EP_UNEMP_10	EPL_UNEMP_10	F_UNEMP_10	E_HBURD_OWN_10	ET_HOUSINGCOST_OWN_10	EP_HBURD_OWN_10	EPL_HBURD_OWN_10	F_HBURD_OWN_10	E_HBURD_RENT_10	ET_HOUSINGCOST_RENT_10	EP_HBURD_RENT_10	EPL_HBURD_RENT_10	F_HBURD_RENT_10	E_HBURD_10	ET_HOUSINGCOST_10	EP_HBURD_10	EPL_HBURD_10	F_HBURD_10	E_NOHSDP_10	ET_EDSTATUS_10	EP_NOHSDP_10	EPL_NOHSDP_10	F_NOHSDP_10	E_UNINSUR_12	ET_INSURSTATUS_12	EP_UNINSUR_12	EPL_UNINSUR_12	F_UNINSUR_12	E_AGE65_10	EP_AGE65_10	EPL_AGE65_10	E_AGE17_10	EP_AGE17_10	EPL_AGE17_10	F_AGE17_10	E_DISABL_12	ET_DISABLSTATUS_12	EP_DISABL_12	EPL_DISABL_12	F_DISABL_12	E_SNGPNT_10	ET_FAMILIES_10	EP_SNGPNT_10	EPL_SNGPNT_10	F_SNGPNT_10	E_LIMENG_10	ET_POPAGE5UP_10	EP_LIMENG_10	EPL_LIMENG_10	F_LIMENG_10	E_MINRTY_10	ET_POPETHRACE_10	EP_MINRTY_10	EPL_MINRTY_10	F_MINRTY_10	E_STRHU_10	E_MUNIT_10	EP_MUNIT_10	EPL_MUNIT_10	F_MUNIT_10	E_MOBILE_10	EP_MOBILE_10	EPL_MOBILE_10	F_MOBILE_10	E_CROWD_10	ET_OCCUPANTS_10	EP_CROWD_10	EPL_CROWD_10	F_CROWD_10	E_NOVEH_10	ET_KNOWNVEH_10	EP_NOVEH_10	EPL_NOVEH_10	F_NOVEH_10	E_GROUPQ_10	ET_HHTYPE_10	EP_GROUPQ_10	EPL_GROUPQ_10	F_GROUPQ_10	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
06065042505	06	065	042505	CA	California	Riverside County	4	West Region	9	Pacific Division	3860	956	817	2783	3845	72.37971	0.9905	1	291	1320	22.04545	0.9695	1	251	347	72.33429	0.9912	1	278	470	59.14894	0.8153	0	529	817	64.74908	0.9836	1	948	1634	58.01714	0.9922	1	1481	4073	36.36140	0.9668	1	99	2.564767	0.023850	1663	43.0829016	0.995100	1	280	2391	11.710581	0.3347	0	212	736	28.80435	0.833100	0	860	3317	25.927042	0.9676	1	3648	3860	94.50777	0.9391	1	956	55	5.753138	0.5628	0	33	3.451883	0.6480	0	302	817	36.964504	0.9965	1	52	817	6.364749	0.57210	0	0	3860	0.000000	0.3640	0	4.9026	0.9880	5	3.154350	0.81900	2	0.9391	0.9304	1	3.14340	0.7960	1	12.13945	0.9581	9
06079012800	06	079	012800	CA	California	San Luis Obispo County	4	West Region	9	Pacific Division	2407	51	51	252	319	78.99687	0.9956	1	58	98	59.18367	0.9997	1	0	0	NaN	NA	NA	51	51	100.00000	0.9973	1	51	51	100.00000	0.9997	1	1010	2255	44.78936	0.9675	1	34	105	32.38095	0.9436	1	68	2.825093	0.027780	16	0.6647279	0.006176	0	10	88	11.363636	0.3128	0	0	13	0.00000	0.007664	0	123	2391	5.144291	0.7574	0	1180	2407	49.02368	0.7095	0	51	13	25.490196	0.8515	0	0	0.000000	0.2198	0	0	51	0.000000	0.1238	0	0	51	0.000000	0.02586	0	2327	2407	96.676361	0.9969	1	4.9061	0.9880	5	1.111820	0.01755	0	0.7095	0.7029	0	2.21786	0.3426	1	8.94528	0.6405	6
12086001402	12	086	001402	FL	Florida	Miami-Dade County	3	South Region	5	South Atlantic Division	4698	1821	1558	3601	4655	77.35768	0.9946	1	424	1492	28.41823	0.9891	1	192	319	60.18809	0.9699	1	981	1239	79.17676	0.9788	1	1173	1558	75.28883	0.9972	1	1391	2527	55.04551	0.9887	1	1867	5070	36.82446	0.9688	1	660	14.048531	0.606600	1630	34.6956152	0.945600	1	653	3270	19.969419	0.7702	0	315	875	36.00000	0.907000	1	1312	4372	30.009149	0.9787	1	4486	4698	95.48744	0.9459	1	1821	520	28.555739	0.8714	0	0	0.000000	0.2198	0	190	1558	12.195122	0.9391	1	560	1558	35.943517	0.95170	1	0	4698	0.000000	0.3640	0	4.9384	0.9880	5	4.208100	0.98550	3	0.9459	0.9371	1	3.34600	0.8704	2	13.43840	0.9864	11
12086980700	12	086	980700	FL	Florida	Miami-Dade County	3	South Region	5	South Atlantic Division	748	30	30	682	748	91.17647	0.9989	1	114	203	56.15764	0.9996	1	0	0	NaN	NA	NA	30	30	100.00000	0.9973	1	30	30	100.00000	0.9997	1	272	480	56.66667	0.9907	1	560	917	61.06870	0.9992	1	0	0.000000	0.003233	130	17.3796791	0.150500	0	173	723	23.928078	0.8840	0	30	30	100.00000	0.999800	1	78	682	11.436950	0.8771	0	621	748	83.02139	0.8779	0	30	0	0.000000	0.1224	0	30	100.000000	1.0000	1	30	30	100.000000	1.0000	1	0	30	0.000000	0.02586	0	528	748	70.588235	0.9937	1	4.9881	0.9880	5	2.914633	0.71540	1	0.8779	0.8697	0	3.14196	0.7955	3	11.92259	0.9453	9
32003004301	32	003	004301	NV	Nevada	Clark County	4	West Region	8	Pacific Division	2029	631	507	1797	2029	88.56580	0.9983	1	166	721	23.02358	0.9740	1	14	22	63.63636	0.9790	1	332	485	68.45361	0.9280	1	346	507	68.24458	0.9909	1	711	893	79.61926	0.9998	1	1133	1908	59.38155	0.9990	1	63	3.104978	0.032440	925	45.5889601	0.997400	1	86	1096	7.846715	0.1199	0	181	436	41.51376	0.942300	1	606	1677	36.135957	0.9899	1	1834	2029	90.38935	0.9142	1	631	0	0.000000	0.1224	0	0	0.000000	0.2198	0	206	507	40.631164	0.9978	1	139	507	27.416174	0.92590	1	0	2029	0.000000	0.3640	0	4.9620	0.9880	5	3.081940	0.79010	3	0.9142	0.9057	1	2.62990	0.5570	2	11.58804	0.9202	11
32003004602	32	003	004602	NV	Nevada	Clark County	4	West Region	8	Pacific Division	3326	909	815	2068	3068	67.40548	0.9834	1	272	1370	19.85401	0.9555	1	113	240	47.08333	0.8806	0	449	575	78.08696	0.9761	1	562	815	68.95706	0.9920	1	1012	1577	64.17248	0.9972	1	1718	3259	52.71556	0.9978	1	247	7.426338	0.187900	1332	40.0481058	0.987800	1	241	1726	13.962920	0.4727	0	110	642	17.13396	0.584500	0	840	2903	28.935584	0.9763	1	2909	3326	87.46242	0.8990	0	909	78	8.580858	0.6358	0	69	7.590759	0.7359	0	222	815	27.239264	0.9895	1	91	815	11.165644	0.75250	0	161	3326	4.840649	0.8850	0	4.9259	0.9880	5	3.209200	0.83930	2	0.8990	0.8906	0	3.99870	0.9798	1	13.03280	0.9838	8
48113002701	48	113	002701	TX	Texas	Dallas County	3	South Region	7	West South Central Division	2205	1212	952	1848	2165	85.35797	0.9978	1	153	653	23.43032	0.9757	1	217	328	66.15854	0.9838	1	468	624	75.00000	0.9661	1	685	952	71.95378	0.9953	1	700	1532	45.69191	0.9703	1	1007	2578	39.06129	0.9773	1	339	15.374150	0.686200	541	24.5351474	0.542900	0	592	1839	32.191408	0.9785	1	161	448	35.93750	0.906500	1	172	2062	8.341416	0.8331	0	2158	2205	97.86848	0.9670	1	1212	195	16.089109	0.7619	0	0	0.000000	0.2198	0	23	952	2.415966	0.6206	0	402	952	42.226891	0.96400	1	0	2205	0.000000	0.3640	0	4.9164	0.9880	5	3.947200	0.97840	2	0.9670	0.9580	1	2.93030	0.7040	1	12.76090	0.9795	9
04013113900	04	013	113900	AZ	Arizona	Maricopa County	4	West Region	8	Pacific Division	1092	456	383	947	1092	86.72161	0.9980	1	47	218	21.55963	0.9667	1	53	73	72.60274	0.9915	1	208	310	67.09677	0.9164	1	261	383	68.14621	0.9907	1	290	413	70.21792	0.9990	1	371	1128	32.89007	0.9471	1	32	2.930403	0.029400	548	50.1831502	0.999100	1	49	596	8.221476	0.1367	0	154	183	84.15301	0.999200	1	167	888	18.806306	0.9361	1	1066	1092	97.61905	0.9643	1	456	131	28.728070	0.8722	0	0	0.000000	0.2198	0	67	383	17.493473	0.9678	1	203	383	53.002611	0.97910	1	0	1092	0.000000	0.3640	0	4.9015	0.9879	5	3.100500	0.79780	3	0.9643	0.9553	1	3.40290	0.8876	2	12.36920	0.9683	11
06037224310	06	037	224310	CA	California	Los Angeles County	4	West Region	9	Pacific Division	2459	682	634	1433	2459	58.27572	0.9585	1	328	1466	22.37381	0.9710	1	43	43	100.00000	0.9987	1	365	591	61.75973	0.8554	0	408	634	64.35331	0.9825	1	827	1456	56.79945	0.9908	1	1121	2282	49.12358	0.9957	1	170	6.913379	0.162400	537	21.8381456	0.358900	0	169	1739	9.718229	0.2138	0	140	397	35.26448	0.901400	1	1043	2291	45.525971	0.9973	1	2317	2459	94.22529	0.9371	1	682	312	45.747801	0.9365	1	0	0.000000	0.2198	0	330	634	52.050473	0.9995	1	259	634	40.851735	0.96150	1	191	2459	7.767385	0.9226	1	4.8985	0.9879	5	2.633800	0.56870	2	0.9371	0.9284	1	4.03990	0.9819	4	12.50930	0.9733	12
06037231220	06	037	231220	CA	California	Los Angeles County	4	West Region	9	Pacific Division	3750	1146	1084	2227	3725	59.78523	0.9637	1	360	1612	22.33251	0.9708	1	74	128	57.81250	0.9612	1	623	956	65.16736	0.8975	0	697	1084	64.29889	0.9823	1	962	1705	56.42229	0.9904	1	1529	3597	42.50765	0.9868	1	124	3.306667	0.036420	1165	31.0666667	0.870300	0	301	2514	11.972952	0.3503	0	392	818	47.92176	0.967700	1	977	3419	28.575607	0.9754	1	3677	3750	98.05333	0.9690	1	1146	378	32.984293	0.8941	0	32	2.792321	0.6272	0	329	1084	30.350554	0.9926	1	351	1084	32.380074	0.94240	1	0	3750	0.000000	0.3640	0	4.8940	0.9879	5	3.200120	0.83610	2	0.9690	0.9600	1	3.82030	0.9654	2	12.88342	0.9816	10

In 2010 the census tracts with a population greater than 100 that had the highest SVI vulnerabilities for THEME 1/SES were in California, Florida, Nevada, Texas, and Arizona.

# INSERT 2010 CODE THEME 2

DESCRIBE OUTPUT DATA 2010 CODE THEME 2

# INSERT 2010 CODE THEME 3

DESCRIBE OUTPUT DATA 2010 CODE THEME 3

# INSERT 2010 CODE THEME 4

DESCRIBE OUTPUT DATA 2010 CODE THEME 4

# INSERT 2010 CODE OVERALL

DESCRIBE OUTPUT DATA 2010 CODE OVERALL

EXAMPLE RESPONSE:

# Find most vulnerable national tracts in 2020 for THEME 1 - SES
svi_2020_national %>% filter(!is.na(F_THEME1)) %>% filter(E_TOTPOP_20 > 100) %>% arrange(desc(RPL_THEME1)) %>% head(10) %>% 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	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
12099008001	12	099	008001	FL	Florida	Palm Beach County	3	South Region	5	South Atlantic Division	4004	1149	998	2404	3625	66.31724	0.9883	1	520	1501	34.64357	0.9986	1	97	284	34.15493	0.862900	0	575	714	80.53221	0.9907	1	672	998	67.33467	0.9947	1	991	2296	43.16202	0.9832	1	776	3625	21.40690	0.9404	1	187	4.670330	0.02935	1116	27.87213	0.8363	0	716	2509	28.537266	0.94440	1	243	682	35.63050	0.9173	1	258	3780	6.825397	0.8189	0	3666	4004	91.55844	0.9188	1	1149	83	7.223673	0.5781	0	174	15.1436031	0.8566	0	72	998	7.214429	0.8624	0	275	998	27.55511	0.9321	1	445	4004	11.1138861	0.9517	1	4.9052	0.9887	5	3.54625	0.9392	2	0.9188	0.9110	1	4.1809	0.9856	2	13.55115	0.9879	10
12099008202	12	099	008202	FL	Florida	Palm Beach County	3	South Region	5	South Atlantic Division	4125	1392	1236	2893	4103	70.50938	0.9925	1	440	1592	27.63819	0.9958	1	27	200	13.50000	0.162300	0	774	1036	74.71042	0.9783	1	801	1236	64.80583	0.9918	1	1024	2406	42.56027	0.9821	1	936	4125	22.69091	0.9506	1	406	9.842424	0.17460	1286	31.17576	0.9265	1	628	2839	22.120465	0.81710	0	385	781	49.29577	0.9774	1	488	3703	13.178504	0.9127	1	4061	4125	98.44848	0.9792	1	1392	171	12.284483	0.6856	0	24	1.7241379	0.5976	0	228	1236	18.446602	0.9743	1	374	1236	30.25890	0.9414	1	0	4125	0.0000000	0.1831	0	4.9128	0.9887	5	3.80830	0.9729	3	0.9792	0.9709	1	3.3820	0.8716	2	13.08230	0.9859	11
48141001900	48	141	001900	TX	Texas	El Paso County	3	South Region	7	West South Central Division	1881	1026	825	1666	1881	88.56991	0.9991	1	107	526	20.34221	0.9852	1	0	23	0.00000	0.003312	0	506	802	63.09227	0.8967	0	506	825	61.33333	0.9849	1	711	1205	59.00415	0.9986	1	704	1881	37.42690	0.9948	1	484	25.730994	0.89730	454	24.13610	0.6499	0	603	1427	42.256482	0.99680	1	101	386	26.16580	0.8113	0	937	1788	52.404922	0.9995	1	1841	1881	97.87347	0.9724	1	1026	572	55.750487	0.9527	1	6	0.5847953	0.4944	0	77	825	9.333333	0.9045	1	406	825	49.21212	0.9769	1	0	1881	0.0000000	0.1831	0	4.9626	0.9887	5	4.35480	0.9881	2	0.9724	0.9642	1	3.5116	0.9058	3	13.80140	0.9882	11
48141002100	48	141	002100	TX	Texas	El Paso County	3	South Region	7	West South Central Division	2008	1272	831	1506	1997	75.41312	0.9959	1	118	739	15.96752	0.9653	1	11	88	12.50000	0.126800	0	456	743	61.37281	0.8754	0	467	831	56.19735	0.9668	1	795	1595	49.84326	0.9935	1	761	2001	38.03098	0.9954	1	365	18.177291	0.62790	311	15.48805	0.1536	0	702	1690	41.538461	0.99630	1	36	291	12.37113	0.4275	0	764	1974	38.703141	0.9966	1	1922	2008	95.71713	0.9509	1	1272	570	44.811321	0.9283	1	0	0.0000000	0.2186	0	18	831	2.166065	0.5543	0	353	831	42.47894	0.9677	1	338	2008	16.8326693	0.9654	1	4.9169	0.9887	5	3.20190	0.8496	2	0.9509	0.9429	1	3.6343	0.9323	3	12.70400	0.9811	11
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.80702	0.565000	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	543	20.48284	0.4073	0	211	1889	11.169931	0.26660	0	207	571	36.25219	0.9217	1	870	2539	34.265459	0.9937	1	2523	2651	95.17163	0.9465	1	943	540	57.264051	0.9549	1	0	0.0000000	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
06037540600	06	037	540600	CA	California	Los Angeles County	4	West Region	9	Pacific Division	5102	1119	1119	2828	5030	56.22266	0.9650	1	507	2053	24.69557	0.9930	1	165	409	40.34230	0.932100	1	551	710	77.60563	0.9859	1	716	1119	63.98570	0.9906	1	1148	2537	45.25030	0.9876	1	1195	5102	23.42219	0.9557	1	350	6.860055	0.07166	2038	39.94512	0.9938	1	268	3064	8.746736	0.13740	0	399	882	45.23810	0.9664	1	960	4291	22.372407	0.9698	1	5072	5102	99.41200	0.9911	1	1119	124	11.081323	0.6642	0	32	2.8596962	0.6499	0	230	1119	20.554066	0.9803	1	137	1119	12.24307	0.7892	0	42	5102	0.8232066	0.6652	0	4.8919	0.9886	5	3.13906	0.8270	3	0.9911	0.9827	1	3.7488	0.9523	1	12.77086	0.9823	10
13059140500	13	059	140500	GA	Georgia	Clarke County	3	South Region	5	South Atlantic Division	1909	934	909	1053	1670	63.05389	0.9830	1	191	860	22.20930	0.9895	1	79	204	38.72549	0.918400	1	509	705	72.19858	0.9684	1	588	909	64.68647	0.9916	1	482	1378	34.97823	0.9593	1	436	1670	26.10778	0.9704	1	334	17.496071	0.59130	276	14.45783	0.1223	0	353	1394	25.322812	0.89540	0	115	361	31.85596	0.8843	0	90	1819	4.947774	0.7658	0	1313	1909	68.77947	0.7885	0	934	16	1.713062	0.3633	0	366	39.1862955	0.9789	1	29	909	3.190319	0.6643	0	150	909	16.50165	0.8570	0	239	1909	12.5196438	0.9560	1	4.8938	0.9886	5	3.25910	0.8687	0	0.7885	0.7818	0	3.8195	0.9616	2	12.76090	0.9821	7
22033001104	22	033	001104	LA	Louisiana	East Baton Rouge Parish	3	South Region	7	West South Central Division	4068	2022	1504	3051	4022	75.85778	0.9961	1	324	1640	19.75610	0.9830	1	0	1	0.00000	0.003312	0	958	1503	63.73919	0.9048	1	958	1504	63.69681	0.9903	1	743	2113	35.16327	0.9601	1	1043	4044	25.79130	0.9690	1	195	4.793510	0.03071	1474	36.23402	0.9817	1	1046	2570	40.700389	0.99550	1	482	788	61.16751	0.9940	1	152	3420	4.444444	0.7474	0	3761	4068	92.45329	0.9253	1	2022	1420	70.227497	0.9722	1	0	0.0000000	0.2186	0	105	1504	6.981383	0.8561	0	524	1504	34.84043	0.9536	1	26	4068	0.6391347	0.6312	0	4.8985	0.9886	5	3.74931	0.9673	3	0.9253	0.9175	1	3.6317	0.9318	2	13.20481	0.9868	11
34031175200	34	031	175200	NJ	New Jersey	Passaic County	1	Northeast Region	2	Middle Atlantic Division	5403	1557	1495	3743	5402	69.28915	0.9915	1	284	2361	12.02880	0.9188	1	29	29	100.00000	0.999200	1	880	1466	60.02729	0.8566	0	909	1495	60.80268	0.9837	1	1351	2762	48.91383	0.9925	1	1913	5403	35.40626	0.9927	1	183	3.387007	0.01697	2288	42.34684	0.9967	1	244	3115	7.833066	0.09813	0	602	1172	51.36519	0.9819	1	1872	4877	38.384253	0.9964	1	5381	5403	99.59282	0.9934	1	1557	493	31.663455	0.8781	0	0	0.0000000	0.2186	0	573	1495	38.327759	0.9983	1	795	1495	53.17726	0.9812	1	5	5403	0.0925412	0.3945	0	4.8792	0.9886	5	3.09010	0.8076	3	0.9934	0.9850	1	3.4707	0.8956	2	12.43340	0.9753	11
34031175802	34	031	175802	NJ	New Jersey	Passaic County	1	Northeast Region	2	Middle Atlantic Division	7136	1807	1712	4060	7081	57.33653	0.9685	1	578	3490	16.56160	0.9697	1	0	66	0.00000	0.003312	0	960	1646	58.32321	0.8304	0	960	1712	56.07477	0.9662	1	1992	3853	51.69997	0.9951	1	2600	7136	36.43498	0.9939	1	377	5.283072	0.03808	2262	31.69843	0.9363	1	293	4874	6.011489	0.04125	0	566	1286	44.01244	0.9623	1	2748	6597	41.655298	0.9976	1	7093	7136	99.39742	0.9908	1	1807	556	30.769231	0.8733	0	0	0.0000000	0.2186	0	573	1712	33.469626	0.9965	1	806	1712	47.07944	0.9744	1	0	7136	0.0000000	0.1831	0	4.8934	0.9886	5	2.97553	0.7555	3	0.9908	0.9824	1	3.2459	0.8257	2	12.10563	0.9638	11

In 2020 the census tracts with a population greater than 100 that had the highest SVI vulnerabilities for THEME 1/SES were in Florida, Texas, California, Georgia, Louisiana, and New Jersey.

# INSERT 2020 CODE THEME 2

DESCRIBE OUTPUT DATA 2020 CODE THEME 2

# INSERT 2020 CODE THEME 3

DESCRIBE OUTPUT DATA 2020 CODE THEME 3

# INSERT 2020 CODE THEME 4

DESCRIBE OUTPUT DATA 2020 CODE THEME 4

# INSERT 2020 CODE OVERALL

DESCRIBE OUTPUT DATA 2020 CODE OVERALL

Pacific Division Analysis

In the Pacific Division, the most & least vulnerable tracts by THEME1, THEME2, THEME3, THEME4, OVERALL are below. They are particularly concentrated in [STATE]:

# INSERT 2010 CODE THEME 1

DESCRIBE OUTPUT DATA 2010 CODE THEME 1

# INSERT 2010 CODE THEME 2

DESCRIBE OUTPUT DATA 2010 CODE THEME 2

# INSERT 2010 CODE THEME 3

DESCRIBE OUTPUT DATA 2010 CODE THEME 3

# INSERT 2010 CODE THEME 4

DESCRIBE OUTPUT DATA 2010 CODE THEME 4

# INSERT 2010 CODE OVERALL

DESCRIBE OUTPUT DATA 2010 CODE OVERALL

# INSERT 2020 CODE THEME 1

DESCRIBE OUTPUT DATA 2020 CODE THEME 1

# INSERT 2020 CODE THEME 2

DESCRIBE OUTPUT DATA 2020 CODE THEME 2

# INSERT 2020 CODE THEME 3

DESCRIBE OUTPUT DATA 2020 CODE THEME 3

# INSERT 2020 CODE THEME 4

DESCRIBE OUTPUT DATA 2020 CODE THEME 4

# INSERT 2020 CODE OVERALL

DESCRIBE OUTPUT DATA 2020 CODE OVERALL

[Most Vulnerable State Analysis]

The most vulnerable state in the Pacific Division is [State]. The most and least vulnerable tracts by THEME1, THEME2, THEME3, THEME4, OVERALL are listed below and concentrated in [Counties]:

# INSERT 2010 CODE THEME 1

DESCRIBE OUTPUT DATA 2010 CODE THEME 1

# INSERT 2010 CODE THEME 2

DESCRIBE OUTPUT DATA 2010 CODE THEME 2

# INSERT 2010 CODE THEME 3

DESCRIBE OUTPUT DATA 2010 CODE THEME 3

# INSERT 2010 CODE THEME 4

DESCRIBE OUTPUT DATA 2010 CODE THEME 4

# INSERT 2010 CODE OVERALL

DESCRIBE OUTPUT DATA 2010 CODE OVERALL

# INSERT 2020 CODE THEME 1

DESCRIBE OUTPUT DATA 2020 CODE THEME 1

# INSERT 2020 CODE THEME 2

DESCRIBE OUTPUT DATA 2020 CODE THEME 2

# INSERT 2020 CODE THEME 3

DESCRIBE OUTPUT DATA 2020 CODE THEME 3

# INSERT 2020 CODE THEME 4

DESCRIBE OUTPUT DATA 2020 CODE THEME 4

# INSERT 2020 CODE OVERALL

DESCRIBE OUTPUT DATA 2020 CODE OVERALL