Attrition from Academy

This Indicator measures the attrition rate by race/ethnicity of police officers from the Oakland Police Department’s Academies over the past 3 years (since the start of 2015). This includes the last six OPD academies (172nd-177th) as well as lateral academies and SFPD-managed academies.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"oaklandca-gov/attrition-from-academy-5rwp-vgpg\".\"attrition_from_academy\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.