COVID-19 Global SQL Analysis

SQL-based analysis of global COVID-19 data across 60 countries using Python, SQLite and Pandas on Kaggle.

Live Notebook

View on Kaggle

Queries Covered

1. Top 10 Countries by Total Cases
2. Top 10 Countries by Death Rate
3. Total Cases, Deaths and Recoveries by Continent
4. Average Recovery Rate by Continent
5. Countries with Death Rate above 2%
6. Most Affected Countries per Million Population
7. Countries with Highest Active Cases
8. Continent with Best and Worst Recovery and Death Rates
9. Countries where Recovery Rate Exceeds 95%
10. Overall Global Summary

Tools Used

• Python (pandas, sqlite3)
• SQL (SQLite)
• Kaggle Notebooks

Dataset

• Source: Our World in Data — COVID-19
• 60 countries, 11 features