About this Dataset

Global Health Observatory - World Health Organization

The GHO data repository is WHO's gateway to health-related statistics for its 194 Member States. It provides access to over 1000 indicators on priority health topics including mortality and burden of diseases, the Millennium Development Goals (child nutrition, child health, maternal and reproductive health, immunization, HIV/AIDS, tuberculosis, malaria, neglected diseases, water and sanitation), non communicable diseases and risk factors, epidemic-prone diseases, health systems, environmental health, violence and injuries, equity among others.

Tables

New Cases: Extrapulmonary

@owid.gho.owid_new_cases_extrapulmonary

21.83 kB
4,268 rows
3 columns

CREATE TABLE owid_new_cases_extrapulmonary (
  "year" INTEGER,
  "country" VARCHAR,
  "new_cases_extrapulmonary" UINTEGER  -- New Cases, Extrapulmonary
);

New Cases: Other

@owid.gho.owid_new_cases_other_1

7.24 kB
1,236 rows
3 columns

CREATE TABLE owid_new_cases_other_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "new_cases_other" INTEGER  -- New Cases, Other
);

New Cases: Other

@owid.gho.owid_new_cases_other_2

9.02 kB
1,236 rows
6 columns

CREATE TABLE owid_new_cases_other_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "new_cases_other" INTEGER  -- New Cases, Other,
  "new_cases_other_low" VARCHAR  -- New Cases, Other Low,
  "new_cases_other_high" VARCHAR  -- New Cases, Other High,
  "comments" VARCHAR
);

New Cases: Pulmonary Smear-negative

@owid.gho.owid_new_cases_pulmonary_smear_negative_1

18.47 kB
3,246 rows
3 columns

CREATE TABLE owid_new_cases_pulmonary_smear_negative_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "new_cases_pulmonary_smear_negative" UINTEGER  -- New Cases, Pulmonary Smear Negative
);

New Cases: Pulmonary Smear-negative

@owid.gho.owid_new_cases_pulmonary_smear_negative_2

20.63 kB
3,246 rows
6 columns

CREATE TABLE owid_new_cases_pulmonary_smear_negative_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "new_cases_pulmonary_smear_negative" UINTEGER  -- New Cases, Pulmonary Smear Negative,
  "new_cases_pulmonary_smear_negative_low" VARCHAR  -- New Cases, Pulmonary Smear Negative Low,
  "new_cases_pulmonary_smear_negative_high" VARCHAR  -- New Cases, Pulmonary Smear Negative High,
  "comments" VARCHAR
);

New Cases: Pulmonary, Smear-negative/unknown/not Done And Other New Cases

@owid.gho.owid_new_cases_pulmonary_smear_negative_unknown_not_do_0528b9be

16.38 kB
2,494 rows
3 columns

CREATE TABLE owid_new_cases_pulmonary_smear_negative_unknown_not_do_0528b9be (
  "year" INTEGER,
  "country" VARCHAR,
  "new_cases_pulmonary_smear_negative_unknown_not_done_an_e5c66af6" UINTEGER  -- New Cases, Pulmonary, Smear Negative Unknown Not Done And Other New Cases
);

New Cases: Pulmonary, Smear-positive

@owid.gho.owid_new_cases_pulmonary_smear_positive

16.58 kB
2,510 rows
3 columns

CREATE TABLE owid_new_cases_pulmonary_smear_positive (
  "year" INTEGER,
  "country" VARCHAR,
  "new_cases_pulmonary_smear_positive" UINTEGER  -- New Cases, Pulmonary, Smear Positive
);

New Cases: Pulmonary Smear Unknown/not Done

@owid.gho.owid_new_cases_pulmonary_smear_unknown_not_done_1

12.96 kB
2,557 rows
3 columns

CREATE TABLE owid_new_cases_pulmonary_smear_unknown_not_done_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "new_cases_pulmonary_smear_unknown_not_done" UINTEGER  -- New Cases, Pulmonary Smear Unknown Not Done
);

New Cases: Pulmonary Smear Unknown/not Done

@owid.gho.owid_new_cases_pulmonary_smear_unknown_not_done_2

15.22 kB
2,557 rows
6 columns

CREATE TABLE owid_new_cases_pulmonary_smear_unknown_not_done_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "new_cases_pulmonary_smear_unknown_not_done" UINTEGER  -- New Cases, Pulmonary Smear Unknown Not Done,
  "new_cases_pulmonary_smear_unknown_not_done_low" VARCHAR  -- New Cases, Pulmonary Smear Unknown Not Done Low,
  "new_cases_pulmonary_smear_unknown_not_done_high" VARCHAR  -- New Cases, Pulmonary Smear Unknown Not Done High,
  "comments" VARCHAR
);

New Cases Tested For RR-/MDR-TB (%)

