Drugs Collected: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
Line 38: | Line 38: | ||
tables=Data_Element, Drugs_Included, | tables=Data_Element, Drugs_Included, | ||
|join on=Data_Element._pageName = Drugs_Included._pageName | |join on=Data_Element._pageName = Drugs_Included._pageName | ||
|fields=Data_Element.sort=sort, Data_Element._pageName=page, | |fields=Data_Element.sort=sort, Data_Element._pageName=page, Data_Element.CCMDB_label, drugs_included=drugs included, end_date=end | ||
|where=Data_Element.tables HOLDS "L_Log table" and Data_Element._pageName LIKE "pharm%" | |where=Data_Element.tables HOLDS "L_Log table" and Data_Element._pageName LIKE "pharm%" | ||
|order by=sort | |order by=sort | ||
Line 44: | Line 44: | ||
|more results text=Click here for the full list of drugs we have ever counted, with start and stop dates. | |more results text=Click here for the full list of drugs we have ever counted, with start and stop dates. | ||
|default=no results were found | |default=no results were found | ||
|format= | |format=table | ||
|rows per page=50 | |rows per page=50 | ||
}} | }} |
Revision as of 14:14, 25 November 2021
see Pharmacy collection for collection instructions
The drugs in brackets () are the brand names. If a specific drug/brand name is not listed on the wiki but you think it is part of one of the drug categories we collect, please flag this on the respective wiki page.
Pharmacy List
Counted drugs
Use ctrl-f to find the drug you are looking for. Edit the lists of drugs on the data item pages themselves.
sort | page | drugs included |
---|---|---|
sort | page | drugs included |
13 | Azoles |
|
14 | Fungins |
|
15 | Antipseudomonals |
|
16 | Vancomycin |
|
17 | Fluoroquinolones |
|
18 | Carbapenems |
|
19 | Vanco alternatives |
|
Click here for the full list of drugs we have ever counted, with start and stop dates.
yes/no drugs
sort | page | CCMDB label | drugs included | end |
---|---|---|---|---|
92 | Pharm Vitamin K antagonists field | (A4)vitamin K antagonists |
|
2300-01-01 |
93 | Pharm Heparin cont inf | (A5)heparin cont inf | by IV continuous infusion only | 2300-01-01 |
94 | Pharm Direct thrombin inhibitors | (B1)direct thrombin inhibitors |
|
2300-01-01 |
95 | Pharm Heparinoids | (B2)Heparinoids |
|
2300-01-01 |
96 | Pharm Factor Xa inhibitors | (B3)Factor Xa inhibitors |
|
2300-01-01 |
97 | Pharm Dopamine cont inf | (C2)dopamine cont inf | 2300-01-01 | |
98 | Pharm Dobutamine cont inf | (C3)dobutamine cont inf | 2300-01-01 | |
99 | Pharm Norepinephrine cont inf | (C4)norepinephrine cont inf |
|
2300-01-01 |
100 | Pharm Epinephrine cont inf | (C5)epinephrine cont inf | 2300-01-01 | |
101 | Pharm Phenylephrine cont inf | (D1)phenylephrine cont inf |
|
2300-01-01 |
102 | Pharm Vasopressin cont inf | (D2)vasopressin cont inf | 2300-01-01 | |
103 | Pharm Milrinone cont inf | (D3)milrinone cont inf | 2300-01-01 | |
104 | Pharm Paralytics cont inf | (E1)paralytics cont IV only |
|
2300-01-01 |
105 | Pharm corticosteroids | (E2)corticosteroids |
|
2300-01-01 |
106 | Pharm amphotericin B | (E3)amphotericin B |
|
2300-01-01 |
107 | Pharm macrolides | <not in CCMDB> | 2013-03-17 | |
108 | Pharm 1st or 2nd generation cephalosporins | <not in CCMDB> | 2013-08-07 | |
109 | Pharm 4th generation cephalosporins | <not in CCMDB> | 2013-02-28 | |
110 | Pharm antistaph penicillins | <not in CCMDB> | 2013-02-19 | |
111 | Pharm aminoglycosides | <not in CCMDB> | 2013-03-05 | |
112 | Pharm influenza drugs | (E4)influenza drugs |
|
2300-01-01 |
113 | Pharm bosentan | (E5)bosentan |
|
2300-01-01 |
114 | Pharm viagra-type vasodilators | (F1)viagra-type vasodilators |
|
2300-01-01 |
115 | Pharm special upper GI bleeding agents | (A3)special upper GI bleeding agents |
|
2300-01-01 |
116 | Pharm amiodarones | (F2)amiodarones | 2300-01-01 | |
117 | Pharm anti-TB drugs | (F3)anti-TB drugs |
|
2300-01-01 |
118 | Pharm statins | (F4)statins |
|
2300-01-01 |
119 | Pharm PPI | (A1)PPI |
|
2300-01-01 |
120 | Pharm H2 blockers | (A2)H2 Blockers |
|
2300-01-01 |
121 | Pharm furosemide | (D5)furosemide cont inf |
|
2300-01-01 |
122 | Pharm heparin sq | (A5)Heparin SQ | 2300-01-01 | |
123 | Pharm LMWH | (A7)LMWH |
|
2300-01-01 |
124 | Pharm benzodiazepines | (B4)benzodiazepines cont inf |
|
2300-01-01 |
125 | Pharm opioids | (B5)opioids cont inf (not PCA) |
|
2300-01-01 |
126 | Pharm propofol | (C1)propofol cont inf | 2300-01-01 | |
127 | Pharm insulin | (D4)insulin cont inf | 2300-01-01 |