crash_reports
2 rows where dcc = "["Distracted"]", intersection = 0 and keywords contains "Solar"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-08-02
Time:
07:01
Address:
79 FLORENCE ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Sunday 8/2/20 at approximately 701 hours while assigned to marked unit n499 I was dispatched to the rear of the Lifetime Center (300 Boylston Street) for a single vehicle motor vehicle crash. Upon arrival I observed a Black Honda CRV with significant front end damage next to a dumpster in the shoulder of Florence Street behind the Lifetime Center. Dumpster was placedt there for the ongoing construction at the Lifetime Center. I spoke with the operator of the CRV, LYSGAARD Ingrid, who states she was frustrated by all the noise being made by the construction workers. Ingrid states she drove to the site to take pictures of the workers whom she believed to be working in violation of Newton's city noise ordinance. She pulled over to the side of the road to take a picture with her cell phone, but didnt realize her foot came off the brake pedal causing her to strike the dumpster. Fire and Medics also responded to the crash and ingrid signed a patient refusal after being evaluated by the medics Tody's responded and towed the vehicle. I stayed on scene until the vehicle was removed and Ingid's son came to transport her hiome.
Keywords:
Crash, Fire, Phone, Pictures, Solar
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3168175
Longitude:
-71.180136
Location:
Case
number:
Date:
2022-06-19
Time:
12:43
Address:
43 LINDEN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Sunday 6/19/22 at aproximaytely 11:48 hours while assigned to marked unit N-498 Officer Soloman was on a special assignment to assist with a procession at Mary Immaculate of Lourdes Church (280 Elliot Street) beginning at noon. While setting up a road closure by placing traffic cones on Linden Street Officer Soloman inadvertently struck a parked motor vehicle in front of 43 Linden Street. While attempting to go around a traffic cone the passenger side fender above the wheel well of N-498 struck the drivers side tail light of the parked motor vehicle. The collision caused the tail light to crack on the parked motor vehicle and there were only minor scratches to N-498. Officer Soloman left the location to assist with the event at the church, Sgt. Dempsey was notified. At the conclusion of the event Officer Soloman went back to 43 Linden Street to attempt to speak with the owner of the motor vehicle. The owner was not home, but Officer Soloman was able to speak with her husband, DWYER Michael, and inform him of what happened. Officer Soloman gave him all the pertinent information that he would need. Pictures were taken of the damage to the motor vehicle and N-498 and forwarded to IT.
Keywords:
Pictures, Solar
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
Longitude:
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);