crash_reports
3 rows where dcc = "["Unknown"]" and "retrieved" is on date 2021-10-25
This data as json, CSV (advanced)
Suggested facets: hit_run, keywords, datetime (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:
Case
number:
Date:
2021-10-14
Time:
13:03
Address:
RACHEL RD & WINCHESTER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 operator stated she came to a stop (four-way stop signs) on Winchester St S/B. #1 stated she looked to her left, a Mv was already stopped on Rachel Rd W/B. #1 stated she yielded to that Mv, that Mv then proceeded through the intersection. #1 stated she then proceeded next, attempting to continue straight ahead. #1 stated at that time, Mv#2 suddenly emerged from Rachel Rd W/B into the intersection directly behind the first Mv. #1 stated this was when her Mv was struck on her driver's side front end by #2. #1 sustained significant front end damage, rendered inoperable and was towed by Tody's. #2 operator stated she came to a stop at the end of Rachel Rd W/B. #2 stated at that time, she thought she had the right of way and attempted to proceed straight ahead through the intersection onto Goddard St. This was when the collision occurred with #1. #2 sustained significant passenger side front end damage, rendered inoperable and was towed by Tody's. Operator of MV#1 had a valid German License. No injuries.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3064293
Longitude:
-71.2056837
Location:
Case
number:
Date:
2021-10-23
Time:
06:19
Address:
JACKSON RD & WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
MV#1 Was traveling Westbound on Washington St then veered of the road and into a light pole at the intersection of Washington St and Jackson Rd. OPMV#1 Stated she fell asleep behind the wheel and was driving to Rhode Island. MV#1 Sustained major damage to the front end and was towed by Tody's Towing.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3549582
Longitude:
-71.1952442
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);