Covid-19 Deaths And Vaccinations Dataset

Analyze the data to find patterns and trends in Covid-19 deaths and vaccination

@kaggle.tohidkhanbagani_covid_19_deaths_and_vaccinations_dataset

Table List

2 tables(16.58 MB)

Covid Vaccinations

@kaggle.tohidkhanbagani_covid_19_deaths_and_vaccinations_dataset.covid_vaccinations

7.26 MB
302749 rows
45 columns

iso_code Iso Code	continent Continent	location Location	date Date	tests_units Tests Units	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	Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	54.42	18.6	2.58	1.34	1803.99	597.03	9.59	37.75	0.5	64.83	0.51
AFG	Asia	Afghanistan	Sat Jan 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	54.42	18.6	2.58	1.34	1803.99	597.03	9.59	37.75	0.5	64.83	0.51
AFG	Asia	Afghanistan	Sun Jan 05 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	54.42	18.6	2.58	1.34	1803.99	597.03	9.59	37.75	0.5	64.83	0.51
AFG	Asia	Afghanistan	Mon Jan 06 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	54.42	18.6	2.58	1.34	1803.99	597.03	9.59	37.75	0.5	64.83	0.51
AFG	Asia	Afghanistan	Tue Jan 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	54.42	18.6	2.58	1.34	1803.99	597.03	9.59	37.75	0.5	64.83	0.51
AFG	Asia	Afghanistan	Wed Jan 08 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	54.42	18.6	2.58	1.34	1803.99	597.03	9.59	37.75	0.5	64.83	0.51
AFG	Asia	Afghanistan	Thu Jan 09 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	54.42	18.6	2.58	1.34	1803.99	597.03	9.59	37.75	0.5	64.83	0.51
AFG	Asia	Afghanistan	Fri Jan 10 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	54.42	18.6	2.58	1.34	1803.99	597.03	9.59	37.75	0.5	64.83	0.51
AFG	Asia	Afghanistan	Sat Jan 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	54.42	18.6	2.58	1.34	1803.99	597.03	9.59	37.75	0.5	64.83	0.51
AFG	Asia	Afghanistan	Sun Jan 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	54.42	18.6	2.58	1.34	1803.99	597.03	9.59	37.75	0.5	64.83	0.51


CREATE TABLE covid_vaccinations (
  "iso_code" VARCHAR,
  "continent" VARCHAR,
  "location" VARCHAR,
  "date" TIMESTAMP,
  "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,
  "excess_mortality_cumulative_absolute" DOUBLE,
  "excess_mortality_cumulative" DOUBLE,
  "excess_mortality" DOUBLE,
  "excess_mortality_cumulative_per_million" DOUBLE
);