crash_reports
2 rows where dcc = "["Inattention", "Distracted"]", hit_run = 0 and "retrieved" is on date 2020-10-20
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-09-26
Time:
15:54
Address:
327 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle one was driving westbound on Washington St when he stated that he was looking at the buildings across from 327 Washington St. Vehicle one drifted into parked car, vehicle two. Vehicle two was parked and unoccupied in a parking spot in front of 327 Washington St. Vehicle two moved forward from the impact and struck vehicle three. It should be noted that vehicle two already had extensive damage to the front end of the vehicle prior to the crash holding the bumper intact with duck tape and clear tape. Vehicle three had minor damage to the rear end bumper. No injuries were reported on scene.
Keywords:
Crash, Severe
Dcc:
Inattention, Distracted
Report
url:
Image
url:
Latitude:
42.3569413
Longitude:
-71.1871127
Location:
Case
number:
Date:
2020-10-10
Time:
11:01
Address:
CENTRE ST & PAUL ST
Speed
limit:
30
Violation
cited:
no
Narrative:
The operator of MV#1 stated she was travelling northbound on Centre St when she stopped for a pedestrian attempting to cross at the intersection of Paul St. The operator of MV#1 stated she was then struck from behind by MV#2. MV#1 sustained moderate damages to its rear end along with under carriage damages. The operator of MV#1 stated her head struck the steering wheel but she refused medical attention. The operator of MV#2 stated he was travelling northbound on Centre St when he dropped his cigarette and looked down to reach it. The operator of MV#2 stated when he looked back up it was too late and struck MV#1. MV#2 sustained heavy front end damages with both front airbags deployed. The operator of MV#2 stated he was not injured and refused medical attention. Both involved vehicles were legally parked and arranged for their own tows for further assistance.
Keywords:
Airbag, Moderate, Ped
Dcc:
Inattention, Distracted
Report
url:
Image
url:
Latitude:
42.326492
Longitude:
-71.197893
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);