Mobility_Google

Google’s Community Mobility Reports are aggregated location data showing the change in visits to places like grocery stores, parks, workplaces, etc. Big Local News takes a snap shot of this data whenever it is updated, which is typically once a week. The CSV files with "BLN" were processed by Big Local News with additional columns of data added such as rolling averages. All files are provided as one zipped file for easier downloading. The date in the file name represents the most recent data available from Google. Please read the README file for complete documentation.

Data source: Big Local News · About: big-local-datasette

Custom SQL query

BLN_Mobility_Report_US_2020_06_07

country_region_code, country_region, sub_region_1, sub_region_2, geolevel_bln, iso_3166_2_code, census_fips_code, date, retail_and_recreation_percent_change_from_baseline...

304,648 rows

BLN_Mobility_Report_nonUS_2020_06_07

country_region_code, country_region, sub_region_1, sub_region_2, iso_3166_2_code, census_fips_code, date, retail_and_recreation_percent_change_from_baseline, grocery_and_pharmacy_percent_change_from_baseline...

211,162 rows

Google_Mobility_Report_2020_06_07

country_region_code, country_region, sub_region_1, sub_region_2, iso_3166_2_code, census_fips_code, date, retail_and_recreation_percent_change_from_baseline, grocery_and_pharmacy_percent_change_from_baseline...

516,697 rows

Download SQLite DB: Mobility_Google.db 83.6 MB

Powered by Datasette · Query took 6.321ms · Data source: Big Local News · About: big-local-datasette