Preventive Chemotherapy (PC) Data Portal

CREATE TABLE owid_soil_transmitted_helminthiases_national_pre_sac (
  "country" VARCHAR,
  "year" INTEGER,
  "national_coverage_pre_sac_pct" FLOAT  -- National Coverage, Pre Sac, Pct,
  "population_requiring_pc_for_sth_pre_sac" FLOAT  -- Population Requiring Pc For Sth, Pre Sac,
  "estimated_number_of_pre_sac_treated" FLOAT
);

CREATE TABLE owid_soil_transmitted_helminthiases_national_sac (
  "country" VARCHAR,
  "year" INTEGER,
  "national_coverage_sac_pct" FLOAT  -- National Coverage, Sac, Pct,
  "population_requiring_pc_for_sth_sac" FLOAT  -- Population Requiring Pc For Sth, Sac,
  "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  -- Programme Coverage, Pct
);

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  -- Programme Coverage, Pct
);