publicdata.au publicdata.au on GitHub

Victims of family and domestic violence crimes by state, sex and year, Australia, version 2026-08-06

latest
Rows 3,564Fields 6Fetched 30 September 2026Source SHA-256 d822a928d03fccd6…

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.arrow51 KB 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.csv304 KB 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.json2.4 KB
  • data.csv.gz20 KB 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.json550 KB JSON: One object with a publicdata header (publisher, licence, attribution, version, source hash), a fields list and a records array of 3,564 objects with typed values. Blank cells are null.
  • data.ndjson546 KB 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.parquet16 KB 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.sqlite324 KB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
  • data.xlsx95 KB Excel: One workbook with a records sheet of 3,564 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.0 KB
  • schema.json783 B
  • schema.sql975 B
  • source.xlsx967 KB

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.

Attribution the licence asks for

Based on Australian Institute of Health and Welfare material. Australian Institute of Health and Welfare, Australian Government, Family, domestic and sexual violence data tables, Recorded Crime Victims table RCV 1, sourced 30 September 2026, https://www.aihw.gov.au/family-domestic-and-sexual-violence/resources/data-downloads, licensed under CC BY 4.0.

Provenance

Fetched from www.aihw.gov.au on 30 September 2026. The portal listed the licence as CC BY 4.0 at that moment. manifest.json has every detail.

05k10k15k20k2014 Females: 5,8112014 Males: 1,13820142015 Females: 6,4972015 Males: 1,1902016 Females: 6,9382016 Males: 1,24320162017 Females: 7,4562017 Males: 1,2122018 Females: 7,6452018 Males: 1,15620182019 Females: 7,6902019 Males: 1,2532020 Females: 8,7392020 Males: 1,41320202021 Females: 10,0632021 Males: 1,2802022 Females: 10,6332022 Males: 1,28820222023 Females: 12,4212023 Males: 1,6182024 Females: 14,0662024 Males: 1,8962024
FemalesMales
Victims of sexual assault per year by sex, 2014 to 2024. Rows where unit is Number and state or territory is Australia and offence is Sexual assault and sex is not Persons are drawn. A sum of the value 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, with a link to the diff file.