Crime Trends in Victoria
Brenda Kipserem
Overview
Goal. Show how crime patterns in Victoria change
over time, categories, and regions using the attached
crime_data.csv.
What you’ll see. Clean visuals and concise commentary.
No code on slides.
At a glance
| Metric | Value |
|---|---|
| Years Covered | 2016–2025 |
| Total Rows | 1,119 |
| Total Incidents (first year) | 396,823 |
| Total Incidents (latest year) | 483,583 |
| Change First→Latest | +21.9% |
| # Regions (distinct) | 6 |
| Top Offence Type | — |
Total incidents by year
Year‑over‑year % change
Offence mix (Top 10)
## Needs 'Offence_Type' and 'Count'.Offence mix over time (stacked)
## Needs 'Year', 'Offence_Type' and 'Count'.Regional leaders (Top 10)
Region × Year heatmap
Biggest movers (earliest → latest)
Movers table (top ↑ / top ↓)
| Direction | Region | Change |
|---|---|---|
| Increase | B Property and deception offences | 59507 |
| Increase | A Crimes against the person | 20587 |
| Increase | E Justice procedures offences | 13767 |
| Increase | C Drug offences | 772 |
| Increase | F Other offences | -34 |
| Increase | D Public order and security offences | -7839 |
| Decrease | D Public order and security offences | -7839 |
| Decrease | F Other offences | -34 |
| Decrease | C Drug offences | 772 |
| Decrease | E Justice procedures offences | 13767 |
| Decrease | A Crimes against the person | 20587 |
| Decrease | B Property and deception offences | 59507 |
Per‑capita rates (per 100k) — if population exists
Data quality
| Column | Missing_N |
|---|---|
| Year | 0 |
| Year ending | 0 |
| Offence Division | 0 |
| Offence Subdivision | 0 |
| Offence Subgroup | 0 |
| Incidents Recorded | 0 |
| Rate per 100,000 population | 0 |
Appendix — column mapping
| Original | Detected | After_Mapping |
|---|---|---|
| Year | Year | Year |
| Year ending | Year ending | Year ending |
| Offence Division | Offence Division | Region |
| Offence Subdivision | Offence Subdivision | Offence Subdivision |
| Offence Subgroup | Offence Subgroup | Offence Subgroup |
| Incidents Recorded | Incidents Recorded | Count |
| Rate per 100,000 population | Rate per 100,000 population | Population |
Notes & sources
- If a chart is blank, the required columns are missing or non‑numeric. Rename columns to include keywords like Year/Date, Offence/Type, Region/LGA, Count, and optionally Population.
- Source: Crime Statistics Agency (Victoria). Criminal Incidents Data Tables (Victoria). Data Vic open data portal.