Person
The PERSON table contains the details of the people involved with an accident. There is a many-to-one relationship with the ACCIDENT table. I.e. there can be one or more people involved with one accident only. The accident_no and person_id fields are the primary keys.
Source
This data file or API can be downloaded from:
https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/60c8fc0c-2806-40f3-bb33-5c52691120e8/download/person.csvResources
Data Dictionary
Additional Information
| Field | Value |
|---|---|
| Data last updated | August 1, 2025 |
| Metadata last updated | August 3, 2025 |
| Format | CSV |
| License | Creative Commons Attribution 3.0 Australia |
| 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. 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.", "fixed_values": "", "id": "7290", "name": "Accident Number", "ref_number": "AT-7290"}, {"attribute_display_order_id": 2, "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": "7299", "name": "Person ID", "ref_number": "AT-7299"}, {"attribute_display_order_id": 3, "db_format": "CHAR(1)", "db_name": "VEHICLE_ID", "definition": "VEHCILE_ID is a character field that uniquely identifies each vehicle involved in the accident. Vehicles have a letter value assigned to them", "fixed_values": "", "id": "7298", "name": "Vehicle ID", "ref_number": "AT-7298"}, {"attribute_display_order_id": 4, "db_format": "CHAR(1)", "db_name": "SEX", "definition": "This indicates the driver's sex and is a user editable field.", "fixed_values": "Code Description M Male F Female U Not known", "id": "7245", "name": "Sex", "ref_number": "AT-7245"}, {"attribute_display_order_id": 5, "db_format": "VARCHAR(7)", "db_name": "AGE_GROUP", "definition": "The age grouping of the person involved in the crash", "fixed_values": "", "id": "7287", "name": "Age Group", "ref_number": "AT-7287"}, {"attribute_display_order_id": 6, "db_format": "CHAR(1)", "db_name": "INJ_LEVEL", "definition": "This is a character field indicates the level or degree of injury that the person has experienced as a result of the accident. It is calculated field using inj_police_level and taken_hospital. This field cannot contain NULL values.", "fixed_values": "Code Description 1 Fatality 2 Serious injury 3 Other injury 4 Not injured", "id": "7293", "name": "Injury Level", "ref_number": "AT-7293"}, {"attribute_display_order_id": 7, "db_format": "VARCHAR(100)", "db_name": "INJ_LEVEL_DESC", "definition": "This is a character field indicates the level or degree of injury that the person has experienced as a result of the accident", "fixed_values": "Code Description 1 Fatality 2 Serious injury 3 Other injury 4 Not injured", "id": "7288", "name": "Injury Level Desc", "ref_number": "AT-7288"}, {"attribute_display_order_id": 8, "db_format": "CHAR(2)", "db_name": "SEATING_POSITION", "definition": "This is a character field indicates where the person was located on the vehicle. This field cannot contain NULL values.", "fixed_values": "Code Description CF Centre-front CR Centre-rear D Driver or rider LF Left-front LR Left-rear NA Not applicable NK Not known OR Other-rear PL Pillion passenger PS Motorcycle sidecar passenger RR Right-rear", "id": "7295", "name": "Seating Position", "ref_number": "AT-7295"}, {"attribute_display_order_id": 9, "db_format": "CHAR(1)", "db_name": "HELMET_BELT_WORN", "definition": "This is a character field indicates whether or not the person was wearing a helmet or seatbelt at the time of the accident. This field cannot contain NULL values.", "fixed_values": "Code Description 1 Seatbelt worn 2 Seatbelt not worn 3 Child restraint worn 4 Child restraint not worn 5 Seatbelt/restraint not fitted 6 Crash helmet worn 7 Crash helmet not worn 8 Not appropriate 9 Not known", "id": "7265", "name": "Seat Belt/Helmet Worn", "ref_number": "AT-7265"}, {"attribute_display_order_id": 10, "db_format": "CHAR(2)", "db_name": "ROAD_USER_TYPE", "definition": "ROAD_USER_TYPE is a character field indicates what the role of the person was at the time of the accident. It is calculated field using person_status and vehicle_type from vehicle table. This field cannot contain NULL values.", "fixed_values": "Code Description 1 Pedestrian 2 Driver (of V-type 1-9 17 60-63 70-71) 3 Passenger (of V-type 1-9 17 60-63 70-71) 4 Motorcyclist 5 Pillion Passenger 6 Bicyclist (incl. passengers) 7 Other driver (V-type 14-16 99) 8 Other passenger (V-type 14-16 99) 9 Not known", "id": "7297", "name": "Road User Type", "ref_number": "AT-7297"}, {"attribute_display_order_id": 11, "db_format": "VARCHAR(100)", "db_name": "ROAD_USER_TYPE_DESC", "definition": "ROAD_USER_TYPE is a descriptive field indicates what the role of the person was at the time of the accident. It is calculated field using person_status and vehicle_type from vehicle table.", "fixed_values": "Code Description 1 Pedestrian 2 Driver (of V-type 1-9 17 60-63 70-71) 3 Passenger (of V-type 1-9 17 60-63 70-71) 4 Motorcyclist 5 Pillion Passenger 6 Bicyclist (incl. passengers) 7 Other driver (V-type 14-16 99) 8 Other passenger (V-type 14-16 99) 9 Not known", "id": "7291", "name": "Road User Type Desc", "ref_number": "AT-7291"}, {"attribute_display_order_id": 12, "db_format": "CHAR(1)", "db_name": "LICENCE_STATE", "definition": "This is a character field indicates the state of issue of the person s driver license. This field cannot contain NULL values.", "fixed_values": "A Australian Capital Territory B Commonwealth D Northern Territory N New South Wales O Overseas Q Queensland S South Australia T Tasmania V Victoria W Western Australia Z Not known _ Not available (Blank value entered)", "id": "7289", "name": "Licence State", "ref_number": "AT-7289"}, {"attribute_display_order_id": 13, "db_format": "CHAR(1)", "db_name": "TAKEN_HOSPITAL", "definition": "This is a character field indicates whether or not the person was taken to hospital. This field cannot contain NULL values.", "fixed_values": "Y Yes N No _ Not Known", "id": "7294", "name": "Taken to hospital", "ref_number": "AT-7294"}, {"attribute_display_order_id": 14, "db_format": "CHAR(1)", "db_name": "EJECTED_CODE", "definition": "This is a character field indicates whether or not the person was ejected or thrown out of the vehicle. This field cannot contain NULL values.", "fixed_values": "Code Description 0 Not applicable 1 Total ejected 2 Partially ejected 3 Partial ejection involving extraction _ Not known", "id": "7292", "name": "Ejected Code", "ref_number": "AT-7292"}] |
| Ckan url | https://discover.data.vic.gov.au |
| Dataset last updated date | 6 days ago |
| Datastore active | True |
| Datastore contains all records of source file | True |
| Edc sync | True |
| Filesize | 31,656,302 |
| Has views | True |
| Hash | d4a7dd56a083dbc33e08234fda8b5d48 |
| Historical | False |
| Id | 60c8fc0c-2806-40f3-bb33-5c52691120e8 |
| Ignore hash | False |
| Last updated date | 6 days ago |
| Mimetype | text/csv |
| Open dataset title | Person |
| Original url | https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/60c8fc0c-2806-40f3-bb33-5c52691120e8/download/person.csv |
| Package id | 4de2a60e-d87e-41cb-8bb5-bca17b7f679f |
| Period end | 2024-11-30 |
| Period start | 2012-01-01 |
| Position | 4 |
| Publication date | 14 years ago |
| Resource id | 60c8fc0c-2806-40f3-bb33-5c52691120e8 |
| Set url type | False |
| State | active |
| Task created | 2025-08-01 17:35:28.695821 |
| Zip extract | False |
| Size | Unknown |
| ID | 60c8fc0c-2806-40f3-bb33-5c52691120e8 |
| Harvested | True |
| Package ID | 4de2a60e-d87e-41cb-8bb5-bca17b7f679f |
| State | active |