City of Cambridge

Close
Author
Josh Wolff
Description
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.
Category
Public Safety
Tags
crash, accident, motor vehicles, vision zero
Rating
Current value: 0 out of 5
Data Provided By
City of Cambridge Public Safety
Source Link
http://www.cambridgepolice.org
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

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
lanmark_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
damanged_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
:@computed_region_rcj3_ccgu
:@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.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.