Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_existence_of_price_subsidies_for_healthy_foods_1 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_price_subsidies_for_healthy_foods" VARCHAR
);
CREATE TABLE owid_existence_of_price_subsidies_for_healthy_foods_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_price_subsidies_for_healthy_foods" VARCHAR,
"existence_of_price_subsidies_for_healthy_foods_low" VARCHAR,
"existence_of_price_subsidies_for_healthy_foods_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_psycho_social_supports_for_dementia_carers_1 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_psycho_social_supports_for_dementia_carers" VARCHAR
);
CREATE TABLE owid_existence_of_psycho_social_supports_for_dementia_carers_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_psycho_social_supports_for_dementia_carers" VARCHAR,
"existence_of_psycho_social_supports_for_dementia_carers_low" VARCHAR,
"existence_of_psycho_social_supports_for_dementia_carers_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_regulations_standards_guidelines_pro_a72022d0 (
"year" INTEGER,
"country" VARCHAR,
"assistive_technology_subquestion" VARCHAR,
"comments" VARCHAR,
"existence_of_regulations_standards_guidelines_protocol_b36f5685" VARCHAR -- Existence Of Regulations Standards Guidelines Protocols On Assistive Technology
);
CREATE TABLE owid_existence_of_regulations_standards_guidelines_pro_d006d756 (
"year" INTEGER,
"country" VARCHAR,
"assistive_technology_subquestion" VARCHAR,
"existence_of_regulations_standards_guidelines_protocol_b36f5685" VARCHAR -- Existence Of Regulations Standards Guidelines Protocols On Assistive Technology,
"existence_of_regulations_standards_guidelines_protocol_febd8fe3" VARCHAR -- Existence Of Regulations Standards Guidelines Protocols On Assistive Technology Low,
"existence_of_regulations_standards_guidelines_protocol_97b2a32d" VARCHAR -- Existence Of Regulations Standards Guidelines Protocols On Assistive Technology High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_respite_care_for_dementia_carers_1 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_respite_care_for_dementia_carers" VARCHAR
);
CREATE TABLE owid_existence_of_respite_care_for_dementia_carers_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_respite_care_for_dementia_carers" VARCHAR,
"existence_of_respite_care_for_dementia_carers_low" VARCHAR,
"existence_of_respite_care_for_dementia_carers_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_responsible_ministry_authority_on_as_0ddebe0f (
"year" INTEGER,
"country" VARCHAR,
"assistive_technology_subquestion" VARCHAR,
"existence_of_responsible_ministry_authority_on_assisti_a47e097e" VARCHAR -- Existence Of Responsible Ministry Authority On Assistive Technology,
"existence_of_responsible_ministry_authority_on_assisti_0c934a92" VARCHAR -- Existence Of Responsible Ministry Authority On Assistive Technology Low,
"existence_of_responsible_ministry_authority_on_assisti_d29f76a2" VARCHAR -- Existence Of Responsible Ministry Authority On Assistive Technology High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_responsible_ministry_authority_on_as_2642db9f (
"year" INTEGER,
"country" VARCHAR,
"assistive_technology_subquestion" VARCHAR,
"comments" VARCHAR,
"existence_of_responsible_ministry_authority_on_assisti_a47e097e" VARCHAR -- Existence Of Responsible Ministry Authority On Assistive Technology
);
CREATE TABLE owid_existence_of_standards_1 (
"year" INTEGER,
"country" VARCHAR,
"exposed" VARCHAR,
"frequency" VARCHAR,
"existence_of_standards" VARCHAR
);
CREATE TABLE owid_existence_of_standards_2 (
"year" INTEGER,
"country" VARCHAR,
"exposed" VARCHAR,
"frequency" VARCHAR,
"existence_of_standards" VARCHAR,
"existence_of_standards_low" VARCHAR,
"existence_of_standards_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_standards_guidelines_protocols_for_a_c3b92795 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_standards_guidelines_protocols_for_advanc_5de8d9d9" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Advance Care Directives, Power Of Attorney Or Guardianship For People With Dementia
);
CREATE TABLE owid_existence_of_standards_guidelines_protocols_for_a_f8a0d822 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_standards_guidelines_protocols_for_advanc_5de8d9d9" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Advance Care Directives, Power Of Attorney Or Guardianship For People With Dementia,
"existence_of_standards_guidelines_protocols_for_advanc_347f25e4" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Advance Care Directives, Power Of Attorney Or Guardianship For People With Dementia Low,
"existence_of_standards_guidelines_protocols_for_advanc_f52cdfdd" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Advance Care Directives, Power Of Attorney Or Guardianship For People With Dementia High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_standards_guidelines_protocols_for_d_1b5ecca8 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_standards_guidelines_protocols_for_diagno_b01ae9c0" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Diagnosis Of Dementia,
"existence_of_standards_guidelines_protocols_for_diagno_c158c779" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Diagnosis Of Dementia Low,
"existence_of_standards_guidelines_protocols_for_diagno_83893986" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Diagnosis Of Dementia High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_standards_guidelines_protocols_for_d_c47a6ee9 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_standards_guidelines_protocols_for_diagno_b01ae9c0" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Diagnosis Of Dementia
);
CREATE TABLE owid_existence_of_standards_guidelines_protocols_for_m_0014ea67 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_standards_guidelines_protocols_for_manage_2213a72f" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Management Of Dementia
);
CREATE TABLE owid_existence_of_standards_guidelines_protocols_for_m_93d7a1b4 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_standards_guidelines_protocols_for_manage_2213a72f" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Management Of Dementia,
"existence_of_standards_guidelines_protocols_for_manage_4a9a064e" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Management Of Dementia Low,
"existence_of_standards_guidelines_protocols_for_manage_919ddf52" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Management Of Dementia High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_standards_guidelines_protocols_for_o_14478bea (
"year" INTEGER,
"country" VARCHAR,
"existence_of_standards_guidelines_protocols_for_other__287e90d3" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Other Post Diagnostic Supports Of People With Dementia
);
CREATE TABLE owid_existence_of_standards_guidelines_protocols_for_o_be2d79e5 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_standards_guidelines_protocols_for_other__287e90d3" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Other Post Diagnostic Supports Of People With Dementia,
"existence_of_standards_guidelines_protocols_for_other__5253640e" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Other Post Diagnostic Supports Of People With Dementia Low,
"existence_of_standards_guidelines_protocols_for_other__3ed31488" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Other Post Diagnostic Supports Of People With Dementia High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_standards_guidelines_protocols_for_p_8dd3f191 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_standards_guidelines_protocols_for_preven_fc8d12fa" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Prevention And Risk Reduction Of Dementia,
"existence_of_standards_guidelines_protocols_for_preven_8fadd73f" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Prevention And Risk Reduction Of Dementia Low,
"existence_of_standards_guidelines_protocols_for_preven_109b7fc7" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Prevention And Risk Reduction Of Dementia High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_standards_guidelines_protocols_for_p_98e8c098 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_standards_guidelines_protocols_for_preven_fc8d12fa" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Prevention And Risk Reduction Of Dementia
);
CREATE TABLE owid_existence_of_standards_guidelines_protocols_for_p_9c7ac12f (
"year" INTEGER,
"country" VARCHAR,
"existence_of_standards_guidelines_protocols_for_pallia_f0f73d75" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Palliative And End Of Life Care For People With Dementia
);
CREATE TABLE owid_existence_of_standards_guidelines_protocols_for_p_eb0a6545 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_standards_guidelines_protocols_for_pallia_f0f73d75" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Palliative And End Of Life Care For People With Dementia,
"existence_of_standards_guidelines_protocols_for_pallia_7b63916e" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Palliative And End Of Life Care For People With Dementia Low,
"existence_of_standards_guidelines_protocols_for_pallia_0441c887" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Palliative And End Of Life Care For People With Dementia High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_standards_guidelines_protocols_for_t_4fc75f46 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_standards_guidelines_protocols_for_treatm_d0e203d3" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Treatment And Support Of Carers And Families Of People With Dementia,
"existence_of_standards_guidelines_protocols_for_treatm_ff7c1d46" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Treatment And Support Of Carers And Families Of People With Dementia Low,
"existence_of_standards_guidelines_protocols_for_treatm_df83fe51" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Treatment And Support Of Carers And Families Of People With Dementia High,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.