Global Health Observatory - World Health Organization

CREATE TABLE owid_availability_of_dementia_diagnostic_rate_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_dementia_diagnostic_rate" VARCHAR,
  "availability_of_dementia_diagnostic_rate_low" VARCHAR,
  "availability_of_dementia_diagnostic_rate_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_dementia_friendly_initiatives_tha_353e7fde (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_dementia_friendly_initiatives_that_imp_83dbf206" VARCHAR  -- Availability Of Dementia Friendly Initiatives That Improve Accessibility,
  "availability_of_dementia_friendly_initiatives_that_imp_6e2af2d2" VARCHAR  -- Availability Of Dementia Friendly Initiatives That Improve Accessibility Low,
  "availability_of_dementia_friendly_initiatives_that_imp_793c114f" VARCHAR  -- Availability Of Dementia Friendly Initiatives That Improve Accessibility High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_dementia_friendly_initiatives_tha_6843490b (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_dementia_friendly_initiatives_that_imp_83dbf206" VARCHAR  -- Availability Of Dementia Friendly Initiatives That Improve Accessibility
);

CREATE TABLE owid_availability_of_diagnostic_services_in_community__0451a2df (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_diagnostic_services_in_community_for_dementia" VARCHAR,
  "availability_of_diagnostic_services_in_community_for_d_4ec9f9ac" VARCHAR  -- Availability Of Diagnostic Services In Community For Dementia Low,
  "availability_of_diagnostic_services_in_community_for_d_bb1905c1" VARCHAR  -- Availability Of Diagnostic Services In Community For Dementia High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_diagnostic_services_in_community__f4bf5533 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_diagnostic_services_in_community_for_dementia" VARCHAR
);

CREATE TABLE owid_availability_of_education_training_for_assistive__0e4c3bb3 (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_subquestion" VARCHAR,
  "availability_of_education_training_for_assistive_technology" VARCHAR,
  "availability_of_education_training_for_assistive_technology_low" VARCHAR,
  "availability_of_education_training_for_assistive_techn_2b20f923" VARCHAR  -- Availability Of Education Training For Assistive Technology High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_education_training_for_assistive__9ba79ef8 (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_subquestion" VARCHAR,
  "availability_of_education_training_for_assistive_technology" VARCHAR
);

CREATE TABLE owid_availability_of_estimates_on_impoverishment_due_t_7f124270 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_estimates_on_impoverishment_due_to_out_bc8a7458" INTEGER  -- Availability Of Estimates On Impoverishment Due To Out Of Pocket Health Expenditures,
  "availability_of_estimates_on_impoverishment_due_to_out_e7b06669" VARCHAR  -- Availability Of Estimates On Impoverishment Due To Out Of Pocket Health Expenditures Low,
  "availability_of_estimates_on_impoverishment_due_to_out_0afca33e" VARCHAR  -- Availability Of Estimates On Impoverishment Due To Out Of Pocket Health Expenditures High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_estimates_on_impoverishment_due_t_c63915d6 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_estimates_on_impoverishment_due_to_out_bc8a7458" INTEGER  -- Availability Of Estimates On Impoverishment Due To Out Of Pocket Health Expenditures
);

CREATE TABLE owid_availability_of_estimates_on_large_health_expendi_78787e6c (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_estimates_on_large_health_expenditures_87b40e50" INTEGER  -- Availability Of Estimates On Large Health Expenditures As A Share Of Total Expenditure Or Income
);

CREATE TABLE owid_availability_of_estimates_on_large_health_expendi_9aa34b86 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_estimates_on_large_health_expenditures_87b40e50" INTEGER  -- Availability Of Estimates On Large Health Expenditures As A Share Of Total Expenditure Or Income,
  "availability_of_estimates_on_large_health_expenditures_3e041805" VARCHAR  -- Availability Of Estimates On Large Health Expenditures As A Share Of Total Expenditure Or Income Low,
  "availability_of_estimates_on_large_health_expenditures_8fb03886" VARCHAR  -- Availability Of Estimates On Large Health Expenditures As A Share Of Total Expenditure Or Income High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_funding_for_dementia_national_plan_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_funding_for_dementia_national_plan" VARCHAR
);

