Global Health Observatory - World Health Organization

CREATE TABLE owid_mental_health_day_treatment_facilities_per_100_00_478e0005 (
  "year" INTEGER,
  "country" VARCHAR,
  "mental_health_day_treatment_facilities_per_100_000_population" FLOAT  -- Mental Health Day Treatment Facilities, Per 100–000 Population,
  "mental_health_day_treatment_facilities_per_100_000_pop_05ebebfa" VARCHAR  -- Mental Health Day Treatment Facilities, Per 100–000 Population Low,
  "mental_health_day_treatment_facilities_per_100_000_pop_44f2f81d" VARCHAR  -- Mental Health Day Treatment Facilities, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_mental_health_outpatient_facilities_per_100_000_p_12b5fa07 (
  "year" INTEGER,
  "country" VARCHAR,
  "mental_health_outpatient_facilities_per_100_000_population" FLOAT  -- Mental Health Outpatient Facilities, Per 100–000 Population
);

CREATE TABLE owid_mental_health_outpatient_facilities_per_100_000_p_655ab8a7 (
  "year" INTEGER,
  "country" VARCHAR,
  "mental_health_outpatient_facilities_per_100_000_population" FLOAT  -- Mental Health Outpatient Facilities, Per 100–000 Population,
  "mental_health_outpatient_facilities_per_100_000_population_low" VARCHAR  -- Mental Health Outpatient Facilities, Per 100–000 Population Low,
  "mental_health_outpatient_facilities_per_100_000_population_high" VARCHAR  -- Mental Health Outpatient Facilities, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_mental_health_plan_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "mental_health_plan" VARCHAR
);

CREATE TABLE owid_mental_health_plan_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "mental_health_plan" VARCHAR,
  "mental_health_plan_low" VARCHAR,
  "mental_health_plan_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_mental_health_policy_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "mental_health_policy" VARCHAR
);

CREATE TABLE owid_mental_health_policy_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "mental_health_policy" VARCHAR,
  "mental_health_policy_low" VARCHAR,
  "mental_health_policy_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_mental_health_units_in_general_hospitals_admissio_5183fd7a (
  "year" INTEGER,
  "country" VARCHAR,
  "mental_health_units_in_general_hospitals_admissions_pe_b5e73fac" FLOAT  -- Mental Health Units In General Hospitals Admissions, Per 100–000 Population,
  "mental_health_units_in_general_hospitals_admissions_pe_220a7d63" VARCHAR  -- Mental Health Units In General Hospitals Admissions, Per 100–000 Population Low,
  "mental_health_units_in_general_hospitals_admissions_pe_8da9cd36" VARCHAR  -- Mental Health Units In General Hospitals Admissions, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_mental_health_units_in_general_hospitals_admissio_9e57422d (
  "year" INTEGER,
  "country" VARCHAR,
  "mental_health_units_in_general_hospitals_admissions_pe_b5e73fac" FLOAT  -- Mental Health Units In General Hospitals Admissions, Per 100–000 Population
);

CREATE TABLE owid_mental_health_units_in_general_hospitals_per_100__4424c324 (
  "year" INTEGER,
  "country" VARCHAR,
  "mental_health_units_in_general_hospitals_per_100_000_population" FLOAT  -- Mental Health Units In General Hospitals, Per 100–000 Population
);

CREATE TABLE owid_mental_health_units_in_general_hospitals_per_100__498e98d6 (
  "year" INTEGER,
  "country" VARCHAR,
  "mental_health_units_in_general_hospitals_per_100_000_population" FLOAT  -- Mental Health Units In General Hospitals, Per 100–000 Population,
  "mental_health_units_in_general_hospitals_per_100_000_p_beb6afb4" VARCHAR  -- Mental Health Units In General Hospitals, Per 100–000 Population Low,
  "mental_health_units_in_general_hospitals_per_100_000_p_1410b797" VARCHAR  -- Mental Health Units In General Hospitals, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_mental_hospital_admissions_per_100_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "mental_hospital_admissions_per_100_000_population" FLOAT  -- Mental Hospital Admissions, Per 100–000 Population
);

CREATE TABLE owid_mental_hospital_admissions_per_100_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "mental_hospital_admissions_per_100_000_population" FLOAT  -- Mental Hospital Admissions, Per 100–000 Population,
  "mental_hospital_admissions_per_100_000_population_low" VARCHAR  -- Mental Hospital Admissions, Per 100–000 Population Low,
  "mental_hospital_admissions_per_100_000_population_high" VARCHAR  -- Mental Hospital Admissions, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_mental_hospitals_per_100_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "mental_hospitals_per_100_000_population" FLOAT  -- Mental Hospitals, Per 100–000 Population
);

