crash_reports_fts
2 rows where "datetime" is on date 2019-11-15
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1154 | 1154 | 1900001176 | 2019-11-15T06:55 | 2019-11-15 | 06:55 | 258 DERBY ST | Operator of MV1 was travelling eastbound on Derby Street when she collided with the rear of the attached trailer on MV2, which was parked on the side of the road in front of 258 Derby St. Operator of MV1 stated due to the sun glare she did not see the landscaping truck and trailer. MV1 sustained heavy front end damage and was towed by Tody's Towing. MV2 had very minor damage to the rear trailer and license plate. Operator of MV1 was evaluated by Cataldo and signed a patient refusal. MV2 was unoccupied at the time of the crash. | Crash, Glare, Solar | Glare | 13 | 258 Derby St, West Newton, MA 02465, USA | 61394 | |
| 1155 | 1155 | 1900001177 | 2019-11-15T16:03 | 2019-11-15 | 16:03 | 260 NEEDHAM ST | OPMV#1 Was parked in the parking lot of Marshals located at 260 Needham St when she was attempting to exit her vehicle. When the OPMV#1 opened her car door, the door was struck by the OPMV#2. OPMV#1 Stated she was exiting her car and another vehicle wiped into the spot next to her. OPMV#2 Was attempting to pull into a parking spot in the Marshals parking lot located at 260 Needham St when she struck the left drivers side door of the OPMV#1. OPMV#2 Stated the person parked in the spot didn't even check to see if it was clear to open her car door before she pulled into her spot. OPMV#2 Was issued MA UNIFORM CITATION#T1442156 M.G.L. C.90 S.10 Unlicensed Operation. See INCIDENT REPORT#19049296. | Citation | Inattention, Unknown | 19, 99 | 260 Needham St, Newton, MA 02461, USA | 61394 |
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]
);