l_naics_code
1,175 rows
Suggested facets: naics_us_industry_code, naics_industry_code, naics_industry_group, naics_subsector, naics_sector
| 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 |
Table schema
CREATE TABLE l_naics_code(naics_code BIGINT, naics_us_industry_code BIGINT, naics_industry_code BIGINT, naics_industry_group BIGINT, naics_subsector BIGINT, naics_sector BIGINT, description VARCHAR, PRIMARY KEY(naics_code), FOREIGN KEY (naics_sector) REFERENCES l_naics_sector(naics_sector));