Global Health Observatory - World Health Organization

CREATE TABLE owid_existence_of_evidence_based_national_guidelines_p_5a7f54cc (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_evidence_based_national_guidelines_protoc_9d96b76e" VARCHAR  -- Existence Of Evidence Based National Guidelines Protocols Standards For The Management Of Chronic Respiratory Diseases
);

CREATE TABLE owid_existence_of_evidence_based_national_guidelines_p_865ad2bf (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_evidence_based_national_guidelines_protoc_6ba620b3" VARCHAR  -- Existence Of Evidence Based National Guidelines Protocols Standards For The Management Of Diabetes,
  "existence_of_evidence_based_national_guidelines_protoc_08edcb99" VARCHAR  -- Existence Of Evidence Based National Guidelines Protocols Standards For The Management Of Diabetes Low,
  "existence_of_evidence_based_national_guidelines_protoc_29f39692" VARCHAR  -- Existence Of Evidence Based National Guidelines Protocols Standards For The Management Of Diabetes High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_evidence_based_national_guidelines_p_a0fc5ac4 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_evidence_based_national_guidelines_protoc_ae449d00" VARCHAR  -- Existence Of Evidence Based National Guidelines Protocols Standards For The Management Of Major Ncds Through A Primary Care Approach,
  "existence_of_evidence_based_national_guidelines_protoc_24a5f2c0" VARCHAR  -- Existence Of Evidence Based National Guidelines Protocols Standards For The Management Of Major Ncds Through A Primary Care Approach Low,
  "existence_of_evidence_based_national_guidelines_protoc_301d6876" VARCHAR  -- Existence Of Evidence Based National Guidelines Protocols Standards For The Management Of Major Ncds Through A Primary Care Approach High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_evidence_based_national_guidelines_p_a21723c1 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_evidence_based_national_guidelines_protoc_5112216c" VARCHAR  -- Existence Of Evidence Based National Guidelines Protocols Standards For The Management Of Cardiovascular Diseases
);

CREATE TABLE owid_existence_of_evidence_based_national_guidelines_p_cb8dd076 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_evidence_based_national_guidelines_protoc_768b4bd8" VARCHAR  -- Existence Of Evidence Based National Guidelines Protocols Standards For The Management Of Overweight Obesity
);

CREATE TABLE owid_existence_of_evidence_based_national_guidelines_p_cd6cafc9 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_evidence_based_national_guidelines_protoc_41b1f67e" VARCHAR  -- Existence Of Evidence Based National Guidelines Protocols Standards For The Management Of Alcohol Use Disorders
);

CREATE TABLE owid_existence_of_evidence_based_national_guidelines_p_dffae44e (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_evidence_based_national_guidelines_protoc_5112216c" VARCHAR  -- Existence Of Evidence Based National Guidelines Protocols Standards For The Management Of Cardiovascular Diseases,
  "existence_of_evidence_based_national_guidelines_protoc_ec6d8780" VARCHAR  -- Existence Of Evidence Based National Guidelines Protocols Standards For The Management Of Cardiovascular Diseases Low,
  "existence_of_evidence_based_national_guidelines_protoc_7ab4473e" VARCHAR  -- Existence Of Evidence Based National Guidelines Protocols Standards For The Management Of Cardiovascular Diseases High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_evidence_based_national_guidelines_p_ebf80ed9 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_evidence_based_national_guidelines_protoc_ae449d00" VARCHAR  -- Existence Of Evidence Based National Guidelines Protocols Standards For The Management Of Major Ncds Through A Primary Care Approach
);

CREATE TABLE owid_existence_of_evidence_based_national_guidelines_p_ed6ec6f2 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_evidence_based_national_guidelines_protoc_768b4bd8" VARCHAR  -- Existence Of Evidence Based National Guidelines Protocols Standards For The Management Of Overweight Obesity,
  "existence_of_evidence_based_national_guidelines_protoc_19013557" VARCHAR  -- Existence Of Evidence Based National Guidelines Protocols Standards For The Management Of Overweight Obesity Low,
  "existence_of_evidence_based_national_guidelines_protoc_21b58ad9" VARCHAR  -- Existence Of Evidence Based National Guidelines Protocols Standards For The Management Of Overweight Obesity High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_financial_benefits_social_protection_20f40f43 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_financial_benefits_social_protection_for__f7a863b2" VARCHAR  -- Existence Of Financial Benefits Social Protection For Dementia Carers
);

