Joint United Nations Programme on HIV/AIDS (UNAIDS): Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
(Added link to GitHub repository in order to separate data for future data pulls.)
No edit summary
 
(4 intermediate revisions by one other user not shown)
Line 1: Line 1:
There are 10 series pulled from the "2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008". Several of these are used in the preprocessor but haven't been updated since 2008. It looks like these series have been pulled since then, but since the series name changed, they are not being read into the preprocessor. Updating the 2008 series should take care of that problem without changing the code. 
= Summary =
The '''[https://aidsinfo.unaids.org 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 through "Data Sheets".
Last updated in May of 2025.  


{| cellspacing="0" border="1" bgcolor="#ffffff"
= Tables in IFs =
|+ <font face="calibri" color="#000000">'''DataDict 720'''</font>
The following 6 tables in IFs are pulled from UNAIDS.
|-
{| class="wikitable"
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Table</font>
|+
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Group</font>
!<font face="calibri" color="#000000">Variable</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Definition</font>
!<font face="calibri" color="#000000">Definition</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Source</font>
!<font face="calibri" color="#000000">Formula</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Last IFs Update</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">UsedInPreprocessor</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Years</font>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSTotalHIVHighEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">High estimate of nuber of people living with HIV</font>
| <font face="calibri" color="#000000">2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008</font>
| <font face="calibri" color="#000000">2008/10/04</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSAdultHIV%HighEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">High estimate of percentage of adults (15-49) with HIV</font>
| <font face="calibri" color="#000000">2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008</font>
| <font face="calibri" color="#000000">2008/10/04</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSDeathsHighEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">High estimate of number of deaths from AIDS</font>
| <font face="calibri" color="#000000">2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008</font>
| <font face="calibri" color="#000000">2008/10/04</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSTotalHIVLowEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Low estimate of number of total population living with HIV</font>
| <font face="calibri" color="#000000">2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008</font>
| <font face="calibri" color="#000000">2008/10/28</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSTotalHIVMidEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Mid-range estimate of number of total population with HIV</font>
| <font face="calibri" color="#000000">2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008</font>
| <font face="calibri" color="#000000">2008/10/28</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSAdultHIV%MidEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Mid-range estimate of percentage of adults (15-49) with HIV</font>
| <font face="calibri" color="#000000">2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008</font>
| <font face="calibri" color="#000000">2008/10/28</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSDeathsMidEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Mid-range estimate of number of deaths from AIDS</font>
| <font face="calibri" color="#000000">2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008</font>
| <font face="calibri" color="#000000">2008/10/28</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSDeathsLowEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Low estimate of number of deaths from AIDS</font>
| <font face="calibri" color="#000000">2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008</font>
| <font face="calibri" color="#000000">2008/10/28</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSAdultHIV%LowEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Low estimate of percentage of adults (15-49)with HIV</font>
| <font face="calibri" color="#000000">2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008</font>
| <font face="calibri" color="#000000">2008/10/28</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSDeathsMidEstRev</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Revised Mid-range estimate of number of deaths from AIDS</font>
| <font face="calibri" color="#000000">2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008</font>
| <font face="calibri" color="#000000">2009/08/10</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|}
 
 
 
= Non-preprocessor series&nbsp; =
 
There are also 57 series pulled more recently from UNAIDS (2013), but none of these are used in the preprocessor.
 
{| cellspacing="0" border="1" bgcolor="#ffffff"
|+ <font face="calibri" color="#000000">'''DataDict 720'''</font>
|-
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Table</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Group</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Definition</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Source</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Last IFs Update</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">UsedInPreprocessor</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Years</font>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthAIDSDeathsTotalSPECTRUM</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">AIDS Deaths, Total Population, UNAIDS and Spectrum EPP, Historic and Forecast</font>
| <font face="calibri" color="#000000">UNAIDS, data and forecast from EPP-Spectrum Software</font>
| <font face="calibri" color="#000000">2009/12/14</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthHIVARTAdultNeedSPECTRUM</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Adults Needing Antiretroviral Treatment, Data and Forecast</font><br/>
| <font face="calibri" color="#000000">UNAIDS, data and forecast from EPP-Spectrum Software</font>
| <font face="calibri" color="#000000">2010/01/07</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthHIVARTAdultRcvdSPECTRUM</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Adults Receiving Antiretroviral Treatment, Data and Forecast</font><br/>
| <font face="calibri" color="#000000">UNAIDS, data and forecast from EPP-Spectrum Software</font>
| <font face="calibri" color="#000000">2010/01/07</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthHIVARTChildNeedSPECTRUM</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Children Needing Antiretroviral Treatment, Data and Forecast</font><br/>
| <font face="calibri" color="#000000">UNAIDS, data and forecast from EPP-Spectrum Software</font>
| <font face="calibri" color="#000000">2010/01/07</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthHIVARTChildRcvdSPECTRUM</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Children Receiving Antiretroviral Treatment</font>
| <font face="calibri" color="#000000">UNAIDS, data and forecast from EPP-Spectrum Software</font>
| <font face="calibri" color="#000000">2010/01/07</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthHIVIncidenceRateTotalSPECTRUM</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">HIV Incidence Rate, Total Population, UNAIDS and Spectrum EPP, Historic and Forecast</font>
| <font face="calibri" color="#000000">UNAIDS, data and forecast from EPP-Spectrum Software</font>
| <font face="calibri" color="#000000">2009/12/14</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthHIVPrevRateAdultSPECTRUM</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">HIV Prevalance Rate, Adult Population, UNAIDS and Spectrum EPP, Historic and Forecast</font>
| <font face="calibri" color="#000000">UNAIDS, data and forecast from EPP-Spectrum Software</font>
| <font face="calibri" color="#000000">2009/12/14</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthHIVPrevRateTotalSPECTRUM</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">HIV Prevalance Rate, Total Population, UNAIDS and Spectrum EPP, Historic and Forecast</font>
| <font face="calibri" color="#000000">UNAIDS, data and forecast from EPP-Spectrum Software</font>
| <font face="calibri" color="#000000">2009/12/14</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDS%AdultTestHIV</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Percentage of adults who received HIV test and results </font><br/>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/01</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDS%IDUTestHIV</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Percent of injection drug users who received HIV test and results</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/01</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSAdult%CondomUse</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Condom use at last sex (%) - # of Adults</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/07/31</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSAdultHIV%HighEst2013</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">High estimate of percentage of adults (15+) with HIV</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/02</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSAdultHIV%LowEst2013</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Low estimate of percentage of adults (15+)with HIV</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/02</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSAdultHIV%MidEst2013</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Mid-range estimate of percentage of adults (15+) with HIV</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/02</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSAdultHIVFemaleHighEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">High estimate of Adult HIV Prevalence (#) Females 15+</font><br/>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/02</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSAdultHIVFemaleLowEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Low estimate of Adult HIV Prevalence (#) Females 15+</font><br/>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/02</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSAdultHIVFemaleMidEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Mid-range estimate of Adult HIV Prevalence (#) Females 15+</font><br/>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/02</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSAdultHIVMaleHighEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">High estimate of Adult HIV Prevalence (#) Males</font><br/>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/02</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSAdultHIVMaleLowEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Low estimate of Adult HIV Prevalence (#) Males</font><br/>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/02</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSAdultHIVMaleMidEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Mid-range estimate of Adult HIV Prevalence (#) Males</font><br/>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/02</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSARTCoverHighEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">High estimate antiretroviral therapy Coverage (%)</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSARTCoverLowEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Low estimate antiretroviral therapy Coverage (%)</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSARTCoverMidEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Mid-range estimate antiretroviral therapy Coverage (%)</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSDeathsHighEst2013</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">High estimate of number of deaths from AIDS</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/07/25</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSDeathsLowEst2013</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Low estimate of number of deaths from AIDS</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/07/25</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSDeathsMidEst2013</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Mid-range estimate of number of deaths from AIDS</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/07/25</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSDomesticSpending</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Domestic Spending on HIV/AIDS current USD</font><br/>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/01</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSFemales15-24HIVHighEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">High estimate of Young People Prevalence (Females 15-24)</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/01</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSFemales15-24HIVLowEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Low estimate of Young People Prevalence (Females 15-24)</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/01</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSFemales15-24HIVMidEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Mid-range estimate of Young People Prevalence (Females 15-24)</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/01</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSHIVTBPatientsART</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">The number of HIV+ TB Patients on antiretroviral therapy</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/01</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSHIVTravelRestriction</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Travel Restrictions. 0 = No Restriction, 1= Restriction</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/01</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSIDU%HIV</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">The HIV Prevalence among Injection drug users (%)</font><br/>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/01</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSMales15-24HIVHighEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">High estimate for Young People Prevalence (Males 15-24)</font><br/>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/01</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSMales15-24HIVLowEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Low estimate for Young People Prevalence (Males 15-24)</font><br/>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/01</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSMales15-24HIVMidEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Mid-range estimate for Young People Prevalence (Males 15-24)</font><br/>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/01</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSNewHIVInfect0-14HighEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">High estimate of new HIV Infections (Ages 0-14) (#)</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSNewHIVInfect0-14LowEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Low estimate of new HIV Infections (Ages 0-14) (#)</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSNewHIVInfect0-14MidEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Mid-range estimate of new HIV Infections (Ages 0-14) (#)</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSNewHIVInfectAdultHighEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">High estimate of New Infections (ages 15+)</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSNewHIVInfectAdultLowEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Low estimate of New Infections (ages 15+)</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSNewHIVInfectAdultMidEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Mid-range estimate of New Infections (ages 15+)</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSNewHIVInfectTotalHighEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">High estimate of New Infections (all ages)</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSNewHIVInfectTotalLowEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Low estimate of New Infections (all ages)</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSNewHIVInfectTotalMidEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Mid-range estimate of New Infections (all ages)</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSPregnantHIV%ARTHighEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">High estimate for HIV+ pregnant women receving effective ART for prevention of mother to child transmission (%)</font><br/>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSPregnantHIV%ARTLowEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Low estimate for HIV+ pregnant women receving effective ART for prevention of mother to child transmission (%)</font><br/>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSPregnantHIV%ARTMidEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Mid-range estimate for HIV+ pregnant women receving effective ART for prevention of mother to child transmission (%)</font><br/>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSSyringesperUser</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Number of syringes distributed per person who injects drugs per year by needle and syringe Programmes</font><br/>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/01</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSTotalAdultHIVHighEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">High estimate of Adult HIV Prevalence (#) Total</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSTotalAdultHIVLowEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Low estimate of Adult HIV Prevalence (#) Total</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSTotalAdultHIVMidEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Mid-range estimate of Adult HIV Prevalence (#) Total</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSTotalART</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Number of people on antiretroviral therapy (#)</font><br/>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/01</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSTotalHIVHighEst2013</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">High estimate of Adult HIV Prevalence (#) Total</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSTotalHIVLowEst2013</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Low estimate of Adult HIV Prevalence (#) Total</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHealthUNAIDSTotalHIVMidEst2013</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Mid-range estimate of Adult HIV Prevalence (#) Total</font>
| <font face="calibri" color="#000000">UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]</font>
| <font face="calibri" color="#000000">2013/08/05</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|- valign="top"
| <font face="calibri" color="#000000">SeriesHIVRate</font>
| <font face="calibri" color="#000000">Population, Health</font>
| <font face="calibri" color="#000000">Percentage of adult (15-49) population infected, end of year; values apparently not comparable across time</font>
| <font face="calibri" color="#000000">UN AIDS; 2001-3 Millennium Indicators Database, UN [http://unstats.un.org/unsd/mi/mi_goals.asp http://unstats.un.org/unsd/mi/mi_goals.asp]; United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/] 2001-5</font>
| <font face="calibri" color="#000000">2006/12</font>
| align="right" | <font face="calibri" color="#000000">No</font>
| <br/>
|}
 
= &nbsp;Instructions on data import - Old Notes =
 
'''People living with HIV (all ages)&nbsp;and AIDS-related deaths (all ages)'''
 
''The data can be found under the “Data Sheet” tab, “national” option from [http://aidsinfo.unaids.org/ http://aidsinfo.unaids.org/] and contains data from 1990 to 2017.''
 
'''Operations carried out:'''
 
The data source has Excel and CSV files. The data in the CSV files was used, and it contains medium data points as well as the “lower”, and “upper” values&nbsp;on the same Excel sheet for the years 1990 to 2017. There are also less than signs < next to the numbers, as they are ranges, and the blank cells have three dots.
 
Using the find and replace option on excel to make sure all symbols were deleted, including the dots for nulls, and the column titles renamed to match the series names as below. The country names were then concorded using the IFs country names.
 
The data were then separated into 3 sheets that contained Medium, Low, and High estimates on separate sheets and was ready for the final Import to IFs. The same applied for the first series, “People Living with HIV (All ages)” – Number of people living with HIV subsection, under People living with HIV, and the second series, “AIDS-related deaths (All ages)” – Number of AIDS-related deaths subsection, under AIDS-related deaths.
 
'''''People living with HIV (all ages)''':''
 
HealthUNAIDSTotalHIVHighEst
 
HealthUNAIDSTotalHIVMidEst
 
HealthUNAIDSTotalHIVLowEst
 
'''AIDS-related deaths (all ages)'''
 
HealthUNAIDSDeathsHighEst
 
HealthUNAIDSDeathsLowEst
 
HealthUNAIDSDeathsMidEst
 
For treatment pull from '''People living with HIV receiving ART (%).'''
 
This series is an update of the 2015 variant of this series and replaces the current series noted above.
 
'''''OECD countries (all series)''': Data for OECD countries was missing from the data sources. The update was blended with data points from the 2013 variant of the series.''
 
For the '''AIDS related -deaths''' variables, there was no data for key countries such as China, Finland, Russia, Iceland, North Korea, South Korea, Spain, Sweden Switzerland, Turkey, UAE, UK. and US (until 2007).
 
For '''People Living with HIV''', counties missing data include: Belgium, Canada, China, Croatia, North Korea, South Korea, Finland, Iceland, Norway, Poland, Sweden, Switzerland, Turkey, UAE, UK, US (until 2007).
 
NOTE: "UNAIDS changes their data because they incorporate new surveillance and program data into their models each year"
 
== Notes for 2024 Update ==
{| cellspacing="0" border="1" bgcolor="#ffffff"
|-
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Variable</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Group</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Definition</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Source</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Unit</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Formula</font>
!Name In Source
!Name In Source
!<font face="calibri" color="#000000">UsedInPreprocessor</font>
!<font face="calibri" color="#000000">UsedInPreprocessor</font>
!<font face="calibri" color="#000000">UsedInPreprocessorFileName</font>
!<font face="calibri" color="#000000">UsedInPreprocessorFileName</font>
|- valign="top"
|-
| <font face="calibri" color="#000000">SeriesHealthUNAIDSTotalHIVHighEst</font>
|<font face="calibri" color="#000000">SeriesHealthUNAIDSTotalHIVHighEst</font>
| <font face="calibri" color="#000000">Population, Health</font>
|<font face="calibri" color="#000000">High estimate of nuber of people living with HIV</font>
| <font face="calibri" color="#000000">High estimate of nuber of people living with HIV</font>
|/1,000,000
| United Nations Program on HIV/AIDS (UNAIDS)
| Millions
| align="right" | /1,000,000
|People living with HIV - All ages
|People living with HIV - All ages
|1
|1
Line 633: Line 22:
|-
|-
|HealthUNAIDSTotalHIVMidEst
|HealthUNAIDSTotalHIVMidEst
|Population, Health
|Mid-range estimate of number of total population with HIV
|Mid-range estimate of number of total population with HIV
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|/1,000,000
|People living with HIV - All ages
|People living with HIV - All ages
Line 643: Line 29:
|-
|-
|HealthUNAIDSTotalHIVLowEst
|HealthUNAIDSTotalHIVLowEst
|Population, Health
|<font face="calibri" color="#000000">Low estimate of number of total population living with HIV</font>
|<font face="calibri" color="#000000">Low estimate of number of total population living with HIV</font>
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|/1,000,000
|People living with HIV - All ages
|People living with HIV - All ages
Line 653: Line 36:
|-
|-
|HealthUNAIDSDeathsLowEst
|HealthUNAIDSDeathsLowEst
|Population, Health
|Low estimate of number of deaths from AIDS
|Low estimate of number of deaths from AIDS
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|/1,000,000
|AIDS-related deaths - All ages
|AIDS-related deaths - All ages
Line 663: Line 43:
|-
|-
|HealthUNAIDSDeathsHighEst
|HealthUNAIDSDeathsHighEst
|Population, Health
|High estimate of number of deaths from AIDS
|High estimate of number of deaths from AIDS
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|/1,000,000
|AIDS-related deaths - All ages
|AIDS-related deaths - All ages
Line 673: Line 50:
|-
|-
|HealthUNAIDSARTCoverMidEst
|HealthUNAIDSARTCoverMidEst
|Population, Health
|Mid-range estimate antiretroviral therapy coverage (%)
|Mid-range estimate antiretroviral therapy coverage (%)
|United Nations Program on HIV/AIDS (UNAIDS)
|Percent
|/100
|/100
|People living with HIV receiving ART (%)
|People living with HIV receiving ART (%)
|
|1
|
|HEALTH
|}
|}
For the 2024 update, we pulled 6 tables.
=== To Pull the Data ===


= Data Pulling Instructions =
# Go to this site: https://aidsinfo.unaids.org/ and click on Epidemic and Responses
# Go to this site: https://aidsinfo.unaids.org/ and click on Epidemic and Responses
# Then in the indicator search bar, search up the indicators you need.  
# Then in the indicator search bar, search up the indicators you need.
# 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.[[File:UNAIDS.png|none|thumb|700x700px]]
# 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.[[File:UNAIDS.png|none|thumb|700x700px]]
# Below is the file after downloading it:[[File:Excel File for UNAIDS.png|none|thumb|997x997px]]
# This is what the data will look like upon downloading the CSV file from UNAIDS.[[File:UNAIDS Data Pull.png|thumb|1147x1147px|none]]
# Each file will have four types of data for the years: 1990 1990_lower 1990_upper 1990_Footnote. Delete the foot note years columns. 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.
# Each file will have four types of data for the years: 2010 2010_lower 2010_upper. The year in the numerical format (2010) 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. '''Make sure to delete the footnote column.'''
# 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.
# 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.
# '''To pull the following tables:'''  
# '''To pull the following tables:'''  
Line 705: Line 77:
# '''To pull the following table:'''  
# '''To pull the following table:'''  
## HealthUNAIDSARTCoverMidEst
## HealthUNAIDSARTCoverMidEst
### Search "People living with HIV receiving ART (%)" in the bar.
### Search "People living with HIV receiving ART" in the bar.
### For these tables, the unit is percent in decimal form. Divide the data in the excel by /100 to get the correct unit.
### For these tables, the unit is percent in decimal form. Divide the data in the excel by /100 to get the correct unit.
NOTES:


= Notes =
# Blending will be imperative as some of the data from countries was not included in the latest update of their data.
# Blending will be imperative as some of the data from countries was not included in the latest update of their data.
# "UNAIDS changes their data because they incorporate new surveillance and program data into their models each year"
# "UNAIDS changes their data because they incorporate new surveillance and program data into their models each year"
# Data 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
# 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

Latest revision as of 16:07, 15 August 2025

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 through "Data Sheets". Last updated in May of 2025.

Tables in IFs

The following 6 tables in IFs are pulled from UNAIDS.

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

Data Pulling Instructions

  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. This is what the data will look like upon downloading the CSV file from UNAIDS.
    UNAIDS Data Pull.png
  5. Each file will have four types of data for the years: 2010 2010_lower 2010_upper. The year in the numerical format (2010) 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. Make sure to delete the footnote column.
  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=13276"