San Diego Crime Incidents with Victim Descriptions

Crime Victims in San Diego, from 2016 though July 2020, with UCR codes for the crime and the age, race and sex of the victim.

arjis.org-crime_victims-pra-1.1.1. Modified 2020-09-30T16:40:33

Resources | Packages | Documentation| Contacts| References| Data Dictionary

Resources

Documentation

There are important national conversations going on about criminal justice reform, aligning resources towards prevention and community support rather than primarily for policing, and calls to Defund or Abolish the Police. These are all valuable discussions about the communities in which we want to live. An important voice in that conversation is the voice of victims of crime. The data below is a complete data set for victims of violent crime from ARJIS (Automated Regional Justice Information System) for San Diego County, the nation’s fifth largest County, from 2016 through 2020. The complete data set, a cleaned version of the data, a data dictionary, the Public Records Act request on which the data was based and several maps are provided for review. A full conversation requires diverse voices and will help ensure that resources are realigned in a way that furthers the dual aims of equity and safety in our communities.

The file has multiple rows per incident, one for each suspect or victim. The primary key pk links records together into a single crime incident.

This package provides the datasets as CSV files. You can also get the Excel source files for these CSVs, and the Excel file originally returned by ARJIS:

  • Processed Dataset. Excel. This is the dataset used to generate this data package
  • Original Source Dataset. Excel. Original, unprocessed dataset, ARJIS’ response to the PRA. This dataset is an Excel file with one tab per year.

Processing

The resources in this pacakage have been converted from Excel format to CSV, and the mixed-case column names are all lowercased. For the Excel file source, as it was recieved by the San Diego Regional Data Library, see the References Section.

  • dates are converted to ISO format
  • Created “year” field
  • Deleted MACRStatus from years 2017-2020
  • Combined years into 1 file
  • Deleted partial August cases to have complete month
  • Deleted 2 ARJIS and 1 DA as AGENCY records
  • Deleted incident type (all were crime case), highcharge (all were 1) and role (all were incident)
  • ALLYRS_NOSUSP includes only victims, victim/witnesses and blank (property?) in the person role
  • UNIQUECASE includes unique case numbers (no matter how many victims)

ALLYEARS data has 676,244 records/ ALLYRS_NOSUSP has 402,397 records with 312,089 unique cases

Of the 312,089 cases, 5% (16,765) don’t have a block number and 2% (5,025) don’t have a ZIP (with another 1-2% with a ZIP not in SD County).

Images

  • Homicide Victims by Race, San Diego County
  • Violent Crime Victims, Jan 2016 to July 2020, South Central San Diego County. Neighborhoods with large proportions of Black/Latino crime victims.
  • Violent Crime Victims, Jan 2016 to July 2020, South Central San Diego County. Higher and lower crime rate neighborhoods

Contacts

Data Dictionary

ucrcodes | sdcrime_16_20_allyears | sdcrime_16_20_nosusp | sdcrime_16_20_uniquecase

ucrcodes

Column NameData TypeDescription
indexinteger
ucr_codestring
descriptionstring

sdcrime_16_20_allyears

