Abstract
Pandemics including COVID-19 have disproportionately affected socioeconomically vulnerable populations. To create a repeatable modelling process to identify regional population centers with pandemic vulnerability, readily available COVID-19 and socioeconomic variable datasets were compiled, and linear regression models were built during the early days of the COVID-19 pandemic. The models were validated later in the pandemic timeline using actual COVID-19 mortality rates in states with high population densities, with New York, New Jersey, Connecticut, Massachusetts, Louisiana, Michigan and Pennsylvania showing the strongest predictive results. Our models have been shared with the Department of Health Commissioners of each of these states as input into a much needed “pandemic playbook” for local healthcare agencies in allocating medical testing and treatment resources.
Competing Interest Statement
The authors have declared no competing interest.
Funding Statement
None
Author Declarations
I confirm all relevant ethical guidelines have been followed, and any necessary IRB and/or ethics committee approvals have been obtained.
Yes
The details of the IRB/oversight body that provided approval or exemption for the research described are given below:
Not applicable
All necessary patient/participant consent has been obtained and the appropriate institutional forms have been archived.
Yes
I understand that all clinical trials and any other prospective interventional studies must be registered with an ICMJE-approved registry, such as ClinicalTrials.gov. I confirm that any such study reported in the manuscript has been registered and the trial registration ID is provided (note: if posting a prospective study registered retrospectively, please provide a statement in the trial ID field explaining why the study was not registered in advance).
Yes
I have followed all appropriate research reporting guidelines and uploaded the relevant EQUATOR Network research reporting checklist(s) and other pertinent material as supplementary files, if applicable.
Yes
Data Availability
All data used in this manuscript are from publicly available sources. [3] COVID-19 Map. Johns Hopkins Coronavirus Resource Center, coronavirus.jhu.edu/map.html. [4] US Census Bureau, https://www.census.gov/data/tables/time-series/demo/popest/2010s-counties-total.html [5] CDC's Social Vulnerability Index (SVI). Centers for Disease Control and Prevention, Centers for Disease Control and Prevention, svi.cdc.gov/data-and-tools-download.html. [6] Davis, Larry. Corona Data Scraper, coronadatascraper.com/. [7] Coronavirus Live Map: US Coronavirus Cases by County. USAFacts, USAFacts, 23 June 2020, usafacts.org/visualizations/coronavirus-covid-19-spread-map/. [8] County Health Rankings, https://www.countyhealthrankings.org/ [9] Elflein, John. Trailing Seven Day Average Number of COVID 19 Deaths Select Countries Worldwide 2020. Statista, 24 June 2020, www.statista.com/statistics/1111867/trailing-seven-day-average-number-of-covid-19-deaths-select-countries-worldwide/. [10] IHME: COVID-19 Projections. Institute for Health Metrics and Evaluation, covid19.healthdata.org/united-states-of-america. [11] Bing & TomTom data from the Excel mapping tools ● Tableau Dashboard on Vulnerability: https://c19hcc.org/resource/vulnerable-population ● World Health Organization (WHO) dashboard: https://who.sprinklr.com/ ● Full list of datasets: https://cgdv.github.io/challenges/COVID-19/datasource/ ● Uninsured data: https://www.census.gov/data-tools/demo/sahie/#/data_2013 ● COVID-19 deaths by ethnicity: https://www.apmresearchlab.org/covid/deaths-by-race ● FIPS to Zip code mapping: https://data.world/niccolley/us-zipcode-to-county-state/workspace/file?filename=ZIP-COUNTY-FIPS_2018-03.csv ● Nursing Home (Medicare) by Zip code: https://data.medicare.gov/data/nursing-home-compare ● Johns Hopkins tracking of states that currently provide COVID data by ethnicity (https://coronavirus.jhu.edu/data/racial-data-transparency)
