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

NAICS-5 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012
22112 | ND | ND | 1.69 | 2.06 | 1.78 | ND | ND | ND | ND | ND | ND | ND
23611 | 0.31 | 0.32 | 0.3 | 0.3 | 0.34 | 0.4 | 0.41 | 0.41 | 0.38 | 0.41 | 0.4 | 0.41
23721 | 0.62 | 0.63 | 0.58 | 0.66 | 0.57 | 0.57 | 0.71 | 0.79 | 0.39 | 0.36 | 0.3 | ND
23731 | 0.4 | 0.42 | 0.45 | 0.39 | 0.4 | 0.46 | 0.44 | 0.43 | 0.4 | 0.5 | 0.51 | 0.43
23811 | 0.32 | 0.28 | 0.24 | 0.23 | 0.3 | 0.25 | 0.27 | 0.18 | 0.17 | 0.18 | 0.17 | 0.16
23816 | 0.67 | 0.62 | 0.63 | 0.66 | 0.6 | 0.61 | 0.55 | 0.51 | 0.45 | 0.48 | 0.5 | 0.43
23821 | 0.37 | 0.4 | 0.39 | 0.4 | 0.38 | 0.44 | 0.42 | 0.44 | 0.38 | 0.35 | 0.32 | 0.39
23822 | 0.93 | 0.65 | 0.64 | 0.67 | 0.78 | 0.66 | 0.61 | 0.65 | 0.58 | 0.58 | 0.55 | 0.53
23839 | 0.5 | 1.07 | 0.53 | 0.68 | 0.52 | 1.37 | 1.39 | 1.26 | 1.18 | 1.21 | 1.55 | 1.9
23891 | 0.23 | 0.19 | 0.18 | 0.18 | 0.15 | 0.17 | 0.18 | 0.2 | 0.18 | 0.15 | 0.19 | 0.16
23899 | 0.35 | 0.37 | 0.3 | 0.22 | 0.21 | 0.19 | 0.17 | 0.16 | 0.14 | 0.16 | 0.09 | 0.11
31193 | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND
31521 | 0.84 | 0.8 | 0.86 | 0.82 | 0.85 | 0.77 | ND | ND | ND | ND | ND | ND
31523 | 1.68 | 2 | 2.43 | 3.28 | 3.69 | ND | ND | ND | ND | ND | NC | NC
32191 | 0.2 | 0.18 | 0.18 | 0.13 | 0.14 | 0.15 | 0.16 | 0.16 | ND | 0.18 | ND | 0.18
32221 | 1.08 | 1.03 | 1.01 | 0.81 | 0.71 | 0.64 | 0.6 | 0.55 | 0.54 | 0.52 | 0.5 | 0.52
32229 | 0.64 | 0.62 | 0.58 | 0.72 | 0.61 | 0.47 | ND | ND | ND | ND | ND | ND
32311 | 0.64 | 0.61 | 0.6 | 0.62 | 0.63 | 0.65 | 0.63 | 0.6 | 0.57 | 0.56 | 0.54 | 0.64
32513 | 0.22 | 0.23 | 0.25 | 0.27 | 0.24 | ND | ND | 0.3 | 0.3 | 0.36 | 0.35 | 0.34
32541 | 0.29 | 0.31 | 0.34 | 0.46 | 0.5 | 0.5 | 0.51 | 0.5 | 0.49 | 0.51 | 0.55 | 0.57
33232 | 0.72 | 0.75 | 0.83 | 0.96 | 0.99 | 1.04 | ND | ND | ND | ND | ND | ND
33281 | 0.43 | 0.37 | 0.35 | 0.39 | 0.37 | 0.37 | 0.38 | 0.36 | 0.35 | 0.34 | 0.31 | 0.3
33331 | 0.19 | 0.2 | 0.21 | 0.21 | 0.23 | 0.21 | 0.2 | 0.21 | 0.25 | 0.25 | 0.27 | 0.29
33341 | 0.53 | 0.55 | 0.55 | 0.66 | 0.61 | 0.66 | 0.66 | 0.54 | 0.48 | 0.57 | 0.55 | 0.43
33411 | ND | ND | ND | NC | NC | NC | NC | NC | NC | NC | ND | ND
33441 | 0.08 | 0.11 | 0.13 | 0.16 | 0.18 | 0.16 | ND | ND | 0.02 | 0.02 | 0.02 | 0.02
33631 | ND | ND | ND | ND | ND | ND | ND | NC | NC | ND | ND | ND
33651 | NC | NC | NC | NC | ND | ND | ND | ND | ND | ND | 0.26 | ND
33721 | 0.83 | 0.87 | 1 | 1.01 | 0.8 | 0.72 | 0.68 | 0.72 | 0.89 | 0.88 | 0.99 | 0.97
33911 | 0.35 | 0.38 | 0.39 | 0.34 | 0.38 | 0.41 | 0.33 | 0.34 | 0.34 | 0.36 | 0.3 | 0.32
33999 | 0.62 | 0.59 | 0.52 | 0.55 | 0.5 | 0.46 | 0.4 | 0.39 | 0.34 | 0.34 | 0.37 | 0.33
42331 | 0.37 | 0.31 | 0.27 | 0.26 | 0.25 | 0.24 | 0.21 | 0.2 | 0.19 | 0.19 | 0.2 | 0.22
42332 | 0.5 | 0.48 | 0.51 | 0.51 | 0.49 | 0.41 | 0.38 | 0.33 | 0.23 | 0.23 | 0.2 | 0.33
42333 | 0.44 | 0.4 | 0.44 | 0.51 | 0.48 | 0.43 | 0.38 | 0.24 | 0.24 | 0.24 | 0.27 | 0.34
42361 | 0.9 | 0.88 | 0.86 | 0.86 | 0.83 | 0.79 | 0.77 | 0.69 | 0.65 | 0.65 | 0.61 | 0.57
42362 | 1.92 | 1.83 | 1.88 | 2.11 | 2.07 | 2.14 | 2.11 | 2.3 | 2.23 | 0.81 | 0.84 | 0.72
42383 | 0.28 | 0.35 | 0.34 | 0.32 | 0.33 | 0.32 | 0.22 | 0.17 | 0.17 | 0.16 | 0.16 | 0.14
42391 | 0.29 | 0.28 | 0.05 | ND | 0.08 | ND | 0.53 | 0.37 | 0.4 | 0.48 | 0.55 | 0.43
42399 | 1.14 | 0.89 | 0.34 | ND | 0.1 | 0.1 | 0.14 | 0.21 | 0.21 | 0.24 | 0.3 | 0.4
42413 | 2.47 | 2.01 | 2.01 | 2.2 | 2.11 | 2.06 | 2.07 | 1.82 | 1.83 | 1.9 | 1.79 | 1.73
42421 | 0.51 | 0.59 | 0.37 | 0.37 | 0.43 | 0.31 | 0.3 | 0.31 | 0.32 | 0.4 | 0.42 | 0.71
42433 | 1.9 | 1.71 | 1.57 | 1.46 | 1.82 | 1.68 | 1.28 | 0.82 | 0.71 | 0.53 | 0.55 | 0.61
42443 | 0.64 | 0.59 | 0.61 | 0.79 | 0.95 | 0.69 | 0.87 | 0.92 | 0.81 | 0.89 | 0.89 | ND
42447 | 2.5 | 2.33 | 2.46 | 2.41 | 2.27 | 2.36 | 2.48 | 2.27 | 2.13 | 2.07 | 1.88 | 1.69
42449 | 0.29 | 0.26 | 0.4 | 0.29 | 0.33 | 0.35 | 0.39 | 0.38 | 0.39 | 0.41 | 0.37 | 0.43
42459 | NC | NC | NC | NC | ND | ND | ND | ND | ND | ND | ND | 0.28
42481 | 1.78 | 1.95 | 2 | 1.8 | 1.72 | 1.69 | 1.67 | 1.8 | 1.8 | 1.82 | 1.87 | 1.92
42499 | 1.14 | 2.59 | 0.47 | 0.51 | 0.66 | 0.6 | 0.5 | 0.52 | 0.43 | 0.42 | 0.64 | 0.73
44112 | 0.45 | 0.37 | 0.44 | 0.45 | 0.42 | 0.42 | 0.48 | 0.5 | 0.44 | 0.41 | 0.39 | 0.42
44419 | 0.34 | 0.33 | 0.35 | 0.34 | 0.37 | 0.38 | 0.41 | 0.33 | 0.36 | 0.35 | 0.35 | 0.34
44529 | 0.79 | 0.68 | 0.75 | 0.77 | 0.76 | 0.81 | 0.72 | 0.82 | 0.86 | 0.98 | 1.06 | 1.06
44599
44812 | 2.33 | 2.34 | 2.17 | 1.46 | 1.33 | 1.38 | 1.26 | 1.17 | 1.14 | 1.15 | 1.21 | 1.23
44814 | 1.45 | 1.38 | 1.45 | 1.17 | 1.14 | 1.2 | 1.17 | 1.08 | 1.08 | 1.06 | 1.1 | 1.1
44819 | 0.96 | 0.93 | 0.97 | 0.96 | 1 | 0.95 | 1.04 | 1.03 | 0.99 | 0.93 | 0.94 | 1.13
45321 | 0.97 | 0.9 | 0.72 | 0.86 | 0.96 | 0.86 | 0.89 | 0.88 | 0.9 | 0.91 | 0.65 | 0.68
45399 | 0.74 | 0.79 | 0.66 | 0.59 | 0.63 | 0.6 | 0.59 | 0.62 | 0.59 | 0.67 | 0.73 | 0.7
45439 | 0.62 | 0.63 | 0.62 | 0.43 | 0.43 | 0.41 | 0.44 | 0.37 | 0.42 | 0.47 | 0.49 | 0.49
48311 | ND | 1.64 | ND | ND | 2.14 | 2.15 | ND | 2.47 | 2.76 | 3.2 | 3.98 | ND
48412 | 0.28 | 0.24 | 0.22 | 0.19 | 0.18 | 0.17 | 0.16 | 0.17 | 0.14 | 0.12 | 0.11 | 0.1
48421 | 0.74 | 0.72 | 0.79 | 0.77 | 0.73 | 0.66 | 0.72 | 0.74 | 0.67 | 0.67 | 0.53 | 0.54
48711 | ND | ND | 3.78 | ND | 2.78 | ND | ND | 2.19 | ND | ND | ND | ND
48832 | 5.88 | 6.04 | 6.45 | 6.68 | 6.56 | 6.7 | 6.36 | 6.15 | 6.03 | 7.02 | 7.26 | 7.2
48839 | ND | ND | ND | ND | ND | ND | ND | 0.81 | ND | 0.25 | ND | ND
48851 | 1.73 | 1.76 | 1.87 | 1.78 | 1.85 | 2.02 | 2.06 | 1.92 | 1.82 | 1.78 | 1.72 | 1.63
49311 | 0.59 | 0.58 | 1.18 | 0.75 | 0.77 | 0.63 | 0.57 | 0.52 | 0.54 | 0.56 | 0.52 | 0.5
49319 | ND | ND | ND | 0.5 | 0.34 | 0.36 | 0.38 | 0.32 | 0.27 | 0.65 | 0.77 | 0.87
51121 | 0.03 | 0.05 | 0.34 | 0.06 | 0.07 | 0.04 | 0.06 | 0.06 | 0.05 | 0.06 | 0.05 | 0.07
51791 | 0.43 | 0.3 | 0.4 | ND | ND | NC | ND | 0.13 | ND | ND | ND | ND
52229 | 0.51 | 0.5 | 0.53 | 1.02 | 0.77 | 0.62 | 0.64 | 0.65 | 0.74 | 0.69 | ND | 0.7
52231 | 0.22 | 0.3 | 0.36 | 0.61 | 0.6 | 0.73 | 0.72 | 0.57 | 0.67 | 0.72 | 0.84 | 0.79
52239 | 1.7 | 1.58 | 1.24 | 1.09 | 1.02 | 0.95 | 1.03 | 1.09 | 1.08 | 1.23 | 0.87 | 1.74
52311 | 1.95 | 1.86 | 1.36 | 1.33 | 1.43 | 1.27 | 1.51 | 1.25 | 1.2 | 1.17 | 0.91 | 0.89
52312 | 2.07 | 1.94 | 1.92 | 2.04 | 2.01 | 1.96 | 2.07 | 2.11 | 2.09 | 2.06 | 2.05 | 1.69
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.5
52392 | 1.21 | 1.28 | 1.27 | 0.9 | 0.67 | 0.77 | 0.8 | 0.92 | 0.79 | 0.9 | 0.95 | 1.01
52393 | 1.05 | 1.72 | 1.58 | 1.57 | 1.64 | 2.02 | 2.17 | 2.04 | 2.1 | 2.05 | 1.99 | 2.09
52399 | 4.25 | 2.75 | 4.87 | 5.04 | 4.05 | 1.76 | 0.73 | 0.6 | 0.46 | 0.53 | 0.65 | 0.59
52421 | 0.58 | 0.62 | 0.57 | 0.58 | 0.64 | 0.83 | 0.8 | 0.71 | 0.66 | 0.64 | 0.63 | 0.6
52429 | 1.68 | 1.63 | 1.53 | 1.46 | 1.45 | 1.22 | 1.12 | 1.06 | 1.31 | 1.28 | 1.23 | 1.22
52591 | ND | ND | ND | ND | ND | 0.48 | ND | 0.43 | ND | ND | ND | ND
52592 | ND | ND | ND | ND | ND | ND | ND | 1.14 | 1.08 | 1.01 | 0.39 | 0.32
52593 | NC | NC | ND | ND | ND | ND | NC | NC | NC | NC | NC | NC
52599 | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND
53111 | 1.78 | 1.7 | 1.88 | 1.66 | 1.68 | 1.84 | 1.89 | 1.92 | 1.87 | 1.74 | 1.79 | 1.85
53112 | 1.02 | 0.98 | 0.92 | 1.12 | 1.1 | 1.19 | 1.22 | 1.25 | 1.26 | 1.19 | 1.2 | 1.26
53113 | 1.42 | ND | 1.32 | 0.68 | 0.74 | 0.74 | 0.98 | 0.76 | 0.66 | 0.59 | 0.78 | 0.72
53119 | 0.05 | ND | 0.27 | 0.13 | 0.17 | 0.15 | 0.12 | 0.12 | 0.08 | 0.1 | 0.16 | 0.13
53121 | 1.08 | 1.09 | 1.07 | 1.19 | 1.2 | 1.2 | 1.23 | 1.35 | 1.35 | 1.34 | 1.39 | 1.45
53131 | 1.89 | 1.92 | 1.85 | 2.02 | 2.02 | 1.93 | 2.02 | 1.99 | 2.03 | 1.82 | 1.81 | 1.93
53139 | 0.28 | 0.39 | 0.45 | 0.47 | 0.39 | 0.34 | 0.44 | 0.56 | 0.58 | 0.64 | 0.72 | 1
53311 | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | 0.25 | ND
54111 | 3.51 | 3.52 | 3.5 | 3.57 | 3.55 | 3.54 | 3.56 | 3.53 | 3.39 | 3.34 | 3.37 | 3.38
54119 | 2.3 | 2.13 | 1.78 | 1.77 | 1.66 | 1.54 | 1.43 | 1.56 | 1.39 | 1.4 | 1.34 | 1.3
54133 | 1.09 | 1.02 | 0.92 | 0.86 | 0.83 | 0.8 | 0.72 | 0.77 | 0.76 | 0.8 | 0.79 | 0.8
54138 | 0.39 | 0.39 | 0.41 | 0.27 | ND | 0.28 | 0.29 | ND | ND | 0.31 | 0.31 | 0.27
54143 | 1.42 | 1.34 | 1.25 | 1.27 | 1.29 | 1.24 | 1.41 | 1.32 | 1.17 | 1.18 | 1.19 | 1.08
54151 | 0.68 | 0.57 | 0.53 | 0.25 | 0.28 | 0.31 | 0.34 | 0.41 | 0.37 | 0.38 | 0.4 | 0.41
54161 | 1.57 | 1.58 | 1.47 | 1.68 | 1.52 | 1.47 | 1.54 | 1.37 | 1.43 | 1.45 | 1.39 | 1.31
54169 | 0.29 | 0.31 | 0.47 | 1.36 | 1.59 | 2.25 | 2.59 | 2.57 | 2.13 | 1.8 | 1.52 | 1.45
54171 | 1.12 | 1.1 | 1.08 | 0.93 | 0.74 | 0.73 | 0.48 | 0.51 | 0.54 | 0.56 | 0.56 | 0.6
54172 | 0.72 | 0.68 | 0.69 | 0.7 | 1.13 | 1.08 | 1.35 | 1.34 | 1.61 | 2.29 | 2.42 | 1.8
54181 | 2.07 | 2.22 | 2.22 | 2.27 | 2.23 | 2.17 | 2.05 | 2.05 | 2.01 | 1.89 | 1.82 | 1.88
54186 | 0.44 | 0.27 | 0.22 | 0.23 | 0.23 | 0.28 | 0.29 | 0.26 | 0.28 | 0.26 | 0.23 | 0.21
54189 | 0.36 | 0.34 | 0.28 | 0.23 | 0.2 | 0.19 | 0.22 | 0.21 | 0.18 | 0.19 | 0.31 | 0.29
54199 | 0.65 | 0.66 | 0.79 | 0.74 | 0.67 | 0.63 | 0.67 | 0.61 | 0.52 | 0.45 | 0.48 | 0.44
55111 | 0.81 | 1.02 | 0.98 | 1.14 | 1.23 | 1.21 | 1.14 | 1.14 | 1.05 | 0.99 | 0.95 | 0.88
56131 | 1.19 | 1.21 | 1.15 | 0.87 | 0.79 | 0.8 | 1.1 | 0.95 | 1.29 | 1.25 | 1.22 | 1.15
56144 | 1.73 | 1.76 | 1.71 | 1.85 | 1.82 | 1.5 | 1.61 | 1.03 | 0.76 | 0.78 | 0.72 | 0.58
56145 | 0.1 | 0.11 | 0.1 | 0.08 | 0.08 | ND | ND | ND | ND | ND | ND | ND
56149 | 1.64 | 1.24 | 0.85 | 0.66 | 0.66 | 0.65 | 0.71 | 0.77 | 0.75 | 0.82 | 1.25 | 1.31
56161 | 1.53 | 1.53 | 1.72 | 1.32 | 1.3 | 1.29 | 1.2 | 1.11 | 1.07 | 2.08 | 2 | 2.02
56173 | 0.17 | 0.17 | 0.15 | 0.13 | 0.12 | 0.11 | 0.11 | 0.1 | 0.12 | 0.13 | 0.13 | 0.16
56221 | 0.35 | 0.39 | 0.35 | 0.26 | 0.3 | 0.36 | 0.36 | 0.34 | 0.22 | 0.12 | 0.16 | 0.09
61131 | 3.69 | 3.77 | 3.71 | 3.81 | 3.78 | 3.7 | 3.73 | 3.69 | 3.59 | 3.53 | 3.55 | 3.56
62111 | 1.01 | 1.02 | 0.99 | 1.03 | 1.01 | 1.09 | 1.05 | 1.03 | 1.01 | 0.99 | 0.99 | 1.01
62141 | 4.57 | 4.7 | 4.69 | 4.53 | 4.52 | ND | ND | ND | 4.07 | ND | 0.75 | 0.91
62149 | 1.43 | 1.52 | 1.3 | 1.2 | 1 | ND | ND | ND | 0.98 | ND | 1.01 | 0.98
72211 | 0.8 | 0.79 | 0.76 | 0.83 | 0.91 | 0.88 | 0.9 | 0.89 | 0.92 | 0.93 | NC | NC
72232 | 1.64 | 1.75 | 1.92 | 1.89 | 1.95 | 1.68 | 1.76 | 1.62 | 1.63 | 1.82 | 1.92 | 2.08
81111 | 0.61 | 0.6 | 0.6 | 0.6 | 0.64 | 0.65 | 0.63 | 0.63 | 0.63 | 0.64 | 0.63 | 0.62
81121 | 0.82 | 0.86 | 0.86 | 1.01 | 0.65 | 0.48 | 0.43 | 0.48 | 0.42 | 0.38 | 0.31 | 0.34
81293 | 5.09 | 5.21 | 4.9 | 5.67 | 5.65 | 5.52 | 5.53 | 5.42 | 5.04 | 5.39 | 5.51 | 5.42
81299 | 1.15 | 1.57 | 1.73 | 1.04 | 1.39 | 1.07 | 1.14 | 1.08 | 0.99 | 0.93 | 1.15 | 1.53
81393 | 1.46 | 1.58 | 1.6 | 1.64 | 1.71 | 1.68 | 1.67 | 1.61 | 1.59 | 1.56 | 1.58 | 1.6