crash_reports
1 row where "datetime" is on date 2019-09-16, intersection = 0 and keywords contains "Speed"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-09-16
Time:
17:50
Address:
749 BEACON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On September 16, 2019 at approximately 17:50 hours I, Officer Guarino, responded to the area of 749 Beacon St. for a report of a motor vehicle crash involving a bicycle. Upon arrival with other units, we determined that MV 1 was parked in front of 749 Beacon St.The operator of MV1 opened the door to her vehicle to exit and her door struck a passing bicyclist. Traffic on Beacon St. westbound was stopped, the bicyclist fell off of the bicycle and sustained injuries and was transported to Newton-Wellesley Hospital for further evaluation.As the bicyclist was falling, he struck the rear of MV2, which did not appear to have any damage. The operator of MV1 said she did not see the bicyclist, as she went to exit her vehicle. Witness 1, who was stopped in traffic said that the bicyclist was traveling at a high speed and understood how MV1 did not see the bicycle coming. Officer D. Siegal transported the bicycle to the Newton Police Department and secured it in support services.
Keywords:
Bike, Crash, Hospital, Speed
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3307778
Longitude:
-71.1915316
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);