Global COVID-19 Deaths: Data Exploration
Explore the global data on confirmed COVID-19 deaths between 24 Feb 2020 and 16 December 2022
Data source: Our World in Data COVID-19 dataset
Performed the following tasks:
- Starting with location, date, total_cases, new_cases, total_deaths, population
- Total Cases vs Total Deaths in the United Kingdom
- Total Cases vs Population in the United Kingdom
- Countries with Highest Infection Rate compared to Population
- Countries with Highest Death Count per Population
- Using CTE to perform Calculation on Partition By in previous query
- Comparison between Total population and Covid Vaccinations
- Using Temp Table to perform Calculation on Partition By in previous query
- Creating View to store data for later visualizations