Reason for Stop by Race / Ethnicity

Custom SQL query returning 60 rows (hide)

SELECT rae_codes.RACE_ETHNICITY as race_ethnicity, rfs_codes.REASON_FOR_STOP as reason_for_stop, COUNT(main.REASON_FOR_STOP) as total_stops FROM aa_main_table as main INNER JOIN race_ethnicity as rae ON rae.UNIQUE_ID = main.UNIQUE_ID INNER JOIN race_ethnicity_codes as rae_codes ON rae.RAE_FULL = rae_codes.CODE INNER JOIN reason_for_stop_codes as rfs_codes ON main.REASON_FOR_STOP = rfs_codes.CODE GROUP BY main.REASON_FOR_STOP, rae.RAE_FULL ORDER BY rae_codes.RACE_ETHNICITY

If you think this query provides useful or interesting information submit it as a suggestion to be included as a canned query! Canned queries are displayed in the main page and come with their own URL. Others might find your query useful in their work!

race_ethnicityreason_for_stoptotal_stops
Asian Traffic Violation 93039
Asian Reasonable suspicion 4955
Asian Parole/probation/PRCS/mandatory supervision 110
Asian Knowledge of outstanding arrest warrant/wanted person 227
Asian Investigation to determine whether person was truant 192
Asian Consensual encounter resulting in search 914
Asian Possible conduct under Education Code 3
Asian Determine whether student violated school policy 7
Black/African American Traffic Violation 205122
Black/African American Reasonable suspicion 52930
Black/African American Parole/probation/PRCS/mandatory supervision 2564
Black/African American Knowledge of outstanding arrest warrant/wanted person 3182
Black/African American Investigation to determine whether person was truant 1171
Black/African American Consensual encounter resulting in search 6177
Black/African American Possible conduct under Education Code 17
Black/African American Determine whether student violated school policy 25
Hispanic/Latino Traffic Violation 609966
Hispanic/Latino Reasonable suspicion 76113
Hispanic/Latino Parole/probation/PRCS/mandatory supervision 5502
Hispanic/Latino Knowledge of outstanding arrest warrant/wanted person 5399
Hispanic/Latino Investigation to determine whether person was truant 1946
Hispanic/Latino Consensual encounter resulting in search 17021
Hispanic/Latino Possible conduct under Education Code 32
Hispanic/Latino Determine whether student violated school policy 50
Middle Eastern/South Asian Traffic Violation 75831
Middle Eastern/South Asian Reasonable suspicion 2912
Middle Eastern/South Asian Parole/probation/PRCS/mandatory supervision 65
Middle Eastern/South Asian Knowledge of outstanding arrest warrant/wanted person 139
Middle Eastern/South Asian Investigation to determine whether person was truant 80
Middle Eastern/South Asian Consensual encounter resulting in search 888
Middle Eastern/South Asian Possible conduct under Education Code 1
Middle Eastern/South Asian Determine whether student violated school policy 1
Multiracial Traffic Violation 17584
Multiracial Reasonable suspicion 2742
Multiracial Parole/probation/PRCS/mandatory supervision 130
Multiracial Knowledge of outstanding arrest warrant/wanted person 190
Multiracial Investigation to determine whether person was truant 55
Multiracial Consensual encounter resulting in search 529
Multiracial Determine whether student violated school policy 9
Native American Traffic Violation 3133
Native American Reasonable suspicion 506
Native American Parole/probation/PRCS/mandatory supervision 46
Native American Knowledge of outstanding arrest warrant/wanted person 54
Native American Investigation to determine whether person was truant 22
Native American Consensual encounter resulting in search 124
Pacific Islander Traffic Violation 9181
Pacific Islander Reasonable suspicion 1064
Pacific Islander Parole/probation/PRCS/mandatory supervision 45
Pacific Islander Knowledge of outstanding arrest warrant/wanted person 89
Pacific Islander Investigation to determine whether person was truant 46
Pacific Islander Consensual encounter resulting in search 158
Pacific Islander Determine whether student violated school policy 1
White Traffic Violation 511997
White Reasonable suspicion 64271
White Parole/probation/PRCS/mandatory supervision 2629
White Knowledge of outstanding arrest warrant/wanted person 3452
White Investigation to determine whether person was truant 2357
White Consensual encounter resulting in search 12988
White Possible conduct under Education Code 14
White Determine whether student violated school policy 57