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

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. This field cannot contain NULL values.
VEHICLE_YEAR_MANUF Vehicle Year of Manufacture INTEGER(10) VEHICLE_YEAR_MANUF is an integer field indicates the year in which the vehicle was built or manufactured. The data is stored in yyyy format.
VEHICLE_DCA_CODE Vehicle DCA Code CHAR(1) VEHICLE_DCA_CODE is a character field indicates that links the vehicle with the movement depicted in the DCA table. For example, if the DCA code for the accident is 111 and the vehicle DCA code is 2, then an inspection of the DCA chart will show that the second vehicle involved in the accident was turning right. Code Description 1 Vehicle 1 2 Vehicle 2 3 Not known which vehicle was number 1 8 Not involved in initial event
INITIAL_DIRECTION Initial Direction CHAR(2) INTIAL_DIRECTION is a character field indicates the initial or first direction of travel of the vehicle. For a vehicle that is turning, the initial direction will be different to the final direction. For a non-turning vehicle, the initial direction will be the same as the final direction. Code Description E East N North NE North east NW North west S South SE South east SW South west W West NK Not known
ROAD_SURFACE_TYPE Road Surface Type CHAR(1) Road surface type describes the type of road surface the crash occurred on (e.g. paved, unpaved, gravel etc) Code Description 1 Paved 2 Unpaved 3 Gravel 9 Not known
ROAD_SURFACE_TYPE_DESC Road Surface Type Description VARCHAR(100) Road surface type its a descriptive field that describes the type of road surface the crash occurred on (e.g. paved, unpaved, gravel etc) Code Description 1 Paved 2 Unpaved 3 Gravel 9 Not known
REG_STATE Registration State CHAR(1) REG_STATE is a character field indicates the state which is the vehicle is registered in. This field will also indicate if the registration is overseas. 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 _ (Blank value entered)/Not available
VEHICLE_BODY_STYLE Vehicle Body Style CHAR(6) VEHICLE_BODY_STYLE is a character field indicates the body type of the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. This field cannot contain NULL values. Code Description AFRAME A Frame AG IMP Agricultural Implement For Prim.Prod. AMB Ambulance Emergency Vehicle AMPHIB Amphibian Land And Water Craft AMUS Amusement ARM V Armoured Vehicle B BIN Bulk Bin B HOE Back Hoe B TR Boat Trailer B/TR Boat Trailer BD/PMR B Double Prime Mover (Feds Only) BOX Box Trailer BUGGY Buggy Beach Buggy, Golf Buggy BUS Bus Used For Passenger Carriage C CAR Car Carrier Used For Car Carriage C MIX Concrete Mixer CARAVN Caravan CARVN Mobile Caravan Self Propelled Caravan CHAIR Motor Chair Motorized Wheelchair COMPAC Compactor CONT C Container Carrier CONVRT Convertible Car with removable top COUPE Coupe Car With 2 Doors CRANE Mobile Crane CYCLE Motor Cycle DITCH Ditch Witch DOLLY Dolly DOZER Bulldozer DUMPER Dumper EDUCTR Eductor EXCVTR Excavator F LIFT Fork Lift F UNIT Fire Unit FLOAT Moomba Float FLUSH Flusher FRAME Frame G UNIT Garbage Unit GRADER Grader H FLT Horse Float H/FLT Horse Float HEARSE Hearse HOE B Hoe HOR FL Horse Float IND/CN Individual Construction INDCON Individual Construction JEEP Jeep JINKER Jinker L FRM Log Frame (Rigid) L LOAD Low Loader L MARK Line Marker LADDER Ladder Truck LOADER Loader M BILL Mobile Billboard M CCH Mourning Coach M STDO Mobile Studio M STND Mobile Grandstand MACH Machine MACHNE Machine MISC Miscellaneous MOPED Motor Cycle MOWER Mower MULTI Multi MULTIX Multix OF SHD Office Shed OF/SHD Office Shed OUTFIT Motor Cycle P CARR Personnell Carrier P MVR Prime Mover P VAN Panel Van PMAMUS Prime Mover Amusement R AMUS Rigid Amusement RDSTR Roadster Convertible with 2 seats RLINER Road Liner ROLLER Roller S AMB Semi Ambulance S AMRV Semi Armoured Vehicle S AMUS Semi Amusement Vehicle S BULK Semi Bulk Bin S CAR Semi Car Carrier S CONT Semi Container Carrier S CRVN Semi Mobile Caravan S DCMP Semi Decompression Chamber S FLSH Semi Flusher S FLT Semi Float S FRM Semi Frame S JINK Semi Timber Jinker S LOAD Semi Loader S MACH Semi Machine S SERV Semi Service S SPRD Semi Lime Spreader S SPRY Semi Sprayer S TANK Semi Tanker S TRL Semi Trailer S TTWR Semi Travel Tower S VAN Semi Trailer Van S WAG Station Wagon Car With Internal Boot SCOOP Shovel SCOOTR Scooter SED Sedan - Car with external boot SEDAN Sedan - Car with external boot SWV1 Quad Bike SWV2 4 Wheel Drive – All Terrain Vehicle
VEHICLE_MAKE Vehicle Make CHAR(6) VEHICLE_MAKE is a character field indicates the vehicle make or manufacturer. This field cannot contain NULL values. Code Description AEC A E C ALBION Albion ALFA R Alfa Romeo ALLARD Allard ALLIS Allis ANSAIR Ansair ASI A S I ASIA Asia ASTON Aston Martin ATHEY Athey ATKINS Atkinson AUDI Audi AUSTIN Austin AUSTRL Austral B KNOX Blaw Knox BED Bedford BED IS Bedford Isuzu BELARS Belarus BENFRD Benford BENT Bentley BERL Berliet BHB B H B BMW B M W BOMBDR Bombardier BSA B S A BUICK Buick CAD Cadillac CASE Case CATPLR Caterpillar CHAMB Chamberlain CHAMP Champion CHEV Chevrolet CHRYS Chrysler CITRN Citroen COLES Coles COMMER Commer CONQ Conquip CUMMIN Cummins D BRN David Brown DAEWOO Daewoo DAF D A F DAIHAT Diahatsu DAIM Daimler DATSUN Datsun DENING Denning DENNIS Dennis DETOM Detomaso DEUTZ Deutz DIA R Diamond Reo DIA T Diamond T DIAMON Diamond DIATTO Diatto DODGE Dodge DOMINO Domino DYNAPC Dynapac ENFLD Enfield ERF E R F ESSEX Essex EUNOS Eunos500 EUREKA Eureka F LINE Freightliner FENDT Fendt FERG Ferguson FERRAR Ferrari FIAT Fiat FMC F M C FORD Ford FORDSN Fordson FRANNA Franna FRGHTR Freighter-Lawton FRMLNR Farmliner FSM F S M FUJI Fuji FURUKA Furukawa GALANT Galant(Chrysler) GALION Galion GMC G M C GRAD Gradall H COCK Hancock H DAV Harley Davidson H MADE Homemade HAFL Haflinger HANOM Hanomag HILL Hillman HITACH Hitachi HOLDEN Holden HSQVRN Husqvarna HUST Hustler HYNDAI Hyundai HYSTER Hyster I RAND Ingerson Rand INTERN International ISEKI Iseki ISUZU Isuzu J DEER John Deere JAGUAR Jaguar JBJ J B J JCB J C B JEEP Jeep JENSEN Jensen KATO Kato KAWASA Kawasaki KENWTH Kenworth KIA Kia L ROV Land Rover LADA Lada LOTUS Lotus MAZDA Mazda MERC B Mercedes-Benz NISSAN Nissan OLDS Oldsmobile PEUGEOT Peugeot PONT Pontiac PORSCH Porsche R ROV Range Rover RAMBLR Rambler REN Renault ROLLS Rolls-Royce ROVER Rover SAAB Saab SUBARU Subaru SUZUKI Suzuki TOYOTA Toyota VOLKS Volkswagen VOLVO Volvo YAMAHA Yamaha
VEHICLE_MODEL Vehicle Model CHAR(6) VEHICLE_MODEL is a character field indicates the model of the vehicle. E.g. FALCON 0 Unknown 66 Sleeper 75 Tow
VEHICLE_POWER Vehicle Power INTEGER(10) VEHICLE_POWER is an integer field indicating the power of the vehicle, in CCs or horsepower. For motor cycles, motor scooters and mopeds, the units will be CCs and for all other vehicles the units are rated horsepower. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. Code Description 0 Unknown 1-1000 Horsepower 1-9999 CCs
VEHICLE_TYPE Vehicle Type CHAR(2) VEHICLE_TYPE is a character field indicates the type or category of vehicle. This field cannot contain NULL values. Code Description 01 Car 02 Station wagon 03 Taxi 04 Utility 05 Panel van 06 Prime Mover (No of Trailers Unknown) 07 Rigid Truck (Weight Unknown) 08 Bus/coach 09 Mini bus (9 13) seats 10 Motor cycle 11 Moped 12 Motor scooter 13 Bicycle 14 Horse (ridden or drawn ) 15 Tram 16 Train 17 Other vehicle 18 Not Applicable 19 Parked Trailers 20 Quad Bike 27 Plant machinery and Agricultural equipment 60 Prime Mover Only 61 Prime Mover – Single Trailer 62 Prime Mover – B-Double 63 Prime Mover B-Triple 71 Light Commercial Vehicle (Rigid) <= 4.5="" tonnes="" gvm="" 72="" heavy="" vehicle="" (rigid)=""> 4.5 Tonnes 99 Not known
VEHICLE_TYPE_DESC Vehicle Type Description VARCHAR(100) VEHICLE_TYPE_DESC is a descriptive field that indicates the type or category of vehicle. This field cannot contain NULL values. Code Description 01 Car 02 Station wagon 03 Taxi 04 Utility 05 Panel van 06 Prime Mover (No of Trailers Unknown) 07 Rigid Truck (Weight Unknown) 08 Bus/coach 09 Mini bus (9 13) seats 10 Motor cycle 11 Moped 12 Motor scooter 13 Bicycle 14 Horse (ridden or drawn ) 15 Tram 16 Train 17 Other vehicle 18 Not Applicable 19 Parked Trailers 20 Quad Bike 27 Plant machinery and Agricultural equipment 60 Prime Mover Only 61 Prime Mover – Single Trailer 62 Prime Mover – B-Double 63 Prime Mover B-Triple 71 Light Commercial Vehicle (Rigid) <= 4.5="" tonnes="" gvm="" 72="" heavy="" vehicle="" (rigid)=""> 4.5 Tonnes 99 Not known
VEHICLE_WEIGHT Vehicle Weight INTEGER(10)

