Countryinfo

Relevant variables that may be required in order to predict COVID's progression.

@kaggle.koryto_countryinfo

Table List

2 tables(87.1 KB)

Covid19countryinfo

@kaggle.koryto_countryinfo.covid19countryinfo

75.82 KB
249 rows
60 columns

region Region	country Country	alpha3code Alpha3code	alpha2code Alpha2code	pop Pop	tests Tests	testpop Testpop	density Density	medianage Medianage	urbanpop Urbanpop	quarantine Quarantine	publicplace Publicplace	gatheringlimit Gatheringlimit	gathering Gathering	hospibed Hospibed	smokers Smokers	sex0 Sex0	sex14 Sex14	sex25 Sex25	sex54 Sex54	sex64 Sex64	sex65plus Sex65plus	sexratio Sexratio	lung Lung	femalelung Femalelung	malelung Malelung	gdp2019 Gdp2019	healthexp Healthexp	healthperpop Healthperpop	fertility Fertility	avgtemp Avgtemp	avghumidity Avghumidity	firstcase Firstcase	totalcases Totalcases	active30 Active30	active31 Active31	active1 Active1	active2 Active2	active3 Active3	newcases30 Newcases30	newcases31 Newcases31	newcases1 Newcases1	newcases2 Newcases2	newcases3 Newcases3	deaths Deaths	newdeaths30 Newdeaths30	newdeaths31 Newdeaths31	newdeaths1 Newdeaths1	newdeaths2 Newdeaths2	newdeaths3 Newdeaths3	recovered Recovered	critical30 Critical30	critical31 Critical31	critical1 Critical1	critical2 Critical2	critical3 Critical3	casediv1m Casediv1m	deathdiv1m Deathdiv1m
nan	Afghanistan	AFG	AF	38928346			60	18	25					0.5		1.05	1.03	1.03	1.03	0.97	0.85	1.03	37.62	36.31	39.33	18734	184	4.726632876	5.12	6.216666667	56.93333333	Sun Feb 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	273	139	165	187	225	257	25	4	22	2		6						10						7	0.2
nan	Albania	ALB	AL	2877797			105	36	63					2.9	29.4	1.08	1.11	1.09	0.93	0.95	0.87	0.98	11.67	7.02	17.04	15418	774	268.9557325	1.51	13.95	69.9	Sat Mar 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	304	168	176	177	194	199	11	20	16	18	27	16	1	4		1		89	7	8	7	7	7	106	6
nan	Algeria	DZA	DZ	43851044			18	29	73					1.9		1.05	1.05	1.05	1.03	1.01	0.89	1.03	8.77	5.03	12.81	172781	1031	23.51141286	2.7	19.56666667	61.71666667	Mon Feb 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	986	449	626	728	728	839		132	131			86		9	14			61						22	2
nan	Andorra	AND	AD	77265			164	45	88					2.5	32.5	1.07	1.05	1.08	1.05	1.15	1.02	1.06				91527	5949	76994.7583	1.4	7.383333333	75.23333333	Sun Mar 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	439	322	352	366	403	407			14	38	11	16			2	1	1	16	10	10	12	12	12	5682	207
nan	Antigua and Barbuda	ATG	AG	97929			223	34	26					3.8		1.05	1.03	0.99	0.84	0.82	0.76	0.9	11.76	7.67	18.78	1688	1105	11283.68512	2			Thu Mar 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	9	7	7	7	7	9																		92
nan	Argentina	ARG	AR	45195774			17	32	93	Fri Mar 20 2020 00:00:00 GMT+0000 (Coordinated Universal Time)				5	23.95	1.05	1.06	1.05	1	0.94	0.71	0.98	29.27	20.16	42.59	445469	1390	30.75508785	2.26	32.81666667	43.61666667	Mon Mar 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1265	570	700	778	851	970		146				39	2	3	1	2	3	256						28	0.9
nan	Armenia	ARM	AM	2963243	694	4269.802594	104	35	63					4.2	26.9	1.13	1.14	1.06	0.93	0.84	0.67	0.94	23.86	16.17	35.99	13444	883	297.9843368	1.64	7.1	58.5	Sat Feb 29 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	736	449	499	536	625	686	58	50	39	92	73	7			1	1		43	15	30	30	30	30	248	2
Aruba	Netherlands	ABW	AW	106766			593	41	44					1.2		1.02	1.01	1.01	0.93	0.87	0.64	0.9				2903	43	402.7499391	1.83	26.53333333	80.16666667	Thu Mar 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	60	49	54	54	54	59		5										1						562
nan	Australia	AUS	AU	25499884	31635	806.0655603	3	38	86		Mon Mar 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	2	Sun Mar 29 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	3.8	14.9	1.06	1.06	1.09	0.99	0.93	0.86	0.99	18.79	15.9	22.16	1376255	4492	176.1576641	1.77	25.78333333	64.23333333	Fri Jan 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	5350	3983	4205	4498	4767	4737	82	101	101	89	36	28	1		1	2	3	585	28	28	50	50	85	210	1
nan	Austria	AUT	AT	9006398	10278	876.2792372	109	43	57	Mon Mar 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)				7.6	35.15	1.05	1.05	1.04	1	0.98	0.76	0.96	17.02	13.02	22.14	447718	5138	570.4833386	1.47	9.466666667	65.35	Mon Feb 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	11444	8710	8886	9003	9120	9254	666	491	405	316	315	168	22	20	18	12	10	2022	193	198	215	227	245	1271	19


