SQL_Portfolio_DataExploration

Coronavirus (COVID-19) Data Exploration using SQL

Data set: https://ourworldindata.org/covid-deaths

coronavirus-data-explorer

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

1

Initial Data of Covid Vaccinations

2

Select Location, date, total_cases, new_cases, total_deaths, population

3

total case vs total deaths % in Canada

4

total case vs total deaths % in Canada

5

total case vs total population % in Canada

6

Countries with highest infection rate %

7

Countries with highest death

8

Datewise global total cases, deaths & deathrate

Datewise addition of total cases & deaths across the globe. And also death vs case %.

9

Global total number: total cases, total deaths and death %

10

Countrywise Rolling People Vaccinated

Total number of vaccinated people added each day/ datewise in a particular country

16

Total population vs Rolling People Vaccinated %

17

Creating view to store data for visualization

13