Foreign Born Employed vs American Citizen Employed

I was looking for a way to show who was getting hired as compared to native born americans and foreign born guest workers.

The Bureau of Labor Statistics maintains this data.

You can select the data and view it by clicking here.

Problem is, the two numbers can’t be compared as you can see here:

Click to zoom in

This is because as of May 2019, foreign born employed was 27,678 and native born employed was 129,474

When you try and chart it, you can’t see what is happening as you can see here.

However, if we divide native born by six, we are now comparing 27,678 to 21,579 and this can be charted in a manner that allows us to compare apples to apples.

The data can be viewed here:

combined_employed_5jul19

wdt_ID date Foreign Born Employed Native Born Employed dividedby6
1 Jan 07 22.356 121.919 20.320
2 Feb 07 22.579 121.900 20.317
3 Mar 07 22.785 122.538 20.423
4 Apr 07 22.793 122.504 20.417
5 May 07 22.973 122.891 20.482
6 Jun 07 23.051 123.906 20.651
7 Jul 07 23.312 124.003 20.667
8 Aug 07 23.308 123.098 20.516
9 Sep 07 23.280 123.168 20.528
10 Oct 07 23.258 123.485 20.581
11 Nov 07 23.104 124.014 20.669
12 Dec 07 22.810 123.524 20.587
13 Jan 08 22.564 122.042 20.340
14 Feb 08 22.502 122.047 20.341
15 Mar 08 22.258 122.850 20.475
16 Apr 08 22.762 123.159 20.526
17 May 08 22.515 123.412 20.569
18 Jun 08 23.020 123.630 20.605
19 Jul 08 23.262 123.605 20.601
20 Aug 08 22.890 123.018 20.503
21 Sep 08 23.048 122.263 20.377
22 Oct 08 22.675 122.868 20.478
23 Nov 08 22.283 122.326 20.388
24 Dec 08 22.138 121.211 20.202
25 Jan 09 21.375 119.061 19.844
26 Feb 09 20.976 119.129 19.855
27 Mar 09 21.274 118.559 19.760
28 Apr 09 21.750 118.835 19.806
29 May 09 21.488 118.875 19.812
30 Jun 09 21.787 119.039 19.840
31 Jul 09 21.856 119.199 19.866
32 Aug 09 21.695 118.379 19.730
33 Sep 09 21.864 117.215 19.536
34 Oct 09 21.856 117.233 19.539
35 Nov 09 22.091 117.041 19.507
36 Dec 09 21.290 116.663 19.444
37 Jan 10 21.090 115.719 19.286
38 Feb 10 21.102 116.102 19.350
39 Mar 10 21.239 116.743 19.457
40 Apr 10 21.816 117.486 19.581
41 May 10 22.125 117.372 19.562
42 Jun 10 22.541 117.342 19.557
43 Jul 10 22.249 117.884 19.647
44 Aug 10 22.415 117.504 19.584
45 Sep 10 22.226 117.488 19.581
46 Oct 10 22.281 117.468 19.578
47 Nov 10 22.387 117.029 19.505
48 Dec 10 22.153 117.006 19.501
49 Jan 11 21.928 115.671 19.278
50 Feb 11 21.614 116.478 19.413
51 Mar 11 21.728 117.234 19.539
52 Apr 11 21.741 117.920 19.653
53 May 11 22.216 117.812 19.635
54 Jun 11 22.260 117.869 19.645
55 Jul 11 22.264 118.120 19.687
56 Aug 11 22.292 118.043 19.674
57 Sep 11 22.224 118.277 19.713
58 Oct 11 22.648 118.338 19.723
59 Nov 11 22.631 118.439 19.740
60 Dec 11 22.647 118.033 19.672
61 Jan 12 22.803 117.141 19.524
62 Feb 12 22.470 118.214 19.702
63 Mar 12 22.785 118.628 19.771
64 Apr 12 22.619 119.376 19.896
65 May 12 23.038 119.689 19.948
66 Jun 12 22.985 120.217 20.036
67 Jul 12 23.211 119.916 19.986
68 Aug 12 23.080 119.479 19.913
69 Sep 12 23.201 120.132 20.022
70 Oct 12 23.388 120.651 20.108
71 Nov 12 23.272 120.277 20.046
72 Dec 12 23.216 119.844 19.974
73 Jan 13 23.089 118.524 19.754
74 Feb 13 23.163 119.065 19.844
75 Mar 13 23.197 119.501 19.917
76 Apr 13 23.292 120.432 20.072
77 May 13 23.384 121.048 20.175
78 Jun 13 23.670 121.172 20.195
79 Jul 13 23.689 121.424 20.237
80 Aug 13 23.833 120.676 20.113
81 Sep 13 24.041 120.610 20.102
82 Oct 12 23.874 120.270 20.045
83 Nov 13 23.961 120.814 20.136
84 Dec 13 23.787 120.636 20.106
85 Jan 14 23.467 120.059 20.010
86 Feb 14 23.658 120.476 20.079
87 Mar 14 23.811 121.279 20.213
88 Apr 14 23.713 122.054 20.342
89 May 14 23.977 122.421 20.404
90 Jun 14 24.039 123.065 20.511
91 Jul 14 24.082 123.183 20.530
92 Aug 14 24.639 122.008 20.335
93 Sep 14 25.019 121.922 20.320
94 Oct 14 24.984 122.952 20.492
95 Nov 14 25.108 122.558 20.426
96 Dec 14 24.890 122.300 20.383
97 Jan 15 24.553 121.999 20.333
98 Feb 15 24.741 122.378 20.396
99 Mar 15 24.937 122.698 20.450
100 Apr 15 24.819 123.769 20.628
101 May 15 25.098 124.251 20.708
102 Jun 15 24.816 124.830 20.805
103 Jul 15 24.710 125.012 20.835
104 Aug 15 24.914 124.314 20.719
105 Sep 15 24.928 124.052 20.675
106 Oct 15 25.120 124.597 20.766
107 Nov 15 25.495 124.271 20.712
108 Dec 15 25.426 124.277 20.713
109 Jan 16 25.328 123.710 20.618
110 Feb 16 25.391 124.670 20.778
111 Mar 16 25.741 124.997 20.833
112 Apr 16 25.460 125.615 20.936
113 May 16 25.274 126.319 21.053
114 Jun 16 25.851 126.140 21.023
115 Jul 16 25.984 126.453 21.076
116 Aug 16 26.134 125.670 20.945
117 Sep 16 26.146 125.832 20.972
118 Oct 16 25.965 126.370 21.062
119 Nov 16 26.196 126.190 21.032
120 Dec 16 25.881 125.917 20.986
121 Jan 17 25.721 124.806 20.801
122 Feb 17 25.701 125.893 20.982
123 Mar 17 25.857 126.771 21.128
124 Apr 17 26.354 126.908 21.151
125 May 17 26.290 127.117 21.186
126 Jun 17 26.528 127.558 21.260
127 Jul 17 26.438 128.033 21.339
128 Aug 17 26.520 127.056 21.176
129 Sep 17 26.754 127.739 21.290
130 Oct 17 26.343 127.880 21.313
131 Nov 17 26.453 127.727 21.288
132 Dec 17 26.091 127.510 21.252
133 Jan 18 26.453 126.395 21.066
134 Feb 18 27.094 127.310 21.218
135 Mar 18 27.280 127.597 21.266
136 Apr 18 27.300 128.049 21.342
137 May 18 27.086 128.924 21.487
138 Jun 18 27.134 129.331 21.555
139 Jul 18 26.942 130.062 21.677
140 Aug 18 27.110 128.429 21.405
141 Sep 18 27.471 128.720 21.453
142 Oct 18 27.533 129.419 21.570
143 Nov 18 27.805 129.210 21.535
144 Dec 18 27.393 129.088 21.515
145 Jan 19 27.381 127.583 21.264
146 Feb 19 27.817 128.351 21.392
147 Mar 19 27.775 128.666 21.444
148 Apr 19 27.660 129.049 21.508
149 May 19 27.678 129.474 21.579
150 Jun 19 27.643 130.185 21.698
date Foreign Born Employed Native Born Employed dividedby6
Print Friendly, PDF & Email