The Use of Nonimmigrant Workers by State (percentages)

The following Python code and output show the percentages that correspond to the counts shown at this link. See that page for the corresponding counts and explanation of the data. The code below is identical to the code there except that the parameter per is set to 1, indicating that percents are to be output.

In [1]:
import pandas as pd
# ACS Occupation Codes at https://usa.ipums.org/usa/volii/occ_acs.shtml
# (described at https://www.census.gov/content/dam/Census/library/publications/2016/acs/acs-35.pdf)
#  110 = Computer and information systems managers
# 1010 = Computer programmers
# 1020 = Software developers, applications and systems software 
# print(pd.get_option('display.width'))
pd.set_option('display.width', 120)

def getCitizenEducByState(min_count, isort, perc, educ, occs, cnames, title, hdrs):
    fipref = "https://www2.census.gov/geo/docs/reference/state.txt"
    #header=STATE|STUSAB|STATE_NAME|STATENS
    mm = pd.read_csv(fipref, skiprows=1, sep='|', names=['Statefip','State','State_Name','Statens'])
    #print(mm)

    usa = pd.read_csv("acs2016.csv")
    if len(occs) > 1:
        occ_start = occs[0]
        for i in range(1,len(occs)):
            if occs[i] >= 0:
                occ_end = occs[i]
                usa.loc[usa['OCC'] == occ_end,'OCC'] = occs[0]
            else:
                occ_end = -occs[i]
                usa.loc[(usa['OCC'] >= occ_start) & (usa['OCC'] <= occ_end),'OCC'] = occs[0]
            occ_start = occ_end + 1
    usa.loc[usa['CITIZEN'] == 0,'CITIZEN'] = 1 # change NA to 'Born abroad to American parents'
    elen = len(educ)
    usa.loc[usa['EDUCD'] <  educ[0],'EDUCD'] = 0
    usa.loc[usa['EDUCD'] >= educ[elen-1],'EDUCD'] = elen
    if elen > 1:
        for i in range(1,elen):
            usa.loc[(usa['EDUCD'] >= educ[i-1]) & (usa['EDUCD'] <  educ[i]),'EDUCD'] = i
    usa['CIT_EDUC'] = (3-usa['CITIZEN']) * (elen+1) + usa['EDUCD']
    #print("usa[{0}] = {1}".format(usa.shape[0], sum(usa['PERWT'])))
    usa = usa[(usa['OCC'] == occs[0]) & (usa['EMPSTAT'] == 1)] # filter OCC and EMPSTAT
    print("usa[%d] = %d\n" % (usa.shape[0], sum(usa['PERWT']))) # counts after filtering

    gg = usa.groupby(['STATEFIP','CIT_EDUC','EMPSTAT','OCC'])['PERWT'].sum()
    uu = gg.unstack('CIT_EDUC')
    nce =len(uu.columns)
    uu.columns = cnames
    uu = uu.fillna(0) # check
    uu['count'] = 0
    for i in range(0, nce):
        uu['count'] += uu.iloc[:,i]
    if perc == 1:
        for i in range(0, nce):
            uu.iloc[:,i] = 100 * uu.iloc[:,i] / uu['count']

    uu = uu.reset_index(level=['STATEFIP','EMPSTAT','OCC'])
    #pp = uu[(uu['OCC'] == occs[0]) & (uu['EMPSTAT'] == 1) & (uu['count'] > min_count)]
    pp = uu[(uu['count'] > min_count)]
    pp = pp.sort_values(by=[cnames[isort]], ascending=False)
    pp = pp.merge(mm, left_on=['STATEFIP'],right_on=['Statefip'],how='left')
    qqState = pp['State']
    qq=pd.DataFrame(qqState, columns=['State'])
    qq['count']=pp['count'].astype('int')
    qq['count']=qq.apply(lambda x: "{:,.0f}".format(x['count']), axis=1)
    if perc == 1:
        #title = pd.concat(title,' (percent)')
        #title = "".join((title,'(percent)'))
        title = title + ' (percent)' + '\n'
        for i in range(0, nce):
            qq[cnames[i]]=pp[cnames[i]].round(1)
    else:
        title = title + ' (counts)' + '\n'
        for i in range(0, nce):
            qq[cnames[i]]=pp.apply(lambda x: "{:,.0f}".format(x[cnames[i]]), axis=1)
    qq.index += 1
    qq.columns = pd.MultiIndex.from_tuples(hdrs, names=['Status','','Degree',''])
    print(title)
    print(qq)
    qq.to_csv("state_comp", sep=';')

All Occupations - Workers by Citizen Status and Education Level

The following table describes all of the parameters that are passed to getCitizenEducByState:

