crash_reports_fts
2 rows where "date" is on date 2020-05-31 and keywords contains "Solar"
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 | 50744 | |
| 1625 | 1625 | 2000000311 | 2020-05-31T18:52 | 2020-05-31 | 18:52 | 432 CHERRY ST | On Sunday, 5/31/20 at 1652 hrs, I (N493) responded to the area of 432 Cherry St. for a single motor vehicle collision. Upon arrival, I observed MV#1 (MA Reg: 6WS227) had collided into utility pole ( 249/47) adjacent to 432 Cherry St. Damage was observed to MV#1's entire front end. The operator stated he was traveling northbound on Cherry St. when he became distracted, lost control of the vehicle and collided into the utility pole. The operator of MV#1 stated he was not injured and signed a patient refusel. Tody's Tow service was contacted to remove the vehicle from the roadway. The utility company was contacted as a precaution to evaluate the damage done to the poll. | Distracted, Solar | Inattention | 19 | 432 Cherry St, West Newton, MA 02465, USA | 50744 |
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]
);