Week 3 Data Analysis

I used the data.gov website to search for Covid-19 deaths by state and the dataset has deaths by pneumonia, influenza, and a combination of all three diseases including Covid-19. I created the pivot table and chose to include only covid-19 cases by month until the month of October. I filtered the sum of Covid-19 deaths in the state of Florida and found that the cases have decreased from the peak number of 5,834 in August to only 828 in the month of October. Florida has a total of 16,055 total deaths by covid-19.

References

CDC. (2020). Provisional covid-19 death counts by week ending date and state. Data.gov. Retrieved from https://catalog.data.gov/dataset/provisional-covid-19-death-counts-by-week-ending-date-and-state-cc9bd