home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2019-12-18 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:
1900001306
Date:
2019-12-18
Time:
08:24
Address:
192 ADAMS ST
Speed limit:
25
Violation cited:
no
Narrative:
MV1 stated his vehicle was parked in front of 192 Adams Street on 12/12/2019 unoccupied when it was possible sideswiped by a FLIXBUS. MV1 stated his dash cam recorded the incident showing a green and yellow colored Prevost bus with FLIXBUS in large lettering make contact with his vehicle. MV1 was unable to provide a plate number at the time but did state he saw what he believes to be the same bus the following day in the same area on 12/13/2019. MV1 was able to get a plate of MA APN REG:3799A, which is registered to United Leasing INC out of Indiana on a white 2017 PREO H345 58 passenger bus, insured by Safety Insurance. MV1 stated he already filed an accident report with the RMV and notified his insurance company. I attempted to make contact with the FLIXBUS company to get the drivers contact information but was only able to speak with a customer service representative in a foreign country who would not provide me with any information. I was able to locate an email address for the company and emailed a request for information but have not received a response. I advised MV1 of my investigation results and he was satisfied. MV1 stated the damage to his vehicle was minor.
Keywords:
Bus, Crash
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.358506
Longitude:
-71.2001564
Location:
192 Adams St, Newton, MA 02458, USA
Case number:
1900001307
Date:
2019-12-18
Time:
09:14
Address:
2122 COMMONWEALTH AVE
Speed limit:
30
Violation cited:
no
Narrative:
Owner of MV 1 stated he parked his car legally on Commonwealth Ave across from the Post Office and left his vehicle to go into a store. Operator of MV 2 was parked directly behind MV1 and was sitting in her vehicle, when she states she observed MV3 park in the space directly in front of MV1. Operator of MV2 states she observed MV 1 shake as MV 3 tried parking and believes that the rear passenger end of MV 3 struck the front left bumper of MV 1. Minor damage sustained to MV1's front drivers side and no injuries reported. Owner of MV 1 did not observe the accident. The operator of MV 3 stated that he was traveling west on Commonwealth Ave and parked his MV in a legal parking spot. He and his passenger left his vehicle and when he came back, he was approached by the owner of the MV behind him, who stated that he believed his vehicle may have struck his while parking. Operator of MV3 stated he did not believe he struck MV2 because neither he or his passenger heard, saw or felt anything, but he couldn't be 100 percent sure. There was no damage to MV3.
Keywords:
Crash
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3477034
Longitude:
-71.2484893
Location:
2122 Commonwealth Avenue, 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 308.346ms