crash_reports
1 row where "datetime" is on date 2019-12-18, dcc contains "Unknown" and keywords contains "Bus"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
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:
Image
url:
Latitude:
42.358506
Longitude:
-71.2001564
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
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);