Crime Data

This data comes from the police department and includes crime data sorted by offense. To respect the privacy of juvenile offenses and witnesses the data has been generalized to the hundred block of the event. Cases involving juvenile related data has been removed. The data is updated weekly.

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 \"fortworthtexas-gov/crime-data-k6ic-7kp7\".\"crime_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.