COVID-19 Community Mobility Dataset
Mobility and Infection for world in time series
@kaggle.arghadeep_covid19_community_mobility_dataset
Mobility and Infection for world in time series
@kaggle.arghadeep_covid19_community_mobility_dataset
CREATE TABLE world_mobility_with_covid_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_country_recovr_inc_rate" DOUBLE,
"covid_country_death_inc_rate" DOUBLE,
"covid_world_confirmed" BIGINT,
"covid_world_recovered" BIGINT,
"covid_world_deaths" BIGINT,
"covid_world_inc_rate" DOUBLE,
"covid_world_recvr_inc_rate" DOUBLE,
"covid_world_death_inc_rate" DOUBLE
);
CREATE TABLE community_mobility_raw_dataset_google (
"days" DOUBLE,
"valus" DOUBLE,
"params" VARCHAR,
"countrycode" VARCHAR,
"src" VARCHAR
);
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
);
Anyone who has the link will be able to view this.