Global Health Observatory - World Health Organization

CREATE TABLE owid_human_development_index_rank_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "human_development_index_rank" INTEGER,
  "human_development_index_rank_low" VARCHAR,
  "human_development_index_rank_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_human_resources (
  "year" INTEGER,
  "country" VARCHAR,
  "human_resources" INTEGER
);

CREATE TABLE owid_human_resources_spar (
  "year" INTEGER,
  "country" VARCHAR,
  "ihr_spar_capacity_level" VARCHAR,
  "human_resources_spar" INTEGER  -- Human Resources, Spar
);

CREATE TABLE owid_hypothecated_taxes_to_be_spent_on_prevention_and__502ea3f5 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "hypothecated_taxes_to_be_spent_on_prevention_and_treat_90089b55" VARCHAR  -- Hypothecated Taxes To Be Spent On Prevention And Treatment For Substance Use Disorders,
  "hypothecated_taxes_to_be_spent_on_prevention_and_treat_5c3169f0" VARCHAR  -- Hypothecated Taxes To Be Spent On Prevention And Treatment For Substance Use Disorders Low,
  "hypothecated_taxes_to_be_spent_on_prevention_and_treat_f1f69002" VARCHAR  -- Hypothecated Taxes To Be Spent On Prevention And Treatment For Substance Use Disorders High,
  "comments" VARCHAR
);

CREATE TABLE owid_hypothecated_taxes_to_be_spent_on_prevention_and__cb21bd46 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "hypothecated_taxes_to_be_spent_on_prevention_and_treat_90089b55" VARCHAR  -- Hypothecated Taxes To Be Spent On Prevention And Treatment For Substance Use Disorders
);

CREATE TABLE owid_icd_11_implementation_progress_level_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "icd_11_implementation_progress_level" INTEGER
);

CREATE TABLE owid_icd_11_implementation_progress_level_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "icd_11_implementation_progress_level" INTEGER,
  "icd_11_implementation_progress_level_low" VARCHAR,
  "icd_11_implementation_progress_level_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_ict_development_index_idi_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "ict_development_index_idi" FLOAT  -- Ict Development Index, Idi
);

CREATE TABLE owid_ict_development_index_idi_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ict_development_index_idi" FLOAT  -- Ict Development Index, Idi,
  "ict_development_index_idi_low" VARCHAR  -- Ict Development Index, Idi Low,
  "ict_development_index_idi_high" VARCHAR  -- Ict Development Index, Idi High,
  "comments" VARCHAR
);

CREATE TABLE owid_ict_development_index_idi_rank_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "ict_development_index_idi_rank" INTEGER  -- Ict Development Index, Idi, Rank
);

CREATE TABLE owid_ict_development_index_idi_rank_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ict_development_index_idi_rank" INTEGER  -- Ict Development Index, Idi, Rank,
  "ict_development_index_idi_rank_low" VARCHAR  -- Ict Development Index, Idi, Rank Low,
  "ict_development_index_idi_rank_high" VARCHAR  -- Ict Development Index, Idi, Rank High,
  "comments" VARCHAR
);

CREATE TABLE owid_identification_of_different_sectors_in_dementia_c_060c0325 (
  "year" INTEGER,
  "country" VARCHAR,
  "identification_of_different_sectors_in_dementia_care_c_56ebe884" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Civil Society,
  "identification_of_different_sectors_in_dementia_care_c_fce60da5" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Civil Society Low,
  "identification_of_different_sectors_in_dementia_care_c_60e230e8" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Civil Society High,
  "comments" VARCHAR
);

CREATE TABLE owid_identification_of_different_sectors_in_dementia_c_0b891799 (
  "year" INTEGER,
  "country" VARCHAR,
  "identification_of_different_sectors_in_dementia_care_c_1009c2fd" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Social,
  "identification_of_different_sectors_in_dementia_care_c_8b1862c2" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Social Low,
  "identification_of_different_sectors_in_dementia_care_c_82af805b" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Social High,
  "comments" VARCHAR
);

CREATE TABLE owid_identification_of_different_sectors_in_dementia_c_18003d0d (
  "year" INTEGER,
  "country" VARCHAR,
  "identification_of_different_sectors_in_dementia_care_c_129e6141" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Private Sector,
  "identification_of_different_sectors_in_dementia_care_c_aa5616df" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Private Sector Low,
  "identification_of_different_sectors_in_dementia_care_c_22eb3c7a" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Private Sector High,
  "comments" VARCHAR
);

