Get Google Mobility Data at the State of Subdivision Level

Source: R/refresh_covid19mobility_google.R

From Google: "Each Community Mobility Report dataset is presented by location and highlights the percent change in visits to places like grocery stores and parks within a geographic area.

Location accuracy and the understanding of categorized places varies from region to region, so we don’t recommend using this data to compare changes between countries, or between regions with different characteristics (e.g. rural versus urban areas).

Changes for each day are compared to a baseline value for that day of the week: The baseline is the median value, for the corresponding day of the week, during the 5-week period Jan 3–Feb 6, 2020. The datasets show trends over several months with the most recent data representing approximately 2-3 days ago—this is how long it takes to produce the datasets."

Data represents changes from baseline visits for the following types of locations visited:

  • retail and recreation

  • grocery and pharmacy

  • parks

  • transit stations

  • workplaces

  • residential

refresh_covid19mobility_google_subregions()

Value

A tibble meeting the Covid19R Project data standard. Columns include:

  • date - The date in YYYY-MM-DD form

  • location - The name of the location as provided by the data source.

  • location_type - The type of location using the covid19R controlled vocabulary.

  • location_code - A standardized location code using a national or international standard. In this case, FIPS state or county codes. See https://en.wikipedia.org/wiki/Federal_Information_Processing_Standard_state_code and https://en.wikipedia.org/wiki/FIPS_county_code for more

  • location_code_type The type of standardized location code being used according to the covid19R controlled vocabulary. Here we use iso_3166_2

  • data_type - the type of data in that given row. See description.

  • value - number of cases of each data type

References

Google Covid-19 Mobility Reports https://www.google.com/covid19/mobility/

The Covid19R Project https://covid19r.github.io/documentation/

Examples

# \donttest{
covid19mobility_google_subregions <- refresh_covid19mobility_google_subregions()
#> Joining, by = c("location_code", "sub_region_1")

head(covid19mobility_google_subregions)
#> # A tibble: 6 x 7
#>   date       location location_type location_code location_code_t… data_type
#>   <date>     <chr>    <chr>         <chr>         <chr>            <chr>    
#> 1 2020-02-15 Abu Dha… state         AE-AZ         iso_3166_2       retail_a…
#> 2 2020-02-15 Abu Dha… state         AE-AZ         iso_3166_2       grocery_…
#> 3 2020-02-15 Abu Dha… state         AE-AZ         iso_3166_2       parks_pe…
#> 4 2020-02-15 Abu Dha… state         AE-AZ         iso_3166_2       transit_…
#> 5 2020-02-15 Abu Dha… state         AE-AZ         iso_3166_2       workplac…
#> 6 2020-02-15 Abu Dha… state         AE-AZ         iso_3166_2       resident…
#> # … with 1 more variable: value <int>
# }