Analyzing Covid-19 Data on the World (July 2022)
GitHub
Repository: HERE
Handled
with: Microsoft SQL Server
Management Studio 18, Microsoft Excel, Tableau
Programming
Language: SQL
Why
I did do this Project?
My initial
journey began at https://ourworldindata.org/covid-deaths where I downloaded some interesting data regarding
Covid-19. Here my initial focus was to analyze the deaths around the world to
get a better understanding of where "we" were as a society in regard
to the significant impact the coronavirus has had nationwide. I've kept my
distance from news articles and news channels as it felt (personally) like
fear-mongering. This is fair (to a degree) since this all happened so fast and
no one had a clue of the devastating amount of damage it can do. Anyways, I
felt this project was very much needed for me as a reminder of where we started
and to determine if we have made any progress since its initial stages.
A
Brief History
The Coronavirus
also referred to as Covid-19 is a highly contagious disease that has spread
nationwide. This damaging virus spread rapidly whereby nationally the virus was
declared a Pandemic and a national emergency was declared on March 13, 2020. To
this day there is no absolute cure for this virus.
Where
Are We Now?
There are
available vaccines present. I'm by all means not a doctor but from what I
understand the vaccine is meant to reduce the likelihood of deadly occurrences
by injecting a micro amount of the virus into the human body. Whereby, the body
builds up a stronger tolerance for fighting off the disease. This doesn't mean
if you get the vaccine you are impenetrable to Covid! It can still happen and
general safety measures are still applied.
General
Safety Measures If You Have Covid-19
1.
Self-isolation to avoid the risk of spreading the disease approximately for 7
days or 14 days (as of writing this).
2.
Immediately let others know you have become infected (yes, it can be awkward
but better safe than sorry. It also gives them a chance to test and see if
they've become infected as well).
3.
If you need to go out it is highly advised to wear a mask to protect others
around you.
4.
Take care of yourself with proper fluids and meals with high nutrients (I found
this link useful if you are curious about which foods to eat -> (https://www.healthline.com/nutrition/what-to-eat-with-covid#1.-Vitamin-D).
Have
I ever had Covid-19?
Unfortunately,
the answer to that question is Yes. I had it in November 2021 near Los Angeles,
CA during my time as an electrical helper when my boss, colleagues, and I went
to a Shakey's Pizza. While definitely, I cannot say exactly how it happened. All
I can deduce was that I and my colleagues were careless and did not take basic
safety precautions in an unknown area during a nationwide pandemic. Anyways, I
personally had a horrible experience with it. It began with feeling fatigue in
my legs, out of breath, felt tired mentally, and of course, I lost both my
smell and taste for about 2 weeks. I isolated myself in my room surviving on
cups of noodles (with lots of hot sauce to stimulate my taste buds) and
tangerines. All of this during the week of my birthday as well. All this to say
I am 100% back to normal as of writing this and while my experience was not
pleasant it's still nowhere near the amount of damage this disease has caused
to other family members and economically to our world. So let's just say this
project expands further than just random curiosity.
Covid-19
Analysis
Analysis #1: Top 10 Countries with High Infection Rates (U.S Rank #57 with 26%)
Conclusion
While
it doesn't surprise me that the United States leads nationally in death count
as of July 2022. What I found the most fascinating was the fact that nationally
from the data there is a 1% chance of a fatality from Covid-19.
Comparatively, I don't personally have the entire history of Covid-19. However,
I do have some comparative statistics derived from https://ourworldindata.org/covid-deaths using the Case-fatality rate metric for specific
countries. According to the data, the U.S had a peak fatality rate of 10.91%
on May 2, 2020. Another impressive statistic is the country that had the
biggest percentage reduction which would be the United Kingdom with a peak
fatality rate of 22.81% on April 20, 2020, which has now been reduced to 0.88%
as of July 31st, 2022. This shows me that our society has made progress throughout the
pandemic.
Another interesting statistic was that the U.S in its entire population
has a quarter of its entire population of people who got Covid-19. To put that
into perspective the U.S has roughly 329.5 million people. Therefore,
approximately 85,670,000 people have had Covid-19.
Thanks
Here
I wanted to show the highlights of my findings as well as show how the data was
derived. In future projects, I intend to add more graphs to make the data more convenient to follow. Covid remains
to this day still a very contagious virus it is our responsibility to limit its
spread as much as we possibly can to reduce its impact on the world. Thank you
for taking the time to read all of this and I hope you have a nice day :)