home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where "datetime" is on date 2019-08-21, intersection = 0 and keywords contains "Speed"

✎ 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:
1900000858
Date:
2019-08-21
Time:
13:17
Address:
843 BEACON ST
Speed limit:
25
Violation cited:
no
Narrative:
Mv#1 operator states she was pulling out forward W/B from a parallel marked parking space in front of 843 Beacon St. #1 states she was about half way into the travel lane coming out of her turn to proceed straight ahead. #1 states at this time, she was struck on her driver's side front end that took off the bumper by Mv#2 that was travelling past her at a high rate of speed from behind straight ahead on Beacon St W/B. #1 operator further states #2 had crossed over the double yellow line to drive around her as she was out into the travel lane. Mv#2 operator states she was travelling on Beacon St W/B and was struck on her passenger side by #1 as #1 was pulling out of the parking space. I observed the initial contact damage on #2 on its passenger side rear door running down to the front of the passenger side wheel well and passenger side rear tire (tire wall partly sliced from impact). When #2 operator was asked if she crossed over the double yellow line, #2 replied only after the impact. #2 added prior to the collision, she briefly looked at her GPS. After statements were received from both operators and at the conclusion of this investigation, a witness identified herself on scene. The witness stated she was sitting in her driver's seat in her parked Mv directly in front of #1. Witness stated she observed #1 pull out from behind her into the travel lane. Witness stated #1's front end had almost fully reached her driver's side door before #2 made impact. Based on statements and witness statements and it appears #2 operator did not see #1 enter the roadway until the last second before impact by overcorrecting and entering the opposite lane of travel.
Keywords:
Crash, Speed
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3302668
Longitude:
-71.1955617
Location:
843 Beacon St, Newton Centre, MA 02459, 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 330.227ms