Pardee Wiki - User contributions [en]

FAOSTAT Food Security and Nutrition

2025-10-16T15:04:41Z

Andrew.French: changed years to 2001-2023

= Summary =
FAOSTAT gives users access to food and agriculture data for over 245 countries and territories. Additionally, it covers all FAO regional groupings from 1961 to the most recent year available. The Suite of Food Security Indicators presents the core set of food security indicators. The choice of the indicators has been informed by expert judgment and the availability of data with sufficient coverage to enable comparisons across regions and over time. Many of these indicators are produced and published elsewhere by FAO and other international organizations. More indicators will be added to as more data will become available. Indicators are classified along the four dimensions of food security -- availability, access, utilization and stability.

The data team uses food security indicators for many series, including those related to hunger/malnutrition such as Series, Series, Series, Series. To pull data, follow the instructions below.

= Tables In IFs =
{| class="wikitable"
|+
!Variable
!Definition
!Years
!UsedInPreprocessor
!UsedInPreprocessorFileName
|-
|MalnDietEnSup
|National average dietary energy supply (DES) (expressed in calories per caput per day) used in the estimation of prevalence of undernourishment.
|2001-2023
|1
|AGRICULTURE
|-
|MalnCaloricDistribution
|Coefficient of variation of habitual caloric consumption distribution.
|2001-2023
|1
|AGRICULTURE
|-
|MalnMinNutrRequired
|In a specified age/sex category, MDER is the minimum amount of dietary energy per person that is considered adequate to meet the energy needs at a minimum acceptable BMI of an individual engaged in low physical activity.
|2001-2023
|1
|AGRICULTURE
|-
|MalnPop%
|Prevalence of undernourishment (% of population)
|2001-2023
|1
|AGRICULTURE
|}

