crash_reports_fts
2 rows where "datetime" is on date 2021-03-01 and dcc = "["Inattention"]"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2273 | 2273 | 2100000155 | 2021-03-01T05:54 | 2021-03-01 | 05:54 | CALIFORNIA ST & CRAFTS ST | Vehicle #1 a City of Newton Street Sweeper was traveling east on California St. at the intersection of California and Crafts when it stopped and reversed to go west in the east bound travel lane. At the same time Vehicle #2 was traveling south on Crafts St. and took a right turn to go east on California St. Once Vehicle #2 Made the turn onto California St. Vehicle #1 Reversed into its front end. Vehicle #1 sustained minor damage to its rear end. Vehicle #2 sustained minor damage to its front end. There were no injuries. Photos were taken of the damage and passed along to The Newton Police IT Bureau. | Pictures | Inattention | 19 | California St & Crafts St, Newton, MA 02460, USA | 44645 | |
| 2277 | 2277 | 2100000157 | 2021-03-01T19:14 | 2021-03-01 | 19:14 | BEACON ST & HAMMOND ST | MV#1 was stopped on Beacon St for the red light at the intersection of Beacon and Hammond. MV#2 was coming up behind MV#1 and did not stop in time, and crashed into the rear of MV#1. No injuries occurred. Both vehicles were driven off scene. | Crash | Inattention | 19 | Beacon St & Hammond St, Newton, MA 02467, USA | 44645 |
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]
);