crash_reports
1 row where dcc = "["Other improper action"]", keywords contains "Speed" and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-08-06
Time:
10:13
Address:
457 WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
City of Newton DPW employee Matthew Dagostino stated that on 08/06/2020 at 10:13 hours he was driving a 2007 International 7400 dump truck south bound on Walnut St in the area of number 457. Walnut St is a public way in the city of Newton. Dagostino stated that the truck was equipped with a sander and it's gross weight was appropriately 26,000 lbs. Dagostino stated that his speed was approximately 25 MPH as he drove past 457 Walnut St. Dagostino stated that a vehicle that was travailing south bound in front of his truck MA reg 491DH5 a 2019 Subaru Impreza stopped short . Dagostino stated that the Subaru stopped to let a pedestrian cross the street. Dagostino stated that when the Subaru stopped abruptly it caught him off guard because there was no marked crosswalk in the area. Dagostino stated when the Subaru stopped short he applied the breaks to his truck and had to turn to the left in an attempt to avoid a crash. Dagostino stated that his truck's front passenger side bumper made contact with the Subaru's rear driver's side bumper and tail light. Dagostino's truck had small scrapes to the front passenger side bumper. Nether operator stated that they were injured and the vehicles were not towed.Lev's vehicle had damage to the rear driver's side bumper and tail light . I took photo's of both vehicle and this disk was tuned over to the NPD's It bureau for downloading. Operator of vehicle two Naomi Lev stated that she was driving south bound on Walnut St when she said she was attempting to turn left into Berwick Rd and stopped to let a pedestrian across over Walnut St . It should be noted that Berwick Rd is approximately 1/2 of a mile south of where the crash occurred. Lev stated that she did stop her vehicle to let a pedestrian across just prior to the crash.
Keywords:
Crash, Crosswalk, Ped, Pictures, Speed
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3449976
Longitude:
-71.2077738
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);