Google now publishes official CSV files
Archive of data extracted from Google’s Community Mobility Reports. All countries are included.
Last updated on the 16th of April 2020, with data up to the 11th of April 2020.
The onus is on you to check against the original PDF files, but this should be okay to use. Previous problems have been fixed. It has been checked against similar work by the Office for National Statistics Data Science Campus.
Illustration of the data only. Google recommends against comparing changes between countries or regions.
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).
Download zipped tab-separated files of the countries or United States counties. Google publishes the data as a sliding window, so some dates appear in several reports, and recent reports only include recent dates. These files cover all dates reported so far, and keep only the latest version of each data point.
Files for each report are also available, named by the date of the
report, for example 2020-03-29-country.tsv for countries and
2020-03-29-regions.tsv for (so far) United States counties.
Based on similar work by the Office for National Statistics Data Science Campus.
- Convert the PDF files to SVG format, and extract the trend lines.
- Extract text from the PDF.
- Pair up the text with the trends.
The differences are:
- All countries are included.
- Using R, instead of Python
- Scripting pdf->svg file conversion with
pdf2svg, rather than doing it manually.