crash_reports
3 rows where "datetime" is on date 2020-06-25 and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-06-25
Time:
00:10
Address:
34 HEREWARD RD
Speed
limit:
20
Violation
cited:
no
Narrative:
Operator of MV 1 stated that he backed into MV2 while conducting a three point turn. MV 2 was unoccupied and legally parked.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3247966
Longitude:
-71.1975555
Location:
Case
number:
Date:
2020-06-25
Time:
09:06
Address:
21 LEWIS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle one, Waste Management employee Kevin Mellett, stated that on 06/25/2020 at 09:06 hours while driving south bound (MA Con reg V42947 a 2020 Mack Trash truck) his vehicle struck an unoccupied vehicle that was parked facing south in front of 21 Lewis St. Lewis St is a public way in the City of Newton. The parked vehicle was MA Con reg T37787 a 2014 Toyota pick up truck registered to AAA Sparkling Window Cleaning. Mellett stated that the mechanical arm that is used to pick up trash barrels was not in the fully closed position. Mellett stated that the his truck's mechanical arm was still partially extended and that the clamps on the arm were in the open position when he attempted to pass the parked vehicle. I told Mellett it was my understanding that the trash truck could not be put into drive as long as the arm was still extended. Mellett stated that the truck can be driven with the arm still partially extended. Vehicle one had no damage and vehicle two had damage to it's rear driver's side bumper and lower quarter panel. Neither vehicle required a tow, and I took photos of both vehicles. Based upon Mellett's statements I issued him MA citation T2015996 and cited him for a violation of City of Newton Ordinance 19/75, failure to use care while starting.
Keywords:
Citation, Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3519862
Longitude:
-71.1963505
Location:
Case
number:
Date:
2020-06-25
Time:
11:04
Address:
55 PINE GROVE AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On 6/25/2020 at approx 1104hrs while assigned to 497 I responded to 55 Pine Grove Av for a report of a past hit and run. Upon arrival I met with the owner of Ma Reg 24D110 , Colleen Hall who stated she had come to visit her boyfriend Brad Mayer who lives at 55 Pine Grove Ave on 6/24/2020 at approx 2200hrs and parked in the street infront of the residence. Upon returning to her car today at approx 1000hrs she discovered the damage. Her vehicle a white 2013 Honda Accord had scuff marks down the rear left quarter and several of the plastic clips holding the bumper in place appeared to be broken, the rear left lens cover was chipped.
Keywords:
[]
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3318644
Longitude:
-71.2599739
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);