Global Health Observatory - World Health Organization

CREATE TABLE owid_effectiveness_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "effectiveness" VARCHAR
);

CREATE TABLE owid_effectiveness_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "effectiveness" VARCHAR,
  "effectiveness_low" VARCHAR,
  "effectiveness_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_effective_standards_and_best_practices_for_data_c_a07fab9b (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "effective_standards_and_best_practices_for_data_captur_34790e60" VARCHAR  -- Effective Standards And Best Practices For Data Capture Not Fully Established,
  "effective_standards_and_best_practices_for_data_captur_ad993375" VARCHAR  -- Effective Standards And Best Practices For Data Capture Not Fully Established Low,
  "effective_standards_and_best_practices_for_data_captur_99c50b8f" VARCHAR  -- Effective Standards And Best Practices For Data Capture Not Fully Established High,
  "comments" VARCHAR
);

CREATE TABLE owid_effective_standards_and_best_practices_for_data_c_a342f151 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "effective_standards_and_best_practices_for_data_captur_34790e60" VARCHAR  -- Effective Standards And Best Practices For Data Capture Not Fully Established
);

CREATE TABLE owid_egg_and_or_flesh_food_consumption_6_23_months_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "mothers_education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "household_wealth" VARCHAR,
  "egg_and_or_flesh_food_consumption_6_23_months" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_egg_and_or_flesh_food_consumption_6_23_months_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "household_wealth" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "education_level" VARCHAR,
  "egg_and_or_flesh_food_consumption_6_23_months" FLOAT,
  "egg_and_or_flesh_food_consumption_6_23_months_low" FLOAT,
  "egg_and_or_flesh_food_consumption_6_23_months_high" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_elder_abuse_extent_of_implementation_of_caregiver_464430ea (
  "year" INTEGER,
  "country" VARCHAR,
  "elder_abuse_extent_of_implementation_of_caregiver_supp_8340cab1" VARCHAR  -- Elder Abuse, Extent Of Implementation Of Caregiver Support Programmes
);

CREATE TABLE owid_elder_abuse_extent_of_implementation_of_caregiver_cd15316b (
  "year" INTEGER,
  "country" VARCHAR,
  "elder_abuse_extent_of_implementation_of_caregiver_supp_8340cab1" VARCHAR  -- Elder Abuse, Extent Of Implementation Of Caregiver Support Programmes,
  "elder_abuse_extent_of_implementation_of_caregiver_supp_9ee68a4a" VARCHAR  -- Elder Abuse, Extent Of Implementation Of Caregiver Support Programmes Low,
  "elder_abuse_extent_of_implementation_of_caregiver_supp_7e61313f" VARCHAR  -- Elder Abuse, Extent Of Implementation Of Caregiver Support Programmes High,
  "comments" VARCHAR
);

CREATE TABLE owid_elearning_courses_accredited_by_continuing_medica_0402c40e (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "elearning_courses_accredited_by_continuing_medical_edu_6037c9d5" VARCHAR  -- Elearning Courses Accredited By Continuing Medical Education Or Professional Licensing Bodies,
  "elearning_courses_accredited_by_continuing_medical_edu_1cdd4bb5" VARCHAR  -- Elearning Courses Accredited By Continuing Medical Education Or Professional Licensing Bodies Low,
  "elearning_courses_accredited_by_continuing_medical_edu_dc9390ab" VARCHAR  -- Elearning Courses Accredited By Continuing Medical Education Or Professional Licensing Bodies High,
  "comments" VARCHAR
);

CREATE TABLE owid_elearning_courses_accredited_by_continuing_medica_68d84f2e (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "elearning_courses_accredited_by_continuing_medical_edu_6037c9d5" VARCHAR  -- Elearning Courses Accredited By Continuing Medical Education Or Professional Licensing Bodies
);

CREATE TABLE owid_elearning_is_used_in_pre_service_education_to_tea_3663ef06 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "elearning_is_used_in_pre_service_education_to_teach_he_de1f1f8e" VARCHAR  -- Elearning Is Used In Pre Service Education To Teach Health Sciences Students
);

CREATE TABLE owid_elearning_is_used_in_pre_service_education_to_tea_fb885cb8 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "elearning_is_used_in_pre_service_education_to_teach_he_de1f1f8e" VARCHAR  -- Elearning Is Used In Pre Service Education To Teach Health Sciences Students,
  "elearning_is_used_in_pre_service_education_to_teach_he_9cc58786" VARCHAR  -- Elearning Is Used In Pre Service Education To Teach Health Sciences Students Low,
  "elearning_is_used_in_pre_service_education_to_teach_he_3a93ef54" VARCHAR  -- Elearning Is Used In Pre Service Education To Teach Health Sciences Students High,
  "comments" VARCHAR
);

CREATE TABLE owid_elearning_programmes_for_in_service_training_of_h_c0bb30d7 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "elearning_programmes_for_in_service_training_of_health_fc591b1b" VARCHAR  -- Elearning Programmes For In Service Training Of Health Professionals Have Been Evaluated
);

