Global Health Observatory - World Health Organization

CREATE TABLE owid_water_sanitation_and_hygiene_attributable_dalys_0_57fe4da8 (
  "year" INTEGER,
  "country" VARCHAR,
  "water_sanitation_and_hygiene_attributable_dalys_000_in_73b71091" FLOAT  -- Water, Sanitation And Hygiene Attributable Dalys, 000, In Children Under 5 Years
);

CREATE TABLE owid_water_sanitation_and_hygiene_attributable_dalys_0_f6f51499 (
  "year" INTEGER,
  "country" VARCHAR,
  "water_sanitation_and_hygiene_attributable_dalys_000_in_73b71091" FLOAT  -- Water, Sanitation And Hygiene Attributable Dalys, 000, In Children Under 5 Years,
  "water_sanitation_and_hygiene_attributable_dalys_000_in_585a146f" VARCHAR  -- Water, Sanitation And Hygiene Attributable Dalys, 000, In Children Under 5 Years Low,
  "water_sanitation_and_hygiene_attributable_dalys_000_in_807c76f4" VARCHAR  -- Water, Sanitation And Hygiene Attributable Dalys, 000, In Children Under 5 Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_water_sanitation_and_hygiene_attributable_dalys_p_12e04e1f (
  "year" INTEGER,
  "country" VARCHAR,
  "water_sanitation_and_hygiene_attributable_dalys_per_10_74223eaa" FLOAT  -- Water, Sanitation And Hygiene Attributable Dalys Per 100000 Capita
);

CREATE TABLE owid_water_sanitation_and_hygiene_attributable_dalys_p_34b39169 (
  "year" INTEGER,
  "country" VARCHAR,
  "water_sanitation_and_hygiene_attributable_dalys_per_10_ca10313b" FLOAT  -- Water, Sanitation And Hygiene Attributable Dalys Per 100000 Children Under 5 Years
);

CREATE TABLE owid_water_sanitation_and_hygiene_attributable_dalys_p_8df07f2f (
  "year" INTEGER,
  "country" VARCHAR,
  "water_sanitation_and_hygiene_attributable_dalys_per_10_ca10313b" FLOAT  -- Water, Sanitation And Hygiene Attributable Dalys Per 100000 Children Under 5 Years,
  "water_sanitation_and_hygiene_attributable_dalys_per_10_3cd17e2b" VARCHAR  -- Water, Sanitation And Hygiene Attributable Dalys Per 100000 Children Under 5 Years Low,
  "water_sanitation_and_hygiene_attributable_dalys_per_10_75f04494" VARCHAR  -- Water, Sanitation And Hygiene Attributable Dalys Per 100000 Children Under 5 Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_water_sanitation_and_hygiene_attributable_dalys_p_a15423f1 (
  "year" INTEGER,
  "country" VARCHAR,
  "water_sanitation_and_hygiene_attributable_dalys_per_10_74223eaa" FLOAT  -- Water, Sanitation And Hygiene Attributable Dalys Per 100000 Capita,
  "water_sanitation_and_hygiene_attributable_dalys_per_10_09779b54" VARCHAR  -- Water, Sanitation And Hygiene Attributable Dalys Per 100000 Capita Low,
  "water_sanitation_and_hygiene_attributable_dalys_per_10_80c39983" VARCHAR  -- Water, Sanitation And Hygiene Attributable Dalys Per 100000 Capita High,
  "comments" VARCHAR
);

CREATE TABLE owid_water_sanitation_and_hygiene_attributable_deaths__0026dc37 (
  "year" INTEGER,
  "country" VARCHAR,
  "water_sanitation_and_hygiene_attributable_deaths_per_1_ab6c5bee" FLOAT  -- Water, Sanitation And Hygiene Attributable Deaths Per 100000 Children Under 5 Years
);

CREATE TABLE owid_water_sanitation_and_hygiene_attributable_deaths__010795b0 (
  "year" INTEGER,
  "country" VARCHAR,
  "water_sanitation_and_hygiene_attributable_deaths_per_1_ab6c5bee" FLOAT  -- Water, Sanitation And Hygiene Attributable Deaths Per 100000 Children Under 5 Years,
  "water_sanitation_and_hygiene_attributable_deaths_per_1_f8ed5030" VARCHAR  -- Water, Sanitation And Hygiene Attributable Deaths Per 100000 Children Under 5 Years Low,
  "water_sanitation_and_hygiene_attributable_deaths_per_1_236c0b4b" VARCHAR  -- Water, Sanitation And Hygiene Attributable Deaths Per 100000 Children Under 5 Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_water_sanitation_and_hygiene_attributable_deaths__6ef97e46 (
  "year" INTEGER,
  "country" VARCHAR,
  "water_sanitation_and_hygiene_attributable_deaths_per_1_5b8b9ae9" FLOAT  -- Water, Sanitation And Hygiene Attributable Deaths Per 100000 Capita
);

CREATE TABLE owid_water_sanitation_and_hygiene_attributable_deaths__72a7db38 (
  "year" INTEGER,
  "country" VARCHAR,
  "water_sanitation_and_hygiene_attributable_deaths_per_1_5b8b9ae9" FLOAT  -- Water, Sanitation And Hygiene Attributable Deaths Per 100000 Capita,
  "water_sanitation_and_hygiene_attributable_deaths_per_1_cf6dd410" VARCHAR  -- Water, Sanitation And Hygiene Attributable Deaths Per 100000 Capita Low,
  "water_sanitation_and_hygiene_attributable_deaths_per_1_90a10a56" VARCHAR  -- Water, Sanitation And Hygiene Attributable Deaths Per 100000 Capita High,
  "comments" VARCHAR
);

CREATE TABLE owid_water_sanitation_and_hygiene_attributable_deaths__e6374eeb (
  "year" INTEGER,
  "country" VARCHAR,
  "water_sanitation_and_hygiene_attributable_deaths_000_i_ffdace30" FLOAT  -- Water, Sanitation And Hygiene Attributable Deaths, 000, In Children Under 5 Years
);

CREATE TABLE owid_water_sanitation_and_hygiene_attributable_deaths__ef7de9b4 (
  "year" INTEGER,
  "country" VARCHAR,
  "water_sanitation_and_hygiene_attributable_deaths_000_i_ffdace30" FLOAT  -- Water, Sanitation And Hygiene Attributable Deaths, 000, In Children Under 5 Years,
  "water_sanitation_and_hygiene_attributable_deaths_000_i_04d0f1ea" VARCHAR  -- Water, Sanitation And Hygiene Attributable Deaths, 000, In Children Under 5 Years Low,
  "water_sanitation_and_hygiene_attributable_deaths_000_i_7eaf2785" VARCHAR  -- Water, Sanitation And Hygiene Attributable Deaths, 000, In Children Under 5 Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_which_allows_for_the_sharing_of_personal_and_heal_8b700c22 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "which_allows_for_the_sharing_of_personal_and_health_da_13a9def7" VARCHAR  -- Which Allows For The Sharing Of Personal And Health Data Between Research Entities,
  "which_allows_for_the_sharing_of_personal_and_health_da_68dbeefe" VARCHAR  -- Which Allows For The Sharing Of Personal And Health Data Between Research Entities Low,
  "which_allows_for_the_sharing_of_personal_and_health_da_0871ac23" VARCHAR  -- Which Allows For The Sharing Of Personal And Health Data Between Research Entities High,
  "comments" VARCHAR
);

CREATE TABLE owid_which_allows_for_the_sharing_of_personal_and_heal_b5d23c96 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "which_allows_for_the_sharing_of_personal_and_health_da_13a9def7" VARCHAR  -- Which Allows For The Sharing Of Personal And Health Data Between Research Entities
);

CREATE TABLE owid_which_allows_individuals_electronic_access_to_the_bc92c86d (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "which_allows_individuals_electronic_access_to_their_ow_26cdb027" VARCHAR  -- Which Allows Individuals Electronic Access To Their Own Health Related Data When Held In An Ehr,
  "which_allows_individuals_electronic_access_to_their_ow_6301ee53" VARCHAR  -- Which Allows Individuals Electronic Access To Their Own Health Related Data When Held In An Ehr Low,
  "which_allows_individuals_electronic_access_to_their_ow_8188f0d4" VARCHAR  -- Which Allows Individuals Electronic Access To Their Own Health Related Data When Held In An Ehr High,
  "comments" VARCHAR
);

CREATE TABLE owid_which_allows_individuals_electronic_access_to_the_eba102c3 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "which_allows_individuals_electronic_access_to_their_ow_26cdb027" VARCHAR  -- Which Allows Individuals Electronic Access To Their Own Health Related Data When Held In An Ehr
);

CREATE TABLE owid_which_allows_individuals_to_demand_that_their_own_51afeb47 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "which_allows_individuals_to_demand_that_their_own_data_32680eb8" VARCHAR  -- Which Allows Individuals To Demand That Their Own Data Be Corrected When Held In An Ehr If It Is Known To Be Inaccurate,
  "which_allows_individuals_to_demand_that_their_own_data_c0a485bc" VARCHAR  -- Which Allows Individuals To Demand That Their Own Data Be Corrected When Held In An Ehr If It Is Known To Be Inaccurate Low,
  "which_allows_individuals_to_demand_that_their_own_data_51759596" VARCHAR  -- Which Allows Individuals To Demand That Their Own Data Be Corrected When Held In An Ehr If It Is Known To Be Inaccurate High,
  "comments" VARCHAR
);

