publicdata.auby National Digital publicdata.au on GitHub
Datasets / Factors in road crashes, Queensland / 2026-04-24

Factors in road crashes, Queensland, version 2026-04-24

latest
As at 30 June 2025Rows 5,523Fields 13Fetched 24 September 2026Source SHA-256 35813538985c9d86…

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.csv, byte for byte.

About this version

Files rebuilt on 25 September 2026 so every one carries the operator and a ready-made cite string in its provenance header, and to add the Excel, Arrow, GeoPackage, gzipped CSV, SQL and CSVW files. Rows unchanged.

Files

  • data.arrow65 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.csv391 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.json3.9 KB
  • data.csv.gz44 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.json2.0 MB JSON: One object with a publicdata header (publisher, licence, attribution, version, source hash), a fields list and a records array of 5,523 objects with typed values. Blank cells are null.
  • data.ndjson2.0 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.parquet39 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.sqlite512 KB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
  • data.xlsx255 KB Excel: One workbook with a records sheet of 5,523 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.7 KB
  • schema.json2.3 KB
  • schema.sql1.3 KB
  • source.csv322 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.

Smaller files by field: by/crash_year/.

Attribution the licence asks for

Department of Transport and Main Roads, Queensland Government, Crash data from Queensland roads, sourced 24 September 2026, https://www.data.qld.gov.au/dataset/crash-data-from-queensland-roads, licensed under CC BY 4.0.

Provenance

Fetched from www.data.qld.gov.au on 24 September 2026. The portal listed the licence as Creative Commons Attribution 4.0 at that moment. manifest.json has every detail.

05k10k15k2001 Fatal: 2962001 Hospitalisation: 4,2262001 Medical treatment: 5,9272001 Minor injury: 3,4182002 Fatal: 2832002 Hospitalisation: 4,4742002 Medical treatment: 5,7292002 Minor injury: 3,3352003 Fatal: 2842003 Hospitalisation: 4,5872003 Medical treatment: 5,4862003 Minor injury: 3,29520032004 Fatal: 2892004 Hospitalisation: 4,9852004 Medical treatment: 5,4652004 Minor injury: 3,2212005 Fatal: 2962005 Hospitalisation: 5,1332005 Medical treatment: 5,4302005 Minor injury: 3,0692006 Fatal: 3132006 Hospitalisation: 4,8532006 Medical treatment: 5,5222006 Minor injury: 3,36020062007 Fatal: 3382007 Hospitalisation: 5,0302007 Medical treatment: 5,5332007 Minor injury: 3,8092008 Fatal: 2942008 Hospitalisation: 5,5272008 Medical treatment: 5,8322008 Minor injury: 3,1172009 Fatal: 2962009 Hospitalisation: 5,4702009 Medical treatment: 5,7742009 Minor injury: 2,47720092010 Fatal: 2362010 Hospitalisation: 5,2532010 Medical treatment: 5,3952010 Minor injury: 2,4662011 Fatal: 2272011 Hospitalisation: 5,2062011 Medical treatment: 5,1142011 Minor injury: 2,1422012 Fatal: 2552012 Hospitalisation: 5,3332012 Medical treatment: 5,4032012 Minor injury: 1,75820122013 Fatal: 2462013 Hospitalisation: 5,6612013 Medical treatment: 5,5102013 Minor injury: 1,3202014 Fatal: 1992014 Hospitalisation: 5,4172014 Medical treatment: 5,5362014 Minor injury: 1,5022015 Fatal: 2202015 Hospitalisation: 5,0582015 Medical treatment: 5,7742015 Minor injury: 1,10720152016 Fatal: 2382016 Hospitalisation: 5,1942016 Medical treatment: 5,7692016 Minor injury: 1,3522017 Fatal: 2272017 Hospitalisation: 5,3082017 Medical treatment: 5,4022017 Minor injury: 1,7982018 Fatal: 2242018 Hospitalisation: 5,5612018 Medical treatment: 5,3212018 Minor injury: 1,85220182019 Fatal: 1992019 Hospitalisation: 5,6572019 Medical treatment: 5,2542019 Minor injury: 1,8552020 Fatal: 2512020 Hospitalisation: 5,6992020 Medical treatment: 4,4622020 Minor injury: 1,7352021 Fatal: 2462021 Hospitalisation: 6,3392021 Medical treatment: 4,8402021 Minor injury: 2,05120212022 Fatal: 2742022 Hospitalisation: 6,1142022 Medical treatment: 4,5052022 Minor injury: 2,1282023 Fatal: 2602023 Hospitalisation: 6,7192023 Medical treatment: 4,5142023 Minor injury: 2,1292024 Fatal: 2732024 Hospitalisation: 7,0512024 Medical treatment: 4,4092024 Minor injury: 2,6252024
FatalHospitalisationMedical treatmentMinor injury
Crashes per year by severity, 2001 to 2024. Rows where severity is not Property damage only are drawn. 2025 is not drawn because the file runs to 30 June 2025. A sum of the crashes 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 crash_year, crash_police_region, crash_severity, involving_drink_driving, involving_driver_speed, involving_fatigued_driver, involving_defective_vehicle, with a link to the diff file.