crash_reports
6 rows where "datetime" is on date 2019-04-23 and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, violation_cited, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-04-23
Time:
09:02
Address:
27 WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle one stated that while stopped in traffic north bound on Walnut St near number 27 her vehicle was rear ended by vehicle one. Operator of vehicle two stated that while driving north bound on Walnut St near number 27 his foot came off the clutch pedal causing his vehicle to rear end vehicle one. Neither vehicle had damage and both vehicles did not require tows. Neither operator stated that they were injured. I took photos of both vehicles and forward the disk to the NPD's IT bureau. I cited the operator of vehicle two for a violation of City of Newton Ordnance 19/71 , following to close. Walnut St is a public way in the city of Newton.
Keywords:
Citation, Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3582882
Longitude:
-71.2117107
Location:
Case
number:
Date:
2019-04-23
Time:
08:54
Address:
0 CYPRESS ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator 1 states she was stopped in traffic Northbound on Cypress St when she was struck from behind by vehicle 2. Vehicle 2 states he was stopped in traffic on Cypress St behind vehicle 1. Vehicle 2 was struck from behind by vehicle 3 which pushed vehicle 2 into vehicle 1. Operator 3 states she was traveling Northbound on Cypress St approaching other vehicles stopped in traffic. Operator 3 started to apply her brakes; however, due to the rain and wet roadway her vehicle started to slide as if she had no brakes.Vehicle 3 slid into vehicle 2 and vehicle 2 struck vehicle 1. Vehicles 2 and 3 sustained moderate damage and vehicle 1 sustained minor damage. Operator 2 was transported to Newton-Wellesley Hospital with neck pain.
Keywords:
Hospital, Moderate, Rain
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.32497
Longitude:
-71.19169
Location:
Case
number:
Date:
2019-04-23
Time:
14:35
Address:
150 NEEDHAM ST
Speed
limit:
10
Violation
cited:
yes
Narrative:
On 04/23/19 at approximately 14:35 Officer Gabriel and I responded to #150 Needham St- The Upper Falls Discount Liquor Store for a crash involving two vehicles. Veh #2 backed into parked veh #1. There was slight damage to veh #1 but moderate damage to veh #2. It was later determined operator of veh #2 was operating under the influence of alcohol when she backed into parked veh #1. Veh #2 was towed from the scene by Tody's towing after Officer Gabriel completed a towed vehicle form. Veh #2 registration was queried and came back revoked for insurance. The operator of veh #2 was arrested (NPD Report #19015765) and given in hand Mass. Citation's # T1444225 and T1444226 for Ch 90/Sec 24/J-O.U.I. Liquor, Ch 90 / Sec 24/E- Negligent Operation of a M.V., Ch 90/ Sec 34/J- Operating with out Insurance and Ch 90/ Sec 23 Operating after Registration Revocation.
Keywords:
Alcohol, Citation, Crash, Moderate
Dcc:
Reckless driving
Report
url:
Image
url:
Latitude:
42.3125203
Longitude:
-71.2122908
Location:
Case
number:
Date:
2019-04-23
Time:
17:20
Address:
CRAFTS ST & WALTHAM ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of MV1 states he was traveling westbound on Crafts Street attempting to take a left on Waltham Street when a large SUV in front of him stopped in the middle of the intersection because of oncoming traffic from Waltham Street eastbound. Operator of MV1 states at the time he had a green traffic light, but while in the middle of the intersection it turned red. At that time, the SUV and MV1 attempted to turn left onto Waltham Street when MV2 struck MV1. MV1 sustained damage to the front fender and was towed. Operator of MV2 states he was traveling eastbound on Waltham Street approaching Crafts Street when he saw a large SUV in the middle of the intersection. Operator of MV2 states when he entered the intersection, the SUV took a left onto Crafts Street and when MV2 proceeded into the intersection MV1 appeared from behind the SUV and MV2 struck MV1. Operator of MV2 states MV1 was completely obstructed by the large SUV and didn't know he was in the middle of the intersection. MV2 sustained damage to the left front corner panel and was towed.
Keywords:
[]
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3602838
Longitude:
-71.2220498
Location:
Case
number:
Date:
2019-04-23
Time:
21:26
Address:
38 TANGLEWOOD RD
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 was parked on the side of the road, in front of 38 Tanglewood Rd. MV#2 was traveling east on Tanglewood Rd, and turning North, continuing on Tanglewood Rd. MV#2 crashed into MV#1. Owner of MV#1 stated that she was not in the vehicle at the time. She stated that the operator of MV#2 came and found her to tell her that she had crashed into her. Operator of MV#2 stated that she was turning from east to north on Tanglewood Rd. Operator MV#2 stated that she did not see MV#1 parked on the side of the road, and crashed into it. MV#1 was towed by AAA. MV#2 was driven off scene. No injuries occurred.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3171514
Longitude:
-71.1813173
Location:
Case
number:
Date:
2019-04-23
Time:
20:34
Address:
105 GRANT AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
Vehicle #1 was parked in front of 105 Grant St. and unoccupied when it was struck from behind by Vehicle #2. Vehicle #2 was traveling southbound on Grant St. when they stated they didn't see Vehicle #1 and struck Vehicle #1 from behind. Vehicle #1 had moderate damage to the rear of the vehicle and was unable to be driven. Vehicle #2 had moderate damage to the front and was unable to be driven. Both Vehicle #1 and 2 were towed away by Tody's towing. Operator of Vehicle #2 stated she had wrist pain and was evaluated by medics. Operator of Vehicle #2 was evaluated and signed a patient refusal and declined any additional medical attention.
Keywords:
Moderate
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3359356
Longitude:
-71.1865558
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);