Road crash locations, Queensland
liveOne row per reported road traffic crash in Queensland from 1 January 2001. The publisher includes a crash when a person was killed or injured, a vehicle was towed away, or property damage met its reporting threshold. Property damage only crashes stop after 31 December 2010. Crashes in the last 12 months of a release are preliminary because police investigations can take up to a year. Coordinates are GDA2020.
This is the largest of six tables the publisher releases together. The other five are aggregate counts by year and police region.
Part of Crash data from Queensland roads, 6 tables the publisher releases together: Road casualties, 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. Cells were typed and headers were made snake_case. The publisher's header is kept beside every field in schema.json. Rows were left alone.
| Field | Type | Publisher's header | Note |
|---|---|---|---|
| crash_ref_number | integer | Crash_Ref_Number | The publisher's identifier for the crash. Unique within a release. |
| crash_severity | string | Crash_Severity | Fatal, Hospitalisation, Medical treatment, Minor injury or Property damage only. Property damage only crashes stop after 31 December 2010. |
| crash_year | integer | Crash_Year | |
| crash_month | string | Crash_Month | Month name. |
| crash_day_of_week | string | Crash_Day_Of_Week | |
| crash_hour | integer | Crash_Hour | Hour of the day, 0 to 23. |
| crash_nature | string | Crash_Nature | For example Angle, Rear-end, Hit pedestrian. |
| crash_type | string | Crash_Type | Single Vehicle, Multi-Vehicle, Hit pedestrian or Other. |
| crash_longitude | number | Crash_Longitude | Decimal degrees, GDA2020. Blank for 598 crashes in the April 2026 release. |
| crash_latitude | number | Crash_Latitude | Decimal degrees, GDA2020. |
| crash_street | string | Crash_Street | |
| crash_street_intersecting | string | Crash_Street_Intersecting | Blank when the crash was not at an intersection. |
| state_road_name | string | State_Road_Name | Blank on locally controlled roads. |
| loc_suburb | string | Loc_Suburb | |
| loc_local_government_area | string | Loc_Local_Government_Area | |
| loc_post_code | string | Loc_Post_Code | Kept as text. |
| loc_police_division | string | Loc_Police_Division | |
| loc_police_district | string | Loc_Police_District | |
| loc_police_region | string | Loc_Police_Region | |
| loc_queensland_transport_region | string | Loc_Queensland_Transport_Region | |
| loc_main_roads_region | string | Loc_Main_Roads_Region | |
| loc_abs_statistical_area_2 | string | Loc_ABS_Statistical_Area_2 | ABS SA2 name. |
| loc_abs_statistical_area_3 | string | Loc_ABS_Statistical_Area_3 | ABS SA3 name. |
| loc_abs_statistical_area_4 | string | Loc_ABS_Statistical_Area_4 | ABS SA4 name. |
| loc_abs_remoteness | string | Loc_ABS_Remoteness | ABS remoteness class. |
| loc_state_electorate | string | Loc_State_Electorate | |
| loc_federal_electorate | string | Loc_Federal_Electorate | |
| crash_controlling_authority | string | Crash_Controlling_Authority | State-controlled, Locally-controlled, Other or Not coded. |
| crash_roadway_feature | string | Crash_Roadway_Feature | |
| crash_traffic_control | string | Crash_Traffic_Control | |
| crash_speed_limit | string | Crash_Speed_Limit | A band such as 60 km/h or 100 - 110 km/h. Kept as text because the publisher uses bands. |
| crash_road_surface_condition | string | Crash_Road_Surface_Condition | |
| crash_atmospheric_condition | string | Crash_Atmospheric_Condition | |
| crash_lighting_condition | string | Crash_Lighting_Condition | |
| crash_road_horiz_align | string | Crash_Road_Horiz_Align | Horizontal alignment. |
| crash_road_vert_align | string | Crash_Road_Vert_Align | Vertical alignment. |
| crash_dca_code | string | Crash_DCA_Code | DCA (Definitions for Coding Accidents) code. Kept as text to preserve leading zeros. |
| crash_dca_description | string | Crash_DCA_Description | |
| crash_dca_group_description | string | Crash_DCA_Group_Description | |
| dca_key_approach_dir | string | DCA_Key_Approach_Dir | Compass direction of the key vehicle. Blank in about 8,000 rows. |
| 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_total | integer | Count_Casualty_Total | |
| count_unit_car | integer | Count_Unit_Car | Number of cars involved. |
| count_unit_motorcycle_moped | integer | Count_Unit_Motorcycle_Moped | |
| count_unit_truck | integer | Count_Unit_Truck | |
| count_unit_bus | integer | Count_Unit_Bus | |
| count_unit_bicycle | integer | Count_Unit_Bicycle | |
| count_unit_pedestrian | integer | Count_Unit_Pedestrian | |
| count_unit_other | integer | Count_Unit_Other |
schema.json has the same list as a Frictionless Table Schema. The key is crash_ref_number.
A sample record
The first row of the latest version, as it appears in data.json.
GET https://publicdata.au/d/qld-road-crash-locations/latest/data.json
{
"crash_ref_number": 1,
"crash_severity": "Medical treatment",
"crash_year": 2006,
"crash_month": "November",
"crash_day_of_week": "Saturday",
"crash_hour": 17,
"crash_nature": "Hit parked vehicle",
"crash_type": "Single Vehicle",
"crash_longitude": 153.549734259921,
"crash_latitude": -28.165244516642,
"crash_street": "Boundary St",
"crash_street_intersecting": null,
"state_road_name": null,
"loc_suburb": "Coolangatta",
"loc_local_government_area": "Gold Coast City",
"loc_post_code": "4225",
"loc_police_division": "Coolangatta",
"loc_police_district": "Gold Coast",
"loc_police_region": "South Eastern",
"loc_queensland_transport_region": "SEQ South",
"loc_main_roads_region": "South Coast",
"loc_abs_statistical_area_2": "Coolangatta",
"loc_abs_statistical_area_3": "Coolangatta",
"loc_abs_statistical_area_4": "Gold Coast",
"loc_abs_remoteness": "Major Cities",
"loc_state_electorate": "Currumbin",
"loc_federal_electorate": "Mcpherson",
"crash_controlling_authority": "Locally-controlled",
"crash_roadway_feature": "No Roadway Feature",
"crash_traffic_control": "No traffic control",
"crash_speed_limit": "0 - 50 km/h",
"crash_road_surface_condition": "Sealed - Dry",
"crash_atmospheric_condition": "Clear",
"crash_lighting_condition": "Daylight",
"crash_road_horiz_align": "Straight",
"crash_road_vert_align": "Grade",
"crash_dca_code": "703",
"crash_dca_description": "Off Path-Straight: Left Off Cway Hit Obj",
"crash_dca_group_description": "16: Off Carriageway on Straight Hit Object",
"dca_key_approach_dir": "E",
"count_casualty_fatality": 0,
"count_casualty_hospitalised": 0,
"count_casualty_medically_treated": 1,
"count_casualty_minor_injury": 0,
"count_casualty_total": 1,
"count_unit_car": 2,
"count_unit_motorcycle_moped": 1,
"count_unit_truck": 0,
"count_unit_bus": 0,
"count_unit_bicycle": 0,
"count_unit_pedestrian": 0,
"count_unit_other": 0
}
Smaller files
The same rows split by a field, one JSON file each with a GeoJSON beside it. Each file carries the same provenance header.
By crash_year (25 files)
by/crash_year/index.json lists every file with its row count.
By loc_local_government_area (79 files)
by/loc_local_government_area/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 415,407 rows52 fieldsutf-8-sig975be4b02a23
versions.json · changes.json · history.tar.zst (17 MB, 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.