home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2022-04-13, intersection = 0 and "retrieved" is on date 2022-04-21

✎ 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:
22000308
Date:
2022-04-13
Time:
10:28
Address:
1750 COMMONWEALTH AVE
Speed limit:
30
Violation cited:
no
Narrative:
The operator of Vehicle #1 stated that he was stopped at the red light at the intersection of Commonwealth Ave and Washington St when the rear-end of his vehicle was struck by Vehicle #2. The operator of Vehicle #2 stated that she attempted to pull forward prior to colliding with the rear-end of Vehicle #1. None of the parties complained of injury when asked. Vehicle #2 was towed from the scene by Tody's.
Keywords:
[]
Dcc:
Followed too closely
Report url:
report
Image url:
image
Latitude:
42.3405731
Longitude:
-71.2384715
Location:
1750 Commonwealth Avenue, Newton, MA 02465, USA
Case number:
22000309
Date:
2022-04-13
Time:
09:15
Address:
1169 COMMONWEALTH AVE
Speed limit:
10
Violation cited:
no
Narrative:
On 4/13/22 at 0915hrs I was dispatched to 1169 Comm Ave for an MVA. The RP on scene was identified as Mr Dustin Aguiar, a Wes Construction employee. Aguiar stated he was called by his office whom informed him the resident from 1169 Comm Ave, later determined to be Ms Helen Macintosh, reported to them that she had just collided with the back of their trailer that was parked on the carriage road. Macintosh was backing out of her driveway at which time her MV rear end struck the trailer. While Macintosh was reporting the accident she was also complaining about the trailer location blocking their driveway resulting in the collision. The Wes office requested a MV accident report from this incident. Aguiar nor any other Wes employee witnessed the accident. On my arrival, Macintosh was not present and I did not observe any trailer parking violations nor the driveway being blocked. No damage to the trailer, only superficial paint transfer. Unknown damage to Macintosh's vehicle. I was able to raise Macintosh's husband at the residence, Mr David Macintosh (lessee). Mr Macintosh stated his wife also called him to report the accident and he in turn called MWRA (contractor supervising sub contractor Wes) to complain. He stated Mrs Macintosh was unavailable at this time to speak but, he stated voluntarily and on her behalf, she in fact was operating their '19 Toyota Highlander (MA reg 7GKA20) that struck the trailer. I properly advised him including that this collision will be documented at the request of Wes. Wes is satisfied with the documentation of this collision.
Keywords:
Crash
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3375407
Longitude:
-71.2150986
Location:
1169 Commonwealth Ave, 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 359.478ms