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

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

1. Navigate to https://www.un.org/development/desa/pd/household-size-and-composition
2. Scroll to Data and click Dataset
3. The indicator is "Average household size (number of members)"
   1. Change Reference date (dd/mm/yyyy) to an actual date format so it will be read by a code correctly or to use =YEAR(__).
      
4. 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
   1. We need to divide the data from UN DESA with SeriesPopulation. The script included in the repo.
5. 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