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.
There are no views created for this resource yet.
Data Dictionary
| Field Name | Name | Type | Description | Fixed Values |
|---|---|---|---|---|
| ACCIDENT_NO | Accident Number | 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. | |
| 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. | |
| VEHICLE_ID | Vehicle ID | CHAR(1) | VEHCILE_ID is a character field that uniquely identifies each vehicle involved in the accident. Vehicles have a letter value assigned to them | |
| SEX | Sex | CHAR(1) | This indicates the driver's sex and is a user editable field. | Code Description M Male F Female U Not known |
| AGE_GROUP | Age Group | VARCHAR(7) | The age grouping of the person involved in the crash | |
| INJ_LEVEL | Injury Level | CHAR(1) | 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. | Code Description 1 Fatality 2 Serious injury 3 Other injury 4 Not injured |
| INJ_LEVEL_DESC | Injury Level Desc | VARCHAR(100) | This is a character field indicates the level or degree of injury that the person has experienced as a result of the accident | Code Description 1 Fatality 2 Serious injury 3 Other injury 4 Not injured |
| SEATING_POSITION | Seating Position | CHAR(2) | This is a character field indicates where the person was located on the vehicle. This field cannot contain NULL 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 |
| HELMET_BELT_WORN | Seat Belt/Helmet Worn | CHAR(1) | 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. | 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 |
| ROAD_USER_TYPE | Road User Type | CHAR(2) | 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. | 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 |
| ROAD_USER_TYPE_DESC | Road User Type Desc | VARCHAR(100) | 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. | 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 |
| LICENCE_STATE | Licence State | CHAR(1) | This is a character field indicates the state of issue of the person s driver license. This field cannot contain NULL 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) |
| TAKEN_HOSPITAL | Taken to hospital | CHAR(1) | This is a character field indicates whether or not the person was taken to hospital. This field cannot contain NULL values. | Y Yes N No _ Not Known |
| EJECTED_CODE | Ejected Code | CHAR(1) | 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. | Code Description 0 Not applicable 1 Total ejected 2 Partially ejected 3 Partial ejection involving extraction _ Not known |
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. 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 | 3 weeks ago |
| Datastore active | True |
| Datastore contains all records of source file | True |
| Edc sync | True |
| Has views | False |
| Hash | 1852a9e57fbaa4a09b1988e2db97e355 |
| Historical | False |
| Id | 60c8fc0c-2806-40f3-bb33-5c52691120e8 |
| Ignore hash | False |
| Last updated date | 3 weeks 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-07-31 |
| Period start | 2012-01-01 |
| Position | 5 |
| Publication date | 13 years ago |
| Resource id | 60c8fc0c-2806-40f3-bb33-5c52691120e8 |
| Set url type | False |
| State | active |
| Task created | 2025-03-18 11:35:49.690680 |
| File Size | 24.7 MB |
| Temporal Coverage Start | 1 January 2012 |
| Temporal Coverage End | 31 July 2024 |