Global Health Observatory - World Health Organization

CREATE TABLE owid_smoking_cessation_support_is_cost_covered_in_othe_edcaed6f (
  "year" INTEGER,
  "country" VARCHAR,
  "smoking_cessation_support_is_cost_covered_in_other_settings" VARCHAR
);

CREATE TABLE owid_smoking_cessation_support_is_cost_covered_in_the__d2b26acd (
  "year" INTEGER,
  "country" VARCHAR,
  "smoking_cessation_support_is_cost_covered_in_the_community" VARCHAR,
  "smoking_cessation_support_is_cost_covered_in_the_community_low" VARCHAR,
  "smoking_cessation_support_is_cost_covered_in_the_community_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_smoking_cessation_support_is_cost_covered_in_the__f4329ce9 (
  "year" INTEGER,
  "country" VARCHAR,
  "smoking_cessation_support_is_cost_covered_in_the_community" VARCHAR
);

CREATE TABLE owid_sobriety_checkpoints (
  "year" INTEGER,
  "country" VARCHAR,
  "sobriety_checkpoints" VARCHAR,
  "sobriety_checkpoints_low" VARCHAR,
  "sobriety_checkpoints_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_social_costs_of_alcohol_use_in_millions_usd_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_social_cost_types" VARCHAR,
  "social_costs_of_alcohol_use_in_millions_usd" FLOAT
);

CREATE TABLE owid_social_costs_of_alcohol_use_in_millions_usd_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_social_cost_types" VARCHAR,
  "social_costs_of_alcohol_use_in_millions_usd" FLOAT,
  "social_costs_of_alcohol_use_in_millions_usd_low" VARCHAR,
  "social_costs_of_alcohol_use_in_millions_usd_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_social_workers_working_in_mental_health_sector_pe_27ffbb3e (
  "year" INTEGER,
  "country" VARCHAR,
  "social_workers_working_in_mental_health_sector_per_100_ff6934e1" FLOAT  -- Social Workers Working In Mental Health Sector, Per 100–000 Population,
  "social_workers_working_in_mental_health_sector_per_100_29518323" VARCHAR  -- Social Workers Working In Mental Health Sector, Per 100–000 Population Low,
  "social_workers_working_in_mental_health_sector_per_100_17289e81" VARCHAR  -- Social Workers Working In Mental Health Sector, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_social_workers_working_in_mental_health_sector_pe_433b1d15 (
  "year" INTEGER,
  "country" VARCHAR,
  "social_workers_working_in_mental_health_sector_per_100_ff6934e1" FLOAT  -- Social Workers Working In Mental Health Sector, Per 100–000 Population
);

CREATE TABLE owid_sources_of_assistive_products_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_product" VARCHAR,
  "sources_of_assistive_products" VARCHAR,
  "sources_of_assistive_products_pct" FLOAT  -- Sources Of Assistive Products, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_sources_of_assistive_products_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_product" VARCHAR,
  "sources_of_assistive_products" VARCHAR,
  "sources_of_assistive_products_pct" FLOAT  -- Sources Of Assistive Products, Pct,
  "sources_of_assistive_products_pct_low" VARCHAR  -- Sources Of Assistive Products, Pct Low,
  "sources_of_assistive_products_pct_high" VARCHAR  -- Sources Of Assistive Products, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_special_housing_services_for_alcohol_use_disorders_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "special_housing_services_for_alcohol_use_disorders" VARCHAR
);

CREATE TABLE owid_special_housing_services_for_alcohol_use_disorders_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "special_housing_services_for_alcohol_use_disorders" VARCHAR,
  "special_housing_services_for_alcohol_use_disorders_low" VARCHAR,
  "special_housing_services_for_alcohol_use_disorders_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_special_housing_services_for_drug_use_disorders_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "special_housing_services_for_drug_use_disorders" VARCHAR
);

CREATE TABLE owid_special_housing_services_for_drug_use_disorders_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "special_housing_services_for_drug_use_disorders" VARCHAR,
  "special_housing_services_for_drug_use_disorders_low" VARCHAR,
  "special_housing_services_for_drug_use_disorders_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_specialist_medical_practitioners_number_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "specialist_medical_practitioners_number" UINTEGER  -- Specialist Medical Practitioners, Number,
  "comments" VARCHAR
);

