Hate Crime Analysis San Diego

Our Project

Hate Crime Analysis in San Diego

In our project, we would like to analyze the Hate Crime Data from San Diego. With this data we can get a better understanding on various aspects of hate crimes within the San Diego region.

The dataset comes from San Diego’s government data and consists of columns such as the time, crime code, block and street, region, weapon, motivation, number of suspects. It also has information regarding the victims which we can analyze to get a better understanding of who has been attacked in the past, the dataset has columns for this such as victim race and victim sex. It also has the same type of information for the suspect as well, which can be used to help analyze what types of people in the past are the perpetrators.

Instance, on the one hand, we would like to examine the data for the frequency and specific types of hate crimes that occur. Furthermore, we want to analyze the data geographically to find out where the dangerous places are in San Diego.

This geographic analysis is especially important to us because we are a team with different cultures and nationalities. Two group members are exchange students and would like to enable other exchange students to see where the most hate crimes are happening. The other two are locals to San Diego and want to gain a better understanding of both the reasons why hate crimes are occurring and if they have been increasing or decreasing over time.

The data analysis will also be valuable for preventative and safety reasons; patterns may be drawn from the analysis that translate to avoidance of certain areas at certain times where there may be especially high rates of dangerous hate crimes.

About us

The Team

Saroop Samra

Big Data Analytics M.Sc. Student at SDSU. Data Science B.Sc. from UCSD

Stefan Helm

Business Informatics B.Sc. Student at the Technical University of Vienna

Nia Fan

Big Data Analytics M.Sc. Student at SDSU. B.A. in Psychology from UCLA

Lukas Schwab

Marketing Intelligence M.Sc. Student at the University of Pforzheim

Our Datasets

Hate Crime Data by FBI CDE

The Hate Crime Statistics dataset provides annual statistics on the number of incidents, offenses, victims, and offenders in reported crimes that are motivated in whole, or in part, by an offender’s bias against the victim’s perceived race, gender, gender identity, religion, disability, sexual orientation, or ethnicity. Hate Crime data are captured by indicating the element of bias present in offenses already being reported to the UCR Program.

Race And Ethnicity by U.S. Census Bureau

The race and ethnicity data is collected annually by the U.S. Census Bureau in cooperation with the Population Estimates Program (PEP). It reports the total amount of people with a specific ethnicity or race. They differentiate the following races: White, Asian, Black or African American, Multiple, American Indian or Alaska Native, Other. The racial categories included in the census questionnaire generally reflect a social definition of race recognized in this country and not an attempt to define race biologically, anthropologically, or genetically.

Hate Crime Data by DataSD

The Hate Crime Statistics dataset consists of columns such as the time, crime code, block and street, region, weapon, motivation, number of suspects. It also has information regarding the victims which we can analyze to get a better understanding of who has been attacked in the past, the dataset has columns for this such as victim race and victim sex. It also has the same type of information for the suspect as well, which can be used to help analyze what types of people in the past are the perpetrators. The data is from the years 2016 to 2021.

ZIP Code Geodata by SD County

This dataset provides information about the different zip codes that exist in San Diego County. The Zip Code dataset consists of columns such as zip, the geom, community and shape style.

Hate Crime Analysis in San Diego County