Race / Ethnicity by Agency Name

Custom SQL query returning 64 rows (hide)

SELECT b.AGENCY_NAME as agency_name, rae_codes.RACE_ETHNICITY as race_ethnicity, COUNT(rae.RAE_FULL) as N FROM race_ethnicity as rae INNER JOIN aa_main_table as b ON b.UNIQUE_ID = rae.UNIQUE_ID INNER JOIN race_ethnicity_codes as rae_codes ON rae.RAE_FULL = rae_codes.CODE GROUP BY agency_name, rae.RAE_FULL

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!

agency_namerace_ethnicityN
CHP-HQ A/C, STAFF Asian 66036
CHP-HQ A/C, STAFF Black/African American 103189
CHP-HQ A/C, STAFF Hispanic/Latino 400048
CHP-HQ A/C, STAFF Middle Eastern/South Asian 57975
CHP-HQ A/C, STAFF Native American 2529
CHP-HQ A/C, STAFF Pacific Islander 6580
CHP-HQ A/C, STAFF White 384932
CHP-HQ A/C, STAFF Multiracial 12132
LAPD Asian 10908
LAPD Black/African American 93913
LAPD Hispanic/Latino 159180
LAPD Middle Eastern/South Asian 10160
LAPD Native American 299
LAPD Pacific Islander 872
LAPD White 58979
LAPD Multiracial 2370
LOS ANGELES CO SD Asian 7717
LOS ANGELES CO SD Black/African American 23754
LOS ANGELES CO SD Hispanic/Latino 66490
LOS ANGELES CO SD Middle Eastern/South Asian 2890
LOS ANGELES CO SD Native American 141
LOS ANGELES CO SD Pacific Islander 746
LOS ANGELES CO SD White 32055
LOS ANGELES CO SD Multiracial 2842
RIVERSIDE CO SO Asian 1374
RIVERSIDE CO SO Black/African American 5259
RIVERSIDE CO SO Hispanic/Latino 19499
RIVERSIDE CO SO Middle Eastern/South Asian 733
RIVERSIDE CO SO Native American 146
RIVERSIDE CO SO Pacific Islander 299
RIVERSIDE CO SO White 16879
RIVERSIDE CO SO Multiracial 316
SAN BERNARDINO CO SO Asian 1832
SAN BERNARDINO CO SO Black/African American 10573
SAN BERNARDINO CO SO Hispanic/Latino 23336
SAN BERNARDINO CO SO Middle Eastern/South Asian 1098
SAN BERNARDINO CO SO Native American 174
SAN BERNARDINO CO SO Pacific Islander 260
SAN BERNARDINO CO SO White 24318
SAN BERNARDINO CO SO Multiracial 842
SAN DIEGO CO SO Asian 1415
SAN DIEGO CO SO Black/African American 3146
SAN DIEGO CO SO Hispanic/Latino 12047
SAN DIEGO CO SO Middle Eastern/South Asian 1179
SAN DIEGO CO SO Native American 322
SAN DIEGO CO SO Pacific Islander 362
SAN DIEGO CO SO White 21680
SAN DIEGO CO SO Multiracial 364
SAN DIEGO PD Asian 4132
SAN DIEGO PD Black/African American 16985
SAN DIEGO PD Hispanic/Latino 25013
SAN DIEGO PD Middle Eastern/South Asian 2251
SAN DIEGO PD Native American 192
SAN DIEGO PD Pacific Islander 760
SAN DIEGO PD White 39217
SAN DIEGO PD Multiracial 905
SAN FRANCISCO PD - DOC Asian 6033
SAN FRANCISCO PD - DOC Black/African American 14369
SAN FRANCISCO PD - DOC Hispanic/Latino 10416
SAN FRANCISCO PD - DOC Middle Eastern/South Asian 3631
SAN FRANCISCO PD - DOC Native American 82
SAN FRANCISCO PD - DOC Pacific Islander 705
SAN FRANCISCO PD - DOC White 19705
SAN FRANCISCO PD - DOC Multiracial 1468