home / crashreports

Menu
  • GraphQL API

crash_reports_fts

3 rows where "datetime" is on date 2019-07-28

✎ View and edit SQL

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
757 757 1900000771 2019-07-28T09:23 2019-07-28 09:23 COMMONWEALTH AVE & MT ALVERNIA RD Operator of Veh # 1 stated that she was coming from Mount Alvernia Road and didn't look right when she pulled onto Comm Ave., and was struck by MV #2. Oper # 2 stated he was traveling down Comm Ave when vehicle # 1 entered Comm Ave, Oper # 2 was unable to stop before hitting MV #1. Medics responded and got all refusals. Veh # 1 towed by Tody's. [] Failed to yield, Inattention 4, 19 Commonwealth Avenue & Mt Alvernia Rd, Newton, MA 02467, USA 29734  
758 758 1900000772 2019-07-28T12:40 2019-07-28 12:40 244 NEEDHAM ST The owner of MV#1 stated his vehicle was parked on Charlemont St directly in front of "Splash" at 244 Needham St when MV#2 reversed out of her parking spot and struck his vehicle. MV#1 sustained minor damages to its left side rear bumper area. There were no reported injuries to the owner of MV#1. The operator of MV#2 stated she was reversing out of her parking spot and struck MV#1. MV#2 sustained minor damages to its rear bumper. There were no reported injuries to the operator of MV#2. [] Inattention 19 244 Needham St, Newton, MA 02464, USA 29734  
759 759 1900000773 2019-07-28T12:26 2019-07-28 12:26 NEEDHAM ST & TOWER RD On 07/28/19 at approximately 12:26 I responded to a two vehicle crash at the intersection of Needham St and Tower Rd. The operator of veh #1 stated she was driving Southbound on Needham St. when veh #2 pulled out of Tower Rd. from her right and collided with her car. The side airbags went off in veh #1 but the driver stated she wasn't hurt. She was checked out and signed a patient refusal with the Medics. Moderate to heavy damage to veh #1 as it was towed by Tody's towing. The operator of veh#1 has a License and Registration issued by the Department of The State (Brazilian Consulate) and isn't in our in house system to plug into this report. The operator of veh #2 stated she was pulling out of Tower Rd attempting to go left (Northbound) on Needham St. and didn't see veh #1 passing as she turned. Minor damage to veh #2 as the operator was cited in hand Mass. #T1271259 for N.C.O. Failure to Use Care in Turning. All roads traveled/ mentioned in this report are public ways in the City of Newton as they are serviced and maintained by this city. Airbag, Citation, Crash, Moderate Failed to yield 4 Tower Rd & Needham St, Newton, MA 02464, USA 29734  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIRTUAL TABLE [crash_reports_fts] USING FTS5 (
    [case_number], [datetime], [date], [time], [address], [narrative], [keywords], [dcc], [dcc_code], [geocoded_address],
    content=[crash_reports]
);
Powered by Datasette · Queries took 545.458ms