This dataset reflects reported incidents of crime that have occurred in the City of Chicago over the past year, minus the most recent seven days of data. Data is extracted from the Chicago Police Department's CLEAR (Citizen Law Enforcement Analysis and Reporting) system. In order to protect the privacy of crime victims, addresses are shown at the block level only and specific locations are not identified. Should you have questions about this dataset, you may contact the Research & Development Division of the Chicago Police Department at 312.745.6071 or RandD@chicagopolice.org. Disclaimer: These crimes may be based upon preliminary information supplied to the Police Department by the reporting parties that have not been verified. The preliminary crime classifications may be changed at a later date based upon additional investigation and there is always the possibility of mechanical or human error. Therefore, the Chicago Police Department does not guarantee (either expressed or implied) the accuracy, completeness, timeliness, or correct sequencing of the information and the information should not be used for comparison purposes over time. The Chicago Police Department will not be responsible for any error or omission, or for the use of, or the results obtained from the use of this information. All data visualizations on maps should be considered approximate and attempts to derive specific addresses are strictly prohibited.

The Chicago Police Department is not responsible for the content of any off-site pages that are referenced by or that reference this web page other than an official City of Chicago or Chicago Police Department web page. The user specifically acknowledges that the Chicago Police Department is not responsible for any defamatory, offensive, misleading, or illegal conduct of other users, links, or third parties and that the risk of injury from the foregoing rests entirely with the user. Any use of the information for commercial purposes is strictly prohibited. The unauthorized use of the words "Chicago Police Department," "Chicago Police," or any colorable imitation of these words or the unauthorized use of the Chicago Police Department logo is unlawful. This web page does not, in any way, authorize such use. Data is updated daily.

This dataset reflects reported incidents of crime (with the exception of murders where data exists for each victim) that have occurred in the City of Chicago over the past year, minus the most recent seven days of data. Data is extracted from the Chicago Police Department's CLEAR (Citizen Law Enforcement Analysis and Reporting) system. In order to protect the privacy of crime victims, addresses are shown at the block level only and specific locations are not identified. Should you have questions about this dataset, you may contact the Research & Development Division of the Chicago Police Department at 312.745.6071 or RandD@chicagopolice.org. Disclaimer: These crimes may be based upon preliminary information supplied to the Police Department by the reporting parties that have not been verified. The preliminary crime classifications may be changed at a later date based upon additional investigation and there is always the possibility of mechanical or human error. Therefore, the Chicago Police Department does not guarantee (either expressed or implied) the accuracy, completeness, timeliness, or correct sequencing of the information and the information should not be used for comparison purposes over time. The Chicago Police Department will not be responsible for any error or omission, or for the use of, or the results obtained from the use of this information. All data visualizations on maps should be considered approximate and attempts to derive specific addresses are strictly prohibited. The Chicago Police Department is not responsible for the content of any off-site pages that are referenced by or that reference this web page other than an official City of Chicago or Chicago Police Department web page. The user specifically acknowledges that the Chicago Police Department is not responsible for any defamatory, offensive, misleading, or illegal conduct of other users, links, or third parties and that the risk of injury from the foregoing rests entirely with the user. The unauthorized use of the words "Chicago Police Department," "Chicago Police," or any colorable imitation of these words or the unauthorized use of the Chicago Police Department logo is unlawful. This web page does not, in any way, authorize such use. Data is updated daily Tuesday through Sunday. The dataset contains more than 65,000 records/rows of data and cannot be viewed in full in Microsoft Excel. Therefore, when downloading the file, select CSV from the Export menu. Open the file in an ASCII text editor, such as Wordpad, to view and search. To access a list of Chicago Police Department - Illinois Uniform Crime Reporting (IUCR) codes, go to http://bit.ly/rk5Tpc.

