Global Health Observatory - World Health Organization

CREATE TABLE owid_existence_of_dementia_carer_support_services_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_carer_support_services" VARCHAR,
  "existence_of_dementia_carer_support_services_low" VARCHAR,
  "existence_of_dementia_carer_support_services_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_dementia_friendly_initiative_for_ass_566560db (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_friendly_initiative_for_assistan_55db8a7d" VARCHAR  -- Existence Of Dementia Friendly Initiative For Assistance With Home Modification,
  "existence_of_dementia_friendly_initiative_for_assistan_5054d91c" VARCHAR  -- Existence Of Dementia Friendly Initiative For Assistance With Home Modification Low,
  "existence_of_dementia_friendly_initiative_for_assistan_2861b817" VARCHAR  -- Existence Of Dementia Friendly Initiative For Assistance With Home Modification High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_dementia_friendly_initiative_for_ass_ef79bcc3 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_friendly_initiative_for_assistan_55db8a7d" VARCHAR  -- Existence Of Dementia Friendly Initiative For Assistance With Home Modification
);

CREATE TABLE owid_existence_of_dementia_friendly_initiative_support_3b87dfdc (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_friendly_initiative_supporting_c_7612ac55" VARCHAR  -- Existence Of Dementia Friendly Initiative Supporting Community Places For Older People
);

CREATE TABLE owid_existence_of_dementia_friendly_initiative_support_47aaad36 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_friendly_initiative_supporting_s_b81d0ea6" VARCHAR  -- Existence Of Dementia Friendly Initiative Supporting Social Opportunities,
  "existence_of_dementia_friendly_initiative_supporting_s_3e92d9f6" VARCHAR  -- Existence Of Dementia Friendly Initiative Supporting Social Opportunities Low,
  "existence_of_dementia_friendly_initiative_supporting_s_21256938" VARCHAR  -- Existence Of Dementia Friendly Initiative Supporting Social Opportunities High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_dementia_friendly_initiative_support_4a37396c (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_friendly_initiative_supporting_s_b81d0ea6" VARCHAR  -- Existence Of Dementia Friendly Initiative Supporting Social Opportunities
);

CREATE TABLE owid_existence_of_dementia_friendly_initiative_support_a0b51a2e (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_friendly_initiative_supporting_c_7612ac55" VARCHAR  -- Existence Of Dementia Friendly Initiative Supporting Community Places For Older People,
  "existence_of_dementia_friendly_initiative_supporting_c_0dd975bf" VARCHAR  -- Existence Of Dementia Friendly Initiative Supporting Community Places For Older People Low,
  "existence_of_dementia_friendly_initiative_supporting_c_c1fd9afc" VARCHAR  -- Existence Of Dementia Friendly Initiative Supporting Community Places For Older People High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_dementia_friendly_initiative_to_impr_299d0549 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_friendly_initiative_to_improve_a_dbf96055" VARCHAR  -- Existence Of Dementia Friendly Initiative To Improve Accessibility Of Public Transportation,
  "existence_of_dementia_friendly_initiative_to_improve_a_8717cce0" VARCHAR  -- Existence Of Dementia Friendly Initiative To Improve Accessibility Of Public Transportation Low,
  "existence_of_dementia_friendly_initiative_to_improve_a_0caf1fe2" VARCHAR  -- Existence Of Dementia Friendly Initiative To Improve Accessibility Of Public Transportation High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_dementia_friendly_initiative_to_impr_93e1d759 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_friendly_initiative_to_improve_a_6e0579be" VARCHAR  -- Existence Of Dementia Friendly Initiative To Improve Accessibility Of Public Spaces
);

CREATE TABLE owid_existence_of_dementia_friendly_initiative_to_impr_c4ba418a (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_friendly_initiative_to_improve_a_dbf96055" VARCHAR  -- Existence Of Dementia Friendly Initiative To Improve Accessibility Of Public Transportation
);

