crash_reports_fts
1 row where "datetime" is on date 2021-08-13 and dcc = "["Failed to yield"]"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2707 | 2707 | 2100000604 | 2021-08-13T11:39 | 2021-08-13 | 11:39 | 716 BEACON ST | Mv#1 operator stated she was travelling straight ahead on Beacon St E/B (right of way) in the area of #716 Beacon. To no avail, #1 stated she quickly veered left in an attempt to avoid being struck by Mv#2 that was exiting the Newton Centre Post Office driveway. #1 was struck passenger side broadside, which appeared to sustain more significant damage to the passenger side rear door. #2 operator stated she was exiting the Post Office driveway (posted stop sign) attempting to turn left onto Beacon St W/B. #2 stated #1 was travelling at a high rate of speed. at which time #2 pulled out turning left and struck #1 passing by. #2 passenger side front end struck #1, #2 appeared to sustain less than moderate damage to that area of the MV. No injuries reported and both vehicles could be safely driven away. | Moderate, Speed | Failed to yield | 4 | 716 Beacon St, Newton Centre, MA 02459, USA | 41536 |
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]
);