Q: What are the individual industries in the dataset?
A:
|
industry_id |
entry_count |
|
sof |
91094 |
|
tel |
70821 |
|
|
65917 |
|
sub |
50975 |
|
com |
33279 |
|
aut |
32711 |
|
man |
32187 |
|
tam |
26306 |
|
non |
25342 |
|
env |
23054 |
|
med |
21593 |
|
mat |
21300 |
|
pho |
12598 |
|
enr |
11749 |
|
che |
11711 |
|
bio |
11629 |
|
trn |
8448 |
|
pha |
7212 |
|
def |
5366 |
|
0 |
3 |
Q: Yearly distribution of #companies in each industry.
A:
|
year |
industry_id |
comp_count |
|
1989 |
|
16984 |
|
1989 |
man |
1 |
|
1990 |
|
20936 |
|
1991 |
|
23523 |
|
1991 |
man |
4 |
|
1991 |
mat |
4 |
|
1991 |
aut |
3 |
|
1991 |
com |
3 |
|
1991 |
med |
3 |
|
1991 |
pha |
2 |
|
1991 |
sub |
2 |
|
1991 |
tel |
2 |
|
1991 |
trn |
2 |
|
1991 |
bio |
1 |
|
1991 |
che |
1 |
|
1991 |
def |
1 |
|
1991 |
enr |
1 |
|
1991 |
pho |
1 |
|
1991 |
sof |
1 |
|
1992 |
|
3790 |
|
1992 |
sof |
3788 |
|
1992 |
sub |
2206 |
|
1992 |
non |
2155 |
|
1992 |
com |
1515 |
|
1992 |
aut |
1305 |
|
1992 |
tam |
1260 |
|
1992 |
man |
1155 |
|
1992 |
env |
1149 |
|
1992 |
mat |
961 |
|
1992 |
med |
897 |
|
1992 |
tel |
882 |
|
1992 |
che |
632 |
|
1992 |
pho |
607 |
|
1992 |
bio |
489 |
|
1992 |
enr |
464 |
|
1992 |
def |
410 |
|
1992 |
trn |
406 |
|
1992 |
pha |
260 |
|
1993 |
sof |
5015 |
|
1993 |
sub |
3108 |
|
1993 |
non |
2340 |
|
1993 |
com |
2005 |
|
1993 |
aut |
1823 |
|
1993 |
env |
1576 |
|
1993 |
tam |
1553 |
|
1993 |
man |
1369 |
|
1993 |
mat |
1234 |
|
1993 |
tel |
1228 |
|
1993 |
med |
1173 |
|
1993 |
pho |
811 |
|
1993 |
che |
785 |
|
1993 |
enr |
625 |
|
1993 |
bio |
617 |
|
1993 |
trn |
579 |
|
1993 |
def |
440 |
|
1993 |
pha |
337 |
|
1993 |
|
320 |
|
1994 |
sof |
6261 |
|
1994 |
sub |
3665 |
|
1994 |
com |
2450 |
|
1994 |
aut |
2425 |
|
1994 |
man |
1926 |
|
1994 |
tam |
1882 |
|
1994 |
env |
1779 |
|
1994 |
mat |
1567 |
|
1994 |
med |
1505 |
|
1994 |
tel |
1450 |
|
1994 |
non |
1148 |
|
1994 |
pho |
1014 |
|
1994 |
che |
915 |
|
1994 |
enr |
784 |
|
1994 |
bio |
737 |
|
1994 |
trn |
649 |
|
1994 |
def |
454 |
|
1994 |
pha |
416 |
|
1994 |
|
117 |
|
1995 |
sof |
6980 |
|
1995 |
sub |
4115 |
|
1995 |
com |
2822 |
|
1995 |
aut |
2765 |
|
1995 |
man |
2411 |
|
1995 |
tam |
2107 |
|
1995 |
env |
1912 |
|
1995 |
mat |
1788 |
|
1995 |
med |
1742 |
|
1995 |
tel |
1731 |
|
1995 |
pho |
1080 |
|
1995 |
che |
966 |
|
1995 |
enr |
864 |
|
1995 |
bio |
802 |
|
1995 |
trn |
715 |
|
1995 |
non |
703 |
|
1995 |
pha |
483 |
|
1995 |
def |
462 |
|
1995 |
|
29 |
|
1996 |
sof |
7290 |
|
1996 |
sub |
4288 |
|
1996 |
com |
2991 |
|
1996 |
aut |
2902 |
|
1996 |
man |
2613 |
|
1996 |
tam |
2210 |
|
1996 |
env |
1994 |
|
1996 |
tel |
1891 |
|
1996 |
mat |
1820 |
|
1996 |
med |
1781 |
|
1996 |
pho |
1083 |
|
1996 |
che |
973 |
|
1996 |
enr |
893 |
|
1996 |
bio |
884 |
|
1996 |
trn |
719 |
|
1996 |
non |
664 |
|
1996 |
pha |
499 |
|
1996 |
def |
477 |
|
1996 |
|
20 |
|
1997 |
sof |
7746 |
|
1997 |
sub |
4460 |
|
1997 |
com |
3107 |
|
1997 |
aut |
2981 |
|
1997 |
tel |
2785 |
|
1997 |
man |
2714 |
|
1997 |
tam |
2239 |
|
1997 |
env |
1977 |
|
1997 |
med |
1870 |
|
1997 |
mat |
1848 |
|
1997 |
pho |
1078 |
|
1997 |
che |
986 |
|
1997 |
bio |
921 |
|
1997 |
enr |
920 |
|
1997 |
non |
783 |
|
1997 |
trn |
737 |
|
1997 |
pha |
576 |
|
1997 |
def |
481 |
|
1997 |
|
19 |
|
1998 |
sof |
7854 |
|
1998 |
sub |
4749 |
|
1998 |
tel |
4700 |
|
1998 |
aut |
3098 |
|
1998 |
com |
3092 |
|
1998 |
man |
2943 |
|
1998 |
tam |
2437 |
|
1998 |
env |
2108 |
|
1998 |
med |
1930 |
|
1998 |
mat |
1864 |
|
1998 |
pho |
1111 |
|
1998 |
bio |
1026 |
|
1998 |
che |
1009 |
|
1998 |
non |
973 |
|
1998 |
enr |
958 |
|
1998 |
trn |
730 |
|
1998 |
pha |
638 |
|
1998 |
def |
463 |
|
1998 |
|
9 |
|
1999 |
sof |
8421 |
|
1999 |
tel |
5276 |
|
1999 |
sub |
4816 |
|
1999 |
aut |
3134 |
|
1999 |
com |
3059 |
|
1999 |
man |
3029 |
|
1999 |
tam |
2479 |
|
1999 |
env |
2123 |
|
1999 |
med |
2026 |
|
1999 |
mat |
1939 |
|
1999 |
pho |
1143 |
|
1999 |
enr |
1120 |
|
1999 |
bio |
1097 |
|
1999 |
non |
1084 |
|
1999 |
che |
1023 |
|
1999 |
trn |
752 |
|
1999 |
pha |
693 |
|
1999 |
def |
442 |
|
1999 |
|
7 |
|
2000 |
tel |
10776 |
|
2000 |
sof |
9207 |
|
2000 |
sub |
4865 |
|
2000 |
man |
3263 |
|
2000 |
aut |
3204 |
|
2000 |
com |
3166 |
|
2000 |
tam |
2530 |
|
2000 |
env |
2172 |
|
2000 |
med |
2134 |
|
2000 |
mat |
1987 |
|
2000 |
non |
1391 |
|
2000 |
pho |
1202 |
|
2000 |
enr |
1195 |
|
2000 |
bio |
1172 |
|
2000 |
che |
1047 |
|
2000 |
trn |
770 |
|
2000 |
pha |
746 |
|
2000 |
def |
448 |
|
2000 |
|
46 |
|
2001 |
tel |
15055 |
|
2001 |
sof |
10105 |
|
2001 |
sub |
4938 |
|
2001 |
non |
4459 |
|
2001 |
man |
3603 |
|
2001 |
com |
3240 |
|
2001 |
aut |
3109 |
|
2001 |
tam |
2578 |
|
2001 |
med |
2175 |
|
2001 |
env |
2120 |
|
2001 |
mat |
2055 |
|
2001 |
enr |
1231 |
|
2001 |
bio |
1224 |
|
2001 |
pho |
1213 |
|
2001 |
che |
1125 |
|
2001 |
pha |
804 |
|
2001 |
trn |
790 |
|
2001 |
def |
433 |
|
2001 |
|
36 |
|
2001 |
0 |
1 |
|
2002 |
tel |
12957 |
|
2002 |
sof |
9260 |
|
2002 |
sub |
4883 |
|
2002 |
non |
4678 |
|
2002 |
man |
3506 |
|
2002 |
aut |
2993 |
|
2002 |
com |
2978 |
|
2002 |
tam |
2527 |
|
2002 |
med |
2186 |
|
2002 |
mat |
2061 |
|
2002 |
env |
2043 |
|
2002 |
bio |
1271 |
|
2002 |
enr |
1265 |
|
2002 |
pho |
1144 |
|
2002 |
che |
1102 |
|
2002 |
pha |
855 |
|
2002 |
trn |
784 |
|
2002 |
def |
416 |
|
2002 |
|
34 |
|
2002 |
0 |
1 |
|
2003 |
tel |
12088 |
|
2003 |
sof |
9166 |
|
2003 |
non |
4964 |
|
2003 |
sub |
4880 |
|
2003 |
man |
3650 |
|
2003 |
aut |
2969 |
|
2003 |
com |
2851 |
|
2003 |
tam |
2504 |
|
2003 |
mat |
2172 |
|
2003 |
med |
2171 |
|
2003 |
env |
2101 |
|
2003 |
enr |
1429 |
|
2003 |
bio |
1388 |
|
2003 |
che |
1147 |
|
2003 |
pho |
1111 |
|
2003 |
pha |
903 |
|
2003 |
trn |
815 |
|
2003 |
def |
439 |
|
2003 |
|
47 |
|
2003 |
0 |
1 |