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 Deaths

@kaggle.tohidkhanbagani_covid_19_deaths_and_vaccinations_dataset.covid_deaths

9.32 MB
302749 rows
26 columns

iso_code Iso Code	continent Continent	location Location	date Date	population Population
AFG	Asia	Afghanistan	Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	41128772
AFG	Asia	Afghanistan	Sat Jan 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	41128772
AFG	Asia	Afghanistan	Sun Jan 05 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	41128772
AFG	Asia	Afghanistan	Mon Jan 06 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	41128772
AFG	Asia	Afghanistan	Tue Jan 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	41128772
AFG	Asia	Afghanistan	Wed Jan 08 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	41128772
AFG	Asia	Afghanistan	Thu Jan 09 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	41128772
AFG	Asia	Afghanistan	Fri Jan 10 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	41128772
AFG	Asia	Afghanistan	Sat Jan 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	41128772
AFG	Asia	Afghanistan	Sun Jan 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	41128772


CREATE TABLE covid_deaths (
  "iso_code" VARCHAR,
  "continent" VARCHAR,
  "location" VARCHAR,
  "date" TIMESTAMP,
  "population" BIGINT,
  "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
);