Global Health Observatory - World Health Organization

CREATE TABLE owid_interventions_projects_actively_involving_young_p_3543a23b (
  "year" INTEGER,
  "country" VARCHAR,
  "interventions_projects_actively_involving_young_people_9f84d65c" VARCHAR  -- Interventions Projects Actively Involving Young People And Civil Society
);

CREATE TABLE owid_interventions_projects_actively_involving_young_p_83dec55c (
  "year" INTEGER,
  "country" VARCHAR,
  "interventions_projects_actively_involving_young_people_9f84d65c" VARCHAR  -- Interventions Projects Actively Involving Young People And Civil Society,
  "interventions_projects_actively_involving_young_people_ad1c06a8" VARCHAR  -- Interventions Projects Actively Involving Young People And Civil Society Low,
  "interventions_projects_actively_involving_young_people_305be0ea" VARCHAR  -- Interventions Projects Actively Involving Young People And Civil Society High,
  "comments" VARCHAR
);

CREATE TABLE owid_interventions_projects_training_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "interventions_projects_training" VARCHAR  -- Interventions, Projects, Training
);

CREATE TABLE owid_interventions_projects_training_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "interventions_projects_training" VARCHAR  -- Interventions, Projects, Training,
  "interventions_projects_training_low" VARCHAR  -- Interventions, Projects, Training Low,
  "interventions_projects_training_high" VARCHAR  -- Interventions, Projects, Training High,
  "comments" VARCHAR
);

CREATE TABLE owid_intimate_partner_violence_extent_of_implementatio_16dcf549 (
  "year" INTEGER,
  "country" VARCHAR,
  "intimate_partner_violence_extent_of_implementation_of__2774564d" VARCHAR  -- Intimate Partner Violence, Extent Of Implementation Of Dating Violence Prevention Programmes,
  "intimate_partner_violence_extent_of_implementation_of__010cb5f6" VARCHAR  -- Intimate Partner Violence, Extent Of Implementation Of Dating Violence Prevention Programmes Low,
  "intimate_partner_violence_extent_of_implementation_of__304cea6d" VARCHAR  -- Intimate Partner Violence, Extent Of Implementation Of Dating Violence Prevention Programmes High,
  "comments" VARCHAR
);

CREATE TABLE owid_intimate_partner_violence_extent_of_implementatio_71fd29a1 (
  "year" INTEGER,
  "country" VARCHAR,
  "intimate_partner_violence_extent_of_implementation_of__2774564d" VARCHAR  -- Intimate Partner Violence, Extent Of Implementation Of Dating Violence Prevention Programmes
);

