Illinois Department of Transportation, Milton R. Sees, Secretary Rod R. Blagojevich, Governor
Traveling PublicMapsProjectsRoad ClosuresNewsDoing BusinessLetting & BiddingCareers@IDOTGeneral Info



 

Racial Profiling Database Format (2007)

This is the format for files sent in by agencies for the Racial Profiling Application.

  • Data must be entered in the order specified below
  • Each field must be separated by a tilde (~)
  • Each Traffic stop record must appear on a single line of the file.
09/29/06
Field Name Acceptable Values
Date of Stop MM/DD/YYYY
Time of Stop HH:MM (Military Time)
Duration of Stop (minutes) 3 digits
Officer Name 60 characters
Officer Badge Number 10 characters
Name of Driver 60 characters (Last Name, First Name)
Address 60 characters (the drivers address)
City 50 characters
State 2 characters
Zip Code 5 digits
Vehicle Make 20 characters
Vehicle Year 4 digit year (e.g. 2001)
Driver’s Year of Birth 4 digit year (e.g. 1977)
Driver Sex 1: Male
2: Female
Driver Race 1: Caucasian
2: African/American
3: Native American/Alaskan
4: Hispanic
5: Asian/Pacific Islander
Reason for Stop 1: Moving Violation
2: Equipment
3: License Plate/Registration
Type of Moving Violation (If reason for stop is Moving Violation) 0: Not applicable (It was not a moving violation)
1: Speed
2: Lane Violation
3: Seat Belt
4: Traffic Sign or Signal
5: Follow too close
6: Other
Result of Stop 1: Citation
2: Written Warning
3: Verbal Warning (stop card)
Beat Location of Stop A string of up to 10 characters
Was a search conducted/requested (other than vehicle consent) 1: Yes
2: No
Vehicle Search Type (non consent)

0: Not applicable
2: Reasonable Suspicion
3: Probable Cause
4: Incidental to Arrest
5: Custodial Arrest
6: Drug Dog Alert
7: Other

Driver Search Type

0: Not applicable
1: Consent
2: Reasonable Suspicion
3: Probable Cause
4: Incidental to Arrest
5: Custodial Arrest
6: Drug Dog Alert
7: Other
8: Consent Search Request Denied
Passenger(s) Search Type

0: Not applicable
1: Consent
2: Reasonable Suspicion
3: Probable Cause
4: Incidental to Arrest
5: Custodial Arrest
6: Drug Dog Alert
7: Other
8: Consent Search Request Denied
Was Contraband Found
 0: Not applicable (a search was not conducted)
1: Yes
2 : No
Drugs found

 0: Not applicable
1: Yes
2 : No
Drug Paraphernalia
 0: Not applicable
1: Yes
2: No
Alcohol Found 0: Not applicable
1: Yes
2: No
Weapon was found

 0: Not applicable
1: Yes
2 : No
Stolen Property was found
 0: Not applicable
1: Yes
2 : No
Other Contraband was found

 0: Not applicable
1: Yes
2 : No
If the contraband was drugs, what was the amount? 0: Not applicable
1: < 2 grams
2: 2-10 grams
3: 11-50 grams
4: 51-100 grams
5: > 100 grams
Was a consent search on the vehicle requested 1: Yes
2:No
If consent was requested to search the vehicle, was consent granted? 0: Not applicable
1: Yes
2:No
If consent was granted, was a search performed? 0: Not applicable
1:Yes
2:No
If consent was granted to search the vehicle, was contraband found? 0: Not applicable
1: Yes
2:No
Drugs
 0: Not applicable
1: Yes
2 : No
Drug Paraphernalia
(only if a vehicle consent search was conducted)		 0: Not applicable
1: Yes
2: No
Alcohol was Found (only if a vehicle consent search was conducted) 0: Not applicable
1: Yes
2: No
Weapon was found
(only if a vehicle consent search was conducted)
 0: Not applicable
1: Yes
2 : No
Stolen Property was found
(only if a vehicle consent search was conducted)
 0: Not applicable
1: Yes
2 : No
Other Contraband was found
(only if a vehicle consent search was conducted)
 0: Not applicable
1: Yes
2 : No
If the contraband was drugs, what was the amount? 0: Not applicable
1: < 2 grams
2: 2-10 grams
3: 11-50 grams
4: 51-100 grams
5: > 100 grams

Study Links
2006 Results
2005 Results
2004 Results
Forms
2007 DB File Format
Contact Us
Login
IDOT Privacy Statement | Illinois Privacy Information | Kids Privacy | Web Accessibility  | FOIA