{\rtf1\ansi\ansicpg1252\cocoartf949\cocoasubrtf540 {\fonttbl\f0\fmodern\fcharset0 Courier;} {\colortbl;\red255\green255\blue255;} \margl1440\margr1440\vieww25020\viewh15120\viewkind0 \pard\tx720\tx1440\tx2160\tx2880\tx3600\tx4320\tx5040\tx5760\tx6480\tx7200\tx7920\tx8640\ql\qnatural\pardirnatural \f0\fs24 \cf0 --------------------------------------------------------------------------------------------------------------------------------------------\ . * READ IN DATA\ \ . insheet using "/Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/employ_special/aah/NHGIS/employ_s\ > pec_indx_data/allcounties_al/employment_alabama_bycounty_byindustry.csv.txt"\ (13 vars, 1328 obs)\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . */need to save data under different name to preserve original data.*/\ \ . save "/Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/employ_special/aah/NHGIS/employ_spec_indx_\ > data/allcounties_al/trial calculations/trial 1/trial 1 data.dta"\ file /Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/employ_special/aah/NHGIS/employ_spec_indx_dat\ > a/allcounties_al/trial calculations/trial 1/trial 1 data.dta saved\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . *DESCRIBE DATA TO SEE WHAT IS IN DATASET\ \ . sum\ \ Variable | Obs Mean Std. Dev. Min Max\ -------------+--------------------------------------------------------\ year | 0\ gisjoin | 0\ state | 0\ statea | 1328 10 0 10 10\ county | 0\ -------------+--------------------------------------------------------\ countya | 1328 723.5843 777.4352 10 9990\ sic | 0\ sica | 0\ naics | 0\ naicsa | 0\ -------------+--------------------------------------------------------\ v11 | 1328 2002 0 2002 2002\ yeara | 1328 2002 0 2002 2002\ v0000001nt~m | 1328 1149.439 3469.443 0 49584\ \ . *ABOUT VARIABLES:\ \ . */year = year group RENAME yeargrp; state = state name; statea = state code (what coding system is used here?; these are not fips codes.\ > ); county = county name; countya = county code (coding system?);sic = not applicable;DELETE (switch from SIC to NAICS occurred before the \ > year of the data contained here so this industry coding system is irrelevant for this data);sica = not applicable DELETE; naics = naics i\ > nustry name; naicsa = naics industry code (1st: remove "---" using ignore command;2nd: convert to a numeric variable using the real comma\ > nd); v11 = year DELETE; yeara = year code; v00...mid-march employees = number of employees RENAME employees /*\ \ . *year var\ \ . rename year yeargrp\ \ . *state var\ \ . label variable state `"STATE NAME"'\ \ . *statea var\ \ . label variable statea `"STATE CODE"'\ \ . *county var\ \ . label variable county `"COUNTY NAME"'\ \ . *countya var\ \ . label variable countya `"COUNTY CODE"'\ \ . *sic var\ \ . drop sic\ \ . *sica var\ \ . drop sica\ \ . *naics var\ \ . label variable naics `"NAICS INDUSTRY NAME"'\ \ . *naicsa var\ \ . label variable naicsa `"NAICS INDUSTRY CODE"'\ \ . ******************************************************************\ \ . *REMOVING "-" FROM NAICSA VAR AND CONVERTING TO NUMERIC VAR\ \ . destring naicsa, ignore("-") replace\ naicsa: characters - removed; replaced as byte\ \ . edit\ - preserve\ \ . ******************************************************************\ \ . *v11 var\ \ . drop v11\ \ . *yeara var\ \ . label variable yeara `"YEAR CODE"'\ \ . *v0000001nt001cbp_1998_2003_cntym var\ \ . rename v0000001nt001cbp_1998_2003_cntym employees\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . */Using reshape command to transform data.\ \ . reshape wide employees, i(statea countya) j(naicsa)\ (note: j = 11 21 22 23 31 42 44 48 51 52 53 54 55 56 61 62 71 72 81 95 99)\ naics not constant within statea countya\ Type "reshape error" for a listing of the problem observations.\ r(9);\ \ . reshape error\ (note: j = 11 21 22 23 31 42 44 48 51 52 53 54 55 56 61 62 71 72 81 95 99)\ \ i (statea countya) indicates the top-level grouping such as subject id.\ j (naicsa) indicates the subgrouping such as time.\ xij variable is employees.\ Thus, the following variable(s) should be constant within i:\ yeargrp gisjoin state county naics yeara\ \ naics not constant within i (statea countya) for 68 values of i:\ \ +---------------------------------------------------------------------------------------------+\ | statea countya naicsa naics |\ |---------------------------------------------------------------------------------------------|\ 1. | 10 10 11 11---- Forestry, fishing, hunting, and agriculture support |\ 2. | 10 10 21 21---- Mining |\ 3. | 10 10 22 22---- Utilities |\ 4. | 10 10 23 23---- Construction |\ 5. | 10 10 31 31---- Manufacturing |\ |---------------------------------------------------------------------------------------------|\ 6. | 10 10 42 42---- Wholesale trade |\ 7. | 10 10 44 44---- Retail trade |\ 8. | 10 10 48 48---- Transportation and warehousing |\ 9. | 10 10 51 51---- Information |\ 10. | 10 10 52 52---- Finance and insurance |\ |---------------------------------------------------------------------------------------------|\ 11. | 10 10 53 53---- Real estate and rental and leasing |\ 12. | 10 10 54 54---- Professional, scientific and technical services |\ 13. | 10 10 55 55---- Management of companies and enterprises |\ 14. | 10 10 56 56---- Admin, support, waste mgt, remediation services |\ 15. | 10 10 61 61---- Educational services |\ |---------------------------------------------------------------------------------------------|\ 16. | 10 10 62 62---- Health care and social assistance |\ 17. | 10 10 71 71---- Arts, entertainment and recreation |\ 18. | 10 10 72 72---- Accommodation and food services |\ 19. | 10 10 81 81---- Other services (except public administration) |\ 20. | 10 10 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ |---------------------------------------------------------------------------------------------|\ 21. | 10 10 99 99---- Unclassified establishments |\ 22. | 10 30 11 11---- Forestry, fishing, hunting, and agriculture support |\ 23. | 10 30 21 21---- Mining |\ 24. | 10 30 22 22---- Utilities |\ 25. | 10 30 23 23---- Construction |\ |---------------------------------------------------------------------------------------------|\ 26. | 10 30 31 31---- Manufacturing |\ 27. | 10 30 42 42---- Wholesale trade |\ 28. | 10 30 44 44---- Retail trade |\ 29. | 10 30 48 48---- Transportation and warehousing |\ 30. | 10 30 51 51---- Information |\ |---------------------------------------------------------------------------------------------|\ 31. | 10 30 52 52---- Finance and insurance |\ 32. | 10 30 53 53---- Real estate and rental and leasing |\ 33. | 10 30 54 54---- Professional, scientific and technical services |\ 34. | 10 30 55 55---- Management of companies and enterprises |\ 35. | 10 30 56 56---- Admin, support, waste mgt, remediation services |\ |---------------------------------------------------------------------------------------------|\ 36. | 10 30 61 61---- Educational services |\ 37. | 10 30 62 62---- Health care and social assistance |\ 38. | 10 30 71 71---- Arts, entertainment and recreation |\ 39. | 10 30 72 72---- Accommodation and food services |\ 40. | 10 30 81 81---- Other services (except public administration) |\ |---------------------------------------------------------------------------------------------|\ 41. | 10 30 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 42. | 10 30 99 99---- Unclassified establishments |\ 43. | 10 50 11 11---- Forestry, fishing, hunting, and agriculture support |\ 44. | 10 50 21 21---- Mining |\ 45. | 10 50 22 22---- Utilities |\ |---------------------------------------------------------------------------------------------|\ 46. | 10 50 23 23---- Construction |\ 47. | 10 50 31 31---- Manufacturing |\ 48. | 10 50 42 42---- Wholesale trade |\ 49. | 10 50 44 44---- Retail trade |\ 50. | 10 50 48 48---- Transportation and warehousing |\ |---------------------------------------------------------------------------------------------|\ 51. | 10 50 51 51---- Information |\ 52. | 10 50 52 52---- Finance and insurance |\ 53. | 10 50 53 53---- Real estate and rental and leasing |\ 54. | 10 50 54 54---- Professional, scientific and technical services |\ 55. | 10 50 55 55---- Management of companies and enterprises |\ |---------------------------------------------------------------------------------------------|\ 56. | 10 50 56 56---- Admin, support, waste mgt, remediation services |\ 57. | 10 50 61 61---- Educational services |\ 58. | 10 50 62 62---- Health care and social assistance |\ 59. | 10 50 71 71---- Arts, entertainment and recreation |\ 60. | 10 50 72 72---- Accommodation and food services |\ |---------------------------------------------------------------------------------------------|\ 61. | 10 50 81 81---- Other services (except public administration) |\ 62. | 10 50 99 99---- Unclassified establishments |\ 63. | 10 70 11 11---- Forestry, fishing, hunting, and agriculture support |\ 64. | 10 70 21 21---- Mining |\ 65. | 10 70 22 22---- Utilities |\ |---------------------------------------------------------------------------------------------|\ 66. | 10 70 23 23---- Construction |\ 67. | 10 70 31 31---- Manufacturing |\ 68. | 10 70 42 42---- Wholesale trade |\ 69. | 10 70 44 44---- Retail trade |\ 70. | 10 70 48 48---- Transportation and warehousing |\ |---------------------------------------------------------------------------------------------|\ 71. | 10 70 51 51---- Information |\ 72. | 10 70 52 52---- Finance and insurance |\ 73. | 10 70 53 53---- Real estate and rental and leasing |\ 74. | 10 70 54 54---- Professional, scientific and technical services |\ 75. | 10 70 55 55---- Management of companies and enterprises |\ |---------------------------------------------------------------------------------------------|\ 76. | 10 70 56 56---- Admin, support, waste mgt, remediation services |\ 77. | 10 70 61 61---- Educational services |\ 78. | 10 70 62 62---- Health care and social assistance |\ 79. | 10 70 71 71---- Arts, entertainment and recreation |\ 80. | 10 70 72 72---- Accommodation and food services |\ |---------------------------------------------------------------------------------------------|\ 81. | 10 70 81 81---- Other services (except public administration) |\ 82. | 10 70 99 99---- Unclassified establishments |\ 83. | 10 90 11 11---- Forestry, fishing, hunting, and agriculture support |\ 84. | 10 90 21 21---- Mining |\ 85. | 10 90 22 22---- Utilities |\ |---------------------------------------------------------------------------------------------|\ 86. | 10 90 23 23---- Construction |\ 87. | 10 90 31 31---- Manufacturing |\ 88. | 10 90 42 42---- Wholesale trade |\ 89. | 10 90 44 44---- Retail trade |\ 90. | 10 90 48 48---- Transportation and warehousing |\ |---------------------------------------------------------------------------------------------|\ 91. | 10 90 51 51---- Information |\ 92. | 10 90 52 52---- Finance and insurance |\ 93. | 10 90 53 53---- Real estate and rental and leasing |\ 94. | 10 90 54 54---- Professional, scientific and technical services |\ 95. | 10 90 55 55---- Management of companies and enterprises |\ |---------------------------------------------------------------------------------------------|\ 96. | 10 90 56 56---- Admin, support, waste mgt, remediation services |\ 97. | 10 90 61 61---- Educational services |\ 98. | 10 90 62 62---- Health care and social assistance |\ 99. | 10 90 71 71---- Arts, entertainment and recreation |\ 100. | 10 90 72 72---- Accommodation and food services |\ |---------------------------------------------------------------------------------------------|\ 101. | 10 90 81 81---- Other services (except public administration) |\ 102. | 10 90 99 99---- Unclassified establishments |\ 103. | 10 110 11 11---- Forestry, fishing, hunting, and agriculture support |\ 104. | 10 110 22 22---- Utilities |\ 105. | 10 110 23 23---- Construction |\ |---------------------------------------------------------------------------------------------|\ 106. | 10 110 31 31---- Manufacturing |\ 107. | 10 110 42 42---- Wholesale trade |\ 108. | 10 110 44 44---- Retail trade |\ 109. | 10 110 48 48---- Transportation and warehousing |\ 110. | 10 110 51 51---- Information |\ |---------------------------------------------------------------------------------------------|\ 111. | 10 110 52 52---- Finance and insurance |\ 112. | 10 110 53 53---- Real estate and rental and leasing |\ 113. | 10 110 54 54---- Professional, scientific and technical services |\ 114. | 10 110 56 56---- Admin, support, waste mgt, remediation services |\ 115. | 10 110 61 61---- Educational services |\ |---------------------------------------------------------------------------------------------|\ 116. | 10 110 62 62---- Health care and social assistance |\ 117. | 10 110 71 71---- Arts, entertainment and recreation |\ 118. | 10 110 72 72---- Accommodation and food services |\ 119. | 10 110 81 81---- Other services (except public administration) |\ 120. | 10 130 11 11---- Forestry, fishing, hunting, and agriculture support |\ |---------------------------------------------------------------------------------------------|\ 121. | 10 130 22 22---- Utilities |\ 122. | 10 130 23 23---- Construction |\ 123. | 10 130 31 31---- Manufacturing |\ 124. | 10 130 42 42---- Wholesale trade |\ 125. | 10 130 44 44---- Retail trade |\ |---------------------------------------------------------------------------------------------|\ 126. | 10 130 48 48---- Transportation and warehousing |\ 127. | 10 130 51 51---- Information |\ 128. | 10 130 52 52---- Finance and insurance |\ 129. | 10 130 53 53---- Real estate and rental and leasing |\ 130. | 10 130 54 54---- Professional, scientific and technical services |\ |---------------------------------------------------------------------------------------------|\ 131. | 10 130 55 55---- Management of companies and enterprises |\ 132. | 10 130 56 56---- Admin, support, waste mgt, remediation services |\ 133. | 10 130 61 61---- Educational services |\ 134. | 10 130 62 62---- Health care and social assistance |\ 135. | 10 130 71 71---- Arts, entertainment and recreation |\ |---------------------------------------------------------------------------------------------|\ 136. | 10 130 72 72---- Accommodation and food services |\ 137. | 10 130 81 81---- Other services (except public administration) |\ 138. | 10 130 99 99---- Unclassified establishments |\ 139. | 10 150 11 11---- Forestry, fishing, hunting, and agriculture support |\ 140. | 10 150 21 21---- Mining |\ |---------------------------------------------------------------------------------------------|\ 141. | 10 150 22 22---- Utilities |\ 142. | 10 150 23 23---- Construction |\ 143. | 10 150 31 31---- Manufacturing |\ 144. | 10 150 42 42---- Wholesale trade |\ 145. | 10 150 44 44---- Retail trade |\ |---------------------------------------------------------------------------------------------|\ 146. | 10 150 48 48---- Transportation and warehousing |\ 147. | 10 150 51 51---- Information |\ 148. | 10 150 52 52---- Finance and insurance |\ 149. | 10 150 53 53---- Real estate and rental and leasing |\ 150. | 10 150 54 54---- Professional, scientific and technical services |\ |---------------------------------------------------------------------------------------------|\ 151. | 10 150 55 55---- Management of companies and enterprises |\ 152. | 10 150 56 56---- Admin, support, waste mgt, remediation services |\ 153. | 10 150 61 61---- Educational services |\ 154. | 10 150 62 62---- Health care and social assistance |\ 155. | 10 150 71 71---- Arts, entertainment and recreation |\ |---------------------------------------------------------------------------------------------|\ 156. | 10 150 72 72---- Accommodation and food services |\ 157. | 10 150 81 81---- Other services (except public administration) |\ 158. | 10 150 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 159. | 10 150 99 99---- Unclassified establishments |\ 160. | 10 170 11 11---- Forestry, fishing, hunting, and agriculture support |\ |---------------------------------------------------------------------------------------------|\ 161. | 10 170 22 22---- Utilities |\ 162. | 10 170 23 23---- Construction |\ 163. | 10 170 31 31---- Manufacturing |\ 164. | 10 170 42 42---- Wholesale trade |\ 165. | 10 170 44 44---- Retail trade |\ |---------------------------------------------------------------------------------------------|\ 166. | 10 170 48 48---- Transportation and warehousing |\ 167. | 10 170 51 51---- Information |\ 168. | 10 170 52 52---- Finance and insurance |\ 169. | 10 170 53 53---- Real estate and rental and leasing |\ 170. | 10 170 54 54---- Professional, scientific and technical services |\ |---------------------------------------------------------------------------------------------|\ 171. | 10 170 55 55---- Management of companies and enterprises |\ 172. | 10 170 56 56---- Admin, support, waste mgt, remediation services |\ 173. | 10 170 61 61---- Educational services |\ 174. | 10 170 62 62---- Health care and social assistance |\ 175. | 10 170 71 71---- Arts, entertainment and recreation |\ |---------------------------------------------------------------------------------------------|\ 176. | 10 170 72 72---- Accommodation and food services |\ 177. | 10 170 81 81---- Other services (except public administration) |\ 178. | 10 170 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 179. | 10 170 99 99---- Unclassified establishments |\ 180. | 10 190 11 11---- Forestry, fishing, hunting, and agriculture support |\ |---------------------------------------------------------------------------------------------|\ 181. | 10 190 22 22---- Utilities |\ 182. | 10 190 23 23---- Construction |\ 183. | 10 190 31 31---- Manufacturing |\ 184. | 10 190 42 42---- Wholesale trade |\ 185. | 10 190 44 44---- Retail trade |\ |---------------------------------------------------------------------------------------------|\ 186. | 10 190 48 48---- Transportation and warehousing |\ 187. | 10 190 51 51---- Information |\ 188. | 10 190 52 52---- Finance and insurance |\ 189. | 10 190 53 53---- Real estate and rental and leasing |\ 190. | 10 190 54 54---- Professional, scientific and technical services |\ |---------------------------------------------------------------------------------------------|\ 191. | 10 190 56 56---- Admin, support, waste mgt, remediation services |\ 192. | 10 190 62 62---- Health care and social assistance |\ 193. | 10 190 71 71---- Arts, entertainment and recreation |\ 194. | 10 190 72 72---- Accommodation and food services |\ 195. | 10 190 81 81---- Other services (except public administration) |\ |---------------------------------------------------------------------------------------------|\ 196. | 10 190 99 99---- Unclassified establishments |\ 197. | 10 210 11 11---- Forestry, fishing, hunting, and agriculture support |\ 198. | 10 210 21 21---- Mining |\ 199. | 10 210 22 22---- Utilities |\ 200. | 10 210 23 23---- Construction |\ |---------------------------------------------------------------------------------------------|\ 201. | 10 210 31 31---- Manufacturing |\ 202. | 10 210 42 42---- Wholesale trade |\ 203. | 10 210 44 44---- Retail trade |\ 204. | 10 210 48 48---- Transportation and warehousing |\ 205. | 10 210 51 51---- Information |\ |---------------------------------------------------------------------------------------------|\ 206. | 10 210 52 52---- Finance and insurance |\ 207. | 10 210 53 53---- Real estate and rental and leasing |\ 208. | 10 210 54 54---- Professional, scientific and technical services |\ 209. | 10 210 55 55---- Management of companies and enterprises |\ 210. | 10 210 56 56---- Admin, support, waste mgt, remediation services |\ |---------------------------------------------------------------------------------------------|\ 211. | 10 210 61 61---- Educational services |\ 212. | 10 210 62 62---- Health care and social assistance |\ 213. | 10 210 71 71---- Arts, entertainment and recreation |\ 214. | 10 210 72 72---- Accommodation and food services |\ 215. | 10 210 81 81---- Other services (except public administration) |\ |---------------------------------------------------------------------------------------------|\ 216. | 10 210 99 99---- Unclassified establishments |\ 217. | 10 230 11 11---- Forestry, fishing, hunting, and agriculture support |\ 218. | 10 230 21 21---- Mining |\ 219. | 10 230 22 22---- Utilities |\ 220. | 10 230 23 23---- Construction |\ |---------------------------------------------------------------------------------------------|\ 221. | 10 230 31 31---- Manufacturing |\ 222. | 10 230 42 42---- Wholesale trade |\ 223. | 10 230 44 44---- Retail trade |\ 224. | 10 230 48 48---- Transportation and warehousing |\ 225. | 10 230 51 51---- Information |\ |---------------------------------------------------------------------------------------------|\ 226. | 10 230 52 52---- Finance and insurance |\ 227. | 10 230 53 53---- Real estate and rental and leasing |\ 228. | 10 230 54 54---- Professional, scientific and technical services |\ 229. | 10 230 55 55---- Management of companies and enterprises |\ 230. | 10 230 56 56---- Admin, support, waste mgt, remediation services |\ |---------------------------------------------------------------------------------------------|\ 231. | 10 230 61 61---- Educational services |\ 232. | 10 230 62 62---- Health care and social assistance |\ 233. | 10 230 71 71---- Arts, entertainment and recreation |\ 234. | 10 230 72 72---- Accommodation and food services |\ 235. | 10 230 81 81---- Other services (except public administration) |\ |---------------------------------------------------------------------------------------------|\ 236. | 10 230 99 99---- Unclassified establishments |\ 237. | 10 250 11 11---- Forestry, fishing, hunting, and agriculture support |\ 238. | 10 250 21 21---- Mining |\ 239. | 10 250 22 22---- Utilities |\ 240. | 10 250 23 23---- Construction |\ |---------------------------------------------------------------------------------------------|\ 241. | 10 250 31 31---- Manufacturing |\ 242. | 10 250 42 42---- Wholesale trade |\ 243. | 10 250 44 44---- Retail trade |\ 244. | 10 250 48 48---- Transportation and warehousing |\ 245. | 10 250 51 51---- Information |\ |---------------------------------------------------------------------------------------------|\ 246. | 10 250 52 52---- Finance and insurance |\ 247. | 10 250 53 53---- Real estate and rental and leasing |\ 248. | 10 250 54 54---- Professional, scientific and technical services |\ 249. | 10 250 55 55---- Management of companies and enterprises |\ 250. | 10 250 56 56---- Admin, support, waste mgt, remediation services |\ |---------------------------------------------------------------------------------------------|\ 251. | 10 250 61 61---- Educational services |\ 252. | 10 250 62 62---- Health care and social assistance |\ 253. | 10 250 71 71---- Arts, entertainment and recreation |\ 254. | 10 250 72 72---- Accommodation and food services |\ 255. | 10 250 81 81---- Other services (except public administration) |\ |---------------------------------------------------------------------------------------------|\ 256. | 10 250 99 99---- Unclassified establishments |\ 257. | 10 270 11 11---- Forestry, fishing, hunting, and agriculture support |\ 258. | 10 270 22 22---- Utilities |\ 259. | 10 270 23 23---- Construction |\ 260. | 10 270 31 31---- Manufacturing |\ |---------------------------------------------------------------------------------------------|\ 261. | 10 270 42 42---- Wholesale trade |\ 262. | 10 270 44 44---- Retail trade |\ 263. | 10 270 48 48---- Transportation and warehousing |\ 264. | 10 270 51 51---- Information |\ 265. | 10 270 52 52---- Finance and insurance |\ |---------------------------------------------------------------------------------------------|\ 266. | 10 270 53 53---- Real estate and rental and leasing |\ 267. | 10 270 54 54---- Professional, scientific and technical services |\ 268. | 10 270 56 56---- Admin, support, waste mgt, remediation services |\ 269. | 10 270 61 61---- Educational services |\ 270. | 10 270 62 62---- Health care and social assistance |\ |---------------------------------------------------------------------------------------------|\ 271. | 10 270 72 72---- Accommodation and food services |\ 272. | 10 270 81 81---- Other services (except public administration) |\ 273. | 10 290 11 11---- Forestry, fishing, hunting, and agriculture support |\ 274. | 10 290 22 22---- Utilities |\ 275. | 10 290 23 23---- Construction |\ |---------------------------------------------------------------------------------------------|\ 276. | 10 290 31 31---- Manufacturing |\ 277. | 10 290 42 42---- Wholesale trade |\ 278. | 10 290 44 44---- Retail trade |\ 279. | 10 290 48 48---- Transportation and warehousing |\ 280. | 10 290 51 51---- Information |\ |---------------------------------------------------------------------------------------------|\ 281. | 10 290 52 52---- Finance and insurance |\ 282. | 10 290 53 53---- Real estate and rental and leasing |\ 283. | 10 290 54 54---- Professional, scientific and technical services |\ 284. | 10 290 56 56---- Admin, support, waste mgt, remediation services |\ 285. | 10 290 62 62---- Health care and social assistance |\ |---------------------------------------------------------------------------------------------|\ 286. | 10 290 71 71---- Arts, entertainment and recreation |\ 287. | 10 290 72 72---- Accommodation and food services |\ 288. | 10 290 81 81---- Other services (except public administration) |\ 289. | 10 310 11 11---- Forestry, fishing, hunting, and agriculture support |\ 290. | 10 310 22 22---- Utilities |\ |---------------------------------------------------------------------------------------------|\ 291. | 10 310 23 23---- Construction |\ 292. | 10 310 31 31---- Manufacturing |\ 293. | 10 310 42 42---- Wholesale trade |\ 294. | 10 310 44 44---- Retail trade |\ 295. | 10 310 48 48---- Transportation and warehousing |\ |---------------------------------------------------------------------------------------------|\ 296. | 10 310 51 51---- Information |\ 297. | 10 310 52 52---- Finance and insurance |\ 298. | 10 310 53 53---- Real estate and rental and leasing |\ 299. | 10 310 54 54---- Professional, scientific and technical services |\ 300. | 10 310 56 56---- Admin, support, waste mgt, remediation services |\ |---------------------------------------------------------------------------------------------|\ 301. | 10 310 61 61---- Educational services |\ 302. | 10 310 62 62---- Health care and social assistance |\ 303. | 10 310 71 71---- Arts, entertainment and recreation |\ 304. | 10 310 72 72---- Accommodation and food services |\ 305. | 10 310 81 81---- Other services (except public administration) |\ |---------------------------------------------------------------------------------------------|\ 306. | 10 310 99 99---- Unclassified establishments |\ 307. | 10 330 11 11---- Forestry, fishing, hunting, and agriculture support |\ 308. | 10 330 21 21---- Mining |\ 309. | 10 330 22 22---- Utilities |\ 310. | 10 330 23 23---- Construction |\ |---------------------------------------------------------------------------------------------|\ 311. | 10 330 31 31---- Manufacturing |\ 312. | 10 330 42 42---- Wholesale trade |\ 313. | 10 330 44 44---- Retail trade |\ 314. | 10 330 48 48---- Transportation and warehousing |\ 315. | 10 330 51 51---- Information |\ |---------------------------------------------------------------------------------------------|\ 316. | 10 330 52 52---- Finance and insurance |\ 317. | 10 330 53 53---- Real estate and rental and leasing |\ 318. | 10 330 54 54---- Professional, scientific and technical services |\ 319. | 10 330 55 55---- Management of companies and enterprises |\ 320. | 10 330 56 56---- Admin, support, waste mgt, remediation services |\ |---------------------------------------------------------------------------------------------|\ 321. | 10 330 61 61---- Educational services |\ 322. | 10 330 62 62---- Health care and social assistance |\ 323. | 10 330 71 71---- Arts, entertainment and recreation |\ 324. | 10 330 72 72---- Accommodation and food services |\ 325. | 10 330 81 81---- Other services (except public administration) |\ |---------------------------------------------------------------------------------------------|\ 326. | 10 330 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 327. | 10 330 99 99---- Unclassified establishments |\ 328. | 10 350 11 11---- Forestry, fishing, hunting, and agriculture support |\ 329. | 10 350 22 22---- Utilities |\ 330. | 10 350 23 23---- Construction |\ |---------------------------------------------------------------------------------------------|\ 331. | 10 350 31 31---- Manufacturing |\ 332. | 10 350 42 42---- Wholesale trade |\ 333. | 10 350 44 44---- Retail trade |\ 334. | 10 350 48 48---- Transportation and warehousing |\ 335. | 10 350 51 51---- Information |\ |---------------------------------------------------------------------------------------------|\ 336. | 10 350 52 52---- Finance and insurance |\ 337. | 10 350 53 53---- Real estate and rental and leasing |\ 338. | 10 350 54 54---- Professional, scientific and technical services |\ 339. | 10 350 56 56---- Admin, support, waste mgt, remediation services |\ 340. | 10 350 61 61---- Educational services |\ |---------------------------------------------------------------------------------------------|\ 341. | 10 350 62 62---- Health care and social assistance |\ 342. | 10 350 71 71---- Arts, entertainment and recreation |\ 343. | 10 350 72 72---- Accommodation and food services |\ 344. | 10 350 81 81---- Other services (except public administration) |\ 345. | 10 350 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ |---------------------------------------------------------------------------------------------|\ 346. | 10 350 99 99---- Unclassified establishments |\ 347. | 10 370 11 11---- Forestry, fishing, hunting, and agriculture support |\ 348. | 10 370 22 22---- Utilities |\ 349. | 10 370 23 23---- Construction |\ 350. | 10 370 31 31---- Manufacturing |\ |---------------------------------------------------------------------------------------------|\ 351. | 10 370 42 42---- Wholesale trade |\ 352. | 10 370 44 44---- Retail trade |\ 353. | 10 370 48 48---- Transportation and warehousing |\ 354. | 10 370 51 51---- Information |\ 355. | 10 370 52 52---- Finance and insurance |\ |---------------------------------------------------------------------------------------------|\ 356. | 10 370 53 53---- Real estate and rental and leasing |\ 357. | 10 370 54 54---- Professional, scientific and technical services |\ 358. | 10 370 56 56---- Admin, support, waste mgt, remediation services |\ 359. | 10 370 62 62---- Health care and social assistance |\ 360. | 10 370 71 71---- Arts, entertainment and recreation |\ |---------------------------------------------------------------------------------------------|\ 361. | 10 370 72 72---- Accommodation and food services |\ 362. | 10 370 81 81---- Other services (except public administration) |\ 363. | 10 390 11 11---- Forestry, fishing, hunting, and agriculture support |\ 364. | 10 390 22 22---- Utilities |\ 365. | 10 390 23 23---- Construction |\ |---------------------------------------------------------------------------------------------|\ 366. | 10 390 31 31---- Manufacturing |\ 367. | 10 390 42 42---- Wholesale trade |\ 368. | 10 390 44 44---- Retail trade |\ 369. | 10 390 48 48---- Transportation and warehousing |\ 370. | 10 390 51 51---- Information |\ |---------------------------------------------------------------------------------------------|\ 371. | 10 390 52 52---- Finance and insurance |\ 372. | 10 390 53 53---- Real estate and rental and leasing |\ 373. | 10 390 54 54---- Professional, scientific and technical services |\ 374. | 10 390 55 55---- Management of companies and enterprises |\ 375. | 10 390 56 56---- Admin, support, waste mgt, remediation services |\ |---------------------------------------------------------------------------------------------|\ 376. | 10 390 61 61---- Educational services |\ 377. | 10 390 62 62---- Health care and social assistance |\ 378. | 10 390 71 71---- Arts, entertainment and recreation |\ 379. | 10 390 72 72---- Accommodation and food services |\ 380. | 10 390 81 81---- Other services (except public administration) |\ |---------------------------------------------------------------------------------------------|\ 381. | 10 390 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 382. | 10 390 99 99---- Unclassified establishments |\ 383. | 10 410 11 11---- Forestry, fishing, hunting, and agriculture support |\ 384. | 10 410 21 21---- Mining |\ 385. | 10 410 22 22---- Utilities |\ |---------------------------------------------------------------------------------------------|\ 386. | 10 410 23 23---- Construction |\ 387. | 10 410 31 31---- Manufacturing |\ 388. | 10 410 42 42---- Wholesale trade |\ 389. | 10 410 44 44---- Retail trade |\ 390. | 10 410 48 48---- Transportation and warehousing |\ |---------------------------------------------------------------------------------------------|\ 391. | 10 410 51 51---- Information |\ 392. | 10 410 52 52---- Finance and insurance |\ 393. | 10 410 53 53---- Real estate and rental and leasing |\ 394. | 10 410 54 54---- Professional, scientific and technical services |\ 395. | 10 410 55 55---- Management of companies and enterprises |\ |---------------------------------------------------------------------------------------------|\ 396. | 10 410 56 56---- Admin, support, waste mgt, remediation services |\ 397. | 10 410 61 61---- Educational services |\ 398. | 10 410 62 62---- Health care and social assistance |\ 399. | 10 410 71 71---- Arts, entertainment and recreation |\ 400. | 10 410 72 72---- Accommodation and food services |\ |---------------------------------------------------------------------------------------------|\ 401. | 10 410 81 81---- Other services (except public administration) |\ 402. | 10 410 99 99---- Unclassified establishments |\ 403. | 10 430 11 11---- Forestry, fishing, hunting, and agriculture support |\ 404. | 10 430 21 21---- Mining |\ 405. | 10 430 22 22---- Utilities |\ |---------------------------------------------------------------------------------------------|\ 406. | 10 430 23 23---- Construction |\ 407. | 10 430 31 31---- Manufacturing |\ 408. | 10 430 42 42---- Wholesale trade |\ 409. | 10 430 44 44---- Retail trade |\ 410. | 10 430 48 48---- Transportation and warehousing |\ |---------------------------------------------------------------------------------------------|\ 411. | 10 430 51 51---- Information |\ 412. | 10 430 52 52---- Finance and insurance |\ 413. | 10 430 53 53---- Real estate and rental and leasing |\ 414. | 10 430 54 54---- Professional, scientific and technical services |\ 415. | 10 430 55 55---- Management of companies and enterprises |\ |---------------------------------------------------------------------------------------------|\ 416. | 10 430 56 56---- Admin, support, waste mgt, remediation services |\ 417. | 10 430 61 61---- Educational services |\ 418. | 10 430 62 62---- Health care and social assistance |\ 419. | 10 430 71 71---- Arts, entertainment and recreation |\ 420. | 10 430 72 72---- Accommodation and food services |\ |---------------------------------------------------------------------------------------------|\ 421. | 10 430 81 81---- Other services (except public administration) |\ 422. | 10 430 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 423. | 10 430 99 99---- Unclassified establishments |\ 424. | 10 450 11 11---- Forestry, fishing, hunting, and agriculture support |\ 425. | 10 450 22 22---- Utilities |\ |---------------------------------------------------------------------------------------------|\ 426. | 10 450 23 23---- Construction |\ 427. | 10 450 31 31---- Manufacturing |\ 428. | 10 450 42 42---- Wholesale trade |\ 429. | 10 450 44 44---- Retail trade |\ 430. | 10 450 48 48---- Transportation and warehousing |\ |---------------------------------------------------------------------------------------------|\ 431. | 10 450 51 51---- Information |\ 432. | 10 450 52 52---- Finance and insurance |\ 433. | 10 450 53 53---- Real estate and rental and leasing |\ 434. | 10 450 54 54---- Professional, scientific and technical services |\ 435. | 10 450 55 55---- Management of companies and enterprises |\ |---------------------------------------------------------------------------------------------|\ 436. | 10 450 56 56---- Admin, support, waste mgt, remediation services |\ 437. | 10 450 61 61---- Educational services |\ 438. | 10 450 62 62---- Health care and social assistance |\ 439. | 10 450 71 71---- Arts, entertainment and recreation |\ 440. | 10 450 72 72---- Accommodation and food services |\ |---------------------------------------------------------------------------------------------|\ 441. | 10 450 81 81---- Other services (except public administration) |\ 442. | 10 450 99 99---- Unclassified establishments |\ 443. | 10 470 11 11---- Forestry, fishing, hunting, and agriculture support |\ 444. | 10 470 21 21---- Mining |\ 445. | 10 470 22 22---- Utilities |\ |---------------------------------------------------------------------------------------------|\ 446. | 10 470 23 23---- Construction |\ 447. | 10 470 31 31---- Manufacturing |\ 448. | 10 470 42 42---- Wholesale trade |\ 449. | 10 470 44 44---- Retail trade |\ 450. | 10 470 48 48---- Transportation and warehousing |\ |---------------------------------------------------------------------------------------------|\ 451. | 10 470 51 51---- Information |\ 452. | 10 470 52 52---- Finance and insurance |\ 453. | 10 470 53 53---- Real estate and rental and leasing |\ 454. | 10 470 54 54---- Professional, scientific and technical services |\ 455. | 10 470 55 55---- Management of companies and enterprises |\ |---------------------------------------------------------------------------------------------|\ 456. | 10 470 56 56---- Admin, support, waste mgt, remediation services |\ 457. | 10 470 61 61---- Educational services |\ 458. | 10 470 62 62---- Health care and social assistance |\ 459. | 10 470 71 71---- Arts, entertainment and recreation |\ 460. | 10 470 72 72---- Accommodation and food services |\ |---------------------------------------------------------------------------------------------|\ 461. | 10 470 81 81---- Other services (except public administration) |\ 462. | 10 470 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 463. | 10 470 99 99---- Unclassified establishments |\ 464. | 10 490 11 11---- Forestry, fishing, hunting, and agriculture support |\ 465. | 10 490 21 21---- Mining |\ |---------------------------------------------------------------------------------------------|\ 466. | 10 490 22 22---- Utilities |\ 467. | 10 490 23 23---- Construction |\ 468. | 10 490 31 31---- Manufacturing |\ 469. | 10 490 42 42---- Wholesale trade |\ 470. | 10 490 44 44---- Retail trade |\ |---------------------------------------------------------------------------------------------|\ 471. | 10 490 48 48---- Transportation and warehousing |\ 472. | 10 490 51 51---- Information |\ 473. | 10 490 52 52---- Finance and insurance |\ 474. | 10 490 53 53---- Real estate and rental and leasing |\ 475. | 10 490 54 54---- Professional, scientific and technical services |\ |---------------------------------------------------------------------------------------------|\ 476. | 10 490 55 55---- Management of companies and enterprises |\ 477. | 10 490 56 56---- Admin, support, waste mgt, remediation services |\ 478. | 10 490 61 61---- Educational services |\ 479. | 10 490 62 62---- Health care and social assistance |\ 480. | 10 490 71 71---- Arts, entertainment and recreation |\ |---------------------------------------------------------------------------------------------|\ 481. | 10 490 72 72---- Accommodation and food services |\ 482. | 10 490 81 81---- Other services (except public administration) |\ 483. | 10 490 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 484. | 10 490 99 99---- Unclassified establishments |\ 485. | 10 510 11 11---- Forestry, fishing, hunting, and agriculture support |\ |---------------------------------------------------------------------------------------------|\ 486. | 10 510 21 21---- Mining |\ 487. | 10 510 22 22---- Utilities |\ 488. | 10 510 23 23---- Construction |\ 489. | 10 510 31 31---- Manufacturing |\ 490. | 10 510 42 42---- Wholesale trade |\ |---------------------------------------------------------------------------------------------|\ 491. | 10 510 44 44---- Retail trade |\ 492. | 10 510 48 48---- Transportation and warehousing |\ 493. | 10 510 51 51---- Information |\ 494. | 10 510 52 52---- Finance and insurance |\ 495. | 10 510 53 53---- Real estate and rental and leasing |\ |---------------------------------------------------------------------------------------------|\ 496. | 10 510 54 54---- Professional, scientific and technical services |\ 497. | 10 510 55 55---- Management of companies and enterprises |\ 498. | 10 510 56 56---- Admin, support, waste mgt, remediation services |\ 499. | 10 510 61 61---- Educational services |\ 500. | 10 510 62 62---- Health care and social assistance |\ |---------------------------------------------------------------------------------------------|\ 501. | 10 510 71 71---- Arts, entertainment and recreation |\ 502. | 10 510 72 72---- Accommodation and food services |\ 503. | 10 510 81 81---- Other services (except public administration) |\ 504. | 10 510 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 505. | 10 510 99 99---- Unclassified establishments |\ |---------------------------------------------------------------------------------------------|\ 506. | 10 530 11 11---- Forestry, fishing, hunting, and agriculture support |\ 507. | 10 530 21 21---- Mining |\ 508. | 10 530 22 22---- Utilities |\ 509. | 10 530 23 23---- Construction |\ 510. | 10 530 31 31---- Manufacturing |\ |---------------------------------------------------------------------------------------------|\ 511. | 10 530 42 42---- Wholesale trade |\ 512. | 10 530 44 44---- Retail trade |\ 513. | 10 530 48 48---- Transportation and warehousing |\ 514. | 10 530 51 51---- Information |\ 515. | 10 530 52 52---- Finance and insurance |\ |---------------------------------------------------------------------------------------------|\ 516. | 10 530 53 53---- Real estate and rental and leasing |\ 517. | 10 530 54 54---- Professional, scientific and technical services |\ 518. | 10 530 55 55---- Management of companies and enterprises |\ 519. | 10 530 56 56---- Admin, support, waste mgt, remediation services |\ 520. | 10 530 61 61---- Educational services |\ |---------------------------------------------------------------------------------------------|\ 521. | 10 530 62 62---- Health care and social assistance |\ 522. | 10 530 71 71---- Arts, entertainment and recreation |\ 523. | 10 530 72 72---- Accommodation and food services |\ 524. | 10 530 81 81---- Other services (except public administration) |\ 525. | 10 530 99 99---- Unclassified establishments |\ |---------------------------------------------------------------------------------------------|\ 526. | 10 550 11 11---- Forestry, fishing, hunting, and agriculture support |\ 527. | 10 550 21 21---- Mining |\ 528. | 10 550 22 22---- Utilities |\ 529. | 10 550 23 23---- Construction |\ 530. | 10 550 31 31---- Manufacturing |\ |---------------------------------------------------------------------------------------------|\ 531. | 10 550 42 42---- Wholesale trade |\ 532. | 10 550 44 44---- Retail trade |\ 533. | 10 550 48 48---- Transportation and warehousing |\ 534. | 10 550 51 51---- Information |\ 535. | 10 550 52 52---- Finance and insurance |\ |---------------------------------------------------------------------------------------------|\ 536. | 10 550 53 53---- Real estate and rental and leasing |\ 537. | 10 550 54 54---- Professional, scientific and technical services |\ 538. | 10 550 55 55---- Management of companies and enterprises |\ 539. | 10 550 56 56---- Admin, support, waste mgt, remediation services |\ 540. | 10 550 61 61---- Educational services |\ |---------------------------------------------------------------------------------------------|\ 541. | 10 550 62 62---- Health care and social assistance |\ 542. | 10 550 71 71---- Arts, entertainment and recreation |\ 543. | 10 550 72 72---- Accommodation and food services |\ 544. | 10 550 81 81---- Other services (except public administration) |\ 545. | 10 550 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ |---------------------------------------------------------------------------------------------|\ 546. | 10 550 99 99---- Unclassified establishments |\ 547. | 10 570 11 11---- Forestry, fishing, hunting, and agriculture support |\ 548. | 10 570 21 21---- Mining |\ 549. | 10 570 22 22---- Utilities |\ 550. | 10 570 23 23---- Construction |\ |---------------------------------------------------------------------------------------------|\ 551. | 10 570 31 31---- Manufacturing |\ 552. | 10 570 42 42---- Wholesale trade |\ 553. | 10 570 44 44---- Retail trade |\ 554. | 10 570 48 48---- Transportation and warehousing |\ 555. | 10 570 51 51---- Information |\ |---------------------------------------------------------------------------------------------|\ 556. | 10 570 52 52---- Finance and insurance |\ 557. | 10 570 53 53---- Real estate and rental and leasing |\ 558. | 10 570 54 54---- Professional, scientific and technical services |\ 559. | 10 570 55 55---- Management of companies and enterprises |\ 560. | 10 570 56 56---- Admin, support, waste mgt, remediation services |\ |---------------------------------------------------------------------------------------------|\ 561. | 10 570 61 61---- Educational services |\ 562. | 10 570 62 62---- Health care and social assistance |\ 563. | 10 570 71 71---- Arts, entertainment and recreation |\ 564. | 10 570 72 72---- Accommodation and food services |\ 565. | 10 570 81 81---- Other services (except public administration) |\ |---------------------------------------------------------------------------------------------|\ 566. | 10 570 99 99---- Unclassified establishments |\ 567. | 10 590 11 11---- Forestry, fishing, hunting, and agriculture support |\ 568. | 10 590 21 21---- Mining |\ 569. | 10 590 22 22---- Utilities |\ 570. | 10 590 23 23---- Construction |\ |---------------------------------------------------------------------------------------------|\ 571. | 10 590 31 31---- Manufacturing |\ 572. | 10 590 42 42---- Wholesale trade |\ 573. | 10 590 44 44---- Retail trade |\ 574. | 10 590 48 48---- Transportation and warehousing |\ 575. | 10 590 51 51---- Information |\ |---------------------------------------------------------------------------------------------|\ 576. | 10 590 52 52---- Finance and insurance |\ 577. | 10 590 53 53---- Real estate and rental and leasing |\ 578. | 10 590 54 54---- Professional, scientific and technical services |\ 579. | 10 590 55 55---- Management of companies and enterprises |\ 580. | 10 590 56 56---- Admin, support, waste mgt, remediation services |\ |---------------------------------------------------------------------------------------------|\ 581. | 10 590 62 62---- Health care and social assistance |\ 582. | 10 590 71 71---- Arts, entertainment and recreation |\ 583. | 10 590 72 72---- Accommodation and food services |\ 584. | 10 590 81 81---- Other services (except public administration) |\ 585. | 10 590 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ |---------------------------------------------------------------------------------------------|\ 586. | 10 590 99 99---- Unclassified establishments |\ 587. | 10 610 11 11---- Forestry, fishing, hunting, and agriculture support |\ 588. | 10 610 21 21---- Mining |\ 589. | 10 610 22 22---- Utilities |\ 590. | 10 610 23 23---- Construction |\ |---------------------------------------------------------------------------------------------|\ 591. | 10 610 31 31---- Manufacturing |\ 592. | 10 610 42 42---- Wholesale trade |\ 593. | 10 610 44 44---- Retail trade |\ 594. | 10 610 48 48---- Transportation and warehousing |\ 595. | 10 610 51 51---- Information |\ |---------------------------------------------------------------------------------------------|\ 596. | 10 610 52 52---- Finance and insurance |\ 597. | 10 610 53 53---- Real estate and rental and leasing |\ 598. | 10 610 54 54---- Professional, scientific and technical services |\ 599. | 10 610 56 56---- Admin, support, waste mgt, remediation services |\ 600. | 10 610 61 61---- Educational services |\ |---------------------------------------------------------------------------------------------|\ 601. | 10 610 62 62---- Health care and social assistance |\ 602. | 10 610 71 71---- Arts, entertainment and recreation |\ 603. | 10 610 72 72---- Accommodation and food services |\ 604. | 10 610 81 81---- Other services (except public administration) |\ 605. | 10 610 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ |---------------------------------------------------------------------------------------------|\ 606. | 10 610 99 99---- Unclassified establishments |\ 607. | 10 630 11 11---- Forestry, fishing, hunting, and agriculture support |\ 608. | 10 630 22 22---- Utilities |\ 609. | 10 630 23 23---- Construction |\ 610. | 10 630 31 31---- Manufacturing |\ |---------------------------------------------------------------------------------------------|\ 611. | 10 630 42 42---- Wholesale trade |\ 612. | 10 630 44 44---- Retail trade |\ 613. | 10 630 48 48---- Transportation and warehousing |\ 614. | 10 630 51 51---- Information |\ 615. | 10 630 52 52---- Finance and insurance |\ |---------------------------------------------------------------------------------------------|\ 616. | 10 630 53 53---- Real estate and rental and leasing |\ 617. | 10 630 54 54---- Professional, scientific and technical services |\ 618. | 10 630 55 55---- Management of companies and enterprises |\ 619. | 10 630 56 56---- Admin, support, waste mgt, remediation services |\ 620. | 10 630 61 61---- Educational services |\ |---------------------------------------------------------------------------------------------|\ 621. | 10 630 62 62---- Health care and social assistance |\ 622. | 10 630 71 71---- Arts, entertainment and recreation |\ 623. | 10 630 72 72---- Accommodation and food services |\ 624. | 10 630 81 81---- Other services (except public administration) |\ 625. | 10 650 11 11---- Forestry, fishing, hunting, and agriculture support |\ |---------------------------------------------------------------------------------------------|\ 626. | 10 650 22 22---- Utilities |\ 627. | 10 650 23 23---- Construction |\ 628. | 10 650 31 31---- Manufacturing |\ 629. | 10 650 42 42---- Wholesale trade |\ 630. | 10 650 44 44---- Retail trade |\ |---------------------------------------------------------------------------------------------|\ 631. | 10 650 48 48---- Transportation and warehousing |\ 632. | 10 650 51 51---- Information |\ 633. | 10 650 52 52---- Finance and insurance |\ 634. | 10 650 53 53---- Real estate and rental and leasing |\ 635. | 10 650 54 54---- Professional, scientific and technical services |\ |---------------------------------------------------------------------------------------------|\ 636. | 10 650 55 55---- Management of companies and enterprises |\ 637. | 10 650 56 56---- Admin, support, waste mgt, remediation services |\ 638. | 10 650 61 61---- Educational services |\ 639. | 10 650 62 62---- Health care and social assistance |\ 640. | 10 650 71 71---- Arts, entertainment and recreation |\ |---------------------------------------------------------------------------------------------|\ 641. | 10 650 72 72---- Accommodation and food services |\ 642. | 10 650 81 81---- Other services (except public administration) |\ 643. | 10 650 99 99---- Unclassified establishments |\ 644. | 10 670 11 11---- Forestry, fishing, hunting, and agriculture support |\ 645. | 10 670 21 21---- Mining |\ |---------------------------------------------------------------------------------------------|\ 646. | 10 670 22 22---- Utilities |\ 647. | 10 670 23 23---- Construction |\ 648. | 10 670 31 31---- Manufacturing |\ 649. | 10 670 42 42---- Wholesale trade |\ 650. | 10 670 44 44---- Retail trade |\ |---------------------------------------------------------------------------------------------|\ 651. | 10 670 48 48---- Transportation and warehousing |\ 652. | 10 670 51 51---- Information |\ 653. | 10 670 52 52---- Finance and insurance |\ 654. | 10 670 53 53---- Real estate and rental and leasing |\ 655. | 10 670 54 54---- Professional, scientific and technical services |\ |---------------------------------------------------------------------------------------------|\ 656. | 10 670 55 55---- Management of companies and enterprises |\ 657. | 10 670 56 56---- Admin, support, waste mgt, remediation services |\ 658. | 10 670 61 61---- Educational services |\ 659. | 10 670 62 62---- Health care and social assistance |\ 660. | 10 670 71 71---- Arts, entertainment and recreation |\ |---------------------------------------------------------------------------------------------|\ 661. | 10 670 72 72---- Accommodation and food services |\ 662. | 10 670 81 81---- Other services (except public administration) |\ 663. | 10 670 99 99---- Unclassified establishments |\ 664. | 10 690 11 11---- Forestry, fishing, hunting, and agriculture support |\ 665. | 10 690 21 21---- Mining |\ |---------------------------------------------------------------------------------------------|\ 666. | 10 690 22 22---- Utilities |\ 667. | 10 690 23 23---- Construction |\ 668. | 10 690 31 31---- Manufacturing |\ 669. | 10 690 42 42---- Wholesale trade |\ 670. | 10 690 44 44---- Retail trade |\ |---------------------------------------------------------------------------------------------|\ 671. | 10 690 48 48---- Transportation and warehousing |\ 672. | 10 690 51 51---- Information |\ 673. | 10 690 52 52---- Finance and insurance |\ 674. | 10 690 53 53---- Real estate and rental and leasing |\ 675. | 10 690 54 54---- Professional, scientific and technical services |\ |---------------------------------------------------------------------------------------------|\ 676. | 10 690 55 55---- Management of companies and enterprises |\ 677. | 10 690 56 56---- Admin, support, waste mgt, remediation services |\ 678. | 10 690 61 61---- Educational services |\ 679. | 10 690 62 62---- Health care and social assistance |\ 680. | 10 690 71 71---- Arts, entertainment and recreation |\ |---------------------------------------------------------------------------------------------|\ 681. | 10 690 72 72---- Accommodation and food services |\ 682. | 10 690 81 81---- Other services (except public administration) |\ 683. | 10 690 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 684. | 10 690 99 99---- Unclassified establishments |\ 685. | 10 710 11 11---- Forestry, fishing, hunting, and agriculture support |\ |---------------------------------------------------------------------------------------------|\ 686. | 10 710 21 21---- Mining |\ 687. | 10 710 22 22---- Utilities |\ 688. | 10 710 23 23---- Construction |\ 689. | 10 710 31 31---- Manufacturing |\ 690. | 10 710 42 42---- Wholesale trade |\ |---------------------------------------------------------------------------------------------|\ 691. | 10 710 44 44---- Retail trade |\ 692. | 10 710 48 48---- Transportation and warehousing |\ 693. | 10 710 51 51---- Information |\ 694. | 10 710 52 52---- Finance and insurance |\ 695. | 10 710 53 53---- Real estate and rental and leasing |\ |---------------------------------------------------------------------------------------------|\ 696. | 10 710 54 54---- Professional, scientific and technical services |\ 697. | 10 710 55 55---- Management of companies and enterprises |\ 698. | 10 710 56 56---- Admin, support, waste mgt, remediation services |\ 699. | 10 710 61 61---- Educational services |\ 700. | 10 710 62 62---- Health care and social assistance |\ |---------------------------------------------------------------------------------------------|\ 701. | 10 710 71 71---- Arts, entertainment and recreation |\ 702. | 10 710 72 72---- Accommodation and food services |\ 703. | 10 710 81 81---- Other services (except public administration) |\ 704. | 10 710 99 99---- Unclassified establishments |\ 705. | 10 730 11 11---- Forestry, fishing, hunting, and agriculture support |\ |---------------------------------------------------------------------------------------------|\ 706. | 10 730 21 21---- Mining |\ 707. | 10 730 22 22---- Utilities |\ 708. | 10 730 23 23---- Construction |\ 709. | 10 730 31 31---- Manufacturing |\ 710. | 10 730 42 42---- Wholesale trade |\ |---------------------------------------------------------------------------------------------|\ 711. | 10 730 44 44---- Retail trade |\ 712. | 10 730 48 48---- Transportation and warehousing |\ 713. | 10 730 51 51---- Information |\ 714. | 10 730 52 52---- Finance and insurance |\ 715. | 10 730 53 53---- Real estate and rental and leasing |\ |---------------------------------------------------------------------------------------------|\ 716. | 10 730 54 54---- Professional, scientific and technical services |\ 717. | 10 730 55 55---- Management of companies and enterprises |\ 718. | 10 730 56 56---- Admin, support, waste mgt, remediation services |\ 719. | 10 730 61 61---- Educational services |\ 720. | 10 730 62 62---- Health care and social assistance |\ |---------------------------------------------------------------------------------------------|\ 721. | 10 730 71 71---- Arts, entertainment and recreation |\ 722. | 10 730 72 72---- Accommodation and food services |\ 723. | 10 730 81 81---- Other services (except public administration) |\ 724. | 10 730 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 725. | 10 730 99 99---- Unclassified establishments |\ |---------------------------------------------------------------------------------------------|\ 726. | 10 750 11 11---- Forestry, fishing, hunting, and agriculture support |\ 727. | 10 750 21 21---- Mining |\ 728. | 10 750 22 22---- Utilities |\ 729. | 10 750 23 23---- Construction |\ 730. | 10 750 31 31---- Manufacturing |\ |---------------------------------------------------------------------------------------------|\ 731. | 10 750 42 42---- Wholesale trade |\ 732. | 10 750 44 44---- Retail trade |\ 733. | 10 750 48 48---- Transportation and warehousing |\ 734. | 10 750 51 51---- Information |\ 735. | 10 750 52 52---- Finance and insurance |\ |---------------------------------------------------------------------------------------------|\ 736. | 10 750 53 53---- Real estate and rental and leasing |\ 737. | 10 750 54 54---- Professional, scientific and technical services |\ 738. | 10 750 56 56---- Admin, support, waste mgt, remediation services |\ 739. | 10 750 62 62---- Health care and social assistance |\ 740. | 10 750 71 71---- Arts, entertainment and recreation |\ |---------------------------------------------------------------------------------------------|\ 741. | 10 750 72 72---- Accommodation and food services |\ 742. | 10 750 81 81---- Other services (except public administration) |\ 743. | 10 750 99 99---- Unclassified establishments |\ 744. | 10 770 11 11---- Forestry, fishing, hunting, and agriculture support |\ 745. | 10 770 21 21---- Mining |\ |---------------------------------------------------------------------------------------------|\ 746. | 10 770 22 22---- Utilities |\ 747. | 10 770 23 23---- Construction |\ 748. | 10 770 31 31---- Manufacturing |\ 749. | 10 770 42 42---- Wholesale trade |\ 750. | 10 770 44 44---- Retail trade |\ |---------------------------------------------------------------------------------------------|\ 751. | 10 770 48 48---- Transportation and warehousing |\ 752. | 10 770 51 51---- Information |\ 753. | 10 770 52 52---- Finance and insurance |\ 754. | 10 770 53 53---- Real estate and rental and leasing |\ 755. | 10 770 54 54---- Professional, scientific and technical services |\ |---------------------------------------------------------------------------------------------|\ 756. | 10 770 55 55---- Management of companies and enterprises |\ 757. | 10 770 56 56---- Admin, support, waste mgt, remediation services |\ 758. | 10 770 61 61---- Educational services |\ 759. | 10 770 62 62---- Health care and social assistance |\ 760. | 10 770 71 71---- Arts, entertainment and recreation |\ |---------------------------------------------------------------------------------------------|\ 761. | 10 770 72 72---- Accommodation and food services |\ 762. | 10 770 81 81---- Other services (except public administration) |\ 763. | 10 770 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 764. | 10 770 99 99---- Unclassified establishments |\ 765. | 10 790 11 11---- Forestry, fishing, hunting, and agriculture support |\ |---------------------------------------------------------------------------------------------|\ 766. | 10 790 21 21---- Mining |\ 767. | 10 790 22 22---- Utilities |\ 768. | 10 790 23 23---- Construction |\ 769. | 10 790 31 31---- Manufacturing |\ 770. | 10 790 42 42---- Wholesale trade |\ |---------------------------------------------------------------------------------------------|\ 771. | 10 790 44 44---- Retail trade |\ 772. | 10 790 48 48---- Transportation and warehousing |\ 773. | 10 790 51 51---- Information |\ 774. | 10 790 52 52---- Finance and insurance |\ 775. | 10 790 53 53---- Real estate and rental and leasing |\ |---------------------------------------------------------------------------------------------|\ 776. | 10 790 54 54---- Professional, scientific and technical services |\ 777. | 10 790 56 56---- Admin, support, waste mgt, remediation services |\ 778. | 10 790 62 62---- Health care and social assistance |\ 779. | 10 790 71 71---- Arts, entertainment and recreation |\ 780. | 10 790 72 72---- Accommodation and food services |\ |---------------------------------------------------------------------------------------------|\ 781. | 10 790 81 81---- Other services (except public administration) |\ 782. | 10 790 99 99---- Unclassified establishments |\ 783. | 10 810 11 11---- Forestry, fishing, hunting, and agriculture support |\ 784. | 10 810 21 21---- Mining |\ 785. | 10 810 22 22---- Utilities |\ |---------------------------------------------------------------------------------------------|\ 786. | 10 810 23 23---- Construction |\ 787. | 10 810 31 31---- Manufacturing |\ 788. | 10 810 42 42---- Wholesale trade |\ 789. | 10 810 44 44---- Retail trade |\ 790. | 10 810 48 48---- Transportation and warehousing |\ |---------------------------------------------------------------------------------------------|\ 791. | 10 810 51 51---- Information |\ 792. | 10 810 52 52---- Finance and insurance |\ 793. | 10 810 53 53---- Real estate and rental and leasing |\ 794. | 10 810 54 54---- Professional, scientific and technical services |\ 795. | 10 810 55 55---- Management of companies and enterprises |\ |---------------------------------------------------------------------------------------------|\ 796. | 10 810 56 56---- Admin, support, waste mgt, remediation services |\ 797. | 10 810 61 61---- Educational services |\ 798. | 10 810 62 62---- Health care and social assistance |\ 799. | 10 810 71 71---- Arts, entertainment and recreation |\ 800. | 10 810 72 72---- Accommodation and food services |\ |---------------------------------------------------------------------------------------------|\ 801. | 10 810 81 81---- Other services (except public administration) |\ 802. | 10 810 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 803. | 10 810 99 99---- Unclassified establishments |\ 804. | 10 830 11 11---- Forestry, fishing, hunting, and agriculture support |\ 805. | 10 830 21 21---- Mining |\ |---------------------------------------------------------------------------------------------|\ 806. | 10 830 23 23---- Construction |\ 807. | 10 830 31 31---- Manufacturing |\ 808. | 10 830 42 42---- Wholesale trade |\ 809. | 10 830 44 44---- Retail trade |\ 810. | 10 830 48 48---- Transportation and warehousing |\ |---------------------------------------------------------------------------------------------|\ 811. | 10 830 51 51---- Information |\ 812. | 10 830 52 52---- Finance and insurance |\ 813. | 10 830 53 53---- Real estate and rental and leasing |\ 814. | 10 830 54 54---- Professional, scientific and technical services |\ 815. | 10 830 55 55---- Management of companies and enterprises |\ |---------------------------------------------------------------------------------------------|\ 816. | 10 830 56 56---- Admin, support, waste mgt, remediation services |\ 817. | 10 830 61 61---- Educational services |\ 818. | 10 830 62 62---- Health care and social assistance |\ 819. | 10 830 71 71---- Arts, entertainment and recreation |\ 820. | 10 830 72 72---- Accommodation and food services |\ |---------------------------------------------------------------------------------------------|\ 821. | 10 830 81 81---- Other services (except public administration) |\ 822. | 10 830 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 823. | 10 830 99 99---- Unclassified establishments |\ 824. | 10 850 11 11---- Forestry, fishing, hunting, and agriculture support |\ 825. | 10 850 21 21---- Mining |\ |---------------------------------------------------------------------------------------------|\ 826. | 10 850 22 22---- Utilities |\ 827. | 10 850 23 23---- Construction |\ 828. | 10 850 31 31---- Manufacturing |\ 829. | 10 850 42 42---- Wholesale trade |\ 830. | 10 850 44 44---- Retail trade |\ |---------------------------------------------------------------------------------------------|\ 831. | 10 850 48 48---- Transportation and warehousing |\ 832. | 10 850 51 51---- Information |\ 833. | 10 850 52 52---- Finance and insurance |\ 834. | 10 850 53 53---- Real estate and rental and leasing |\ 835. | 10 850 54 54---- Professional, scientific and technical services |\ |---------------------------------------------------------------------------------------------|\ 836. | 10 850 56 56---- Admin, support, waste mgt, remediation services |\ 837. | 10 850 61 61---- Educational services |\ 838. | 10 850 62 62---- Health care and social assistance |\ 839. | 10 850 71 71---- Arts, entertainment and recreation |\ 840. | 10 850 72 72---- Accommodation and food services |\ |---------------------------------------------------------------------------------------------|\ 841. | 10 850 81 81---- Other services (except public administration) |\ 842. | 10 850 99 99---- Unclassified establishments |\ 843. | 10 870 11 11---- Forestry, fishing, hunting, and agriculture support |\ 844. | 10 870 21 21---- Mining |\ 845. | 10 870 23 23---- Construction |\ |---------------------------------------------------------------------------------------------|\ 846. | 10 870 31 31---- Manufacturing |\ 847. | 10 870 42 42---- Wholesale trade |\ 848. | 10 870 44 44---- Retail trade |\ 849. | 10 870 48 48---- Transportation and warehousing |\ 850. | 10 870 51 51---- Information |\ |---------------------------------------------------------------------------------------------|\ 851. | 10 870 52 52---- Finance and insurance |\ 852. | 10 870 53 53---- Real estate and rental and leasing |\ 853. | 10 870 54 54---- Professional, scientific and technical services |\ 854. | 10 870 56 56---- Admin, support, waste mgt, remediation services |\ 855. | 10 870 61 61---- Educational services |\ |---------------------------------------------------------------------------------------------|\ 856. | 10 870 62 62---- Health care and social assistance |\ 857. | 10 870 71 71---- Arts, entertainment and recreation |\ 858. | 10 870 72 72---- Accommodation and food services |\ 859. | 10 870 81 81---- Other services (except public administration) |\ 860. | 10 870 99 99---- Unclassified establishments |\ |---------------------------------------------------------------------------------------------|\ 861. | 10 890 11 11---- Forestry, fishing, hunting, and agriculture support |\ 862. | 10 890 21 21---- Mining |\ 863. | 10 890 22 22---- Utilities |\ 864. | 10 890 23 23---- Construction |\ 865. | 10 890 31 31---- Manufacturing |\ |---------------------------------------------------------------------------------------------|\ 866. | 10 890 42 42---- Wholesale trade |\ 867. | 10 890 44 44---- Retail trade |\ 868. | 10 890 48 48---- Transportation and warehousing |\ 869. | 10 890 51 51---- Information |\ 870. | 10 890 52 52---- Finance and insurance |\ |---------------------------------------------------------------------------------------------|\ 871. | 10 890 53 53---- Real estate and rental and leasing |\ 872. | 10 890 54 54---- Professional, scientific and technical services |\ 873. | 10 890 55 55---- Management of companies and enterprises |\ 874. | 10 890 56 56---- Admin, support, waste mgt, remediation services |\ 875. | 10 890 61 61---- Educational services |\ |---------------------------------------------------------------------------------------------|\ 876. | 10 890 62 62---- Health care and social assistance |\ 877. | 10 890 71 71---- Arts, entertainment and recreation |\ 878. | 10 890 72 72---- Accommodation and food services |\ 879. | 10 890 81 81---- Other services (except public administration) |\ 880. | 10 890 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ |---------------------------------------------------------------------------------------------|\ 881. | 10 890 99 99---- Unclassified establishments |\ 882. | 10 910 11 11---- Forestry, fishing, hunting, and agriculture support |\ 883. | 10 910 22 22---- Utilities |\ 884. | 10 910 23 23---- Construction |\ 885. | 10 910 31 31---- Manufacturing |\ |---------------------------------------------------------------------------------------------|\ 886. | 10 910 42 42---- Wholesale trade |\ 887. | 10 910 44 44---- Retail trade |\ 888. | 10 910 48 48---- Transportation and warehousing |\ 889. | 10 910 51 51---- Information |\ 890. | 10 910 52 52---- Finance and insurance |\ |---------------------------------------------------------------------------------------------|\ 891. | 10 910 53 53---- Real estate and rental and leasing |\ 892. | 10 910 54 54---- Professional, scientific and technical services |\ 893. | 10 910 56 56---- Admin, support, waste mgt, remediation services |\ 894. | 10 910 61 61---- Educational services |\ 895. | 10 910 62 62---- Health care and social assistance |\ |---------------------------------------------------------------------------------------------|\ 896. | 10 910 71 71---- Arts, entertainment and recreation |\ 897. | 10 910 72 72---- Accommodation and food services |\ 898. | 10 910 81 81---- Other services (except public administration) |\ 899. | 10 910 99 99---- Unclassified establishments |\ 900. | 10 930 11 11---- Forestry, fishing, hunting, and agriculture support |\ |---------------------------------------------------------------------------------------------|\ 901. | 10 930 21 21---- Mining |\ 902. | 10 930 22 22---- Utilities |\ 903. | 10 930 23 23---- Construction |\ 904. | 10 930 31 31---- Manufacturing |\ 905. | 10 930 42 42---- Wholesale trade |\ |---------------------------------------------------------------------------------------------|\ 906. | 10 930 44 44---- Retail trade |\ 907. | 10 930 48 48---- Transportation and warehousing |\ 908. | 10 930 51 51---- Information |\ 909. | 10 930 52 52---- Finance and insurance |\ 910. | 10 930 53 53---- Real estate and rental and leasing |\ |---------------------------------------------------------------------------------------------|\ 911. | 10 930 54 54---- Professional, scientific and technical services |\ 912. | 10 930 55 55---- Management of companies and enterprises |\ 913. | 10 930 56 56---- Admin, support, waste mgt, remediation services |\ 914. | 10 930 62 62---- Health care and social assistance |\ 915. | 10 930 71 71---- Arts, entertainment and recreation |\ |---------------------------------------------------------------------------------------------|\ 916. | 10 930 72 72---- Accommodation and food services |\ 917. | 10 930 81 81---- Other services (except public administration) |\ 918. | 10 930 99 99---- Unclassified establishments |\ 919. | 10 950 11 11---- Forestry, fishing, hunting, and agriculture support |\ 920. | 10 950 21 21---- Mining |\ |---------------------------------------------------------------------------------------------|\ 921. | 10 950 22 22---- Utilities |\ 922. | 10 950 23 23---- Construction |\ 923. | 10 950 31 31---- Manufacturing |\ 924. | 10 950 42 42---- Wholesale trade |\ 925. | 10 950 44 44---- Retail trade |\ |---------------------------------------------------------------------------------------------|\ 926. | 10 950 48 48---- Transportation and warehousing |\ 927. | 10 950 51 51---- Information |\ 928. | 10 950 52 52---- Finance and insurance |\ 929. | 10 950 53 53---- Real estate and rental and leasing |\ 930. | 10 950 54 54---- Professional, scientific and technical services |\ |---------------------------------------------------------------------------------------------|\ 931. | 10 950 55 55---- Management of companies and enterprises |\ 932. | 10 950 56 56---- Admin, support, waste mgt, remediation services |\ 933. | 10 950 61 61---- Educational services |\ 934. | 10 950 62 62---- Health care and social assistance |\ 935. | 10 950 71 71---- Arts, entertainment and recreation |\ |---------------------------------------------------------------------------------------------|\ 936. | 10 950 72 72---- Accommodation and food services |\ 937. | 10 950 81 81---- Other services (except public administration) |\ 938. | 10 950 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 939. | 10 950 99 99---- Unclassified establishments |\ 940. | 10 970 11 11---- Forestry, fishing, hunting, and agriculture support |\ |---------------------------------------------------------------------------------------------|\ 941. | 10 970 21 21---- Mining |\ 942. | 10 970 22 22---- Utilities |\ 943. | 10 970 23 23---- Construction |\ 944. | 10 970 31 31---- Manufacturing |\ 945. | 10 970 42 42---- Wholesale trade |\ |---------------------------------------------------------------------------------------------|\ 946. | 10 970 44 44---- Retail trade |\ 947. | 10 970 48 48---- Transportation and warehousing |\ 948. | 10 970 51 51---- Information |\ 949. | 10 970 52 52---- Finance and insurance |\ 950. | 10 970 53 53---- Real estate and rental and leasing |\ |---------------------------------------------------------------------------------------------|\ 951. | 10 970 54 54---- Professional, scientific and technical services |\ 952. | 10 970 55 55---- Management of companies and enterprises |\ 953. | 10 970 56 56---- Admin, support, waste mgt, remediation services |\ 954. | 10 970 61 61---- Educational services |\ 955. | 10 970 62 62---- Health care and social assistance |\ |---------------------------------------------------------------------------------------------|\ 956. | 10 970 71 71---- Arts, entertainment and recreation |\ 957. | 10 970 72 72---- Accommodation and food services |\ 958. | 10 970 81 81---- Other services (except public administration) |\ 959. | 10 970 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 960. | 10 970 99 99---- Unclassified establishments |\ |---------------------------------------------------------------------------------------------|\ 961. | 10 990 11 11---- Forestry, fishing, hunting, and agriculture support |\ 962. | 10 990 21 21---- Mining |\ 963. | 10 990 22 22---- Utilities |\ 964. | 10 990 23 23---- Construction |\ 965. | 10 990 31 31---- Manufacturing |\ |---------------------------------------------------------------------------------------------|\ 966. | 10 990 42 42---- Wholesale trade |\ 967. | 10 990 44 44---- Retail trade |\ 968. | 10 990 48 48---- Transportation and warehousing |\ 969. | 10 990 51 51---- Information |\ 970. | 10 990 52 52---- Finance and insurance |\ |---------------------------------------------------------------------------------------------|\ 971. | 10 990 53 53---- Real estate and rental and leasing |\ 972. | 10 990 54 54---- Professional, scientific and technical services |\ 973. | 10 990 55 55---- Management of companies and enterprises |\ 974. | 10 990 56 56---- Admin, support, waste mgt, remediation services |\ 975. | 10 990 61 61---- Educational services |\ |---------------------------------------------------------------------------------------------|\ 976. | 10 990 62 62---- Health care and social assistance |\ 977. | 10 990 71 71---- Arts, entertainment and recreation |\ 978. | 10 990 72 72---- Accommodation and food services |\ 979. | 10 990 81 81---- Other services (except public administration) |\ 980. | 10 990 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ |---------------------------------------------------------------------------------------------|\ 981. | 10 990 99 99---- Unclassified establishments |\ 982. | 10 1010 11 11---- Forestry, fishing, hunting, and agriculture support |\ 983. | 10 1010 21 21---- Mining |\ 984. | 10 1010 22 22---- Utilities |\ 985. | 10 1010 23 23---- Construction |\ |---------------------------------------------------------------------------------------------|\ 986. | 10 1010 31 31---- Manufacturing |\ 987. | 10 1010 42 42---- Wholesale trade |\ 988. | 10 1010 44 44---- Retail trade |\ 989. | 10 1010 48 48---- Transportation and warehousing |\ 990. | 10 1010 51 51---- Information |\ |---------------------------------------------------------------------------------------------|\ 991. | 10 1010 52 52---- Finance and insurance |\ 992. | 10 1010 53 53---- Real estate and rental and leasing |\ 993. | 10 1010 54 54---- Professional, scientific and technical services |\ 994. | 10 1010 55 55---- Management of companies and enterprises |\ 995. | 10 1010 56 56---- Admin, support, waste mgt, remediation services |\ |---------------------------------------------------------------------------------------------|\ 996. | 10 1010 61 61---- Educational services |\ 997. | 10 1010 62 62---- Health care and social assistance |\ 998. | 10 1010 71 71---- Arts, entertainment and recreation |\ 999. | 10 1010 72 72---- Accommodation and food services |\ 1000. | 10 1010 81 81---- Other services (except public administration) |\ |---------------------------------------------------------------------------------------------|\ 1001. | 10 1010 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 1002. | 10 1010 99 99---- Unclassified establishments |\ 1003. | 10 1030 11 11---- Forestry, fishing, hunting, and agriculture support |\ 1004. | 10 1030 21 21---- Mining |\ 1005. | 10 1030 22 22---- Utilities |\ |---------------------------------------------------------------------------------------------|\ 1006. | 10 1030 23 23---- Construction |\ 1007. | 10 1030 31 31---- Manufacturing |\ 1008. | 10 1030 42 42---- Wholesale trade |\ 1009. | 10 1030 44 44---- Retail trade |\ 1010. | 10 1030 48 48---- Transportation and warehousing |\ |---------------------------------------------------------------------------------------------|\ 1011. | 10 1030 51 51---- Information |\ 1012. | 10 1030 52 52---- Finance and insurance |\ 1013. | 10 1030 53 53---- Real estate and rental and leasing |\ 1014. | 10 1030 54 54---- Professional, scientific and technical services |\ 1015. | 10 1030 55 55---- Management of companies and enterprises |\ |---------------------------------------------------------------------------------------------|\ 1016. | 10 1030 56 56---- Admin, support, waste mgt, remediation services |\ 1017. | 10 1030 61 61---- Educational services |\ 1018. | 10 1030 62 62---- Health care and social assistance |\ 1019. | 10 1030 71 71---- Arts, entertainment and recreation |\ 1020. | 10 1030 72 72---- Accommodation and food services |\ |---------------------------------------------------------------------------------------------|\ 1021. | 10 1030 81 81---- Other services (except public administration) |\ 1022. | 10 1030 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 1023. | 10 1030 99 99---- Unclassified establishments |\ 1024. | 10 1050 11 11---- Forestry, fishing, hunting, and agriculture support |\ 1025. | 10 1050 22 22---- Utilities |\ |---------------------------------------------------------------------------------------------|\ 1026. | 10 1050 23 23---- Construction |\ 1027. | 10 1050 31 31---- Manufacturing |\ 1028. | 10 1050 42 42---- Wholesale trade |\ 1029. | 10 1050 44 44---- Retail trade |\ 1030. | 10 1050 48 48---- Transportation and warehousing |\ |---------------------------------------------------------------------------------------------|\ 1031. | 10 1050 51 51---- Information |\ 1032. | 10 1050 52 52---- Finance and insurance |\ 1033. | 10 1050 53 53---- Real estate and rental and leasing |\ 1034. | 10 1050 54 54---- Professional, scientific and technical services |\ 1035. | 10 1050 56 56---- Admin, support, waste mgt, remediation services |\ |---------------------------------------------------------------------------------------------|\ 1036. | 10 1050 61 61---- Educational services |\ 1037. | 10 1050 62 62---- Health care and social assistance |\ 1038. | 10 1050 72 72---- Accommodation and food services |\ 1039. | 10 1050 81 81---- Other services (except public administration) |\ 1040. | 10 1050 99 99---- Unclassified establishments |\ |---------------------------------------------------------------------------------------------|\ 1041. | 10 1070 11 11---- Forestry, fishing, hunting, and agriculture support |\ 1042. | 10 1070 21 21---- Mining |\ 1043. | 10 1070 22 22---- Utilities |\ 1044. | 10 1070 23 23---- Construction |\ 1045. | 10 1070 31 31---- Manufacturing |\ |---------------------------------------------------------------------------------------------|\ 1046. | 10 1070 42 42---- Wholesale trade |\ 1047. | 10 1070 44 44---- Retail trade |\ 1048. | 10 1070 48 48---- Transportation and warehousing |\ 1049. | 10 1070 51 51---- Information |\ 1050. | 10 1070 52 52---- Finance and insurance |\ |---------------------------------------------------------------------------------------------|\ 1051. | 10 1070 53 53---- Real estate and rental and leasing |\ 1052. | 10 1070 54 54---- Professional, scientific and technical services |\ 1053. | 10 1070 56 56---- Admin, support, waste mgt, remediation services |\ 1054. | 10 1070 61 61---- Educational services |\ 1055. | 10 1070 62 62---- Health care and social assistance |\ |---------------------------------------------------------------------------------------------|\ 1056. | 10 1070 71 71---- Arts, entertainment and recreation |\ 1057. | 10 1070 72 72---- Accommodation and food services |\ 1058. | 10 1070 81 81---- Other services (except public administration) |\ 1059. | 10 1070 99 99---- Unclassified establishments |\ 1060. | 10 1090 11 11---- Forestry, fishing, hunting, and agriculture support |\ |---------------------------------------------------------------------------------------------|\ 1061. | 10 1090 22 22---- Utilities |\ 1062. | 10 1090 23 23---- Construction |\ 1063. | 10 1090 31 31---- Manufacturing |\ 1064. | 10 1090 42 42---- Wholesale trade |\ 1065. | 10 1090 44 44---- Retail trade |\ |---------------------------------------------------------------------------------------------|\ 1066. | 10 1090 48 48---- Transportation and warehousing |\ 1067. | 10 1090 51 51---- Information |\ 1068. | 10 1090 52 52---- Finance and insurance |\ 1069. | 10 1090 53 53---- Real estate and rental and leasing |\ 1070. | 10 1090 54 54---- Professional, scientific and technical services |\ |---------------------------------------------------------------------------------------------|\ 1071. | 10 1090 55 55---- Management of companies and enterprises |\ 1072. | 10 1090 56 56---- Admin, support, waste mgt, remediation services |\ 1073. | 10 1090 61 61---- Educational services |\ 1074. | 10 1090 62 62---- Health care and social assistance |\ 1075. | 10 1090 71 71---- Arts, entertainment and recreation |\ |---------------------------------------------------------------------------------------------|\ 1076. | 10 1090 72 72---- Accommodation and food services |\ 1077. | 10 1090 81 81---- Other services (except public administration) |\ 1078. | 10 1090 99 99---- Unclassified establishments |\ 1079. | 10 1110 11 11---- Forestry, fishing, hunting, and agriculture support |\ 1080. | 10 1110 21 21---- Mining |\ |---------------------------------------------------------------------------------------------|\ 1081. | 10 1110 22 22---- Utilities |\ 1082. | 10 1110 23 23---- Construction |\ 1083. | 10 1110 31 31---- Manufacturing |\ 1084. | 10 1110 42 42---- Wholesale trade |\ 1085. | 10 1110 44 44---- Retail trade |\ |---------------------------------------------------------------------------------------------|\ 1086. | 10 1110 48 48---- Transportation and warehousing |\ 1087. | 10 1110 51 51---- Information |\ 1088. | 10 1110 52 52---- Finance and insurance |\ 1089. | 10 1110 53 53---- Real estate and rental and leasing |\ 1090. | 10 1110 54 54---- Professional, scientific and technical services |\ |---------------------------------------------------------------------------------------------|\ 1091. | 10 1110 55 55---- Management of companies and enterprises |\ 1092. | 10 1110 56 56---- Admin, support, waste mgt, remediation services |\ 1093. | 10 1110 61 61---- Educational services |\ 1094. | 10 1110 62 62---- Health care and social assistance |\ 1095. | 10 1110 71 71---- Arts, entertainment and recreation |\ |---------------------------------------------------------------------------------------------|\ 1096. | 10 1110 72 72---- Accommodation and food services |\ 1097. | 10 1110 81 81---- Other services (except public administration) |\ 1098. | 10 1110 99 99---- Unclassified establishments |\ 1099. | 10 1130 11 11---- Forestry, fishing, hunting, and agriculture support |\ 1100. | 10 1130 21 21---- Mining |\ |---------------------------------------------------------------------------------------------|\ 1101. | 10 1130 22 22---- Utilities |\ 1102. | 10 1130 23 23---- Construction |\ 1103. | 10 1130 31 31---- Manufacturing |\ 1104. | 10 1130 42 42---- Wholesale trade |\ 1105. | 10 1130 44 44---- Retail trade |\ |---------------------------------------------------------------------------------------------|\ 1106. | 10 1130 48 48---- Transportation and warehousing |\ 1107. | 10 1130 51 51---- Information |\ 1108. | 10 1130 52 52---- Finance and insurance |\ 1109. | 10 1130 53 53---- Real estate and rental and leasing |\ 1110. | 10 1130 54 54---- Professional, scientific and technical services |\ |---------------------------------------------------------------------------------------------|\ 1111. | 10 1130 55 55---- Management of companies and enterprises |\ 1112. | 10 1130 56 56---- Admin, support, waste mgt, remediation services |\ 1113. | 10 1130 61 61---- Educational services |\ 1114. | 10 1130 62 62---- Health care and social assistance |\ 1115. | 10 1130 71 71---- Arts, entertainment and recreation |\ |---------------------------------------------------------------------------------------------|\ 1116. | 10 1130 72 72---- Accommodation and food services |\ 1117. | 10 1130 81 81---- Other services (except public administration) |\ 1118. | 10 1130 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 1119. | 10 1130 99 99---- Unclassified establishments |\ 1120. | 10 1150 11 11---- Forestry, fishing, hunting, and agriculture support |\ |---------------------------------------------------------------------------------------------|\ 1121. | 10 1150 21 21---- Mining |\ 1122. | 10 1150 22 22---- Utilities |\ 1123. | 10 1150 23 23---- Construction |\ 1124. | 10 1150 31 31---- Manufacturing |\ 1125. | 10 1150 42 42---- Wholesale trade |\ |---------------------------------------------------------------------------------------------|\ 1126. | 10 1150 44 44---- Retail trade |\ 1127. | 10 1150 48 48---- Transportation and warehousing |\ 1128. | 10 1150 51 51---- Information |\ 1129. | 10 1150 52 52---- Finance and insurance |\ 1130. | 10 1150 53 53---- Real estate and rental and leasing |\ |---------------------------------------------------------------------------------------------|\ 1131. | 10 1150 54 54---- Professional, scientific and technical services |\ 1132. | 10 1150 55 55---- Management of companies and enterprises |\ 1133. | 10 1150 56 56---- Admin, support, waste mgt, remediation services |\ 1134. | 10 1150 61 61---- Educational services |\ 1135. | 10 1150 62 62---- Health care and social assistance |\ |---------------------------------------------------------------------------------------------|\ 1136. | 10 1150 71 71---- Arts, entertainment and recreation |\ 1137. | 10 1150 72 72---- Accommodation and food services |\ 1138. | 10 1150 81 81---- Other services (except public administration) |\ 1139. | 10 1150 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 1140. | 10 1150 99 99---- Unclassified establishments |\ |---------------------------------------------------------------------------------------------|\ 1141. | 10 1170 11 11---- Forestry, fishing, hunting, and agriculture support |\ 1142. | 10 1170 21 21---- Mining |\ 1143. | 10 1170 22 22---- Utilities |\ 1144. | 10 1170 23 23---- Construction |\ 1145. | 10 1170 31 31---- Manufacturing |\ |---------------------------------------------------------------------------------------------|\ 1146. | 10 1170 42 42---- Wholesale trade |\ 1147. | 10 1170 44 44---- Retail trade |\ 1148. | 10 1170 48 48---- Transportation and warehousing |\ 1149. | 10 1170 51 51---- Information |\ 1150. | 10 1170 52 52---- Finance and insurance |\ |---------------------------------------------------------------------------------------------|\ 1151. | 10 1170 53 53---- Real estate and rental and leasing |\ 1152. | 10 1170 54 54---- Professional, scientific and technical services |\ 1153. | 10 1170 55 55---- Management of companies and enterprises |\ 1154. | 10 1170 56 56---- Admin, support, waste mgt, remediation services |\ 1155. | 10 1170 61 61---- Educational services |\ |---------------------------------------------------------------------------------------------|\ 1156. | 10 1170 62 62---- Health care and social assistance |\ 1157. | 10 1170 71 71---- Arts, entertainment and recreation |\ 1158. | 10 1170 72 72---- Accommodation and food services |\ 1159. | 10 1170 81 81---- Other services (except public administration) |\ 1160. | 10 1170 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ |---------------------------------------------------------------------------------------------|\ 1161. | 10 1170 99 99---- Unclassified establishments |\ 1162. | 10 1190 11 11---- Forestry, fishing, hunting, and agriculture support |\ 1163. | 10 1190 21 21---- Mining |\ 1164. | 10 1190 22 22---- Utilities |\ 1165. | 10 1190 23 23---- Construction |\ |---------------------------------------------------------------------------------------------|\ 1166. | 10 1190 31 31---- Manufacturing |\ 1167. | 10 1190 42 42---- Wholesale trade |\ 1168. | 10 1190 44 44---- Retail trade |\ 1169. | 10 1190 48 48---- Transportation and warehousing |\ 1170. | 10 1190 51 51---- Information |\ |---------------------------------------------------------------------------------------------|\ 1171. | 10 1190 52 52---- Finance and insurance |\ 1172. | 10 1190 53 53---- Real estate and rental and leasing |\ 1173. | 10 1190 54 54---- Professional, scientific and technical services |\ 1174. | 10 1190 56 56---- Admin, support, waste mgt, remediation services |\ 1175. | 10 1190 61 61---- Educational services |\ |---------------------------------------------------------------------------------------------|\ 1176. | 10 1190 62 62---- Health care and social assistance |\ 1177. | 10 1190 71 71---- Arts, entertainment and recreation |\ 1178. | 10 1190 72 72---- Accommodation and food services |\ 1179. | 10 1190 81 81---- Other services (except public administration) |\ 1180. | 10 1190 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ |---------------------------------------------------------------------------------------------|\ 1181. | 10 1190 99 99---- Unclassified establishments |\ 1182. | 10 1210 11 11---- Forestry, fishing, hunting, and agriculture support |\ 1183. | 10 1210 21 21---- Mining |\ 1184. | 10 1210 22 22---- Utilities |\ 1185. | 10 1210 23 23---- Construction |\ |---------------------------------------------------------------------------------------------|\ 1186. | 10 1210 31 31---- Manufacturing |\ 1187. | 10 1210 42 42---- Wholesale trade |\ 1188. | 10 1210 44 44---- Retail trade |\ 1189. | 10 1210 48 48---- Transportation and warehousing |\ 1190. | 10 1210 51 51---- Information |\ |---------------------------------------------------------------------------------------------|\ 1191. | 10 1210 52 52---- Finance and insurance |\ 1192. | 10 1210 53 53---- Real estate and rental and leasing |\ 1193. | 10 1210 54 54---- Professional, scientific and technical services |\ 1194. | 10 1210 55 55---- Management of companies and enterprises |\ 1195. | 10 1210 56 56---- Admin, support, waste mgt, remediation services |\ |---------------------------------------------------------------------------------------------|\ 1196. | 10 1210 61 61---- Educational services |\ 1197. | 10 1210 62 62---- Health care and social assistance |\ 1198. | 10 1210 71 71---- Arts, entertainment and recreation |\ 1199. | 10 1210 72 72---- Accommodation and food services |\ 1200. | 10 1210 81 81---- Other services (except public administration) |\ |---------------------------------------------------------------------------------------------|\ 1201. | 10 1210 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 1202. | 10 1210 99 99---- Unclassified establishments |\ 1203. | 10 1230 11 11---- Forestry, fishing, hunting, and agriculture support |\ 1204. | 10 1230 21 21---- Mining |\ 1205. | 10 1230 22 22---- Utilities |\ |---------------------------------------------------------------------------------------------|\ 1206. | 10 1230 23 23---- Construction |\ 1207. | 10 1230 31 31---- Manufacturing |\ 1208. | 10 1230 42 42---- Wholesale trade |\ 1209. | 10 1230 44 44---- Retail trade |\ 1210. | 10 1230 48 48---- Transportation and warehousing |\ |---------------------------------------------------------------------------------------------|\ 1211. | 10 1230 51 51---- Information |\ 1212. | 10 1230 52 52---- Finance and insurance |\ 1213. | 10 1230 53 53---- Real estate and rental and leasing |\ 1214. | 10 1230 54 54---- Professional, scientific and technical services |\ 1215. | 10 1230 55 55---- Management of companies and enterprises |\ |---------------------------------------------------------------------------------------------|\ 1216. | 10 1230 56 56---- Admin, support, waste mgt, remediation services |\ 1217. | 10 1230 61 61---- Educational services |\ 1218. | 10 1230 62 62---- Health care and social assistance |\ 1219. | 10 1230 71 71---- Arts, entertainment and recreation |\ 1220. | 10 1230 72 72---- Accommodation and food services |\ |---------------------------------------------------------------------------------------------|\ 1221. | 10 1230 81 81---- Other services (except public administration) |\ 1222. | 10 1230 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 1223. | 10 1230 99 99---- Unclassified establishments |\ 1224. | 10 1250 11 11---- Forestry, fishing, hunting, and agriculture support |\ 1225. | 10 1250 21 21---- Mining |\ |---------------------------------------------------------------------------------------------|\ 1226. | 10 1250 22 22---- Utilities |\ 1227. | 10 1250 23 23---- Construction |\ 1228. | 10 1250 31 31---- Manufacturing |\ 1229. | 10 1250 42 42---- Wholesale trade |\ 1230. | 10 1250 44 44---- Retail trade |\ |---------------------------------------------------------------------------------------------|\ 1231. | 10 1250 48 48---- Transportation and warehousing |\ 1232. | 10 1250 51 51---- Information |\ 1233. | 10 1250 52 52---- Finance and insurance |\ 1234. | 10 1250 53 53---- Real estate and rental and leasing |\ 1235. | 10 1250 54 54---- Professional, scientific and technical services |\ |---------------------------------------------------------------------------------------------|\ 1236. | 10 1250 55 55---- Management of companies and enterprises |\ 1237. | 10 1250 56 56---- Admin, support, waste mgt, remediation services |\ 1238. | 10 1250 61 61---- Educational services |\ 1239. | 10 1250 62 62---- Health care and social assistance |\ 1240. | 10 1250 71 71---- Arts, entertainment and recreation |\ |---------------------------------------------------------------------------------------------|\ 1241. | 10 1250 72 72---- Accommodation and food services |\ 1242. | 10 1250 81 81---- Other services (except public administration) |\ 1243. | 10 1250 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 1244. | 10 1250 99 99---- Unclassified establishments |\ 1245. | 10 1270 11 11---- Forestry, fishing, hunting, and agriculture support |\ |---------------------------------------------------------------------------------------------|\ 1246. | 10 1270 21 21---- Mining |\ 1247. | 10 1270 22 22---- Utilities |\ 1248. | 10 1270 23 23---- Construction |\ 1249. | 10 1270 31 31---- Manufacturing |\ 1250. | 10 1270 42 42---- Wholesale trade |\ |---------------------------------------------------------------------------------------------|\ 1251. | 10 1270 44 44---- Retail trade |\ 1252. | 10 1270 48 48---- Transportation and warehousing |\ 1253. | 10 1270 51 51---- Information |\ 1254. | 10 1270 52 52---- Finance and insurance |\ 1255. | 10 1270 53 53---- Real estate and rental and leasing |\ |---------------------------------------------------------------------------------------------|\ 1256. | 10 1270 54 54---- Professional, scientific and technical services |\ 1257. | 10 1270 55 55---- Management of companies and enterprises |\ 1258. | 10 1270 56 56---- Admin, support, waste mgt, remediation services |\ 1259. | 10 1270 61 61---- Educational services |\ 1260. | 10 1270 62 62---- Health care and social assistance |\ |---------------------------------------------------------------------------------------------|\ 1261. | 10 1270 71 71---- Arts, entertainment and recreation |\ 1262. | 10 1270 72 72---- Accommodation and food services |\ 1263. | 10 1270 81 81---- Other services (except public administration) |\ 1264. | 10 1270 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ 1265. | 10 1270 99 99---- Unclassified establishments |\ |---------------------------------------------------------------------------------------------|\ 1266. | 10 1290 11 11---- Forestry, fishing, hunting, and agriculture support |\ 1267. | 10 1290 21 21---- Mining |\ 1268. | 10 1290 22 22---- Utilities |\ 1269. | 10 1290 23 23---- Construction |\ 1270. | 10 1290 31 31---- Manufacturing |\ |---------------------------------------------------------------------------------------------|\ 1271. | 10 1290 42 42---- Wholesale trade |\ 1272. | 10 1290 44 44---- Retail trade |\ 1273. | 10 1290 48 48---- Transportation and warehousing |\ 1274. | 10 1290 51 51---- Information |\ 1275. | 10 1290 52 52---- Finance and insurance |\ |---------------------------------------------------------------------------------------------|\ 1276. | 10 1290 53 53---- Real estate and rental and leasing |\ 1277. | 10 1290 54 54---- Professional, scientific and technical services |\ 1278. | 10 1290 56 56---- Admin, support, waste mgt, remediation services |\ 1279. | 10 1290 61 61---- Educational services |\ 1280. | 10 1290 62 62---- Health care and social assistance |\ |---------------------------------------------------------------------------------------------|\ 1281. | 10 1290 71 71---- Arts, entertainment and recreation |\ 1282. | 10 1290 72 72---- Accommodation and food services |\ 1283. | 10 1290 81 81---- Other services (except public administration) |\ 1284. | 10 1290 99 99---- Unclassified establishments |\ 1285. | 10 1310 11 11---- Forestry, fishing, hunting, and agriculture support |\ |---------------------------------------------------------------------------------------------|\ 1286. | 10 1310 22 22---- Utilities |\ 1287. | 10 1310 23 23---- Construction |\ 1288. | 10 1310 31 31---- Manufacturing |\ 1289. | 10 1310 42 42---- Wholesale trade |\ 1290. | 10 1310 44 44---- Retail trade |\ |---------------------------------------------------------------------------------------------|\ 1291. | 10 1310 48 48---- Transportation and warehousing |\ 1292. | 10 1310 51 51---- Information |\ 1293. | 10 1310 52 52---- Finance and insurance |\ 1294. | 10 1310 53 53---- Real estate and rental and leasing |\ 1295. | 10 1310 54 54---- Professional, scientific and technical services |\ |---------------------------------------------------------------------------------------------|\ 1296. | 10 1310 56 56---- Admin, support, waste mgt, remediation services |\ 1297. | 10 1310 61 61---- Educational services |\ 1298. | 10 1310 62 62---- Health care and social assistance |\ 1299. | 10 1310 72 72---- Accommodation and food services |\ 1300. | 10 1310 81 81---- Other services (except public administration) |\ |---------------------------------------------------------------------------------------------|\ 1301. | 10 1310 99 99---- Unclassified establishments |\ 1302. | 10 1330 11 11---- Forestry, fishing, hunting, and agriculture support |\ 1303. | 10 1330 21 21---- Mining |\ 1304. | 10 1330 22 22---- Utilities |\ 1305. | 10 1330 23 23---- Construction |\ |---------------------------------------------------------------------------------------------|\ 1306. | 10 1330 31 31---- Manufacturing |\ 1307. | 10 1330 42 42---- Wholesale trade |\ 1308. | 10 1330 44 44---- Retail trade |\ 1309. | 10 1330 48 48---- Transportation and warehousing |\ 1310. | 10 1330 51 51---- Information |\ |---------------------------------------------------------------------------------------------|\ 1311. | 10 1330 52 52---- Finance and insurance |\ 1312. | 10 1330 53 53---- Real estate and rental and leasing |\ 1313. | 10 1330 54 54---- Professional, scientific and technical services |\ 1314. | 10 1330 55 55---- Management of companies and enterprises |\ 1315. | 10 1330 56 56---- Admin, support, waste mgt, remediation services |\ |---------------------------------------------------------------------------------------------|\ 1316. | 10 1330 62 62---- Health care and social assistance |\ 1317. | 10 1330 71 71---- Arts, entertainment and recreation |\ 1318. | 10 1330 72 72---- Accommodation and food services |\ 1319. | 10 1330 81 81---- Other services (except public administration) |\ 1320. | 10 1330 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ |---------------------------------------------------------------------------------------------|\ 1321. | 10 1330 99 99---- Unclassified establishments |\ 1322. | 10 9990 21 21---- Mining |\ 1323. | 10 9990 23 23---- Construction |\ 1324. | 10 9990 52 52---- Finance and insurance |\ 1325. | 10 9990 54 54---- Professional, scientific and technical services |\ |---------------------------------------------------------------------------------------------|\ 1326. | 10 9990 56 56---- Admin, support, waste mgt, remediation services |\ 1327. | 10 9990 61 61---- Educational services |\ 1328. | 10 9990 95 95---- Auxiliaries (exc corporate, subsidiary and regional mgt) |\ +---------------------------------------------------------------------------------------------+\ \ (data now sorted by statea countya naicsa)\ \ . edit\ - preserve\ \ . ******************************************************************\ \ . *TREATING ERROR\ \ . *ADDING OBSERVATIONS FOR NAICSA 95 FOR BIBB AND BLOUNT COUNTIES AND DROPPING NON-COUNTY DATA\ \ . input\ \ yeargrp gisjoin state statea county countya \ > naics naicsa yeara employees\ 1329. 1998-2003 G0100010 Alabama 10 Bibb 70 "95---- Auxiliaries (exc corporate, subsidiary and regional mgt)" 95 2002 0\ 1330. 1998-2004 G0100011 Alabama 10 Blount 90 "95---- Auxiliaries (exc corporate, subsidiary and regional mgt)" 95 2002 0\ 1331. end\ \ . edit\ - preserve\ \ . ******************************************************************\ \ . *NOT DROPPING Non-COUNTY DATA, ADDING ADDITIONAL OBSERVATIONS W/EMPLOYEES = 0\ \ . input\ \ yeargrp gisjoin state statea county countya \ > naics naicsa yeara employees\ 1331. 1998-1984 G0109971 Alabama 10 "Alabama Statewide No Fixed Loc [multi-county area]" 9990 "11---- Forestry, fishing, hunting, and agricu\ > lture support" 11 2002 0\ 1332. 1998-1986 G0109973 Alabama 10 "Alabama Statewide No Fixed Loc [multi-county area]" 9990 "22---- Utilities" 22 2002 0\ 1333. 1998-1988 G0109975 Alabama 10 "Alabama Statewide No Fixed Loc [multi-county area]" 9990 "31---- Manufacturing" 31 2002 0\ 1334. 1998-1989 G0109976 Alabama 10 "Alabama Statewide No Fixed Loc [multi-county area]" 9990 "42---- Wholesale trade" 42 2002 0\ 1335. 1998-1990 G0109977 Alabama 10 "Alabama Statewide No Fixed Loc [multi-county area]" 9990 "44---- Retail trade" 44 2002 0\ 1336. 1998-1991 G0109978 Alabama 10 "Alabama Statewide No Fixed Loc [multi-county area]" 9990 "48---- Transportation and warehousing" 48 200\ > 2 0\ 1337. 1998-1992 G0109979 Alabama 10 "Alabama Statewide No Fixed Loc [multi-county area]" 9990 "51---- Information" 51 2002 0\ 1338. 1998-1994 G0109981 Alabama 10 "Alabama Statewide No Fixed Loc [multi-county area]" 9990 "53---- Real estate and rental and leasing" 53\ > 2002 0\ 1339. 1998-1996 G0109983 Alabama 10 "Alabama Statewide No Fixed Loc [multi-county area]" 9990 "55---- Management of companies and enterprise\ > s" 55 2002 0\ 1340. 1998-1999 G0109986 Alabama 10 "Alabama Statewide No Fixed Loc [multi-county area]" 9990 "62---- Health care and social assistance" 62 \ > 2002 0\ 1341. 1998-2000 G0109987 Alabama 10 "Alabama Statewide No Fixed Loc [multi-county area]" 9990 "71---- Arts, entertainment and recreation" 71\ > 2002 0\ 1342. 1998-2001 G0109988 Alabama 10 "Alabama Statewide No Fixed Loc [multi-county area]" 9990 "72---- Accommodation and food services" 72 20\ > 02 0\ 1343. 1998-2002 G0109989 Alabama 10 "Alabama Statewide No Fixed Loc [multi-county area]" 9990 "81---- Other services (except public administ\ > ration)" 81 2002 0\ 1344. 1998-2003 G0109990 Alabama 11 "Alabama Statewide No Fixed Loc [multi-county area]" 9991 "99---- Unclassified establishments" 99 2002 0\ 1345. end\ \ . ******************************************************************\ \ . ******************************************************************\ \ . reshape wide employees, i(statea countya) j(naicsa)\ (note: j = 11 21 22 23 31 42 44 48 51 52 53 54 55 56 61 62 71 72 81 95 99)\ yeargrp not constant within statea countya\ gisjoin not constant within statea countya\ naics not constant within statea countya\ Type "reshape error" for a listing of the problem observations.\ r(9);\ \ . edit\ - preserve\ - replace yeargrp = "1998-2003" in 1330\ - replace yeargrp = "1998-2003" in 1331\ - replace yeargrp = "1998-2003" in 1332\ - replace yeargrp = "1998-2003" in 1333\ - replace yeargrp = "1998-2003" in 1334\ - replace yeargrp = "1998-2003" in 1335\ - replace yeargrp = "1998-2003" in 1336\ - replace yeargrp = "1998-2003" in 1337\ - replace yeargrp = "1998-2003" in 1338\ - replace yeargrp = "1998-2003" in 1339\ - replace yeargrp = "1998-2003" in 1340\ - replace yeargrp = "1998-2003" in 1341\ - replace yeargrp = "1998-2003" in 1342\ - replace yeargrp = "1998-2003" in 1343\ - replace gisjoin = "G0109990" in 1331\ - replace gisjoin = "G0109990" in 1332\ - replace gisjoin = "G0109990" in 1333\ - replace gisjoin = "G0109990" in 1334\ - replace gisjoin = "G0109990" in 1335\ - replace gisjoin = "G0109990" in 1336\ - replace gisjoin = "G0109990" in 1337\ - replace gisjoin = "G0109990" in 1338\ - replace gisjoin = "G0109990" in 1339\ - replace gisjoin = "G0109990" in 1340\ - replace gisjoin = "G0109990" in 1341\ - replace gisjoin = "G0109990" in 1342\ - replace gisjoin = "G0109990" in 1343\ - replace gisjoin = "G0100090" in 1330\ - preserve\ \ . reshape wide employees, i(statea countya) j(naicsa)\ (note: j = 11 21 22 23 31 42 44 48 51 52 53 54 55 56 61 62 71 72 81 95 99)\ gisjoin not constant within statea countya\ naics not constant within statea countya\ Type "reshape error" for a listing of the problem observations.\ r(9);\ \ . *QUICK FIX drop gisjoin and naics\ \ . drop gisjoin naics\ \ . reshape wide employees, i(statea countya) j(naicsa)\ (note: j = 11 21 22 23 31 42 44 48 51 52 53 54 55 56 61 62 71 72 81 95 99)\ \ Data long -> wide\ -----------------------------------------------------------------------------\ Number of obs. 1344 -> 69\ Number of variables 8 -> 27\ j variable (21 values) naicsa -> (dropped)\ xij variables:\ employees -> employees11 employees21 ... employees99\ -----------------------------------------------------------------------------\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . *DESCRIBE AND SUMMARIZE DATA\ \ . describe\ \ Contains data\ obs: 69 \ vars: 27 \ size: 10,971 (99.9% of memory free)\ --------------------------------------------------------------------------------------------------------------------------------------------\ storage display value\ variable name type format label variable label\ --------------------------------------------------------------------------------------------------------------------------------------------\ statea byte %8.0g STATE CODE\ countya int %8.0g COUNTY CODE\ employees11 long %12.0g 11 employees\ employees21 long %12.0g 21 employees\ employees22 long %12.0g 22 employees\ employees23 long %12.0g 23 employees\ employees31 long %12.0g 31 employees\ employees42 long %12.0g 42 employees\ employees44 long %12.0g 44 employees\ employees48 long %12.0g 48 employees\ employees51 long %12.0g 51 employees\ employees52 long %12.0g 52 employees\ employees53 long %12.0g 53 employees\ employees54 long %12.0g 54 employees\ employees55 long %12.0g 55 employees\ employees56 long %12.0g 56 employees\ employees61 long %12.0g 61 employees\ employees62 long %12.0g 62 employees\ employees71 long %12.0g 71 employees\ employees72 long %12.0g 72 employees\ employees81 long %12.0g 81 employees\ employees95 long %12.0g 95 employees\ employees99 long %12.0g 99 employees\ yeargrp str9 %9s YEAR\ state str7 %9s STATE NAME\ county str50 %50s COUNTY NAME\ yeara int %8.0g YEAR CODE\ --------------------------------------------------------------------------------------------------------------------------------------------\ Sorted by: statea countya\ Note: dataset has changed since last saved\ \ . sum\ \ Variable | Obs Mean Std. Dev. Min Max\ -------------+--------------------------------------------------------\ statea | 69 10.01449 .1203859 10 11\ countya | 69 940.1594 1621.231 10 9991\ employees11 | 68 98.36765 104.9779 0 438\ employees21 | 51 108.3333 348.5638 0 1731\ employees22 | 66 58.65152 171.5097 0 1292\ -------------+--------------------------------------------------------\ employees23 | 68 1387.235 3409.131 0 24477\ employees31 | 68 4092.838 5287.584 0 30650\ employees42 | 68 1076.941 2782.3 0 20543\ employees44 | 68 3301.926 6261.994 0 42374\ employees48 | 68 649.1176 1474.898 0 10463\ -------------+--------------------------------------------------------\ employees51 | 68 561.2206 1964.318 0 15470\ employees52 | 68 1117.941 3943.946 0 31462\ employees53 | 68 329.2059 896.5464 0 6303\ employees54 | 68 1182.118 3809.602 0 23510\ employees55 | 50 357.38 1199.054 0 8109\ -------------+--------------------------------------------------------\ employees56 | 68 1497.235 4023.513 0 25524\ employees61 | 60 288.3833 821.9758 0 5456\ employees62 | 68 3090.956 6930.796 0 49584\ employees71 | 65 189.4615 509.1581 0 3393\ employees72 | 68 1896.412 3671.404 0 23572\ -------------+--------------------------------------------------------\ employees81 | 68 1251.853 3028.392 0 22034\ employees95 | 37 126.027 344.6789 0 1774\ employees99 | 63 10.15873 27.74725 0 206\ yeargrp | 0\ state | 0\ -------------+--------------------------------------------------------\ county | 0\ yeara | 69 2002 0 2002 2002\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . *TREATING MISSINGNESS\ \ . foreach var of varlist employees11-employees99 \{\ 2. replace `var'=0 if `var'==.\ 3. \}\ (1 real change made)\ (18 real changes made)\ (3 real changes made)\ (1 real change made)\ (1 real change made)\ (1 real change made)\ (1 real change made)\ (1 real change made)\ (1 real change made)\ (1 real change made)\ (1 real change made)\ (1 real change made)\ (19 real changes made)\ (1 real change made)\ (9 real changes made)\ (1 real change made)\ (4 real changes made)\ (1 real change made)\ (1 real change made)\ (32 real changes made)\ (6 real changes made)\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . edit\ - preserve\ \ . *CREATING TOTAL OF EMPLOYEES IN EACH COUNTY\ \ . gen cntyemployeestot=(employees11+employees21+employees22+employees23+employees31+employees42+employees44+employees48+employees51+employee\ > s53+employees52+employees54+employees55+employees56+employees61+employees62+employees71+employees72+employees81+employees95+employees99+em\ > ployees99)\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . *CREATING EMPLOYMENT SHARES\ \ . foreach var of varlist employees11-employees99 \{\ 2. gen shr`var'=`var'/cntyemployeestot\ 3. \}\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ (1 missing value generated)\ \ \ . *MISSINGNESS CAUSED BY INCORRECT VALUE OF STATEA. MISSINGNESS IN NON-COUNTY OBSERVATION. DROPPING WILL NOT CAUSE DATA LOSS. WILL DROP.\ \ . drop if statea==11\ (1 observation deleted)\ \ . *USING TABULATE TO GET A SENSE OF SHARES\ \ . foreach var of varlist employees11-employees99\{\ 2. bysort countya: tab shr`var'\ 3. \}\ . *Output deleted because it was too long\ \ . *ADDING DESCRIPTIVE LABELS\ \ . foreach var of varlist shremployees11-shremployees99\{\ 2. label variable `var' `"share of county's employees in given naics industry"'\ 3. \}\ \ . foreach var of varlist employees11-employees99\{\ 2. label variable `var' `"total # of employees in county in given naics industry"'\ 3. \}\ \ . edit\ - preserve\ \ . label variable cntyemployeestot `"total number of employees in each county"'\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . *Creating other employment shares\ \ . */own total employees = cntyemployeestot; own employees in industry = employees11-employees99; total employees in all counties in all indu\ > stries = the sum of cntyemployeestot*/\ \ . *Creating total employees for each industry\ \ . foreach var of varlist employees11-employees99 \{\ 2. gen tot`var'= sum(`var')\ 3. *LAEBEL VARS\ . label variable tot`var' `"total employees for naics industry"'\ 4. \}\ \ . *Creating total employees in all counties in all industries\ \ . egen allemp= max (sum(cntyemployeestot))\ \ . label variable allemp `"total number of employees in all counties in all industries"'\ \ . *Creating othrshr\ \ . foreach var of varlist employees11-employees99\{\ 2. edit\ 3. gen othrshr`var'=(tot`var' - `var')/(allemp - cntyemployeestot)\ 4. \}\ - preserve\ - preserve\ - preserve\ - preserve\ - preserve\ - preserve\ - preserve\ - preserve\ - preserve\ - preserve\ - preserve\ - preserve\ - preserve\ - preserve\ - preserve\ - preserve\ - preserve\ - preserve\ - preserve\ - preserve\ - preserve\ \ . edit\ - preserve\ \ . *CORRECTING MISTAKE: totemployees## gives a running total not the anticipated total \ \ . foreach var of varlist employees11-employees99 \{\ 2. egen newtot`var'= max(sum(`var'))\ 3. \}\ \ . *reassigning value of totemployees## to newtotemployees##\ \ . foreach var of varlist totemployees11-totemployees99\{\ 2. replace `var'=new`var'\ 3. \}\ (66 real changes made)\ (67 real changes made)\ (64 real changes made)\ (66 real changes made)\ (66 real changes made)\ (66 real changes made)\ (66 real changes made)\ (66 real changes made)\ (66 real changes made)\ (66 real changes made)\ (66 real changes made)\ (66 real changes made)\ (63 real changes made)\ (66 real changes made)\ (62 real changes made)\ (66 real changes made)\ (62 real changes made)\ (66 real changes made)\ (66 real changes made)\ (62 real changes made)\ (64 real changes made)\ \ . edit\ - preserve\ \ . *dropping newtotemployees##\ \ . foreach var of varlist newtotemployees11-newtotemployees99\{\ 2. drop `var'\ 3. \}\ \ . edit\ - preserve\ \ . foreach var of varlist othrshremployees11-othrshremployees99\{\ 2. drop `var'\ 3. \}\ \ . edit\ - preserve\ \ . *CREATING CORRECT OTHRSHR\ \ . foreach var of varlist employees11-employees99\{\ 2. gen othrshr`var'=(tot`var' - `var')/(allemp - cntyemployeestot)\ 3. \}\ \ . edit\ - preserve\ \ . *Adding labels\ \ . foreach var of varlist othrshremployees11-othrshremployees99\{\ 2. label variable `var' `"employment shares (by industry) for all other counties"'\ 3. \}\ \ . describe\ \ Contains data\ obs: 68 \ vars: 92 \ size: 28,492 (99.7% of memory free)\ --------------------------------------------------------------------------------------------------------------------------------------------\ storage display value\ variable name type format label variable label\ --------------------------------------------------------------------------------------------------------------------------------------------\ statea byte %8.0g STATE CODE\ countya int %8.0g COUNTY CODE\ employees11 long %12.0g total # of employees in county in given naics industry\ employees21 long %12.0g total # of employees in county in given naics industry\ employees22 long %12.0g total # of employees in county in given naics industry\ employees23 long %12.0g total # of employees in county in given naics industry\ employees31 long %12.0g total # of employees in county in given naics industry\ employees42 long %12.0g total # of employees in county in given naics industry\ employees44 long %12.0g total # of employees in county in given naics industry\ employees48 long %12.0g total # of employees in county in given naics industry\ employees51 long %12.0g total # of employees in county in given naics industry\ employees52 long %12.0g total # of employees in county in given naics industry\ employees53 long %12.0g total # of employees in county in given naics industry\ employees54 long %12.0g total # of employees in county in given naics industry\ employees55 long %12.0g total # of employees in county in given naics industry\ employees56 long %12.0g total # of employees in county in given naics industry\ employees61 long %12.0g total # of employees in county in given naics industry\ employees62 long %12.0g total # of employees in county in given naics industry\ employees71 long %12.0g total # of employees in county in given naics industry\ employees72 long %12.0g total # of employees in county in given naics industry\ employees81 long %12.0g total # of employees in county in given naics industry\ employees95 long %12.0g total # of employees in county in given naics industry\ employees99 long %12.0g total # of employees in county in given naics industry\ yeargrp str9 %9s YEAR\ state str7 %9s STATE NAME\ county str50 %50s COUNTY NAME\ yeara int %8.0g YEAR CODE\ cntyemployees~t float %9.0g total number of employees in each county\ shremployees11 float %9.0g share of county's employees in given naics industry\ shremployees21 float %9.0g share of county's employees in given naics industry\ shremployees22 float %9.0g share of county's employees in given naics industry\ shremployees23 float %9.0g share of county's employees in given naics industry\ shremployees31 float %9.0g share of county's employees in given naics industry\ shremployees42 float %9.0g share of county's employees in given naics industry\ shremployees44 float %9.0g share of county's employees in given naics industry\ shremployees48 float %9.0g share of county's employees in given naics industry\ shremployees51 float %9.0g share of county's employees in given naics industry\ shremployees52 float %9.0g share of county's employees in given naics industry\ shremployees53 float %9.0g share of county's employees in given naics industry\ shremployees54 float %9.0g share of county's employees in given naics industry\ shremployees55 float %9.0g share of county's employees in given naics industry\ shremployees56 float %9.0g share of county's employees in given naics industry\ shremployees61 float %9.0g share of county's employees in given naics industry\ shremployees62 float %9.0g share of county's employees in given naics industry\ shremployees71 float %9.0g share of county's employees in given naics industry\ shremployees72 float %9.0g share of county's employees in given naics industry\ shremployees81 float %9.0g share of county's employees in given naics industry\ shremployees95 float %9.0g share of county's employees in given naics industry\ shremployees99 float %9.0g share of county's employees in given naics industry\ totemployees11 float %9.0g total employees for naics industry\ totemployees21 float %9.0g total employees for naics industry\ totemployees22 float %9.0g total employees for naics industry\ totemployees23 float %9.0g total employees for naics industry\ totemployees31 float %9.0g total employees for naics industry\ totemployees42 float %9.0g total employees for naics industry\ totemployees44 float %9.0g total employees for naics industry\ totemployees48 float %9.0g total employees for naics industry\ totemployees51 float %9.0g total employees for naics industry\ totemployees52 float %9.0g total employees for naics industry\ totemployees53 float %9.0g total employees for naics industry\ totemployees54 float %9.0g total employees for naics industry\ totemployees55 float %9.0g total employees for naics industry\ totemployees56 float %9.0g total employees for naics industry\ totemployees61 float %9.0g total employees for naics industry\ totemployees62 float %9.0g total employees for naics industry\ totemployees71 float %9.0g total employees for naics industry\ totemployees72 float %9.0g total employees for naics industry\ totemployees81 float %9.0g total employees for naics industry\ totemployees95 float %9.0g total employees for naics industry\ totemployees99 float %9.0g total employees for naics industry\ allemp float %9.0g total number of employees in all counties in all industries\ othrshremplo~11 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~21 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~22 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~23 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~31 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~42 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~44 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~48 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~51 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~52 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~53 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~54 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~55 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~56 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~61 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~62 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~71 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~72 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~81 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~95 float %9.0g employment shares (by industry) for all other counties\ othrshremplo~99 float %9.0g employment shares (by industry) for all other counties\ --------------------------------------------------------------------------------------------------------------------------------------------\ Sorted by: countya\ Note: dataset has changed since last saved\ \ . sum\ \ Variable | Obs Mean Std. Dev. Min Max\ -------------+--------------------------------------------------------\ statea | 68 10 0 10 10\ countya | 68 807.0588 1194.566 10 9990\ employees11 | 68 98.36765 104.9779 0 438\ employees21 | 68 81.25 304.7992 0 1731\ employees22 | 68 56.92647 169.2252 0 1292\ -------------+--------------------------------------------------------\ employees23 | 68 1387.235 3409.131 0 24477\ employees31 | 68 4092.838 5287.584 0 30650\ employees42 | 68 1076.941 2782.3 0 20543\ employees44 | 68 3301.926 6261.994 0 42374\ employees48 | 68 649.1176 1474.898 0 10463\ -------------+--------------------------------------------------------\ employees51 | 68 561.2206 1964.318 0 15470\ employees52 | 68 1117.941 3943.946 0 31462\ employees53 | 68 329.2059 896.5464 0 6303\ employees54 | 68 1182.118 3809.602 0 23510\ employees55 | 68 262.7794 1037.644 0 8109\ -------------+--------------------------------------------------------\ employees56 | 68 1497.235 4023.513 0 25524\ employees61 | 68 254.4559 777.002 0 5456\ employees62 | 68 3090.956 6930.796 0 49584\ employees71 | 68 181.1029 499.1698 0 3393\ employees72 | 68 1896.412 3671.404 0 23572\ -------------+--------------------------------------------------------\ employees81 | 68 1251.853 3028.392 0 22034\ employees95 | 68 68.57353 260.4483 0 1774\ employees99 | 68 9.411765 26.82516 0 206\ yeargrp | 0\ state | 0\ -------------+--------------------------------------------------------\ county | 0\ yeara | 68 2002 0 2002 2002\ cntyemploy~t | 68 22457.28 48222.7 433 340549\ shremploy~11 | 68 .0195604 .0289667 0 .1511401\ shremploy~21 | 68 .0163821 .1211743 0 1\ -------------+--------------------------------------------------------\ shremploy~22 | 68 .0037164 .010119 0 .0769499\ shremploy~23 | 68 .0537436 .0320332 0 .1551791\ shremploy~31 | 68 .2711549 .1620903 0 .6956947\ shremploy~42 | 68 .041355 .0428738 0 .2998124\ shremploy~44 | 68 .1614925 .0515145 0 .2911695\ -------------+--------------------------------------------------------\ shremploy~48 | 68 .0343557 .0412894 0 .283087\ shremploy~51 | 68 .0125313 .0118864 0 .0519126\ shremploy~52 | 68 .0361824 .0165276 0 .0923861\ shremploy~53 | 68 .0086279 .0067813 0 .0317563\ shremploy~54 | 68 .0236794 .024704 0 .1841683\ -------------+--------------------------------------------------------\ shremploy~55 | 68 .0036073 .0069423 0 .034118\ shremploy~56 | 68 .0284595 .0354235 0 .1292665\ shremploy~61 | 68 .0082866 .0213333 0 .1443243\ shremploy~62 | 68 .1407429 .0801599 0 .6417642\ shremploy~71 | 68 .0037186 .0054818 0 .0219137\ -------------+--------------------------------------------------------\ shremploy~72 | 68 .0791682 .0351007 0 .1869614\ shremploy~81 | 68 .0505445 .0235603 0 .1724324\ shremploy~95 | 68 .0018586 .0098217 0 .0793488\ shremploy~99 | 68 .0004162 .000723 0 .0034638\ totemploy~11 | 68 6689 0 6689 6689\ -------------+--------------------------------------------------------\ totemploy~21 | 68 5525 0 5525 5525\ totemploy~22 | 68 3871 0 3871 3871\ totemploy~23 | 68 94332 0 94332 94332\ totemploy~31 | 68 278313 0 278313 278313\ totemploy~42 | 68 73232 0 73232 73232\ -------------+--------------------------------------------------------\ totemploy~44 | 68 224531 0 224531 224531\ totemploy~48 | 68 44140 0 44140 44140\ totemploy~51 | 68 38163 0 38163 38163\ totemploy~52 | 68 76020 0 76020 76020\ totemploy~53 | 68 22386 0 22386 22386\ -------------+--------------------------------------------------------\ totemploy~54 | 68 80384 0 80384 80384\ totemploy~55 | 68 17869 0 17869 17869\ totemploy~56 | 68 101812 0 101812 101812\ totemploy~61 | 68 17303 0 17303 17303\ totemploy~62 | 68 210185 0 210185 210185\ -------------+--------------------------------------------------------\ totemploy~71 | 68 12315 0 12315 12315\ totemploy~72 | 68 128956 0 128956 128956\ totemploy~81 | 68 85126 0 85126 85126\ totemploy~95 | 68 4663 0 4663 4663\ totemploy~99 | 68 640 0 640 640\ -------------+--------------------------------------------------------\ allemp | 68 1527095 0 1527095 1527095\ othrshrem~11 | 68 .0043858 .0001897 .0041127 .0056374\ othrshrem~21 | 68 .0036169 .0001529 .0025988 .003948\ othrshrem~22 | 68 .0025367 .0001328 .0018778 .0032624\ othrshrem~23 | 68 .0617621 .0005037 .0588726 .0632496\ -------------+--------------------------------------------------------\ othrshrem~31 | 68 .1823529 .0036853 .1770351 .208726\ othrshrem~42 | 68 .0479441 .0005353 .0444054 .0489782\ othrshrem~44 | 68 .1470541 .0008948 .1449572 .1535187\ othrshrem~48 | 68 .0289034 .0002548 .0279806 .0299456\ othrshrem~51 | 68 .0249725 .0007308 .0191253 .0255902\ -------------+--------------------------------------------------------\ othrshrem~52 | 68 .049746 .0015662 .0375527 .0518722\ othrshrem~53 | 68 .0146547 .00018 .0135545 .014835\ othrshrem~54 | 68 .0526222 .0015094 .0406405 .0535286\ othrshrem~55 | 68 .0116903 .0004435 .0082256 .0119476\ othrshrem~56 | 68 .0666532 .000804 .0620678 .0674171\ -------------+--------------------------------------------------------\ othrshrem~61 | 68 .0113253 .0002143 .0099844 .0116035\ othrshrem~62 | 68 .1376308 .0006687 .1353517 .1401253\ othrshrem~71 | 68 .0080619 .0001068 .0075193 .0083129\ othrshrem~72 | 68 .0844578 .0006205 .0826884 .0888158\ othrshrem~81 | 68 .0557353 .0003686 .0531728 .0565105\ -------------+--------------------------------------------------------\ othrshrem~95 | 68 .0030562 .0001953 .0019199 .0039299\ othrshrem~99 | 68 .000419 8.16e-06 .0003658 .0004363\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . *Creating indices\ \ . *******************************************************************\ \ . *KI\ \ . foreach var of varlist shremployees21-shremployees99 shremployees11\{\ 2. gen adiff`var'=abs(`var' - othr`var')\ 3. \}\ \ . gen ki = adiffshremployees11+adiffshremployees21+adiffshremployees22+adiffshremployees23+adiffshremployees31+adiffshremployees42+adiffshre\ > mployees44+adiffshremployees48+adiffshremployees51+adiffshremployees53+adiffshremployees52+adiffshremployees54+adiffshremployees55+adiffsh\ > remployees56+adiffshremployees61+adiffshremployees62+adiffshremployees71+adiffshremployees72+adiffshremployees81+adiffshremployees95+adiff\ > shremployees99+adiffshremployees99\ \ . *******************************************************************\ \ . *HI\ \ . *Creating squares of own shares\ \ . foreach var of varlist shremployees11-shremployees99\{\ 2. gen sq`var'=(`var')^2\ 3. gen sumsq`var'=sum(sq`var')\ 4. \}\ \ . ********************************\ \ . *ADDING VAR LABELS\ \ . foreach var of varlist sqshremployees11-sqshremployees99\{\ 2. label variable `var' `"square of own share of employees in industry"'\ 3. \}\ \ . ********************************\ \ . *CORRECTING KI\ \ . drop ki\ \ . foreach var of varlist adiffshremployees21-adiffshremployees21\{\ 2. drop `var'\ 3. \}\ \ . edit\ - preserve\ \ . edit\ - preserve\ \ . foreach var of varlist adiffshremployees22-adiffshremployees99\{\ 2. drop `var'\ 3. \}\ \ . drop adiffshremployees11\ \ . foreach var of varlist shremployees11-shremployees99\{\ 2. gen adiff`var'=abs(`var' - othr`var')\ 3. \}\ \ . *Adding labels\ \ . foreach var of varlist adiffshremployees11-adiffshremployees99\{\ 2. label variable `var' `"abs val of diff between own and other industry shares"'\ 3. \}\ \ . gen ki = adiffshremployees11+adiffshremployees21+adiffshremployees22+adiffshremployees23+adiffshremployees31+adiffshremployees42+adiffshre\ > mployees44+adiffshremployees48+adiffshremployees51+adiffshremployees53+adiffshremployees52+adiffshremployees54+adiffshremployees55+adiffsh\ > remployees56+adiffshremployees61+adiffshremployees62+adiffshremployees71+adiffshremployees72+adiffshremployees81+adiffshremployees95+adiff\ > shremployees99+adiffshremployees99\ \ . label variable ki `"Krugman Index "'\ \ . ******************************** \ \ . *CORRECTING sumsqshr. Used sum() but should have used max(sum()) to generate.\ \ . foreach var of varlist shremployees11-shremployees99\{\ 2. drop sq`var'\ 3. drop sumsq`var'\ 4. \}\ \ . ********************************\ \ . *Creating squares of own shares\ \ . foreach var of varlist shremployees11-shremployees99\{\ 2. gen sq`var'=(`var')^2\ 3. label variable `var' `"square of own share of employees in industry"'\ 4. \}\ \ . edit\ - preserve\ \ . *Correcting label\ \ . foreach var of varlist shremployees11-shremployees99\{\ 2. label variable `var' `"share of county's employees in given industry"'\ 3. \}\ \ . *Adding labels\ \ . . foreach var of varlist sqshremployees11-sqshremployees99\{\ 2. label variable `var' `"square of own share of employees in industry"`\ 3. \}\ \ . ********************************\ \ . gen hi = (sqshremployees11+sqshremployees21+sqshremployees22+sqshremployees23+sqshremployees31+sqshremployees42+sqshremployees44+sqshrempl\ > oyees48+sqshremployees51+sqshremployees53+sqshremployees52+sqshremployees54+sqshremployees55+sqshremployees56+sqshremployees61+sqshremploy\ > ees62+sqshremployees71+sqshremployees72+sqshremployees81+sqshremployees95+sqshremployees99+sqshremployees99)\ \ . label variable hi `"Herfindahl Index"'\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . sum hi, detail\ \ Herfindahl Index\ -------------------------------------------------------------\ Percentiles Smallest\ 1% .0841313 .0841313\ 5% .0919922 .0870946\ 10% .1108106 .0882547 Obs 68\ 25% .1241794 .0919922 Sum of Wgt. 68\ \ 50% .1586642 Mean .1970934\ Largest Std. Dev. .1312392\ 75% .2308077 .4064237\ 90% .3325134 .4462678 Variance .0172237\ 95% .4064237 .5077531 Skewness 3.787676\ 99% 1 1 Kurtosis 22.15784\ \ . sum ki, detail\ \ Krugman Index \ -------------------------------------------------------------\ Percentiles Smallest\ 1% .206022 .206022\ 5% .2335115 .2220325\ 10% .2541172 .2313563 Obs 68\ 25% .365736 .2335115 Sum of Wgt. 68\ \ 50% .4753618 Mean .5489707\ Largest Std. Dev. .2851976\ 75% .691308 1.010883\ 90% .8866996 1.05902 Variance .0813376\ 95% 1.010883 1.126515 Skewness 2.134416\ 99% 1.993329 1.993329 Kurtosis 10.92131\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . *COMPARE HI AND KI\ \ . correlate hi ki\ (obs=68)\ \ | hi ki\ -------------+------------------\ hi | 1.0000\ ki | 0.8851 1.0000\ \ \ . graph twoway scatter hi ki, title("AL HI KI")\ \ . edit\ - preserve\ \ . graph save Graph "/Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/employ_special/aah/NHGIS/emplo\ > y_spec_indx_data/allcounties_al/trial calculations/trial 1/trial 1 graph hi ki.gph"\ (file /Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/employ_special/aah/NHGIS/employ_spec_indx_da\ > ta/allcounties_al/trial calculations/trial 1/trial 1 graph hi ki.gph saved)\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . graph use "/Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/employ_special/aah/NHGIS/employ_spec_\ > indx_data/allcounties_al/trial calculations/trial 1/trial 1 graph hi ki.gph"\ \ . tabulate employees11 county\ \ total # of |\ employees |\ in county |\ in given |\ naics | COUNTY NAME\ industry | Alabama S Autauga Baldwin Barbour Bibb Blount Bullock Butler Calhoun Chambers | Total\ -----------+--------------------------------------------------------------------------------------------------------------+----------\ 0 | 1 1 0 0 0 1 1 0 0 0 | 25 \ 52 | 0 0 0 0 0 0 0 0 0 0 | 2 \ 54 | 0 0 0 0 0 0 0 0 1 0 | 1 \ 55 | 0 0 0 0 0 0 0 0 0 0 | 2 \ 58 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 60 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 62 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 64 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 65 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 66 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 69 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 76 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 83 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 86 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 88 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 100 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 107 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 108 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 109 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 138 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 150 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 152 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 165 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 173 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 177 | 0 0 0 0 0 0 0 0 0 1 | 1 \ 188 | 0 0 0 1 0 0 0 0 0 0 | 1 \ 197 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 204 | 0 0 0 0 1 0 0 0 0 0 | 1 \ 205 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 207 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 223 | 0 0 1 0 0 0 0 0 0 0 | 1 \ 229 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 232 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 233 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 239 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 252 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 271 | 0 0 0 0 0 0 0 1 0 0 | 1 \ 273 | 0 0 0 0 0 0 0 0 0 0 | 2 \ 275 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 326 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 438 | 0 0 0 0 0 0 0 0 0 0 | 1 \ -----------+--------------------------------------------------------------------------------------------------------------+----------\ Total | 1 1 1 1 1 1 1 1 1 1 | 68 \ \ \ total # of |\ employees |\ in county |\ in given |\ naics | COUNTY NAME\ industry | Cherokee Chilton Choctaw Clarke Clay Cleburne Coffee Colbert Conecuh Coosa | Total\ -----------+--------------------------------------------------------------------------------------------------------------+----------\ 0 | 1 0 0 0 0 0 1 1 0 0 | 25 \ 52 | 0 0 0 0 0 0 0 0 0 0 | 2 \ 54 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 55 | 0 0 0 0 0 0 0 0 0 1 | 2 \ 58 | 0 0 0 0 0 1 0 0 0 0 | 1 \ 60 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 62 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 64 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 65 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 66 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 69 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 76 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 83 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 86 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 88 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 100 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 107 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 108 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 109 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 138 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 150 | 0 0 0 0 1 0 0 0 0 0 | 1 \ 152 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 165 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 173 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 177 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 188 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 197 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 204 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 205 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 207 | 0 1 0 0 0 0 0 0 0 0 | 1 \ 223 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 229 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 232 | 0 0 1 0 0 0 0 0 0 0 | 1 \ 233 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 239 | 0 0 0 0 0 0 0 0 1 0 | 1 \ 252 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 271 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 273 | 0 0 0 0 0 0 0 0 0 0 | 2 \ 275 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 326 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 438 | 0 0 0 1 0 0 0 0 0 0 | 1 \ -----------+--------------------------------------------------------------------------------------------------------------+----------\ Total | 1 1 1 1 1 1 1 1 1 1 | 68 \ \ \ total # of |\ employees |\ in county |\ in given |\ naics | COUNTY NAME\ industry | Covington Crenshaw Cullman Dale Dallas DeKalb Elmore Escambia Etowah Fayette | Total\ -----------+--------------------------------------------------------------------------------------------------------------+----------\ 0 | 0 0 0 1 0 1 0 0 1 0 | 25 \ 52 | 0 0 0 0 0 0 0 0 0 0 | 2 \ 54 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 55 | 0 0 0 0 0 0 0 0 0 0 | 2 \ 58 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 60 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 62 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 64 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 65 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 66 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 69 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 76 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 83 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 86 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 88 | 0 0 0 0 0 0 1 0 0 0 | 1 \ 100 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 107 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 108 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 109 | 1 0 0 0 0 0 0 0 0 0 | 1 \ 138 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 150 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 152 | 0 0 1 0 0 0 0 0 0 0 | 1 \ 165 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 173 | 0 0 0 0 1 0 0 0 0 0 | 1 \ 177 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 188 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 197 | 0 0 0 0 0 0 0 1 0 0 | 1 \ 204 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 205 | 0 1 0 0 0 0 0 0 0 0 | 1 \ 207 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 223 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 229 | 0 0 0 0 0 0 0 0 0 1 | 1 \ 232 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 233 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 239 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 252 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 271 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 273 | 0 0 0 0 0 0 0 0 0 0 | 2 \ 275 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 326 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 438 | 0 0 0 0 0 0 0 0 0 0 | 1 \ -----------+--------------------------------------------------------------------------------------------------------------+----------\ Total | 1 1 1 1 1 1 1 1 1 1 | 68 \ \ \ total # of |\ employees |\ in county |\ in given |\ naics | COUNTY NAME\ industry | Franklin Geneva Greene Hale Henry Houston Jackson Jefferson Lamar Lauderdal | Total\ -----------+--------------------------------------------------------------------------------------------------------------+----------\ 0 | 0 0 1 0 0 1 0 1 0 0 | 25 \ 52 | 0 0 0 0 0 0 0 0 0 0 | 2 \ 54 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 55 | 0 0 0 0 0 0 1 0 0 0 | 2 \ 58 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 60 | 0 1 0 0 0 0 0 0 0 0 | 1 \ 62 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 64 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 65 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 66 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 69 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 76 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 83 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 86 | 0 0 0 1 0 0 0 0 0 0 | 1 \ 88 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 100 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 107 | 0 0 0 0 0 0 0 0 0 1 | 1 \ 108 | 1 0 0 0 0 0 0 0 0 0 | 1 \ 109 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 138 | 0 0 0 0 0 0 0 0 1 0 | 1 \ 150 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 152 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 165 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 173 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 177 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 188 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 197 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 204 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 205 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 207 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 223 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 229 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 232 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 233 | 0 0 0 0 1 0 0 0 0 0 | 1 \ 239 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 252 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 271 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 273 | 0 0 0 0 0 0 0 0 0 0 | 2 \ 275 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 326 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 438 | 0 0 0 0 0 0 0 0 0 0 | 1 \ -----------+--------------------------------------------------------------------------------------------------------------+----------\ Total | 1 1 1 1 1 1 1 1 1 1 | 68 \ \ \ total # of |\ employees |\ in county |\ in given |\ naics | COUNTY NAME\ industry | Lawrence Lee Limestone Lowndes Macon Madison Marengo Marion Marshall Mobile | Total\ -----------+--------------------------------------------------------------------------------------------------------------+----------\ 0 | 0 0 1 0 1 1 0 0 1 0 | 25 \ 52 | 0 1 0 0 0 0 0 0 0 0 | 2 \ 54 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 55 | 0 0 0 0 0 0 0 0 0 0 | 2 \ 58 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 60 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 62 | 0 0 0 0 0 0 0 1 0 0 | 1 \ 64 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 65 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 66 | 0 0 0 1 0 0 0 0 0 0 | 1 \ 69 | 1 0 0 0 0 0 0 0 0 0 | 1 \ 76 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 83 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 86 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 88 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 100 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 107 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 108 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 109 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 138 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 150 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 152 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 165 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 173 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 177 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 188 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 197 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 204 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 205 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 207 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 223 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 229 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 232 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 233 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 239 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 252 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 271 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 273 | 0 0 0 0 0 0 0 0 0 1 | 2 \ 275 | 0 0 0 0 0 0 1 0 0 0 | 1 \ 326 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 438 | 0 0 0 0 0 0 0 0 0 0 | 1 \ -----------+--------------------------------------------------------------------------------------------------------------+----------\ Total | 1 1 1 1 1 1 1 1 1 1 | 68 \ \ \ total # of |\ employees |\ in county |\ in given |\ naics | COUNTY NAME\ industry | Monroe Montgomer Morgan Perry Pickens Pike Randolph Russell Shelby St Clair | Total\ -----------+--------------------------------------------------------------------------------------------------------------+----------\ 0 | 0 1 1 1 0 0 1 1 1 0 | 25 \ 52 | 0 0 0 0 0 0 0 0 0 0 | 2 \ 54 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 55 | 0 0 0 0 0 0 0 0 0 0 | 2 \ 58 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 60 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 62 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 64 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 65 | 0 0 0 0 0 1 0 0 0 0 | 1 \ 66 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 69 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 76 | 0 0 0 0 0 0 0 0 0 1 | 1 \ 83 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 86 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 88 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 100 | 0 0 0 0 1 0 0 0 0 0 | 1 \ 107 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 108 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 109 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 138 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 150 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 152 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 165 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 173 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 177 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 188 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 197 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 204 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 205 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 207 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 223 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 229 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 232 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 233 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 239 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 252 | 1 0 0 0 0 0 0 0 0 0 | 1 \ 271 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 273 | 0 0 0 0 0 0 0 0 0 0 | 2 \ 275 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 326 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 438 | 0 0 0 0 0 0 0 0 0 0 | 1 \ -----------+--------------------------------------------------------------------------------------------------------------+----------\ Total | 1 1 1 1 1 1 1 1 1 1 | 68 \ \ \ total # of |\ employees |\ in county |\ in given |\ naics | COUNTY NAME\ industry | Sumter Talladega Tallapoos Tuscaloos Walker Washingto Wilcox Winston | Total\ -----------+----------------------------------------------------------------------------------------+----------\ 0 | 0 1 0 0 0 0 1 0 | 25 \ 52 | 0 0 0 0 0 0 0 1 | 2 \ 54 | 0 0 0 0 0 0 0 0 | 1 \ 55 | 0 0 0 0 0 0 0 0 | 2 \ 58 | 0 0 0 0 0 0 0 0 | 1 \ 60 | 0 0 0 0 0 0 0 0 | 1 \ 62 | 0 0 0 0 0 0 0 0 | 1 \ 64 | 1 0 0 0 0 0 0 0 | 1 \ 65 | 0 0 0 0 0 0 0 0 | 1 \ 66 | 0 0 0 0 0 0 0 0 | 1 \ 69 | 0 0 0 0 0 0 0 0 | 1 \ 76 | 0 0 0 0 0 0 0 0 | 1 \ 83 | 0 0 1 0 0 0 0 0 | 1 \ 86 | 0 0 0 0 0 0 0 0 | 1 \ 88 | 0 0 0 0 0 0 0 0 | 1 \ 100 | 0 0 0 0 0 0 0 0 | 1 \ 107 | 0 0 0 0 0 0 0 0 | 1 \ 108 | 0 0 0 0 0 0 0 0 | 1 \ 109 | 0 0 0 0 0 0 0 0 | 1 \ 138 | 0 0 0 0 0 0 0 0 | 1 \ 150 | 0 0 0 0 0 0 0 0 | 1 \ 152 | 0 0 0 0 0 0 0 0 | 1 \ 165 | 0 0 0 0 1 0 0 0 | 1 \ 173 | 0 0 0 0 0 0 0 0 | 1 \ 177 | 0 0 0 0 0 0 0 0 | 1 \ 188 | 0 0 0 0 0 0 0 0 | 1 \ 197 | 0 0 0 0 0 0 0 0 | 1 \ 204 | 0 0 0 0 0 0 0 0 | 1 \ 205 | 0 0 0 0 0 0 0 0 | 1 \ 207 | 0 0 0 0 0 0 0 0 | 1 \ 223 | 0 0 0 0 0 0 0 0 | 1 \ 229 | 0 0 0 0 0 0 0 0 | 1 \ 232 | 0 0 0 0 0 0 0 0 | 1 \ 233 | 0 0 0 0 0 0 0 0 | 1 \ 239 | 0 0 0 0 0 0 0 0 | 1 \ 252 | 0 0 0 0 0 0 0 0 | 1 \ 271 | 0 0 0 0 0 0 0 0 | 1 \ 273 | 0 0 0 0 0 1 0 0 | 2 \ 275 | 0 0 0 0 0 0 0 0 | 1 \ 326 | 0 0 0 1 0 0 0 0 | 1 \ 438 | 0 0 0 0 0 0 0 0 | 1 \ -----------+----------------------------------------------------------------------------------------+----------\ Total | 1 1 1 1 1 1 1 1 | 68 \ \ \ \ . tabulate cntyemployeestot county\ \ total |\ number of |\ employees |\ in each | COUNTY NAME\ county | Alabama S Autauga Baldwin Barbour Bibb Blount Bullock Butler Calhoun Chambers | Total\ -----------+--------------------------------------------------------------------------------------------------------------+----------\ 433 | 1 0 0 0 0 0 0 0 0 0 | 1 \ 838 | 0 0 0 0 0 0 1 0 0 0 | 1 \ 1022 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1098 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1178 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1535 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1850 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2096 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2141 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2196 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2483 | 0 0 0 0 1 0 0 0 0 0 | 1 \ 2571 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2597 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2669 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2775 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2872 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2887 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3045 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3333 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3714 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3875 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3886 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 4298 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 4751 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 4885 | 0 0 0 0 0 0 0 1 0 0 | 1 \ 5330 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6159 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6426 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6679 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6821 | 0 0 0 0 0 1 0 0 0 0 | 1 \ 6895 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 7166 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 7175 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 8350 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 8555 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9180 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9187 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9399 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9568 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9594 | 0 0 0 1 0 0 0 0 0 0 | 1 \ 9761 | 0 0 0 0 0 0 0 0 0 1 | 1 \ 9899 | 0 1 0 0 0 0 0 0 0 0 | 1 \ 10381 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 10938 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 11062 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 11412 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 12663 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 13718 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 14046 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 14737 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 17901 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 20274 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 21145 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 22357 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 25256 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 30432 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 32452 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 32488 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 38041 | 0 0 0 0 0 0 0 0 1 0 | 1 \ 43078 | 0 0 1 0 0 0 0 0 0 0 | 1 \ 44952 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 45665 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 60236 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 67198 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 103609 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 127655 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 153678 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 340549 | 0 0 0 0 0 0 0 0 0 0 | 1 \ -----------+--------------------------------------------------------------------------------------------------------------+----------\ Total | 1 1 1 1 1 1 1 1 1 1 | 68 \ \ \ total |\ number of |\ employees |\ in each | COUNTY NAME\ county | Cherokee Chilton Choctaw Clarke Clay Cleburne Coffee Colbert Conecuh Coosa | Total\ -----------+--------------------------------------------------------------------------------------------------------------+----------\ 433 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 838 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1022 | 0 0 0 0 0 0 0 0 0 1 | 1 \ 1098 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1178 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1535 | 0 0 1 0 0 0 0 0 0 0 | 1 \ 1850 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2096 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2141 | 0 0 0 0 0 1 0 0 0 0 | 1 \ 2196 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2483 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2571 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2597 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2669 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2775 | 1 0 0 0 0 0 0 0 0 0 | 1 \ 2872 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2887 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3045 | 0 0 0 0 0 0 0 0 1 0 | 1 \ 3333 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3714 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3875 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3886 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 4298 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 4751 | 0 0 0 0 1 0 0 0 0 0 | 1 \ 4885 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 5330 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6159 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6426 | 0 1 0 0 0 0 0 0 0 0 | 1 \ 6679 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6821 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6895 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 7166 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 7175 | 0 0 0 1 0 0 0 0 0 0 | 1 \ 8350 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 8555 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9180 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9187 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9399 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9568 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9594 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9761 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9899 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 10381 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 10938 | 0 0 0 0 0 0 1 0 0 0 | 1 \ 11062 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 11412 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 12663 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 13718 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 14046 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 14737 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 17901 | 0 0 0 0 0 0 0 1 0 0 | 1 \ 20274 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 21145 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 22357 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 25256 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 30432 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 32452 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 32488 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 38041 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 43078 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 44952 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 45665 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 60236 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 67198 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 103609 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 127655 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 153678 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 340549 | 0 0 0 0 0 0 0 0 0 0 | 1 \ -----------+--------------------------------------------------------------------------------------------------------------+----------\ Total | 1 1 1 1 1 1 1 1 1 1 | 68 \ \ \ total |\ number of |\ employees |\ in each | COUNTY NAME\ county | Covington Crenshaw Cullman Dale Dallas DeKalb Elmore Escambia Etowah Fayette | Total\ -----------+--------------------------------------------------------------------------------------------------------------+----------\ 433 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 838 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1022 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1098 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1178 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1535 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1850 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2096 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2141 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2196 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2483 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2571 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2597 | 0 1 0 0 0 0 0 0 0 0 | 1 \ 2669 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2775 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2872 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2887 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3045 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3333 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3714 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3875 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3886 | 0 0 0 0 0 0 0 0 0 1 | 1 \ 4298 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 4751 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 4885 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 5330 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6159 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6426 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6679 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6821 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6895 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 7166 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 7175 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 8350 | 0 0 0 1 0 0 0 0 0 0 | 1 \ 8555 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9180 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9187 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9399 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9568 | 0 0 0 0 0 0 0 1 0 0 | 1 \ 9594 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9761 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9899 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 10381 | 1 0 0 0 0 0 0 0 0 0 | 1 \ 10938 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 11062 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 11412 | 0 0 0 0 0 0 1 0 0 0 | 1 \ 12663 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 13718 | 0 0 0 0 1 0 0 0 0 0 | 1 \ 14046 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 14737 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 17901 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 20274 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 21145 | 0 0 0 0 0 1 0 0 0 0 | 1 \ 22357 | 0 0 1 0 0 0 0 0 0 0 | 1 \ 25256 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 30432 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 32452 | 0 0 0 0 0 0 0 0 1 0 | 1 \ 32488 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 38041 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 43078 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 44952 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 45665 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 60236 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 67198 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 103609 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 127655 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 153678 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 340549 | 0 0 0 0 0 0 0 0 0 0 | 1 \ -----------+--------------------------------------------------------------------------------------------------------------+----------\ Total | 1 1 1 1 1 1 1 1 1 1 | 68 \ \ \ total |\ number of |\ employees |\ in each | COUNTY NAME\ county | Franklin Geneva Greene Hale Henry Houston Jackson Jefferson Lamar Lauderdal | Total\ -----------+--------------------------------------------------------------------------------------------------------------+----------\ 433 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 838 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1022 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1098 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1178 | 0 0 1 0 0 0 0 0 0 0 | 1 \ 1535 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1850 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2096 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2141 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2196 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2483 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2571 | 0 0 0 1 0 0 0 0 0 0 | 1 \ 2597 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2669 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2775 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2872 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2887 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3045 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3333 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3714 | 0 0 0 0 1 0 0 0 0 0 | 1 \ 3875 | 0 1 0 0 0 0 0 0 0 0 | 1 \ 3886 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 4298 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 4751 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 4885 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 5330 | 0 0 0 0 0 0 0 0 1 0 | 1 \ 6159 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6426 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6679 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6821 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6895 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 7166 | 1 0 0 0 0 0 0 0 0 0 | 1 \ 7175 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 8350 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 8555 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9180 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9187 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9399 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9568 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9594 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9761 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9899 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 10381 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 10938 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 11062 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 11412 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 12663 | 0 0 0 0 0 0 1 0 0 0 | 1 \ 13718 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 14046 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 14737 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 17901 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 20274 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 21145 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 22357 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 25256 | 0 0 0 0 0 0 0 0 0 1 | 1 \ 30432 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 32452 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 32488 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 38041 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 43078 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 44952 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 45665 | 0 0 0 0 0 1 0 0 0 0 | 1 \ 60236 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 67198 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 103609 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 127655 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 153678 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 340549 | 0 0 0 0 0 0 0 1 0 0 | 1 \ -----------+--------------------------------------------------------------------------------------------------------------+----------\ Total | 1 1 1 1 1 1 1 1 1 1 | 68 \ \ \ total |\ number of |\ employees |\ in each | COUNTY NAME\ county | Lawrence Lee Limestone Lowndes Macon Madison Marengo Marion Marshall Mobile | Total\ -----------+--------------------------------------------------------------------------------------------------------------+----------\ 433 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 838 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1022 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1098 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1178 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1535 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1850 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2096 | 0 0 0 1 0 0 0 0 0 0 | 1 \ 2141 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2196 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2483 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2571 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2597 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2669 | 1 0 0 0 0 0 0 0 0 0 | 1 \ 2775 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2872 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2887 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3045 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3333 | 0 0 0 0 1 0 0 0 0 0 | 1 \ 3714 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3875 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3886 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 4298 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 4751 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 4885 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 5330 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6159 | 0 0 0 0 0 0 1 0 0 0 | 1 \ 6426 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6679 | 0 0 0 0 0 0 0 1 0 0 | 1 \ 6821 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6895 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 7166 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 7175 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 8350 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 8555 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9180 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9187 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9399 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9568 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9594 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9761 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9899 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 10381 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 10938 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 11062 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 11412 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 12663 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 13718 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 14046 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 14737 | 0 0 1 0 0 0 0 0 0 0 | 1 \ 17901 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 20274 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 21145 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 22357 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 25256 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 30432 | 0 0 0 0 0 0 0 0 1 0 | 1 \ 32452 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 32488 | 0 1 0 0 0 0 0 0 0 0 | 1 \ 38041 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 43078 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 44952 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 45665 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 60236 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 67198 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 103609 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 127655 | 0 0 0 0 0 1 0 0 0 0 | 1 \ 153678 | 0 0 0 0 0 0 0 0 0 1 | 1 \ 340549 | 0 0 0 0 0 0 0 0 0 0 | 1 \ -----------+--------------------------------------------------------------------------------------------------------------+----------\ Total | 1 1 1 1 1 1 1 1 1 1 | 68 \ \ \ total |\ number of |\ employees |\ in each | COUNTY NAME\ county | Monroe Montgomer Morgan Perry Pickens Pike Randolph Russell Shelby St Clair | Total\ -----------+--------------------------------------------------------------------------------------------------------------+----------\ 433 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 838 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1022 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1098 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1178 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1535 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 1850 | 0 0 0 1 0 0 0 0 0 0 | 1 \ 2096 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2141 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2196 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2483 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2571 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2597 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2669 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2775 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2872 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 2887 | 0 0 0 0 1 0 0 0 0 0 | 1 \ 3045 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3333 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3714 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3875 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 3886 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 4298 | 0 0 0 0 0 0 1 0 0 0 | 1 \ 4751 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 4885 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 5330 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6159 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6426 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6679 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6821 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 6895 | 1 0 0 0 0 0 0 0 0 0 | 1 \ 7166 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 7175 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 8350 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 8555 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9180 | 0 0 0 0 0 1 0 0 0 0 | 1 \ 9187 | 0 0 0 0 0 0 0 1 0 0 | 1 \ 9399 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9568 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9594 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9761 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 9899 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 10381 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 10938 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 11062 | 0 0 0 0 0 0 0 0 0 1 | 1 \ 11412 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 12663 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 13718 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 14046 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 14737 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 17901 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 20274 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 21145 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 22357 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 25256 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 30432 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 32452 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 32488 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 38041 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 43078 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 44952 | 0 0 1 0 0 0 0 0 0 0 | 1 \ 45665 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 60236 | 0 0 0 0 0 0 0 0 1 0 | 1 \ 67198 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 103609 | 0 1 0 0 0 0 0 0 0 0 | 1 \ 127655 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 153678 | 0 0 0 0 0 0 0 0 0 0 | 1 \ 340549 | 0 0 0 0 0 0 0 0 0 0 | 1 \ -----------+--------------------------------------------------------------------------------------------------------------+----------\ Total | 1 1 1 1 1 1 1 1 1 1 | 68 \ \ \ total |\ number of |\ employees |\ in each | COUNTY NAME\ county | Sumter Talladega Tallapoos Tuscaloos Walker Washingto Wilcox Winston | Total\ -----------+----------------------------------------------------------------------------------------+----------\ 433 | 0 0 0 0 0 0 0 0 | 1 \ 838 | 0 0 0 0 0 0 0 0 | 1 \ 1022 | 0 0 0 0 0 0 0 0 | 1 \ 1098 | 0 0 0 0 0 0 1 0 | 1 \ 1178 | 0 0 0 0 0 0 0 0 | 1 \ 1535 | 0 0 0 0 0 0 0 0 | 1 \ 1850 | 0 0 0 0 0 0 0 0 | 1 \ 2096 | 0 0 0 0 0 0 0 0 | 1 \ 2141 | 0 0 0 0 0 0 0 0 | 1 \ 2196 | 1 0 0 0 0 0 0 0 | 1 \ 2483 | 0 0 0 0 0 0 0 0 | 1 \ 2571 | 0 0 0 0 0 0 0 0 | 1 \ 2597 | 0 0 0 0 0 0 0 0 | 1 \ 2669 | 0 0 0 0 0 0 0 0 | 1 \ 2775 | 0 0 0 0 0 0 0 0 | 1 \ 2872 | 0 0 0 0 0 1 0 0 | 1 \ 2887 | 0 0 0 0 0 0 0 0 | 1 \ 3045 | 0 0 0 0 0 0 0 0 | 1 \ 3333 | 0 0 0 0 0 0 0 0 | 1 \ 3714 | 0 0 0 0 0 0 0 0 | 1 \ 3875 | 0 0 0 0 0 0 0 0 | 1 \ 3886 | 0 0 0 0 0 0 0 0 | 1 \ 4298 | 0 0 0 0 0 0 0 0 | 1 \ 4751 | 0 0 0 0 0 0 0 0 | 1 \ 4885 | 0 0 0 0 0 0 0 0 | 1 \ 5330 | 0 0 0 0 0 0 0 0 | 1 \ 6159 | 0 0 0 0 0 0 0 0 | 1 \ 6426 | 0 0 0 0 0 0 0 0 | 1 \ 6679 | 0 0 0 0 0 0 0 0 | 1 \ 6821 | 0 0 0 0 0 0 0 0 | 1 \ 6895 | 0 0 0 0 0 0 0 0 | 1 \ 7166 | 0 0 0 0 0 0 0 0 | 1 \ 7175 | 0 0 0 0 0 0 0 0 | 1 \ 8350 | 0 0 0 0 0 0 0 0 | 1 \ 8555 | 0 0 0 0 0 0 0 1 | 1 \ 9180 | 0 0 0 0 0 0 0 0 | 1 \ 9187 | 0 0 0 0 0 0 0 0 | 1 \ 9399 | 0 0 1 0 0 0 0 0 | 1 \ 9568 | 0 0 0 0 0 0 0 0 | 1 \ 9594 | 0 0 0 0 0 0 0 0 | 1 \ 9761 | 0 0 0 0 0 0 0 0 | 1 \ 9899 | 0 0 0 0 0 0 0 0 | 1 \ 10381 | 0 0 0 0 0 0 0 0 | 1 \ 10938 | 0 0 0 0 0 0 0 0 | 1 \ 11062 | 0 0 0 0 0 0 0 0 | 1 \ 11412 | 0 0 0 0 0 0 0 0 | 1 \ 12663 | 0 0 0 0 0 0 0 0 | 1 \ 13718 | 0 0 0 0 0 0 0 0 | 1 \ 14046 | 0 0 0 0 1 0 0 0 | 1 \ 14737 | 0 0 0 0 0 0 0 0 | 1 \ 17901 | 0 0 0 0 0 0 0 0 | 1 \ 20274 | 0 1 0 0 0 0 0 0 | 1 \ 21145 | 0 0 0 0 0 0 0 0 | 1 \ 22357 | 0 0 0 0 0 0 0 0 | 1 \ 25256 | 0 0 0 0 0 0 0 0 | 1 \ 30432 | 0 0 0 0 0 0 0 0 | 1 \ 32452 | 0 0 0 0 0 0 0 0 | 1 \ 32488 | 0 0 0 0 0 0 0 0 | 1 \ 38041 | 0 0 0 0 0 0 0 0 | 1 \ 43078 | 0 0 0 0 0 0 0 0 | 1 \ 44952 | 0 0 0 0 0 0 0 0 | 1 \ 45665 | 0 0 0 0 0 0 0 0 | 1 \ 60236 | 0 0 0 0 0 0 0 0 | 1 \ 67198 | 0 0 0 1 0 0 0 0 | 1 \ 103609 | 0 0 0 0 0 0 0 0 | 1 \ 127655 | 0 0 0 0 0 0 0 0 | 1 \ 153678 | 0 0 0 0 0 0 0 0 | 1 \ 340549 | 0 0 0 0 0 0 0 0 | 1 \ -----------+----------------------------------------------------------------------------------------+----------\ Total | 1 1 1 1 1 1 1 1 | 68 \ \ \ . graph twoway scatter cntyemployeestot countya , title("AL tot # emps vs. county")\ \ . graph save Graph "/Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/employ_special/aah/NHGIS/emplo\ > y_spec_indx_data/allcounties_al/trial calculations/trial 1/trial 1 tot#empncnty vs cnty.gph"\ (file /Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/employ_special/aah/NHGIS/employ_spec_indx_da\ > ta/allcounties_al/trial calculations/trial 1/trial 1 tot#empncnty vs cnty.gph saved)\ \ . log off\ }