Preventive Chemotherapy (PC) Data Portal

CREATE TABLE owid_soil_transmitted_helminthiases_national_pre_sac (
  "country" VARCHAR,
  "year" INTEGER,
  "national_coverage_pre_sac_pct" FLOAT,
  "population_requiring_pc_for_sth_pre_sac" FLOAT,
  "estimated_number_of_pre_sac_treated" FLOAT
);

CREATE TABLE owid_soil_transmitted_helminthiases_national_sac (
  "country" VARCHAR,
  "year" INTEGER,
  "national_coverage_sac_pct" FLOAT,
  "population_requiring_pc_for_sth_sac" FLOAT,
  "estimated_number_of_sac_treated" FLOAT
);

CREATE TABLE owid_soil_transmitted_helminthiases_pre_sac (
  "country" VARCHAR,
  "year" INTEGER,
  "drug_combination" VARCHAR,
  "number_targeted" FLOAT,
  "reported_number_treated" FLOAT,
  "programme_coverage_pct" FLOAT
);

CREATE TABLE owid_soil_transmitted_helminthiases_sac (
  "country" VARCHAR,
  "year" INTEGER,
  "drug_combination" VARCHAR,
  "number_targeted" FLOAT,
  "reported_number_treated" FLOAT,
  "programme_coverage_pct" FLOAT
);