CREATE TABLE owid_which_allows_individuals_to_demand_that_their_own_93e76e89 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "which_allows_individuals_to_demand_that_their_own_data_32680eb8" VARCHAR  -- Which Allows Individuals To Demand That Their Own Data Be Corrected When Held In An Ehr If It Is Known To Be Inaccurate
);

CREATE TABLE owid_which_allows_individuals_to_demand_the_deletion_o_619b54c3 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "which_allows_individuals_to_demand_the_deletion_of_hea_5efa0b53" VARCHAR  -- Which Allows Individuals To Demand The Deletion Of Health Related Data From Their Ehr,
  "which_allows_individuals_to_demand_the_deletion_of_hea_eae17a07" VARCHAR  -- Which Allows Individuals To Demand The Deletion Of Health Related Data From Their Ehr Low,
  "which_allows_individuals_to_demand_the_deletion_of_hea_78e09e4c" VARCHAR  -- Which Allows Individuals To Demand The Deletion Of Health Related Data From Their Ehr High,
  "comments" VARCHAR
);

CREATE TABLE owid_which_allows_individuals_to_demand_the_deletion_o_a9edd5d5 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "which_allows_individuals_to_demand_the_deletion_of_hea_5efa0b53" VARCHAR  -- Which Allows Individuals To Demand The Deletion Of Health Related Data From Their Ehr
);

