Name: OWID COVID19
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

OWID COVID19

Content

Widely available data on confirmed cases only becomes meaningful when it can be interpreted in light of how much a country is testing. This is why Our World in Data built the global database on COVID-19 testing [1]. The additional smoothing and per capita rates make different countries (somewhat) comparable.

Our World in Data also had a good overview of global cause of death two years ago [2] I shared that data as well for additional comparisons.

Acknowledgements

[1] Max Roser, Hannah Ritchie, Esteban Ortiz-Ospina and Joe Hasell (2020) - "Coronavirus Pandemic (COVID-19)". Published online at OurWorldInData.org. https://ourworldindata.org/coronavirus

[2] Hannah Ritchie (2018) - "Causes of Death". Published online at OurWorldInData.org. https://ourworldindata.org/causes-of-death

Inspiration

First and second wave differences in Europe
Global Forecasting for total 2020 numbers
Covid death toll compared to main cause of death

Tables

Annual Number Of Deaths By Cause

@kaggle.gaborfodor_owid_covid19.annual_number_of_deaths_by_cause

1.96 MB
6,686 rows
37 columns

CREATE TABLE annual_number_of_deaths_by_cause (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "number_of_executions_amnesty_international" VARCHAR  -- Number Of Executions (Amnesty International),
  "deaths_road_injuries_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Road Injuries - Sex: Both - Age: All Ages (Number),
  "deaths_cirrhosis_and_other_chronic_liver_diseases_sex__97badbdc" DOUBLE  -- Deaths - Cirrhosis And Other Chronic Liver Diseases - Sex: Both - Age: All Ages (Number),
  "deaths_digestive_diseases_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Digestive Diseases - Sex: Both - Age: All Ages (Number),
  "deaths_tuberculosis_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Tuberculosis - Sex: Both - Age: All Ages (Number),
  "deaths_hiv_aids_sex_both_age_all_ages_number" DOUBLE  -- Deaths - HIV/AIDS - Sex: Both - Age: All Ages (Number),
  "deaths_diarrheal_diseases_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Diarrheal Diseases - Sex: Both - Age: All Ages (Number),
  "deaths_intestinal_infectious_diseases_sex_both_age_all_cb26269f" DOUBLE  -- Deaths - Intestinal Infectious Diseases - Sex: Both - Age: All Ages (Number),
  "deaths_lower_respiratory_infections_sex_both_age_all_a_04c08283" DOUBLE  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: All Ages (Number),
  "deaths_meningitis_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Meningitis - Sex: Both - Age: All Ages (Number),
  "deaths_drowning_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Drowning - Sex: Both - Age: All Ages (Number),
  "deaths_alzheimer_disease_and_other_dementias_sex_both__7163b391" DOUBLE  -- Deaths - Alzheimer Disease And Other Dementias - Sex: Both - Age: All Ages (Number),
  "deaths_parkinson_disease_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Parkinson Disease - Sex: Both - Age: All Ages (Number),
  "deaths_alcohol_use_disorders_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Alcohol Use Disorders - Sex: Both - Age: All Ages (Number),
  "deaths_drug_use_disorders_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Drug Use Disorders - Sex: Both - Age: All Ages (Number),
  "deaths_malaria_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Malaria - Sex: Both - Age: All Ages (Number),
  "deaths_maternal_disorders_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Maternal Disorders - Sex: Both - Age: All Ages (Number),
  "deaths_neonatal_disorders_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Neonatal Disorders - Sex: Both - Age: All Ages (Number),
  "deaths_nutritional_deficiencies_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Nutritional Deficiencies - Sex: Both - Age: All Ages (Number),
  "deaths_diabetes_mellitus_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Diabetes Mellitus - Sex: Both - Age: All Ages (Number),
  "deaths_chronic_kidney_disease_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Chronic Kidney Disease - Sex: Both - Age: All Ages (Number),
  "deaths_chronic_respiratory_diseases_sex_both_age_all_a_5fe95eb3" DOUBLE  -- Deaths - Chronic Respiratory Diseases - Sex: Both - Age: All Ages (Number),
  "deaths_conflict_and_terrorism_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Conflict And Terrorism - Sex: Both - Age: All Ages (Number),
  "deaths_hepatitis_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Hepatitis - Sex: Both - Age: All Ages (Number),
  "deaths_neoplasms_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Neoplasms - Sex: Both - Age: All Ages (Number),
  "deaths_fire_heat_and_hot_substances_sex_both_age_all_a_a15461ab" DOUBLE  -- Deaths - Fire, Heat, And Hot Substances - Sex: Both - Age: All Ages (Number),
  "deaths_poisonings_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Poisonings - Sex: Both - Age: All Ages (Number),
  "deaths_exposure_to_forces_of_nature_sex_both_age_all_a_da879c0d" DOUBLE  -- Deaths - Exposure To Forces Of Nature - Sex: Both - Age: All Ages (Number),
  "deaths_environmental_heat_and_cold_exposure_sex_both_a_d4f48874" DOUBLE  -- Deaths - Environmental Heat And Cold Exposure - Sex: Both - Age: All Ages (Number),
  "deaths_protein_energy_malnutrition_sex_both_age_all_ag_9b9b0ecc" DOUBLE  -- Deaths - Protein-energy Malnutrition - Sex: Both - Age: All Ages (Number),
  "deaths_cardiovascular_diseases_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Cardiovascular Diseases - Sex: Both - Age: All Ages (Number),
  "deaths_self_harm_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Self-harm - Sex: Both - Age: All Ages (Number),
  "deaths_interpersonal_violence_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Interpersonal Violence - Sex: Both - Age: All Ages (Number),
  "terrorism_deaths" DOUBLE  -- Terrorism (deaths)
);

