crash_reports_fts
3 rows where "date" is on date 2019-02-10
This data as json, CSV (advanced)
Suggested facets: keywords, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 164 | 164 | 1900000167 | 2019-02-10T15:12 | 2019-02-10 | 15:12 | CHESTNUT ST & PRINCE ST | The operator of MV#1 stated that she was traveling south on Chestnut St approaching Prince St when MV#2 pulled out in front of her from Prince St and crash occurred. Operator #1 stated she had no time to stop. The operator of MV#2 stated that he was traveling west on Prince St and had come to a complete stop at the stop sign at Chestnut St, but did not see MV#1 until it was too late and crash occurred. Operator #2 stated the crash was his fault and he was cited. | Citation, Crash | Failed to yield | 4 | Chestnut St & Prince St, Newton, MA 02465, USA | 74885 | |
| 165 | 165 | 1900000168 | 2019-02-10T15:34 | 2019-02-10 | 15:34 | CRAFTS ST & WATERTOWN ST | Vehicle 1 was travelling straight ahead, westbound on Watertown St. Vehicle 2 was in the left turn only lane, and taking a turn onto Crafts St. The operator of vehicle 1 stated they needed to swerve off of the road to avoid getting struck by the rear of vehicle 2. Vehicle 1 struck the curb with their right front tire. The tire popped and the rim was damaged. No one was injured due to the accident. Vehicle 1 was towed by Tody's. A level 3 inspection was done to vehicle 2 by Officer Marini, and a citation was issued. | Citation, Crash | Lane departure | 9 | Watertown St & Crafts St, Newton, MA 02460, USA | 74885 | |
| 166 | 166 | 1900000169 | 2019-02-10T17:04 | 2019-02-10 | 17:04 | CENTRE ST & COMMONWEALTH AVE | Operator of vehicle 1 stated that traffic was coming to a hault and she slammed on her breaks to avoid hitting the vehicle in front of her. Operator of vehicle 2 stated she did not have enough reaction time to avoid hitting vehicle 1 and rear ended vehicle 1. | [] | Followed too closely | 5 | Commonwealth Avenue & Centre St, Newton, MA 02459, USA | 74885 |
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]
);