crash_reports
1 row where keywords contains "Alcohol" and "retrieved" is on date 2021-10-25
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-10-06
Time:
16:22
Address:
PARKER ST & THEODORE RD
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 was travelling North bound on Parker St. while waiting in traffic MV2 had rear ended MV1. Operator of MV2 exited vehicle to assess damage, then proceeded to get back in his vehicle and leave. Owner and passenger of MV1 proceeded to step in front of MV2 to obtain his information, but MV2 proceeded to drive towards the operator of MV1. Passenger of MV2 stated he placed his hands on the hood of MV2's vehicle to block him from leaving. MV2 proceeded to drive around MV1 passenger and left the scene. The driver and passenger of MV1 described the operator of MV2 as an older black male, in his 70's, with a salt and pepper beard and short black hair and wearing a white t-shirt. Driver and passenger of MV1 are unsure if the operator of MV2 is under the influence, due to the operator appearing "dirty" and having "eyes really wide open." It was asked if they could smell alcohol on the man or if he walked unsteadily, which the reporting party stated "no." Driver and passenger of MV1 stated they were okay and did not sustain any injuries and declining medical attention. MV1 had minimal damage to the rear bumper consisting of scratches. A description of MV2 was given as a gray Honda Civic with a Connecticut license plate. Upon clearing the scene, I canvassed the area yielding negative results. State Police was also notified, due to the accidents close proximity to Route 9.
Keywords:
Alcohol, Crash, Walk
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3149411
Longitude:
-71.1953867
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);