crash_reports_fts
1 row where "datetime" is on date 2019-05-19, dcc = "["Distracted"]" and keywords contains "Pictures"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 498 | 498 | 1900000506 | 2019-05-19T00:04 | 2019-05-19 | 00:04 | 134 MT VERNON ST | MV1, a 1999 Ford Explorer, MA Reg: 7ZT136, collided with a tree on city property just outside of 134 Mt Vernon St. Operator, Jarrod Stomberg, immediately told me that he looked down at his phone to make a phone call and in that moment, ran off the road and hit the tree. There was airbag deployment. Jarrod signed a refusal with the medics and was driven home by a family member. He was issued in hand MA Citation T1441780 for 90/13B - Texting While Driving. The vehicle was towed by Tody's Towing. Pictures were taken of the scene and placed into ITs box. | Airbag, Citation, Phone, Pictures, Tree | Distracted | 20 | 134 Mt Vernon St, Newton, MA 02465, USA | 30291 |
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]
);