Chicago's Crime Landscape: A 2025 Data Story

Inspiration

Urban crime patterns significantly impact community safety and policy decisions, yet raw incident data is difficult to interpret without proper analysis. This project was inspired by the need to transform Chicago's 235,680 crime records into actionable intelligence for residents, policymakers, and community stakeholders.

What it does

The project analyzes Chicago's 2025 crime data across three dimensions: temporal patterns revealing seasonal peaks (37% summer surge), categorical breakdowns identifying dominant threats (Property Theft: 70,291 incidents; Physical Violence: 65,736), and geographic disparities showing 6x crime variation between safest (Ward 38: 1,904 incidents) and most dangerous wards (Ward 27: 11,308). Interactive visualizations and heatmaps enable users to explore crime patterns by type, time, and location.

How we built it

Built using Hex notebook environment combining SQL queries for data transformation, Python for statistical analysis and visualization, and interactive chart/map components. The workflow chains SQL cells for temporal aggregation and categorical classification, followed by explore cells for chart creation and folium-based heatmap rendering.

Challenges we ran into

Managing geographic data quality with null coordinate handling, designing intuitive threat categorization that balances granularity with actionability, and optimizing query performance for 235K+ records across multiple aggregation grains. Balancing analytical depth with accessible presentation required iterative refinement of visualization design and narrative structure.

Accomplishments that we're proud of

Transforming raw incident data into prevention-ready intelligence through systematic threat categorization. Creating geographic analysis revealing quantifiable safety disparities (83% crime reduction in edge vs. central wards). Building interactive dashboard allowing drill-down from citywide trends to ward-specific patterns. Designing analysis methodology applicable to other urban crime dataset

What we learned

Spatial crime analysis requires multi-dimensional approaches—temporal, categorical, and geographic patterns intersect to reveal actionable insights. Effective threat categorization demands understanding prevention strategies, not just statistical grouping. Data visualization must balance analytical rigor with accessibility for diverse stakeholders. Geographic disparities in urban crime are more dramatic than aggregate statistics suggest.

What's next for Chicago's Crime Landscape: A 2025 Data Story

Integrate predictive modeling to forecast crime hotspots based on temporal and spatial patterns. Expand analysis to include arrest rates and case resolution trends by ward and crime type. Develop neighborhood-specific risk profiles combining threat categories with location-based vulnerability factors. Create API endpoint for real-time crime pattern queries enabling dynamic community safety applications.

Built With

• hex
• python