Spreadsheet: 269646d1381240325-combining-a-spreadsheet-into-a-column-on-a-different-spreadsheet-pa_naic_5_lq-1
Sheet: philly v usa lq5

NAICS-5 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012
22112 | ND | ND | 1.91 | 2.3 | 2.21 | ND | ND | ND | ND | ND | ND | ND
23611 | 0.32 | 0.31 | 0.29 | 0.29 | 0.32 | 0.35 | 0.36 | 0.37 | 0.36 | 0.41 | 0.41 | 0.4
23721 | 0.25 | 0.26 | 0.26 | 0.26 | 0.22 | 0.2 | 0.26 | 0.33 | 0.17 | 0.17 | 0.19 | na
23731 | 0.35 | 0.35 | 0.36 | 0.32 | 0.33 | 0.4 | 0.38 | 0.36 | 0.37 | 0.48 | 0.51 | 0.44
23811 | 0.16 | 0.13 | 0.12 | 0.12 | 0.15 | 0.13 | 0.14 | 0.1 | 0.1 | 0.12 | 0.11 | 0.11
23816 | 0.56 | 0.5 | 0.5 | 0.56 | 0.48 | 0.48 | 0.43 | 0.41 | 0.36 | 0.39 | 0.42 | 0.35
23821 | 0.3 | 0.33 | 0.32 | 0.31 | 0.3 | 0.34 | 0.33 | 0.34 | 0.3 | 0.29 | 0.26 | 0.31
23822 | 0.87 | 0.61 | 0.59 | 0.6 | 0.68 | 0.58 | 0.54 | 0.58 | 0.53 | 0.53 | 0.52 | 0.5
23839 | 0.33 | 0.73 | 0.3 | 0.38 | 0.29 | 0.82 | 0.9 | 0.88 | 0.86 | 0.98 | 1.36 | 1.8
23891 | 0.25 | 0.21 | 0.2 | 0.2 | 0.17 | 0.19 | 0.21 | 0.23 | 0.22 | 0.19 | 0.26 | 0.21
23899 | 0.32 | 0.34 | 0.26 | 0.19 | 0.18 | 0.15 | 0.14 | 0.13 | 0.12 | 0.14 | 0.08 | 0.11
31193 | ND | ND | ND | ND | ND | ND | ND | ND | ND | NA | ND | ND
31521 | 1.27 | 1.09 | 1.06 | 0.95 | 0.88 | 0.69 | ND | ND | ND | ND | ND | ND
31523 | 1.56 | 1.76 | 2.06 | 3.28 | 5.28 | ND | ND | ND | ND | NA | NC | NC
32191 | 0.15 | 0.15 | 0.16 | 0.12 | 0.12 | 0.12 | 0.14 | 0.13 | ND | 0.16 | ND | 0.18
32221 | 1.31 | 1.26 | 1.23 | 0.98 | 0.82 | 0.76 | 0.72 | 0.66 | 0.66 | 0.65 | 0.61 | 0.65
32229 | 1.6 | 1.6 | 1.5 | 1.93 | 1.75 | 1.35 | ND | ND | ND | ND | ND | ND
32311 | 0.82 | 0.79 | 0.78 | 0.8 | 0.82 | 0.85 | 0.81 | 0.78 | 0.73 | 0.73 | 0.7 | 0.82
32513 | 0.39 | 0.41 | 0.45 | 0.47 | 0.45 | ND | ND | 0.57 | 0.57 | 0.72 | 0.77 | 0.77
32541 | 0.6 | 0.65 | 0.71 | 0.84 | 0.87 | 0.89 | 0.88 | 0.89 | 0.84 | 0.87 | 0.93 | 0.91
33232 | 1.06 | 1.07 | 1.14 | 1.27 | 1.33 | 1.34 | ND | ND | ND | ND | ND | ND
33281 | 0.39 | 0.37 | 0.36 | 0.42 | 0.4 | 0.4 | 0.37 | 0.36 | 0.36 | 0.34 | 0.3 | 0.29
33331 | 0.21 | 0.21 | 0.21 | 0.22 | 0.22 | 0.21 | 0.22 | 0.24 | 0.25 | 0.23 | 0.24 | 0.24
33341 | 0.52 | 0.54 | 0.5 | 0.62 | 0.61 | 0.6 | 0.58 | 0.5 | 0.46 | 0.49 | 0.46 | 0.39
33411 | ND | ND | ND | NC | NC | NC | NC | NC | NC | NC | ND | ND
33441 | 0.07 | 0.09 | 0.1 | 0.11 | 0.12 | 0.1 | ND | ND | 0.01 | 0.02 | 0.01 | 0.01
33631 | ND | ND | ND | ND | ND | ND | ND | NC | NC | NC | ND | ND
33651 | NC | NC | NC | NC | ND | ND | ND | ND | ND | ND | 1.91 | ND
33721 | 0.7 | 0.67 | 0.82 | 0.83 | 0.72 | 0.64 | 0.63 | 0.67 | 0.85 | 0.84 | 1.02 | 1.04
33911 | 0.47 | 0.52 | 0.54 | 0.46 | 0.5 | 0.53 | 0.42 | 0.41 | 0.39 | 0.4 | 0.33 | 0.34
33999 | 0.62 | 0.61 | 0.52 | 0.57 | 0.55 | 0.52 | 0.47 | 0.46 | 0.42 | 0.41 | 0.44 | 0.42
42331 | 0.42 | 0.35 | 0.29 | 0.27 | 0.26 | 0.26 | 0.23 | 0.22 | 0.21 | 0.22 | 0.24 | 0.26
42332 | 0.38 | 0.36 | 0.38 | 0.4 | 0.36 | 0.31 | 0.28 | 0.25 | 0.19 | 0.2 | 0.19 | 0.34
42333 | 0.54 | 0.5 | 0.54 | 0.63 | 0.58 | 0.52 | 0.48 | 0.3 | 0.3 | 0.3 | 0.36 | 0.43
42361 | 0.73 | 0.74 | 0.72 | 0.7 | 0.72 | 0.71 | 0.69 | 0.65 | 0.6 | 0.61 | 0.57 | 0.54
42362 | 1.82 | 1.78 | 1.79 | 2.2 | 2.08 | 1.96 | 2.04 | 2.05 | 2.03 | 0.64 | 0.73 | 0.66
42383 | 0.23 | 0.29 | 0.28 | 0.27 | 0.28 | 0.29 | 0.2 | 0.15 | 0.15 | 0.15 | 0.15 | 0.14
42391 | 0.19 | 0.19 | 0.04 | ND | 0.05 | ND | 0.38 | 0.27 | 0.31 | 0.37 | 0.4 | 0.3
42399 | 0.63 | 0.52 | 0.19 | ND | 0.09 | 0.09 | 0.14 | 0.19 | 0.19 | 0.21 | 0.26 | 0.35
42413 | 2.05 | 1.6 | 1.6 | 2.34 | 2.32 | 2.29 | 2.37 | 2.11 | 2.16 | 2.2 | 2.13 | 1.98
42421 | 0.53 | 0.65 | 0.43 | 0.36 | 0.35 | 0.26 | 0.25 | 0.31 | 0.32 | 0.36 | 0.38 | 0.63
42433 | 0.56 | 0.48 | 0.42 | 0.31 | 0.33 | 0.3 | 0.24 | 0.22 | 0.18 | 0.14 | 0.12 | 0.13
42443 | 0.45 | 0.42 | 0.39 | 0.44 | 0.46 | 0.42 | 0.54 | 0.53 | 0.49 | 0.5 | 0.48 | ND
42447 | 2.32 | 2.34 | 2.49 | 2.29 | 2.23 | 2.16 | 2.13 | 1.96 | 1.8 | 1.72 | 1.57 | 1.47
42449 | 0.18 | 0.17 | 0.29 | 0.23 | 0.25 | 0.26 | 0.28 | 0.28 | 0.29 | 0.32 | 0.28 | 0.35
42459 | NC | NC | NC | NC | ND | ND | ND | ND | ND | ND | ND | 0.15
42481 | 1.14 | 1.25 | 1.28 | 1.24 | 1.25 | 1.26 | 1.29 | 1.36 | 1.28 | 1.3 | 1.32 | 1.34
42499 | 0.85 | 2.26 | 0.31 | 0.31 | 0.36 | 0.32 | 0.25 | 0.22 | 0.21 | 0.2 | 0.29 | 0.32
44112 | 0.44 | 0.36 | 0.42 | 0.44 | 0.41 | 0.41 | 0.46 | 0.49 | 0.45 | 0.42 | 0.41 | 0.45
44419 | 0.24 | 0.24 | 0.25 | 0.24 | 0.26 | 0.24 | 0.27 | 0.22 | 0.25 | 0.24 | 0.24 | 0.23
44529 | 0.78 | 0.76 | 0.97 | 1.04 | 1.02 | 0.99 | 0.76 | 0.83 | 0.86 | 0.91 | 0.97 | 0.92
44599
44812 | 2.27 | 2.27 | 2.1 | 1.27 | 1.19 | 1.2 | 1.08 | 0.99 | 0.87 | 0.87 | 0.89 | 0.91
44814 | 1.12 | 1.12 | 1.23 | 1.04 | 0.96 | 1.05 | 1.08 | 0.97 | 1.05 | 1.03 | 1.21 | 1.18
44819 | 1.01 | 0.99 | 1.06 | 1.06 | 1.06 | 0.99 | 1.02 | 0.99 | 0.96 | 0.89 | 0.89 | 1.01
45321 | 0.78 | 0.71 | 0.57 | 0.63 | 0.73 | 0.66 | 0.69 | 0.66 | 0.68 | 0.68 | 0.46 | 0.48
45399 | 0.87 | 0.92 | 0.81 | 0.75 | 0.81 | 0.79 | 0.79 | 0.81 | 0.77 | 0.72 | 0.79 | 0.78
45439 | 0.43 | 0.49 | 0.69 | 0.47 | 0.5 | 0.45 | 0.46 | 0.37 | 0.41 | 0.48 | 0.53 | 0.52
48311 | ND | 0.62 | ND | ND | 0.65 | 0.64 | ND | 0.73 | 0.75 | 0.73 | 0.75 | ND
48412 | 0.35 | 0.29 | 0.26 | 0.21 | 0.19 | 0.18 | 0.17 | 0.19 | 0.15 | 0.13 | 0.11 | 0.1
48421 | 0.53 | 0.51 | 0.6 | 0.61 | 0.58 | 0.55 | 0.6 | 0.61 | 0.55 | 0.52 | 0.39 | 0.39
48711 | ND | ND | 2.83 | ND | 3.09 | ND | ND | 2.4 | ND | ND | ND | ND
48832 | 4.22 | 4.3 | 4.55 | 4.7 | 4.62 | 4.8 | 3.93 | 3.48 | 3.56 | 3.82 | 4.2 | 3.8
48839 | ND | ND | ND | ND | ND | ND | ND | 0.25 | ND | 0.08 | ND | ND
48851 | 0.98 | 1 | 1.02 | 0.99 | 1.01 | 1.04 | 1.05 | 1 | 0.96 | 0.95 | 0.91 | 0.88
49311 | 0.8 | 0.83 | 1.87 | 1.24 | 1.35 | 1.26 | 1.22 | 1.13 | 1.19 | 1.23 | 1.17 | 1.1
49319 | ND | ND | ND | 0.47 | 0.37 | 0.4 | 0.42 | 0.31 | 0.26 | 0.62 | 0.66 | 0.75
51121 | 0.01 | 0.02 | 0.15 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.03 | 0.02 | 0.03
51791 | 0.22 | 0.11 | 0.14 | ND | ND | NC | ND | 0.05 | ND | ND | ND | ND
52229 | 0.33 | 0.32 | 0.32 | 0.59 | 0.42 | 0.31 | 0.31 | 0.3 | 0.33 | 0.32 | ND | 0.41
52231 | 0.13 | 0.18 | 0.23 | 0.39 | 0.37 | 0.51 | 0.56 | 0.45 | 0.44 | 0.45 | 0.47 | 0.44
52239 | 1.22 | 1.24 | 1.27 | 1.07 | 1 | 0.87 | 0.92 | 0.89 | 0.71 | 0.8 | 0.73 | 0.72
52311 | 0.65 | 0.63 | 0.56 | 0.56 | 0.6 | 0.52 | 0.46 | 0.41 | 0.41 | 0.4 | 0.29 | 0.29
52312 | 1.73 | 1.66 | 1.77 | 1.84 | 1.72 | 1.46 | 1.56 | 1.61 | 1.57 | 1.5 | 1.48 | 1.03
52314 | NC | NC | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND
52391 | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | 0.18
52392 | 1.27 | 1.28 | 1.2 | 1.11 | 0.78 | 0.89 | 1 | 1.11 | 1.1 | 1.2 | 1.22 | 1.5
52393 | 1.09 | 2.09 | 1.87 | 1.85 | 1.72 | 2.2 | 2.17 | 1.93 | 1.84 | 1.7 | 1.69 | 1.69
52399 | 3.62 | 2.01 | 1.92 | 2.01 | 1.52 | 0.54 | 0.59 | 0.52 | 0.42 | 0.49 | 0.6 | 0.6
52421 | 0.54 | 0.57 | 0.52 | 0.54 | 0.58 | 0.76 | 0.71 | 0.62 | 0.56 | 0.54 | 0.54 | 0.52
52429 | 2.64 | 2.55 | 2.38 | 2.44 | 2.32 | 1.99 | 1.75 | 1.6 | 2.03 | 1.94 | 1.81 | 1.74
52591 | ND | ND | ND | ND | ND | 4.85 | 4.78 | 4.49 | 4.69 | ND | ND | ND
52592 | ND | ND | ND | ND | ND | ND | ND | 1.58 | 1.33 | 1.12 | 0.45 | 0.38
52593 | NC | NC | NC | ND | ND | ND | NC | NC | NC | NC | NC | NC
52599 | ND | ND | ND | ND | ND | ND | 0.69 | ND | ND | ND | 1.57 | ND
53111 | 1.43 | 1.33 | 1.31 | 1.18 | 1.26 | 1.36 | 1.43 | 1.4 | 1.34 | 1.24 | 1.3 | 1.35
53112 | 0.98 | 0.96 | 0.88 | 1.03 | 1.05 | 1.1 | 1.11 | 1.14 | 1.12 | 1 | 1 | 1.03
53113 | 0.64 | ND | 0.52 | 0.24 | 0.27 | 0.29 | 0.4 | 0.31 | 0.32 | 0.29 | 0.34 | 0.31
53119 | 0.02 | ND | 0.13 | 0.06 | 0.08 | 0.08 | 0.06 | 0.06 | 0.04 | 0.05 | 0.08 | 0.06
53121 | 0.8 | 0.81 | 0.8 | 0.87 | 0.84 | 0.83 | 0.8 | 0.89 | 0.87 | 0.87 | 0.88 | 0.91
53131 | 1.1 | 1.13 | 1.09 | 1.12 | 1.09 | 1.04 | 1.09 | 1.07 | 1.04 | 0.9 | 0.87 | 0.92
53139 | 0.22 | 0.27 | 0.33 | 0.5 | 0.4 | 0.36 | 0.49 | 0.64 | 0.65 | 0.59 | 0.68 | 0.84
53311 | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | 0.2 | ND
54111 | 3.58 | 3.54 | 3.51 | 3.59 | 3.58 | 3.59 | 3.58 | 3.51 | 3.31 | 3.21 | 3.25 | 3.27
54119 | 2.27 | 2.07 | 1.98 | 2.14 | 2.16 | 2.28 | 2.32 | 2.75 | 2.56 | 2.44 | 2.36 | 2.26
54133 | 1.05 | 0.95 | 0.84 | 0.79 | 0.76 | 0.73 | 0.66 | 0.7 | 0.7 | 0.75 | 0.76 | 0.78
54138 | 0.46 | 0.44 | 0.47 | 0.33 | ND | 0.3 | 0.31 | ND | ND | 0.35 | 0.35 | 0.35
54143 | 1.35 | 1.36 | 1.3 | 1.2 | 1.2 | 1.12 | 1.16 | 1.05 | 0.97 | 0.97 | 0.89 | 0.74
54151 | 0.47 | 0.43 | 0.4 | 0.21 | 0.23 | 0.26 | 0.27 | 0.33 | 0.31 | 0.31 | 0.32 | 0.34
54161 | 2 | 2.08 | 1.97 | 1.92 | 1.74 | 1.68 | 1.69 | 1.42 | 1.43 | 1.42 | 1.35 | 1.3
54169 | 0.24 | 0.23 | 0.32 | 1.03 | 1.17 | 1.13 | 1.34 | 1.32 | 1.21 | 1.04 | 0.91 | 0.85
54171 | 1.03 | 1.07 | 1.04 | 0.99 | 0.91 | 0.94 | 0.62 | 0.62 | 0.64 | 0.64 | 0.61 | 0.65
54172 | 0.74 | 0.7 | 0.75 | 0.8 | 0.92 | 0.93 | 1.2 | 1.26 | 1.45 | 1.37 | 1.49 | 1.03
54181 | 1.63 | 1.7 | 1.63 | 1.68 | 1.62 | 1.61 | 1.53 | 1.49 | 1.44 | 1.3 | 1.22 | 1.28
54186 | 0.78 | 0.48 | 0.4 | 0.49 | 0.5 | 0.58 | 0.6 | 0.54 | 0.52 | 0.47 | 0.41 | 0.39
54189 | 0.2 | 0.21 | 0.19 | 0.15 | 0.14 | 0.13 | 0.15 | 0.16 | 0.14 | 0.13 | 0.2 | 0.19
54199 | 1.06 | 1.07 | 1.32 | 1.28 | 1.07 | 0.94 | 0.86 | 0.74 | 0.58 | 0.51 | 0.54 | 0.52
55111 | 0.59 | 0.8 | 0.85 | 1.13 | 1.37 | 1.47 | 1.54 | 1.55 | 1.44 | 1.4 | 1.37 | 1.28
56131 | 1.13 | 1.26 | 1.26 | 1.02 | 0.81 | 0.74 | 0.99 | 0.71 | 0.45 | 0.41 | 0.37 | 0.32
56144 | 1.79 | 1.91 | 1.84 | 1.95 | 1.97 | 1.8 | 1.96 | 1.22 | 0.82 | 0.81 | 0.72 | 0.53
56145 | 0.23 | 0.27 | 0.26 | 0.21 | 0.19 | ND | ND | ND | ND | ND | ND | ND
56149 | 1.63 | 1.23 | 0.79 | 0.65 | 0.59 | 0.63 | 0.63 | 0.59 | 0.64 | 0.68 | 1.02 | 1.07
56161 | 1.35 | 1.35 | 1.54 | 1.18 | 1.18 | 1.19 | 1.1 | 1 | 0.95 | 1.87 | 1.82 | 1.9
56173 | 0.15 | 0.15 | 0.13 | 0.11 | 0.1 | 0.09 | 0.09 | 0.08 | 0.1 | 0.11 | 0.12 | 0.14
56221 | 0.48 | 0.5 | 0.45 | 0.36 | 0.43 | 0.34 | 0.35 | 0.33 | 0.2 | 0.1 | 0.12 | 0.07
61131 | 8.7 | 8.81 | 8.48 | 8.56 | 8.59 | 8.31 | 8.26 | 8.13 | 7.7 | 7.52 | 7.44 | 7.4
62111 | 1.05 | 1.04 | 1.02 | 1.05 | 1.03 | 1.16 | 1.14 | 1.11 | 1.08 | 1.04 | 1.04 | 1.05
62141 | 9.1 | 9.27 | 10.24 | 7.82 | 8.44 | ND | ND | ND | 6.32 | ND | 0.7 | 0.7
62149 | 1.46 | 1.62 | 1.49 | 1.45 | 1.15 | ND | ND | ND | 0.9 | ND | 0.82 | 0.89
72211 | 0.73 | 0.73 | 0.71 | 0.78 | 0.86 | 0.8 | 0.82 | 0.8 | 0.81 | 0.81 | NC | NC
72232 | 1.45 | 1.72 | 2.05 | 2 | 2.04 | 1.79 | 1.91 | 1.66 | 1.62 | 1.79 | 1.86 | 1.97
81111 | 0.68 | 0.67 | 0.67 | 0.68 | 0.74 | 0.75 | 0.73 | 0.74 | 0.72 | 0.74 | 0.74 | 0.73
81121 | 0.66 | 0.73 | 0.79 | 0.88 | 0.61 | 0.4 | 0.35 | 0.41 | 0.39 | 0.35 | 0.27 | 0.31
81293 | 5.22 | 5.39 | 5.09 | 5.71 | 5.45 | 5.36 | 5.18 | 4.77 | 4.37 | 4.49 | 4.53 | 4.64
81299 | 1.04 | 2.1 | 2.4 | 1.23 | 1.44 | 1.08 | 0.79 | 0.75 | 0.64 | 0.54 | 0.62 | 0.78
81393 | 2.11 | 2.25 | 2.24 | 2.35 | 2.47 | 2.44 | 2.4 | 2.31 | 2.25 | 2.19 | 2.22 | 2.26