VEHICLE_WEIGHT is an integer field indicating the weight or mass of the vehicle. The unit of measurement is kilograms.

NULL values are valid entries.

Code Description 01 Car 02 Station wagon 03 Taxi 04 Utility 05 Panel van 06 Prime Mover (No of Trailers Unknown) 07 Rigid Truck (Weight Unknown) 08 Bus/coach 09 Mini bus (9 13) seats 10 Motor cycle 11 Moped 12 Motor scooter 13 Bicycle 14 Horse (ridden or drawn ) 15 Tram 16 Train 17 Other vehicle 18 Not Applicable 60 Prime Mover Only 61 Prime Mover – Single Trailer 62 Prime Mover – B-Double 63 Prime Mover B-Triple 71 Light Commercial Vehicle (Rigid) <= 4.5="" tonnes="" gvm="" 72="" heavy="" vehicle="" (rigid)=""> 4.5 Tonnes 99 Not known
CONSTRUCTION_TYPE Construction Type CHAR(1) CONSTRUCTION_TYPE is a character field indicates the construction or formation of the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. This field cannot contain NULL values. A Articulated P Interpretation is not known R Rigid _ (Blank value entered) Unknown
FUEL_TYPE Fuel Type CHAR(1) FUEL_TYPE is a character field indicates the type of fuel used by the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. This field cannot contain NULL values. Code Description D Diesel E Electric G Gas M Multi P Petrol R Rotary Z Unknown
NO_OF_WHEELS Number of Wheels INTEGER(10) NO_OF_WHEELS is an integer field indicates the number of wheels that the vehicle has. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. NULL values are valid entries.
NO_OF_CYLINDERS Number of Cylinders INTEGER(10) NO_OF_CYLINDERS is an integer field indicates the number of engine cylinders that the vehicle has. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. NULL values are valid entries.
SEATING_CAPACITY Seating Capacity INTEGER(10) SEATING_CAPACITY is an integer field indicates the number of seats in the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. NULL values are valid entries.
TARE_WEIGHT Tare Weight INTEGER(10) TARE_WEIGHT is an integer field indicates the tare or unladen weight of the vehicle. The unit of measurement is kilograms. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. NULL values are valid entries.
TOTAL_NO_OCCUPANTS Total Number of Occupants INTEGER(10) TOTAL_NO_OCCUPANTS is an integer field indicates the number of occupants or people in the vehicle at the time of the accident. NULL values are valid entries.
CARRY_CAPACITY Carry Capacity INTEGER(10)

