Police Department Crash Data - Updated | Open Data Portal

Police Department Crash Data - UpdatedList 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.Visit the full page to view this data.

This view cannot be displayed

Embed this Dataset

      <div><iframe width="_width_px" title="Police Department Crash Data - Updated" height="_height_px" src="https://data.cambridgema.gov/w/gb5w-yva3/t8rt-rkcd?cur=-gKLmgvsF__&from=hQTNnuYSZ0h" frameborder="0"scrolling="no"><a href="https://data.cambridgema.gov/Public-Safety/Police-Department-Crash-Data-Updated/gb5w-yva3" title="Police Department Crash Data - Updated" target="_blank">Police Department Crash Data - Updated</a></iframe></div>

Size

500x425
760x646
950x808

Custom Size

425x425 is the minimum size

Width

Height

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Date Time: date_time
Day of Week: day_of_week
Object 1: object_1
Object 2: object_2
Street Number: street_number
Street Name: street_name
Cross Street: cross_street
Near Street: near_street
Location: location
May involve cyclist: may_involve_cyclist
May Involve Pedestrian: may_involve_pedestrian
Manner of Collision: manner_of_collision
First Harmful Event Location: first_harmful_event_location
First Harmful Event: first_harmful_event
Ambient Light: ambient_light
Weather Condition 1: weather_condition_1
Weather Condition 2: weather_condition_2
Traffic Control Device Type: traffic_control_device_type
Traffic Control Device Functionality: traffic_control_device_functionality
Road Surface Condition: road_surface_condition
Roadway Junction Type: roadway_junction_type
Trafficway Description: trafficway_description
School Bus Related: school_bus_related
Work Zone: work_zone
Speed Limit: speed_limit
Street or Intersection: street_or_intersection
Intersection Name 1: intersection_name_1
Intersection Direction 1: intersection_direction_1
Intersection Name 2: intersection_name_2
Intersection Direction 2: intersection_direction_2
Intersection Name 3: intersection_name_3
Intersection Direction 3: intersection_direction_3
Street Direction: street_direction
Nearest Intersection Distance: nearest_intersection_distance
Nearest Intersection Direction: nearest_intersection_direction
Landmark Distance: landmark_distance
Landmark Direction: landmark_direction
Landmark: landmark
Mile Marker Direction: mile_marker_direction
Non Public Area: non_public_area
Road Contributing: road_contributing
Damaged Property Type: damaged_property_type
Description of Damaged Property: description_of_damaged_property
V1 Registration Type: v1_registration_type
v1 State Code: v1_state_code
V1 Configuration: v1_configuration
V1 Emergency Response: v1_emergency_response
V1 Moped: v1_moped
V1 Hit and Run: v1_hit_and_run
V1 Action Prior to Crash: v1_action_prior_to_crash
V1 Model Year: v1_model_year
V1 Most Harmful Event: v1_most_harmful_event
V1 Model: v1_model
V1 Make: v1_make
V1 Occupant Count: v1_occupant_count
V1 Underride Override: v1_underride_override
V1 First Event: v1_first_event
V1 Second Event: v1_second_event
V1 Third Event: v1_third_event
V1 Fourth Event: v1_fourth_event
V1 Most Damaged Area: v1_most_damaged_area
V1 Second Damaged Area: v1_second_damaged_area
V1 Third Damaged Area: v1_third_damaged_area
V1 Towed: v1_towed
V1 Travel Direction: v1_travel_direction
V1 Interstate: v1_interstate
V1 Cargo Body Type: v1_cargo_body_type
V1 Gross Weight: v1_gross_weight
V1 Haz Placard: v1_haz_placard
V1 Haz Release: v1_haz_release
V1 Trailer Reg Type: v1_trailer_reg_type
V1 Trailer Reg Plate: v1_trailer_reg_plate
V1 Trailer Reg State: v1_trailer_reg_state
V1 Trailer Reg Year: v1_trailer_reg_year
V1 Trailer Len: v1_trailer_len
V1 Driver Contribution: v1_driver_contribution
V1 Driver Contribution 2: v1_driver_contribution_2
V1 Is Truck: v1_is_truck
V1 Has Trailer: v1_has_trailer
V1 Is Bus: v1_is_bus
V1 Is Hazmat: v1_is_hazmat
V1 Reg Year: v1_reg_year
V1 Driver Distracted: v1_driver_distracted
V1 Bus Use: v1_bus_use
V1 Tow Use: v1_tow_use
V2 Registration Type: v2_registration_type
V2 State Code: v2_state_code
V2 Configuration: v2_configuration
V2 Emergency Response: v2_emergency_response
V2 Moped: v2_moped
V2 Hit and Run: v2_hit_and_run
V2 Action Prior to Crash: v2_action_prior_to_crash
V2 Model Year: v2_model_year
V2 Most Harmful Event: v2_most_harmful_event
V2 Model: v2_model
V2 Make: v2_make
V2 Occupant Count: v2_occupant_count
V2 Underride Override: v2_underride_override
V2 First Event: v2_first_event
V2 Second Event: v2_second_event
V2 Third Event: v2_third_event
V2 Fourth Event: v2_fourth_event
V2 Most Damaged Area: v2_most_damaged_area
V2 Second Damaged Area: v2_second_damaged_area
V2 Third Damaged Area: v2_third_damaged_area
V2 Towed: v2_towed
V2 Travel Direction: v2_travel_direction
V2 Interstate: v2_interstate
V2 Cargo Body Type: v2_cargo_body_type
V2 Gross Weight: v2_gross_weight
V2 Haz Placard: v2_haz_placard
V2 Haz Release: v2_haz_release
V2 Trailer Reg Type: v2_trailer_reg_type
V2 Trailer Reg Plate: v2_trailer_reg_plate
V2 Trailer Reg State: v2_trailer_reg_state
V2 Trailer Reg Year: v2_trailer_reg_year
V2 Trailer Len: v2_trailer_len
V2 Driver Contribution: v2_driver_contribution
V2 Driver Contribution 2: v2_driver_contribution_2
V2 Is Truck: v2_is_truck
V2 Has Trailer: v2_has_trailer
V2 Is Bus: v2_is_bus
V2 Is Hazmat: v2_is_hazmat
V2 Reg Year: v2_reg_year
V2 Driver Distracted: v2_driver_distracted
V2 Bus Use: v2_bus_use
V2 Tow Use: v2_tow_use
P1 Role: p1_role
P1 Injury: p1_injury
P1 Drivers Lic State: p1_drivers_lic_state
P1 Drivers Lic Class 1: p1_drivers_lic_class_1
P1 Drivers Lic Class 2: p1_drivers_lic_class_2
P1 Drivers Lic Restrict: p1_drivers_lic_restrict
P1 Non Motorist Desc: p1_non_motorist_desc
P1 Non Motorist Action: p1_non_motorist_action
P1 Non Motorist Location: p1_non_motorist_location
P1 Safety Equipment: p1_safety_equipment
P1 Age: p1_age
P1 Sex: p1_sex
P1 Seat Position: p1_seat_position
P1 Safety System: p1_safety_system
P1 Trapped: p1_trapped
P1 Veh Owner: p1_veh_owner
P2 Role: p2_role
P2 Injury: p2_injury
P2 Drivers Lic State: p2_drivers_lic_state
P2 Drivers Lic Class 1: p2_drivers_lic_class_1
P2 Drivers Lic Class 2: p2_drivers_lic_class_2
P2 Drivers Lic Restrict: p2_drivers_lic_restrict
P2 Non Motorist Desc: p2_non_motorist_desc
P2 Non Motorist Action: p2_non_motorist_action
P2 Non Motorist Location: p2_non_motorist_location
P2 Safety Equipment: p2_safety_equipment
P2 Age: p2_age
P2 Sex: p2_sex
P2 Seat Position: p2_seat_position
P2 Safety System: p2_safety_system
P2 Trapped: p2_trapped
P2 Veh Owner: p2_veh_owner
Police Neighborhood Regions: :@computed_region_guic_hr4a
Police Response Districts: :@computed_region_v7jj_366k
cambridge_neighborhoods: :@computed_region_rffn_qbt6
cambridge_cdd_zoning: :@computed_region_swkg_bavi
Census Blocks 2010: :@computed_region_e4yd_rwk4
cambridge_zipcodes: :@computed_region_rcj3_ccgu

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

City of Cambridge

API Endpoint:

Field Names:

OData V4 Endpoint:

OData V2 Endpoint:

Want to leave a comment?

You are leaving data.cambridgema.gov.

Notice