@owid.gho.owid_new_cases_tested_for_rr_mdr_tb_pct_1

10.65 kB
2,925 rows
3 columns

CREATE TABLE owid_new_cases_tested_for_rr_mdr_tb_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "new_cases_tested_for_rr_mdr_tb_pct" FLOAT  -- New Cases Tested For Rr, Mdr Tb, Pct
);

New Cases Tested For RR-/MDR-TB (%)

@owid.gho.owid_new_cases_tested_for_rr_mdr_tb_pct_2

13 kB
3,104 rows
6 columns

CREATE TABLE owid_new_cases_tested_for_rr_mdr_tb_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "new_cases_tested_for_rr_mdr_tb_pct" FLOAT  -- New Cases Tested For Rr, Mdr Tb, Pct,
  "new_cases_tested_for_rr_mdr_tb_pct_low" VARCHAR  -- New Cases Tested For Rr, Mdr Tb, Pct Low,
  "new_cases_tested_for_rr_mdr_tb_pct_high" VARCHAR  -- New Cases Tested For Rr, Mdr Tb, Pct High,
  "comments" VARCHAR
);

New HIV Infections (per 1000 Uninfected Population)

@owid.gho.owid_new_hiv_infections_per_1000_uninfected_population_1

28.22 kB
13,806 rows
4 columns

CREATE TABLE owid_new_hiv_infections_per_1000_uninfected_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "new_hiv_infections_per_1000_uninfected_population" FLOAT  -- New Hiv Infections, Per 1000 Uninfected Population
);

New HIV Infections (per 1000 Uninfected Population)

@owid.gho.owid_new_hiv_infections_per_1000_uninfected_population_2

49.23 kB
14,939 rows
7 columns

CREATE TABLE owid_new_hiv_infections_per_1000_uninfected_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "new_hiv_infections_per_1000_uninfected_population" FLOAT  -- New Hiv Infections, Per 1000 Uninfected Population,
  "new_hiv_infections_per_1000_uninfected_population_low" FLOAT  -- New Hiv Infections, Per 1000 Uninfected Population Low,
  "new_hiv_infections_per_1000_uninfected_population_high" FLOAT  -- New Hiv Infections, Per 1000 Uninfected Population High,
  "comments" VARCHAR
);

New Leprosy Case Detection Rate Per 1–000 000 Population

@owid.gho.owid_new_leprosy_case_detection_rate_per_1_000_000_population_1

12.78 kB
1,473 rows
3 columns

CREATE TABLE owid_new_leprosy_case_detection_rate_per_1_000_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "new_leprosy_case_detection_rate_per_1_000_000_population" FLOAT
);

New Leprosy Case Detection Rate Per 1–000 000 Population

@owid.gho.owid_new_leprosy_case_detection_rate_per_1_000_000_population_2

16.13 kB
1,657 rows
6 columns

CREATE TABLE owid_new_leprosy_case_detection_rate_per_1_000_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "new_leprosy_case_detection_rate_per_1_000_000_population" FLOAT,
  "new_leprosy_case_detection_rate_per_1_000_000_population_low" VARCHAR,
  "new_leprosy_case_detection_rate_per_1_000_000_population_high" VARCHAR,
  "comments" VARCHAR
);

New Leprosy Cases With G2D Rate Per 1–000 000 Population

@owid.gho.owid_new_leprosy_cases_with_g2d_rate_per_1_000_000_population_1

10.94 kB
1,344 rows
3 columns

CREATE TABLE owid_new_leprosy_cases_with_g2d_rate_per_1_000_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "new_leprosy_cases_with_g2d_rate_per_1_000_000_population" FLOAT
);

New Leprosy Cases With G2D Rate Per 1–000 000 Population

@owid.gho.owid_new_leprosy_cases_with_g2d_rate_per_1_000_000_population_2

14.13 kB
1,525 rows
6 columns

CREATE TABLE owid_new_leprosy_cases_with_g2d_rate_per_1_000_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "new_leprosy_cases_with_g2d_rate_per_1_000_000_population" FLOAT,
  "new_leprosy_cases_with_g2d_rate_per_1_000_000_population_low" VARCHAR,
  "new_leprosy_cases_with_g2d_rate_per_1_000_000_population_high" VARCHAR,
  "comments" VARCHAR
);

New Leprosy Child Case Detection Rate (less Than 15 Years Of Age) Per 1–000 000 Child Population

@owid.gho.owid_new_leprosy_child_case_detection_rate_less_than_1_5ddfd18c

14.1 kB
1,558 rows
6 columns