CREATE TABLE owid_specialist_medical_practitioners_number_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "specialist_medical_practitioners_number" UINTEGER  -- Specialist Medical Practitioners, Number,
  "specialist_medical_practitioners_number_low" VARCHAR  -- Specialist Medical Practitioners, Number Low,
  "specialist_medical_practitioners_number_high" VARCHAR  -- Specialist Medical Practitioners, Number High,
  "comments" VARCHAR
);

CREATE TABLE owid_specialized_treatment_facilities_for_alcohol_use__549ee8e2 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "specialized_treatment_facilities_for_alcohol_use_disorders" VARCHAR
);

CREATE TABLE owid_specialized_treatment_facilities_for_alcohol_use__9b58a88f (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "specialized_treatment_facilities_for_alcohol_use_disorders" VARCHAR,
  "specialized_treatment_facilities_for_alcohol_use_disorders_low" VARCHAR,
  "specialized_treatment_facilities_for_alcohol_use_disorders_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_specialized_treatment_facilities_for_drug_use_disorders_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "specialized_treatment_facilities_for_drug_use_disorders" VARCHAR
);

CREATE TABLE owid_specialized_treatment_facilities_for_drug_use_disorders_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "specialized_treatment_facilities_for_drug_use_disorders" VARCHAR,
  "specialized_treatment_facilities_for_drug_use_disorders_low" VARCHAR,
  "specialized_treatment_facilities_for_drug_use_disorders_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_specialized_treatment_facilities_for_substance_us_71fcaf09 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "specialized_treatment_facilities_for_substance_use_disorders" VARCHAR
);

CREATE TABLE owid_specialized_treatment_facilities_for_substance_us_9e1b2b25 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "specialized_treatment_facilities_for_substance_use_disorders" VARCHAR,
  "specialized_treatment_facilities_for_substance_use_dis_6144da9f" VARCHAR  -- Specialized Treatment Facilities For Substance Use Disorders Low,
  "specialized_treatment_facilities_for_substance_use_dis_657e955a" VARCHAR  -- Specialized Treatment Facilities For Substance Use Disorders High,
  "comments" VARCHAR
);

CREATE TABLE owid_specialized_treatment_services_for_drug_use_disod_0e83a16a (
  "year" INTEGER,
  "country" VARCHAR,
  "specialized_treatment_services_for_drug_use_disoders_a_eb95bb05" VARCHAR  -- Specialized Treatment Services For Drug Use Disoders And Hiv Aids,
  "specialized_treatment_services_for_drug_use_disoders_a_a5c6c4aa" VARCHAR  -- Specialized Treatment Services For Drug Use Disoders And Hiv Aids Low,
  "specialized_treatment_services_for_drug_use_disoders_a_fa34cc3c" VARCHAR  -- Specialized Treatment Services For Drug Use Disoders And Hiv Aids High,
  "comments" VARCHAR
);

CREATE TABLE owid_specialized_treatment_services_for_drug_use_disod_811974cd (
  "year" INTEGER,
  "country" VARCHAR,
  "specialized_treatment_services_for_drug_use_disoders_a_eb95bb05" VARCHAR  -- Specialized Treatment Services For Drug Use Disoders And Hiv Aids
);

CREATE TABLE owid_specialized_treatment_services_for_substance_use__1e401da6 (
  "year" INTEGER,
  "country" VARCHAR,
  "specialized_treatment_services_for_substance_use_disor_47af928f" VARCHAR  -- Specialized Treatment Services For Substance Use Disorders And Tb,
  "specialized_treatment_services_for_substance_use_disor_4f482f8d" VARCHAR  -- Specialized Treatment Services For Substance Use Disorders And Tb Low,
  "specialized_treatment_services_for_substance_use_disor_f0b8ea58" VARCHAR  -- Specialized Treatment Services For Substance Use Disorders And Tb High,
  "comments" VARCHAR
);