Covid ETL

Project Description

Since Covid-19 came to the US in early 2020, the New York Times ("NYT") has been tracking data related to cases and deaths at the county level. For this project, we wanted to integrate these findings with data from the US Census to provide data analysts a resource for confirmed case and death numbers at the state and local level, as well as the impact of estimated mask-usage on cases and deaths in a given population.

Our database can be used to find data from the state or county level. It contains information about the number of cases and the number of deaths, and can be controlled for population using the estimated 2019 US Census Data. The estimated mask-usage data can be used to predict the effect of mask-usage at the state or county level.

Potential Questions for Analysis:

Is there a correlation between mask-usage and the number of cases by county?

Is there a correlation between mask-usage and the number of deaths by county?

Is there a correlation between mask-usage and the number of cases by state?

Is there a correlation between mask-usage and the number of deaths by state?

How many cases are there per 100,000 people by county?

How many cases are there per 100,000 people by state?

Is there a correlation between mask-usage and the population of a county?

---

Limitation of Mask-Usage Data

The survey that was performed to determine the estimated mask-usage numbers was performed from July 2- July 14 in 2020 with approximately 250,000 respondents. The ability to extrapolate from these numbers is therefore limited based on the time period. Data presented includes numbers only from July 14 onward. To read the NYT documentation on how this study was conducted, click here.