xbrlSemanticSQLiteDB.ddl

-- This DDL (SQL) script initializes a database for the XBRL Abstract Model Postgres

-- (c) Copyright 2014 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).

-- drop tables and sequences
DROP TABLE IF EXISTS entity;
DROP TABLE IF EXISTS former_entity;
DROP TABLE IF EXISTS filing;
DROP TABLE IF EXISTS report;
DROP TABLE IF EXISTS document;
DROP TABLE IF EXISTS referenced_documents;
DROP TABLE IF EXISTS aspect;
DROP TABLE IF EXISTS data_type;
DROP TABLE IF EXISTS role_type;
DROP TABLE IF EXISTS arcrole_type;
DROP TABLE IF EXISTS used_on;
DROP TABLE IF EXISTS resource;
DROP TABLE IF EXISTS relationship_set;
DROP TABLE IF EXISTS relationship;
DROP TABLE IF EXISTS root;
DROP TABLE IF EXISTS data_point;
DROP TABLE IF EXISTS entity_identifier;
DROP TABLE IF EXISTS period;
DROP TABLE IF EXISTS unit;
DROP TABLE IF EXISTS unit_measure;
DROP TABLE IF EXISTS aspect_value_selection_set;
DROP TABLE IF EXISTS aspect_value_selection;
DROP TABLE IF EXISTS table_data_points;
DROP TABLE IF EXISTS message;
DROP TABLE IF EXISTS message_reference;
DROP TABLE IF EXISTS industry;
DROP TABLE IF EXISTS industry_level;
DROP TABLE IF EXISTS industry_structure;

-- sequences are synced up in loading code by Arelle

--
-- note that dropping table also drops the indexes and triggers
--
CREATE TABLE entity (
    entity_id INTEGER PRIMARY KEY AUTOINCREMENT,
    legal_entity_number TEXT, -- LEI
    file_number TEXT, -- authority internal number
    reference_number TEXT, -- external code, e.g. CIK
    tax_number TEXT,
    standard_industry_code INTEGER DEFAULT (-1) NOT NULL,
    name TEXT,
    legal_state TEXT,
    phone TEXT,
    phys_addr1 TEXT, -- physical (real) address
    phys_addr2 TEXT,
    phys_city TEXT,
    phys_state TEXT,
    phys_zip TEXT,
    phys_country TEXT,
    mail_addr1 TEXT, -- mailing (postal) address
    mail_addr2 TEXT,
    mail_city TEXT,
    mail_state TEXT,
    mail_zip TEXT,
    mail_country TEXT,
    fiscal_year_end TEXT,
    filer_category TEXT,
    public_float double precision,
    trading_symbol TEXT
);
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 INTEGER NOT NULL,
    date_changed TEXT,
    former_name TEXT
);
CREATE INDEX former_entity_index02 ON former_entity (entity_id);

CREATE TABLE filing (
    filing_id INTEGER PRIMARY KEY AUTOINCREMENT,
    filing_number TEXT NOT NULL,
    form_type TEXT,
    entity_id INTEGER NOT NULL,
    reference_number TEXT, -- external code, e.g. CIK
    accepted_timestamp TEXT,
    is_most_current BOOLEAN DEFAULT false NOT NULL,
    filing_date TEXT NOT NULL,
    creation_software TEXT,
    authority_html_url TEXT,
    entry_url TEXT
);
CREATE UNIQUE INDEX filing_index02 ON filing  (filing_number);
CREATE INDEX filing_index03 ON filing  (entity_id);

CREATE TABLE report (
    report_id INTEGER PRIMARY KEY AUTOINCREMENT,
    filing_id INTEGER NOT NULL,
    report_data_doc_id INTEGER,  -- instance or primary inline document
    report_schema_doc_id INTEGER,  -- extension schema of the report (primary)
    agency_schema_doc_id INTEGER,  -- agency schema (receiving authority)
    standard_schema_doc_id INTEGER  -- e.g., IFRS, XBRL-US, or EDInet schema
);
CREATE INDEX report_index02 ON report(filing_id);

CREATE TABLE document (
    document_id INTEGER PRIMARY KEY AUTOINCREMENT,
    document_url TEXT NOT NULL,
    document_type TEXT,  -- ModelDocument.Type string value
    namespace TEXT  -- targetNamespace if schema else NULL
);
CREATE INDEX document_index02 ON document (document_url);

-- documents referenced by report or document

CREATE TABLE referenced_documents (
    object_id INTEGER NOT NULL,
    document_id INTEGER 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);

