dep_index

A Nationwide Community Deprivation Index

Citation for Scientific Publications: If you use the deprivation index in a scientific publication, please cite our manuscript detailing its creation and application to health outcomes:

Cole Brokamp, Andrew F. Beck, Neera K. Goyal, Patrick Ryan, James M. Greenberg, Eric S. Hall. Material Community Deprivation and Hospital Utilization During the First Year of Life: An Urban Population-Based Cohort Study. Annals of Epidemiology. 30. 37-43. 2019. Download.

2018 Update: The 2018_dep_index folder contains an version of the same deprivation index, but updated with data from the 2018 5-yr American Community Survey data. See the 2018 README for details on getting and using the data at the census tract and ZIP code level.

---

Overview

Socioeconomic variables from the American Community Survey (ACS) are frequently used in place of or in addition to individual confounders in observational studies. There are several census tract level measures that can be used to capture “community deprivation” and they are often highly correlated, e.g., median household income and educational attainment. Choosing only one ACS measure might not capture the entirety of community deprivation, but using more than one ACS measure can lead to problems in statistical models due to colinearity.

Here, we create a deprivation index for each census tract in the United States based on a principal components analysis of six different 2015 ACS measures. The first component explains over 60% of the total variance present in the five different ACS measures and is dubbed the “Deprivation Index”. Rescaling and normalizing forces the index to range from 0 to 1, with a higher index being more deprived.

The high resolution of the tract level is masked when using a nationwide scale. Click one of the maps or visit http://dep-index.s3-website.us-east-2.amazonaws.com/ to view an interactive, nationwide map online. Below is an example of how the index looks across the Greater Cincinnati, Ohio area:

Getting the data

Download the CSV file

The data is contained in a CSV file called ACS_deprivation_index_by_census_tracts.csv which is a table of 73,056 census tracts listed by their FIPS ID and corresponding deprivation index. Also included for each tract are the six individual ACS measures used to create the deprivation index.

Import Directly Into R

Use the following code to download the deprivation index data.frame directly into R:

dep_index <- 'https://github.com/geomarker-io/dep_index/raw/master/ACS_deprivation_index_by_census_tracts.rds' %>% 
    url() %>% 
    gzcon() %>% 
    readRDS() %>% 
    as_tibble()

ZIP Code Deprivation Index

The deprivation index is also available by zip codes, denoted using the ZIP Code Tabulation Area (ZCTA) boundaries. The value for each ZCTA is calculated as the mean of all of its intersecting census tracts. Download the file called ACS_deprivation_index_by_zipcode.csv or use the above code to read it into R by replacing the RDS file name with ACS_deprivation_index_by_zipcode.rds.

Details on Creating the Index

The following census tract level variables were derived from the 2015 5-year American Community Survey:

• fraction_poverty: fraction of population with income in past 12 months below poverty level
• median_income: median household income in the past 12 months in 2015 inflation-adjusted dollars
• fraction_high_school_edu: fraction of population 25 and older with educational attainment of at least high school graduation (includes GED equivalency)
• fraction_no_health_ins: fraction of poulation with no health insurance coverage
• acs_assisted_income: fraction of households receiving public assistance income or food stamps or SNAP in the past 12 months
• fraction_vacant_housing: fraction of houses that are vacant

Looking at a pairs plot of all the ACS estimates, we can see that they are mostly highly correlated with one another:

Carrying out a principal component analysis results in six components, with the first explaining over 70% of the total variance in the six ACS measures:

Looking at the loading weights used to calculate the principal components, we can see that (other than the fraction of vacant housing) the first component is somewhat equally weighted by each ACS measure, each in the expected direction such that a higher first component value is associated with higher deprivation.

The first component is dubbed the “Deprivation Index”; rescaling and normalizing forces the index to range from 0 to 1, with a higher index being more deprived.

Applying the weights to the data for all census tracts leads to a deprivation index assignment for US census tracts with non-missing ACS measures. 999 of the 73,056 total US census tracts have a missing value for the deprivation index because of a missing value for one or more of the underlying ACS measures.

We calculated the nationwide mean (0.37) and standard error (0.0006) for the deprivation index by weighting each tract-level deprivation index by its population under age 18. Details are in the weighted_avg/dep_index_pop_under_18_weighted_avg.R file.

Measure	2015 Deprivation Index	2018 Deprivation Index
Mean	0.37	0.35
Standard Error	0.0006	0.0006
25th percentile	0.27	0.25
Median	0.36	0.33
75th percentile	0.46	0.43

We can verify the relationship between the deprivation index and each of the ACS measures individually with scatter plots:

Reproducibility

01_make_data_for_dep_index.R is used to fetch the ACS census tract level data and then 02_pca_on_dep_index_data.R is used to carry out the principal components analysis, create the deprivation index, and create the images used in this document. 03_calculate_dep_index_by_ZCTA.R calculates each measurement and deprivation index for each ZIP code.