home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc = "["Speeding", "Reckless driving"]", intersection = 0 and "retrieved" is on date 2020-10-07

✎ 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:
1900000820
Date:
2019-08-08
Time:
20:25
Address:
719 WASHINGTON ST
Speed limit:
25
Violation cited:
yes
Narrative:
On Thursday, August 8th 2019, at approximately 8:25pm, I, Officer Brooks, was parked in front of 719 Washington street facing westbound. I looked into my side view mirror to pull into traffic and observed MV1 (MA REG 118GL4) parked behind me with the driver's side door open. The operator was leaning into the car to retrieve an item, and then stood up and turned around to close the door. I observed MV2(IN REG VWI565) traveling westbound, at what I estimated to be 45 miles per hour. MV2 struck the open door of MV1, narrowly missing operator #1. MV1 sustained major damage to the driver's side door and was towed by Tody's. MV2 had heavy damage to the passenger side front end. The operator of MV2 was placed under arrest for Operating under the influence of alcohol after investigation. MV2 was towed by Tody's. There were no injuries as a result of the accident.
Keywords:
Alcohol, Crash
Dcc:
Speeding, Reckless driving
Report url:
report
Image url:
image
Latitude:
42.3527843
Longitude:
-71.2030088
Location:
719 Washington St, Newton, MA 02458, USA
Case number:
1900001335
Date:
2019-12-25
Time:
20:28
Address:
107 SHERIDAN ST
Speed limit:
25
Violation cited:
yes
Narrative:
The operator of MV1, Nicole Laurin, sates that she was driving southbound on Sheridan Street when she lost control of her vehicle causing her to crash into MV2 which was parked in front of 107 Sheridan Street. Both vehicles sustained major damage and airbag deployment and were towed from the scene by Tody's. Due to the high rate of speed of the crash and air bag deployment, the operator of MV1 was transported to Newton Wellesley Hospital to be evaluated. It should be noted that prior to the reported crash there was a 911 call regarding a white sedan traveling at a high rate of speed going through numerous traffic signals and signs in a densely populated neighborhood with narrow streets. After the crash several more 911 calls were received stating that a vehicle traveling at an excessive rate of speed just crashed into a parked vehicle. Based on these calls and the nature of the crash, Ms. Nicole Laurin was issued in hand Massachusetts Unifrom Citation T2013231 for 90-24, Operating to Endanger, and 90-17, Speeding over the reasonable and proper rate. Sheridan Street is a public way in the city of Newton.
Keywords:
Airbag, Citation, Crash, Hospital, Speed
Dcc:
Speeding, Reckless driving
Report url:
report
Image url:
image
Latitude:
42.3560213
Longitude:
-71.2349613
Location:
107 Sheridan 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 246.26ms