crash_reports
3 rows where "date" is on date 2019-05-21, intersection = 0 and keywords contains "Pictures"
This data as json, CSV (advanced)
Suggested facets: speed_limit, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-21
Time:
08:38
Address:
111 HAMMONDSWOOD RD
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 had just gotten out of her MV in the driveway of 111 Hammondswood Rd. While between the door and the MV the MV started rolling backwards down the sloped driveway. The operator grabbed a hold of the top of the door and was dragged backwards across the street into the yard of 104 Hammondswood Rd where it came to a stop. The operator initaially claimed minor injuries but signed a refusal. This accident was caused by operator error as it appears that the car was not completely in park. There was minor damage(tire track mark) to the lawn. I attempted to contact the homeowner with negative results. I took pictures of the damage and TOT IT.
Keywords:
Crash, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3331925
Longitude:
-71.1795815
Location:
Case
number:
Date:
2019-05-21
Time:
16:36
Address:
53 RANGELEY RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Tipruthai Thangthong stated that on 05/21/2019 at approximately 16:36 hours she was pulling into the driveway of her sisters home at 53 Rangeley Rd while operating her vehicle MA reg 2LVL61 a 2018 Honda Accord. Thangthong stated that her three old son Mighty Mettanant was a passenger in her vehicle. Thangthong stated that she was driving approximately 5 MPH as she drove into the driveway. The driveway runs east to west and Thangthong's vehicle was heading west into the driveway as the sun was in the Western sky creating a glare. Thangthong stated that she did no see anything in the driveway prior to her pulling into it. Thangthong stated that she felt the front of her vehicle strike what she described as " something " and stopped her vehicle. Thangthong stated that she put her vehicle in reverse and then into park and exited her vehicle to see what she had struck. Thangthong stated that she saw her two nieces, Kalla Mongkhonlertsirkul age three and Kelley Mongkhonlertsirkul age seven laying in the driveway in front of her vehicle. Thangthong stated that she then realized that her vehicle had stuck her two nieces as they were in the driveway. Both of the Mongkhonlertsirkul sisters were conscious and alert and were able to walk to an ambulance for transport to Newton Wellesley Hospital for treatment. Thangthong stated that she and her son were not injured in the crash. I observed no damage to Thangthong's vehicle. I responded to the Newton Wellesley Hospital and spoke with the Mongkhonlertsirkul sisters and their mother Piyada Kellum. Kellum stated that her oldest daughter Kelly is a student at the Franklin Elementary School . Kellum stated that her daughters told her that they were playing in their driveway when their aunt's vehicle entered the driveway and did not stop. I spoke with both of the Mongkhonlertsirkul sisters who told me that they tried to get out of the way of their aunt's vehicle but could not in time. The Mongkhonlertsirkul sisters stated that they were both struck in the back and fell to the ground between the two front tires of their aunt's vehicle. Kalla Mongkhonlertsirkul had scrapes to her right knuckles. Kelly Mongkhonlertsirkul had lacerations to her lower left arm and the left side of her face near her eye. I spoke with hospital staff who stated that there did not appear to be any broken bones or other internal injures. I took photos of the crash area and forwarded the disk to the NPD's IT bureau for downloading.
Keywords:
Crash, Ems, Glare, Hospital, Pictures, School, Solar, Walk
Dcc:
Glare, Inattention
Report
url:
Image
url:
Latitude:
42.3562921
Longitude:
-71.2254774
Location:
Case
number:
Date:
2019-05-21
Time:
19:12
Address:
11 LOVETT RD
Speed
limit:
30
Violation
cited:
no
Narrative:
Vehicle 1 was travelling southbound on Brookline St, and took a right turn onto Lovett St. The operator of the bicycle crashed into the back right of vehicle 1 as it was taking the turn. There was minor damage to the rear of vehicle 1. I observed a dent with a small amount of blood on it. I observed a laceration on the right arm of the operator of the bicycle. The medics evaluated the operator of the bicycle, and cleared with a patient refusal. Pictures were taken, and placed in the IT bureau's mailbox.
Keywords:
Bike, Crash, Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3011824
Longitude:
-71.1834461
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);