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, the state with the highest crime rate in the United States per 100,000 inhabitants was New Mexico. That year, the crime rate was ******** crimes per 100,000 people. In comparison, New Hampshire had the lowest crime rate at ****** crimes per 100,000 people. Crime rate The crime rate in the United States has generally decreased over time. There are several factors attributed to the decrease in the crime rate across the United States. An increase in the number of police officers and an increase in income are some of the reasons for a decrease in the crime rate. Unfortunately, people of color have been disproportionately affected by crime rates, as they are more likely to be arrested for a crime versus a white person. Crime rates regionally The District of Columbia had the highest rate of reported violent crimes in the United States in 2023 per 100,000 inhabitants. The most common crime clearance type in metropolitan counties in the United States in 2020 was murder and non-negligent manslaughter. The second most dangerous city in the country in 2020 was Detroit. Detroit has faced severe levels of economic and demographic declines in the past years. Not only has the population decreased, the city has filed for bankruptcy. Despite the median household income increasing, the city still struggles financially.

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

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

This data set is no longer compiled by the Ministry of the Solicitor General.

Violent crimes under the Criminal Code include:

• homicide
• attempted murder
• sexual assault (levels 1-3)
• assault
• robbery
• criminal harassment
• uttering threats
• other violent violations

The data can be accessed from "https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3510002601">Statistics Canada.

Crime severity index (violent, non-violent, youth) and weighted clearance rates (violent, non-violent), Canada, provinces, territories and Census Metropolitan Areas, 1998 to 2024.

Serious violent crimes consist of Part 1 offenses as defined by the U.S. Department of Justice’s Uniform Reporting Statistics. These include murders, nonnegligent homicides, rapes (legacy and revised), robberies, and aggravated assaults. LAPD data were used for City of Los Angeles, LASD data were used for unincorporated areas and cities that contract with LASD for law enforcement services, and CA Attorney General data were used for all other cities with local police departments. This indicator is based on location of residence. Single-year data are only available for Los Angeles County overall, Service Planning Areas, Supervisorial Districts, City of Los Angeles overall, and City of Los Angeles Council Districts.Neighborhood violence and crime can have a harmful impact on all members of a community. Living in communities with high rates of violence and crime not only exposes residents to a greater personal risk of injury or death, but it can also render individuals more susceptible to many adverse health outcomes. People who are regularly exposed to violence and crime are more likely to suffer from chronic stress, depression, anxiety, and other mental health conditions. They are also less likely to be able to use their parks and neighborhoods for recreation and physical activity.For more information about the Community Health Profiles Data Initiative, please see the initiative homepage.

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.

The data are provided are the Maryland Statistical Analysis Center (MSAC), within the Governor's Office of Crime Control and Prevention (GOCCP). MSAC, in turn, receives these data from the Maryland State Police's annual Uniform Crime Reports.

The Division of Criminal Justice Services (DCJS) collects crime reports from more than 500 New York State police and sheriffs’ departments. DCJS compiles these reports as New York’s official crime statistics and submits them to the FBI under the National Uniform Crime Reporting (UCR) Program. UCR uses standard offense definitions to count crime in localities across America regardless of variations in crime laws from state to state. In New York State, law enforcement agencies use the UCR system to report their monthly crime totals to DCJS. The UCR reporting system collects information on seven crimes classified as Index offenses which are most commonly used to gauge overall crime volume. These include the violent crimes of murder/non-negligent manslaughter, forcible rape, robbery, and aggravated assault; and the property crimes of burglary, larceny, and motor vehicle theft. Firearm counts are derived from taking the number of violent crimes which involve a firearm. Population data are provided every year by the FBI, based on US Census information. Police agencies may experience reporting problems that preclude accurate or complete reporting. The counts represent only crimes reported to the police but not total crimes that occurred. DCJS posts preliminary data in the spring and final data in the fall.

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.

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 Alberta Official Statistic describes the violent crime rates for Canada and provinces for the years from 1998 to 2014. The rate is based on the incidence of violent crime per 100,000 population in each province. The Canadian Centre for Justice Statistics (CCJS), in co-operation with the policing community, collects police-reported crime statistics through the Uniform Crime Reporting (UCR) Survey. The UCR Survey was designed to measure the incidence of crime in Canadian society and its characteristics. UCR data reflect reported crime that has been substantiated by police. Information collected by the survey includes the number of criminal incidents, the clearance status of those incidents and persons-charged information. The UCR Survey produces a continuous historical record of crime and traffic statistics reported by every police agency in Canada since 1962. In 1988, a new version of the survey (UCR3) was created, which is referred to as the "incident-based" survey. It captures microdata on characteristics of incidents, victims and accused. Data from the UCR Survey provide key information for crime analysis, resource planning and program development for the policing community. Municipal and provincial governments use the data to aid decisions about the distribution of police resources, definitions of provincial standards and for comparisons with other departments and provinces. To the federal government, the UCR survey provides information for policy and legislative development, evaluation of new legislative initiatives, and international comparisons. To the public, the UCR survey offers information on the nature and extent of police-reported crime and crime trends in Canada. As well, media, academics and researchers use these data to examine specific issues about crime.

Violent crime rates for Everett, Snohomish County, Washington State, and the US as reported

by the FBI's National Incident-Based Reporting System (NIBRS) program. The violent crime rate is defined as the number of reported violent

crimes per 100,000 residents. Violent crime figures include the offenses of murder, rape, robbery, and aggravated assault.

Note that County population figures come from the US Census Bureau's

American Community Survey.

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

See the Splitgraph documentation for more information.

Comprehensive crime statistics for Orange County including homicides, violent crime, property crime, and city-by-city breakdowns with five-year trend analysis.

Incident-based crime statistics (actual incidents, rate per 100,000 population, percentage change in rate, unfounded incidents, percent unfounded, total cleared, cleared by charge, cleared otherwise, persons charged, adults charged, youth charged / not charged), by detailed violations (violent, property, traffic, drugs, other Federal Statutes), Canada, provinces, territories, Census Metropolitan Areas and Canadian Forces Military Police, 1998 to 2024.