Name: Crash Data - Queensland, Australia 2001-2022
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

About this Dataset

Crash Data - Queensland, Australia 2001-2022

Overview:

Information on location and characteristics of crashes in Queensland for all reported Road Traffic Crashes occurred from 1 January 2001 to 31 December 2021, fatal, hospitalisation, medical treatment and minor injury crashes to 31 December 2021 and property damage only crashes to 31 December 2010.

Fatal, Hospitalisation, Medical treatment and Minor injury:

This dataset contains information on crashes reported to the police which resulted from the movement of at least 1 road vehicle on a road or road related area. Crashes listed in this resource have occurred on a public road and meet one of the following criteria:

a person is killed or injured, or
at least 1 vehicle was towed away, or
the value of the property damage meets the appropriate criteria listed below.

Property damage:

$2500 or more damage to property other than vehicles (after 1 December 1999)
$2500 or more damage to vehicle and/or other property (after 1 December 1991 and before 1 December 1999)
value of property damage is greater than $1000 (before December 1991).

Please note:

This data has been extracted from the Queensland Road Crash Database.
Information held in the Road Crash Database on events occurring within the last 12 months is considered preliminary as investigations into crashes can take up to 1 year to finalise.
Property damage only crashes ceased to be reported/recorded by Queensland Police Service after 31 December 2010.
These crash location coordinates reference the current Australian geodetic datum is GDA2020 (previously it was GDA94).

Tables

Crash Data Queensland 1 Crash Locations

@kaggle.joebeachcapital_crash_data_queensland_australia_2001_2022.crash_data_queensland_1_crash_locations

15.6 MB
367230 rows
52 columns


CREATE TABLE crash_data_queensland_1_crash_locations (
  "crash_ref_number" BIGINT,
  "crash_severity" VARCHAR,
  "crash_year" BIGINT,
  "crash_month" VARCHAR,
  "crash_day_of_week" VARCHAR,
  "crash_hour" BIGINT,
  "crash_nature" VARCHAR,
  "crash_type" VARCHAR,
  "crash_longitude" DOUBLE,
  "crash_latitude" DOUBLE,
  "crash_street" VARCHAR,
  "crash_street_intersecting" VARCHAR,
  "state_road_name" VARCHAR,
  "loc_suburb" VARCHAR,
  "loc_local_government_area" VARCHAR,
  "loc_post_code" VARCHAR,
  "loc_police_division" VARCHAR,
  "loc_police_district" VARCHAR,
  "loc_police_region" VARCHAR,
  "loc_queensland_transport_region" VARCHAR,
  "loc_main_roads_region" VARCHAR,
  "loc_abs_statistical_area_2" VARCHAR,
  "loc_abs_statistical_area_3" VARCHAR,
  "loc_abs_statistical_area_4" VARCHAR,
  "loc_abs_remoteness" VARCHAR,
  "loc_state_electorate" VARCHAR,
  "loc_federal_electorate" VARCHAR,
  "crash_controlling_authority" VARCHAR,
  "crash_roadway_feature" VARCHAR,
  "crash_traffic_control" VARCHAR,
  "crash_speed_limit" VARCHAR,
  "crash_road_surface_condition" VARCHAR,
  "crash_atmospheric_condition" VARCHAR,
  "crash_lighting_condition" VARCHAR,
  "crash_road_horiz_align" VARCHAR,
  "crash_road_vert_align" VARCHAR,
  "crash_dca_code" DOUBLE,
  "crash_dca_description" VARCHAR,
  "crash_dca_group_description" VARCHAR,
  "dca_key_approach_dir" VARCHAR,
  "count_casualty_fatality" BIGINT,
  "count_casualty_hospitalised" BIGINT,
  "count_casualty_medicallytreated" BIGINT,
  "count_casualty_minorinjury" BIGINT,
  "count_casualty_total" BIGINT,
  "count_unit_car" BIGINT,
  "count_unit_motorcycle_moped" BIGINT,
  "count_unit_truck" BIGINT,
  "count_unit_bus" BIGINT,
  "count_unit_bicycle" BIGINT,
  "count_unit_pedestrian" BIGINT,
  "count_unit_other" BIGINT
);

