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

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 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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"albanyny-gov/city-of-albany-crime-datafebapr2020-qt5m-6kxz\".\"city_of_albany_crime_datafebapr2020\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • city_of_albany_crime_datafebapr2020