siccodes.txt

国外的一套开源CRM

insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1021, "Copper Ores", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1031, "Lead and Zinc Ores", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1041, "Gold Ores", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1044, "Silver Ores", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1061, "Ferroalloy Ores", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1081, "Metal Mining Services", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1094, "Uranium-radium-vanadium Ores", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1099, "Metal Ores", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1221, "Bituminous Coal and Lignite-surface Mining", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1222, "Bituminous Coal-underground Mining", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1231, "Anthracite Mining", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1241, "Coal Mining Services", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1311, "Crude Petroleum and Natural Gas", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1321, "Natural Gas Liquids", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1381, "Drilling Oil and Gas Wells", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1382, "Oil and Gas Exploration Services", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1389, "Oil and Gas Field Services", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1411, "Dimension Stone", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1422, "Crushed and Broken Limestone", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1423, "Crushed and Broken Granite", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1429, "Crushed and Broken Stone", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1442, "Construction Sand and Gravel", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1446, "Industrial Sand", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1455, "Kaolin and Ball Clay", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1459, "Clay and Related Minerals", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1474, "Potash", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1475, "Phosphate Rock", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1479, "Chemical and Fertilizer Mining", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1481, "Nonmetallic Mineral Services", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1499, "Miscellaneous Nonmetallic Mining", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1521, "Single-family Housing Construction", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1522, "Residential Construction", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1531, "Operative Builders", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1541, "Industrial Buildings and Warehouses", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1542, "Nonresidential Construction", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1611, "Highway and Street Construction", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1622, "Bridge", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1623, "Water", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1629, "Heavy Construction", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1711, "Plumbing", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1721, "Painting and Paper Hanging", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1731, "Electrical Work", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1741, "Masonry and Other Stonework", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1742, "Plastering", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1743, "Terrazzo", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1751, "Carpentry Work", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1752, "Floor Laying and Floor Work", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1761, "Roofing", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1771, "Concrete Work", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1781, "Water Well Drilling", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1791, "Structural Steel Erection", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1793, "Glass and Glazing Work", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1794, "Excavation Work", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1795, "Wrecking and Demolition Work", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1796, "Installing Building Equipment", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1799, "Special Trade Contractors", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (2011, "Meat Packing Plants", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (2013, "Sausages and Other Prepared Meats", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (2015, "Poultry Slaughtering and Processing", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');