crash_reports
2 rows where dcc = "["Wrong way"]" and keywords = "["Citation", "Crash"]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-11
Time:
14:56
Address:
BRUSH HILL RD & DEDHAM ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
On 05/11/19 at approximately 14:56 I responded to a two car m.v. crash at the intersection of Dedham St and Brush Hill Rd. The operator of veh #1 stated he was traveling South bound on Dedham St when veh #2 crossed into his lane and struck the front of his car. The operator of veh #1 had right wrist pain but was checked out by the medics and signed a patient refusal. Heavy damage to veh #1 with the drivers side air bag deployed. The operator of veh #2 stated he was driving due North on Dedham St when the next thing he knew he collided with veh #1. The operator of veh #2 was traveling straight ahead when the crash happened. Heavy damage to veh #2 with front and side air bags deployed. The operator of veh #2 signed a patient refusal from Medics was cited in hand Mass #T1444233 for Ch 89/ SEC 4A- Marked Lanes Violation. Both vehicles were towed by Tody's towing.
Keywords:
Citation, Crash
Dcc:
Wrong way
Report
url:
Image
url:
Latitude:
42.3098745
Longitude:
-71.2025402
Location:
Case
number:
Date:
2020-07-17
Time:
15:01
Address:
29 GROVE ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
The operator of MV#1 states that she was traveling east on Grove St in the area of #29 Grove St when MV#2, who was traveling westbound on Grove St crossed the center line and crashed into MV#1. The operator of MV#2 stated that she was traveling west on Grove St and had difficulty maneuvering the sharp curve, crossed the center line and crashed into MV#1. Operator #2 stated that her MV may have had some mechanical issues that prevented her from operating her MV just prior to the crash. Operator #1 transported to NWH with a wrist injury and operator #2 cited for crossing the center line.
Keywords:
Citation, Crash
Dcc:
Wrong way
Report
url:
Image
url:
Latitude:
42.3452887
Longitude:
-71.2468414
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "crash_reports" ( [case_number] TEXT PRIMARY KEY, [datetime] TEXT, [date] TEXT, [time] TEXT, [address] INTEGER, [street1] TEXT, [street2] TEXT, [intersection] INTEGER, [speed_limit] INTEGER, [hit_run] INTEGER, [violation_cited] INTEGER, [narrative] TEXT, [keywords] TEXT, [dcc] TEXT, [dcc_code] TEXT, [report_url] TEXT, [image_url] TEXT , [geocoded_address] TEXT, [latitude] TEXT, [longitude] TEXT, [manual_geocode] INTEGER, [retrieved] TEXT);