home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc contains "Failed to yield", "retrieved" is on date 2021-10-21 and violation_cited = 0

✎ 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:
2100000802
Date:
2021-10-10
Time:
13:31
Address:
175 BOYLSTON ST
Speed limit:
15
Violation cited:
no
Narrative:
The operator of MV1 stated he was traveling westbound in the parking lot travel lane at Bloomingdale's's when MV2 drove out behind a dodge truck and struck the passenger side of his vehicle. The operator of MV2 stated he was driving across a parking spot, to another spot and as he entered the travel lane in the parking lot, he struck the passenger side of MV1 with the front of his vehicle. All occupants stated they were not injured. MV1 sustained significant damage to the passenger side of the vehicle. MV2 had major damage to the front of his vehicle. MV1 was able to drive away from the accident after proper paper work was gathered. MV2 called for a private tow, AAA.
Keywords:
Crash
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3214181
Longitude:
-71.1748826
Location:
175 Boylston St, Chestnut Hill, MA 02467, USA
Case number:
2100000843
Date:
2021-10-18
Time:
20:18
Address:
BEACON ST & CHESTNUT HILL RD
Speed limit:
25
Violation cited:
no
Narrative:
On 10/18/2021, while assigned to N496, I, Officer Conary, responded to Beacon St at Chestnut Hill Road for a MVA with airbag deployment. Upon arrival, I met with the Operator of MV1 who stated that he was traveling Westbound on Beacon Street when MV2 pulled out from Chestnut Hill Road onto Beacon Street right in front of him. Operator of MV1 stated that MV2 just pulled right out that he had no time to stop. The passenger present in MV1 stated that they were traveling Westbound on Beacon Street when MV2 cut in front of them and could not avoid a collision. Operator of MV2 stated that they were pulling out from Chestnut Hill Road turning left. They saw no other cars traveling on Beacon Street and continued to make the left turn when MV2 hit MV1. Witness who was running across the street heard MV1 attempt to stop (screeching tires) and then MV2 hit MV1. Witness only provided a phone number for contact. All parties were evaluated by medics and signed patient refusal. Operator of MV1 complained of a hand injury but was going to transport themselves to the hospital. Both vehicles were towed.
Keywords:
Airbag, Hospital, Phone
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3339598
Longitude:
-71.1623085
Location:
Beacon St & Chestnut Hill Rd, Boston, MA 02467, 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 932.212ms