home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2019-09-22, dcc = "["Failed to yield"]" and intersection = 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:
1900000967
Date:
2019-09-22
Time:
11:53
Address:
1247 CENTER STREET
Speed limit:
25
Violation cited:
yes
Narrative:
MV#1 was entering Center Street from a parking stall when he was struck by MV#2. -OpMV#1 stated he was entering Center Street from a parking stall when he was struck by MV#2. He stated he observed a far distance buffer between him and MV #2. MV#1 was occupied by two passengers. -OpMV#2 stated she was traveling north on Center Street. She stated she observed a MV#1 entering the roadway. She stated MV#1 pulled out suddenly in front of MV #2. She collided with MV#1. - I observe the damage to both vehicles. I observed the heavy damage and deep gouge to the driver(cid:31)s side door of MV#1. The gouge had cut open the outer panel of the door revealing the mechanical components inside the door. OpMV#1 stated he could not open the door, but the vehicle was drivable. I next conducted an inspection of the exterior damage of MV#2. I observed that the plastic bumper was separated from the frame and several cracks and breaks on the bumper. I further observed damage to the wheel well panel. OpMV#2 stated the vehicle was drivable. -There were no injuries reported at the scene and all parties declined medical assistance. Neither vehicle was towed from the scene. OpMV#1 was cited (T2015553) for Failure to Use Care Entering the Roadway.
Keywords:
Citation
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3303452
Longitude:
-71.1947576
Location:
1247 Centre St, Newton Centre, MA 02459, USA
Case number:
1900000969
Date:
2019-09-22
Time:
14:41
Address:
2366 WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
Operator#1 stated she was going W/B on Washington St when she attempted to make a left turn into #2366 Washington St,, Lower Falls Wine parking lot but was struck by vehicle #2. Operator #2 stated he was going E/B on Washington St just passing Concord St intersection when vehicle #1 turned left in front of him causing the crash.
Keywords:
Crash
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3252081
Longitude:
-71.2581459
Location:
2366 Washington St, Newton Lower Falls, 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 785.967ms