I decided I wanted to analyze the introduction of the vaccines to see how it affected those afflicted with the Corona virus. My general hope and belief was that the availability of the virus lowered the amount of new cases and stabilized the amount of deaths in the U.S.
I first started my analysis by downloading a .xslx data set from ourworldindata.com. With this data, I did some very menial data cleaning to sort out the unnecessary columns but made sure to keep the important ones such as total cases, new cases, total deaths, and people vaccinated. I did my best to keep the data as is, I don't know about you but I would hate to skew the data in favor of my bias'. I first plugged in the data into flourish.studio as is. This is not show my data in the way I wanted to because I forgot to normalize the data set in order to show a true relationship between them. You can see how I did that in the Excel File below:
Now let's take a look at the data visualizations I made:
There are a couple things to take away from this but lets go from left to right. The first thing I noticed is the huge spike in new cases around the holiday season of December 2020 but soon after in January 2021 we see a huge decline as the introduction of the first vaccines. Many events in January are the cause for this. We saw the American Heart Association pushing for faster vaccine rollout and pharmacies were being tapped to distribute vaccines around January 8th. At this point vaccines were allocated to older Americans, those with underlying health conditions, and healthcare workers but we also saw a push from the three pharma giants as they revealed their testing plans for younger adults.
Throughout the year, I was happy to see the number of new cases steadily decline up until August 2021 and we see that spike continue until the end of September 2021. Thankfully we see another sharp decline from that around October 2021.
What can you summarize from this data? Any insights you can offer to explain these peaks and dips? Let me know below!
Sources Cited:
Mathieu, E., Ritchie, H., Ortiz-Ospina, E. et al. A global database of COVID-19 vaccinations. Nat Hum Behav (2021)
Comments