Parse relationships of patients

Relationships of patients are listed under the travel_hx field (travel history). Create a way to extract the data as accurately as possible.

Sample data

(HOUSEHOLD MEMBER OF PH9) HUSBAND OF PH30
(HOUSEHOLD MEMBER OF PH9) NIECE OF PH9
(HOUSEHOLD OF PH9) WIFE OF PH28
(HOUSEHOLD OF PH9) WIFE OF PH9
BROTHER OF PH52
CONTACT OF PH141
CONTACT OF PH143
CONTACT OF PH157
CONTACT OF PH158
CONTACT OF PH164
CONTACT OF PH169 AND PH170
CONTACT OF PH170 AND PH176
CONTACT OF PH173
CONTACT OF PH35
CONTACT OF PH42, PH43
CONTACT OF PH43
CONTACT OF PH43
CONTACT OF PH49 AND PH52
DAUGHTER OF PH134, SISTER OF PH51
HUSBAND OF PH166
HUSBAND OF PH17
HUSBAND OF PH35
HUSBAND OF PH6
HUSBAND OF PH90
MOTHER OF PH135 AND PH51
NO TRAVEL HISTORY; CONTACT OF FN2
RELATIVE OF PH41, PH44, PH87
SISTER OF PH41 AND PH44; RELATIVE OF PH112
SISTER OF PH41 AND PH87; RELATIVE OF PH112
SON OF PH134, BROTHER OF PH135
SON OF PH169 AND PH176
TAIWAN; HUSBAND OF PH19
USA; SISTER OF PH44 AND PH87; RELATIVE OF PH112
UNITED KINGDOM; SISTER OF PH49
WIFE IS SISTER OF PH12; CLOSE CONTACT OF PH35
WIFE OF PH16
WIFE OF PH165
WIFE OF PH18
WIFE OF PH32
WIFE OF PH34
WIFE OF PH5
WITH EXPOSURE HISTORY TO PH5
WITH EXPOSURE HISTORY TO PH9
WITH EXPOSURE HISTORY TO A KNOWN COVID-19 CASE
WITH EXPOSURE HISTORY TO A KNOWN COVID-19 CASE
WITH EXPOSURE HISTORY TO A KNOWN COVID-19 CASE
WITH EXPOSURE TO PH21
WITH EXPOSURE TO PH21
WITH EXPOSURE TO PH21 AND PH67
WITH EXPOSURE TO KNOWN COVID-19 CASE
WITH EXPOSURE TO KNOWN COVID-19 CASE
WITH EXPOSURE TO KNOWN COVID-19 CASE
YES (CHINA); HUSBAND OF PH1
YES (CHINA); WIFE OF PH2
YES (UAE)
YES (USA, KOREA); IN SAME HOUSEHOLD WITH PH27-30; CONTACT OF PH31

hubertursua / ncovph

Parse relationships of patients #1

Sample data