United Nations Population Division Department of Economic and Social Affairs
Summary
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
- 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(__).
- Change Reference date (dd/mm/yyyy) to an actual date format so it will be read by a code correctly or to use =YEAR(__).
- If you create a separate column for year using =YEAR(), you cam use this code to pull:
