Covid-19 Cases & Deaths

Covid-19 total cases, deaths data by Country

@kaggle.totoro29_covid19_cases_deaths

Table List

1 table(23.04 KB)

Covid 19 Countrywise

@kaggle.totoro29_covid19_cases_deaths.covid_19_countrywise

23.04 KB
237 rows
12 columns

country Country	region Region	total_cases Total Cases	total_cases_per_100k_pop Total Cases Per 100k Pop	new_cases_7_days New Cases (7 Days)	new_cases_per_100k_pop_7_days New Cases Per 100k Pop (7 Days)	new_cases_24_hours New Cases (24 Hours)	total_deaths Total Deaths	total_deaths_per_100k_pop Total Deaths Per 100k Pop	new_deaths_7_days New Deaths (7 Days)	new_deaths_per_100k_pop_7_days New Deaths Per 100k Pop (7 Days)	new_deaths_24_hours New Deaths (24 Hours)
United States of America	Americas	94152573	28444.658	416281	125.764	76462	1040506	314.35	2590	0.782	624
India	South-East Asia	44516479	3225.822	37843	2.742	6422	528250	38.279	160	0.012	34
Brazil	Americas	34544377	16251.633	53446	25.144	10420	685002	322.264	422	0.199	104
France	Europe	33766090	51916.394	150781	231.83	36147	151062	232.262	217	0.334	38
Germany	Europe	32604993	39204.38	203649	244.868	32168	148728	178.831	50	0.06	8
Republic of Korea	Western Pacific	24264470	47327.591	399931	780.061	71471	27665	53.96	352	0.687	72
The United Kingdom	Europe	23554971	34697.831	2093	3.083		189026	278.446
Italy	Europe	22096450	37048.791	109155	183.019	18849	176404	295.774	395	0.662	69
Japan	Western Pacific	20399933	16129.431	638200	504.6	99546	43177	34.138	1337	1.057	192
Russian Federation	Europe	20265004	13886.373	356815	244.504	56126	385727	264.315	658	0.451	99


CREATE TABLE covid_19_countrywise (
  "country" VARCHAR,
  "region" VARCHAR,
  "total_cases" BIGINT,
  "total_cases_per_100k_pop" DOUBLE,
  "new_cases_7_days" BIGINT,
  "new_cases_per_100k_pop_7_days" DOUBLE,
  "new_cases_24_hours" BIGINT,
  "total_deaths" BIGINT,
  "total_deaths_per_100k_pop" DOUBLE,
  "new_deaths_7_days" BIGINT,
  "new_deaths_per_100k_pop_7_days" DOUBLE,
  "new_deaths_24_hours" BIGINT
);