crash_reports
5 rows where dcc = "["Followed too closely", "Inattention"]", intersection = 0 and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: speed_limit, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-07
Time:
17:03
Address:
580 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Vehicle one was stopped in traffic when vehicle two rear ended vehicle one. Vehicle two stated she looked down at the radio quick and then rear ended vehicle one. vehicle one was transporting two male parties while working for LYFT. Both male parties of vehicle one were transported to Newton Wellesley Hospital.
Keywords:
Hospital
Dcc:
Followed too closely, Inattention
Report
url:
Image
url:
Latitude:
42.3542305
Longitude:
-71.1975358
Location:
Case
number:
Date:
2019-07-01
Time:
15:15
Address:
31 NAHANTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of Vehicle #1 stated that she was traveling on Nahanton street and stopped to let a golfer cross the street from one side of the country club to the other. Vehicle #1 was rear ended by Vehicle #2 and sustained heavy rear end damage. Vehicle #1 was towed from the scene by David from Tody's. The operator of Vehicle #2 stated that he was traveling on Nahanton Street when a golfer ran across the street in front of Vehicle #1. Operator stated that he couldn't stop and struck Vehicle #1. Vehicle #2 sustained front end damage and was towed from the scene by Bobby from Todys. Both operators were picked up from the scene. No injuries were reported. It should be noted that there is no crosswalk at the location of the crash.
Keywords:
Crash, Crosswalk
Dcc:
Followed too closely, Inattention
Report
url:
Image
url:
Latitude:
42.3002782
Longitude:
-71.1892941
Location:
Case
number:
Date:
2020-01-21
Time:
18:25
Address:
80 WINCHESTER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of Vehicle #1 was traveling North on Winchester street when he stopped in traffic. Vehicle #1 was rear ended by Vehicle #2. Operator of Vehicle #2 was traveling North on Winchester Street when Vehicle #1 stopped. Vehicle #2 struck Vehicle #1. Vehicle #1 sustained damage in the rear. Vehicle #2 sustained front end damage. Both vehicles were towed from the scene by Tody's. Inventory sheets were completed and filed. No injuries were reported.
Keywords:
[]
Dcc:
Followed too closely, Inattention
Report
url:
Image
url:
Latitude:
42.3172866
Longitude:
-71.2087341
Location:
Case
number:
Date:
2020-02-22
Time:
09:26
Address:
15 CYPRESS ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Mv#1 operator stated he was travelling on Cypress St N/B and briefly looked into his rear view mirror. #1 stated at that time he rear ended Mv#2 that was stopped in traffic ahead of him. #2 operator stated she was travelling on Cypress St N/B and slowed to a stop for another MV in front of her whom had stopped for a pedestrian in the crosswalk at #15 Cypress. #2 stated at this time she was rear ended by #1. Mvs #1 and #2 both sustained heavy damage to the passenger side front end and passenger side rear end, respectively. Both towed by Tody's towing. No injuries reported.
Keywords:
Crosswalk, Ped
Dcc:
Followed too closely, Inattention
Report
url:
Image
url:
Latitude:
42.3285638
Longitude:
-71.1951188
Location:
Case
number:
Date:
2020-03-03
Time:
19:29
Address:
675 WATERTOWN ST
Speed
limit:
15
Violation
cited:
no
Narrative:
On Saturday 2/22/2020 at approximately 2200 hours surveillance of the Boys and Girls Club (675 Watertown St Newton MA) captured this motor vehicle accident on camera. The operator of MV 1 was backing out of a parking spot in the parking lot of 675 Watertown St when he struck the rear end of MV 2. MV 2 was parked in front of the lobby of 675 Watertown St when MV 1 rear ended him. The operator of MV 2 has a copy of the surveilance and requested this report for insurance purposes.
Keywords:
Crash
Dcc:
Followed too closely, Inattention
Report
url:
Image
url:
Latitude:
42.354834
Longitude:
-71.2124765
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);