United Nations Population Division Department of Economic and Social Affairs: Difference between revisions
Jump to navigation
Jump to search
Norah.Shamin (talk | contribs) No edit summary |
Norah.Shamin (talk | contribs) |
||
| Line 21: | Line 21: | ||
= Data Pulling Instructions = | = Data Pulling Instructions = | ||
# Navigate to | # 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: | |||
= Notes = | = Notes = | ||
Revision as of 18:36, 19 November 2025
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:
