COVID-19 Community Mobility Dataset
Mobility and Infection for world in time series
@kaggle.arghadeep_covid19_community_mobility_dataset
Table List
- 3 tables(469.55 KB)
Community Dataset With Infection Count
@kaggle.arghadeep_covid19_community_mobility_dataset.community_dataset_with_infection_count
- 149.31 KB
- 7068 rows
- 25 columns
country_region_codeCOUNTRY REGION CODE | country_regionCOUNTRY REGION | date_valDATE VAL | day_ctDAY CT | retail_and_recreation_pctRETAIL AND RECREATION PCT | inc_retail_and_recreation_pctINC RETAIL AND RECREATION PCT | grocery_and_pharmacy_pctGROCERY AND PHARMACY PCT | inc_grocery_and_pharmacy_pctINC GROCERY AND PHARMACY PCT | parks_pctPARKS PCT | inc_parks_pctINC PARKS PCT | transit_stations_pctTRANSIT STATIONS PCT | inc_transit_stations_pctINC TRANSIT STATIONS PCT | workplaces_pctWORKPLACES PCT | inc_workplaces_pctINC WORKPLACES PCT | residential_pctRESIDENTIAL PCT | inc_residential_pctINC RESIDENTIAL PCT | covid_confirmedCOVID CONFIRMED | covid_recoveredCOVID RECOVERED | covid_deathsCOVID DEATHS | covid_cnty_new_casesCOVID CNTY NEW CASES | covid_country_inc_rateCOVID COUNTRY INC RATE | covid_world_confirmedCOVID WORLD CONFIRMED | covid_world_recoveredCOVID WORLD RECOVERED | covid_world_deathsCOVID WORLD DEATHS | covid_world_inc_rateCOVID WORLD INC RATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AE | United Arab Emirates | 15-02-20 | 1 | 4 | 5 | 2 | 1 | 8 | 3 | 69030 | 9395 | 1666 | 3.206997084548105 | |||||||||||
| AE | United Arab Emirates | 16-02-20 | 2 | 1 | -1 | 4 | 4 | 1 | 1 | -1 | 2 | 1 | 9 | 4 | 1 | 0.125 | 71224 | 10865 | 1770 | 3.1783282630740253 | ||||
| AE | United Arab Emirates | 17-02-20 | 3 | -1 | 2 | 1 | 3 | 5 | -1 | 1 | 2 | 1 | 9 | 4 | 73258 | 12583 | 1868 | 2.855778950915422 | ||||||
| AE | United Arab Emirates | 18-02-20 | 4 | -2 | 1 | 1 | 5 | 1 | 2 | 1 | 9 | 4 | 75136 | 14352 | 2007 | 2.5635425482541154 | ||||||||
| AE | United Arab Emirates | 19-02-20 | 5 | -2 | 1 | 4 | 1 | -1 | 1 | 2 | 1 | 9 | 4 | 75639 | 16121 | 2122 | 0.6694527257240205 | |||||||
| AE | United Arab Emirates | 20-02-20 | 6 | -2 | 1 | -1 | 6 | -2 | 1 | -2 | 1 | 1 | 1 | 9 | 4 | 76197 | 18177 | 2247 | 0.737714671003054 | |||||
| AE | United Arab Emirates | 21-02-20 | 7 | -3 | 1 | 2 | -1 | 6 | 1 | -1 | 2 | 1 | 9 | 4 | 76819 | 18890 | 2251 | 0.8163051038754806 | ||||||
| AE | United Arab Emirates | 22-02-20 | 8 | -2 | -1 | 2 | 4 | 2 | -2 | 2 | 3 | -4 | 1 | 13 | 4 | 4 | 0.444 | 78572 | 22886 | 2458 | 2.281987529126909 | |||
| AE | United Arab Emirates | 23-02-20 | 9 | -1 | -1 | 3 | -1 | 3 | 1 | -1 | -1 | 4 | -1 | 1 | 13 | 4 | 78958 | 23394 | 2469 | 0.4912691544061497 | ||||
| AE | United Arab Emirates | 24-02-20 | 10 | -3 | 2 | 3 | 5 | -2 | -1 | 3 | 1 | 1 | 13 | 4 | 79561 | 25227 | 2629 | 0.7636971554497327 |
CREATE TABLE community_dataset_with_infection_count (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"date_val" VARCHAR,
"day_ct" BIGINT,
"retail_and_recreation_pct" BIGINT,
"inc_retail_and_recreation_pct" BIGINT,
"grocery_and_pharmacy_pct" BIGINT,
"inc_grocery_and_pharmacy_pct" BIGINT,
"parks_pct" BIGINT,
"inc_parks_pct" BIGINT,
"transit_stations_pct" BIGINT,
"inc_transit_stations_pct" BIGINT,
"workplaces_pct" BIGINT,
"inc_workplaces_pct" BIGINT,
"residential_pct" BIGINT,
"inc_residential_pct" BIGINT,
"covid_confirmed" BIGINT,
"covid_recovered" BIGINT,
"covid_deaths" BIGINT,
"covid_cnty_new_cases" DOUBLE,
"covid_country_inc_rate" DOUBLE,
"covid_world_confirmed" BIGINT,
"covid_world_recovered" BIGINT,
"covid_world_deaths" BIGINT,
"covid_world_inc_rate" DOUBLE
);