Collisions involving vehicles managed by Department of Health and Mental Hygiene (DOHMH)

The total number of City-vehicle operated vehicles that are managed by DOHMH that were involved in collisions involving injury or property damage for the citywide fleet reported in the citywide collision reporting system (CRASH). New York State MV-104 reports are required whenever a collision occurs involving death, or other personal injury, or property damage over $1,000. Collisions are tracked and reported regardless of whether or not the driver was at fault and whether or not the vehicle was in motion. Collisions involving City vehicles occur whenever a City vehicle strikes (or is struck by) a second vehicle, pedestrian, bicyclist or fixed object

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/collisions-involving-vehicles-managed-by-knr6-vurn\".\"collisions_involving_vehicles_managed_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.