In July 2024, in the Mexican state of Jalisco the most common crime was robberies with a 30.96 percent of the total reported crimes. Followed by other common law crimes and domestic violence with 12.17 percent and 11.34 percent respectively. Homicides, sexual abuse, and drug dealing also made the cut.

The crime prevalence rate per 100,000 inhabitants aged 18 and over in Jalisco stood at approximately ****** in 2023. Between 2010 and 2023, the rate rose by around ***, though the increase followed an uneven trajectory rather than a consistent upward trend.

The share of people whose neighbors are organized against crime in their locality in Jalisco amounted to approximately ***** percent in 2024. Between 2012 and 2024, the share rose by around ***** percentage points, though the increase followed an uneven trajectory rather than a consistent upward trend.

The number of homicides in Jalisco peaked during 2018 with 2,762 cases. As of 2023, Mexico State and Guanajuato ranked as the federal entities with the highest number of homicides.

The average cost of crime against individuals in Jalisco stood at approximately ****** U.S. dollars in 2023. Between 2010 and 2023, the average cost of crime rose by around ****** U.S. dollars, though the increase followed an uneven trajectory rather than a consistent upward trend.

In 2023, the share of crimes involving weapons in Jalisco decreased by 4.7 percentage points (-13.43 percent) compared to 2022. Nevertheless, the last two years recorded a significantly higher share than the preceding years.For more insights about the share of crimes involving weapons consider different countries: In 2023, in comparison to Jalisco, the share in Coahuila de Zaragoza was lower and in Querétaro it was considerably lower.

Introduction

Chicago is one of America's most iconic cities. It has a colorful history, which rich histories such. Recently, Chicago was also a setting for one of Netflix's popular series : Ozark. The story has it that Chicago is the center for drug distribution for the Navarro cartel.

So, how true is the series? A quick search on the internet reveals a recently released DEA report on the. The report shows that drug crime exists in Chicago, although they are distributed by the Cartel de Jalisco Nueva Generacion, the Sinaloa Cartel and the Guerros Unidos, to name a few.

Content

The government of the City of Chicago has provided a publicly available crime database accessible via Google BigQuery. I have downloaded a subset of the data with crime_type narcotics and year > 2015. The data contains records between 1 Jan 2016 UTC until 23 Jul 2020 UTC.

The dataset contains these columns : - case_number : ID of the record - date : Date of incident - iucr : Category of the crime, per Illinois Unified Crime Reporting (IUCR) code. [more](https://data.cityofchicago.org/widgets/c7ck-438e) -description: More detailed description of the crime -location_description: Location of the crime -arrest: Whether an arrest was made -domestic: Was the crime domestic? -district: Which district code where the crime happened. [more](https://data.cityofchicago.org/Public-Safety/Boundaries-Police-Districts-current-/fthy-xz3r) -ward: The ward code where the crime happened. [more](https://data.cityofchicago.org/Facilities-Geographic-Boundaries/Boundaries-Wards-2015-/sp34-6z76) -community_area` : The community area code where the crime happened. more

Acknowledgements

The data is owned and kindly provided by the City of Chicago.

Inspiration

Some questions to get you started:

1. Is there a trend? Is the crime increasing? or decreasing?
2. Is there seasonality? Are dealers more like to be out and about in summer? Do they deal inside in winter?
3. Are some activities more like to happen at certain locations?
4. We tend to think that more deals happen at night, especially as people wind down, and the surroundings get dark. Does the data reflect that?
5. Are the incidents clustered to a certain district? Certain type of location?

Lastly, if you are : - a newly recruited analyst at the DEA / police, what would you recommend? - asked by el jefe del cartel (boss of the cartel) on how to expand operation / operate better, what would you say?

Happy wrangling!

In 2023, the share of male victims of at least one crime in Jalisco amounted to approximately ***** percent. Between 2010 and 2023, the figure dropped by around **** percentage points, though the decline followed an uneven course rather than a steady trajectory.

The number of drug dealing reported cases in Jalisco peaked during 2018 with ***** cases. As of 2024, Guanajuato and Coahuila ranked as the federal entities with the highest number of drug dealing offenses.

The number of reported criminal offenses in Jalisco amounted to approximately ******* in 2023. Between 2010 and 2023, the number rose by around ******, though the increase followed an uneven trajectory rather than a consistent upward trend.

83 (Number) in 2010.

In 2021, the number of criminal offenses with no preliminary investigation in Jalisco stood at approximately *****. Between 2011 and 2021, the figure dropped by around *****, though the decline followed an uneven course rather than a steady trajectory.

The border city of Tijuana was the Mexican municipality with the highest number of homicides, with 1,844 cases reported in 2023, a decrease when compared to the over 2,000 cases reported last year. Tijuana was followed by Ciudad Juárez, located south of El Paso, Texas, with a total of 1,246 homicides.

In 2023, the share of crimes involving weapons in Michoacán de Ocampo increased by 4.3 percentage points (+17.92 percent) compared to 2022. In total, the share amounted to 28.31 percent in 2023. This increase was preceded by a declining share.For more insights about the share of crimes involving weapons consider different countries: In 2023, in comparison to Michoacán de Ocampo, the share in Jalisco as well as in Tlaxcala was higher.

In 2023, the number of reported criminal offenses in Guerrero decreased by 10.7 thousand crimes (-33.47 percent) compared to 2022. In 2023, the number thereby reached its lowest value in recent years. For more insights about the number of reported criminal offenses consider different countries: In 2023, in comparison to Guerrero, the number in Campeche was higher and in Jalisco it was considerably higher.

The share of male victims of at least one crime in Baja California decreased by 1.4 percentage points (-5.74 percent) in 2023 in comparison to the previous year. This marks the lowest share during the observed period. For more insights about the share of male victims of at least one crime consider different countries: In 2023, in comparison to Baja California, the share in Jalisco was higher and in Querétaro it was considerably higher.

The number of criminal offenses with no preliminary investigation in Michoacán de Ocampo declined to 230.95 crimes in 2021. The number thereby reached its lowest value in recent years.For more insights about the number of criminal offenses with no preliminary investigation consider different countries: In 2021, in comparison to Michoacán de Ocampo, the number in Morelos as well as in Jalisco was considerably higher.