CREATE TABLE owid_new_leprosy_child_case_detection_rate_less_than_1_5ddfd18c (
  "year" INTEGER,
  "country" VARCHAR,
  "new_leprosy_child_case_detection_rate_less_than_15_yea_1a432d8e" FLOAT  -- New Leprosy Child Case Detection Rate, Less Than 15 Years Of Age, Per 1–000 000 Child Population,
  "new_leprosy_child_case_detection_rate_less_than_15_yea_99fd8520" VARCHAR  -- New Leprosy Child Case Detection Rate, Less Than 15 Years Of Age, Per 1–000 000 Child Population Low,
  "new_leprosy_child_case_detection_rate_less_than_15_yea_539a45fe" VARCHAR  -- New Leprosy Child Case Detection Rate, Less Than 15 Years Of Age, Per 1–000 000 Child Population High,
  "comments" VARCHAR
);

New Leprosy Child Case Detection Rate (less Than 15 Years Of Age) Per 1–000 000 Child Population

@owid.gho.owid_new_leprosy_child_case_detection_rate_less_than_1_fa26c2ec

10.92 kB
1,369 rows
3 columns

CREATE TABLE owid_new_leprosy_child_case_detection_rate_less_than_1_fa26c2ec (
  "year" INTEGER,
  "country" VARCHAR,
  "new_leprosy_child_case_detection_rate_less_than_15_yea_1a432d8e" FLOAT  -- New Leprosy Child Case Detection Rate, Less Than 15 Years Of Age, Per 1–000 000 Child Population
);

New Or Unknown Treatment History Cases: Pulmonary, Clinically Diagnosed

@owid.gho.owid_new_or_unknown_treatment_history_cases_pulmonary__8e2ea64d

12.97 kB
1,780 rows
3 columns

CREATE TABLE owid_new_or_unknown_treatment_history_cases_pulmonary__8e2ea64d (
  "year" INTEGER,
  "country" VARCHAR,
  "new_or_unknown_treatment_history_cases_pulmonary_clini_81051a81" UINTEGER  -- New Or Unknown Treatment History Cases, Pulmonary, Clinically Diagnosed
);

New Or Unknown Treatment History Cases: Pulmonary, Bacteriologically Confirmed

@owid.gho.owid_new_or_unknown_treatment_history_cases_pulmonary__c5744fd9

20.52 kB
2,778 rows
6 columns

CREATE TABLE owid_new_or_unknown_treatment_history_cases_pulmonary__c5744fd9 (
  "year" INTEGER,
  "country" VARCHAR,
  "new_or_unknown_treatment_history_cases_pulmonary_bacte_62eb0ab2" UINTEGER  -- New Or Unknown Treatment History Cases, Pulmonary, Bacteriologically Confirmed,
  "new_or_unknown_treatment_history_cases_pulmonary_bacte_dd8b736f" VARCHAR  -- New Or Unknown Treatment History Cases, Pulmonary, Bacteriologically Confirmed Low,
  "new_or_unknown_treatment_history_cases_pulmonary_bacte_a233d9df" VARCHAR  -- New Or Unknown Treatment History Cases, Pulmonary, Bacteriologically Confirmed High,
  "comments" VARCHAR
);

New Or Unknown Treatment History Cases: Pulmonary, Bacteriologically Confirmed

@owid.gho.owid_new_or_unknown_treatment_history_cases_pulmonary__d27762e2

16.2 kB
2,352 rows
3 columns

CREATE TABLE owid_new_or_unknown_treatment_history_cases_pulmonary__d27762e2 (
  "year" INTEGER,
  "country" VARCHAR,
  "new_or_unknown_treatment_history_cases_pulmonary_bacte_62eb0ab2" UINTEGER  -- New Or Unknown Treatment History Cases, Pulmonary, Bacteriologically Confirmed
);

New Types Of Alcoholic Beverages Emerging

@owid.gho.owid_new_types_of_alcoholic_beverages_emerging_1

4.68 kB
45 rows
4 columns

CREATE TABLE owid_new_types_of_alcoholic_beverages_emerging_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "new_types_of_alcoholic_beverages_emerging" VARCHAR
);

New Types Of Alcoholic Beverages Emerging

@owid.gho.owid_new_types_of_alcoholic_beverages_emerging_2

6.32 kB
45 rows
6 columns

CREATE TABLE owid_new_types_of_alcoholic_beverages_emerging_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "new_types_of_alcoholic_beverages_emerging" VARCHAR,
  "new_types_of_alcoholic_beverages_emerging_low" VARCHAR,
  "new_types_of_alcoholic_beverages_emerging_high" VARCHAR,
  "comments" VARCHAR
);

NGOs For Alcohol Use Disorders

@owid.gho.owid_ngos_for_alcohol_use_disorders_1

6.08 kB
544 rows
4 columns

CREATE TABLE owid_ngos_for_alcohol_use_disorders_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_ngos" VARCHAR,
  "ngos_for_alcohol_use_disorders" VARCHAR
);