crash_reports
3 rows where dcc = "["Inattention", "Unknown"]", intersection = 0 and keywords contains "Moderate"
This data as json, CSV (advanced)
Suggested facets: speed_limit, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-14
Time:
15:03
Address:
483 DEDHAM ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Vehicle 1 was travelling southbound on Dedham St. Vehicle 2 was travelling southbound on Dedham St. Vehicle 2 rear ended vehicle 1, while both cars were travelling straight ahead. There was major damage to the rear of vehicle 1, and moderate damage to the front right of vehicle 2. Vehicle 2 was towed to Todys lot. The operator of vehicle 1 was transported to NWH for minor injuries. The operator of vehicle 2 sustained no injuries, and signed a patient refusal.
Keywords:
Moderate
Dcc:
Inattention, Unknown
Report
url:
Image
url:
Latitude:
42.3040323
Longitude:
-71.1960518
Location:
Case
number:
Date:
2020-02-14
Time:
14:55
Address:
14 CLOVERDALE RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 operator stated he was travelling on Cloverdale Rd E/B. #1 stated he began veering to the far left to avoid a parked MV on the right side of the road. #1 stated he saw Mv#2 on Cloverdale Rd on the left side of the road but believed #2 was parked as well. #1 attempted to drive between the middle of those two MVs. As a result, #1 driver's side front end struck #2 driver's rear passenger side. #2 operator stated he was not parked but also travelling on Cloverdale Rd W/B. #2 stated he saw #1 veering into his lane of travel. #2 stated he started to brake and move to his right and was forced onto the grassy birm by #1 approaching from the wrong side when #2 was struck by #1. No injuries reported. #1 was towed by Tody's with heavy front end damage. #2 had moderate damage not including rim damage to the driver's side rear wheel which #2 was able to change the flat to a spare on scene and able to drive the MV away.
Keywords:
Moderate
Dcc:
Inattention, Unknown
Report
url:
Image
url:
Latitude:
42.3209143
Longitude:
-71.199644
Location:
Case
number:
Date:
2021-07-20
Time:
17:09
Address:
330 WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 07/20/2021 while assigned to marked cruiser #493 at 17:09, responded to intersection of Walnut St and Highland Ave for MVA with parked vehicle. Upon arrival we met with MV1 driver Ms. Yelena Margolin, who stated that she was traveling northbound on Walnut St. when she felt a thud against her car on the right/passenger side. Ms. Margolin stated that she then realized that her car crashed into open door of MV2 which was parked on Walnut St. Ms. Margolin stated that she did not see MV2 to open the door before the collision because she was focused on driving and oncoming traffic. MV1 had minor damage to right front corner, right side mirror, and moderate damage to right rear door. Then we spoke to MV2 operator Mr. Adam Ruttenberg. Mr. Ruttenberg stated that he parked on Walnut St. and sat in his car for a minute before he decided to open the door to get out. Mr. Ruttenberg could not recall whether or not he checked his mirrors before opening the door. Mr. Ruttenberg stated that as soon as he opened his door, MV1 crashed into his door. Due to the damage caused by collision, Mr. Ruttenberg was not able to close his door and he requested a tow through AAA. All parties involved denied any medical complaints or need for EMS.
Keywords:
Crash, Ems, Moderate
Dcc:
Inattention, Unknown
Report
url:
Image
url:
Latitude:
42.3496903
Longitude:
-71.2065592
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);