home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc = "["Failed to yield"]", keywords contains "Crash" and "retrieved" is on date 2022-05-20

✎ 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:
22000392
Date:
2022-05-12
Time:
15:46
Address:
LEWIS TER & WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
Vehicle 1 was traveling East on Washington St. in the right hand travel lane. Vehicle 2 was traveling West on Washington St. in the middle travel lane. Both direction each had a straight Green Traffic Signal. Vehicle 2 was attempting a left hand turn onto Lewis Ter. The operator of Vehicle 2 stated when he saw a break in the traffic he attempted the left turn but did not see Vehicle 1. Vehicle 1 collided with Vehicle 2 in a T-Bone manner. Vehicle 1 sustained significant damage to its front end and needed to be towed from the scene (Todys). Vehicle 2 sustained damage to its passenger side door and passenger side front quarter panel but was able to drive away from the scene. There were no injuries reported at the accident.
Keywords:
Crash
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3548687
Longitude:
-71.1957088
Location:
Lewis Terrace & Washington St, Newton, MA 02458, USA
Case number:
22000407
Date:
2022-05-16
Time:
08:31
Address:
FRANKLIN ST & WAVERLEY AVE
Speed limit:
30
Violation cited:
no
Narrative:
The operator of MV#1 stated she was traveling SouthBound on Waverely Ave when she was struck by MV#2 at the intersection of Franklin Street. The operator of MV#2 stated he was stopped on Franklin Street Eastbound at the stop sign. He then proceeded through to cross over Waverley Ave when he struck MV#1. The operator of MV#2 stated that his view was obstructed by a tree. It also should be noted that there are many motor vehicle accidents at this intersection based on there being no traffic signal making it difficult to cross. MV#1 had major Passenger side damage with airbag deployment. MV#2 had front end damage. The operators signed medical refusal's and Tody's towed MV#1.
Keywords:
Airbag, Crash, Tree
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3492419
Longitude:
-71.1804564
Location:
Franklin St & Waverley Ave, 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 271.937ms