Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add function to calculate number of people in each household record #5

Open
MaxGhenis opened this issue Oct 4, 2020 · 2 comments
Open

Comments

@MaxGhenis
Copy link
Collaborator

No description provided.

@MaxGhenis
Copy link
Collaborator Author

MaxGhenis commented Oct 18, 2020

This can't be calculated from the summary dataset only, since it lacks a column for adult dependents: it only has the presence of a spouse and number of kids. The current number of people accounted for in the data in the 2019 dataset is 293 million, vs 328 million total US population.

This will therefore require merging to the raw SCF, which contains more information on number of adults (https://www.federalreserve.gov/apps/scfcb/detail/2974/5928/adults). The full microdata is at https://www.federalreserve.gov/econres/files/scf2019s.zip (linked from https://www.federalreserve.gov/econres/scfindex.htm), which can be merged on CASEID.

Thanks @ngpsu22 for identifying the issue and pointing to the potential solution.

@MaxGhenis
Copy link
Collaborator Author

Adding an extra person to the household for each of the cases of (a) another relative being present during the survey, and (b) another adult being present during the survey, produces a total population of 305 million (notebook).

@ngpsu22 will email the Fed to see if there's another way.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant