Global Health Observatory - World Health Organization

CREATE TABLE owid_tax_incentives_for_production_low_no_alcohol_cont_56a55365 (
  "year" INTEGER,
  "country" VARCHAR,
  "tax_incentives_for_production_low_no_alcohol_content_beer" VARCHAR,
  "tax_incentives_for_production_low_no_alcohol_content_beer_low" VARCHAR,
  "tax_incentives_for_production_low_no_alcohol_content_beer_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_tax_incentives_for_production_low_no_alcohol_cont_ac276f45 (
  "year" INTEGER,
  "country" VARCHAR,
  "tax_incentives_for_production_low_no_alcohol_content_beer" VARCHAR
);

CREATE TABLE owid_tax_incentives_for_production_of_alcoholic_beverages_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "tax_incentives_for_production_of_alcoholic_beverages" VARCHAR
);

CREATE TABLE owid_tax_incentives_for_production_of_alcoholic_beverages_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "tax_incentives_for_production_of_alcoholic_beverages" VARCHAR,
  "tax_incentives_for_production_of_alcoholic_beverages_low" VARCHAR,
  "tax_incentives_for_production_of_alcoholic_beverages_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_tb_patients_with_known_hiv_status_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "tb_patients_with_known_hiv_status_pct" FLOAT  -- Tb Patients With Known Hiv Status, Pct
);

CREATE TABLE owid_tb_patients_with_known_hiv_status_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "tb_patients_with_known_hiv_status_pct" FLOAT  -- Tb Patients With Known Hiv Status, Pct,
  "tb_patients_with_known_hiv_status_pct_low" VARCHAR  -- Tb Patients With Known Hiv Status, Pct Low,
  "tb_patients_with_known_hiv_status_pct_high" VARCHAR  -- Tb Patients With Known Hiv Status, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_tertiary_institutions_provide_students_of_health__415b0741 (
  "year" INTEGER,
  "country" VARCHAR,
  "tertiary_institutions_provide_students_of_health_scien_c74ea9ef" VARCHAR  -- Tertiary Institutions Provide Students Of Health Sciences With Training On Ehealth
);

CREATE TABLE owid_tertiary_institutions_provide_students_of_health__6cf1b355 (
  "year" INTEGER,
  "country" VARCHAR,
  "tertiary_institutions_provide_students_of_health_scien_c74ea9ef" VARCHAR  -- Tertiary Institutions Provide Students Of Health Sciences With Training On Ehealth,
  "tertiary_institutions_provide_students_of_health_scien_02144850" VARCHAR  -- Tertiary Institutions Provide Students Of Health Sciences With Training On Ehealth Low,
  "tertiary_institutions_provide_students_of_health_scien_c270b742" VARCHAR  -- Tertiary Institutions Provide Students Of Health Sciences With Training On Ehealth High,
  "comments" VARCHAR
);

CREATE TABLE owid_tested_tb_patients_hiv_positive_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "tested_tb_patients_hiv_positive_pct" FLOAT  -- Tested Tb Patients Hiv Positive, Pct
);

CREATE TABLE owid_tested_tb_patients_hiv_positive_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "tested_tb_patients_hiv_positive_pct" FLOAT  -- Tested Tb Patients Hiv Positive, Pct,
  "tested_tb_patients_hiv_positive_pct_low" VARCHAR  -- Tested Tb Patients Hiv Positive, Pct Low,
  "tested_tb_patients_hiv_positive_pct_high" VARCHAR  -- Tested Tb Patients Hiv Positive, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_testing_and_counselling_facilities_estimated_numb_b6050ce7 (
  "year" INTEGER,
  "country" VARCHAR,
  "testing_and_counselling_facilities_estimated_number_pe_7e05163e" INTEGER  -- Testing And Counselling Facilities, Estimated Number Per 100–000 Adult Population
);

CREATE TABLE owid_testing_and_counselling_facilities_estimated_numb_f850edb5 (
  "year" INTEGER,
  "country" VARCHAR,
  "testing_and_counselling_facilities_estimated_number_pe_7e05163e" INTEGER  -- Testing And Counselling Facilities, Estimated Number Per 100–000 Adult Population,
  "testing_and_counselling_facilities_estimated_number_pe_88451502" VARCHAR  -- Testing And Counselling Facilities, Estimated Number Per 100–000 Adult Population Low,
  "testing_and_counselling_facilities_estimated_number_pe_1d9dedaa" VARCHAR  -- Testing And Counselling Facilities, Estimated Number Per 100–000 Adult Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_testing_and_counselling_facilities_reported_number_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "testing_and_counselling_facilities_reported_number" INTEGER  -- Testing And Counselling Facilities, Reported Number,
  "comments" VARCHAR
);

