Population preprocessor: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(One intermediate revision by the same user not shown)
Line 2: Line 2:


[[United_Nations_Statistics_Division:_MDG_Indicators]]
[[United_Nations_Statistics_Division:_MDG_Indicators]]
[[UNPD]]


There are clearly some preprocessor series that need to be updated: [[WHOSIS|WHOSIS]], [[UNAIDS|UNAIDS]]. A good amount of data also comes from the World Development Indicators ([[World_Development_Indicators|WDI]]).
There are clearly some preprocessor series that need to be updated: [[WHOSIS|WHOSIS]], [[UNAIDS|UNAIDS]]. A good amount of data also comes from the World Development Indicators ([[World_Development_Indicators|WDI]]).
Line 7: Line 9:
= Population series pulled into preprocessor  =
= Population series pulled into preprocessor  =


This table was created using DataDict (7.20) filtered by "Used in preprocessor" and then selecting the following groups: Population; Population, health.
 
 
{| border="1" cellpadding="0" cellspacing="0" width="320"
|- height="20"
| height="20" width="64" | Table
| width="64" | Definition
| width="64" | Source
| width="64" | Notes
| width="64" | Last IFs Update
|- height="20"
| height="20" | SeriesIlliteracy%
| Illiteracy rate
| WDI CD 04
|  
| 2005/01
|- height="20"
| height="20" | SeriesHealthUNAIDSDeathsHighEst
| High estimate of number of deaths from AIDS
| 2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008
| No Notes
| 2008/10/04
|- height="20"
| height="20" | SeriesHealthUNAIDSTotalHIVHighEst
| High estimate of nuber of people living with HIV
| 2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008
| No Notes
| 2008/10/04
|- height="20"
| height="20" | SeriesHealthUNAIDSDeathsLowEst
| Low estimate of number of deaths from AIDS
| 2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008
| No Notes
| 2008/10/28
|- height="20"
| height="20" | SeriesHealthUNAIDSDeathsMidEst
| Mid-range estimate of number of deaths from AIDS
| 2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008
| No Notes
| 2008/10/28
|- height="20"
| height="20" | SeriesHealthUNAIDSTotalHIVLowEst
| Low estimate of number of total population living with HIV
| 2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008
| No Notes
| 2008/10/28
|- height="20"
| height="20" | SeriesHealthUNAIDSTotalHIVMidEst
| Mid-range estimate of number of total population with HIV
| 2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008
| No Notes
| 2008/10/28
|- height="20"
| height="20" | SeriesForecastNetMigrationUNPD
| Medium-fertility variant Net migration both sexes by country, every five years 1955-2095 (millions) (Annualized version of ForecastNetMigrationMedUNPD2012Rev)
| See ForecastNetMigrationMedUNPD2012Rev
| Transformed data table by spreading out data in ForecastNetMigrationMedUNPD2012Rev provided every 5 years
| 2013/11/08
|- height="20"
| height="20" | SeriesHIVPeaks
| Year and infection rate at peak of HIV epidemic
| UN Pop Revision 2002 Annex Table 17, UN World Population Prospects 2012 Revision: http://esa.un.org/wpp/ASCII-Data/DISK_NAVIGATION_ASCII.htm
| PJO (2013)
| 2013/12/17
|- height="20"
| height="20" | SeriesForecastNetMigrationRateUNPD
| Migration Rate
| See ForecastNetMigrationUNPD and ForecastPopBothSexesMedUNPD2012Rev
| Transformed data table by dividing ForecastNetMigrationUNPD by ForecastPopBothSexesMedUNPD2012Rev and multiplying by 100
| 2014/01/27
|- height="20"
| height="20" | SeriesLaborInformal%TotalFemaleWB
| Labor, informal, as a share of total, female
| World Bank Gender Statistics
| dab; JEM; Data refer to non-agricultural emplyment only (i.e., exclude agriculture, hunting, forestry and fishing)
| 2014/04/28
|- height="20"
| height="20" | SeriesLaborInformal%TotalMaleWB
| Labor, informal, as a share of total, male
| World Bank Gender Statistics
| dab; JEM; Data refer to non-agricultural emplyment only (i.e., exclude agriculture, hunting, forestry and fishing)
| 2014/04/28
|- height="20"
| height="20" | SeriesInfMortMedUNPD
| Medium-fertility variant Infant mortality rate by country, every five years 1955-2010 ( infant deaths per 1,000 live births)
| http://esa.un.org/unpd/wpp/Excel-Data/population.htm
| 2010 assigned average of 2005-2010 and 2010-2015, and so on
| 2014/1/23
|- height="20"
| height="20" | SeriesLaborInformal%TotalAllBlended
| Labor, informal, as a share of total, all, blended from ILO-WIEGO and World Bank
| Blended from ILO-WEIGO and calculated World Bank
| DKB
| 2014/10/21
|- height="20"
| height="20" | SeriesLifExpectFemale
| Life expectancy at birth, female
| http://esa.un.org/wpp/Excel-Data/mortality.htm
| 1955 assigned average of 1950-1955 and 1955-1960, and so on
| 2015/02/21
|- height="20"
| height="20" | SeriesLifExpectMale
| Life expectancy at birth, Male
| http://esa.un.org/wpp/Excel-Data/mortality.htm
| 1955 assigned average of 1950-1955 and 1955-1960, and so on
| 2015/02/21
|- height="20"
| height="20" | SeriesCBR
| Crude birth rate
| WDI  BATCH PULL
| AD
| 2015/07/14
|- height="20"
| height="20" | SeriesCDR
| Crude death rate
| WDI  BATCH PULL
| AD
| 2015/07/14
|- height="20"
| height="20" | SeriesLabor
| Labor force size
| WDI 2015 BATCH PULL
| mjs; MJE
| 2015/07/22
|- height="20"
| height="20" | SeriesLaborAgr%TotFemale
| Employees, agriculture, female as % of female employment
| WDI 2015 BATCH PULL
| DKB
| 2015/07/22
|- height="20"
| height="20" | SeriesLaborAgr%TotMale
| Employees, agriculture, males as % of male employment
| WDI 2015 BATCH PULL
| DKB
| 2015/07/22
|- height="20"
| height="20" | SeriesLaborFemale%
| Portion of labor force made up by women
| WDI 2015 BATCH PULL
| mjs; MJE
| 2015/07/22
|- height="20"
| height="20" | SeriesLiteracyAdultTotal%
| Literacy rate, percent of adults (15 or older)
| WDI 2015 BATCH PULL
| DAB - New data did not blend well with original literacyAdult%. Therefore we created "new" and "old" series
| 2015/07/22
|- height="20"
| height="20" | SeriesPopContrUse%WDI
| Prevalence of contraceptive use
| WDI 2015 BATCH PULL
| MR;CN
| 2015/07/22
|- height="20"
| height="20" | SeriesPopulationUrban
| Urban population
| WDI 2015 BATCH PULL
| CN, TL
| 2015/07/22
|- height="20"
| height="20" | SeriesPopulationYouthDep%
| Population of young people (<15) as percent of total
| WDI 2015 BATCH PULL
| MR;CN
| 2015/07/22
|- height="20"
| height="20" | SeriesTFRMedUNPD
| Medium-fertility variant total fertility rate by country, every five years 1955-2010 (births)
| http://esa.un.org/wpp/Excel-Data/fertility.htm
| 2010 assigned average of 2005-2010 and 2010-2015, and so on
| 2016/02/23
|}


