crash_reports
2 rows where "datetime" is on date 2019-11-11 and keywords contains "Ped"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-11-11
Time:
16:38
Address:
CEDAR ST & COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
yes
Narrative:
MV#1 was traveling east on Commonwealth Ave. Pedestrian was crossing the cross walk at Cedar St from the north side of Commonwealth ave to the south side. The pedestrian stated that he was more than half way across the cross walk when he was struck by a vehicle. The pedestrian stated that he did not see the vehicle until it was to late. Operator of MV#1 stated that she did not see the pedestrian crossing the cross walk until right before she struck him. Operator of MV#1 stated that as soon as she saw him she attempted to stop, but was not able to do so until after she struck the pedestrian. A witness at the scene stated that he was stopped in the west bound side of Commonwealth Ave allowing the pedestrian to cross. He stated that he saw MV#1 approaching the crosswalk and not stopping. He stated that he was not able to signal the pedestrian or operator of MV#1. The witness stated that he observed the pedestrian struck, and immediately got out of his vehicle to help. The pedestrian was transported to the hospital by medics. Pictures were taken of his injuries to be attached to this report. MV#1 was driven off scene. Pictures were take of the damage to MV#1. A citation was issued to the operator of MV#1.
Keywords:
Citation, Crosswalk, Hospital, Ped, Pictures, Walk
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3380858
Longitude:
-71.1987809
Location:
Case
number:
Date:
2019-11-11
Time:
17:44
Address:
21 PARKER ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Vehicle #1 Was Traveling Southbound on Parker St. Vehicle #1 collided with a pedestrian on it's left drive side in a marked crosswalk in front of 21 Parker St. The operator of vehicle #1 stated she saw the pedestrian through her driver's side window at the same time she heard a loud bang. The operator of vehicle #1 stated she noticed her mirror was gone and realized she had hit something so she stopped. The pedestrian in the crosswalk was crossing from his residence at 21 Parker St. on the west side of Parker to the east side of Parker St. in a marked crosswalk. The pedestrian was approximately 2 feet from the middle divider when he was hit by the mirror of vehicle #1. It should be noted that the pedestrian was wearing all dark clothing. The Pedestrian appeared to suffer an injury to his arm and his body and was transported to Beth Israel by Cataldo. The Witness stated he did not see the crash, but just prior to it he saw an unknown vehicle driving at a high rate of speed northbound on Parker St. and the vehicle may have beeped at the pedestrian in the crosswalk causing him to step back into the southbound travel lane where the crash happened. Photographs were taken of the scene and submitted to the IT bureau to be attached to this report. The operator of Vehicle #1 was cited with MGL Ch. 89-11 fail to yield to pedestrian in a crosswalk (Citation #T2079123).
Keywords:
Citation, Crash, Crosswalk, Ped, Pictures, Speed
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.326654
Longitude:
-71.194141
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);