CREATE TABLE owid_which_governs_the_sharing_of_digital_data_between_0a9a74e3 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "which_governs_the_sharing_of_digital_data_between_heal_916c5ebb" VARCHAR  -- Which Governs The Sharing Of Digital Data Between Health Professionals In Health Services In Other Countries Through The Use Of An Ehr
);

CREATE TABLE owid_which_governs_the_sharing_of_digital_data_between_2a1fb61c (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "which_governs_the_sharing_of_digital_data_between_heal_9f6adf0b" VARCHAR  -- Which Governs The Sharing Of Digital Data Between Health Professionals In Other Health Services In The Same Country Through The Use Of An Ehr,
  "which_governs_the_sharing_of_digital_data_between_heal_988f8ced" VARCHAR  -- Which Governs The Sharing Of Digital Data Between Health Professionals In Other Health Services In The Same Country Through The Use Of An Ehr Low,
  "which_governs_the_sharing_of_digital_data_between_heal_0cf3586c" VARCHAR  -- Which Governs The Sharing Of Digital Data Between Health Professionals In Other Health Services In The Same Country Through The Use Of An Ehr High,
  "comments" VARCHAR
);

CREATE TABLE owid_which_governs_the_sharing_of_digital_data_between_efcf91cb (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "which_governs_the_sharing_of_digital_data_between_heal_9f6adf0b" VARCHAR  -- Which Governs The Sharing Of Digital Data Between Health Professionals In Other Health Services In The Same Country Through The Use Of An Ehr
);

CREATE TABLE owid_which_governs_the_sharing_of_digital_data_between_f029e39d (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "which_governs_the_sharing_of_digital_data_between_heal_916c5ebb" VARCHAR  -- Which Governs The Sharing Of Digital Data Between Health Professionals In Health Services In Other Countries Through The Use Of An Ehr,
  "which_governs_the_sharing_of_digital_data_between_heal_cd35c1c4" VARCHAR  -- Which Governs The Sharing Of Digital Data Between Health Professionals In Health Services In Other Countries Through The Use Of An Ehr Low,
  "which_governs_the_sharing_of_digital_data_between_heal_10740423" VARCHAR  -- Which Governs The Sharing Of Digital Data Between Health Professionals In Health Services In Other Countries Through The Use Of An Ehr High,
  "comments" VARCHAR
);

CREATE TABLE owid_women_accessing_antenatal_care_anc_services_who_w_a40d3200 (
  "year" INTEGER,
  "country" VARCHAR,
  "women_accessing_antenatal_care_anc_services_who_were_t_4918ffd5" FLOAT  -- Women Accessing Antenatal Care, Anc, Services Who Were Tested For Syphilis, Pct, Reported,
  "women_accessing_antenatal_care_anc_services_who_were_t_864a0b19" VARCHAR  -- Women Accessing Antenatal Care, Anc, Services Who Were Tested For Syphilis, Pct, Reported Low,
  "women_accessing_antenatal_care_anc_services_who_were_t_32f07648" VARCHAR  -- Women Accessing Antenatal Care, Anc, Services Who Were Tested For Syphilis, Pct, Reported High,
  "comments" VARCHAR
);