{| border="1" bgcolor="#ffffff" cellspacing="0"
{| border="1" bgcolor="#ffffff" cellspacing="0"
|+ <font face="Calibri" color="#000000">'''DataDict 720'''</font>
|-
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Table</font>
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Group</font>
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Definition</font>
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Source</font>
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Last IFs Update</font>
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">UsedInPreprocessor</font>
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Years</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesPopForeign%</font>
| <font face="Calibri" color="#000000">Population</font>
| <font face="Calibri" color="#000000">Foreign population as&nbsp;% of total population</font>
| <font face="Calibri" color="#000000">WDI 2015 BATCH PULL</font>
| <font face="Calibri" color="#000000">2015/07/22</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMalarDthsper100000</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Malaria deaths per 100,000 at all ages - annual</font>
| <font face="Calibri" color="#000000">Millennium Indicators Database, United Nation's Statistics Division; Available at [http://unstats.un.org/unsd/mi/mi_goals http://unstats.un.org/unsd/mi/mi_goals].</font>
| <font face="Calibri" color="#000000">2013/12/18</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingImpactFemales30to44</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Health impact for females 30 to 44</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingImpactFemales45to59</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Health impact for females 45 to 59</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingImpactFemales60to69</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Health impact for females 60 to 69</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingImpactMales30to44</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Health impact for males 30 to 44</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingImpactMales45to59</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Health impact for males 45 to 59</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingImpactMales60to69</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Health impact for males 60 to 69</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRFemales15to29</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among females 15 to 29</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRFemales30to44</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among females 30 to 44</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRFemales45to59</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among females 45 to 59</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRFemales60to69</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among females 60 to 69</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRFemales70to79</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among females 70 to 79</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRFemales80to100</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among females 80 plus</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRMales15to29</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among Males 15 to 29</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRMales30to44</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among Males 30 to 44</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRMales45to59</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among Males 45 to 59</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRMales60to69</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among Males 60 to 69</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRMales70to79</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among males 70 to 79</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRMales80to100</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among Males 80 plus</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingImpactFemales70to100</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Health impact for females 70 to 100</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingImpactMales70to100</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Health impact for males 70 and older</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthUNAIDSDeathsLowEst</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Low estimate of number of deaths from AIDS</font>
| <font face="Calibri" color="#000000">2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008</font>
| <font face="Calibri" color="#000000">2008/10/28</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthObesityFemales30+Est%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Percentage of females aged 30-100 who are obese</font>
| <font face="Calibri" color="#000000">WHO website [http://www.who.int/infobase/comparestart.aspx http://www.who.int/infobase/comparestart.aspx] access on 7/22/2008 at 3:41PM</font>
| <font face="Calibri" color="#000000">2008/07/22</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthObesityMales30+Est%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Percentage of males aged 30-100 who are obese</font>
| <font face="Calibri" color="#000000">WHO website, [http://www.who.int/infobase/comparestart.aspx http://www.who.int/infobase/comparestart.aspx] on 7/22/2008 at 2:00 PM</font>
| <font face="Calibri" color="#000000">2008/07/22</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthBMIFemales30+EstMean</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Average Body Mass Index for females aged 30-100</font>
| <font face="Calibri" color="#000000">WHO website [http://www.who.int/infobase/comparestart.aspx http://www.who.int/infobase/comparestart.aspx] access on 7/22/2008 at 3:41PM</font>
| <font face="Calibri" color="#000000">2008/07/22</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthBMIMales30+EstMean</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Average Body Mass Index for Males age 30-100</font>
| <font face="Calibri" color="#000000">WHO website [http://www.who.int/infobase/comparestart.aspx http://www.who.int/infobase/comparestart.aspx] access on 7/22/2008 at 3:41PM</font>
| <font face="Calibri" color="#000000">2008/07/22</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthUNAIDSDeathsMidEst</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Mid-range estimate of number of deaths from AIDS</font>
| <font face="Calibri" color="#000000">2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008</font>
| <font face="Calibri" color="#000000">2008/10/28</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthUNAIDSTotalHIVMidEst</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Mid-range estimate of number of total population with HIV</font>
| <font face="Calibri" color="#000000">2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008</font>
| <font face="Calibri" color="#000000">2008/10/28</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthUNAIDSDeathsHighEst</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">High estimate of number of deaths from AIDS</font>
| <font face="Calibri" color="#000000">2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008</font>
| <font face="Calibri" color="#000000">2008/10/04</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthUNAIDSTotalHIVHighEst</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">High estimate of nuber of people living with HIV</font>
| <font face="Calibri" color="#000000">2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008</font>
| <font face="Calibri" color="#000000">2008/10/04</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingFemales%SI</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">smoking rate estimates from WHO forecast on smoking impact on health<br/>forecast on smoking impact on health</font>
| <font face="Calibri" color="#000000">IFs Estimates using WHO forecasts of smoking impact and smoking rate data</font>
| <font face="Calibri" color="#000000">2011/03/09</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingMales%SI</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">smoking rate estimates from WHO forecast on smoking impact on health<br/>forecast on smoking impact on health</font>
| <font face="Calibri" color="#000000">IFs Estimates using WHO forecasts of smoking impact and smoking rate data</font>
| <font face="Calibri" color="#000000">2011/03/09</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthUNAIDSTotalHIVLowEst</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Low estimate of number of total population living with HIV</font>
| <font face="Calibri" color="#000000">2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008</font>
| <font face="Calibri" color="#000000">2008/10/28</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesPrev%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Prevalence of diabetes</font>
| <font face="Calibri" color="#000000">International Diabetes Federation's Diabetes Atlas; [http://www.eatlas.idf.org http://www.eatlas.idf.org]</font>
| <font face="Calibri" color="#000000">2013/12/13</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthIGTPrev%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Prevalence of impaired glucose intolerance</font>
| <font face="Calibri" color="#000000">International Diabetes Federation's Diabetes Atlas; [http://www.eatlas.idf.org http://www.eatlas.idf.org]</font>
| <font face="Calibri" color="#000000">2013/12/12</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingTCS</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Tobacco Control Score</font>
| <font face="Calibri" color="#000000">WHO provided by Cecilia</font>
| <font face="Calibri" color="#000000">2011/09/09</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesCBR</font>
| <font face="Calibri" color="#000000">Population</font>
| <font face="Calibri" color="#000000">Crude birth rate</font>
| <font face="Calibri" color="#000000">WDI BATCH PULL</font>
| <font face="Calibri" color="#000000">2015/07/14</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesCDR</font>
| <font face="Calibri" color="#000000">Population</font>
| <font face="Calibri" color="#000000">Crude death rate</font>
| <font face="Calibri" color="#000000">WDI BATCH PULL</font>
| <font face="Calibri" color="#000000">2015/07/14</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesTFRMedUNPD</font>
| <font face="Calibri" color="#000000">Population</font>
| <font face="Calibri" color="#000000">Medium-fertility variant total fertility rate by country, every five years 1955-2010 (births)</font>
| <font face="Calibri" color="#000000">[http://esa.un.org/wpp/Excel-Data/fertility.htm http://esa.un.org/wpp/Excel-Data/fertility.htm]</font>
| <font face="Calibri" color="#000000">2016/02/23</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesPopulationYouthDep%</font>
| <font face="Calibri" color="#000000">Population</font>
| <font face="Calibri" color="#000000">Population of young people (</font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">WDI 2015 BATCH PULL</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">2015/07/22</font></font>
| align="RIGHT" | <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Yes</font></font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">SeriesHealthSmokingPrevalenceWHOFemales%</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Population, Health</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Percent of females smoking a tobacco product on a daily or non-daily basis</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">WHO</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">2011/06/01</font></font>
| align="RIGHT" | <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Yes</font></font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">SeriesPopContrUse%WDI</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Population</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Prevalence of contraceptive use</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">WDI 2015 BATCH PULL</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">2015/07/22</font></font>
| align="RIGHT" | <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Yes</font></font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">SeriesPopulationUrban</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Population</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Urban population</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">WDI 2015 BATCH PULL</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">2015/07/22</font></font>
| align="RIGHT" | <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Yes</font></font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">SeriesHealthSmokingPrevalenceWHOMales%</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Population, Health</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Percent of males smoking a tobacco product on a daily or non-daily basis</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">WHO</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">2011/06/01</font></font>
| align="RIGHT" | <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Yes</font></font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">SeriesPopulation</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Population</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Population in millions</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">UNPD 2015 (DSR added Taiwan from WEO)</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">2015/09/18</font></font>
| align="RIGHT" | <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Yes</font></font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">SeriesForecastNetMigrationRateUNPD</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Population</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Migration Rate</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">See ForecastNetMigrationUNPD and ForecastPopBothSexesMedUNPD2012Rev</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">2014/01/27</font></font>
| align="RIGHT" | <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Yes</font></font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">SeriesForecastNetMigrationUNPD</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Population</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Medium-fertility variant Net migration both sexes by country, every five years 1955-2095 (millions) (Annualized version of ForecastNetMigrationMedUNPD2012Rev)</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">See ForecastNetMigrationMedUNPD2012Rev</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">2013/11/08</font></font>
| align="RIGHT" | <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Yes</font></font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">SeriesHIVPeaks</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Population, Health</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Year and infection rate at peak of HIV epidemic</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">UN Pop Revision 2002 Annex Table 17, UN World Population Prospects 2012 Revision: [http://esa.un.org/wpp/ASCII-Data/DISK_NAVIGATION_ASCII.htm http://esa.un.org/wpp/ASCII-Data/DISK_NAVIGATION_ASCII.htm]</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">2013/12/17</font></font>
| align="RIGHT" | <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Yes</font></font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">SeriesHouseholds</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Population</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Number of Households in millions</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">ITU 2011</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">2011/08/19</font></font>
| align="RIGHT" | <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Yes</font></font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">SeriesHealthExpPriv%Tot</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Population, Health</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Private expenditure on health (PvtHE) as&nbsp;% of Total Health Expenditure</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">WHO Global Health Expenditure Database</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">2014/04/22</font></font>
| align="RIGHT" | <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Yes</font></font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">SeriesHealthExpTot%GDP</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Population, Health</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Total health expenditure (THE)&nbsp;% Gross Domestic Product (GDP)</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">WHO Global Health Expenditure Database</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">2014/04/22</font></font>
| align="RIGHT" | <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Yes</font></font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">SeriesMalnChilSAMCured%Admission</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Population, Health</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Percent of SAM admissions that are successfully treated</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Various, SAM Project (ask David Bohl)</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">2016/01/14</font></font>
| align="RIGHT" | <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Yes</font></font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">SeriesSevereWasting</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Population, Health</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Percentage of children aged 0–59 months who are below minus three standard deviations from median weight-for-height of the WHO Child Growth Standards.</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">UNICEF/WHO/WBG</font></font>
| <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">2016/01/14</font></font>
| align="RIGHT" | <font face="Calibri" color="#000000"><font face="Calibri" color="#000000">Yes</font></font>
| <br/>
|}
|}

Latest revision as of 20:26, 6 June 2016

Sources

United_Nations_Statistics_Division:_MDG_Indicators

UNPD

There are clearly some preprocessor series that need to be updated: WHOSISUNAIDS. A good amount of data also comes from the World Development Indicators (WDI).

Population series pulled into preprocessor 

Table Definition Source Notes Last IFs Update
SeriesIlliteracy% Illiteracy rate WDI CD 04   2005/01
SeriesHealthUNAIDSDeathsHighEst High estimate of number of deaths from AIDS 2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008 No Notes 2008/10/04
SeriesHealthUNAIDSTotalHIVHighEst High estimate of nuber of people living with HIV 2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008 No Notes 2008/10/04
SeriesHealthUNAIDSDeathsLowEst Low estimate of number of deaths from AIDS 2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008 No Notes 2008/10/28
SeriesHealthUNAIDSDeathsMidEst Mid-range estimate of number of deaths from AIDS 2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008 No Notes 2008/10/28
SeriesHealthUNAIDSTotalHIVLowEst Low estimate of number of total population living with HIV 2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008 No Notes 2008/10/28
SeriesHealthUNAIDSTotalHIVMidEst Mid-range estimate of number of total population with HIV 2008 Report on the global AIDS epidemic, UNAIDS/WHO, July 2008 No Notes 2008/10/28
SeriesForecastNetMigrationUNPD Medium-fertility variant Net migration both sexes by country, every five years 1955-2095 (millions) (Annualized version of ForecastNetMigrationMedUNPD2012Rev) See ForecastNetMigrationMedUNPD2012Rev Transformed data table by spreading out data in ForecastNetMigrationMedUNPD2012Rev provided every 5 years 2013/11/08
SeriesHIVPeaks Year and infection rate at peak of HIV epidemic UN Pop Revision 2002 Annex Table 17, UN World Population Prospects 2012 Revision: http://esa.un.org/wpp/ASCII-Data/DISK_NAVIGATION_ASCII.htm PJO (2013) 2013/12/17
SeriesForecastNetMigrationRateUNPD Migration Rate See ForecastNetMigrationUNPD and ForecastPopBothSexesMedUNPD2012Rev Transformed data table by dividing ForecastNetMigrationUNPD by ForecastPopBothSexesMedUNPD2012Rev and multiplying by 100 2014/01/27
SeriesLaborInformal%TotalFemaleWB Labor, informal, as a share of total, female World Bank Gender Statistics dab; JEM; Data refer to non-agricultural emplyment only (i.e., exclude agriculture, hunting, forestry and fishing) 2014/04/28
SeriesLaborInformal%TotalMaleWB Labor, informal, as a share of total, male World Bank Gender Statistics dab; JEM; Data refer to non-agricultural emplyment only (i.e., exclude agriculture, hunting, forestry and fishing) 2014/04/28
SeriesInfMortMedUNPD Medium-fertility variant Infant mortality rate by country, every five years 1955-2010 ( infant deaths per 1,000 live births) http://esa.un.org/unpd/wpp/Excel-Data/population.htm 2010 assigned average of 2005-2010 and 2010-2015, and so on 2014/1/23
SeriesLaborInformal%TotalAllBlended Labor, informal, as a share of total, all, blended from ILO-WIEGO and World Bank Blended from ILO-WEIGO and calculated World Bank DKB 2014/10/21
SeriesLifExpectFemale Life expectancy at birth, female http://esa.un.org/wpp/Excel-Data/mortality.htm 1955 assigned average of 1950-1955 and 1955-1960, and so on 2015/02/21
SeriesLifExpectMale Life expectancy at birth, Male http://esa.un.org/wpp/Excel-Data/mortality.htm 1955 assigned average of 1950-1955 and 1955-1960, and so on 2015/02/21
SeriesCBR Crude birth rate WDI  BATCH PULL AD 2015/07/14
SeriesCDR Crude death rate WDI  BATCH PULL AD 2015/07/14
SeriesLabor Labor force size WDI 2015 BATCH PULL mjs; MJE 2015/07/22
SeriesLaborAgr%TotFemale Employees, agriculture, female as % of female employment WDI 2015 BATCH PULL DKB 2015/07/22
SeriesLaborAgr%TotMale Employees, agriculture, males as % of male employment WDI 2015 BATCH PULL DKB 2015/07/22
SeriesLaborFemale% Portion of labor force made up by women WDI 2015 BATCH PULL mjs; MJE 2015/07/22
SeriesLiteracyAdultTotal% Literacy rate, percent of adults (15 or older) WDI 2015 BATCH PULL DAB - New data did not blend well with original literacyAdult%. Therefore we created "new" and "old" series 2015/07/22
SeriesPopContrUse%WDI Prevalence of contraceptive use WDI 2015 BATCH PULL MR;CN 2015/07/22
SeriesPopulationUrban Urban population WDI 2015 BATCH PULL CN, TL 2015/07/22
SeriesPopulationYouthDep% Population of young people (<15) as percent of total WDI 2015 BATCH PULL MR;CN 2015/07/22
SeriesTFRMedUNPD Medium-fertility variant total fertility rate by country, every five years 1955-2010 (births) http://esa.un.org/wpp/Excel-Data/fertility.htm 2010 assigned average of 2005-2010 and 2010-2015, and so on 2016/02/23