crash_reports_fts
1 row where "date" is on date 2019-12-19 and keywords contains "Snow"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1288 | 1288 | 1900001310 | 2019-12-19T10:00 | 2019-12-19 | 10:00 | COMMONWEALTH AVE & EXETER ST | On 12/19/2019 while assigned to WNSQ I took a report at the front desk of NPD HQ for a past single motor vehicle cash. On 12/19/2019 Vehicle 1 was on Exeter St attempting to turn around in the driveway of 1536 Commonwealth Ave. While entering the driveway Vehicle 1 slid on a patch of ice and exited the roadway. The vehicle came to final rest in the front yard of 1526 Commonwealth Ave. No injuries were reported. No vehicles required a tow. Vehicle 1 had no visible damage. It should be noted that at the time of the crash the weather was clear with freezing temperatures. The area had just experienced snow and freezing rain precipitation on 12/17/2019. The operator of Vehicle 1 stated that after sliding into the front yard she was able to drive Vehicle 1 back on to Exeter St. The operator of Vehicle 1 stated that while she was exiting the front yard her tires were spinning and may have caused minor damage to the lawn. The operator of Vehicle 1 stated that she attempted to notify the homeowner of 1526 Commonwealth Ave but nobody appeared to be home. Officer Claflin N493 responded to 1526 Commonwealth Ave and tried to raise the homeowner with negative results. Officer Claflin observe tire tracks in the front yard but due to the presence of snow and ice it is unknown how much damage had been done. No phone number is listed for the homeowner of 1526 Commonwealth Ave as a result I will mail notification of this crash to the homeowner. | Crash, Ice, Phone, Rain, Snow | Lane departure | 9 | Commonwealth Avenue & Exeter St, Newton, MA 02465, USA | 45258 |
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]
);