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.

In 2023, the District of Columbia had the highest reported violent crime rate in the United States, with 1,150.9 violent crimes per 100,000 of the population. Maine had the lowest reported violent crime rate, with 102.5 offenses per 100,000 of the population. Life in the District The District of Columbia has seen a fluctuating population over the past few decades. Its population decreased throughout the 1990s, when its crime rate was at its peak, but has been steadily recovering since then. While unemployment in the District has also been falling, it still has had a high poverty rate in recent years. The gentrification of certain areas within Washington, D.C. over the past few years has made the contrast between rich and poor even greater and is also pushing crime out into the Maryland and Virginia suburbs around the District. Law enforcement in the U.S. Crime in the U.S. is trending downwards compared to years past, despite Americans feeling that crime is a problem in their country. In addition, the number of full-time law enforcement officers in the U.S. has increased recently, who, in keeping with the lower rate of crime, have also made fewer arrests than in years past.

The following datasets contain the crime rate for cities in the United States. The four datasets are separated based on population ranges.

FILE DESCRIPTION

File names: - 'crime_40 _60.csv': dataset for population ranging from 40,000 to 60,000. - 'crime_60 _100.csv': dataset for population ranging from 60,000 to 100,000. - 'crime_100 _250.csv': dataset for population ranging from 100,000 to 250,000. - 'crime_250 _plus.csv': dataset for population greater than 250,000.

COLUMN DESCRIPTION

For file: crime_40 _60.csv: - 'states': name of the state - 'cities': name of the city - 'population': population of the city - 'violent_crime': violent crime - 'murder': murder and nonnegligent manslaughter - 'rape': forcible rape - 'robbery': robbery - 'agrv_ The following datasets contain the crime rate for cities in the United States. The four datasets are separated based on population ranges.

FILE DESCRIPTION

File names: - 'crime_40 _60.csv': dataset for population ranging from 40,000 to 60,000. - 'crime_60 _100.csv': dataset for population ranging from 60,000 to 100,000. - 'crime_100 _250.csv': dataset for population ranging from 100,000 to 250,000. - 'crime_250 _plus.csv': dataset for population greater than 250,000.

COLUMN DESCRIPTION

For file: crime_40 _60.csv: - 'states': name of the state - 'cities': name of the city - 'population': population of the city - 'violent_crime': violent crime - 'murder': murder and nonnegligent manslaughter - 'rape': forcible rape - 'robbery': robbery - 'agrv_ assault': agrv_ assault - 'prop_crime': property crime - 'burglary': burglary - 'larceny': larceny theft - 'vehicle_theft': motor vehicle theft

crime_60 _100.csv: - 'states': name of the state - 'cities': name of the city - 'population': population of the city - 'violent_crime': violent crime - 'murder': murder and nonnegligent manslaughter - 'rape': forcible rape - 'robbery': robbery - 'agrv_ assault': agrv_ assault - 'prop_crime': property crime - 'burglary': burglary - 'larceny': larceny theft - 'vehicle_theft': motor vehicle theft

crime_100 _250.csv: - 'states': name of the state - 'cities': name of the city - 'population': population of the city - 'violent_crime': violent crime - 'murder': murder and nonnegligent manslaughter - 'rape': forcible rape - 'robbery': robbery - 'agrv_ assault': agrv_ assault - 'prop_crime': property crime - 'burglary': burglary - 'larceny': larceny theft - 'vehicle_theft': motor vehicle theft

crime_250 _plus.csv: - 'states': name of the state - 'cities': name of the city - 'population': population of the city - 'total_crime': total crime - 'murder': murder and nonnegligent manslaughter - 'rape': forcible rape - 'robbery': robbery - 'agrv_ assault': agrv_ assault - 'total_violent _crime': total violent crime - 'prop_crime': property crime - 'burglary': burglary - 'larceny': larceny theft - 'vehicle_theft': motor vehicle theft - 'tot_prop _crime': total property crime - 'arson': arson

