crash_reports
3 rows where intersection = 0, keywords contains "Solar" and "retrieved" is on date 2021-11-16
This data as json, CSV (advanced)
Suggested facets: dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-05
Time:
13:04
Address:
36 GREYLOCK RD
Speed
limit:
25
Violation
cited:
no
Narrative:
On Friday November 5th 2021, at approximately 1304 hours I responded to the area of 36 Greylock Road for a two car motor vehicle accident involving a city contracted Waste Management receptacle truck. At the time of the accident the weather was sunny and the road conditions were dry. Greylock Road is owned and maintained by the City of Newton. Upon arrival I spoke with the operator of the garbage truck identified by RI License 9898223, as Norbin Cordon. Norbin stated he was operating the garbage truck and travelling westbound on Greylock Rd. Due to cars parked on both sides of the road he stopped to let another vehicle go by him coming from the opposite direction. The other vehicle stopped at the bend to let the garbage truck go by. Norbin stated it was a tight squeeze and when he tried to make his way through his rear drivers side tires made contact with the drivers side panel of the other vehicle. The only damage to the garbage truck was a smudge on the tire. Norbin reported no injuries. I then spoke with the operator of the other vehicle involved, identified by Mass Lic as Jane Lewis S79838916. Jane stated she was traveling eastbound on Greylock Road and stopped in the road to let the garbage truck pass. As the truck attempted to pass it struck her rear drivers side panel causing moderate body damage. Jane reported no injuries. Several photographs of both vehicles were taken and submitted to the IT Bureau. Jane's vehicle was able to drive and she left without further incident.
Keywords:
Crash, Moderate, Pictures, Solar
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3456597
Longitude:
-71.2148898
Location:
Case
number:
Date:
2021-11-08
Time:
08:55
Address:
182 WEBSTER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Monday November 8th, 2021 at approximately 0855 hours I responded to the area of 182 Webster Street for a motor vehicle accident involving a City of Newton DPW truck. At the time of the accident the weather was sunny and the road surface was dry. Webster Street is owned and maintained by the City of Newton. Upon arrival I spoke with the operator of the city vehicle identified by Mass License as Michael Cannistraro S40721835. Michael stated he was travelling eastbound on Webster Street when the other vehicle involved backed out of the driveway and struck the front passenger side bumper of the truck. Michael reported no injuries and the vehicle was drive able. I then spoke with the operator of other vehicle involved, identified by Mass permit license as Sophia Mercado SA5660670. Sophia stated she was backing out the driveway and stopped, and that is when the DPW struck her rear end. Sophia reported no injuries and minor damage to the vehicle was reported. The vehicle was drive able and several pictures of the vehicles were taken and submitted to the IT Bureau.
Keywords:
Crash, Pictures, Solar
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3485452
Longitude:
-71.2346829
Location:
Case
number:
Date:
2021-11-09
Time:
16:49
Address:
50 EDDY ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 11/9/21 Alexandra Hogan came to NPD Headquarters to report a past mva that occurred at 0730hrs today. Hogan states she was driving southbound on Eddy St in MA reg WS1543 (vehicle #1), when she observed MA reg CI396B (vehicle #2) driving down the middle of the road northbound. Hogan was unable to swerve out of the way and contact was made. She reports extensive damage to the front left side of her vehicle. Operator #2 left her information with Hogan and allegedly stated that the sun was in her eyes. She was apologetic. Attempts to call operator #2 were met with negative results. Hogan reports no injuries but needed documentation for her insurance company.
Keywords:
Severe, Solar
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3513132
Longitude:
-71.2160988
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);