crash_reports
1 row where date = "2022-06-11", dcc contains "Inattention" and "retrieved" is on date 2022-06-14
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-11
Time:
14:54
Address:
53 ABERDEEN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 06/11/2022, while assigned to N499, I, Officer Conary, responded to Aberdeen Street for a report a minor MVA and one of the cars drove away. Upon arrival, I met with Operator of MV1 who explained to me that they parked their car Southbound of Aberdeen Street when their left side mirror was hit. Operator of MV1 said the operator of MV2 stopped and gave their phone number but did not exchange the rest of the information. I went to Operator of MV2's house and they explained to me that they tried to give their phone number to pay for the damages out of pocket instead of insurance. They also had their daughter in the car and was in a rush. After speaking to both operators, they both agreed there was miscommunication involving the exchange of information. I existed both parties getting the right information. There was minor damage to the rear side of MV1, and minor damage to right side of MV2.
Keywords:
Phone
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3195717
Longitude:
-71.2031248
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);