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.

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, 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.

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.

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.

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.

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.

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.

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 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.

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.

In 2022, there were slightly more female victims of violent crime than male victims in the United States, with about ********* male victims and ********* female victims. These figures are a significant increase from the previous year, when there were ********* male victims and ********* female victims. What counts as violent crime? Violent crime in the United States includes murder, rape, sexual assault, robbery, and assault. While violent crime across all areas has been steadily falling over the past few decades, the rate of aggravated assault is still relatively high, at ***** cases per 100,000 of the population. In 2021, there were more property crimes committed in the U.S. than there were violent crimes. Keep your enemies closer It is usually said that most victims know their attacker, and the data backs this up. In 2021, very few murders were committed by strangers. The same goes for rape and sexual assault victims; the majority were perpetrated by acquaintances, intimate partners, or relatives.

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.

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.

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.

This comprehensive dataset provides a deep dive into crime statistics across the United States. It encompasses a wide range of crime types, spanning from violent offenses like homicide and assault to property crimes such as theft and burglary. The data is meticulously organized, offering insights into crime trends, geographical variations, and temporal patterns.

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.

Number, percentage and rate (per 100,000 population) of homicide victims, by racialized identity group (total, by racialized identity group; racialized identity group; South Asian; Chinese; Black; Filipino; Arab; Latin American; Southeast Asian; West Asian; Korean; Japanese; other racialized identity group; multiple racialized identity; racialized identity, but racialized identity group is unknown; rest of the population; unknown racialized identity group), gender (all genders; male; female; gender unknown) and region (Canada; Atlantic region; Quebec; Ontario; Prairies region; British Columbia; territories), 2019 to 2024.