Global Health Observatory - World Health Organization

CREATE TABLE owid_hepatitis_b_surface_antigen_hbsag_prevalence_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" VARCHAR,
  "population_type" VARCHAR,
  "hepatitis_b_surface_antigen_hbsag_prevalence" FLOAT  -- Hepatitis B Surface Antigen, Hbsag, Prevalence,
  "hepatitis_b_surface_antigen_hbsag_prevalence_low" FLOAT  -- Hepatitis B Surface Antigen, Hbsag, Prevalence Low,
  "hepatitis_b_surface_antigen_hbsag_prevalence_high" FLOAT  -- Hepatitis B Surface Antigen, Hbsag, Prevalence High,
  "comments" VARCHAR
);

CREATE TABLE owid_hib_hib3_immunization_coverage_among_1_year_olds_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "hib_hib3_immunization_coverage_among_1_year_olds_pct" INTEGER  -- Hib, Hib3, Immunization Coverage Among 1 Year Olds, Pct
);

CREATE TABLE owid_hib_hib3_immunization_coverage_among_1_year_olds_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "hib_hib3_immunization_coverage_among_1_year_olds_pct" INTEGER  -- Hib, Hib3, Immunization Coverage Among 1 Year Olds, Pct,
  "hib_hib3_immunization_coverage_among_1_year_olds_pct_low" VARCHAR  -- Hib, Hib3, Immunization Coverage Among 1 Year Olds, Pct Low,
  "hib_hib3_immunization_coverage_among_1_year_olds_pct_high" VARCHAR  -- Hib, Hib3, Immunization Coverage Among 1 Year Olds, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_hiv_hepatitis_counselling_and_treatment_availabil_ab23b804 (
  "year" INTEGER,
  "country" VARCHAR,
  "hiv_hepatitis_counselling_and_treatment" VARCHAR  -- Hiv, Hepatitis Counselling And Treatment,
  "hiv_hepatitis_counselling_and_treatment_availability_i_ca435060" VARCHAR  -- Hiv, Hepatitis Counselling And Treatment Availability In Specialized Facilities And Services
);

CREATE TABLE owid_hiv_hepatitis_counselling_and_treatment_availabil_b91b41ee (
  "year" INTEGER,
  "country" VARCHAR,
  "hiv_hepatitis_counselling_and_treatment" VARCHAR  -- Hiv, Hepatitis Counselling And Treatment,
  "hiv_hepatitis_counselling_and_treatment_availability_i_ca435060" VARCHAR  -- Hiv, Hepatitis Counselling And Treatment Availability In Specialized Facilities And Services,
  "hiv_hepatitis_counselling_and_treatment_availability_i_91419f7a" VARCHAR  -- Hiv, Hepatitis Counselling And Treatment Availability In Specialized Facilities And Services Low,
  "hiv_hepatitis_counselling_and_treatment_availability_i_fb0a3e36" VARCHAR  -- Hiv, Hepatitis Counselling And Treatment Availability In Specialized Facilities And Services High,
  "comments" VARCHAR
);

CREATE TABLE owid_hiv_positive_tb_patients_on_art_antiretroviral_th_6d2ad1a1 (
  "year" INTEGER,
  "country" VARCHAR,
  "hiv_positive_tb_patients_on_art_antiretroviral_therapy_pct" FLOAT  -- Hiv Positive Tb Patients On Art, Antiretroviral Therapy, Pct,
  "hiv_positive_tb_patients_on_art_antiretroviral_therapy_pct_low" VARCHAR  -- Hiv Positive Tb Patients On Art, Antiretroviral Therapy, Pct Low,
  "hiv_positive_tb_patients_on_art_antiretroviral_therapy_pct_high" VARCHAR  -- Hiv Positive Tb Patients On Art, Antiretroviral Therapy, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_hiv_positive_tb_patients_on_art_antiretroviral_th_a5a84ebc (
  "year" INTEGER,
  "country" VARCHAR,
  "hiv_positive_tb_patients_on_art_antiretroviral_therapy_pct" FLOAT  -- Hiv Positive Tb Patients On Art, Antiretroviral Therapy, Pct
);

CREATE TABLE owid_hiv_positive_tb_patients_on_cpt_co_trimoxazole_pr_7ce678b5 (
  "year" INTEGER,
  "country" VARCHAR,
  "hiv_positive_tb_patients_on_cpt_co_trimoxazole_prevent_2e91ec3f" FLOAT  -- Hiv Positive Tb Patients On Cpt, Co Trimoxazole Preventive Therapy, Pct
);

CREATE TABLE owid_hiv_positive_tb_patients_on_cpt_co_trimoxazole_pr_8bb18444 (
  "year" INTEGER,
  "country" VARCHAR,
  "hiv_positive_tb_patients_on_cpt_co_trimoxazole_prevent_2e91ec3f" FLOAT  -- Hiv Positive Tb Patients On Cpt, Co Trimoxazole Preventive Therapy, Pct,
  "hiv_positive_tb_patients_on_cpt_co_trimoxazole_prevent_8c33ad0a" VARCHAR  -- Hiv Positive Tb Patients On Cpt, Co Trimoxazole Preventive Therapy, Pct Low,
  "hiv_positive_tb_patients_on_cpt_co_trimoxazole_prevent_470d57fe" VARCHAR  -- Hiv Positive Tb Patients On Cpt, Co Trimoxazole Preventive Therapy, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_hospice_centre_beds_per_10_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "hospice_centre_beds_per_10_000_population" INTEGER  -- Hospice Centre Beds, Per 10–000 Population
);

CREATE TABLE owid_hospice_centre_beds_per_10_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "hospice_centre_beds_per_10_000_population" INTEGER  -- Hospice Centre Beds, Per 10–000 Population,
  "hospice_centre_beds_per_10_000_population_low" VARCHAR  -- Hospice Centre Beds, Per 10–000 Population Low,
  "hospice_centre_beds_per_10_000_population_high" VARCHAR  -- Hospice Centre Beds, Per 10–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_hospital_beds_per_10_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "hospital_beds_per_10_000_population" FLOAT  -- Hospital Beds, Per 10–000 Population,
  "comments" VARCHAR
);

