GOOGLE MOBILITY DATA
Understand how people are moving due to COVID
@kaggle.aiswaryaramachandran_google_mobility_data
Understand how people are moving due to COVID
@kaggle.aiswaryaramachandran_google_mobility_data
As global communities respond to COVID-19, we've heard from public health officials that the same type of aggregated, anonymized insights we use in products such as Google Maps could be helpful as they make critical decisions to combat COVID-19.
These Community Mobility Reports aim to provide insights into what has changed in response to policies aimed at combating COVID-19. The reports chart movement trends over time by geography, across different categories of places such as retail and recreation, groceries and pharmacies, parks, transit stations, workplaces, and residential. (https://www.google.com/covid19/mobility/)
The data contains aggregated and anonymised aggregated data per day for each country. For say accessing data for India - the files 2020_IN_Region_Mobility_Report.csv for 2020 data and 2021_IN_Region_Mobility_Report.csv. The aggregated data is not only present at country level, but also at States and district level - as given in sub_region_1 and sub_region_2.
This data from report published by Google. https://www.google.com/covid19/mobility/
Some Questions to answer
India is having its Second Wave and one of the major causes is considered to the election rallies held in different parts of the country. How does Mobility Impact the COVID Cases?
Comparing Mobility across different Countries
CREATE TABLE n_2022_qa_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" BIGINT,
"grocery_and_pharmacy_percent_change_from_baseline" BIGINT,
"parks_percent_change_from_baseline" BIGINT,
"transit_stations_percent_change_from_baseline" BIGINT,
"workplaces_percent_change_from_baseline" BIGINT,
"residential_percent_change_from_baseline" BIGINT
);CREATE TABLE n_2022_re_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" DOUBLE,
"grocery_and_pharmacy_percent_change_from_baseline" DOUBLE,
"parks_percent_change_from_baseline" DOUBLE,
"transit_stations_percent_change_from_baseline" DOUBLE,
"workplaces_percent_change_from_baseline" DOUBLE,
"residential_percent_change_from_baseline" VARCHAR
);CREATE TABLE n_2022_ro_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" DOUBLE,
"grocery_and_pharmacy_percent_change_from_baseline" DOUBLE,
"parks_percent_change_from_baseline" DOUBLE,
"transit_stations_percent_change_from_baseline" DOUBLE,
"workplaces_percent_change_from_baseline" DOUBLE,
"residential_percent_change_from_baseline" DOUBLE
);CREATE TABLE n_2022_rs_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" BIGINT,
"grocery_and_pharmacy_percent_change_from_baseline" BIGINT,
"parks_percent_change_from_baseline" BIGINT,
"transit_stations_percent_change_from_baseline" BIGINT,
"workplaces_percent_change_from_baseline" BIGINT,
"residential_percent_change_from_baseline" BIGINT
);CREATE TABLE n_2022_ru_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" BIGINT,
"grocery_and_pharmacy_percent_change_from_baseline" BIGINT,
"parks_percent_change_from_baseline" BIGINT,
"transit_stations_percent_change_from_baseline" BIGINT,
"workplaces_percent_change_from_baseline" BIGINT,
"residential_percent_change_from_baseline" BIGINT
);CREATE TABLE n_2022_rw_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" DOUBLE,
"grocery_and_pharmacy_percent_change_from_baseline" DOUBLE,
"parks_percent_change_from_baseline" DOUBLE,
"transit_stations_percent_change_from_baseline" DOUBLE,
"workplaces_percent_change_from_baseline" DOUBLE,
"residential_percent_change_from_baseline" DOUBLE
);CREATE TABLE n_2022_sa_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" BIGINT,
"grocery_and_pharmacy_percent_change_from_baseline" BIGINT,
"parks_percent_change_from_baseline" DOUBLE,
"transit_stations_percent_change_from_baseline" DOUBLE,
"workplaces_percent_change_from_baseline" BIGINT,
"residential_percent_change_from_baseline" BIGINT
);CREATE TABLE n_2022_se_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" DOUBLE,
"grocery_and_pharmacy_percent_change_from_baseline" DOUBLE,
"parks_percent_change_from_baseline" DOUBLE,
"transit_stations_percent_change_from_baseline" DOUBLE,
"workplaces_percent_change_from_baseline" DOUBLE,
"residential_percent_change_from_baseline" DOUBLE
);CREATE TABLE n_2022_sg_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" BIGINT,
"grocery_and_pharmacy_percent_change_from_baseline" BIGINT,
"parks_percent_change_from_baseline" BIGINT,
"transit_stations_percent_change_from_baseline" BIGINT,
"workplaces_percent_change_from_baseline" BIGINT,
"residential_percent_change_from_baseline" BIGINT
);CREATE TABLE n_2022_si_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" DOUBLE,
"grocery_and_pharmacy_percent_change_from_baseline" DOUBLE,
"parks_percent_change_from_baseline" DOUBLE,
"transit_stations_percent_change_from_baseline" DOUBLE,
"workplaces_percent_change_from_baseline" DOUBLE,
"residential_percent_change_from_baseline" DOUBLE
);CREATE TABLE n_2022_sk_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" DOUBLE,
"grocery_and_pharmacy_percent_change_from_baseline" DOUBLE,
"parks_percent_change_from_baseline" DOUBLE,
"transit_stations_percent_change_from_baseline" DOUBLE,
"workplaces_percent_change_from_baseline" DOUBLE,
"residential_percent_change_from_baseline" DOUBLE
);CREATE TABLE n_2022_sn_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" DOUBLE,
"grocery_and_pharmacy_percent_change_from_baseline" DOUBLE,
"parks_percent_change_from_baseline" DOUBLE,
"transit_stations_percent_change_from_baseline" DOUBLE,
"workplaces_percent_change_from_baseline" DOUBLE,
"residential_percent_change_from_baseline" DOUBLE
);CREATE TABLE n_2022_sv_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" DOUBLE,
"grocery_and_pharmacy_percent_change_from_baseline" DOUBLE,
"parks_percent_change_from_baseline" DOUBLE,
"transit_stations_percent_change_from_baseline" DOUBLE,
"workplaces_percent_change_from_baseline" BIGINT,
"residential_percent_change_from_baseline" DOUBLE
);CREATE TABLE n_2022_tg_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" DOUBLE,
"grocery_and_pharmacy_percent_change_from_baseline" DOUBLE,
"parks_percent_change_from_baseline" DOUBLE,
"transit_stations_percent_change_from_baseline" DOUBLE,
"workplaces_percent_change_from_baseline" BIGINT,
"residential_percent_change_from_baseline" DOUBLE
);CREATE TABLE n_2022_th_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" BIGINT,
"grocery_and_pharmacy_percent_change_from_baseline" BIGINT,
"parks_percent_change_from_baseline" BIGINT,
"transit_stations_percent_change_from_baseline" BIGINT,
"workplaces_percent_change_from_baseline" BIGINT,
"residential_percent_change_from_baseline" BIGINT
);CREATE TABLE n_2022_tj_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" BIGINT,
"grocery_and_pharmacy_percent_change_from_baseline" BIGINT,
"parks_percent_change_from_baseline" BIGINT,
"transit_stations_percent_change_from_baseline" BIGINT,
"workplaces_percent_change_from_baseline" BIGINT,
"residential_percent_change_from_baseline" BIGINT
);CREATE TABLE n_2022_tr_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" DOUBLE,
"grocery_and_pharmacy_percent_change_from_baseline" DOUBLE,
"parks_percent_change_from_baseline" DOUBLE,
"transit_stations_percent_change_from_baseline" DOUBLE,
"workplaces_percent_change_from_baseline" DOUBLE,
"residential_percent_change_from_baseline" DOUBLE
);CREATE TABLE n_2022_tt_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" BIGINT,
"grocery_and_pharmacy_percent_change_from_baseline" BIGINT,
"parks_percent_change_from_baseline" BIGINT,
"transit_stations_percent_change_from_baseline" BIGINT,
"workplaces_percent_change_from_baseline" BIGINT,
"residential_percent_change_from_baseline" BIGINT
);CREATE TABLE n_2022_tw_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" BIGINT,
"grocery_and_pharmacy_percent_change_from_baseline" BIGINT,
"parks_percent_change_from_baseline" BIGINT,
"transit_stations_percent_change_from_baseline" BIGINT,
"workplaces_percent_change_from_baseline" BIGINT,
"residential_percent_change_from_baseline" BIGINT
);CREATE TABLE n_2022_tz_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" DOUBLE,
"grocery_and_pharmacy_percent_change_from_baseline" DOUBLE,
"parks_percent_change_from_baseline" DOUBLE,
"transit_stations_percent_change_from_baseline" DOUBLE,
"workplaces_percent_change_from_baseline" DOUBLE,
"residential_percent_change_from_baseline" DOUBLE
);CREATE TABLE n_2022_ua_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" BIGINT,
"grocery_and_pharmacy_percent_change_from_baseline" BIGINT,
"parks_percent_change_from_baseline" BIGINT,
"transit_stations_percent_change_from_baseline" BIGINT,
"workplaces_percent_change_from_baseline" BIGINT,
"residential_percent_change_from_baseline" BIGINT
);CREATE TABLE n_2022_ug_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" DOUBLE,
"grocery_and_pharmacy_percent_change_from_baseline" DOUBLE,
"parks_percent_change_from_baseline" DOUBLE,
"transit_stations_percent_change_from_baseline" DOUBLE,
"workplaces_percent_change_from_baseline" DOUBLE,
"residential_percent_change_from_baseline" DOUBLE
);CREATE TABLE n_2022_us_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" DOUBLE,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" DOUBLE,
"grocery_and_pharmacy_percent_change_from_baseline" DOUBLE,
"parks_percent_change_from_baseline" DOUBLE,
"transit_stations_percent_change_from_baseline" DOUBLE,
"workplaces_percent_change_from_baseline" DOUBLE,
"residential_percent_change_from_baseline" DOUBLE
);CREATE TABLE n_2022_uy_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" DOUBLE,
"grocery_and_pharmacy_percent_change_from_baseline" DOUBLE,
"parks_percent_change_from_baseline" DOUBLE,
"transit_stations_percent_change_from_baseline" DOUBLE,
"workplaces_percent_change_from_baseline" DOUBLE,
"residential_percent_change_from_baseline" DOUBLE
);CREATE TABLE n_2022_ve_region_mobility_report (
"country_region_code" VARCHAR,
"country_region" VARCHAR,
"sub_region_1" VARCHAR,
"sub_region_2" VARCHAR,
"metro_area" VARCHAR,
"iso_3166_2_code" VARCHAR,
"census_fips_code" VARCHAR,
"place_id" VARCHAR,
"date" TIMESTAMP,
"retail_and_recreation_percent_change_from_baseline" BIGINT,
"grocery_and_pharmacy_percent_change_from_baseline" BIGINT,
"parks_percent_change_from_baseline" BIGINT,
"transit_stations_percent_change_from_baseline" BIGINT,
"workplaces_percent_change_from_baseline" BIGINT,
"residential_percent_change_from_baseline" BIGINT
);Anyone who has the link will be able to view this.