crash_reports
1 row where dcc_code = "[3]" and "retrieved" is on date 2021-12-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-26
Time:
16:19
Address:
WALNUT ST & WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 11/26/2021, at 1619 hrs, Newton Police were dispatched to the intersection of Watertown St. and Walnut St. (both public ways within the City of Newton) for a motor vehicle collision involving two vehicles. The operator of MV#1 stated they had a green light as the were traveling southbound on Walnut St. through the intersection of Watertown St. when MV#2 collided into their passenger side. The operator of MV#1's (2) infant children were located within child protection devices in the second row of the vehicle and were reported to be uninjured. The operator of MV#1 and his wife whom was seated in the front seat of the vehicle declined medical attention for themselves and their children. The operator of MV#2 admitted to police he was turning right (southbound) onto Walnut St. from Watertown St. when he collided into the passenger side of MV#1. There is a posted "No turn on right" sign on the corner of Watertown St. and Walnut St. Damage to MV#1 and MV#2 was consistent with MV#2 colliding into MV#1's passenger side. Both vehicles were able to be driven from the scene and the operator of MV#2 was issued Ma Uniform Citation; T20144922 for: Mgl Ch. 89. Sec 9. Red light violation. Mgl Ch. 90. Sec. 11. No License in Possession.
Keywords:
Citation
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3558631
Longitude:
-71.2090326
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);