Global Health Observatory - World Health Organization

CREATE TABLE owid_treatment_programmes_for_children_and_adolescents_39f97f4a (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "treatment_programmes_for_children_and_adolescents_with_029683db" VARCHAR  -- Treatment Programmes For Children And Adolescents With Alcohol Use Disorders, Treatment
);

CREATE TABLE owid_treatment_programmes_for_children_and_adolescents_3a354dbb (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "treatment_programmes_for_children_and_adolescents_with_0ed7ca14" VARCHAR  -- Treatment Programmes For Children And Adolescents With Drug Use Disorders, Youth
);

CREATE TABLE owid_treatment_programmes_for_children_and_adolescents_4b20cb57 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "treatment_programmes_for_children_and_adolescents_with_ac58365e" VARCHAR  -- Treatment Programmes For Children And Adolescents With Drug Use Disorders, Treatment
);

CREATE TABLE owid_treatment_programmes_for_children_and_adolescents_6d0bd0c1 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "treatment_programmes_for_children_and_adolescents_with_de15460e" VARCHAR  -- Treatment Programmes For Children And Adolescents With Alcohol Use Disorders, Youth
);

CREATE TABLE owid_treatment_programmes_for_children_and_adolescents_9d1d9487 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "treatment_programmes_for_children_and_adolescents_with_029683db" VARCHAR  -- Treatment Programmes For Children And Adolescents With Alcohol Use Disorders, Treatment,
  "treatment_programmes_for_children_and_adolescents_with_499e57ca" VARCHAR  -- Treatment Programmes For Children And Adolescents With Alcohol Use Disorders, Treatment Low,
  "treatment_programmes_for_children_and_adolescents_with_f1b175dd" VARCHAR  -- Treatment Programmes For Children And Adolescents With Alcohol Use Disorders, Treatment High,
  "comments" VARCHAR
);

CREATE TABLE owid_treatment_programmes_for_children_and_adolescents_d5987ce0 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "treatment_programmes_for_children_and_adolescents_with_ac58365e" VARCHAR  -- Treatment Programmes For Children And Adolescents With Drug Use Disorders, Treatment,
  "treatment_programmes_for_children_and_adolescents_with_f1d074bf" VARCHAR  -- Treatment Programmes For Children And Adolescents With Drug Use Disorders, Treatment Low,
  "treatment_programmes_for_children_and_adolescents_with_e685d48e" VARCHAR  -- Treatment Programmes For Children And Adolescents With Drug Use Disorders, Treatment High,
  "comments" VARCHAR
);

CREATE TABLE owid_treatment_programmes_for_children_and_adolescents_e811e7cf (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "treatment_programmes_for_children_and_adolescents_with_0ed7ca14" VARCHAR  -- Treatment Programmes For Children And Adolescents With Drug Use Disorders, Youth,
  "treatment_programmes_for_children_and_adolescents_with_4954b629" VARCHAR  -- Treatment Programmes For Children And Adolescents With Drug Use Disorders, Youth Low,
  "treatment_programmes_for_children_and_adolescents_with_8355a3ab" VARCHAR  -- Treatment Programmes For Children And Adolescents With Drug Use Disorders, Youth High,
  "comments" VARCHAR
);

CREATE TABLE owid_treatment_programmes_for_children_and_adolescents_fa631b93 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "treatment_programmes_for_children_and_adolescents_with_de15460e" VARCHAR  -- Treatment Programmes For Children And Adolescents With Alcohol Use Disorders, Youth,
  "treatment_programmes_for_children_and_adolescents_with_9b37dc9f" VARCHAR  -- Treatment Programmes For Children And Adolescents With Alcohol Use Disorders, Youth Low,
  "treatment_programmes_for_children_and_adolescents_with_cd1baa75" VARCHAR  -- Treatment Programmes For Children And Adolescents With Alcohol Use Disorders, Youth High,
  "comments" VARCHAR
);

CREATE TABLE owid_treatment_programmes_for_women_with_alcohol_use_d_57205cef (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "treatment_programmes_for_women_with_alcohol_use_disorders" VARCHAR
);

CREATE TABLE owid_treatment_programmes_for_women_with_alcohol_use_d_b20cb64e (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "treatment_programmes_for_women_with_alcohol_use_disorders" VARCHAR,
  "treatment_programmes_for_women_with_alcohol_use_disorders_low" VARCHAR,
  "treatment_programmes_for_women_with_alcohol_use_disorders_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_treatment_programmes_for_women_with_drug_use_disorders_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "treatment_programmes_for_women_with_drug_use_disorders" VARCHAR
);

CREATE TABLE owid_treatment_programmes_for_women_with_drug_use_disorders_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "treatment_programmes_for_women_with_drug_use_disorders" VARCHAR,
  "treatment_programmes_for_women_with_drug_use_disorders_low" VARCHAR,
  "treatment_programmes_for_women_with_drug_use_disorders_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_treatment_services_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_services" VARCHAR  -- Treatment, Services
);