Parameter Usage
min_count Minimum count to include in output
isort Column by which to sort data (0-based)
perc 0=output counts, 1=output percents
educ IPUMS EDUC detailed codes to define education levels
occs ACS OCC codes to define occupations
cnames simple column names of citizen/education groups
title title of table
hdrs multi-row headers of citizen/education groups

The following code specifies the education levels to be used and sets up a multi-row header that corresponds to those levels. It also specifies other parameters shown in the table above, including occupation codes of 1 through 99999 to indicate all occupations. It then calls getCitizenEducByState to generate the following output.

In [2]:
tt = [('','','','State'),('','','','count'),
      ('Non-citizen','','Bachelor','& below'),('Non-citizen','','Master','Degree'),('Non-citizen','','above','Master'),
      ('Naturalized','','Bachelor','& below'),('Naturalized','','Master','Degree'),('Naturalized','','above','Master'),
      ('U.S. Born'  ,'','Bachelor','& below'),('U.S. Born'  ,'','Master','Degree'),('U.S. Born'  ,'','above','Master')
     ]
per = 1
educs = [114,115]
cnames = ['non-cit_<','non-cit_ms','non-cit_>','natur_<','natur_ms','natur_>','us-born_<','us-born_ms','us-born_>']
getCitizenEducByState(1, 0, per, educs, [1,-99999], cnames, "All Occupations - Workers by Citizen Status and Education Level",tt)
usa[1459560] = 153640528

All Occupations - Workers by Citizen Status and Education Level (percent)

Status                   Non-citizen               Naturalized               U.S. Born              
                                                                                                    
Degree                      Bachelor Master  above    Bachelor Master  above  Bachelor Master  above
       State       count     & below Degree Master     & below Degree Master   & below Degree Master
1         CA  18,472,665        15.2    1.2    0.4        14.6    1.7    0.9      57.4    5.8    2.8
2         NV   1,383,986        13.6    0.3    0.1        11.9    0.7    0.3      66.7    4.5    2.0
3         TX  13,025,480        12.2    0.8    0.3         7.2    0.9    0.5      70.3    5.7    2.1
4         NY   9,494,739        10.9    1.0    0.5        13.2    1.8    0.7      59.0    9.2    3.6
5         NJ   4,429,108        10.7    1.7    0.4        12.6    2.1    1.0      60.8    7.7    3.0
6         FL   9,278,473        10.7    0.7    0.3        12.6    1.2    0.6      66.3    5.3    2.3
7         AZ   3,038,304         8.9    0.5    0.2         6.6    0.6    0.4      73.7    6.4    2.5
8         HI     726,915         8.8    0.2    0.3        11.0    0.7    0.5      69.2    6.4    2.9
9         IL   6,251,890         8.0    0.8    0.3         7.1    1.1    0.5      71.2    8.2    3.0
10        MD   3,109,090         7.9    0.9    0.6         7.5    1.8    1.0      65.8   10.5    4.1
11        WA   3,534,210         7.5    1.1    0.3         6.9    0.9    0.5      72.2    7.5    2.9
12        MA   3,570,231         7.1    1.2    0.7         8.4    1.4    0.9      65.2   11.0    4.2
13        GA   4,777,802         7.0    0.7    0.2         4.9    0.8    0.4      75.6    7.4    3.1
14        NM     893,300         6.8    0.4    0.2         4.2    0.4    0.5      77.5    7.3    2.6
15        CT   1,830,584         6.8    0.9    0.4         7.5    1.3    0.6      68.6    9.8    4.0
16        CO   2,855,778         6.5    0.4    0.2         3.7    0.6    0.3      75.4    9.4    3.5
17        UT   1,449,242         6.4    0.4    0.2         3.8    0.2    0.1      79.4    6.8    2.7
18        OR   1,941,752         6.2    0.6    0.3         4.8    0.7    0.3      76.2    7.5    3.4
19        DC     366,706         6.2    1.8    1.2         4.9    1.6    1.1      52.0   19.9   11.3
20        VA   4,232,725         6.0    0.8    0.3         6.7    1.5    0.5      70.0   10.6    3.7
21        RI     525,029         5.6    0.8    0.2         8.4    0.6    0.5      71.5    9.0    3.4
22        NC   4,721,856         5.6    0.5    0.2         3.4    0.6    0.3      79.6    7.2    2.6
23        DE     445,316         4.9    0.8    0.5         4.8    1.0    0.5      77.0    7.6    3.0
24        KS   1,448,581         4.8    0.5    0.2         3.3    0.4    0.3      79.7    8.2    2.6
25        OK   1,753,268         4.5    0.2    0.1         2.4    0.3    0.2      84.1    5.8    2.3
26        NE     991,764         4.4    0.2    0.2         2.9    0.2    0.1      82.3    6.7    3.0
27        ID     760,871         4.2    0.3    0.2         2.8    0.1    0.2      84.5    5.2    2.5
28        MN   2,931,212         4.0    0.4    0.2         4.5    0.5    0.3      79.9    7.2    3.0
29        AR   1,297,197         3.8    0.2    0.2         1.8    0.2    0.1      85.4    6.1    2.2
30        AK     367,079         3.7    0.0    0.2         6.8    0.4    0.1      78.6    7.2    3.0
31        TN   3,049,923         3.6    0.3    0.2         2.0    0.3    0.2      84.0    6.6    2.7
32        SC   2,268,666         3.6    0.3    0.1         1.9    0.2    0.1      84.4    6.8    2.5
33        IA   1,612,886         3.2    0.3    0.2         2.1    0.2    0.1      85.4    5.9    2.5
34        IN   3,181,991         3.1    0.3    0.2         2.2    0.2    0.3      85.3    6.3    2.1
35        WI   2,970,806         2.8    0.4    0.1         2.3    0.4    0.3      85.0    6.1    2.5
36        MI   4,611,522         2.8    0.5    0.3         3.1    0.6    0.4      82.4    7.2    2.6
37        PA   6,105,096         2.7    0.4    0.3         3.8    0.5    0.4      80.6    8.1    3.2
38        LA   2,040,593         2.6    0.3    0.1         1.9    0.1    0.2      86.2    5.6    2.9
39        WY     285,760         2.6    0.2    0.2         1.3    0.1    0.3      86.6    6.2    2.5
40        KY   1,973,971         2.4    0.2    0.2         1.6    0.2    0.2      85.6    7.0    2.7
41        AL   2,098,516         2.3    0.3    0.1         1.3    0.2    0.2      85.7    7.2    2.8
42        SD     441,179         2.2    0.2    0.1         1.2    0.0    0.1      87.2    5.7    3.2
43        MO   2,919,918         2.1    0.4    0.2         2.0    0.3    0.3      84.8    7.3    2.6
44        ND     414,143         2.1    0.2    0.1         1.2    0.3    0.1      89.3    4.8    2.0
45        NH     727,345         2.0    0.3    0.3         2.6    0.5    0.3      81.7    9.8    2.5
46        OH   5,563,255         1.8    0.3    0.2         2.1    0.4    0.3      85.0    7.2    2.7
47        ME     658,328         1.6    0.0    0.1         1.6    0.1    0.2      84.9    8.6    2.9
48        MS   1,239,548         1.5    0.1    0.1         0.8    0.1    0.1      88.2    6.3    2.8
49        MT     503,181         1.3    0.0    0.1         1.2    0.0    0.2      88.1    5.9    3.2
50        VT     328,279         1.2    0.3    0.1         1.7    0.5    0.5      82.1    8.9    4.8
51        WV     740,469         1.0    0.3    0.1         0.6    0.1    0.2      87.6    7.8    2.4

