Crime data (San Francisco Police Department)

Rachelle Annechino filed this request with the San Francisco Police Department of San Francisco, CA .
Tracking #

P028509-030121

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 Francisco Police Department

Dear Rachelle Annechino:

Thank you for your interest in public records of the San Francisco Police Department ("SFPD").

The San Francisco Police Department ("SFPD") received your request, dated March 01, 2021 and given the reference number P028509-030121 for tracking purposes.

Record(s) Requested: 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

Upload documents directly: https://https://www.muckrock.comhttps://www.muckrock.com/

Your request is being forwarded to the appropriate department(s) for processing and you will be notified once the request is complete.

You can monitor request progress at the link below.  Thank you for using the San Francisco Public Records Center.


San Francisco Police Department

From: San Francisco Police Department

--- Please respond above this line ---

March 08, 2021
Via email requests@muckrock.com

Rachelle Annechino
MuckRock News DEPT MR 109063 411A Highland Ave
Somerville, MA 02144

RE: Public Records Request, dated March 01, 2021, Reference # P028509-030121

Dear Rachelle Annechino:

The San Francisco Police Department (SFPD) received your Public Records Act request, dated March 01, 2021.

You requested, " 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

Upload documents directly: https://https://www.muckrock.comhttps://www.muckrock.com/

From: San Francisco Police Department

--- Please respond above this line ---

March 08, 2021
Via email requests@muckrock.com

Rachelle Annechino
MuckRock News DEPT MR 109063 411A Highland Ave
Somerville, MA 02144

RE: Public Records Request, dated March 01, 2021, Reference # P028509-030121

Dear Rachelle Annechino:

The San Francisco Police Department (SFPD) received your Public Records Act request, dated March 01, 2021.

You requested, " 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

Upload documents directly: https://https://www.muckrock.comhttps://www.muckrock.com/
UCR data is released by the FBI thru 2019, and is available publicly here: FBI — Crime in the U.S. 2019 and here: (https://u8387795.ct.sendgrid.net/ls/click?upn=nZGH0ylxadMp5hTpNkeAFrM2bAGgcsjbxO6C4d3ov7zDOEsmO7hWJ9zFwC24hwyV6vDxZ6r9951KKjWForXw6Bjr-2FZzOpl5eh5dIHz5YYnE-3DjZMX_7nbFdiglF756uyC3Gam-2FsVpTouf9TKi4Su9EakYq7-2Fw-2BsPPS6Ofn9KmPDIboeuJaVAdHdA8RVi0LHEaSRzwVC4wOrHRVePYYq6F00GQgNMYO8sV-2Fv12v1vwdFI-2FHXpUd08e0s5WkAudLPE9SVZgJd4nJQvtxIqXyb-2FSiOtp87QadBIZFK0wjQ2WKM03iqIGupRwLr3KDpgdfzh6qY5fgG-2FCyFAsAB5nAkdwWPBHC0XFw0N4u73hqlKdMm7Tr9I1ua-2BOwJnkOt-2B1tDHm-2BKlJNndRBElRCiZMZWd2VZN3EXVghM-2FLVbflNWK4YJUca-2Fys2MG-2FAsTgJ6p6BFaG-2FqqrxnSbMehRGh946J17wMPv9TWKjcLs30wD-2BhLDPt1vapB-2BlFtPyKMGEneOrldPT6ZZcXg-3D-3D) CDE :: Downloads (cloud.gov) (https://u8387795.ct.sendgrid.net/ls/click?upn=nZGH0ylxadMp5hTpNkeAFogqt21f6ApObSxE37IUNzX8swn17Vz47fTzsVDAQ397iWvxh2Kvnk0LSPl6Up0yFvN37RuwidswtcEPkgQv794-3DGmc6_7nbFdiglF756uyC3Gam-2FsVpTouf9TKi4Su9EakYq7-2Fw-2BsPPS6Ofn9KmPDIboeuJaVAdHdA8RVi0LHEaSRzwVC4wOrHRVePYYq6F00GQgNMYO8sV-2Fv12v1vwdFI-2FHXpUd08e0s5WkAudLPE9SVZgJd4nJQvtxIqXyb-2FSiOtp87QadBIZFK0wjQ2WKM03iqIGupRwLr3KDpgdfzh6qY5fgG-2FCyFAsAB5nAkdwWPBHC0XFw0N4u73hqlKdMm7Tr9I1uq1IDj-2BentK28cFMHZL4xhpL-2BHkZwtokCVq8pH14uwYwsR2I7UY3sHdDIY1lBu5lGdLZP5nvWuKMNSL4xieR1Jk3LqJEtj78Nlfo0efDOUl5XNcHgIhrVzGw3Rzw6cZ8FeMS54l9WlxoAmHU5D6UE2A-3D-3D)
The Crime Analysis Unit is working on your 2020 data request.

Sincerely,

Michael Andraychak
Media Relations
415-837-7395

This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY.

From: San Francisco Police Department

--- Please respond above this line ---

March 24, 2021 Via email requests@muckrock.com
Rachelle Annechino
MuckRock News DEPT MR 109063 411A Highland Ave
Somerville, MA 02144
RE: Public Records Request, dated March 01, 2021, Reference # P028509-030121
Dear Rachelle Annechino:
The San Francisco Police Department (SFPD) received your Public Records Act request, dated March 01, 2021, on March 24, 2021.
You requested, " 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

Upload documents directly: https://https://www.muckrock.comhttps://www.muckrock.com/
Responsive records are available via the San Francisco Public Records Center. Click on the link below to view your request.
From our Crime Analysis Team:
The requestor is asking for UCR data under the NIBRS schema (see the link they provided.) As of today, SFPD does not submit information to the UCR Program via NIBRS/incident-based reporting - we utilize summary reporting, the summary which is what was attached.

The department does not have NIBRS compliant data to provide.

Please refer to FBI/UCR page for data prior to 2020.
https://crime-data-explorer.app.cloud.gov/explorer/agency/CA0380100/crime
or
https://www.fbi.gov/services/cjis/ucr/ Public Records Request - P028509-030121
If you have any questions, please contact Michael Andraychak at 415-837-7395.
Thank you for your attention.
Sincerely,
Sergeant Michael Andraychak
Officer in Charge
Media Relations

This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY.

Files

pages

Close