crash_reports_fts
3 rows where "datetime" is on date 2019-09-20
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 945 | 945 | 1900000962 | 2019-09-20T14:02 | 2019-09-20 | 14:02 | ARNOLD RD & DEDHAM ST | Mvs# 1,2,3 were travelling west on Dedham St (at Arnold Rd) at approx 5 mph. As mv#1 slowed in traffic, Mv#3 collided into mv#2 which in turn got pushed into mv#1. Mv#1 sustained minor rear damage Mv#2 sustained minor rear/front damage Mv#3 sustained moderate front end damage mv#3 was towed away by AAA and there were no injuries due to this accident. | Crash, Moderate | [] | [] | Arnold Rd & Dedham St, Newton, MA 02459, USA | 42726 | |
| 946 | 946 | 1900000963 | 2019-09-20T13:35 | 2019-09-20 | 13:35 | 999 BOYLSTON ST | OPERATOR OF MV 1 STATED THAT SHE WAS IN THE PARKING LOT BEHIND 999 BOYLSTON STREETAND WHILE SHE WAS IN A SPOT, SHE BELIEVES SHE ACCIDENTALLY STEPPED ON THE GAS PEDAL AND THE VEHICLE MOVED FORWARD. THE VEHICLE STRUCK A SECTION OF THE WOODEN FENCE WHICH FELL AND CAUSED MINOR DAMAGE TO THE VEHICLE PARKED NEXT TO THEM. MODERATE DAMAGE SUSTAINED TO MV 1 AND NO INJURIES WERE REPORTED. OWNER OF MV REQUESTED A PRIVATE TOW FOR THE VEHICLE. TWO OTHER VEHICLES WHO WERE PARKED CLOSE TO MV 1 MAY HAVE BEEN DAMAGED BY THE FALLING FENCE. | Crash, Moderate | Inattention | 19 | 999 Boylston St, Newton Highlands, MA 02461, USA | 42726 | |
| 947 | 947 | 1900000964 | 2019-09-20T15:36 | 2019-09-20 | 15:36 | 31 LAFAYETTE RD | The owner of MV#1 states he parked his vehicle on the roadway on 09/17/2019 at approx. 1300 hrs. On 09/18/2019 at approx. 1700 hrs., he noticed there was damage to the left side of his vehicle. There was a note on the windshield of his car with a phone number and an illegible name, unknown if that's related to the accident. The owner of MV#1 tried calling that number and didn't get a call back. Dispatch tried calling as well and left a message. The owner of MV#1 will forward that piece of paper to his insurance company. | Crash, Phone | Unknown | 99 | 31 Lafayette Rd, Newton, MA 02462, USA | 42726 |
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]
);