crash_reports
2 rows where "datetime" is on date 2019-04-29 and hit_run = 1
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
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);