Q: How many companies have how many different NAICS (9 TOP naics) over the years?
A:
|
diff_prime_naics_count |
company_count |
|
4 |
8 |
|
3 |
540 |
|
2 |
10760 |
|
1 |
73164 |
Q: # companies that change NAICS code per year?
A:
| year | comp_total | comp_change_count | change_percentage |
| 1990 | 20936 | 784 | 3.74% |
| 1991 | 23554 | 857 | 3.64% |
| 1992 | 24331 | 1843 | 7.57% |
| 1993 | 26938 | 1158 | 4.30% |
| 1994 | 31144 | 906 | 2.91% |
| 1995 | 34477 | 1013 | 2.94% |
| 1996 | 35992 | 1484 | 4.12% |
| 1997 | 38228 | 838 | 2.19% |
| 1998 | 41692 | 1411 | 3.38% |
| 1999 | 43663 | 783 | 1.79% |
| 2000 | 51321 | 642 | 1.25% |
| 2001 | 60294 | 615 | 1.02% |
| 2002 | 56944 | 669 | 1.17% |
| 2003 | 56796 | 915 | 1.61% |
Q: identify bursts of sales & #employees
A:
I. Bursts of sales
Burst threshold: 2.0 (i.e. sales have been doubled that year)
|
year |
comp_count |
min_rate |
max_rate |
avg_rate |
|
1990 |
763 |
2 |
1014 |
5.9 |
|
1991 |
1432 |
2 |
1054 |
5.8 |
|
1992 |
1077 |
2 |
1245 |
7.5 |
|
1993 |
1166 |
2 |
1590 |
8.5 |
|
1994 |
1042 |
2 |
173333 |
174.9 |
|
1995 |
2112 |
2 |
5072 |
8.6 |
|
1996 |
2321 |
2 |
444 |
5.3 |
|
1997 |
2169 |
2 |
300 |
5.0 |
|
1998 |
2560 |
2 |
1060 |
5.4 |
|
1999 |
2256 |
2 |
1666 |
7.2 |
|
2000 |
1820 |
2 |
3333 |
7.0 |
|
2001 |
2211 |
2 |
3902 |
10.2 |
|
2002 |
2055 |
2 |
1067 |
10.2 |
|
2003 |
1834 |
2 |
1694 |
9.5 |
Burst threshold: 5.0
|
year |
comp_count |
min_rate |
max_rate |
avg_rate |
|
1990 |
140 |
5 |
1014 |
19.7 |
|
1991 |
246 |
5 |
1054 |
20.3 |
|
1992 |
186 |
5 |
1245. |
30.2 |
|
1993 |
199 |
5 |
1590 |
36.4 |
|
1994 |
208 |
5 |
173333 |
864.8 |
|
1995 |
390 |
5 |
5072 |
34.4 |
|
1996 |
380 |
5 |
444 |
18.0 |
|
1997 |
395 |
5 |
300 |
15.0 |
|
1998 |
443 |
5 |
1060 |
17.6 |
|
1999 |
397 |
5 |
1666 |
27.6 |
|
2000 |
346 |
5 |
3333 |
24.3 |
|
2001 |
552 |
5 |
3902 |
32.3 |
|
2002 |
467 |
5 |
1068 |
35.8 |
|
2003 |
377 |
5 |
1694 |
35.9 |
Burst threshold: 5.0
|
year |
comp_count |
min_rate |
max_rate |
avg_rate |
|
1990 |
50 |
10 |
1014 |
42.7 |
|
1991 |
96 |
10 |
1054 |
41.9 |
|
1992 |
68 |
10 |
1245 |
71.0 |
|
1993 |
70 |
10 |
1590 |
91.1 |
|
1994 |
91 |
10 |
173333 |
1967.7 |
|
1995 |
172 |
10 |
5072 |
69.4 |
|
1996 |
155 |
10 |
444 |
34.5 |
|
1997 |
162 |
10 |
300 |
26.8 |
|
1998 |
192 |
10 |
1060 |
31.6 |
|
1999 |
167 |
10 |
1666 |
56.1 |
|
2000 |
147 |
10 |
3333 |
48.0 |
|
2001 |
251 |
10 |
3902 |
62.8 |
|
2002 |
219 |
10 |
1067 |
68.8 |
|
2003 |
162 |
10 |
1694 |
74.9 |
II. Bursts of both sales and #employees
Burst threshold: 2.0
|
year |
comp_count |
|
1990 |
186 |
|
1991 |
326 |
|
1992 |
246 |
|
1993 |
262 |
|
1994 |
222 |
|
1995 |
525 |
|
1996 |
488 |
|
1997 |
462 |
|
1998 |
547 |
|
1999 |
403 |
|
2000 |
384 |
|
2001 |
763 |
|
2002 |
613 |
|
2003 |
407 |
Burst threshold: 5.0
|
year |
comp_count |
|
1990 |
34 |
|
1991 |
47 |
|
1992 |
34 |
|
1993 |
40 |
|
1994 |
45 |
|
1995 |
103 |
|
1996 |
87 |
|
1997 |
77 |
|
1998 |
95 |
|
1999 |
73 |
|
2000 |
67 |
|
2001 |
136 |
|
2002 |
134 |
|
2003 |
75 |
Burst threshold: 10.0
|
year |
comp_count |
|
1990 |
15 |
|
1991 |
21 |
|
1992 |
14 |
|
1993 |
13 |
|
1994 |
19 |
|
1995 |
46 |
|
1996 |
39 |
|
1997 |
30 |
|
1998 |
40 |
|
1999 |
27 |
|
2000 |
23 |
|
2001 |
48 |
|
2002 |
52 |
|
2003 |
29 |
Q: Correlate company location changes, sales, #employees?
A:
| company_id | year | cum_distance | cum_sales | cum_employees | sales_rate | emp_rate |
| 12908 | 1989 | 6.5 | 11 | |||
| 12908 | 1990 | 8.496 | 22 | 0.3071 | 1.0000 | |
| 12908 | 1991 | 0.0440 | 8.496 | 22 | 1.0000 | 1.0000 |
| 12908 | 1991 | 0.0440 | 8.496 | 22 | 1.0000 | 1.0000 |
| 12908 | 1992 | 0.0440 | 8.496 | 22 | 1.0000 | 1.0000 |
| 12908 | 1993 | 4.9114 | 10.31 | 32 | 0.9088 | 0.9091 |
| 12908 | 1993 | 4.9114 | 10.31 | 32 | 0.9088 | 0.9091 |
| 12908 | 1994 | 4.9114 | 11.399 | 38 | 0.6003 | 0.6000 |
| 12908 | 1995 | 4.9114 | 11.399 | 38 | 1.0000 | 1.0000 |
| 12908 | 1996 | 5.7455 | 21.399 | 44 | 9.1827 | 1.0000 |
| 12908 | 1996 | 5.7455 | 21.399 | 44 | 9.1827 | 1.0000 |
| 12908 | 1997 | 7.8715 | 21.399 | 44 | 1.0000 | 1.0000 |
| 12908 | 1997 | 7.8715 | 21.399 | 44 | 1.0000 | 1.0000 |
| 12908 | 1998 | 8.8806 | 438.711 | 2344 | 41.7312 | 383.3333 |
| 12908 | 1998 | 8.8806 | 438.711 | 2344 | 41.7312 | 383.3333 |
| 12908 | 1999 | 8.8806 | 938.711 | 4344 | 1.1981 | 0.8696 |
| 12908 | 2000 | 8.8806 | 938.711 | 4344 | 1.0000 | 1.0000 |
| 12908 | 2001 | 8.8806 | 1005.21 | 5844 | 0.1330 | 0.7500 |
| 12908 | 2002 | 9.2678 | 1071.71 | 7338 | 1.0000 | 0.9960 |
| 12908 | 2002 | 9.2678 | 1071.71 | 7338 | 1.0000 | 0.9960 |
| 12908 | 2003 | 9.2678 | 1071.71 | 7338 | 1.0000 | 1.0000 |
| 27771 | 1989 | 0.62 | 6 | |||
| 27771 | 1990 | 2.12 | 14 | 2.4194 | 1.3333 | |
| 27771 | 1991 | 3.82 | 30 | 1.1333 | 2.0000 | |
| 27771 | 1992 | 18.82 | 56 | 8.8235 | 1.6250 | |
| 27771 | 1993 | 33.82 | 96 | 1.0000 | 1.5385 | |
| 27771 | 1994 | 48.82 | 161 | 1.0000 | 1.6250 | |
| 27771 | 1995 | 0.4262 | 82.12 | 281 | 2.2200 | 1.8462 |
| 27771 | 1995 | 0.4262 | 82.12 | 281 | 2.2200 | 1.8462 |
| 27771 | 1996 | 0.4262 | 82.12 | 281 | 1.0000 | 1.0000 |
| 27771 | 1997 | 0.4811 | 82.12 | 281 | 1.0000 | 1.0000 |
| 27771 | 1997 | 0.4811 | 82.12 | 281 | 1.0000 | 1.0000 |
| 27771 | 1998 | 0.4811 | 92.12 | 307 | 0.3003 | 0.2167 |
| 27771 | 1999 | 0.8734 | 107.12 | 322 | 1.5000 | 0.5769 |
| 27771 | 1999 | 0.8734 | 107.12 | 322 | 1.5000 | 0.5769 |
| 27771 | 2000 | 1.8257 | 109.62 | 334 | 0.1667 | 0.8000 |
| 27771 | 2000 | 1.8257 | 109.62 | 334 | 0.1667 | 0.8000 |
| 27771 | 2001 | 1.8257 | 109.62 | 334 | 1.0000 | 1.0000 |
| 27771 | 2002 | 2.4681 | 110.389 | 340 | 0.3076 | 0.5000 |
| 27771 | 2002 | 2.4681 | 110.389 | 340 | 0.3076 | 0.5000 |
| 27771 | 2003 | 2.6569 | 110.389 | 340 | 1.0000 | 1.0000 |
| 27771 | 2003 | 2.6569 | 110.389 | 340 | 1.0000 | 1.0000 |
| 39754 | 1989 | 12 | 110 | |||
| 39754 | 1990 | 12 | 110 | 1.0000 | 1.0000 | |
| 39754 | 1991 | 0.4030 | 17 | 140 | 0.4167 | 0.2727 |
| 39754 | 1991 | 0.4030 | 17 | 140 | 0.4167 | 0.2727 |
| 39754 | 1992 | 0.4030 | 36.8 | 395 | 3.9600 | 8.5000 |
| 39754 | 1992 | 0.4030 | 36.8 | 395 | 3.9600 | 8.5000 |
| 39754 | 1993 | 0.4030 | 56.8 | 595 | 1.0101 | 0.7843 |
| 39754 | 1994 | 0.7744 | 76.8 | 845 | 1.0000 | 1.2500 |
| 39754 | 1994 | 0.7744 | 76.8 | 845 | 1.0000 | 1.2500 |
| 39754 | 1995 | 0.7744 | 104.8 | 1095 | 1.4000 | 1.0000 |
| 39754 | 1996 | 1.1458 | 139.2 | 1345 | 1.2286 | 1.0000 |
| 39754 | 1996 | 1.1458 | 139.2 | 1345 | 1.2286 | 1.0000 |
| 39754 | 1997 | 1.1458 | 173.2 | 1595 | 0.9884 | 1.0000 |
| 39754 | 1998 | 1.5119 | 213.617 | 1845 | 1.1887 | 1.0000 |
| 39754 | 1998 | 1.5119 | 213.617 | 1845 | 1.1887 | 1.0000 |
| 39754 | 1999 | 1.8779 | 257.917 | 2075 | 1.0961 | 0.9200 |
| 39754 | 1999 | 1.8779 | 257.917 | 2075 | 1.0961 | 0.9200 |
| 39754 | 2000 | 1.8779 | 257.917 | 2075 | 1.0000 | 1.0000 |
| 39754 | 2001 | 2.2439 | 302.217 | 2325 | 1.0000 | 1.0870 |
| 39754 | 2001 | 2.2439 | 302.217 | 2325 | 1.0000 | 1.0870 |
| 39754 | 2002 | 2.2439 | 360.617 | 2575 | 1.3183 | 1.0000 |
| 39754 | 2003 | 2.2439 | 414.617 | 2825 | 0.9247 | 1.0000 |
| 44426 | 1989 | 5 | 60 | |||
| 44426 | 1990 | 11.4 | 120 | 1.2800 | 1.0000 | |
| 44426 | 1991 | 17.9 | 180 | 1.0156 | 1.0000 | |
| 44426 | 1992 | 24.5 | 240 | 1.0154 | 1.0000 | |
| 44426 | 1993 | 0.1223 | 31.4 | 300 | 1.0455 | 1.0000 |
| 44426 | 1993 | 0.1223 | 31.4 | 300 | 1.0455 | 1.0000 |
| 44426 | 1994 | 0.1223 | 38.6 | 360 | 1.0435 | 1.0000 |
| 44426 | 1995 | 28.5899 | 46 | 420 | 1.0278 | 1.0000 |
| 44426 | 1995 | 28.5899 | 46 | 420 | 1.0278 | 1.0000 |
| 44426 | 1996 | 28.5899 | 52.6 | 486 | 0.8919 | 1.1000 |
| 44426 | 1997 | 28.8724 | 52.6 | 486 | 1.0000 | 1.0000 |
| 44426 | 1997 | 28.8724 | 52.6 | 486 | 1.0000 | 1.0000 |
| 44426 | 1998 | 28.8724 | 59.2 | 511 | 1.0000 | 0.3788 |
| 44426 | 1999 | 28.9310 | 64.2 | 536 | 0.7576 | 1.0000 |
| 44426 | 1999 | 28.9310 | 64.2 | 536 | 0.7576 | 1.0000 |
| 44426 | 2000 | 28.9310 | 64.2 | 536 | 1.0000 | 1.0000 |
| 44426 | 2001 | 28.9310 | 64.2 | 536 | 1.0000 | 1.0000 |
| 44426 | 2002 | 29.0874 | 64.2 | 536 | 1.0000 | 1.0000 |
| 44426 | 2002 | 29.0874 | 64.2 | 536 | 1.0000 | 1.0000 |
| 44426 | 2003 | 29.3591 | 65.661 | 546 | 0.2922 | 0.4000 |
| 44426 | 2003 | 29.3591 | 65.661 | 546 | 0.2922 | 0.4000 |
| 77117 | 1989 | 0.05 | 3 | |||
| 77117 | 1990 | 0.05 | 3 | 1.0000 | 1.0000 | |
| 77117 | 1991 | 0.0785 | 0.05 | 3 | 1.0000 | 1.0000 |
| 77117 | 1991 | 0.0785 | 0.05 | 3 | 1.0000 | 1.0000 |
| 77117 | 1992 | 0.0785 | 0.05 | 3 | 1.0000 | 1.0000 |
| 77117 | 1993 | 0.1938 | 0.2 | 6 | 3.0000 | 1.0000 |
| 77117 | 1993 | 0.1938 | 0.2 | 6 | 3.0000 | 1.0000 |
| 77117 | 1994 | 0.1938 | 0.2 | 6 | 1.0000 | 1.0000 |
| 77117 | 1995 | 0.2185 | 0.2 | 6 | 1.0000 | 1.0000 |
| 77117 | 1995 | 0.2185 | 0.2 | 6 | 1.0000 | 1.0000 |
| 77117 | 1996 | 0.2185 | 0.2 | 6 | 1.0000 | 1.0000 |
| 77117 | 1997 | 0.2185 | 0.84 | 11 | 4.2667 | 1.6667 |
| 77117 | 1998 | 0.3219 | 1.14 | 16 | 0.4688 | 1.0000 |
| 77117 | 1998 | 0.3219 | 1.14 | 16 | 0.4688 | 1.0000 |
| 77117 | 1999 | 0.3219 | 1.14 | 16 | 2.1333 | 1.0000 |
| 77117 | 2000 | 0.3219 | 1.81 | 21 | 1.0469 | 1.0000 |
| 77117 | 2001 | 0.3219 | 1.81 | 21 | 1.0000 | 1.0000 |
| 77117 | 2002 | 0.6138 | 1.81 | 21 | 1.0000 | 1.0000 |
| 77117 | 2002 | 0.6138 | 1.81 | 21 | 1.0000 | 1.0000 |
| 77117 | 2003 | 1.0995 | 2.575 | 26 | 1.1418 | 1.0000 |
| 77117 | 2003 | 1.0995 | 2.575 | 26 | 1.1418 | 1.0000 |
| 78356 | 1989 | |||||
| 78356 | 1990 | 52.8 | 340 | |||
| 78356 | 1991 | 47.8619 | 105.8 | 680 | 1.0038 | 1.0000 |
| 78356 | 1991 | 47.8619 | 105.8 | 680 | 1.0038 | 1.0000 |
| 78356 | 1992 | 47.8619 | 105.8 | 680 | 1.0000 | 1.0000 |
| 78356 | 1993 | 47.9554 | 169.079 | 1580 | 1.1939 | 2.6471 |
| 78356 | 1993 | 47.9554 | 169.079 | 1580 | 1.1939 | 2.6471 |
| 78356 | 1994 | 47.9554 | 214.362 | 2480 | 0.7156 | 1.0000 |
| 78356 | 1995 | 95.9845 | 310.007 | 3450 | 2.1122 | 1.0778 |
| 78356 | 1995 | 95.9845 | 310.007 | 3450 | 2.1122 | 1.0778 |
| 78356 | 1996 | 95.9845 | 310.007 | 3450 | 1.0000 | 1.0000 |
| 78356 | 1997 | 95.9845 | 430.007 | 4550 | 1.2546 | 1.1340 |
| 78356 | 1998 | 101.7923 | 571.507 | 5950 | 1.1792 | 1.2727 |
| 78356 | 1998 | 101.7923 | 571.507 | 5950 | 1.1792 | 1.2727 |
| 78356 | 1999 | 101.7923 | 718.707 | 6950 | 1.0403 | 0.7143 |
| 78356 | 2000 | 101.8323 | 883.707 | 7950 | 1.1209 | 1.0000 |
| 78356 | 2000 | 101.8323 | 883.707 | 7950 | 1.1209 | 1.0000 |
| 78356 | 2001 | 101.8323 | 1081.01 | 10050 | 1.1958 | 2.1000 |
| 78356 | 2002 | 107.6694 | 1315.61 | 12150 | 1.1891 | 1.0000 |
| 78356 | 2002 | 107.6694 | 1315.61 | 12150 | 1.1891 | 1.0000 |
| 78356 | 2003 | 107.6694 | 1630.91 | 15650 | 1.3440 | 1.6667 |