crash_reports
4 rows where dcc contains "Other improper action", intersection = 0 and keywords contains "Alcohol"
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-10-25
Time:
03:29
Address:
173 GRANT AVE
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 10/25/2020 at approximately 0330 hours, I responded to 173 Grant Ave for a report of a vehicle into the residence. Upon arrival, the operator of the vehicle was out of her vehicle and speaking with the medics. She stated is that she was driving southbound on Grant Ave when a car swerved at her causing her to swerve. As I was speaking with her, I smelt a strong odor of alcohol and she was slurring her speech. She was brought into the ambulance due to her possible head injuries. She was transported to Newton Wellesley for an evaluation. The residence had structural damage to front window and the door frame. The vehicle was removed and towed by Todys and a towed motor vehicle form was filled out and filed.
Keywords:
Alcohol, Ems
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3340429
Longitude:
-71.1883194
Location:
Case
number:
Date:
2021-05-05
Time:
02:59
Address:
200 HIGHLAND ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 5/4/21 at approx 2327 dispatched called in an erratic opertor in front of the NPD Headquarters, 1321 Washington St. Multiple units located the involved vehicle after it had turned onto Chrery St. (See Incident# 21019152) Traces of the vehicles skid marks were seen all the way into Waltham from our Highland St. While on Highland St it was clear MV 1 was traveling northbound on Highland St when the operator of the MV collided with telephone pole 208/22 in front of 200 Highland St causing significant damage to the passenger side of the truck. The vehicle continured NB driving by the police station and ultimately all the way to Waltham failing to stop for police. The operator, Mr. Edgar Ramirez was cited two citations MA uniform citation T2080798 for Ch 90/24J oui liquor, Ch 90/25D failure to stop for police, and Ch 9024 E Negligent Oper. MA uniform citation T 2080799 for Ch 90/24C Leaving the scene of property damage (telephone pole), Ch 90/24I Open container of alcohol, and Ch 89/4A marked lanes violation. The vehicle MA Reg 3GDB19 was towed by Tody's towing.
Keywords:
Alcohol, Citation
Dcc:
Lane departure, Other improper action
Report
url:
Image
url:
Latitude:
42.3436792
Longitude:
-71.2225009
Location:
Case
number:
Date:
2021-09-18
Time:
01:16
Address:
324 CRAFTS ST.
Speed
limit:
30
Violation
cited:
yes
Narrative:
MV1 was traveling Westbound on Crafts St. when MV1 crossed the double yellow solid line, hopped the curb and crashed into a telephone pole just prior to the intersection of Crafts St. and California St. Owner/ operator of MV1 stated he was rear ended causing him to crash. Located in front of 324 Crafts St. There were no indications of a second vehicle and the operator was concluded to be under the influence of alcohol. See incident report 21039916 for further information. The vehicle had not been towed yet, since the vehicle was trapped under a broken/ hanging part of the telephone pole. The vehicle will be towed as soon as the power company is able to replace the pole.
Keywords:
Alcohol, Crash
Dcc:
Reckless driving, Other improper action
Report
url:
Image
url:
Latitude:
42.358981
Longitude:
-71.2127317
Location:
Case
number:
Date:
2021-09-28
Time:
03:39
Address:
1717 BEACON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 09/28/2021 @ approx. 0339 hrs. while on patrolin the area of 1717 Beacon St. I, Officer Sullivan, observed two motor vehicles pulled off to the side of the Beacon St. (public way). The rear vehicle MA Reg. W27879 had its hazard lights on with the operator, in the vehicle, in the driver's seat. The forward vehicle MA Reg. 3FHK99 also with its operator seated in the driver's seat. The vehicle was running and the operator was testing the operation of the vehicle by slowly moving forward by tapping the accelerator. I observed the vehicle to have tire/wheel damage to multiple tires. I activated my blue lights and exited my cruiser. As I approached the two vehicles I instructed the forward operator identified as Jiang, Xuan to stop the vehicle. The operator from the rear vehicle exited his vehicle. He was identified as Tao,Haichun. Mr. Tao stated his friend (Mr. Jiang) called him and stated he had a damaged tire. I later discovered through continued conversation that Tao is his boss. The two men work at IQ kitchen restaurant located at 1158 Beacon St, Newton. The location of the business is approximately 1 mile from the location of this incident. Jiang stated he was coming from work. while speaking with Jiang the odor of Alcoholic beverage was detected. further information in regards to this incident is documented. Reference Newton PD incident report #21041400. The location of a crash is unknown at this time. The vehicle sustained damage along the passenger side of the vehicle, mirror taken off and damage to three tires; two front and rear passenger. The vehicle MA Reg. 3FHK99 was towed from the area of 1717 Beacon St, Newton by Tody's Towing. The Incident/crash to be further investigated with pending MV violations.
Keywords:
Alcohol, Bus, Crash
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3265933
Longitude:
-71.2338635
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);