crash_reports
1 row where "datetime" is on date 2020-02-07, dcc contains "Unknown" and keywords contains "Bus"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-02-07
Time:
10:36
Address:
25 BOYLSTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
On Friday, February 7, 2020 while assigned to Traffic unit N525, I responded to the rear parking lot of 1 Boylston Street, Newton for a report of a hit and run motor vehicle crash. I spoke with the operator of MV1, Hong Zhang (S39408212). Zhang stated while operating her 2019 Volkswagon Tiguan (MA: 6YJF90), she was attempting to back out of a parking spot in the parking lot behind 25 Boylston Street, Newton. Zhang stated while backing out of the spot she crashed into an unknown vehicle traveling Westbound through the parking lot. Zhang stated the only information she had for the other vehicle was that it was a large red and black truck. I observed damage to the rear trunk window of MV1. Zhang reported no injuries. Zhang stated she was unsure if she hit the vehicle or if something fell off of it as it was passing by. I went to several local businesses in the area in an attempt to view surveillance footage of the area where the accident occurred with a negative result. While canvassing the area for the other vehicle involved, I observed a red dump truck (MA CON: T71619) removing snow on the property next to Hammond Pond Parkway. The operator stated he has been working down that end of the parking lot for most of the morning and stated he was not involved in a crash. I observed no fresh damage to the vehicle consistent with a crash.
Keywords:
Bus, Crash, Snow
Dcc:
Inattention, Unknown
Report
url:
Image
url:
Latitude:
42.3231975
Longitude:
-71.1669923
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);