crash_reports
1 row where dcc = "["Over-steering", "Inattention"]", intersection = 0 and keywords contains "Hospital"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-10-27
Time:
18:15
Address:
854 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
I was dispatched to 854 Beacon St, Newton, MA for an overturned motor vehicle accident. I arrived on scene and saw Vehicle #1 (MA reg 9AS213) overturned on its driver's side with the female operator/registered owner trapped inside. Newton Fire arrived on scene and mechanically removed the operator out of the motor vehicle. Prior to where Vehicle #1 was overturned I observed Vehicle #2 (MA reg 615FF6) with rear bumper damage and a snapped rear axle. Vehicle #2 was unoccupied. Operator of Vehicle #1 was transported to Newton-Wellesley Hospital for treatment by Newton Medics. Both motor vehicles were towed by Tody's and inventory sheets were completed and filed. I spoke with the Operator of Vehicle #1 at Newton-Wellesley Hospital. Operator stated that she does not remember what happened before the crash and that she only remembers waking up in her car. I told her that her car was towed and a report is on file. Ofc Selig spoke with the registered owner of Vehicle #2 and notified her of the incident. Based on my investigation it appears that Vehicle #1 struck the rear of Vehicle #2 and the operator over steered causing the vehicle to overturn onto the driver's side.
Keywords:
Crash, Fire, Hospital
Dcc:
Over-steering, Inattention
Report
url:
Image
url:
Latitude:
42.330261
Longitude:
-71.1965808
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);