search

MIT-LCP / eicu-code

Code and website related to the eICU Collaborative Research Database
https://eicu-crd.mit.edu
MIT License
307 stars 212 forks source link

Find all antibiotic applications #228

Open schererdavid opened 1 year ago

schererdavid commented 1 year ago

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 commented 1 year ago

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