CREATE TABLE owid_mental_hospitals_per_100_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "mental_hospitals_per_100_000_population" FLOAT  -- Mental Hospitals, Per 100–000 Population,
  "mental_hospitals_per_100_000_population_low" VARCHAR  -- Mental Hospitals, Per 100–000 Population Low,
  "mental_hospitals_per_100_000_population_high" VARCHAR  -- Mental Hospitals, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_methadone_formulation_used_for_the_treatment_of_o_c9f77792 (
  "year" INTEGER,
  "country" VARCHAR,
  "methadone_formulation_used_for_the_treatment_of_opiod__27a3e7a0" VARCHAR  -- Methadone Formulation Used For The Treatment Of Opiod Dependence
);

CREATE TABLE owid_methadone_formulation_used_for_the_treatment_of_o_e829e0c9 (
  "year" INTEGER,
  "country" VARCHAR,
  "methadone_formulation_used_for_the_treatment_of_opiod__27a3e7a0" VARCHAR  -- Methadone Formulation Used For The Treatment Of Opiod Dependence,
  "methadone_formulation_used_for_the_treatment_of_opiod__a60b789e" VARCHAR  -- Methadone Formulation Used For The Treatment Of Opiod Dependence Low,
  "methadone_formulation_used_for_the_treatment_of_opiod__a2af4c45" VARCHAR  -- Methadone Formulation Used For The Treatment Of Opiod Dependence High,
  "comments" VARCHAR
);

CREATE TABLE owid_methadone_provision_in_clinical_and_community_bas_2372611a (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_public_private_settings" VARCHAR,
  "methadone_provision_in_clinical_and_community_based_settings" VARCHAR,
  "methadone_provision_in_clinical_and_community_based_se_ff4a1e1b" VARCHAR  -- Methadone Provision In Clinical And Community Based Settings Low,
  "methadone_provision_in_clinical_and_community_based_se_723c6566" VARCHAR  -- Methadone Provision In Clinical And Community Based Settings High,
  "comments" VARCHAR
);

CREATE TABLE owid_methadone_provision_in_clinical_and_community_bas_43cb29f9 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_public_private_settings" VARCHAR,
  "methadone_provision_in_clinical_and_community_based_settings" VARCHAR
);

CREATE TABLE owid_methadone_used_for_detoxification_or_maintenance_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "methadone_used_for_detoxification_or_maintenance" VARCHAR
);

CREATE TABLE owid_methadone_used_for_detoxification_or_maintenance_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "methadone_used_for_detoxification_or_maintenance" VARCHAR,
  "methadone_used_for_detoxification_or_maintenance_low" VARCHAR,
  "methadone_used_for_detoxification_or_maintenance_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_methadone_used_for_the_treatment_of_opioid_dependence_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "methadone_used_for_the_treatment_of_opioid_dependence" VARCHAR
);

CREATE TABLE owid_methadone_used_for_the_treatment_of_opioid_dependence_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "methadone_used_for_the_treatment_of_opioid_dependence" VARCHAR,
  "methadone_used_for_the_treatment_of_opioid_dependence_low" VARCHAR,
  "methadone_used_for_the_treatment_of_opioid_dependence_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_met_need_of_assistive_products_as_proportion_of_need_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "residence_area_type" VARCHAR,
  "assistive_technology_product" VARCHAR,
  "met_need_of_assistive_products_as_proportion_of_need_pct" FLOAT  -- Met Need Of Assistive Products As Proportion Of Need, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_met_need_of_assistive_products_as_proportion_of_need_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "residence_area_type" VARCHAR,
  "assistive_technology_product" VARCHAR,
  "met_need_of_assistive_products_as_proportion_of_need_pct" FLOAT  -- Met Need Of Assistive Products As Proportion Of Need, Pct,
  "met_need_of_assistive_products_as_proportion_of_need_pct_low" VARCHAR  -- Met Need Of Assistive Products As Proportion Of Need, Pct Low,
  "met_need_of_assistive_products_as_proportion_of_need_pct_high" VARCHAR  -- Met Need Of Assistive Products As Proportion Of Need, Pct High,
  "comments" VARCHAR
);