Dataset: COVID-19 (coronavirus) Dataset By OWID

About this Dataset

COVID-19 (coronavirus) Dataset By OWID

This dataset is a set of select datasets pertaining to COVID-19 including COVID-19 statistics, vaccination, variation and testing

This is a Work in Progress

Tables

Covid Testing All Observations

@kaggle.kalilurrahman_covid19_coronavirus_dataset_by_owid.covid_testing_all_observations

3.1 MB
106788 rows
14 columns


CREATE TABLE covid_testing_all_observations (
  "entity" VARCHAR,
  "iso_code" VARCHAR,
  "date" TIMESTAMP,
  "source_url" VARCHAR,
  "source_label" VARCHAR,
  "notes" VARCHAR,
  "cumulative_total" DOUBLE,
  "daily_change_in_cumulative_total" DOUBLE,
  "cumulative_total_per_thousand" DOUBLE,
  "daily_change_in_cumulative_total_per_thousand" DOUBLE,
  "n_7_day_smoothed_daily_change" DOUBLE,
  "n_7_day_smoothed_daily_change_per_thousand" DOUBLE,
  "short_term_positive_rate" DOUBLE,
  "short_term_tests_per_case" DOUBLE
);

Owid Covid Data

@kaggle.kalilurrahman_covid19_coronavirus_dataset_by_owid.owid_covid_data

17.9 MB
350108 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
);

Vaccinations

@kaggle.kalilurrahman_covid19_coronavirus_dataset_by_owid.vaccinations

4.62 MB
182227 rows
16 columns


CREATE TABLE vaccinations (
  "location" VARCHAR,
  "iso_code" VARCHAR,
  "date" TIMESTAMP,
  "total_vaccinations" DOUBLE,
  "people_vaccinated" DOUBLE,
  "people_fully_vaccinated" DOUBLE,
  "total_boosters" DOUBLE,
  "daily_vaccinations_raw" DOUBLE,
  "daily_vaccinations" DOUBLE,
  "total_vaccinations_per_hundred" DOUBLE,
  "people_vaccinated_per_hundred" DOUBLE,
  "people_fully_vaccinated_per_hundred" DOUBLE,
  "total_boosters_per_hundred" DOUBLE,
  "daily_vaccinations_per_million" DOUBLE,
  "daily_people_vaccinated" DOUBLE,
  "daily_people_vaccinated_per_hundred" DOUBLE
);