CREATE TABLE covid19countryinfo (
  "region" VARCHAR,
  "country" VARCHAR,
  "alpha3code" VARCHAR,
  "alpha2code" VARCHAR,
  "pop" DOUBLE,
  "tests" DOUBLE,
  "testpop" DOUBLE,
  "density" DOUBLE,
  "medianage" DOUBLE,
  "urbanpop" DOUBLE,
  "quarantine" TIMESTAMP,
  "schools" TIMESTAMP,
  "publicplace" TIMESTAMP,
  "gatheringlimit" DOUBLE,
  "gathering" TIMESTAMP,
  "nonessential" TIMESTAMP,
  "hospibed" DOUBLE,
  "smokers" DOUBLE,
  "sex0" DOUBLE,
  "sex14" DOUBLE,
  "sex25" DOUBLE,
  "sex54" DOUBLE,
  "sex64" DOUBLE,
  "sex65plus" DOUBLE,
  "sexratio" DOUBLE,
  "lung" DOUBLE,
  "femalelung" DOUBLE,
  "malelung" DOUBLE,
  "gdp2019" DOUBLE,
  "healthexp" DOUBLE,
  "healthperpop" DOUBLE,
  "fertility" DOUBLE,
  "avgtemp" DOUBLE,
  "avghumidity" DOUBLE,
  "firstcase" TIMESTAMP,
  "totalcases" DOUBLE,
  "active30" DOUBLE,
  "active31" DOUBLE,
  "active1" DOUBLE,
  "active2" DOUBLE,
  "active3" DOUBLE,
  "newcases30" DOUBLE,
  "newcases31" DOUBLE,
  "newcases1" DOUBLE,
  "newcases2" DOUBLE,
  "newcases3" DOUBLE,
  "deaths" DOUBLE,
  "newdeaths30" DOUBLE,
  "newdeaths31" DOUBLE,
  "newdeaths1" DOUBLE,
  "newdeaths2" DOUBLE,
  "newdeaths3" DOUBLE,
  "recovered" DOUBLE,
  "critical30" DOUBLE,
  "critical31" DOUBLE,
  "critical1" DOUBLE,
  "critical2" DOUBLE,
  "critical3" DOUBLE,
  "casediv1m" DOUBLE,
  "deathdiv1m" DOUBLE
);