This PR is for the reported crime metric. There are four files:
The first two files are 01_agnecy_geo_county.Rmd and 01_agnecy_geo_place.Rmd. Our arrest data is at the law enforcement agency level, and these files link law enforcement agencies to counties or places respectively. They also pull in demographic data from 2014-2022 from the ACS which is later used in creation of the metric at each geographic level. So these files need to be run and reviewed first. Note that these files are the exact same as the files with the same names for the juvenile arrests metric, so the reviewer need only review the pair once.
The second two files are reported-crime-county-all.Rmd and reported-crime-place-all.Rmd. These files create the metric of reported crimes (violent crimes and property crimes). Note that the beginning of these files that reads in and appends all the data takes a while to run.
Outstanding items are marked with either todo(): or Note. Items marked with todo() are mostly last minute additions I was asked to make. Items marked with Note are mostly things I am noting for future update reference. I would also appreciate the reviewer paying close attention to areas of the code that join data sets and checking the rate values. I implemented some checks along the way, but I have been working in this program for a long time, so having a fresh pair of eyes to check my logic would be great. Note that there is a lot of missingness prior to 2021 because most law enforcement agencies did not report to NIBRS (our main data source) before then.
Data necessary for review of these files can be found in the Box folder here. Please reach out to Vincent on Slack with any questions.
This PR is for the reported crime metric. There are four files:
The first two files are 01_agnecy_geo_county.Rmd and 01_agnecy_geo_place.Rmd. Our arrest data is at the law enforcement agency level, and these files link law enforcement agencies to counties or places respectively. They also pull in demographic data from 2014-2022 from the ACS which is later used in creation of the metric at each geographic level. So these files need to be run and reviewed first. Note that these files are the exact same as the files with the same names for the juvenile arrests metric, so the reviewer need only review the pair once.
The second two files are reported-crime-county-all.Rmd and reported-crime-place-all.Rmd. These files create the metric of reported crimes (violent crimes and property crimes). Note that the beginning of these files that reads in and appends all the data takes a while to run.
Outstanding items are marked with either
todo():orNote. Items marked withtodo()are mostly last minute additions I was asked to make. Items marked withNoteare mostly things I am noting for future update reference. I would also appreciate the reviewer paying close attention to areas of the code that join data sets and checking the rate values. I implemented some checks along the way, but I have been working in this program for a long time, so having a fresh pair of eyes to check my logic would be great. Note that there is a lot of missingness prior to 2021 because most law enforcement agencies did not report to NIBRS (our main data source) before then.Data necessary for review of these files can be found in the Box folder here. Please reach out to Vincent on Slack with any questions.