This repository contains the code, final dataset, and source data files for an analysis that looks at how each state has responded to the COVID-19 pandemic, and how that may be related to the volume of cases and deaths experienced by that state. I leverage data on COVID-19 cases and deaths by state, combined with information on when each state implemented key policy decisions, to create a series of interactive dashboards that allow the user to explore these relationships further.
These dashboards, along with a short accompanying piece, were published by the Georgetown Public Policy Review in August 2020. The link to that publication can be found here.
You can find a brief summary of the files available in this repository below:
- COVID_dashboard.ipynb: Jupyter Notebook containing the code used to compile the datasets
- covid_policy.csv: Final state-level compiled dataset
- covid_party.csv: Final compiled dataset aggregated by party (averages for each party)
- Source_Data: Directory containing the four source data files
- daily.csv: Daily data on confirmed COVID-19 cases, by state
- Source: The COVID Tracking Project
- policy.xlsx: Data on policy responses by state
- governors.csv: Name and party of each state's governor
- Source: Ballotpedia
- population.xlsx: Yearly data on total population, by state
- Source: U.S. Census Bureau
- daily.csv: Daily data on confirmed COVID-19 cases, by state