Track Crime Trends Over Time

A single month of crime data tells you almost nothing useful. What matters is whether crime is rising or falling, which categories are shifting, and whether any changes coincide with policing operations, seasonal patterns, or local events. Most people never have access to this longitudinal view because pulling multiple months of data manually is too time-consuming.

By querying crime_stats across consecutive time periods and comparing the results, you can build a clear picture of how an area has changed. Are burglaries up over winter? Did anti-social behaviour spike after a nearby venue opened? These patterns are invisible in snapshot data but obvious in a trend.

Landlords monitoring properties they manage, council officers tracking the impact of interventions, and community groups building cases for additional policing resources all use this approach to make data-backed arguments.