Our World in Data - COVID-19

▶ About Our World in Data 🏢

▶ Similar Datasets 📄

▶ Context 📝

The complete COVID-19 dataset is a collection of the COVID-19 data maintained and provided by Our World in Data. Our World in Data team will update it daily throughout the duration of the COVID-19 pandemic.

▶ Content 📃

These are the following information that includes in the dataset:
| Metrics | Source | Updated | Countries |
| --- | --- |
| Vaccinations | Official data collated by the Our World in Data team | Daily | 218 |
| Tests & positivity | Official data collated by the Our World in Data team | Weekly | 139 |
| Hospital & ICU | Official data collated by the Our World in Data team | Weekly | 39 |
| Confirmed cases | JHU CSSE COVID-19 Data | Daily | 196 |
| Confirmed deaths | JHU CSSE COVID-19 Data | Daily | 196 |
| Reproduction rate | Arroyo-Marioli F, Bullano F, Kucinskas S, Rondón-Moreno C | Daily | 185 |
| Policy responses | Oxford COVID-19 Government Response Tracker | Daily | 186 |
| Other variables of interest | International organizations (UN, World Bank, OECD, IHME…) | Fixed |

Data dictionary is available below ⤵

▶ Acknowledgements 🙏

I'd like to clarify that I'm only making data about vaccines collected by Our World in Data available to Kaggle community.
This dataset is gathered, integrated, and posted the new version on a daily basis, as maintained by Our World in Data on their GitHub repository.

▶ Inspiration 💭

Forecasting daily new confirmed cases of COVID-19 in specific country.
Perform data analysis/data visualization of COVID-19 cases/death/etc.

📷 Images by Fusion Medical Animation.

Tables

Owid Covid Data

@kaggle.caesarmario_our_world_in_data_covid19_dataset.owid_covid_data

17.9 MB
350085 rows
67 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,
  "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" DOUBLE,
  "excess_mortality_cumulative_absolute" DOUBLE,
  "excess_mortality_cumulative" DOUBLE,
  "excess_mortality" DOUBLE,
  "excess_mortality_cumulative_per_million" DOUBLE
);