= Data Pulling Instructions =
Step 1. Navigate to [https://www.fao.org/faostat/en/#data/FS FAOSTAT Food Security]site. This site will display a suite of food security indicators.

[[File:FAO IMG 1.jpg|center|thumb|696x696px|FAO Food Security Homepage]]

Step 2. The page displays four options that must be selected to download data: Countries/Regions/Special Groups, Elements, Years, and Items. For all these options, you can also type in a search box.
[[File:FAO IMG 2.jpg|center|thumb|754x754px|FAO Data Selections]]

Step 3. For '''“Countries”''' options, you will generally want to select '''“Select All”''' to capture all country data.
[[File:FAO IMG 3.jpg|center|thumb|688x688px|Country Selection]]

Step 4. For the '''“Elements”''' options you will most likely want to select '''“Value”''', depending on the desired dataset.
[[File:FAO IMG 4.jpg|center|thumb|684x684px|Elements Selection]]

Step 5. For '''“Years”''', you will generally want to select '''“Select All”''' to capture all years of data available.
[[File:FAO IMG 5.jpg|center|thumb|678x678px|Years Selection]]

Step 6. For '''“Items”''', select the desired indicator. You can also type in the search box for the indicator. This example will use '''“Prevalence of undernourishment (percent)”'''.
[[File:FAO IMG 6.jpg|center|thumb|684x684px|Items Selection]]

Step 7. After selecting for these for options, the page will display the completed selections.
[[File:FAO IMG 7.jpg|center|thumb|716x716px|Completed Selections ]]

Step 8. Scroll down below the options. You also have options to select the “Output Type”, “File Type”, and “Thousand Separator in ‘Show Data’”. It’s recommended to select '''“Pivot”''' under '''“Output Type”''' to have easier data cleaning.
[[File:FAO IMG 8.jpg|center|thumb|701x701px|Additional Data Options]]

Step 9. You may select '''“Show Data”''' to look at the data before downloading. This option will populate data at the bottom of the page.

Step 10. Click '''“Download Data”'''. Either an Excel or CSV sheet will download. Now you can format the data to upload it into IFs. To import data into IFs, please follow the instructions found in the [[Importing data (general instructions)|Importing Data (general instructions)]] page.
[[File:FAO IMG 9.jpg|center|thumb|718x718px|Show and Download Data]]

= Data Notes =
* Any data values that include a symbol (ie. <2.5 for Algeria 2018-2022) need to be changed to NULL.
* For the table MalnMinNutrRequired, we need to make sure Sahrawi has values (use Mali as a proxy). So, only Kosovo is allowed to have nulls.
* MalnPop% has year ranges; only include the mid-year in the range. (ie. If 2000-2002, change it to 2001).
* While exporting data, make sure to select "Null Values" under Output Formatting Options. This is to ensure that all countries are included even if there is no data available.

FAOSTAT Food Security and Nutrition

2025-10-14T15:41:19Z

Andrew.French: Added relevant information into the data note section

= Summary =
FAOSTAT gives users access to food and agriculture data for over 245 countries and territories. Additionally, it covers all FAO regional groupings from 1961 to the most recent year available. The Suite of Food Security Indicators presents the core set of food security indicators. The choice of the indicators has been informed by expert judgment and the availability of data with sufficient coverage to enable comparisons across regions and over time. Many of these indicators are produced and published elsewhere by FAO and other international organizations. More indicators will be added to as more data will become available. Indicators are classified along the four dimensions of food security -- availability, access, utilization and stability.

The data team uses food security indicators for many series, including those related to hunger/malnutrition such as Series, Series, Series, Series. To pull data, follow the instructions below.

= Tables In IFs =
{| class="wikitable"
|+
!Variable
!Definition
!Years
!UsedInPreprocessor
!UsedInPreprocessorFileName
|-
|MalnDietEnSup
|National average dietary energy supply (DES) (expressed in calories per caput per day) used in the estimation of prevalence of undernourishment.
|2000-2024
|1
|AGRICULTURE
|-
|MalnCaloricDistribution
|Coefficient of variation of habitual caloric consumption distribution.
|2000-2024
|1
|AGRICULTURE
|-
|MalnMinNutrRequired
|In a specified age/sex category, MDER is the minimum amount of dietary energy per person that is considered adequate to meet the energy needs at a minimum acceptable BMI of an individual engaged in low physical activity.
|2000-2024
|1
|AGRICULTURE
|-
|MalnPop%
|Prevalence of undernourishment (% of population)
|2001-2023
|1
|AGRICULTURE
|}

= Data Pulling Instructions =
Step 1. Navigate to [https://www.fao.org/faostat/en/#data/FS FAOSTAT Food Security]site. This site will display a suite of food security indicators.

[[File:FAO IMG 1.jpg|center|thumb|696x696px|FAO Food Security Homepage]]

Step 2. The page displays four options that must be selected to download data: Countries/Regions/Special Groups, Elements, Years, and Items. For all these options, you can also type in a search box.
[[File:FAO IMG 2.jpg|center|thumb|754x754px|FAO Data Selections]]

Step 3. For '''“Countries”''' options, you will generally want to select '''“Select All”''' to capture all country data.
[[File:FAO IMG 3.jpg|center|thumb|688x688px|Country Selection]]

Step 4. For the '''“Elements”''' options you will most likely want to select '''“Value”''', depending on the desired dataset.
[[File:FAO IMG 4.jpg|center|thumb|684x684px|Elements Selection]]

Step 5. For '''“Years”''', you will generally want to select '''“Select All”''' to capture all years of data available.
[[File:FAO IMG 5.jpg|center|thumb|678x678px|Years Selection]]

Step 6. For '''“Items”''', select the desired indicator. You can also type in the search box for the indicator. This example will use '''“Prevalence of undernourishment (percent)”'''.
[[File:FAO IMG 6.jpg|center|thumb|684x684px|Items Selection]]

Step 7. After selecting for these for options, the page will display the completed selections.
[[File:FAO IMG 7.jpg|center|thumb|716x716px|Completed Selections ]]

Step 8. Scroll down below the options. You also have options to select the “Output Type”, “File Type”, and “Thousand Separator in ‘Show Data’”. It’s recommended to select '''“Pivot”''' under '''“Output Type”''' to have easier data cleaning.
[[File:FAO IMG 8.jpg|center|thumb|701x701px|Additional Data Options]]

Step 9. You may select '''“Show Data”''' to look at the data before downloading. This option will populate data at the bottom of the page.

Step 10. Click '''“Download Data”'''. Either an Excel or CSV sheet will download. Now you can format the data to upload it into IFs. To import data into IFs, please follow the instructions found in the [[Importing data (general instructions)|Importing Data (general instructions)]] page.
[[File:FAO IMG 9.jpg|center|thumb|718x718px|Show and Download Data]]

= Data Notes =
* Any data values that include a symbol (ie. <2.5 for Algeria 2018-2022) need to be changed to NULL.
* For the table MalnMinNutrRequired, we need to make sure Sahrawi has values (use Mali as a proxy). So, only Kosovo is allowed to have nulls.
* MalnPop% has year ranges; only include the mid-year in the range. (ie. If 2000-2002, change it to 2001).
* While exporting data, make sure to select "Null Values" under Output Formatting Options. This is to ensure that all countries are included even if there is no data available.

Business Ready (B-READY), World Bank

2025-08-05T22:23:18Z

Andrew.French:

= Summary =

=== Business Ready (B-READY) ===
The World Bank's "[https://www.worldbank.org/en/businessready/about-us Business Ready]" (B-READY) project is a new initiative launched to replace the discontinued "Doing Business" report. The B-READY project, which began its pilot phase in 2024, seeks to assess countries on ten key indicators, focusing on how business regulations are implemented in practice compared to what is written in law. Here are the new indicators will be provided in the BusinessReady. (<nowiki>https://www.enterprisesurveys.org/content/dam/enterprisesurveys/documents/methodology/Indicator-Description.pdf</nowiki>)

=== Doing Business ===
The World Bank has an annual global doing business report available here http://www.doingbusiness.org/. The Doing Business project faced criticism and was discontinued in 2021. In 2020, the World Bank halted the Doing Business report after an internal audit revealed that data had been improperly altered in past reports to boost the rankings of certain countries. Specifically, it was found that the rankings of China, Saudi Arabia, the United Arab Emirates, and Azerbaijan had been adjusted inappropriately due to pressure from senior World Bank officials. In September 2021, the World Bank officially announced that it would discontinue the Doing Business report. The decision came after the findings of the investigation, which detailed significant ethical concerns, particularly with regards to the manipulation of rankings for political and economic reasons.

= Tables In IFs: Doing Business Report =
{| class="wikitable"
|+
!Variable
!Definition
!Years
!UsedInPreprocessor
!UsedInPreprocessorFileName
!Name In Source
!Code In Source
|-
|GovWBDoingBusConstructionPermitDays
|The number of days need to get a construction permit
|2004-2019
|0
|
|Time (days) construct permits
|IC.CNST.PRMT.PROC.NO
|-
|GovWBDoingBusConstructionPermitProcedures
|Number of procedures needed to get a construction permit
|2004-2019
|0
|
|Procedures (number) construct permit
|IC.CNST.PRMT.PROC.NO
|-
|GovWBDoingBusContainExportCostUSDNew
|Cost of exporting one container in USD - border cost + documentation cost
|2004-2019
|0
|
|Time (years)- resolving insolevency
|TRD.ACRS.BRDR.EXPT.COST.BRDR.COMP.CD.DB1619 & TRD.ACRS.BRDR.EXPT.COST.DOC.COMP.CD.DB1619
|-
|GovWBDoingBusContainImportCostUSDNew
|Cost of importing one container in USD - border cost + documentation cost
|2004-2019
|0
|
|Time (years)- resolving insolevency
|TRD.ACRS.BRDR.IMP.COST.BRDR.COMP.CD.DB1619 & TRD.ACRS.BRDR.IMP.COST.DOC.COMP.CD.DB1619
|-
|GovWBDoingBusContainerExportCostUSD
|Cost of exporting one container in USD
|2006-2014
|0
|
|Cost to export (US$ per container) old methodology-trade
|
|-
|GovWBDoingBusContainerImportCostUSD
|Cost of importing one container in USD
|2006-2014
|0
|
|Cost to import (US$ per container) old methodology-trade
|
|-
|GovWBDoingBusContractEnforceDays
|Number of days required to enforce a contract
|2004-2019
|0
|
|Time (days)- enforcing contracts
|ENF.CONT.DURS.DY
|-
|GovWBDoingBusCostClose
|Average cost of closing a business in percent of estate
|2004-2019
|0
|
|Cost (% of estate)-resolving insolvency
|RESLV.ISV.COST.ZS
|-
|GovWBDoingBusCreditTransparency
|World Bank index on the depth of credit information (0-6)
|2004-2019
|0
|
|Transparency of information index (0–6) reg prop
|IC.CRED.ACC.DPTH.CISI.XD.06.DB0514
|-
|GovWBDoingBusDirectorLiability
|World Bank index on the extent of director liability
|2004-2019
|0
|
|Extent of director liability index (0-10)-min investor protect
|PROT.MINOR.INV.IC.PRIN.EXT.DIR.LGL.010.XD
|-
|GovWBDoingBusDisclosureIndex
|World Bank index on the extent of disclosure
|2004-2019
|0
|
|Extent of disclosure index (0-10)- min investor protect
|PROT.MINOR.INV.EXT.BUS.DISC.010.XD
|-
|GovWBDoingBusEmpRigiIndex
|World Bank index on the rigidity of employment
|2004-2010
|0
|
|
|
|-
|GovWBDoingBusExportDocumentationNeeded
|Number of documents needed to export
|2004-2019
|0
|
|Documents to export (number) old methodology- trade
|TRD.ACRS.BRDR.DOCS.EXPT.NO.DB0615
|-
|GovWBDoingBusHiringDiffIndex
|World Bank index documenting the difficulty in hiring workers 0-100
|2004-2010
|0
|
|
|
|-
|GovWBDoingBusImportDays
|Number of days required to import
|2006-2014
|0
|
|Time to import (days) old methodology-trade
|
|-
|GovWBDoingBusImportDaysNew
|Number of days required to import - border + doc
|2004-2019
|0
|
|Time (years)- resolving insolevency
|TRD.ACRS.BRDR.IMP.BRDR.COMP.HR.DB1619&TRD.ACRS.BRDR.IMP.DOC.COMP.HR.DB1619
|-
|GovWBDoingBusImportDocumentationNeeded
|Number of documents needed to import
|2004-2019
|0
|
|Documents to import (number) old methodology-trade
|TRD.ACRS.BRDR.DOCS.IMP.NO.DB0615
|-
|GovWBDoingBusInvestorProtection
|World bank index measuring the strength of investor protection (0-10)
|2004-2019
|0
|
|Strength of investor protection index (0-10) old methodology-min investor protect
|PROT.MINOR.INV.STRENG.INV.PROT.XD.010.DB0614
|-
|GovWBDoingBusLegalRightsStrengthIndex
|World Bank index of the strength of legal rights, getting credit (0-10)
|2004-2019
|0
|
|Strength of legal rights index (0-10) old methodology-getting credit
|IC.CRED.ACC.LGL.RGHT.XD.010.DB0514
|-
|GovWBDoingBusPropertyProceduresRequired
|Number of procedures required to register for property
|2004-2019
|0
|
|Procedures (number) reg prop
|IC.REG.PRRT.PROC.NO
|-
|GovWBDoingBusRedundancyCostperWeekSalary
|Cost of firing a worker (in weeks of salary)
|2004-2010
|0
|
|
|
|-
|GovWBDoingBusRedundancyIndex
|World Bank index on the difficulty in firing a worker
|2004-2010
|0
|
|
|
|-
|GovWBDoingBusTax%Profit
|Total tax rate as a percentage of profit
|2004-2019
|0
|
|
|PAY.TAX.TOT.TAX.RT.ZS
|-
|GovWBDoingBusTaxHoursperPerson
|Number of hours per year a person works to pay taxes
|2004-2019
|0
|
|Time (hours per year)-paying taxes
|PAY.TAX.TM
|-
|GovWBDoingBusTimeClose
|Average number of years needed to close a business
|2004-2019
|0
|
|Time (years)- resolving insolevency
|RESLV.ISV.DURS.YR
|-
|GovWBDoingBusTotalTaxRate
|The total tax rate expressed as a share of commercial profits.
|2005-2016
|0
|
|Total tax rate (% of commercial profit)
|
|-
|GovWBDoingBusinessProcedures
|Number of procedures required to start a business
|2004-2019
|0
|
|Procedures (number) starting a bus
|IC.REG.PROC.MA.NO
|-
|GovWBDoingBusinessPropRegDays
|Number of days required to registar property
|2004-2019
|0
|
|Time (days) reg prop
|IC.REG.PRRT.DURS.TM
|-
|GovWBDoingBusinessRanking
|Total overall ranking of ease of doing business
|2004-2019
|0
|
|Ease of Doing Business Rank
|
|-
|GovWBDoingBusinessStartDays
|Number of days required to start a business
|2004-2019
|0
|
|Time (days) starting a bus
|IC.REG.DURS.MA.DY
|-
|GovBusinessRegulationIndex
|A composit index of business environment indicators. Higher indicates a greater ease of doing business.
|2004-2010
|1
|SOCIOPOL
|
|
|-
|GovBetterBusinessIndex
|A composit index of bussness environment indicators. Higher indicates a greater regulatory burden on business.
|2004-2010
|0
|
|
|
|-
|GovWBDoingBusinessCostofStarting
|Cost of registring a business as a percent of per capita income
|2003-2019
|1
|SOCIOPOL
|Cost of business start-up procedures (% of GNI per capita)
|
|}

== Data Pulling Instructions: Doing Business ==
#The data can be accessed from the World Bank’s Doing Business database page http://data.worldbank.org/data-catalog/doing-business-database. By clicking on the tab entitled "Data & Resources", the raw data can be downloaded either through CSV format or Excel format.
#Using Excel files as an example, the file contains three sheets with the names Data, Series, and Footnote. The Doing Business data was acquired from the Data tab. Prior to importing the data into the IFs, the raw data needs some pre-processing. The first step is to concord the country names with the IFs country names since the IFs does not have a specific country concordance list for Doing Business data. Then, the next step is to separate the data into several individual files based on different series. After those two procedures, the data should be ready for import.
#One thing to note in the country concordance process is that there are some sub-areas in the data (e.g., China - Beijing). Those data should be ignored since we only care about the data in certain countries. However, data for areas like 'Hong Kong, China' would be different, we actually need the data for that. Thus, to differentiate from sub-areas and main areas, you should look for that dash symbol '-' (i.e., China - Beijing would be treated as a sub-area).
#Certain series we had in the system are not being measured in the Doing Business data. Thus, series that were not included in the original downloaded data were typically not updated. Since the organization constantly updates their data and methodology each year, some series will not be concordant through years. Those series will need to be handled carefully.
#Series that were not updated are as follows (11 series in total): BetterBusinessIndex, BusinessRegulationIndex, ConstructionPermitDays, ConstructionPermitProcedures, EmpRigiIndex, ExportDocumentationNeeded, ImportDocumentationNeeded, HiringDiffIndex, RedundancyCostperWeekSalary, RedundancyIndex, TotalTaxRate. Note that the Tax%Profit series was updated using the "Total tax rate (% of profit)" in the raw downloaded data.
#Series that have been updated but need to be put on hold due to inconsistency in values through years are: SeriesGovWBDoingBusContainerExportCostUSD, SeriesGovWBDoingBusContainerImportCostUSD, SeriesGovWBDoingBusCreditTransparency, SeriesGovWBDoingBusImportDays, SeriesGovWBDoingBusLegalRightsStrengthIndex. Those 5 series in the most recent updated data only cover the years 2014-2017 while data in IFs covers 2006-2014. Moreover, the values in the overlapping year 2014 differ so much that we might need to create them as new series.
'''GovWBDoingBusImportDays; SeriesGovWBDoingBusContainerImportCostUSD; SeriesGovWBDoingBusContainerExportCostUSD.'''

GovWBDoingBusContainExportCostUSDNew, calculated by adding the Documentary compliance and Border compliance costs for import together.

GovWBDoingBusContainImportCostUSDNew, calculated by <span style="display: inline !important; float: none; background-color: rgb(255, 255, 255); color: rgb(51, 51, 51); font-family: sans-serif,arial,verdana,"trebuchet ms" ; font-size: 13px; font-style: normal; font-variant: font-weight: 400; letter-spacing: orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: -webkit-text-stroke-width: white-space: word-spacing: 0px;">adding the Documentary compliance and Border compliance costs for export together.

GovWBDoingBusImportDaysNew, calculated by adding <span style="display: inline !important; float: none; background-color: rgb(255, 255, 255); color: rgb(51, 51, 51); font-family: sans-serif,arial,verdana,"trebuchet ms" ; font-size: 13px; font-style: normal; font-variant: font-weight: 400; letter-spacing: orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: -webkit-text-stroke-width: white-space: word-spacing: 0px;">the Documentary compliance and Border compliance time for import together.

== '''2024 Update: Data Pulling Instructions''' ==
'''For the 2024 update, the Doing Business project faced criticism and was discontinued in 2021.'''

We updated 1 series in preprocessor, '''GovWBDoingBusinessCostofStarting.'''

* Download archive corrected data from https://archive.doingbusiness.org/en/doingbusiness[[File:Image dobu 1.png|none|thumb|878x878px]]
* Open the downloaded file and in the "All Data" tab, find the Cost - Men (% of income per capita) and Cost - Women (% of income per capita) under Starting a business.[[File:Image dobu 2.png|none|thumb|1005x1005px]]
* Take an average of the 2 columns listed above to get the new values.
* Compare the new values with the values in IFs.
* Blend in the new values to the values in IFs followed by 2 rules:
** If he new values are null, then use the values in IFs to fill the null.
** If the new values are not null, then use the new values.
* The final series contains values from 2003 to 2020.

IMF Global Debt Database

2025-08-04T20:06:56Z

Andrew.French: year range of data --> 1950-2021 changed to 1950-2023

== SUMMARY ==
The Global Debt Database (GDD) is the result of a multiyear investigative process that started with the October 2016 Fiscal Monitor. The dataset comprises total gross debt of the (private and public) nonfinancial sector for an unbalanced panel of 190 advanced economies, emerging market economies and low-income countries, dating back to 1950. Both the private and public indicators that make up the GDD have a range from 1950-2023 and therefore are not updated any further.

The Data Team uses the GDD for series such as '''SeriesGovtDebt%GDPIMF''' and '''SeriesGovtDebtGen%GDPIMF,''' which both measure Government Debt.

For instructions on how to pull data from the GDD, refer to the instructions below.

== STEPS TO PULL FROM GLOBAL DEBT DATABASE ==

Step 1: Navigate to the [https://www.imf.org/external/datamapper/datasets/GDD Global Debt Database Home Page]
[[File:GDD IMG STEP 01.png|center|thumb|750x750px|Global Debt Database Home Page]]

Step 2: Scroll down and click the desired indicator (ex. General Government Debt)
[[File:GDD IMG STEP 02.png|center|thumb|750x750px|GDD Indicators]]

You will be navigated to this page:
[[File:GDD IMG STEP 2A.png|center|thumb|750x750px|General Government Debt Data Page]]

Step 3: Scroll down and select the Excel File button under All Country Data to download the data for that indicator
[[File:Screenshot 2023-01-26 at 11.08.22 AM.png|center|thumb|750x750px|All Country Data Download Option]]

Joint United Nations Programme on HIV/AIDS (UNAIDS)

2025-06-23T19:32:04Z

Andrew.French:

== 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".

== Tables in IFs ==
The following 6 tables in IFs are pulled from UNAIDS.
{| cellspacing="0" border="1" bgcolor="#ffffff"
|-
! bgcolor="#c0c0c0" | Variable
! bgcolor="#c0c0c0" | Group
! bgcolor="#c0c0c0" | Definition
! bgcolor="#c0c0c0" | Source
! bgcolor="#c0c0c0" | Unit
! bgcolor="#c0c0c0" | Formula
!Name In Source
!UsedInPreprocessor
!UsedInPreprocessorFileName
|- valign="top"
| SeriesHealthUNAIDSTotalHIVHighEst
| Population, Health
| High estimate of nuber of people living with HIV
| United Nations Program on HIV/AIDS (UNAIDS)
| Millions
| align="right" | /1,000,000
|People living with HIV - All ages
|1
|POPULATION
|-
|HealthUNAIDSTotalHIVMidEst
|Population, Health
|Mid-range estimate of number of total population with HIV
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|People living with HIV - All ages
|1
|POPULATION
|-
|HealthUNAIDSTotalHIVLowEst
|Population, Health
|Low estimate of number of total population living with HIV
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|People living with HIV - All ages
|1
|POPULATION
|-
|HealthUNAIDSDeathsLowEst
|Population, Health
|Low estimate of number of deaths from AIDS
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|AIDS-related deaths - All ages
|1
|POPULATION
|-
|HealthUNAIDSDeathsHighEst
|Population, Health
|High estimate of number of deaths from AIDS
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|AIDS-related deaths - All ages
|1
|POPULATION
|-
|HealthUNAIDSARTCoverMidEst
|Population, Health
|Mid-range estimate antiretroviral therapy coverage (%)
|United Nations Program on HIV/AIDS (UNAIDS)
|Percent
|/100
|People living with HIV receiving ART (%)
|1
|HEALTH
|}
For the 2025 update, we pulled 6 tables.

== Data Instruction ==
# 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.
# 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]]
# This is what the data will look like upon downloading the CSV file from UNAIDS.[[File:UNAIDS Data Pull.png|thumb|1147x1147px]]
# 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.
# '''To pull the following tables:'''
## SeriesHealthUNAIDSTotalHIVHighEst
## HealthUNAIDSTotalHIVMidEst
## HealthUNAIDSTotalHIVLowEst
### Search "People living with HIV - All ages" in the bar.
### For these tables, the unit is Millions. Divide the data in the excel by /1,000,000 to get the correct unit.
# '''To pull the following tables:'''
## HealthUNAIDSDeathsLowEst
## HealthUNAIDSDeathsHighEst
### Search "AIDS-related deaths - All ages" in the bar.
### For these tables, the unit is Millions. Divide the data in the excel by /1,000,000 to get the correct unit.
# '''To pull the following table:'''
## HealthUNAIDSARTCoverMidEst
### 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.

== Notes ==
# 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"
# 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

File:UNAIDS Data Pull.png

2025-06-23T19:29:41Z

Andrew.French:

This screenshot shows the formatting of the data once pulled from UNAIDS as a CSV file.

Joint United Nations Programme on HIV/AIDS (UNAIDS)

2025-06-20T21:04:22Z

Andrew.French:

== 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".

== Tables in IFs ==
The following 6 tables in IFs are pulled from UNAIDS.
{| cellspacing="0" border="1" bgcolor="#ffffff"
|-
! bgcolor="#c0c0c0" | Variable
! bgcolor="#c0c0c0" | Group
! bgcolor="#c0c0c0" | Definition
! bgcolor="#c0c0c0" | Source
! bgcolor="#c0c0c0" | Unit
! bgcolor="#c0c0c0" | Formula
!Name In Source
!UsedInPreprocessor
!UsedInPreprocessorFileName
|- valign="top"
| SeriesHealthUNAIDSTotalHIVHighEst
| Population, Health
| High estimate of nuber of people living with HIV
| United Nations Program on HIV/AIDS (UNAIDS)
| Millions
| align="right" | /1,000,000
|People living with HIV - All ages
|1
|POPULATION
|-
|HealthUNAIDSTotalHIVMidEst
|Population, Health
|Mid-range estimate of number of total population with HIV
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|People living with HIV - All ages
|1
|POPULATION
|-
|HealthUNAIDSTotalHIVLowEst
|Population, Health
|Low estimate of number of total population living with HIV
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|People living with HIV - All ages
|1
|POPULATION
|-
|HealthUNAIDSDeathsLowEst
|Population, Health
|Low estimate of number of deaths from AIDS
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|AIDS-related deaths - All ages
|1
|POPULATION
|-
|HealthUNAIDSDeathsHighEst
|Population, Health
|High estimate of number of deaths from AIDS
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|AIDS-related deaths - All ages
|1
|POPULATION
|-
|HealthUNAIDSARTCoverMidEst
|Population, Health
|Mid-range estimate antiretroviral therapy coverage (%)
|United Nations Program on HIV/AIDS (UNAIDS)
|Percent
|/100
|People living with HIV receiving ART (%)
|1
|HEALTH
|}
For the 2025 update, we pulled 6 tables.

== Data Instruction ==
# 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.
# 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]]
# Each file will have four types of data for the years: 1990 1990_lower 1990_upper. The year in the numerical format (1990) is the mid range estimate. The year_upper is the high estimate number and the year_lower is the low estimate number. This is how we will organize the data for the respective series.
# 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:'''
## SeriesHealthUNAIDSTotalHIVHighEst
## HealthUNAIDSTotalHIVMidEst
## HealthUNAIDSTotalHIVLowEst
### Search "People living with HIV - All ages" in the bar.
### For these tables, the unit is Millions. Divide the data in the excel by /1,000,000 to get the correct unit.
# '''To pull the following tables:'''
## HealthUNAIDSDeathsLowEst
## HealthUNAIDSDeathsHighEst
### Search "AIDS-related deaths - All ages" in the bar.
### For these tables, the unit is Millions. Divide the data in the excel by /1,000,000 to get the correct unit.
# '''To pull the following table:'''
## HealthUNAIDSARTCoverMidEst
### 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.

== Notes ==
# 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"
# 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

Joint United Nations Programme on HIV/AIDS (UNAIDS)

2025-06-20T21:03:25Z

Andrew.French: Updated pulling information for the 2025 update with a refreshed source summary

== 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.

== Tables in IFs ==
The following 6 tables in IFs are pulled from UNAIDS.
{| cellspacing="0" border="1" bgcolor="#ffffff"
|-
! bgcolor="#c0c0c0" | Variable
! bgcolor="#c0c0c0" | Group
! bgcolor="#c0c0c0" | Definition
! bgcolor="#c0c0c0" | Source
! bgcolor="#c0c0c0" | Unit
! bgcolor="#c0c0c0" | Formula
!Name In Source
!UsedInPreprocessor
!UsedInPreprocessorFileName
|- valign="top"
| SeriesHealthUNAIDSTotalHIVHighEst
| Population, Health
| High estimate of nuber of people living with HIV
| United Nations Program on HIV/AIDS (UNAIDS)
| Millions
| align="right" | /1,000,000
|People living with HIV - All ages
|1
|POPULATION
|-
|HealthUNAIDSTotalHIVMidEst
|Population, Health
|Mid-range estimate of number of total population with HIV
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|People living with HIV - All ages
|1
|POPULATION
|-
|HealthUNAIDSTotalHIVLowEst
|Population, Health
|Low estimate of number of total population living with HIV
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|People living with HIV - All ages
|1
|POPULATION
|-
|HealthUNAIDSDeathsLowEst
|Population, Health
|Low estimate of number of deaths from AIDS
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|AIDS-related deaths - All ages
|1
|POPULATION
|-
|HealthUNAIDSDeathsHighEst
|Population, Health
|High estimate of number of deaths from AIDS
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|AIDS-related deaths - All ages
|1
|POPULATION
|-
|HealthUNAIDSARTCoverMidEst
|Population, Health
|Mid-range estimate antiretroviral therapy coverage (%)
|United Nations Program on HIV/AIDS (UNAIDS)
|Percent
|/100
|People living with HIV receiving ART (%)
|1
|HEALTH
|}
For the 2025 update, we pulled 6 tables.

== Data Instruction ==
# 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.
# 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]]
# Each file will have four types of data for the years: 1990 1990_lower 1990_upper. The year in the numerical format (1990) is the mid range estimate. The year_upper is the high estimate number and the year_lower is the low estimate number. This is how we will organize the data for the respective series.
# 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:'''
## SeriesHealthUNAIDSTotalHIVHighEst
## HealthUNAIDSTotalHIVMidEst
## HealthUNAIDSTotalHIVLowEst
### Search "People living with HIV - All ages" in the bar.
### For these tables, the unit is Millions. Divide the data in the excel by /1,000,000 to get the correct unit.
# '''To pull the following tables:'''
## HealthUNAIDSDeathsLowEst
## HealthUNAIDSDeathsHighEst
### Search "AIDS-related deaths - All ages" in the bar.
### For these tables, the unit is Millions. Divide the data in the excel by /1,000,000 to get the correct unit.
# '''To pull the following table:'''
## HealthUNAIDSARTCoverMidEst
### 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.

== Notes ==
# 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"
# 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

Joint United Nations Programme on HIV/AIDS (UNAIDS)

2025-06-08T02:41:30Z

Andrew.French: /* Notes for 2025 Update */

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. 

{| cellspacing="0" border="1" bgcolor="#ffffff"
|+ '''DataDict 720'''
|-
! bgcolor="#c0c0c0" | Table
! bgcolor="#c0c0c0" | Group
! bgcolor="#c0c0c0" | Definition
! bgcolor="#c0c0c0" | Source
! bgcolor="#c0c0c0" | Last IFs Update
! bgcolor="#c0c0c0" | UsedInPreprocessor
! bgcolor="#c0c0c0" | Years
|- valign="top"
| 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
| align="right" | Yes
| 
|- valign="top"
| 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
| align="right" | No
| 
|- valign="top"
| 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
| align="right" | Yes
| 
|- valign="top"
| 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
| align="right" | Yes
| 
|- valign="top"
| 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
| align="right" | Yes
| 
|- valign="top"
| 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
| align="right" | No
| 
|- valign="top"
| 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
| align="right" | Yes
| 
|- valign="top"
| 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
| align="right" | Yes
| 
|- valign="top"
| 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
| align="right" | No
| 
|- valign="top"
| 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
| align="right" | No
| 
|}

= Non-preprocessor series  =

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"
|+ '''DataDict 720'''
|-
! bgcolor="#c0c0c0" | Table
! bgcolor="#c0c0c0" | Group
! bgcolor="#c0c0c0" | Definition
! bgcolor="#c0c0c0" | Source
! bgcolor="#c0c0c0" | Last IFs Update
! bgcolor="#c0c0c0" | UsedInPreprocessor
! bgcolor="#c0c0c0" | Years
|- valign="top"
| 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
| align="right" | No
| 
|- valign="top"
| SeriesHealthHIVARTAdultNeedSPECTRUM
| Population, Health
| Adults Needing Antiretroviral Treatment, Data and Forecast 
| UNAIDS, data and forecast from EPP-Spectrum Software
| 2010/01/07
| align="right" | No
| 
|- valign="top"
| SeriesHealthHIVARTAdultRcvdSPECTRUM
| Population, Health
| Adults Receiving Antiretroviral Treatment, Data and Forecast 
| UNAIDS, data and forecast from EPP-Spectrum Software
| 2010/01/07
| align="right" | No
| 
|- valign="top"
| SeriesHealthHIVARTChildNeedSPECTRUM
| Population, Health
| Children Needing Antiretroviral Treatment, Data and Forecast 
| UNAIDS, data and forecast from EPP-Spectrum Software
| 2010/01/07
| align="right" | No
| 
|- valign="top"
| SeriesHealthHIVARTChildRcvdSPECTRUM
| Population, Health
| Children Receiving Antiretroviral Treatment
| UNAIDS, data and forecast from EPP-Spectrum Software
| 2010/01/07
| align="right" | No
| 
|- valign="top"
| 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
| align="right" | No
| 
|- valign="top"
| 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
| align="right" | No
| 
|- valign="top"
| 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
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDS%AdultTestHIV
| Population, Health
| Percentage of adults who received HIV test and results 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| 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/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdult%CondomUse
| Population, Health
| Condom use at last sex (%) - # of Adults
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/07/31
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdultHIV%HighEst2013
| Population, Health
| High estimate of percentage of adults (15+) with HIV
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/02
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdultHIV%LowEst2013
| Population, Health
| Low estimate of percentage of adults (15+)with HIV
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/02
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdultHIV%MidEst2013
| Population, Health
| Mid-range estimate of percentage of adults (15+) with HIV
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/02
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdultHIVFemaleHighEst
| Population, Health
| High estimate of Adult HIV Prevalence (#) Females 15+ 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/02
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdultHIVFemaleLowEst
| Population, Health
| Low estimate of Adult HIV Prevalence (#) Females 15+ 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/02
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdultHIVFemaleMidEst
| Population, Health
| Mid-range estimate of Adult HIV Prevalence (#) Females 15+ 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/02
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdultHIVMaleHighEst
| Population, Health
| High estimate of Adult HIV Prevalence (#) Males 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/02
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdultHIVMaleLowEst
| Population, Health
| Low estimate of Adult HIV Prevalence (#) Males 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/02
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdultHIVMaleMidEst
| Population, Health
| Mid-range estimate of Adult HIV Prevalence (#) Males 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/02
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSARTCoverHighEst
| Population, Health
| High estimate antiretroviral therapy Coverage (%)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSARTCoverLowEst
| Population, Health
| Low estimate antiretroviral therapy Coverage (%)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSARTCoverMidEst
| Population, Health
| Mid-range estimate antiretroviral therapy Coverage (%)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSDeathsHighEst2013
| Population, Health
| High estimate of number of deaths from AIDS
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/07/25
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSDeathsLowEst2013
| Population, Health
| Low estimate of number of deaths from AIDS
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/07/25
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSDeathsMidEst2013
| Population, Health
| Mid-range estimate of number of deaths from AIDS
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/07/25
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSDomesticSpending
| Population, Health
| Domestic Spending on HIV/AIDS current USD 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSFemales15-24HIVHighEst
| Population, Health
| High estimate of Young People Prevalence (Females 15-24)
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSFemales15-24HIVLowEst
| Population, Health
| Low estimate of Young People Prevalence (Females 15-24)
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSFemales15-24HIVMidEst
| Population, Health
| Mid-range estimate of Young People Prevalence (Females 15-24)
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSHIVTBPatientsART
| Population, Health
| The number of HIV+ TB Patients on antiretroviral therapy
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSHIVTravelRestriction
| Population, Health
| Travel Restrictions. 0 = No Restriction, 1= Restriction
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSIDU%HIV
| Population, Health
| The HIV Prevalence among Injection drug users (%) 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSMales15-24HIVHighEst
| Population, Health
| High estimate for Young People Prevalence (Males 15-24) 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSMales15-24HIVLowEst
| Population, Health
| Low estimate for Young People Prevalence (Males 15-24) 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSMales15-24HIVMidEst
| Population, Health
| Mid-range estimate for Young People Prevalence (Males 15-24) 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSNewHIVInfect0-14HighEst
| Population, Health
| High estimate of new HIV Infections (Ages 0-14) (#)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSNewHIVInfect0-14LowEst
| Population, Health
| Low estimate of new HIV Infections (Ages 0-14) (#)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSNewHIVInfect0-14MidEst
| Population, Health
| Mid-range estimate of new HIV Infections (Ages 0-14) (#)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSNewHIVInfectAdultHighEst
| Population, Health
| High estimate of New Infections (ages 15+)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSNewHIVInfectAdultLowEst
| Population, Health
| Low estimate of New Infections (ages 15+)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSNewHIVInfectAdultMidEst
| Population, Health
| Mid-range estimate of New Infections (ages 15+)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSNewHIVInfectTotalHighEst
| Population, Health
| High estimate of New Infections (all ages)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSNewHIVInfectTotalLowEst
| Population, Health
| Low estimate of New Infections (all ages)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSNewHIVInfectTotalMidEst
| Population, Health
| Mid-range estimate of New Infections (all ages)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| 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/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| 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/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| 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/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| 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/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSTotalAdultHIVHighEst
| Population, Health
| High estimate of Adult HIV Prevalence (#) Total
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSTotalAdultHIVLowEst
| Population, Health
| Low estimate of Adult HIV Prevalence (#) Total
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSTotalAdultHIVMidEst
| Population, Health
| Mid-range estimate of Adult HIV Prevalence (#) Total
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSTotalART
| Population, Health
| Number of people on antiretroviral therapy (#) 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSTotalHIVHighEst2013
| Population, Health
| High estimate of Adult HIV Prevalence (#) Total
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSTotalHIVLowEst2013
| Population, Health
| Low estimate of Adult HIV Prevalence (#) Total
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSTotalHIVMidEst2013
| Population, Health
| Mid-range estimate of Adult HIV Prevalence (#) Total
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| 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 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
| 2006/12
| align="right" | 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/ 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 2025 Update ==
{| cellspacing="0" border="1" bgcolor="#ffffff"
|-
! bgcolor="#c0c0c0" | Variable
! bgcolor="#c0c0c0" | Group
! bgcolor="#c0c0c0" | Definition
! bgcolor="#c0c0c0" | Source
! bgcolor="#c0c0c0" | Unit
! bgcolor="#c0c0c0" | Formula
!Name In Source
!UsedInPreprocessor
!UsedInPreprocessorFileName
|- valign="top"
| SeriesHealthUNAIDSTotalHIVHighEst
| Population, Health
| High estimate of nuber of people living with HIV
| United Nations Program on HIV/AIDS (UNAIDS)
| Millions
| align="right" | /1,000,000
|People living with HIV - All ages
|1
|POPULATION
|-
|HealthUNAIDSTotalHIVMidEst
|Population, Health
|Mid-range estimate of number of total population with HIV
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|People living with HIV - All ages
|1
|POPULATION
|-
|HealthUNAIDSTotalHIVLowEst
|Population, Health
|Low estimate of number of total population living with HIV
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|People living with HIV - All ages
|1
|POPULATION
|-
|HealthUNAIDSDeathsLowEst
|Population, Health
|Low estimate of number of deaths from AIDS
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|AIDS-related deaths - All ages
|1
|POPULATION
|-
|HealthUNAIDSDeathsHighEst
|Population, Health
|High estimate of number of deaths from AIDS
|United Nations Program on HIV/AIDS (UNAIDS)
|Millions
|/1,000,000
|AIDS-related deaths - All ages
|1
|POPULATION
|-
|HealthUNAIDSARTCoverMidEst
|Population, Health
|Mid-range estimate antiretroviral therapy coverage (%)
|United Nations Program on HIV/AIDS (UNAIDS)
|Percent
|/100
|People living with HIV receiving ART (%)
|1
|HEALTH
|}
For the 2025 update, we pulled 6 tables.

=== To Pull the Data ===

# 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.
# 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]]
# Each file will have four types of data for the years: 1990 1990_lower 1990_upper. The year in the numerical format (1990) is the mid range estimate. The year_upper is the high estimate number and the year_lower is the low estimate number. This is how we will organize the data for the respective series.
# 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:'''
## SeriesHealthUNAIDSTotalHIVHighEst
## HealthUNAIDSTotalHIVMidEst
## HealthUNAIDSTotalHIVLowEst
### Search "People living with HIV - All ages" in the bar.
### For these tables, the unit is Millions. Divide the data in the excel by /1,000,000 to get the correct unit.
# '''To pull the following tables:'''
## HealthUNAIDSDeathsLowEst
## HealthUNAIDSDeathsHighEst
### Search "AIDS-related deaths - All ages" in the bar.
### For these tables, the unit is Millions. Divide the data in the excel by /1,000,000 to get the correct unit.
# '''To pull the following table:'''
## HealthUNAIDSARTCoverMidEst
### 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.
NOTES:

# 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"
# 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

Joint United Nations Programme on HIV/AIDS (UNAIDS)

2025-06-04T16:51:04Z

Andrew.French: Added link to GitHub repository in order to separate data for future data pulls.

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. 

{| cellspacing="0" border="1" bgcolor="#ffffff"
|+ '''DataDict 720'''
|-
! bgcolor="#c0c0c0" | Table
! bgcolor="#c0c0c0" | Group
! bgcolor="#c0c0c0" | Definition
! bgcolor="#c0c0c0" | Source
! bgcolor="#c0c0c0" | Last IFs Update
! bgcolor="#c0c0c0" | UsedInPreprocessor
! bgcolor="#c0c0c0" | Years
|- valign="top"
| 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
| align="right" | Yes
| 
|- valign="top"
| 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
| align="right" | No
| 
|- valign="top"
| 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
| align="right" | Yes
| 
|- valign="top"
| 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
| align="right" | Yes
| 
|- valign="top"
| 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
| align="right" | Yes
| 
|- valign="top"
| 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
| align="right" | No
| 
|- valign="top"
| 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
| align="right" | Yes
| 
|- valign="top"
| 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
| align="right" | Yes
| 
|- valign="top"
| 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
| align="right" | No
| 
|- valign="top"
| 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
| align="right" | No
| 
|}

= Non-preprocessor series  =

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"
|+ '''DataDict 720'''
|-
! bgcolor="#c0c0c0" | Table
! bgcolor="#c0c0c0" | Group
! bgcolor="#c0c0c0" | Definition
! bgcolor="#c0c0c0" | Source
! bgcolor="#c0c0c0" | Last IFs Update
! bgcolor="#c0c0c0" | UsedInPreprocessor
! bgcolor="#c0c0c0" | Years
|- valign="top"
| 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
| align="right" | No
| 
|- valign="top"
| SeriesHealthHIVARTAdultNeedSPECTRUM
| Population, Health
| Adults Needing Antiretroviral Treatment, Data and Forecast 
| UNAIDS, data and forecast from EPP-Spectrum Software
| 2010/01/07
| align="right" | No
| 
|- valign="top"
| SeriesHealthHIVARTAdultRcvdSPECTRUM
| Population, Health
| Adults Receiving Antiretroviral Treatment, Data and Forecast 
| UNAIDS, data and forecast from EPP-Spectrum Software
| 2010/01/07
| align="right" | No
| 
|- valign="top"
| SeriesHealthHIVARTChildNeedSPECTRUM
| Population, Health
| Children Needing Antiretroviral Treatment, Data and Forecast 
| UNAIDS, data and forecast from EPP-Spectrum Software
| 2010/01/07
| align="right" | No
| 
|- valign="top"
| SeriesHealthHIVARTChildRcvdSPECTRUM
| Population, Health
| Children Receiving Antiretroviral Treatment
| UNAIDS, data and forecast from EPP-Spectrum Software
| 2010/01/07
| align="right" | No
| 
|- valign="top"
| 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
| align="right" | No
| 
|- valign="top"
| 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
| align="right" | No
| 
|- valign="top"
| 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
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDS%AdultTestHIV
| Population, Health
| Percentage of adults who received HIV test and results 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| 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/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdult%CondomUse
| Population, Health
| Condom use at last sex (%) - # of Adults
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/07/31
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdultHIV%HighEst2013
| Population, Health
| High estimate of percentage of adults (15+) with HIV
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/02
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdultHIV%LowEst2013
| Population, Health
| Low estimate of percentage of adults (15+)with HIV
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/02
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdultHIV%MidEst2013
| Population, Health
| Mid-range estimate of percentage of adults (15+) with HIV
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/02
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdultHIVFemaleHighEst
| Population, Health
| High estimate of Adult HIV Prevalence (#) Females 15+ 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/02
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdultHIVFemaleLowEst
| Population, Health
| Low estimate of Adult HIV Prevalence (#) Females 15+ 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/02
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdultHIVFemaleMidEst
| Population, Health
| Mid-range estimate of Adult HIV Prevalence (#) Females 15+ 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/02
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdultHIVMaleHighEst
| Population, Health
| High estimate of Adult HIV Prevalence (#) Males 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/02
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdultHIVMaleLowEst
| Population, Health
| Low estimate of Adult HIV Prevalence (#) Males 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/02
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSAdultHIVMaleMidEst
| Population, Health
| Mid-range estimate of Adult HIV Prevalence (#) Males 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/02
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSARTCoverHighEst
| Population, Health
| High estimate antiretroviral therapy Coverage (%)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSARTCoverLowEst
| Population, Health
| Low estimate antiretroviral therapy Coverage (%)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSARTCoverMidEst
| Population, Health
| Mid-range estimate antiretroviral therapy Coverage (%)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSDeathsHighEst2013
| Population, Health
| High estimate of number of deaths from AIDS
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/07/25
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSDeathsLowEst2013
| Population, Health
| Low estimate of number of deaths from AIDS
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/07/25
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSDeathsMidEst2013
| Population, Health
| Mid-range estimate of number of deaths from AIDS
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/07/25
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSDomesticSpending
| Population, Health
| Domestic Spending on HIV/AIDS current USD 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSFemales15-24HIVHighEst
| Population, Health
| High estimate of Young People Prevalence (Females 15-24)
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSFemales15-24HIVLowEst
| Population, Health
| Low estimate of Young People Prevalence (Females 15-24)
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSFemales15-24HIVMidEst
| Population, Health
| Mid-range estimate of Young People Prevalence (Females 15-24)
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSHIVTBPatientsART
| Population, Health
| The number of HIV+ TB Patients on antiretroviral therapy
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSHIVTravelRestriction
| Population, Health
| Travel Restrictions. 0 = No Restriction, 1= Restriction
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSIDU%HIV
| Population, Health
| The HIV Prevalence among Injection drug users (%) 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSMales15-24HIVHighEst
| Population, Health
| High estimate for Young People Prevalence (Males 15-24) 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSMales15-24HIVLowEst
| Population, Health
| Low estimate for Young People Prevalence (Males 15-24) 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSMales15-24HIVMidEst
| Population, Health
| Mid-range estimate for Young People Prevalence (Males 15-24) 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSNewHIVInfect0-14HighEst
| Population, Health
| High estimate of new HIV Infections (Ages 0-14) (#)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSNewHIVInfect0-14LowEst
| Population, Health
| Low estimate of new HIV Infections (Ages 0-14) (#)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSNewHIVInfect0-14MidEst
| Population, Health
| Mid-range estimate of new HIV Infections (Ages 0-14) (#)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSNewHIVInfectAdultHighEst
| Population, Health
| High estimate of New Infections (ages 15+)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSNewHIVInfectAdultLowEst
| Population, Health
| Low estimate of New Infections (ages 15+)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSNewHIVInfectAdultMidEst
| Population, Health
| Mid-range estimate of New Infections (ages 15+)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSNewHIVInfectTotalHighEst
| Population, Health
| High estimate of New Infections (all ages)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSNewHIVInfectTotalLowEst
| Population, Health
| Low estimate of New Infections (all ages)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSNewHIVInfectTotalMidEst
| Population, Health
| Mid-range estimate of New Infections (all ages)
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| 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/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| 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/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| 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/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| 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/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSTotalAdultHIVHighEst
| Population, Health
| High estimate of Adult HIV Prevalence (#) Total
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSTotalAdultHIVLowEst
| Population, Health
| Low estimate of Adult HIV Prevalence (#) Total
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSTotalAdultHIVMidEst
| Population, Health
| Mid-range estimate of Adult HIV Prevalence (#) Total
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSTotalART
| Population, Health
| Number of people on antiretroviral therapy (#) 
| UNAIDS AIDSinfo; [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/01
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSTotalHIVHighEst2013
| Population, Health
| High estimate of Adult HIV Prevalence (#) Total
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSTotalHIVLowEst2013
| Population, Health
| Low estimate of Adult HIV Prevalence (#) Total
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| SeriesHealthUNAIDSTotalHIVMidEst2013
| Population, Health
| Mid-range estimate of Adult HIV Prevalence (#) Total
| UNAIDS AIDSinfo: [http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/ http://www.unaids.org/en/dataanalysis/datatools/aidsinfo/]
| 2013/08/05
| align="right" | No
| 
|- valign="top"
| 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 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
| 2006/12
| align="right" | 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/ 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 ==
{| cellspacing="0" border="1" bgcolor="#ffffff"
|-
! bgcolor="#c0c0c0" | Variable
! bgcolor="#c0c0c0" | Group
! bgcolor="#c0c0c0" | Definition
! bgcolor="#c0c0c0" | Source
! bgcolor="#c0c0c0" | Unit
! bgcolor="#c0c0c0" | Formula
!Name In Source
!UsedInPreprocessor
!UsedInPreprocessorFileName
|- valign="top"
| SeriesHealthUNAIDSTotalHIVHighEst
| Population, Health
| High estimate of nuber of people living with HIV
| United Nations Program on HIV/AIDS (UNAIDS)
| Millions
| align="right" | /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 ===

# 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.
# 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]]
# 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.
# 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:'''
## SeriesHealthUNAIDSTotalHIVHighEst
## HealthUNAIDSTotalHIVMidEst
## HealthUNAIDSTotalHIVLowEst
### Search "People living with HIV - All ages" in the bar.
### For these tables, the unit is Millions. Divide the data in the excel by /1,000,000 to get the correct unit.
# '''To pull the following tables:'''
## HealthUNAIDSDeathsLowEst
## HealthUNAIDSDeathsHighEst
### Search "AIDS-related deaths - All ages" in the bar.
### For these tables, the unit is Millions. Divide the data in the excel by /1,000,000 to get the correct unit.
# '''To pull the following table:'''
## HealthUNAIDSARTCoverMidEst
### 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.
NOTES:

# 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"
# 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

Worldwide Governance Indicators

2025-05-16T20:19:29Z

Andrew.French: Updated source as well as some language used to maintain consistency with source

The six aggregate indicators are based on over 30 underlying data sources reporting the perceptions of governance of a large number of survey respondents and expert assessments worldwide. Details on the underlying data sources, the aggregation method, and the interpretation of the indicators, can be found in the WGI methodology paper:

Daniel Kaufmann, Aart Kraay and Massimo Mastruzzi (2010). "The Worldwide Governance Indicators : A Summary of Methodology, Data and Analytical Issues". World Bank Policy Research Working Paper No. 5430

<nowiki>http://papers.ssrn.com/sol3/papers.cfm?abstract_id=1682130</nowiki>

The governance indicator dataset was initiated in 1998 and grouped in as six dimension of governance: Voice and Accountability, Political Stability and Absence of Violence, Government Effectiveness, Regulatory Quality, Rule of Law, Control of Corruption. The dataset and detailed methodological description is available at http://info.worldbank.org/governance/wgi2007

Series taken from WGI:

{| border="1" cellpadding="0" cellspacing="0" width="64"
|-
| height="20" width="64" | SeriesGovernanceEffect
|-
| height="20" | SeriesGovernanceRegQual
|-
| height="20" | SeriesGovWBGovMatCorrupt
|-
| height="20" | SeriesGovWBGovMatPolStab
|-
| height="20" | SeriesGovWBGovMatRuleLaw
|-
| height="20" | SeriesGovWBGovMatVoiceAcct
|}

= Instructions on importing data from Worldwide Governance Indicators =

'''Introduction-'''

This section explains the methodology that is to be followed when importing World Governance Indicators (WGI) data into Ifs. It also describes certain problems that a user might face in interpreting, understanding the data

'''Source'''- WGI data is published by the World Bank. The data is available at this website , [http://data.worldbank.org/data-catalog/worldwide-governance-indicators http://data.worldbank.org/data-catalog/worldwide-governance-indicators]

'''Types of Data-'''Following categories of data need to be imported into Ifs
<ol style="list-style-type:lower-alpha;">
<li>'''GovernanceEffect-'''Indicator of Governance effectiveness on a scale of -2.5 to 2.5 , where higher is better</li>
<li>'''GovernanceRegQual-'''Indicator of Government regulatory quality, on a scale of -2.5 to 2.5, where a higher score is better</li>
<li>'''GovWBGovMatCorrupt-'''Indicator of Control of corruption, on a scale of -2.5 to 2.5, where a higher score indicates better control over corruption.</li>
<li>'''GovWBGovMatPolStab-'''Indicator of Political Stability and absence of violence. , on a scale of -2.5 to 2.5 where a higher score indicates higher political stability.</li>
<li>'''GovWBGovMatRuleLaw-'''Indicator of quality of rule of law, on a scale of -2.5 to 2.5, where a higher score indicates better rule of law.</li>
<li>'''GovWBGovMatVoiceAcct-'''Indicator of Voice and accountability, on a scale of -2.5 to 2.5 where a higher score indicates better Voice for citizens and higher accountability.</li>
</ol>

'''Country List to be Used-'''World Bank countries

'''Issues with Data import for certain countries-''' In certain  cases, IFs does not populate data in relation to countries such as Cape Verde, Taiwan, Ivory Coast. It is recommended, that the importer verify the data in relation to said countries in order to ensure that there are no discrepancies.

Worldwide Governance Indicators

2025-05-16T20:17:49Z

Andrew.French:

The six aggregate indicators are based on over 30 underlying data sources reporting the perceptions of governance of a large number of survey respondents and expert assessments worldwide. The governance indicator dataset was initiated in 1998 and grouped in as six dimension of governance: Voice and Accountability, Political Stability and Absence of Violence, Government Effectiveness, Regulatory Quality, Rule of Law, Control of Corruption. Details on the underlying data sources, the aggregation method, and the interpretation of the indicators, can be found in the WGI methodology paper:
Daniel Kaufmann, Aart Kraay and Massimo Mastruzzi (2010). "The Worldwide Governance Indicators : A Summary of Methodology, Data and Analytical Issues". World Bank Policy Research Working Paper No. 5430
http://papers.ssrn.com/sol3/papers.cfm?abstract_id=1682130

'''Series taken from WGI:'''
{| class="wikitable"
|Variable
|Definition
|-
|SeriesGovernanceEffect
|Governance quality, effectiveness (-2.5 to 2.5, higher is better)
|-
|SeriesGovernanceRegQual
|Governance quality, regulatory quality (-2.5 to 2.5, higher is better)
|-
|SeriesGovWBGovMatCorrupt
|Governance quality, control of corruption (-2.5 to 2.5, higher is better)
|-
|SeriesGovWBGovMatPolStab
|Governance quality, political stability (-2.5 to 2.5, higher is better)
|-
|SeriesGovWBGovMatRuleLaw
|Governance quality, rule of law (-2.5 to 2.5, higher is better)
|-
|SeriesGovWBGovMatVoiceAcct
|Governance quality, voice and accountability (-2.5 to 2.5, higher is better)
|}

=Instructions on importing data from Worldwide Governance Indicators=

WGI data is published by the World Bank. The data is available at this website: [https://www.worldbank.org/en/publication/worldwide-governance-indicators http://data.worldbank.org/data-catalog/worldwide-governance-indicators]. Download the whole WGI dataset through the link provided [https://www.worldbank.org/content/dam/sites/govindicators/doc/wgidataset.xlsx here]

==Specific Series Instructions & Discrepancies==
'''SeriesGovernanceEffect/SeriesGovernanceRegQual'''

*When pulling data for GovernanceEffect, only use '''estimate''' data
*Prior to importing the data into IFs, empty all cells that don't contain a numerical value. This is to avoid IFs creating values to fill in those cells.