This dataset reflects reported incidents of crime (with the exception of murders where data exists for each victim) that occurred in the City of Chicago from 2001 to present, minus the most recent seven days. Data is extracted from the Chicago Police Department's CLEAR (Citizen Law Enforcement Analysis and Reporting) system. In order to protect the privacy of crime victims, addresses are shown at the block level only and specific locations are not identified. Should you have questions about this dataset, you may contact the Research & Development Division of the Chicago Police Department at 312.745.6071 or RandD@chicagopolice.org. Disclaimer: These crimes may be based upon preliminary information supplied to the Police Department by the reporting parties that have not been verified. The preliminary crime classifications may be changed at a later date based upon additional investigation and there is always the possibility of mechanical or human error. Therefore, the Chicago Police Department does not guarantee (either expressed or implied) the accuracy, completeness, timeliness, or correct sequencing of the information and the information should not be used for comparison purposes over time. The Chicago Police Department will not be responsible for any error or omission, or for the use of, or the results obtained from the use of this information. All data visualizations on maps should be considered approximate and attempts to derive specific addresses are strictly prohibited. The Chicago Police Department is not responsible for the content of any off-site pages that are referenced by or that reference this web page other than an official City of Chicago or Chicago Police Department web page. The user specifically acknowledges that the Chicago Police Department is not responsible for any defamatory, offensive, misleading, or illegal conduct of other users, links, or third parties and that the risk of injury from the foregoing rests entirely with the user. The unauthorized use of the words "Chicago Police Department," "Chicago Police," or any colorable imitation of these words or the unauthorized use of the Chicago Police Department logo is unlawful. This web page does not, in any way, authorize such use. Data is updated daily Tuesday through Sunday. The dataset contains more than 65,000 records/rows of data and cannot be viewed in full in Microsoft Excel. Therefore, when downloading the file, select CSV from the Export menu. Open the file in an ASCII text editor, such as Wordpad, to view and search. To access a list of Chicago Police Department - Illinois Uniform Crime Reporting (IUCR) codes, go to http://data.cityofchicago.org/Public-Safety/Chicago-Police-Department-Illinois-Uniform-Crime-R/c7ck-438e

Records from the Crimes - 2001 to Present dataset for the indicated year.

Please see the description section of the full dataset for further information about the data.

This study explores the relationship between crime and neighborhood deterioration in eight neighborhoods in Chicago. The neighborhoods were selected on the basis of slowly or rapidly appreciating real estate values, stable or changing racial composition, and high or low crime rates. These data provide the results of a telephone survey administered to approximately 400 heads of households in each study neighborhood, a total of 3,310 completed interviews. The survey was designed to measure victimization experience, fear and perceptions of crime, protective measures taken, attitudes toward neighborhood quality and resources, attitudes toward the neighborhood as an investment, and density of community involvement. Each record includes appearance ratings for the block of the respondent's residence and aggregate figures on personal and property victimization for that city block. The aggregate appearance ratings were compiled from windshield surveys taken by trained personnel of the National Opinion Research Center. The criminal victimization figures came from Chicago City Police files.

Prelude

This dataset is a cleaned version of the Chicago Crime Dataset, which can be found here. All rights for the dataset go to the original owners. The purpose of this dataset is to display my skills in visualizations and creating dashboards. To be specific, I will attempt to create a dashboard that will allow users to see metrics for a specific crime within a given year using filters and metrics. Due to this, there will not be much of a focus on the analysis of the data, but there will be portions discussing the validity of the dataset, the steps I took to clean the data, and how I organized it. The cleaned datasets can be found below, the Query (which utilized BigQuery) can be found here and the Tableau dashboard can be found here.

About the Dataset

Important Facts

The dataset comes directly from the City of Chicago's website under the page "City Data Catalog." The data is gathered directly from the Chicago Police's CLEAR (Citizen Law Enforcement Analysis and Reporting) and is updated daily to present the information accurately. This means that a crime on a specific date may be changed to better display the case. The dataset represents crimes starting all the way from 2001 to seven days prior to today's date.

Reliability

Using the ROCCC method, we can see that: * The data has high reliability: The data covers the entirety of Chicago from a little over 2 decades. It covers all the wards within Chicago and even gives the street names. While we may not have an idea for how big the sample size is, I do believe that the dataset has high reliability since it geographically covers the entirety of Chicago. * The data has high originality: The dataset was gained directly from the Chicago Police Dept. using their database, so we can say this dataset is original. * The data is somewhat comprehensive: While we do have important information such as the types of crimes committed and their geographic location, I do not think this gives us proper insights as to why these crimes take place. We can pinpoint the location of the crime, but we are limited by the information we have. How hot was the day of the crime? Did the crime take place in a neighborhood with low-income? I believe that these key factors prevent us from getting proper insights as to why these crimes take place, so I would say that this dataset is subpar with how comprehensive it is. * The data is current: The dataset is updated frequently to display crimes that took place seven days prior to today's date and may even update past crimes as more information comes to light. Due to the frequent updates, I do believe the data is current. * The data is cited: As mentioned prior, the data is collected directly from the polices CLEAR system, so we can say that the data is cited.

