Australian Road Deaths Database, fatalities, version 2026-10-20
latest
Rows 59,169Fields 20Fetched 26 October 2026Source SHA-256 c5bf739b3bfefae0…
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.csv9.7 MBCSV: 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.gz1.5 MBCSV (gzip): The same CSV, gzipped, at about a tenth of the size. curl, pandas, DuckDB and R read it directly.
data.duckdbDuckDB: 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.json29 MBJSON: One object with a publicdata header (publisher, licence, attribution, version, source hash), a fields list and a records array of 59,169 objects with typed values. Blank cells are null.
data.ndjson29 MBNDJSON: The first line is the provenance header, then one JSON object per line. For streaming and for tools that read line by line.
data.parquet874 KBParquet: 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.sqlite7.4 MBSQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
data.xlsx5.5 MBExcel: One workbook with a records sheet of 59,169 typed rows, a fields sheet and a publicdata sheet with the provenance. Dates are real Excel dates. Opens in Excel, Numbers, LibreOffice and Sheets.
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.
58,837 rows in 2026-08-07 and 59,169 in this version. No key is declared, so rows are compared by count only. The comparison is in diff/2026-08-07..2026-10-20.json.
Attribution the licence asks for
Bureau of Infrastructure and Transport Research Economics, Australian Road Deaths Database, https://catalogue.data.infrastructure.gov.au/dataset/australian-road-deaths-database, accessed 26 October 2026, licensed under CC BY 4.0.
People killed per year by road user, 1989 to 2025. 2026 is not drawn because the year was not over when the publisher released this version on 20 October 2026. A count of rows in this version, worked out in the build.
Change from the version before
58,837 rows before, 59,169 now
Against 2026-08-07. No key is declared, so rows are compared by count only. The comparison is in diff/2026-08-07..2026-10-20.json.