Global AIDS Update
@owid.unaids
@owid.unaids
UNAIDS leads the world's most extensive data collection on HIV epidemiology, programme coverage and finance and publishes the most authoritative and up-to-date information on the HIV epidemic.
In some cases there is no data for some country and year. This can be a result of very small epidemics among women in the reproductive age which makes estimation of the mother to child transmission very unstable. Another reason for missing data is that relevant authorities may have asked UNAIDS not to share their estimates.
This UNAIDS 2024 report brings together new data and case studies which demonstrate that the decisions and policy choices taken by world leaders this year will decide the fate of millions of lives and whether the world's deadliest pandemic is overcome.
CREATE TABLE owid_epi (
"country" VARCHAR,
"year" INTEGER,
"age" VARCHAR,
"sex" VARCHAR,
"estimate" VARCHAR,
"aids_mortality_1000_pop" FLOAT,
"coverage_mothers_receiving_arv" FLOAT,
"hiv_incidence" FLOAT,
"hiv_prevalence" FLOAT,
"imr" FLOAT,
"ipr" FLOAT,
"mtct_rate" FLOAT,
"pct_change_aids_deaths_2010" INTEGER,
"pct_change_new_infections_2010" INTEGER,
"people_unsupp_vl" FLOAT,
"percent_art_vl_suppressed" FLOAT,
"percent_know_status_on_art" FLOAT,
"percent_plwh" FLOAT,
"plhiv_knowledge_of_status" FLOAT,
"viral_load_suppression" FLOAT,
"aids_deaths" FLOAT,
"aids_orphans" FLOAT,
"children_exposed_uninfected" FLOAT,
"deaths_plhiv_all_causes" FLOAT,
"infections_averted_pmtct" FLOAT,
"new_infections" FLOAT,
"plwh" FLOAT,
"deaths_averted_art" FLOAT,
"mothers_needing_arv_for_pmtct" FLOAT,
"mothers_receiving_arv_for_pmtct" FLOAT,
"people_receiving_art" FLOAT,
"number_plhiv_knowledge_of_status" FLOAT,
"art_none_preg_child_inf_preg" INTEGER,
"art_drop_bf_child_inf" INTEGER,
"art_drop_preg_child_inf" INTEGER,
"mother_child_inf_bf" INTEGER,
"mother_child_inf_preg" INTEGER,
"art_none_bf" INTEGER,
"art_start_before_preg_child_inf_bf" INTEGER,
"art_start_before_preg_child_inf_preg" INTEGER,
"art_start_during_preg_child_inf_bf" INTEGER,
"art_start_child_inf_during_preg" INTEGER,
"art_start_late_preg_child_inf_bf" INTEGER,
"art_start_late_preg_child_inf_preg" INTEGER,
"number_viral_suppression" FLOAT
);CREATE TABLE owid_gam (
"country" VARCHAR,
"year" INTEGER,
"expenditure_tb_hiv_activities" FLOAT,
"plhiv_current_tb_preventative" FLOAT,
"plhiv_in_care_with_active_tb" FLOAT,
"plhiv_receiving_tb_preventive_therapy" FLOAT,
"prisoners_tb" FLOAT,
"pwid_needles" INTEGER,
"resource_needs_ft" BIGINT,
"tb_expenditure" FLOAT,
"tb_patients_documented_hiv_positive_status" FLOAT,
"tb_patients_documented_hiv_status" FLOAT,
"new_relapse_tb_cases" UINTEGER,
"notified_tb_cases" UINTEGER,
"hiv_tb_patients_receiving_art" UINTEGER,
"hiv_tb_patients_receiving_cpt" UINTEGER,
"hiv_tb_patients_under_ipt" UINTEGER,
"tb_patients_tested_positive_hiv" UINTEGER,
"hiv_care" UINTEGER,
"newly_enrolled_care" UINTEGER,
"hiv_tb_diagnosis" UINTEGER,
"prisoners_condoms_distributed" UINTEGER,
"prisoners_ost" UINTEGER,
"num_art_init_tpt" UINTEGER,
"people_on_prep" UINTEGER,
"plhiv_current_enrolled" UINTEGER,
"plhiv_current_treatment_tb" UINTEGER,
"people_art_elig_tpt" UINTEGER,
"people_art_elig_tpt_strt" UINTEGER,
"prop_art_tpt_start" FLOAT,
"per_tpt_art_cmplt" FLOAT,
"num_art_complt_tpt" UINTEGER,
"people_new_art_elig_tpt_strt" UINTEGER,
"prop_new_art_tpt_strt" FLOAT,
"pwid_needles_distributed" UINTEGER
);CREATE TABLE owid_gam_age (
"country" VARCHAR,
"year" INTEGER,
"age" VARCHAR,
"male_circumcisions_performed" UINTEGER
);CREATE TABLE owid_gam_age_group (
"country" VARCHAR,
"year" INTEGER,
"age" VARCHAR,
"group" VARCHAR,
"prevalence_male_circumcision" FLOAT,
"hiv_self_tests" UINTEGER
);CREATE TABLE owid_gam_age_sex (
"country" VARCHAR,
"year" INTEGER,
"age" VARCHAR,
"sex" VARCHAR,
"att_tow_wife_beating" FLOAT,
"demand_family_planning" FLOAT,
"hiv_pos_rate" FLOAT,
"prevalence_ipv" FLOAT,
"pwid_ost_coverage" FLOAT
);CREATE TABLE owid_gam_age_sex_group (
"country" VARCHAR,
"year" INTEGER,
"age" VARCHAR,
"sex" VARCHAR,
"group" VARCHAR,
"art_coverage" FLOAT,
"avoidance_care" FLOAT,
"condom_use" FLOAT,
"discriminatory_attitudes" FLOAT,
"experience_stigma" FLOAT,
"hiv_prevalence" FLOAT,
"hiv_programmes_coverage" FLOAT,
"hiv_status_awareness" FLOAT,
"pwid_safety" FLOAT,
"hiv_tests" UINTEGER
);CREATE TABLE owid_gam_estimates (
"country" VARCHAR,
"year" INTEGER,
"estimate" VARCHAR,
"comanagement_tb_hiv" FLOAT,
"hiv_new_tb_cases" FLOAT,
"incident_tb_cases" UINTEGER,
"tb_related_deaths" INTEGER
);CREATE TABLE owid_gam_group (
"country" VARCHAR,
"year" INTEGER,
"group" VARCHAR,
"discrimination_hc_settings" FLOAT,
"domestic_spending_fund_source" FLOAT,
"resource_avail_constant" BIGINT,
"population" UINTEGER,
"condoms_distributed_pp" FLOAT
);CREATE TABLE owid_gam_hepatitis (
"country" VARCHAR,
"year" INTEGER,
"age" VARCHAR,
"sex" VARCHAR,
"group" VARCHAR,
"hepatitis" VARCHAR,
"viral_hepatitis" FLOAT
);CREATE TABLE owid_gam_sex (
"country" VARCHAR,
"year" INTEGER,
"sex" VARCHAR,
"knowledge_in_young_people" FLOAT
);CREATE TABLE owid_gam_sex_group (
"country" VARCHAR,
"year" INTEGER,
"sex" VARCHAR,
"group" VARCHAR,
"experience_violence" FLOAT,
"syphilis_prevalence" FLOAT,
"condoms_distributed" UINTEGER
);CREATE TABLE owid_unaids (
"country" VARCHAR,
"year" INTEGER,
"disaggregation" VARCHAR,
"aids_deaths" FLOAT,
"aids_orphans" FLOAT,
"condom_use" FLOAT,
"deaths_averted_art" FLOAT,
"discriminatory_attitudes" FLOAT,
"domestic_spending_fund_source" FLOAT,
"gap_on_art" FLOAT,
"hiv_incidence" FLOAT,
"hiv_prevalence" FLOAT,
"infections_averted_pmtct" FLOAT,
"knowledge_in_young_people" FLOAT,
"msm_condom_use" FLOAT,
"new_infections" FLOAT,
"resource_avail_constant" FLOAT,
"resource_needs_ft" FLOAT,
"domestic_spending_fund_source_per_capita" FLOAT,
"hiv_tb_patients_receiving_art" FLOAT,
"tb_patients_tested_positive_hiv" FLOAT,
"tb_related_deaths" FLOAT
);Anyone who has the link will be able to view this.