crash_reports
2 rows where "datetime" is on date 2019-06-24, intersection = 0 and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-24
Time:
07:03
Address:
195 PARMENTER RD
Speed
limit:
25
Violation
cited:
no
Narrative:
The owner of MV#1 states that on 6/23/19 at approx. 11:30PM she heard a loud MV crash from her home. Owner was unaware which MV's were involved, but when she looked out her house window she observed a black pick up truck driving off towards Derby St. This morning she discovered that her parked and unoccupied MV was the other MV involved in the crash. MV#1 sustained heavy damage to the rear of her MV and her MV was pushed forward a few feet as a result of the crash. Owner is going to arrange for her own tow as it appears that her rear axel is broken. I searched the area for a black PU with front end damage on the passengers side with negative results.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3596891
Longitude:
-71.2321639
Location:
Case
number:
Date:
2019-06-24
Time:
18:57
Address:
256 ALBEMARLE RD
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was pulling into a parking spot outside of 256 Albemarle Rd (The Gaff Pool) when she collided with a parked car to her right. MV2, the parked vehicle was backed into a parking spot when it was struck by MV1. There was damage to MV1 on the front passenger side wheel area and front bumper. There was no visual damage done to MV2. It appears that MV1 made impact directly on the tire of MV2. MV1 (MA Reg: 6NH473; 2015 Subaru Outback) was being operated by Zhuoyan Xie. MV2 (MA Reg: 5VL268; 2006 Jeep Liberty) was unoccupied.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3576147
Longitude:
-71.2159572
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);