Icon for Socrata external plugin
Open repository in Console
Updated 13 hours ago
Indexed 3 hours ago

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"memphistn-gov/police-headcount-iwk8-fxnz\".\"police_headcount\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • police_headcount
Upstream Metadata