crash_reports
3 rows where dcc = "["Over-steering"]", keywords contains "Pictures" and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, hit_run, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-01-13
Time:
17:55
Address:
1136 CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV1 stated that she was traveling southbound on Chestnut street when she lost control of her vehicle causing the vehicle to jump the curb and run over a city speed limit sign breaking it at the base. The city was notified of the broken sign and pictures were taken and placed in ITs mailbox to be attached to the report. The vehicle sustained a right rear flat tire and was towed by AAA. All parties reported no injuries and signed a patient refusal.
Keywords:
Pictures, Speed
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3103168
Longitude:
-71.2238119
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:
Case
number:
Date:
2020-08-10
Time:
21:48
Address:
BROOKLINE ST & OBER RD
Speed
limit:
30
Violation
cited:
no
Narrative:
The operator of MV1 states that he was driving eastbound on Brookline street when another motor vehicle entered his lane of traffic head on causing him to swerve to the right and hit two city trees. No other vehicle remained on scene. MV1 sustained major damage and was towed from the scene by Todys. Due to significant airbag deployment medics evaluated the operator of MV1 who signed a patient refusal. Pictures of the city trees were submitted to IT.
Keywords:
Airbag, Pictures, Tree
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3002161
Longitude:
-71.1846123
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);