crash_reports
3 rows where dcc = "[]", intersection = 0 and "retrieved" is on date 2021-06-29
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-06-02
Time:
15:50
Address:
21 HALE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 06/02/2021 at 19:19 hours I was dispatched to 21 Hale St for a report of a past MVA involving a bike. Upon my arrival I spoke with Jason Lobell who stated approximately three and a half hours prior at 15:50 hours he was moving his vehicle MA reg 1CTG62 a 2017 Toyota Corolla from where it was parked on Hale St into his driveway at number 21. The Toyota was parked across from number 21 facing north bound. Lobell stated that as he was turning left into his driveway at approximately 5 MPH a male bicyclist that was riding north bound on Hale St attempted to pass his vehicle on the left. Lobell stated that the bicyclist drove into the front drivers side of his vehicle. Lobell stated that the impact of the bicyclist riding into his vehicle caused the driver's side mirror to be damaged. Lobell stated that the bicyclist did not stop and did not exchange any information. The only description that Lobell had of the bicyclist was a male of an unknown race that was approximately 20 years of age. I canvassed the area with negative results. As of the writing of this report at 21:00 hours on 06/02/2021 no bicyclist has reported being involved in a MVA in the area of 21 Hale St.
Keywords:
Bike, Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.312159
Longitude:
-71.2234395
Location:
Case
number:
Date:
2021-06-16
Time:
19:59
Address:
1897 WASHINGTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
MV1 was parked in the parking lot of 1897 Washington St., the Woodland Country Club when it was struck by a vehicle that was believed to be pulling out from next to it. The operator of MV1 stated that the vehicle was parked at 2:30 and noticed the damage to the front left side of the vehicle when leaving around 4PM. Operator of MV1 stated that the Woodland Country Club has security footage of the incident and would be able to bring the footage in at a later time. Operator of MV1 stated the vehicle that was parked next to her was white as well as the paint she noticed on her vehicle. The operator stated she was unsure of the make of the model of the vehicle next to hers and did not have the vehicles license plate. It should be noted that MV1 sustained minimal damage and was still able to be operated.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3365452
Longitude:
-71.2460112
Location:
Case
number:
Date:
2021-06-24
Time:
09:20
Address:
140 ADAMS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 06/24/21 at 09:20 hours, I (Traffic Unit 523) was dispatched to 140 Adams Street for a city motor vehicle accident involving a Waste Management truck and a parked motor vehicle. Waste Management of Mass Inc. is contracted through the City of Newton to conduct trash pickup for the residents. The weather at the time was sunny and partly cloudy with road conditions being dry. Adams Street is a public way owned and maintained by the City of Newton. On arrival, I spoke to the operator of the Waste Management Truck identified as Jose Lopes (MA D/L # S60186065). Mr. Lopes was operating (M/V # 1) a 2010 Mack Leu dump truck bearing MA. Commercial Reg. # N81671 at the time. It is a right side loading truck that picks up the trash using a double claw mechanism. Lopes states that he did a trash pickup in the driveway right before 140 Adams Street and proceeded to drive northbound on Adams Street. While doing so, the left side double claw retracted back outward after it was closed by him. The claw then struck parked M/V # 2 which was parked in a legal spot in front of 140 Adams Street. The claw struck the driver's side rear bumper/taillight area and scraped along until the driver's side rear passenger door. Mr. Lopes then stopped the truck after noticing. This caused scrapes and dents to the rear bumper, rear quarter panel, and the rear door to that driver's side area. After, I was showed that the truck's claw feature was having mechanical failure as mentioned above. The claw was manually pushed in and secured. The truck was then put out of service. M/V # 2 is a 2013 Jeep Compass color blue bearing MA reg. # 3055GB. The owner Joseph Cedrone (MA D/L # S50190711) was parked and inside his vehicle at the time of the accident. No injuries were reported by him. Digital photos taken of the scene.
Keywords:
Crash, Pictures, Solar
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3598396
Longitude:
-71.2018497
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);