Global Health Observatory - World Health Organization

CREATE TABLE owid_has_conducted_a_recent_national_adult_risk_factor_c0a69b7e (
  "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,
  "has_conducted_a_recent_national_adult_risk_factor_surv_f912b6fc" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Unhealthy Diet Low,
  "has_conducted_a_recent_national_adult_risk_factor_surv_65c182cc" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Unhealthy Diet High,
  "comments" VARCHAR
);

CREATE TABLE owid_has_conducted_a_recent_national_adult_risk_factor_c9685a40 (
  "year" INTEGER,
  "country" VARCHAR,
  "has_conducted_a_recent_national_adult_risk_factor_surv_9e674825" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Overweight And Obesity
);

CREATE TABLE owid_has_conducted_a_recent_national_adult_risk_factor_cfc05c58 (
  "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,
  "has_conducted_a_recent_national_adult_risk_factor_surv_60a6c436" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Raised Blood Glucose Diabetes Low,
  "has_conducted_a_recent_national_adult_risk_factor_surv_d4800684" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Raised Blood Glucose Diabetes High,
  "comments" VARCHAR
);

CREATE TABLE owid_has_conducted_a_recent_national_adult_risk_factor_d30cf2ba (
  "year" INTEGER,
  "country" VARCHAR,
  "has_conducted_a_recent_national_adult_risk_factor_surv_9e674825" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Overweight And Obesity,
  "has_conducted_a_recent_national_adult_risk_factor_surv_781a160c" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Overweight And Obesity Low,
  "has_conducted_a_recent_national_adult_risk_factor_surv_dcaf4696" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Overweight And Obesity High,
  "comments" VARCHAR
);

CREATE TABLE owid_has_conducted_a_recent_national_adult_risk_factor_da1a94ce (
  "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,
  "has_conducted_a_recent_national_adult_risk_factor_surv_8a4519e9" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Raised Blood Pressure Hypertension Low,
  "has_conducted_a_recent_national_adult_risk_factor_surv_8ecd24c9" VARCHAR  -- Has Conducted A Recent, National Adult Risk Factor Survey Covering Raised Blood Pressure Hypertension High,
  "comments" VARCHAR
);

CREATE TABLE owid_has_conducted_a_recent_national_adult_risk_factor_dfb8f032 (
  "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
);

CREATE TABLE owid_has_conducted_a_recent_national_adult_risk_factor_ea9e316f (
  "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
);

CREATE TABLE owid_has_systems_for_follow_up_recall_to_deliver_long__88d7d249 (
  "year" INTEGER,
  "country" VARCHAR,
  "has_systems_for_follow_up_recall_to_deliver_long_term__edd99034" VARCHAR  -- Has Systems For Follow Up Recall To Deliver Long Term Penicillin Prophylaxis To Patients With Rheumatic Fever And Rheumatic Heart Disease,
  "has_systems_for_follow_up_recall_to_deliver_long_term__13e6517e" VARCHAR  -- Has Systems For Follow Up Recall To Deliver Long Term Penicillin Prophylaxis To Patients With Rheumatic Fever And Rheumatic Heart Disease Low,
  "has_systems_for_follow_up_recall_to_deliver_long_term__ae90dcbc" VARCHAR  -- Has Systems For Follow Up Recall To Deliver Long Term Penicillin Prophylaxis To Patients With Rheumatic Fever And Rheumatic Heart Disease High,
  "comments" VARCHAR
);

CREATE TABLE owid_has_systems_for_follow_up_recall_to_deliver_long__aa4b023e (
  "year" INTEGER,
  "country" VARCHAR,
  "has_systems_for_follow_up_recall_to_deliver_long_term__edd99034" VARCHAR  -- Has Systems For Follow Up Recall To Deliver Long Term Penicillin Prophylaxis To Patients With Rheumatic Fever And Rheumatic Heart Disease
);

CREATE TABLE owid_healthcare_staff_in_prisons_ftes_per_1000_prisoners_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "healthcare_staff_in_prisons_ftes_per_1000_prisoners" FLOAT  -- Healthcare Staff In Prisons, Ftes Per 1000 Prisoners
);

