publicdata.au publicdata.au on GitHub

Recorded offences by suburb and offence, Victoria, version 2026-09-24

latest
Rows 371,541Fields 9Fetched 29 September 2026Source SHA-256 54b62bc2dd0f9216…

This version is kept for as long as this site exists, and its URL can be cited. Its files change only for the reasons the terms give, and each change is recorded in its notes. The publisher's file is here as source.xlsx, byte for byte.

Files

  • data.arrow9.3 MB Arrow: Arrow IPC file (Feather v2), zstd compressed, with the provenance in the schema metadata. Memory-maps in pyarrow, Polars, Arrow JS and R without parsing.
  • data.csv52 MB CSV: UTF-8 without a byte-order mark, RFC 4180 quoting, one header row using the normalised field names. Opens in Excel, Numbers and Sheets.
  • data.csv-metadata.json3.0 KB
  • data.csv.gz2.5 MB CSV (gzip): The same CSV, gzipped, at about a tenth of the size. curl, pandas, DuckDB and R read it directly.
  • data.duckdb DuckDB: One DuckDB database with a records table of typed columns, a fields table and a publicdata metadata table. It attaches read-only over HTTPS, so DuckDB, Python and R can query it without downloading it.
  • data.json99 MB JSON: One object with a publicdata header (publisher, licence, attribution, version, source hash), a fields list and a records array of 371,541 objects with typed values. Blank cells are null.
  • data.ndjson99 MB NDJSON: The first line is the provenance header, then one JSON object per line. For streaming and for tools that read line by line.
  • data.parquet1.0 MB Parquet: Columnar and typed. The smallest download and the fastest to query. Reads directly in DuckDB, pandas, Polars, Arrow and Spark. The provenance header is in the file metadata.
  • data.sqlite76 MB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
  • data.xlsx15 MB Excel: One workbook with a records sheet of 371,541 typed rows, a fields sheet and a publicdata sheet with the provenance. Dates are real Excel dates. Opens in Excel, Numbers, LibreOffice and Sheets.
  • manifest.json1.4 KB
  • schema.json1.3 KB
  • schema.sql1.2 KB
  • source.xlsx22 MB

SHA256SUMS holds the SHA-256 of every file in this version under the name it downloads as. Check what you downloaded with sha256sum -c --ignore-missing SHA256SUMS in the same folder. On a Mac, use shasum -a 256 -c --ignore-missing SHA256SUMS. Each list is signed by the deploy that wrote it: gh attestation verify SHA256SUMS --repo National-Digital/publicdata.au --source-ref refs/heads/main shows it came from this project's main branch.

Smaller files by field: by/lga/.

Attribution the licence asks for

Crime Statistics Agency, Victorian Government, Data tables - Recorded offences, sourced 29 September 2026, https://discover.data.vic.gov.au/dataset/data-tables-recorded-offences, licensed under CC BY 4.0.

Provenance

Fetched from files.crimestatistics.vic.gov.au on 29 September 2026. The portal listed the licence as Creative Commons Attribution 4.0 International at that moment. manifest.json has every detail.

0200k400k600k800k2017 A Crimes against the person: 78,0622017 B Property and deception offences: 314,9212017 C Drug offences: 30,1142017 D Public order and security offences: 35,8592017 E Justice procedures offences: 69,2792017 F Other offences: 1,51320172018 A Crimes against the person: 78,7482018 B Property and deception offences: 287,8212018 C Drug offences: 29,6582018 D Public order and security offences: 34,6132018 E Justice procedures offences: 70,0972018 F Other offences: 2,0032019 A Crimes against the person: 80,0122019 B Property and deception offences: 286,9062019 C Drug offences: 32,1852019 D Public order and security offences: 34,7492019 E Justice procedures offences: 75,1792019 F Other offences: 1,30320192020 A Crimes against the person: 81,9472020 B Property and deception offences: 303,7152020 C Drug offences: 36,6312020 D Public order and security offences: 31,5012020 E Justice procedures offences: 79,6352020 F Other offences: 7,3992021 A Crimes against the person: 84,3692021 B Property and deception offences: 251,6332021 C Drug offences: 36,6182021 D Public order and security offences: 29,6812021 E Justice procedures offences: 82,9022021 F Other offences: 33,18920212022 A Crimes against the person: 81,3682022 B Property and deception offences: 235,8912022 C Drug offences: 29,9222022 D Public order and security offences: 28,5462022 E Justice procedures offences: 80,2742022 F Other offences: 11,0792023 A Crimes against the person: 83,3572023 B Property and deception offences: 272,5242023 C Drug offences: 30,1512023 D Public order and security offences: 29,2602023 E Justice procedures offences: 86,9112023 F Other offences: 1,25520232024 A Crimes against the person: 88,1632024 B Property and deception offences: 311,7202024 C Drug offences: 31,3872024 D Public order and security offences: 27,8572024 E Justice procedures offences: 88,8862024 F Other offences: 1,8282025 A Crimes against the person: 96,5732025 B Property and deception offences: 376,8672025 C Drug offences: 32,4062025 D Public order and security offences: 29,7902025 E Justice procedures offences: 96,9182025 F Other offences: 1,5972025
A Crimes against the personB Property and deception offencesC Drug offencesD Public order and security offencesE Justice procedures offencesF Other offences
Offences per year by offence division, 2017 to 2025. 2026 is not drawn because the year was not over when the publisher released this version on 24 September 2026. A sum of the offences column in this version, worked out in the build.
Change from the version before

First version followed here.

When the publisher releases again, this panel shows rows added, removed and changed by year, lga, postcode, suburb, offence_subgroup, with a link to the diff file.