crash_reports
4 rows where "retrieved" is on date 2022-04-29
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, violation_cited, dcc, dcc_code, 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-17
Time:
22:54
Address:
2360 COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
MV#1 was traveling Eastbound on Commonwealth Ave and rolled over colliding with a tree on the side of the road. Upon arrival the vehicle was located upside down in front of 2360 Commonwealth Ave and there was no one in the vehicle. Vehicle was towed by Tody's Towing.
Keywords:
Tree
Dcc:
Reckless driving, Unknown
Report
url:
Image
url:
Latitude:
42.3449305
Longitude:
-71.2575841
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:
Case
number:
Date:
2022-04-21
Time:
13:34
Address:
CENTRE AVE & CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
THE OPERATOR OF MV 1 STATED SHE WAS TURNING RIGHT ONTO CENTRE AVE FROM CENTRE ST AND WHILE SHE HAD PROPERLY STOPPED IN ORDER TO MERGE INTO ONCOMING TRAFFIC, MV 2 REAR ENDED HER. MV 1 SUSTAINED MODERATE REAR END DAMAGE AND STATED SHE WAS SORE BUT DID NOT WISH TO BE SEEN BY MEDICS. THE OPERATOR OF MV 2 STATED THAT HE WAS TRAVELING BEHIND MV 1, DID NOT SEE HER COME TO A STOP AND REAR ENDED HER. MODERATE DAMAGE SUSTAINED TO MV 2 AND NO INJURIES REPORTED.
Keywords:
Moderate
Dcc:
Followed too closely, Inattention
Report
url:
Image
url:
Latitude:
42.3557988
Longitude:
-71.1865324
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);