ENDGBV: The Intersection of Domestic Violence, Race/Ethnicity and Sex

This data set contains New York City Police Department count data for domestic violence related offenses (murder, rape, sex offense, felony assault, strangulation and stalking) by the victim's race and the victim's gender for calendar years 2017, 2018 and 2019.

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/endgbv-the-intersection-of-domestic-violence-ge9t-ywzs\".\"endgbv_the_intersection_of_domestic_violence\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.