Road casualties, Queensland
liveAggregate counts of people killed or injured in reported Queensland road crashes from 1 January 2001. Each row is one combination of year, police region, casualty severity, age group, gender and road user type, with the number of casualties.
Part of Crash data from Queensland roads, 6 tables the publisher releases together: Road crash locations, Queensland, Driver demographics in road crashes, Queensland, Seatbelt and helmet use in road crash casualties, Queensland, Vehicle types in road crashes, 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. |
| casualty_severity | string | Casualty_Severity | Fatality, Hospitalised, Medically treated or Minor injury. |
| casualty_age_group | string | Casualty_AgeGroup | Age band such as 17 to 24. |
| casualty_gender | string | Casualty_Gender | Female, Male or Unknown. |
| casualty_road_user_type | string | Casualty_RoadUserType | Driver, Passenger, Motorcyclist, Bicyclist, Pedestrian or Other. |
| casualty_count | integer | Casualty_Count | Number of casualties in this group. |
schema.json has the same list as a Frictionless Table Schema. The key is crash_year, crash_police_region, casualty_severity, casualty_age_group, casualty_gender, casualty_road_user_type.
A sample record
The first row of the latest version, as it appears in data.json.
GET https://publicdata.au/d/qld-road-casualties/latest/data.json
{
"crash_year": 2004,
"crash_police_region": "Brisbane",
"casualty_severity": "Minor injury",
"casualty_age_group": "40 to 49",
"casualty_gender": "Male",
"casualty_road_user_type": "Driver",
"casualty_count": 81
}
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 38,893 rows7 fieldsutf-8-sigbc9de78b77cc
versions.json · changes.json · history.tar.zst (105 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.