City of Atlanta Crime Incidents

The dataset consists of reported crime incidents in the City of Atlanta for the years 2016 and 2017. The data are made publically available by the City of Atlanta Police Department. Some data fields in the original data have been removed because they were more applicable to internal use than public use. The fields Crime Category and Crime Class were added. The values in those two fields represent two levels of grouping of the Crime Type.

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 \"performance-fultoncountyga-gov/city-of-atlanta-crime-incidents-jgdb-bp9a\".\"city_of_atlanta_crime_incidents\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.