Photo by David von Diemar on Unsplash

In 2023, an estimated 1,21,467 violent crimes occurred in the United States. This is a decrease from the year before, when 1,256,671 violent crimes were reported. Violent crime in the United States The Federal Bureau of Investigation reported that violent crime fell nationwide in the period from 1990 to 2023. Violent crime was at a height of 1.93 million crimes in 1992, but has since reached a low of 1.15 million violent crimes in 2014. When conducting crime reporting, the FBI’s Uniform Crime Reporting Program considered murder, nonnegligent manslaughter, forcible rape, robbery and aggravated assault to be violent crimes, because they are offenses which involve force or threat of violence. In 2023, there were 19,252 reported murder and nonnegligent manslaughter cases in the United States. California ranked first on a list of U.S. states by number of murders, followed by Texas, and Florida.The greatest number of murders were committed by murderers of unknown relationship to their victim. “Girlfriend” was the fourth most common relationship of victim to offender in 2023, with a reported 568 partners murdering their girlfriends that year, while the sixth most common was “wife.” In addition, seven people were murdered by their employees and 12 people were murdered by their employers. The most used murder weapon in 2023 was the handgun, which was used in 7,1 murders that year. According to the FBI, firearms (of all types) were used in more than half of the nation’s murders. The total number of firearms manufactured in the U.S. annually has reached over 13 million units.

In response to a growing concern about hate crimes, the United States Congress enacted the Hate Crime Statistics Act of 1990. The Act requires the attorney general to establish guidelines and collect, as part of the Uniform Crime Reporting (UCR) Program, data "about crimes that manifest evidence of prejudice based on race, religion, sexual orientation, or ethnicity, including where appropriate the crimes of murder and non-negligent manslaughter, forcible rape, aggravated assault, simple assault, intimidation, arson, and destruction, damage or vandalism of property." Hate crime data collection was required by the Act to begin in calendar year 1990 and to continue for four successive years. In September 1994, the Violent Crime Control and Law Enforcement Act amended the Hate Crime Statistics Act to add disabilities, both physical and mental, as factors that could be considered a basis for hate crimes. Although the Act originally mandated data collection for five years, the Church Arson Prevention Act of 1996 amended the collection duration "for each calendar year," making hate crime statistics a permanent addition to the UCR program. As with the other UCR data, law enforcement agencies contribute reports either directly or through their state reporting programs. Information contained in the data includes number of victims and offenders involved in each hate crime incident, type of victims, bias motivation, offense type, and location type.

The graph illustrates the murder rate in the United States from 1985 to 2025. The x-axis represents the years, labeled with two-digit abbreviations from '85 to '25, while the y-axis shows the annual murder rate per 100,000 individuals. Throughout this 41-year period, the murder rate fluctuates between a high of 10.66 in 1991 and a low of 4.7 in 2014. Overall, the data reveals a significant downward trend in the murder rate from the mid-1980s, reaching its lowest point in the mid-2010s, followed by slight increases in the most recent years.

This dataset contains county-level totals for the years 2002-2014 for eight types of crime: murder, rape, robbery, aggravated assault, burglary, larceny, motor vehicle theft, and arson. These crimes are classed as Part I criminal offenses by the United States Federal Bureau of Investigations (FBI) in their Uniform Crime Reporting (UCR) program. Each record in the dataset represents the total of each type of criminal offense reported in (or, in the case of missing data, attributed to) the county in a given year.

In 2023, a total of ******* violent crimes were committed in Texas, the most out of any U.S. state. New York followed, with ******* violent crimes committed. California, Illinois, and Michigan rounded out the top five states for violent crimes in that year.

