crash_reports
2 rows where dcc contains "Failed to yield" and "retrieved" is on date 2022-04-29
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-04-04
Time:
16:59
Address:
WALNUT ST & WATERTOWN ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
MV 1 was operating straight westbound on Watertown street in the lane to the left of MV 2. MV 1 attempted to cross in front of MV 2 and change lanes when she struck MV 2. MV 1 sustained moderate damage to her right passenger side and doors. The operator and owner of MV 1, Ms. Samantha Silverman, did not sustain any injuries. Ms. Silverman received a citation for an unsafe lane change. MV 2 was traveling straight westbound on Watertown St, through the intersection of Watertown and Walnut St. While in the intersection, MV 1 attempted to switch lanes in front of MV 2 striking his left front. MV 2 sustained minor damage to the front left. The operator of MV 2 was uninjured. The registration of MV 2 was expired at the time of the crash. The operator and owner of MV 2, Mr. Seton Murphy, was able to register the vehicle at the scene. Mr. Murphy recieved a citation for an expired registration. Neither vehicle required a tow.
Keywords:
Citation, Crash, Moderate
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3558631
Longitude:
-71.2090326
Location:
Case
number:
Date:
2022-04-18
Time:
15:12
Address:
102 GARLAND RD
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 (Newton City vehicle) was traveling Southbound on Garland Rd. when it side swiped a vehicle that was parked facing Southbound in front of 102 Gardland Rd. Operator of MV1 stated he did not believe he struck the vehicle, but stated he heard a loud crunch when passing MV2. MV1 was completely operational and appeared to not have sustained any damage. MV2 sustained large scrapes by the left front tire and heavy front end damage, consisting of the front bumper being almost entirely taken off. Owner of MV2 arrived on scene and stated they would be contacting their own tow company in regards to the vehicle being moved. Pictures of the scene and the damaged vehicles were taken and sent to the IT Bureau in order to be attached to this report.
Keywords:
Pictures
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3342945
Longitude:
-71.2055846
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);