Skip to content

Latest commit

 

History

History
 
 

data

README.md

Data on COVID-19 (coronavirus) by Our World in Data

Our complete COVID-19 dataset is a collection of the COVID-19 data maintained by Our World in Data. It is updated daily and includes data on confirmed cases, deaths, hospitalizations, and testing, as well as other variables of potential interest.

🗂️ Download our complete COVID-19 dataset : CSV | XLSX | JSON

We will continue to publish up-to-date data on confirmed cases, deaths, hospitalizations, and testing, throughout the duration of the COVID-19 pandemic.

⚠️ Our source for confirmed cases and deaths, the European Centre for Disease Prevention and Control (ECDC), recently announced that it would switch from a daily to a weekly reporting schedule from December. Our World in Data will therefore have to transition away from the ECDC as a source to continue to provide daily updates of confirmed cases and deaths. Starting on November 30, the data for confirmed cases and deaths presented on ourworldindata.org and available in our GitHub repository will be sourced from the daily dataset provided by Johns Hopkins University. The data last sourced from the ECDC will remain available as an archive on GitHub. The format (variable names and types) of our complete COVID-19 dataset will remain the same.

Our data sources

  • Confirmed cases and deaths: our data comes from the European Centre for Disease Prevention and Control (ECDC). We discuss how and when the ECDC collects and publishes this data here. The cases & deaths dataset is updated daily. Note: the number of cases or deaths reported by any institution—including the ECDC, the WHO, Johns Hopkins and others—on a given day does not necessarily represent the actual number on that date. This is because of the long reporting chain that exists between a new case/death and its inclusion in statistics. This also means that negative values in cases and deaths can sometimes appear when a country sends a correction to the ECDC, because it had previously overestimated the number of cases/deaths. Alternatively, large changes can sometimes (although rarely) be made to a country's entire time series if the ECDC decides (and has access to the necessary data) to correct values retrospectively.
  • Hospitalizations and intensive care unit (ICU) admissions: our data comes from the European Centre for Disease Prevention and Control (ECDC), who provide these statistics only for a select number of European countries, and update it on a weekly basis; and the COVID Tracking Project, which provides statistics for the United States. Unfortunately, we are unable to provide data on hospitalizations for other countries: there is currently no global, aggregated database on COVID-19 hospitalization, and our team at Our World in Data does not have the capacity to build such a dataset.
  • 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. The testing dataset is updated around twice a week.
  • 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.

The complete Our World in Data COVID-19 dataset

Our complete COVID-19 dataset is available in CSV, XLSX, and JSON formats, and includes all of our historical data on the pandemic up to the date of publication.

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.

As of 13 November 2020, the columns are: iso_code, continent, location, date, total_cases, new_cases, new_cases_smoothed, total_deaths, new_deaths, new_deaths_smoothed, total_cases_per_million, new_cases_per_million, new_cases_smoothed_per_million, total_deaths_per_million, new_deaths_per_million, new_deaths_smoothed_per_million, reproduction_rate, icu_patients, icu_patients_per_million, hosp_patients, hosp_patients_per_million, weekly_icu_admissions, weekly_icu_admissions_per_million, weekly_hosp_admissions, weekly_hosp_admissions_per_million, total_tests, new_tests, new_tests_smoothed, total_tests_per_thousand, new_tests_per_thousand, new_tests_smoothed_per_thousand, tests_per_case, positive_rate, tests_units, stringency_index, population, population_density, median_age, aged_65_older, aged_70_older, gdp_per_capita, extreme_poverty, cardiovasc_death_rate, diabetes_prevalence, female_smokers, male_smokers, handwashing_facilities, hospital_beds_per_thousand, life_expectancy, human_development_index

A full codebook is made available, with a description and source for each variable in the dataset.

Additional files and information

If you are interested in the individual files that make up the complete dataset, or more detailed information, other files can be found in the subfolders:

  • ecdc: data from the European Centre for Disease Prevention and Control, related to confirmed cases and deaths;
  • testing: data from various official sources, related to COVID-19 tests performed in each country. This folder contains two files with more detailed information:
  • excess_mortality: data on excess mortality during the pandemic, sourced from the Human Mortality Database and the UK Office for National Statistics;
  • who: data from the World Health Organization, related to confirmed cases and deaths—we have stopped using and updating this data since 18 March 2020.

