crash_reports
2 rows where dcc = "["Inattention"]" and "retrieved" is on date 2022-05-16
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2022-05-07
Time:
14:27
Address:
CENTRE ST & CUSHING ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 operator stated he was slowed in traffic travelling on Centre St S/B just prior to reaching Cushing St. #1 stated he came to a full stop at this location in order to avoid blocking the "X" box marking in the roadway signaling vehicles to not block the intersection. Mv#2 operator stated she was travelling on Centre St S/B behind #1. #2 stated she didn't realize #1 was stopping and she rear ended #1. Both operators stated they may have some back discomfort but both refused evaluation. #1 passenger was not injured. Mv#1 sustained possible minor damage to rear liftgate steps, while Mv#2 sustained significant front end damage and was inoperable. #2 towed by Tody's.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3228067
Longitude:
-71.2013811
Location:
Case
number:
Date:
2022-05-12
Time:
01:39
Address:
255 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 was traveling straight ahead down Washington St a public way in the City of Newton when MV2 tried to merge into MV1'S lane and hit the back right driver side door of MV1. Operator of MV2 stated she did not see MV1 traveling next to beside her. There were no injuries and neither car was towed.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3578474
Longitude:
-71.1840263
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);