crash_reports
5 rows where "datetime" is on date 2019-06-24 and intersection = 0
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-24
Time:
01:27
Address:
61 PEARL ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 stated he was travelling w/b on Pearl St when he "fell asleep" subsequently making contact with 4 parked cars. Operator was evaluated by Cataldo Ambulance who cleared with a patient refusal. MV1 was removed from the scene by Tody's Towing after sustaining heavy passenger side & front end damage. MV2 sustained minor drivers side damage. A note was left on the windshield with this report number for the owner. MV3 sustained heavy drivers side damage. A note was left on the windshield with this report number for the owner. MV4 sustained minor drivers side damage. A note was left on the windshield with this report number for the owner. MV5 sustained minor drivers side damage.A note was left on the windshield with this report number for the owner.
Keywords:
Ems
Dcc:
Inattention, Fatigue/Sleep
Report
url:
Image
url:
Latitude:
42.358457
Longitude:
-71.1879481
Location:
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:
11:49
Address:
821 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
MV 1 was traveling straight going west on Washington Street. MV 2 proceeded to merge into traffic lane from a parked spot. MV 2 did not see MV 1. MV 2 collided into MV 1. MV 1 was not speeding and had the right of way. Minor damage to both vehicles and no injuries.
Keywords:
Speed
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3519466
Longitude:
-71.2067378
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:
Case
number:
Date:
2019-06-24
Time:
18:57
Address:
256 ALBEMARLE RD
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was pulling into a parking spot outside of 256 Albemarle Rd (The Gaff Pool) when she collided with a parked car to her right. MV2, the parked vehicle was backed into a parking spot when it was struck by MV1. There was damage to MV1 on the front passenger side wheel area and front bumper. There was no visual damage done to MV2. It appears that MV1 made impact directly on the tire of MV2. MV1 (MA Reg: 6NH473; 2015 Subaru Outback) was being operated by Zhuoyan Xie. MV2 (MA Reg: 5VL268; 2006 Jeep Liberty) was unoccupied.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3576147
Longitude:
-71.2159572
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);