search

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 #18

Closed chekos closed 4 years ago

chekos commented 4 years ago

Findings regarding RIPA Stop Data Bullet 3

From the report

query

-- 95.3 percent of stops were officer-initiated, while 4.7 percent of stops were in response to a call for service, radio call, or dispatch.
SELECT
  CALL_FOR_SERVICE as call_for_service,
  COUNT(*) as N,
  PRINTF("%.4f", COUNT(*) * 1.0 / (SELECT COUNT(*) FROM aa_main_table)) as share
FROM
  aa_main_table
GROUP BY
  CALL_FOR_SERVICE