crash_reports
1 row where dcc contains "Distracted", intersection = 0 and keywords contains "Night"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-05-15
Time:
22:23
Address:
163 SUFFOLK RD
Speed
limit:
30
Violation
cited:
no
Narrative:
On May 15, 2020 at approximately 22:26 hours Officer Stake and I responded to 163 Suffolk Rd for a hit and run that had just occurred. Upon arrival, we observed MV1,a black Cadillac Escalate with heavy rear end damage parked facing westbound in front of 163 Suffolk Rd. MV1 also was had damage to the passenger side due to it being pushed into a utility pole. MV1 was parked and unoccupied at the time of the crash. I spoke with the residents of 170 Suffolk Rd, who said that they heard the crash and went outside and saw a dark colored Jeep Wrangler leaving the scene at a high rate of speed. They described the Jeep Wrangler as a "newer" model, possibly a four door with a hard top. The residents of 163 Suffolk Rd have a camera system and will view the footage at a later time. Units checked the area for the Jeep Wrangler but were unable to locate it. Todys's responded and removed MV1 from the scene. **Update by Ofc. Hamann** At 0600 hours, Dispatch advised me that a male party that was involved in an accident last night (5/15/20). Brett Catlin stated that he was driving home from CVS last night and admitted to looking down at his phone and then had crashed. He stated after he crashed he drove to his home, which is 4 houses down. He stated he had called the owner of the vehicle and apologized and stated he was going to report it in the morning. I advised him that there will charges pending.****
Keywords:
Crash, Night, Phone, Speed
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3295751
Longitude:
-71.1728741
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);