crash_reports
3 rows where dcc contains "Unknown" and "retrieved" is on date 2021-09-25
This data as json, CSV (advanced)
Suggested facets: date, intersection, speed_limit, hit_run, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-09-09
Time:
16:14
Address:
AUSTIN ST & LOWELL AVE
Speed
limit:
20
Violation
cited:
no
Narrative:
On 9/9/21, at 1614 hrs, Newton Police and Fire personnel responded to Lowell Ave. at Austin S. for a motor vehicle accident involving a City of Newton student transportation van. Upon arrival, all involved parties including students reported no injuries. Each student's guardian was contacted and responded to the scene to sign a patient refusal and take custody of their child. The operator of MV#1 stated he made a complete stop at the stop sign on Austin St. prior to crossing westbound over Lowell Ave. As MV#1 proceeded across the intersection he was struck on the passenger side by MV#2 (JCS transport van) which was traveling south on Lowell Ave. The operator of MV#2 stated he was traveling south on Lowell Ave. approaching the intersection of Austin St. when he observed MV#1 crossing westbound on Lowell Ave. The operator of MV#2 stated due to the rain and slick conditions he could not stop his vehicle in time prior to colliding into MV#1. No damage was observed to MV#2 (JCS transportation van) however MV#1 sustained damage to its passenger side front and rear door. Both vehicles were able to be driven from the scene. Pictures of the damage were captured on the N492 camera and will be attached to this report. Both operators were given directions on how to obtain a copy of this report.
Keywords:
Crash, Fire, Pictures, Rain
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3502544
Longitude:
-71.2108899
Location:
Case
number:
Date:
2021-09-17
Time:
16:44
Address:
125 DERBY ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV1 stated at approximately 1450 hrs she parked her vehicle facing westbound on Derby Street. When she came outside from picking up a family member at school her vehicle was struck on the driver side. The mirror was damage and the rear driver side was also damaged. Witnesses stated they heard a bang but did not get a plate number. Witnesses stated the vehicle was a blue sedan. The operator of MV1 was not injured.
Keywords:
School
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3583035
Longitude:
-71.2286202
Location:
Case
number:
Date:
2021-09-17
Time:
15:11
Address:
BEACON ST & HAMMOND POND PKWY
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated he was traveling eastbound on Beacon Street when MV2, who was traveling in front of him, made a u-turn and collided with the passenger side of his car. Operator of MV2 refused to give a statement or answer any questions regarding what happen without a lawyer present. Both parties stated they were not injured and refused medical attention. MV1 sustained moderate damage to the passenger side, and MV1 had slight damage to the front end. Both cars were able to drive from the scene.
Keywords:
Moderate
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3321327
Longitude:
-71.1812114
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);