Methods

Data preparation

I acquired the data from the server and performed consistency tests. I fixed data format quality issues in relation to timestamps.

Data Selection

I selected data for 10 annual periods, starting from May 13, 2011 to May, 12, 2021.
Data extraction involved the subsetting of the primary dataset, by “CALL_TYPE”. Only “DOMESTIC DISTURBANCE” calls were selected. I further subsetted data to remove all entries that related to serious adverse action by SJPD. Instead, I selected those records where I believe SJPD has made a formal determination after actually visiting the site.