CREATE TABLE owid_intimate_partner_violence_prevalence_among_ever_p_81aa873d (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "intimate_partner_violence_prevalence_among_ever_partne_90ca7cef" FLOAT  -- Intimate Partner Violence Prevalence Among Ever Partnered Women, Pct,
  "intimate_partner_violence_prevalence_among_ever_partne_e7cc0656" FLOAT  -- Intimate Partner Violence Prevalence Among Ever Partnered Women, Pct Low,
  "intimate_partner_violence_prevalence_among_ever_partne_d00baba8" FLOAT  -- Intimate Partner Violence Prevalence Among Ever Partnered Women, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_introduction_of_solid_semi_solid_or_soft_foods_6__aad4e13f (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "household_wealth" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "education_level" VARCHAR,
  "introduction_of_solid_semi_solid_or_soft_foods_6_8_months" FLOAT  -- Introduction Of Solid, Semi Solid Or Soft Foods 6–8 Months,
  "introduction_of_solid_semi_solid_or_soft_foods_6_8_months_low" FLOAT  -- Introduction Of Solid, Semi Solid Or Soft Foods 6–8 Months Low,
  "introduction_of_solid_semi_solid_or_soft_foods_6_8_months_high" FLOAT  -- Introduction Of Solid, Semi Solid Or Soft Foods 6–8 Months High,
  "comments" VARCHAR
);

CREATE TABLE owid_introduction_of_solid_semi_solid_or_soft_foods_6__ae7de4ef (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mothers_education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "household_wealth" VARCHAR,
  "introduction_of_solid_semi_solid_or_soft_foods_6_8_months" FLOAT  -- Introduction Of Solid, Semi Solid Or Soft Foods 6–8 Months,
  "comments" VARCHAR
);

CREATE TABLE owid_involvement_of_representatives_of_affected_or_tar_0e29bfb9 (
  "year" INTEGER,
  "country" VARCHAR,
  "representatives" VARCHAR,
  "involvement_of_representatives_of_affected_or_targeted_e23ee0d7" VARCHAR  -- Involvement Of Representatives Of Affected Or Targeted Populations In The Development And Formulation Of Policies And Strategies For Prevention For Alcohol And Drugs
);

CREATE TABLE owid_involvement_of_representatives_of_affected_or_tar_13558068 (
  "year" INTEGER,
  "country" VARCHAR,
  "representatives" VARCHAR,
  "involvement_of_representatives_of_affected_or_targeted_e23ee0d7" VARCHAR  -- Involvement Of Representatives Of Affected Or Targeted Populations In The Development And Formulation Of Policies And Strategies For Prevention For Alcohol And Drugs,
  "involvement_of_representatives_of_affected_or_targeted_6cb110d0" VARCHAR  -- Involvement Of Representatives Of Affected Or Targeted Populations In The Development And Formulation Of Policies And Strategies For Prevention For Alcohol And Drugs Low,
  "involvement_of_representatives_of_affected_or_targeted_bbb17f96" VARCHAR  -- Involvement Of Representatives Of Affected Or Targeted Populations In The Development And Formulation Of Policies And Strategies For Prevention For Alcohol And Drugs High,
  "comments" VARCHAR
);

CREATE TABLE owid_involvement_of_representatives_of_affected_or_tar_65e10156 (
  "year" INTEGER,
  "country" VARCHAR,
  "representatives" VARCHAR,
  "involvement_of_representatives_of_affected_or_targeted_b2f9691d" VARCHAR  -- Involvement Of Representatives Of Affected Or Targeted Populations In The Development And Implementation Of National Programmes For Prevention For Alcohol And Drugs,
  "involvement_of_representatives_of_affected_or_targeted_4de7da3d" VARCHAR  -- Involvement Of Representatives Of Affected Or Targeted Populations In The Development And Implementation Of National Programmes For Prevention For Alcohol And Drugs Low,
  "involvement_of_representatives_of_affected_or_targeted_43f455fa" VARCHAR  -- Involvement Of Representatives Of Affected Or Targeted Populations In The Development And Implementation Of National Programmes For Prevention For Alcohol And Drugs High,
  "comments" VARCHAR
);

CREATE TABLE owid_involvement_of_representatives_of_affected_or_tar_65ffe898 (
  "year" INTEGER,
  "country" VARCHAR,
  "representatives" VARCHAR,
  "involvement_of_representatives_of_affected_or_targeted_24a9b891" VARCHAR  -- Involvement Of Representatives Of Affected Or Targeted Populations In The Development And Formulation Of Policies And Strategies For Treatment Of Substance Use Disorders,
  "involvement_of_representatives_of_affected_or_targeted_8f34a708" VARCHAR  -- Involvement Of Representatives Of Affected Or Targeted Populations In The Development And Formulation Of Policies And Strategies For Treatment Of Substance Use Disorders Low,
  "involvement_of_representatives_of_affected_or_targeted_3f535f79" VARCHAR  -- Involvement Of Representatives Of Affected Or Targeted Populations In The Development And Formulation Of Policies And Strategies For Treatment Of Substance Use Disorders High,
  "comments" VARCHAR
);

CREATE TABLE owid_involvement_of_representatives_of_affected_or_tar_755d0f1b (
  "year" INTEGER,
  "country" VARCHAR,
  "representatives" VARCHAR,
  "involvement_of_representatives_of_affected_or_targeted_96c3c02c" VARCHAR  -- Involvement Of Representatives Of Affected Or Targeted Populations In The Development And Implementation Of National Programmes For Treatment Of Substance Use Disorders,
  "involvement_of_representatives_of_affected_or_targeted_d7e9e8ea" VARCHAR  -- Involvement Of Representatives Of Affected Or Targeted Populations In The Development And Implementation Of National Programmes For Treatment Of Substance Use Disorders Low,
  "involvement_of_representatives_of_affected_or_targeted_c4f7728f" VARCHAR  -- Involvement Of Representatives Of Affected Or Targeted Populations In The Development And Implementation Of National Programmes For Treatment Of Substance Use Disorders High,
  "comments" VARCHAR
);

CREATE TABLE owid_involvement_of_representatives_of_affected_or_tar_a2018eca (
  "year" INTEGER,
  "country" VARCHAR,
  "representatives" VARCHAR,
  "involvement_of_representatives_of_affected_or_targeted_96c3c02c" VARCHAR  -- Involvement Of Representatives Of Affected Or Targeted Populations In The Development And Implementation Of National Programmes For Treatment Of Substance Use Disorders
);

CREATE TABLE owid_involvement_of_representatives_of_affected_or_tar_eee0446f (
  "year" INTEGER,
  "country" VARCHAR,
  "representatives" VARCHAR,
  "involvement_of_representatives_of_affected_or_targeted_24a9b891" VARCHAR  -- Involvement Of Representatives Of Affected Or Targeted Populations In The Development And Formulation Of Policies And Strategies For Treatment Of Substance Use Disorders
);

CREATE TABLE owid_involvement_of_representatives_of_affected_or_tar_fd809021 (
  "year" INTEGER,
  "country" VARCHAR,
  "representatives" VARCHAR,
  "involvement_of_representatives_of_affected_or_targeted_b2f9691d" VARCHAR  -- Involvement Of Representatives Of Affected Or Targeted Populations In The Development And Implementation Of National Programmes For Prevention For Alcohol And Drugs
);

CREATE TABLE owid_japanese_encephalitis_number_of_reported_cases_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "japanese_encephalitis_number_of_reported_cases" INTEGER  -- Japanese Encephalitis, Number Of Reported Cases
);

