workers in their POWPUMA

Hello,

 

I am trying to extract workers at their place of work from the 1-year ACS microdata but I am having a hard time figuring out the right variables.  I have an Access database with the 1-year data so I am looking for the correct query.  If I pull all records where Employment status recode is 1 (Civilian employed, at work), 2 (Civilian employed, with a job but not at work), 4 (Armed forces, at work), and 5 (Armed forces, with a job but not at work) along with the POWPUMA number and the person weight, will that get me the correct number?

I tried getting it from iPUMS but for some reason even with selecting out only employed ESR codes I kept getting a number that looked closer to the residential population than the number of workers for each POWPUMA/county.  I used to rely on DataFerret but it no longer works on my computer at all, even using their very specific technical requirements.

 

Thanks,

Mara

Parents
  • Also if you are looking at employed persons that will most likely be where they live, not where they work. I believe there are a limited number of tables in the ACS that have workers as the universe and geography is by place of work. I am not as familiar with the data from ACS PUMS, but an example from the standard ACS estimates is table B08006. Hopefully someone more familiar with the PUMS data can chime in on that aspect.
Reply
  • Also if you are looking at employed persons that will most likely be where they live, not where they work. I believe there are a limited number of tables in the ACS that have workers as the universe and geography is by place of work. I am not as familiar with the data from ACS PUMS, but an example from the standard ACS estimates is table B08006. Hopefully someone more familiar with the PUMS data can chime in on that aspect.
Children