crash_reports
3 rows where "datetime" is on date 2020-08-20
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-08-20
Time:
07:31
Address:
HOMER ST & WALNUT ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Mv#1 operator stated she was in the right lane (right turn only) on Homer St E/B at the Walnut St intersection. #1 stated the MV beside her in the left lane started rolling forward. #1 stated as a result, she believed the light was green but stated she never saw the light (red) prior to proceeding. #1 stated at that time, she proceeded straight ahead through the intersection and struck Mv#2 that was travelling straight ahead on Walnut St N/B. Mv#2 operator stated he was travelling straight ahead on Walnut St N/B. #2 stated while approaching the Homer St intersection he had a solid green light and proceeded straight ahead. #2 stated #1 suddenly appeared from his left going through the red light and struck him in the intersection. No injuries reported. Both Mv's sustained heavy front end damage, including airbag deployment in #2. Both were towed by Tody's. #1 operator cited in hand for violation of Ch89/Sec 4A Marked Lanes Violation and Ch89/Sec9 F/C Red Light.
Keywords:
Airbag, Citation
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.33615
Longitude:
-71.20708
Location:
Case
number:
Date:
2020-08-20
Time:
15:33
Address:
ADAMS ST & WATERTOWN ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
The operator of MV 1 was traveling westbound on Watertown St and attempted to pass MV 2 on the right. While trying to pass MV 2, the operator of MV 1 struck MV 2's right side. The operator of MV 2 was attempting to make a right hand turn Northbound onto Adam St from Westbound on Watertown St. While making the turn MV 2 struck his right side. MV 1 sustained major damage to the front left part of the vehicle. The vehicle was towed by Tody's. A towed motor vehicle inventory sheet was filled out and filed. MV 2 sustained minor damage to the right side and was able to be driven away. The operator of MV 1 was issued citation T 2080795 M.G.L 89/4 (unsafe passing).
Keywords:
Citation
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3599932
Longitude:
-71.202353
Location:
Case
number:
Date:
2020-08-20
Time:
15:27
Address:
1897 WASHINGTON ST.
Speed
limit:
30
Violation
cited:
no
Narrative:
MV/1 stated she was stopped on Washington St. waiting to turn left into Woodland Golf Country Club. While waiting to turn left MV/1 was struck by MV/2. Mv/2 had struck the right rear bumper of MV/1. The driver of MV/2 stated that he was heading East bound on Washington St. when he was cut off by another driver causing him to stear to the left and strike MV.1 with the right front corner of his bumper. Both MV/1 and MV/2 stated there was heavy amounts of traffic.
Keywords:
[]
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3365452
Longitude:
-71.2460112
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);