City of Albany Crime Data(Feb.-Apr.2020)

All crime data on openAlbany is preliminary data and subject to change. The information presented through openAlbany represents Part I victim based crime data. The data does not represent statistics submitted to the FBI's Uniform Crime Report (UCR); therefore any comparisons are strictly prohibited. For further clarification of UCR data, please visit http://www.fbi.gov/about-us/cjis/ucr/ucr. Please note that this data is preliminary and subject to change. Prior month data is likely to show changes when it is refreshed on a monthly basis. All data is geocoded to the approximate latitude/longitude location of the incident and excludes those records for which an address could not be geocoded. Any attempt to match the approximate location of the incident to an exact address is strictly prohibited.

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 \"albanyny-gov/city-of-albany-crime-datafebapr2020-qt5m-6kxz\".\"city_of_albany_crime_datafebapr2020\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.