home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc contains "Failed to yield" and "retrieved" is on date 2022-06-14

✎ 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:
22000455
Date:
2022-05-26
Time:
15:56
Address:
BRANDEIS RD & 140 BRANDEIS RD PARKING LOT
Speed limit:
25
Violation cited:
yes
Narrative:
MV1 was traveling Northbound out of the parking lot and attempting to pull out Westbound onto Brandeis Rd. while MV3 was stopped in the Eastbound lane, allowing for MV1 to pull out. When MV1 pulled out they struck MV2 who was traveling Westbound on Brandeis Rd. MV1 subsequently hit MV3 from the impact. MV1 had damage to the front right of the vehicle and driver side door. MV2 had damage to the driver side door. MV3 had damage to the driver side door. There were no injuries and MV1 was towed from the scene. A towed MV form was completed and filed with NPD. Operator of MV1 was issued in hand MA Uniform Citation #T1447650 MGL Ch. 89/8 Failure to Yield to oncoming Traffic while attempting to turn left.
Keywords:
Citation, Crash
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3134114
Longitude:
-71.1866254
Location:
140 Brandeis Rd, Newton, MA 02459, USA
Case number:
22000500
Date:
2022-06-08
Time:
10:11
Address:
MARLBORO STREET & TREMONT STREEET
Speed limit:
35
Violation cited:
no
Narrative:
THE OPERATOR OF MV#1 STATED HE WAS TRAVELING WEST BOUND ON TREMONT STREET WHEN MV#2 BACKED OUT OF A DRIVEWAY AND STRUCK HIM. THIS CAUSED HIM TO THEN CRASH INTO A FENCE AT 4 MARLBORO STREET. THE OPERATOR OF MV#2 STATED SHE WAS BACKING OUT OF A DRIVEWAY WHEN SHE STRUCK MV#1. SHE STATED THAT MV#1 WAS SPEEDING. THE PROPERTY OWNER AT 4 MARLBORO STREET WAS ON SCENE AND AWARE OF THE PROPERTY DAMAGE. BOTH OPERATORS HAD CONFLICTING STATEMENTS BUT MV#1 HAD THE RIGHT OF WAY. BOTH VEHICLES WERE TOWED BY TODYS TOWING. BOTH OPERATORS APPEARED TO HAVE MINOR INJURIES AND WERE TRANSPORTED. THERE WAS AIRBAG DEPLOYMENT TO MV#1. BOTH VEHICLES HAD MAJOR DAMAGE.
Keywords:
Airbag, Crash, Speed
Dcc:
Failed to yield, Inattention
Report url:
report
Image url:
image
Latitude:
42.3524407
Longitude:
-71.1756664
Location:
Marlboro St & Tremont St, Newton, MA 02458, 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 513.701ms