Column NameData TypeDescription
pkintegerPk – this is an auto number generated by our SQL database when a new unique record comes into ARJIS. Note: Use this as your unique identifier.
activitynumberstringactivityNumber – the case number for each activity/incident/crime case (these all mean the same thing), this can be used as a unique identifier when combined with the agency name
activitydatedatetimeActivityDate – The date/time the crime case occurred
yearintegerYear of source file
agencystringAgency – the agency reporting the crime case
violationsectionstringViolationSection – the highest charge number recorded on the arrest ( i.e. most serious charge connected to the arrest, arrests may have up to ten charges)
violationtypestringViolationType – the municipal, penal or other code section which is attached to the highest recorded Violation section on the arrest
chargedescriptionstringChargeDescription – A brief text definition of the type of crime type noted in the violation section
chargelevelstringChargeLevel – whether the highest charge is a felony, misdemeanor or infraction (there should only be felonies and misdemeanors in this file)
codeucrstringCodeUCR – a more specific code to define the exact crime type per Uniform Crime Reporting Standards, see defining table on last tab of excel. If you really want to get specific with crime categories this is your tool!
crimecategorystringCrimeCategory – This is the category of the offense type based on the UCR program definitions and corresponds to the categories used on the Crime Statistics portal, with the exception that additional crime categories are included such as arson, simple assault, Part II crimes, and recovered vehicles.
personrolestringPersonRole – the role of the person on this particular record (victim, suspect, victim/witness or blank) please note that the same crime case may have multiple suspects or victims and some crime cases may not have any suspect or victim information listed depending on what the agency provided to ARJIS.
racestringRace – the ethnicity of the person listed in the person role field which can include numerous fields. Note: ARJIS agencies may apply race codes differently across the region.
ageintegerAge – the age of the person listed in the person role field Note: some cases may have no age listed which is a data entry error or unknown by the agency
sexstringSex – the gender of the person listed in the person role field which can include Male, Female, Non-Binary or Unknown. Note: some cases may have no sex listed which is a data entry error or unknown by the agency
zipcodeintegerZipCode – The zip code where the incident/crime case occurred
censusblockstringCensus Block/Tract – the census block/tract where the incident/crime case occurred
censustractstringCensus Block/Tract – the census block/tract where the incident/crime case occurred
citystringCity – The city where the incident/crime case occurred

sdcrime_16_20_nosusp

Column NameData TypeDescription
pkintegerPk – this is an auto number generated by our SQL database when a new unique record comes into ARJIS. Note: Use this as your unique identifier.
activitynumberstringactivityNumber – the case number for each activity/incident/crime case (these all mean the same thing), this can be used as a unique identifier when combined with the agency name
activitydatedatetimeActivityDate – The date/time the crime case occurred
yearintegerYear of source file
agencystringAgency – the agency reporting the crime case
violationsectionstringViolationSection – the highest charge number recorded on the arrest ( i.e. most serious charge connected to the arrest, arrests may have up to ten charges)
violationtypestringViolationType – the municipal, penal or other code section which is attached to the highest recorded Violation section on the arrest
chargedescriptionstringChargeDescription – A brief text definition of the type of crime type noted in the violation section
chargelevelstringChargeLevel – whether the highest charge is a felony, misdemeanor or infraction (there should only be felonies and misdemeanors in this file)
codeucrstringCodeUCR – a more specific code to define the exact crime type per Uniform Crime Reporting Standards, see defining table on last tab of excel. If you really want to get specific with crime categories this is your tool!
crimecategorystringCrimeCategory – This is the category of the offense type based on the UCR program definitions and corresponds to the categories used on the Crime Statistics portal, with the exception that additional crime categories are included such as arson, simple assault, Part II crimes, and recovered vehicles.
personrolestringPersonRole – the role of the person on this particular record (victim, suspect, victim/witness or blank) please note that the same crime case may have multiple suspects or victims and some crime cases may not have any suspect or victim information listed depending on what the agency provided to ARJIS.
racestringRace – the ethnicity of the person listed in the person role field which can include numerous fields. Note: ARJIS agencies may apply race codes differently across the region.
ageintegerAge – the age of the person listed in the person role field Note: some cases may have no age listed which is a data entry error or unknown by the agency
sexstringSex – the gender of the person listed in the person role field which can include Male, Female, Non-Binary or Unknown. Note: some cases may have no sex listed which is a data entry error or unknown by the agency
zipcodeintegerZipCode – The zip code where the incident/crime case occurred
censusblockstringCensus Block/Tract – the census block/tract where the incident/crime case occurred
censustractstringCensus Block/Tract – the census block/tract where the incident/crime case occurred
citystringCity – The city where the incident/crime case occurred

sdcrime_16_20_uniquecase

