NYPD Arrests Data (Historic)

List of every arrest in NYC going back to 2006 through the end of the previous calendar year. This is a breakdown of every arrest effected in NYC by the NYPD going back to 2006 through the end of the previous calendar year. This data is manually extracted every quarter and reviewed by the Office of Management Analysis and Planning before being posted on the NYPD website. Each record represents an arrest effected in NYC by the NYPD and includes information about the type of crime, the location and time of enforcement.

In addition, information related to suspect demographics is also included.

This data can be used by the public to explore the nature of police enforcement activity.

Please refer to the attached data footnotes for additional information about this dataset.

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 \"cityofnewyork-us/nypd-arrests-data-historic-8h9b-rp9u\".\"nypd_arrests_data_historic\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.