crash_reports
2 rows where date = "2021-11-29" 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-29
Time:
17:07
Address:
CRAFTS ST & FESSENDEN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was traveling eastbound on Crafts St attempted to take a left, northbound, on Fessenden St. MV1 did not see MV2 traveling westbound on crafts st and struck the vehicle. MV2 was traveling Westbound on Crafts St when all of a sudden MV1 attempted to take a left turn onto Fessenden St and collided with MV2. Both parties declined medical attention. Both vehicles were towed by Todys.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3596868
Longitude:
-71.2148342
Location:
Case
number:
Date:
2021-11-29
Time:
17:21
Address:
LOWELL AVE & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On November 29th 2021, at approximately 1721hrs, Lizabeth Mansfield (operator 1), reported to the front desk of Newton Police Headquarters to report a past hit and run that occured approximately at 1711hrs. The accident occured at the intersection of Lowell Ave and Washington St. Operator 1 stated that she was driving Northbound on Lowell ave in the left turn only lane just prior to the intersection of Washington St. As she was driving, vehicle 2 was in the right lane traveling Northbound and their attached trailer side swiped the front bumper of vehicle 1. Operator 2 did not stop after the collision and continued onto Washington St. Operator 1 described vehicle 2 as a red landscaping truck with a trailer attached to it. She could not provide any more details or a plate of vehicle 2. There was heavy damage to front bumper of vehicle 1, but the vehicle was operable. It is unknown if there is any damage to vehicle 2. Operator 1 stated she did not need medical attention.
Keywords:
Crash
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3510472
Longitude:
-71.2106128
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);