CREATE TABLE owid_existence_of_dementia_friendly_initiative_to_impr_f7a90231 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_friendly_initiative_to_improve_a_6e0579be" VARCHAR  -- Existence Of Dementia Friendly Initiative To Improve Accessibility Of Public Spaces,
  "existence_of_dementia_friendly_initiative_to_improve_a_5b55638d" VARCHAR  -- Existence Of Dementia Friendly Initiative To Improve Accessibility Of Public Spaces Low,
  "existence_of_dementia_friendly_initiative_to_improve_a_e4d6d5d8" VARCHAR  -- Existence Of Dementia Friendly Initiative To Improve Accessibility Of Public Spaces High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_dementia_friendly_initiative_with_as_06b42ab0 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_friendly_initiative_with_assisti_60df4bb9" VARCHAR  -- Existence Of Dementia Friendly Initiative With Assistive Technology For Loss Of Capacity,
  "existence_of_dementia_friendly_initiative_with_assisti_442fcdeb" VARCHAR  -- Existence Of Dementia Friendly Initiative With Assistive Technology For Loss Of Capacity Low,
  "existence_of_dementia_friendly_initiative_with_assisti_0af1cff0" VARCHAR  -- Existence Of Dementia Friendly Initiative With Assistive Technology For Loss Of Capacity High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_dementia_friendly_initiative_with_as_a5739fd0 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_friendly_initiative_with_assisti_60df4bb9" VARCHAR  -- Existence Of Dementia Friendly Initiative With Assistive Technology For Loss Of Capacity
);

CREATE TABLE owid_existence_of_dementia_legislation_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_legislation" VARCHAR
);

CREATE TABLE owid_existence_of_dementia_legislation_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_legislation" VARCHAR,
  "existence_of_dementia_legislation_low" VARCHAR,
  "existence_of_dementia_legislation_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_dementia_national_nongovernmental_or_17dd7eef (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_national_nongovernmental_organization" VARCHAR,
  "existence_of_dementia_national_nongovernmental_organization_low" VARCHAR,
  "existence_of_dementia_national_nongovernmental_organiz_2c146c9a" VARCHAR  -- Existence Of Dementia National Nongovernmental Organization High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_dementia_national_nongovernmental_or_ce000580 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_national_nongovernmental_organization" VARCHAR
);

CREATE TABLE owid_existence_of_dementia_national_plan_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_national_plan" VARCHAR
);

CREATE TABLE owid_existence_of_dementia_national_plan_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_national_plan" VARCHAR,
  "existence_of_dementia_national_plan_low" VARCHAR,
  "existence_of_dementia_national_plan_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_dementia_representative_in_ministry_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_representative_in_ministry" VARCHAR
);

CREATE TABLE owid_existence_of_dementia_representative_in_ministry_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_representative_in_ministry" VARCHAR,
  "existence_of_dementia_representative_in_ministry_low" VARCHAR,
  "existence_of_dementia_representative_in_ministry_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_dementia_standards_guidelines_protocols_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_standards_guidelines_protocols" VARCHAR  -- Existence Of Dementia Standards, Guidelines, Protocols
);

CREATE TABLE owid_existence_of_dementia_standards_guidelines_protocols_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_standards_guidelines_protocols" VARCHAR  -- Existence Of Dementia Standards, Guidelines, Protocols,
  "existence_of_dementia_standards_guidelines_protocols_low" VARCHAR  -- Existence Of Dementia Standards, Guidelines, Protocols Low,
  "existence_of_dementia_standards_guidelines_protocols_high" VARCHAR  -- Existence Of Dementia Standards, Guidelines, Protocols High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_dementia_sub_national_plan_s_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_sub_national_plan_s" VARCHAR  -- Existence Of Dementia Sub National Plan, S
);

CREATE TABLE owid_existence_of_dementia_sub_national_plan_s_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_dementia_sub_national_plan_s" VARCHAR  -- Existence Of Dementia Sub National Plan, S,
  "existence_of_dementia_sub_national_plan_s_low" VARCHAR  -- Existence Of Dementia Sub National Plan, S Low,
  "existence_of_dementia_sub_national_plan_s_high" VARCHAR  -- Existence Of Dementia Sub National Plan, S High,
  "comments" VARCHAR
);