Australian Fatal Road Accident 1989-2021
A Countrywide Traffic Accident Dataset (1989-2021)
@kaggle.deepcontractor_australian_fatal_car_accident_data_19892021
A Countrywide Traffic Accident Dataset (1989-2021)
@kaggle.deepcontractor_australian_fatal_car_accident_data_19892021
The Australian Road Deaths Database provides basic details of road transport crash fatalities in Australia as reported by the police each month to the State and Territory road safety authorities. Road deaths from recent months are preliminary and the series is subject to revision.
The data is collected from the year 1989 to 2021, Click here to lear more about the dataset.
Bureau of Infrastructure and Transport Research Economics: The Bureau of Infrastructure and Transport Research Economics (BITRE) provides economic analysis, research and statistics on infrastructure, transport and cities issues to inform both Australian Government policy development and wider community understanding. click here
Please contact me if any part of the data is to be removed.
CREATE TABLE crash_data (
"crash_id" BIGINT,
"state" VARCHAR,
"month" BIGINT,
"year" BIGINT,
"dayweek" VARCHAR,
"time" VARCHAR,
"crash_type" VARCHAR,
"bus_involvement" VARCHAR,
"heavy_rigid_truck_involvement" VARCHAR,
"articulated_truck_involvement" VARCHAR,
"speed_limit" VARCHAR,
"road_user" VARCHAR,
"gender" VARCHAR,
"age" BIGINT,
"national_remoteness_areas" VARCHAR,
"sa4_name_2016" VARCHAR,
"national_lga_name_2017" VARCHAR,
"national_road_type" VARCHAR,
"christmas_period" VARCHAR,
"easter_period" VARCHAR,
"age_group" VARCHAR,
"day_of_week" VARCHAR,
"time_of_day" VARCHAR
);Anyone who has the link will be able to view this.