search

UI-Research / mobility-from-poverty

https://ui-research.github.io/mobility-from-poverty/
4 stars 1 forks source link

Iss213 #288

Closed vpancini closed 4 months ago

vpancini commented 4 months ago

This PR is for the county-level juvenile arrests metric. There are two files:

The first file is 01_agnecy_geo_county.Rmd. Our arrest data is at the law enforcement agency level, and this file links law enforcement agencies to counties. It also pulls in demographic data from 2014-2022 from the ACS which is later used in creation of the metric. So this file needs to be run and reviewed first.

The second file is juvenile-arrests-county-all.Rmd. This file creates the metric of juvenile arrests (total, violent crimes, and property crimes) and for the race/ethnicity subgroup. Note that the beginning of this file that reads in and appends all the data takes a long time to run.

Outstanding items are marked with either todo(): or Note. Items marked todo(): are especially welcome for reviewer input. Items marked with Note are more 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 that create rates in sections 6 and 7. 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.

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.

vpancini commented 4 months ago

Also note that the only files that should be reviewed are 01_agnecy_geo_county.Rmd followed by juvenile-arrests-county-all.Rmd. Any other files included in this PR are old/included by accident.

vpancini commented 4 months ago

This PR is for the juvenile arrests 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.

The second two files are juvenile-arrests-county-all.Rmd and juvenile-arrests-place-all.Rmd. These files create the metric of juvenile arrests (total, violent crimes, and property crimes) and for the race/ethnicity subgroup. Note that the beginning of these files that reads in and appends all the data takes a long time 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.