chekos / RIPA-2018-datasette

Publishing datasette of CA's RIPA 2018 data

http://ripa-2018.datasettes.cimarron.io/

GNU General Public License v3.0

0 stars 0 forks source link

Query suggestion #28

Open chekos opened 4 years ago

chekos commented 4 years ago

firearm point and discharge stats by racen

query

select
  rae_codes.RACE_ETHNICITY,
  sum(ADS_FIREARM_POINT),
  sum(ADS_FIREARM_DISCHARGE)
from
  action_taken as at
  inner join race_ethnicity as rae on rae.UNIQUE_ID = at.UNIQUE_ID
  inner join race_ethnicity_codes as rae_codes on rae.RAE_FULL = rae_codes.CODE
group by
  rae.RAE_FULL