Processing the Data

Cleaning the Dataset

The purpose of this step is to clean the dataset such that there are no outliers in the dashboard. To do this, we are going to do the following: * Check for any null values and determine whether we should remove them. * Update any values where there may be typos. * Check for outliers and determine if we should remove them.

The following steps will be explained in the code segments below. (I used BigQuery for this so the coding will follow BigQuery's syntax) ```

Examining the dataset

There are over 7.5 million rows of data

Putting a limit so it does not take a long time to run

SELECT * FROM portfolioproject-350601.ChicagoCrime.Crime LIMIT 1000;

Seeing which points are null

There are 85,000 null points so we can exclude them as it's not a significant amount since it is only ~1.3% of the dataset

Most of the null points are in the lat and long, which we will need later

Because we don't have the full address, we can't estimate the lat and long in SQL so we will have to delete the rows with Null Data

SELECT * FROM portfolioproject-350601.ChicagoCrime.Crime WHERE unique_key IS NULL OR case_number IS NULL OR date IS NULL OR primary_type IS NULL OR location_description IS NULL OR arrest IS NULL OR longitude IS NULL OR latitude IS NULL;

Deleting all null rows

DELETE FROM portfolioproject-350601.ChicagoCrime.Crime WHERE
unique_key IS NULL OR case_number IS NULL OR date IS NULL OR primary_type IS NULL OR location_description IS NULL OR arrest IS NULL OR longitude IS NULL OR latitude IS NULL;

Checking for any duplicates in the unique keys

None to be found

SELECT unique_key, COUNT(unique_key) FROM `portfolioproject-350601.ChicagoCrime....

Two previously released data collections from ICPSR are combined in this dataset: CHARACTERISTICS OF HIGH AND LOW CRIME NEIGHBORHOODS IN ATLANTA, 1980 (ICPSR 7951) and CRIME FACTORS AND NEIGHBORHOOD DECLINE IN CHICAGO, 1979 (ICPSR 7952). Information for ICPSR 7951 was obtained from 523 residents interviewed in six selected neighborhoods in Atlanta, Georgia. A research team from the Research Triangle Institute sampled and surveyed the residents. ICPSR 7952 contains 3,310 interviews of Chicago residents in eight selected neighborhoods. The combined data collection contains variables on topics such as residents' demographics and socioeconomic status, personal crime rates, property crime rates, neighborhood crime rates, and neighborhood characteristics. The documentation contains three pieces of information for each variable: variable reference numbers for both the Atlanta and Chicago datasets, the complete wording of the questions put to the respondents of each survey, and the exact wording of the coding schemes adopted by the researchers.

This dataset contains different collected datasets with crime data of many large cities. Below are the descriptions for each seperate dataset. Note: Dataset properties and column may differ from each other since the information was collected by the local police in different styles and situations.

1. Los Angeles

The Los Angeles dataset has the collected data on different crimes that happened in Los Angeles from 2000 up until May 2024. The columns are as follows:

• DR_NO - Division of Records Number: Official file number made up of a 2 digit year, area ID, and 5 digits

• Date Rptd - The date when the police found out about the crime

• Date OCC - The actual date of the crime

• Time OCC - In military time

• Area - The LAPD has 21 Community Police Stations referred to as Geographic Areas within the department. These Geographic Areas are sequentially numbered from 1-21.

• Area Name - The 21 Geographic Areas or Patrol Divisions are also given a name designation that references a landmark or the surrounding community that it is responsible for. For example 77th Street Division is located at the intersection of South Broadway and 77th Street, serving neighborhoods in South Los Angeles.

• Rpt Dist No - A four-digit code that represents a sub-area within a Geographic Area. All crime records reference the "RD" that it occurred in for statistical comparisons. Find LAPD Reporting Districts on the LA City GeoHub at http://geohub.lacity.org/datasets/c4f83909b81d4786aa8ba8a74a4b4db1_4

• Crm Cd - Indicates the crime committed. (Same as Crime Code 1)

• Crm Cd Desc - Defines the Crime Code provided.

• Mocodes - Modus Operandi: Activities associated with the suspect in commission of the crime.

• Vict Age - The age of the victim

• Vict Sex - The gender of the victim. They are as follows:

  • M - Male
  • F - Female
  • X - Unknown

• Vict Descent - Descent Code:

  • A - Other Asian
  • B - Black
  • C - Chinese
  • D - Cambodian
  • F - Filipino
  • G - Guamanian
  • H - Hispanic/Latin/Mexican
  • I - American Indian/Alaskan Native
  • J - Japanese
  • K - Korean
  • L - Laotian
  • O - Other
  • P - Pacific Islander
  • S - Samoan
  • U - Hawaiian
  • V - Vietnamese
  • W - White
  • X - Unknown
  • Z - Asian Indian

• Premis Cd - The type of structure, vehicle, or location where the crime took place.

• Premis Desc - Defines the Premise Code provided.

• Weapon Used Cd - The type of weapon used in the crime.

• Status - Status of the case. (IC is the default)

• Status Desc - Defines the Status Code provided.

• Crm Cd 1 - Indicates the crime committed. Crime Code 1 is the primary and most serious one. Crime Code 2, 3, and 4 are respectively less serious offenses. Lower crime class numbers are more serious.

• Crm Cd 2 - May contain a code for an additional crime, less serious than Crime Code 1.

• Crm Cd 3 - May contain a code for an additional crime, less serious than Crime Code 1.

• Crm Cd 4 - May contain a code for an additional crime, less serious than Crime Code 1.

• Location - Street address of crime incident rounded to the nearest hundred block to maintain anonymity.

• Cross Street - Cross Street of rounded Address

• LAT - Latitude

• LON - Longitude

This dataset has 28 columns and 944K rows. I hope you will find it useful. God bless you

1. Chicago

This dataset contains crime data on Chicago, from 2001 to present. The columns are as follows:

• ID - Unique Identifier for the record

• Case Number - The Chicago Police Department RD Number (Records Division Number), which is unique to the incident.

• Date - Date when the incident occurred. this is sometimes a best estimate.

• Block - The partially redacted address where the incident occurred, placing it on the same block as the actual address.

• IUCR - The Illinois Unifrom Crime Reporting code. This is directly linked to the Primary Type and Description. See the list of IUCR codes at https://data.cityofchicago.org/d/c7ck-438e..

• Primary Type - The primary description of the IUCR code.

• Description - The secondary description of the IUCR code, a subcategory of the primary description.

• Location Description - Description of the location where the incident occurred.

• Arrest - Indicates whether an arrest was made.

• Domestic - Indicates whether the incident was domestic-related as defined by the Illinois Domestic Violence Act.

• Beat - Indicates the beat where the incident occurred. A beat is the smallest police geographic area – each beat has a dedicated police beat car. Three to five beats make up a police sector, and three sectors make up a police district. The Chicago Police Department has 22 police districts. See the beats at https://data.cityofchicago.org/d/aerh-rz74.

• Distric...

This dataset reflects reported incidents of crime (with the exception of murders where data exists for each victim) that have occurred in the City of Chicago over the past year, minus the most recent seven days of data. Data is extracted from the Chicago Police Department's CLEAR (Citizen Law Enforcement Analysis and Reporting) system. In order to protect the privacy of crime victims, addresses are shown at the block level only and specific locations are not identified. Should you have questions about this dataset, you may contact the Research & Development Division of the Chicago Police Department at 312.745.6071 or RandD@chicagopolice.org. Disclaimer: These crimes may be based upon preliminary information supplied to the Police Department by the reporting parties that have not been verified. The preliminary crime classifications may be changed at a later date based upon additional investigation and there is always the possibility of mechanical or human error. Therefore, the Chicago Police Department does not guarantee (either expressed or implied) the accuracy, completeness, timeliness, or correct sequencing of the information and the information should not be used for comparison purposes over time. The Chicago Police Department will not be responsible for any error or omission, or for the use of, or the results obtained from the use of this information. All data visualizations on maps should be considered approximate and attempts to derive specific addresses are strictly prohibited.

The Chicago Police Department is not responsible for the content of any off-site pages that are referenced by or that reference this web page other than an official City of Chicago or Chicago Police Department web page. The user specifically acknowledges that the Chicago Police Department is not responsible for any defamatory, offensive, misleading, or illegal conduct of other users, links, or third parties and that the risk of injury from the foregoing rests entirely with the user. The unauthorized use of the words "Chicago Police Department," "Chicago Police," or any colorable imitation of these words or the unauthorized use of the Chicago Police Department logo is unlawful. This web page does not, in any way, authorize such use. Data is updated daily Tuesday through Sunday. The dataset contains more than 65,000 records/rows of data and cannot be viewed in full in Microsoft Excel. Therefore, when downloading the file, select CSV from the Export menu. Open the file in an ASCII text editor, such as Wordpad, to view and search. To access a list of Chicago Police Department - Illinois Uniform Crime Reporting (IUCR) codes, go to http://bit.ly/rk5Tpc.

This dataset contains detailed records of reported crimes in the City of Chicago. The data includes attributes such as the date and time of the incident, the type of crime, location description, arrest status, and more.

🔹 Source: This dataset is sourced from the City of Chicago Official Crime Data Portal: https://data.cityofchicago.org The data is made publicly available by the City of Chicago for research, analysis, and educational purposes.

🔹 Purpose of Upload: I am uploading this dataset for practice purposes related to data analysis, visualization, and future machine learning projects. This dataset is commonly used to explore trends in urban crime, identify hotspots, and understand the distribution of different types of offenses over time.

Columns (Example Structure): ID

Case Number

Date

Block

IUCR

Primary Type (Crime Type)

Description

Location Description

Arrest (True/False)

Domestic (True/False)

Beat

District

Ward

Community Area

FBI Code

X Coordinate

Y Coordinate

Year

Updated On

Latitude

Longitude

Acknowledgment: All credit for data collection and maintenance goes to the City of Chicago. I do not claim ownership of this data.

In 2023, around 3,640.56 violent crimes per 100,000 residents were reported in Oakland, California. This made Oakland the most dangerous city in the United States in that year. Four categories of violent crimes were used: murder and non-negligent manslaughter; forcible rape; robbery; and aggravated assault. Only cities with a population of at least 200,000 were considered.

This dataset reflects reported incidents of crime (with the exception of murders where data exists for each victim) that occurred in the City of Chicago from 2001 to present, minus the most recent seven days. Data is extracted from the Chicago Police Department's CLEAR (Citizen Law Enforcement Analysis and Reporting) system. In order to protect the privacy of crime victims, addresses are shown at the block level only and specific locations are not identified. Should you have questions about this dataset, you may contact the Research & Development Division of the Chicago Police Department at 312.745.6071 or RandD@chicagopolice.org. Disclaimer: These crimes may be based upon preliminary information supplied to the Police Department by the reporting parties that have not been verified. The preliminary crime classifications may be changed at a later date based upon additional investigation and there is always the possibility of mechanical or human error. Therefore, the Chicago Police Department does not guarantee (either expressed or implied) the accuracy, completeness, timeliness, or correct sequencing of the information and the information should not be used for comparison purposes over time. The Chicago Police Department will not be responsible for any error or omission, or for the use of, or the results obtained from the use of this information. All data visualizations on maps should be considered approximate and attempts to derive specific addresses are strictly prohibited. The Chicago Police Department is not responsible for the content of any off-site pages that are referenced by or that reference this web page other than an official City of Chicago or Chicago Police Department web page. The user specifically acknowledges that the Chicago Police Department is not responsible for any defamatory, offensive, misleading, or illegal conduct of other users, links, or third parties and that the risk of injury from the foregoing rests entirely with the user. The unauthorized use of the words "Chicago Police Department," "Chicago Police," or any colorable imitation of these words or the unauthorized use of the Chicago Police Department logo is unlawful. This web page does not, in any way, authorize such use. Data is updated daily Tuesday through Sunday. The dataset contains more than 65,000 records/rows of data and cannot be viewed in full in Microsoft Excel. Therefore, when downloading the file, select CSV from the Export menu. Open the file in an ASCII text editor, such as Wordpad, to view and search. To access a list of Chicago Police Department - Illinois Uniform Crime Reporting (IUCR) codes, go to http://data.cityofchicago.org/Public-Safety/Chicago-Police-Department-Illinois-Uniform-Crime-R/c7ck-438e

In 2023, the violent crime rate in the United States was 363.8 cases per 100,000 of the population. Even though the violent crime rate has been decreasing since 1990, the United States tops the ranking of countries with the most prisoners. In addition, due to the FBI's transition to a new crime reporting system in which law enforcement agencies voluntarily submit crime reports, data may not accurately reflect the total number of crimes committed in recent years. Reported violent crime rate in the United States The United States Federal Bureau of Investigation tracks the rate of reported violent crimes per 100,000 U.S. inhabitants. In the timeline above, rates are shown starting in 1990. The rate of reported violent crime has fallen since a high of 758.20 reported crimes in 1991 to a low of 363.6 reported violent crimes in 2014. In 2023, there were around 1.22 million violent crimes reported to the FBI in the United States. This number can be compared to the total number of property crimes, roughly 6.41 million that year. Of violent crimes in 2023, aggravated assaults were the most common offenses in the United States, while homicide offenses were the least common. Law enforcement officers and crime clearance Though the violent crime rate was down in 2013, the number of law enforcement officers also fell. Between 2005 and 2009, the number of law enforcement officers in the United States rose from around 673,100 to 708,800. However, since 2009, the number of officers fell to a low of 626,900 officers in 2013. The number of law enforcement officers has since grown, reaching 720,652 in 2023. In 2023, the crime clearance rate in the U.S. was highest for murder and non-negligent manslaughter charges, with around 57.8 percent of murders being solved by investigators and a suspect being charged with the crime. Additionally, roughly 46.1 percent of aggravated assaults were cleared in that year. A statistics report on violent crime in the U.S. can be found here.

This dataset shows reported crimes that happened in the City of Chicago from 2001 to the present, excluding the most recent seven days, with the exception of murders, for which data is available for each victim. Data is taken from the CLEAR (Citizen Law Enforcement Analysis and Reporting) system of the Chicago Police Department. Addresses are only displayed at the block level and exact locations are not specified to preserve the anonymity of crime victims. This information includes reports that were given to the Police Department but were not validated. There is always a chance of human or technological error, and the initial categories of crimes could alter later based on further research. Therefore, the Chicago Police Department does not guarantee (either expressed or implied) the accuracy, completeness, timeliness, or correct sequencing of the information and the information should not be used for comparison purposes over time.

This dataset contains aggregate data on violent index victimizations at the quarter level of each year (i.e., January – March, April – June, July – September, October – December), from 2001 to the present (1991 to present for Homicides), with a focus on those related to gun violence. Index crimes are 10 crime types selected by the FBI (codes 1-4) for special focus due to their seriousness and frequency. This dataset includes only those index crimes that involve bodily harm or the threat of bodily harm and are reported to the Chicago Police Department (CPD). Each row is aggregated up to victimization type, age group, sex, race, and whether the victimization was domestic-related. Aggregating at the quarter level provides large enough blocks of incidents to protect anonymity while allowing the end user to observe inter-year and intra-year variation. Any row where there were fewer than three incidents during a given quarter has been deleted to help prevent re-identification of victims. For example, if there were three domestic criminal sexual assaults during January to March 2020, all victims associated with those incidents have been removed from this dataset. Human trafficking victimizations have been aggregated separately due to the extremely small number of victimizations.

This dataset includes a " GUNSHOT_INJURY_I " column to indicate whether the victimization involved a shooting, showing either Yes ("Y"), No ("N"), or Unknown ("UKNOWN.") For homicides, injury descriptions are available dating back to 1991, so the "shooting" column will read either "Y" or "N" to indicate whether the homicide was a fatal shooting or not. For non-fatal shootings, data is only available as of 2010. As a result, for any non-fatal shootings that occurred from 2010 to the present, the shooting column will read as “Y.” Non-fatal shooting victims will not be included in this dataset prior to 2010; they will be included in the authorized dataset, but with "UNKNOWN" in the shooting column.

The dataset is refreshed daily, but excludes the most recent complete day to allow CPD time to gather the best available information. Each time the dataset is refreshed, records can change as CPD learns more about each victimization, especially those victimizations that are most recent. The data on the Mayor's Office Violence Reduction Dashboard is updated daily with an approximately 48-hour lag. As cases are passed from the initial reporting officer to the investigating detectives, some recorded data about incidents and victimizations may change once additional information arises. Regularly updated datasets on the City's public portal may change to reflect new or corrected information.

How does this dataset classify victims?

The methodology by which this dataset classifies victims of violent crime differs by victimization type:

Homicide and non-fatal shooting victims: A victimization is considered a homicide victimization or non-fatal shooting victimization depending on its presence in CPD's homicide victims data table or its shooting victims data table. A victimization is considered a homicide only if it is present in CPD's homicide data table, while a victimization is considered a non-fatal shooting only if it is present in CPD's shooting data tables and absent from CPD's homicide data table.

To determine the IUCR code of homicide and non-fatal shooting victimizations, we defer to the incident IUCR code available in CPD's Crimes, 2001-present dataset (available on the City's open data portal). If the IUCR code in CPD's Crimes dataset is inconsistent with the homicide/non-fatal shooting categorization, we defer to CPD's Victims dataset.

For a criminal homicide, the only sensible IUCR codes are 0110 (first-degree murder) or 0130 (second-degree murder). For a non-fatal shooting, a sensible IUCR code must signify a criminal sexual assault, a robbery, or, most commonly, an aggravated battery. In rare instances, the IUCR code in CPD's Crimes and Victims dataset do not align with the homicide/non-fatal shooting categorization:

1. In instances where a homicide victimization does not correspond to an IUCR code 0110 or 0130, we set the IUCR code to "01XX" to indicate that the victimization was a homicide but we do not know whether it was a first-degree murder (IUCR code = 0110) or a second-degree murder (IUCR code = 0130).
2. When a non-fatal shooting victimization does not correspond to an IUCR code that signifies a criminal sexual assault, robbery, or aggravated battery, we enter “UNK” in the IUCR column, “YES” in the GUNSHOT_I column, and “NON-FATAL” in the PRIMARY column to indicate that the victim was non-fatally shot, but the precise IUCR code is unknown.

Other violent crime victims: For other violent crime types, we refer to the IUCR classification that exists in CPD's victim table, with only one exception:

1. When there is an incident that is associated with no victim with a matching IUCR code, we assume that this is an error. Every crime should have at least 1 victim with a matching IUCR code. In these cases, we change the IUCR code to reflect the incident IUCR code because CPD's incident table is considered to be more reliable than the victim table.

Note: All businesses identified as victims in CPD data have been removed from this dataset.

Note: The definition of “homicide” (shooting or otherwise) does not include justifiable homicide or involuntary manslaughter. This dataset also excludes any cases that CPD considers to be “unfounded” or “noncriminal.”

Note: In some instances, the police department's raw incident-level data and victim-level data that were inputs into this dataset do not align on the type of crime that occurred. In those instances, this dataset attempts to correct mismatches between incident and victim specific crime types. When it is not possible to determine which victims are associated with the most recent crime determination, the dataset will show empty cells in the respective demographic fields (age, sex, race, etc.).

Note: The initial reporting officer usually asks victims to report demographic data. If victims are unable to recall, the reporting officer will use their best judgment. “Unknown” can be reported if it is truly unknown.

The purpose of the study was to examine homicide trends in Chicago neighborhoods from 1980-2000 using HOMICIDES IN CHICAGO, 1965-1995 (ICPSR 6399), 1980-2000 Census data, and PROJECT ON HUMAN DEVELOPMENT IN CHICAGO NEIGHBORHOODS: COMMUNITY SURVEY, 1994-1995 (ICPSR 2766). Drawing on the social disorganization and concentrated disadvantage literature, this study used growth-curve modeling and semi-parametric group-based trajectory modeling to: (1) assess neighborhood variation in homicide trends; (2) identify the particular types of homicide trajectory that Chicago neighborhoods follow; (3) assess whether structural characteristics of neighborhoods influence homicide trends and trajectories; and (4) determine the extent to which the influence of structural characteristics is mediated by neighborhood levels of collective efficacy. This project extended prior research by not only describing the homicide trends and trajectories of Chicago neighborhoods, but also identifying the neighborhood characteristics that directly and indirectly influence those trends.

In 2022, the New Orleans-Metairie, LA metro area recorded the highest homicide rate of U.S. cities with a population over 250,000, at **** homicides per 100,000 residents, followed by the Memphis, TN-MS-AR metro area. However, homicide data was not recorded in all U.S. metro areas, meaning that there may be some cities with a higher homicide rate. St. Louis St. Louis, which had a murder and nonnegligent manslaughter rate of **** in 2022, is the second-largest city by population in Missouri. It is home to many famous treasures, such as the St. Louis Cardinals baseball team, Washington University in St. Louis, the Saint Louis Zoo, and the renowned Gateway Arch. It is also home to many corporations, such as Monsanto, Arch Coal, and Emerson Electric. The economy of St. Louis is centered around business and healthcare, and boasts ten Fortune 500 companies. Crime in St. Louis Despite all of this, St. Louis suffers from high levels of crime and violence. As of 2023, it was listed as the seventh most dangerous city in the world as a result of their extremely high murder rate. Not only does St. Louis have one of the highest homicide rates in the United States, it also reports one of the highest numbers of violent crimes. Despite high crime levels, the GDP of the St. Louis metropolitan area has been increasing since 2001.

This study sought to answer the question: If a woman is experiencing intimate partner violence, does the collective efficacy and community capacity of her neighborhood facilitate or erect barriers to her ability to escape violence, other things being equal? To address this question, longitudinal data on a sample of 210 abused women from the CHICAGO WOMEN'S HEALTH RISK STUDY, 1995-1998 (ICPSR 3002) were combined with community context data for each woman's residential neighborhood taken from the Chicago Alternative Policing Strategy (CAPS) evaluation, LONGITUDINAL EVALUATION OF CHICAGO'S COMMUNITY POLICING PROGRAM, 1993-2000 (ICPSR 3335). The unit of analysis for the study is the individual abused woman (not the neighborhood). The study takes the point of view of a woman standing at a street address and looking around her. The characteristics of the small geographical area immediately surrounding her residential address form the community context for that woman. Researchers chose the police beat as the best definition of a woman's neighborhood, because it is the smallest Chicago area for which reliable and complete data are available. The characteristics of the woman's police beat then became the community context for each woman. The beat, district, and community area of the woman's address are present. Neighborhood-level variables include voter turnout percentage, organizational involvement, percentage of households on public aid, percentage of housing that was vacant, percentage of housing units owned, percentage of feminine poverty households, assault rate, and drug crime rate. Individual-level demographic variables include the race, ethnicity, age, marital status, income, and level of education of the woman and the abuser. Other individual-level variables include the Social Support Network (SSN) scale, language the interview was conducted in, Harass score, Power and Control score, Post-Traumatic Stress Disorder (PTSD) diagnosis, other data pertaining to the respondent's emotional and physical health, and changes over the past year. Also included are details about the woman's household, such as whether she was homeless, the number of people living in the household and details about each person, the number of her children or other children in the household, details of any of her children not living in her household, and any changes in the household structure over the past year. Help-seeking in the past year includes whether the woman had sought medical care, had contacted the police, or had sought help from an agency or counselor, and whether she had an order of protection. Several variables reflect whether the woman left or tried to leave the relationship in the past year. Finally, the dataset includes summary variables about violent incidents in the past year (severity, recency, and frequency), and in the follow-up period.

A number of studies have explored the relationship between public housing policy, poverty, and crime. This Commentary discusses the results of a recent study, which investigated the effects of closing large public housing developments on crime. To see if the demolitions—and the associated deconcentration of poverty—reduced crime or merely displaced it, researchers examined the case of Chicago. They found that closing large public housing developments and dispersing former residents throughout a wider portion of the city was associated with net reductions in violent crime, at the city level.

This StoryMap is designed to help teachers guide students through applying spatial analysis to prepare a report for the City of Chicago Mayor that: shows and explains the changing patterns, both spatial and temporal (over time), of the homicide rate in Chicago provides an analysis of whether the location of police stations and police beats appear to be having an effect on homicide rates recommends solutions related to urban development which could address the problem. Students have their own assessment materials to work through, you should not give them access to this Story Map. Click the link below to open the student assessment materials.Student Materials