Police Department Crash Data - Historical

List of crashes involving motor vehicles, bicycles and/or pedestrians reported in the City of Cambridge from January 2010 through June 2016. Please refer to the dataset "Police Department Crash Data - Updated" for more recent and comprehensive crash data. Please Note: addresses are approximate. Rows for years 2010-2013 were geocoded as part of the MIT Public Safety Data Challenge. Any Latitude/Longitude with a value of 0 indicates that the location was not found though their geocoding efforts. Please see attachment for more details.

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 \"cambridgema-gov/police-department-crash-data-historical-ybny-g9cv\".\"police_department_crash_data_historical\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.