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
ATMOSPH_COND Atmospheric Condition CHAR(1) 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(10) 1 and incremented by 1 if more than one atmospheric condition is entered for the same incident
ATMOSPH_COND_DESC Atmospheric Condition Description VARCHAR(100) 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
Dataset Last Updated Date 14 April 2025
Last Updated Date 13 April 2025
Publication Date 1 January 2012
Format CSV
License Creative Commons Attribution 4.0
Open Data Title Atmospheric Condition
Dataset File Size 4.3 MiB
Dataset Security Value BIL1 OFFICIAL - Authorised Public Release
Dataset Reporting Period Start 1 January 2012
Dataset Reporting Period End 31 August 2024