crash_reports
1 row where keywords contains "Walk" and "retrieved" is on date 2021-03-19
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-03-15
Time:
09:12
Address:
50 UNION ST
Speed
limit:
20
Violation
cited:
no
Narrative:
The owner of MV#1 stated she had parked her vehicle in front of 50 Union St on Saturday 03/13 and discovered a hand written note on her windshield. The note was from a party who witnessed MV#2 struck MV#1. MV#1 sustained minor damages to its driver's side door (Lower panel). I spoke to the witness who stated on Saturday 03/13 at 14:30 he was sitting outside at 45 Union St (The Bar-A-Mor Restaurant) and observed MV#2 attempting to parallel park behind MV#1. The witness stated he heard a loud bang and observed MV#1 shook. The witness then observed 2 Asian parties (1 male party and 1 female party) exit MV#2 while carrying carpet/ rugs walking northbound on Langley Rd. The witness stated he was unsure if the male or the female party was operating MV#2. The witness described MV#2 as a black colored "BMW X5" SUV bearing New York registration GFS4413. The witness stated he was unsure what part of MV#2 made contact with MV#1 but believes it to be either its front passenger side tire area or rear passenger side tire area. I spoke to the operator of MV#2 and she stated she is the owner of a BMW X5 SUV bearing New York registration GFS4413 and was in Newton Massachusetts on Saturday 03/13 delivering some carpet/ rugs to a nearby business. The operator of MV#2 stated she was unaware she had made contact with any vehicles. The operator of MV#2 was forthcoming with her information and provided her driver's license number along with her insurance provider. Based on the statements made to me, I will not pursue this accident further. The operator of MV#2 was provided with this accident report number and advised to contact her insurance provider.
Keywords:
Bus, Crash, Walk
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3297094
Longitude:
-71.1920684
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);