Crime data (San Diego Police Department)

Rachelle Annechino filed this request with the San Diego Police Department of San Diego, CA.

It is a clone of this request.

Tracking #

21-1033

Multi Request Crime data
Status
Completed

Communications

From: Rachelle Annechino

To Whom It May Concern:

Pursuant to the California Public Records Act, I hereby request the following records:

Data on incidents/crimes reported from 1/1/2009 through 12/31/2020. I am part of a public health research team that is seeking this information for research aimed at reducing violence.

Specifically we are looking for data on all incidents that fall under FBI UCR Part I and Part II [https://ucr.fbi.gov/crime-in-the-u.s/2011/crime-in-the-u.s.-2011/offense-definitions], including as many of the following fields as possible (based on the FBI UCR data elements shown at [https://www.fbi.gov/file-repository/ucr/ucr-2019-1-nibrs-technical-specification.pdf/view]):

Incident Number (UCR Data Element 2)
Incident Date & Time/Hour (UCR Data Element 3)
UCR Offense Code (UCR Data Element 6)
Offense Attempted/Completed (UCR Data Element 7)
Offender Suspected of Using (UCR Data Element 8)
Bias Motivation (UCR Data Element 8A)
Location Type (UCR Data Element 9)
Type Weapon/Force Involved (UCR Data Element 13)
Type Property Loss/Etc. (UCR Data Element 14)
Suspected Drug Type (UCR Data Element 20)
Type of Victim (UCR Data Element 25)
Type of Officer Activity/Circumstance (UCR Data Element 25A)
Officer Assignment Type (UCR Data Element 25B)
Officer- ORI Other Jurisdiction (UCR Data Element 25C)
Age of Victim (UCR Data Element 26)
Sex of Victim (UCR Data Element 27)
Race of Victim (UCR Data Element 28)
Ethnicity of Victim (UCR Data Element 29)
Resident Status of Victim (UCR Data Element 30)
Aggravated Assault/Homicide Circumstances (UCR Data Element 31)
Type Injury (UCR Data Element 33)
Age of Offender (UCR Data Element 37)
Sex of Offender (UCR Data Element 38)
Race of Offender (UCR Data Element 39)
Ethnicity of Offender (UCR Data Element 39A)
Arrest Date (UCR Data Element 42)
Type of Arrest (UCR Data Element 43)
UCR Arrest Offense Code (UCR Data Element 43)
Age of Arrestee (UCR Data Element 47)
Sex of Arrestee (UCR Data Element 48)
Race of Arrestee (UCR Data Element 49)
Ethnicity of Arrestee (UCR Data Element 50)
Resident Status of Arrestee (UCR Data Element 51)
Disposition of Arrestee Under 18 (UCR Data Element 52)

and

street level location data for each incident, such as a geocoded location, street address, census block and/or census block group

We are requesting this data in a machine-readable format such as Excel spreadsheets or .csv files.

The requested documents will be made available to the general public, and this request is not being made for commercial purposes.

In the event that there are fees, I would be grateful if you would inform me of the total charges in advance of fulfilling my request. I would prefer the request filled electronically, by e-mail attachment if available or CD-ROM if not.

Thank you in advance for your anticipated cooperation in this matter. I look forward to receiving your response to this request within 10 calendar days, as the statute requires.

Sincerely,

Rachelle Annechino

From: San Diego Police Department

City of San Diego

************************************************************************

Hi there

Your first City of San Diego record request (request number #21-1033) has been submitted.
It is currently unpublished and is not available for the general public to view.

Please be advised that City staff have received your CPRA request. Within the next 10 days, we will determine whether your request seeks copies of disclosable records in the City's possession or whether the City will require an extension. If your request is submitted on a Saturday, Sunday, or City holiday, the City considers the request received on the following business day.

Request #21-1033.

************************************************************************
<em>Questions about your request?</em> Reply to this email or sign in to contact staff at City of San Diego.<br></br><em>Technical support:</em> See our <a href='https://www.nextrequest.com/support'>help page</a>

From: San Diego Police Department

City of San Diego

************************************************************************

Hi there

A message was sent to you regarding record request #21-1033:

Good afternoon,

Pursuant to California Government Code section 6253(c), in the case of electronic records, the City needs to compile data. Therefore, the City is taking a 14-day extension in which to conduct this compilation. We will notify you on or before March 26 whether the City has responsive records.

Kind regards.

************************************************************************
<em>Questions about your request?</em> Reply to this email or sign in to contact staff at City of San Diego.<br></br><em>Technical support:</em> See our <a href='https://www.nextrequest.com/support'>help page</a>

From: San Diego Police Department

City of San Diego

************************************************************************

Hi there

A message was sent to you regarding record request #21-1033:

Good morning,

In response to the request, all responsive records have been uploaded. Please note that there are multiple tabs in the report. The dataset has a retention period for only 7 years, therefore the data provided begins in 2013 and culminates with the requested date of December 2020. Additionally, historical data was not stored in a NIBRs UCR data element format. The fields provided in the responsive records are the closest match to what was requested. Any fields that are absent from the requested data unfortunately do not exist in the historical dataset.

Kind regards.

************************************************************************
<em>Questions about your request?</em> Reply to this email or sign in to contact staff at City of San Diego.<br></br><em>Technical support:</em> See our <a href='https://www.nextrequest.com/support'>help page</a>

From: San Diego Police Department

City of San Diego

************************************************************************

Hi there

A document has been released for record request #21-1033:

* CPRA 21-1033 SDPD_Crimes_Arrests 2013-2020_SDPD.xlsx

************************************************************************
<em>Questions about your request?</em> Reply to this email or sign in to contact staff at City of San Diego.<br></br><em>Technical support:</em> See our <a href='https://www.nextrequest.com/support'>help page</a>

From: San Diego Police Department

City of San Diego

************************************************************************

Hi there

Record request #21-1033 has been closed.

************************************************************************
<em>Questions about your request?</em> Reply to this email or sign in to contact staff at City of San Diego.<br></br><em>Technical support:</em> See our <a href='https://www.nextrequest.com/support'>help page</a>

From: San Diego Police Department

City of San Diego

************************************************************************

Hi there

Record request #21-1033 has been published and is now available for public view.

************************************************************************
<em>Questions about your request?</em> Reply to this email or sign in to contact staff at City of San Diego.<br></br><em>Technical support:</em> See our <a href='https://www.nextrequest.com/support'>help page</a>

Files