home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where "datetime" is on date 2019-03-19, intersection = 0 and keywords contains "Pictures"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
1900000302
Date:
2019-03-19
Time:
12:26
Address:
220 DEDHAM ST
Speed limit:
25
Violation cited:
no
Narrative:
On 03/19/19 at 14:57 hours, I responded to 220 Dedham Street for a past motor vehicle hit and run accident involving a parked car that occurred at 12:26 hours on this date. Dedham Street is a public way maintained by the City of Newton. The owner of M/V # 1 states her vehicle was legally parked in front of 220 Dedham Street facing northbound when she came out and found a note from a witness saying it was struck by a gray Honda Accord bearing MA Reg. # 8512HV. It appears that the operator of M/V # 2 side swiped M/V # 1 as it was passing by on Dedham Street. I observed marks to the driver's side rear door area and the side view mirror was broken. On 03/20/19 at 08:47 hours, I spoke to the witness, Kawtar Bhih, on the phone and she stated that she was parked on the opposite side of where the accident took place. Bhih observed a gray Honda Accord with an elderly female operating M/V # 2 on Dedham Street almost side swiped another parked car before side swiping M/V # 1. She says that the vehicle slowed down after and then continued to leave the scene of the accident. She then took a photo of the above listed registration plate. I attempted to contact the owner of M/V # 2 (Jali Medical Inc Waltham, MA) and the receptionist was not able to provide any information at the time. I was told to call back the next day. I gave the vehicle and registration info to the person inquiring if they could find a possible driver and call back. While working on this report, I observed that the owner of M/V # 2 was involved in a past accident in our system and the operator at the time had an address of 66 Country Club Rd. Newton. On 03/20/19 at approx. 09:30 hours, I went over to this address and observed M/V # 2 in the driveway with an operator inside. After inquiring about the accident, she stated she was driving down Dedham Street when she heard a noise coming from her passenger side view mirror as she had struck something. She then left the scene not thinking it was serious. I observed fresh damage to her passenger side mirror along with other marks along the doors which appeared to be older. Operator was issued in hand MA Uniform Citation # T1441710 for Ch. 90/S24 Leaving the scene of property damage.
Keywords:
Citation, Crash, Phone, Pictures, Severe
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3120377
Longitude:
-71.2018717
Location:
220 Dedham St, Newton, MA 02461, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "crash_reports" (
   [case_number] TEXT PRIMARY KEY,
   [datetime] TEXT,
   [date] TEXT,
   [time] TEXT,
   [address] INTEGER,
   [street1] TEXT,
   [street2] TEXT,
   [intersection] INTEGER,
   [speed_limit] INTEGER,
   [hit_run] INTEGER,
   [violation_cited] INTEGER,
   [narrative] TEXT,
   [keywords] TEXT,
   [dcc] TEXT,
   [dcc_code] TEXT,
   [report_url] TEXT,
   [image_url] TEXT
, [geocoded_address] TEXT, [latitude] TEXT, [longitude] TEXT, [manual_geocode] INTEGER, [retrieved] TEXT);
Powered by Datasette · Queries took 516.053ms