crash_reports
1 row where "datetime" is on date 2019-02-07, dcc contains "Visibility obstructed" and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2019-02-07
Time:
05:50
Address:
CENTRE ST & WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
At approximately 0550HRs on Thursday, February 07, 2019, I was dispatched to the intersection of Washington St. at Centre St. for a report of a two car MVA. Upon arrival, I spoke with the operator of MV1 (CT Pass: 981YJX) who stated she was in the rotary and was attempting to switch lanes by the concrete island to enter I90 Eastbound. As she did so, she collided with MV2. I then spoke with the operator of MV2 (MA Con: S15313) who stated that he was attempting to change lanes and enter Centre St. Northbound by the concrete island. As he attempted to do so, he yielded at the sign on the concrete island and when he did not see any oncoming traffic, he attempted to proceed and collided with MV1. I observed damage to the left fender, left front bumper/hood area and left front wheel area of MV1 and damage to the right door of MV2. MV2 was removed from the scene by Todys Services (NPD Towed MV Form completed/filled). Both parties stated they were uninjured, I assisted in exchanging information and cleared without incident.
Keywords:
[]
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3557988
Longitude:
-71.1865324
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);