UNAIDS

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. 

DataDict 720

Table	Group	Definition	Source	Last IFs Update	UsedInPreprocessor	Years
SeriesHealthUNAIDSTotalHIVHighEst	Population, Health	High estimate of nuber of people living with HIV	2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008	2008/10/04	Yes
SeriesHealthUNAIDSAdultHIV%HighEst	Population, Health	High estimate of percentage of adults (15-49) with HIV	2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008	2008/10/04	No
SeriesHealthUNAIDSDeathsHighEst	Population, Health	High estimate of number of deaths from AIDS	2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008	2008/10/04	Yes
SeriesHealthUNAIDSTotalHIVLowEst	Population, Health	Low estimate of number of total population living with HIV	2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008	2008/10/28	Yes
SeriesHealthUNAIDSTotalHIVMidEst	Population, Health	Mid-range estimate of number of total population with HIV	2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008	2008/10/28	Yes
SeriesHealthUNAIDSAdultHIV%MidEst	Population, Health	Mid-range estimate of percentage of adults (15-49) with HIV	2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008	2008/10/28	No
SeriesHealthUNAIDSDeathsMidEst	Population, Health	Mid-range estimate of number of deaths from AIDS	2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008	2008/10/28	Yes
SeriesHealthUNAIDSDeathsLowEst	Population, Health	Low estimate of number of deaths from AIDS	2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008	2008/10/28	Yes
SeriesHealthUNAIDSAdultHIV%LowEst	Population, Health	Low estimate of percentage of adults (15-49)with HIV	2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008	2008/10/28	No
SeriesHealthUNAIDSDeathsMidEstRev	Population, Health	Revised Mid-range estimate of number of deaths from AIDS	2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008	2009/08/10	No

Non-preprocessor series 

There are also 57 series pulled more recently from UNAIDS (2013), but none of these are used in the preprocessor.

DataDict 720