The graph shows the number of violent crime victims in the United States by gender from 2015 to 2025. The x-axis represents the years, while the y-axis indicates the number of male and female victims reported annually. Male victim counts range from a low of 181,851 in 2015 to a peak of 580,445 in 2023, while female victim counts range from 165,060 in 2015 to a high of 531,872 in 2023. Both genders show a consistent upward trend from 2015 to 2023, followed by a sharp drop in 2025. The data illustrates parallel trends for both male and female victims across the observed period.

This table contains data on the rate of violent crime (crimes per 1,000 population) for California, its regions, counties, cities and towns. Crime and population data are from the Federal Bureau of Investigations, Uniform Crime Reports. Rates above the city/town level include data from city, university and college, county, state, tribal, and federal law enforcement agencies. The table is part of a series of indicators in the Healthy Communities Data and Indicators Project of the Office of Health Equity. Ten percent of all deaths in young California adults aged 15-44 years are related to assault and homicide. In 2010, California law enforcement agencies reported 1,809 murders, 8,331 rapes, and over 95,000 aggravated assaults. African Americans in California are 11 times more likely to die of assault and homicide than Whites. More information about the data table and a data dictionary can be found in the About/Attachments section.

In 2023, around **** percent of persons between the ages of 12 and 17 years old in the United States experienced one or more violent victimizations. This was a decrease from the previous year, when **** percent of children in the same age group were the victim of a violent crime.

Context

