VIVID IBORI’s Post

View profile for VIVID IBORI, graphic

Data Analyst / BI Developer

🌍 UK Crime Report: July & August 2024 🕵️♀️ This report is generated from the dataset obtained from the official UK Police Archive (https://lnkd.in/e6Y2S5Mz). I’ve filtered out all records with "crime type not stated" and here are my findings: 📊 June - July Comparison: There was a 21.66% increase in crime records in July compared to June: June: 338,165 July: 411,410 (+21.66%) 📈 🏙️ Top 3 Cities by Crime Records (July): Birmingham: 12,836 Leeds: 9,099 Westminster: 6,438 🔍 Top 3 Crime Types by Records (July): Violence and Sexual Offences: 173,026 Shoplifting: 39,185 Public Order: 37,878 🌍 Crimes by Region (July): London: 62,006 South East: 60,727 Yorkshire and The Humber: 50,159 West Midlands: 47,167 East of England: 39,488 South West: 36,239 East Midlands: 34,917 North West: 32,678 North East: 24,553 Wales: 23,476 ⚖️ Outcomes Records in July: Under investigation: 148,657 Investigation complete, no suspect identified: 123,627 Unable to prosecute: 104,160 Awaiting court outcome: 17,587 Local resolution: 7,186 Further investigation not in public interest: 2,336 Action to be taken by another organization: 3,933 Offender given a caution: 1,651 Formal action not in public interest: 1,321 Further action not in public interest: 602 📉 July - August Comparison: There was an 11.69% decrease in crime records in August compared to July: August: 363,332 July: 411,410 (-11.69%) 📉 🏙️ Top 3 Cities by Crime Records (August): Leeds: 8,805 Bradford: 6,180 Bristol: 5,636 🔍 Top 3 Crime Types by Records (August): Violence and Sexual Offences: 152,019 Shoplifting: 35,475 Public Order: 35,135 🌍 Crimes by Region (August): South East: 59,708 London: 50,114 Yorkshire and The Humber: 48,609 East of England: 38,485 South West: 36,316 East Midlands: 33,612 North West: 31,467 North East: 24,285 Wales: 22,603 West Midlands: 18,133 ⚖️ Outcomes Records in August: Under investigation: 211,464 Investigation complete, no suspect identified: 79,510 Unable to prosecute: 52,638 Awaiting court outcome: 11,049 Local resolution: 3,802 Further investigation not in public interest: 1,401 Action to be taken by another organization: 1,264 Offender given a caution: 952 Formal action not in public interest: 821 Further action not in public interest: 195 📊 Key Insights: The increase in July's crime records and the drop in August offer fascinating insights into trends across different regions and crime types. The rise in under investigation outcomes in August is notable, suggesting a focus on ongoing investigations. #DataAnalytics #CrimeTrends #UKCrime #DataDrivenInsights #July2024 #August2024 #PublicSafety #Analytics Metropolitan Police Bristol Hospice Birmingham City University Leeds Beckett University Bradford City Village #leeds #bradford #bristol Westminster City Council #Westminster #london #manchester Liverpool Football Club #liverpool

To view or add a comment, sign in

Explore topics