crash_reports
3 rows where dcc = "["Inattention", "Distracted"]" and keywords contains "Ped"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-08-05
Time:
18:22
Address:
ELM ST & WALNUT ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of vehicle 1 stated he was heading east on Elm St approaching the cross walk when he looked to one side but not the other and inched out and struck the pedestrian in the cross walk. Pedestrian stated he was in the cross walk when the car was inching forward and then accelerated and that is when he got hit.
Keywords:
Ped, Walk
Dcc:
Inattention, Distracted
Report
url:
Image
url:
Latitude:
42.3516
Longitude:
-71.230741
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:
Case
number:
Date:
2021-10-15
Time:
08:32
Address:
1200 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 operator stated she was travelling on Beacon St E/B in the area of #1200 when she stated she briefly looked down to touch a button on her front dash. At that time, #1 rear ended Mv#2 which in turn rear ended Mv#3. #1 operator signed a patient refusal. #1 sustained significant front end damaage and was able to be driven from the scene. #2 operator was slowing to a stop behind #3 when he was rear ended and pushed forward between both Mv's. #2 operator appeared to be significantly shaken up from impact and was transported by medics with unknown or any injuries. #2 sustained heavy rear end and front end damage, towed by Tody's. #3 operator stated he came to a stop on Beacon St E/B to allow a pedestrian to cross in a marked crosswalk when he was rear ended by #2. #3 operator signed a patient refusal. #3 sustained significant rear end damage and was able to be driven from the scene. Pedestrian/witness stated she was crossing in the crosswalk when the collision occurred. Pedestrian was not injured.
Keywords:
Crash, Crosswalk, Ped
Dcc:
Inattention, Distracted
Report
url:
Image
url:
Latitude:
42.3311133
Longitude:
-71.2132723
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);