home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where "datetime" is on date 2022-05-26 and dcc_code = "[9]"

✎ 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:
22000453
Date:
2022-05-26
Time:
08:18
Address:
474 WOODWARD ST
Speed limit:
25
Violation cited:
no
Narrative:
On Thursday, May 26, 2022, while assigned to Traffic unit N525, I responded to 466 Woodward Street, Newton for a report of a motor vehicle crash involving a City of Newton owned vehicle. The weather at the time of the crash was clear and sunny. The road surface was dry. Woodward Street is a public way maintained by the City of Newton. I spoke with the operator of MV1, Mr. Alessandro Marini (S65112681). Mr. Marini was operating a City of Newton owned 2016 Ford F350 (MA MVN: M98136) in the area of the Bank of America on Woodward Street. Mr. Marini stated as he was traveling the passenger side door mirror of his vehicle made very minor contact with the driver door mirror of a vehicle parked to the right side of the roadway. No injuries were reported by Mr. Marini or his passenger. I observed minor damage to the driver side door mirror of MV1. Mr. Marini is an employee of the City of Newton DPW. I then spoke with the operator of MV2, Ms. Kasia Hollins (S78643620). Ms. Hollins stated he was parked in 2006 Toyota Highlander (MA: 81N570) across from the Bank of America on Woodward Street (W) when MV1 traveled by her driver side and made contact with the front driver side door of her vehicle. Ms. Hollins reported no injuries. I observed minor damage to the front driver side door mirror of MV2. Photos of both vehicles were submitted to the IT Bureau.
Keywords:
Crash, Pictures, Solar
Dcc:
Lane departure
Report url:
report
Image url:
image
Latitude:
42.3264092
Longitude:
-71.2301735
Location:
474 Woodward St, Waban, MA 02468, 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 391.691ms