home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where address = "1238 BOYLSTON ST & _1_" 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), dcc (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
22000289
Date:
2022-04-08
Time:
15:58
Address:
1238 BOYLSTON ST & _1_
Speed limit:
45
Violation cited:
no
Narrative:
On Friday April 8, 2022 at approximately 1558 hours I was dispatched to Boylston St Eastbound at Rockland Place for a reported MVA involving a Newton Medic's Ambulance. MV1 operator stated he and AMB1 were on Boylston St Eastbound (a public way) next to highway marker 127.0. MV1 operator stated he was in the right lane and AMB1 was in the left lane. MV1 operator said AMB1 was next to him when AMB1 began to merge into his lane. MV1 operator said it was at this time that the rear passenger tire of AMB1 struck MV1's driver side bumper. MV1 operator said he was not injured at this time. MV1 sustained minor driver side bumper damage. AMB1 operator stated he was on Boylston St Eastbound in the left lane. AMB1 operator said in front of him was unknown debris that he was trying to avoid so the ambulance would not be damaged. AMB1 operator said before attempting to merge into the right lane he checked all his mirrors and could not see any other MV. AMB1 stated MV1 must have been in his blind spot and close to AMB1. AMB1 operator said after he checked his mirrors he attempted to merge into the right lane but struck MV1. AMB1 operator stated he was not injured at this time. AMB1 sustained minor damage to the rear passenger tire wheel well. No tows were required. MV1 and AMB1 operators signed refusals. Both were given copies of the accident report number and advised. Photos were taken and forwarded to the I.T. Bureau to be added to this incident.
Keywords:
Crash, Ems, Pictures
Dcc:
Swerving
Report url:
report
Image url:
image
Latitude:
42.3173635
Longitude:
-71.2233149
Location:
1238 Boylston St #1, Newton, MA 02464, 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 266.73ms