CREATE TABLE owid_testing_and_counselling_facilities_reported_number_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "testing_and_counselling_facilities_reported_number" INTEGER  -- Testing And Counselling Facilities, Reported Number,
  "testing_and_counselling_facilities_reported_number_low" VARCHAR  -- Testing And Counselling Facilities, Reported Number Low,
  "testing_and_counselling_facilities_reported_number_high" VARCHAR  -- Testing And Counselling Facilities, Reported Number High,
  "comments" VARCHAR
);

CREATE TABLE owid_testing_and_counselling_facilities_reporting_period_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "testing_and_counselling_facilities_reporting_period" VARCHAR  -- Testing And Counselling Facilities, Reporting Period
);

CREATE TABLE owid_testing_and_counselling_facilities_reporting_period_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "testing_and_counselling_facilities_reporting_period" VARCHAR  -- Testing And Counselling Facilities, Reporting Period,
  "testing_and_counselling_facilities_reporting_period_low" VARCHAR  -- Testing And Counselling Facilities, Reporting Period Low,
  "testing_and_counselling_facilities_reporting_period_high" VARCHAR  -- Testing And Counselling Facilities, Reporting Period High,
  "comments" VARCHAR
);

CREATE TABLE owid_the_quit_line_number_must_appear_on_cigarette_pac_1408adcd (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "the_quit_line_number_must_appear_on_cigarette_packagin_2194b139" VARCHAR  -- The Quit Line Number Must Appear On Cigarette Packaging Or Labelling
);

CREATE TABLE owid_the_quit_line_number_must_appear_on_cigarette_pac_2e591c15 (
  "year" INTEGER,
  "country" VARCHAR,
  "the_quit_line_number_must_appear_on_cigarette_packagin_2194b139" VARCHAR  -- The Quit Line Number Must Appear On Cigarette Packaging Or Labelling,
  "the_quit_line_number_must_appear_on_cigarette_packagin_28ebc275" VARCHAR  -- The Quit Line Number Must Appear On Cigarette Packaging Or Labelling Low,
  "the_quit_line_number_must_appear_on_cigarette_packagin_db78ee43" VARCHAR  -- The Quit Line Number Must Appear On Cigarette Packaging Or Labelling High,
  "comments" VARCHAR
);

CREATE TABLE owid_the_quit_line_number_must_appear_on_other_smoked__59a3fe98 (
  "year" INTEGER,
  "country" VARCHAR,
  "the_quit_line_number_must_appear_on_other_smoked_tobac_f72084c4" VARCHAR  -- The Quit Line Number Must Appear On Other Smoked Tobacco Packaging Or Labelling,
  "the_quit_line_number_must_appear_on_other_smoked_tobac_f57574bf" VARCHAR  -- The Quit Line Number Must Appear On Other Smoked Tobacco Packaging Or Labelling Low,
  "the_quit_line_number_must_appear_on_other_smoked_tobac_27031db8" VARCHAR  -- The Quit Line Number Must Appear On Other Smoked Tobacco Packaging Or Labelling High,
  "comments" VARCHAR
);

CREATE TABLE owid_the_quit_line_number_must_appear_on_other_smoked__af2bcbc5 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "the_quit_line_number_must_appear_on_other_smoked_tobac_f72084c4" VARCHAR  -- The Quit Line Number Must Appear On Other Smoked Tobacco Packaging Or Labelling
);

CREATE TABLE owid_the_quit_line_number_must_appear_on_smokeless_tob_8bf653a7 (
  "year" INTEGER,
  "country" VARCHAR,
  "the_quit_line_number_must_appear_on_smokeless_tobacco__26679221" VARCHAR  -- The Quit Line Number Must Appear On Smokeless Tobacco Packaging Or Labelling,
  "the_quit_line_number_must_appear_on_smokeless_tobacco__bd5c6660" VARCHAR  -- The Quit Line Number Must Appear On Smokeless Tobacco Packaging Or Labelling Low,
  "the_quit_line_number_must_appear_on_smokeless_tobacco__7de01934" VARCHAR  -- The Quit Line Number Must Appear On Smokeless Tobacco Packaging Or Labelling High,
  "comments" VARCHAR
);

CREATE TABLE owid_the_quit_line_number_must_appear_on_smokeless_tob_e1e24b6e (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "the_quit_line_number_must_appear_on_smokeless_tobacco__26679221" VARCHAR  -- The Quit Line Number Must Appear On Smokeless Tobacco Packaging Or Labelling
);

CREATE TABLE owid_timeframe_for_maintenance_treatment_of_opioid_dependence_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "timeframe_for_maintenance_treatment_of_opioid_dependence" VARCHAR
);

CREATE TABLE owid_timeframe_for_maintenance_treatment_of_opioid_dependence_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "timeframe_for_maintenance_treatment_of_opioid_dependence" VARCHAR,
  "timeframe_for_maintenance_treatment_of_opioid_dependence_low" VARCHAR,
  "timeframe_for_maintenance_treatment_of_opioid_dependence_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_timeframe_of_opioid_agonist_treatment_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "timeframe_of_opioid_agonist_treatment" VARCHAR
);