Find all antibiotic applications

[schererdavid]

When I search infusiondrug for amoxicillin, I keep getting 0 results and for admissiondrug there are only 396.

SELECT * FROM physionet-data.eicu_crd.infusiondrug WHERE LOWER(drugname) LIKE '%amoxicillin%'

SELECT * FROM physionet-data.eicu_crd.admissiondrug WHERE LOWER(drugname) LIKE '%amoxicillin%'

Is this the right and best way to find the uses of antibiotic applications before, during, and after an ICU stay? Is it really necessary to search for each drug individually or to know its name?

[jraffa]

Hi @schererdavid,

We have very limited data about medications before and after an ICU stay. During, you will find in infusion drug and medication tables. I'm not a clinician, but amoxicillin I don't think is used as much as some other antibiotics, such as azithromycin and vancomycin. There thousands of doses recorded in the medication tables for each.

Jesse