home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2021-04-02, hit_run = 0 and speed_limit = 5

✎ 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:
2100000224
Date:
2021-04-02
Time:
09:00
Address:
612 WASHINGTON ST
Speed limit:
5
Violation cited:
no
Narrative:
On Friday, April 2, 2021, I spoke with Mr. Michael Maguire from the City of Newton Buildings Department in the Traffic Bureau. Mr. Maguire wanted to report a crash the he was involved in this morning with his City of Newton owned vehicle. Mr. Maguire reported the crash occurred at 612 Washington Street, Newton. Mr. Maguire stated he was traveling (E) through the 7-11 convince store parking lot at approximately 0755 hours this morning. Mr. Maguire stated he was operating a City of Newton owned 2010 Ford Ecovan (MA MVN: M99243) at the time of the crash. Mr. Maguire stated at this time a vehicle to his right backed out of it's parking spot and it's rear driver side bumper area crashed into the middle passenger side of his vehicle. I observed minor damage to the middle passenger side door area of MV1. Mr. Maguire reported no injuries. Mr. Maguire reported MV2 was a 2015 Honda Civic (MA: 588LG8) and the vehicle was being operated by Mr. Donald Sampson (S29010431). Mr. Maguire stated Mr. Sampson exchange information with him and he observed damage to the rear driver side bumper area of MV2. Mr. Maguire provided me with a picture of the damage to MV2. I have submitted it to the IT Bureau to be added to this report. I took picture of the damage to MV1 and submitted them to the IT Bureau.
Keywords:
Crash, Pictures
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3538657
Longitude:
-71.198379
Location:
612 Washington St, Newton, MA 02458, USA
Case number:
2100000227
Date:
2021-04-02
Time:
09:51
Address:
220 BOYLSTON ST
Speed limit:
5
Violation cited:
no
Narrative:
On Friday 4/2/21 at approx 0958hrs, while assigned to N499, I responded to 220 Boylston St for a 2 car MVA. Operator 1 states that he was driving straight while in the 220 Boylston St parking lot after getting off RT9 EB. Then he said MV2, while attempting to take a left, drove into the left driver side of his vehicle. Operator 2 left his license and vehicle information with operator 1 and then left before I arrived. I am unable to get a statement from operator 2 at this time.
Keywords:
[]
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3197333
Longitude:
-71.1761359
Location:
220 Boylston St, Chestnut Hill, MA 02467, 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 298.197ms