CREATE TABLE owid_existence_of_financial_benefits_social_protection_5f8f6f5d (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_financial_benefits_social_protection_for__f7a863b2" VARCHAR  -- Existence Of Financial Benefits Social Protection For Dementia Carers,
  "existence_of_financial_benefits_social_protection_for__b30a7a8b" VARCHAR  -- Existence Of Financial Benefits Social Protection For Dementia Carers Low,
  "existence_of_financial_benefits_social_protection_for__2a781dc8" VARCHAR  -- Existence Of Financial Benefits Social Protection For Dementia Carers High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_financial_mechanisms_for_assistive_t_ded81b0a (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_subquestion" VARCHAR,
  "comments" VARCHAR,
  "existence_of_financial_mechanisms_for_assistive_technology" VARCHAR
);

CREATE TABLE owid_existence_of_financial_mechanisms_for_assistive_t_f3a02572 (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_subquestion" VARCHAR,
  "existence_of_financial_mechanisms_for_assistive_technology" VARCHAR,
  "existence_of_financial_mechanisms_for_assistive_technology_low" VARCHAR,
  "existence_of_financial_mechanisms_for_assistive_technology_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_implementation_plan_for_dementia_car_76f955cc (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_implementation_plan_for_dementia_carer_su_71c46afc" VARCHAR  -- Existence Of Implementation Plan For Dementia Carer Support Services
);

CREATE TABLE owid_existence_of_implementation_plan_for_dementia_car_940dbba8 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_implementation_plan_for_dementia_carer_su_71c46afc" VARCHAR  -- Existence Of Implementation Plan For Dementia Carer Support Services,
  "existence_of_implementation_plan_for_dementia_carer_su_26370233" VARCHAR  -- Existence Of Implementation Plan For Dementia Carer Support Services Low,
  "existence_of_implementation_plan_for_dementia_carer_su_4fe8cb74" VARCHAR  -- Existence Of Implementation Plan For Dementia Carer Support Services High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_information_on_legal_rights_for_deme_59e3ee8a (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_information_on_legal_rights_for_dementia_carers" VARCHAR
);

CREATE TABLE owid_existence_of_information_on_legal_rights_for_deme_98babe09 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_information_on_legal_rights_for_dementia_carers" VARCHAR,
  "existence_of_information_on_legal_rights_for_dementia__c5b9fabc" VARCHAR  -- Existence Of Information On Legal Rights For Dementia Carers Low,
  "existence_of_information_on_legal_rights_for_dementia__12b65215" VARCHAR  -- Existence Of Information On Legal Rights For Dementia Carers High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_initiatives_collaborations_on_assist_8fa4d8da (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_subquestion" VARCHAR,
  "existence_of_initiatives_collaborations_on_assistive_technology" VARCHAR,
  "existence_of_initiatives_collaborations_on_assistive_t_411de45f" VARCHAR  -- Existence Of Initiatives Collaborations On Assistive Technology Low,
  "existence_of_initiatives_collaborations_on_assistive_t_f28c06e4" VARCHAR  -- Existence Of Initiatives Collaborations On Assistive Technology High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_initiatives_collaborations_on_assist_e3c5d572 (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_subquestion" VARCHAR,
  "existence_of_initiatives_collaborations_on_assistive_technology" VARCHAR
);

CREATE TABLE owid_existence_of_legislation_for_advanced_care_direct_2cbc2a8b (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_legislation_for_advanced_care_directives__96a3cb0d" VARCHAR  -- Existence Of Legislation For Advanced Care Directives For People With Dementia
);

CREATE TABLE owid_existence_of_legislation_for_advanced_care_direct_ff225a65 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_legislation_for_advanced_care_directives__96a3cb0d" VARCHAR  -- Existence Of Legislation For Advanced Care Directives For People With Dementia,
  "existence_of_legislation_for_advanced_care_directives__8d9e0236" VARCHAR  -- Existence Of Legislation For Advanced Care Directives For People With Dementia Low,
  "existence_of_legislation_for_advanced_care_directives__f23f9d24" VARCHAR  -- Existence Of Legislation For Advanced Care Directives For People With Dementia High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_legislation_for_supported_decision_m_41774ff7 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_legislation_for_supported_decision_making_73b8d183" VARCHAR  -- Existence Of Legislation For Supported Decision Making For People With Dementia,
  "existence_of_legislation_for_supported_decision_making_b5124dfe" VARCHAR  -- Existence Of Legislation For Supported Decision Making For People With Dementia Low,
  "existence_of_legislation_for_supported_decision_making_c60ced1d" VARCHAR  -- Existence Of Legislation For Supported Decision Making For People With Dementia High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_legislation_for_supported_decision_m_aaeb8655 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_legislation_for_supported_decision_making_73b8d183" VARCHAR  -- Existence Of Legislation For Supported Decision Making For People With Dementia
);

CREATE TABLE owid_existence_of_legislation_on_access_to_assistive_t_1f42fd98 (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_subquestion" VARCHAR,
  "comments" VARCHAR,
  "existence_of_legislation_on_access_to_assistive_technology" VARCHAR
);

CREATE TABLE owid_existence_of_legislation_on_access_to_assistive_t_ed26eacd (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_subquestion" VARCHAR,
  "existence_of_legislation_on_access_to_assistive_technology" VARCHAR,
  "existence_of_legislation_on_access_to_assistive_technology_low" VARCHAR,
  "existence_of_legislation_on_access_to_assistive_technology_high" VARCHAR,
  "comments" VARCHAR
);