NYPD Complaint Data Current (Year To Date)

This dataset includes all valid felony, misdemeanor, and violation crimes reported to the New York City Police Department (NYPD) for all complete quarters so far this year (2019). For additional details, please see the attached data dictionary in the ‘About’ section.

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-complaint-data-current-year-to-date-5uac-w243\".\"nypd_complaint_data_current_year_to_date\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.