Accident Event
The ACCIDENT_EVENT table contains information about sequence of accident events. There is a one-to-many relationship with the ACCIDENT table. The accident_no and event_seq_no fields are the primary keys.
There are no views created for this resource yet.
Data Dictionary
| Field Name | Name | Type | Description | Fixed Values |
|---|---|---|---|---|
| ACCIDENT_NO | ACCIDENT_NO | CHAR(12) | ACCIDENT_NO is the Primary Key for the database to uniquely identify the accident and cannot contain NULL values. First character T indicates TIS incident and characters 2-5 typically represent the year in which the accident created in TIS system and characters 6-11 are a numeric sequencing number | |
| EVENT_SEQ_NO | SEQUENCE | INTEGER(10) | EVENT_SEQ_NO is an integer field that starts with 1 and incremented for more than one event in the same accident. This field cannot contain NULL values. | |
| EVENT_TYPE | EVENT TYPE | CHAR(1) | EVENT_TYPE is a character field indicates type of incident event. This field cannot contain NULL values. | 0 Not applicable 1 Rollover on/off carriageway 2 Fell from vehicle 3 Ran off carriageway 4 Mechanical failure 5 Struck by stone/projectile/load 6 Fell in vehicle 8 Other 9 Not known C Collision |
| EVENT_TYPE_DESC | EVENT TYPE DESC | VARCHAR(100) | Is a descriptive field that indicates type of incident event. This field cannot contain NULL values. | 0 Not applicable 1 Rollover on/off carriageway 2 Fell from vehicle 3 Ran off carriageway 4 Mechanical failure 5 Struck by stone/projectile/load 6 Fell in vehicle 8 Other 9 Not known C Collision |
| VEHICLE_1_ID | FIRST PARTICIPANT VEHICLE ID | CHAR(1) | VEHICLE_1_ID is character field indicates first vehicle involved in the event. Vehicle ID has a letter value assigned to them. This field cannot contain NULL values. | |
| VEHICLE_1_COLL_PT | POINT OF COLLISION 1 | CHAR(1) | VEHICLE_1_COLL_PT is a character field indicates collision point on the vehicle. This field cannot contain NULL values. | |
| VEHICLE 1 COLL PT DESC | VEHICLE 1 COLL PT DESC | VARCHAR(100) | Its a descriptive field that indicates collision point on the vehicle. This field cannot contain NULL values. | 0 Towed unit 1 Right front corner 2 Right side (forwards) 3 Right side (rearwards) 4 Right rear corner 5 Left front corner 6 Left side (forwards) 7 Left side (rearwards) 8 Left rear corner 9 Not known or Not Applicable F Front N None R Rear S Sidecar T Top/Roof U Undercarriage |
| VEHICLE_2_ID | SECOND PARTICIPANT VEHICLE ID | CHAR(1) | VEHICLE_2_ID is character field indicates second vehicle involved in the event. Vehicle ID has a letter value assigned to them. This field cannot contain NULL values | |
| VEHICLE_2_COLL_PT | POINT OF COLLISION 2 | CHAR(1) | VEHICLE_2_COLL_PT is a character field indicates collision point on the vehicle. This field cannot contain NULL values. | |
| VEHICLE 2 COLL PT DESC | VEHICLE 2 COLL PT DESC | VARCHAR(100) | It's a descriptive field that indicates collision point on the vehicle. This field cannot contain NULL values. | 0 Towed unit 1 Right front corner 2 Right side (forwards) 3 Right side (rearwards) 4 Right rear corner 5 Left front corner 6 Left side (forwards) 7 Left side (rearwards) 8 Left rear corner 9 Not known or Not Applicable F Front N None R Rear S Sidecar T Top/Roof U |
| PERSON_ID | PERSON_ID | CHAR(2) | Uniquely identifies each person involved in the accident. Persons who are drivers of a vehicle have a letter value assigned to them and persons who are not drivers have a numerical value assigned to them. | |
| OBJECT_TYPE | OBJECT TYPE | CHAR(2) | OBJECT_TYPE is a character field that identifies object involved in the specific accident event. This field cannot contain NULL values. | 1 Pole (telephone/electricity) 2 Tree (shrub/scrub) 3 Fence/Wall (including gates) 17 Traffic island |
| OBJECT_TYPE_DESC | OBJECT TYPE DESC | VARCHAR(100) | It's a descriptive field that identifies object involved in the specific accident event. This field cannot contain NULL values. | 1 Pole (telephone/electricity) 2 Tree (shrub/scrub) 3 Fence/Wall (including gates) 17 Traffic island |
Additional Information
| Field | Value |
|---|---|
| Data last updated | 18 March 2025 |
| Metadata last updated | 18 March 2025 |
| Created | 18 March 2025 |
| Format | CSV |
| License | Creative Commons Attribution 4.0 International |
| Attributes | [{"attribute_display_order_id": 1, "db_format": "CHAR(12)", "db_name": "ACCIDENT_NO", "definition": "ACCIDENT_NO is the Primary Key for the database to uniquely identify the accident and cannot contain NULL values.\nFirst character T indicates TIS incident and characters 2-5 typically represent the year in which the accident created in TIS system and characters 6-11 are a numeric sequencing number", "fixed_values": "", "id": "7215", "name": "ACCIDENT_NO", "ref_number": "AT-7215"}, {"attribute_display_order_id": 2, "db_format": "INTEGER(10)", "db_name": "EVENT_SEQ_NO", "definition": "EVENT_SEQ_NO is an integer field that starts with 1 and incremented for more than one event in the same accident. This field cannot contain NULL values.", "fixed_values": "", "id": "7221", "name": "SEQUENCE", "ref_number": "AT-7221"}, {"attribute_display_order_id": 3, "db_format": "CHAR(1)", "db_name": "EVENT_TYPE", "definition": "EVENT_TYPE is a character field indicates type of incident event. This field cannot contain NULL values.", "fixed_values": "0 Not applicable 1 Rollover on/off carriageway 2 Fell from vehicle 3 Ran off carriageway 4 Mechanical failure 5 Struck by stone/projectile/load 6 Fell in vehicle 8 Other 9 Not known C Collision", "id": "7217", "name": "EVENT TYPE", "ref_number": "AT-7217"}, {"attribute_display_order_id": 4, "db_format": "VARCHAR(100)", "db_name": "EVENT_TYPE_DESC", "definition": "Is a descriptive field that indicates type of incident event. This field cannot contain NULL values.", "fixed_values": "0 Not applicable 1 Rollover on/off carriageway 2 Fell from vehicle 3 Ran off carriageway 4 Mechanical failure 5 Struck by stone/projectile/load 6 Fell in vehicle 8 Other 9 Not known C Collision", "id": "7473", "name": "EVENT TYPE DESC", "ref_number": "AT-7473"}, {"attribute_display_order_id": 5, "db_format": "CHAR(1)", "db_name": "VEHICLE_1_ID", "definition": "VEHICLE_1_ID is character field indicates first vehicle involved in the event. Vehicle ID has a letter value assigned to them. This field cannot contain NULL values.", "fixed_values": "", "id": "7219", "name": "FIRST PARTICIPANT VEHICLE ID", "ref_number": "AT-7219"}, {"attribute_display_order_id": 6, "db_format": "CHAR(1)", "db_name": "VEHICLE_1_COLL_PT", "definition": "VEHICLE_1_COLL_PT is a character field indicates collision point on the vehicle. This field cannot contain NULL values.", "fixed_values": "", "id": "7216", "name": "POINT OF COLLISION 1", "ref_number": "AT-7216"}, {"attribute_display_order_id": 7, "db_format": "VARCHAR(100)", "db_name": "VEHICLE 1 COLL PT DESC", "definition": "Its a descriptive field that indicates collision point on the vehicle. This field cannot contain NULL values.", "fixed_values": "0 Towed unit 1 Right front corner 2 Right side (forwards) 3 Right side (rearwards) 4 Right rear corner 5 Left front corner 6 Left side (forwards) 7 Left side (rearwards) 8 Left rear corner 9 Not known or Not Applicable F Front N None R Rear S Sidecar T Top/Roof U Undercarriage", "id": "7475", "name": "VEHICLE 1 COLL PT DESC", "ref_number": "AT-7475"}, {"attribute_display_order_id": 8, "db_format": "CHAR(1)", "db_name": "VEHICLE_2_ID", "definition": "VEHICLE_2_ID is character field indicates second vehicle involved in the event. Vehicle ID has a letter value assigned to them. This field cannot contain NULL values", "fixed_values": "", "id": "7222", "name": "SECOND PARTICIPANT VEHICLE ID", "ref_number": "AT-7222"}, {"attribute_display_order_id": 9, "db_format": "CHAR(1)", "db_name": "VEHICLE_2_COLL_PT", "definition": "VEHICLE_2_COLL_PT is a character field indicates collision point on the vehicle. This field cannot contain NULL values.", "fixed_values": "", "id": "7213", "name": "POINT OF COLLISION 2", "ref_number": "AT-7213"}, {"attribute_display_order_id": 10, "db_format": "VARCHAR(100)", "db_name": "VEHICLE 2 COLL PT DESC", "definition": "It's a descriptive field that indicates collision point on the vehicle. This field cannot contain NULL values.", "fixed_values": "0 Towed unit 1 Right front corner 2 Right side (forwards) 3 Right side (rearwards) 4 Right rear corner 5 Left front corner 6 Left side (forwards) 7 Left side (rearwards) 8 Left rear corner 9 Not known or Not Applicable F Front N None R Rear S Sidecar T Top/Roof U", "id": "7474", "name": "VEHICLE 2 COLL PT DESC", "ref_number": "AT-7474"}, {"attribute_display_order_id": 11, "db_format": "CHAR(2)", "db_name": "PERSON_ID", "definition": "Uniquely identifies each person involved in the accident. Persons who are drivers of a vehicle have a letter value assigned to them and persons who are not drivers have a numerical value assigned to them.", "fixed_values": "", "id": "7218", "name": "PERSON_ID", "ref_number": "AT-7218"}, {"attribute_display_order_id": 12, "db_format": "CHAR(2)", "db_name": "OBJECT_TYPE", "definition": "OBJECT_TYPE is a character field that identifies object involved in the specific accident event. This field cannot contain NULL values.", "fixed_values": "1 Pole (telephone/electricity) 2 Tree (shrub/scrub) 3 Fence/Wall (including gates) 17 Traffic island", "id": "7214", "name": "OBJECT TYPE", "ref_number": "AT-7214"}, {"attribute_display_order_id": 13, "db_format": "VARCHAR(100)", "db_name": "OBJECT_TYPE_DESC", "definition": "It's a descriptive field that identifies object involved in the specific accident event. This field cannot contain NULL values.", "fixed_values": "1 Pole (telephone/electricity) 2 Tree (shrub/scrub) 3 Fence/Wall (including gates) 17 Traffic island", "id": "7476", "name": "OBJECT TYPE DESC", "ref_number": "AT-7476"}] |
| Ckan url | https://discover.data.vic.gov.au |
| Dataset last updated date | 3 weeks ago |
| Datastore active | True |
| Datastore contains all records of source file | True |
| Edc sync | True |
| Has views | False |
| Hash | 094c7c4adaedad00043bbfa3c974b820 |
| Historical | False |
| Id | b83605e0-cb32-49a2-9c3d-3d17544f2a3d |
| Ignore hash | False |
| Last updated date | 3 weeks ago |
| Mimetype | text/csv |
| Open dataset title | Accident Event |
| Original url | https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/b83605e0-cb32-49a2-9c3d-3d17544f2a3d/download/accident_event.csv |
| Package id | 4de2a60e-d87e-41cb-8bb5-bca17b7f679f |
| Period end | 2024-07-31 |
| Period start | 2012-01-01 |
| Position | 2 |
| Publication date | 13 years ago |
| Resource id | b83605e0-cb32-49a2-9c3d-3d17544f2a3d |
| Set url type | False |
| State | active |
| Task created | 2025-03-18 11:35:49.318410 |
| File Size | 23.7 MB |
| Temporal Coverage Start | 1 January 2012 |
| Temporal Coverage End | 31 July 2024 |