Crash Data Queensland A Road Casualties

@kaggle.joebeachcapital_crash_data_queensland_australia_2001_2022.crash_data_queensland_a_road_casualties

106.17 KB
32527 rows
7 columns


CREATE TABLE crash_data_queensland_a_road_casualties (
  "crash_year" BIGINT,
  "crash_police_region" VARCHAR,
  "casualty_severity" VARCHAR,
  "casualty_agegroup" VARCHAR,
  "casualty_gender" VARCHAR,
  "casualty_roadusertype" VARCHAR,
  "casualty_count" BIGINT
);

Crash Data Queensland B Driver Involvement

@kaggle.joebeachcapital_crash_data_queensland_australia_2001_2022.crash_data_queensland_b_driver_involvement

110.67 KB
19896 rows
16 columns


CREATE TABLE crash_data_queensland_b_driver_involvement (
  "crash_year" BIGINT,
  "crash_police_region" VARCHAR,
  "crash_severity" VARCHAR,
  "involving_male_driver" VARCHAR,
  "involving_female_driver" VARCHAR,
  "involving_young_driver_16_24" VARCHAR,
  "involving_senior_driver_60plus" VARCHAR,
  "involving_provisional_driver" VARCHAR,
  "involving_overseas_licensed_driver" VARCHAR,
  "involving_unlicensed_driver" VARCHAR,
  "count_crashes" BIGINT,
  "count_casualty_fatality" BIGINT,
  "count_casualty_hospitalised" BIGINT,
  "count_casualty_medicallytreated" BIGINT,
  "count_casualty_minorinjury" BIGINT,
  "count_casualty_all" BIGINT
);

Crash Data Queensland C Restraint Helmet Use

@kaggle.joebeachcapital_crash_data_queensland_australia_2001_2022.crash_data_queensland_c_restraint_helmet_use

73.23 KB
36212 rows
8 columns


CREATE TABLE crash_data_queensland_c_restraint_helmet_use (
  "crash_year" BIGINT,
  "crash_policeregion" VARCHAR,
  "casualty_severity" VARCHAR,
  "casualty_agegroup" VARCHAR,
  "casualty_gender" VARCHAR,
  "casualty_road_user_type" VARCHAR,
  "casualty_restraint_helmet_use" VARCHAR,
  "casualty_count" BIGINT
);

Crash Data Queensland D Vehicle Involvement

@kaggle.joebeachcapital_crash_data_queensland_australia_2001_2022.crash_data_queensland_d_vehicle_involvement

36.43 KB
3246 rows
12 columns


CREATE TABLE crash_data_queensland_d_vehicle_involvement (
  "crash_year" BIGINT,
  "crash_police_region" VARCHAR,
  "crash_severity" VARCHAR,
  "involving_motorcycle_moped" VARCHAR,
  "involving_truck" VARCHAR,
  "involving_bus" VARCHAR,
  "count_crashes" BIGINT,
  "count_casualty_fatality" BIGINT,
  "count_casualty_hospitalised" BIGINT,
  "count_casualty_medicallytreated" BIGINT,
  "count_casualty_minorinjury" BIGINT,
  "count_casualty_all" BIGINT
);

Crash Data Queensland E Alcohol Speed Fatigue Defect

@kaggle.joebeachcapital_crash_data_queensland_australia_2001_2022.crash_data_queensland_e_alcohol_speed_fatigue_defect

42.4 KB
4799 rows
13 columns


CREATE TABLE crash_data_queensland_e_alcohol_speed_fatigue_defect (
  "crash_year" BIGINT,
  "crash_police_region" VARCHAR,
  "crash_severity" VARCHAR,
  "involving_drink_driving" VARCHAR,
  "involving_driver_speed" VARCHAR,
  "involving_fatigued_driver" VARCHAR,
  "involving_defective_vehicle" VARCHAR,
  "count_crashes" BIGINT,
  "count_fatality" BIGINT,
  "count_hospitalised" BIGINT,
  "count_medically_treated" BIGINT,
  "count_minor_injury" BIGINT,
  "count_all_casualties" BIGINT
);