crash_reports
2 rows where "datetime" is on date 2021-04-05, hit_run = 0 and "retrieved" is on date 2021-04-12
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-04-05
Time:
11:57
Address:
ADAMS ST & WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Driver of vehicle #1 stated he was travelling East bound in the right hand lane on Washington St. Operator #1 stated he had a green light at the intersection of Washington St. and Adams St. Operator #1 stated that vehicle #2 which was travelling Westbound made a left hand turn in front of Vehicle #1 and he had no time to react and collided with vehicle #2. The operator of vehicle #2 stated that he was travelling West bound on Washington St. attempting to make a left hand turn onto Lewis St. Operator #1 stated a vehicle heading in the opposite direction stopped to allow vehicle #2 to make a left hand turn. Vehicle #2 was then struck by vehicle #1 which was travelling in the right lane heading Eastbound. Vehicle #2 was spun around by the impact and struck Vehicle #3 which was stopped at a red light. Operator of vehicle #3 stated he was stopped at the red light at Lewis St. and Washington when he observed Vehicle #2 attempt to make a left turn onto Lewis St. Vehicle #2 was struck by vehicle #1 which spun vehicle #2 into vehicle #3. Vehicles #1 and #2 were towed away by tody's due to excessive damage. Occupant of vehicle#2 was taken to Newton Wellesley Hospital by paramedics for minor inuries.
Keywords:
Crash, Hospital
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3548522
Longitude:
-71.1956673
Location:
Case
number:
Date:
2021-04-05
Time:
21:39
Address:
48 WACHUSETT RD
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of MV1 was traveling Westbound of Wachusett Rd. and collided with a utility pole in front of 48 Wachusett Rd. Operator of MV1 left the scene of the accident and was located nearby at the intersection of Hammondswood Rd. at Intervale Rd. Operator of MV1 stated he left the scene of the accident because he was scared. During questioning, Operator of MV1 admitted to consuming alcohol, appeared impaired and under the influence of alcohol on scene. Operator of MV1 completely left his lane of travel and was operating in a negligent manner. Operator of MV1 sustained injuries to his head and left ankle. He was then transported to Newton Wellesley Hospital for evaluation. MV1 sustained heavy front end damage due to impact. MV1 was unable to be towed due to live power lines underneath the vehicle. A voicemail was left with the traffic bureau to follow up on when it was safe to tow the vehicle involved. Operator of MV1 was mailed a criminal application, citation #T2012668 for the following offenses: 1. Ch. 90 Sec. 24/C (Leaving the scene of property damage). 2. Ch. 90 Sec. 24/E (MV, Negligent operation). 3. Ch. 90 Sec 24/J (OUI, Liquor). See incident #21016286 for further review.
Keywords:
Alcohol, Citation, Crash, Hospital, Impairment
Dcc:
Reckless driving, Inattention
Report
url:
Image
url:
Latitude:
42.334481
Longitude:
-71.179733
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);