CARRY_CAPACITY is an integer field indicates the carry or load capacity of the vehicle. The unit of measurement is kilograms. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name.

NULL values are valid entries.

CUBIC_CAPACITY Cubic Capacity INTEGER(10) CONSTRUCTION_TYPE is a character field indicates the construction or formation of the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. This field cannot contain NULL values.
FINAL_DIRECTION Final Direction CHAR(2) FINAL_DIRECTION is a character field indicates the final or last direction of travel of the vehicle. For a vehicle that is turning, the initial direction will be different to the final direction. For a non-turning vehicle, the initial direction will be the same as the final direction. Code Description E East N North NE North east NW North west S South SE South east SW South west W West NK Not known
DRIVER_INTENT Driver Intent CHAR(2) DRIVER_INTENT is a character field indicates what the driver of the vehicle was attempting to undertake at the time of the accident. This information is meant to obtain via an interview of the vehicle's driver.. Code Description 01 Going straight ahead 02 Turning right 03 Turning left 04 Leaving a driveway 05 'U' turning 06 Changing lanes 07 Overtaking 08 Merging 09 Reversing 10 Parking or unparking 11 Parked legally 12 Parked illegally 13 Stationary accident 14 Stationary broken down 15 Other stationary 16 Avoiding animals 17 Slow/stopping 18 Out of control 19 Wrong way 99 Not known
VEHICLE_MOVEMENT Vehicle Movement CHAR(2) VEHICLE_MOVEMENT is a character field indicates the actual movement of the vehicle prior to the accident. Code Description 01 Going straight ahead 02 Turning right 03 Turning left 04 Leaving a driveway 05 'U' turning 06 Changing lanes 07 Overtaking 08 Merging 09 Reversing 10 Parking or unparking 11 Parked legally 12 Parked illegally 13 Stationary accident 14 Stationary broken down 15 Other stationary 16 Avoiding animals 17 Slow/stopping 18 Out of control 19 Wrong way 99 Not known _ (Blank value entered)
TRAILER_TYPE Trailer Type CHAR(1) TRAILER_TYPE is a character field indicates the type of trailer towed by the vehicle involved in the accident, as reported by the police. Code Description A Caravan B Trailer (general) C Trailer (boat) D Horse float E Machinery F Farm/agricultural equipment G Not known what is being towed H Not applicable I Trailer (Exempt) J Semi Trailer K Pig Trailer L Dog Trailer
VEHICLE_COLOUR_1 Vehicle Colour 1 CHAR(3) VEHICLE_COLOUR_1 is a character field indicates the primary or main colour of the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. Code Description BLK Black BLU Blue BRN Brown CRM Cream FWN Fawn GLD Gold GRN Green GRY Grey MRN Maroon MVE Mauve OGE Orange PNK Pink PUR Purple RED Red SIL Silver WHI White YLW Yellow ZZ Unknown or Not applicable
VEHICLE_COLOUR_2 Vehicle Colour 2 CHAR(3)

VEHICLE_COLOUR_2 is a character field indicates the secondary colour of the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name.

Valid entries for this field are same as VEHICLE_COLOUR_1

