crash_reports_fts: 680
This data as json
| rowid | case_number | datetime | date | time | address | narrative | keywords | dcc | dcc_code | geocoded_address |
|---|---|---|---|---|---|---|---|---|---|---|
| 680 | 1900000692 | 2019-07-06T23:11 | 2019-07-06 | 23:11 | BRIDGE ST & CALIFORNIA ST | Vehicle 1 was traveling westbound on California St while approaching the intersection of California and Bridge. Vehicle 1 stated he wanted to take a left from California to Bridge St when his brakes failed and ended up crashing onto the sidewalk and fence of 1 Bridge St. and coming to a stop. 1 Bridge St owner was notified of the damage to the fence. | Crash | Inattention, Defective equipment | 19, 22 | Bridge St & California St, Newton, MA 02458, USA |