Illinois Department of Transportation, Ann L. Schneider, Acting Secretary
Patrick J. Quinn, 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
2010 Results NEW
2009 Results
2008 Results
2007 Results
2006 Results
2005 Results
2004 Results
Forms
DB File Format 2007
2012 Forms NEW
Contact Us
Login
IDOT Privacy Statement | Illinois Privacy Information | Kids Privacy | Web Accessibility  | FOIA