Code Description BLK Black BLU Blue BRN Brown CRM Cream FWN Fawn GLD Gold GRN Green GRY Grey MRN Maroon MVE Mauve OGE Orange PNK Pink PUR Purple RED Red SIL Silver WHI White YLW Yellow ZZ Unknown or Not applicable
CAUGHT_FIRE Caught Fire CHAR(1) CAUGHT_FIRE is a character field indicates whether or not the vehicle caught fire as a result of the accident. Code Description 0 Not applicable 1 Yes 2 No 9 Not known
INITIAL_IMPACT Initial Impact CHAR(1) INITIAL_IMPACT is a character field indicates the position on the vehicle where the initial impact occurred. Code Description 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/not applicable F Front N None R Rear S Sidecar T Top/roof U Undercarriage _ (Blank value entered)
LAMPS, + 1 LAMPS CHAR(1) LAMPS is a character field indicates whether the lamps or headlights for the vehicle (under the ambient lighting conditions) were alight (on). Code Description 0 Not applicable 1 Yes 2 No 9 Not known
LEVEL_OF_DAMAGE Level of Damage CHAR(1) LEVEL_OF_DAMAGE is a character field indicates the damage level of the vehicle. Code Description 1 Minor 2 Moderate (driveable vehicle) 3 Moderate (unit towed away) 4 Major (unit towed away) 5 Extensive (unrepairable) 6 Nil damage 9 Not known
TOWED_AWAY_FLAG Towed Away Flag CHAR(1) TOWED_AWAY_FLAG is a character field indicates whether or not the vehicle was towed from the accident site. 1,2
TRAFFIC_CONTROL Traffic Control CHAR(2) TRAFFIC_CONTROL is a character field indicates the traffic control facing that was facing the vehicle, prior to the accident.
TRAFFIC_CONTROL_DESC Traffic Control Description VARCHAR(100) TRAFFIC_CONTROL_DESC is a descriptive field that indicates the traffic control facing that was facing the vehicle, prior to the accident.

Additional Information

