Reason for stop by race/ethinicty by agency

Custom SQL query (hide)

SELECT rae_codes.RACE_ETHNICITY, rfs_codes.REASON_FOR_STOP, COUNT(*) as N FROM aa_main_table as main JOIN race_ethnicity as rae ON rae.UNIQUE_ID = main.UNIQUE_ID JOIN race_ethnicity_codes as rae_codes ON rae.RAE_FULL = rae_codes.CODE JOIN reason_for_stop_codes as rfs_codes on main.REASON_FOR_STOP = rfs_codes.CODE WHERE "AGENCY_NAME" = :agency GROUP BY main.REASON_FOR_STOP, rae.RAE_FULL ORDER BY RACE_ETHNICITY, N DESC

Query parameters

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!

0 results