Multiple datasets related to Houston Police Department Crime Stats

Pulled from here: https://www.houstontx.gov/police/cs/crime-stats-archives.htm

Recognized that Houston crime stats were in an outdated .xls format and partitioned by month. Used bs4 to pull .xls files onto local machine and used pandas read_excel and applied some basic cleaning to provide an aggregate dataset of all Houston crime data.

Data is collected from 2010-2018 with some extra historical rows from the 1900s

As a contribution to nationwide efforts to more thoroughly understand urban violence, this study was conducted to assess the impact of cultural dynamics on homicide rates in Houston, Texas, and to profile homicides in the city from 1985 to 1994. This data collection provides the results of quantitative analysis of data collected from all Houston homicide cases recorded in the police murder logs for 1985-1994. Variables describe the homicide circumstances, the victim-offender relationship, the type of weapon used, and any drug- or gang-related activity involved. Other variables include the year and month in which the homicide occurred, whether the homicide occurred on a weekday or over the weekend, the motive of the homicide, whether the homicide was drug-related, whether the case was cleared by police at time of data entry, weapon type and means of killing, the relationship between the victim and the offender, whether a firearm was the homicide method, whether it was a multiple victim incident or multiple offender incident, whether the victim or the offender was younger than age 15, and the inter-racial relationship between the victim and the offender. Demographic variables include age, sex, and race of the victim as well as the offender.

FBI National Incident-Based Reporting System (FBI NIBRS) crime data for University of Texas: Houston (University or College) in Texas, including incidents, statistics, demographics, and detailed incident information.

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.

FBI National Incident-Based Reporting System (FBI NIBRS) crime data for Independent School District: Houston (Other) in Texas, including incidents, statistics, demographics, and detailed incident information.

FBI National Incident-Based Reporting System (FBI NIBRS) crime data for South Houston Police Department (City) in Texas, including incidents, statistics, demographics, and detailed incident information.

FBI National Incident-Based Reporting System (FBI NIBRS) crime data for Houston Christian University Police Department (University or College) in Texas, including incidents, statistics, demographics, and detailed incident information.

FBI National Incident-Based Reporting System (FBI NIBRS) crime data for Houston Arson Bureau (Other) in Texas, including incidents, statistics, demographics, and detailed incident information.

FBI National Incident-Based Reporting System (FBI NIBRS) crime data for University of Houston: Clearlake (University or College) in Texas, including incidents, statistics, demographics, and detailed incident information.

FBI National Incident-Based Reporting System (FBI NIBRS) crime data for Houston County Constable: Precinct 1 (Other) in Texas, including incidents, statistics, demographics, and detailed incident information.

FBI National Incident-Based Reporting System (FBI NIBRS) crime data for Fire Marshal's Office: Houston County (Other) in Texas, including incidents, statistics, demographics, and detailed incident information.