COVID19 AND VACCINATIONS

Exploration on Covid and Vaccinations

@kaggle.happyude_covid19_and_vaccinations

Table List

1 table(4.79 MB)

Coviddeaths Data

@kaggle.happyude_covid19_and_vaccinations.coviddeaths_data

4.79 MB
85171 rows
44 columns

iso_code Iso Code	continent Continent	location Location	date Date	population Population	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
AFG	Asia	Afghanistan	Mon Feb 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	38928341	1	1		0.026	0.026		nan
AFG	Asia	Afghanistan	Tue Feb 25 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	38928341	1			0.026			nan
AFG	Asia	Afghanistan	Wed Feb 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	38928341	1			0.026			nan
AFG	Asia	Afghanistan	Thu Feb 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	38928341	1			0.026			nan
AFG	Asia	Afghanistan	Fri Feb 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	38928341	1			0.026			nan
AFG	Asia	Afghanistan	Sat Feb 29 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	38928341	1		0.143	0.026		0.004	nan
AFG	Asia	Afghanistan	Sun Mar 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	38928341	1		0.143	0.026		0.004	nan
AFG	Asia	Afghanistan	Mon Mar 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	38928341	1			0.026			nan
AFG	Asia	Afghanistan	Tue Mar 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	38928341	2	1	0.143	0.051	0.026	0.004	nan
AFG	Asia	Afghanistan	Wed Mar 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	38928341	4	2	0.429	0.103	0.051	0.011	nan


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