Table	Group	Definition	Source	Last IFs Update	UsedInPreprocessor	Years
SeriesHealthAIDSDeathsTotalSPECTRUM	Population, Health	AIDS Deaths, Total Population, UNAIDS and Spectrum EPP, Historic and Forecast	UNAIDS, data and forecast from EPP-Spectrum Software	2009/12/14	No
SeriesHealthHIVARTAdultNeedSPECTRUM	Population, Health	Adults Needing Antiretroviral Treatment, Data and Forecast	UNAIDS, data and forecast from EPP-Spectrum Software	2010/01/07	No
SeriesHealthHIVARTAdultRcvdSPECTRUM	Population, Health	Adults Receiving Antiretroviral Treatment, Data and Forecast	UNAIDS, data and forecast from EPP-Spectrum Software	2010/01/07	No
SeriesHealthHIVARTChildNeedSPECTRUM	Population, Health	Children Needing Antiretroviral Treatment, Data and Forecast	UNAIDS, data and forecast from EPP-Spectrum Software	2010/01/07	No
SeriesHealthHIVARTChildRcvdSPECTRUM	Population, Health	Children Receiving Antiretroviral Treatment	UNAIDS, data and forecast from EPP-Spectrum Software	2010/01/07	No
SeriesHealthHIVIncidenceRateTotalSPECTRUM	Population, Health	HIV Incidence Rate, Total Population, UNAIDS and Spectrum EPP, Historic and Forecast	UNAIDS, data and forecast from EPP-Spectrum Software	2009/12/14	No
SeriesHealthHIVPrevRateAdultSPECTRUM	Population, Health	HIV Prevalance Rate, Adult Population, UNAIDS and Spectrum EPP, Historic and Forecast	UNAIDS, data and forecast from EPP-Spectrum Software	2009/12/14	No
SeriesHealthHIVPrevRateTotalSPECTRUM	Population, Health	HIV Prevalance Rate, Total Population, UNAIDS and Spectrum EPP, Historic and Forecast	UNAIDS, data and forecast from EPP-Spectrum Software	2009/12/14	No
SeriesHealthUNAIDS%AdultTestHIV	Population, Health	Percentage of adults who received HIV test and results	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/01	No
SeriesHealthUNAIDS%IDUTestHIV	Population, Health	Percent of injection drug users who received HIV test and results	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/01	No
SeriesHealthUNAIDSAdult%CondomUse	Population, Health	Condom use at last sex (%) - # of Adults	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/07/31	No
SeriesHealthUNAIDSAdultHIV%HighEst2013	Population, Health	High estimate of percentage of adults (15+) with HIV	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/02	No
SeriesHealthUNAIDSAdultHIV%LowEst2013	Population, Health	Low estimate of percentage of adults (15+)with HIV	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/02	No
SeriesHealthUNAIDSAdultHIV%MidEst2013	Population, Health	Mid-range estimate of percentage of adults (15+) with HIV	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/02	No
SeriesHealthUNAIDSAdultHIVFemaleHighEst	Population, Health	High estimate of Adult HIV Prevalence (#) Females 15+	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/02	No
SeriesHealthUNAIDSAdultHIVFemaleLowEst	Population, Health	Low estimate of Adult HIV Prevalence (#) Females 15+	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/02	No
SeriesHealthUNAIDSAdultHIVFemaleMidEst	Population, Health	Mid-range estimate of Adult HIV Prevalence (#) Females 15+	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/02	No
SeriesHealthUNAIDSAdultHIVMaleHighEst	Population, Health	High estimate of Adult HIV Prevalence (#) Males	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/02	No
SeriesHealthUNAIDSAdultHIVMaleLowEst	Population, Health	Low estimate of Adult HIV Prevalence (#) Males	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/02	No
SeriesHealthUNAIDSAdultHIVMaleMidEst	Population, Health	Mid-range estimate of Adult HIV Prevalence (#) Males	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/02	No
SeriesHealthUNAIDSARTCoverHighEst	Population, Health	High estimate antiretroviral therapy Coverage (%)	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSARTCoverLowEst	Population, Health	Low estimate antiretroviral therapy Coverage (%)	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSARTCoverMidEst	Population, Health	Mid-range estimate antiretroviral therapy Coverage (%)	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSDeathsHighEst2013	Population, Health	High estimate of number of deaths from AIDS	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/07/25	No
SeriesHealthUNAIDSDeathsLowEst2013	Population, Health	Low estimate of number of deaths from AIDS	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/07/25	No
SeriesHealthUNAIDSDeathsMidEst2013	Population, Health	Mid-range estimate of number of deaths from AIDS	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/07/25	No
SeriesHealthUNAIDSDomesticSpending	Population, Health	Domestic Spending on HIV/AIDS current USD	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/01	No
SeriesHealthUNAIDSFemales15-24HIVHighEst	Population, Health	High estimate of Young People Prevalence (Females 15-24)	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/01	No
SeriesHealthUNAIDSFemales15-24HIVLowEst	Population, Health	Low estimate of Young People Prevalence (Females 15-24)	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/01	No
SeriesHealthUNAIDSFemales15-24HIVMidEst	Population, Health	Mid-range estimate of Young People Prevalence (Females 15-24)	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/01	No
SeriesHealthUNAIDSHIVTBPatientsART	Population, Health	The number of HIV+ TB Patients on antiretroviral therapy	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/01	No
SeriesHealthUNAIDSHIVTravelRestriction	Population, Health	Travel Restrictions. 0 = No Restriction, 1= Restriction	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/01	No
SeriesHealthUNAIDSIDU%HIV	Population, Health	The HIV Prevalence among Injection drug users (%)	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/01	No
SeriesHealthUNAIDSMales15-24HIVHighEst	Population, Health	High estimate for Young People Prevalence (Males 15-24)	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/01	No
SeriesHealthUNAIDSMales15-24HIVLowEst	Population, Health	Low estimate for Young People Prevalence (Males 15-24)	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/01	No
SeriesHealthUNAIDSMales15-24HIVMidEst	Population, Health	Mid-range estimate for Young People Prevalence (Males 15-24)	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/01	No
SeriesHealthUNAIDSNewHIVInfect0-14HighEst	Population, Health	High estimate of new HIV Infections (Ages 0-14) (#)	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSNewHIVInfect0-14LowEst	Population, Health	Low estimate of new HIV Infections (Ages 0-14) (#)	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSNewHIVInfect0-14MidEst	Population, Health	Mid-range estimate of new HIV Infections (Ages 0-14) (#)	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSNewHIVInfectAdultHighEst	Population, Health	High estimate of New Infections (ages 15+)	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSNewHIVInfectAdultLowEst	Population, Health	Low estimate of New Infections (ages 15+)	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSNewHIVInfectAdultMidEst	Population, Health	Mid-range estimate of New Infections (ages 15+)	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSNewHIVInfectTotalHighEst	Population, Health	High estimate of New Infections (all ages)	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSNewHIVInfectTotalLowEst	Population, Health	Low estimate of New Infections (all ages)	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSNewHIVInfectTotalMidEst	Population, Health	Mid-range estimate of New Infections (all ages)	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSPregnantHIV%ARTHighEst	Population, Health	High estimate for HIV+ pregnant women receving effective ART for prevention of mother to child transmission (%)	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSPregnantHIV%ARTLowEst	Population, Health	Low estimate for HIV+ pregnant women receving effective ART for prevention of mother to child transmission (%)	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSPregnantHIV%ARTMidEst	Population, Health	Mid-range estimate for HIV+ pregnant women receving effective ART for prevention of mother to child transmission (%)	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSSyringesperUser	Population, Health	Number of syringes distributed per person who injects drugs per year by needle and syringe Programmes	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/01	No
SeriesHealthUNAIDSTotalAdultHIVHighEst	Population, Health	High estimate of Adult HIV Prevalence (#) Total	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSTotalAdultHIVLowEst	Population, Health	Low estimate of Adult HIV Prevalence (#) Total	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSTotalAdultHIVMidEst	Population, Health	Mid-range estimate of Adult HIV Prevalence (#) Total	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSTotalART	Population, Health	Number of people on antiretroviral therapy (#)	UNAIDS AIDSinfo; http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/01	No
SeriesHealthUNAIDSTotalHIVHighEst2013	Population, Health	High estimate of Adult HIV Prevalence (#) Total	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSTotalHIVLowEst2013	Population, Health	Low estimate of Adult HIV Prevalence (#) Total	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHealthUNAIDSTotalHIVMidEst2013	Population, Health	Mid-range estimate of Adult HIV Prevalence (#) Total	UNAIDS AIDSinfo: http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/	2013/08/05	No
SeriesHIVRate	Population, Health	Percentage of adult (15-49) population infected, end of year; values apparently not comparable across time	UN AIDS; 2001-3 Millennium Indicators Database, UN http://unstats.un.org/unsd/mi/mi_goals.asp; United Nations Statistics Division available at http://mdgs.un.org/unsd/mdg/ 2001-5	2006/12	No

 Instructions on data import - Old Notes

People living with HIV (all ages) and AIDS-related deaths (all ages)

The data can be found under the “Data Sheet” tab, “national” option from 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 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

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 (%)

For the 2024 update, we pulled 6 tables.

To Pull the Data

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.
   
4. Below is the file after downloading it:
   1. 
5. 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.
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"