crash_reports
1 row where dcc contains "Physical impairment" and keywords contains "Walk"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-08-08
Time:
21:31
Address:
BEACON ST & HOBART RD
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of MV1 stated he was stopped in traffic facing Southbound on Hobart Rd. when MV2 came head on at him nearly colliding into his vehicle. It should be noted Operator of MV1 stated MV2 caused a minor paint scratch located on his gasoline cover once he walked around his vehicle to observe any damage. Operator of MV2 stated he was traveling Northbound on Hammond Pond Pkwy. when he fell asleep at the wheel and crashed. A (Do Not Enter Sign) was also damaged due to the accident. After further investigation, Operator of MV2 was arrested on scene for Ch. 90 Sec. 24 (Operating under the influence, liquor) along with Ch. 90. Sec. 10 (Unlicensed operation of MV). Citation #T2014789. MV1 sustained minor damage. MV2 sustained heavy front end damage and was towed by Tody's. There were no injuries due to this accident. A towed motor vehicle was filled out and placed on file.
Keywords:
Citation, Crash, Walk
Dcc:
Physical impairment, Inattention
Report
url:
Image
url:
Latitude:
42.3321327
Longitude:
-71.1812114
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);