crash_reports
2 rows where date = "2021-11-05" and "retrieved" is on date 2021-11-16
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-05
Time:
09:13
Address:
CENTRE ST & COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
THE OPERATOR OF MV#1 STATED HE WAS TRAVELING WEST-BOUND ON COMMONWEALTH AVE WITH A GREEN LIGHT WHEN HE STRUCK MV#2. THE OPERATOR OF MV#2 STATED HE WAS TRAVELING NORTH-BOUND ON CENTRE STREET, GOT STUCK IN THE INTERSECTION, OBSTRUCTED BY SOME TYPE OF BUS, WHEN HE STRUCK MV#1. BOTH OPERATORS HAD NO INJURIES. MV#1 HAD DAMAGE TO THE D/S FRONT AND MV#2 HAD DAMAGE TO THE P/S FRONT. MV#2 WAS TOWED BY TODYS TOWING. THERE WAS NO AIRBAG DEPLOYMENT. THERE WERE NO INJURIES DUE TO THIS ACCIDENT.
Keywords:
Airbag, Bus, Crash
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3365124
Longitude:
-71.1932597
Location:
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:
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);