Staffing - Representation

This Indicator measures the rate of sworn staff in OPD per 100,000 people of the same race/ethnicity in Oakland, in other words how representative are the sworn staff of the Oakland population? Numbers of sworn staff are as of February 28, 2018.

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/staffing-representation-sri7-xyr3\".\"staffing_representation\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.