CREATE TABLE owid_hospital_beds_per_10_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "hospital_beds_per_10_000_population" FLOAT  -- Hospital Beds, Per 10–000 Population,
  "hospital_beds_per_10_000_population_low" VARCHAR  -- Hospital Beds, Per 10–000 Population Low,
  "hospital_beds_per_10_000_population_high" VARCHAR  -- Hospital Beds, Per 10–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_hospital_discharges_alcoholic_liver_disease_per_100_000_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "hospital_discharges_alcoholic_liver_disease_per_100_000" INTEGER  -- Hospital Discharges, Alcoholic Liver Disease, Per 100–000
);

CREATE TABLE owid_hospital_discharges_alcoholic_liver_disease_per_100_000_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "hospital_discharges_alcoholic_liver_disease_per_100_000" INTEGER  -- Hospital Discharges, Alcoholic Liver Disease, Per 100–000,
  "hospital_discharges_alcoholic_liver_disease_per_100_000_low" VARCHAR  -- Hospital Discharges, Alcoholic Liver Disease, Per 100–000 Low,
  "hospital_discharges_alcoholic_liver_disease_per_100_000_high" VARCHAR  -- Hospital Discharges, Alcoholic Liver Disease, Per 100–000 High,
  "comments" VARCHAR
);

CREATE TABLE owid_hospital_discharges_alcohol_related_injuries_and__4ef36cd5 (
  "year" INTEGER,
  "country" VARCHAR,
  "hospital_discharges_alcohol_related_injuries_and_poiso_1964d3e6" FLOAT  -- Hospital Discharges, Alcohol Related Injuries And Poisoning, Per 100–000,
  "hospital_discharges_alcohol_related_injuries_and_poiso_36452d31" VARCHAR  -- Hospital Discharges, Alcohol Related Injuries And Poisoning, Per 100–000 Low,
  "hospital_discharges_alcohol_related_injuries_and_poiso_5e65d3d2" VARCHAR  -- Hospital Discharges, Alcohol Related Injuries And Poisoning, Per 100–000 High,
  "comments" VARCHAR
);

CREATE TABLE owid_hospital_discharges_alcohol_related_injuries_and__e8cfba27 (
  "year" INTEGER,
  "country" VARCHAR,
  "hospital_discharges_alcohol_related_injuries_and_poiso_1964d3e6" FLOAT  -- Hospital Discharges, Alcohol Related Injuries And Poisoning, Per 100–000
);

CREATE TABLE owid_household_air_pollution_attributable_dalys_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "cause" VARCHAR,
  "household_air_pollution_attributable_dalys" FLOAT
);

CREATE TABLE owid_household_air_pollution_attributable_dalys_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "ghe_cause_of_death_codes" VARCHAR,
  "household_air_pollution_attributable_dalys" FLOAT,
  "household_air_pollution_attributable_dalys_low" FLOAT,
  "household_air_pollution_attributable_dalys_high" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_household_air_pollution_attributable_dalys_in_chi_1f2a5088 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "cause" VARCHAR,
  "household_air_pollution_attributable_dalys_in_children_2173fc11" FLOAT  -- Household Air Pollution Attributable Dalys In Children Under 15 Years,
  "household_air_pollution_attributable_dalys_in_children_d6c9369c" FLOAT  -- Household Air Pollution Attributable Dalys In Children Under 15 Years Low,
  "household_air_pollution_attributable_dalys_in_children_82b4c7aa" FLOAT  -- Household Air Pollution Attributable Dalys In Children Under 15 Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_household_air_pollution_attributable_dalys_in_chi_73b50323 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "cause" VARCHAR,
  "household_air_pollution_attributable_dalys_in_children_5c79f5bd" FLOAT  -- Household Air Pollution Attributable Dalys In Children Under 5 Years
);

CREATE TABLE owid_household_air_pollution_attributable_dalys_in_chi_ab00d0ce (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "cause" VARCHAR,
  "household_air_pollution_attributable_dalys_in_children_2173fc11" FLOAT  -- Household Air Pollution Attributable Dalys In Children Under 15 Years
);

CREATE TABLE owid_household_air_pollution_attributable_dalys_in_chi_de54b9cc (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "cause" VARCHAR,
  "household_air_pollution_attributable_dalys_in_children_5c79f5bd" FLOAT  -- Household Air Pollution Attributable Dalys In Children Under 5 Years,
  "household_air_pollution_attributable_dalys_in_children_48b7c3dd" FLOAT  -- Household Air Pollution Attributable Dalys In Children Under 5 Years Low,
  "household_air_pollution_attributable_dalys_in_children_781aeebe" FLOAT  -- Household Air Pollution Attributable Dalys In Children Under 5 Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_household_air_pollution_attributable_dalys_per_10_632b66cd (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "cause" VARCHAR,
  "household_air_pollution_attributable_dalys_per_100_000_86e33d36" FLOAT  -- Household Air Pollution Attributable Dalys, Per 100–000, Age Standardized
);

CREATE TABLE owid_household_air_pollution_attributable_dalys_per_10_750f45a2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "cause" VARCHAR,
  "household_air_pollution_attributable_dalys_per_100_000_32bcc9c8" FLOAT  -- Household Air Pollution Attributable Dalys, Per 100–000 Population
);