Column NameData TypeDescription
activitynumberstringactivityNumber – the case number for each activity/incident/crime case (these all mean the same thing), this can be used as a unique identifier when combined with the agency name
activitydatedatetimeActivityDate – The date/time the crime case occurred
yearintegerYear of source file
agencystringAgency – the agency reporting the crime case
violationsectionstringViolationSection – the highest charge number recorded on the arrest ( i.e. most serious charge connected to the arrest, arrests may have up to ten charges)
violationtypestringViolationType – the municipal, penal or other code section which is attached to the highest recorded Violation section on the arrest
chargedescriptionstringChargeDescription – A brief text definition of the type of crime type noted in the violation section
chargelevelstringChargeLevel – whether the highest charge is a felony, misdemeanor or infraction (there should only be felonies and misdemeanors in this file)
codeucrstringCodeUCR – a more specific code to define the exact crime type per Uniform Crime Reporting Standards, see defining table on last tab of excel. If you really want to get specific with crime categories this is your tool!
crimecategorystringCrimeCategory – This is the category of the offense type based on the UCR program definitions and corresponds to the categories used on the Crime Statistics portal, with the exception that additional crime categories are included such as arson, simple assault, Part II crimes, and recovered vehicles.
personrolestringPersonRole – the role of the person on this particular record (victim, suspect, victim/witness or blank) please note that the same crime case may have multiple suspects or victims and some crime cases may not have any suspect or victim information listed depending on what the agency provided to ARJIS.
racestringRace – the ethnicity of the person listed in the person role field which can include numerous fields. Note: ARJIS agencies may apply race codes differently across the region.
ageintegerAge – the age of the person listed in the person role field Note: some cases may have no age listed which is a data entry error or unknown by the agency
sexstringSex – the gender of the person listed in the person role field which can include Male, Female, Non-Binary or Unknown. Note: some cases may have no sex listed which is a data entry error or unknown by the agency
zipcodeintegerZipCode – The zip code where the incident/crime case occurred
censusblockstringCensus Block/Tract – the census block/tract where the incident/crime case occurred
censustractstringCensus Block/Tract – the census block/tract where the incident/crime case occurred
citystringCity – The city where the incident/crime case occurred
citystring

References

Urls used in the creation of this data package.

  • Processed Source Dataset. Source dataset, as received by SDRDL, and processed by Julie Wartell. This is the dataset used to generate this data package
  • Original Source Dataset. Original, unprocessed dataset, ARJIS’ response to the PRA. This dataset is an Excel file with one tab per year.

Packages

Accessing Data in Vanilla Pandas

import pandas as pd


sdcrime_16_20_allyears_df =  pd.read_csv('http://library.metatab.org/arjis.org-crime_victims-pra-1.1.1/data/sdcrime_16_20_allyears.csv')
sdcrime_16_20_nosusp_df =  pd.read_csv('http://library.metatab.org/arjis.org-crime_victims-pra-1.1.1/data/sdcrime_16_20_nosusp.csv')
sdcrime_16_20_uniquecase_df =  pd.read_csv('http://library.metatab.org/arjis.org-crime_victims-pra-1.1.1/data/sdcrime_16_20_uniquecase.csv')
ucrcodes_df =  pd.read_csv('http://library.metatab.org/arjis.org-crime_victims-pra-1.1.1/data/ucrcodes.csv')

Accessing Package in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/arjis.org-crime_victims-pra-1.1.1.csv')

# Create Dataframes
sdcrime_16_20_allyears_df = pkg.resource('sdcrime_16_20_allyears').dataframe()
sdcrime_16_20_nosusp_df = pkg.resource('sdcrime_16_20_nosusp').dataframe()
sdcrime_16_20_uniquecase_df = pkg.resource('sdcrime_16_20_uniquecase').dataframe()
ucrcodes_df = pkg.resource('ucrcodes').dataframe()

1 thought on “San Diego Crime Incidents with Victim Descriptions”

Comments are closed.