CREATE TABLE owid_japanese_encephalitis_number_of_reported_cases_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "japanese_encephalitis_number_of_reported_cases" INTEGER  -- Japanese Encephalitis, Number Of Reported Cases,
  "japanese_encephalitis_number_of_reported_cases_low" VARCHAR  -- Japanese Encephalitis, Number Of Reported Cases Low,
  "japanese_encephalitis_number_of_reported_cases_high" VARCHAR  -- Japanese Encephalitis, Number Of Reported Cases High,
  "comments" VARCHAR
);

CREATE TABLE owid_joint_effects_of_air_pollution_attributable_deaths (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "ghe_cause_of_death_codes" VARCHAR,
  "joint_effects_of_air_pollution_attributable_deaths" FLOAT,
  "joint_effects_of_air_pollution_attributable_deaths_low" FLOAT,
  "joint_effects_of_air_pollution_attributable_deaths_high" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_laboratories_providing_drug_susceptibility_testin_3522b5a9 (
  "year" INTEGER,
  "country" VARCHAR,
  "laboratories_providing_drug_susceptibility_testing_dst_799b6d42" FLOAT  -- Laboratories Providing Drug Susceptibility Testing, Dst, Per 5 Million Population
);

CREATE TABLE owid_laboratories_providing_drug_susceptibility_testin_461b4824 (
  "year" INTEGER,
  "country" VARCHAR,
  "laboratories_providing_drug_susceptibility_testing_dst_799b6d42" FLOAT  -- Laboratories Providing Drug Susceptibility Testing, Dst, Per 5 Million Population,
  "laboratories_providing_drug_susceptibility_testing_dst_cf81bbe6" VARCHAR  -- Laboratories Providing Drug Susceptibility Testing, Dst, Per 5 Million Population Low,
  "laboratories_providing_drug_susceptibility_testing_dst_560377d3" VARCHAR  -- Laboratories Providing Drug Susceptibility Testing, Dst, Per 5 Million Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_laboratories_providing_tuberculosis_diagnostic_se_8a9623e9 (
  "year" INTEGER,
  "country" VARCHAR,
  "laboratories_providing_tuberculosis_diagnostic_service_dde4e51a" FLOAT  -- Laboratories Providing Tuberculosis Diagnostic Services Using Sputum Smear Microscopy, Per 100–000 Population,
  "laboratories_providing_tuberculosis_diagnostic_service_34ed0650" VARCHAR  -- Laboratories Providing Tuberculosis Diagnostic Services Using Sputum Smear Microscopy, Per 100–000 Population Low,
  "laboratories_providing_tuberculosis_diagnostic_service_5d27ba9b" VARCHAR  -- Laboratories Providing Tuberculosis Diagnostic Services Using Sputum Smear Microscopy, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_laboratories_providing_tuberculosis_diagnostic_se_b5e22f21 (
  "year" INTEGER,
  "country" VARCHAR,
  "laboratories_providing_tuberculosis_diagnostic_service_80b32c39" FLOAT  -- Laboratories Providing Tuberculosis Diagnostic Services Using Culture, Per 5 Million Population
);

CREATE TABLE owid_laboratories_providing_tuberculosis_diagnostic_se_c3b62b80 (
  "year" INTEGER,
  "country" VARCHAR,
  "laboratories_providing_tuberculosis_diagnostic_service_80b32c39" FLOAT  -- Laboratories Providing Tuberculosis Diagnostic Services Using Culture, Per 5 Million Population,
  "laboratories_providing_tuberculosis_diagnostic_service_6205b09f" VARCHAR  -- Laboratories Providing Tuberculosis Diagnostic Services Using Culture, Per 5 Million Population Low,
  "laboratories_providing_tuberculosis_diagnostic_service_6dccd481" VARCHAR  -- Laboratories Providing Tuberculosis Diagnostic Services Using Culture, Per 5 Million Population High,
  "comments" VARCHAR
);