Global Health Observatory - World Health Organization

CREATE TABLE owid_groups_and_agencies_involved_in_prevention_programs_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_groups" VARCHAR,
  "groups_and_agencies_involved_in_prevention_programs" VARCHAR
);

CREATE TABLE owid_groups_and_agencies_involved_in_prevention_programs_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_groups" VARCHAR,
  "groups_and_agencies_involved_in_prevention_programs" VARCHAR,
  "groups_and_agencies_involved_in_prevention_programs_low" VARCHAR,
  "groups_and_agencies_involved_in_prevention_programs_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_guidelines_on_pharmacological_treatment_for_subst_49ab7f6c (
  "year" INTEGER,
  "country" VARCHAR,
  "guidelines_on_pharmacological_treatment_for_substance__3276db7a" VARCHAR  -- Guidelines On Pharmacological Treatment For Substance Use Disorders
);

CREATE TABLE owid_guidelines_on_pharmacological_treatment_for_subst_58666c9e (
  "year" INTEGER,
  "country" VARCHAR,
  "guidelines_on_pharmacological_treatment_for_substance__3276db7a" VARCHAR  -- Guidelines On Pharmacological Treatment For Substance Use Disorders,
  "guidelines_on_pharmacological_treatment_for_substance__13fd3667" VARCHAR  -- Guidelines On Pharmacological Treatment For Substance Use Disorders Low,
  "guidelines_on_pharmacological_treatment_for_substance__7bd9f2e3" VARCHAR  -- Guidelines On Pharmacological Treatment For Substance Use Disorders High,
  "comments" VARCHAR
);

CREATE TABLE owid_guidelines_on_the_pharmacological_treatment_of_su_a835d377 (
  "year" INTEGER,
  "country" VARCHAR,
  "guidelines_on_the_pharmacological_treatment_of_substan_b8a5d327" VARCHAR  -- Guidelines On The Pharmacological Treatment Of Substance Use Disorders,
  "guidelines_on_the_pharmacological_treatment_of_substan_a51cf4c6" VARCHAR  -- Guidelines On The Pharmacological Treatment Of Substance Use Disorders Low,
  "guidelines_on_the_pharmacological_treatment_of_substan_35509f3e" VARCHAR  -- Guidelines On The Pharmacological Treatment Of Substance Use Disorders High,
  "comments" VARCHAR
);

CREATE TABLE owid_guidelines_on_the_pharmacological_treatment_of_su_bbb41a41 (
  "year" INTEGER,
  "country" VARCHAR,
  "guidelines_on_the_pharmacological_treatment_of_substan_b8a5d327" VARCHAR  -- Guidelines On The Pharmacological Treatment Of Substance Use Disorders
);

CREATE TABLE owid_handwashing_with_soap_after_cleaning_childs_stool_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "handwashing_with_soap_after_cleaning_childs_stool_pct" INTEGER  -- Handwashing With Soap After Cleaning Childs Stool, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_handwashing_with_soap_after_cleaning_childs_stool_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "handwashing_with_soap_after_cleaning_childs_stool_pct" INTEGER  -- Handwashing With Soap After Cleaning Childs Stool, Pct,
  "handwashing_with_soap_after_cleaning_childs_stool_pct_low" VARCHAR  -- Handwashing With Soap After Cleaning Childs Stool, Pct Low,
  "handwashing_with_soap_after_cleaning_childs_stool_pct_high" VARCHAR  -- Handwashing With Soap After Cleaning Childs Stool, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_handwashing_with_soap_after_using_the_toilet_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "handwashing_with_soap_after_using_the_toilet_pct" INTEGER  -- Handwashing With Soap After Using The Toilet, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_handwashing_with_soap_after_using_the_toilet_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "handwashing_with_soap_after_using_the_toilet_pct" INTEGER  -- Handwashing With Soap After Using The Toilet, Pct,
  "handwashing_with_soap_after_using_the_toilet_pct_low" VARCHAR  -- Handwashing With Soap After Using The Toilet, Pct Low,
  "handwashing_with_soap_after_using_the_toilet_pct_high" VARCHAR  -- Handwashing With Soap After Using The Toilet, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_harm_reduction_programmes_for_idus_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_programmes" VARCHAR,
  "harm_reduction_programmes_for_idus" VARCHAR
);

CREATE TABLE owid_harm_reduction_programmes_for_idus_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_programmes" VARCHAR,
  "harm_reduction_programmes_for_idus" VARCHAR,
  "harm_reduction_programmes_for_idus_low" VARCHAR,
  "harm_reduction_programmes_for_idus_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_has_a_steps_survey_or_a_comprehensive_health_exam_13e4ab02 (
  "year" INTEGER,
  "country" VARCHAR,
  "has_a_steps_survey_or_a_comprehensive_health_examinati_8b92f0ba" VARCHAR  -- Has A Steps Survey Or A Comprehensive Health Examination Survey Every 5 Years,
  "has_a_steps_survey_or_a_comprehensive_health_examinati_fe46fd46" VARCHAR  -- Has A Steps Survey Or A Comprehensive Health Examination Survey Every 5 Years Low,
  "has_a_steps_survey_or_a_comprehensive_health_examinati_ffe32a69" VARCHAR  -- Has A Steps Survey Or A Comprehensive Health Examination Survey Every 5 Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_has_a_steps_survey_or_a_comprehensive_health_exam_a6765ee7 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "has_a_steps_survey_or_a_comprehensive_health_examinati_8b92f0ba" VARCHAR  -- Has A Steps Survey Or A Comprehensive Health Examination Survey Every 5 Years
);

