OWID COVID19

Coronavirus Pandemic (COVID-19) - Published online at OurWorldInData.org

@kaggle.gaborfodor_owid_covid19

Table List

2 tables(4.02 MB)

Owid Covid Data

@kaggle.gaborfodor_owid_covid19.owid_covid_data

2.15 MB
52873 rows
41 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	diabetes_prevalence Diabetes Prevalence	life_expectancy Life Expectancy
ABW	North America	Aruba	Fri Mar 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	2	2		18.733	18.733		nan		106766	584.8	41.2	13.085	7.452	35973.781	11.62	76.29
ABW	North America	Aruba	Thu Mar 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)			0.286			2.676	nan	33.33	106766	584.8	41.2	13.085	7.452	35973.781	11.62	76.29
ABW	North America	Aruba	Fri Mar 20 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4	2	0.286	37.465	18.733	2.676	nan	33.33	106766	584.8	41.2	13.085	7.452	35973.781	11.62	76.29
ABW	North America	Aruba	Sat Mar 21 2020 00:00:00 GMT+0000 (Coordinated Universal Time)			0.286			2.676	nan	44.44	106766	584.8	41.2	13.085	7.452	35973.781	11.62	76.29
ABW	North America	Aruba	Sun Mar 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)			0.286			2.676	nan	44.44	106766	584.8	41.2	13.085	7.452	35973.781	11.62	76.29
ABW	North America	Aruba	Mon Mar 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)			0.286			2.676	nan	44.44	106766	584.8	41.2	13.085	7.452	35973.781	11.62	76.29
ABW	North America	Aruba	Tue Mar 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12	8	1.429	112.395	74.93	13.38	nan	44.44	106766	584.8	41.2	13.085	7.452	35973.781	11.62	76.29
ABW	North America	Aruba	Wed Mar 25 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	17	5	2.143	159.227	46.831	20.071	nan	44.44	106766	584.8	41.2	13.085	7.452	35973.781	11.62	76.29
ABW	North America	Aruba	Thu Mar 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	19	2	2.429	177.959	18.733	22.747	nan	44.44	106766	584.8	41.2	13.085	7.452	35973.781	11.62	76.29
ABW	North America	Aruba	Fri Mar 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	28	9	3.429	262.256	84.296	32.113	nan	44.44	106766	584.8	41.2	13.085	7.452	35973.781	11.62	76.29


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,
  "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,
  "tests_per_case" DOUBLE,
  "positive_rate" DOUBLE,
  "tests_units" VARCHAR,
  "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
);