CREATE TABLE aspect (
    aspect_id INTEGER PRIMARY KEY AUTOINCREMENT,
    document_id INTEGER NOT NULL,
    xml_id TEXT,
    xml_child_seq TEXT,
    qname TEXT NOT NULL,  -- clark notation qname (do we need this?)
    name TEXT NOT NULL,  -- local qname
    datatype_id INTEGER,
    base_type TEXT, -- xml base type if any
    substitution_group_aspect_id INTEGER,
    balance TEXT,
    period_type TEXT,
    abstract BOOLEAN NOT NULL,
    nillable BOOLEAN NOT NULL,
    is_numeric BOOLEAN NOT NULL,
    is_monetary BOOLEAN NOT NULL,
    is_text_block BOOLEAN NOT NULL
);
CREATE INDEX aspect_index02 ON aspect  (document_id);
CREATE INDEX aspect_index03 ON aspect (qname);

CREATE TABLE data_type (
    data_type_id INTEGER PRIMARY KEY AUTOINCREMENT,
    document_id INTEGER NOT NULL,
    xml_id TEXT,
    xml_child_seq TEXT,
    qname TEXT NOT NULL,  -- clark notation qname (do we need this?)
    name TEXT NOT NULL,  -- local qname
    base_type TEXT, -- xml base type if any
    derived_from_type_id INTEGER
);
CREATE INDEX data_type_index02 ON data_type (document_id);
CREATE INDEX data_type_index03 ON data_type (qname);

CREATE TABLE role_type (
    role_type_id INTEGER PRIMARY KEY AUTOINCREMENT,
    document_id INTEGER NOT NULL,
    xml_id TEXT,
    xml_child_seq TEXT,
    role_uri TEXT NOT NULL,
    definition TEXT
);
CREATE INDEX role_type_index02 ON role_type (document_id);
CREATE INDEX role_type_index03 ON role_type (role_uri);

CREATE TABLE arcrole_type (
    arcrole_type_id INTEGER PRIMARY KEY AUTOINCREMENT,
    document_id INTEGER NOT NULL,
    xml_id TEXT,
    xml_child_seq TEXT,
    arcrole_uri TEXT NOT NULL,
    cycles_allowed TEXT NOT NULL,
    definition TEXT
);
CREATE INDEX arcrole_type_index02 ON arcrole_type (document_id);
CREATE INDEX arcrole_type_index03 ON arcrole_type (arcrole_uri);

CREATE TABLE used_on (
    object_id INTEGER NOT NULL,
    aspect_id INTEGER 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);

CREATE TABLE resource (
    resource_id INTEGER PRIMARY KEY AUTOINCREMENT,
    document_id INTEGER NOT NULL,
    xml_id TEXT,
    xml_child_seq TEXT,
    qname TEXT NOT NULL,  -- clark notation qname (do we need this?)
    role TEXT,
    value TEXT,
    xml_lang TEXT
);
CREATE INDEX resource_index01 ON resource  (resource_id);
CREATE INDEX resource_index02 ON resource  (document_id, xml_child_seq);

CREATE TABLE relationship_set (
    relationship_set_id INTEGER PRIMARY KEY AUTOINCREMENT,
    document_id INTEGER NOT NULL,
    arc_qname TEXT NOT NULL,  -- clark notation qname (do we need this?)
    link_qname TEXT NOT NULL,  -- clark notation qname (do we need this?)
    arc_role TEXT NOT NULL,
    link_role TEXT NOT NULL
);
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); 

CREATE TABLE root (
    relationship_set_id INTEGER NOT NULL,
    relationship_id INTEGER NOT NULL
);
CREATE INDEX root_index01 ON root  (relationship_set_id); 

CREATE TABLE relationship (
    relationship_id INTEGER PRIMARY KEY AUTOINCREMENT,
    document_id INTEGER NOT NULL,
    xml_id TEXT,
    xml_child_seq TEXT,
    relationship_set_id INTEGER NOT NULL,
    reln_order double precision,
    from_id INTEGER,
    to_id INTEGER,
    calculation_weight double precision,
    tree_sequence integer NOT NULL,
    tree_depth integer NOT NULL,
    preferred_label_role TEXT
);
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); 

CREATE TABLE data_point (
    datapoint_id INTEGER PRIMARY KEY AUTOINCREMENT,
    report_id INTEGER,
    document_id INTEGER NOT NULL,  -- multiple inline documents are sources of data points
    xml_id TEXT,
    xml_child_seq TEXT,
    source_line integer,
    parent_datapoint_id INTEGER, -- id of tuple parent
    aspect_id INTEGER NOT NULL,
    context_xml_id TEXT, -- (do we need this?)
    entity_identifier_id INTEGER,
    period_id INTEGER,
    aspect_value_selection_id INTEGER,
    unit_id INTEGER,
    is_nil BOOLEAN DEFAULT FALSE,
    precision_value TEXT,
    decimals_value TEXT,
    effective_value double precision,
    value TEXT
);
CREATE INDEX data_point_index02 ON data_point  (document_id, xml_child_seq);
CREATE INDEX data_point_index03 ON data_point  (report_id);
CREATE INDEX data_point_index04 ON data_point  (aspect_id);

