crash_reports
3 rows where dcc = "["Followed too closely", "Inattention"]" and keywords contains "Ped"
This data as json, CSV (advanced)
Suggested facets: date, intersection, speed_limit, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
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-02-22
Time:
10:10
Address:
HILLSIDE RD & WALNUT ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Mv#1 operator stated she was travelling on Walnut St N/B and looked to her left at a house for sale. #1 stated at that time she rear ended Mv#2 that was stopped in traffic ahead of her. #1 sustained heavy front end damage and was towed by AAA. Mv#2 operator stated he was travelling on Walnut St N/B and slowed to a stop for Mv#3 which came to a stop in front of him for a pedestrian crossing Walnut St at Hillside Rd. #2 stated at that time he was rear ended by #1 and was pushed forward into #3. #2 sustained significant rear end damage and appeared to sustain no damage to the front end. #2 was able to be driven away. Mv#3 operator stated she was travelling on Walnut St N/B at Hillside Rd and slowed to a stop for a pedestrian crossing Walnut St. #3 stated at that time she was rear ended by #2. #3 appeared to sustain no damage to the rear end. No injuries reported.
Keywords:
Ped
Dcc:
Followed too closely, Inattention
Report
url:
Image
url:
Latitude:
42.324184
Longitude:
-71.206984
Location:
Case
number:
Date:
2022-03-11
Time:
08:31
Address:
LOWELL AVE & WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Friday, March 11, 2022, I responded to the area of Washington Street and Lowell Avenue for a report of a motor vehicle crash. The weather at the time of the crash was clear and sunny. The road surface was dry. Washington Street and Lowell Avenue are both public ways maintained by the City of Newton. The operator of MV1, Ms. Caroline Wilson (S14662375), stated she was operating her 2019 Mini Cooper (MA: 7GK482) Southbound on Lowell Avenue towards Washington Street. Ms. Wilson stated she came to a stop at the red light on Lowell Avenue, observed no traffic in the area, and then made a right turn onto Washington Street. Ms. Wilson stated after she completed her right turn, she observed the pedestrian signal activate in front of her and a pedestrian began entering a marked crosswalk on Washington Street to cross. Ms. Wilson stated she stopped her vehicle to allow the pedestrian to cross. Ms. Wilson stated at this time, MV2 crashed into the rear of her vehicle. Ms. Wilson reported no injuries. I observed damage to the rear passenger side of MV1. The operator of MV2, Ms. Geraldine Bartlett (S68389347), stated she was operating her 2020 Jeep Grand Cherokee (Ma: 371TV3) Southbound on Lowell Avenue towards Washington Street. Ms. Bartlett stated she came to a stop at the red light on Lowell Avenue behind MV1. Ms. Bartlett stated she observed MV1 take a right turn onto Washington Street. Ms. Bartlett stated after MV1 made her turn, she observed no traffic in the area. Ms. Bartlett stated she then made a right turn onto Washington Street. Ms. Bartlett stated MV1 stopped in front of her in the roadway and she crashed into the rear of MV1. I observed damage to the front passenger side of MV2. Ms. Bartlett report not injuries. Both vehicles were able to be driven away from the crash scene.
Keywords:
Crash, Crosswalk, Ped, Solar
Dcc:
Followed too closely, Inattention
Report
url:
Image
url:
Latitude:
42.3510472
Longitude:
-71.2106128
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);