View source for United Nations Population Division Department of Economic and Social Affairs

= Summary =
The Population Division of the Department of Economic and Social Affairs conducts demographic research, supports intergovernmental processes at the United Nations in the area of population and development, and assists countries in developing their capacity to produce and analyze population data and information. 

IFs uses the UN DESA for many tables; the most current is the SeriesHouseholds which utilizes the Household Size and Composition Database. This database presents a compilation of indicators on household size and membership composition around the world, estimated using both tabulated data and household roster micro-data from censuses and household surveys.

= Tables In IFs =
{| class="wikitable"
|+
!Variable
!Definition
!Extended Source Defn
!Last IFs Update
!UsedInPreprocessor
!UsedInPreprocessorFileName
|-
|SeriesHouseholds
|Number of households (SeriesPopulation/average household size (number of members)
|Most data points up to 2014 are based on SeriesHouseholdsITU2014, with some values before and after 2014 are filled by UNPD
|2025/11/19
|1
|INFRASTRUCTURE, POPULATION
|}

= Data Pulling Instructions =

# Navigate to https://www.un.org/development/desa/pd/household-size-and-composition
# Scroll to '''Data''' and click ''Dataset'' 
# The indicator is "Average household size (number of members)"
## Change Reference date (dd/mm/yyyy) to an actual date format so it will be read by a code correctly '''or''' to use =YEAR(__). [[File:UN DESA .png|none|thumb|600x600px]] 
#If you create a separate column for year using =YEAR(), you cam use this code to pull:https://github.com/n1shamin/UN-DESA-Household-Data/tree/main
##We need to divide the data from UN DESA with SeriesPopulation. The script included in the repo. 
#After this, blend the data with SeriesHouseholdsITU2014.    

= Notes =

* In Source Ext Definition state: Most data points up to 2014 are based on SeriesHouseholdsITU2014, with some values before and after 2014 are filled by UNPD