crash_reports_fts
2 rows where "datetime" is on date 2022-01-17
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), keywords (array)
| Link | rowid ▼ | case_number | datetime | date | time | address | narrative | keywords | dcc | dcc_code | geocoded_address | crash_reports_fts | rank |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3172 | 3172 | 22000052 | 2022-01-17T06:11 | 2022-01-17 | 06:11 | 260 CONCORD ST | Operator of MV1 states he was traveling south on Concord Street and attempted to stop for the red light at Washington Street when MV1 would not stop. MV1 slid across Concord Street, striking a City of Newton no parking sign pole and the wall in front of 260 Concord Street. City notified to replace/repair sign pole. Photos taken and submitted to IT. Operator of MV1 evaluated by the medics and signed a refusal. Todys towed MV1. | Pictures | [] | [] | 260 Concord St, Newton, MA 02462, USA | 53417 | |
| 3173 | 3173 | 22000050 | 2022-01-17T05:30 | 2022-01-17 | 05:30 | 1053 WASHINGTON ST | MV 1 was traveling straight eastbound on Washington St when he began to spin out due to the icy rainy conditons of the road. MV spun out into a 360 degree circle and collisoned its rear left side with a light pole on the side of Washington St. The operator of MV 1 was not injured. MV 1 sustained major damage to the entire rear of the vehicle and disabled it. The light pole sustained major damage and had to be removed by Dagle. MV 1 was towed by Tody's due to it being disabled on a public way. | Ice, Rain | [] | [] | 1053 Washington St, Newton, MA 02465, USA | 53417 |
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]
);