Skip to content

Used SQL queries to perform data analysis of the COVID-19 pandemic, exploring key trends, statistics, and insights sourced from Our World in Data.

Notifications You must be signed in to change notification settings

jianninapinto/COVID19_Crisis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Crisis in Numbers: COVID-19 Data Analysis Project

Introduction

This repository contains an analysis of COVID-19 data sourced from Our World in Data. The project explores various aspects of the COVID-19 pandemic using SQL queries and data manipulation techniques.

Dataset

The COVID-19 dataset used in this analysis is provided by Our World in Data. It includes data on cases, deaths, vaccinations, and population statistics from various locations around the world.

Project Scope

The scope of this project includes:

  • Data exploration and analysis using SQL queries.
  • Calculation of key COVID-19 statistics, including cases, deaths, and vaccination rates.
  • Demonstration of SQL skills, including joins, CTEs, window functions, and more.

Skills Demonstrated

This project demonstrates proficiency in the following SQL skills and techniques:

  • Joins
  • Common Table Expressions (CTEs)
  • Window Functions
  • Temporary Tables
  • Aggregate Functions
  • View Creation
  • Data Type Conversion

Queries and Analysis

The project comprises several SQL queries and analyses, including:

  • Total cases and deaths by location and over time.
  • Likelihood of dying from COVID-19 in specific locations.
  • Percentage of population infected with COVID-19.
  • Identification of countries with high infection rates relative to population.
  • Analysis of death counts and rates by location and continent.
  • Global COVID-19 trends and statistics.

Acknowledgments

I acknowledge the valuable COVID-19 data provided by Our World in Data and the open-source community for their contributions to the data used in this project.

About

Used SQL queries to perform data analysis of the COVID-19 pandemic, exploring key trends, statistics, and insights sourced from Our World in Data.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published