crash_reports_fts
1 row where "date" is on date 2019-03-04, dcc contains "Unknown" and keywords = "["Crash"]"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 243 | 243 | 1900000246 | 2019-03-04T16:10 | 2019-03-04 | 16:10 | BOYLSTON ST & WOODWARD ST | On Wednesday, March 6th 2019, at approximately 16:10 hours, I took a report at the front desk for a past motor vehicle accident, which occured two days ago. The operator of vehicle 1 was the one that came to the station to report it. He stated he was travelling eastbound on Boylston St in the middle of three lanes. Vehicle 1 was travelling up to the traffic signals at the intersection of Woodward St. He stated vehicle 2 was in the far right lane, and tried to change lanes, all the way to the far left lane. The drivers side of vehicle 2 side swiped the passenger side of vehicle 1. There was minor damage to the passenger side of vehicle 1. The operator of vehicle 1 stated vehicle 2 did not immediately stop, and he had to follow her to the CVS at 978 Bolyston St. No one was injured due to the accident. | Crash | Unknown | 99 | Woodward St & Boylston St, Newton, MA 02461, USA | 22210 |
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]
);