Dear Jill,

You need to use PUMS variables ESR and COW in combination as follows:

Note the universe for S2408 is the Employed Civilian population 16 years old and over

# ESR: Employment status recode
# b [0].N/A (less than 16 years old)
# 1 .Civilian employed…

Perhaps query this in iPUMS or by merging the housing and person records PUMS SAS files?  I like MDAT, and maybe you can yield your desired results in MDAT by tweaking your setup, but I find the other PUMS sources more flexible.  

Did you check out the PUMS TYPEHUGQ variable ?  (TYPE 2019 and earlier).  You can merge on SERIALNO with the PUMS "person" dataset.

You can get the total population who moved from outside of the U.S. from table B07204 but I can't think of any pre-tabulated disaggregation by origin--PUMS is the best option. Would pooling 3 years of PUMS data work?

Also, if you're willing to share…

The poverty level is computed by the US Census Bureau following the Office of Management Statistical Directive #14 https://www.census.gov/topics/income-poverty/poverty/guidance/poverty-measures.html  The POVPIP value in the PUMS data is determined based…

A couple of comments.  The PUMS query FER variable is the ACS checkoff "have you given birth within the last 12 months."  So it needs the "twins" correction.  I emailed the people at the NCHS.  There is a recent publication with fertility…

Yes, the Public Use Microdata Sample (PUMS) data from the U.S. Census Bureau can be used to analyze the distribution of household sizes across various income levels. By leveraging PUMS data, you can derive insights into the number of households based…