crash_reports
2 rows where "datetime" is on date 2019-06-24, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (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:
15:55
Address:
871 WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Bicyclist, Tasker Howell, was traveling SOUTH on Watertown St, entering the lane of traffic when MV1 collided with her handlebars and front tire. MV1 (MA Reg: 8SP529, 2018 Ford SUV) was traveling WEST on Watertown St when she collided with the Tasker on the bicycle. MV1 operator, Maria Forgione, stated that while she was traveling on Watertown St, she had a passed a large landscaping truck parked at 857 Watertown St which hindered her seeing Tasker pulling out into traffic on the bicycle. Tasker stated the same, that she saw traffic clear and believed it would be safe to pull out into traffic but the landscaping truck created a blindspot. Tasker was not wearing a helmet. There was damage to MV1 on the passenger front end. Tasker was transported to Newton Wellesley Hospital. Tasker's bicycle was left in her possession at her residence at 871 Watertown St. Pictures were sumbitted to IT.
Keywords:
Bike, Helmet, Hospital, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.351689
Longitude:
-71.2209926
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);