Joint United Nations Programme on HIV/AIDS (UNAIDS)

From Pardee Wiki
Revision as of 21:03, 20 June 2025 by Andrew.French (talk | contribs) (Updated pulling information for the 2025 update with a refreshed source summary)
Jump to navigation Jump to search

Summary

The Joint United Nations Programme on HIV/AIDS (UNAIDS) is a global partnership that leads and coordinates international efforts to end HIV/AIDS as a public health threat. Established in 1996, it brings together 11 UN agencies to respond to the HIV/AIDS epidemic. UNAIDS plays a pivotal role in maintaining global solidarity, reducing stigma and discrimination, and promoting sustainable development goals related to health. The data is located under "Epidemic and Response" on the homepage of UNAIDS, where users can access data for each indicator.



Tables in IFs

The following 6 tables in IFs are pulled from UNAIDS.

Variable Group Definition Source Unit Formula Name In Source UsedInPreprocessor UsedInPreprocessorFileName
SeriesHealthUNAIDSTotalHIVHighEst Population, Health High estimate of nuber of people living with HIV United Nations Program on HIV/AIDS (UNAIDS) Millions /1,000,000 People living with HIV - All ages 1 POPULATION
HealthUNAIDSTotalHIVMidEst Population, Health Mid-range estimate of number of total population with HIV United Nations Program on HIV/AIDS (UNAIDS) Millions /1,000,000 People living with HIV - All ages 1 POPULATION
HealthUNAIDSTotalHIVLowEst Population, Health Low estimate of number of total population living with HIV United Nations Program on HIV/AIDS (UNAIDS) Millions /1,000,000 People living with HIV - All ages 1 POPULATION
HealthUNAIDSDeathsLowEst Population, Health Low estimate of number of deaths from AIDS United Nations Program on HIV/AIDS (UNAIDS) Millions /1,000,000 AIDS-related deaths - All ages 1 POPULATION
HealthUNAIDSDeathsHighEst Population, Health High estimate of number of deaths from AIDS United Nations Program on HIV/AIDS (UNAIDS) Millions /1,000,000 AIDS-related deaths - All ages 1 POPULATION
HealthUNAIDSARTCoverMidEst Population, Health Mid-range estimate antiretroviral therapy coverage (%) United Nations Program on HIV/AIDS (UNAIDS) Percent /100 People living with HIV receiving ART (%) 1 HEALTH

For the 2025 update, we pulled 6 tables.

Data Instruction

  1. Go to this site: https://aidsinfo.unaids.org/ and click on Epidemic and Responses
  2. Then in the indicator search bar, search up the indicators you need.
  3. The data sheets you will need are under "Data Sheet." You can either export a CSV or XLS file. For this update, CSV files were used.
    UNAIDS.png
  4. Below is the file after downloading it:
    Excel File for UNAIDS.png
  5. Each file will have four types of data for the years: 1990 1990_lower 1990_upper. The year in the numerical format (1990) is the mid range estimate. The year_upper is the high estimate number and the year_lower is the low estimate number. This is how we will organize the data for the respective series.
  6. It is imperative that all symbols are removed from the file (this includes <, > signs, ... that acts as NULLs,) so that the data can import properly.
  7. To pull the following tables:
    1. SeriesHealthUNAIDSTotalHIVHighEst
    2. HealthUNAIDSTotalHIVMidEst
    3. HealthUNAIDSTotalHIVLowEst
      1. Search "People living with HIV - All ages" in the bar.
      2. For these tables, the unit is Millions. Divide the data in the excel by /1,000,000 to get the correct unit.
  8. To pull the following tables:
    1. HealthUNAIDSDeathsLowEst
    2. HealthUNAIDSDeathsHighEst
      1. Search "AIDS-related deaths - All ages" in the bar.
      2. For these tables, the unit is Millions. Divide the data in the excel by /1,000,000 to get the correct unit.
  9. To pull the following table:
    1. HealthUNAIDSARTCoverMidEst
      1. Search "People living with HIV receiving ART" in the bar.
      2. For these tables, the unit is percent in decimal form. Divide the data in the excel by /100 to get the correct unit.

Notes

  1. Blending will be imperative as some of the data from countries was not included in the latest update of their data.
  2. "UNAIDS changes their data because they incorporate new surveillance and program data into their models each year"
  3. If the data is downloaded into a XLS file, the sheet will be formatted with LowEst, MidEst, and HighEst in the same cells. Visit this GitHub repository for a python script to separate the data into their own sheets: https://github.com/fr3nch1/Automations/blob/main/%23%20Data%20Separation%20Script.py
Retrieved from "https://pardeewiki.du.edu//index.php?title=Joint_United_Nations_Programme_on_HIV/AIDS_(UNAIDS)&oldid=12610"