garbamoussa/data-teams-unite-personal-team

COVID-19 Mortality Risk Factors and economic policies

COVID-19 Mortality Risk Factors and economic policies

Hackathon for good , data-teams-unite-personal-team:

Participants:

GARBA Moussa, PhD
Dr Raouf Hajji, MD
Anand Nagasayanam

Mr Akhil Kumar

Research Question

Objective: To find the relationship between the sociodemographic and health service factors with the COVID-19 mortality in the United States. Predict the best policies/ the best time for reopening

Aim 1: Overview: Showing the chance of a patient who is diagnosed with COVID-19 in a specific county will die

Specifics: There will be a map of the US with all the counties and will also rank which counties are the worst to live in if you get COVID-19. The variables that will be taken into consideration: Location (county in the US), Smoker, Obesity, Drinking, ICU beds in each county, Healthcare professionals in each county (high, med, low), Quality of life, Physical environment, Corrected for Population Density, Number of tests conducted per 1000 Length of lockdown

Aim 2: Overview: Predicting the outcome of a patient who is diagnosed with COVID-19

Specifics: The user will input certain variables, Location (county in the US), Smoker, Obesity, Drinking. The output will be the predicted outcome of whether the user will die or not in a percentage. The variables that will be in the background ICU beds in each county, Healthcare professionals in each county (high, med, low), Quality of life, Physical environment Corrected for Population Density, Number of tests conducted per 1000, Length of lockdown

Datasets

• John Hopkins University Dataset for COVID 19 - (For Confirmed cases and Deaths)

• New York Times Covid Dataset

• COVID-19 US County level Summaries



• Economic and Unemployment county level details


Healthcare Workers.PNG

Methodology

• Exploratory Analysis of COVID-19 Mortality Risk Factors in the United States The current Covid-19 crisis has created unprecedented public health and economic emergency. The lockdown is trying to stop spreading the disease and its effects. The choice of the time and the process of reopening is crucial to solve these issues and prevent the potential second wave.

• Current understanding of the virus spread and its mortality pattern is limited; however, significant amounts of data have been collected and made publicly available.

• Objective: To find the relationship between the socio-demographic and health service factors with the COVID-19 mortality in the United States. Analyze the datasets on comorbidities, social and economic conditions, and healthcare system preparedness COVID 19 mortality per county.

  Decision tree

  Random Forest

Presentation link

• https://devpost.com/software/covid-19-mortality-risk-factors-in-the-united-states

Prerequisites for technical implementation

• Python 3
• BigQuery
• Databricks
• MLFlow
• Azure Microsoft
• R
• Python