Changelog

  • Up until 17 March 2020, we were using WHO data manually extracted from their daily situation report PDFs.
  • From 19 March 2020, we started relying on data published by the European CDC. We wrote about why we decided to switch sources.
  • On 3 April 2020, we added country-level time series on COVID-19 tests.
  • On 16 April 2020, we made available a complete dataset of all of our main variables related to confirmed cases, deaths, and tests.
  • On 25 April 2020, we added rows for "World" and "International" to our complete dataset. The iso_code column for "International" is blank, and for "World" we use OWID_WRL.
  • On 9 May 2020, we added new variables related to demographic, economic, and public health data to our complete dataset.
  • On 19 May 2020, we added 2 variables related to testing: new_tests_smoothed and new_tests_smoothed_per_thousand. To generate them we assume that testing changed equally on a daily basis over any periods in which no data was reported (as not all countries report testing data on a daily basis). This produces a complete series of daily figures, which is then averaged over a rolling 7-day window.
  • On 23 May 2020, we added a JSON version of our complete dataset.
  • On 4 June 2020, we added a continent column to our complete dataset.
  • On 1 July 2020, we changed the format of the JSON version of our complete dataset to normalize the data and reduce file size.
  • On 4 August 2020, we added the positive_rate and tests_per_case columns to our complete dataset.
  • On 7 August 2020, we transformed our markdown codebook to a CSV file to allow easier merging with the complete dataset.
  • On 17 August 2020, we added 4 variables related to cases and deaths: new_cases_smoothed, new_deaths_smoothed, new_cases_smoothed_per_million, and new_deaths_smoothed_per_million. These metrics are averaged versions (over a rolling 7-day window) of the daily variables.
  • On 10 September 2020, we added the human_development_index column to our complete dataset.
  • On 14 October 2020, we added data on excess mortality during the pandemic in the excess_mortality folder, sourced from the Human Mortality Database and the UK Office for National Statistics.
  • On 29 October 2020, we added data on hospitalizations and intensive care unit (ICU) admissions, sourced from the European Centre for Disease Prevention and Control (ECDC), who provide these statistics only for a select number of European countries, and update it on a weekly basis.
  • On 10 November 2020, we added data on hospitalizations and intensive care unit (ICU) admissions for the United States, sourced from the COVID Tracking Project.
  • On 13 November 2020, we added real-time estimates of the effective reproduction rate (R) of the virus, sourced from Arroyo Marioli et al. (2020).

Data alterations

  • We standardize names of countries and regions. Since the names of countries and regions are different in different data sources, we standardize all names to the Our World in Data standard entity names.
  • We may correct or discard inconsistencies that we detect in the original data.
  • Testing data is collected from many different sources. A detailed documentation for each country is available in our post on COVID-19 testing.
  • Where we collect multiple time series for a given country in our testing data (for example: for the United States, we collect data from both the CDC, and the COVID Tracking Project), our complete COVID-19 dataset only includes the most complete, or, if equally complete, data on the number of people tested rather than the number of tests/samples/swabs processed. The list of 'secondary' test series (those removed) is located in scripts/input/owid/secondary_testing_series.csv.

Stable URLs

The /public path of this repository is hosted at https://covid.ourworldindata.org/. For example, you can access the CSV for the complete dataset at https://covid.ourworldindata.org/data/owid-covid-data.csv.

We have the goal to keep all stable URLs working, even when we have to restructure this repository. If you need regular updates, please consider using the covid.ourworldindata.org URLs rather than pointing to GitHub.

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 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.

Authors

This data has been collected, aggregated, and documented by Cameron Appel, Diana Beltekian, Daniel Gavrilov, Charlie Giattino, Joe Hasell, Bobbie Macdonald, Edouard Mathieu, Esteban Ortiz-Ospina, Hannah Ritchie, Max Roser.

The mission of Our World in Data is to make data and research on the world's largest problems understandable and accessible. Read more about our mission.