home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "date" is on date 2020-02-15

✎ 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:
2000000159
Date:
2020-02-15
Time:
13:27
Address:
14 ELLIOT ST
Speed limit:
5
Violation cited:
no
Narrative:
On 02/15/20 at approximately 13:27 Officer Anderson and I responded to #14 Elliot St- The Negoshians Sunoco Gas Station to meet with the operator of Mass. Reg# 7EK387 Grey 2017 Mazda 3, Galina Zavlin. Zalvin stated she spoke with Edward Negoshian who told her she ran into Fuel Pump #6 and dented the metallic base after striking the fuel nozzle of Pump #4 approximately a half hour ago while she was fueling up. Zalvin admitted to hitting Fuel Pump #4 with her passengers side mirror but denied ever striking Fuel Pump #6 or the Oil Dolly Display as stated by Negoshian. Officer Anderson asked Negoshian if his security cameras were working and he pointed to the closest one and said "not that one" . He went on to say that he didn't know how to retrieve the security footage. I observed the Mazda 3 in question and didn't see any damage or dents in the front of the vehicle. The approx 1-2" dent on Fuel Pump #6 is showing signs of rust and appears to be old damage. Employee John O'Donnell stated he saw Zalvin strike Fuel Nozzle #4 but never saw her hit Fuel Pump #6 with her vehicle.
Keywords:
Solar
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3182959
Longitude:
-71.2122676
Location:
14 Elliot St, Newton Highlands, MA 02461, USA
Case number:
2000000160
Date:
2020-02-15
Time:
20:34
Address:
DANA RD & PARMENTER RD
Speed limit:
25
Violation cited:
yes
Narrative:
Vehicle #1 was traveling north on Parmenter Rd. approaching Dana Rd. Vehicle #2 was traveling east on Dana Rd. approaching Parmenter Rd. Vehicle #2 failed to come to a complete stop at the stop sign at the corner of Dana and Parmenter Rd. Vehicle #2 failed to yield to oncoming traffic and failed to yield to Vehicle #1 who had the right of way. Vehicle #1 collided with the passenger side of Vehicle #2. Both Vehicles suffered minor damage and did not need tows due to the accident. The operator of vehicle #2 admitted to failing to stop at the stop sign. Neither driver was injured. The operator of vehicle #2 was cited with: (Citation #T2080768 / T2080768) MGL 90/24/F OUI Drugs MGL 89/9 Stop Sign Violation MGL 89/8 Fail to Yield to oncoming traffic MGL 90/24/O MV, Reckless operation of a MV MGL 94C/34/I Possession of Class E Vehicle #2 was towed from the scene by Tody's due to the operator being placed under arrest.
Keywords:
Citation, Crash
Dcc:
Signs/Signals, Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3622316
Longitude:
-71.2310709
Location:
Dana Rd & Parmenter Rd, Newton, MA 02465, 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 678.563ms