KeyACCIDENT DATA Format

Issue

Here you will find example Format for KeyACCIDENT

Solution

Project, Police Special Project, Local Authority Special Project, School Name, Casualty Postcode, Road Worker, Ethnicity as Defined by Casualty, Ethnicity as Defined by Officer.

 

The type, format and maximum length for each field is given in the following tables:

 

Accident Details

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

1st 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

2nd 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

 

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

 

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

 

Vehicle Detail

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

 

 

Casualty Details

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

 

 

Notes:

  1. If age of driver is unknown the driver age must be left blank
  1. If the age of casualty is unknown the casualty age must be left blank
  2. If any of the fields do not map from the source data leave the field blank

0 Comments

Please sign in to leave a comment.