crash_reports

1 row where dcc contains "History heart/epilepsy/fainting", intersection = 0 and "retrieved" is on date 2020-10-06

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

1900000525

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:

report

Image url:

image

Latitude:

42.3321561

Longitude:

-71.1759545

Location:

400 Beacon St, Chestnut Hill, MA 02467, USA

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);