KeyACCIDENT DATA Format

No.

Field

Type

Max

Comment

1

Reference No

Character

11

Max length previously 9

2

Accident Severity

Numeric

1

3

Number of Vehicles

Numeric

3

4

Number of Casualties

Numeric

3

5

Date of Accident

Character

8

In format ddmmyyyy

6

Day of Accident

Numeric

1

7

Time of Accident

Character

4

In format hhmm

8

1^st Road Class and Number

Character

5

e.g. A1M or A123

9

Speed Limit

Numeric

3

10

Road Surface Condition

Numeric

1

11

Road Type

Numeric

1

12

Junction Detail

Numeric

2

13

Junction Control

Numeric

1

14

2^nd Road Class and Number

Character

5

e.g. B4088

15

Pedestrian Crossing – Human

Control

Numeric

1

16

Pedestrian Crossing – Physical

Facilities

Numeric

1

17

Lighting Conditions

Numeric

1

18

Weather Conditions

Numeric

1

19

Special Conditions

Numeric

1 

20

Carriageway Hazards

Numeric

1

21

Overtaking

Numeric

1

22

Grid Reference Easting

Numeric

6

23

Grid Reference Northing

Numeric

6

24

Parish Reference

Character

4

25

DfT Special Project

Character

4

26

Police Special Project

Character

4

27

Local Authority Special Project

Character

4

28

Location of Accident

Character

No maximum

29

Description of Accident

Character

No maximum

30

Accident Identifier

Character

16

31

Local Authority Reference 

Character

3

32

User Field 1

Character

4 

33

User Field 2

Character

4

34

User Field 3

Character

4

35

User Field 4

Character

4

36

Officer Dealing

Character

No maximum

37

Station Involved

Character

4

38

Month Accident Recorded

Numeric

2

e.g. feb=02

39

Year Accident Recorded

Numeric

4

e.g. 2005

40

Police Beat Number

Character

2

41

Area Code

Character

2

42

Street Reference

Character

6

43

Second Street Reference

Character

6

44

Record Batch

Character

1

45

Contributory Factor 1

Character

3

46

Contributory Factor 2

Character

3

47

Contributory Factor 3

Character

3

48

Contributory Factor 4

Character

3

49

Contributory Factor 5

Character

3

New field

50

Contributory Factor 6

Character

3

“

51

Participant 1

Character 

4

“

52

Participant 2

Character 

4

“

53

Participant 3

Character 

4

“

54

Participant 4

Character 

4

“

55

Participant 5

Character 

4

“

56

Participant 6

Character 

4

“

57

Probability 1

Character

1

“

58

Probability 2

Character

1

“

59

Probability 3

Character

1

“

60

Probability 4

Character

1

“

61

Probability 5

Character

1

“

62

Probability 6

Character

1

“

63

Police Officer

Complete Record

Attend

and

Numeric

1

Previously Accident

Reported

Place

64

Trunk Road

Boolean

1

0=Not

Road

1=Trunk Road

Trunk

65

Validated

Boolean

1

0 = No 1=Yes

No.

Field

Type

Max

Comment

1

Reference Number

Character

11

Max length previously 9

2

Vehicle Reference Number

Numeric

3

3

Vehicle Type

Numeric

2

4

Towing and Articulation

Numeric

1

5

Vehicle Manoeuvre

Numeric

2

6

Vehicle Movement Compass

Point From

Numeric

1

7

Vehicle Movement Compass

Point To

Numeric

1

8

Vehicle Location at Time of Accident – Restricted Lane

Numeric

1

9

Junction Location

Numeric

1

10

Skidding

Numeric

1

11

Hit Object In Carriageway

Numeric

2

12

Vehicle Leaving Carriageway

Numeric

1

13

Hit Object Off Carriageway

Numeric

2

14

First Point of Impact

Numeric

1

15

Other Vehicle Hit

Numeric

3

16

Parts Damaged

Character

3

Field retained at present

17

Sex of Driver

Numeric

1

18

Age of Driver

Numeric

2

If age unknown

leave blank

19

Breathtest

Numeric

1

20

Hit and Run

Numeric

1

21

DfT Special Project

Character

4

22

Police Special Project

Character

4

23

Local Authority Special Project

Character

4

24

Vehicle Registration Mark

Character

8

25

Driver Details

Character

No Maximum

26

Failed to Stop

Character

1

27

Stolen

Character

1

28

Driver Postcode

Character

7

29

Foreign Vehicle

Numeric

1

New Field

30

Purpose of Journey

Numeric

1

New Field

31

Emergency Vehicle

Numeric

1

0=No Emergency

Vehicle

1=Police

2=Fire

3=Ambulance

32

Ethnicity as Defined by

Driver/Rider

Character

2

W1=British

W2=Irish

W3= Other White Background

M1=White and

Black Caribbean

M2=White and

Black African

M3=White and

Asian

M9=Any other

Mixed Race

A1=Indian

A2=Pakistani

A3=Bangladeshi 

A9=Any other

Asian background

B1=Caribbean 

B2=African

B9=Any other

Black background

O1=Chinese

O9=Any other

Ethnic group

NS=Not stated  

33

Ethnicity as defined by Officer

Numeric

1

No.

Field

Type

Max

Comment

1

Reference Number

Character

11

Max length previously 9

2

Vehicle Reference Number

Numeric

3

3

Casualty Reference Number

Numeric

3

4

Casualty Class

Numeric

1

5

Casualty Sex

Numeric

1

6

Casualty Age

Numeric

2

If age unknown leave blank

7

Casualty Severity

Numeric

1

8

Pedestrian Located

Numeric

2

9

Pedestrian Movement

Numeric

1

10

Pedestrian Direction

Numeric

1

11

Seat Belt Usage

Numeric

1

Historic

12

School Pupil Casualty

Numeric

1

13

School Code

Character

4

14

Car Passenger

Numeric

1

15

PSV Passenger

Numeric

1

16

DfT Special Project

Character

4

17

Police Special Project

Character

4

18

Local Authority Special Project

Character

4

19

School Name

Character

No Maximum

20

Casualty Postcode

Character

7

21

Road Worker

Numeric

1

New Field

22

Ethnicity as Defined by Casualty

Character

2

W1=British

W2=Irish

W3= Other White Background

M1=White and

Black Caribbean

M2=White and

Black African

M3=White and

Asian

M9=Any other

Mixed Race

A1=Indian

A2=Pakistani

A3=Bangladeshi 

A9=Any other

Asian background

B1=Caribbean 

B2=African

B9=Any other

Black background

O1=Chinese

O9=Any other

Ethnic group

NS=Not stated  

23

Ethnicity as defined by Officer

Numeric

1