home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc contains "Lane departure" and latitude = "42.3563932"

✎ 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:
2100000293
Date:
2021-04-28
Time:
15:44
Address:
320 WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV1 stated she was traveling Westbound on Washington Street passing Four Points Sheraton, approaching the rotary. She stated she was in the far left lane, making a slight left turn over the Mass pike bridge. As she was approaching the left, MV2 made two lane changes, toward her vehicle, cutting her off. As MV2 attempting to drive in front of her, MV2 struck the passenger side front bumper. Operator of MV1 stated, the Operator of MV2 then got out of her vehicle, began yelling at her and hit her passenger side window. Hand prints were visible on the window. I asked the Operator of MV2 what had happened and what led up to the accident. The operator of MV2 stated she didn't recall what had happened. She stated she was following MV1 from a previous accident that had just occurred in Watertown, Ma. There was visible damage to the rear driver side of MV2 vehicle. I asked the operator of MV2 how she got the damage and she stated she did not know. MV1 had minor damage to the front passenger side bumper. MV2 had minor damage to the rear driver side. All parties stated they were not injured and were able to operate their vehicles. Watertown PD arrived on scene and also took a report for the accident in Watertown. Report # 21-7242.
Keywords:
Crash
Dcc:
Lane departure
Report url:
report
Image url:
image
Latitude:
42.3563932
Longitude:
-71.1872752
Location:
320 Washington St, Newton, MA 02458, USA
Case number:
2100000819
Date:
2021-10-13
Time:
09:10
Address:
320 WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator #1 stated he was travelling westbound on Washington St passing the Sheraton Four Points Hotel, 320 Washington St, when he was hit by another vehicle. Operator #1 stated the operator of a white sedan ( Operator #2) was attempting to change lanes behind him and hit the rear driver side of his vehicle. Operator #2 fled the area without stopping. Vehicle #1 had minor damage to the rear of his vehicle. He stated Vehicle #2 would have damage to the front of their vehicle but unsure what side. He stated Vehicle #2 was a white sedan with a black male driver and a person in the back seat, possibly a rideshare service. Operator #1 was able to drive his vehicle away from the scene.
Keywords:
[]
Dcc:
Lane departure, Inattention
Report url:
report
Image url:
image
Latitude:
42.3563932
Longitude:
-71.1872752
Location:
320 Washington 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 291.087ms