crash_reports
2 rows where dcc = "[]", intersection = 0 and "retrieved" is on date 2021-10-01
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-09-27
Time:
23:10
Address:
926 WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator 1 stated she was traveling Southbound on Walnut St and tried to turn left into her driveway located at 926 Walnut St. As she tried to pull into her driveway, her vehicle got stuck in a ditch that was dug up by the city. There was also about an inch of water in the ditch, it is unknown if it was related to the excavation work. It should be noted that there was no cones placed around her driveway. There was minor damage to the front bumper of vehicle 1 and operator 1 had AAA towing removed the vehicle from the ditch and she was able to park it in a neighbors driveway for the night. Photos were taken and will be submitted to the IT Bureau to attach to this report.
Keywords:
Night, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3297836
Longitude:
-71.2065087
Location:
Case
number:
Date:
2021-09-28
Time:
18:23
Address:
176 BOYLSTON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of MV1 stated they were stopped at the stop sign in front of Milton's facing Southbound attempting to get onto RT. 9 East. Operator of MV1 stated MV2 rear ended them. Operator of MV2 stated they were heading south from the Milton's parking lot towards RT. 9 when they rear ended MV1. A query was performed on both Motor Vehicles and operators. Operator of MV2 did not have a license and was issued MA Uniform Citation #T1447643. See incident report #21041506. MV1 and MV2 sustained minor damage. MV2 was towed. A towed motor vehicle inventory sheet was completed and filed with the Newton Police Department.
Keywords:
Citation
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3199042
Longitude:
-71.1748892
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);