crash_reports_fts
2 rows where "date" is on date 2020-08-19 and keywords = "[]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), dcc (array)
| Link | rowid ▼ | case_number | datetime | date | time | address | narrative | keywords | dcc | dcc_code | geocoded_address | crash_reports_fts | rank |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1768 | 1768 | 2000000460 | 2020-08-19T07:33 | 2020-08-19 | 07:33 | 10 MANHATTAN TER | Vehicle 1 was turning off of Westland Ave onto Manhattan Terr and caught a low hanging cable wire bringing the wire down. As a result the services of #10 Manhattan Terr and #104 Westland Ave were also pulled from the homes causing minor damage. Verizon and eversource were notified. | [] | [] | [] | 10 Manhattan Terrace, Newton, MA 02465, USA | 6976 | |
| 1771 | 1771 | 2000000463 | 2020-08-19T18:50 | 2020-08-19 | 18:50 | NEEDHAM ST & TOWER RD | The operator of M/V#1 stated that she was traveling west on Needham St., and as she approached the intersection of Needham ST. and Tower Rd. a siler or grey toyota (possibly Camry) slowly pulled out of Tower Rd. and struck the right rear of M/V#1. M/V#2 did not stop, and no plate number was seen. | [] | Unknown | 99 | Tower Rd & Needham St, Newton, MA 02464, USA | 6976 |
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]
);