l_naics_code

1,175 rows

✎ View and edit SQL

This data as json, CSV (advanced)

naics_code ▼ naics_us_industry_code naics_industry_code naics_industry_group naics_subsector naics_sector description
111110 0 1 1 1 Agriculture, Forestry, Fishing, and Hunting 11 Soybean Farming
111120 0 2 1 1 Agriculture, Forestry, Fishing, and Hunting 11 Oilseed (except Soybean) Farming
111130 0 3 1 1 Agriculture, Forestry, Fishing, and Hunting 11 Dry Pea and Bean Farming
111140 0 4 1 1 Agriculture, Forestry, Fishing, and Hunting 11 Wheat Farming
111150 0 5 1 1 Agriculture, Forestry, Fishing, and Hunting 11 Corn Farming
111160 0 6 1 1 Agriculture, Forestry, Fishing, and Hunting 11 Rice Farming
111191 1 9 1 1 Agriculture, Forestry, Fishing, and Hunting 11 Oilseed and Grain Combination Farming
111199 9 9 1 1 Agriculture, Forestry, Fishing, and Hunting 11 All Other Grain Farming
111211 1 1 2 1 Agriculture, Forestry, Fishing, and Hunting 11 Potato Farming
111219 9 1 2 1 Agriculture, Forestry, Fishing, and Hunting 11 Other Vegetable (except Potato) and Melon Farming
111310 0 1 3 1 Agriculture, Forestry, Fishing, and Hunting 11 Orange Groves
111320 0 2 3 1 Agriculture, Forestry, Fishing, and Hunting 11 Citrus (except Orange) Groves
111331 1 3 3 1 Agriculture, Forestry, Fishing, and Hunting 11 Apple Orchards
111332 2 3 3 1 Agriculture, Forestry, Fishing, and Hunting 11 Grape Vineyards
111333 3 3 3 1 Agriculture, Forestry, Fishing, and Hunting 11 Strawberry Farming
111334 4 3 3 1 Agriculture, Forestry, Fishing, and Hunting 11 Berry (except Strawberry) Farming
111335 5 3 3 1 Agriculture, Forestry, Fishing, and Hunting 11 Tree Nut Farming
111336 6 3 3 1 Agriculture, Forestry, Fishing, and Hunting 11 Fruit and Tree Nut Combination Farming
111339 9 3 3 1 Agriculture, Forestry, Fishing, and Hunting 11 Other Noncitrus Fruit Farming
111411 1 1 4 1 Agriculture, Forestry, Fishing, and Hunting 11 Mushroom Production
111419 9 1 4 1 Agriculture, Forestry, Fishing, and Hunting 11 Other Food Crops Grown Under Cover
111421 1 2 4 1 Agriculture, Forestry, Fishing, and Hunting 11 Nursery and Tree Production
111422 2 2 4 1 Agriculture, Forestry, Fishing, and Hunting 11 Floriculture Production
111910 0 1 9 1 Agriculture, Forestry, Fishing, and Hunting 11 Tobacco Farming
111920 0 2 9 1 Agriculture, Forestry, Fishing, and Hunting 11 Cotton Farming
111930 0 3 9 1 Agriculture, Forestry, Fishing, and Hunting 11 Sugarcane Farming
111940 0 4 9 1 Agriculture, Forestry, Fishing, and Hunting 11 Hay Farming
111991 1 9 9 1 Agriculture, Forestry, Fishing, and Hunting 11 Sugar Beet Farming
111992 2 9 9 1 Agriculture, Forestry, Fishing, and Hunting 11 Peanut Farming
111998 8 9 9 1 Agriculture, Forestry, Fishing, and Hunting 11 All Other Miscellaneous Crop Farming
112111 1 1 1 2 Agriculture, Forestry, Fishing, and Hunting 11 Beef Cattle Ranching and Farming
112112 2 1 1 2 Agriculture, Forestry, Fishing, and Hunting 11 Cattle Feedlots
112120 0 2 1 2 Agriculture, Forestry, Fishing, and Hunting 11 Dairy Cattle and Milk Production
112130 0 3 1 2 Agriculture, Forestry, Fishing, and Hunting 11 Dual-Purpose Cattle Ranching and Farming
112210 0 1 2 2 Agriculture, Forestry, Fishing, and Hunting 11 Hog and Pig Farming
112310 0 1 3 2 Agriculture, Forestry, Fishing, and Hunting 11 Chicken Egg Production
112320 0 2 3 2 Agriculture, Forestry, Fishing, and Hunting 11 Broilers and Other Meat Type Chicken Production
112330 0 3 3 2 Agriculture, Forestry, Fishing, and Hunting 11 Turkey Production
112340 0 4 3 2 Agriculture, Forestry, Fishing, and Hunting 11 Poultry Hatcheries
112390 0 9 3 2 Agriculture, Forestry, Fishing, and Hunting 11 Other Poultry Production
112410 0 1 4 2 Agriculture, Forestry, Fishing, and Hunting 11 Sheep Farming
112420 0 2 4 2 Agriculture, Forestry, Fishing, and Hunting 11 Goat Farming
112511 1 1 5 2 Agriculture, Forestry, Fishing, and Hunting 11 Finfish Farming and Fish Hatcheries
112512 2 1 5 2 Agriculture, Forestry, Fishing, and Hunting 11 Shellfish Farming
112519 9 1 5 2 Agriculture, Forestry, Fishing, and Hunting 11 Other Aquaculture
112910 0 1 9 2 Agriculture, Forestry, Fishing, and Hunting 11 Apiculture
112920 0 2 9 2 Agriculture, Forestry, Fishing, and Hunting 11 Horses and Other Equine Production
112930 0 3 9 2 Agriculture, Forestry, Fishing, and Hunting 11 Fur-Bearing Animal and Rabbit Production
112990 0 9 9 2 Agriculture, Forestry, Fishing, and Hunting 11 All Other Animal Production
113110 0 1 1 3 Agriculture, Forestry, Fishing, and Hunting 11 Timber Tract Operations
113210 0 1 2 3 Agriculture, Forestry, Fishing, and Hunting 11 Forest Nurseries and Gathering of Forest Products
113310 0 1 3 3 Agriculture, Forestry, Fishing, and Hunting 11 Logging
114111 1 1 1 4 Agriculture, Forestry, Fishing, and Hunting 11 Finfish Fishing
114112 2 1 1 4 Agriculture, Forestry, Fishing, and Hunting 11 Shellfish Fishing
114119 9 1 1 4 Agriculture, Forestry, Fishing, and Hunting 11 Other Marine Fishing
114210 0 1 2 4 Agriculture, Forestry, Fishing, and Hunting 11 Hunting and Trapping
115111 1 1 1 5 Agriculture, Forestry, Fishing, and Hunting 11 Cotton Ginning
115112 2 1 1 5 Agriculture, Forestry, Fishing, and Hunting 11 Soil Preparation, Planting, and Cultivating
115113 3 1 1 5 Agriculture, Forestry, Fishing, and Hunting 11 Crop Harvesting, Primarily by Machine
115114 4 1 1 5 Agriculture, Forestry, Fishing, and Hunting 11 Postharvest Crop Activities (except Cotton Ginning)
115115 5 1 1 5 Agriculture, Forestry, Fishing, and Hunting 11 Farm Labor Contractors and Crew Leaders
115116 6 1 1 5 Agriculture, Forestry, Fishing, and Hunting 11 Farm Management Services
115210 0 1 2 5 Agriculture, Forestry, Fishing, and Hunting 11 Support Activities for Animal Production
115310 0 1 3 5 Agriculture, Forestry, Fishing, and Hunting 11 Support Activities for Forestry
211111 1 1 1 1 Mining, Quarrying, and Oil and Gas Extraction 21 Crude Petroleum and Natural Gas Extraction
211112 2 1 1 1 Mining, Quarrying, and Oil and Gas Extraction 21 Natural Gas Liquid Extraction
212111 1 1 1 2 Mining, Quarrying, and Oil and Gas Extraction 21 Bituminous Coal and Lignite Surface Mining
212112 2 1 1 2 Mining, Quarrying, and Oil and Gas Extraction 21 Bituminous Coal Underground Mining
212113 3 1 1 2 Mining, Quarrying, and Oil and Gas Extraction 21 Anthracite Mining
212210 0 1 2 2 Mining, Quarrying, and Oil and Gas Extraction 21 Iron Ore Mining
212221 1 2 2 2 Mining, Quarrying, and Oil and Gas Extraction 21 Gold Ore Mining
212222 2 2 2 2 Mining, Quarrying, and Oil and Gas Extraction 21 Silver Ore Mining
212231 1 3 2 2 Mining, Quarrying, and Oil and Gas Extraction 21 Lead Ore and Zinc Ore Mining
212234 4 3 2 2 Mining, Quarrying, and Oil and Gas Extraction 21 Copper Ore and Nickel Ore Mining
212291 1 9 2 2 Mining, Quarrying, and Oil and Gas Extraction 21 Uranium-Radium-Vanadium Ore Mining
212299 9 9 2 2 Mining, Quarrying, and Oil and Gas Extraction 21 All Other Metal Ore Mining
212311 1 1 3 2 Mining, Quarrying, and Oil and Gas Extraction 21 Dimension Stone Mining and Quarrying
212312 2 1 3 2 Mining, Quarrying, and Oil and Gas Extraction 21 Crushed and Broken Limestone Mining and Quarrying
212313 3 1 3 2 Mining, Quarrying, and Oil and Gas Extraction 21 Crushed and Broken Granite Mining and Quarrying
212319 9 1 3 2 Mining, Quarrying, and Oil and Gas Extraction 21 Other Crushed and Broken Stone Mining and Quarrying
212321 1 2 3 2 Mining, Quarrying, and Oil and Gas Extraction 21 Construction Sand and Gravel Mining
212322 2 2 3 2 Mining, Quarrying, and Oil and Gas Extraction 21 Industrial Sand Mining
212324 4 2 3 2 Mining, Quarrying, and Oil and Gas Extraction 21 Kaolin and Ball Clay Mining
212325 5 2 3 2 Mining, Quarrying, and Oil and Gas Extraction 21 Clay and Ceramic and Refractory Minerals Mining
212391 1 9 3 2 Mining, Quarrying, and Oil and Gas Extraction 21 Potash, Soda, and Borate Mineral Mining
212392 2 9 3 2 Mining, Quarrying, and Oil and Gas Extraction 21 Phosphate Rock Mining
212393 3 9 3 2 Mining, Quarrying, and Oil and Gas Extraction 21 Other Chemical and Fertilizer Mineral Mining
212399 9 9 3 2 Mining, Quarrying, and Oil and Gas Extraction 21 All Other Nonmetallic Mineral Mining
213111 1 1 1 3 Mining, Quarrying, and Oil and Gas Extraction 21 Drilling Oil and Gas Wells
213112 2 1 1 3 Mining, Quarrying, and Oil and Gas Extraction 21 Support Activities for Oil and Gas Operations
213113 3 1 1 3 Mining, Quarrying, and Oil and Gas Extraction 21 Support Activities for Coal Mining
213114 4 1 1 3 Mining, Quarrying, and Oil and Gas Extraction 21 Support Activities for Metal Mining
213115 5 1 1 3 Mining, Quarrying, and Oil and Gas Extraction 21 Support Activities for Nonmetallic Minerals (except Fuels)
221111 1 1 1 1 Utilities 22 Hydroelectric Power Generation
221112 2 1 1 1 Utilities 22 Fossil Fuel Electric Power Generation
221113 3 1 1 1 Utilities 22 Nuclear Electric Power Generation
221119 9 1 1 1 Utilities 22 Other Electric Power Generation
221121 1 2 1 1 Utilities 22 Electric Bulk Power Transmission and Control
221122 2 2 1 1 Utilities 22 Electric Power Distribution
221210 0 1 2 1 Utilities 22 Natural Gas Distribution

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "l_naics_code" (
[naics_code] integer PRIMARY KEY,
[naics_us_industry_code] integer,
[naics_industry_code] integer,
[naics_industry_group] integer,
[naics_subsector] integer,
[naics_sector] integer,
[description] text,
    FOREIGN KEY ([naics_sector]) REFERENCES[l_naics_sector] ([naics_sector])
);