Pet project to understand more of SQLite, R Shiny, and data visualization on Windows 10 x64. Contains R code to download and process Google Mobility data for only Canadian regions. The scripts are to simplify the download, clean, and process steps.
- Download .zip and only extract Canadian regions .csv files
- Process raw .csv into national, provincial/territorial, and municipal levels
- Store into local SQLite database
- Read tables from SQLite and feed into downstream workflows
Last updated: 2021-01-26