Global Health Observatory - World Health Organization

CREATE TABLE owid_number_of_new_leprosy_cases_among_children_less_t_8167f828 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_new_leprosy_cases_among_children_less_than_1_22926280" INTEGER  -- Number Of New Leprosy Cases Among Children, Less Than 15 Years Of Age
);

CREATE TABLE owid_number_of_new_leprosy_cases_among_children_less_t_acee588e (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_new_leprosy_cases_among_children_less_than_1_22926280" INTEGER  -- Number Of New Leprosy Cases Among Children, Less Than 15 Years Of Age,
  "number_of_new_leprosy_cases_among_children_less_than_1_8f7a9cbd" VARCHAR  -- Number Of New Leprosy Cases Among Children, Less Than 15 Years Of Age Low,
  "number_of_new_leprosy_cases_among_children_less_than_1_200da4ef" VARCHAR  -- Number Of New Leprosy Cases Among Children, Less Than 15 Years Of Age High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_new_leprosy_cases_among_females_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_new_leprosy_cases_among_females" INTEGER
);

CREATE TABLE owid_number_of_new_leprosy_cases_among_females_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_new_leprosy_cases_among_females" INTEGER,
  "number_of_new_leprosy_cases_among_females_low" VARCHAR,
  "number_of_new_leprosy_cases_among_females_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_new_leprosy_cases_with_g2d_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_new_leprosy_cases_with_g2d" INTEGER
);

CREATE TABLE owid_number_of_new_leprosy_cases_with_g2d_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_new_leprosy_cases_with_g2d" INTEGER,
  "number_of_new_leprosy_cases_with_g2d_low" VARCHAR,
  "number_of_new_leprosy_cases_with_g2d_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_new_leprosy_cases_with_g2d_among_childr_01c8b1ab (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_new_leprosy_cases_with_g2d_among_children_le_cf81605f" INTEGER  -- Number Of New Leprosy Cases With G2d Among Children, Less Than 15 Years Of Age
);

CREATE TABLE owid_number_of_new_leprosy_cases_with_g2d_among_childr_e271debc (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_new_leprosy_cases_with_g2d_among_children_le_cf81605f" INTEGER  -- Number Of New Leprosy Cases With G2d Among Children, Less Than 15 Years Of Age,
  "number_of_new_leprosy_cases_with_g2d_among_children_le_a3975871" VARCHAR  -- Number Of New Leprosy Cases With G2d Among Children, Less Than 15 Years Of Age Low,
  "number_of_new_leprosy_cases_with_g2d_among_children_le_188aae8f" VARCHAR  -- Number Of New Leprosy Cases With G2d Among Children, Less Than 15 Years Of Age High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_new_reported_cases_of_buruli_ulcer_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_new_reported_cases_of_buruli_ulcer" INTEGER
);

CREATE TABLE owid_number_of_new_reported_cases_of_buruli_ulcer_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_new_reported_cases_of_buruli_ulcer" INTEGER,
  "number_of_new_reported_cases_of_buruli_ulcer_low" VARCHAR,
  "number_of_new_reported_cases_of_buruli_ulcer_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_new_reported_cases_of_human_african_try_06320736 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_new_reported_cases_of_human_african_trypanos_0096bcd8" INTEGER  -- Number Of New Reported Cases Of Human African Trypanosomiasis, T B, Gambiense,
  "number_of_new_reported_cases_of_human_african_trypanos_5139fd1b" VARCHAR  -- Number Of New Reported Cases Of Human African Trypanosomiasis, T B, Gambiense Low,
  "number_of_new_reported_cases_of_human_african_trypanos_9530dc9c" VARCHAR  -- Number Of New Reported Cases Of Human African Trypanosomiasis, T B, Gambiense High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_new_reported_cases_of_human_african_try_225562b0 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_new_reported_cases_of_human_african_trypanos_1943de11" INTEGER  -- Number Of New Reported Cases Of Human African Trypanosomiasis, T B, Rhodesiense
);

CREATE TABLE owid_number_of_new_reported_cases_of_human_african_try_a9cbe2f7 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_new_reported_cases_of_human_african_trypanos_1943de11" INTEGER  -- Number Of New Reported Cases Of Human African Trypanosomiasis, T B, Rhodesiense,
  "number_of_new_reported_cases_of_human_african_trypanos_ae572ff9" VARCHAR  -- Number Of New Reported Cases Of Human African Trypanosomiasis, T B, Rhodesiense Low,
  "number_of_new_reported_cases_of_human_african_trypanos_eb373107" VARCHAR  -- Number Of New Reported Cases Of Human African Trypanosomiasis, T B, Rhodesiense High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_new_reported_cases_of_human_african_try_e5f7be15 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_new_reported_cases_of_human_african_trypanos_0096bcd8" INTEGER  -- Number Of New Reported Cases Of Human African Trypanosomiasis, T B, Gambiense
);

