crash_reports_fts
3 rows where "datetime" is on date 2021-08-13
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2702 | 2702 | 2100000605 | 2021-08-13T14:15 | 2021-08-13 | 14:15 | 260 NEEDHAM ST | On 08/13/21 at approximately 14:15 I responded to #260 Needham St.-Marshalls for a past H&R M.V.. Upon arrival I spoke with the owner of veh #1 who is an employee of Marshalls. She stated she parked her vehicle at approximately 09:00 this morning and when she finished her shift at approximately 14:15, she saw the passenger side rear quarter had been struck. It appears as if a small white colored car struck her parked vehicle while it was either pulling in or out. Owner of veh#1 stated she checked with her manager who told her there are no cameras in the area of the parking lot. Minor damage to veh #1. | [] | [] | [] | 260 Needham St, Newton, MA 02461, USA | 41400 | |
| 2703 | 2703 | 2100000606 | 2021-08-13T12:20 | 2021-08-13 | 12:20 | 14 MT IDA ST | ON 8-13-21 AT APPROX. 1220HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT HIT AND RUN. UPON ARRIVAL AT 14 MT. IDA ST. I SPOKE TO THE LESSEE ( CHRISTIAN FALK ) OF VEHICLE #1. LESSEE STATES HE PARKED HIS CAR ON THE STREET IN FRONT OF 14 MT. IDA ST AND SOMETIME BETWEEN 0030-1200HRS. SOMEONE HIT HIS CAR AND SPED AWAY. VEHICLE #1 HAD LEFT REAR QTR. PANEL DAMAGE, LEFT REAR DOOR DENTS AND LEFT REAR TIRE SCRAPES. IT WAS DIFFICULT TO TELL FROM THE DAMAGE THE ANGLE AS WELL AS THE POSSIBLE VEHICLE INVOLVED. DRIVER ADVISED TO CONTACT HIS INSURANCE COMPANY. CLEARED WITHOUT FURTHER INCIDENT. | Crash | Other improper action | 97 | 14 Mt Ida St, Newton, MA 02458, USA | 41400 | |
| 2707 | 2707 | 2100000604 | 2021-08-13T11:39 | 2021-08-13 | 11:39 | 716 BEACON ST | Mv#1 operator stated she was travelling straight ahead on Beacon St E/B (right of way) in the area of #716 Beacon. To no avail, #1 stated she quickly veered left in an attempt to avoid being struck by Mv#2 that was exiting the Newton Centre Post Office driveway. #1 was struck passenger side broadside, which appeared to sustain more significant damage to the passenger side rear door. #2 operator stated she was exiting the Post Office driveway (posted stop sign) attempting to turn left onto Beacon St W/B. #2 stated #1 was travelling at a high rate of speed. at which time #2 pulled out turning left and struck #1 passing by. #2 passenger side front end struck #1, #2 appeared to sustain less than moderate damage to that area of the MV. No injuries reported and both vehicles could be safely driven away. | Moderate, Speed | Failed to yield | 4 | 716 Beacon St, Newton Centre, MA 02459, USA | 41400 |
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]
);