Coronavirus Extra Credit Analysis

For this extra credit project, I used two datasets that had similar information about Covid-19, but had collected data on different areas. One of them analyzed coronavirus cases by country, looking at the greater picture of the whole world. This dataset is useful in comparing countries to each other and seeing if theres been an progress in numbers. The dataset contains variables such as “deaths”, “confirmed_cases”, “daily_confirmed_cases” and “daily_deaths.” The information was organized by the date and was recorded every day. We have information from the end of December until now so far.

The other dataset that I looked into was one that analyzed coronavirus cases by state in the United States. This helps us get a deeper look into not only how we’re doing overall as a country, but also how each state is doing. Using this dataset we can analyze and identify the problem areas and this can help us determine what extra safety measures we may need to add, as well as estimate how long it will take for that state to be able to safely open up. This dataset includes variables such as “confirmed_cases” and “deaths.” The information was also organized by date, and recorded statistics per day.

I used my notebook with cross dataset analysis to look at both datasets and see how people could use them together to benefit me. I joined the two datasets on the date variable so I could narrow it down to each day. Here is the chart for my first query along with the query itself:

I summed the deaths from both to see the total amount as one number for each. This is from March 15th, around the time that most states in the U.S. and even some countries started locking down and enforcing social distancing.

The query above is the same except for this time its from May 9th, so it shows the change in deaths from mid March to around now.

Now the queries show the confirmed cases. Again, this is from March 15, around the time when people especially in the U.S. were getting serious about social distancing.

This shows the significant change in confirmed cases both globally and by state from mid March to about now, showing an upward trend in possibly testing as well as actual confirmed cases. As we can see from the chart as well, there are many more cases, as the bar graph increases.