crash_reports_fts
1 row where "date" is on date 2020-05-31 and keywords contains "Distracted"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | 50436 |
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]
);