CREATE TABLE owid_has_conducted_a_recent_national_adult_risk_factor_0eb54496 (
  "year" INTEGER,
  "country" VARCHAR,
  "has_conducted_a_recent_national_adult_risk_factor_surv_1bf83360" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Tobacco Use
);

CREATE TABLE owid_has_conducted_a_recent_national_adult_risk_factor_16423abc (
  "year" INTEGER,
  "country" VARCHAR,
  "has_conducted_a_recent_national_adult_risk_factor_surv_cb1b8db4" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Raised Blood Glucose Diabetes
);

CREATE TABLE owid_has_conducted_a_recent_national_adult_risk_factor_16ab75ec (
  "year" INTEGER,
  "country" VARCHAR,
  "has_conducted_a_recent_national_adult_risk_factor_surv_83ca3781" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Raised Blood Pressure Hypertension
);

CREATE TABLE owid_has_conducted_a_recent_national_adult_risk_factor_4329f578 (
  "year" INTEGER,
  "country" VARCHAR,
  "has_conducted_a_recent_national_adult_risk_factor_surv_1bf83360" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Tobacco Use,
  "has_conducted_a_recent_national_adult_risk_factor_surv_5db6affa" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Tobacco Use Low,
  "has_conducted_a_recent_national_adult_risk_factor_surv_bb0c4328" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Tobacco Use High,
  "comments" VARCHAR
);

CREATE TABLE owid_has_conducted_a_recent_national_adult_risk_factor_4f80b178 (
  "year" INTEGER,
  "country" VARCHAR,
  "has_conducted_a_recent_national_adult_risk_factor_surv_4a44ff0d" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Raised Total Cholesterol,
  "has_conducted_a_recent_national_adult_risk_factor_surv_a1ae7f07" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Raised Total Cholesterol Low,
  "has_conducted_a_recent_national_adult_risk_factor_surv_b2e46dba" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Raised Total Cholesterol High,
  "comments" VARCHAR
);

CREATE TABLE owid_has_conducted_a_recent_national_adult_risk_factor_643fc2f7 (
  "year" INTEGER,
  "country" VARCHAR,
  "has_conducted_a_recent_national_adult_risk_factor_surv_54a42975" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Harmful Alcohol Use,
  "has_conducted_a_recent_national_adult_risk_factor_surv_5dfd156b" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Harmful Alcohol Use Low,
  "has_conducted_a_recent_national_adult_risk_factor_surv_bacd2c4c" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Harmful Alcohol Use High,
  "comments" VARCHAR
);

CREATE TABLE owid_has_conducted_a_recent_national_adult_risk_factor_6c1fc26c (
  "year" INTEGER,
  "country" VARCHAR,
  "has_conducted_a_recent_national_adult_risk_factor_surv_4a44ff0d" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Raised Total Cholesterol
);

CREATE TABLE owid_has_conducted_a_recent_national_adult_risk_factor_7876aa71 (
  "year" INTEGER,
  "country" VARCHAR,
  "has_conducted_a_recent_national_adult_risk_factor_surv_386ada7b" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Salt Sodium Intake,
  "has_conducted_a_recent_national_adult_risk_factor_surv_2b2de049" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Salt Sodium Intake Low,
  "has_conducted_a_recent_national_adult_risk_factor_surv_683bf10c" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Salt Sodium Intake High,
  "comments" VARCHAR
);

CREATE TABLE owid_has_conducted_a_recent_national_adult_risk_factor_7e8d4589 (
  "year" INTEGER,
  "country" VARCHAR,
  "has_conducted_a_recent_national_adult_risk_factor_surv_e4aed68c" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Unhealthy Diet
);

CREATE TABLE owid_has_conducted_a_recent_national_adult_risk_factor_a89d8e75 (
  "year" INTEGER,
  "country" VARCHAR,
  "has_conducted_a_recent_national_adult_risk_factor_surv_65a52f89" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Physical Inactivity,
  "has_conducted_a_recent_national_adult_risk_factor_surv_3388b64c" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Physical Inactivity Low,
  "has_conducted_a_recent_national_adult_risk_factor_surv_8e2d474a" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Physical Inactivity High,
  "comments" VARCHAR
);

CREATE TABLE owid_has_conducted_a_recent_national_adult_risk_factor_abaa2ea0 (
  "year" INTEGER,
  "country" VARCHAR,
  "has_conducted_a_recent_national_adult_risk_factor_surv_54a42975" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Harmful Alcohol Use
);