UNAIDS: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
JoelMaweni (talk | contribs) No edit summary |
||
| Line 570: | Line 570: | ||
= Instructions on data import = | = Instructions on data import = | ||
'''People living with HIV (all ages) and AIDS-related deaths(all ages)''' | |||
The data can be found under national "Data Sheet" from httphttp://aidsinfo.unaids.org/ . | |||
'''Operations carried out:''' | |||
The data source has Excel files and CSV files. The data in the excel files is in the format of a text, containing medium data points coupled with a'''low-high range '''within the same Excel cell and other text characters. Using the data tab on Excel the cell was separated to create 3 separate columns within one sheet. The Excel function used was '''“Text to Columns”'''.Two sheets with separated columns were created and two more sheets that contained Low, Medium, and High as separate sheets were them created for the final Import. | |||
People living with HIV(all ages): | |||
HealthUNAIDSTotalHIVHighEst | |||
HealthUNAIDSTotalHIVMidEst | |||
HealthUNAIDSTotalHIVLowEst | |||
'''AIDS-related deaths(all ages)''' | |||
HealthUNAIDSDeathsHighEst | |||
HealthUNAIDSDeathsLowEst | |||
HealthUNAIDSDeathsMidEst | |||
This series is an update of the 2013 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. | |||
'''China(People living with HIV)''': The 2013 variant of the series only contained one data point for China and the current update(2012-2014) does not contain data points for China. Data points that can be found up to 2007 were left out due to possible unreliability. | |||
Revision as of 20:16, 29 April 2016
Back to data
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.
| 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.
| 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 national "Data Sheet" from httphttp://aidsinfo.unaids.org/ .
Operations carried out:
The data source has Excel files and CSV files. The data in the excel files is in the format of a text, containing medium data points coupled with alow-high range within the same Excel cell and other text characters. Using the data tab on Excel the cell was separated to create 3 separate columns within one sheet. The Excel function used was “Text to Columns”.Two sheets with separated columns were created and two more sheets that contained Low, Medium, and High as separate sheets were them created for the final Import.
People living with HIV(all ages):
HealthUNAIDSTotalHIVHighEst
HealthUNAIDSTotalHIVMidEst
HealthUNAIDSTotalHIVLowEst
AIDS-related deaths(all ages)
HealthUNAIDSDeathsHighEst
HealthUNAIDSDeathsLowEst
HealthUNAIDSDeathsMidEst
This series is an update of the 2013 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.
China(People living with HIV): The 2013 variant of the series only contained one data point for China and the current update(2012-2014) does not contain data points for China. Data points that can be found up to 2007 were left out due to possible unreliability.