Data Dictionary

Field Name Name Type Description Fixed Values
ACCIDENT_NO Accident Number CHAR 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
ATMOSPH_COND Atmospheric Condition CHAR Weather and atmospheric conditions at the time of the crash Code Description 1 Clear 2 Raining 3 Snowing 4 Fog 5 Smoke 6 Dust 7 Strong winds 9 Not known
ATMOSPH_COND_SEQ Atmospheric Condition Sequence INTEGER 1 and incremented by 1 if more than one atmospheric condition is entered for the same incident
ATMOSPH_COND_DESC Atmospheric Condition Description VARCHAR ATMOSPH_COND_DESC is a Descriptive field. it can be 1 Clear 2 Raining 3 Snowing 4 Fog 5 Smoke 6 Dust 7 Strong winds 9 and Not known Code Description 1 Clear 2 Raining 3 Snowing 4 Fog 5 Smoke 6 Dust 7 Strong winds 9 Not known

Additional Information

Field Value
Data last updated 14 April 2026
Metadata last updated 9 June 2026
Created 11 August 2025
Format CSV
License Creative Commons Attribution 4.0 International
Attributes[{"attribute_display_order_id": 1, "db_format": "CHAR", "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", "id": "7273", "name": "Accident Number", "ref_number": "AT-7273"}, {"attribute_display_order_id": 2, "db_format": "CHAR", "db_name": "ATMOSPH_COND", "definition": "Weather and atmospheric conditions at the time of the crash", "fixed_values": "Code Description 1 Clear 2 Raining 3 Snowing 4 Fog 5 Smoke 6 Dust 7 Strong winds 9 Not known", "id": "7271", "name": "Atmospheric Condition", "ref_number": "AT-7271"}, {"attribute_display_order_id": 3, "db_format": "INTEGER", "db_name": "ATMOSPH_COND_SEQ", "definition": "1 and incremented by 1 if more than one atmospheric condition is entered for the same incident", "id": "7272", "name": "Atmospheric Condition Sequence", "ref_number": "AT-7272"}, {"attribute_display_order_id": 4, "db_format": "VARCHAR", "db_name": "ATMOSPH_COND_DESC", "definition": "ATMOSPH_COND_DESC is a Descriptive field. it can be 1 Clear 2 Raining 3 Snowing 4 Fog 5 Smoke 6 Dust 7 Strong winds 9 and Not known", "fixed_values": "Code Description 1 Clear 2 Raining 3 Snowing 4 Fog 5 Smoke 6 Dust 7 Strong winds 9 Not known", "id": "7479", "name": "Atmospheric Condition Description", "ref_number": "AT-7479"}]
Dataset last updated date2 months ago
Datastore activeFalse
Datastore contains all records of source fileFalse
Edc syncTrue
Has viewsTrue
HistoricalFalse
Id891a8e3a-2fbd-4974-badc-b5616c25b0ab
Ignore hashFalse
Mimetypetext/csv
Open dataset titleAtmospheric Condition
Package ide0880296-585d-47bd-8e72-fc1b2045f53d
Period end2025-08-31
Period start2012-01-01
Position5
Publication date14 years ago
Resource id891a8e3a-2fbd-4974-badc-b5616c25b0ab
Set url typeFalse
Stateactive
File size (bytes) 4.7 MB
Temporal Coverage Start 1 January 2012
Temporal Coverage End 31 August 2025