crash_reports
2 rows where dcc = "["Signs/Signals"]", intersection = 0 and "retrieved" is on date 2020-10-07
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:
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:
Case
number:
Date:
2019-11-24
Time:
05:24
Address:
320 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 stated he got off the Mass Pike Eastbound at exit 17, and once at the top of the ramp, his GPS directed him to take a left onto Washington St. While responding to a separate call, I witnessed MV1 traveling the wrong direction (NE) in the area of 320 Washington St. (one way section of rotary). I activated my blue lights and pulled up to MV1, telling the operator the street was a one way and he needed to turn around. The operator stated he had room to turn around, at which point I blocked Washington St. While turning around, the trailer of MV1 struck a City of Newton concrete light pole and knocked it down. The concrete pole was taped and coned off, and Daigle was notified to respond. Photos were taken and submitted to the IT bureau.
Keywords:
Pictures
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3563932
Longitude:
-71.1872752
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);