CREATE TABLE owid_treatment_services_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_services" VARCHAR  -- Treatment, Services,
  "treatment_services_low" VARCHAR  -- Treatment, Services Low,
  "treatment_services_high" VARCHAR  -- Treatment, Services High,
  "comments" VARCHAR
);

CREATE TABLE owid_treatment_setting_for_substance_use_disorders_mos_166386f9 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_type_disorders" VARCHAR,
  "treatment_setting_for_substance_use_disorders_most_common" VARCHAR  -- Treatment Setting For Substance Use Disorders, Most Common
);

CREATE TABLE owid_treatment_setting_for_substance_use_disorders_mos_5c036d60 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_type_disorders" VARCHAR,
  "treatment_setting_for_substance_use_disorders_most_common" VARCHAR  -- Treatment Setting For Substance Use Disorders, Most Common,
  "treatment_setting_for_substance_use_disorders_most_common_low" VARCHAR  -- Treatment Setting For Substance Use Disorders, Most Common Low,
  "treatment_setting_for_substance_use_disorders_most_common_high" VARCHAR  -- Treatment Setting For Substance Use Disorders, Most Common High,
  "comments" VARCHAR
);

CREATE TABLE owid_treatment_slots_for_alcohol_and_drug_use_disorder_1f9baae7 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_slots_for_alcohol_and_drug_use_disorders_out_e0811e70" FLOAT  -- Treatment Slots For Alcohol And Drug Use Disorders, Outpatient, Per 10–000
);

CREATE TABLE owid_treatment_slots_for_alcohol_and_drug_use_disorder_45f83f17 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_slots_for_alcohol_and_drug_use_disorders_out_e0811e70" FLOAT  -- Treatment Slots For Alcohol And Drug Use Disorders, Outpatient, Per 10–000,
  "treatment_slots_for_alcohol_and_drug_use_disorders_out_caa16563" VARCHAR  -- Treatment Slots For Alcohol And Drug Use Disorders, Outpatient, Per 10–000 Low,
  "treatment_slots_for_alcohol_and_drug_use_disorders_out_78418965" VARCHAR  -- Treatment Slots For Alcohol And Drug Use Disorders, Outpatient, Per 10–000 High,
  "comments" VARCHAR
);

CREATE TABLE owid_treatment_success_rate_for_new_pulmonary_smear_ne_9884af29 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_success_rate_for_new_pulmonary_smear_negativ_1df46b08" INTEGER  -- Treatment Success Rate For New Pulmonary Smear Negative And Extrapulmonary Tuberculosis Cases
);

CREATE TABLE owid_treatment_success_rate_for_patients_treated_for_m_7e5065c2 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_success_rate_for_patients_treated_for_mdr_tb_pct" INTEGER  -- Treatment Success Rate For Patients Treated For Mdr Tb, Pct
);

CREATE TABLE owid_treatment_success_rate_for_patients_treated_for_m_ca9feafc (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_success_rate_for_patients_treated_for_mdr_tb_pct" INTEGER  -- Treatment Success Rate For Patients Treated For Mdr Tb, Pct,
  "treatment_success_rate_for_patients_treated_for_mdr_tb_pct_low" VARCHAR  -- Treatment Success Rate For Patients Treated For Mdr Tb, Pct Low,
  "treatment_success_rate_for_patients_treated_for_mdr_tb_pct_high" VARCHAR  -- Treatment Success Rate For Patients Treated For Mdr Tb, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_treatment_success_rate_hiv_positive_tb_cases_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_success_rate_hiv_positive_tb_cases" INTEGER  -- Treatment Success Rate, Hiv Positive Tb Cases
);

CREATE TABLE owid_treatment_success_rate_hiv_positive_tb_cases_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_success_rate_hiv_positive_tb_cases" INTEGER  -- Treatment Success Rate, Hiv Positive Tb Cases,
  "treatment_success_rate_hiv_positive_tb_cases_low" VARCHAR  -- Treatment Success Rate, Hiv Positive Tb Cases Low,
  "treatment_success_rate_hiv_positive_tb_cases_high" VARCHAR  -- Treatment Success Rate, Hiv Positive Tb Cases High,
  "comments" VARCHAR
);

CREATE TABLE owid_treatment_success_rate_new_tb_cases_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_success_rate_new_tb_cases" INTEGER  -- Treatment Success Rate, New Tb Cases
);

CREATE TABLE owid_treatment_success_rate_new_tb_cases_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_success_rate_new_tb_cases" INTEGER  -- Treatment Success Rate, New Tb Cases,
  "treatment_success_rate_new_tb_cases_low" VARCHAR  -- Treatment Success Rate, New Tb Cases Low,
  "treatment_success_rate_new_tb_cases_high" VARCHAR  -- Treatment Success Rate, New Tb Cases High,
  "comments" VARCHAR
);