Dataset: Coronavirus (COVID-19) Cases (Daily Updates)

About this Dataset

Coronavirus (COVID-19) Cases (Daily Updates)

Daily updated dataset of all Coronavirus (COVID-19) Cases in all countries in the world. See the README file and the Codebook for more information including data dictionary.

Confirmed cases and deaths: this data is collected from the World Health Organization Coronavirus Dashboard. The cases & deaths dataset is updated daily.
- Note 1: Time/date stamps reflect when the data was last updated by WHO. Due to the time required to process and validate the incoming data, there is a delay between reporting to WHO and the update of the dashboard.
- Note 2: Counts and corrections made after these times will be carried forward to the next reporting cycle for that specific region. Delayed reporting for any specific country, territory or area may result in pooled counts for multiple days being presented, with a retrospective update to counts on previous days to accurately reflect trends. Significant data errors detected or reported to WHO may be corrected at more frequent intervals.
Hospitalizations and intensive care unit (ICU) admissions: our data is collected from official sources and collated by Our World in Data. The complete list of country-by-country sources is available here.
Testing for COVID-19: this data is collected by the Our World in Data team from official reports; you can find
further details in our post on COVID-19 testing, including our checklist of questions to understand testing
data, information on
geographical and temporal
coverage, and detailed
country-by-country source information. On 23 June 2022, we stopped adding new datapoints to our COVID-19 testing dataset. You can read more here.
Vaccinations against COVID-19: this data is collected by the Our World in Data team from official reports.
Other variables: this data is collected from a variety of sources (United Nations, World Bank, Global Burden of Disease, Blavatnik School of Government, etc.). More information is available in our codebook.

Tables

Coronavirus Cases Daily Update

@kaggle.joebeachcapital_coronavirus_covid_19_cases_daily_updates.coronavirus_cases_daily_update

13.79 MB
429435 rows
67 columns


CREATE TABLE coronavirus_cases_daily_update (
  "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,
  "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,
  "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,
  "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,
  "new_people_vaccinated_smoothed" DOUBLE,
  "new_people_vaccinated_smoothed_per_hundred" DOUBLE,
  "stringency_index" 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,
  "population" BIGINT,
  "excess_mortality_cumulative_absolute" DOUBLE,
  "excess_mortality_cumulative" DOUBLE,
  "excess_mortality" DOUBLE,
  "excess_mortality_cumulative_per_million" DOUBLE
);

Owid Covid Codebook

@kaggle.joebeachcapital_coronavirus_covid_19_cases_daily_updates.owid_covid_codebook

11.06 KB
67 rows
4 columns


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