Owid Covid Data

@kaggle.gaborfodor_owid_covid19.owid_covid_data

2.25 MB
52,873 rows
41 columns

CREATE TABLE owid_covid_data (
  "iso_code" VARCHAR,
  "continent" VARCHAR,
  "location" VARCHAR,
  "date" TIMESTAMP,
  "total_cases" DOUBLE,
  "new_cases" DOUBLE,
  "new_cases_smoothed" DOUBLE,
  "total_deaths" DOUBLE,
  "new_deaths" DOUBLE,
  "new_deaths_smoothed" DOUBLE,
  "total_cases_per_million" DOUBLE,
  "new_cases_per_million" DOUBLE,
  "new_cases_smoothed_per_million" DOUBLE,
  "total_deaths_per_million" DOUBLE,
  "new_deaths_per_million" DOUBLE,
  "new_deaths_smoothed_per_million" DOUBLE,
  "total_tests" DOUBLE,
  "new_tests" DOUBLE,
  "total_tests_per_thousand" DOUBLE,
  "new_tests_per_thousand" DOUBLE,
  "new_tests_smoothed" DOUBLE,
  "new_tests_smoothed_per_thousand" DOUBLE,
  "tests_per_case" DOUBLE,
  "positive_rate" DOUBLE,
  "tests_units" VARCHAR,
  "stringency_index" DOUBLE,
  "population" DOUBLE,
  "population_density" DOUBLE,
  "median_age" DOUBLE,
  "aged_65_older" DOUBLE,
  "aged_70_older" DOUBLE,
  "gdp_per_capita" DOUBLE,
  "extreme_poverty" DOUBLE,
  "cardiovasc_death_rate" DOUBLE,
  "diabetes_prevalence" DOUBLE,
  "female_smokers" DOUBLE,
  "male_smokers" DOUBLE,
  "handwashing_facilities" DOUBLE,
  "hospital_beds_per_thousand" DOUBLE,
  "life_expectancy" DOUBLE,
  "human_development_index" DOUBLE
);