home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc = "["Lane departure", "Unknown"]", intersection = 0 and "retrieved" is on date 2020-10-06

✎ 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:
1900000183
Date:
2019-02-13
Time:
10:21
Address:
280 NEWTONVILLE AVE
Speed limit:
15
Violation cited:
no
Narrative:
On Wednesday, February 13, 2019 while assigned to Traffic unit N525, I responded to the 280 Newtonville Avenue, Newton for a report of a past hit and run accident. I met with Madeleine Aubourg (S67566148) who stated she is a Nursing Assistant at Cabot Park Village. Aubourg stated due to the snowfall the area had the previous day, Aubourg left her vehicle parked (S) in the rear parking lot overnight. Aubourg stated this morning when she returned to work she observed damage to the front bumper area of her 2018 Toyota Camry (MA: 6AN179). Aubourg stated she believes sometime overnight when the parking lot was being plowed a plow truck hit the front of her vehicle. I observed moderate damage to the front bumper area. I spoke with Adolfo Merida-Diaz (S44133458) on scene who stated he is employed by Marquense Landscaping and is responsible for the snow removal at 280 Newtonville Avenue. Merida-Diaz stated last evening and this morning he removed snow from the parking lot and did not make contact with any vehicles in the parking lot during his duties. I showed Merida-Diaz where the alleged accident occurred. Merida-Diaz stated he does not remember a car being parked in that particular spot, but if there was a car parked there he leaves enough room so he is not near any vehicles. I did not observe any surveillance cameras in this portion of the parking lot. There are no witnesses to the alleged accident. Aubourg was advised to speak with her insurance company.
Keywords:
Crash, Moderate, Snow
Dcc:
Lane departure, Unknown
Report url:
report
Image url:
image
Latitude:
42.3509349
Longitude:
-71.1980647
Location:
280 Newtonville Ave, Newton, MA 02460, USA
Case number:
1900000326
Date:
2019-03-29
Time:
10:45
Address:
1232 WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
The operator of MV#1 stated that he was traveling east on Washington St in the right hand lane in front of #1232 Washington St when his MV was struck by MV#2, who was also traveling east on Washington St in the left bound lane. The female operator of MV#2 pulled over initially, but then left the area. Operator #1 took a photograph of MV#2 and reports a female was operating Ma. Reg. 5HW272, a Toyt. Highlander. Mansfield PD notified and will have owner of MV#2 contact me.
Keywords:
Pictures
Dcc:
Lane departure, Unknown
Report url:
report
Image url:
image
Latitude:
42.3491307
Longitude:
-71.224465
Location:
1232 Washington St, West 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 672.227ms