home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2021-09-16 and keywords contains "Crash"

✎ 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:
2100000714
Date:
2021-09-16
Time:
13:26
Address:
BOYLSTON ST & SHELDON RD
Speed limit:
25
Violation cited:
no
Narrative:
On Thursday 9/16/21 at approximately 1326hrs, I responded along with Officer Gabriel (495) to the area of Boylston Street and Sheldon Road for the report of a single motor vehicle accident. Upon arrival I observed Ma reg(9JV392) on the sidewalk stuck in a stop sign. The vehicle was unoccupied at the time with no operator in sight. The motor vehicle sustained heavy damage and was towed by Tody's. I notified dispatch to the damage to the Stop Sign and Hidden Driveway sign. Traffic Officer Wilson took photos of the accident scene. Update By Sgt Dempsey On Thursday afternoon the owner of the vehicle came to the lobby of the Newton Police Station inquiring about his vehicle. Officer Gabriel was unable to identify him as the driver of the vehicle at the time of the crash. This matter is still under investigation.
Keywords:
Crash, Pictures
Dcc:
Reckless driving
Report url:
report
Image url:
image
Latitude:
42.319359
Longitude:
-71.194258
Location:
Parker St @ Boylston St, Newton, MA 02459, USA
Case number:
2100000716
Date:
2021-09-16
Time:
16:40
Address:
45 WILLIAM ST
Speed limit:
25
Violation cited:
no
Narrative:
Owner of Vehicle 1,Mary Malloy, stated that at approximately 1630hrs she heard a loud bang out in front of 45 William Street. Malloy stated she went out front and observed a blue dump truck driving southbound on William Street. Malloy said she was unable to see any writing on the vehicle. Malloy said she saw there was damage done to her vehicle. The front driver side bumper was hanging off and there was scratches starting from the rear driver door all the way up to the front driver side door causing the driver side mirror to be taken off as well. Malloy was visiting her friend, Barbara Harteln, who lives at 45 William Street. Harteln has a ring camera which catches the blue dump truck driving southbound on William Street. However Harteln informed me the camera did not pick up Malloy's vehicle being struck. I provided Harteln with my department email and advised her to send me the footage from her ring camera. I canvassed the neighborhood and was unable to find any other cameras near 45 William Street. I provided Malloy with the crash report number to this incident and advised her to contact her insurance company and to take photographs of her vehicle. Malloy said she was going to contact AAA to come and tow the vehicle to a dealership near her house in Hingham.
Keywords:
Crash, Pictures
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3574819
Longitude:
-71.2354718
Location:
45 William St, West 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 397.312ms