WHO GLASS
@owid.antimicrobial_usage
@owid.antimicrobial_usage
CREATE TABLE owid_aware (
"country" VARCHAR,
"year" INTEGER,
"awarelabel" VARCHAR,
"ddd" FLOAT,
"did" FLOAT
);
CREATE TABLE owid_class (
"country" VARCHAR,
"year" INTEGER,
"antimicrobialclass" VARCHAR,
"atc4name" VARCHAR,
"routeofadministration" VARCHAR,
"ddd" FLOAT,
"did" FLOAT
);
CREATE TABLE owid_class_aggregated (
"country" VARCHAR,
"year" INTEGER,
"ddd_anti_malarials" FLOAT,
"ddd_antibacterials_and_antituberculosis" UINTEGER,
"ddd_antifungals" UINTEGER,
"ddd_antituberculosis" FLOAT,
"ddd_antivirals" FLOAT,
"did_anti_malarials" FLOAT,
"did_antibacterials_and_antituberculosis" FLOAT,
"did_antifungals" FLOAT,
"did_antituberculosis" FLOAT,
"did_antivirals" FLOAT
);
Anyone who has the link will be able to view this.