Police Headcount

Dataset that contains the historical number of sworn commissioned officers for the Memphis Police Department. The dataset also contains some statistical info about the 13-month rolling average of the number of officers, and confidence intervals around the number of officers. Additionally, there is information about the projected number of officers through 2020.

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 \"memphistn-gov/police-headcount-iwk8-fxnz\".\"police_headcount\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.