-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy patheiolca.sql
501 lines (487 loc) · 34.8 KB
/
eiolca.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 18, 2012 at 07:17 PM
-- Server version: 5.1.44
-- PHP Version: 5.3.1
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `eiolca`
--
CREATE DATABASE `eiolca` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `eiolca`;
-- --------------------------------------------------------
--
-- Table structure for table `component_categorynames`
--
CREATE TABLE IF NOT EXISTS `component_categorynames` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=29 ;
--
-- Dumping data for table `component_categorynames`
--
INSERT INTO `component_categorynames` (`id`, `name`) VALUES
(1, 'Agriculture, Livestock, Forestry, and Fisheries \n'),
(2, 'Mining and Utilities \n'),
(3, 'Construction \n'),
(4, 'Food, Beverage, and Tobacco \n'),
(5, 'Textiles, Apparel, and Leather \n'),
(6, 'Wood, Paper, and Printing \n'),
(7, 'Petroleum and Basic Chemical \n'),
(8, 'Resin, Rubber, Artificial Fibers, Agric. Chems, and Pharm \n'),
(9, 'Paint, Adhesives, Cleaning, and Other Chemicals \n'),
(10, 'Plastic, Rubber, and Nonmetallic mineral products \n'),
(11, 'Ferrous and nonferrous metal production \n'),
(12, 'Cutlery, Handtools, Structural and Metal Containers \n'),
(13, 'Other Metal Hardware and Ordnance Manufacturing \n'),
(14, 'Machinery and Engines \n'),
(15, 'Computers, Audio-Video, and Communications Equipment \n'),
(16, 'Semiconductors, Electronic Equipment, and Media Reproduction \n'),
(17, 'Lighting, Electrical Components, Batteries \n'),
(18, 'Vehicles and Other Transportation Equipment \n'),
(19, 'Furniture, Medical Equipment, and Supplies \n'),
(20, 'Other Miscellaneous Manufacturing \n'),
(21, 'Trade, Transportation, and Communications Media \n'),
(22, 'Finance, Insurance, Real Estate, Rental and Leasing \n'),
(23, 'Professional and Technical Services \n'),
(24, 'Management, Administrative, and Waste Services \n'),
(25, 'Education and Health Care Services \n'),
(26, 'Arts, Entertainment, Hotels and Food Services \n'),
(27, 'Other Services, Except Public Administration \n'),
(28, 'Government and Special Services \n');
-- --------------------------------------------------------
--
-- Table structure for table `component_sectors`
--
CREATE TABLE IF NOT EXISTS `component_sectors` (
`number` int(3) DEFAULT NULL,
`sector` varchar(84) DEFAULT NULL,
`xml` varchar(80) NOT NULL,
`cat_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `component_sectors`
--
INSERT INTO `component_sectors` (`number`, `sector`, `xml`, `cat_id`) VALUES
(100, 'Wood container and pallet manufacturing', 'xml/newLoop$1MSector_100', 6),
(101, 'Manufactured home mobile home manufacturing', 'xml/newLoop$1MSector_101', 6),
(103, 'Miscellaneous wood product manufacturing', 'xml/newLoop$1MSector_103', 6),
(104, 'Pulp mills', 'xml/newLoop$1MSector_104', 6),
(105, 'Paper mills', 'xml/newLoop$1MSector_105', 6),
(106, 'Paperboard Mills', 'xml/newLoop$1MSector_106', 6),
(107, 'Paperboard container manufacturing', 'xml/newLoop$1MSector_107', 6),
(108, 'Coated and laminated paper packaging materials and plastic films manufacturing', 'xml/newLoop$1MSector_108', 6),
(109, 'All other paper bag and coated and treated paper manufacturing', 'xml/newLoop$1MSector_109', 6),
(11, 'Milk Production', 'xml/newLoop$1MSector_11', 1),
(110, 'Stationery product manufacturing', 'xml/newLoop$1MSector_110', 6),
(111, 'Sanitary paper product manufacturing', 'xml/newLoop$1MSector_111', 6),
(112, 'All other converted paper product manufacturing', 'xml/newLoop$1MSector_112', 6),
(113, 'Printing', 'xml/newLoop$1MSector_113', 6),
(114, 'Support activities for printing', 'xml/newLoop$1MSector_114', 6),
(115, 'Petroleum refineries', 'xml/newLoop$1MSector_115', 7),
(116, 'Asphalt paving mixture and block manufacturing', 'xml/newLoop$1MSector_116', 7),
(117, 'Asphalt shingle and coating materials manufacturing', 'xml/newLoop$1MSector_117', 7),
(118, 'Petroleum lubricating oil and grease manufacturing', 'xml/newLoop$1MSector_118', 7),
(119, 'All other petroleum and coal products manufacturing', 'xml/newLoop$1MSector_119', 7),
(12, 'Cattle ranching and farming', 'xml/newLoop$1MSector_12', 1),
(120, 'Petrochemical manufacturing', 'xml/newLoop$1MSector_120', 7),
(121, 'Industrial gas manufacturing', 'xml/newLoop$1MSector_121', 7),
(122, 'Synthetic dye and pigment manufacturing', 'xml/newLoop$1MSector_122', 7),
(123, 'Alkalies and chlorine manufacturing', 'xml/newLoop$1MSector_123', 7),
(124, 'Carbon black manufacturing', 'xml/newLoop$1MSector_124', 7),
(125, 'All other basic inorganic chemical manufacturing', 'xml/newLoop$1MSector_125', 7),
(126, 'Other basic organic chemical manufacturing', 'xml/newLoop$1MSector_126', 7),
(128, 'Synthetic rubber manufacturing', 'xml/newLoop$1MSector_128', 8),
(129, 'Artificial and synthetic fibers and filaments manufacturing', 'xml/newLoop$1MSector_129', 8),
(130, 'Fertilizer Manufacturing', 'xml/newLoop$1MSector_130', 8),
(131, 'Pesticide and other agricultural chemical manufacturing', 'xml/newLoop$1MSector_131', 8),
(133, 'Pharmaceutical preparation manufacturing', 'xml/newLoop$1MSector_133', 8),
(134, 'In-vitro diagnostic substance manufacturing', 'xml/newLoop$1MSector_134', 8),
(135, 'Biological product (except diagnostic) Manufacturing', 'xml/newLoop$1MSector_135', 8),
(136, 'Paint and coating manufacturing', 'xml/newLoop$1MSector_136', 9),
(137, 'Adhesive manufacturing', 'xml/newLoop$1MSector_137', 9),
(138, 'Soap and cleaning compound manufacturing', 'xml/newLoop$1MSector_138', 9),
(139, 'Toilet preparation manufacturing', 'xml/newLoop$1MSector_139', 9),
(14, 'Animal production except cattle and poultry and eggs', 'xml/newLoop$1MSector_14', 1),
(140, 'Printing ink manufacturing', 'xml/newLoop$1MSector_140', 9),
(141, 'All other chemical product and preparation manufacturing', 'xml/newLoop$1MSector_141', 9),
(142, 'Plastics packaging materials film and sheet', 'xml/newLoop$1MSector_142', 10),
(143, 'Unlaminated plastics profile shape manufacturing', 'xml/newLoop$1MSector_143', 10),
(144, 'Plastics Pipe and Pipe Fitting Manufacturing', 'xml/newLoop$1MSector_144', 10),
(146, 'Polystyrene Foam Product Manufacturing', 'xml/newLoop$1MSector_146', 10),
(147, 'Urethane and Other Foam Product (except Polystyrene) Manufacturing', 'xml/newLoop$1MSector_147', 10),
(149, 'Other plastics product manufacturing', 'xml/newLoop$1MSector_149', 10),
(15, 'Logging', 'xml/newLoop$1MSector_15', 1),
(150, 'Tire manufacturing', 'xml/newLoop$1MSector_150', 10),
(151, 'Rubber and plastics hose and belting manufacturing', 'xml/newLoop$1MSector_151', 10),
(152, 'Other rubber product manufacturing', 'xml/newLoop$1MSector_152', 10),
(153, 'Pottery ceramics and plumbing fixture manufacturing', 'xml/newLoop$1MSector_153', 10),
(154, 'Brick tile and other structural clay product manufacturing', 'xml/newLoop$1MSector_154', 10),
(155, 'Clay and non-clay refractory manufacturing', 'xml/newLoop$1MSector_155', 10),
(156, 'Flat glass manufacturing', 'xml/newLoop$1MSector_156', 10),
(159, 'Glass Product Manufacturing Made of Purchased Glass', 'xml/newLoop$1MSector_159', 10),
(160, 'Cement manufacturing', 'xml/newLoop$1MSector_160', 10),
(161, 'Ready-mix concrete manufacturing', 'xml/newLoop$1MSector_161', 10),
(162, 'Concrete pipe brick and block manufacturing', 'xml/newLoop$1MSector_162', 10),
(163, 'Other concrete product manufacturing', 'xml/newLoop$1MSector_163', 10),
(165, 'Abrasive product manufacturing', 'xml/newLoop$1MSector_165', 10),
(167, 'Ground or treated minerals and earths manufacturing', 'xml/newLoop$1MSector_167', 10),
(168, 'Mineral wool manufacturing', 'xml/newLoop$1MSector_168', 10),
(169, 'Miscellaneous nonmetallic mineral products', 'xml/newLoop$1MSector_169', 10),
(17, 'Fishing', 'xml/newLoop$1MSector_17', 1),
(170, 'Iron and steel mills', 'xml/newLoop$1MSector_170', 11),
(171, 'Iron steel pipe and tube manufacturing from purchased steel', 'xml/newLoop$1MSector_171', 11),
(172, 'Secondary smelting and alloying of aluminum', 'xml/newLoop$1MSector_172', 11),
(173, 'Alumina refining and primary aluminum production', 'xml/newLoop$1MSector_173', 11),
(174, 'Aluminum product manufacturing from purchased aluminum', 'xml/newLoop$1MSector_174', 11),
(175, 'Primary smelting and refining of copper', 'xml/newLoop$1MSector_175', 11),
(176, 'Primary smelting and refining of nonferrous metal (except copper and aluminum)', 'xml/newLoop$1MSector_176', 11),
(178, 'Nonferrous metal (except copper and aluminum) rolling drawing extruding and alloying', 'xml/newLoop$1MSector_178', 11),
(179, 'Ferrous metal foundaries', 'xml/newLoop$1MSector_179', 11),
(18, 'Hunting and trapping', 'xml/newLoop$1MSector_18', 1),
(180, 'Nonferrous foundries', 'xml/newLoop$1MSector_180', 11),
(181, 'Custom roll forming', 'xml/newLoop$1MSector_181', 11),
(183, 'Crown closure and metal stamping manufacturing', 'xml/newLoop$1MSector_183', 11),
(184, 'Cutlery utensils pots and pans manufacturing', 'xml/newLoop$1MSector_184', 12),
(185, 'Handtool manufacturing', 'xml/newLoop$1MSector_185', 12),
(186, 'Plate work and fabricated structural product manufacturing', 'xml/newLoop$1MSector_186', 12),
(187, 'Ornamental and architectural metail products manufacturing', 'xml/newLoop$1MSector_187', 12),
(189, 'Metal tank heavy gauge manufacturing', 'xml/newLoop$1MSector_189', 12),
(19, 'Agriculture and forestry support activities', 'xml/newLoop$1MSector_19', 1),
(190, 'Metal can box and other container manufacturing', 'xml/newLoop$1MSector_190', 12),
(191, 'Hardware manufacturing', 'xml/newLoop$1MSector_191', 13),
(194, 'Turned product and screw nut and bolt manufacturing', 'xml/newLoop$1MSector_194', 13),
(196, 'Plumbing Fixture Fitting and Trim Manufacturing', 'xml/newLoop$1MSector_196', 13),
(197, 'Valve and fittings other than plumbing', 'xml/newLoop$1MSector_197', 13),
(199, 'Fabricated pipe and pipe fitting manufacturing', 'xml/newLoop$1MSector_199', 13),
(2, 'Grain farming', 'xml/newLoop$1MSector_2', 1),
(200, 'Ammunition manufacturing', 'xml/newLoop$1MSector_200', 13),
(201, 'Ordnance and accessories manufacturing', 'xml/newLoop$1MSector_201', 13),
(202, 'Other fabricated metal manufacturing', 'xml/newLoop$1MSector_202', 13),
(203, 'Farm machinery and equipment manufacturing', 'xml/newLoop$1MSector_203', 14),
(204, 'Lawn and garden equipment manufacturing', 'xml/newLoop$1MSector_204', 14),
(205, 'Construction machinery manufacturing', 'xml/newLoop$1MSector_205', 14),
(206, 'Mining and oil and gas field machinery manufacturing', 'xml/newLoop$1MSector_206', 14),
(207, 'Plastics and rubber industry machinery', 'xml/newLoop$1MSector_207', 14),
(209, 'Other industrial machinery manufacturing', 'xml/newLoop$1MSector_209', 14),
(21, 'Coal mining', 'xml/newLoop$1MSector_21', 2),
(213, 'Vending commerical industrial and office machinery manufacturing', 'xml/newLoop$1MSector_213', 14),
(214, 'Heating equipment (except warm air furnaces) manufacturing', 'xml/newLoop$1MSector_214', 14),
(215, 'Air conditioning refrigeration and warm air heating equipment manufacturing', 'xml/newLoop$1MSector_215', 14),
(216, 'Air purification and ventilation equipment manufacturing', 'xml/newLoop$1MSector_216', 14),
(218, 'Special tool die jig and fixture manufacturing', 'xml/newLoop$1MSector_218', 14),
(22, 'Iron ore mining', 'xml/newLoop$1MSector_22', 2),
(220, 'Metal cutting and forming machine tool manufacturing', 'xml/newLoop$1MSector_220', 14),
(221, 'Rolling mill and other metalworking machinery manufacturing', 'xml/newLoop$1MSector_221', 14),
(223, 'Speed Changer Industrial High-Speed Drive and Gear Manufacturing', 'xml/newLoop$1MSector_223', 14),
(225, 'Other engine equipment manufacturing', 'xml/newLoop$1MSector_225', 14),
(226, 'Pump and pumping equipment manufacturing', 'xml/newLoop$1MSector_226', 14),
(227, 'Air and gas compressor manufacturing', 'xml/newLoop$1MSector_227', 14),
(229, 'Power-driven handtool manufacturing', 'xml/newLoop$1MSector_229', 14),
(233, 'Process and oven not fluid power machinery', 'xml/newLoop$1MSector_233', 14),
(236, 'Computer terminals and other computer peripheral equipment manufacturing', 'xml/newLoop$1MSector_236', 15),
(238, 'Broadcast and wireless communications equipment', 'xml/newLoop$1MSector_238', 15),
(239, 'Other communications equipment manufacturing', 'xml/newLoop$1MSector_239', 15),
(240, 'Audio and video equipment manufacturing', 'xml/newLoop$1MSector_240', 15),
(241, 'Electron tube manufacturing', 'xml/newLoop$1MSector_241', 15),
(242, 'Bare printed circuit board manufacturing', 'xml/newLoop$1MSector_242', 15),
(243, 'Semiconductor and related device manufacturing', 'xml/newLoop$1MSector_243', 16),
(244, 'Electronic connector manufacturing', 'xml/newLoop$1MSector_244', 16),
(245, 'Printed circuit assembly (electronic assembly) manufacturing', 'xml/newLoop$1MSector_245', 16),
(246, 'Other electronic component manufacturing', 'xml/newLoop$1MSector_246', 16),
(247, 'Electronic capacitor resistor coil transformer and other inductor manufacturing', 'xml/newLoop$1MSector_247', 16),
(248, 'Electromedical apparatus manufacturing', 'xml/newLoop$1MSector_248', 16),
(249, 'Search detection and navigation instruments', 'xml/newLoop$1MSector_249', 16),
(251, 'Industrial process variable instruments', 'xml/newLoop$1MSector_251', 16),
(252, 'Totalizing fluid meters and counting devices', 'xml/newLoop$1MSector_252', 16),
(253, 'Electricity and signal testing instruments', 'xml/newLoop$1MSector_253', 16),
(254, 'Analytical laboratory instrument manufacturing', 'xml/newLoop$1MSector_254', 16),
(255, 'Irradiation apparatus manufacturing', 'xml/newLoop$1MSector_255', 16),
(256, 'Watch clock and other measuring and controlling device manufacturing', 'xml/newLoop$1MSector_256', 16),
(257, 'Magnetic and optical recording media manufacturing', 'xml/newLoop$1MSector_257', 16),
(260, 'Lighting fixture manufacturing', 'xml/newLoop$1MSector_260', 17),
(261, 'Small electrical appliance manufacturing', 'xml/newLoop$1MSector_261', 17),
(266, 'Electric power and specialty transformer manufacturing', 'xml/newLoop$1MSector_266', 17),
(268, 'Switchgear and switchboard apparatus manufacturing', 'xml/newLoop$1MSector_268', 17),
(269, 'Relay and industrial control manufacturing', 'xml/newLoop$1MSector_269', 17),
(27, 'Other nonmetallic mineral mining', 'xml/newLoop$1MSector_27', 2),
(273, 'Wiring device manufacturing', 'xml/newLoop$1MSector_273', 17),
(275, 'Miscellaneous electrical equipment manufacturing', 'xml/newLoop$1MSector_275', 17),
(276, 'Automobile Manufacturing', 'xml/newLoop$1MSector_276', 18),
(278, 'Heavy duty truck manufacturing', 'xml/newLoop$1MSector_278', 18),
(279, 'Motor vehicle body manufacturing', 'xml/newLoop$1MSector_279', 18),
(280, 'Truck trailer manufacturing', 'xml/newLoop$1MSector_280', 18),
(281, 'Motor home manufacturing', 'xml/newLoop$1MSector_281', 18),
(282, 'Travel trailer and camper manufacturing', 'xml/newLoop$1MSector_282', 18),
(284, 'Aircraft manufacturing', 'xml/newLoop$1MSector_284', 18),
(285, 'Aircraft engine and engine parts manufacturing', 'xml/newLoop$1MSector_285', 18),
(286, 'Other aircraft parts and equipment', 'xml/newLoop$1MSector_286', 18),
(287, 'Guided missile and space vehicle manufacturing', 'xml/newLoop$1MSector_287', 18),
(288, 'Other guided missile and space vehicle parts and auxiliary equipment manufacturing', 'xml/newLoop$1MSector_288', 18),
(289, 'Railroad rolling stock manufacturing', 'xml/newLoop$1MSector_289', 18),
(29, 'Support activities for oil and gas operations', 'xml/newLoop$1MSector_29', 2),
(290, 'Ship building and repairing', 'xml/newLoop$1MSector_290', 18),
(292, 'Motorcycle bicycle and parts manufacturing', 'xml/newLoop$1MSector_292', 18),
(293, 'Military armored vehicles and tank parts manufacturing', 'xml/newLoop$1MSector_293', 18),
(294, 'All other transportation equipment manufacturing', 'xml/newLoop$1MSector_294', 18),
(299, 'Metal and other household nonupholsetered furniture', 'xml/newLoop$1MSector_299', 19),
(30, 'Support activities for other mining', 'xml/newLoop$1MSector_30', 2),
(300, 'Custom architectural woodwork and millwork', 'xml/newLoop$1MSector_300', 19),
(302, 'Office furniture manufacturing', 'xml/newLoop$1MSector_302', 19),
(303, 'Mattress manufacturing', 'xml/newLoop$1MSector_303', 19),
(305, 'Laboratory apparatus and furniture manufacturing', 'xml/newLoop$1MSector_305', 19),
(308, 'Dental equipment and supplies manufacturing', 'xml/newLoop$1MSector_308', 19),
(309, 'Ophthalmic goods manufacturing', 'xml/newLoop$1MSector_309', 19),
(31, 'Power generation and supply', 'xml/newLoop$1MSector_31', 2),
(310, 'Dental laboratories', 'xml/newLoop$1MSector_310', 19),
(311, 'Jewelry and silverware manufacturing', 'xml/newLoop$1MSector_311', 20),
(313, 'Doll toy and game manufacturing', 'xml/newLoop$1MSector_313', 20),
(314, 'Office supplies (except paper) manufacturing', 'xml/newLoop$1MSector_314', 20),
(315, 'Sign manufacturing', 'xml/newLoop$1MSector_315', 20),
(316, 'Gasket packing and sealing device manufacturing', 'xml/newLoop$1MSector_316', 20),
(317, 'Musical instrument manufacturing', 'xml/newLoop$1MSector_317', 20),
(32, 'Natural gas distribution', 'xml/newLoop$1MSector_32', 2),
(320, 'Wholesale trade', 'xml/newLoop$1MSector_320', 21),
(321, 'Air transportation', 'xml/newLoop$1MSector_321', 21),
(322, 'Rail transportation', 'xml/newLoop$1MSector_322', 21),
(323, 'Water transportation', 'xml/newLoop$1MSector_323', 21),
(324, 'Truck transportation', 'xml/newLoop$1MSector_324', 21),
(325, 'Transit and ground passenger transportation', 'xml/newLoop$1MSector_325', 21),
(326, 'Pipeline transportation', 'xml/newLoop$1MSector_326', 21),
(327, 'Scenic and sightseeing transportation and support activities for transportation', 'xml/newLoop$1MSector_327', 21),
(328, 'Postal service', 'xml/newLoop$1MSector_328', 21),
(329, 'Couriers and messengers', 'xml/newLoop$1MSector_329', 21),
(330, 'Warehousing and storage', 'xml/newLoop$1MSector_330', 21),
(331, 'Retail trade', 'xml/newLoop$1MSector_331', 21),
(332, 'Newspaper publishers', 'xml/newLoop$1MSector_332', 21),
(334, 'Book publishers', 'xml/newLoop$1MSector_334', 21),
(335, 'Directory mailing list and other publishers', 'xml/newLoop$1MSector_335', 21),
(336, 'Software publishers', 'xml/newLoop$1MSector_336', 21),
(337, 'Motion picture and video industries', 'xml/newLoop$1MSector_337', 21),
(338, 'Sound recording industries', 'xml/newLoop$1MSector_338', 21),
(34, 'Nonresidential commercial and health care structures', 'xml/newLoop$1MSector_34', 3),
(340, 'Cable and other subscription programming', 'xml/newLoop$1MSector_340', 21),
(341, 'Internet publishing and broadcasting', 'xml/newLoop$1MSector_341', 21),
(342, 'Telecommunications', 'xml/newLoop$1MSector_342', 21),
(344, 'Data processing hosting and related services', 'xml/newLoop$1MSector_344', 21),
(345, 'Other information services', 'xml/newLoop$1MSector_345', 21),
(346, 'Nondepository credit intermediation and related activities', 'xml/newLoop$1MSector_346', 22),
(347, 'Securities commodity contracts investments', 'xml/newLoop$1MSector_347', 22),
(348, 'Insurance carriers', 'xml/newLoop$1MSector_348', 22),
(35, 'Nonresidential manufacturing structures', 'xml/newLoop$1MSector_35', 3),
(352, 'Real estate', 'xml/newLoop$1MSector_352', 22),
(353, 'Automotive equipment rental and leasing', 'xml/newLoop$1MSector_353', 22),
(354, 'Video tape and disc rental', 'xml/newLoop$1MSector_354', 22),
(355, 'Commercial and industrial machinery and equipment rental and leasing', 'xml/newLoop$1MSector_355', 22),
(356, 'General and consumer goods rental except video tapes and discs', 'xml/newLoop$1MSector_356', 22),
(358, 'Legal services', 'xml/newLoop$1MSector_358', 23),
(359, 'Accounting and bookkeeping services', 'xml/newLoop$1MSector_359', 23),
(36, 'Other nonresidential structures', 'xml/newLoop$1MSector_36', 3),
(360, 'Architectural and engineering services', 'xml/newLoop$1MSector_360', 23),
(361, 'Specialized design services', 'xml/newLoop$1MSector_361', 23),
(362, 'Custom computer programming services', 'xml/newLoop$1MSector_362', 23),
(363, 'Computer systems design services', 'xml/newLoop$1MSector_363', 23),
(364, 'Other computer related services including facilities management', 'xml/newLoop$1MSector_364', 23),
(365, 'Management consulting services', 'xml/newLoop$1MSector_365', 23),
(367, 'Scientific research and development services', 'xml/newLoop$1MSector_367', 23),
(368, 'Advertising and related services', 'xml/newLoop$1MSector_368', 23),
(370, 'Veterinary services', 'xml/newLoop$1MSector_370', 23),
(371, 'All other miscellaneous professional and technical services', 'xml/newLoop$1MSector_371', 23),
(372, 'Management of companies and enterprises', 'xml/newLoop$1MSector_372', 24),
(373, 'Office administrative services', 'xml/newLoop$1MSector_373', 24),
(374, 'Facilities support services', 'xml/newLoop$1MSector_374', 24),
(375, 'Employment services', 'xml/newLoop$1MSector_375', 24),
(377, 'Travel arrangement and reservation services', 'xml/newLoop$1MSector_377', 24),
(378, 'Investigation and security services', 'xml/newLoop$1MSector_378', 24),
(379, 'Services to buildings and dwellings', 'xml/newLoop$1MSector_379', 24),
(38, 'Other residential structures', 'xml/newLoop$1MSector_38', 3),
(380, 'Other support services', 'xml/newLoop$1MSector_380', 24),
(382, 'Elementary and secondary schools', 'xml/newLoop$1MSector_382', 25),
(384, 'Other educational services', 'xml/newLoop$1MSector_384', 25),
(387, 'Healthcare and social assistance', 'xml/newLoop$1MSector_387', 25),
(389, 'Nursing and residential care facilities', 'xml/newLoop$1MSector_389', 25),
(39, 'Nonresidential maintenance and repair', 'xml/newLoop$1MSector_39', 3),
(391, 'Child day care services', 'xml/newLoop$1MSector_391', 25),
(392, 'Individual and family services', 'xml/newLoop$1MSector_392', 25),
(394, 'Spectator sports', 'xml/newLoop$1MSector_394', 26),
(395, 'Independent artists writers and performers', 'xml/newLoop$1MSector_395', 26),
(397, 'Museums historical sites zoos and parks', 'xml/newLoop$1MSector_397', 26),
(398, 'Fitness and recreational sports centers', 'xml/newLoop$1MSector_398', 26),
(399, 'Bowling centers', 'xml/newLoop$1MSector_399', 26),
(4, 'Tree nut farming', 'xml/newLoop$1MSector_4', 1),
(400, 'Amusement parks and arcades', 'xml/newLoop$1MSector_400', 26),
(401, 'Other amusement gambling and recreation industries', 'xml/newLoop$1MSector_401', 26),
(403, 'Other accommodations', 'xml/newLoop$1MSector_403', 26),
(405, 'Car washes', 'xml/newLoop$1MSector_405', 27),
(406, 'Automotive repair and maintenance except car washes', 'xml/newLoop$1MSector_406', 27),
(407, 'Electronic equipment repair and maintenance', 'xml/newLoop$1MSector_407', 27),
(408, 'Commercial machinery repair and maintenance', 'xml/newLoop$1MSector_408', 27),
(409, 'Household goods repair and maintenance', 'xml/newLoop$1MSector_409', 27),
(410, 'Personal care services', 'xml/newLoop$1MSector_410', 27),
(411, 'Death care services', 'xml/newLoop$1MSector_411', 27),
(412, 'Drycleaning and laundry services', 'xml/newLoop$1MSector_412', 27),
(413, 'Other personal services', 'xml/newLoop$1MSector_413', 27),
(414, 'Religious organizations', 'xml/newLoop$1MSector_414', 27),
(415, 'Grantmaking giving and social advocacy organizations', 'xml/newLoop$1MSector_415', 27),
(416, 'Civic social professional and similar organizations', 'xml/newLoop$1MSector_416', 27),
(42, 'Other animal food manufacturing', 'xml/newLoop$1MSector_42', 4),
(43, 'Flour milling and malt manufacturing', 'xml/newLoop$1MSector_43', 4),
(44, 'Wet corn milling', 'xml/newLoop$1MSector_44', 4),
(45, 'Fats and oils refining and blending', 'xml/newLoop$1MSector_45', 4),
(46, 'Soybean and other oilseed processing', 'xml/newLoop$1MSector_46', 4),
(48, 'Beet sugar manufacturing', 'xml/newLoop$1MSector_48', 4),
(49, 'Sugar cane mills and refining', 'xml/newLoop$1MSector_49', 4),
(5, 'Fruit farming', 'xml/newLoop$1MSector_5', 1),
(50, 'Confectionery manufacturing from cacao beans', 'xml/newLoop$1MSector_50', 4),
(51, 'Confectionery manufacturing from purchased chocolate', 'xml/newLoop$1MSector_51', 4),
(52, 'Nonchocolate confectionery manufacturing', 'xml/newLoop$1MSector_52', 4),
(53, 'Frozen food manufacturing', 'xml/newLoop$1MSector_53', 4),
(54, 'Fruit and vegetable canning pickling and drying', 'xml/newLoop$1MSector_54', 4),
(55, 'Cheese manufacturing', 'xml/newLoop$1MSector_55', 4),
(56, 'Dry condensed and evaporated dairy products', 'xml/newLoop$1MSector_56', 4),
(57, 'Fluid milk and butter manufacturing', 'xml/newLoop$1MSector_57', 4),
(6, 'Greenhouse and nursery production', 'xml/newLoop$1MSector_6', 1),
(60, 'Animal (except poultry) slaughtering and processing', 'xml/newLoop$1MSector_60', 4),
(61, 'Seafood product preparation and packaging', 'xml/newLoop$1MSector_61', 4),
(65, 'Snack food manufacturing', 'xml/newLoop$1MSector_65', 4),
(66, 'Coffee and tea manufacturing', 'xml/newLoop$1MSector_66', 4),
(67, 'Flavoring syrup and concentrate manufacturing', 'xml/newLoop$1MSector_67', 4),
(68, 'Seasoning and dressing manufacturing', 'xml/newLoop$1MSector_68', 4),
(69, 'All other food manufacturing', 'xml/newLoop$1MSector_69', 4),
(70, 'Soft drink and ice manufacturing', 'xml/newLoop$1MSector_70', 4),
(71, 'Breweries', 'xml/newLoop$1MSector_71', 4),
(72, 'Wineries', 'xml/newLoop$1MSector_72', 4),
(73, 'Distilleries', 'xml/newLoop$1MSector_73', 4),
(74, 'Tobacco product manufacturing', 'xml/newLoop$1MSector_74', 4),
(75, 'Fiber yarn and thread mills', 'xml/newLoop$1MSector_75', 5),
(76, 'Broadwoven fabric mills', 'xml/newLoop$1MSector_76', 5),
(77, 'Narrow fabric mills and schiffli embroidery', 'xml/newLoop$1MSector_77', 5),
(78, 'Nonwoven fabric mills', 'xml/newLoop$1MSector_78', 5),
(79, 'Knit fabric mills', 'xml/newLoop$1MSector_79', 5),
(8, 'Cotton farming', 'xml/newLoop$1MSector_8', 1),
(81, 'Fabric coating mills', 'xml/newLoop$1MSector_81', 5),
(82, 'Carpet and rug mills', 'xml/newLoop$1MSector_82', 5),
(83, 'Curtain and linen mills', 'xml/newLoop$1MSector_83', 5),
(84, 'Textile bag and canvas mills', 'xml/newLoop$1MSector_84', 5),
(85, 'All other miscellaneous textile product mills', 'xml/newLoop$1MSector_85', 5),
(87, 'Cut and sew apparel contractors', 'xml/newLoop$1MSector_87', 5),
(9, 'Sugarcane and sugar beet farming', 'xml/newLoop$1MSector_9', 1),
(90, 'Other cut and sew apparel manufacturing', 'xml/newLoop$1MSector_90', 5),
(91, 'Accessories and other apparel manufacturing', 'xml/newLoop$1MSector_91', 5),
(96, 'Reconstituted wood product manufacturing', 'xml/newLoop$1MSector_96', 6),
(97, 'Veneer and plywood manufacturing', 'xml/newLoop$1MSector_97', 6),
(99, 'Wood windows and doors and millwork', 'xml/newLoop$1MSector_99', 6),
(1, 'Oilseed farming', 'xml/newLoop$1MSector_1', 1),
(10, 'All other crop farming', 'xml/newLoop$1MSector_10', 1),
(102, 'Prefabricated wood building manufacturing', 'xml/newLoop$1MSector_102', 6),
(127, 'Plastics material and resin manufacturing', 'xml/newLoop$1MSector_127', 8),
(13, 'Poultry and egg production', 'xml/newLoop$1MSector_13', 1),
(132, 'Medicinal and botanical manufacturing', 'xml/newLoop$1MSector_132', 8),
(145, 'Laminated plastics plate sheet and shapes', 'xml/newLoop$1MSector_145', 10),
(148, 'Plastics bottle manufacturing', 'xml/newLoop$1MSector_148', 10),
(157, 'Other pressed and blown glass and glassware manufacturing', 'xml/newLoop$1MSector_157', 10),
(158, 'Glass container manufacturing', 'xml/newLoop$1MSector_158', 10),
(16, 'Forest nurseries forest products and timber tracts', 'xml/newLoop$1MSector_16', 1),
(164, 'Lime and gypsum product manufacturing', 'xml/newLoop$1MSector_164', 10),
(166, 'Cut stone and stone product manufacturing', 'xml/newLoop$1MSector_166', 10),
(177, 'Copper rolling drawing extruding and alloying', 'xml/newLoop$1MSector_177', 11),
(182, 'All other forging stamping and sintering', 'xml/newLoop$1MSector_182', 11),
(188, 'Power boiler and heat exchanger manufacturing', 'xml/newLoop$1MSector_188', 12),
(192, 'Spring and wire product manufacturing', 'xml/newLoop$1MSector_192', 13),
(193, 'Machine shops', 'xml/newLoop$1MSector_193', 13),
(195, 'Coating engraving heat treating and allied activities', 'xml/newLoop$1MSector_195', 13),
(198, 'Ball and roller bearing manufacturing', 'xml/newLoop$1MSector_198', 13),
(20, 'Oil and gas extraction', 'xml/newLoop$1MSector_20', 2),
(208, 'Semiconductor machinery manufacturing', 'xml/newLoop$1MSector_208', 14),
(210, 'Optical instrument and lens manufacturing', 'xml/newLoop$1MSector_210', 14),
(211, 'Photographic and photocopying equipment manufacturing', 'xml/newLoop$1MSector_211', 14),
(212, 'Other commercial and service industry machinery manufacturing', 'xml/newLoop$1MSector_212', 14),
(217, 'Industrial mold manufacturing', 'xml/newLoop$1MSector_217', 14),
(219, 'Cutting tool and machine tool accessory manufacturing', 'xml/newLoop$1MSector_219', 14),
(222, 'Turbine and turbine generator set units manufacturing', 'xml/newLoop$1MSector_222', 14),
(224, 'Mechanical Power Transmission Equipment Manufacturing', 'xml/newLoop$1MSector_224', 14),
(228, 'Material handling equipment manufacturing', 'xml/newLoop$1MSector_228', 14),
(23, 'Copper nickel lead and zinc mining', 'xml/newLoop$1MSector_23', 2),
(230, 'Packaging machinery manufacturing', 'xml/newLoop$1MSector_230', 14),
(231, 'Industrial process furnace and oven manufacturing', 'xml/newLoop$1MSector_231', 14),
(232, 'Fluid power process machinery', 'xml/newLoop$1MSector_232', 14),
(234, 'Electronic computer manufacturing', 'xml/newLoop$1MSector_234', 15),
(235, 'Computer storage device manufacturing', 'xml/newLoop$1MSector_235', 15),
(237, 'Telephone apparatus manufacturing', 'xml/newLoop$1MSector_237', 15),
(24, 'Gold silver and other metal ore mining', 'xml/newLoop$1MSector_24', 2),
(25, 'Stone mining and quarrying', 'xml/newLoop$1MSector_25', 2),
(250, 'Automatic environmental control manufacturing', 'xml/newLoop$1MSector_250', 16),
(258, 'Software audio and video reproduction', 'xml/newLoop$1MSector_258', 16),
(259, 'Electric lamp bulb and part manufacturing', 'xml/newLoop$1MSector_259', 17),
(26, 'Sand gravel clay and refractory mining', 'xml/newLoop$1MSector_26', 2),
(262, 'Household cooking appliance manufacturing', 'xml/newLoop$1MSector_262', 17),
(263, 'Household refrigerator and home freezer manufacturing', 'xml/newLoop$1MSector_263', 17),
(264, 'Household laundry equipment manufacturing', 'xml/newLoop$1MSector_264', 17),
(265, 'Other major household appliance manufacturing', 'xml/newLoop$1MSector_265', 17),
(267, 'Motor and generator manufacturing', 'xml/newLoop$1MSector_267', 17),
(270, 'Storage battery manufacturing', 'xml/newLoop$1MSector_270', 17),
(271, 'Primary battery manufacturing', 'xml/newLoop$1MSector_271', 17),
(272, 'Communication and energy wire and cable manufacturing', 'xml/newLoop$1MSector_272', 17),
(274, 'Carbon and graphite product manufacturing', 'xml/newLoop$1MSector_274', 17),
(277, 'Light Truck and Utility Vehicle Manufacturing', 'xml/newLoop$1MSector_277', 18),
(28, 'Drilling oil and gas wells', 'xml/newLoop$1MSector_28', 2),
(283, 'Motor vehicle parts manufacturing', 'xml/newLoop$1MSector_283', 18),
(291, 'Boat building', 'xml/newLoop$1MSector_291', 18),
(295, 'Wood kitchen cabinet and countertop manufacturing', 'xml/newLoop$1MSector_295', 19),
(296, 'Upholstered household furniture manufacturing', 'xml/newLoop$1MSector_296', 19),
(297, 'Nonupholstered wood household furniture manufacturing', 'xml/newLoop$1MSector_297', 19),
(298, 'Institutional furniture manufacturing', 'xml/newLoop$1MSector_298', 19),
(3, 'Vegetable and melon farming', 'xml/newLoop$1MSector_3', 1),
(301, 'Showcases partitions shelving and lockers', 'xml/newLoop$1MSector_301', 19),
(304, 'Blind and shade manufacturing', 'xml/newLoop$1MSector_304', 19),
(306, 'Surgical and medical instrument manufacturing', 'xml/newLoop$1MSector_306', 19),
(307, 'Surgical appliance and supplies manufacturing', 'xml/newLoop$1MSector_307', 19),
(312, 'Sporting and athletic goods manufacturing', 'xml/newLoop$1MSector_312', 20),
(318, 'Broom brush and mop manufacturing', 'xml/newLoop$1MSector_318', 20),
(319, 'All other miscellaneous manufacturing', 'xml/newLoop$1MSector_319', 20),
(33, 'Water sewage and other systems', 'xml/newLoop$1MSector_33', 2),
(333, 'Periodical publishers', 'xml/newLoop$1MSector_333', 21),
(339, 'Radio and television broadcasting', 'xml/newLoop$1MSector_339', 21),
(343, 'Internet service providers and web search portals', 'xml/newLoop$1MSector_343', 21),
(349, 'Insurance agencies brokerages and related', 'xml/newLoop$1MSector_349', 22),
(350, 'Funds trusts and other financial vehicles', 'xml/newLoop$1MSector_350', 22),
(351, 'Monetary authorities and depository credit intermediation', 'xml/newLoop$1MSector_351', 22),
(357, 'Lessors of nonfinancial intangible assets', 'xml/newLoop$1MSector_357', 22),
(366, 'Environmental and other technical consulting services', 'xml/newLoop$1MSector_366', 23),
(369, 'Photographic services', 'xml/newLoop$1MSector_369', 23),
(37, 'Residential permanent site single- and multi-family structures', 'xml/newLoop$1MSector_37', 3),
(376, 'Business support services', 'xml/newLoop$1MSector_376', 24),
(381, 'Waste management and remediation services', 'xml/newLoop$1MSector_381', 24),
(383, 'Colleges universities and junior colleges', 'xml/newLoop$1MSector_383', 25),
(385, 'Home health care services', 'xml/newLoop$1MSector_385', 25),
(386, 'Offices of physicians dentists and other health practitioners', 'xml/newLoop$1MSector_386', 25),
(388, 'Hospitals', 'xml/newLoop$1MSector_388', 25),
(390, 'Community food housing and other relief services incl rehabilitation services', 'xml/newLoop$1MSector_390', 25),
(393, 'Performing arts companies', 'xml/newLoop$1MSector_393', 26),
(396, 'Promoters of performing arts and sports and agents for public figures', 'xml/newLoop$1MSector_396', 26),
(40, 'Residential maintenance and repair', 'xml/newLoop$1MSector_40', 3),
(402, 'Hotels and motels including casino hotels', 'xml/newLoop$1MSector_402', 26),
(404, 'Food services and drinking places', 'xml/newLoop$1MSector_404', 26),
(41, 'Dog and cat food manufacturing', 'xml/newLoop$1MSector_41', 4),
(47, 'Breakfast cereal manufacturing', 'xml/newLoop$1MSector_47', 4),
(58, 'Ice cream and frozen dessert manufacturing', 'xml/newLoop$1MSector_58', 4),
(59, 'Poultry processing', 'xml/newLoop$1MSector_59', 4),
(62, 'Bread and bakery product manufacturing', 'xml/newLoop$1MSector_62', 4),
(63, 'Cookie cracker and pasta manufacturing', 'xml/newLoop$1MSector_63', 4),
(64, 'Tortilla manufacturing', 'xml/newLoop$1MSector_64', 4),
(7, 'Tobacco farming', 'xml/newLoop$1MSector_7', 1),
(80, 'Textile and fabric finishing mills', 'xml/newLoop$1MSector_80', 5),
(86, 'Hosiery and sock mills', 'xml/newLoop$1MSector_86', 5),
(92, 'Leather and hide tanning and finishing', 'xml/newLoop$1MSector_92', 5),
(93, 'Footwear manufacturing', 'xml/newLoop$1MSector_93', 5),
(94, 'Other leather and allied product manufacturing', 'xml/newLoop$1MSector_94', 5),
(95, 'Sawmills and wood preservation', 'xml/newLoop$1MSector_95', 6),
(98, 'Engineered wood member and truss manufacturing', 'xml/newLoop$1MSector_98', 6);