The World Dataset Of COVID-19

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

@kaggle.aditeloo_the_world_dataset_of_covid19

Table List

1 table(5.24 MB)

Owid Covid Data

@kaggle.aditeloo_the_world_dataset_of_covid19.owid_covid_data

5.24 MB
91026 rows
59 columns

iso_code Iso Code	continent Continent	location Location	date Date	total_cases Total Cases	new_cases New Cases	new_cases_smoothed New Cases Smoothed	total_cases_per_million Total Cases Per Million	new_cases_per_million New Cases Per Million	new_cases_smoothed_per_million New Cases Smoothed Per Million	tests_units Tests Units	stringency_index Stringency Index	population Population	population_density Population Density	median_age Median Age	aged_65_older Aged 65 Older	aged_70_older Aged 70 Older	gdp_per_capita Gdp Per Capita	cardiovasc_death_rate Cardiovasc Death Rate	diabetes_prevalence Diabetes Prevalence	handwashing_facilities Handwashing Facilities	hospital_beds_per_thousand Hospital Beds Per Thousand	life_expectancy Life Expectancy	human_development_index Human Development Index
AFG	Asia	Afghanistan	Mon Feb 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1		0.026	0.026		nan	8.33	38928341	54.422	18.6	2.581	1.337	1803.987	597.029	9.59	37.746	0.5	64.83	0.511
AFG	Asia	Afghanistan	Tue Feb 25 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1			0.026			nan	8.33	38928341	54.422	18.6	2.581	1.337	1803.987	597.029	9.59	37.746	0.5	64.83	0.511
AFG	Asia	Afghanistan	Wed Feb 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1			0.026			nan	8.33	38928341	54.422	18.6	2.581	1.337	1803.987	597.029	9.59	37.746	0.5	64.83	0.511
AFG	Asia	Afghanistan	Thu Feb 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1			0.026			nan	8.33	38928341	54.422	18.6	2.581	1.337	1803.987	597.029	9.59	37.746	0.5	64.83	0.511
AFG	Asia	Afghanistan	Fri Feb 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1			0.026			nan	8.33	38928341	54.422	18.6	2.581	1.337	1803.987	597.029	9.59	37.746	0.5	64.83	0.511
AFG	Asia	Afghanistan	Sat Feb 29 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1		0.143	0.026		0.004	nan	8.33	38928341	54.422	18.6	2.581	1.337	1803.987	597.029	9.59	37.746	0.5	64.83	0.511
AFG	Asia	Afghanistan	Sun Mar 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1		0.143	0.026		0.004	nan	27.78	38928341	54.422	18.6	2.581	1.337	1803.987	597.029	9.59	37.746	0.5	64.83	0.511
AFG	Asia	Afghanistan	Mon Mar 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1			0.026			nan	27.78	38928341	54.422	18.6	2.581	1.337	1803.987	597.029	9.59	37.746	0.5	64.83	0.511
AFG	Asia	Afghanistan	Tue Mar 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	2	1	0.143	0.051	0.026	0.004	nan	27.78	38928341	54.422	18.6	2.581	1.337	1803.987	597.029	9.59	37.746	0.5	64.83	0.511
AFG	Asia	Afghanistan	Wed Mar 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4	2	0.429	0.103	0.051	0.011	nan	27.78	38928341	54.422	18.6	2.581	1.337	1803.987	597.029	9.59	37.746	0.5	64.83	0.511


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,
  "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,
  "new_vaccinations" DOUBLE,
  "new_vaccinations_smoothed" DOUBLE,
  "total_vaccinations_per_hundred" DOUBLE,
  "people_vaccinated_per_hundred" DOUBLE,
  "people_fully_vaccinated_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
);