crash_reports_fts
1 row where "date" is on date 2021-10-21 and keywords = "["Citation", "Crash", "Ems"]"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2932 | 2932 | 2100000847 | 2021-10-21T06:16 | 2021-10-21 | 06:16 | CHAPEL ST & WATERTOWN ST | MV 1 was traveling north on Watertown St approaching Chapel St. MV 2 was traveling east on Chapel St approaching Watertown St. MV 2 had a green light and began to cross over Watertown St. and continue straight on Chapel St. MV 1 had a red light but failed to stop for it. MV 1 went through the red light crashing into MV 2 in a T-bone manner. The Operator of MV 1 was cited for failure to stop/red light violation (MGL 89-9) )(Citation #T2014775). Both vehicles sustained significant damage and were towed from the scene by Tody's. The operator of MV 1 sustained no injuries. The operator of MV 2 complained of neck pain and was transported to NWH by Fallon Ambulance. | Citation, Crash, Ems | Signs/Signals | 3 | Chapel St & Watertown St, Newton, MA 02458, USA | 11674 |
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]
);