Field Value
Data last updated 16 November 2024
Metadata last updated 26 November 2024
Created 16 November 2024
Format CSV
License Creative Commons Attribution 4.0 International
Attributes[{"attribute_display_order_id": 1, "db_format": "CHAR(12)", "db_name": "ACCIDENT_NO", "definition": "<p>ACCIDENT_NO is the Primary Key for the database to uniquely identify the accident and cannot contain NULL values.</p>\n<p>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</p>", "fixed_values": "", "id": "7384", "name": "Accident Number", "ref_number": "AT-7384"}, {"attribute_display_order_id": 2, "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. This field cannot contain NULL values.", "fixed_values": "", "id": "7382", "name": "Vehicle ID", "ref_number": "AT-7382"}, {"attribute_display_order_id": 3, "db_format": "INTEGER(10)", "db_name": "VEHICLE_YEAR_MANUF", "definition": "VEHICLE_YEAR_MANUF is an integer field indicates the year in which the vehicle was built or manufactured. The data is stored in yyyy format.", "fixed_values": "", "id": "7387", "name": "Vehicle Year of Manufacture", "ref_number": "AT-7387"}, {"attribute_display_order_id": 4, "db_format": "CHAR(1)", "db_name": "VEHICLE_DCA_CODE", "definition": "VEHICLE_DCA_CODE is a character field indicates that links the vehicle with the movement depicted in the DCA table. For example, if the DCA code for the accident is 111 and the vehicle DCA code is 2, then an inspection of the DCA chart will show that the second vehicle involved in the accident was turning right.", "fixed_values": "Code Description 1 Vehicle 1 2 Vehicle 2 3 Not known which vehicle was number 1 8 Not involved in initial event", "id": "7379", "name": "Vehicle DCA Code", "ref_number": "AT-7379"}, {"attribute_display_order_id": 5, "db_format": "CHAR(2)", "db_name": "INITIAL_DIRECTION", "definition": "INTIAL_DIRECTION is a character field indicates the initial or first direction of travel of the vehicle. For a vehicle that is turning, the initial direction will be different to the final direction. For a non-turning vehicle, the initial direction will be the same as the final direction.", "fixed_values": "Code Description E East N North NE North east NW North west S South SE South east SW South west W West NK Not known", "id": "7366", "name": "Initial Direction", "ref_number": "AT-7366"}, {"attribute_display_order_id": 6, "db_format": "CHAR(1)", "db_name": "ROAD_SURFACE_TYPE", "definition": "Road surface type describes the type of road surface the crash occurred on (e.g. paved, unpaved, gravel etc)", "fixed_values": "Code Description 1 Paved 2 Unpaved 3 Gravel 9 Not known", "id": "7376", "name": "Road Surface Type", "ref_number": "AT-7376"}, {"attribute_display_order_id": 7, "db_format": "VARCHAR(100)", "db_name": "ROAD_SURFACE_TYPE_DESC", "definition": "Road surface type its a descriptive field that describes the type of road surface the crash occurred on (e.g. paved, unpaved, gravel etc)", "fixed_values": "Code Description 1 Paved 2 Unpaved 3 Gravel 9 Not known", "id": "7364", "name": "Road Surface Type Description", "ref_number": "AT-7364"}, {"attribute_display_order_id": 8, "db_format": "CHAR(1)", "db_name": "REG_STATE", "definition": "REG_STATE is a character field indicates the state which is the vehicle is registered in. This field will also indicate if the registration is overseas. 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 _ (Blank value entered)/Not available", "id": "7394", "name": "Registration State", "ref_number": "AT-7394"}, {"attribute_display_order_id": 9, "db_format": "CHAR(6)", "db_name": "VEHICLE_BODY_STYLE", "definition": "VEHICLE_BODY_STYLE is a character field indicates the body type of the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. This field cannot contain NULL values.", "fixed_values": "Code Description AFRAME A Frame AG IMP Agricultural Implement For Prim.Prod. AMB Ambulance Emergency Vehicle AMPHIB Amphibian Land And Water Craft AMUS Amusement ARM V Armoured Vehicle B BIN Bulk Bin B HOE Back Hoe B TR Boat Trailer B/TR Boat Trailer BD/PMR B Double Prime Mover (Feds Only) BOX Box Trailer BUGGY Buggy Beach Buggy, Golf Buggy BUS Bus Used For Passenger Carriage C CAR Car Carrier Used For Car Carriage C MIX Concrete Mixer CARAVN Caravan CARVN Mobile Caravan Self Propelled Caravan CHAIR Motor Chair Motorized Wheelchair COMPAC Compactor CONT C Container Carrier CONVRT Convertible Car with removable top COUPE Coupe Car With 2 Doors CRANE Mobile Crane CYCLE Motor Cycle DITCH Ditch Witch DOLLY Dolly DOZER Bulldozer DUMPER Dumper EDUCTR Eductor EXCVTR Excavator F LIFT Fork Lift F UNIT Fire Unit FLOAT Moomba Float FLUSH Flusher FRAME Frame G UNIT Garbage Unit GRADER Grader H FLT Horse Float H/FLT Horse Float HEARSE Hearse HOE B Hoe HOR FL Horse Float IND/CN Individual Construction INDCON Individual Construction JEEP Jeep JINKER Jinker L FRM Log Frame (Rigid) L LOAD Low Loader L MARK Line Marker LADDER Ladder Truck LOADER Loader M BILL Mobile Billboard M CCH Mourning Coach M STDO Mobile Studio M STND Mobile Grandstand MACH Machine MACHNE Machine MISC Miscellaneous MOPED Motor Cycle MOWER Mower MULTI Multi MULTIX Multix OF SHD Office Shed OF/SHD Office Shed OUTFIT Motor Cycle P CARR Personnell Carrier P MVR Prime Mover P VAN Panel Van PMAMUS Prime Mover Amusement R AMUS Rigid Amusement RDSTR Roadster Convertible with 2 seats RLINER Road Liner ROLLER Roller S AMB Semi Ambulance S AMRV Semi Armoured Vehicle S AMUS Semi Amusement Vehicle S BULK Semi Bulk Bin S CAR Semi Car Carrier S CONT Semi Container Carrier S CRVN Semi Mobile Caravan S DCMP Semi Decompression Chamber S FLSH Semi Flusher S FLT Semi Float S FRM Semi Frame S JINK Semi Timber Jinker S LOAD Semi Loader S MACH Semi Machine S SERV Semi Service S SPRD Semi Lime Spreader S SPRY Semi Sprayer S TANK Semi Tanker S TRL Semi Trailer S TTWR Semi Travel Tower S VAN Semi Trailer Van S WAG Station Wagon Car With Internal Boot SCOOP Shovel SCOOTR Scooter SED Sedan - Car with external boot SEDAN Sedan - Car with external boot SWV1 Quad Bike SWV2 4 Wheel Drive \u2013 All Terrain Vehicle", "id": "7390", "name": "Vehicle Body Style", "ref_number": "AT-7390"}, {"attribute_display_order_id": 10, "db_format": "CHAR(6)", "db_name": "VEHICLE_MAKE", "definition": "VEHICLE_MAKE is a character field indicates the vehicle make or manufacturer. This field cannot contain NULL values.", "fixed_values": "Code Description AEC A E C ALBION Albion ALFA R Alfa Romeo ALLARD Allard ALLIS Allis ANSAIR Ansair ASI A S I ASIA Asia ASTON Aston Martin ATHEY Athey ATKINS Atkinson AUDI Audi AUSTIN Austin AUSTRL Austral B KNOX Blaw Knox BED Bedford BED IS Bedford Isuzu BELARS Belarus BENFRD Benford BENT Bentley BERL Berliet BHB B H B BMW B M W BOMBDR Bombardier BSA B S A BUICK Buick CAD Cadillac CASE Case CATPLR Caterpillar CHAMB Chamberlain CHAMP Champion CHEV Chevrolet CHRYS Chrysler CITRN Citroen COLES Coles COMMER Commer CONQ Conquip CUMMIN Cummins D BRN David Brown DAEWOO Daewoo DAF D A F DAIHAT Diahatsu DAIM Daimler DATSUN Datsun DENING Denning DENNIS Dennis DETOM Detomaso DEUTZ Deutz DIA R Diamond Reo DIA T Diamond T DIAMON Diamond DIATTO Diatto DODGE Dodge DOMINO Domino DYNAPC Dynapac ENFLD Enfield ERF E R F ESSEX Essex EUNOS Eunos500 EUREKA Eureka F LINE Freightliner FENDT Fendt FERG Ferguson FERRAR Ferrari FIAT Fiat FMC F M C FORD Ford FORDSN Fordson FRANNA Franna FRGHTR Freighter-Lawton FRMLNR Farmliner FSM F S M FUJI Fuji FURUKA Furukawa GALANT Galant(Chrysler) GALION Galion GMC G M C GRAD Gradall H COCK Hancock H DAV Harley Davidson H MADE Homemade HAFL Haflinger HANOM Hanomag HILL Hillman HITACH Hitachi HOLDEN Holden HSQVRN Husqvarna HUST Hustler HYNDAI Hyundai HYSTER Hyster I RAND Ingerson Rand INTERN International ISEKI Iseki ISUZU Isuzu J DEER John Deere JAGUAR Jaguar JBJ J B J JCB J C B JEEP Jeep JENSEN Jensen KATO Kato KAWASA Kawasaki KENWTH Kenworth KIA Kia L ROV Land Rover LADA Lada LOTUS Lotus MAZDA Mazda MERC B Mercedes-Benz NISSAN Nissan OLDS Oldsmobile PEUGEOT Peugeot PONT Pontiac PORSCH Porsche R ROV Range Rover RAMBLR Rambler REN Renault ROLLS Rolls-Royce ROVER Rover SAAB Saab SUBARU Subaru SUZUKI Suzuki TOYOTA Toyota VOLKS Volkswagen VOLVO Volvo YAMAHA Yamaha", "id": "7396", "name": "Vehicle Make", "ref_number": "AT-7396"}, {"attribute_display_order_id": 11, "db_format": "CHAR(6)", "db_name": "VEHICLE_MODEL", "definition": "VEHICLE_MODEL is a character field indicates the model of the vehicle.", "fixed_values": "E.g. FALCON 0 Unknown 66 Sleeper 75 Tow", "id": "7370", "name": "Vehicle Model", "ref_number": "AT-7370"}, {"attribute_display_order_id": 12, "db_format": "INTEGER(10)", "db_name": "VEHICLE_POWER", "definition": "VEHICLE_POWER is an integer field indicating the power of the vehicle, in CCs or horsepower. For motor cycles, motor scooters and mopeds, the units will be CCs and for all other vehicles the units are rated horsepower. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name.", "fixed_values": "Code Description 0 Unknown 1-1000 Horsepower 1-9999 CCs", "id": "7363", "name": "Vehicle Power", "ref_number": "AT-7363"}, {"attribute_display_order_id": 13, "db_format": "CHAR(2)", "db_name": "VEHICLE_TYPE", "definition": "VEHICLE_TYPE is a character field indicates the type or category of vehicle. This field cannot contain NULL values.", "fixed_values": "Code Description 01 Car 02 Station wagon 03 Taxi 04 Utility 05 Panel van 06 Prime Mover (No of Trailers Unknown) 07 Rigid Truck (Weight Unknown) 08 Bus/coach 09 Mini bus (9 13) seats 10 Motor cycle 11 Moped 12 Motor scooter 13 Bicycle 14 Horse (ridden or drawn ) 15 Tram 16 Train 17 Other vehicle 18 Not Applicable 19 Parked Trailers 20 Quad Bike 27 Plant machinery and Agricultural equipment 60 Prime Mover Only 61 Prime Mover \u2013 Single Trailer 62 Prime Mover \u2013 B-Double 63 Prime Mover B-Triple 71 Light Commercial Vehicle (Rigid) <= 4.5=\"\" tonnes=\"\" gvm=\"\" 72=\"\" heavy=\"\" vehicle=\"\" (rigid)=\"\"> 4.5 Tonnes 99 Not known", "id": "7372", "name": "Vehicle Type", "ref_number": "AT-7372"}, {"attribute_display_order_id": 14, "db_format": "VARCHAR(100)", "db_name": "VEHICLE_TYPE_DESC", "definition": "VEHICLE_TYPE_DESC is a descriptive field that indicates the type or category of vehicle. This field cannot contain NULL values.", "fixed_values": "Code Description 01 Car 02 Station wagon 03 Taxi 04 Utility 05 Panel van 06 Prime Mover (No of Trailers Unknown) 07 Rigid Truck (Weight Unknown) 08 Bus/coach 09 Mini bus (9 13) seats 10 Motor cycle 11 Moped 12 Motor scooter 13 Bicycle 14 Horse (ridden or drawn ) 15 Tram 16 Train 17 Other vehicle 18 Not Applicable 19 Parked Trailers 20 Quad Bike 27 Plant machinery and Agricultural equipment 60 Prime Mover Only 61 Prime Mover \u2013 Single Trailer 62 Prime Mover \u2013 B-Double 63 Prime Mover B-Triple 71 Light Commercial Vehicle (Rigid) <= 4.5=\"\" tonnes=\"\" gvm=\"\" 72=\"\" heavy=\"\" vehicle=\"\" (rigid)=\"\"> 4.5 Tonnes 99 Not known", "id": "7385", "name": "Vehicle Type Description", "ref_number": "AT-7385"}, {"attribute_display_order_id": 15, "db_format": "INTEGER(10)", "db_name": "VEHICLE_WEIGHT", "definition": "<p>VEHICLE_WEIGHT is an integer field indicating the weight or mass of the vehicle. The unit of measurement is kilograms.</p>\n<p>NULL values are valid entries.</p>", "fixed_values": "Code Description 01 Car 02 Station wagon 03 Taxi 04 Utility 05 Panel van 06 Prime Mover (No of Trailers Unknown) 07 Rigid Truck (Weight Unknown) 08 Bus/coach 09 Mini bus (9 13) seats 10 Motor cycle 11 Moped 12 Motor scooter 13 Bicycle 14 Horse (ridden or drawn ) 15 Tram 16 Train 17 Other vehicle 18 Not Applicable 60 Prime Mover Only 61 Prime Mover \u2013 Single Trailer 62 Prime Mover \u2013 B-Double 63 Prime Mover B-Triple 71 Light Commercial Vehicle (Rigid) <= 4.5=\"\" tonnes=\"\" gvm=\"\" 72=\"\" heavy=\"\" vehicle=\"\" (rigid)=\"\"> 4.5 Tonnes 99 Not known", "id": "7375", "name": "Vehicle Weight", "ref_number": "AT-7375"}, {"attribute_display_order_id": 16, "db_format": "CHAR(1)", "db_name": "CONSTRUCTION_TYPE", "definition": "CONSTRUCTION_TYPE is a character field indicates the construction or formation of the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. This field cannot contain NULL values.", "fixed_values": "A Articulated P Interpretation is not known R Rigid _ (Blank value entered) Unknown", "id": "7374", "name": "Construction Type", "ref_number": "AT-7374"}, {"attribute_display_order_id": 17, "db_format": "CHAR(1)", "db_name": "FUEL_TYPE", "definition": "FUEL_TYPE is a character field indicates the type of fuel used by the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. This field cannot contain NULL values.", "fixed_values": "Code Description D Diesel E Electric G Gas M Multi P Petrol R Rotary Z Unknown", "id": "7377", "name": "Fuel Type", "ref_number": "AT-7377"}, {"attribute_display_order_id": 18, "db_format": "INTEGER(10)", "db_name": "NO_OF_WHEELS", "definition": "NO_OF_WHEELS is an integer field indicates the number of wheels that the vehicle has. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. NULL values are valid entries.", "fixed_values": "", "id": "7378", "name": "Number of Wheels", "ref_number": "AT-7378"}, {"attribute_display_order_id": 19, "db_format": "INTEGER(10)", "db_name": "NO_OF_CYLINDERS", "definition": "NO_OF_CYLINDERS is an integer field indicates the number of engine cylinders that the vehicle has. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. NULL values are valid entries.", "fixed_values": "", "id": "7362", "name": "Number of Cylinders", "ref_number": "AT-7362"}, {"attribute_display_order_id": 20, "db_format": "INTEGER(10)", "db_name": "SEATING_CAPACITY", "definition": "SEATING_CAPACITY is an integer field indicates the number of seats in the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. NULL values are valid entries.", "fixed_values": "", "id": "7368", "name": "Seating Capacity", "ref_number": "AT-7368"}, {"attribute_display_order_id": 21, "db_format": "INTEGER(10)", "db_name": "TARE_WEIGHT", "definition": "TARE_WEIGHT is an integer field indicates the tare or unladen weight of the vehicle. The unit of measurement is kilograms. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. NULL values are valid entries.", "fixed_values": "", "id": "7395", "name": "Tare Weight", "ref_number": "AT-7395"}, {"attribute_display_order_id": 22, "db_format": "INTEGER(10)", "db_name": "TOTAL_NO_OCCUPANTS", "definition": "TOTAL_NO_OCCUPANTS is an integer field indicates the number of occupants or people in the vehicle at the time of the accident. NULL values are valid entries.", "fixed_values": "", "id": "7386", "name": "Total Number of Occupants", "ref_number": "AT-7386"}, {"attribute_display_order_id": 23, "db_format": "INTEGER(10)", "db_name": "CARRY_CAPACITY", "definition": "<p>CARRY_CAPACITY is an integer field indicates the carry or load capacity of the vehicle. The unit of measurement is kilograms. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name.</p>\n<p>NULL values are valid entries.</p>", "fixed_values": "", "id": "7361", "name": "Carry Capacity", "ref_number": "AT-7361"}, {"attribute_display_order_id": 24, "db_format": "INTEGER(10)", "db_name": "CUBIC_CAPACITY", "definition": "CONSTRUCTION_TYPE is a character field indicates the construction or formation of the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. This field cannot contain NULL values.", "fixed_values": "", "id": "7373", "name": "Cubic Capacity", "ref_number": "AT-7373"}, {"attribute_display_order_id": 25, "db_format": "CHAR(2)", "db_name": "FINAL_DIRECTION", "definition": "FINAL_DIRECTION is a character field indicates the final or last direction of travel of the vehicle. For a vehicle that is turning, the initial direction will be different to the final direction. For a non-turning vehicle, the initial direction will be the same as the final direction.", "fixed_values": "Code Description E East N North NE North east NW North west S South SE South east SW South west W West NK Not known", "id": "7383", "name": "Final Direction", "ref_number": "AT-7383"}, {"attribute_display_order_id": 26, "db_format": "CHAR(2)", "db_name": "DRIVER_INTENT", "definition": "DRIVER_INTENT is a character field indicates what the driver of the vehicle was attempting to undertake at the time of the accident. This information is meant to obtain via an interview of the vehicle's driver..", "fixed_values": "Code Description 01 Going straight ahead 02 Turning right 03 Turning left 04 Leaving a driveway 05 'U' turning 06 Changing lanes 07 Overtaking 08 Merging 09 Reversing 10 Parking or unparking 11 Parked legally 12 Parked illegally 13 Stationary accident 14 Stationary broken down 15 Other stationary 16 Avoiding animals 17 Slow/stopping 18 Out of control 19 Wrong way 99 Not known", "id": "7371", "name": "Driver Intent", "ref_number": "AT-7371"}, {"attribute_display_order_id": 27, "db_format": "CHAR(2)", "db_name": "VEHICLE_MOVEMENT", "definition": "VEHICLE_MOVEMENT is a character field indicates the actual movement of the vehicle prior to the accident.", "fixed_values": "Code Description 01 Going straight ahead 02 Turning right 03 Turning left 04 Leaving a driveway 05 'U' turning 06 Changing lanes 07 Overtaking 08 Merging 09 Reversing 10 Parking or unparking 11 Parked legally 12 Parked illegally 13 Stationary accident 14 Stationary broken down 15 Other stationary 16 Avoiding animals 17 Slow/stopping 18 Out of control 19 Wrong way 99 Not known _ (Blank value entered)", "id": "7393", "name": "Vehicle Movement", "ref_number": "AT-7393"}, {"attribute_display_order_id": 28, "db_format": "CHAR(1)", "db_name": "TRAILER_TYPE", "definition": "TRAILER_TYPE is a character field indicates the type of trailer towed by the vehicle involved in the accident, as reported by the police.", "fixed_values": "Code Description A Caravan B Trailer (general) C Trailer (boat) D Horse float E Machinery F Farm/agricultural equipment G Not known what is being towed H Not applicable I Trailer (Exempt) J Semi Trailer K Pig Trailer L Dog Trailer", "id": "7367", "name": "Trailer Type", "ref_number": "AT-7367"}, {"attribute_display_order_id": 29, "db_format": "CHAR(3)", "db_name": "VEHICLE_COLOUR_1", "definition": "VEHICLE_COLOUR_1 is a character field indicates the primary or main colour of the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name.", "fixed_values": "Code Description BLK Black BLU Blue BRN Brown CRM Cream FWN Fawn GLD Gold GRN Green GRY Grey MRN Maroon MVE Mauve OGE Orange PNK Pink PUR Purple RED Red SIL Silver WHI White YLW Yellow ZZ Unknown or Not applicable", "id": "7381", "name": "Vehicle Colour 1", "ref_number": "AT-7381"}, {"attribute_display_order_id": 30, "db_format": "CHAR(3)", "db_name": "VEHICLE_COLOUR_2", "definition": "<p>VEHICLE_COLOUR_2 is a character field indicates the secondary colour of the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name.</p></p>\n<p><p></p></p>\n<p><p>Valid entries for this field are same as VEHICLE_COLOUR_1</p></p>", "fixed_values": "Code Description BLK Black BLU Blue BRN Brown CRM Cream FWN Fawn GLD Gold GRN Green GRY Grey MRN Maroon MVE Mauve OGE Orange PNK Pink PUR Purple RED Red SIL Silver WHI White YLW Yellow ZZ Unknown or Not applicable", "id": "7365", "name": "Vehicle Colour 2", "ref_number": "AT-7365"}, {"attribute_display_order_id": 31, "db_format": "CHAR(1)", "db_name": "CAUGHT_FIRE", "definition": "CAUGHT_FIRE is a character field indicates whether or not the vehicle caught fire as a result of the accident.", "fixed_values": "Code Description 0 Not applicable 1 Yes 2 No 9 Not known", "id": "7388", "name": "Caught Fire", "ref_number": "AT-7388"}, {"attribute_display_order_id": 32, "db_format": "CHAR(1)", "db_name": "INITIAL_IMPACT", "definition": "INITIAL_IMPACT is a character field indicates the position on the vehicle where the initial impact occurred.", "fixed_values": "Code Description 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/not applicable F Front N None R Rear S Sidecar T Top/roof U Undercarriage _ (Blank value entered)", "id": "7391", "name": "Initial Impact", "ref_number": "AT-7391"}, {"attribute_display_order_id": 33, "db_format": "CHAR(1)", "db_name": "LAMPS, + 1", "definition": "LAMPS is a character field indicates whether the lamps or headlights for the vehicle (under the ambient lighting conditions) were alight (on).", "fixed_values": "Code Description 0 Not applicable 1 Yes 2 No 9 Not known", "id": "7195", "name": "LAMPS", "ref_number": "AT-7195"}, {"attribute_display_order_id": 34, "db_format": "CHAR(1)", "db_name": "LEVEL_OF_DAMAGE", "definition": "LEVEL_OF_DAMAGE is a character field indicates the damage level of the vehicle.", "fixed_values": "Code Description 1 Minor 2 Moderate (driveable vehicle) 3 Moderate (unit towed away) 4 Major (unit towed away) 5 Extensive (unrepairable) 6 Nil damage 9 Not known", "id": "7392", "name": "Level of Damage", "ref_number": "AT-7392"}, {"attribute_display_order_id": 35, "db_format": "CHAR(1)", "db_name": "TOWED_AWAY_FLAG", "definition": "TOWED_AWAY_FLAG is a character field indicates whether or not the vehicle was towed from the accident site.", "fixed_values": "1,2", "id": "7380", "name": "Towed Away Flag", "ref_number": "AT-7380"}, {"attribute_display_order_id": 36, "db_format": "CHAR(2)", "db_name": "TRAFFIC_CONTROL", "definition": "TRAFFIC_CONTROL is a character field indicates the traffic control facing that was facing the vehicle, prior to the accident.", "fixed_values": "", "id": "7369", "name": "Traffic Control", "ref_number": "AT-7369"}, {"attribute_display_order_id": 37, "db_format": "VARCHAR(100)", "db_name": "TRAFFIC_CONTROL_DESC", "definition": "TRAFFIC_CONTROL_DESC is a descriptive field that indicates the traffic control facing that was facing the vehicle, prior to the accident.", "fixed_values": "", "id": "7389", "name": "Traffic Control Description", "ref_number": "AT-7389"}]
Ckan urlhttps://discover.data.vic.gov.au
Dataset last updated date2 weeks ago
Datastore activeTrue
Datastore contains all records of source fileTrue
Has viewsTrue
Hasha6178790bfc4ce1b1ff759c53963d63c
HistoricalFalse
Id7ef18bf3-d263-4c00-b06b-50a6bb16ebbf
Ignore hashFalse
Last updated date2 weeks ago
Mimetypetext/csv
Open dataset titleVehicle
Original urlhttps://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/7ef18bf3-d263-4c00-b06b-50a6bb16ebbf/download/vehicle.csv
Package ide03104fe-fd02-4045-aa05-e916c6d46433
Period end2024-03-31
Period start2012-01-01
Position1
Publication date13 years ago
Resource id7ef18bf3-d263-4c00-b06b-50a6bb16ebbf
Set url typeFalse
Stateactive
Task created2024-11-25 05:35:06.251661
File Size 38.7 MB
Release Date
Temporal Coverage Start 1 January 2012
Temporal Coverage End 31 March 2024
Data Quality Statement
Attribution Statement