Icon for Socrata external plugin
Open repository in Console
Updated 9 days ago
Indexed 1 day ago

Police Department Crash Data - Updated

List of crashes involving motor vehicles, bicycles and/or pedestrians reported in the City of Cambridge since 2015.

Any data or text that may identify specific persons or companies has been omitted. Please see attached MassTRAC documentation for additional explanation about crash reporting data elements.

Note: crashes involving pedestrians are indicated in the “P1 Non Motorist Desc” and “P2 Mon Motorist Desc” columns. When using Socrata's built in visualization tools to map crashes, please use the geocoded "Location" column. The column "May involve cyclist" specifies whether a given incident may involve a bicycle operator.

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cambridgema-gov/police-department-crash-data-updated-gb5w-yva3\".\"police_department_crash_data_updated\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • police_department_crash_data_updated
Upstream Metadata