Countryinfo
Relevant variables that may be required in order to predict COVID's progression.
@kaggle.koryto_countryinfo
Relevant variables that may be required in order to predict COVID's progression.
@kaggle.koryto_countryinfo
Greetings everyone!
I hope you find this dataset valuable for your COVID-19 models.
It is aligned with SRK's Novel Corona Virus dataset.
Feel free to upvote if you use it!
This dataset contains what I find as essential demographic information for every country specified in the submission COVID-19 competition file.
Moreover, there is additional data which is critical in my point of view in order to predict the infection rate and mortality rate per country such as the number of COVID detection tests, detection date of 'patient zero' and initial restrictions dates.
Please look at the columns description for the comprehensive explanation.
My
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
);
CREATE TABLE covid19tests (
"region" VARCHAR,
"country" VARCHAR,
"alpha3code" VARCHAR,
"alpha2code" VARCHAR,
"tests" VARCHAR,
"positive" DOUBLE,
"date" VARCHAR,
"testper1m" BIGINT,
"positiveper1m" DOUBLE
);
Anyone who has the link will be able to view this.