Antibiotic Dataset

An Overview of Common Antibiotics

@kaggle.kanchana1990_antibiotic_dataset

Antibiotics List

@kaggle.kanchana1990_antibiotic_dataset.antibiotics_list

name Name	family Family	usage Usage	popular_brand_name Popular Brand Name
Amoxicillin	Penicillin	Bacterial infections (ear, nose, throat, skin)	Amoxil, Trimox
Ciprofloxacin	Fluoroquinolone	Bacterial infections (UTI, respiratory)	Cipro
Doxycycline	Tetracycline	Bacterial infections, acne, malaria prophylaxis	Vibramycin, Oracea
Azithromycin	Macrolide	Bacterial infections (respiratory, skin)	Zithromax, Z-Pak
Cephalexin	Cephalosporin	Bacterial infections (skin, bone, ear)	Keflex
Trimethoprim/Sulfamethoxazole	Sulfonamide	UTIs, MRSA infections	Bactrim, Septra
Levofloxacin	Fluoroquinolone	Bacterial infections (pneumonia, UTI, skin)	Levaquin
Clindamycin	Lincosamide	Bacterial infections (skin, soft tissue)	Cleocin
Metronidazole	Nitroimidazole	Bacterial and protozoal infections (anaerobic bacteria, trichomoniasis)	Flagyl
Penicillin V	Penicillin	Streptococcal infections (throat), pneumococcal infections	Veetids


CREATE TABLE antibiotics_list (
  "name" VARCHAR,
  "family" VARCHAR,
  "usage" VARCHAR,
  "popular_brand_name" VARCHAR
);