home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

4 rows where dcc = "["Improper turn"]", intersection = 0 and "retrieved" is on date 2020-10-07

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speed_limit, violation_cited, keywords, 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:
1900000838
Date:
2019-08-15
Time:
18:20
Address:
117 ELM ST
Speed limit:
25
Violation cited:
yes
Narrative:
Operator of MV1 states she was backing out of the parking lot behind the Village Bank when MV2 struck MV1's left rear fender due MV2 performing a U-Turn from the southbound side of Elm St to the northbound side of Elm St. MV1 sustained minor damage to the left rear fender. Operator of MV2 states she was traveling southbound on Elm St when she performed a U-Turn in front of 117 Elm St and struck MV1. MV2 sustained minor damage to the front right fender. Witness, Christopher Bryan, states he was in the parking lot behind the Village Bank when he observed MV2 perform a U-Turn, which struck MV1 in the left rear fender. I issued the operator of MV2 in hand Massachusetts Uniform Citation #T1442617 for the following: Ch. 89 Sec. 8 Fail to Yield/Making U-Turn while interrupting traffic
Keywords:
Citation
Dcc:
Improper turn
Report url:
report
Image url:
image
Latitude:
42.3489092
Longitude:
-71.2293243
Location:
117 Elm St, Newton, MA 02465, USA
Case number:
1900000879
Date:
2019-08-28
Time:
05:48
Address:
29 CENTRE ST
Speed limit:
30
Violation cited:
no
Narrative:
MV1 operator states she was driving in the left lane going eastbound on Centre St heading towards Charles Banks Rd when MV2 hit her car on the right side. MV1 operator reported general pain and shock from accident. Medics responded and a refusal was signed. MV2 operator states he was driving eastbound on Centre St when he missed his left turn to go over the bridge heading towards Watertown. He then attempted to make an illegal left turn at the next set of lights but did not see MV1 in left lane. MV2 then hit MV1. Damage was observed on front left of MV2. I then cleared without further incident.
Keywords:
Crash
Dcc:
Improper turn
Report url:
report
Image url:
image
Latitude:
42.3298184
Longitude:
-71.093395
Location:
29 Centre St, Boston, MA 02119, USA
Case number:
1900001132
Date:
2019-11-04
Time:
17:09
Address:
510 WINCHESTER ST
Speed limit:
30
Violation cited:
no
Narrative:
Veh #1 was travelling south on Winchester St, Veh #2 was making a u-turn in Winchester Street. Veh #2 struck Veh #1 in the roadway. The left front bumper/quarter panel of Veh #2 struck the right rear quarter/bumper of Veh #1. No injuries reported. Both operators were able to drive their respective vehicles.
Keywords:
[]
Dcc:
Improper turn
Report url:
report
Image url:
image
Latitude:
42.3027694
Longitude:
-71.2054122
Location:
510 Winchester St, Newton, MA 02461, USA
Case number:
1900001293
Date:
2019-12-16
Time:
10:57
Address:
2014 WASHINGTON ST
Speed limit:
35
Violation cited:
no
Narrative:
Operator of vehicle 1 stated he was in the right lane of the eastbound side of Washington St with his right blinker on waiting to turn right into 2000 Washington St. As he proceeded to turn right vehicle 2 came from his left around the front of his car clipping the front end. Operator of vehicle 2 stated he saw vehicle 1 stopped ahead of him but did not notice his turn signal on and thought he was just stopped so he attempted to go around him from the left lane and collided with him. Neither operator reported any injuries and neither vehicle required a tow.
Keywords:
[]
Dcc:
Improper turn
Report url:
report
Image url:
image
Latitude:
42.3306338
Longitude:
-71.2464373
Location:
2014 Washington St, Newton, MA 02462, 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 496.209ms