COVID-19 Dataset

COVID-19 Dataset grouped on County Level and US cities

@kaggle.tavishaggarwal_covid_19_dataset_on_country_level

Table List

2 tables(1.33 MB)

Covid Country

@kaggle.tavishaggarwal_covid_19_dataset_on_country_level.covid_country

1 MB
34932 rows
14 columns

country Country	total_cases Total Cases	new_cases New Cases	total_deaths Total Deaths	new_deaths New Deaths	total_recovered Total Recovered	active_cases Active Cases	serious_critical Serious/Critical	total_cases_1m_pop Total Cases/1M Pop	deaths_1m_pop Deaths /1M Pop	total_tests Total Tests	tests_1m_pop Tests /1M Pop	continent Continent	date Date
World	1741818	42983	106694	4010	393456	1241668	50130	223	13.7			All	04-11-2020
USA	508575	5699	19833	1086	28224	460518	10947	1536	60	2578931	7791	North America	04-11-2020
Spain	161852	3579	16353	272	59109	86390	7371	3462	350	355000	7593	Europe	04-11-2020
Italy	152271	4694	19468	619	32534	100269	3381	2518	322	963473	15935	Europe	04-11-2020
France	124869		13197		24932	86740	7004	1913	202	333807	5114	Europe	04-11-2020
Germany	123826	1655	2736		53913	67177	4895	1478	33	1317887	15730	Europe	04-11-2020
China	81953	46	3339	3	77525	1089	141	57	2			Asia	04-11-2020
UK	78991	5233	9875	917	344	68772	1559	1164	145	334974	4934	Europe	04-11-2020
Iran	70029	1837	4357	125	41947	23725	3987	834	52	251703	2997	Asia	04-11-2020
Turkey	52167	5138	1101	95	2965	48101	1626	619	13	340380	4036	Asia	04-11-2020


CREATE TABLE covid_country (
  "country" VARCHAR,
  "total_cases" BIGINT,
  "new_cases" DOUBLE,
  "total_deaths" VARCHAR,
  "new_deaths" DOUBLE,
  "total_recovered" DOUBLE,
  "active_cases" DOUBLE,
  "serious_critical" DOUBLE,
  "total_cases_1m_pop" DOUBLE,
  "deaths_1m_pop" DOUBLE,
  "total_tests" DOUBLE,
  "tests_1m_pop" DOUBLE,
  "continent" VARCHAR,
  "date" VARCHAR
);