Police Data: Crashes | City of Somerville, MA

Police Data: CrashesThis data set contains Somerville crashes that occurred from May 2018 to present. Crash reports are completed when a motor vehicle crash occurs on a public way and involves at least one of the following: Any person is killed, any person is injured, or damage is in excess of $1,000 to any one vehicle or other property. Data does not include crashes that are under active investigation, nor those that occur on state roads, which are under the jurisdiction of the Massachusetts State Police. State crash data may be accessed on the Massachusetts Department of Transportation’s crash data portal, IMPACT. <p>This data set should be refreshed daily with data appearing with a one-month delay (e.g. crashes that occurred from 1/1 will appear on 2/1). If a daily update does not refresh, please email data@somervillema.gov.Visit the full page to view this data.

This view cannot be displayed

Embed this Dataset

      <div><iframe width="_width_px" title="Police Data: Crashes" height="_height_px" src="https://data.somervillema.gov/w/mtik-28va/default?cur=VLk-3TE-IRk&from=1DJ6m9478NV" frameborder="0"scrolling="no"><a href="https://data.somervillema.gov/Public-Safety/Police-Data-Crashes/mtik-28va" title="Police Data: Crashes" target="_blank">Police Data: Crashes</a></iframe><p><a href="http://www.socrata.com/" target="_blank">Powered by Tyler Technologies</a></p></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:

Crash Number: crashnum
Date and Time of Crash: dtcrash
Police Shift: policeshift
Crash Location: address
Light Conditions: ambntlightdesc
Weather Conditions: weathcond1desc
Road Surface: roadsurfdesc
Road Contributing Circumstances: roadcontribdesc
Traffic Control Device Type: trafcntrltypedesc
Roadway Intersection Type: rdwyjuncdesc
Trafficway Description: trafydescrdesc
Manner of Collision: manrcolldesc
First Harmful Event: hrmfeventdesc2
First Harmful Event Location: hrmfeventdesc1
Speed Limit: speedlimit
Work Zone: workzonerelddesc
Count Fatal Injury: fatalinjury
Count Suspected Serious Injury: suspectedseriousinjury
Count Suspected Minor Injury: suspectedminorinjury
Count Possible Injury: possibleinjury
Count No Apparent Injury: noapparentinjury
Count Unknown Injury: unknown
Count Not Reported Injury: notreported
Total Non-Motorists: numnonmotorist
Pedestrian Involvement (Non-Motorist): nonmotoristpedestrian
Cyclist Involvement (Non-Motorist): nonmotoristcyclist
Other Non-Motorist Involvement: nonmotoristother
Non-Motorist Location: nonmtrstlocdesc
Non-Motorist Action: nonmtrstactdesc
Non-Motorist Condition: nonmtrstconddesc
Hit and Run Flag: hitrunflag
Latitude: latitude
Longitude: longitude
Ward: ward
Block Code: blockcode

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 Somerville, MA

API Endpoint:

Field Names:

OData V4 Endpoint:

OData V2 Endpoint:

Want to leave a comment?

You are leaving data.somervillema.gov.

Notice