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

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

Cumulative incidents since first year

Distribution across regions by year (boxplot)

Data quality

Missing values (top 20 columns)
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 vs. mapped column names (only for reference).
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.