Spreadsheet: 269646d1381240325-combining-a-spreadsheet-into-a-column-on-a-different-spreadsheet-pa_naic_5_lq-1
Sheet: Metro Philly LQ5

NAICS-5 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012
22112 | ND | 1.85 | 1.81 | 1.82 | 1.77 | 0.88 | 0.86 | 0.9 | 0.92 | 0.92 | 0.92 | 0.96
23611
23721
23731
23811
23816
23821 | ND | 0.86 | ND | ND | 0.84 | ND | ND | ND | ND | ND | 0.84 | ND
23822 | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND
23839 | ND | 0.76 | 0.65 | ND | ND | ND | ND | ND | ND | 1.05 | 1.17 | ND
23891 | ND | 0.73 | 0.74 | 0.75 | 0.75 | 0.72 | 0.71 | ND | 0.71 | 0.76 | 0.78 | 0.72
23899 | ND | 0.89 | 0.88 | 0.85 | 0.83 | 0.81 | 0.78 | ND | 0.79 | 0.85 | 0.88 | 0.85
31193 | ND | ND | 1.14 | 1.22 | 1.24 | ND | ND | ND | ND | ND | ND | ND
31521 | ND | 0.84 | 0.77 | 0.76 | 0.84 | 0.66 | ND | ND | 0.35 | 0.32 | ND | 0.33
31523 | ND | 0.8 | 0.78 | 1.07 | ND | 1.69 | ND | ND | ND | ND | NC | NC
32191 | ND | 0.28 | 0.28 | 0.28 | 0.27 | 0.23 | ND | ND | 0.26 | 0.25 | ND | 0.26
32221 | ND | ND | ND | ND | ND | ND | 0.96 | 0.95 | 0.91 | 0.92 | 0.9 | 0.95
32229 | ND | 1.62 | 1.68 | 1.89 | 1.72 | 1.54 | 1.32 | 1.43 | 1.32 | 1.15 | 1.13 | ND
32311 | ND | ND | 1.01 | ND | ND | ND | ND | ND | 1.02 | 1.03 | ND | 1.09
32513 | ND | ND | ND | ND | 2.92 | 2.98 | 2.98 | ND | ND | ND | 3.05 | 3.39
32541 | ND | ND | ND | ND | ND | ND | ND | ND | ND | 2.85 | 2.92 | 2.76
33232 | ND | 1.09 | 1.03 | ND | 0.91 | 0.97 | 0.98 | 0.99 | 0.94 | 0.96 | 0.92 | 0.88
33281 | ND | ND | ND | ND | ND | 0.5 | 0.5 | ND | ND | ND | ND | 0.49
33331 | ND | 0.99 | ND | ND | ND | ND | ND | ND | ND | ND | 1.01 | 0.96
33341 | ND | 0.42 | 0.4 | 0.42 | 0.4 | 0.37 | 0.35 | 0.39 | 0.39 | 0.44 | 0.39 | 0.38
33411 | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | 0.34 | 0.31
33441 | ND | ND | 0.33 | 0.32 | 0.33 | ND | ND | ND | ND | 0.35 | ND | ND
33631 | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND
33651 | ND | 0.3 | 0.36 | 0.28 | 0.34 | 0.33 | 0.34 | 0.43 | 0.51 | 0.83 | 0.79 | 0.88
33721 | ND | 0.94 | 0.96 | 0.96 | 0.91 | ND | ND | ND | 1.01 | 1.04 | 1.1 | 1.22
33911 | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND
33999 | ND | ND | ND | ND | ND | ND | ND | ND | 0.81 | 0.85 | 0.86 | 0.86
42331 | ND | ND | ND | ND | ND | ND | ND | ND | 0.92 | ND | ND | ND
42332 | ND | ND | ND | ND | 0.65 | 0.67 | ND | 0.7 | 0.77 | 0.65 | 0.68 | 0.82
42333 | ND | 0.95 | ND | ND | ND | ND | ND | 0.96 | 0.96 | 0.95 | ND | ND
42361 | ND | 1.03 | 0.95 | 0.95 | 0.98 | ND | 0.95 | 0.98 | ND | ND | 1.07 | 1.06
42362 | ND | ND | ND | ND | ND | ND | 1.34 | 1.36 | ND | ND | ND | ND
42383 | ND | 0.85 | ND | ND | ND | 0.78 | 0.74 | ND | ND | ND | ND | ND
42391 | ND | ND | ND | 0.92 | 0.92 | 0.86 | 0.88 | ND | 0.82 | 0.86 | 0.84 | 0.81
42399 | ND | 0.61 | 0.54 | 0.56 | 0.67 | ND | ND | 0.63 | ND | 0.65 | 0.57 | 0.64
42413 | ND | 0.95 | 0.93 | 1.16 | ND | 1.51 | ND | 1.19 | ND | 1.26 | 1.26 | 1.17
42421 | ND | ND | ND | 2.05 | 1.93 | 1.99 | 1.89 | ND | ND | ND | 2.08 | 2.16
42433 | ND | ND | ND | 0.35 | ND | 0.25 | 0.22 | ND | ND | 0.3 | ND | ND
42443 | ND | 1.03 | 0.94 | ND | 0.74 | ND | 0.92 | 0.93 | 0.92 | ND | ND | 0.87
42447 | ND | 1.12 | 1.07 | 0.9 | ND | ND | ND | ND | ND | ND | ND | 0.94
42449 | ND | ND | ND | ND | ND | ND | 0.84 | 0.84 | 0.84 | 0.81 | 0.78 | 0.77
42459 | ND | 0.31 | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND
42481 | ND | 0.7 | 0.68 | 0.67 | 0.69 | 0.68 | 0.67 | 0.64 | 0.61 | 0.62 | ND | 0.57
42499 | ND | 1.1 | 0.61 | 0.65 | 0.56 | 0.53 | 0.46 | ND | 0.52 | 0.57 | ND | 0.54
44112 | ND | 0.66 | 0.61 | 0.63 | 0.65 | ND | 0.71 | 0.74 | 0.74 | ND | ND | ND
44419 | ND | ND | ND | ND | ND | ND | ND | ND | 0.67 | 0.65 | ND | ND
44529 | ND | ND | ND | ND | 1.25 | ND | 0.9 | ND | ND | ND | 1.1 | 1.06
44599
44812 | ND | ND | 1.32 | ND | ND | ND | ND | ND | ND | ND | ND | ND
44814 | ND | ND | ND | 1.22 | 1.11 | 1.14 | ND | ND | ND | 1.13 | ND | ND
44819 | ND | ND | ND | 1.22 | 1.15 | ND | ND | ND | 1.06 | 1.04 | ND | 0.97
45321 | ND | ND | ND | 0.89 | ND | ND | ND | ND | ND | ND | ND | ND
45399 | ND | 1.01 | 1.04 | ND | ND | ND | ND | ND | 1.11 | 0.95 | 0.98 | ND
45439 | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND
48311 | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND
48412 | ND | ND | 0.44 | ND | 0.41 | 0.44 | ND | ND | ND | ND | ND | ND
48421 | ND | ND | ND | 0.88 | 0.91 | ND | 0.95 | ND | 0.99 | ND | ND | ND
48711 | ND | ND | 0.84 | 0.65 | 0.77 | ND | ND | ND | ND | ND | 0.86 | 0.86
48832 | ND | ND | 2.32 | 2.38 | 2.26 | 2.29 | 2.15 | 1.96 | 2 | 1.86 | ND | ND
48839 | ND | ND | ND | 1.82 | ND | ND | ND | ND | 3.09 | ND | 0.75 | 0.31
48851 | ND | ND | 0.69 | 0.71 | ND | ND | ND | ND | ND | 0.78 | ND | ND
49311 | ND | 0.8 | 1.06 | 0.9 | 0.88 | 0.99 | 1.01 | 1 | 1.01 | 0.99 | ND | ND
49319 | ND | ND | ND | ND | ND | 1.05 | ND | ND | ND | 1.01 | ND | ND
51121 | ND | ND | 0.51 | ND | ND | ND | ND | ND | ND | ND | ND | 0.43
51791 | ND | ND | ND | ND | ND | ND | 0.32 | 0.37 | 0.4 | 0.41 | 0.34 | 0.38
52229 | ND | ND | ND | 1.3 | 1.24 | ND | ND | ND | ND | 0.98 | ND | 1.36
52231 | ND | 0.8 | ND | 0.85 | ND | 0.92 | ND | 1.09 | ND | 1.06 | 1.24 | 1.1
52239 | ND | 1.74 | 2.12 | 2.07 | 2.12 | ND | ND | ND | ND | 2.1 | ND | ND
52311 | ND | 0.93 | 1.12 | 0.84 | ND | 0.96 | 0.76 | 0.78 | 0.86 | 0.86 | 0.92 | 1.04
52312 | ND | ND | 1.09 | ND | 1.07 | ND | ND | ND | ND | ND | ND | 0.89
52314 | ND | 0.07 | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND
52391 | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND
52392 | ND | 1.52 | 1.44 | 2.56 | ND | ND | ND | 2.42 | 2.36 | 2.27 | 2.27 | 2.48
52393 | ND | ND | ND | ND | ND | 1.46 | ND | 1.45 | 1.34 | 1.26 | ND | 1.31
52399 | ND | 1.6 | 0.83 | 0.84 | 0.77 | ND | 1.5 | ND | ND | ND | ND | ND
52421 | ND | ND | ND | ND | ND | ND | ND | 1.08 | ND | 1.05 | 1.02 | ND
52429 | ND | ND | ND | ND | ND | ND | ND | 1.85 | ND | 1.99 | 2.05 | ND
52591 | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND
52592 | ND | 0.86 | 0.93 | ND | ND | ND | ND | 1.19 | ND | ND | 0.7 | 0.79
52593 | ND | ND | 0.32 | ND | ND | ND | NC | NC | NC | NC | NC | NC
52599 | ND | ND | ND | ND | ND | 0.57 | 0.54 | ND | ND | ND | 0.65 | ND
53111 | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | 0.98 | 0.98
53112 | ND | 1.06 | 1.01 | ND | ND | 0.96 | 0.99 | ND | ND | ND | ND | ND
53113 | ND | ND | ND | 0.76 | 0.7 | ND | ND | ND | ND | ND | ND | ND
53119 | ND | ND | ND | ND | 0.51 | 0.5 | 0.43 | 0.41 | ND | 0.38 | 0.39 | 0.43
53121 | ND | ND | 0.98 | ND | 0.94 | 0.93 | 0.93 | ND | ND | 0.87 | 0.85 | 0.87
53131 | ND | ND | ND | ND | ND | ND | 0.68 | 0.69 | ND | 0.65 | 0.65 | 0.67
53139 | ND | 0.58 | ND | ND | ND | 0.83 | ND | ND | ND | ND | ND | 0.87
53311 | ND | 1.02 | ND | 0.93 | 0.89 | ND | ND | ND | ND | ND | ND | ND
54111 | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | 1.58
54119 | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | 1.81
54133 | ND | ND | 1.04 | 1.02 | ND | 1 | 1 | 0.98 | 0.94 | 0.94 | 0.95 | 0.95
54138 | ND | ND | ND | ND | 0.97 | ND | ND | ND | 1.14 | 1.07 | ND | ND
54143 | ND | 1.32 | 1.35 | 1.2 | 1.15 | 1.16 | ND | 1.14 | 1.14 | ND | ND | ND
54151 | ND | 1.15 | 1.17 | ND | 1.3 | 1.25 | 1.18 | 1.16 | 1.17 | 1.12 | 1.08 | 1.07
54161 | ND | ND | 1.87 | 1.68 | 1.64 | 1.57 | 1.53 | ND | 1.41 | 1.39 | 1.4 | 1.41
54169 | ND | ND | ND | 1.12 | 1.13 | ND | ND | 0.74 | ND | ND | 0.74 | 0.73
54171 | ND | 2.02 | 1.89 | 2.08 | 2.35 | ND | 2.4 | 2.24 | 2.15 | 2.04 | 2.05 | 2.12
54172 | ND | 1.2 | ND | 1.26 | ND | ND | 0.67 | 0.64 | ND | 0.67 | 0.73 | 0.6
54181 | ND | ND | ND | ND | 0.93 | ND | 0.92 | 0.92 | ND | ND | 0.86 | ND
54186 | ND | 2.13 | 2.17 | ND | 2.88 | ND | ND | 3.02 | 2.58 | ND | ND | ND
54189 | ND | 0.81 | 0.74 | 0.7 | ND | ND | ND | ND | 0.61 | 0.59 | 0.6 | 0.62
54199 | ND | ND | 1.69 | 1.54 | 1.56 | 1.51 | 1.45 | ND | ND | ND | 1.02 | ND
55111 | ND | ND | ND | ND | 1.24 | ND | 1.37 | ND | ND | ND | ND | ND
56131 | ND | 1.23 | 1.3 | 1.31 | 1.22 | 1.11 | 1.09 | 0.99 | 0.77 | 0.7 | 0.64 | ND
56144 | ND | ND | ND | ND | 1.72 | 1.68 | 1.68 | 1.72 | 1.7 | 1.59 | 1.53 | 1.41
56145 | ND | ND | ND | ND | ND | ND | ND | ND | 1.26 | ND | 1.09 | ND
56149 | ND | 0.82 | ND | 0.52 | ND | ND | 0.54 | 0.5 | ND | 0.69 | ND | 0.93
56161 | ND | 1.04 | ND | ND | ND | ND | 1.15 | 1.15 | 1.12 | 1.13 | 1.14 | 1.18
56173 | ND | 1.1 | 1.2 | 1.14 | 1.11 | 1.14 | 1.1 | 1.09 | 1.07 | 1.12 | 1.13 | 1.12
56221 | ND | ND | ND | ND | 0.97 | 0.77 | 0.76 | ND | ND | ND | ND | ND
61131 | ND | ND | ND | ND | ND | 2.47 | 2.47 | 2.46 | 2.39 | 2.36 | 2.34 | 2.32
62111 | ND | 1.07 | 1.04 | 1.03 | 1.03 | 1.07 | 1.06 | 1.04 | 1.03 | 1.01 | 1.01 | 1.02
62141 | ND | ND | ND | ND | ND | ND | ND | ND | ND | 2.11 | 1 | ND
62149 | ND | 1.07 | 1.06 | ND | 0.98 | 0.93 | 0.92 | 0.91 | 0.81 | 0.76 | 0.73 | ND
72211 | ND | 0.81 | 0.81 | 0.82 | 0.83 | 0.82 | 0.83 | 0.82 | 0.82 | 0.83 | NC | NC
72232 | ND | 1.25 | ND | ND | 1.35 | 1.29 | ND | ND | 1.26 | ND | ND | ND
81111 | ND | 1.05 | 1.04 | 1.05 | 1.08 | 1.1 | 1.1 | 1.1 | 1.07 | 1.1 | 1.13 | 1.12
81121 | ND | 1.19 | 1.35 | 1.13 | 1.03 | ND | ND | ND | ND | ND | 0.68 | 0.83
81293 | ND | 1.5 | 1.45 | ND | ND | ND | ND | 1.38 | ND | ND | ND | 1.4
81299 | ND | ND | ND | ND | 1.22 | ND | 0.82 | 0.89 | 0.88 | 0.84 | 0.84 | 0.82
81393 | ND | 1.06 | 1.04 | ND | ND | ND | ND | ND | ND | 1.12 | ND | ND