Pedestrian Stop DB File Format

This is the format for files sent in by agencies for the Pedestrian Stop Data Collection.

Data must be entered in the order specified below. Each field must be separated by a tilde (~).

Each pedestrian stop record must appear on a single line of the file.

Field Name

Acceptable Values

1

Date of Stop

MM/DD/YYYY

2

Time of Stop

HH:MM (Military Time)

3

Officer Name

60 characters

4

Officer Badge Number

10 characters

5

Location of Stop

Physical Address - 60 Characters

6

Beat Location of Stop

10 characters

7

Gender

1: Male

2: Female

       8

Race

1: White

2: Black or African American

3: American Indian or Alaska Native 4: Hispanic or Latino

5: Asian

6: Native Hawaiian or Other Pacific Islander

9

RFS - Drug

1: Yes

2: No

10

RFS - Fits Description Radio / Call

1: Yes

2: No

11

RFS - Fits Description Witness

1: Yes

2: No

12

RFS - Casing

1: Yes

2: No

13

RFS - Proximity

1: Yes

2: No

14

RFS - Gang Enforcement

1: Yes

2: No

15

RFS - Suspicious Activity

1: Yes

2: No

16

RFS - Other

1: Yes

2: No

17

RFS - Other Specify

60 Characters

18

Pat Down/Frisk Conducted?

1: Yes

2: No

19

Pat Down/Frisk Conducted by

0: N/A

1: Consent

2: Reasonable Suspicion

20

RFF - Verbal Threats

0: N/A

1: Yes

2: No

21

RFF - Prior Knowledge

0: N/A

1: Yes

2: No

22

RFF - Actions violent

0: N/A

1: Yes

2: No

23

RFF - Violent Crime

0: N/A

1: Yes

2: No

24

RFF - Suspicious Bulge

0: N/A

1: Yes

2: No

25

RFF - Evasive

0: N/A

1: Yes

2: No

26

RFF - Other

0: N/A

1: Yes

2: No

27

RFF - Other Specify

60 Characters

28

Pat Down Conducted, lead to Search Beyond?

0: N/A

1: Yes

2: No

29

Search Conducted Beyond

Pat Down/Frisk?

1: Yes

2: No

30

Search Beyond Conducted by

0: N/A

1: Consent

2: Probable Cause

3: Search Incident to Arrest

31

RFSB - Drug/Para Found

0: N/A

1: Yes

2: No

32

RFSB - Hard Object

0: N/A

1: Yes

2: No

33

RFSB - Firearm

0: N/A

1: Yes

2: No