CREATE TABLE owid_availability_of_funding_for_dementia_national_plan_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_funding_for_dementia_national_plan" VARCHAR,
  "availability_of_funding_for_dementia_national_plan_low" VARCHAR,
  "availability_of_funding_for_dementia_national_plan_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_funding_for_dementia_specific_res_05bb302a (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_funding_for_dementia_specific_research_b34204d3" VARCHAR  -- Availability Of Funding For Dementia Specific Research Plan Programme,
  "availability_of_funding_for_dementia_specific_research_b0e84a94" VARCHAR  -- Availability Of Funding For Dementia Specific Research Plan Programme Low,
  "availability_of_funding_for_dementia_specific_research_0be39f23" VARCHAR  -- Availability Of Funding For Dementia Specific Research Plan Programme High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_funding_for_dementia_specific_res_3e105921 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_funding_for_dementia_specific_research_b34204d3" VARCHAR  -- Availability Of Funding For Dementia Specific Research Plan Programme
);

CREATE TABLE owid_availability_of_funding_for_national_road_safety__57e37b48 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_funding_for_national_road_safety_strategy" VARCHAR,
  "availability_of_funding_for_national_road_safety_strategy_low" VARCHAR,
  "availability_of_funding_for_national_road_safety_strategy_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_funding_for_national_road_safety__96492460 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_funding_for_national_road_safety_strategy" VARCHAR
);

CREATE TABLE owid_availability_of_generic_anti_dementia_medication_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_generic_anti_dementia_medication" VARCHAR
);

CREATE TABLE owid_availability_of_generic_anti_dementia_medication_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_generic_anti_dementia_medication" VARCHAR,
  "availability_of_generic_anti_dementia_medication_low" VARCHAR,
  "availability_of_generic_anti_dementia_medication_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_government_registered_services_fo_70c55d73 (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_subquestion" VARCHAR,
  "availability_of_government_registered_services_for_ass_149b8d0c" VARCHAR  -- Availability Of Government Registered Services For Assistive Technology
);

CREATE TABLE owid_availability_of_government_registered_services_fo_a57212b6 (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_subquestion" VARCHAR,
  "availability_of_government_registered_services_for_ass_149b8d0c" VARCHAR  -- Availability Of Government Registered Services For Assistive Technology,
  "availability_of_government_registered_services_for_ass_d495f4b5" VARCHAR  -- Availability Of Government Registered Services For Assistive Technology Low,
  "availability_of_government_registered_services_for_ass_874fee08" VARCHAR  -- Availability Of Government Registered Services For Assistive Technology High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_investigational_pharmaceutical_tr_245a732d (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_investigational_pharmaceutical_trials__cd43a7ec" VARCHAR  -- Availability Of Investigational Pharmaceutical Trials For Dementia
);

CREATE TABLE owid_availability_of_investigational_pharmaceutical_tr_513f805f (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_investigational_pharmaceutical_trials__cd43a7ec" VARCHAR  -- Availability Of Investigational Pharmaceutical Trials For Dementia,
  "availability_of_investigational_pharmaceutical_trials__9f4bc181" VARCHAR  -- Availability Of Investigational Pharmaceutical Trials For Dementia Low,
  "availability_of_investigational_pharmaceutical_trials__f3a71015" VARCHAR  -- Availability Of Investigational Pharmaceutical Trials For Dementia High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_mechanisms_to_coordinate_dementia_47f22b17 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_mechanisms_to_coordinate_dementia_care_2a5c86e6" VARCHAR  -- Availability Of Mechanisms To Coordinate Dementia Care Across Sectors,
  "availability_of_mechanisms_to_coordinate_dementia_care_b2b1c3fa" VARCHAR  -- Availability Of Mechanisms To Coordinate Dementia Care Across Sectors Low,
  "availability_of_mechanisms_to_coordinate_dementia_care_47751c12" VARCHAR  -- Availability Of Mechanisms To Coordinate Dementia Care Across Sectors High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_mechanisms_to_coordinate_dementia_7096d937 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_mechanisms_to_coordinate_dementia_care_2a5c86e6" VARCHAR  -- Availability Of Mechanisms To Coordinate Dementia Care Across Sectors
);