home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where dcc = "["Improper turn", "Inattention"]"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, speed_limit, violation_cited, 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:
2100000542
Date:
2021-07-23
Time:
17:10
Address:
325 WASHINGTON ST
Speed limit:
25
Violation cited:
yes
Narrative:
Operator of MV1 stated he was proceeding Westbound on Washington street in the center lane when he turned left into the Four Points By Sheraton hotel entrance. Operator of MV1 stated he did not see MV2 and crossed into the left lane to complete the turn. Operator of MV2 stated he was proceeding Westbound on Washington Street when MV1 cut in front of him to make the turn into the hotel. MV1 sustained heavy drivers side damage. MV2 sustained moderate right front end and passenger side damage. No injuries. Operator of MV1 was cited in hand for Ch. 89 Sec.4A (marked lane violation) on Massachusetts Uniform Citation #T1445462. Tody's towing responded on scene and towed MV1. A towed motor vehicle form was completed, scanned into this report and filed.
Keywords:
Citation, Moderate
Dcc:
Improper turn, Inattention
Report url:
report
Image url:
image
Latitude:
42.3569627
Longitude:
-71.1870199
Location:
325 Washington St, Newton, MA 02458, USA
Case number:
2100000799
Date:
2021-10-08
Time:
17:42
Address:
LOWELL AVE & WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
The operator of vehicle 1 stated he was traveling westbound on Washington Street through the intersection of Washington Street and Lowell Ave. While going through the intersection vehicle 2 crashed into vehicle 1 while vehicle 2 was attempting a left turn. The operator of vehicle 2 stated he was on Washington Street and turned left onto Lowell Ave, he did not see vehicle 1 and crashed the front center of his vehicle into the passenger side quarter panel of vehicle 1.
Keywords:
Crash
Dcc:
Improper turn, Inattention
Report url:
report
Image url:
image
Latitude:
42.3510472
Longitude:
-71.2106128
Location:
Lowell Ave & Washington St, Newton, MA 02460, USA
Case number:
22000409
Date:
2022-05-16
Time:
11:16
Address:
777 WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
THE OPERATOR OF MV 1 STATED HE WAS TRAVELING WEST ON WASHINGTON ST WHEN MV 2 (WHO WAS PARKED ON WASHINGTON FACING WEST ABRUPTY TURNED INTO TRAFFIC (TO MAKE A U TURN) AND COLLIDED WITH MV 1. MV 1 HAD DAMAGE TO THE FRONT AND PASSENGER SIDE OF THE VEHICLE AND NO INJURIES WERE REPORTED MV1 HAD A PRIVATE TOW.. MV 2 STATED HE DIDNT SEE MV 1 WHEN HE TURNED INTO TRAFFIC. MV 2 SUSTAINED FRONT END DAMAGE AND NO INJURIES WERE REPORTED.
Keywords:
[]
Dcc:
Improper turn, Inattention
Report url:
report
Image url:
image
Latitude:
42.3524326
Longitude:
-71.2050973
Location:
777 Washington St, 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 291.051ms