-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathextract_drugs
113 lines (103 loc) · 5.24 KB
/
extract_drugs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
WITH antiplatelet_table AS (
SELECT
subject_id,
MAX(CASE WHEN drug IN ('Aspi','Aspir','Aspiri','aspirin') OR
drug = 'Aspirin' OR drug = 'Aspirin ' OR
drug = 'Aspirin (Buffered)' OR drug = 'Aspirin (Rectal)' OR
drug = 'Aspirin 325 ' OR drug = 'Aspirin 325 mg' OR
drug = 'aspirin 325 mg' OR drug = 'Aspirin 325 mg ' OR
drug = 'Aspirin 325 mg p-o' OR drug = 'Aspirin 325mg' OR
drug = 'Aspirin 325mg ' OR drug = 'Aspirin 325mg TAB' OR
drug = 'aspirin 81 mg' OR drug = 'Aspirin 81 mg' OR
drug = 'Aspirin 81 mg ' OR drug = 'Aspirin 81mg' OR
drug = 'Aspirin 81mg ' OR drug = 'Aspirin 81mg (1cap)' OR
drug = 'Aspirin 81mg or placbo' OR drug = 'Aspirin 81mg TAB' OR
drug = 'Aspirin EC' OR drug = 'Aspirin Low Dose' OR
drug = 'Aspirin Low-Strength' OR drug = 'INV-Aspirin' OR
drug = 'Enteric Coated Aspirin'
THEN 1 ELSE 0 END ) as aspirin,
MAX(CASE WHEN drug = 'clopidigrel 75mg' OR drug = 'Clopidigrel 75mg po' OR
drug = 'clopidogrel' OR drug = 'Clopidogrel' OR
drug = 'Clopidogrel ' OR drug = 'clopidogrel 150 mg' OR
drug = 'Clopidogrel 150 mg' OR drug = 'Clopidogrel 150mg' OR
drug = 'Clopidogrel 75 mg' OR drug = 'Clopidogrel 75mg' OR
drug = 'Clopidogrel Bisulfate' OR drug = 'clopidogrel suspension' OR
drug = 'Clopidogrel75mg' OR drug = 'Clopidogril 75mg' OR
drug = 'Clopidopgrel 75mg ' OR drug ='INV-Clopidogrel' OR
drug = 'Effient' OR drug = 'Plavix' OR drug = 'prasugrel' OR
drug ='Prasugrel'
THEN 1 ELSE 0 END ) as clopidogrel,
MAX(CASE WHEN drug = 'Cangrelor' OR drug = 'Brilinta' OR
drug = 'ticagrelor' OR drug = 'Ticlopidine HCl'
THEN 1 ELSE 0 END ) as ticagrelor,
subject_id, min(starttime)
FROM mimiciv_hosp.prescriptions
WHERE drug = 'aspirin'
group by subject_id;
FROM mimiciv_hosp.prescriptions
GROUP BY subject_id
)
SELECT
subject_id,
aspirin,
clopidogrel,
ticagrelor
FROM antiplatelet_table;
Grouping medications under aspirin, clopidogrel and other_antiplatelet categories, and electing specific drugs under the aspirin, clopidogrel and other_antiplatelet categories only. (together with patient ID, start and stop time of when the medications are administered.
SELECT subject_id,
(CASE WHEN drug IN ('Aspi','Aspir','Aspiri','aspirin') OR
drug = 'Aspirin' OR drug = 'Aspirin ' OR
drug = 'Aspirin (Buffered)' OR drug = 'Aspirin (Rectal)' OR
drug = 'Aspirin 325 ' OR drug = 'Aspirin 325 mg' OR
drug = 'aspirin 325 mg' OR drug = 'Aspirin 325 mg ' OR
drug = 'Aspirin 325 mg p-o' OR drug = 'Aspirin 325mg' OR
drug = 'Aspirin 325mg ' OR drug = 'Aspirin 325mg TAB' OR
drug = 'aspirin 81 mg' OR drug = 'Aspirin 81 mg' OR
drug = 'Aspirin 81 mg ' OR drug = 'Aspirin 81mg' OR
drug = 'Aspirin 81mg ' OR drug = 'Aspirin 81mg (1cap)' OR
drug = 'Aspirin 81mg or placbo' OR drug = 'Aspirin 81mg TAB' OR
drug = 'Aspirin EC' OR drug = 'Aspirin Low Dose' OR
drug = 'Aspirin Low-Strength' OR drug = 'INV-Aspirin' OR
drug = 'Enteric Coated Aspirin'
THEN aspirin,
CASE WHEN drug = 'clopidigrel 75mg' OR drug = 'Clopidigrel 75mg po' OR
drug = 'clopidogrel' OR drug = 'Clopidogrel' OR
drug = 'Clopidogrel ' OR drug = 'clopidogrel 150 mg' OR
drug = 'Clopidogrel 150 mg' OR drug = 'Clopidogrel 150mg' OR
drug = 'Clopidogrel 75 mg' OR drug = 'Clopidogrel 75mg' OR
drug = 'Clopidogrel Bisulfate' OR drug = 'clopidogrel suspension' OR
drug = 'Clopidogrel75mg' OR drug = 'Clopidogril 75mg' OR
drug = 'Clopidopgrel 75mg ' OR drug ='INV-Clopidogrel' OR
drug = 'Effient' OR drug = 'Plavix' OR drug = 'prasugrel' OR
drug ='Prasugrel'
THEN clopidogrel,
CASE WHEN drug = 'Cangrelor' OR drug = 'Brilinta' OR
drug = 'ticagrelor' OR drug = 'Ticlopidine HCl'
THEN ticagrelor,
END ) AS other_antiplatelet,
starttime, stoptime,
FROM mimiciv_hosp.prescriptions
WHEN (drug IN ('Aspi','Aspir','Aspiri','aspirin') OR
drug = 'Aspirin' OR drug = 'Aspirin ' OR
drug = 'Aspirin (Buffered)' OR drug = 'Aspirin (Rectal)' OR
drug = 'Aspirin 325 ' OR drug = 'Aspirin 325 mg' OR
drug = 'aspirin 325 mg' OR drug = 'Aspirin 325 mg ' OR
drug = 'Aspirin 325 mg p-o' OR drug = 'Aspirin 325mg' OR
drug = 'Aspirin 325mg ' OR drug = 'Aspirin 325mg TAB' OR
drug = 'aspirin 81 mg' OR drug = 'Aspirin 81 mg' OR
drug = 'Aspirin 81 mg ' OR drug = 'Aspirin 81mg' OR
drug = 'Aspirin 81mg ' OR drug = 'Aspirin 81mg (1cap)' OR
drug = 'Aspirin 81mg or placbo' OR drug = 'Aspirin 81mg TAB' OR
drug = 'Aspirin EC' OR drug = 'Aspirin Low Dose' OR
drug = 'Aspirin Low-Strength' OR drug = 'INV-Aspirin' OR
drug = 'Enteric Coated Aspirin' OR drug = 'clopidigrel 75mg' OR drug = 'Clopidigrel 75mg po' OR
drug = 'clopidogrel' OR drug = 'Clopidogrel' OR
drug = 'Clopidogrel ' OR drug = 'clopidogrel 150 mg' OR
drug = 'Clopidogrel 150 mg' OR drug = 'Clopidogrel 150mg' OR
drug = 'Clopidogrel 75 mg' OR drug = 'Clopidogrel 75mg' OR
drug = 'Clopidogrel Bisulfate' OR drug = 'clopidogrel suspension' OR
drug = 'Clopidogrel75mg' OR drug = 'Clopidogril 75mg' OR
drug = 'Clopidopgrel 75mg ' OR drug ='INV-Clopidogrel' OR
drug = 'Effient' OR drug = 'Plavix' OR drug = 'prasugrel' OR
drug ='Prasugrel' drug = 'Cangrelor' OR drug = 'Brilinta' OR
drug = 'ticagrelor' OR drug = 'Ticlopidine HCl') ;