Software Developers - Workers by Citizen Status and Education Level

The following code calls getCitizenEducByState and lists the number of workes with OCC code 1020 (Software developers, applications and systems software) by citizen status and education level.

In [3]:
getCitizenEducByState(1, 0, per, educs, [1020], cnames, "Software Developers - Workers by Citizen Status and Education Level",tt)
usa[12371] = 1276877

Software Developers - Workers by Citizen Status and Education Level (percent)

Status                Non-citizen               Naturalized               U.S. Born              
                                                                                                 
Degree                   Bachelor Master  above    Bachelor Master  above  Bachelor Master  above
       State    count     & below Degree Master     & below Degree Master   & below Degree Master
1         NJ   49,210        19.5   19.5    1.2        10.3   12.7    0.7      27.0    7.5    1.6
2         CT   13,065        16.7   11.3    0.0         8.5   10.6    0.5      40.2   11.8    0.4
3         NC   34,435        16.5   10.2    0.4         5.0    5.8    0.9      52.3    8.5    0.4
4         DE    3,211        16.0   22.3    0.0        10.7    8.2    1.4      26.6    9.3    5.5
5         AR    4,333        15.3    3.6    0.0         4.1    0.0    0.0      68.1    7.7    1.2
6         WA   74,135        14.7   18.2    2.1         5.1    4.4    1.9      45.3    7.3    1.0
7         CA  269,117        14.4   17.0    2.8        12.1    9.1    1.8      33.5    7.7    1.7
8         NE    6,111        13.3    2.9    0.0         4.5    3.1    0.0      60.0   14.4    1.7
9         MI   23,829        12.6   10.3    1.1         4.2    5.2    0.6      52.2   13.1    0.7
10        IL   50,267        12.6   12.5    0.5         5.7    8.6    0.6      44.9   12.4    2.1
11        AZ   22,268        11.3    5.0    0.2         3.2    1.7    2.2      62.1   13.7    0.6
12        GA   34,985        11.3   12.4    0.5         6.9    6.8    0.6      50.9   10.1    0.6
13        WI   18,925        10.7   19.1    1.1         1.9    1.0    0.0      58.3    6.6    1.3
14        KS   12,186        10.7   13.2    0.5         2.8    6.1    0.0      52.8   11.9    2.1
15        TX   97,008        10.4   10.8    1.2         7.3    7.1    0.5      53.4    8.7    0.6
16        FL   50,880        10.2    7.6    0.2         8.4    6.2    0.3      56.6    9.3    1.3
17        PA   38,971        10.1   11.9    0.4         4.1    4.1    1.3      51.2   15.0    2.0
18        TN   12,993         9.7    9.2    2.3         3.6    0.8    0.4      65.5    7.5    1.0
19        RI    3,723         9.3   17.2    0.0         3.4    0.0    0.0      59.3   10.8    0.0
20        CO   43,179         8.7    3.5    0.3         4.5    3.4    1.2      58.0   17.9    2.5
21        MA   60,387         8.3   12.8    1.8         7.1    7.4    2.0      45.5   13.0    2.0
22        VA   59,335         7.3    9.9    0.3         9.5    6.1    0.4      44.4   20.3    1.6
23        MD   38,986         6.7    5.9    0.2         6.0    6.9    2.7      47.0   22.2    2.3
24        MN   30,490         6.6    7.4    0.8         6.9    8.4    0.0      58.3   10.4    1.3
25        DC    2,860         6.3    0.0    0.0         6.9    1.5    0.0      49.1   30.8    5.5
26        NY   50,041         6.1    5.5    2.5        11.8    6.1    0.4      49.6   15.5    2.6
27        KY    5,965         6.0    6.9    0.0         0.0    0.0    0.0      73.6    7.0    6.5
28        OH   27,872         5.9    6.0    0.7         4.8    4.4    0.2      66.9   10.0    1.1
29        NV    4,204         5.5   10.4    0.0         4.5    0.0    0.0      78.0    1.5    0.0
30        MO   13,521         5.4   11.1    0.0         3.1    3.6    0.9      68.8    6.3    0.8
31        IA   10,734         4.4   14.0    0.0         7.4    8.3    0.0      49.5   16.5    0.0
32        IN   12,822         4.1    2.6    0.0         9.6    0.0    0.0      79.0    4.8    0.0
33        NM    2,858         4.0    2.4    0.0         7.5    0.0    0.0      55.6   30.5    0.0
34        OK    5,336         3.4   11.1    0.0         4.1   12.8    0.0      66.0    2.5    0.0
35        VT    2,013         3.3    0.0    0.0         1.4    0.0    0.0      83.2    7.1    5.1
36        ND    2,054         3.2   20.3    0.0         0.0    0.0    0.0      76.6    0.0    0.0
37        UT   18,010         2.8    5.7    0.0         1.7    2.1    0.0      82.0    5.4    0.2
38        LA    5,964         2.5    3.6    0.0         3.3    0.0    0.7      72.2   17.7    0.0
39        OR   18,096         2.4    7.3    1.5         6.1    4.7    0.5      65.4   11.0    1.2
40        NH    9,246         1.9    3.8    1.4         2.4    7.9    2.3      65.3   15.1    0.0
41        SC    7,988         1.6    3.8    0.0         2.8    0.9    0.0      75.6   12.2    3.2
42        AL    9,443         1.3    4.9    0.0         3.9    1.0    2.1      67.2   15.5    4.1
43        SD      959         0.0    9.2    0.0         0.0    0.0    0.0      79.1    0.0   11.7
44        MT    1,741         0.0    0.0    0.0         0.0    0.0    0.0      97.4    2.6    0.0
45        AK    1,468         0.0    0.0    0.0         0.0    0.0    0.0     100.0    0.0    0.0
46        MS    3,025         0.0    0.0    0.0         0.0    0.0    0.0     100.0    0.0    0.0
47        ME    2,248         0.0    0.0    0.0         0.0    0.0    0.0      97.5    1.0    1.5
48        ID    2,554         0.0    0.0    0.0         5.7    0.0    0.0      84.5    9.8    0.0
49        WV    1,662         0.0    0.0    0.0         0.0    0.0    0.0      79.2   20.1    0.7
50        HI    1,026         0.0    8.0    0.0        14.2    0.0    0.0      39.0   26.1   12.7
51        WY    1,138         0.0    0.0    0.0         0.0    0.0    0.0      91.6    8.4    0.0

