crash_reports
3 rows where date = "2019-04-29"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, hit_run, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-04-29
Time:
07:48
Address:
80 MADISON AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was traveling east on Madison Ave from Walnut St approaching #80. There were 2 landscape vehicles parked on left side of the street. The operator, Sarah Ruth Loper-Sengupta, stated that she never saw the pedestrian that was in the roadway (N) due to solar glare. Loper-Sengupta stated she heard a thump coming from the passenger side of her vehicle. Loper-Sengupta stated she looked over to her right and saw a trash barrel in the air. Loper-Sengupta stated she then saw a male party lying on the roadway on her passenger side. Immediately after striking the pedestrian, Loper-Sengupta, stopped to check on him. There was a golden doodle dog in the back seat of the MV at the time of the accident, unrestrained. There were no obstructions hanging from the mirror or windshield area. The front drivers visor was down. There was no airbag deployment. I observed significat damage to the front passenger side windshield area. There was also damage to the front passenger side hood area. See Sgt. Lee update for victim statement Numerous pictures were taken by Ofc. Gaudet of the MV and scene. They were TOT IT. The MV was towed by Tody's due to its shattered windshield. No citation will be issued to Loper-Sengupta. The solar glare caused her to not able to see the pedestrian. The Sgt. and I dont believe the pedestrian looked before crossing with the barell on his left shoulder because he would have been able to see the MV coming as this is straight away section of Madison Ave. It should be noted, that when I arrived on scene I immediately noticed the seolar glare as I walked east on Madison Ave.
Keywords:
Airbag, Citation, Crash, Glare, Ped, Pictures, Solar, Walk
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3497937
Longitude:
-71.2051351
Location:
Case
number:
Date:
2019-04-29
Time:
15:38
Address:
NAHANTON ST & WINCHESTER ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Witness 1 stated that vehicle 1 was travelling northbound on Nahanton St. Vehicle 1 made a left hand turn, westbound onto Winchester St. During the turn the right side of vehicle 1 made contact with the crosswalk signal post. I observed the post to be leaning due to the impact. The witness was unable to get a plate number, but was able to tell me that it was a commercial truck with a California registration. Dispatcher Brunelle notified Dagle to fix the light post. Photos were taken of the pole, and submitted to the IT bureau.
Keywords:
Crash, Crosswalk, Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.2969738
Longitude:
-71.2009796
Location:
Case
number:
Date:
2019-04-29
Time:
20:15
Address:
NONANTUM ST & WAVERLEY AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle one was traveling westbound on Franklin street and taking a right hand turn to head north on Waverly Ave when the female operator overturned the wheel and struck pole number 21 on the corner of Nonantum St and Waverly ave. The male passenger then stated for the female party to leave the driver seat of the vehicle. The male party took possession of the vehicle and drove off. Witnesses stated that a female was driving and a male party then took over possession of the car and drove off. Witnesses then wrote down the license plate of the vehicle. Officer Anderson responded to the operators residence to check on well being and spoke to the male party. The male party stated he left the scene and stated that his daughter was learning to drive and she only has her learners permit when she overturned the wheel taking a right hand turn and struck the pole. Male party stated he didn't think there was damage to the pole so he left the scene, since the female party was shook up. Pictures were taken and submitted to IT.
Keywords:
Pictures
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3495419
Longitude:
-71.180363
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);