crash_reports
1 row where dcc = "["Inattention", "Other improper action"]" and "retrieved" is on date 2021-04-03
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-03-30
Time:
09:58
Address:
612 WASHINGTON ST
Speed
limit:
5
Violation
cited:
no
Narrative:
On 03/30/21 at 09:58 hours, Ofc. Marini (N537) and I (Ofc. Wilson (N523) responded to the parking lot of Tedeschi's located at 612 Washington Street for a two car motor vehicle accident involving a city motor vehicle which belonged to the Newton D.P.W.. At the time of the accident, weather conditions were clear and sunny with dry road conditions. The operator of M/V # 1, Danielle Finklea MA D/L S09835151, states she was eastbound on Washington Street in her 18' Mitsubishi Outlander (MA reg. # 9TM745) and turned right in to the parking lot of Tedeschi's. While pulling in, Finklea misjudged the distance that M/V # 2 was parked in a spot to the left of her. She then struck the right side of M/V # 2's rear bumper which sustained scrape marks to it. The Outlander sustained scrapes to the driver's side front quarter panel area and a broken headlight lens cover to that same side. The other vehicle (M/V # 2) was a 2014 Ford F350 pickup bearing MA Official Reg.# M87258 which is owned by the City of Newton Department of Public Works. At the time, the F350 was parked in a parking spot in front of the store unoccupied. The operator, Robert Mazzarella, stated he saw the F350 shake as it had been struck so he walked over to the other operator involved. No injuries reported. Ofc. Marini took digital photos of the scene and submitted them to the I.T. Bureau.
Keywords:
Crash, Pictures, Solar, Walk
Dcc:
Inattention, Other improper action
Report
url:
Image
url:
Latitude:
42.3538657
Longitude:
-71.198379
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);