The following sections look at other major occupation groups.

Computer and Mathematical Occupations - Workers by Citizen Status and Education Level

In [4]:
getCitizenEducByState(1, 0, per, educs, [1000,-1299], cnames, "Computer and Mathematical Occupations - Non-citizen, Naturalized, and US-born",tt)
usa[43900] = 4525376

Computer and Mathematical Occupations - Non-citizen, Naturalized, and US-born (percent)

Status                Non-citizen               Naturalized               U.S. Born              
                                                                                                 
Degree                   Bachelor Master  above    Bachelor Master  above  Bachelor Master  above
       State    count     & below Degree Master     & below Degree Master   & below Degree Master
1         NJ  175,620        13.4   12.8    0.8        12.4    8.4    1.2      42.1    7.5    1.5
2         CA  647,312        10.1    9.9    1.7        13.3    6.1    1.3      47.8    8.2    1.7
3         WA  156,399         9.7   11.1    1.3         6.5    2.8    1.4      57.1    8.4    1.7
4         CT   59,953         9.4    8.4    0.2         5.3    4.5    0.6      60.2   10.2    1.2
5         AR   19,552         8.9    3.0    0.7         5.2    0.3    0.0      73.3    8.1    0.5
6         DE   14,513         8.8   11.8    0.9         9.7    2.4    0.3      53.8   10.8    1.5
7         IL  191,256         7.8    6.3    0.4         8.1    5.2    0.7      58.5   11.4    1.5
8         TX  360,711         7.3    6.0    0.5         7.3    4.3    0.7      64.9    8.0    1.1
9         RI   15,494         7.2   10.3    0.0         4.5    0.0    0.6      71.6    4.6    1.1
10        FL  210,294         6.8    3.8    0.3        10.1    3.9    0.3      65.0    9.0    0.9
11        AZ   85,079         6.7    3.9    0.3         5.0    1.3    0.8      71.4    8.8    1.9
12        NC  137,662         6.6    5.2    0.3         5.4    3.7    0.6      66.8   10.1    1.3
13        GA  143,142         6.5    6.2    0.5         6.8    4.5    0.4      62.6   11.2    1.4
14        MA  151,032         6.3    8.6    1.4         7.2    4.5    1.2      55.9   12.5    2.4
15        MN  107,950         5.6    4.1    0.4         7.0    4.4    0.0      67.9    9.2    1.4
16        WI   81,342         5.3    5.3    0.3         2.8    1.8    0.0      75.0    7.6    1.9
17        VA  211,858         5.2    4.8    0.2         9.3    5.6    0.5      54.0   18.3    2.1
18        IN   60,972         5.1    1.4    0.0         2.7    0.7    0.1      78.9   10.6    0.5
19        CO  121,757         5.0    2.2    0.2         3.5    1.9    0.5      72.2   13.1    1.4
20        PA  175,324         5.0    4.3    0.6         5.0    2.4    0.8      68.9   11.2    1.9
21        KS   39,788         4.9    5.0    0.1         3.4    2.2    0.0      71.2   11.4    1.8
22        NY  239,743         4.9    3.4    1.1        12.0    5.4    0.8      58.6   12.0    1.7
23        NE   28,054         4.7    1.2    0.0         1.5    1.7    0.0      77.0   13.2    0.8
24        MI  111,769         4.6    4.6    0.5         5.5    3.4    0.5      69.0   10.3    1.5
25        ND    8,243         4.3    5.0    0.0         0.0    0.0    0.0      89.8    0.8    0.0
26        KY   37,048         4.2    2.4    0.0         2.2    0.2    0.2      82.1    7.1    1.6
27        MD  161,719         4.1    3.4    0.5         7.3    5.2    1.4      56.1   19.2    2.9
28        TN   64,394         4.0    2.9    0.6         3.9    0.7    0.3      75.9   10.6    1.1
29        MO   69,643         3.6    3.7    0.0         3.5    2.0    0.3      75.5    9.9    1.4
30        OH  140,929         3.4    4.2    0.2         3.9    2.0    0.1      74.8   10.1    1.3
31        NH   27,031         3.4    2.2    0.5         2.6    3.7    0.8      68.7   16.6    1.5
32        UT   53,995         3.3    2.9    0.0         3.1    0.8    0.0      79.3    9.5    1.1
33        IA   34,284         3.3    4.6    0.0         3.4    2.6    0.3      75.6   10.2    0.0
34        HI   13,175         3.0    0.6    0.0         9.6    1.2    1.0      70.8   11.4    2.4
35        ID   17,931         2.7    2.2    0.0         1.1    0.0    0.0      85.8    7.3    0.9
36        OK   29,785         2.3    3.1    0.0         3.4    2.6    0.0      81.2    7.1    0.4
37        NM   17,772         2.3    0.9    0.0         4.2    1.1    0.3      76.7   12.0    2.5
38        OR   59,841         2.3    3.5    1.2         5.2    3.0    0.2      74.3    8.9    1.5
39        NV   27,246         2.3    2.9    0.0         9.0    0.9    0.0      76.6    6.9    1.3
40        SC   43,361         2.0    1.1    0.1         2.1    0.6    0.2      80.3   11.1    2.5
41        LA   27,101         1.9    2.6    0.0         1.9    1.7    0.2      82.6    8.3    0.7
42        ME   15,168         1.8    0.0    0.0         4.5    0.9    0.0      82.3    8.7    1.8
43        AK    7,309         1.7    0.0    0.0        10.5    0.0    0.0      74.0    6.9    6.9
44        DC   19,754         1.6    2.2    1.1         6.1    1.6    0.7      49.0   30.4    7.2
45        MT    8,915         1.5    0.0    0.0         0.0    0.0    0.0      92.4    3.4    2.7
46        AL   46,824         1.4    1.0    0.0         1.0    0.5    0.7      83.2   10.3    1.8
47        VT    8,723         0.8    3.8    0.0         0.3    0.0    0.0      82.5    9.5    3.1
48        WV   13,453         0.6    0.0    0.0         1.4    0.0    0.0      89.5    8.5    0.1
49        SD    6,786         0.0    1.3    0.0         0.0    0.0    0.0      91.1    6.0    1.7
50        MS   14,318         0.0    0.2    0.0         0.7    0.0    0.0      90.1    7.5    1.6
51        WY    4,052         0.0    0.0    0.0         0.0    0.0    0.0      94.8    5.2    0.0

