This repo consists of Google's Community 19 Mobility Report data for India at the district level, daily over the period 15th February 2020 to 15th October 2022. The data is publicly available here. My small contribution here is to match the districts to the local government directory (LGD codes), which allows for easy merging with datasets to conduct any empirical analysis at the district level!
After cleaning and matching, the dataset consists of 620 districts and 32 states/Union Territories.
You will find the following folders above
1_raw
: Raw csvs, lgd keys and handmatched district data2_code
: do file needed to clean and produce the matched data3_clean
: Final cleaned dataset
In case you want to generate the dataset from scratch, follow the steps below:
- Open
google_mob.stpr
- From within the Stata project, open
2_code/clean.do
and run the file. - This generate
google_mobility_data.dta
andgoogle_mobility_data.csv
- Each value represents a percentage change from the January 2020 mobility level, so be careful while defining your other variables. Normalizing them to Jan 2020 values may be a good idea
- While all other indicators correlate well and co-move, residential mobility doesn't (see figure below)! You might want to consider excluding it from your dataset altogether.
The cleaning was done using Stata 16