crash_reports
2 rows where dcc = "["Distracted"]" and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-16
Time:
15:14
Address:
135 WELLS AVE
Speed
limit:
10
Violation
cited:
no
Narrative:
The owner of vehicle 1 arrived to the parking lot of the Boston Sports Club at 135 Wells Ave, at approximately 09:30 hours. He left the gym at approximately 15:00 hours, at which point he noticed that his vehicle (vehicle 1) had a white paint mark on the rear left side. There was a note left on vehicle 1 from an unknown witness, which provided the license plate of vehicle 2. The note stated that the person witnessed vehicle 2 hit vehicle 1. I was able to locate vehicle 2 at the owners residence. I asked them if they were aware that they hit a vehicle today at Boston Sports Club. They stated that they did not hit any vehicle. I asked if I could see the vehicle in their garage, and they stated I could. I noticed green paint on the right rear side of vehicle 2. The owner of vehicle 2 acted surprised, and stated that they must have hit a vehicle backing up. She stated her radio was on very loud, and did not hear or feel any collision. I advised her if she hits a car that she needs to leave her information or to locate the owner, and she stated she would have if she had known. I supplied the owner of vehicle 1 with all the information he needed to file a claim with his insurance if he would like. He was satisfied.
Keywords:
[]
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.2921993
Longitude:
-71.1952581
Location:
Case
number:
Date:
2022-05-30
Time:
10:33
Address:
276 CHURCH ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On May 30th, 2022 at approximately 10:33 hours, while assigned to N491 I responded to #276 Church St, the YMCA parking lot for a report of a MV crash. On my arrival I located both involved vehicles in front of the main entrance doors to the YMCA. Vehicle #1 was a White 2019 Toyota RAV4, Ma. plate 2VKZ97. Owner was identified as Tamer M. Tahoun. He stated he was sitting in his parked vehicle in front of the YMCA when vehicle#2 struck his vehicle as it was backing into a parking space behind him. Vehicle #1 sustained damage to its drivers side rear quarter. Vehicle #2 was a 2018 Green Subaru Forester, Ma plate, 433NT9, operated by a Ralph Gilbert. He stated he was attempting to back into a parking space behind vehicle #1 when he struck vehicle#1. His vehicle sustained damage to its passenger side front quarter. There were no reported injuries and neither vehicle required a tow.
Keywords:
Crash
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3545312
Longitude:
-71.1913325
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);