crash_reports_fts
1 row where "date" is on date 2020-05-31 and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), keywords (array), dcc (array)
| Link | rowid ▼ | case_number | datetime | date | time | address | narrative | keywords | dcc | dcc_code | geocoded_address | crash_reports_fts | rank |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1624 | 1624 | 2000000310 | 2020-05-31T00:36 | 2020-05-31 | 00:36 | 20 NAHANTON ST | On Sunday, May 31st, 2020 at 0145 hours, I responded to 20 Nahanton St for a single motor vehicle collision into a telephone pole. The motor vehicle (Mass Reg #9ATB20 2017 BMW COLOR BLACK) was being operated by Robert Shklyar. Robert stated he was driving north on Dedham St when he took a left hand turn at the intersection of Dedham and Nahanton St. While turning left on Nahanton St, he stated he lost control of the vehicle and drifted into the other lane where he crashed into the telephone pole in front of 20 Nahanton St. Robert also stated the roadway was dark and he did not see the curve in the road ahead of him. I observed all the roadside lights to be working properly upon inspection. Robert did not have any injuries. The motor vehicle suffered major front end damage with air bag deployment. Roadside Rescue responded and Towed the BMW. Eversource and Verizon were notified about the pole. The vehicle is insured by Safeco. | Crash, Solar | Inattention | 19 | 20 Nahanton St, Newton, MA 02459, USA | 50840 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE [crash_reports_fts] USING FTS5 (
[case_number], [datetime], [date], [time], [address], [narrative], [keywords], [dcc], [dcc_code], [geocoded_address],
content=[crash_reports]
);