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 Ua Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_ua_region_mobility_report
  • 20.87 kB
  • 642 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_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
);

N 2020 Ug Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_ug_region_mobility_report
  • 40.04 kB
  • 5,964 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_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
);

N 2020 Us Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_us_region_mobility_report
  • 3.27 MB
  • 812,065 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_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
);

N 2020 Uy Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_uy_region_mobility_report
  • 58.04 kB
  • 6,564 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_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
);

N 2020 Ve Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_ve_region_mobility_report
  • 18.36 kB
  • 321 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_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
);

N 2020 Vn Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_vn_region_mobility_report
  • 139.91 kB
  • 20,516 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_vn_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 Ye Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_ye_region_mobility_report
  • 17.8 kB
  • 321 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_ye_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" 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
);

N 2020 Za Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_za_region_mobility_report
  • 38.26 kB
  • 3,210 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_za_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" BIGINT
);

N 2020 Zm Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_zm_region_mobility_report
  • 19.86 kB
  • 642 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_zm_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" BIGINT,
  "workplaces_percent_change_from_baseline" BIGINT,
  "residential_percent_change_from_baseline" BIGINT
);

N 2020 Zw Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2020_zw_region_mobility_report
  • 35.94 kB
  • 5,694 rows
  • 15 columns
Loading...
CREATE TABLE n_2020_zw_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 2021 Ae Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2021_ae_region_mobility_report
  • 35.72 kB
  • 2,920 rows
  • 15 columns
Loading...
CREATE TABLE n_2021_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" 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" DOUBLE
);

N 2021 Af Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2021_af_region_mobility_report
  • 21.8 kB
  • 730 rows
  • 15 columns
Loading...
CREATE TABLE n_2021_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" 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 2021 Ag Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2021_ag_region_mobility_report
  • 23.75 kB
  • 1,577 rows
  • 15 columns
Loading...
CREATE TABLE n_2021_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 2021 Ao Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2021_ao_region_mobility_report
  • 24.68 kB
  • 1,820 rows
  • 15 columns
Loading...
CREATE TABLE n_2021_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 2021 Ar Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2021_ar_region_mobility_report
  • 780.8 kB
  • 158,348 rows
  • 15 columns
Loading...
CREATE TABLE n_2021_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 2021 At Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2021_at_region_mobility_report
  • 204.31 kB
  • 35,500 rows
  • 15 columns
Loading...
CREATE TABLE n_2021_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 2021 Au Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2021_au_region_mobility_report
  • 513.55 kB
  • 104,926 rows
  • 15 columns
Loading...
CREATE TABLE n_2021_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 2021 Aw Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2021_aw_region_mobility_report
  • 18.57 kB
  • 365 rows
  • 15 columns
Loading...
CREATE TABLE n_2021_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" 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 2021 Ba Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2021_ba_region_mobility_report
  • 19.11 kB
  • 365 rows
  • 15 columns
Loading...
CREATE TABLE n_2021_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 2021 Bb Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2021_bb_region_mobility_report
  • 29.78 kB
  • 2,791 rows
  • 15 columns
Loading...
CREATE TABLE n_2021_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 2021 Bd Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2021_bd_region_mobility_report
  • 19.34 kB
  • 365 rows
  • 15 columns
Loading...
CREATE TABLE n_2021_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 2021 Be Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2021_be_region_mobility_report
  • 53.45 kB
  • 5,110 rows
  • 15 columns
Loading...
CREATE TABLE n_2021_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" BIGINT,
  "grocery_and_pharmacy_percent_change_from_baseline" BIGINT,
  "parks_percent_change_from_baseline" DOUBLE,
  "transit_stations_percent_change_from_baseline" BIGINT,
  "workplaces_percent_change_from_baseline" BIGINT,
  "residential_percent_change_from_baseline" BIGINT
);

N 2021 Bf Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2021_bf_region_mobility_report
  • 26.11 kB
  • 1,680 rows
  • 15 columns
Loading...
CREATE TABLE n_2021_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" BIGINT,
  "residential_percent_change_from_baseline" DOUBLE
);

N 2021 Bg Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2021_bg_region_mobility_report
  • 184.27 kB
  • 46,812 rows
  • 15 columns
Loading...
CREATE TABLE n_2021_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 2021 Bh Region Mobility Report

@kaggle.aiswaryaramachandran_google_mobility_data.n_2021_bh_region_mobility_report
  • 18.03 kB
  • 365 rows
  • 15 columns
Loading...
CREATE TABLE n_2021_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
);

Share link

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