CREATE TABLE owid_healthcare_staff_in_prisons_ftes_per_1000_prisoners_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "healthcare_staff_in_prisons_ftes_per_1000_prisoners" FLOAT  -- Healthcare Staff In Prisons, Ftes Per 1000 Prisoners,
  "healthcare_staff_in_prisons_ftes_per_1000_prisoners_low" VARCHAR  -- Healthcare Staff In Prisons, Ftes Per 1000 Prisoners Low,
  "healthcare_staff_in_prisons_ftes_per_1000_prisoners_high" VARCHAR  -- Healthcare Staff In Prisons, Ftes Per 1000 Prisoners High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_professionals_mostly_involved_in_treatment_7c118bf1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_type_disorders" VARCHAR,
  "health_professionals_mostly_involved_in_treatment_of_s_5e6823fb" VARCHAR  -- Health Professionals Mostly Involved In Treatment Of Substance Use Disorders
);

CREATE TABLE owid_health_professionals_mostly_involved_in_treatment_c5412050 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_type_disorders" VARCHAR,
  "health_professionals_mostly_involved_in_treatment_of_s_5e6823fb" VARCHAR  -- Health Professionals Mostly Involved In Treatment Of Substance Use Disorders,
  "health_professionals_mostly_involved_in_treatment_of_s_d4985034" VARCHAR  -- Health Professionals Mostly Involved In Treatment Of Substance Use Disorders Low,
  "health_professionals_mostly_involved_in_treatment_of_s_27a3cf07" VARCHAR  -- Health Professionals Mostly Involved In Treatment Of Substance Use Disorders High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_professionals_providing_treatment_for_alco_8ec8c410 (
  "year" INTEGER,
  "country" VARCHAR,
  "human_resources_health_workforce" VARCHAR  -- Human Resources, Health Workforce,
  "health_professionals_providing_treatment_for_alcohol_a_f00bf532" VARCHAR  -- Health Professionals Providing Treatment For Alcohol And Drug Use Disorders
);

CREATE TABLE owid_health_professionals_providing_treatment_for_alco_bfbfd284 (
  "year" INTEGER,
  "country" VARCHAR,
  "human_resources_health_workforce" VARCHAR  -- Human Resources, Health Workforce,
  "health_professionals_providing_treatment_for_alcohol_a_f00bf532" VARCHAR  -- Health Professionals Providing Treatment For Alcohol And Drug Use Disorders,
  "health_professionals_providing_treatment_for_alcohol_a_69e75aef" VARCHAR  -- Health Professionals Providing Treatment For Alcohol And Drug Use Disorders Low,
  "health_professionals_providing_treatment_for_alcohol_a_94185ec3" VARCHAR  -- Health Professionals Providing Treatment For Alcohol And Drug Use Disorders High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_service_provision (
  "year" INTEGER,
  "country" VARCHAR,
  "ihr_spar_capacity_level" VARCHAR,
  "health_service_provision" INTEGER
);

CREATE TABLE owid_health_technology_medical_device_national_policy_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_technology_medical_device_national_policy" INTEGER  -- Health Technology, Medical Device, National Policy,
  "comments" VARCHAR
);

CREATE TABLE owid_health_technology_medical_device_national_policy_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_technology_medical_device_national_policy" INTEGER  -- Health Technology, Medical Device, National Policy,
  "health_technology_medical_device_national_policy_low" VARCHAR  -- Health Technology, Medical Device, National Policy Low,
  "health_technology_medical_device_national_policy_high" VARCHAR  -- Health Technology, Medical Device, National Policy High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warning_labels_on_alcohol_advertising_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warning_labels_on_alcohol_advertising" VARCHAR
);

CREATE TABLE owid_health_warning_labels_on_alcohol_advertising_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warning_labels_on_alcohol_advertising" VARCHAR,
  "health_warning_labels_on_alcohol_advertising_low" VARCHAR,
  "health_warning_labels_on_alcohol_advertising_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warning_labels_on_alcohol_containers_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warning_labels_on_alcohol_containers" VARCHAR
);

CREATE TABLE owid_health_warning_labels_on_alcohol_containers_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warning_labels_on_alcohol_containers" VARCHAR,
  "health_warning_labels_on_alcohol_containers_low" VARCHAR,
  "health_warning_labels_on_alcohol_containers_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warning_labels_on_drink_driving_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warning_labels_on_drink_driving" VARCHAR
);

CREATE TABLE owid_health_warning_labels_on_drink_driving_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warning_labels_on_drink_driving" VARCHAR,
  "health_warning_labels_on_drink_driving_low" VARCHAR,
  "health_warning_labels_on_drink_driving_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warning_labels_on_pregnancy_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warning_labels_on_pregnancy" VARCHAR
);