Healthcare Practitioners and Technical Occupations - Workers by Citizen Status and Education Level

In [5]:
getCitizenEducByState(1, 0, per, educs, [3000,-3599], cnames, "Healthcare Practitioners and Technical Occupations - Non-citizen, Naturalized, and US-born",tt)
usa[90137] = 9129020

Healthcare Practitioners and Technical Occupations - Non-citizen, Naturalized, and US-born (percent)

Status                Non-citizen               Naturalized               U.S. Born              
                                                                                                 
Degree                   Bachelor Master  above    Bachelor Master  above  Bachelor Master  above
       State    count     & below Degree Master     & below Degree Master   & below Degree Master
1         CA  923,857         4.8    0.8    1.0        16.6    2.2    6.8      45.6    8.3   13.8
2         NV   62,766         4.6    0.8    1.2         9.7    2.1    4.1      55.6    9.0   13.1
3         MD  195,891         3.9    0.4    1.5        11.4    2.2    5.2      50.1   10.0   15.3
4         FL  576,975         3.8    0.3    1.2        13.2    1.9    4.4      55.6    8.2   11.4
5         NJ  266,279         3.7    1.0    1.1        16.2    2.7    6.1      47.5    8.6   13.0
6         TX  684,763         3.7    0.5    1.2         8.8    1.5    4.1      60.4    7.8   12.1
7         NY  578,458         3.6    0.8    1.6        14.0    2.9    4.8      47.0   10.7   14.7
8         HI   40,345         3.0    0.0    0.6        14.0    1.6    2.6      47.4   10.2   20.6
9         AZ  182,704         2.8    0.4    0.7         6.4    1.0    3.4      62.0    9.3   14.0
10        WA  189,153         2.7    0.7    0.7         8.0    1.3    3.3      55.4    9.1   18.6
11        CT  107,555         2.7    0.1    1.3         8.4    1.5    4.5      52.1   11.7   17.7
12        MA  245,811         2.7    0.8    1.4         6.6    1.4    3.6      55.4   13.1   15.0
13        GA  248,656         2.2    0.3    0.6         4.2    1.0    3.7      62.6    9.9   15.5
14        IL  348,643         2.2    0.5    0.7         8.2    0.9    4.2      58.7   10.5   14.1
15        DC   12,021         2.0    3.0    5.8         5.6    0.8    8.4      32.6   15.7   26.1
16        UT   74,093         1.9    0.0    0.2         2.6    0.3    1.1      67.7    9.5   16.8
17        ME   41,136         1.9    0.1    0.5         2.1    0.0    1.5      65.1   15.4   13.4
18        NC  285,041         1.8    0.2    0.5         1.8    0.8    1.1      66.0   12.0   15.8
19        VT   20,558         1.8    0.5    0.3         1.1    0.9    0.6      60.6   10.9   23.2
20        NM   55,212         1.8    0.0    0.7         4.2    0.4    3.0      64.3   10.6   15.1
21        ID   44,954         1.6    0.8    0.2         2.7    0.2    1.1      69.4    8.1   15.8
22        OR  104,808         1.5    0.2    0.7         3.5    0.7    1.6      59.4    9.5   22.8
23        CO  151,757         1.5    0.0    0.8         2.5    0.4    1.9      60.3   11.2   21.3
24        TN  205,471         1.4    0.1    0.8         2.2    0.4    1.6      70.4    9.7   13.5
25        DE   32,549         1.4    0.0    0.6         7.2    0.9    2.0      65.8    8.1   14.1
26        MO  188,173         1.3    0.2    1.2         2.2    0.5    1.4      70.7    9.8   12.6
27        SC  133,016         1.3    0.1    0.8         2.4    0.5    0.5      71.1    8.2   15.0
28        VA  236,230         1.3    0.2    1.2         6.6    1.1    3.3      58.6   11.7   16.0
29        MN  184,290         1.3    0.2    0.8         6.0    0.6    1.0      67.0    9.6   13.5
30        MI  294,835         1.2    0.2    1.6         3.3    0.7    2.8      66.1   10.2   13.7
31        IN  185,724         1.2    0.0    0.6         2.1    0.0    1.8      74.3    8.4   11.6
32        RI   35,347         1.2    0.0    0.7         5.3    0.1    3.0      67.8    9.5   12.4
33        NH   44,531         1.1    0.5    0.8         0.9    0.1    1.8      68.0   12.9   13.8
34        ND   25,210         1.1    0.2    0.2         0.4    0.0    0.0      75.9   12.2   10.0
35        PA  423,461         1.1    0.4    1.3         3.7    0.6    2.4      65.0   11.2   14.4
36        OH  392,796         1.1    0.0    0.6         2.3    0.2    1.6      70.7   10.0   13.5
37        IA  100,538         0.9    0.0    0.9         1.2    0.0    0.5      71.6    5.9   19.0
38        KS   86,007         0.8    0.3    0.1         2.0    0.7    1.9      69.3    9.6   15.2
39        AK   22,969         0.6    0.0    0.2         3.3    1.8    0.2      67.8   10.0   16.1
40        MS   88,779         0.5    0.0    0.3         0.5    0.1    0.7      74.1    9.6   14.1
41        AL  152,330         0.5    0.1    0.3         1.1    0.5    0.7      75.7    8.9   12.2
42        WY   15,865         0.5    0.0    0.7         0.0    0.0    1.6      66.8    8.4   22.0
43        NE   59,305         0.5    0.0    0.4         1.4    0.0    0.7      67.2   10.3   19.5
44        KY  142,964         0.5    0.1    0.6         1.4    0.3    0.9      73.7    8.1   14.5
45        OK  104,153         0.4    0.0    0.1         3.7    0.2    2.2      72.9    7.1   13.3
46        LA  144,404         0.4    0.1    0.7         1.3    0.0    1.4      73.3    9.5   13.4
47        MT   31,161         0.4    0.0    0.0         0.7    0.0    0.0      60.5   11.0   27.5
48        WV   58,085         0.3    0.0    0.5         1.7    0.0    1.4      73.0   11.2   11.9
49        AR   80,536         0.2    0.0    1.3         1.5    0.0    0.3      74.8    9.8   12.2
50        WI  187,612         0.2    0.2    0.4         2.0    0.1    2.5      69.2   10.3   15.2
51        SD   31,243         0.0    0.0    1.3         1.1    0.0    0.9      67.0   10.9   18.8

