crash_reports
2 rows where "retrieved" is on date 2022-06-01 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:
2022-05-24
Time:
13:24
Address:
2014 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On 524/2022 at approx 1324Hrs while assigned to 497 I responded to the west entrance of Newton Wellesley Hospital for a report of a two car crash. Upon arrival I observed a gray Land Rover Ma Reg 1106 and a white delivery truck Ma reg W13340 connected at the entrance to the rear of NWH, an area that is under construction. I spoke with the owner of the Land Rover, Frederick Camerato who stated he had parked his car in order to pick someone at the hospital up, while it was parked it was struck and dragged by a delivery truck, Ma Reg W13340 being operated by Mohammed Aquas. Aquas stated he was heading to make a delivery to the hospital and the Land Rover was parked in an illegal spot. Construction at the hospital created poor conditions, in addition to multiple vehicles stopped or parked in the fire lane. There were multiple construction trucks parked on access road and on the curb.
Keywords:
Crash, Fire, Hospital
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3306679
Longitude:
-71.2477866
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);