Name: Covid-19 Dataset
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

Covid-19 Dataset

Context

This dataset is a collection of the COVID-19 data maintained by Our World in Data.

Content

The CSV and XLSX files follow a format of 1 row per location and date. The JSON version is split by country ISO code, with static variables and an array of daily records.

The variables represent all of our main data related to confirmed cases, deaths, hospitalizations, and testing, as well as other variables of potential interest.

Confirmed cases

Variable	Description
`total_cases`	Total confirmed cases of COVID-19
`new_cases`	New confirmed cases of COVID-19
`new_cases_smoothed`	New confirmed cases of COVID-19 (7-day smoothed)
`total_cases_per_million`	Total confirmed cases of COVID-19 per 1,000,000 people
`new_cases_per_million`	New confirmed cases of COVID-19 per 1,000,000 people
`new_cases_smoothed_per_million`	New confirmed cases of COVID-19 (7-day smoothed) per 1,000,000 people

Confirmed deaths

Variable	Description
`total_deaths`	Total deaths attributed of COVID-19
`new_deaths`	New deaths attributed of COVID-19
`new_deaths_smoothed`	New deaths attributed of COVID-19 (7-day smoothed)
`total_deaths_per_million`	Total deaths attributed of COVID-19 per 1,000,000 people
`new_deaths_per_million`	New deaths attributed of COVID-19 per 1,000,000 people
`new_deaths_smoothed_per_million`	New deaths attributed of COVID-19 (7-day smoothed) per 1,000,000 people

Hospital & ICU

Variable	Description
`icu_patients`	Number of COVID-19 patients in intensive care units (ICUs) on a given day
`icu_patients_per_million`	Number of COVID-19 patients in intensive care units (ICUs) on a given day per 1,000,000 people
`hosp_patients`	Number of COVID-19 patients in hospital on a given day
`hosp_patients_per_million`	Number of COVID-19 patients in hospital on a given day per 1,000,000 people
`weekly_icu_admissions`	Number of COVID-19 patients newly admitted to intensive care units (ICUs) in a given week
`weekly_icu_admissions_per_million`	Number of COVID-19 patients newly admitted to intensive care units (ICUs) in a given week per 1,000,000 people
`weekly_hosp_admissions`	Number of COVID-19 patients newly admitted to hospitals in a given week
`weekly_hosp_admissions_per_million`	Number of COVID-19 patients newly admitted to hospitals in a given week per 1,000,000 people

Policy responses

Variable	Description
`stringency_index`	Government Response Stringency Index: composite measure based on 9 response indicators including school closures, workplace closures, and travel bans, rescaled to a value from 0 to 100 (100 = strictest response)

Reproduction rate

Variable	Description
`reproduction_rate`	Real-time estimate of the effective reproduction rate (R) of COVID-19. See https://github.com/crondonm/TrackingR/tree/main/Estimates-Database

Tests & positivity

Variable	Description
`total_tests`	Total tests for COVID-19
`new_tests`	New tests for COVID-19 (only calculated for consecutive days)
`total_tests_per_thousand`	Total tests for COVID-19 per 1,000 people
`new_tests_per_thousand`	New tests for COVID-19 per 1,000 people
`new_tests_smoothed`	New tests for COVID-19 (7-day smoothed). For countries that don't report testing data on a daily basis, we assume that testing changed equally on a daily basis over any periods in which no data was reported. This produces a complete series of daily figures, which is then averaged over a rolling 7-day window
`new_tests_smoothed_per_thousand`	New tests for COVID-19 (7-day smoothed) per 1,000 people
`positive_rate`	The share of COVID-19 tests that are positive, given as a rolling 7-day average (this is the inverse of tests_per_case)
`tests_per_case`	Tests conducted per new confirmed case of COVID-19, given as a rolling 7-day average (this is the inverse of positive_rate)
`tests_units`	Units used by the location to report its testing data

Vaccinations

Variable	Description
`total_vaccinations`	Total number of COVID-19 vaccination doses administered
`people_vaccinated`	Total number of people who received at least one vaccine dose
`people_fully_vaccinated`	Total number of people who received all doses prescribed by the vaccination protocol
`total_boosters`	Total number of COVID-19 vaccination booster doses administered (doses administered beyond the number prescribed by the vaccination protocol)
`new_vaccinations`	New COVID-19 vaccination doses administered (only calculated for consecutive days)
`new_vaccinations_smoothed`	New COVID-19 vaccination doses administered (7-day smoothed). For countries that don't report vaccination data on a daily basis, we assume that vaccination changed equally on a daily basis over any periods in which no data was reported. This produces a complete series of daily figures, which is then averaged over a rolling 7-day window
`total_vaccinations_per_hundred`	Total number of COVID-19 vaccination doses administered per 100 people in the total population
`people_vaccinated_per_hundred`	Total number of people who received at least one vaccine dose per 100 people in the total population
`people_fully_vaccinated_per_hundred`	Total number of people who received all doses prescribed by the vaccination protocol per 100 people in the total population
`total_boosters_per_hundred`	Total number of COVID-19 vaccination booster doses administered per 100 people in the total population
`new_vaccinations_smoothed_per_million`	New COVID-19 vaccination doses administered (7-day smoothed) per 1,000,000 people in the total population

