UNAIDS: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 572: Line 572:


''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.''
''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.''
[[File:UNAIDS.png|none|thumb|700x700px]]


'''Operations carried out:'''
'''Operations carried out:'''
Line 577: Line 578:
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.
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, 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. As the data were in ones, they were all divided by 1,000,000 to maintain the million units, to match the units on IFs. 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.&nbsp;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.
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)''':''
'''''People living with HIV (all ages)''':''
Line 586: Line 589:


HealthUNAIDSTotalHIVLowEst
HealthUNAIDSTotalHIVLowEst
For these datasheets, pull from '''People living with HIV receiving ART (%).'''


'''AIDS-related deaths (all ages)'''
'''AIDS-related deaths (all ages)'''
Line 599: Line 604:
'''''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.''
'''''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).&nbsp;
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).
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"

Revision as of 00:10, 9 August 2024

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

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.

UNAIDS.png

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

For these datasheets, pull from People living with HIV receiving ART (%).

AIDS-related deaths (all ages)

HealthUNAIDSDeathsHighEst

HealthUNAIDSDeathsLowEst

HealthUNAIDSDeathsMidEst

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"

Retrieved from "https://pardeewiki.du.edu//index.php?title=UNAIDS&oldid=11687"