This dataset looks at the number of movies produced in the United States of America that fall into the "crime" genre between 1985 and 2017 and compares it to violent crime rates of the same time. The time frame was chosen based off of accessible data (The Movies Dataset ends with 2017 and the FBI's CDE tool starts at 1985).

The data for the movies and genres was pulled from "The Movies Dataset" on Kaggle where columns were adjusted and the first two genres were kept. The data was then filtered to only include films released in the United States of America from 1985-2017. Violent crime data and population data in the USA was then joined.

Tableau Public Visualization

Content

movies-to-crime_data_by_population_1985-2017_2023-03-06.csv: This file contains the filtered and sorted data joining together the rest of the included data.

movies_data_cleaned_V2.csv: This includes a large movie dataset that was pulled from the aforementioned "The Movies Dataset" and adjusted for usability for this project, find original dataset here.

population_data_1985-2017.csv: This data was pulled from the World Bank, Population, Total for United States [POPTOTUSA647NWDB], retrieved from FRED, Federal Reserve Bank of St. Louis.

violent_crime_rates_USA_1985-2017_2024-03-06.csv: This data was pulled from the Federal Bureau of Investigation's "Crime Data Explorer" tool. Data pulled includes all violent crime 1985-2017. More information concerning how violent crimes are categorized can be found on the Crime Data Explorer's website linked above.

Acknowledgements

All data was sourced via publicly available datasets and linked to above. Special thanks to Kaggle user Rounak Banik for their work creating "The Movies Dataset" which was incredibly helpful.

Inspiration

This project was a side project to gain further practice with tools such as SQL, R, Tableau and spreadsheets. It began with a focus on authors of crime novels vs amount of actual criminals. The project soon morphed into this after a struggle to find usable datasets.

This comprehensive dataset offers detailed crime data from 2020 to the present, encompassing a wide range of criminal offenses, arrest statistics, and law enforcement activities across the United States. The dataset captures the evolving landscape of crime during a pivotal period shaped by the COVID-19 pandemic, social justice movements, and shifting socio-political dynamics.

Each record provides granular information on crime types, including violent crimes, property offenses, drug-related incidents, and more. The data includes key variables such as location details, timeframes, demographic information of offenders and victims, and arrest outcomes, enabling deep analysis of crime trends at national, state, and local levels.

This dataset is a valuable resource for criminal justice researchers, policy makers, law enforcement agencies, and data analysts, offering crucial insights for understanding patterns in public safety, shaping crime prevention strategies, and informing data-driven policy decisions. It supports comparative studies on crime fluctuations during and after significant societal events, helping stakeholders address pressing issues in public safety and community well-being.

The purpose of this project was to estimate long-term trends in violent victimization by gender and various socio-demographic factors. These factors included race and ethnicity, age, type of place (urban, suburban, rural), socio-economic status, marital status (for adults), and family status (for juveniles). The principal investigators also further disaggregated these violent victimization trends by victim-offender relationship to reveal trends in violence committed by strangers, intimate partners, and known/non-intimate offenders. The researchers produced these various trends in violent victimization by pooling and appropriately weighting the National Crime Survey and its successor, the National Crime Victimization Survey for the period 1973 to 2005, resulting in 33 years of data. In total, a series of 135 trends in violent victimization were developed.

This project was designed to isolate the effects that individual crimes have on wage rates and housing prices, as gauged by individuals' and households' decisionmaking preferences changing over time. Additionally, this project sought to compute a dollar value that individuals would bear in their wages and housing costs to reduce the rates of specific crimes. The study used multiple decades of information obtained from counties across the United States to create a panel dataset. This approach was designed to compensate for the problem of collinearity by tracking how housing and occupation choices within particular locations changed over the decade considering all amenities or disamenities, including specific crime rates. Census data were obtained for this project from the Integrated Public Use Microdata Series (IPUMS) constructed by Ruggles and Sobek (1997). Crime data were obtained from the Federal Bureau of Investigation's Uniform Crime Reports (UCR). Other data were collected from the American Chamber of Commerce Researchers Association, County and City Data Book, National Oceanic and Atmospheric Administration, and Environmental Protection Agency. Independent variables for the Wages Data (Part 1) include years of education, school enrollment, sex, ability to speak English well, race, veteran status, employment status, and occupation and industry. Independent variables for the Housing Data (Part 2) include number of bedrooms, number of other rooms, building age, whether unit was a condominium or detached single-family house, acreage, and whether the unit had a kitchen, plumbing, public sewers, and water service. Both files include the following variables as separating factors: census geographic division, cost-of-living index, percentage unemployed, percentage vacant housing, labor force employed in manufacturing, living near a coastline, living or working in the central city, per capita local taxes, per capita intergovernmental revenue, per capita property taxes, population density, and commute time to work. Lastly, the following variables measured amenities or disamenities: average precipitation, temperature, windspeed, sunshine, humidity, teacher-pupil ratio, number of Superfund sites, total suspended particulate in air, and rates of murder, rape, robbery, aggravated assault, burglary, larceny, auto theft, violent crimes, and property crimes.

The violent crime rate indicator includes both the total number of violent crime incidents per year in Champaign County, and the number of violent crime incidents per 100,000 people per year in Champaign County. “Violent crimes” are those counted in the following categories in the Illinois State Police’s annual Crime in Illinois report: Criminal Homicide, Criminal Sexual Assault (Rape), Robbery, Aggravated Assault, and Aggravated Battery. The incidence of violent crime is an integral part of understanding the safety of a given community.

Both the total number of offenses in Champaign County and the rate per 100,000 population were significantly lower in 2021 than at the start of the measured time period, 1996. The most recent rise in both of these figures was in 2019-2020, before falling again in 2021. The year with the lowest number of total offenses and the rate per 100,000 population in the study period was 2015; both measures are slightly higher since then.

This data is sourced from the Illinois State Police’s annually released Crime in Illinois: Annual Uniform Crime Report, available on the Uniform Crime Report Index Offense Explorer.

Sources: Illinois State Police. (2021). Crime in Illinois: Annual Uniform Crime Report 2021. Illinois State Police. (2020). Crime in Illinois: Annual Uniform Crime Report 2020. Illinois State Police. (2019). Crime in Illinois: Annual Uniform Crime Report 2019. Illinois State Police. (2018). Crime in Illinois: Annual Uniform Crime Report 2018. Illinois State Police. (2017). Crime in Illinois: Annual Uniform Crime Report 2017.Illinois State Police. (2016). Crime in Illinois: Annual Uniform Crime Report 2016. Illinois State Police. (2015). Crime in Illinois: Annual Uniform Crime Report 2015. Illinois State Police. (2014). Crime in Illinois: Annual Uniform Crime Report 2014.; Illinois State Police. (2012). Crime in Illinois: Annual Uniform Crime Report 2012.; Illinois State Police. (2011). Crime in Illinois: Annual Uniform Crime Report 2010-2011.; Illinois State Police. (2009). Crime in Illinois: Annual Uniform Crime Report 2009.; Illinois State Police. (2007). Crime in Illinois: Annual Uniform Crime Report 2007.; Illinois State Police. (2005). Crime in Illinois: Annual Uniform Crime Report 2005.; Illinois State Police. (2003). Crime in Illinois: Annual Uniform Crime Report 2003.; Illinois State Police. (2001). Crime in Illinois: Annual Uniform Crime Report 2001.; Illinois State Police. (1999). Crime in Illinois: Annual Uniform Crime Report 1999.; Illinois State Police. (1997). Crime in Illinois: Annual Uniform Crime Report 1997.

In 2023, the violent crime rate in the United States was at 374.4 cases per 100,000 inhabitants. However, the total rate of property crime was far higher, at 1,916.7 cases per 100,000 inhabitants.

These data provide information on the number of arrests reported to the Federal Bureau of Investigation's (FBI) Uniform Crime Reporting (UCR) Program each month by police agencies in the United States. Although not as well known as the "Crimes Known to the Police" data drawn from the Uniform Crime Report's Return A form, the arrest reports by age, sex, and race provide valuable data on 43 offenses including violent, drug, gambling, and larceny crimes. The data received by ICPSR were structured as a hierarchical file containing (per reporting police agency) an agency header record, and 1 to 12 monthly header reports, and 1 to 43 detail offense records containing the counts of arrests by age, sex, and race for a particular offense. ICPSR restructured the original data to a rectangular format.

The graph shows the number of violent crime victims in the United States by gender and type in 2024. The x-axis represents the crime type, while the y-axis indicates the number of male and female victims reported annually.

Context

The Uniform Crime Reporting (UCR) Program has been the starting place for law enforcement executives, students of criminal justice, researchers, members of the media, and the public at large seeking information on crime in the nation. The program was conceived in 1929 by the International Association of Chiefs of Police to meet the need for reliable uniform crime statistics for the nation. In 1930, the FBI was tasked with collecting, publishing, and archiving those statistics.

Today, four annual publications, Crime in the United States, National Incident-Based Reporting System, Law Enforcement Officers Killed and Assaulted, and Hate Crime Statistics are produced from data received from over 18,000 city, university/college, county, state, tribal, and federal law enforcement agencies voluntarily participating in the program. The crime data are submitted either through a state UCR Program or directly to the FBI’s UCR Program.

This dataset focuses on the crime rates and law enforcement employment data in the state of California.

Content

Crime and law enforcement employment rates are separated into individual files, focusing on offenses by enforcement agency, college/university campus, county, and city. Categories of crimes reported include violent crime, murder and nonnegligent manslaughter, rape, robbery, aggravated assault, property crime, burglary, larceny-theft, motor vehicle damage, and arson. In the case of rape, data is collected for both revised and legacy definitions. In some cases, a small number of enforcement agencies switched definition collection sometime within the same year.

Acknowledgements

This dataset originates from the FBI UCR project, and the complete dataset for all 2015 crime reports can be found here.

Inspiration

• What are the most common types of crimes in California? Are there certain crimes that are more common in a particular place category, such as a college/university campus, compared to the rest of the state?
• How does the number of law enforcement officers compare to the crime rates of a particular area? Is the ratio similar throughout the state, or do certain campuses, counties, or cities have a differing rate?
• How does the legacy vs. refined definition of rape differ, and how do the rape counts compare? If you pulled the same data from FBI datasets for previous years, can you see a difference in rape rates over time?