CREATE TABLE owid_number_of_non_pregnant_women_aged_15_49_years_wit_35830f18 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "severity" VARCHAR,
  "number_of_non_pregnant_women_aged_15_49_years_with_ana_49977c9d" FLOAT  -- Number Of Non Pregnant Women, Aged 15–49 Years, With Anaemia, Thousands,
  "number_of_non_pregnant_women_aged_15_49_years_with_ana_66bbc4ed" FLOAT  -- Number Of Non Pregnant Women, Aged 15–49 Years, With Anaemia, Thousands Low,
  "number_of_non_pregnant_women_aged_15_49_years_with_ana_824887de" FLOAT  -- Number Of Non Pregnant Women, Aged 15–49 Years, With Anaemia, Thousands High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_non_pregnant_women_aged_15_49_years_wit_92f24555 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "severity" VARCHAR,
  "number_of_non_pregnant_women_aged_15_49_years_with_ana_49977c9d" FLOAT  -- Number Of Non Pregnant Women, Aged 15–49 Years, With Anaemia, Thousands
);

CREATE TABLE owid_number_of_people_all_ages_living_with_hiv_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_people_all_ages_living_with_hiv" UINTEGER  -- Number Of People, All Ages, Living With Hiv
);

CREATE TABLE owid_number_of_people_all_ages_living_with_hiv_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_people_all_ages_living_with_hiv" UINTEGER  -- Number Of People, All Ages, Living With Hiv,
  "number_of_people_all_ages_living_with_hiv_low" UINTEGER  -- Number Of People, All Ages, Living With Hiv Low,
  "number_of_people_all_ages_living_with_hiv_high" UINTEGER  -- Number Of People, All Ages, Living With Hiv High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_people_dying_of_hiv_related_causes_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_people_dying_of_hiv_related_causes" UINTEGER
);

CREATE TABLE owid_number_of_people_dying_of_hiv_related_causes_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_people_dying_of_hiv_related_causes" UINTEGER,
  "number_of_people_dying_of_hiv_related_causes_low" UINTEGER,
  "number_of_people_dying_of_hiv_related_causes_high" UINTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_people_newly_admitted_to_prison_per_100_0f3e4eff (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_people_newly_admitted_to_prison_per_100_000__bbce6680" FLOAT  -- Number Of People Newly Admitted To Prison, Per 100–000 Inhabitants
);

CREATE TABLE owid_number_of_people_newly_admitted_to_prison_per_100_de38a7fa (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_people_newly_admitted_to_prison_per_100_000__bbce6680" FLOAT  -- Number Of People Newly Admitted To Prison, Per 100–000 Inhabitants,
  "number_of_people_newly_admitted_to_prison_per_100_000__e24ae1c6" VARCHAR  -- Number Of People Newly Admitted To Prison, Per 100–000 Inhabitants Low,
  "number_of_people_newly_admitted_to_prison_per_100_000__b97ec7a7" VARCHAR  -- Number Of People Newly Admitted To Prison, Per 100–000 Inhabitants High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_people_operated_for_trachomatous_trichiasis_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "number_of_people_operated_for_trachomatous_trichiasis" UINTEGER
);

CREATE TABLE owid_number_of_people_operated_for_trachomatous_trichiasis_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "number_of_people_operated_for_trachomatous_trichiasis" UINTEGER,
  "number_of_people_operated_for_trachomatous_trichiasis_low" VARCHAR,
  "number_of_people_operated_for_trachomatous_trichiasis_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_people_protected_from_malaria_by_indoor_6e2fbe41 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_people_protected_from_malaria_by_indoor_resi_60579390" UINTEGER  -- Number Of People Protected From Malaria By Indoor Residual Spraying, Irs,
  "number_of_people_protected_from_malaria_by_indoor_resi_a6aa50d1" VARCHAR  -- Number Of People Protected From Malaria By Indoor Residual Spraying, Irs Low,
  "number_of_people_protected_from_malaria_by_indoor_resi_856a5e88" VARCHAR  -- Number Of People Protected From Malaria By Indoor Residual Spraying, Irs High,
  "comments" VARCHAR
);