home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where date = "2021-01-07" and latitude = "42.3344554"

✎ 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:
2100000011
Date:
2021-01-07
Time:
18:51
Address:
CENTRE ST & HOMER ST
Speed limit:
30
Violation cited:
yes
Narrative:
On Thursday 1/7/21 at approx 1851hrs, while assigned to N494, I responded to Comm Ave and Centre St for a 2 car MVA. Operator of MV2 stated that he was attempting to take a left turn on to Centre St NB when MV1 came straight at him before both vehicles collided. He said the light was green and he was in the left turn only lane on Comm Ave EB. Operator of MV1 stated that he was driving WB on Comm Ave and while the signal was green tried to go straight across the intersection. He said that MV2 struck his vehicle in the middle of the intersection. He said he briefly lost control and his car turned onto to Centre St SB and stopped at the corner of Homer St. It should be noted that driver side airbags were deployed. Both occupants in MV1 signed refusals with medics. M1 was towed by Tody's Towing service. MV2 had an expired registration and a citation was issued to Dos Santos. Witness statement 1 Canzano stated that she was travelling WB on Comm Ave in the left turn only lane(ma reg 6TL410). She said that the light was green for all Comm Ave traffic and she stopped to yield to on coming traffic. Canzano stated that MV1 passed her on her right and attempting to cross the intersection when MV2, failing to yield, tried to turn left on to Centre St. She witnessed both cars collide. Witness statement 2 Danberg stated that he was traveling NB on Centre St and was coming to a stop at the Comm Ave intersection. He said that it appeared that all Comm Ave had a green light and that MV2 failed too yield to MV1. He states that his dash cam captured that accident and will email me the video.
Keywords:
Airbag, Citation, Crash
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3344554
Longitude:
-71.1934235
Location:
Centre St & Homer St, Newton, 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 387.704ms