Others

Variable	Description
`iso_code`	ISO 3166-1 alpha-3 – three-letter country codes
`continent`	Continent of the geographical location
`location`	Geographical location
`date`	Date of observation
`population`	Population in 2020
`population_density`	Number of people divided by land area, measured in square kilometers, most recent year available
`median_age`	Median age of the population, UN projection for 2020
`aged_65_older`	Share of the population that is 65 years and older, most recent year available
`aged_70_older`	Share of the population that is 70 years and older in 2015
`gdp_per_capita`	Gross domestic product at purchasing power parity (constant 2011 international dollars), most recent year available
`extreme_poverty`	Share of the population living in extreme poverty, most recent year available since 2010
`cardiovasc_death_rate`	Death rate from cardiovascular disease in 2017 (annual number of deaths per 100,000 people)
`diabetes_prevalence`	Diabetes prevalence (% of population aged 20 to 79) in 2017
`female_smokers`	Share of women who smoke, most recent year available
`male_smokers`	Share of men who smoke, most recent year available
`handwashing_facilities`	Share of the population with basic handwashing facilities on premises, most recent year available
`hospital_beds_per_thousand`	Hospital beds per 1,000 people, most recent year available since 2010
`life_expectancy`	Life expectancy at birth in 2019
`human_development_index`	A composite index measuring average achievement in three basic dimensions of human development—a long and healthy life, knowledge and a decent standard of living. Values for 2019, imported from http://hdr.undp.org/en/indicators/137506

License

All visualizations, data, and code produced by Our World in Data are completely open access under the Creative Commons BY license. You have the permission to use, distribute, and reproduce these in any medium, provided the source and authors are credited.

In the case of our vaccination dataset, please give the following citation:

Mathieu, E., Ritchie, H., Ortiz-Ospina, E. et al. A global database of COVID-19 vaccinations. Nat Hum Behav (2021). https://doi.org/10.1038/s41562-021-01122-8

In the case of our testing dataset, please give the following citation:

Hasell, J., Mathieu, E., Beltekian, D. et al. A cross-country database of COVID-19 testing. Sci Data 7, 345 (2020). https://doi.org/10.1038/s41597-020-00688-8

The data produced by third parties and made available by Our World in Data is subject to the license terms from the original third-party authors. We will always indicate the original source of the data in our database, and you should always check the license of any such third-party data before use.

Tables

Covid

@kaggle.deepshah16_covid19_dataset.covid

108.17 kB
225 rows
65 columns

CREATE TABLE covid (
  "iso_code" VARCHAR,
  "continent" VARCHAR,
  "location" VARCHAR,
  "last_updated_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,
  "reproduction_rate" DOUBLE,
  "icu_patients" DOUBLE,
  "icu_patients_per_million" DOUBLE,
  "hosp_patients" DOUBLE,
  "hosp_patients_per_million" DOUBLE,
  "weekly_icu_admissions" DOUBLE,
  "weekly_icu_admissions_per_million" DOUBLE,
  "weekly_hosp_admissions" DOUBLE,
  "weekly_hosp_admissions_per_million" DOUBLE,
  "new_tests" DOUBLE,
  "total_tests" DOUBLE,
  "total_tests_per_thousand" DOUBLE,
  "new_tests_per_thousand" DOUBLE,
  "new_tests_smoothed" DOUBLE,
  "new_tests_smoothed_per_thousand" DOUBLE,
  "positive_rate" DOUBLE,
  "tests_per_case" DOUBLE,
  "tests_units" VARCHAR,
  "total_vaccinations" DOUBLE,
  "people_vaccinated" DOUBLE,
  "people_fully_vaccinated" DOUBLE,
  "total_boosters" DOUBLE,
  "new_vaccinations" DOUBLE,
  "new_vaccinations_smoothed" DOUBLE,
  "total_vaccinations_per_hundred" DOUBLE,
  "people_vaccinated_per_hundred" DOUBLE,
  "people_fully_vaccinated_per_hundred" DOUBLE,
  "total_boosters_per_hundred" DOUBLE,
  "new_vaccinations_smoothed_per_million" DOUBLE,
  "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,
  "excess_mortality_cumulative_absolute" DOUBLE,
  "excess_mortality_cumulative" DOUBLE,
  "excess_mortality" DOUBLE,
  "excess_mortality_cumulative_per_million" DOUBLE
);

Covid Codebook

@kaggle.deepshah16_covid19_dataset.covid_codebook

9.53 kB
65 rows
4 columns

CREATE TABLE covid_codebook (
  "column" VARCHAR,
  "source" VARCHAR,
  "category" VARCHAR,
  "description" VARCHAR
);