CREATE TABLE entity_identifier (
    entity_identifier_id INTEGER PRIMARY KEY AUTOINCREMENT,
    report_id INTEGER,
    scheme TEXT NOT NULL,
    identifier TEXT NOT NULL
);
CREATE INDEX entity_identifier_index02 ON entity_identifier (report_id, identifier);

CREATE TABLE period (
    period_id INTEGER PRIMARY KEY AUTOINCREMENT,
    report_id INTEGER,
    start_date TEXT,
    end_date TEXT,
    is_instant BOOLEAN NOT NULL,
    is_forever BOOLEAN NOT NULL
);
CREATE INDEX period_index02 ON period  (report_id, start_date, end_date, is_instant, is_forever);

CREATE TABLE unit (
    unit_id INTEGER PRIMARY KEY AUTOINCREMENT,
    report_id INTEGER,
    xml_id TEXT,
    xml_child_seq TEXT,
    measures_hash TEXT
);
CREATE INDEX unit_index02 ON unit  (report_id, measures_hash);


CREATE TABLE unit_measure (
    unit_id INTEGER NOT NULL,
    qname TEXT NOT NULL,  -- clark notation qname (do we need this?)
    is_multiplicand BOOLEAN 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);

CREATE TABLE aspect_value_selection_set (
    aspect_value_selection_id INTEGER PRIMARY KEY AUTOINCREMENT,
    report_id INTEGER
);
CREATE UNIQUE INDEX aspect_value_sel_set_index01 ON aspect_value_selection_set (aspect_value_selection_id);
CREATE INDEX aspect_value_sel_set_index02 ON aspect_value_selection_set (report_id);

CREATE TABLE aspect_value_selection (
    aspect_value_selection_id INTEGER NOT NULL,
    report_id INTEGER,
    aspect_id INTEGER NOT NULL,
    aspect_value_id INTEGER,
    is_typed_value BOOLEAN NOT NULL,
    typed_value TEXT
);
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);

CREATE TABLE table_data_points(
    report_id INTEGER,
    object_id INTEGER NOT NULL, -- may be any role_type or aspect defining a table table with 'seq_object' id
    table_code TEXT,  -- short code of table, like BS, PL, or 4.15.221
    datapoint_id INTEGER -- 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);

CREATE TABLE message (
    message_id INTEGER PRIMARY KEY AUTOINCREMENT,
    report_id INTEGER,
    sequence_in_report int,
    message_code TEXT,
    message_level TEXT,
    value TEXT
);
CREATE INDEX message_index02 ON message  (report_id, sequence_in_report);

CREATE TABLE message_reference (
    message_id INTEGER NOT NULL,
    object_id INTEGER 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);

CREATE TABLE industry (
    industry_id INTEGER,
    industry_classification TEXT,
    industry_code integer,
    industry_description TEXT,
    depth integer,
    parent_id INTEGER,
    PRIMARY KEY (industry_id)
);

CREATE TABLE industry_level (
    industry_level_id INTEGER,
    industry_classification TEXT,
    ancestor_id INTEGER,
    ancestor_code integer,
    ancestor_depth integer,
    descendant_id INTEGER,
    descendant_code integer,
    descendant_depth integer,
    PRIMARY KEY (industry_level_id)
);

CREATE TABLE industry_structure (
    industry_structure_id INTEGER,
    industry_classification TEXT NOT NULL,
    depth integer NOT NULL,
    level_name TEXT,
    PRIMARY KEY (industry_structure_id)
);

--
-- optional inserts for standard industry codes
--
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', 1442, '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 HoConstruction', 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', 3442, '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', 3442, '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),
(3442, '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);

INSERT INTO industry (industry_id, industry_classification, industry_code, industry_description, depth, parent_id) VALUES
(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 Wareho& Storage', 4, 3626),
(3630, 'SIC', 4226, 'Special Wareho& Storage, nec', 4, 3626),
(3629, 'SIC', 4225, 'General Wareho& Storage', 4, 3626),
(3628, 'SIC', 4222, 'Refrigerated Wareho& 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', 4424, '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, 'HoPrograms', 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),
(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);

INSERT INTO industry (industry_id, industry_classification, industry_code, industry_description, depth, parent_id) VALUES
(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);

INSERT INTO industry (industry_id, industry_classification, industry_code, industry_description, depth, parent_id) VALUES
(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 HoConstruction (except For-Sale Builders)', 5, 208),
(210, 'NAICS', 236116, 'New Multifamily HoConstruction (except For-Sale Builders)', 5, 208),
(211, 'NAICS', 236117, 'New HoFor-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,