crash_reports
1 row where dcc_code = "[3]" and "retrieved" is on date 2021-06-23
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-06-15
Time:
17:50
Address:
CENTRE ST & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated she was on the off ramp, left lane of I90 approaching Washington Street The traffic light turned green and she pulled straight ahead, westbound on Washington street. When she crossed the intersection of Washington and Centre Street, the car to the left of her swerved, avoiding MV2. MV1 was unable to avoid MV2 and it struck the front driver side of her vehicle The operator of MV1 stated she had the green light and MV2 ran the red light. The operator of MV2 stated she was traveling northbound on Washington Street, approaching the intersection of Washington street and Centre Street and struck MV1. The operator stated due to the sun she did not see the traffic light red. MV1 had damage to the driver side of the vehicle and tire. MV2 had damage to the front passenger side of the vehicle and tire. Both parties refused medical treatment and Todys was notified for two tows. The operator of MV2 was cited (Warning) 89/9 for failure to stop at a red light, (Mass Uniform Citation T2014289).
Keywords:
Citation, Solar
Dcc:
Signs/Signals
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);