Healthcare Support Occupations - Workers by Citizen Status and Education Level

In [6]:
getCitizenEducByState(1, 0, per, educs, [3600,-3699], cnames, "Healthcare Support Occupations - Non-citizen, Naturalized, and US-born",tt)
usa[31247] = 3581778

Healthcare Support Occupations - Non-citizen, Naturalized, and US-born (percent)

Status                Non-citizen               Naturalized               U.S. Born              
                                                                                                 
Degree                   Bachelor Master  above    Bachelor Master  above  Bachelor Master  above
       State    count     & below Degree Master     & below Degree Master   & below Degree Master
1         NY  320,038        19.7    0.5    0.1        32.0    0.7    0.1      45.7    1.0    0.3
2         NJ  104,412        17.7    0.4    0.1        20.8    0.0    0.3      59.5    0.4    0.9
3         MD   74,347        13.1    0.5    0.5        13.3    0.4    0.3      70.6    1.1    0.2
4         CA  334,111        12.5    0.1    0.3        22.1    0.3    0.8      62.1    1.1    0.8
5         FL  223,853        12.0    0.4    0.8        22.8    0.5    0.4      62.0    0.6    0.5
6         VT    6,677        11.7    0.0    0.0         4.2    0.0    0.0      84.0    0.0    0.0
7         MA   93,652        10.4    0.1    0.0        25.7    0.3    0.1      62.0    0.8    0.7
8         HI   16,949         9.9    0.0    0.4        20.0    0.9    0.3      66.7    1.8    0.0
9         DC    4,771         9.7    0.0    0.0        13.1    0.0    0.0      75.8    1.4    0.0
10        CT   57,059         9.3    0.0    0.0        19.2    0.1    0.0      69.9    0.8    0.6
11        CO   56,392         7.9    0.0    0.0         6.4    0.6    0.1      83.1    1.4    0.6
12        RI   16,237         7.7    0.0    0.0        20.4    0.0    0.0      70.7    0.0    1.2
13        TX  288,560         7.7    0.2    0.3         9.6    0.0    0.4      80.7    0.8    0.4
14        WA   79,730         7.3    0.1    1.0        10.2    0.0    0.2      79.1    1.1    1.0
15        UT   29,942         5.4    0.0    0.4         3.8    0.5    0.0      89.0    0.5    0.3
16        DE   11,201         5.2    0.0    0.0         2.2    0.0    0.0      91.4    0.0    1.2
17        WV   21,922         5.1    0.0    0.0         3.4    0.0    0.0      91.0    0.2    0.3
18        GA   83,240         4.9    0.4    0.0         6.3    0.2    0.0      86.5    0.8    0.9
19        IL  141,669         4.8    0.1    0.0         8.5    0.1    0.1      85.1    0.7    0.6
20        AZ   63,939         4.5    0.1    0.4         8.3    0.2    0.1      83.6    2.2    0.6
21        KS   34,410         4.5    0.0    0.0         2.5    0.0    0.5      89.1    2.9    0.6
22        VA   74,422         4.3    0.0    0.2        10.6    0.1    0.4      81.6    1.8    0.8
23        NV   22,440         4.3    0.0    0.0        13.8    0.2    0.6      79.8    0.9    0.4
24        ME   18,887         4.1    0.0    0.0         1.1    0.0    0.0      94.0    0.4    0.4
25        MN   74,638         3.4    0.0    0.2         9.1    0.0    0.0      85.8    0.8    0.6
26        MT   10,574         3.4    0.0    0.0         1.4    0.0    0.0      90.6    4.7    0.0
27        OR   43,375         3.2    0.1    0.2         4.1    0.3    0.1      90.2    1.0    0.8
28        OK   38,307         3.2    0.0    0.0         1.7    0.0    0.0      93.3    0.9    0.9
29        WI   74,148         2.5    0.0    0.0         1.6    0.1    0.1      94.7    0.5    0.4
30        NM   20,218         2.4    0.0    0.0         6.5    0.0    0.0      89.8    0.0    1.3
31        MO   74,317         2.3    0.1    0.0         2.6    0.0    0.0      93.0    1.5    0.6
32        NH   17,748         2.2    0.0    0.0         3.2    0.0    0.0      92.6    2.0    0.0
33        NC  113,792         2.2    0.0    0.2         3.6    0.1    0.0      92.7    0.8    0.3
34        PA  166,051         2.2    0.0    0.0         6.2    0.1    0.1      89.9    1.2    0.3
35        NE   25,684         2.2    0.0    0.0         7.0    0.0    0.0      89.8    0.6    0.4
36        AR   32,310         1.9    0.0    0.0         1.6    0.0    0.0      95.3    1.2    0.0
37        IA   37,463         1.9    0.0    0.0         4.2    0.0    0.0      93.1    0.3    0.5
38        MI  115,369         1.8    0.1    0.1         2.2    0.2    0.0      94.3    0.9    0.5
39        ID   18,502         1.7    0.0    0.0         0.2    0.0    0.0      95.8    2.4    0.0
40        ND   14,030         1.6    0.0    0.0         1.0    0.0    0.0      96.1    0.0    1.4
41        KY   42,805         1.5    0.0    0.0         2.8    0.4    0.0      94.4    0.8    0.1
42        IN   74,190         1.2    0.1    0.0         3.2    0.1    0.0      94.3    0.7    0.3
43        OH  154,463         1.1    0.1    0.0         2.2    0.0    0.3      95.0    0.8    0.5
44        TN   58,347         1.0    0.2    0.5         3.8    0.1    0.1      92.6    0.5    1.2
45        SD    8,363         0.6    0.0    0.0         4.7    0.0    0.0      87.3    7.5    0.0
46        AK    8,927         0.5    0.0    0.0         8.4    0.0    2.4      88.0    0.6    0.0
47        SC   43,633         0.5    0.0    0.0         1.6    0.1    0.0      97.0    0.7    0.1
48        AL   46,646         0.4    0.9    0.0         2.1    0.0    0.0      95.7    0.6    0.3
49        MS   30,730         0.3    0.0    0.0         0.1    0.0    0.0      98.8    0.7    0.1
50        LA   51,798         0.3    0.0    0.0         0.5    0.0    0.0      98.0    0.9    0.3
51        WY    6,490         0.2    0.0    0.0         3.1    0.0    0.0      96.8    0.0    0.0

Note: As previously mentioned, the counts corresponding to the above percents can be seen at this link.