home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where keywords contains "Phone" and "retrieved" is on date 2022-05-04

✎ View and edit SQL

This data as json, CSV (advanced)

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

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
22000319
Date:
2022-04-19
Time:
13:24
Address:
2014 WASHINGTON ST
Speed limit:
0
Violation cited:
no
Narrative:
On 04/19/2022@1324 hrs. I responded to 2014 Washington St/Newton Wellesley Hospital (E.R.Entrance) for a report of a MVA. On scene I spoke with Alexi Martin MA OLN#S30269628 owner of MA Reg. 1AND24; 2021 Toyt/RAV4 color green (V1). Martin's parked vehicle was backed into by MA Reg. 8844NO; 2016 Toyt/COR color black (V2). Owner of V2 is Jane Lindenbaum MA OLN#S71524093. V2 operated by Lindenbaum backed into V1 which was parked and unoccupied. V1 was parked by NWH Valet Jerome Saint Luc (Valet Co. is VPNE). Saint Luc witnessed the collision and stopped Lindenbaum. He informed her that she hit a parked vehicle as she backed up. Saint Luc informed me that Lindenbaum stated she did not hit the car and proceeded on her way. On scene I also spoke with VPNE Manager Jean Emmanuel Pierre-Canal (857)472-8269. I advised him that Saint Luc was not involved in the MVA but he did witness the collision. I checked with NWH Public Safety and reviewed video surveillance footage which captured the collision. The video did confirm the collision and Saint Luc stopping and speaking with Lindenbaum. Further follow up on this incident to be conducted.as I have not made contact with Jane Lindenbaum. I have left a VM message on a phone number believed to be hers.
Keywords:
Hospital, Phone
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3306679
Longitude:
-71.2477866
Location:
2014 Washington St, Newton, MA 02462, 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 518.676ms