crash_reports
1 row where dcc contains "Too fast for conditions", keywords contains "Alcohol" and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-09-27
Time:
22:29
Address:
565 CHESTNUT ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 9/27/20 I was Working N497 when I responded to an MVA with rollover in the area of Chestnut and Beacon St. along with multiple other units. Upon arrival at 565 Chestnut St. (which is a publicway in the city of Newton) I spoke with the operator of Veh 1 Jenna Wolf. Wolf stated that she was traveling northbound on Chestnut St. when a Vehicle traveling southbound swerved at her causing her to swerve to the left causing her to jump the curb and collide with a parked car. Wolf stated the car then rolled over and she was able to climb out on her own. Wolf had a laceration to the head that was bleeding so Newton Medics transported her to NWH for treatment. Wolf had a moderate smell of alcoholic beverages emanating from her person and glassy eyes and was slurring her words. Wolf was not asked to do field sobriety due to her injuries. The first parked car (Veh 2) that was struck by Veh 1 slid across the driveway and struck Veh 3, also causing damages to the driveway and yard. The Vehicles owner Vladimir Berezovsky was notified and provided a report number. Veh 2, and Veh 3 were disabled and towed away by Todys at the owners request. A witness named Reza Dana spoke with Ofc. T Keefe and stated "We were traveling down Beacon St. and had a green light at the intersection of Chestnut St. when two cars came speeding northbound on Chestnut St. and ran the red light at Beacon St. almost killing him". Then one of the cars went off the road and struck a parked car causing it to rollover. Veh 1 came back through dispatch as unregistered. Due to the fact that it was a residental area, the vehicle almost struck a home and the witness statment, Wolf was issued a Ma Uniform Citation T2080019 for 90/24/j Oui, 90/24/E MV Negligent Operation, 90/9/b Unregistered, 90/17/A Speeding. Pictures were taken by Ofc Keefe and submitted to IT.
Keywords:
Alcohol, Citation, Moderate, Pictures, Speed
Dcc:
Too fast for conditions, Reckless driving
Report
url:
Image
url:
Latitude:
42.3305312
Longitude:
-71.2254362
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);