crash_reports
2 rows where date = "2021-11-08" 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-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-08
Time:
10:51
Address:
JACKSON & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle 1 stated he was on Washington St (eastbound) at a complete stop for the red light at Jackson Rd when he was struck from behind by vehicle 2. Operator of vehicle 2 stated she took a left turn off of Adams St on to Washington St then suddenly saw vehicle 1 stopped in front of her and rear ended him. Operator believes her snow tires are to blame because there was no snow on the road. Both vehicles were towed by Todys. Both operators were seen by medics and signed patient refusals.
Keywords:
Snow
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3549582
Longitude:
-71.1952442
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);