crash_reports
2 rows where dcc = "["History heart/epilepsy/fainting"]", dcc contains "History heart/epilepsy/fainting" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-23
Time:
15:52
Address:
400 BEACON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Vehicle #1 stated they were traveling east bound on beacon st. when the driver fainted. The passenger in Vehicle #1 stated that the driver fainted and then the vehicle drifted left and off the road before crashing into a tree. The operator of Vehicle #1 doesn't remember anything after fainting. The vehicle had major damage to the front of the vehicle and was unable to be driven and towed by Tody's towing. Both parties were evaluated by medics and the passenger refused any further medical treatment. The operator of Vehicle #1 did go to Newton Wellesley Hospital for further evaluation. The operator of Vehicle #1 did stated she was on a new medication for blood pressure her doctor prescribed her a few days ago.
Keywords:
Crash, Hospital, Tree
Dcc:
History heart/epilepsy/fainting
Report
url:
Image
url:
Latitude:
42.3321561
Longitude:
-71.1759545
Location:
Case
number:
Date:
2021-11-12
Time:
07:19
Address:
1301 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Friday 11/12/2021 at approx 0719hrs, while assigned to N-496, I responded to an MVA in front of 1301 Centre in Newton. On scene, I observed MV2's front bumper still in contact with MV1's rear bumper. The operator of MV2, Ellen Wheeler, was hunched over inside her vehicle with her head resting on the driver side window. When I opened the door, she slowing raised her head and appeared disoriented. She did not know where she was and was unaware she was just involved in an accident. Medics and fire personnel placed Wheeler on a stretcher and she was transported to NWH. MV2, which sustained minor front end damage, was moved to the First Baptist Church parking lot at 848 Beacon St. The parish was notified that it would be parked there temporarily. Operator of MV1 said that she was stopped in traffic heading NB on Centre St when MV1 hit the back of her vehicle "very hard." MV1 sustained damage to its rear bumper but the accident did not disable the vehicle.
Keywords:
Crash, Fire
Dcc:
History heart/epilepsy/fainting
Report
url:
Image
url:
Latitude:
42.3293113
Longitude:
-71.195583
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);