Permalink
Fetching contributors…
Cannot retrieve contributors at this time
14152 lines (14096 sloc) 711 KB
-- This SQL script initializes a database for the XBRL Abstract Model using Microsoft SQL Server (MSSQL)
-- (c) Copyright 2013 Mark V Systems Limited, California US, All rights reserved.
-- Mark V copyright applies to this software, which is licensed according to the terms of Arelle(r).
-- note that MS SQL Server index limit is 900 characters (450 nchars, 441 together with a bigint)
-- all index nvarchar fields reduced to 450 (sufficient for SEC filings)
set quoted_identifier on;
GO
-- drop tables before sequences, then drop seqences
IF OBJECT_ID('entity', 'U') IS NOT NULL DROP TABLE "entity";
IF OBJECT_ID('former_entity', 'U') IS NOT NULL DROP TABLE "former_entity";
IF OBJECT_ID('filing', 'U') IS NOT NULL DROP TABLE "filing";
IF OBJECT_ID('report', 'U') IS NOT NULL DROP TABLE "report";
IF OBJECT_ID('document', 'U') IS NOT NULL DROP TABLE "document";
IF OBJECT_ID('referenced_documents', 'U') IS NOT NULL DROP TABLE "referenced_documents";
IF OBJECT_ID('aspect', 'U') IS NOT NULL DROP TABLE "aspect";
IF OBJECT_ID('data_type', 'U') IS NOT NULL DROP TABLE "data_type";
IF OBJECT_ID('role_type', 'U') IS NOT NULL DROP TABLE "role_type";
IF OBJECT_ID('arcrole_type', 'U') IS NOT NULL DROP TABLE "arcrole_type";
IF OBJECT_ID('used_on', 'U') IS NOT NULL DROP TABLE "used_on";
IF OBJECT_ID('resource', 'U') IS NOT NULL DROP TABLE "resource";
IF OBJECT_ID('relationship_set', 'U') IS NOT NULL DROP TABLE "relationship_set";
IF OBJECT_ID('root', 'U') IS NOT NULL DROP TABLE "root";
IF OBJECT_ID('relationship', 'U') IS NOT NULL DROP TABLE "relationship";
IF OBJECT_ID('data_point', 'U') IS NOT NULL DROP TABLE "data_point";
IF OBJECT_ID('entity_identifier', 'U') IS NOT NULL DROP TABLE "entity_identifier";
IF OBJECT_ID('period', 'U') IS NOT NULL DROP TABLE "period";
IF OBJECT_ID('unit', 'U') IS NOT NULL DROP TABLE "unit";
IF OBJECT_ID('unit_measure', 'U') IS NOT NULL DROP TABLE "unit_measure";
IF OBJECT_ID('aspect_value_selection_set', 'U') IS NOT NULL DROP TABLE "aspect_value_selection_set";
IF OBJECT_ID('aspect_value_selection', 'U') IS NOT NULL DROP TABLE "aspect_value_selection";
IF OBJECT_ID('table_data_points', 'U') IS NOT NULL DROP TABLE "table_data_points";
IF OBJECT_ID('message', 'U') IS NOT NULL DROP TABLE "message";
IF OBJECT_ID('message_reference', 'U') IS NOT NULL DROP TABLE "message_reference";
IF OBJECT_ID('industry', 'U') IS NOT NULL DROP TABLE "industry";
IF OBJECT_ID('industry_level', 'U') IS NOT NULL DROP TABLE "industry_level";
IF OBJECT_ID('industry_structure', 'U') IS NOT NULL DROP TABLE "industry_structure";
GO
IF OBJECT_ID('seq_entity', 'SO') IS NOT NULL DROP SEQUENCE seq_entity;
IF OBJECT_ID('seq_filing', 'SO') IS NOT NULL DROP SEQUENCE seq_filing;
IF OBJECT_ID('seq_object', 'SO') IS NOT NULL DROP SEQUENCE seq_object;
IF OBJECT_ID('seq_relationship_set', 'SO') IS NOT NULL DROP SEQUENCE seq_relationship_set;
IF OBJECT_ID('seq_message', 'SO') IS NOT NULL DROP SEQUENCE seq_message;
GO
CREATE SEQUENCE seq_entity AS bigint START WITH 1 INCREMENT BY 1;
GO
ALTER SEQUENCE seq_entity RESTART;
GO
CREATE TABLE entity (
entity_id bigint default next value for seq_entity,
legal_entity_number nvarchar(30), -- LEI
file_number nvarchar(30), -- authority internal number
reference_number nvarchar(30), -- external code, e.g. CIK
tax_number nvarchar(30),
standard_industry_code integer NOT NULL DEFAULT -1,
name nvarchar(1024),
legal_state nvarchar(32),
phone nvarchar(32),
phys_addr1 nvarchar(128), -- physical (real) address
phys_addr2 nvarchar(128),
phys_city nvarchar(128),
phys_state nvarchar(128),
phys_zip nvarchar(32),
phys_country nvarchar(16),
mail_addr1 nvarchar(128), -- mailing (postal) address
mail_addr2 nvarchar(128),
mail_city nvarchar(128),
mail_state nvarchar(128),
mail_zip nvarchar(32),
mail_country nvarchar(16),
fiscal_year_end nvarchar(6),
filer_category nvarchar(128),
public_float float(53),
trading_symbol nvarchar(32)
);
CREATE INDEX entity_index01 ON entity (entity_id);
CREATE INDEX entity_index02 ON entity (file_number);
CREATE INDEX entity_index03 ON entity (reference_number);
CREATE INDEX entity_index04 ON entity (legal_entity_number);
CREATE INDEX entity_index05 ON entity (legal_entity_number, file_number);
CREATE TABLE "former_entity" (
entity_id bigint NOT NULL,
date_changed date,
former_name nvarchar(1024)
);
CREATE INDEX former_entity_index02 ON "former_entity" (entity_id);
CREATE SEQUENCE seq_filing AS bigint START WITH 1 INCREMENT BY 1;
GO
ALTER SEQUENCE seq_filing RESTART;
GO
CREATE TABLE "filing" (
filing_id bigint default next value for seq_filing, -- IDs are null on insert because trigger fires AFTER insert in MS SQL
filing_number nvarchar(30) NOT NULL,
form_type nvarchar(30),
entity_id bigint NOT NULL,
reference_number nvarchar(30), -- external code, e.g. CIK
accepted_timestamp datetime NOT NULL,
is_most_current bit NOT NULL DEFAULT 0,
filing_date datetime NOT NULL, -- no date in MSSQL 2005
creation_software nvarchar(max),
authority_html_url nvarchar(max),
entry_url nvarchar(max)
);
CREATE INDEX filing_index01 ON "filing" (filing_id);
CREATE UNIQUE INDEX filing_index02 ON "filing" (filing_number);
GO
-- object sequence can be any element that can terminate a relationship (aspect, type, resource, data point, document, role type, ...)
-- or be a reference of a message (report or any of above)
CREATE SEQUENCE seq_object AS bigint START WITH 1 INCREMENT BY 1;
GO
ALTER SEQUENCE seq_object RESTART;
GO
CREATE TABLE "report" (
report_id bigint DEFAULT NEXT VALUE FOR seq_object,
filing_id bigint NOT NULL,
report_data_doc_id bigint, -- instance or primary inline document
report_schema_doc_id bigint, -- extension schema of the report (primary)
agency_schema_doc_id bigint, -- agency schema (receiving authority)
standard_schema_doc_id bigint -- e.g., IFRS, XBRL-US, or EDInet schema
);
CREATE INDEX report_index01 ON "report" (report_id);
CREATE INDEX report_index02 ON "report" (filing_id);
GO
CREATE TABLE "document" (
document_id bigint DEFAULT NEXT VALUE FOR seq_object,
document_url nvarchar(450) NOT NULL,
document_type nvarchar(32), -- ModelDocument.Type string value
namespace nvarchar(450) -- targetNamespace if schema else NULL
);
CREATE INDEX document_index01 ON "document" (document_id);
CREATE INDEX document_index02 ON "document" (document_url);
-- documents referenced by report or document
GO
CREATE TABLE "referenced_documents" (
object_id bigint,
document_id bigint NOT NULL
);
CREATE INDEX referenced_documents_index01 ON "referenced_documents" (object_id);
CREATE UNIQUE INDEX referenced_documents_index02 ON "referenced_documents" (object_id, document_id);
GO
-- all fields shortened for MSFT's 900 character index limitation
CREATE TABLE "aspect" (
aspect_id bigint DEFAULT NEXT VALUE FOR seq_object,
document_id bigint NOT NULL,
xml_id nvarchar(max),
xml_child_seq nvarchar(450),
qname nvarchar(450) NOT NULL, -- clark notation qname
name nvarchar(450) NOT NULL, -- local qname
datatype_id bigint,
base_type nvarchar(128), -- xml base type if any
substitution_group_aspect_id bigint,
balance nvarchar(16),
period_type nvarchar(16),
abstract bit NOT NULL,
nillable bit NOT NULL,
is_numeric bit NOT NULL,
is_monetary bit NOT NULL,
is_text_block bit NOT NULL
);
CREATE INDEX aspect_index01 ON "aspect" (aspect_id);
CREATE INDEX aspect_index02 ON "aspect" (qname);
GO
CREATE TABLE "data_type" (
data_type_id bigint DEFAULT NEXT VALUE FOR seq_object,
document_id bigint NOT NULL,
xml_id nvarchar(max),
xml_child_seq nvarchar(450),
qname nvarchar(450) NOT NULL, -- clark notation qname
name nvarchar(450) NOT NULL, -- local qname
base_type nvarchar(128), -- xml base type if any
derived_from_type_id bigint
);
CREATE INDEX data_type_index01 ON "data_type" (data_type_id);
CREATE INDEX data_type_index02 ON "data_type" (qname);
GO
CREATE TABLE "role_type" (
role_type_id bigint DEFAULT NEXT VALUE FOR seq_object,
document_id bigint NOT NULL,
xml_id nvarchar(max),
xml_child_seq nvarchar(450),
role_uri nvarchar(450) NOT NULL,
definition nvarchar(max)
);
CREATE INDEX role_type_index01 ON "role_type" (role_type_id);
CREATE INDEX role_type_index02 ON "role_type" (role_uri);
GO
CREATE TABLE "arcrole_type" (
arcrole_type_id bigint DEFAULT NEXT VALUE FOR seq_object,
document_id bigint NOT NULL,
xml_id nvarchar(max),
xml_child_seq nvarchar(450),
arcrole_uri nvarchar(450) NOT NULL,
cycles_allowed nvarchar(10) NOT NULL,
definition nvarchar(max)
);
CREATE INDEX arcrole_type_index01 ON "arcrole_type" (arcrole_type_id);
CREATE INDEX arcrole_type_index02 ON "arcrole_type" (arcrole_uri);
GO
CREATE TABLE "used_on" (
object_id bigint NOT NULL,
aspect_id bigint NOT NULL
);
CREATE INDEX used_on_index01 ON "used_on" (object_id);
CREATE UNIQUE INDEX used_on_index02 ON "used_on" (object_id, aspect_id);
GO
CREATE TABLE "resource" (
resource_id bigint DEFAULT NEXT VALUE FOR seq_object,
document_id bigint NOT NULL,
xml_id nvarchar(max),
xml_child_seq nvarchar(441),
qname nvarchar(450) NOT NULL, -- clark notation qname (do we need this?)
role nvarchar(450),
value nvarchar(max),
xml_lang nvarchar(16)
);
CREATE INDEX resource_index01 ON "resource" (resource_id);
CREATE INDEX resource_index02 ON "resource" (document_id, xml_child_seq);
GO
CREATE SEQUENCE seq_relationship_set AS bigint START WITH 1 INCREMENT BY 1;
GO
ALTER SEQUENCE seq_relationship_set RESTART;
GO
CREATE TABLE "relationship_set" (
relationship_set_id bigint DEFAULT NEXT VALUE FOR seq_relationship_set,
document_id bigint NOT NULL,
arc_qname nvarchar(450) NOT NULL, -- clark notation qname (do we need this?)
link_qname nvarchar(450) NOT NULL, -- clark notation qname (do we need this?)
arc_role nvarchar(450) NOT NULL,
link_role nvarchar(450) NOT NULL
);
CREATE INDEX relationship_set_index01 ON "relationship_set" (relationship_set_id);
CREATE INDEX relationship_set_index02 ON "relationship_set" (document_id);
CREATE INDEX relationship_set_index03 ON "relationship_set" (arc_role);
CREATE INDEX relationship_set_index04 ON "relationship_set" (link_role);
GO
CREATE TABLE root (
relationship_set_id bigint NOT NULL,
relationship_id bigint NOT NULL
);
CREATE INDEX root_index01 ON "root" (relationship_set_id);
GO
CREATE TABLE "relationship" (
relationship_id bigint DEFAULT NEXT VALUE FOR seq_object,
document_id bigint NOT NULL,
xml_id nvarchar(max),
xml_child_seq nvarchar(441),
relationship_set_id bigint NOT NULL,
reln_order float(24),
from_id bigint,
to_id bigint,
calculation_weight float(24),
tree_sequence integer NOT NULL,
tree_depth integer NOT NULL,
preferred_label_role nvarchar(1024)
);
CREATE INDEX relationship_index01 ON "relationship" (relationship_id);
CREATE INDEX relationship_index02 ON "relationship" (relationship_set_id);
CREATE INDEX relationship_index03 ON "relationship" (relationship_set_id, tree_depth);
CREATE INDEX relationship_index04 ON "relationship" (relationship_set_id, document_id, xml_child_seq);
CREATE INDEX relationship_index05 ON "relationship" (from_id);
GO
CREATE TABLE "data_point" (
datapoint_id bigint DEFAULT NEXT VALUE FOR seq_object,
report_id bigint,
document_id bigint NOT NULL, -- multiple inline documents are sources of data points
xml_id nvarchar(max),
xml_child_seq nvarchar(441),
source_line integer,
parent_datapoint_id bigint, -- id of tuple parent
aspect_id bigint NOT NULL,
context_xml_id nvarchar(max), -- 693 max length observed in 2012-2014)
entity_identifier_id bigint,
period_id bigint,
aspect_value_selection_id bigint,
unit_id bigint,
is_nil bit DEFAULT 0,
precision_value nvarchar(16),
decimals_value nvarchar(16),
effective_value float(53),
value nvarchar(max)
);
CREATE INDEX datapoint_index01 ON "data_point" (datapoint_id);
CREATE INDEX datapoint_index02 ON "data_point" (document_id, xml_child_seq);
CREATE INDEX datapoint_index03 ON "data_point" (report_id);
CREATE INDEX datapoint_index04 ON "data_point" (aspect_id);
GO
CREATE TABLE "entity_identifier" (
entity_identifier_id bigint DEFAULT NEXT VALUE FOR seq_object,
report_id bigint,
scheme nvarchar(450) NOT NULL,
identifier nvarchar(441) NOT NULL
);
CREATE INDEX entity_identifier_index01 ON "entity_identifier" (entity_identifier_id);
CREATE INDEX entity_identifier_index02 ON "entity_identifier" (report_id, identifier);
GO
CREATE TABLE "period" (
period_id bigint DEFAULT NEXT VALUE FOR seq_object,
report_id bigint,
start_date date,
end_date date,
is_instant bit NOT NULL,
is_forever bit NOT NULL
);
CREATE INDEX period_index01 ON "period" (period_id);
CREATE INDEX period_index02 ON "period" (report_id, start_date, end_date, is_instant, is_forever);
GO
CREATE TABLE "unit" (
unit_id bigint DEFAULT NEXT VALUE FOR seq_object,
report_id bigint,
xml_id nvarchar(max),
xml_child_seq nvarchar(450),
measures_hash char(32),
);
CREATE INDEX unit_index01 ON "unit" (unit_id);
CREATE INDEX unit_index02 ON "unit" (report_id, measures_hash);
GO
CREATE TABLE "unit_measure" (
unit_id bigint NOT NULL,
qname nvarchar(440) NOT NULL, -- clark notation qname (do we need this?)
is_multiplicand bit NOT NULL
);
CREATE INDEX unit_measure_index01 ON "unit_measure" (unit_id);
CREATE INDEX unit_measure_index02 ON "unit_measure" (unit_id, qname, is_multiplicand);
GO
CREATE TABLE "aspect_value_selection_set" (
aspect_value_selection_id bigint DEFAULT NEXT VALUE FOR seq_object,
report_id bigint
);
CREATE INDEX aspect_value_selection_set_index01 ON "aspect_value_selection_set" (aspect_value_selection_id);
CREATE INDEX aspect_value_selection_set_index02 ON "aspect_value_selection_set" (report_id);
GO
CREATE TABLE "aspect_value_selection" (
aspect_value_selection_id bigint,
aspect_id bigint NOT NULL,
aspect_value_id bigint,
is_typed_value bit NOT NULL,
typed_value nvarchar(max)
);
CREATE INDEX aspect_value_selection_index01 ON "aspect_value_selection" (aspect_value_selection_id);
CREATE INDEX aspect_value_selection_index02 ON "aspect_value_selection" (aspect_id);
GO
CREATE TABLE "table_data_points" (
report_id bigint,
object_id bigint NOT NULL, -- may be any role_type or aspect defining a table table with 'seq_object' id
table_code nvarchar(16), -- short code of table, like BS, PL, or 4.15.221
datapoint_id bigint -- id of data_point in this table (according to its aspects)
);
CREATE INDEX table_data_points_index01 ON "table_data_points" (report_id);
CREATE INDEX table_data_points_index02 ON "table_data_points" (table_code);
CREATE INDEX table_data_points_index03 ON "table_data_points" (datapoint_id);
GO
CREATE SEQUENCE seq_message AS bigint START WITH 1 INCREMENT BY 1;
GO
ALTER SEQUENCE seq_message RESTART;
GO
CREATE TABLE "message" (
message_id bigint DEFAULT NEXT VALUE FOR seq_message,
report_id bigint,
sequence_in_report int,
message_code nvarchar(256),
message_level nvarchar(256),
value nvarchar(max)
);
CREATE INDEX message_index01 ON "message" (message_id);
CREATE INDEX message_index02 ON "message" (report_id, sequence_in_report);
GO
GO
CREATE TABLE "message_reference" (
message_id bigint NOT NULL,
object_id bigint NOT NULL -- may be any table with 'seq_object' id
);
CREATE INDEX message_reference_index01 ON "message_reference" (message_id);
CREATE UNIQUE INDEX message_reference_index02 ON "message_reference" (message_id, object_id);
GO
GO
CREATE TABLE "industry" (
industry_id bigint NOT NULL,
industry_classification nvarchar(16),
industry_code integer,
industry_description nvarchar(512),
depth integer,
parent_id bigint
);
CREATE INDEX industry_index01 ON "industry" (industry_id);
INSERT INTO industry (industry_id, industry_classification, industry_code, industry_description, depth, parent_id) VALUES
(4315, 'SEC', 3576, 'Computer Communications Equipment', 4, 2424),
(4316, 'SEC', 4955, 'Hazardous Waste Management', 4, 2552),
(4317, 'SEC', 4990, 'Hazardous Waste Management', 3, 2792),
(4318, 'SEC', 4991, 'Hazardous Waste Management', 4, 4317),
(4319, 'SEC', 5412, 'Convenience Stores', 4, 2618),
(4320, 'SEC', 6170, 'Finance Lessors', 3, 2659),
(4322, 'SEC', 6180, 'Asset Backed Securities', 3, 2659),
(4323, 'SEC', 6189, 'Asset Backed Securities', 4, 4322),
(4324, 'SEC', 6190, 'Financial Services', 3, 2659),
(4325, 'SEC', 6199, 'Financial Services', 4, 4324),
(4326, 'SEC', 6532, 'Real Estate Dealers (for their own account)', 4, 2694),
(4327, 'SEC', 6770, 'Blank Checks', 3, 2703),
(4328, 'SEC', 6795, 'Mineral Royalty Traders', 4, 2704),
(4329, 'SEC', 7385, 'Telephone Interconnect Systems', 4, 2731),
(4337, 'SEC', 8880, 'American Depositary Receipts', 2, 4336),
(4338, 'SEC', 8888, 'Foreign Governments', 2, 4336),
(4339, 'SEC', 9995, 'Non-operating Establishments', 2, 4336),
(4340, 'SEC', 6172, 'Finance Lessors', 4, 4320),
(4336, 'SEC', 99, 'Miscellaneous', 1, NULL),
(1, 'NAICS', 11, 'Agriculture, Forestry, Fishing and Hunting', 1, NULL),
(132, 'NAICS', 21, 'Mining, Quarrying, and Oil and Gas Extraction', 1, NULL),
(98, 'NAICS', 113, 'Forestry and Logging', 2, 1),
(180, 'NAICS', 22, 'Utilities', 1, NULL),
(205, 'NAICS', 23, 'Construction', 1, NULL),
(278, 'NAICS', 31, 'Manufacturing', 4, NULL),
(572, 'NAICS', 327, 'Nonmetallic Mineral Product Manufacturing', 2, 278),
(700, 'NAICS', 333, 'Machinery Manufacturing', 2, 278),
(930, 'NAICS', 42, 'Wholesale Trade', 1, NULL),
(1095, 'NAICS', 44, 'Retail Trade', 4, NULL),
(1194, 'NAICS', 4482, 'Shoe Stores', 3, 1180),
(1262, 'NAICS', 48, 'Transportation and Warehousing', 4, NULL),
(1273, 'NAICS', 482, 'Rail Transportation', 2, 1262),
(1402, 'NAICS', 51, 'Information', 1, NULL),
(1480, 'NAICS', 52, 'Finance and Insurance', 1, NULL),
(1569, 'NAICS', 53, 'Real Estate and Rental and Leasing', 1, NULL),
(1624, 'NAICS', 54, 'Professional, Scientific, and Technical Services', 1, NULL),
(1591, 'NAICS', 532, 'Rental and Leasing Services', 2, 1569),
(1718, 'NAICS', 55, 'Management of Companies and Enterprises', 1, NULL),
(1725, 'NAICS', 56, 'Administrative and Support and Waste Management and Remediation Services', 1, NULL),
(1812, 'NAICS', 61, 'Educational Services', 1, NULL),
(1850, 'NAICS', 62, 'Health Care and Social Assistance', 1, NULL),
(1942, 'NAICS', 71, 'Arts, Entertainment, and Recreation', 1, NULL),
(2003, 'NAICS', 72, 'Accommodation and Food Services', 1, NULL),
(2037, 'NAICS', 81, 'Other Services (except Public Administration)', 1, NULL),
(2071, 'NAICS', 812, 'Personal and Laundry Services', 2, 2037),
(2135, 'NAICS', 92, 'Public Administration', 1, NULL),
(2900, 'SIC', 1099, 'Metal Ores, nec', 4, 2898),
(3040, 'SIC', 2099, 'Food Preparations, nec', 4, 3033),
(3162, 'SIC', 2541, 'Wood Partitions & Fixtures', 4, 3161),
(3295, 'SIC', 3161, 'Luggage', 4, 3294),
(2797, 'SEC', 90, 'Public Administration', 1, NULL),
(2789, 'SEC', 10, 'Mining', 1, NULL),
(2790, 'SEC', 15, 'Construction', 1, NULL),
(2791, 'SEC', 20, 'Manufacturing', 1, NULL),
(2792, 'SEC', 40, 'Transportation, Communications, Eletric, Gas and Sanitary Services', 1, NULL),
(2793, 'SEC', 50, 'Wholesale Trade', 1, NULL),
(2794, 'SEC', 52, 'Retail Trade', 1, NULL),
(2795, 'SEC', 60, 'Finance, Insurance, and Real Estate', 1, NULL),
(2796, 'SEC', 70, 'Services', 1, NULL),
(4314, 'SIC', 90, 'Public Administration', 1, NULL),
(4306, 'SIC', 10, 'Mining', 1, NULL),
(4307, 'SIC', 15, 'Construction', 1, NULL),
(4308, 'SIC', 20, 'Manufacturing', 1, NULL),
(4309, 'SIC', 40, 'Transportation, Communications, Eletric, Gas and Sanitary Services', 1, NULL),
(4310, 'SIC', 50, 'Wholesale Trade', 1, NULL),
(4311, 'SIC', 52, 'Retail Trade', 1, NULL),
(4312, 'SIC', 60, 'Finance, Insurance, and Real Estate', 1, NULL),
(4313, 'SIC', 70, 'Services', 1, NULL),
(2788, 'SEC', 1, 'Agriculture, Forestry, And Fishing', 1, NULL),
(4305, 'SIC', 1, 'Agriculture, Forestry, And Fishing', 1, NULL),
(2513, 'SEC', 4010, 'Railroads', 3, 2512),
(2799, 'SIC', 110, 'Cash Grains', 3, 2798),
(3420, 'SIC', 3510, 'Engines & Turbines', 3, 3419),
(2868, 'SIC', 800, 'FORESTRY', 2, 4305),
(2804, 'SIC', 119, 'Cash Grains, nec', 4, 2799),
(2800, 'SIC', 111, 'Wheat', 4, 2799),
(2801, 'SIC', 112, 'Rice', 4, 2799),
(2802, 'SIC', 115, 'Corn', 4, 2799),
(2803, 'SIC', 116, 'Soybeans', 4, 2799),
(2810, 'SIC', 139, 'Field Crops, Except Cash Grains, nec', 4, 2805),
(2809, 'SIC', 134, 'Potato Growers', 4, 2805),
(2808, 'SIC', 133, 'Sugarcane And Sugar Beets', 4, 2805),
(2807, 'SIC', 132, 'Tobacco Growers', 4, 2805),
(2806, 'SIC', 131, 'Cotton', 4, 2805),
(2812, 'SIC', 161, 'Vegetables And Melons', 4, 2811),
(2814, 'SIC', 171, 'Berry Crops', 4, 2813),
(2815, 'SIC', 172, 'Grapes/Vineyards', 4, 2813),
(2816, 'SIC', 173, 'Tree Nuts', 4, 2813),
(2214, 'SEC', 900, 'FISHING, HUNTING & TRAPPING', 2, 2788),
(2213, 'SEC', 800, 'FORESTRY', 2, 2788),
(105, 'NAICS', 1133, 'Logging', 3, 98),
(368, 'NAICS', 313, 'Textile Mills', 2, 278),
(2817, 'SIC', 174, 'Citrus Fruits', 4, 2813),
(2818, 'SIC', 175, 'Deciduous Tree Fruits/Orchards', 4, 2813),
(2819, 'SIC', 179, 'Fruits & Tree Nuts, nec', 4, 2813),
(2821, 'SIC', 181, 'Ornamental Nursery Products', 4, 2820),
(2822, 'SIC', 182, 'Food Crops Grown Under Cover', 4, 2820),
(2824, 'SIC', 191, 'General Farms, Primarily Crop', 4, 2823),
(2829, 'SIC', 213, 'Hogs', 4, 2826),
(2877, 'SIC', 912, 'Finfish', 4, 2876),
(2830, 'SIC', 214, 'Sheep & Goats', 4, 2826),
(2828, 'SIC', 212, 'Beef Cattle, Except Feedlots', 4, 2826),
(2827, 'SIC', 211, 'Beef Cattle Feedlots', 4, 2826),
(2831, 'SIC', 219, 'General Livestock, Except Dairy/Poultry', 4, 2826),
(2833, 'SIC', 241, 'Dairy Farms', 4, 2832),
(2978, 'SIC', 1794, 'Excavation Work', 4, 2975),
(2979, 'SIC', 1795, 'Wrecking & Demolition Work', 4, 2975),
(2980, 'SIC', 1796, 'Installing Building Equipment, nec', 4, 2975),
(2981, 'SIC', 1799, 'Special Trade Contractors, nec', 4, 2975),
(2976, 'SIC', 1791, 'Structural Steel Erection', 4, 2975),
(2242, 'SEC', 2011, 'Meat Packing Plants', 4, 2241),
(2244, 'SEC', 2015, 'Poultry Slaughtering & Processing', 4, 2241),
(2243, 'SEC', 2013, 'Sausages & Other Prepared Meats', 4, 2241),
(2984, 'SIC', 2011, 'Meat Packing Plants', 4, 2983),
(2986, 'SIC', 2015, 'Poultry Slaughtering & Processing', 4, 2983),
(2985, 'SIC', 2013, 'Sausages & Other Prepared Meats', 4, 2983),
(2246, 'SEC', 2024, 'Ice Cream & Frozen Desserts', 4, 2245),
(2990, 'SIC', 2023, 'Dry, Condensed & Evaporated Products', 4, 2987),
(2991, 'SIC', 2024, 'Ice Cream & Frozen Desserts', 4, 2987),
(2989, 'SIC', 2022, 'Cheese, Natural & Processed', 4, 2987),
(2988, 'SIC', 2021, 'Creamery Butter', 4, 2987),
(2992, 'SIC', 2026, 'Fluid Milk', 4, 2987),
(2248, 'SEC', 2033, 'Canned Fruits & Vegetables', 4, 2247),
(2999, 'SIC', 2038, 'Frozen Specialties, nec', 4, 2993),
(2994, 'SIC', 2032, 'Canned Specialties', 4, 2993),
(2998, 'SIC', 2037, 'Frozen Fruits & Vegetables', 4, 2993),
(2997, 'SIC', 2035, 'Pickles, Sauces & Salad Dressings', 4, 2993),
(2607, 'SEC', 5211, 'Lumber & Other Building Materials', 4, 2606),
(3806, 'SIC', 5211, 'Lumber & Other Building Materials', 4, 3805),
(3808, 'SIC', 5231, 'Paint, Glass & Wallpaper Stores', 4, 3807),
(3810, 'SIC', 5251, 'Hardware Stores', 4, 3809),
(3812, 'SIC', 5261, 'Retail Nurseries & Garden Stores', 4, 3811),
(2609, 'SEC', 5271, 'Mobile Homes Dealers', 4, 2608),
(3814, 'SIC', 5271, 'Mobile Homes Dealers', 4, 3813),
(2612, 'SEC', 5311, 'Department Stores', 4, 2611),
(3817, 'SIC', 5311, 'Department Stores', 4, 3816),
(2614, 'SEC', 5331, 'Variety Stores', 4, 2613),
(3819, 'SIC', 5331, 'Variety Stores', 4, 3818),
(2616, 'SEC', 5399, 'Miscellaneous General Merchandise Stores', 4, 2615),
(3821, 'SIC', 5399, 'Miscellaneous General Merchandise Stores', 4, 3820),
(2619, 'SEC', 5411, 'Grocery Stores', 4, 2618),
(3824, 'SIC', 5411, 'Grocery Stores', 4, 3823),
(3826, 'SIC', 5421, 'Meat & Fish Markets', 4, 3825),
(3828, 'SIC', 5431, 'Fruit & Vegetable Markets', 4, 3827),
(3830, 'SIC', 5441, 'Candy, Nut & Confectionery Stores', 4, 3829),
(3832, 'SIC', 5451, 'Dairy Products Stores', 4, 3831),
(3834, 'SIC', 5461, 'Retail Bakeries', 4, 3833),
(3836, 'SIC', 5499, 'Miscellaneous Food Stores', 4, 3835),
(3839, 'SIC', 5511, 'New & Used Car Dealers', 4, 3838),
(3841, 'SIC', 5521, 'Used Car Dealers', 4, 3840),
(2622, 'SEC', 5531, 'Auto & Home Supply Stores', 4, 2621),
(3919, 'SIC', 6011, 'Federal Reserve Banks', 4, 3918),
(2711, 'SEC', 7011, 'Hotels & Motels', 4, 2710),
(4009, 'SIC', 7011, 'Hotels & Motels', 4, 4008),
(4011, 'SIC', 7021, 'Rooming & Boarding Houses', 4, 4010),
(4013, 'SIC', 7032, 'Sporting & Recreational Camps', 4, 4012),
(4014, 'SIC', 7033, 'Trailer Parks & Campsites', 4, 4012),
(4016, 'SIC', 7041, 'Membership Basis Organization Hotels', 4, 4015),
(4024, 'SIC', 7217, 'Carpet & Upholstery Cleaners', 4, 4018),
(4020, 'SIC', 7212, 'Garment Pressing & Cleaners'' Agents', 4, 4018),
(4021, 'SIC', 7213, 'Linen Supply', 4, 4018),
(4022, 'SIC', 7215, 'Coin-Operated Laundries & Cleaning', 4, 4018),
(4023, 'SIC', 7216, 'Drycleaning Plants, Except Rug', 4, 4018),
(12, 'NAICS', 111150, 'Corn Farming', 5, 13),
(107, 'NAICS', 11331, 'Logging', 4, 105),
(1151, 'NAICS', 44521, 'Meat Markets', 4, 1149),
(1773, 'NAICS', 561622, 'Locksmiths', 5, 1771),
(2315, 'SEC', 2770, 'Greeting Cards', 3, 2302),
(2860, 'SIC', 752, 'Animal Specialty Services', 4, 2858),
(2837, 'SIC', 253, 'Turkey Farms', 4, 2834),
(2839, 'SIC', 259, 'Poultry & Eggs, nec', 4, 2834),
(2838, 'SIC', 254, 'Poultry Farms', 4, 2834),
(2836, 'SIC', 252, 'Chicken Eggs', 4, 2834),
(2835, 'SIC', 251, 'Broiler, Fryer & Roaster Chickens', 4, 2834),
(2843, 'SIC', 273, 'Aquaculture', 4, 2840),
(2844, 'SIC', 279, 'Animal Specialties, nec', 4, 2840),
(2841, 'SIC', 271, 'Fur Bearing Animals & Rabbits', 4, 2840),
(2842, 'SIC', 272, 'Horses & Other Equines', 4, 2840),
(2846, 'SIC', 291, 'General Farms, Primarily Animal', 4, 2845),
(2849, 'SIC', 711, 'Soil Preparation Services', 4, 2848),
(2854, 'SIC', 724, 'Cotton Ginning', 4, 2850),
(2853, 'SIC', 723, 'Crop Preparation Services For Market', 4, 2850),
(2851, 'SIC', 721, 'Crop Planting & Protecting', 4, 2850),
(2852, 'SIC', 722, 'Crop Harvesting', 4, 2850),
(2856, 'SIC', 741, 'Veterinary Services for Livestock', 4, 2855),
(2857, 'SIC', 742, 'Veterinary Services, Specialties', 4, 2855),
(2859, 'SIC', 751, 'Livestock Services, Except Veterinary', 4, 2858),
(2862, 'SIC', 761, 'Farm Labor Contractors', 4, 2861),
(2863, 'SIC', 762, 'Farm Management Services', 4, 2861),
(2866, 'SIC', 782, 'Lawn & Garden Services', 4, 2864),
(2867, 'SIC', 783, 'Ornamental Shrub & Tree Services', 4, 2864),
(2865, 'SIC', 781, 'Landscape Counseling & Planning', 4, 2864),
(2870, 'SIC', 811, 'Timber Tracts', 4, 2869),
(2872, 'SIC', 831, 'Forest Products', 4, 2871),
(2874, 'SIC', 851, 'Forestry Services', 4, 2873),
(2879, 'SIC', 919, 'Miscellaneous Marine Products', 4, 2876),
(2878, 'SIC', 913, 'Shellfish', 4, 2876),
(2881, 'SIC', 921, 'Fish Hatcheries & Preserves', 4, 2880),
(2883, 'SIC', 971, 'Hunting, Trapping & Game Propagation', 4, 2882),
(2886, 'SIC', 1011, 'Iron Ores', 4, 2885),
(2888, 'SIC', 1021, 'Copper Ores', 4, 2887),
(2890, 'SIC', 1031, 'Lead & Zinc Ores', 4, 2889),
(2893, 'SIC', 1044, 'Silver Ores', 4, 2891),
(2892, 'SIC', 1041, 'Gold Ores', 4, 2891),
(2895, 'SIC', 1061, 'Ferroalloy Ores, Except Vanadium', 4, 2894),
(2223, 'SEC', 1311, 'Crude Petroleum & Natural Gas', 4, 2222),
(2911, 'SIC', 1311, 'Crude Petroleum & Natural Gas', 4, 2910),
(2913, 'SIC', 1321, 'Natural Gas Liquids', 4, 2912),
(2226, 'SEC', 1382, 'Oil & Gas Exploration Services', 4, 2224),
(2227, 'SEC', 1389, 'Oil & Gas Field Services, nec', 4, 2224),
(2225, 'SEC', 1381, 'Drilling Oil & Gas Wells', 4, 2224),
(2917, 'SIC', 1389, 'Oil & Gas Field Services, nec', 4, 2914),
(2915, 'SIC', 1381, 'Drilling Oil & Gas Wells', 4, 2914),
(2916, 'SIC', 1382, 'Oil & Gas Exploration Services', 4, 2914),
(2920, 'SIC', 1411, 'Dimension Stone', 4, 2919),
(2924, 'SIC', 1429, 'Crushed & Broken Stone, nec', 4, 2921),
(2922, 'SIC', 1422, 'Crushed & Broken Limestone', 4, 2921),
(2923, 'SIC', 1423, 'Crushed & Broken Granite', 4, 2921),
(2926, 'SIC', 1441, 'Construction Sand & Gravel', 4, 2925),
(2927, 'SIC', 1446, 'Industrial Sand', 4, 2925),
(2929, 'SIC', 1455, 'Kaolin & Ball Clay', 4, 2928),
(2930, 'SIC', 1459, 'Clay & Related Minerals, nec', 4, 2928),
(2934, 'SIC', 1479, 'Chemical & Fertilizer Mining nec', 4, 2931),
(2932, 'SIC', 1474, 'Potash, Soda & Borate Minerals', 4, 2931),
(2933, 'SIC', 1475, 'Phosphate Rock', 4, 2931),
(2936, 'SIC', 1481, 'Nonmetallic Minerals Services', 4, 2935),
(2938, 'SIC', 1499, 'Miscellaneous Nonmetallic Minerals', 4, 2937),
(2942, 'SIC', 1522, 'Residential Construction, nec', 4, 2940),
(2941, 'SIC', 1521, 'Single-Family Housing Construction', 4, 2940),
(2232, 'SEC', 1531, 'Operative Builders', 4, 2231),
(2944, 'SIC', 1531, 'Operative Builders', 4, 2943),
(2946, 'SIC', 1541, 'Industrial Buildings & Warehouses', 4, 2945),
(2947, 'SIC', 1542, 'Nonresidential Construction, nec', 4, 2945),
(2950, 'SIC', 1611, 'Highway & Street Construction', 4, 2949),
(2236, 'SEC', 1623, 'Water, Sewer & Utility Lines', 4, 2235),
(2954, 'SIC', 1629, 'Heavy Construction, nec', 4, 2951),
(2953, 'SIC', 1623, 'Water, Sewer & Utility Lines', 4, 2951),
(2952, 'SIC', 1622, 'Bridge, Tunnel & Elevated Highway', 4, 2951),
(2957, 'SIC', 1711, 'Plumbing, Heating, Air-Conditioning', 4, 2956),
(2996, 'SIC', 2034, 'Dehydrated Fruits, Vegetables & Soups', 4, 2993),
(2995, 'SIC', 2033, 'Canned Fruits & Vegetables', 4, 2993),
(3005, 'SIC', 2046, 'Wet Corn Milling', 4, 3000),
(3007, 'SIC', 2048, 'Prepared Feeds, nec', 4, 3000),
(3006, 'SIC', 2047, 'Dog & Cat Food', 4, 3000),
(3004, 'SIC', 2045, 'Prepared Flour Mixes & Doughs', 4, 3000),
(3003, 'SIC', 2044, 'Rice Milling', 4, 3000),
(3002, 'SIC', 2043, 'Cereal Breakfast Foods', 4, 3000),
(3001, 'SIC', 2041, 'Flour & Other Grain Mill Products', 4, 3000),
(2251, 'SEC', 2052, 'Cookies & Crackers', 4, 2250),
(3009, 'SIC', 2051, 'Bread, Cake & Related Products', 4, 3008),
(3011, 'SIC', 2053, 'Frozen Bakery Products, Except Bread', 4, 3008),
(3010, 'SIC', 2052, 'Cookies & Crackers', 4, 3008),
(3015, 'SIC', 2063, 'Beet Sugar', 4, 3012),
(3019, 'SIC', 2068, 'Salted & Roasted Nuts & Seeds', 4, 3012),
(3018, 'SIC', 2067, 'Chewing Gum', 4, 3012),
(3017, 'SIC', 2066, 'Chocolate & Cocoa Products', 4, 3012),
(3016, 'SIC', 2064, 'Candy & Other Confectionery Products', 4, 3012),
(3072, 'SIC', 2273, 'Carpets & Rugs', 4, 3071),
(3075, 'SIC', 2282, 'Throwing & Winding Mills', 4, 3073),
(3076, 'SIC', 2284, 'Thread Mills', 4, 3073),
(3074, 'SIC', 2281, 'Yarn Spinning Mills', 4, 3073),
(3079, 'SIC', 2296, 'Tire Cord & Fabrics', 4, 3077),
(3082, 'SIC', 2299, 'Textile Goods, nec', 4, 3077),
(3081, 'SIC', 2298, 'Cordage & Twine', 4, 3077),
(3080, 'SIC', 2297, 'Nonwoven Fabrics', 4, 3077),
(3078, 'SIC', 2295, 'Coated Fabrics, Not Rubberized', 4, 3077),
(3085, 'SIC', 2311, 'Men''s & Boys'' Suits & Coats', 4, 3084),
(3087, 'SIC', 2321, 'Men''s & Boys'' Shirts', 4, 3086),
(3091, 'SIC', 2326, 'Men''s & Boys'' Work Clothing', 4, 3086),
(3092, 'SIC', 2329, 'Men''s & Boys'' Clothing, nec', 4, 3086),
(3088, 'SIC', 2322, 'Men''s & Boys'' Underwear & Nightwear', 4, 3086),
(3089, 'SIC', 2323, 'Men''s & Boys'' Neckwear', 4, 3086),
(3090, 'SIC', 2325, 'Men''s & Boys'' Trousers & Slacks', 4, 3086),
(3097, 'SIC', 2339, 'Women''s & Misses'' Outerwear, nec', 4, 3093),
(3094, 'SIC', 2331, 'Women''s & Misses'' Blouses & Shirts', 4, 3093),
(3095, 'SIC', 2335, 'Women''s & Misses'' & Junior''s Dresses', 4, 3093),
(3096, 'SIC', 2337, 'Women''s & Misses'' Suits & Coats', 4, 3093),
(3100, 'SIC', 2342, 'Bras, Girdles & Allied Garments', 4, 3098),
(3099, 'SIC', 2341, 'Women''s & Children''s Underwear', 4, 3098),
(3107, 'SIC', 2371, 'Fur Goods', 4, 3106),
(3147, 'SIC', 2499, 'Wood Products, nec', 4, 3144),
(3145, 'SIC', 2491, 'Wood Preserving', 4, 3144),
(3146, 'SIC', 2493, 'Reconstituted Wood Products', 4, 3144),
(2285, 'SEC', 2511, 'Wood Household Furniture', 4, 2284),
(3155, 'SIC', 2519, 'Household Furniture, nec', 4, 3149),
(3154, 'SIC', 2517, 'Wood TV & Radio Cabinets', 4, 3149),
(3153, 'SIC', 2515, 'Mattresses & Bedsprings', 4, 3149),
(3152, 'SIC', 2514, 'Metal Household Furniture', 4, 3149),
(3151, 'SIC', 2512, 'Upholstered Household Furniture', 4, 3149),
(3150, 'SIC', 2511, 'Wood Household Furniture', 4, 3149),
(2287, 'SEC', 2522, 'Office Furniture, Except Wood', 4, 2286),
(3158, 'SIC', 2522, 'Office Furniture, Except Wood', 4, 3156),
(3157, 'SIC', 2521, 'Wood Office Furniture', 4, 3156),
(2289, 'SEC', 2531, 'Public Building & Related Furniture', 4, 2288),
(3160, 'SIC', 2531, 'Public Building & Related Furniture', 4, 3159),
(3163, 'SIC', 2542, 'Partitions & Fixtures, Except Wood', 4, 3161),
(3165, 'SIC', 2591, 'Drapery Hardware & Blinds & Shades', 4, 3164),
(3166, 'SIC', 2599, 'Furniture & Fixtures, nec', 4, 3164),
(2294, 'SEC', 2611, 'Pulp Mills', 4, 2293),
(3169, 'SIC', 2611, 'Pulp Mills', 4, 3168),
(2296, 'SEC', 2621, 'Paper Mills', 4, 2295),
(3171, 'SIC', 2621, 'Paper Mills', 4, 3170),
(2298, 'SEC', 2631, 'Paperboard Mills', 4, 2297),
(3173, 'SIC', 2631, 'Paperboard Mills', 4, 3172),
(3175, 'SIC', 2652, 'Setup Paperboard Boxes', 4, 3174),
(3179, 'SIC', 2657, 'Folding Paperboard Boxes', 4, 3174),
(3177, 'SIC', 2655, 'Fiber Cans, Drums & Similar Products', 4, 3174),
(3176, 'SIC', 2653, 'Corrugated & Solid Fiber Boxes', 4, 3174),
(3178, 'SIC', 2656, 'Sanitary Food Containers', 4, 3174),
(2301, 'SEC', 2673, 'Bags: Plastic, Laminated & Coated', 4, 2300),
(3188, 'SIC', 2678, 'Stationery Products', 4, 3180),
(3189, 'SIC', 2679, 'Converted Paper Products, nec', 4, 3180),
(3183, 'SIC', 2673, 'Bags: Plastic, Laminated & Coated', 4, 3180),
(3184, 'SIC', 2674, 'Bags: Uncoated Paper & Multiwall', 4, 3180),
(3185, 'SIC', 2675, 'Die-Cut Paper & Board', 4, 3180),
(3186, 'SIC', 2676, 'Sanitary Paper Products', 4, 3180),
(3187, 'SIC', 2677, 'Envelopes', 4, 3180),
(3197, 'SIC', 2732, 'Book Printing', 4, 3195),
(3196, 'SIC', 2731, 'Book Publishing', 4, 3195),
(2311, 'SEC', 2741, 'Miscellaneous Publishing', 4, 2310),
(3199, 'SIC', 2741, 'Miscellaneous Publishing', 4, 3198),
(3202, 'SIC', 2754, 'Commercial Printing, Gravure', 4, 3200),
(3203, 'SIC', 2759, 'Commercial Printing, nec', 4, 3200),
(3201, 'SIC', 2752, 'Commercial Printing, Lithographic', 4, 3200),
(2314, 'SEC', 2761, 'Manifold Business Forms', 4, 2313),
(3205, 'SIC', 2761, 'Manifold Business Forms', 4, 3204),
(2316, 'SEC', 2771, 'Greeting Cards', 4, 2315),
(3207, 'SIC', 2771, 'Greeting Cards', 4, 3206),
(3209, 'SIC', 2782, 'Blankbooks & Looseleaf Binders', 4, 3208),
(3210, 'SIC', 2789, 'Bookbinding & Related Work', 4, 3208),
(3212, 'SIC', 2791, 'Typesetting', 4, 3211),
(3213, 'SIC', 2796, 'Platemaking Services', 4, 3211),
(3216, 'SIC', 2812, 'Alkalies & Chlorine', 4, 3215),
(3217, 'SIC', 2813, 'Industrial Gases', 4, 3215),
(3218, 'SIC', 2816, 'Inorganic Pigments', 4, 3215),
(3219, 'SIC', 2819, 'Industrial Inorganic Chemicals, nec', 4, 3215),
(2322, 'SEC', 2821, 'Plastics Materials & Resins', 4, 2321),
(3222, 'SIC', 2822, 'Synthetic Rubber', 4, 3220),
(3221, 'SIC', 2821, 'Plastics Materials & Resins', 4, 3220),
(3223, 'SIC', 2823, 'Cellulosic Manmade Fibers', 4, 3220),
(3248, 'SIC', 2892, 'Explosives', 4, 3246),
(3259, 'SIC', 2992, 'Lubricating Oils & Greases', 4, 3258),
(2344, 'SEC', 3011, 'Tires & Inner Tubes', 4, 2343),
(3263, 'SIC', 3011, 'Tires & Inner Tubes', 4, 3262),
(2346, 'SEC', 3021, 'Rubber & Plastics Footwear', 4, 2345),
(3265, 'SIC', 3021, 'Rubber & Plastics Footwear', 4, 3264),
(3267, 'SIC', 3052, 'Rubber & Plastics Hose & Belting', 4, 3266),
(3268, 'SIC', 3053, 'Gaskets, Packing & Sealing Devices', 4, 3266),
(3271, 'SIC', 3069, 'Fabricated Rubber Products, nec', 4, 3269),
(3270, 'SIC', 3061, 'Mechanical Rubber Goods', 4, 3269),
(2352, 'SEC', 3089, 'Plastics Products, nec', 4, 2349),
(2350, 'SEC', 3081, 'Unsupported Plastics Film & Sheet', 4, 2349),
(2351, 'SEC', 3086, 'Plastics Foam Products', 4, 2349),
(3276, 'SIC', 3084, 'Plastics Pipe', 4, 3272),
(3278, 'SIC', 3086, 'Plastics Foam Products', 4, 3272),
(3279, 'SIC', 3087, 'Custom Compound Purchased Resins', 4, 3272),
(3280, 'SIC', 3088, 'Plastics Plumbing Fixtures', 4, 3272),
(3281, 'SIC', 3089, 'Plastics Products, nec', 4, 3272),
(3273, 'SIC', 3081, 'Unsupported Plastics Film & Sheet', 4, 3272),
(3277, 'SIC', 3085, 'Plastics Bottles', 4, 3272),
(3274, 'SIC', 3082, 'Unsupported Plastics Profile Shapes', 4, 3272),
(3275, 'SIC', 3083, 'Laminated Plastics Plate, Sheet, and Profile Shapes', 4, 3272),
(3284, 'SIC', 3111, 'Leather Tanning & Finishing', 4, 3283),
(3286, 'SIC', 3131, 'Footwear Cut Stock', 4, 3285),
(3291, 'SIC', 3149, 'Footwear, Except Rubber, nec', 4, 3287),
(3289, 'SIC', 3143, 'Men''s Footwear, Except Athletic', 4, 3287),
(3290, 'SIC', 3144, 'Women''s Footwear, Except Athletic', 4, 3287),
(3288, 'SIC', 3142, 'House Slippers', 4, 3287),
(3293, 'SIC', 3151, 'Leather Gloves & Mittens', 4, 3292),
(3298, 'SIC', 3172, 'Personal Leather Goods, nec', 4, 3296),
(3297, 'SIC', 3171, 'Women''s Handbags & Purses', 4, 3296),
(3300, 'SIC', 3199, 'Leather Goods, nec', 4, 3299),
(2357, 'SEC', 3211, 'Flat Glass', 4, 2356),
(3303, 'SIC', 3211, 'Flat Glass', 4, 3302),
(2359, 'SEC', 3221, 'Glass Containers', 4, 2358),
(3305, 'SIC', 3221, 'Glass Containers', 4, 3304),
(3306, 'SIC', 3229, 'Pressed & Blown Glass, nec', 4, 3304),
(2361, 'SEC', 3231, 'Products of Purchased Glass', 4, 2360),
(3308, 'SIC', 3231, 'Products of Purchased Glass', 4, 3307),
(3321, 'SIC', 3269, 'Pottery Products, nec', 4, 3316),
(3319, 'SIC', 3263, 'Semivitreous Table & Kitchenware', 4, 3316),
(3317, 'SIC', 3261, 'Vitreous Plumbing Fixtures', 4, 3316),
(3318, 'SIC', 3262, 'Vitreous China Table & Kitchenware', 4, 3316),
(3320, 'SIC', 3264, 'Porcelain Electrical Supplies', 4, 3316),
(2367, 'SEC', 3272, 'Concrete Products, nec', 4, 2366),
(3325, 'SIC', 3273, 'Ready-Mixed Concrete', 4, 3322),
(3324, 'SIC', 3272, 'Concrete Products, nec', 4, 3322),
(3326, 'SIC', 3274, 'Lime', 4, 3322),
(3327, 'SIC', 3275, 'Gypsum Products', 4, 3322),
(3323, 'SIC', 3271, 'Concrete Block & Brick', 4, 3322),
(2369, 'SEC', 3281, 'Cut Stone & Stone Products', 4, 2368),
(3329, 'SIC', 3281, 'Cut Stone & Stone Products', 4, 3328),
(3336, 'SIC', 3299, 'Nonmetallic Mineral Products, nec', 4, 3330),
(3331, 'SIC', 3291, 'Abrasive Products', 4, 3330),
(3332, 'SIC', 3292, 'Asbestos Products', 4, 3330),
(3333, 'SIC', 3295, 'Minerals, Ground or Treated', 4, 3330),
(3334, 'SIC', 3296, 'Mineral Wool', 4, 3330),
(3335, 'SIC', 3297, 'Nonclay Refractories', 4, 3330),
(2373, 'SEC', 3312, 'Blast Furnaces & Steel Mills', 4, 2372),
(2374, 'SEC', 3317, 'Steel Pipe & Tubes', 4, 2372),
(3341, 'SIC', 3315, 'Steel Wire & Related Products', 4, 3338),
(3342, 'SIC', 3316, 'Cold Finishing of Steel Shapes', 4, 3338),
(3343, 'SIC', 3317, 'Steel Pipe & Tubes', 4, 3338),
(3339, 'SIC', 3312, 'Blast Furnaces & Steel Mills', 4, 3338),
(3340, 'SIC', 3313, 'Electrometallurgical Products', 4, 3338),
(3347, 'SIC', 3324, 'Steel Investment Foundries', 4, 3344),
(3348, 'SIC', 3325, 'Steel Foundries, nec', 4, 3344),
(3346, 'SIC', 3322, 'Malleable Iron Foundries', 4, 3344),
(3345, 'SIC', 3321, 'Gray & Ductile Iron Foundries', 4, 3344),
(2377, 'SEC', 3334, 'Primary Aluminum', 4, 2376),
(2387, 'SEC', 3412, 'Metal Barrels, Drums & Pails', 4, 2385),
(2386, 'SEC', 3411, 'Metal Cans', 4, 2385),
(3374, 'SIC', 3412, 'Metal Barrels, Drums & Pails', 4, 3372),
(3373, 'SIC', 3411, 'Metal Cans', 4, 3372),
(3377, 'SIC', 3423, 'Hand & Edge Tools, nec', 4, 3375),
(3379, 'SIC', 3429, 'Hardware, nec', 4, 3375),
(3378, 'SIC', 3425, 'Saw Blades & Handsaws', 4, 3375),
(3376, 'SIC', 3421, 'Cutlery', 4, 3375),
(2390, 'SEC', 3433, 'Heating Equipment, Except Electric', 4, 2389),
(3382, 'SIC', 3432, 'Plumbing Fixture Fittings & Trim', 4, 3380),
(3383, 'SIC', 3433, 'Heating Equipment, Except Electric', 4, 3380),
(3381, 'SIC', 3431, 'Metal Sanitary Ware', 4, 3380),
(2392, 'SEC', 3441, 'Metal Doors, Sash & Trim', 4, 2391),
(2393, 'SEC', 3443, 'Fabricated Plate Work (Boiler Shops)', 4, 2391),
(2395, 'SEC', 3448, 'Prefabricated Metal Buildings', 4, 2391),
(2394, 'SEC', 3444, 'Sheet Metal Work', 4, 2391),
(3391, 'SIC', 3449, 'Miscellaneous Metal Work', 4, 3384),
(3390, 'SIC', 3448, 'Prefabricated Metal Buildings', 4, 3384),
(3389, 'SIC', 3446, 'Architectural Metal Work', 4, 3384),
(3388, 'SIC', 3444, 'Sheet Metal Work', 4, 3384),
(3387, 'SIC', 3443, 'Fabricated Plate Work (Boiler Shops)', 4, 3384),
(3386, 'SIC', 3441, 'Metal Doors, Sash & Trim', 4, 3384),
(3432, 'SIC', 3536, 'Hoists, Cranes & Monorails', 4, 3426),
(3431, 'SIC', 3535, 'Conveyors & Conveying Equipment', 4, 3426),
(3430, 'SIC', 3534, 'Elevators & Moving Stairways', 4, 3426),
(3429, 'SIC', 3533, 'Oil & Gas Field Machinery', 4, 3426),
(3428, 'SIC', 3532, 'Mining Machinery', 4, 3426),
(2414, 'SEC', 3541, 'Machine Tools, Metal Cutting Types', 4, 2413),
(3443, 'SIC', 3549, 'Metalworking Machinery, nec', 4, 3434),
(3435, 'SIC', 3541, 'Machine Tools, Metal Cutting Types', 4, 3434),
(3436, 'SIC', 3542, 'Machine Tools, Metal Forming Types', 4, 3434),
(3437, 'SIC', 3543, 'Industrial Patterns', 4, 3434),
(3438, 'SIC', 3544, 'Special Dies, Tools, Jigs & Fixtures', 4, 3434),
(3439, 'SIC', 3545, 'Machine Tool Accessories', 4, 3434),
(3440, 'SIC', 3546, 'Power-Driven Handtools', 4, 3434),
(3441, 'SIC', 3547, 'Rolling Mill Machinery', 4, 3434),
(3441, 'SIC', 3548, 'Welding Apparatus', 4, 3434),
(2416, 'SEC', 3555, 'Printing Trades Machinery', 4, 2415),
(2417, 'SEC', 3559, 'Special Industry Machinery, nec', 4, 2415),
(3449, 'SIC', 3556, 'Food Products Machinery', 4, 3444),
(3483, 'SIC', 3613, 'Switchgear & Switchboard Apparatus', 4, 3481),
(3482, 'SIC', 3612, 'Transformers, Except Electronic', 4, 3481),
(2439, 'SEC', 3621, 'Motors & Generators', 4, 2438),
(3488, 'SIC', 3629, 'Electrical Industrial Apparatus, nec', 4, 3484),
(3486, 'SIC', 3624, 'Carbon & Graphite Products', 4, 3484),
(3485, 'SIC', 3621, 'Motors & Generators', 4, 3484),
(3487, 'SIC', 3625, 'Relays & Industrial Controls', 4, 3484),
(2441, 'SEC', 3634, 'Electric Housewares & Fans', 4, 2440),
(3490, 'SIC', 3631, 'Household Cooking Equipment', 4, 3489),
(3491, 'SIC', 3632, 'Household Refrigerators & Freezers', 4, 3489),
(3492, 'SIC', 3633, 'Household Laundry Equipment', 4, 3489),
(3493, 'SIC', 3634, 'Electric Housewares & Fans', 4, 3489),
(3494, 'SIC', 3635, 'Household Vacuum Cleaners', 4, 3489),
(3495, 'SIC', 3639, 'Household Appliances, nec', 4, 3489),
(3502, 'SIC', 3647, 'Vehicular Lighting Equipment', 4, 3496),
(3536, 'SIC', 3728, 'Aircraft Parts & Equipment, nec', 4, 3533),
(3535, 'SIC', 3724, 'Aircraft Engines & Engine Parts', 4, 3533),
(3539, 'SIC', 3732, 'Boat Building & Repairing', 4, 3537),
(3538, 'SIC', 3731, 'Ship Building & Repairing', 4, 3537),
(2471, 'SEC', 3743, 'Railroad Equipment', 4, 2470),
(3541, 'SIC', 3743, 'Railroad Equipment', 4, 3540),
(2473, 'SEC', 3751, 'Motorcycles, Bicycles & Parts', 4, 2472),
(3543, 'SIC', 3751, 'Motorcycles, Bicycles & Parts', 4, 3542),
(3546, 'SIC', 3764, 'Space Propulsion Units & Parts', 4, 3544),
(3547, 'SIC', 3769, 'Space Vehicle Equipment, nec', 4, 3544),
(3545, 'SIC', 3761, 'Guided Missiles & Space Vehicles', 4, 3544),
(3549, 'SIC', 3792, 'Travel Trailers & Campers', 4, 3548),
(3550, 'SIC', 3795, 'Tanks & Tank Components', 4, 3548),
(3551, 'SIC', 3799, 'Transportation Equipment, nec', 4, 3548),
(2478, 'SEC', 3812, 'Search & Navigation Equipment', 4, 2477),
(3554, 'SIC', 3812, 'Search & Navigation Equipment', 4, 3553),
(2482, 'SEC', 3823, 'Process Control Instruments', 4, 2479),
(2480, 'SEC', 3821, 'Laboratory Apparatus & Furniture', 4, 2479),
(2481, 'SEC', 3822, 'Environmental Controls', 4, 2479),
(2483, 'SEC', 3824, 'Fluid Meters & Counting Devices', 4, 2479),
(2484, 'SEC', 3825, 'Instruments to Measure Electricity', 4, 2479),
(2485, 'SEC', 3826, 'Analytical Instruments', 4, 2479),
(2486, 'SEC', 3827, 'Optical Instruments & Lenses', 4, 2479),
(2487, 'SEC', 3829, 'Measuring & Controlling Devices, nec', 4, 2479),
(2506, 'SEC', 3942, 'Dolls & Stuffed Toys', 4, 2505),
(2508, 'SEC', 3949, 'Sporting & Athletic Goods, nec', 4, 2505),
(2507, 'SEC', 3944, 'Games, Toys & Children''s Vehicles', 4, 2505),
(3586, 'SIC', 3949, 'Sporting & Athletic Goods, nec', 4, 3583),
(3584, 'SIC', 3942, 'Dolls & Stuffed Toys', 4, 3583),
(3585, 'SIC', 3944, 'Games, Toys & Children''s Vehicles', 4, 3583),
(3591, 'SIC', 3955, 'Carbon Paper & Inked Ribbons', 4, 3587),
(3590, 'SIC', 3953, 'Marking Devices', 4, 3587),
(3589, 'SIC', 3952, 'Lead Pencils & Art Goods', 4, 3587),
(3588, 'SIC', 3951, 'Pens & Mechanical Pencils', 4, 3587),
(3593, 'SIC', 3961, 'Costume Jewelry', 4, 3592),
(3594, 'SIC', 3965, 'Fasteners, Buttons, Needles & Pins', 4, 3592),
(3597, 'SIC', 3993, 'Signs & Advertising Specialties', 4, 3595),
(3600, 'SIC', 3999, 'Manufacturing Industries, nec', 4, 3595),
(3599, 'SIC', 3996, 'Hard Surface Floor Coverings, nec', 4, 3595),
(3598, 'SIC', 3995, 'Burial Caskets', 4, 3595),
(3596, 'SIC', 3991, 'Brooms & Brushes', 4, 3595),
(2514, 'SEC', 4011, 'Railroads Line-Haul Operating', 4, 2513),
(2515, 'SEC', 4013, 'Switching & Terminal Devices', 4, 2513),
(3604, 'SIC', 4013, 'Switching & Terminal Devices', 4, 3602),
(3603, 'SIC', 4011, 'Railroads Line-Haul Operating', 4, 3602),
(3608, 'SIC', 4119, 'Local Passenger Transportation, nec', 4, 3606),
(3607, 'SIC', 4111, 'Local & Suburban Transit', 4, 3606),
(3610, 'SIC', 4121, 'Taxicabs', 4, 3609),
(3612, 'SIC', 4131, 'Intercity & Rural Bus Transportation', 4, 3611),
(3615, 'SIC', 4142, 'Bus Charter Service, Except Local', 4, 3613),
(3614, 'SIC', 4141, 'Local Bus Charter Service', 4, 3613),
(3617, 'SIC', 4151, 'School Buses', 4, 3616),
(3619, 'SIC', 4173, 'Bus Terminal & Service Facilities', 4, 3618),
(2519, 'SEC', 4213, 'Trucking, Except Local', 4, 2518),
(3622, 'SIC', 4212, 'Local Trucking, Without Storage', 4, 3621),
(3624, 'SIC', 4214, 'Local Trucking With Storage', 4, 3621),
(3625, 'SIC', 4215, 'Courier Service, Except by Air', 4, 3621),
(3623, 'SIC', 4213, 'Trucking, Except Local', 4, 3621),
(3627, 'SIC', 4221, 'Farm Product Warehousing & Storage', 4, 3626),
(3630, 'SIC', 4226, 'Special Warehousing & Storage, nec', 4, 3626),
(3629, 'SIC', 4225, 'General Warehousing & Storage', 4, 3626),
(3628, 'SIC', 4222, 'Refrigerated Warehousing & Storage', 4, 3626),
(2522, 'SEC', 4231, 'Trucking Terminal Facilities', 4, 2521),
(2525, 'SEC', 4412, 'Deep Sea Foreign Transport of Freight', 4, 2524),
(3638, 'SIC', 4412, 'Deep Sea Foreign Transport of Freight', 4, 3637),
(3640, 'SIC', 4414, 'Deep Sea Domestic Transport of Freight', 4, 3639),
(3642, 'SIC', 4432, 'Freight Transport on The Great Lakes', 4, 3641),
(3644, 'SIC', 4449, 'Water Transportation of Freight, nec', 4, 3643),
(3648, 'SIC', 4489, 'Water Passenger Transportation, nec', 4, 3645),
(3646, 'SIC', 4481, 'Deep Sea Passenger Transportation, Except Ferry', 4, 3645),
(3647, 'SIC', 4482, 'Ferries', 4, 3645),
(3650, 'SIC', 4491, 'Marine Cargo Handling', 4, 3649),
(3653, 'SIC', 4499, 'Water Transportation Services, nec', 4, 3649),
(3652, 'SIC', 4493, 'Marinas', 4, 3649),
(3651, 'SIC', 4492, 'Towing & Tugboat Service', 4, 3649),
(2528, 'SEC', 4512, 'Air Transportation, Scheduled', 4, 2527),
(2529, 'SEC', 4513, 'Air Courier Services', 4, 2527),
(3656, 'SIC', 4512, 'Air Transportation, Scheduled', 4, 3655),
(3657, 'SIC', 4513, 'Air Courier Services', 4, 3655),
(2531, 'SEC', 4522, 'Air Transportation, Nonscheduled', 4, 2530),
(3659, 'SIC', 4522, 'Air Transportation, Nonscheduled', 4, 3658),
(2533, 'SEC', 4581, 'Airports, Flying Fields & Services', 4, 2532),
(3661, 'SIC', 4581, 'Airports, Flying Fields & Services', 4, 3660),
(3664, 'SIC', 4612, 'Crude Petroleum Pipelines', 4, 3663),
(3666, 'SIC', 4619, 'Pipelines, nec', 4, 3663),
(3665, 'SIC', 4613, 'Refined Petroleum Pipelines', 4, 3663),
(3670, 'SIC', 4725, 'Tour Operators', 4, 3668),
(3669, 'SIC', 4724, 'Travel Agencies', 4, 3668),
(3671, 'SIC', 4729, 'Passenger Transport Arrangement, nec', 4, 3668),
(2538, 'SEC', 4731, 'Freight Transportation Arrangement', 4, 2537),
(3673, 'SIC', 4731, 'Freight Transportation Arrangement', 4, 3672),
(3675, 'SIC', 4741, 'Rental of Railroad Cars', 4, 3674),
(3679, 'SIC', 4789, 'Transportation Services, nec', 4, 3676),
(3678, 'SIC', 4785, 'Inspection & Fixed Facilities', 4, 3676),
(3677, 'SIC', 4783, 'Packing & Crating', 4, 3676),
(2554, 'SEC', 4911, 'Electric Services', 4, 2553),
(3695, 'SIC', 4911, 'Electric Services', 4, 3694),
(2558, 'SEC', 4924, 'Natural Gas Distribution', 4, 2555),
(2556, 'SEC', 4922, 'Natural Gas Transmission', 4, 2555),
(2557, 'SEC', 4923, 'Gas Transmission & Distribution', 4, 2555),
(3698, 'SIC', 4923, 'Gas Transmission & Distribution', 4, 3696),
(3697, 'SIC', 4922, 'Natural Gas Transmission', 4, 3696),
(3700, 'SIC', 4925, 'Gas Production and/or Distribution', 4, 3696),
(3699, 'SIC', 4924, 'Natural Gas Distribution', 4, 3696),
(2561, 'SEC', 4932, 'Gas & Other Services Combined', 4, 2559),
(2560, 'SEC', 4931, 'Electric & Other Services Combined', 4, 2559),
(3704, 'SIC', 4939, 'Combination Utilities, nec', 4, 3701),
(3703, 'SIC', 4932, 'Gas & Other Services Combined', 4, 3701),
(3702, 'SIC', 4931, 'Electric & Other Services Combined', 4, 3701),
(2563, 'SEC', 4941, 'Water Supply', 4, 2562),
(3706, 'SIC', 4941, 'Water Supply', 4, 3705),
(2565, 'SEC', 4953, 'Refuse Systems', 4, 2564),
(3708, 'SIC', 4952, 'Sewerage Systems', 4, 3707),
(3709, 'SIC', 4953, 'Refuse Systems', 4, 3707),
(3710, 'SIC', 4959, 'Sanitary Services, nec', 4, 3707),
(2567, 'SEC', 4961, 'Steam & Air Conditioning Supply', 4, 2566),
(3712, 'SIC', 4961, 'Steam & Air Conditioning Supply', 4, 3711),
(3714, 'SIC', 4971, 'Irrigation Systems', 4, 3713),
(2570, 'SEC', 5013, 'Motor Vehicle Supplies & New Parts', 4, 2569),
(3719, 'SIC', 5014, 'Tires & Tubes', 4, 3716),
(3717, 'SIC', 5012, 'Automobiles & Other Motor Vehicles', 4, 3716),
(3718, 'SIC', 5013, 'Motor Vehicle Supplies & New Parts', 4, 3716),
(3720, 'SIC', 5015, 'Motor Vehicle Parts, Used', 4, 3716),
(3723, 'SIC', 5023, 'Homefurnishings', 4, 3721),
(3722, 'SIC', 5021, 'Furniture', 4, 3721),
(2573, 'SEC', 5031, 'Lumber, Plywood & Millwork', 4, 2572),
(3728, 'SIC', 5039, 'Construction Materials, nec', 4, 3724),
(3726, 'SIC', 5032, 'Brick, Stone & Related Materials', 4, 3724),
(2582, 'SEC', 5065, 'Electronic Parts & Equipment', 4, 2579),
(3743, 'SIC', 5065, 'Electronic Parts & Equipment', 4, 3740),
(3741, 'SIC', 5063, 'Electrical Apparatus & Equipment', 4, 3740),
(3742, 'SIC', 5064, 'Electrical Appliances, TV & Radios', 4, 3740),
(2584, 'SEC', 5072, 'Hardware', 4, 2583),
(3745, 'SIC', 5072, 'Hardware', 4, 3744),
(3747, 'SIC', 5075, 'Warm Air Heating & Air-Conditioning', 4, 3744),
(3746, 'SIC', 5074, 'Plumbing & Hydronic Heating Supplies', 4, 3744),
(3748, 'SIC', 5078, 'Refrigeration Equipment & Supplies', 4, 3744),
(2586, 'SEC', 5082, 'Construction & Mining Machinery', 4, 2585),
(2587, 'SEC', 5084, 'Industrial Machinery & Equipment', 4, 2585),
(3751, 'SIC', 5083, 'Farm & Garden Machinery', 4, 3749),
(3752, 'SIC', 5084, 'Industrial Machinery & Equipment', 4, 3749),
(3750, 'SIC', 5082, 'Construction & Mining Machinery', 4, 3749),
(3755, 'SIC', 5088, 'Transportation Equipment & Supplies', 4, 3749),
(3754, 'SIC', 5087, 'Service Establishment Equipment', 4, 3749),
(3753, 'SIC', 5085, 'Industrial Supplies', 4, 3749),
(2590, 'SEC', 5099, 'Durable Goods, nec', 4, 2588),
(2589, 'SEC', 5094, 'Jewelry & Precious Stones', 4, 2588),
(3761, 'SIC', 5099, 'Durable Goods, nec', 4, 3756),
(3843, 'SIC', 5531, 'Auto & Home Supply Stores', 4, 3842),
(3845, 'SIC', 5541, 'Gasoline Service Stations', 4, 3844),
(3847, 'SIC', 5551, 'Boat Dealers', 4, 3846),
(3849, 'SIC', 5561, 'Recreational Vehicle Dealers', 4, 3848),
(3851, 'SIC', 5571, 'Motorcycle Dealers', 4, 3850),
(3853, 'SIC', 5599, 'Automotive Dealers, nec', 4, 3852),
(3856, 'SIC', 5611, 'Men''s & Boys'' Clothing Stores', 4, 3855),
(2625, 'SEC', 5621, 'Women''s Clothing Stores', 4, 2624),
(3858, 'SIC', 5621, 'Women''s Clothing Stores', 4, 3857),
(3860, 'SIC', 5632, 'Women''s Accessory & Specialty Stores', 4, 3859),
(3862, 'SIC', 5641, 'Children''s & Infants'' Wear Stores', 4, 3861),
(2627, 'SEC', 5651, 'Family Clothing Stores', 4, 2626),
(3864, 'SIC', 5651, 'Family Clothing Stores', 4, 3863),
(2629, 'SEC', 5661, 'Shoe Stores', 4, 2628),
(3866, 'SIC', 5661, 'Shoe Stores', 4, 3865),
(3868, 'SIC', 5699, 'Miscellaneous Apparel & Accessory Stores', 4, 3867),
(2632, 'SEC', 5712, 'Furniture Stores', 4, 2631),
(3871, 'SIC', 5712, 'Furniture Stores', 4, 3870),
(3874, 'SIC', 5719, 'Miscellaneous Homefurnishings Stores', 4, 3870),
(3873, 'SIC', 5714, 'Drapery & Upholstery Stores', 4, 3870),
(3872, 'SIC', 5713, 'Floor Covering Stores', 4, 3870),
(3876, 'SIC', 5722, 'Household Appliance Stores', 4, 3875),
(2634, 'SEC', 5731, 'Radio, TV & Electronic Stores', 4, 2633),
(2636, 'SEC', 5735, 'Record & Prerecorded Tape Stores', 4, 2633),
(2635, 'SEC', 5734, 'Computer & Software Stores', 4, 2633),
(3880, 'SIC', 5735, 'Record & Prerecorded Tape Stores', 4, 3877),
(3878, 'SIC', 5731, 'Radio, TV & Electronic Stores', 4, 3877),
(3881, 'SIC', 5736, 'Musical Instrument Stores', 4, 3877),
(3879, 'SIC', 5734, 'Computer & Software Stores', 4, 3877),
(2639, 'SEC', 5812, 'Caterers & Banquet Halls', 4, 2638),
(3885, 'SIC', 5813, 'Drinking Places', 4, 3883),
(3884, 'SIC', 5812, 'Caterers & Banquet Halls', 4, 3883),
(2642, 'SEC', 5912, 'Drug Stores & Proprietary Stores', 4, 2641),
(3888, 'SIC', 5912, 'Drug Stores & Proprietary Stores', 4, 3887),
(3920, 'SIC', 6019, 'Central Reserve Depository, nec', 4, 3918),
(2651, 'SEC', 6021, 'National Commercial Banks', 4, 2650),
(2652, 'SEC', 6022, 'State Commercial Banks', 4, 2650),
(2653, 'SEC', 6029, 'Commercial Banks, nec', 4, 2650),
(3923, 'SIC', 6022, 'State Commercial Banks', 4, 3921),
(3922, 'SIC', 6021, 'National Commercial Banks', 4, 3921),
(3924, 'SIC', 6029, 'Commercial Banks, nec', 4, 3921),
(2656, 'SEC', 6036, 'Savings Institutions, Except Federal', 4, 2654),
(2655, 'SEC', 6035, 'Federal Savings Institutions', 4, 2654),
(3927, 'SIC', 6036, 'Savings Institutions, Except Federal', 4, 3925),
(3926, 'SIC', 6035, 'Federal Savings Institutions', 4, 3925),
(3930, 'SIC', 6062, 'State Credit Unions', 4, 3928),
(3929, 'SIC', 6061, 'Federal Credit Unions', 4, 3928),
(3932, 'SIC', 6081, 'Foreign Bank & Branches & Agencies', 4, 3931),
(3933, 'SIC', 6082, 'Foreign Trade & International Banks', 4, 3931),
(2658, 'SEC', 6099, 'Functions Related to Deposit Banking', 4, 2657),
(3936, 'SIC', 6099, 'Functions Related to Deposit Banking', 4, 3934),
(3935, 'SIC', 6091, 'Nondeposit Trust Facilities', 4, 3934),
(2661, 'SEC', 6111, 'Federal & Federally Sponsored Credit Agencies', 4, 2660),
(3939, 'SIC', 6111, 'Federal & Federally Sponsored Credit Agencies', 4, 3938),
(2663, 'SEC', 6141, 'Personal Credit Unions', 4, 2662),
(3941, 'SIC', 6141, 'Personal Credit Unions', 4, 3940),
(2665, 'SEC', 6153, 'Short Term Business Credit', 4, 2664),
(2666, 'SEC', 6159, 'Misc. Business Credit Institutions', 4, 2664),
(3944, 'SIC', 6159, 'Misc. Business Credit Institutions', 4, 3942),
(3943, 'SIC', 6153, 'Short Term Business Credit', 4, 3942),
(2669, 'SEC', 6163, 'Loan Brokers', 4, 2667),
(2668, 'SEC', 6162, 'Mortgage Bankers & Correspondents', 4, 2667),
(3946, 'SIC', 6162, 'Mortgage Bankers & Correspondents', 4, 3945),
(3947, 'SIC', 6163, 'Loan Brokers', 4, 3945),
(2672, 'SEC', 6211, 'Security Brokers & Dealers', 4, 2671),
(3950, 'SIC', 6211, 'Security Brokers & Dealers', 4, 3949),
(2674, 'SEC', 6221, 'Commodity Contracts Brokers, Dealers', 4, 2673),
(3952, 'SIC', 6221, 'Commodity Contracts Brokers, Dealers', 4, 3951),
(3954, 'SIC', 6231, 'Security & Commodity Exchanges', 4, 3953),
(2676, 'SEC', 6282, 'Investment Advice', 4, 2675),
(3957, 'SIC', 6289, 'Security & Commodity Services, nec', 4, 3955),
(3956, 'SIC', 6282, 'Investment Advice', 4, 3955),
(2679, 'SEC', 6311, 'Life Insurance', 4, 2678),
(3960, 'SIC', 6311, 'Life Insurance', 4, 3959),
(2682, 'SEC', 6324, 'Hospital & Medical Service Plans', 4, 2680),
(2681, 'SEC', 6321, 'Accident & Health Insurance', 4, 2680),
(3962, 'SIC', 6321, 'Accident & Health Insurance', 4, 3961),
(3963, 'SIC', 6324, 'Hospital & Medical Service Plans', 4, 3961),
(2684, 'SEC', 6331, 'Fire, Marine & Casualty Insurance', 4, 2683),
(3965, 'SIC', 6331, 'Fire, Marine & Casualty Insurance', 4, 3964),
(2686, 'SEC', 6351, 'Surety Insurance', 4, 2685),
(3967, 'SIC', 6351, 'Surety Insurance', 4, 3966),
(2688, 'SEC', 6361, 'Title Insurance', 4, 2687),
(3969, 'SIC', 6361, 'Title Insurance', 4, 3968),
(3971, 'SIC', 6371, 'Pension, Health & Welfare Funds', 4, 3970),
(2690, 'SEC', 6399, 'Insurance Carriers, nec', 4, 2689),
(3973, 'SIC', 6399, 'Insurance Carriers, nec', 4, 3972),
(2693, 'SEC', 6411, 'Insurance Agents, Brokers & Service', 4, 2692),
(3976, 'SIC', 6411, 'Insurance Agents, Brokers & Service', 4, 3975),
(2696, 'SEC', 6512, 'Nonresidential Building Operators', 4, 2695),
(2698, 'SEC', 6519, 'Real Property Lessors, nec', 4, 2695),
(2697, 'SEC', 6513, 'Apartment Building Operators', 4, 2695),
(3983, 'SIC', 6517, 'Railroad Property Lessors', 4, 3978),
(3984, 'SIC', 6519, 'Real Property Lessors, nec', 4, 3978),
(3979, 'SIC', 6512, 'Nonresidential Building Operators', 4, 3978),
(3980, 'SIC', 6513, 'Apartment Building Operators', 4, 3978),
(3981, 'SIC', 6514, 'Dwelling Operators, Except Apartments', 4, 3978),
(3982, 'SIC', 6515, 'Mobile Home Site Operators', 4, 3978),
(2700, 'SEC', 6531, 'Real Estate Agents & Managers', 4, 2699),
(3986, 'SIC', 6531, 'Real Estate Agents & Managers', 4, 3985),
(3988, 'SIC', 6541, 'Title Abstract Offices', 4, 3987),
(2702, 'SEC', 6552, 'Subdividers & Developers, nec', 4, 2701),
(3990, 'SIC', 6552, 'Subdividers & Developers, nec', 4, 3989),
(3991, 'SIC', 6553, 'Cemetery Subdividers & Developers', 4, 3989),
(3994, 'SIC', 6712, 'Bank Holding Companies', 4, 3993),
(3995, 'SIC', 6719, 'Holding Companies, nec', 4, 3993),
(4025, 'SIC', 7218, 'Industrial Launderers', 4, 4018),
(4026, 'SIC', 7219, 'Laundry & Garment Services, nec', 4, 4018),
(4019, 'SIC', 7211, 'Power Laundries, Family & Commercial', 4, 4018),
(4028, 'SIC', 7221, 'Photographic Studios, Portrait', 4, 4027),
(4030, 'SIC', 7231, 'Beauty Shops', 4, 4029),
(4032, 'SIC', 7241, 'Barber Shops', 4, 4031),
(4034, 'SIC', 7251, 'Shoe Repair & Shoeshine Parlors', 4, 4033),
(4036, 'SIC', 7261, 'Funeral Service & Crematories', 4, 4035),
(4039, 'SIC', 7299, 'Miscellaneous Personal Services, nec', 4, 4037),
(4038, 'SIC', 7291, 'Tax Return Preparation Services', 4, 4037),
(2715, 'SEC', 7311, 'Advertising Agencies', 4, 2714),
(4042, 'SIC', 7311, 'Advertising Agencies', 4, 4041),
(4044, 'SIC', 7313, 'Radio, TV Publisher Representatives', 4, 4041),
(4045, 'SIC', 7319, 'Advertising, nec', 4, 4041),
(4043, 'SIC', 7312, 'Outdoor Advertising Services', 4, 4041),
(4047, 'SIC', 7322, 'Adjustment & Collection Services', 4, 4046),
(4048, 'SIC', 7323, 'Credit Reporting Services', 4, 4046),
(2718, 'SEC', 7331, 'Direct Mail Advertising Services', 4, 2717),
(4050, 'SIC', 7331, 'Direct Mail Advertising Services', 4, 4049),
(4051, 'SIC', 7334, 'Photocopying & Duplicating Services', 4, 4049),
(4052, 'SIC', 7335, 'Commercial Photography', 4, 4049),
(4053, 'SIC', 7336, 'Commercial Art & Graphic Design', 4, 4049),
(4054, 'SIC', 7338, 'Secretarial & Court Reporting', 4, 4049),
(4057, 'SIC', 7349, 'Building Maintenance Services, nec', 4, 4055),
(4056, 'SIC', 7342, 'Disinfecting & Pest Control Services', 4, 4055),
(2721, 'SEC', 7359, 'Misc. Equipment Rental & Leasing, nec', 4, 2720),
(4061, 'SIC', 7359, 'Misc. Equipment Rental & Leasing, nec', 4, 4058),
(4059, 'SIC', 7352, 'Medical Equipment Rental', 4, 4058),
(4060, 'SIC', 7353, 'Heavy Construction Equipment Rental', 4, 4058),
(2723, 'SEC', 7361, 'Employment Agencies', 4, 2722),
(2724, 'SEC', 7363, 'Help Supply Services', 4, 2722),
(4063, 'SIC', 7361, 'Employment Agencies', 4, 4062),
(4064, 'SIC', 7363, 'Help Supply Services', 4, 4062),
(2727, 'SEC', 7372, 'Prepackaged Software', 4, 2725),
(2730, 'SEC', 7377, 'Computer Rental & Leasing', 4, 2725),
(2729, 'SEC', 7374, 'Data Processing & Preparation', 4, 2725),
(2728, 'SEC', 7373, 'Computer Integrated Systems Design', 4, 2725),
(2726, 'SEC', 7371, 'Computer Programming Services', 4, 2725),
(4071, 'SIC', 7376, 'Computer Facilities Management', 4, 4065),
(4069, 'SIC', 7374, 'Data Processing & Preparation', 4, 4065),
(4068, 'SIC', 7373, 'Computer Integrated Systems Design', 4, 4065),
(4119, 'SIC', 7829, 'Motion Picture Distribution Services', 4, 4117),
(4118, 'SIC', 7822, 'Motion Picture & Tape Distribution', 4, 4117),
(4121, 'SIC', 7832, 'Motion Picture Theaters, Except Drive-In', 4, 4120),
(4122, 'SIC', 7833, 'Drive-In Motion Picture Theaters', 4, 4120),
(2747, 'SEC', 7841, 'Video Tape Rental', 4, 2746),
(4124, 'SIC', 7841, 'Video Tape Rental', 4, 4123),
(4127, 'SIC', 7911, 'Dance Studios, Schools & Halls', 4, 4126),
(4129, 'SIC', 7922, 'Theatrical Producers & Services', 4, 4128),
(4130, 'SIC', 7929, 'Entertainers & Entertainment Groups', 4, 4128),
(4132, 'SIC', 7933, 'Bowling Centers', 4, 4131),
(2750, 'SEC', 7948, 'Racing, Including Track Operation', 4, 2749),
(4134, 'SIC', 7941, 'Sports Clubs, Managers & Promoters', 4, 4133),
(4135, 'SIC', 7948, 'Racing, Including Track Operation', 4, 4133),
(4137, 'SIC', 7951, 'Ski Facilities, Down Hill', 4, 4136),
(4138, 'SIC', 7952, 'Ski Facilities, Cross Country', 4, 4136),
(2752, 'SEC', 7997, 'Membership Sports & Recreation Clubs', 4, 2751),
(4140, 'SIC', 7991, 'Physical Fitness Facilities', 4, 4139),
(4145, 'SIC', 7999, 'Amusement & Recreation, nec', 4, 4139),
(4144, 'SIC', 7997, 'Membership Sports & Recreation Clubs', 4, 4139),
(4143, 'SIC', 7996, 'Amusement Parks', 4, 4139),
(4142, 'SIC', 7993, 'Coin-Operated Amusement Devices', 4, 4139),
(4141, 'SIC', 7992, 'Public Golf Courses', 4, 4139),
(2755, 'SEC', 8011, 'Offices & Clinics of Medical Doctors', 4, 2754),
(4148, 'SIC', 8011, 'Offices & Clinics of Medical Doctors', 4, 4147),
(4150, 'SIC', 8021, 'Offices & Clinics of Dentists', 4, 4149),
(4152, 'SIC', 8031, 'Offices of Osteopathic Physicians', 4, 4151),
(4157, 'SIC', 8049, 'Offices of Health Practitioners, nec', 4, 4153),
(4156, 'SIC', 8043, 'Offices & Clinics of Podiatrists', 4, 4153),
(4180, 'SIC', 8211, 'Elementary & Secondary Schools', 4, 4179),
(4182, 'SIC', 8221, 'Colleges & Universities', 4, 4181),
(4183, 'SIC', 8222, 'Junior Colleges', 4, 4181),
(4185, 'SIC', 8231, 'Libraries', 4, 4184),
(4187, 'SIC', 8243, 'Data Processing Schools', 4, 4186),
(4189, 'SIC', 8249, 'Vocational Schools, nec', 4, 4186),
(4188, 'SIC', 8244, 'Business & Secretarial Schools', 4, 4186),
(4191, 'SIC', 8299, 'Schools & Educational Services, nec', 4, 4190),
(4194, 'SIC', 8322, 'Individual & Family Services', 4, 4193),
(4196, 'SIC', 8331, 'Job Training & Related Services', 4, 4195),
(2772, 'SEC', 8351, 'Child Day Care Services', 4, 2771),
(4198, 'SIC', 8351, 'Child Day Care Services', 4, 4197),
(4200, 'SIC', 8361, 'Residential Care', 4, 4199),
(4202, 'SIC', 8399, 'Social Services, nec', 4, 4201),
(4205, 'SIC', 8412, 'Museums & Art Galleries', 4, 4204),
(4207, 'SIC', 8422, 'Botanical & Zoological Gardens', 4, 4206),
(4210, 'SIC', 8611, 'Business Associations', 4, 4209),
(4212, 'SIC', 8621, 'Professional Organizations', 4, 4211),
(4214, 'SIC', 8631, 'Labor Organizations', 4, 4213),
(4216, 'SIC', 8641, 'Civic & Social Organizations', 4, 4215),
(4218, 'SIC', 8651, 'Political Organizations', 4, 4217),
(4220, 'SIC', 8661, 'Religious Organizations', 4, 4219),
(4222, 'SIC', 8699, 'Membership Organizations, nec', 4, 4221),
(2776, 'SEC', 8711, 'Engineering Services', 4, 2775),
(4226, 'SIC', 8712, 'Architectural Services', 4, 4224),
(4227, 'SIC', 8713, 'Surveying Services', 4, 4224),
(4225, 'SIC', 8711, 'Engineering Services', 4, 4224),
(4229, 'SIC', 8721, 'Accounting, Auditing & Bookkeeping', 4, 4228),
(2778, 'SEC', 8731, 'Commercial Physical Research', 4, 2777),
(2779, 'SEC', 8734, 'Testing Laboratories', 4, 2777),
(4232, 'SIC', 8732, 'Commercial Nonphysical Research', 4, 4230),
(4234, 'SIC', 8734, 'Testing Laboratories', 4, 4230),
(4231, 'SIC', 8731, 'Commercial Physical Research', 4, 4230),
(4233, 'SIC', 8733, 'Noncommercial Research Organizations', 4, 4230),
(2781, 'SEC', 8741, 'Management Services', 4, 2780),
(2783, 'SEC', 8744, 'Facilities Support Services', 4, 2780),
(2782, 'SEC', 8742, 'Management Consulting Services', 4, 2780),
(4249, 'SIC', 9111, 'Executive Offices', 4, 4248),
(4251, 'SIC', 9121, 'Legislative Bodies', 4, 4250),
(4253, 'SIC', 9131, 'Executive & Legislative Combined', 4, 4252),
(4255, 'SIC', 9191, 'General Government, nec', 4, 4254),
(4258, 'SIC', 9211, 'Courts', 4, 4257),
(4261, 'SIC', 9222, 'Legal Counsel & Prosecution', 4, 4259),
(4262, 'SIC', 9223, 'Correctional Institutions', 4, 4259),
(4263, 'SIC', 9224, 'Fire Protection', 4, 4259),
(4264, 'SIC', 9229, 'Public Order & Safety, nec', 4, 4259),
(4260, 'SIC', 9221, 'Police Protection', 4, 4259),
(4267, 'SIC', 9311, 'Finance, Taxation & Monetary Policy', 4, 4266),
(4270, 'SIC', 9411, 'Admin. of Educational Programs', 4, 4269),
(4272, 'SIC', 9431, 'Admin. of Public Health Programs', 4, 4271),
(4274, 'SIC', 9441, 'Admin. of Social & Manpower Programs', 4, 4273),
(4276, 'SIC', 9451, 'Administration of Veteran''s Affairs', 4, 4275),
(4280, 'SIC', 9512, 'Land, Mineral, Wildlife Conservation', 4, 4278),
(4279, 'SIC', 9511, 'Air, Water & Solid Waste Management', 4, 4278),
(4283, 'SIC', 9532, 'Urban & Community Development', 4, 4281),
(4282, 'SIC', 9531, 'Housing Programs', 4, 4281),
(4286, 'SIC', 9611, 'Administration of General Economic Programs', 4, 4285),
(4288, 'SIC', 9621, 'Regulation, Admin. of Transportation', 4, 4287),
(4290, 'SIC', 9631, 'Regulation, Admin. of Utilities', 4, 4289),
(1321, 'NAICS', 4855, 'Charter Bus Industry', 3, 1303),
(2163, 'NAICS', 92216, 'Fire Protection', 4, 2151),
(3127, 'SIC', 2420, 'Sawmills & Planing Mills', 3, 3124),
(3840, 'SIC', 5520, 'Used Car Dealers', 3, 3837),
(2210, 'SEC', 100, 'AGRICULTURAL PRODUCTION - CROPS', 2, 2788),
(2212, 'SEC', 700, 'AGRICULTURAL SERVICES', 2, 2788),
(2211, 'SEC', 200, 'AGRICULTURAL PRODUCTION - LIVESTOCK', 2, 2788),
(2875, 'SIC', 900, 'FISHING, HUNTING & TRAPPING', 2, 4305),
(2798, 'SIC', 100, 'AGRICULTURAL PRODUCTION - CROPS', 2, 4305),
(2825, 'SIC', 200, 'AGRICULTURAL PRODUCTION - LIVESTOCK', 2, 4305),
(2847, 'SIC', 700, 'AGRICULTURAL SERVICES', 2, 4305),
(2820, 'SIC', 180, 'Horticultural Specialties', 3, 2798),
(2805, 'SIC', 130, 'Field Crops, Except Cash Grains', 3, 2798),
(2811, 'SIC', 160, 'Vegetables & Melons', 3, 2798),
(2823, 'SIC', 190, 'General Farms, Primarily Crop', 3, 2798),
(2813, 'SIC', 170, 'Fruits & Tree Nuts', 3, 2798),
(2897, 'SIC', 1081, 'Metal Mining Services', 4, 2896),
(2899, 'SIC', 1094, 'Uranium Radium Vanadium Ores', 4, 2898),
(2220, 'SEC', 1221, 'Bituminous Coal & Lignite - Surface', 4, 2219),
(2903, 'SIC', 1221, 'Bituminous Coal & Lignite - Surface', 4, 2902),
(2904, 'SIC', 1222, 'Bituminous Coal - Underground', 4, 2902),
(2906, 'SIC', 1231, 'Anthracite Mining', 4, 2905),
(2908, 'SIC', 1241, 'Coal Mining Services', 4, 2907),
(2218, 'SEC', 1200, 'COAL MINING', 2, 2789),
(2959, 'SIC', 1721, 'Painting & Paper Hanging', 4, 2958),
(2239, 'SEC', 1731, 'Electrical Work', 4, 2238),
(2961, 'SIC', 1731, 'Electrical Work', 4, 2960),
(2965, 'SIC', 1743, 'Terrazzo, Tile, Marble, Mosaic Work', 4, 2962),
(2964, 'SIC', 1742, 'Plastering, Drywall & Insulation', 4, 2962),
(2963, 'SIC', 1741, 'Masonry & Other Stonework', 4, 2962),
(2968, 'SIC', 1752, 'Floor Laying & Floor Work, nec', 4, 2966),
(2967, 'SIC', 1751, 'Carpentry Work', 4, 2966),
(2970, 'SIC', 1761, 'Roofing, Siding & Sheet Metal Work', 4, 2969),
(2972, 'SIC', 1771, 'Concrete Work', 4, 2971),
(2974, 'SIC', 1781, 'Water Well Drilling', 4, 2973),
(2977, 'SIC', 1793, 'Glass & Glazing Work', 4, 2975),
(3013, 'SIC', 2061, 'Raw Cane Sugar', 4, 3012),
(3014, 'SIC', 2062, 'Cane Sugar Refining', 4, 3012),
(3021, 'SIC', 2074, 'Cottonseed Oil Mills', 4, 3020),
(3025, 'SIC', 2079, 'Edible Fats & Oils, nec', 4, 3020),
(3024, 'SIC', 2077, 'Animal & Marine Fats & Oils', 4, 3020),
(3023, 'SIC', 2076, 'Vegetable Oil Mills, nec', 4, 3020),
(3022, 'SIC', 2075, 'Soybean Oil Mills', 4, 3020),
(2256, 'SEC', 2086, 'Bottled & Canned Soft Drinks', 4, 2254),
(2255, 'SEC', 2082, 'Malt Beverages', 4, 2254),
(3029, 'SIC', 2084, 'Wines, Brandy & Brandy Spirits', 4, 3026),
(3028, 'SIC', 2083, 'Malt', 4, 3026),
(3027, 'SIC', 2082, 'Malt Beverages', 4, 3026),
(3031, 'SIC', 2086, 'Bottled & Canned Soft Drinks', 4, 3026),
(3030, 'SIC', 2085, 'Distilled & Blended Liquors', 4, 3026),
(3032, 'SIC', 2087, 'Flavoring Extracts & Syrups, nec', 4, 3026),
(2258, 'SEC', 2092, 'Fresh or Frozen Prepared Fish', 4, 2257),
(3034, 'SIC', 2091, 'Canned & Cured Fish & Seafoods', 4, 3033),
(3039, 'SIC', 2098, 'Macaroni & Spaghetti', 4, 3033),
(3038, 'SIC', 2097, 'Manufactured Ice', 4, 3033),
(3037, 'SIC', 2096, 'Potato Chips & Similar Snacks', 4, 3033),
(3035, 'SIC', 2092, 'Fresh or Frozen Prepared Fish', 4, 3033),
(3036, 'SIC', 2095, 'Roasted Coffee', 4, 3033),
(2261, 'SEC', 2111, 'Cigarettes', 4, 2260),
(3043, 'SIC', 2111, 'Cigarettes', 4, 3042),
(3045, 'SIC', 2121, 'Cigars', 4, 3044),
(3047, 'SIC', 2131, 'Chewing & Smoking Tobacco', 4, 3046),
(3049, 'SIC', 2141, 'Tobacco Stemming & Redrying', 4, 3048),
(2264, 'SEC', 2211, 'Broadwoven Fabric Mills, Cotton', 4, 2263),
(3052, 'SIC', 2211, 'Broadwoven Fabric Mills, Cotton', 4, 3051),
(2266, 'SEC', 2221, 'Broadwoven Fabric Mills, Manmade', 4, 2265),
(3054, 'SIC', 2221, 'Broadwoven Fabric Mills, Manmade', 4, 3053),
(3056, 'SIC', 2231, 'Broadwoven Fabric Mills, Wool', 4, 3055),
(3058, 'SIC', 2241, 'Narrow Fabric Mills', 4, 3057),
(2268, 'SEC', 2253, 'Knit Outerwear Mills', 4, 2267),
(3062, 'SIC', 2253, 'Knit Outerwear Mills', 4, 3059),
(3066, 'SIC', 2259, 'Knitting Mills, nec', 4, 3059),
(3065, 'SIC', 2258, 'Lace & Warp Knit Fabric Mills', 4, 3059),
(3064, 'SIC', 2257, 'Weft Knit Fabric Mills', 4, 3059),
(3063, 'SIC', 2254, 'Knit Underwear Mills', 4, 3059),
(3061, 'SIC', 2252, 'Hosiery, nec', 4, 3059),
(3060, 'SIC', 2251, 'Women''s Hosiery, Except Socks', 4, 3059),
(3068, 'SIC', 2261, 'Finishing Plants, Cotton', 4, 3067),
(3069, 'SIC', 2262, 'Finishing Plants, Manmade', 4, 3067),
(3070, 'SIC', 2269, 'Finishing Plants, nec', 4, 3067),
(2270, 'SEC', 2273, 'Carpets & Rugs', 4, 2269),
(2260, 'SEC', 2110, 'Cigarettes', 3, 2259),
(3102, 'SIC', 2353, 'Hats, Caps & Millinery', 4, 3101),
(3104, 'SIC', 2361, 'Girls & Children''s Dresses & Blouses', 4, 3103),
(3105, 'SIC', 2369, 'Girls & Children''s Outerwear, nec', 4, 3103),
(3109, 'SIC', 2381, 'Fabric Dress & Work Gloves', 4, 3108),
(3113, 'SIC', 2387, 'Apparel Belts', 4, 3108),
(3114, 'SIC', 2389, 'Apparel & Accessories, nec', 4, 3108),
(3112, 'SIC', 2386, 'Leather & Sheep-Lined Clothing', 4, 3108),
(3111, 'SIC', 2385, 'Waterproof Outerwear', 4, 3108),
(3110, 'SIC', 2384, 'Robes & Dressing Gowns', 4, 3108),
(3120, 'SIC', 2395, 'Pleating & Stitching', 4, 3115),
(3122, 'SIC', 2397, 'Schiffli Machine Embroideries', 4, 3115),
(3116, 'SIC', 2391, 'Curtains & Draperies', 4, 3115),
(3123, 'SIC', 2399, 'Fabricated Textile Products, nec', 4, 3115),
(3117, 'SIC', 2392, 'House Furnishings, nec', 4, 3115),
(3118, 'SIC', 2393, 'Textile Bags', 4, 3115),
(3119, 'SIC', 2394, 'Canvas & Related Products', 4, 3115),
(3121, 'SIC', 2396, 'Automotive & Apparel Trimmings', 4, 3115),
(3126, 'SIC', 2411, 'Logging', 4, 3125),
(2278, 'SEC', 2421, 'Sawmills & Planing Mills, General', 4, 2277),
(3128, 'SIC', 2421, 'Sawmills & Planing Mills, General', 4, 3127),
(3130, 'SIC', 2429, 'Special Product Sawmills, nec', 4, 3127),
(3129, 'SIC', 2426, 'Hardwood Dimension & Flooring Mills', 4, 3127),
(3134, 'SIC', 2435, 'Hardwood Veneer & Plywood', 4, 3131),
(3133, 'SIC', 2434, 'Wood Kitchen Cabinets', 4, 3131),
(3132, 'SIC', 2431, 'Millwork', 4, 3131),
(3136, 'SIC', 2439, 'Structural Wood Members, nec', 4, 3131),
(3135, 'SIC', 2436, 'Softwood Veneer & Plywood', 4, 3131),
(3139, 'SIC', 2448, 'Wood Pallets & Skids', 4, 3137),
(3138, 'SIC', 2441, 'Nailed Wood Boxes & Shook', 4, 3137),
(3140, 'SIC', 2449, 'Wood Containers, nec', 4, 3137),
(2281, 'SEC', 2451, 'Mobile Homes', 4, 2280),
(2282, 'SEC', 2452, 'Prefabricated Wood Buildings', 4, 2280),
(3142, 'SIC', 2451, 'Mobile Homes', 4, 3141),
(3143, 'SIC', 2452, 'Prefabricated Wood Buildings', 4, 3141),
(3106, 'SIC', 2370, 'Fur Goods', 3, 3083),
(3181, 'SIC', 2671, 'Paper Coated & Laminated, Packaging', 4, 3180),
(3182, 'SIC', 2672, 'Paper Coated & Laminated, nec', 4, 3180),
(2304, 'SEC', 2711, 'Newspapers', 4, 2303),
(3192, 'SIC', 2711, 'Newspapers', 4, 3191),
(2306, 'SEC', 2721, 'Periodicals', 4, 2305),
(3194, 'SIC', 2721, 'Periodicals', 4, 3193),
(2309, 'SEC', 2732, 'Book Printing', 4, 2307),
(2308, 'SEC', 2731, 'Book Publishing', 4, 2307),
(3224, 'SIC', 2824, 'Organic Fibers, Noncellulosic', 4, 3220),
(2326, 'SEC', 2835, 'Diagnostic Substances', 4, 2323),
(2327, 'SEC', 2836, 'Biological Products, Except Diagnostic', 4, 2323),
(2324, 'SEC', 2833, 'Medicinals & Botanicals', 4, 2323),
(2325, 'SEC', 2834, 'Pharmaceutical Preparations', 4, 2323),
(3229, 'SIC', 2836, 'Biological Products, Except Diagnostic', 4, 3225),
(3226, 'SIC', 2833, 'Medicinals & Botanicals', 4, 3225),
(3228, 'SIC', 2835, 'Diagnostic Substances', 4, 3225),
(3227, 'SIC', 2834, 'Pharmaceutical Preparations', 4, 3225),
(2329, 'SEC', 2842, 'Polishes & Sanitation Goods', 4, 2328),
(2330, 'SEC', 2844, 'Perfumes & Cosmetics -Toilet Preparations', 4, 2328),
(3231, 'SIC', 2841, 'Soap & Other Detergents', 4, 3230),
(3232, 'SIC', 2842, 'Polishes & Sanitation Goods', 4, 3230),
(3233, 'SIC', 2843, 'Surface Active Agents', 4, 3230),
(3234, 'SIC', 2844, 'Perfumes & Cosmetics -Toilet Preparations', 4, 3230),
(2332, 'SEC', 2851, 'Paints & Allied Products', 4, 2331),
(3236, 'SIC', 2851, 'Paints & Allied Products', 4, 3235),
(3240, 'SIC', 2869, 'Industrial Organic Chemicals, nec', 4, 3237),
(3238, 'SIC', 2861, 'Gum & Wood Chemicals', 4, 3237),
(3239, 'SIC', 2865, 'Cyclic Crudes & Intermediates', 4, 3237);
-- max 1000 values in MS SQL SERVER
INSERT INTO industry (industry_id, industry_classification, industry_code, industry_description, depth, parent_id) VALUES
(3244, 'SIC', 2875, 'Fertilizers, Mixing Only', 4, 3241),
(3245, 'SIC', 2879, 'Agricultural Chemicals, nec', 4, 3241),
(3243, 'SIC', 2874, 'Phosphatic Fertilizers', 4, 3241),
(3242, 'SIC', 2873, 'Nitrogenous Fertilizers', 4, 3241),
(2336, 'SEC', 2891, 'Adhesives & Sealants', 4, 2335),
(3251, 'SIC', 2899, 'Chemical Preparations, nec', 4, 3246),
(3247, 'SIC', 2891, 'Adhesives & Sealants', 4, 3246),
(3249, 'SIC', 2893, 'Printing Ink', 4, 3246),
(3250, 'SIC', 2895, 'Carbon Black', 4, 3246),
(2339, 'SEC', 2911, 'Petroleum Refining', 4, 2338),
(3254, 'SIC', 2911, 'Petroleum Refining', 4, 3253),
(3256, 'SIC', 2951, 'Asphalt Paving Mixtures & Blocks', 4, 3255),
(3257, 'SIC', 2952, 'Asphalt Felts & Coatings', 4, 3255),
(3260, 'SIC', 2999, 'Petroleum & Coal Products, nec', 4, 3258),
(2363, 'SEC', 3241, 'Cement, Hydraulic', 4, 2362),
(3310, 'SIC', 3241, 'Cement, Hydraulic', 4, 3309),
(3313, 'SIC', 3253, 'Ceramic Wall & Floor Tile', 4, 3311),
(3314, 'SIC', 3255, 'Clay Refectories', 4, 3311),
(3315, 'SIC', 3259, 'Structural Clay Products, nec', 4, 3311),
(3312, 'SIC', 3251, 'Brick & Structural Clay Tile', 4, 3311),
(3351, 'SIC', 3334, 'Primary Aluminum', 4, 3349),
(3352, 'SIC', 3339, 'Primary Nonferrous Metals, nec', 4, 3349),
(3350, 'SIC', 3331, 'Primary Copper', 4, 3349),
(2379, 'SEC', 3341, 'Secondary Nonferrous Metals', 4, 2378),
(3354, 'SIC', 3341, 'Secondary Nonferrous Metals', 4, 3353),
(2381, 'SEC', 3357, 'Nonferrous Wiredrawing & Insulating', 4, 2380),
(3357, 'SIC', 3353, 'Aluminum Sheet, Plate & Foil', 4, 3355),
(3359, 'SIC', 3355, 'Aluminum Rolling & Drawing, nec', 4, 3355),
(3361, 'SIC', 3357, 'Nonferrous Wiredrawing & Insulating', 4, 3355),
(3360, 'SIC', 3356, 'Nonferrous Rolling & Drawing, nec', 4, 3355),
(3356, 'SIC', 3351, 'Copper Rolling & Drawing', 4, 3355),
(3358, 'SIC', 3354, 'Aluminum Extruded Products', 4, 3355),
(3365, 'SIC', 3365, 'Aluminum Foundries', 4, 3362),
(3367, 'SIC', 3369, 'Nonferrous Foundries, nec', 4, 3362),
(3364, 'SIC', 3364, 'Nonferrous Die Castings, Except Aluminum', 4, 3362),
(3366, 'SIC', 3366, 'Copper Foundries', 4, 3362),
(3363, 'SIC', 3363, 'Aluminum Die Castings', 4, 3362),
(3370, 'SIC', 3399, 'Primary Metal Products, nec', 4, 3368),
(3369, 'SIC', 3398, 'Metal Heat Treating', 4, 3368),
(2400, 'SEC', 3470, 'Metal Services, nec', 3, 2384),
(3385, 'SIC', 3441, 'Fabricated Structural Metal', 4, 3384),
(2398, 'SEC', 3452, 'Bolts, Nuts, Rivets & Washers', 4, 2396),
(2397, 'SEC', 3451, 'Screw Machine Products', 4, 2396),
(3394, 'SIC', 3452, 'Bolts, Nuts, Rivets & Washers', 4, 3392),
(3393, 'SIC', 3451, 'Screw Machine Products', 4, 3392),
(3399, 'SIC', 3466, 'Crowns & Closures', 4, 3395),
(3400, 'SIC', 3469, 'Metal Stampings, nec', 4, 3395),
(3396, 'SIC', 3462, 'Iron & Steel Forgings', 4, 3395),
(3397, 'SIC', 3463, 'Nonferrous Forgings', 4, 3395),
(3398, 'SIC', 3465, 'Automotive Stampings', 4, 3395),
(3402, 'SIC', 3471, 'Plating & Polishing', 4, 3401),
(3403, 'SIC', 3479, 'Metal Coating & Allied Services', 4, 3401),
(3406, 'SIC', 3483, 'Ammunition, Except for Small Arms, nec', 4, 3404),
(3405, 'SIC', 3482, 'Small Arms Ammunition', 4, 3404),
(3408, 'SIC', 3489, 'Ordnance & Accessories, nec', 4, 3404),
(3407, 'SIC', 3484, 'Small Arms', 4, 3404),
(3412, 'SIC', 3493, 'Steel Spring, Except Wire', 4, 3409),
(3418, 'SIC', 3499, 'Fabricated Metal Products, nec', 4, 3409),
(3417, 'SIC', 3498, 'Fabricated Pipe & Fittings', 4, 3409),
(3416, 'SIC', 3497, 'Metal Foil & Leaf', 4, 3409),
(3415, 'SIC', 3496, 'Miscellaneous Fabricated Wire Products', 4, 3409),
(3414, 'SIC', 3495, 'Wire Springs', 4, 3409),
(3413, 'SIC', 3494, 'Valves & Pipe Fittings, nec', 4, 3409),
(3411, 'SIC', 3492, 'Fluid Power Valves & Hose Fittings', 4, 3409),
(3410, 'SIC', 3491, 'Industrial Valves', 4, 3409),
(3422, 'SIC', 3519, 'Internal Combustion Engines, nec', 4, 3420),
(3421, 'SIC', 3511, 'Turbines & Turbine Generator Sets', 4, 3420),
(2407, 'SEC', 3524, 'Lawn & Garden Equipment', 4, 2405),
(2406, 'SEC', 3523, 'Farm Machinery & Equipment', 4, 2405),
(3425, 'SIC', 3524, 'Lawn & Garden Equipment', 4, 3423),
(3424, 'SIC', 3523, 'Farm Machinery & Equipment', 4, 3423),
(2412, 'SEC', 3537, 'Industrial Trucks & Tractors', 4, 2408),
(2409, 'SEC', 3531, 'Construction Machinery', 4, 2408),
(2410, 'SEC', 3532, 'Mining Machinery', 4, 2408),
(2411, 'SEC', 3533, 'Oil & Gas Field Machinery', 4, 2408),
(3427, 'SIC', 3531, 'Construction Machinery', 4, 3426),
(3433, 'SIC', 3537, 'Industrial Trucks & Tractors', 4, 3426),
(3450, 'SIC', 3559, 'Special Industry Machinery, nec', 4, 3444),
(3445, 'SIC', 3552, 'Textile Machinery', 4, 3444),
(3447, 'SIC', 3554, 'Paper Industries Machinery', 4, 3444),
(3446, 'SIC', 3553, 'Woodworking Machinery', 4, 3444),
(3448, 'SIC', 3555, 'Printing Trades Machinery', 4, 3444),
(2420, 'SEC', 3562, 'Ball & Roller Bearings', 4, 2418),
(2421, 'SEC', 3564, 'Blowers & Fans', 4, 2418),
(2422, 'SEC', 3567, 'Industrial Furnaces & Ovens', 4, 2418),
(2423, 'SEC', 3569, 'General Industrial Machinery, nec', 4, 2418),
(2419, 'SEC', 3561, 'Pumps & Pumping Equipment', 4, 2418),
(3452, 'SIC', 3561, 'Pumps & Pumping Equipment', 4, 3451),
(3454, 'SIC', 3563, 'Air & Gas Compressors', 4, 3451),
(3455, 'SIC', 3564, 'Blowers & Fans', 4, 3451),
(3456, 'SIC', 3565, 'Packaging Machinery', 4, 3451),
(3457, 'SIC', 3566, 'Speed Changers, Drives & Gears', 4, 3451),
(3458, 'SIC', 3567, 'Industrial Furnaces & Ovens', 4, 3451),
(3459, 'SIC', 3568, 'Power Transmission Equipment, nec', 4, 3451),
(3460, 'SIC', 3569, 'General Industrial Machinery, nec', 4, 3451),
(3453, 'SIC', 3562, 'Ball & Roller Bearings', 4, 3451),
(2426, 'SEC', 3572, 'Computer Storage Devices', 4, 2424),
(2428, 'SEC', 3577, 'Computer Peripheral Equipment, nec', 4, 2424),
(2429, 'SEC', 3578, 'Calculating & Accounting Equipment', 4, 2424),
(2430, 'SEC', 3579, 'Office Machines, nec', 4, 2424),
(2425, 'SEC', 3571, 'Electronic Computers', 4, 2424),
(2427, 'SEC', 3575, 'Computer Terminals', 4, 2424),
(3462, 'SIC', 3571, 'Electronic Computers', 4, 3461),
(3463, 'SIC', 3572, 'Computer Storage Devices', 4, 3461),
(3464, 'SIC', 3575, 'Computer Terminals', 4, 3461),
(3465, 'SIC', 3577, 'Computer Peripheral Equipment, nec', 4, 3461),
(3466, 'SIC', 3578, 'Calculating & Accounting Equipment', 4, 3461),
(3467, 'SIC', 3579, 'Office Machines, nec', 4, 3461),
(2432, 'SEC', 3585, 'Refrigeration & Heating Equipment', 4, 2431),
(3473, 'SIC', 3589, 'Service Industry Machinery, nec', 4, 3468),
(3472, 'SIC', 3586, 'Measuring & Dispensing Pumps', 4, 3468),
(3469, 'SIC', 3581, 'Automatic Vending Machines', 4, 3468),
(3470, 'SIC', 3582, 'Commercial Laundry Equipment', 4, 3468),
(3471, 'SIC', 3585, 'Refrigeration & Heating Equipment', 4, 3468),
(3475, 'SIC', 3592, 'Carburetors, Piston Rings & Valves', 4, 3474),
(3479, 'SIC', 3599, 'Industrial Machinery, nec', 4, 3474),
(3476, 'SIC', 3593, 'Fluid Power Cylinders & Actuators', 4, 3474),
(3477, 'SIC', 3594, 'Fluid Power Pumps & Motors', 4, 3474),
(3478, 'SIC', 3596, 'Scales & Balances, Except Laboratory', 4, 3474),
(2437, 'SEC', 3613, 'Switchgear & Switchboard Apparatus', 4, 2435),
(2436, 'SEC', 3612, 'Transformers, Except Electronic', 4, 2435),
(3503, 'SIC', 3648, 'Lighting Equipment, nec', 4, 3496),
(3501, 'SIC', 3646, 'Commercial Lighting Fixtures', 4, 3496),
(3500, 'SIC', 3645, 'Residential Lighting Fixtures', 4, 3496),
(3499, 'SIC', 3644, 'Noncurrent-Carrying Wiring Devices', 4, 3496),
(3498, 'SIC', 3643, 'Current-Carrying Wiring Devices', 4, 3496),
(3497, 'SIC', 3641, 'Electric Lamps', 4, 3496),
(2444, 'SEC', 3651, 'Household Audio & Video Equipment', 4, 2443),
(2445, 'SEC', 3652, 'Prerecorded Records & Tapes', 4, 2443),
(3506, 'SIC', 3652, 'Prerecorded Records & Tapes', 4, 3504),
(3505, 'SIC', 3651, 'Household Audio & Video Equipment', 4, 3504),
(2449, 'SEC', 3669, 'Communications Equipment, nec', 4, 2446),
(2447, 'SEC', 3661, 'Telephone & Telegraph Apparatus', 4, 2446),
(2448, 'SEC', 3663, 'Radio & TV Communications Equipment', 4, 2446),
(3508, 'SIC', 3661, 'Telephone & Telegraph Apparatus', 4, 3507),
(3509, 'SIC', 3663, 'Radio & TV Communications Equipment', 4, 3507),
(3510, 'SIC', 3669, 'Communications Equipment, nec', 4, 3507),
(2451, 'SEC', 3672, 'Printed Circuit Boards', 4, 2450),
(2453, 'SEC', 3677, 'Electronic Coils & Transformers', 4, 2450),
(2452, 'SEC', 3674, 'Semiconductors & Related Devices', 4, 2450),
(2454, 'SEC', 3678, 'Electronic Connectors', 4, 2450),
(2455, 'SEC', 3679, 'Electronic Components, nec', 4, 2450),
(3516, 'SIC', 3676, 'Electronic Resistors', 4, 3511),
(3519, 'SIC', 3679, 'Electronic Components, nec', 4, 3511),
(3518, 'SIC', 3678, 'Electronic Connectors', 4, 3511),
(3517, 'SIC', 3677, 'Electronic Coils & Transformers', 4, 3511),
(3515, 'SIC', 3675, 'Electronic Capacitors', 4, 3511),
(3514, 'SIC', 3674, 'Semiconductors & Related Devices', 4, 3511),
(3513, 'SIC', 3672, 'Printed Circuit Boards', 4, 3511),
(3512, 'SIC', 3671, 'Electron Tubes', 4, 3511),
(2457, 'SEC', 3695, 'Magnetic & Optical Recording Media', 4, 2456),
(3521, 'SIC', 3691, 'Storage Batteries', 4, 3520),
(3522, 'SIC', 3692, 'Primary Batteries, Dry & Wet', 4, 3520),
(3523, 'SIC', 3694, 'Engine Electrical Equipment', 4, 3520),
(3524, 'SIC', 3695, 'Magnetic & Optical Recording Media', 4, 3520),
(3525, 'SIC', 3699, 'Electrical Equipment & Supplies, nec', 4, 3520),
(2460, 'SEC', 3711, 'Motor Vehicles & Car Bodies', 4, 2459),
(2464, 'SEC', 3716, 'Motor Homes', 4, 2459),
(2463, 'SEC', 3715, 'Truck Trailers', 4, 2459),
(2462, 'SEC', 3714, 'Motor Vehicle Parts & Accessories', 4, 2459),
(2461, 'SEC', 3713, 'Truck & Bus Bodies', 4, 2459),
(3532, 'SIC', 3716, 'Motor Homes', 4, 3527),
(3528, 'SIC', 3711, 'Motor Vehicles & Car Bodies', 4, 3527),
(3530, 'SIC', 3714, 'Motor Vehicle Parts & Accessories', 4, 3527),
(3531, 'SIC', 3715, 'Truck Trailers', 4, 3527),
(3529, 'SIC', 3713, 'Truck & Bus Bodies', 4, 3527),
(2467, 'SEC', 3724, 'Aircraft Engines & Engine Parts', 4, 2465),
(2468, 'SEC', 3728, 'Aircraft Parts & Equipment, nec', 4, 2465),
(2466, 'SEC', 3721, 'Aircraft', 4, 2465),
(3534, 'SIC', 3721, 'Aircraft', 4, 3533),
(3559, 'SIC', 3824, 'Fluid Meters & Counting Devices', 4, 3555),
(3560, 'SIC', 3825, 'Instruments to Measure Electricity', 4, 3555),
(3561, 'SIC', 3826, 'Analytical Instruments', 4, 3555),
(3563, 'SIC', 3829, 'Measuring & Controlling Devices, nec', 4, 3555),
(3562, 'SIC', 3827, 'Optical Instruments & Lenses', 4, 3555),
(3556, 'SIC', 3821, 'Laboratory Apparatus & Furniture', 4, 3555),
(3557, 'SIC', 3822, 'Environmental Controls', 4, 3555),
(3558, 'SIC', 3823, 'Process Control Instruments', 4, 3555),
(2490, 'SEC', 3842, 'Surgical Appliances & Supplies', 4, 2488),
(2491, 'SEC', 3843, 'Dental Equipment & Supplies', 4, 2488),
(2492, 'SEC', 3844, 'X-Ray Apparatus & Tubes', 4, 2488),
(2493, 'SEC', 3845, 'Electromedical Equipment', 4, 2488),
(2489, 'SEC', 3841, 'Surgical & Medical Instruments', 4, 2488),
(3565, 'SIC', 3841, 'Surgical & Medical Instruments', 4, 3564),
(3566, 'SIC', 3842, 'Surgical Appliances & Supplies', 4, 3564),
(3567, 'SIC', 3843, 'Dental Equipment & Supplies', 4, 3564),
(3568, 'SIC', 3844, 'X-Ray Apparatus & Tubes', 4, 3564),
(3569, 'SIC', 3845, 'Electromedical Equipment', 4, 3564),
(2495, 'SEC', 3851, 'Ophthalmic Goods', 4, 2494),
(3571, 'SIC', 3851, 'Ophthalmic Goods', 4, 3570),
(2497, 'SEC', 3861, 'Photographic Equipment & Supplies', 4, 2496),
(3573, 'SIC', 3861, 'Photographic Equipment & Supplies', 4, 3572),
(2499, 'SEC', 3873, 'Watches, Clocks, Watchcases & Parts', 4, 2498),
(3575, 'SIC', 3873, 'Watches, Clocks, Watchcases & Parts', 4, 3574),
(2502, 'SEC', 3911, 'Jewelry, Precious Metal', 4, 2501),
(3580, 'SIC', 3915, 'Jewelers'' Materials & Lapidary Work', 4, 3577),
(3579, 'SIC', 3914, 'Silverware & Plated Ware', 4, 3577),
(3578, 'SIC', 3911, 'Jewelry, Precious Metal', 4, 3577),
(2504, 'SEC', 3931, 'Musical Instruments', 4, 2503),
(3582, 'SIC', 3931, 'Musical Instruments', 4, 3581),
(3632, 'SIC', 4231, 'Trucking Terminal Facilities', 4, 3631),
(3635, 'SIC', 4311, 'US Postal Service', 4, 3634),
(2541, 'SEC', 4812, 'Radiotelephone Communications', 4, 2540),
(2542, 'SEC', 4813, 'Telephone Communications, Except Radio', 4, 2540),
(3682, 'SIC', 4812, 'Radiotelephone Communications', 4, 3681),
(3683, 'SIC', 4813, 'Telephone Communications, Except Radio', 4, 3681),
(2544, 'SEC', 4822, 'Telegraph & Other Communications', 4, 2543),
(3685, 'SIC', 4822, 'Telegraph & Other Communications', 4, 3684),
(2546, 'SEC', 4832, 'Radio Broadcasting Stations', 4, 2545),
(2547, 'SEC', 4833, 'Television Broadcasting Stations', 4, 2545),
(3688, 'SIC', 4833, 'Television Broadcasting Stations', 4, 3686),
(3687, 'SIC', 4832, 'Radio Broadcasting Stations', 4, 3686),
(2549, 'SEC', 4841, 'Cable & Other Pay TV Services', 4, 2548),
(3690, 'SIC', 4841, 'Cable & Other Pay TV Services', 4, 3689),
(2551, 'SEC', 4899, 'Communications Services, nec', 4, 2550),
(3692, 'SIC', 4899, 'Communications Services, nec', 4, 3691),
(3725, 'SIC', 5031, 'Lumber, Plywood & Millwork', 4, 3724),
(3727, 'SIC', 5033, 'Roofing, Siding & Insulation', 4, 3724),
(2576, 'SEC', 5047, 'Medical & Hospital Equipment', 4, 2574),
(2575, 'SEC', 5045, 'Computers, Peripherals & Software', 4, 2574),
(3732, 'SIC', 5045, 'Computers, Peripherals & Software', 4, 3729),
(3736, 'SIC', 5049, 'Professional Equipment, nec', 4, 3729),
(3735, 'SIC', 5048, 'Ophthalmic Goods', 4, 3729),
(3734, 'SIC', 5047, 'Medical & Hospital Equipment', 4, 3729),
(3733, 'SIC', 5046, 'Commercial Equipment, nec', 4, 3729),
(3731, 'SIC', 5044, 'Office Equipment', 4, 3729),
(3730, 'SIC', 5043, 'Photographic Equipment & Supplies', 4, 3729),
(2578, 'SEC', 5051, 'Metals Service Centers & Offices', 4, 2577),
(3738, 'SIC', 5051, 'Metals Service Centers & Offices', 4, 3737),
(3739, 'SIC', 5052, 'Coal & Other Minerals & Ores', 4, 3737),
(2580, 'SEC', 5063, 'Electrical Apparatus & Equipment', 4, 2579),
(2581, 'SEC', 5064, 'Electrical Appliances, TV & Radios', 4, 2579),
(3758, 'SIC', 5092, 'Toys & Hobby Goods & Supplies', 4, 3756),
(3759, 'SIC', 5093, 'Scrap & Waste Materials', 4, 3756),
(3760, 'SIC', 5094, 'Jewelry & Precious Stones', 4, 3756),
(3757, 'SIC', 5091, 'Sporting & Recreational Goods', 4, 3756),
(3766, 'SIC', 5113, 'Industrial & Personal Service Paper', 4, 3763),
(3764, 'SIC', 5111, 'Printing & Writing Paper', 4, 3763),
(3765, 'SIC', 5112, 'Stationery & Office Supplies', 4, 3763),
(2594, 'SEC', 5122, 'Drugs, Proprietaries & Sundries', 4, 2593),
(3768, 'SIC', 5122, 'Drugs, Proprietaries & Sundries', 4, 3767),
(3770, 'SIC', 5131, 'Piece Goods & Notations', 4, 3769),
(3773, 'SIC', 5139, 'Footwear', 4, 3769),
(3772, 'SIC', 5137, 'Women''s & Children''s Clothing', 4, 3769),
(3771, 'SIC', 5136, 'Men''s & Boys'' Clothing', 4, 3769),
(2597, 'SEC', 5141, 'Groceries, General Line', 4, 2596),
(3775, 'SIC', 5141, 'Groceries, General Line', 4, 3774),
(3776, 'SIC', 5142, 'Packaged Frozen Foods', 4, 3774),
(3777, 'SIC', 5143, 'Dairy Products, Except Dried or Canned', 4, 3774),
(3778, 'SIC', 5144, 'Poultry & Poultry Products', 4, 3774),
(3779, 'SIC', 5145, 'Confectionery', 4, 3774),
(3780, 'SIC', 5146, 'Fish & Seafoods', 4, 3774),
(3781, 'SIC', 5147, 'Meat & Meat Products', 4, 3774),
(3783, 'SIC', 5149, 'Groceries & Related Products, nec', 4, 3774),
(3782, 'SIC', 5148, 'Fresh Fruits & Vegetables', 4, 3774),
(3786, 'SIC', 5154, 'Livestock', 4, 3784),
(3785, 'SIC', 5153, 'Grain & Field Beans', 4, 3784),
(3787, 'SIC', 5159, 'Farm-Product Raw Materials, nec', 4, 3784),
(3789, 'SIC', 5162, 'Plastics Materials & Basic Shapes', 4, 3788),
(3790, 'SIC', 5169, 'Chemicals & Allied Products, nec', 4, 3788),
(2601, 'SEC', 5171, 'Petroleum Bulk Stations &Terminals', 4, 2600),
(2602, 'SEC', 5172, 'Petroleum Products, nec', 4, 2600),
(3793, 'SIC', 5172, 'Petroleum Products, nec', 4, 3791),
(3792, 'SIC', 5171, 'Petroleum Bulk Stations &Terminals', 4, 3791),
(3796, 'SIC', 5182, 'Wines & Distilled Beverages', 4, 3794),
(3795, 'SIC', 5181, 'Beer & Ale', 4, 3794),
(3800, 'SIC', 5193, 'Flowers & Florists'' Supplies', 4, 3797),
(3798, 'SIC', 5191, 'Farm Supplies', 4, 3797),
(3799, 'SIC', 5192, 'Books, Periodicals & Newspapers', 4, 3797),
(3803, 'SIC', 5199, 'Nondurable Goods, nec', 4, 3797),
(3802, 'SIC', 5198, 'Paints, Varnishes & Supplies', 4, 3797),
(3801, 'SIC', 5194, 'Tobacco & Tobacco Products', 4, 3797),
(3890, 'SIC', 5921, 'Liquor Stores', 4, 3889),
(3892, 'SIC', 5932, 'Used Merchandise Stores', 4, 3891),
(2644, 'SEC', 5944, 'Jewelers Stores', 4, 2643),
(2645, 'SEC', 5945, 'Hobby, Toy & Game Shops', 4, 2643),
(3896, 'SIC', 5943, 'Stationary Stores', 4, 3893),
(3895, 'SIC', 5942, 'Book Stores', 4, 3893),
(3894, 'SIC', 5941, 'Sporting Goods & Bicycle Shops', 4, 3893),
(3897, 'SIC', 5944, 'Jewelers Stores', 4, 3893),
(3902, 'SIC', 5949, 'Sewing, Needlework & Piece Goods', 4, 3893),
(3901, 'SIC', 5948, 'Luggage & Leather Goods Stores', 4, 3893),
(3900, 'SIC', 5947, 'Gift, Novelty & Souvenir Shops', 4, 3893),
(3899, 'SIC', 5946, 'Camera & Photographic Supply Stores', 4, 3893),
(3898, 'SIC', 5945, 'Hobby, Toy & Game Shops', 4, 3893),
(2647, 'SEC', 5961, 'Catalog & Mail Order Houses', 4, 2646),
(3906, 'SIC', 5963, 'Direct Selling Establishments', 4, 3903),
(3905, 'SIC', 5962, 'Merchandising Machine Operators', 4, 3903),
(3904, 'SIC', 5961, 'Catalog & Mail Order Houses', 4, 3903),
(3910, 'SIC', 5989, 'Fuel Dealers, nec', 4, 3907),
(3909, 'SIC', 5984, 'Liquefied Petroleum Gas Dealers', 4, 3907),
(3908, 'SIC', 5983, 'Fuel Oil Dealers', 4, 3907),
(3915, 'SIC', 5995, 'Optical Goods Stores', 4, 3911),
(3912, 'SIC', 5992, 'Florists', 4, 3911),
(3913, 'SIC', 5993, 'Tobacco Stores & Stands', 4, 3911),
(3914, 'SIC', 5994, 'News Dealers & News Stands', 4, 3911),
(3916, 'SIC', 5999, 'Miscellaneous Retail Stores, nec', 4, 3911),
(3998, 'SIC', 6726, 'Investment Offices, nec', 4, 3996),
(3997, 'SIC', 6722, 'Management Investment Open-End', 4, 3996),
(4000, 'SIC', 6732, 'Education, Religious, Etc. Trusts', 4, 3999),
(4001, 'SIC', 6733, 'Trusts, nec', 4, 3999),
(2706, 'SEC', 6794, 'Patent Owners & Lessors', 4, 2704),
(2705, 'SEC', 6792, 'Oil Royalty Traders', 4, 2704),
(2707, 'SEC', 6798, 'Real Estate Investment Trusts', 4, 2704),
(2708, 'SEC', 6799, 'Investors, nec', 4, 2704),
(4004, 'SIC', 6794, 'Patent Owners & Lessors', 4, 4002),
(4003, 'SIC', 6792, 'Oil Royalty Traders', 4, 4002),
(4005, 'SIC', 6798, 'Real Estate Investment Trusts', 4, 4002),
(4006, 'SIC', 6799, 'Investors, nec', 4, 4002),
(4067, 'SIC', 7372, 'Prepackaged Software', 4, 4065),
(4074, 'SIC', 7379, 'Computer Related Services, nec', 4, 4065),
(4066, 'SIC', 7371, 'Computer Programming Services', 4, 4065),
(4073, 'SIC', 7378, 'Computer Maintenance & Repair', 4, 4065),
(4072, 'SIC', 7377, 'Computer Rental & Leasing', 4, 4065),
(4070, 'SIC', 7375, 'Information Retrieval Services', 4, 4065),
(2732, 'SEC', 7381, 'Detective & Armored Car Services', 4, 2731),
(2733, 'SEC', 7384, 'Photo Finishing Laboratories', 4, 2731),
(2734, 'SEC', 7389, 'Trade Shows & Fairs', 4, 2731),
(4077, 'SIC', 7382, 'Security Systems Services', 4, 4075),
(4080, 'SIC', 7389, 'Trade Shows & Fairs', 4, 4075),
(4078, 'SIC', 7383, 'News Syndicates', 4, 4075),
(4076, 'SIC', 7381, 'Detective & Armored Car Services', 4, 4075),
(4079, 'SIC', 7384, 'Photo Finishing Laboratories', 4, 4075),
(4083, 'SIC', 7513, 'Truck Rental & Leasing, No Drivers', 4, 4082),
(4086, 'SIC', 7519, 'Utility Trailer Rental', 4, 4082),
(4085, 'SIC', 7515, 'Passenger Car Leasing', 4, 4082),
(4084, 'SIC', 7514, 'Passenger Car Rental', 4, 4082),
(4088, 'SIC', 7521, 'Automobile Parking', 4, 4087),
(4091, 'SIC', 7533, 'Auto Exhaust System Repair Shops', 4, 4089),
(4093, 'SIC', 7536, 'Automotive Glass Replacement Shops', 4, 4089),
(4092, 'SIC', 7534, 'Tire Retreading & Repair Shops', 4, 4089),
(4096, 'SIC', 7539, 'Automotive Repair Shops, nec', 4, 4089),
(4095, 'SIC', 7538, 'General Automotive Repair Shops', 4, 4089),
(4094, 'SIC', 7537, 'Automotive Transmission Repair Shops', 4, 4089),
(4090, 'SIC', 7532, 'Top & Body Repair & Paint Shops', 4, 4089),
(4099, 'SIC', 7549, 'Automotive Services, nec', 4, 4097),
(4098, 'SIC', 7542, 'Carwashes', 4, 4097),
(4102, 'SIC', 7622, 'Radio & Television Repair', 4, 4101),
(4103, 'SIC', 7623, 'Refrigeration Service & Repair', 4, 4101),
(4104, 'SIC', 7629, 'Electrical Repair Shops, nec', 4, 4101),
(4106, 'SIC', 7631, 'Watch, Clock & Jewelry Repair', 4, 4105),
(4108, 'SIC', 7641, 'Reupholstery & Furniture Repair', 4, 4107),
(4112, 'SIC', 7699, 'Repair Services, nec', 4, 4109),
(4111, 'SIC', 7694, 'Armatures Rewinding Shops', 4, 4109),
(4110, 'SIC', 7692, 'Welding Repair', 4, 4109),
(2740, 'SEC', 7812, 'Motion Picture & Video Production', 4, 2739),
(2741, 'SEC', 7819, 'Services Allied to Motion Pictures', 4, 2739),
(4115, 'SIC', 7812, 'Motion Picture & Video Production', 4, 4114),
(4116, 'SIC', 7819, 'Services Allied to Motion Pictures', 4, 4114),
(2743, 'SEC', 7822, 'Motion Picture & Tape Distribution', 4, 2742),
(2744, 'SEC', 7829, 'Motion Picture Distribution Services', 4, 2742),
(4155, 'SIC', 8042, 'Offices & Clinics of Optometrists', 4, 4153),
(4154, 'SIC', 8041, 'Offices & Clinics of Chiropractors', 4, 4153),
(2757, 'SEC', 8051, 'Skilled Nursing Care Facilities', 4, 2756),
(4159, 'SIC', 8051, 'Skilled Nursing Care Facilities', 4, 4158),
(4161, 'SIC', 8059, 'Nursing & Personal Care, nec', 4, 4158),
(4160, 'SIC', 8052, 'Intermediate Care Facilities', 4, 4158),
(2759, 'SEC', 8062, 'General Medical & Surgical Hospitals', 4, 2758),
(4163, 'SIC', 8062, 'General Medical & Surgical Hospitals', 4, 4162),
(4164, 'SIC', 8063, 'Psychiatric Hospitals', 4, 4162),
(4165, 'SIC', 8069, 'Specialty Hospitals, Except Psychiatric', 4, 4162),
(2761, 'SEC', 8071, 'Medical Laboratories', 4, 2760),
(4168, 'SIC', 8072, 'Dental Laboratories', 4, 4166),
(4167, 'SIC', 8071, 'Medical Laboratories', 4, 4166),
(2763, 'SEC', 8082, 'Home Health Care Services', 4, 2762),
(4170, 'SIC', 8082, 'Home Health Care Services', 4, 4169),
(2765, 'SEC', 8093, 'Specialty Outpatient Clinics, nec', 4, 2764),
(4173, 'SIC', 8093, 'Specialty Outpatient Clinics, nec', 4, 4171),
(4172, 'SIC', 8092, 'Kidney Dialysis Centers', 4, 4171),
(4174, 'SIC', 8099, 'Health & Allied Services, nec', 4, 4171),
(2768, 'SEC', 8111, 'Legal Services', 4, 2767),
(4177, 'SIC', 8111, 'Legal Services', 4, 4176),
(4238, 'SIC', 8743, 'Public Relations Services', 4, 4235),
(4236, 'SIC', 8741, 'Management Services', 4, 4235),
(4237, 'SIC', 8742, 'Management Consulting Services', 4, 4235),
(4239, 'SIC', 8744, 'Facilities Support Services', 4, 4235),
(4240, 'SIC', 8748, 'Business Consulting, nec', 4, 4235),
(4243, 'SIC', 8811, 'Private Households', 4, 4242),
(4246, 'SIC', 8999, 'Services, nec', 4, 4245),
(4292, 'SIC', 9641, 'Regulation of Agricultural Marketing', 4, 4291),
(4294, 'SIC', 9651, 'Regulation Misc. Commercial Sectors', 4, 4293),
(4296, 'SIC', 9661, 'Space Research & Technology', 4, 4295),
(4299, 'SIC', 9711, 'National Security', 4, 4298),
(2787, 'SEC', 9721, 'International Affairs', 4, 2786),
(4301, 'SIC', 9721, 'International Affairs', 4, 4300),
(4304, 'SIC', 9999, 'Nonclassifiable Establishments', 4, 4303),
(56, 'NAICS', 112, 'Animal Production and Aquaculture', 2, 1),
(108, 'NAICS', 114, 'Fishing, Hunting and Trapping', 2, 1),
(2, 'NAICS', 111, 'Crop Production', 2, 1),
(117, 'NAICS', 115, 'Support Activities for Agriculture and Forestry', 2, 1),
(3, 'NAICS', 1111, 'Oilseed and Grain Farming', 3, 2),
(23, 'NAICS', 1113, 'Fruit and Tree Nut Farming', 3, 2),
(43, 'NAICS', 1119, 'Other Crop Farming', 3, 2),
(19, 'NAICS', 1112, 'Vegetable and Melon Farming', 3, 2),
(36, 'NAICS', 1114, 'Greenhouse, Nursery, and Floriculture Production', 3, 2),
(11, 'NAICS', 11114, 'Wheat Farming', 4, 3),
(5, 'NAICS', 11111, 'Soybean Farming', 4, 3),
(13, 'NAICS', 11115, 'Corn Farming', 4, 3),
(15, 'NAICS', 11116, 'Rice Farming', 4, 3),
(16, 'NAICS', 11119, 'Other Grain Farming', 4, 3),
(7, 'NAICS', 11112, 'Oilseed (except Soybean) Farming', 4, 3),
(9, 'NAICS', 11113, 'Dry Pea and Bean Farming', 4, 3),
(4, 'NAICS', 111110, 'Soybean Farming', 5, 5),
(6, 'NAICS', 111120, 'Oilseed (except Soybean) Farming', 5, 7),
(8, 'NAICS', 111130, 'Dry Pea and Bean Farming', 5, 9),
(10, 'NAICS', 111140, 'Wheat Farming', 5, 11),
(14, 'NAICS', 111160, 'Rice Farming', 5, 15),
(17, 'NAICS', 111191, 'Oilseed and Grain Combination Farming', 5, 16),
(18, 'NAICS', 111199, 'All Other Grain Farming', 5, 16),
(20, 'NAICS', 11121, 'Vegetable and Melon Farming', 4, 19),
(21, 'NAICS', 111211, 'Potato Farming', 5, 20),
(4257, 'SIC', 9210, 'Courts', 3, 4256),
(22, 'NAICS', 111219, 'Other Vegetable (except Potato) and Melon Farming', 5, 20),
(28, 'NAICS', 11133, 'Noncitrus Fruit and Tree Nut Farming', 4, 23),
(27, 'NAICS', 11132, 'Citrus (except Orange) Groves', 4, 23),
(25, 'NAICS', 11131, 'Orange Groves', 4, 23),
(24, 'NAICS', 111310, 'Orange Groves', 5, 25),
(26, 'NAICS', 111320, 'Citrus (except Orange) Groves', 5, 27),
(32, 'NAICS', 111334, 'Berry (except Strawberry) Farming', 5, 28),
(33, 'NAICS', 111335, 'Tree Nut Farming', 5, 28),
(34, 'NAICS', 111336, 'Fruit and Tree Nut Combination Farming', 5, 28),
(30, 'NAICS', 111332, 'Grape Vineyards', 5, 28),
(29, 'NAICS', 111331, 'Apple Orchards', 5, 28),
(35, 'NAICS', 111339, 'Other Noncitrus Fruit Farming', 5, 28),
(31, 'NAICS', 111333, 'Strawberry Farming', 5, 28),
(37, 'NAICS', 11141, 'Food Crops Grown Under Cover', 4, 36),
(40, 'NAICS', 11142, 'Nursery and Floriculture Production', 4, 36),
(39, 'NAICS', 111419, 'Other Food Crops Grown Under Cover', 5, 37),
(38, 'NAICS', 111411, 'Mushroom Production', 5, 37),
(42, 'NAICS', 111422, 'Floriculture Production', 5, 40),
(41, 'NAICS', 111421, 'Nursery and Tree Production', 5, 40),
(51, 'NAICS', 11194, 'Hay Farming', 4, 43),
(45, 'NAICS', 11191, 'Tobacco Farming', 4, 43),
(47, 'NAICS', 11192, 'Cotton Farming', 4, 43),
(49, 'NAICS', 11193, 'Sugarcane Farming', 4, 43),
(52, 'NAICS', 11199, 'All Other Crop Farming', 4, 43),
(44, 'NAICS', 111910, 'Tobacco Farming', 5, 45),
(46, 'NAICS', 111920, 'Cotton Farming', 5, 47),
(48, 'NAICS', 111930, 'Sugarcane Farming', 5, 49),
(50, 'NAICS', 111940, 'Hay Farming', 5, 51),
(53, 'NAICS', 111991, 'Sugar Beet Farming', 5, 52),
(55, 'NAICS', 111998, 'All Other Miscellaneous Crop Farming', 5, 52),
(54, 'NAICS', 111992, 'Peanut Farming', 5, 52),
(68, 'NAICS', 1123, 'Poultry and Egg Production', 3, 56),
(65, 'NAICS', 1122, 'Hog and Pig Farming', 3, 56),
(89, 'NAICS', 1129, 'Other Animal Production', 3, 56),
(84, 'NAICS', 1125, 'Aquaculture', 3, 56),
(79, 'NAICS', 1124, 'Sheep and Goat Farming', 3, 56),
(57, 'NAICS', 1121, 'Cattle Ranching and Farming', 3, 56),
(62, 'NAICS', 11212, 'Dairy Cattle and Milk Production', 4, 57),
(64, 'NAICS', 11213, 'Dual-Purpose Cattle Ranching and Farming', 4, 57),
(58, 'NAICS', 11211, 'Beef Cattle Ranching and Farming, including Feedlots', 4, 57),
(59, 'NAICS', 112111, 'Beef Cattle Ranching and Farming', 5, 58),
(60, 'NAICS', 112112, 'Cattle Feedlots', 5, 58),
(61, 'NAICS', 112120, 'Dairy Cattle and Milk Production', 5, 62),
(63, 'NAICS', 112130, 'Dual-Purpose Cattle Ranching and Farming', 5, 64),
(67, 'NAICS', 11221, 'Hog and Pig Farming', 4, 65),
(66, 'NAICS', 112210, 'Hog and Pig Farming', 5, 67),
(70, 'NAICS', 11231, 'Chicken Egg Production', 4, 68),
(72, 'NAICS', 11232, 'Broilers and Other Meat Type Chicken Production', 4, 68),
(76, 'NAICS', 11234, 'Poultry Hatcheries', 4, 68),
(78, 'NAICS', 11239, 'Other Poultry Production', 4, 68),
(74, 'NAICS', 11233, 'Turkey Production', 4, 68),
(69, 'NAICS', 112310, 'Chicken Egg Production', 5, 70),
(71, 'NAICS', 112320, 'Broilers and Other Meat Type Chicken Production', 5, 72),
(73, 'NAICS', 112330, 'Turkey Production', 5, 74),
(75, 'NAICS', 112340, 'Poultry Hatcheries', 5, 76),
(77, 'NAICS', 112390, 'Other Poultry Production', 5, 78),
(81, 'NAICS', 11241, 'Sheep Farming', 4, 79),
(83, 'NAICS', 11242, 'Goat Farming', 4, 79),
(80, 'NAICS', 112410, 'Sheep Farming', 5, 81),
(82, 'NAICS', 112420, 'Goat Farming', 5, 83),
(85, 'NAICS', 11251, 'Aquaculture', 4, 84),
(88, 'NAICS', 112519, 'Other Aquaculture', 5, 85),
(86, 'NAICS', 112511, 'Finfish Farming and Fish Hatcheries', 5, 85),
(87, 'NAICS', 112512, 'Shellfish Farming', 5, 85),
(95, 'NAICS', 11293, 'Fur-Bearing Animal and Rabbit Production', 4, 89),
(97, 'NAICS', 11299, 'All Other Animal Production', 4, 89),
(93, 'NAICS', 11292, 'Horses and Other Equine Production', 4, 89),
(91, 'NAICS', 11291, 'Apiculture', 4, 89),
(90, 'NAICS', 112910, 'Apiculture', 5, 91),
(92, 'NAICS', 112920, 'Horses and Other Equine Production', 5, 93),
(94, 'NAICS', 112930, 'Fur-Bearing Animal and Rabbit Production', 5, 95),
(96, 'NAICS', 112990, 'All Other Animal Production', 5, 97),
(102, 'NAICS', 1132, 'Forest Nurseries and Gathering of Forest Products', 3, 98),
(99, 'NAICS', 1131, 'Timber Tract Operations', 3, 98),
(101, 'NAICS', 11311, 'Timber Tract Operations', 4, 99),
(100, 'NAICS', 113110, 'Timber Tract Operations', 5, 101),
(104, 'NAICS', 11321, 'Forest Nurseries and Gathering of Forest Products', 4, 102),
(103, 'NAICS', 113210, 'Forest Nurseries and Gathering of Forest Products', 5, 104),
(106, 'NAICS', 113310, 'Logging', 5, 107),
(109, 'NAICS', 1141, 'Fishing', 3, 108),
(114, 'NAICS', 1142, 'Hunting and Trapping', 3, 108),
(110, 'NAICS', 11411, 'Fishing', 4, 109),
(113, 'NAICS', 114119, 'Other Marine Fishing', 5, 110),
(111, 'NAICS', 114111, 'Finfish Fishing', 5, 110),
(112, 'NAICS', 114112, 'Shellfish Fishing', 5, 110),
(116, 'NAICS', 11421, 'Hunting and Trapping', 4, 114),
(115, 'NAICS', 114210, 'Hunting and Trapping', 5, 116),
(129, 'NAICS', 1153, 'Support Activities for Forestry', 3, 117),
(126, 'NAICS', 1152, 'Support Activities for Animal Production', 3, 117),
(118, 'NAICS', 1151, 'Support Activities for Crop Production', 3, 117),
(119, 'NAICS', 11511, 'Support Activities for Crop Production', 4, 118),
(120, 'NAICS', 115111, 'Cotton Ginning', 5, 119),
(125, 'NAICS', 115116, 'Farm Management Services', 5, 119),
(124, 'NAICS', 115115, 'Farm Labor Contractors and Crew Leaders', 5, 119),
(123, 'NAICS', 115114, 'Postharvest Crop Activities (except Cotton Ginning)', 5, 119),
(122, 'NAICS', 115113, 'Crop Harvesting, Primarily by Machine', 5, 119),
(121, 'NAICS', 115112, 'Soil Preparation, Planting, and Cultivating', 5, 119),
(128, 'NAICS', 11521, 'Support Activities for Animal Production', 4, 126),
(127, 'NAICS', 115210, 'Support Activities for Animal Production', 5, 128),
(131, 'NAICS', 11531, 'Support Activities for Forestry', 4, 129),
(130, 'NAICS', 115310, 'Support Activities for Forestry', 5, 131),
(172, 'NAICS', 213, 'Support Activities for Mining', 2, 132),
(133, 'NAICS', 211, 'Oil and Gas Extraction', 2, 132),
(138, 'NAICS', 212, 'Mining (except Oil and Gas)', 2, 132),
(134, 'NAICS', 2111, 'Oil and Gas Extraction', 3, 133),
(135, 'NAICS', 21111, 'Oil and Gas Extraction', 4, 134),
(137, 'NAICS', 211112, 'Natural Gas Liquid Extraction', 5, 135),
(136, 'NAICS', 211111, 'Crude Petroleum and Natural Gas Extraction', 5, 135),
(156, 'NAICS', 2123, 'Nonmetallic Mineral Mining and Quarrying', 3, 138),
(144, 'NAICS', 2122, 'Metal Ore Mining', 3, 138),
(139, 'NAICS', 2121, 'Coal Mining', 3, 138),
(140, 'NAICS', 21211, 'Coal Mining', 4, 139),
(143, 'NAICS', 212113, 'Anthracite Mining', 5, 140),
(142, 'NAICS', 212112, 'Bituminous Coal Underground Mining', 5, 140),
(141, 'NAICS', 212111, 'Bituminous Coal and Lignite Surface Mining', 5, 140),
(153, 'NAICS', 21229, 'Other Metal Ore Mining', 4, 144),
(150, 'NAICS', 21223, 'Copper, Nickel, Lead, and Zinc Mining', 4, 144),
(147, 'NAICS', 21222, 'Gold Ore and Silver Ore Mining', 4, 144),
(146, 'NAICS', 21221, 'Iron Ore Mining', 4, 144),
(145, 'NAICS', 212210, 'Iron Ore Mining', 5, 146),
(148, 'NAICS', 212221, 'Gold Ore Mining', 5, 147),
(149, 'NAICS', 212222, 'Silver Ore Mining', 5, 147),
(151, 'NAICS', 212231, 'Lead Ore and Zinc Ore Mining', 5, 150),
(152, 'NAICS', 212234, 'Copper Ore and Nickel Ore Mining', 5, 150),
(155, 'NAICS', 212299, 'All Other Metal Ore Mining', 5, 153),
(154, 'NAICS', 212291, 'Uranium-Radium-Vanadium Ore Mining', 5, 153),
(162, 'NAICS', 21232, 'Sand, Gravel, Clay, and Ceramic and Refractory Minerals Mining and Quarrying', 4, 156),
(167, 'NAICS', 21239, 'Other Nonmetallic Mineral Mining and Quarrying', 4, 156),
(157, 'NAICS', 21231, 'Stone Mining and Quarrying', 4, 156),
(159, 'NAICS', 212312, 'Crushed and Broken Limestone Mining and Quarrying', 5, 157),
(160, 'NAICS', 212313, 'Crushed and Broken Granite Mining and Quarrying', 5, 157),
(161, 'NAICS', 212319, 'Other Crushed and Broken Stone Mining and Quarrying', 5, 157),
(158, 'NAICS', 212311, 'Dimension Stone Mining and Quarrying', 5, 157),
(163, 'NAICS', 212321, 'Construction Sand and Gravel Mining', 5, 162),
(166, 'NAICS', 212325, 'Clay and Ceramic and Refractory Minerals Mining', 5, 162),
(165, 'NAICS', 212324, 'Kaolin and Ball Clay Mining', 5, 162),
(164, 'NAICS', 212322, 'Industrial Sand Mining', 5, 162),
(170, 'NAICS', 212393, 'Other Chemical and Fertilizer Mineral Mining', 5, 167),
(169, 'NAICS', 212392, 'Phosphate Rock Mining', 5, 167),
(171, 'NAICS', 212399, 'All Other Nonmetallic Mineral Mining', 5, 167),
(168, 'NAICS', 212391, 'Potash, Soda, and Borate Mineral Mining', 5, 167),
(173, 'NAICS', 2131, 'Support Activities for Mining', 3, 172),
(174, 'NAICS', 21311, 'Support Activities for Mining', 4, 173),
(176, 'NAICS', 213112, 'Support Activities for Oil and Gas Operations', 5, 174),
(178, 'NAICS', 213114, 'Support Activities for Metal Mining', 5, 174),
(179, 'NAICS', 213115, 'Support Activities for Nonmetallic Minerals (except Fuels) Mining', 5, 174),
(296, 'NAICS', 31131, 'Sugar Manufacturing', 4, 295),
(177, 'NAICS', 213113, 'Support Activities for Coal Mining', 5, 174),
(175, 'NAICS', 213111, 'Drilling Oil and Gas Wells', 5, 174),
(181, 'NAICS', 221, 'Utilities', 2, 180),
(182, 'NAICS', 2211, 'Electric Power Generation, Transmission and Distribution', 3, 181),
(195, 'NAICS', 2212, 'Natural Gas Distribution', 3, 181),
(198, 'NAICS', 2213, 'Water, Sewage and Other Systems', 3, 181),
(192, 'NAICS', 22112, 'Electric Power Transmission, Control, and Distribution', 4, 182),
(183, 'NAICS', 22111, 'Electric Power Generation', 4, 182),
(190, 'NAICS', 221117, 'Biomass Electric Power Generation', 5, 183),
(184, 'NAICS', 221111, 'Hydroelectric Power Generation', 5, 183),
(185, 'NAICS', 221112, 'Fossil Fuel Electric Power Generation', 5, 183),
(186, 'NAICS', 221113, 'Nuclear Electric Power Generation', 5, 183),
(187, 'NAICS', 221114, 'Solar Electric Power Generation', 5, 183),
(188, 'NAICS', 221115, 'Wind Electric Power Generation', 5, 183),
(189, 'NAICS', 221116, 'Geothermal Electric Power Generation', 5, 183),
(191, 'NAICS', 221118, 'Other Electric Power Generation', 5, 183),
(193, 'NAICS', 221121, 'Electric Bulk Power Transmission and Control', 5, 192),
(194, 'NAICS', 221122, 'Electric Power Distribution', 5, 192),
(197, 'NAICS', 22121, 'Natural Gas Distribution', 4, 195),
(196, 'NAICS', 221210, 'Natural Gas Distribution', 5, 197),
(204, 'NAICS', 22133, 'Steam and Air-Conditioning Supply', 4, 198),
(200, 'NAICS', 22131, 'Water Supply and Irrigation Systems', 4, 198),
(202, 'NAICS', 22132, 'Sewage Treatment Facilities', 4, 198),
(199, 'NAICS', 221310, 'Water Supply and Irrigation Systems', 5, 200),
(201, 'NAICS', 221320, 'Sewage Treatment Facilities', 5, 202),
(203, 'NAICS', 221330, 'Steam and Air-Conditioning Supply', 5, 204),
(206, 'NAICS', 236, 'Construction of Buildings', 2, 205),
(235, 'NAICS', 238, 'Specialty Trade Contractors', 2, 205),
(218, 'NAICS', 237, 'Heavy and Civil Engineering Construction', 2, 205),
(213, 'NAICS', 2362, 'Nonresidential Building Construction', 3, 206),
(207, 'NAICS', 2361, 'Residential Building Construction', 3, 206),
(208, 'NAICS', 23611, 'Residential Building Construction', 4, 207),
(209, 'NAICS', 236115, 'New Single-Family Housing Construction (except For-Sale Builders)', 5, 208),
(210, 'NAICS', 236116, 'New Multifamily Housing Construction (except For-Sale Builders)', 5, 208),
(211, 'NAICS', 236117, 'New Housing For-Sale Builders', 5, 208),
(212, 'NAICS', 236118, 'Residential Remodelers', 5, 208),
(217, 'NAICS', 23622, 'Commercial and Institutional Building Construction', 4, 213),
(215, 'NAICS', 23621, 'Industrial Building Construction', 4, 213),
(214, 'NAICS', 236210, 'Industrial Building Construction', 5, 215),
(216, 'NAICS', 236220, 'Commercial and Institutional Building Construction', 5, 217),
(229, 'NAICS', 2373, 'Highway, Street, and Bridge Construction', 3, 218),
(232, 'NAICS', 2379, 'Other Heavy and Civil Engineering Construction', 3, 218),
(219, 'NAICS', 2371, 'Utility System Construction', 3, 218),
(226, 'NAICS', 2372, 'Land Subdivision', 3, 218),
(225, 'NAICS', 23713, 'Power and Communication Line and Related Structures Construction', 4, 219),
(221, 'NAICS', 23711, 'Water and Sewer Line and Related Structures Construction', 4, 219),
(223, 'NAICS', 23712, 'Oil and Gas Pipeline and Related Structures Construction', 4, 219),
(220, 'NAICS', 237110, 'Water and Sewer Line and Related Structures Construction', 5, 221),
(222, 'NAICS', 237120, 'Oil and Gas Pipeline and Related Structures Construction', 5, 223),
(224, 'NAICS', 237130, 'Power and Communication Line and Related Structures Construction', 5, 225),
(228, 'NAICS', 23721, 'Land Subdivision', 4, 226),
(227, 'NAICS', 237210, 'Land Subdivision', 5, 228),
(231, 'NAICS', 23731, 'Highway, Street, and Bridge Construction', 4, 229),
(230, 'NAICS', 237310, 'Highway, Street, and Bridge Construction', 5, 231),
(234, 'NAICS', 23799, 'Other Heavy and Civil Engineering Construction', 4, 232),
(233, 'NAICS', 237990, 'Other Heavy and Civil Engineering Construction', 5, 234),
(253, 'NAICS', 2382, 'Building Equipment Contractors', 3, 235),
(273, 'NAICS', 2389, 'Other Specialty Trade Contractors', 3, 235),
(260, 'NAICS', 2383, 'Building Finishing Contractors', 3, 235),
(236, 'NAICS', 2381, 'Foundation, Structure, and Building Exterior Contractors', 3, 235),
(246, 'NAICS', 23815, 'Glass and Glazing Contractors', 4, 236),
(252, 'NAICS', 23819, 'Other Foundation, Structure, and Building Exterior Contractors', 4, 236),
(238, 'NAICS', 23811, 'Poured Concrete Foundation and Structure Contractors', 4, 236),
(250, 'NAICS', 23817, 'Siding Contractors', 4, 236),
(240, 'NAICS', 23812, 'Structural Steel and Precast Concrete Contractors', 4, 236),
(248, 'NAICS', 23816, 'Roofing Contractors', 4, 236),
(242, 'NAICS', 23813, 'Framing Contractors', 4, 236),
(244, 'NAICS', 23814, 'Masonry Contractors', 4, 236),
(237, 'NAICS', 238110, 'Poured Concrete Foundation and Structure Contractors', 5, 238),
(239, 'NAICS', 238120, 'Structural Steel and Precast Concrete Contractors', 5, 240),
(241, 'NAICS', 238130, 'Framing Contractors', 5, 242),
(243, 'NAICS', 238140, 'Masonry Contractors', 5, 244),
(245, 'NAICS', 238150, 'Glass and Glazing Contractors', 5, 246),
(247, 'NAICS', 238160, 'Roofing Contractors', 5, 248),
(249, 'NAICS', 238170, 'Siding Contractors', 5, 250),
(251, 'NAICS', 238190, 'Other Foundation, Structure, and Building Exterior Contractors', 5, 252),
(259, 'NAICS', 23829, 'Other Building Equipment Contractors', 4, 253),
(255, 'NAICS', 23821, 'Electrical Contractors and Other Wiring Installation Contractors', 4, 253),
(257, 'NAICS', 23822, 'Plumbing, Heating, and Air-Conditioning Contractors', 4, 253),
(254, 'NAICS', 238210, 'Electrical Contractors and Other Wiring Installation Contractors', 5, 255),
(256, 'NAICS', 238220, 'Plumbing, Heating, and Air-Conditioning Contractors', 5, 257),
(258, 'NAICS', 238290, 'Other Building Equipment Contractors', 5, 259),
(268, 'NAICS', 23834, 'Tile and Terrazzo Contractors', 4, 260),
(266, 'NAICS', 23833, 'Flooring Contractors', 4, 260),
(272, 'NAICS', 23839, 'Other Building Finishing Contractors'<