Coronavirus (COVID-19) Data Exploration using SQL
Data set: https://ourworldindata.org/covid-deaths
Number of rows 339,462 in table of Covid Deaths
Number of rows 339,562 in table of Covid Vaccinations
Initial Data of Covid Deaths
Initial Data of Covid Vaccinations
Select Location, date, total_cases, new_cases, total_deaths, population
total case vs total deaths % in Canada
total case vs total deaths % in Canada
total case vs total population % in Canada
Countries with highest infection rate %
Countries with highest death
Datewise global total cases, deaths & deathrate
Datewise addition of total cases & deaths across the globe. And also death vs case %.
Global total number: total cases, total deaths and death %
Countrywise Rolling People Vaccinated
Total number of vaccinated people added each day/ datewise in a particular country
Total population vs Rolling People Vaccinated %
Creating view to store data for visualization