crash_reports
1 row where "datetime" is on date 2019-02-03, intersection = 0 and keywords contains "Solar"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-03
Time:
23:45
Address:
CHERRY ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
On Sunday, February 3rd 2019, at approximately 11:45pm, I, Officer Brooks, responded to a single car MVA at the intersection of River street and Auburndale avenue. Upon arrival I observed MV1(MA REG 7TT558) in the travel lane with both tires broken free from the axle. I spoke with the operator who could not recall how the accident happened, or what was struck. After an investigation the operator was placed under arrest for 90/24 OUI Alcohol. Officer Boyle was able to assist in the accident investigation. It appears the operator had been traveling westbound on River street and struck a utility pole on the drivers side front tire. The vehicle continued to the intersection of River street and Auburndale avenue and struck a curb here on the passenger side tire. Both tires were broken free from the axles. The vehicle was towed by Tody's and an inventory form was filed. Eversource was notified about the pole.
Keywords:
Alcohol, Crash, Solar
Dcc:
Reckless driving
Report
url:
Image
url:
Latitude:
42.3560826
Longitude:
-71.2279862
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);