United Nations Population Division Department of Economic and Social Affairs
Jump to navigation
Jump to search
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(__).
- 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