crash_reports_fts
1 row where "datetime" is on date 2019-07-28 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 759 | 759 | 1900000773 | 2019-07-28T12:26 | 2019-07-28 | 12:26 | NEEDHAM ST & TOWER RD | On 07/28/19 at approximately 12:26 I responded to a two vehicle crash at the intersection of Needham St and Tower Rd. The operator of veh #1 stated she was driving Southbound on Needham St. when veh #2 pulled out of Tower Rd. from her right and collided with her car. The side airbags went off in veh #1 but the driver stated she wasn't hurt. She was checked out and signed a patient refusal with the Medics. Moderate to heavy damage to veh #1 as it was towed by Tody's towing. The operator of veh#1 has a License and Registration issued by the Department of The State (Brazilian Consulate) and isn't in our in house system to plug into this report. The operator of veh #2 stated she was pulling out of Tower Rd attempting to go left (Northbound) on Needham St. and didn't see veh #1 passing as she turned. Minor damage to veh #2 as the operator was cited in hand Mass. #T1271259 for N.C.O. Failure to Use Care in Turning. All roads traveled/ mentioned in this report are public ways in the City of Newton as they are serviced and maintained by this city. | Airbag, Citation, Crash, Moderate | Failed to yield | 4 | Tower Rd & Needham St, Newton, MA 02464, USA | 30926 |
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]
);