CREATE TABLE owid_elearning_programmes_for_in_service_training_of_h_cdd1d410 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "elearning_programmes_for_in_service_training_of_health_fc591b1b" VARCHAR  -- Elearning Programmes For In Service Training Of Health Professionals Have Been Evaluated,
  "elearning_programmes_for_in_service_training_of_health_e5185ecd" VARCHAR  -- Elearning Programmes For In Service Training Of Health Professionals Have Been Evaluated Low,
  "elearning_programmes_for_in_service_training_of_health_6e34d4b3" VARCHAR  -- Elearning Programmes For In Service Training Of Health Professionals Have Been Evaluated High,
  "comments" VARCHAR
);

CREATE TABLE owid_elearning_used_for_in_service_training_of_health__9a9796fa (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "elearning_used_for_in_service_training_of_health_professionals" VARCHAR
);

CREATE TABLE owid_elearning_used_for_in_service_training_of_health__b58265a5 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "elearning_used_for_in_service_training_of_health_professionals" VARCHAR,
  "elearning_used_for_in_service_training_of_health_profe_85721ddf" VARCHAR  -- Elearning Used For In Service Training Of Health Professionals Low,
  "elearning_used_for_in_service_training_of_health_profe_3ba338be" VARCHAR  -- Elearning Used For In Service Training Of Health Professionals High,
  "comments" VARCHAR
);

CREATE TABLE owid_electric_field_kv_m_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "exposed" VARCHAR,
  "frequency" VARCHAR,
  "comments" VARCHAR,
  "electric_field_kv_m" VARCHAR  -- Electric Field, Kv M
);

CREATE TABLE owid_electric_field_kv_m_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "exposed" VARCHAR,
  "frequency" VARCHAR,
  "electric_field_kv_m" VARCHAR  -- Electric Field, Kv M,
  "electric_field_kv_m_low" VARCHAR  -- Electric Field, Kv M Low,
  "electric_field_kv_m_high" VARCHAR  -- Electric Field, Kv M High,
  "comments" VARCHAR
);

CREATE TABLE owid_electric_field_kv_m_low_frequency_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "exposed" VARCHAR,
  "frequency" VARCHAR,
  "comments" VARCHAR,
  "electric_field_kv_m_low_frequency" VARCHAR  -- Electric Field, Kv M, Low Frequency
);

CREATE TABLE owid_electric_field_kv_m_low_frequency_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "exposed" VARCHAR,
  "frequency" VARCHAR,
  "electric_field_kv_m_low_frequency" VARCHAR  -- Electric Field, Kv M, Low Frequency,
  "electric_field_kv_m_low_frequency_low" VARCHAR  -- Electric Field, Kv M, Low Frequency Low,
  "electric_field_kv_m_low_frequency_high" VARCHAR  -- Electric Field, Kv M, Low Frequency High,
  "comments" VARCHAR
);

CREATE TABLE owid_electric_field_v_m_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "exposed" VARCHAR,
  "frequency" VARCHAR,
  "radio_band" VARCHAR,
  "comments" VARCHAR,
  "electric_field_v_m" VARCHAR  -- Electric Field, V M
);

CREATE TABLE owid_electric_field_v_m_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "exposed" VARCHAR,
  "frequency" VARCHAR,
  "radio_band" VARCHAR,
  "electric_field_v_m" VARCHAR  -- Electric Field, V M,
  "electric_field_v_m_low" VARCHAR  -- Electric Field, V M Low,
  "electric_field_v_m_high" VARCHAR  -- Electric Field, V M High,
  "comments" VARCHAR
);

CREATE TABLE owid_electronic_availability_of_data_sources_used_to_r_1ec5da6b (
  "year" INTEGER,
  "country" VARCHAR,
  "electronic_availability_of_data_sources_used_to_routin_49ae329c" VARCHAR  -- Electronic Availability Of Data Sources Used To Routinely Monitor People With Dementia
);

CREATE TABLE owid_electronic_availability_of_data_sources_used_to_r_4d7c798e (
  "year" INTEGER,
  "country" VARCHAR,
  "electronic_availability_of_data_sources_used_to_routin_49ae329c" VARCHAR  -- Electronic Availability Of Data Sources Used To Routinely Monitor People With Dementia,
  "electronic_availability_of_data_sources_used_to_routin_e103dea9" VARCHAR  -- Electronic Availability Of Data Sources Used To Routinely Monitor People With Dementia Low,
  "electronic_availability_of_data_sources_used_to_routin_d0f82b5e" VARCHAR  -- Electronic Availability Of Data Sources Used To Routinely Monitor People With Dementia High,
  "comments" VARCHAR
);

CREATE TABLE owid_employment_services_for_alcohol_use_disorders_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "employment_services_for_alcohol_use_disorders" VARCHAR
);