publicdata.au publicdata.au on GitHub

Australian Road Deaths Database, fatalities, version 2026-08-07

Rows 58,837Fields 20Fetched 28 September 2026Source SHA-256 245947df7e2e44a4…

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.arrow2.9 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.csv9.7 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.json5.1 KB
  • data.csv.gz1.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.json29 MB JSON: One object with a publicdata header (publisher, licence, attribution, version, source hash), a fields list and a records array of 58,837 objects with typed values. Blank cells are null.
  • data.ndjson29 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.parquet861 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.sqlite7.3 MB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
  • data.xlsx5.4 MB Excel: One workbook with a records sheet of 58,837 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.3 KB
  • schema.json3.8 KB
  • schema.sql1.9 KB
  • source.xlsx6.0 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/state/, by/year/.

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 28 September 2026, licensed under CC BY 4.0.

Provenance

Fetched from aueprod01ckanstg.blob.core.windows.net on 28 September 2026. The portal listed the licence as Creative Commons Attribution at that moment. manifest.json has every detail.

01k2k3k1989 Driver: 1,1221989 Motorcycle pillion passenger: 301989 Motorcycle rider: 2691989 Passenger: 7801989 Pedal cyclist: 981989 Pedestrian: 5011990 Driver: 9351990 Motorcycle pillion passenger: 211990 Motorcycle rider: 2411990 Passenger: 6341990 Pedal cyclist: 801990 Pedestrian: 42019901991 Driver: 9101991 Motorcycle pillion passenger: 211991 Motorcycle rider: 2271991 Passenger: 5541991 Pedal cyclist: 581991 Pedestrian: 3431992 Driver: 8151992 Motorcycle pillion passenger: 191992 Motorcycle rider: 1781992 Passenger: 5701992 Pedal cyclist: 411992 Pedestrian: 3501992 Unknown: 11993 Driver: 8591993 Motorcycle pillion passenger: 161993 Motorcycle rider: 1871993 Passenger: 5131993 Pedal cyclist: 451993 Pedestrian: 3311993 Unknown: 21994 Driver: 8091994 Motorcycle pillion passenger: 141994 Motorcycle rider: 1761994 Passenger: 5011994 Pedal cyclist: 591994 Pedestrian: 3671994 Unknown: 21995 Driver: 8741995 Motorcycle pillion passenger: 101995 Motorcycle rider: 1941995 Passenger: 4911995 Pedal cyclist: 481995 Pedestrian: 3981995 Unknown: 219951996 Driver: 8691996 Motorcycle pillion passenger: 161996 Motorcycle rider: 1771996 Passenger: 4991996 Pedal cyclist: 571996 Pedestrian: 3511996 Unknown: 11997 Driver: 7761997 Motorcycle pillion passenger: 131997 Motorcycle rider: 1641997 Passenger: 4311997 Pedal cyclist: 521997 Pedestrian: 3281997 Unknown: 31998 Driver: 7411998 Motorcycle pillion passenger: 111998 Motorcycle rider: 1701998 Passenger: 4681998 Pedal cyclist: 441998 Pedestrian: 3181998 Unknown: 31999 Driver: 8201999 Motorcycle pillion passenger: 121999 Motorcycle rider: 1641999 Passenger: 4281999 Pedal cyclist: 401999 Pedestrian: 2991999 Unknown: 12000 Driver: 8522000 Motorcycle pillion passenger: 92000 Motorcycle rider: 1822000 Passenger: 4502000 Pedal cyclist: 312000 Pedestrian: 2872000 Unknown: 620002001 Driver: 7762001 Motorcycle pillion passenger: 62001 Motorcycle rider: 2102001 Passenger: 4072001 Pedal cyclist: 462001 Pedestrian: 2902001 Unknown: 22002 Driver: 7852002 Motorcycle pillion passenger: 92002 Motorcycle rider: 2152002 Passenger: 4222002 Pedal cyclist: 342002 Pedestrian: 2492002 Unknown: 12003 Driver: 7472003 Motorcycle pillion passenger: 102003 Motorcycle rider: 1782003 Passenger: 4202003 Pedal cyclist: 262003 Pedestrian: 2322003 Unknown: 82004 Driver: 7602004 Motorcycle pillion passenger: 112004 Motorcycle rider: 1842004 Passenger: 3622004 Pedal cyclist: 432004 Pedestrian: 2202004 Unknown: 32005 Driver: 7752005 Motorcycle pillion passenger: 102005 Motorcycle rider: 2232005 Passenger: 3472005 Pedal cyclist: 412005 Pedestrian: 2262005 Unknown: 520052006 Driver: 7572006 Motorcycle pillion passenger: 92006 Motorcycle rider: 2292006 Passenger: 3362006 Pedal cyclist: 392006 Pedestrian: 2282007 Driver: 7852007 Motorcycle pillion passenger: 112007 Motorcycle rider: 2262007 Passenger: 3362007 Pedal cyclist: 412007 Pedestrian: 2042008 Driver: 6702008 Motorcycle pillion passenger: 112008 Motorcycle rider: 2342008 Passenger: 3032008 Pedal cyclist: 282008 Pedestrian: 1892008 Unknown: 22009 Driver: 7072009 Motorcycle pillion passenger: 82009 Motorcycle rider: 2162009 Passenger: 3332009 Pedal cyclist: 312009 Pedestrian: 1962010 Driver: 6362010 Motorcycle pillion passenger: 102010 Motorcycle rider: 2142010 Passenger: 2842010 Pedal cyclist: 382010 Pedestrian: 1702010 Unknown: 120102011 Driver: 5682011 Motorcycle pillion passenger: 112011 Motorcycle rider: 1912011 Passenger: 2862011 Pedal cyclist: 342011 Pedestrian: 1862011 Unknown: 12012 Driver: 6102012 Motorcycle pillion passenger: 122012 Motorcycle rider: 2112012 Passenger: 2602012 Pedal cyclist: 332012 Pedestrian: 1702012 Unknown: 42013 Driver: 5562013 Motorcycle pillion passenger: 122013 Motorcycle rider: 2012013 Passenger: 2042013 Pedal cyclist: 502013 Pedestrian: 1582013 Unknown: 52014 Driver: 5322014 Motorcycle pillion passenger: 52014 Motorcycle rider: 1862014 Passenger: 2282014 Pedal cyclist: 452014 Pedestrian: 1512014 Unknown: 32015 Driver: 5552015 Motorcycle pillion passenger: 72015 Motorcycle rider: 1982015 Passenger: 2522015 Pedal cyclist: 312015 Pedestrian: 1602015 Unknown: 320152016 Driver: 6232016 Motorcycle pillion passenger: 82016 Motorcycle rider: 2412016 Passenger: 2092016 Pedal cyclist: 292016 Pedestrian: 1822016 Unknown: 22017 Driver: 5662017 Motorcycle pillion passenger: 52017 Motorcycle rider: 2062017 Passenger: 2352017 Pedal cyclist: 392017 Pedestrian: 1622017 Unknown: 102018 Driver: 5192018 Motorcycle pillion passenger: 12018 Motorcycle rider: 1902018 Passenger: 2052018 Pedal cyclist: 352018 Pedestrian: 1782018 Unknown: 72019 Driver: 5692019 Motorcycle pillion passenger: 42019 Motorcycle rider: 2082019 Passenger: 2052019 Pedal cyclist: 392019 Pedestrian: 1582019 Unknown: 32020 Driver: 5342020 Motorcycle pillion passenger: 72020 Motorcycle rider: 1802020 Passenger: 1922020 Pedal cyclist: 422020 Pedestrian: 1382020 Unknown: 420202021 Driver: 5292021 Motorcycle pillion passenger: 72021 Motorcycle rider: 2302021 Passenger: 1822021 Pedal cyclist: 422021 Pedestrian: 1332021 Unknown: 62022 Driver: 5422022 Motorcycle pillion passenger: 92022 Motorcycle rider: 2362022 Passenger: 1882022 Pedal cyclist: 352022 Pedestrian: 1622022 Unknown: 102023 Driver: 5952023 Motorcycle pillion passenger: 32023 Motorcycle rider: 2492023 Passenger: 2062023 Pedal cyclist: 332023 Pedestrian: 1572023 Unknown: 92024 Driver: 5852024 Motorcycle pillion passenger: 62024 Motorcycle rider: 2722024 Passenger: 1992024 Pedal cyclist: 372024 Pedestrian: 1742024 Unknown: 182025 Driver: 5642025 Motorcycle pillion passenger: 72025 Motorcycle rider: 2602025 Passenger: 2062025 Pedal cyclist: 512025 Pedestrian: 1952025 Unknown: 262025
DriverMotorcycle pillion passengerMotorcycle riderPassengerPedal cyclistPedestrianUnknown
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 7 August 2026. A count of rows 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.

Other versions: 2026-10-20.