crash_reports
1 row where keywords contains "Alcohol" and "retrieved" is on date 2022-02-04
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-01-22
Time:
19:03
Address:
BEACON ST & WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Saturday, January 22, 2022 at approximately 1903hrs, MV1 was stopped at the intersection of Walnut St and Beacon St. when MV2 traveling Northbound on Walnut St. rear ended MV1. I asked the operator of MV1 if he was okay and if he would like to be evaluated by paramedics, which he replied "no." MV1 sustained minimal damage, consisting of a cracked rear bumper. Operator of MV1 stated he believed the operator of MV2 was under the influence of alcohol because the operator kept repeating himself. The operator of MV2 was no longer on scene, but Ofc. Boyle, who also responded to the call was able to make contact with the operator. It was concluded the operator was not under the influence, but had been repeating himself because he could not understand the other operators language. The operator of MV2 stated he spoke over the phone with MV1's niece, Nawarath Kluaypanngam, in order to exchange information. Operator of MV2 stated that he was not paying attention and thought the operator of MV1 was going to continue to drive forward. He stated he did not expect to see the brake lights in front of him and was unable to stop in time, causing him to rear end MV1. MV2 stated that his vehicle sustained no damage and also refused medical attention. Both vehicles were operational and the operators of MV1 and MV2 were informed a report would be generated.
Keywords:
Alcohol, Phone
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3308369
Longitude:
-71.2070206
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);