Spreadsheet: 770210d1645893518-sums-of-dynamic-unique-values-with-multiple-criteria-sample-tests
Sheet: Data

hospital_DB | type | drug_bug | drug | bug | isolates_hospital_n | isolates_tested | susceptibility | isolates_susceptible | year
ABC MEDICAL CENTER | gram_negative | Amikacin-Citrobacter freundii | Amikacin | Citrobacter freundii | 13 | 12 | 1 |  | 2018
ABC MEDICAL CENTER | gram_negative | [NAME] cloacae complex | Ampicillin | Enterobacter cloacae complex | 44 | 33 | 1 |  | 2019
ABC MEDICAL CENTER | gram_negative | [NAME] coli | Citroxene | E. coli | 10 | 10 | 0.3 |  | 2020
ABC MEDICAL CENTER | gram_positive | Group A Strep-Penicillin | Penicillin | Group A Strep | 253 | 150 | 1 | 25 | 2019
ABC MEDICAL CENTER | gram_positive | Linezolid-MRSA | Linezolid | MRSA | 33 | 24 | 1 |  | 2019
ABC MEDICAL CENTER | gram_negative | Imipenem-Citrobacter freundii | Imipenem | Citrobacter freundii | 13 | 10 | 0.66 |  | 2018
ABC MEDICAL CENTER | gram_negative | Meripenem-Citrobacter freundii | [NAME] | Citrobacter freundii | 13 | 8 | 0.8 |  | 2018
XYZ MEDICAL CENTER | gram_negative | Meripenem-Citrobacter freundii | [NAME] | Citrobacter freundii | 13 | 17 | 0.9 |  | 2018
XYZ MEDICAL CENTER | gram_negative | Ciproflaxin-Citrobacter freundii | Ciprofloxacin | Citrobacter freundii | 67 | 67 | 0.6 |  | 2018
Med hospital | gram_negative | Ciproflaxin-Citrobacter freundii | Ciprofloxacin | Citrobacter freundii | 67 | 60 | 0.8 |  | 2018
Med hospital | gram_positive | Linezolid-MSSA | Linezolid | MSSA | 6 | 5 | 1 |  | 2020
Care MEDICAL CENTER | gram_negative | Amikacin-Proteus mirabilis | Amikacin | Proteus mirabilis | 663 | 662 | 0.89 |  | 2018
Care MEDICAL CENTER | gram_negative | [NAME] cloacae complex | Ampicillin | Enterobacter cloacae complex | 112 | 101 | 0.98 |  | 2019
Care MEDICAL CENTER | gram_positive | Linezolid-MSSA | Linezolid | MSSA | 66 | 34 | 0.89 |  | 2020
Care MEDICAL CENTER | gram_positive | Penicillin-MSSA | Penicillin | MSSA | 66 | 28 | 0.7 |  | 2020
Care MEDICAL CENTER | gram_positive | Penicillin-MRSA | Penicillin | MRSA | 333 | 89 | 0.98 |  | 2020
MedicineHOSPITAL | gram_negative | Ertapenem-Acinetobacter baumannii | Ertapenem | Acinetobacter baumannii | 8 | 7 | 0.77 |  | 2018
MedicineHOSPITAL | gram_negative | Ertapenem-E. coli | Ertapenem | E. coli | 4 | 3 | 0.33 |  | 2020
MedicineHOSPITAL | gram_positive | Group B Strep-Penicillin | Penicillin | Group B Strep | 459 | 457 | 1 |  | 2018
MedicineHOSPITAL | gram_positive | Penicillin-Staphylococcus aureus | Penicillin | Staphylococcus aureus | 32 | 32 | 0.5 |  | 2019
MedicineHOSPITAL | gram_negative | Tobramycin-Klebsiella aerogenes | Tobramycin | Klebsiella aerogenes | 10 | 10 | 1 |  | 2020
XYZ MEDICAL CENTER | gram_negative | Amikacin-Klebsiella pneumoniae | Amikacin | Klebsiella pneumoniae | 5 | 5 | 0.98 |  | 2018
XYZ MEDICAL CENTER | gram_negative | Amikacin-Proteus mirabilis | Amikacin | Proteus mirabilis | 33 | 24 | 1 |  | 2019
XYZ MEDICAL CENTER | gram_negative | [NAME] cloacae complex | Ampicillin | Enterobacter cloacae complex | 213 | 211 | 1 |  | 2019
XYZ MEDICAL CENTER | gram_negative | [NAME] morganii | Ciprofloxacin | Morganella morganii | 53 | 54 | 0.45 |  | 2019
XYZ MEDICAL CENTER | gram_positive | Group A Strep-Penicillin | Penicillin | Group A Strep | 14 | 14 | 1 |  | 2018
Medcare | gram_negative | Amikacin-E. coli | Amikacin | E. coli | 220 | 33 | 1 |  | 2020