Is there a variable for "Civilian Employed" and "Civilian Unemployed" for laborforce and resident population?

I am looking for Cilivian population data by age, sex and employment status (employed/unemployed/ In Labor Force/ In Armed Services) extracted from the 5% ACS sample at the Couty Level and PUMA level using the 5-year sample from ACS. This data would be used to feed into our Labor Force Model for Socio-Economic and Demographic Forecasting. I could not find any Civilian related variables under IPUMS USA but found it under IPUMS CPS. I was hoping to know if there is a Civilian related variable under employment for this purpose.

1 Like

Those employed in the armed forces can be identified using the detailed codes for EMPSTAT (EMPSTATD). From 1970 onward, codes 14 and 15 respectively identify those employed in the armed forces – at work and those employed in the armed forces – with a job but not at work.

Additionally, you could look into using the detailed codes of VETSTAT (VETSTATD) to identify those in the armed forces.

1 Like

Between EMPSTAT (https://usa.ipums.org/usa-action/vari…) and IND (https://usa.ipums.org/usa-action/vari…), you should be able to construct a variable like that:

label define civ_employed_lbl 1 “Civilian, employed” 0 “Civilian, unemployed” .a “Age <16 yo” .l “Not in labor force” .m “Military”, modify

gen byte civ_employed = (empstat == 1) if inrange(ind, 0001, 9599)

replace civ_employed = .a if age < 16

replace civ_employed = .l if empstat == 3

replace civ_employed = .m if inrange(ind,9600,9899)

label values civ_employed civ_employed_lbl

* edge cases

count if civ_employed == .

if r(N) {

sort empstat ind age

list age empstat ind if civ_employed == ., sepby( empstat ind )

}

What’s the difference between those employed in the armed forces – at work and those employed in the armed forces – with a job but not at work? Are those armed forces (no civilians) anyways?

In the EMPSTAT variable, the two categories “Armed forces — at work” and “Armed forces — with job but not at work” indicate whether the respondent worked during the reference week at their job in the armed forces. People coded as “Armed forces — at work” (EMPSTATD==14) have a job in the armed forces and worked at least one day in the reference week. People coded as “Armed forces — with job but not at work” (EMPSTATD==15) have a job in the armed forces but did not work at all in the reference week. This is described in the documentation of the EMPSTAT variable under the comparability tab. The exact wording is:

“All years except for 1910 distinguish between employed people who were at work during any part of the reference week and those who were absent for the entire week (i.e., who had a job but were not at work).”

A person who answers that they have a job and were not at work during any part of the reference week may have been absent due to illness, vacation, personal time, or other reasons. You can interpret “Armed forces — with job but not at work” the same way you would interpret an absence from any other job, noting however that work schedules and structure in the armed forces may vary considerably from civilian jobs due to deployment, training, etc.