home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2019-10-17, 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:
1900001055
Date:
2019-10-17
Time:
07:47
Address:
EDDY ST & WATERTOWN ST
Speed limit:
35
Violation cited:
no
Narrative:
Operator of vehicle two stated that while tuning from the west bound lane of Watertown St onto the north bound lane of Eddy St vehicle one struck the rear driver's side of his vehicle. Operator of vehicle two stated that he was not injured and his vehicle did not require a tow. Operator of vehicle one stated that while driving east bound on Watertown St she could not stop her vehicle time to prevent it from crashing into vehicle two. Vehicle one had damage to the front passenger side and did not require a tow. Operator of vehicle one stated that she was not injured and her vehicle was towed by AAA. Witness Christina Colantonio stated that she was behind vehicle two and saw vehicle one " speeding and crash into the rear passenger side of vehicle two. Operator of vehicle one was cited for CO 19/75, failure to use care. Watertown St and Eddy St are pubic ways in the city of Newton.
Keywords:
Citation, Crash, Speed
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3526115
Longitude:
-71.217724
Location:
Eddy St & Watertown St, Newton, MA 02465, USA
Case number:
1900001056
Date:
2019-10-17
Time:
08:12
Address:
COMMONWEALTH AVE & TEMPLE ST
Speed limit:
25
Violation cited:
no
Narrative:
The operator of MV #1(Ma Reg 7TR785) stated she was traveling eastbound on Commonwealth Ave. when she attempted to turn left onto Temple St. Operator of MV#1 stated her vehicle was struck as she turned onto Temple St by the operator of MV #2. The operator of MV#2 (Pupils reg 44301) stated he was traveling westbound on Commonwealth Ave. approaching the intersection of Temple St. Operator of MV2 stated as he was traveling straight ahead he observed MV1 start to turn left onto Temple St. Operator of MV2 stated he hit the breaks and attempted to swerve out of the way but ended up hitting MV1. MV #2 struck MV #1's passenger side rear bumper causing minor damage. MV #2 sustained damage to its passenger side front bumper. No injuries were reported and both vehicles were able to be driven away from the scene. The operator of MV #1 will be mailed a citation (T2079066) for MGL. Ch. 89 Sec. 8; Failure to yield to oncoming traffic while turning left.
Keywords:
Citation
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3392936
Longitude:
-71.233645
Location:
Commonwealth Avenue & Temple St, Newton, MA 02465, 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 1065.331ms