Dataset: Australian Fatal Road Accident 1989-2021

About this Dataset

Australian Fatal Road Accident 1989-2021

Context

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.

Content

The data is collected from the year 1989 to 2021, Click here to lear more about the dataset.

Acknowledgements

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

Data Removal

Please contact me if any part of the data is to be removed.

Tables

Crash Data

@kaggle.deepcontractor_australian_fatal_car_accident_data_19892021.crash_data

622.58 KB
52843 rows
23 columns


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
);