home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2019-04-10, dcc = "["Failed to yield"]" and keywords contains "Citation"

✎ 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:
1900000360
Date:
2019-04-10
Time:
09:47
Address:
HAMMOND ST & HAMMONDSWOOD RD
Speed limit:
25
Violation cited:
yes
Narrative:
Operator 1 states she was traveling Eastbound on Hammond St when vehicle 2 pulled out of Hammondswood Rd and struck vehicle 1. Operator 2 states she stopped at the stop sign on Hammondswood Rd. Operator two made sure both ways were clear and then pulled out of Hammondswood. Vehicle 1 was traveling at a high rate of speed and struck vehicle 2. Both vehicles sustained moderate damage and vehicle 2 was towed by Tody's. Operator 1 complained of back pain; but, refused medical attention. Operator 2 was not injured. Operator 2's license was suspended and she was issued citation #T0646633 for 89/9 failure to comply stop sign, 90/23/D operating on a suspended license, and 90/23 Unregistered M/V.
Keywords:
Citation, Moderate, Speed
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3351954
Longitude:
-71.1775586
Location:
Hammondswood Rd & Hammond St, Newton, MA 02467, USA
Case number:
1900000361
Date:
2019-04-10
Time:
17:31
Address:
ALBEMARLE RD & CRAFTS ST
Speed limit:
30
Violation cited:
yes
Narrative:
On Wednesday, April 10th 2019, at approximately 5:31pm, I, Officer Brooks, responded to Crafts St street at Albemarle road, for a report of a 2 car MVA with injuries. Upon my arrival I spoke with the operator of MV1 (MA REG 61MS57), who stated he was traveling southbound on Albemarle road. He stated he stopped at the stop sign at the intersection with Crafts street, and then proceeded over Crafts street down Albemarle road. The operator stated he was struck by MV2 as he was crossing Crafts street. MV1 sustained heavy damage to the passenger side front end and wheel well area. The operator of MV1 was not injured. I then spoke with the operator of MV2(MA REG 11809), who stated she was traveling eastbound on Crafts street, when MV1 pulled out in front of her. She was not able to stop and her vehicle struck MV1 in the middle of the intersection. MV2 had damage to the front end. The operator of MV2 was complaining of pain in her head from striking the steering wheel. A witness to the accident stated he was stopped behind MV1 at the intersection of Albemarle road and Crafts street. He stated that MV1 accelerated across the intersection without yielding to MV2, and that there was no time for MV2 to stop safely. Both vehicles were towed due to the damage. The operator of MV1 was issued in hand MA Uniform Citation T1442386 for 89/9 Failure to safely proceed after stopping. The operator of MV2 was transported by Cataldo to NWH.
Keywords:
Citation, Crash
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3598454
Longitude:
-71.2170818
Location:
Crafts St & Albemarle Rd, Newton, MA 02460, 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 972.822ms