cambridgema-gov/police-department-crash-data-updated-gb5w-yva3
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 1 month 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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cambridgema-gov/police-department-crash-data-updated-gb5w-yva3\".\"police_department_crash_data_updated\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • police_department_crash_data_updated
     
     
     
     
     
Upstream Metadata