Vehicle types in road crashes, Queensland
liveAggregate counts of reported Queensland road crashes from 1 January 2001 by the kinds of vehicle involved. Each row is one combination of year, police region, crash severity and three yes or no vehicle flags.
Part of Crash data from Queensland roads, 6 tables the publisher releases together: Road crash locations, Queensland, Road casualties, Queensland, Driver demographics in road crashes, Queensland, Seatbelt and helmet use in road crash casualties, Queensland, Factors in road crashes, Queensland.
What is in it
Column names are made snake_case and the publisher's original header is kept beside each one. Blank cells are null. Nothing is added, removed, ranked or summarised.
| Field | Type | Publisher's header | Note |
|---|---|---|---|
| crash_year | integer | Crash_Year | |
| crash_police_region | string | Crash_Police_Region | Queensland Police Service region, or Unknown. |
| crash_severity | string | Crash_Severity | Fatal, Hospitalisation, Medical treatment, Minor injury or Property damage only. |
| involving_motorcycle_moped | boolean | Involving_Motorcycle_Moped | |
| involving_truck | boolean | Involving_Truck | |
| involving_bus | boolean | Involving_Bus | |
| count_crashes | integer | Count_Crashes | |
| count_casualty_fatality | integer | Count_Casualty_Fatality | |
| count_casualty_hospitalised | integer | Count_Casualty_Hospitalised | |
| count_casualty_medically_treated | integer | Count_Casualty_MedicallyTreated | |
| count_casualty_minor_injury | integer | Count_Casualty_MinorInjury | |
| count_casualty_all | integer | Count_Casualty_All |
schema.json has the same list as a Frictionless Table Schema. The key is crash_year, crash_police_region, crash_severity, involving_motorcycle_moped, involving_truck, involving_bus.
A sample record
The first row of the latest version, as it appears in data.json.
GET https://publicdata.au/d/qld-road-crash-vehicle-types/latest/data.json
{
"crash_year": 2001,
"crash_police_region": "Brisbane",
"crash_severity": "Fatal",
"involving_motorcycle_moped": false,
"involving_truck": false,
"involving_bus": false,
"count_crashes": 36,
"count_casualty_fatality": 38,
"count_casualty_hospitalised": 18,
"count_casualty_medically_treated": 1,
"count_casualty_minor_injury": 0,
"count_casualty_all": 57
}
Smaller files
The same rows split by a field, one JSON file each. Each file carries the same provenance header.
By crash_year (25 files)
by/crash_year/index.json lists every file with its row count.
What changed
One version for every release the publisher has made since this site started following the dataset. The date is the day the file changed on the portal. The "as at" date is the publisher's own.
- 2026-04-24as at 30 June 2025 3,764 rows12 fieldsutf-8-sigb2049cf5fb0d
versions.json · changes.json · history.tar.zst (28 KB, every version's Parquet and manifest)
What this site did to the data. Cells were typed, headers were renamed and the encoding was made UTF-8. Rows were left alone. The publisher's file sits beside every version as source.csv so the change can be checked.
The publisher releases Crash data from Queensland roads as 6 files at once, so all 6 tables here share a version date.