Baselight

GOOGLE MOBILITY DATA

Understand how people are moving due to COVID

@kaggle.aiswaryaramachandran_google_mobility_data

Loading...
Loading...

About this Dataset

GOOGLE MOBILITY DATA

Context

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/)

Content

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.

Acknowledgements

This data from report published by Google. https://www.google.com/covid19/mobility/

Inspiration

Some Questions to answer

  1. 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?

  2. Comparing Mobility across different Countries

Tables

N 2020 Ae Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_ae_region_mobility_report
  • 32.99 kB
  • 2,561 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_ae_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
);

N 2020 Af Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_af_region_mobility_report
  • 19.85 kB
  • 552 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_af_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" BIGINT
);

N 2020 Ag Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_ag_region_mobility_report
  • 22.55 kB
  • 1,292 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_ag_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
);

N 2020 Ao Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_ao_region_mobility_report
  • 23.07 kB
  • 1,528 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_ao_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
);

N 2020 Ar Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_ar_region_mobility_report
  • 630.18 kB
  • 130,441 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_ar_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
);

N 2020 At Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_at_region_mobility_report
  • 171.07 kB
  • 30,403 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_at_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
);

N 2020 Au Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_au_region_mobility_report
  • 425.62 kB
  • 85,330 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_au_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
);

N 2020 Aw Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_aw_region_mobility_report
  • 18.49 kB
  • 321 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_aw_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
);

N 2020 Ba Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_ba_region_mobility_report
  • 18.46 kB
  • 321 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_ba_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
);

N 2020 Bb Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_bb_region_mobility_report
  • 27.25 kB
  • 2,357 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_bb_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
);

N 2020 Bd Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_bd_region_mobility_report
  • 18.46 kB
  • 321 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_bd_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
);

N 2020 Be Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_be_region_mobility_report
  • 48.19 kB
  • 4,494 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_be_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" BIGINT,
  "workplaces_percent_change_from_baseline" DOUBLE,
  "residential_percent_change_from_baseline" BIGINT
);

N 2020 Bf Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_bf_region_mobility_report
  • 24.08 kB
  • 1,399 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_bf_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
);

N 2020 Bg Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_bg_region_mobility_report
  • 152.27 kB
  • 35,899 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_bg_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
);

N 2020 Bh Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_bh_region_mobility_report
  • 17.52 kB
  • 321 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_bh_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
);

N 2020 Bj Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_bj_region_mobility_report
  • 23.25 kB
  • 1,650 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_bj_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
);

N 2020 Bo Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_bo_region_mobility_report
  • 87.53 kB
  • 15,587 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_bo_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
);

N 2020 Br Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_br_region_mobility_report
  • 2.08 MB
  • 590,689 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_br_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
);

N 2020 Bs Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_bs_region_mobility_report
  • 23.36 kB
  • 1,234 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_bs_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
);

N 2020 Bw Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_bw_region_mobility_report
  • 26.36 kB
  • 2,388 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_bw_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
);

N 2020 By Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_by_region_mobility_report
  • 17.94 kB
  • 321 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_by_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
);

N 2020 Bz Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_bz_region_mobility_report
  • 24.95 kB
  • 1,718 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_bz_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
);

N 2020 Ca Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_ca_region_mobility_report
  • 340.5 kB
  • 76,903 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_ca_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
);

N 2020 Ch Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_ch_region_mobility_report
  • 66.5 kB
  • 8,374 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_ch_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
);

N 2020 Ci Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_ci_region_mobility_report
  • 30.93 kB
  • 3,697 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_ci_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
);

Share link

Anyone who has the link will be able to view this.