CREATE TABLE owid_identification_of_different_sectors_in_dementia_c_2e327a2e (
  "year" INTEGER,
  "country" VARCHAR,
  "identification_of_different_sectors_in_dementia_care_c_ac41b70e" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Other,
  "identification_of_different_sectors_in_dementia_care_c_f2ed7ad7" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Other Low,
  "identification_of_different_sectors_in_dementia_care_c_90df2dd9" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Other High,
  "comments" VARCHAR
);

CREATE TABLE owid_identification_of_different_sectors_in_dementia_c_3362677f (
  "year" INTEGER,
  "country" VARCHAR,
  "identification_of_different_sectors_in_dementia_care_c_8df5e368" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Justice
);

CREATE TABLE owid_identification_of_different_sectors_in_dementia_c_3f7a10a8 (
  "year" INTEGER,
  "country" VARCHAR,
  "identification_of_different_sectors_in_dementia_care_c_3ccc3810" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Employment
);

CREATE TABLE owid_identification_of_different_sectors_in_dementia_c_4ee2ee40 (
  "year" INTEGER,
  "country" VARCHAR,
  "identification_of_different_sectors_in_dementia_care_c_129e6141" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Private Sector
);

CREATE TABLE owid_identification_of_different_sectors_in_dementia_c_5cea7124 (
  "year" INTEGER,
  "country" VARCHAR,
  "identification_of_different_sectors_in_dementia_care_c_b9596fed" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Health,
  "identification_of_different_sectors_in_dementia_care_c_043ea99e" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Health Low,
  "identification_of_different_sectors_in_dementia_care_c_8b5f2390" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Health High,
  "comments" VARCHAR
);

CREATE TABLE owid_identification_of_different_sectors_in_dementia_c_6d389f1e (
  "year" INTEGER,
  "country" VARCHAR,
  "identification_of_different_sectors_in_dementia_care_c_1009c2fd" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Social
);

CREATE TABLE owid_identification_of_different_sectors_in_dementia_c_760d2bb0 (
  "year" INTEGER,
  "country" VARCHAR,
  "identification_of_different_sectors_in_dementia_care_c_b9596fed" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Health
);

CREATE TABLE owid_identification_of_different_sectors_in_dementia_c_7d0aaafd (
  "year" INTEGER,
  "country" VARCHAR,
  "identification_of_different_sectors_in_dementia_care_c_51dde307" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Housing,
  "identification_of_different_sectors_in_dementia_care_c_882d0e2c" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Housing Low,
  "identification_of_different_sectors_in_dementia_care_c_e04128fb" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Housing High,
  "comments" VARCHAR
);

CREATE TABLE owid_identification_of_different_sectors_in_dementia_c_7d4d35d4 (
  "year" INTEGER,
  "country" VARCHAR,
  "identification_of_different_sectors_in_dementia_care_c_8df5e368" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Justice,
  "identification_of_different_sectors_in_dementia_care_c_9044769a" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Justice Low,
  "identification_of_different_sectors_in_dementia_care_c_a86ae67c" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Justice High,
  "comments" VARCHAR
);

CREATE TABLE owid_identification_of_different_sectors_in_dementia_c_a6db510d (
  "year" INTEGER,
  "country" VARCHAR,
  "identification_of_different_sectors_in_dementia_care_c_3ccc3810" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Employment,
  "identification_of_different_sectors_in_dementia_care_c_1dd08cb9" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Employment Low,
  "identification_of_different_sectors_in_dementia_care_c_b459d599" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Employment High,
  "comments" VARCHAR
);

CREATE TABLE owid_identification_of_different_sectors_in_dementia_c_c95ba1ec (
  "year" INTEGER,
  "country" VARCHAR,
  "identification_of_different_sectors_in_dementia_care_c_09d60ce7" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Education,
  "identification_of_different_sectors_in_dementia_care_c_c9fd0023" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Education Low,
  "identification_of_different_sectors_in_dementia_care_c_6c6051ab" VARCHAR  -- Identification Of Different Sectors In Dementia Care Coordination, Education High,
  "comments" VARCHAR
);