crash_reports
2 rows where "datetime" is on date 2022-06-20, intersection = 0 and keywords contains "Pictures"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-20
Time:
13:42
Address:
124 LANGLEY RD
Speed
limit:
35
Violation
cited:
no
Narrative:
On June 20, 2022 at approximately 1342 hours, I responded to 124 Langley Rd for a report of an MVA. Upon arrival, I spoke with owner of MV2 who stated a man named Patrick Fabrizio saw MV1 strike their MV and continue down the road(see Patricks witness statement). The owner of MV2 stated their vehicle was parked outside of 124 Langley Rd when the incident occurred. I observed damage to the driver's side mirror. Patrick was able to take a photo of MV1 plate and I was able to contact the owner and coordinate an exchange of information among the Owners. Owner of MV1 states she was driving WB on Langley Rd when she struck MV2 side mirror. No injuries or tows to be reported.
Keywords:
Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3287678
Longitude:
-71.1893408
Location:
Case
number:
Date:
2022-06-20
Time:
15:05
Address:
300 NEEDHAM ST
Speed
limit:
5
Violation
cited:
no
Narrative:
Operator of MV1 was parking in a parking spot outside of Pressed Cafe located at 300 Needham St. Operator believed she was in Park but was actually in Drive. Operator mistakenly pressed on the gas and accelerated over the curb and through a large window and ended up inside of Pressed Cafe. Operator and her daughter, Brynn Bryant, were trapped in the vehicle and freed by NFD. Operator and Brynn were transported to Newton Wellesley Hospital. The other 2 passengers, Gabe Cohen and Marc Andrew, were not trapped and declined any medical attention and left the scene after speaking with the medics. MV1 was towed by Todys. Nobody inside Pressed Cafe was injured. John Faggiano was standing next to where the car went through the building but declined any medical attention. Pictures and a video of the accident from the security system was sent to IT to attach to the report.
Keywords:
Crash, Fire, Hospital, Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
Longitude:
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);