Somerville Police Crash Reports from 2018

Somerville, Massachusetts crash reports from May 2018 onward, collected by the Somerville Police Department. Data includes crashes on public ways involving fatalities, injuries, or property damage over $1,000, excluding state roads and active investigations. The dataset is refreshed daily with a one-month reporting delay.

Use Cases

• Analyze crash severity by correlating 'Count Suspected Serious Injury' with 'Weather Conditions' and 'Light Conditions'.
• Identify high-risk intersections for pedestrians and cyclists using 'Pedestrian Involvement (Non-Motorist)', 'Cyclist Involvement (Non-Motorist)', and 'Crash Location' coordinates.
• Model contributing factors for hit-and-run incidents by examining 'Hit and Run Flag' against 'Police Shift' and 'Traffic Control Device Type'.
• Assess road surface and trafficway impact by linking 'Road Surface' and 'Trafficway Description' to 'First Harmful Event'.

Strengths

• Contains detailed crash attributes including 29 columns such as injury counts, environmental conditions, and geospatial coordinates.
• Time-series data with daily updates, providing ongoing coverage from May 2018 to present.

Limitations

• Excludes crashes on state roads and those under active investigation, limiting geographic and temporal completeness.
• Sample size and total row count are unknown, preventing assessment of statistical power.

Provenance

Source

Somerville Police Department, via data.somervillema.gov.

Collection Method

Police crash reports filed when a motor vehicle crash on a public way meets specific severity criteria.

Time Range

From May 2018 to present.

Freshness

Refreshed daily with a one-month reporting delay.

Geography

Somerville, Massachusetts, USA (excluding state roads).