Analyzing COVID-19 Impact in the US: Demographic, Economic, and Social Factors

The COVID-19 pandemic has had a great impact on the world, with the United States experiencing a disproportionately high burden in terms of infections and deaths compared to other nations. The virus has disrupted daily life across the country and highlighted longstanding health inequalities. Therefore, this study aims to analyze the correlation between total COVID-19 cases and deaths with various demographic variables such as median age, education level, race, ethnicity, income, unemployment rate, disability status, and insurance coverage. The goal is to identify groups of people who are disproportionately affected by the COVID-19 virus and the factors that contribute to this inequality. To achieve this, the study collects data from all 50 states in the United States, using authoritative sources such as the U.S. Census Bureau and the Bureau of Labor. Then, ETL process (Extract, Transform, and Load) is performed to obtain clean and refined datasets and compile them into a final table for correlation analysis. With the help of this study, public health officials and policymakers could initiate the development of targeted interventions to ensure that everybody has the same opportunity to achieve good health, regardless of their demographic, economic, and social status.