home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "date" is on date 2019-04-11 and intersection = 0

✎ 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:
1900000363
Date:
2019-04-11
Time:
11:43
Address:
1302 WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
On Thursday, April 11, 2019 while assigned to Traffic unit N525, I responded to the area of 1302 Washington Street, Newton for a report of a motor vehicle accident. The weather at the time of the accident was clear and sunny. The road surface was dry. Washington Street is a public way maintained by the City of Newton. The operator of MV1, Jacqueline Dupre (S29256883), stated she was parked in front of 1302 Washington Street (E) in her 2018 Honda CRV (MA: 5054RF). Dupre stated she was attempting to exit her street parking spot and did not see any vehicles traveling towards her as she entered Washington Street. Dupre stated MV2's passenger side hit her front driver side area as she was attempting to enter the lane. I observed minor damage to the front driver side quarter panel/headlight area. Dupre reported no injuries at this time. The operator of MV2, Donnell Stoute (S53698210), stated he was operating a 2017 Porsche Macan (MA: 7ZC447) East on Washington Street. Stoute stated as he was traveling by 1302 Washington Street, MV1 pulled out of her parking spot and hit the passenger side of the vehicle he was operating. I observed moderate damage to the passenger side of MV2. Stoute reported no injuries at this time.
Keywords:
Crash, Moderate, Solar
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3491718
Longitude:
-71.2265476
Location:
1302 Washington St, Newton, MA 02465, USA
Case number:
1900000367
Date:
2019-04-11
Time:
17:41
Address:
287 AUBURN ST
Speed limit:
10
Violation cited:
no
Narrative:
Owner of MV1 reports he came out to the parking lot and observed new damage to the drivers rear door of his MV. MV1 was parked at approximatley 0900 hours and the damage was observed at 1700 hours. I observed damage to the drivers side rear door of MV1. I also observed broken red plastic on the ground, consistent with a broken taillight from being backed into by another MV. Owner of MV1 is going to check with his boss to see if cameras from his workplace capture the parking lot. No other cameras were visible in the parking lot area.
Keywords:
[]
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3468186
Longitude:
-71.2468033
Location:
287 Auburn St, Auburndale, MA 02466, 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 326.592ms