Skip to content

Latest commit

 

History

History
22 lines (20 loc) · 1.83 KB

README.md

File metadata and controls

22 lines (20 loc) · 1.83 KB
Raw

Italy Covid Data Analysis

This is a project about data covid in Italy per regions, where I did an exploratory analysis with SQL.

Language

alt text

About Datasets

ItaliaCovid

This dataset is composed by 16111 rows and 33 columns. This dataset is a merge between covidIta and Popolazione. The chosen period for the analysis goes from the beginning of the pandemic up to 04/04/2022. To know more about the columns of dataset check here.

PopFasciaVacc

This dataset is composed by 209977 rows and 16 columns. This dataset is a merge between covidItaVacc and platea. The chosen period for the analysis goes from the beginning of the vaccination period to 04/04/2022. To know more about the columns of dataset check here.

Summary of the analysis

  • Looking at total cases vs total deaths. Letality rate in your region daily.
  • Looking total cases vs Population. Show what percentage of population got Covid.
  • Looking at Regions with highest infection rate compared to population
  • Showing Regions with highest Death count per Population
  • Global Numbers
  • Positivity rate per region daily
  • Showing total somministration vaccin per region with resepct population
  • Showing total somministration vaccin per age-class by region