# # Table structure for table `soc_codes` # # Creation: Dec 11, 2003 at 03:12 PM # Last update: Dec 11, 2003 at 04:01 PM # CREATE TABLE `soc_codes` ( `gid` int(11) NOT NULL auto_increment, `major_group` int(11) NOT NULL default '0', `minor_group` int(11) NOT NULL default '0', `description` tinytext NOT NULL, PRIMARY KEY (`gid`) ) TYPE=MyISAM AUTO_INCREMENT=1390 ; # # Dumping data for table `soc_codes` # INSERT INTO `soc_codes` VALUES (2, 11, 0, 'Management Occupations'); INSERT INTO `soc_codes` VALUES (3, 11, 1000, 'Top Executives'); INSERT INTO `soc_codes` VALUES (4, 11, 1010, 'Chief Executives'); INSERT INTO `soc_codes` VALUES (5, 11, 1011, 'Chief Executives'); INSERT INTO `soc_codes` VALUES (6, 11, 1020, 'General and Operations Managers'); INSERT INTO `soc_codes` VALUES (7, 11, 1021, 'General and Operations Managers'); INSERT INTO `soc_codes` VALUES (8, 11, 1030, 'Legislators'); INSERT INTO `soc_codes` VALUES (9, 11, 1031, 'Legislators'); INSERT INTO `soc_codes` VALUES (10, 11, 2000, 'Advertising, Marketing, Promotions, Public Relations, and Sales Managers'); INSERT INTO `soc_codes` VALUES (11, 11, 2010, 'Advertising and Promotions Managers'); INSERT INTO `soc_codes` VALUES (12, 11, 2011, 'Advertising and Promotions Managers'); INSERT INTO `soc_codes` VALUES (13, 11, 2020, 'Marketing and Sales Managers'); INSERT INTO `soc_codes` VALUES (14, 11, 2021, 'Marketing Managers'); INSERT INTO `soc_codes` VALUES (15, 11, 2022, 'Sales Managers'); INSERT INTO `soc_codes` VALUES (16, 11, 2030, 'Public Relations Managers'); INSERT INTO `soc_codes` VALUES (17, 11, 2031, 'Public Relations Managers'); INSERT INTO `soc_codes` VALUES (18, 11, 3000, 'Operations Specialties Managers'); INSERT INTO `soc_codes` VALUES (19, 11, 3010, 'Administrative Services Managers'); INSERT INTO `soc_codes` VALUES (20, 11, 3011, 'Administrative Services Managers'); INSERT INTO `soc_codes` VALUES (21, 11, 3020, 'Computer and Information Systems Managers'); INSERT INTO `soc_codes` VALUES (22, 11, 3021, 'Computer and Information Systems Managers'); INSERT INTO `soc_codes` VALUES (23, 11, 3030, 'Financial Managers'); INSERT INTO `soc_codes` VALUES (24, 11, 3031, 'Financial Managers'); INSERT INTO `soc_codes` VALUES (25, 11, 3040, 'Human Resources Managers'); INSERT INTO `soc_codes` VALUES (26, 11, 3041, 'Compensation and Benefits Managers'); INSERT INTO `soc_codes` VALUES (27, 11, 3042, 'Training and Development Managers'); INSERT INTO `soc_codes` VALUES (28, 11, 3049, 'Human Resources Managers, All Other'); INSERT INTO `soc_codes` VALUES (29, 11, 3050, 'Industrial Production Managers'); INSERT INTO `soc_codes` VALUES (30, 11, 3051, 'Industrial Production Managers'); INSERT INTO `soc_codes` VALUES (31, 11, 3060, 'Purchasing Managers'); INSERT INTO `soc_codes` VALUES (32, 11, 3061, 'Purchasing Managers'); INSERT INTO `soc_codes` VALUES (33, 11, 3070, 'Transportation, Storage, and Distribution Managers'); INSERT INTO `soc_codes` VALUES (34, 11, 3071, 'Transportation, Storage, and Distribution Managers'); INSERT INTO `soc_codes` VALUES (35, 11, 9000, 'Other Management Occupations'); INSERT INTO `soc_codes` VALUES (36, 11, 9010, 'Agricultural Managers'); INSERT INTO `soc_codes` VALUES (37, 11, 9011, 'Farm, Ranch, and Other Agricultural Managers'); INSERT INTO `soc_codes` VALUES (38, 11, 9012, 'Farmers and Ranchers'); INSERT INTO `soc_codes` VALUES (39, 11, 9020, 'Construction Managers'); INSERT INTO `soc_codes` VALUES (40, 11, 9021, 'Construction Managers'); INSERT INTO `soc_codes` VALUES (41, 11, 9030, 'Education Administrators'); INSERT INTO `soc_codes` VALUES (42, 11, 9031, 'Education Administrators, Preschool and Child Care Center/Program'); INSERT INTO `soc_codes` VALUES (43, 11, 9032, 'Education Administrators, Elementary and Secondary School'); INSERT INTO `soc_codes` VALUES (44, 11, 9033, 'Education Administrators, Postsecondary'); INSERT INTO `soc_codes` VALUES (45, 11, 9039, 'Education Administrators, All Other'); INSERT INTO `soc_codes` VALUES (46, 11, 9040, 'Engineering Managers'); INSERT INTO `soc_codes` VALUES (47, 11, 9041, 'Engineering Managers'); INSERT INTO `soc_codes` VALUES (48, 11, 9050, 'Food Service Managers'); INSERT INTO `soc_codes` VALUES (49, 11, 9051, 'Food Service Managers'); INSERT INTO `soc_codes` VALUES (50, 11, 9060, 'Funeral Directors'); INSERT INTO `soc_codes` VALUES (51, 11, 9061, 'Funeral Directors'); INSERT INTO `soc_codes` VALUES (52, 11, 9070, 'Gaming Managers'); INSERT INTO `soc_codes` VALUES (53, 11, 9071, 'Gaming Managers'); INSERT INTO `soc_codes` VALUES (54, 11, 9080, 'Lodging Managers'); INSERT INTO `soc_codes` VALUES (55, 11, 9081, 'Lodging Managers'); INSERT INTO `soc_codes` VALUES (56, 11, 9110, 'Medical and Health Services Managers'); INSERT INTO `soc_codes` VALUES (57, 11, 9111, 'Medical and Health Services Managers'); INSERT INTO `soc_codes` VALUES (58, 11, 9120, 'Natural Sciences Managers'); INSERT INTO `soc_codes` VALUES (59, 11, 9121, 'Natural Sciences Managers'); INSERT INTO `soc_codes` VALUES (60, 11, 9130, 'Postmasters and Mail Superintendents'); INSERT INTO `soc_codes` VALUES (61, 11, 9131, 'Postmasters and Mail Superintendents'); INSERT INTO `soc_codes` VALUES (62, 11, 9140, 'Property, Real Estate, and Community Association Managers'); INSERT INTO `soc_codes` VALUES (63, 11, 9141, 'Property, Real Estate, and Community Association Managers'); INSERT INTO `soc_codes` VALUES (64, 11, 9150, 'Social and Community Service Managers'); INSERT INTO `soc_codes` VALUES (65, 11, 9151, 'Social and Community Service Managers'); INSERT INTO `soc_codes` VALUES (66, 11, 9190, 'Miscellaneous Managers'); INSERT INTO `soc_codes` VALUES (67, 11, 9199, 'Managers, All Other'); INSERT INTO `soc_codes` VALUES (68, 13, 0, 'Business and Financial Operations Occupations'); INSERT INTO `soc_codes` VALUES (69, 13, 1000, 'Business Operations Specialists'); INSERT INTO `soc_codes` VALUES (70, 13, 1010, 'Agents and Business Managers of Artists, Performers, and Athletes'); INSERT INTO `soc_codes` VALUES (71, 13, 1011, 'Agents and Business Managers of Artists, Performers, and Athletes'); INSERT INTO `soc_codes` VALUES (72, 13, 1020, 'Buyers and Purchasing Agents'); INSERT INTO `soc_codes` VALUES (73, 13, 1021, 'Purchasing Agents and Buyers, Farm Products'); INSERT INTO `soc_codes` VALUES (74, 13, 1022, 'Wholesale and Retail Buyers, Except Farm Products'); INSERT INTO `soc_codes` VALUES (75, 13, 1023, 'Purchasing Agents, Except Wholesale, Retail, and Farm Products'); INSERT INTO `soc_codes` VALUES (76, 13, 1030, 'Claims Adjusters, Appraisers, Examiners, and Investigators'); INSERT INTO `soc_codes` VALUES (77, 13, 1031, 'Claims Adjusters, Examiners, and Investigators'); INSERT INTO `soc_codes` VALUES (78, 13, 1032, 'Insurance Appraisers, Auto Damage'); INSERT INTO `soc_codes` VALUES (79, 13, 1040, 'Compliance Officers, Except Agriculture, Construction, Health and Safety, and Transportation'); INSERT INTO `soc_codes` VALUES (80, 13, 1041, 'Compliance Officers, Except Agriculture, Construction, Health and Safety, and Transportation'); INSERT INTO `soc_codes` VALUES (81, 13, 1050, 'Cost Estimators'); INSERT INTO `soc_codes` VALUES (82, 13, 1051, 'Cost Estimators'); INSERT INTO `soc_codes` VALUES (83, 13, 1060, 'Emergency Management Specialists'); INSERT INTO `soc_codes` VALUES (84, 13, 1061, 'Emergency Management Specialists'); INSERT INTO `soc_codes` VALUES (85, 13, 1070, 'Human Resources, Training, and Labor Relations Specialists'); INSERT INTO `soc_codes` VALUES (86, 13, 1071, 'Employment, Recruitment, and Placement Specialists'); INSERT INTO `soc_codes` VALUES (87, 13, 1072, 'Compensation, Benefits, and Job Analysis Specialists'); INSERT INTO `soc_codes` VALUES (88, 13, 1073, 'Training and Development Specialists'); INSERT INTO `soc_codes` VALUES (89, 13, 1079, 'Human Resources, Training, and Labor Relations Specialists, All Other'); INSERT INTO `soc_codes` VALUES (90, 13, 1080, 'Logisticians'); INSERT INTO `soc_codes` VALUES (91, 13, 1081, 'Logisticians'); INSERT INTO `soc_codes` VALUES (92, 13, 1110, 'Management Analysts'); INSERT INTO `soc_codes` VALUES (93, 13, 1111, 'Management Analysts'); INSERT INTO `soc_codes` VALUES (94, 13, 1120, 'Meeting and Convention Planers'); INSERT INTO `soc_codes` VALUES (95, 13, 1121, 'Meeting and Convention Planers'); INSERT INTO `soc_codes` VALUES (96, 13, 1190, 'Miscellaneous Business Operations Specialists'); INSERT INTO `soc_codes` VALUES (97, 13, 1199, 'Business Operations Specialists, All Other'); INSERT INTO `soc_codes` VALUES (98, 13, 2000, 'Financial Specialists'); INSERT INTO `soc_codes` VALUES (99, 13, 2010, 'Accountants and Auditors'); INSERT INTO `soc_codes` VALUES (100, 13, 2011, 'Accountants and Auditors'); INSERT INTO `soc_codes` VALUES (101, 13, 2020, 'Appraisers and Assessors of Real Estate'); INSERT INTO `soc_codes` VALUES (102, 13, 2021, 'Appraisers and Assessors of Real Estate'); INSERT INTO `soc_codes` VALUES (103, 13, 2030, 'Budget Analysts'); INSERT INTO `soc_codes` VALUES (104, 13, 2031, 'Budget Analysts'); INSERT INTO `soc_codes` VALUES (105, 13, 2040, 'Credit Analysts'); INSERT INTO `soc_codes` VALUES (106, 13, 2041, 'Credit Analysts'); INSERT INTO `soc_codes` VALUES (107, 13, 2050, 'Financial Analysts and Advisors'); INSERT INTO `soc_codes` VALUES (108, 13, 2051, 'Financial Analysts'); INSERT INTO `soc_codes` VALUES (109, 13, 2052, 'Personal Financial Advisors'); INSERT INTO `soc_codes` VALUES (110, 13, 2053, 'Insurance Underwriters'); INSERT INTO `soc_codes` VALUES (111, 13, 2060, 'Financial Examiners'); INSERT INTO `soc_codes` VALUES (112, 13, 2061, 'Financial Examiners'); INSERT INTO `soc_codes` VALUES (113, 13, 2070, 'Loan Counselors and Officers'); INSERT INTO `soc_codes` VALUES (114, 13, 2071, 'Loan Counselors'); INSERT INTO `soc_codes` VALUES (115, 13, 2072, 'Loan Officers'); INSERT INTO `soc_codes` VALUES (116, 13, 2080, 'Tax Examiners, Collectors, Preparers, and Revenue Agents'); INSERT INTO `soc_codes` VALUES (117, 13, 2081, 'Tax Examiners, Collectors, and Revenue Agents'); INSERT INTO `soc_codes` VALUES (118, 13, 2082, 'Tax Preparers'); INSERT INTO `soc_codes` VALUES (119, 13, 2090, 'Miscellaneous Financial Specialists'); INSERT INTO `soc_codes` VALUES (120, 13, 2099, 'Financial Specialists, All Other'); INSERT INTO `soc_codes` VALUES (121, 15, 0, 'Computer and Mathematical Occupations'); INSERT INTO `soc_codes` VALUES (122, 15, 1000, 'Computer Specialists'); INSERT INTO `soc_codes` VALUES (123, 15, 1010, 'Computer and Information Scientists, Research'); INSERT INTO `soc_codes` VALUES (124, 15, 1011, 'Computer and Information Scientists, Research'); INSERT INTO `soc_codes` VALUES (125, 15, 1020, 'Computer Programmers'); INSERT INTO `soc_codes` VALUES (126, 15, 1021, 'Computer Programmers'); INSERT INTO `soc_codes` VALUES (127, 15, 1030, 'Computer Software Engineers'); INSERT INTO `soc_codes` VALUES (128, 15, 1031, 'Computer Software Engineers, Applications'); INSERT INTO `soc_codes` VALUES (129, 15, 1032, 'Computer Software Engineers, Systems Software'); INSERT INTO `soc_codes` VALUES (130, 15, 1040, 'Computer Support Specialists'); INSERT INTO `soc_codes` VALUES (131, 15, 1041, 'Computer Support Specialists'); INSERT INTO `soc_codes` VALUES (132, 15, 1050, 'Computer Systems Analysts'); INSERT INTO `soc_codes` VALUES (133, 15, 1051, 'Computer Systems Analysts'); INSERT INTO `soc_codes` VALUES (134, 15, 1060, 'Database Administrators'); INSERT INTO `soc_codes` VALUES (135, 15, 1061, 'Database Administrators'); INSERT INTO `soc_codes` VALUES (136, 15, 1070, 'Network and Computer Systems Administrators'); INSERT INTO `soc_codes` VALUES (137, 15, 1071, 'Network and Computer Systems Administrators'); INSERT INTO `soc_codes` VALUES (138, 15, 1080, 'Network Systems and Data Communications Analysts'); INSERT INTO `soc_codes` VALUES (139, 15, 1081, 'Network Systems and Data Communications Analysts'); INSERT INTO `soc_codes` VALUES (140, 15, 1090, 'Miscellaneous Computer Specialists'); INSERT INTO `soc_codes` VALUES (141, 15, 1099, 'Computer Specialists, All Other'); INSERT INTO `soc_codes` VALUES (142, 15, 2000, 'Mathematical Science Occupations'); INSERT INTO `soc_codes` VALUES (143, 15, 2010, 'Actuaries'); INSERT INTO `soc_codes` VALUES (144, 15, 2011, 'Actuaries'); INSERT INTO `soc_codes` VALUES (145, 15, 2020, 'Mathematicians'); INSERT INTO `soc_codes` VALUES (146, 15, 2021, 'Mathematicians'); INSERT INTO `soc_codes` VALUES (147, 15, 2030, 'Operations Research Analysts'); INSERT INTO `soc_codes` VALUES (148, 15, 2031, 'Operations Research Analysts'); INSERT INTO `soc_codes` VALUES (149, 15, 2040, 'Statisticians'); INSERT INTO `soc_codes` VALUES (150, 15, 2041, 'Statisticians'); INSERT INTO `soc_codes` VALUES (151, 15, 2090, 'Miscellaneous Mathematical Science Occupations'); INSERT INTO `soc_codes` VALUES (152, 15, 2091, 'Mathematical Technicians'); INSERT INTO `soc_codes` VALUES (153, 15, 2099, 'Mathematical Science Occupations, All Other'); INSERT INTO `soc_codes` VALUES (154, 17, 0, 'Architecture and Engineering Occupations'); INSERT INTO `soc_codes` VALUES (155, 17, 1000, 'Architects, Surveyors, and Cartographers'); INSERT INTO `soc_codes` VALUES (156, 17, 1010, 'Architects, Except Naval'); INSERT INTO `soc_codes` VALUES (157, 17, 1011, 'Architects, Except Landscape and Naval'); INSERT INTO `soc_codes` VALUES (158, 17, 1012, 'Landscape Architects'); INSERT INTO `soc_codes` VALUES (159, 17, 1020, 'Surveyors, Cartographers, and Photogrammetrists'); INSERT INTO `soc_codes` VALUES (160, 17, 1021, 'Cartographers and Photogrammetrists'); INSERT INTO `soc_codes` VALUES (161, 17, 1022, 'Surveyors'); INSERT INTO `soc_codes` VALUES (162, 17, 2000, 'Engineers'); INSERT INTO `soc_codes` VALUES (163, 17, 2010, 'Aerospace Engineers'); INSERT INTO `soc_codes` VALUES (164, 17, 2011, 'Aerospace Engineers'); INSERT INTO `soc_codes` VALUES (165, 17, 2020, 'Agricultural Engineers'); INSERT INTO `soc_codes` VALUES (166, 17, 2021, 'Agricultural Engineers'); INSERT INTO `soc_codes` VALUES (167, 17, 2030, 'Biomedical Engineers'); INSERT INTO `soc_codes` VALUES (168, 17, 2031, 'Biomedical Engineers'); INSERT INTO `soc_codes` VALUES (169, 17, 2040, 'Chemical Engineers'); INSERT INTO `soc_codes` VALUES (170, 17, 2041, 'Chemical Engineers'); INSERT INTO `soc_codes` VALUES (171, 17, 2050, 'Civil Engineers'); INSERT INTO `soc_codes` VALUES (172, 17, 2051, 'Civil Engineers'); INSERT INTO `soc_codes` VALUES (173, 17, 2060, 'Computer Hardware Engineers'); INSERT INTO `soc_codes` VALUES (174, 17, 2061, 'Computer Hardware Engineers'); INSERT INTO `soc_codes` VALUES (175, 17, 2070, 'Electrical and Electronics Engineers'); INSERT INTO `soc_codes` VALUES (176, 17, 2071, 'Electrical Engineers'); INSERT INTO `soc_codes` VALUES (177, 17, 2072, 'Electronics Engineers, Except Computer'); INSERT INTO `soc_codes` VALUES (178, 17, 2080, 'Environmental Engineers'); INSERT INTO `soc_codes` VALUES (179, 17, 2081, 'Environmental Engineers'); INSERT INTO `soc_codes` VALUES (180, 17, 2110, 'Industrial Engineers, Including Health and Safety'); INSERT INTO `soc_codes` VALUES (181, 17, 2111, 'Health and Safety Engineers, Except Mining Safety Engineers and Inspectors'); INSERT INTO `soc_codes` VALUES (182, 17, 2112, 'Industrial Engineers'); INSERT INTO `soc_codes` VALUES (183, 17, 2120, 'Marine Engineers and Naval Architects'); INSERT INTO `soc_codes` VALUES (184, 17, 2121, 'Marine Engineers and Naval Architects'); INSERT INTO `soc_codes` VALUES (185, 17, 2130, 'Materials Engineers'); INSERT INTO `soc_codes` VALUES (186, 17, 2131, 'Materials Engineers'); INSERT INTO `soc_codes` VALUES (187, 17, 2140, 'Mechanical Engineers'); INSERT INTO `soc_codes` VALUES (188, 17, 2141, 'Mechanical Engineers'); INSERT INTO `soc_codes` VALUES (189, 17, 2150, 'Mining and Geological Engineers, Including Mining Safety Engineers'); INSERT INTO `soc_codes` VALUES (190, 17, 2151, 'Mining and Geological Engineers, Including Mining Safety Engineers'); INSERT INTO `soc_codes` VALUES (191, 17, 2160, 'Nuclear Engineers'); INSERT INTO `soc_codes` VALUES (192, 17, 2161, 'Nuclear Engineers'); INSERT INTO `soc_codes` VALUES (193, 17, 2170, 'Petroleum Engineers'); INSERT INTO `soc_codes` VALUES (194, 17, 2171, 'Petroleum Engineers'); INSERT INTO `soc_codes` VALUES (195, 17, 2190, 'Miscellaneous Engineers'); INSERT INTO `soc_codes` VALUES (196, 17, 2199, 'Engineers, All Other'); INSERT INTO `soc_codes` VALUES (197, 17, 3000, 'Drafters, Engineering, and Mapping Technicians'); INSERT INTO `soc_codes` VALUES (198, 17, 3010, 'Drafters'); INSERT INTO `soc_codes` VALUES (199, 17, 3011, 'Architectural and Civil Drafters'); INSERT INTO `soc_codes` VALUES (200, 17, 3012, 'Electrical and Electronics Drafters'); INSERT INTO `soc_codes` VALUES (201, 17, 3013, 'Mechanical Drafters'); INSERT INTO `soc_codes` VALUES (202, 17, 3019, 'Drafters, All Other'); INSERT INTO `soc_codes` VALUES (203, 17, 3020, 'Engineering Technicians, Except Drafters'); INSERT INTO `soc_codes` VALUES (204, 17, 3021, 'Aerospace Engineering and Operations Technicians'); INSERT INTO `soc_codes` VALUES (205, 17, 3022, 'Civil Engineering Technicians'); INSERT INTO `soc_codes` VALUES (206, 17, 3023, 'Electrical and Electronic Engineering Technicians'); INSERT INTO `soc_codes` VALUES (207, 17, 3024, 'Electro-Mechanical Technicians'); INSERT INTO `soc_codes` VALUES (208, 17, 3025, 'Environmental Engineering Technicians'); INSERT INTO `soc_codes` VALUES (209, 17, 3026, 'Industrial Engineering Technicians'); INSERT INTO `soc_codes` VALUES (210, 17, 3027, 'Mechanical Engineering Technicians'); INSERT INTO `soc_codes` VALUES (211, 17, 3029, 'Engineering Technicians, Except Drafters, All Other'); INSERT INTO `soc_codes` VALUES (212, 17, 3030, 'Surveying and Mapping Technicians'); INSERT INTO `soc_codes` VALUES (213, 17, 3031, 'Surveying and Mapping Technicians'); INSERT INTO `soc_codes` VALUES (214, 19, 0, 'Life, Physical, and Social Science Occupations'); INSERT INTO `soc_codes` VALUES (215, 19, 1000, 'Life Scientists'); INSERT INTO `soc_codes` VALUES (216, 19, 1010, 'Agricultural and Food Scientists'); INSERT INTO `soc_codes` VALUES (217, 19, 1011, 'Animal Scientists'); INSERT INTO `soc_codes` VALUES (218, 19, 1012, 'Food Scientists and Technologists'); INSERT INTO `soc_codes` VALUES (219, 19, 1013, 'Soil and Plant Scientists'); INSERT INTO `soc_codes` VALUES (220, 19, 1020, 'Biological Scientists'); INSERT INTO `soc_codes` VALUES (221, 19, 1021, 'Biochemists and Biophysicists'); INSERT INTO `soc_codes` VALUES (222, 19, 1022, 'Microbiologists'); INSERT INTO `soc_codes` VALUES (223, 19, 1023, 'Zoologists and Wildlife Biologists'); INSERT INTO `soc_codes` VALUES (224, 19, 1029, 'Biological Scientists, All Other'); INSERT INTO `soc_codes` VALUES (225, 19, 1030, 'Conservation Scientists and Foresters'); INSERT INTO `soc_codes` VALUES (226, 19, 1031, 'Conservation Scientists'); INSERT INTO `soc_codes` VALUES (227, 19, 1032, 'Foresters'); INSERT INTO `soc_codes` VALUES (228, 19, 1040, 'Medical Scientists'); INSERT INTO `soc_codes` VALUES (229, 19, 1041, 'Epidemiologists'); INSERT INTO `soc_codes` VALUES (230, 19, 1042, 'Medical Scientists, Except Epidemiologists'); INSERT INTO `soc_codes` VALUES (231, 19, 1090, 'Miscellaneous Life Scientists'); INSERT INTO `soc_codes` VALUES (232, 19, 1099, 'Life Scientists, All Other'); INSERT INTO `soc_codes` VALUES (233, 19, 2000, 'Physical Scientists'); INSERT INTO `soc_codes` VALUES (234, 19, 2010, 'Astronomers and Physicists'); INSERT INTO `soc_codes` VALUES (235, 19, 2011, 'Astronomers'); INSERT INTO `soc_codes` VALUES (236, 19, 2012, 'Physicists'); INSERT INTO `soc_codes` VALUES (237, 19, 2020, 'Atmospheric and Space Scientists'); INSERT INTO `soc_codes` VALUES (238, 19, 2021, 'Atmospheric and Space Scientists'); INSERT INTO `soc_codes` VALUES (239, 19, 2030, 'Chemists and Materials Scientists'); INSERT INTO `soc_codes` VALUES (240, 19, 2031, 'Chemists'); INSERT INTO `soc_codes` VALUES (241, 19, 2032, 'Materials Scientists'); INSERT INTO `soc_codes` VALUES (242, 19, 2040, 'Environmental Scientists and Geoscientists'); INSERT INTO `soc_codes` VALUES (243, 19, 2041, 'Environmental Scientists and Specialists, Including Health'); INSERT INTO `soc_codes` VALUES (244, 19, 2042, 'Geoscientists, Except Hydrologists and Geographers'); INSERT INTO `soc_codes` VALUES (245, 19, 2043, 'Hydrologists'); INSERT INTO `soc_codes` VALUES (246, 19, 2090, 'Miscellaneous Physical Scientists'); INSERT INTO `soc_codes` VALUES (247, 19, 2099, 'Physical Scientists, All Other'); INSERT INTO `soc_codes` VALUES (248, 19, 3000, 'Social Scientists and Related Workers'); INSERT INTO `soc_codes` VALUES (249, 19, 3010, 'Economists'); INSERT INTO `soc_codes` VALUES (250, 19, 3011, 'Economists'); INSERT INTO `soc_codes` VALUES (251, 19, 3020, 'Market and Survey Researchers'); INSERT INTO `soc_codes` VALUES (252, 19, 3021, 'Market Research Analysts'); INSERT INTO `soc_codes` VALUES (253, 19, 3022, 'Survey Researchers'); INSERT INTO `soc_codes` VALUES (254, 19, 3030, 'Psychologists'); INSERT INTO `soc_codes` VALUES (255, 19, 3031, 'Clinical, Counseling, and School Psychologists'); INSERT INTO `soc_codes` VALUES (256, 19, 3032, 'Industrial-Organizational Psychologists'); INSERT INTO `soc_codes` VALUES (257, 19, 3039, 'Psychologists, All Other'); INSERT INTO `soc_codes` VALUES (258, 19, 3040, 'Sociologists'); INSERT INTO `soc_codes` VALUES (259, 19, 3041, 'Sociologists'); INSERT INTO `soc_codes` VALUES (260, 19, 3050, 'Urban and Regional Planers'); INSERT INTO `soc_codes` VALUES (261, 19, 3051, 'Urban and Regional Planers'); INSERT INTO `soc_codes` VALUES (262, 19, 3090, 'Miscellaneous Social Scientists and Related Workers'); INSERT INTO `soc_codes` VALUES (263, 19, 3091, 'Anthropologists and Archeologists'); INSERT INTO `soc_codes` VALUES (264, 19, 3092, 'Geographers'); INSERT INTO `soc_codes` VALUES (265, 19, 3093, 'Historians'); INSERT INTO `soc_codes` VALUES (266, 19, 3094, 'Political Scientists'); INSERT INTO `soc_codes` VALUES (267, 19, 3099, 'Social Scientists and Related Workers, All Other'); INSERT INTO `soc_codes` VALUES (268, 19, 4000, 'Life, Physical, and Social Science Technicians'); INSERT INTO `soc_codes` VALUES (269, 19, 4010, 'Agricultural and Food Science Technicians'); INSERT INTO `soc_codes` VALUES (270, 19, 4011, 'Agricultural and Food Science Technicians'); INSERT INTO `soc_codes` VALUES (271, 19, 4020, 'Biological Technicians'); INSERT INTO `soc_codes` VALUES (272, 19, 4021, 'Biological Technicians'); INSERT INTO `soc_codes` VALUES (273, 19, 4030, 'Chemical Technicians'); INSERT INTO `soc_codes` VALUES (274, 19, 4031, 'Chemical Technicians'); INSERT INTO `soc_codes` VALUES (275, 19, 4040, 'Geological and Petroleum Technicians'); INSERT INTO `soc_codes` VALUES (276, 19, 4041, 'Geological and Petroleum Technicians'); INSERT INTO `soc_codes` VALUES (277, 19, 4050, 'Nuclear Technicians'); INSERT INTO `soc_codes` VALUES (278, 19, 4051, 'Nuclear Technicians'); INSERT INTO `soc_codes` VALUES (279, 19, 4060, 'Social Science Research Assistants'); INSERT INTO `soc_codes` VALUES (280, 19, 4061, 'Social Science Research Assistants'); INSERT INTO `soc_codes` VALUES (281, 19, 4090, 'Miscellaneous Life, Physical, and Social Science Technicians'); INSERT INTO `soc_codes` VALUES (282, 19, 4091, 'Environmental Science and Protection Technicians, Including Health'); INSERT INTO `soc_codes` VALUES (283, 19, 4092, 'Forensic Science Technicians'); INSERT INTO `soc_codes` VALUES (284, 19, 4093, 'Forest and Conservation Technicians'); INSERT INTO `soc_codes` VALUES (285, 19, 4099, 'Life, Physical, and Social Science Technicians, All Other'); INSERT INTO `soc_codes` VALUES (286, 21, 0, 'Community and Social Services Occupations'); INSERT INTO `soc_codes` VALUES (287, 21, 1000, 'Counselors, Social Workers, and Other Community and Social Service Specialists'); INSERT INTO `soc_codes` VALUES (288, 21, 1010, 'Counselors'); INSERT INTO `soc_codes` VALUES (289, 21, 1011, 'Substance Abuse and Behavioral Disorder Counselors'); INSERT INTO `soc_codes` VALUES (290, 21, 1012, 'Educational, Vocational, and School Counselors'); INSERT INTO `soc_codes` VALUES (291, 21, 1013, 'Marriage and Family Therapists'); INSERT INTO `soc_codes` VALUES (292, 21, 1014, 'Mental Health Counselors'); INSERT INTO `soc_codes` VALUES (293, 21, 1015, 'Rehabilitation Counselors'); INSERT INTO `soc_codes` VALUES (294, 21, 1019, 'Counselors, All Other'); INSERT INTO `soc_codes` VALUES (295, 21, 1020, 'Social Workers'); INSERT INTO `soc_codes` VALUES (296, 21, 1021, 'Child, Family, and School Social Workers'); INSERT INTO `soc_codes` VALUES (297, 21, 1022, 'Medical and Public Health Social Workers'); INSERT INTO `soc_codes` VALUES (298, 21, 1023, 'Mental Health and Substance Abuse Social Workers'); INSERT INTO `soc_codes` VALUES (299, 21, 1029, 'Social Workers, All Other'); INSERT INTO `soc_codes` VALUES (300, 21, 1090, 'Miscellaneous Community and Social Service Specialists'); INSERT INTO `soc_codes` VALUES (301, 21, 1091, 'Health Educators'); INSERT INTO `soc_codes` VALUES (302, 21, 1092, 'Probation Officers and Correctional Treatment Specialists'); INSERT INTO `soc_codes` VALUES (303, 21, 1093, 'Social and Human Service Assistants'); INSERT INTO `soc_codes` VALUES (304, 21, 1099, 'Community and Social Service Specialists, All Other'); INSERT INTO `soc_codes` VALUES (305, 21, 2000, 'Religious Workers'); INSERT INTO `soc_codes` VALUES (306, 21, 2010, 'Clergy'); INSERT INTO `soc_codes` VALUES (307, 21, 2011, 'Clergy'); INSERT INTO `soc_codes` VALUES (308, 21, 2020, 'Directors, Religious Activities and Education'); INSERT INTO `soc_codes` VALUES (309, 21, 2021, 'Directors, Religious Activities and Education'); INSERT INTO `soc_codes` VALUES (310, 21, 2090, 'Miscellaneous Religious Workers'); INSERT INTO `soc_codes` VALUES (311, 21, 2099, 'Religious Workers, All Other'); INSERT INTO `soc_codes` VALUES (312, 23, 0, 'Legal Occupations'); INSERT INTO `soc_codes` VALUES (313, 23, 1000, 'Lawyers, Judges, and Related Workers'); INSERT INTO `soc_codes` VALUES (314, 23, 1010, 'Lawyers'); INSERT INTO `soc_codes` VALUES (315, 23, 1011, 'Lawyers'); INSERT INTO `soc_codes` VALUES (316, 23, 1020, 'Judges, Magistrates, and Other Judicial Workers'); INSERT INTO `soc_codes` VALUES (317, 23, 1021, 'Administrative Law Judges, Adjudicators, and Hearing Officers'); INSERT INTO `soc_codes` VALUES (318, 23, 1022, 'Arbitrators, Mediators, and Conciliators'); INSERT INTO `soc_codes` VALUES (319, 23, 1023, 'Judges, Magistrate Judges, and Magistrates'); INSERT INTO `soc_codes` VALUES (320, 23, 2000, 'Legal Support Workers'); INSERT INTO `soc_codes` VALUES (321, 23, 2010, 'Paralegals and Legal Assistants'); INSERT INTO `soc_codes` VALUES (322, 23, 2011, 'Paralegals and Legal Assistants'); INSERT INTO `soc_codes` VALUES (323, 23, 2090, 'Miscellaneous Legal Support Workers'); INSERT INTO `soc_codes` VALUES (324, 23, 2091, 'Court Reporters'); INSERT INTO `soc_codes` VALUES (325, 23, 2092, 'Law Clerks'); INSERT INTO `soc_codes` VALUES (326, 23, 2093, 'Title Examiners, Abstractors, and Searchers'); INSERT INTO `soc_codes` VALUES (327, 23, 2099, 'Legal Support Workers, All Other'); INSERT INTO `soc_codes` VALUES (328, 25, 0, 'Education, Training, and Library Occupations'); INSERT INTO `soc_codes` VALUES (329, 25, 1000, 'Postsecondary Teachers'); INSERT INTO `soc_codes` VALUES (330, 25, 1010, 'Business Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (331, 25, 1011, 'Business Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (332, 25, 1020, 'Math and Computer Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (333, 25, 1021, 'Computer Science Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (334, 25, 1022, 'Mathematical Science Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (335, 25, 1030, 'Engineering and Architecture Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (336, 25, 1031, 'Architecture Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (337, 25, 1032, 'Engineering Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (338, 25, 1040, 'Life Sciences Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (339, 25, 1041, 'Agricultural Sciences Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (340, 25, 1042, 'Biological Science Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (341, 25, 1043, 'Forestry and Conservation Science Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (342, 25, 1050, 'Physical Sciences Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (343, 25, 1051, 'Atmospheric, Earth, Marine, and Space Sciences Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (344, 25, 1052, 'Chemistry Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (345, 25, 1053, 'Environmental Science Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (346, 25, 1054, 'Physics Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (347, 25, 1060, 'Social Sciences Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (348, 25, 1061, 'Anthropology and Archeology Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (349, 25, 1062, 'Area, Ethnic, and Cultural Studies Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (350, 25, 1063, 'Economics Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (351, 25, 1064, 'Geography Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (352, 25, 1065, 'Political Science Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (353, 25, 1066, 'Psychology Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (354, 25, 1067, 'Sociology Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (355, 25, 1069, 'Social Sciences Teachers, Postsecondary, All Other'); INSERT INTO `soc_codes` VALUES (356, 25, 1070, 'Health Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (357, 25, 1071, 'Health Specialties Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (358, 25, 1072, 'Nursing Instructors and Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (359, 25, 1080, 'Education and Library Science Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (360, 25, 1081, 'Education Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (361, 25, 1082, 'Library Science Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (362, 25, 1110, 'Law, Criminal Justice, and Social Work Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (363, 25, 1111, 'Criminal Justice and Law Enforcement Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (364, 25, 1112, 'Law Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (365, 25, 1113, 'Social Work Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (366, 25, 1120, 'Arts, Communications, and Humanities Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (367, 25, 1121, 'Art, Drama, and Music Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (368, 25, 1122, 'Communications Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (369, 25, 1123, 'English Language and Literature Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (370, 25, 1124, 'Foreign Language and Literature Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (371, 25, 1125, 'History Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (372, 25, 1126, 'Philosophy and Religion Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (373, 25, 1190, 'Miscellaneous Postsecondary Teachers'); INSERT INTO `soc_codes` VALUES (374, 25, 1191, 'Graduate Teaching Assistants'); INSERT INTO `soc_codes` VALUES (375, 25, 1192, 'Home Economics Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (376, 25, 1193, 'Recreation and Fitness Studies Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (377, 25, 1194, 'Vocational Education Teachers, Postsecondary'); INSERT INTO `soc_codes` VALUES (378, 25, 1199, 'Postsecondary Teachers, All Other'); INSERT INTO `soc_codes` VALUES (379, 25, 2000, 'Primary, Secondary, and Special Education School Teachers'); INSERT INTO `soc_codes` VALUES (380, 25, 2010, 'Preschool and Kindergarten Teachers'); INSERT INTO `soc_codes` VALUES (381, 25, 2011, 'Preschool Teachers, Except Special Education'); INSERT INTO `soc_codes` VALUES (382, 25, 2012, 'Kindergarten Teachers, Except Special Education'); INSERT INTO `soc_codes` VALUES (383, 25, 2020, 'Elementary and Middle School Teachers'); INSERT INTO `soc_codes` VALUES (384, 25, 2021, 'Elementary School Teachers, Except Special Education'); INSERT INTO `soc_codes` VALUES (385, 25, 2022, 'Middle School Teachers, Except Special and Vocational Education'); INSERT INTO `soc_codes` VALUES (386, 25, 2023, 'Vocational Education Teachers, Middle School'); INSERT INTO `soc_codes` VALUES (387, 25, 2030, 'Secondary School Teachers'); INSERT INTO `soc_codes` VALUES (388, 25, 2031, 'Secondary School Teachers, Except Special and Vocational Education'); INSERT INTO `soc_codes` VALUES (389, 25, 2032, 'Vocational Education Teachers, Secondary School'); INSERT INTO `soc_codes` VALUES (390, 25, 2040, 'Special Education Teachers'); INSERT INTO `soc_codes` VALUES (391, 25, 2041, 'Special Education Teachers, Preschool, Kindergarten, and Elementary School'); INSERT INTO `soc_codes` VALUES (392, 25, 2042, 'Special Education Teachers, Middle School'); INSERT INTO `soc_codes` VALUES (393, 25, 2043, 'Special Education Teachers, Secondary School'); INSERT INTO `soc_codes` VALUES (394, 25, 3000, 'Other Teachers and Instructors'); INSERT INTO `soc_codes` VALUES (395, 25, 3010, 'Adult Literacy, Remedial Education, and GED Teachers and Instructors'); INSERT INTO `soc_codes` VALUES (396, 25, 3011, 'Adult Literacy, Remedial Education, and GED Teachers and Instructors'); INSERT INTO `soc_codes` VALUES (397, 25, 3020, 'Self-Enrichment Education Teachers'); INSERT INTO `soc_codes` VALUES (398, 25, 3021, 'Self-Enrichment Education Teachers'); INSERT INTO `soc_codes` VALUES (399, 25, 3090, 'Miscellaneous Teachers and Instructors'); INSERT INTO `soc_codes` VALUES (400, 25, 3099, 'Teachers and Instructors, All Other'); INSERT INTO `soc_codes` VALUES (401, 25, 4000, 'Librarians, Curators, and Archivists'); INSERT INTO `soc_codes` VALUES (402, 25, 4010, 'Archivists, Curators, and Museum Technicians'); INSERT INTO `soc_codes` VALUES (403, 25, 4011, 'Archivists'); INSERT INTO `soc_codes` VALUES (404, 25, 4012, 'Curators'); INSERT INTO `soc_codes` VALUES (405, 25, 4013, 'Museum Technicians and Conservators'); INSERT INTO `soc_codes` VALUES (406, 25, 4020, 'Librarians'); INSERT INTO `soc_codes` VALUES (407, 25, 4021, 'Librarians'); INSERT INTO `soc_codes` VALUES (408, 25, 4030, 'Library Technicians'); INSERT INTO `soc_codes` VALUES (409, 25, 4031, 'Library Technicians'); INSERT INTO `soc_codes` VALUES (410, 25, 9000, 'Other Education, Training, and Library Occupations'); INSERT INTO `soc_codes` VALUES (411, 25, 9010, 'Audio-Visual Collections Specialists'); INSERT INTO `soc_codes` VALUES (412, 25, 9011, 'Audio-Visual Collections Specialists'); INSERT INTO `soc_codes` VALUES (413, 25, 9020, 'Farm and Home Management Advisors'); INSERT INTO `soc_codes` VALUES (414, 25, 9021, 'Farm and Home Management Advisors'); INSERT INTO `soc_codes` VALUES (415, 25, 9030, 'Instructional Coordinators'); INSERT INTO `soc_codes` VALUES (416, 25, 9031, 'Instructional Coordinators'); INSERT INTO `soc_codes` VALUES (417, 25, 9040, 'Teacher Assistants'); INSERT INTO `soc_codes` VALUES (418, 25, 9041, 'Teacher Assistants'); INSERT INTO `soc_codes` VALUES (419, 25, 9090, 'Miscellaneous Education, Training, and Library Workers'); INSERT INTO `soc_codes` VALUES (420, 25, 9099, 'Education, Training, and Library Workers, All Other'); INSERT INTO `soc_codes` VALUES (421, 27, 0, 'Arts, Design, Entertainment, Sports, and Media Occupations'); INSERT INTO `soc_codes` VALUES (422, 27, 1000, 'Art and Design Workers'); INSERT INTO `soc_codes` VALUES (423, 27, 1010, 'Artists and Related Workers'); INSERT INTO `soc_codes` VALUES (424, 27, 1011, 'Art Directors'); INSERT INTO `soc_codes` VALUES (425, 27, 1012, 'Craft Artists'); INSERT INTO `soc_codes` VALUES (426, 27, 1013, 'Fine Artists, Including Painters, Sculptors, and Illustrators'); INSERT INTO `soc_codes` VALUES (427, 27, 1014, 'Multi-Media Artists and Animators'); INSERT INTO `soc_codes` VALUES (428, 27, 1019, 'Artists and Related Workers, All Other'); INSERT INTO `soc_codes` VALUES (429, 27, 1020, 'Designers'); INSERT INTO `soc_codes` VALUES (430, 27, 1021, 'Commercial and Industrial Designers'); INSERT INTO `soc_codes` VALUES (431, 27, 1022, 'Fashion Designers'); INSERT INTO `soc_codes` VALUES (432, 27, 1023, 'Floral Designers'); INSERT INTO `soc_codes` VALUES (433, 27, 1024, 'Graphic Designers'); INSERT INTO `soc_codes` VALUES (434, 27, 1025, 'Interior Designers'); INSERT INTO `soc_codes` VALUES (435, 27, 1026, 'Merchandise Displayers and Window Trimmers'); INSERT INTO `soc_codes` VALUES (436, 27, 1027, 'Set and Exhibit Designers'); INSERT INTO `soc_codes` VALUES (437, 27, 1029, 'Designers, All Other'); INSERT INTO `soc_codes` VALUES (438, 27, 2000, 'Entertainers and Performers, Sports and Related Workers'); INSERT INTO `soc_codes` VALUES (439, 27, 2010, 'Actors, Producers, and Directors'); INSERT INTO `soc_codes` VALUES (440, 27, 2011, 'Actors'); INSERT INTO `soc_codes` VALUES (441, 27, 2012, 'Producers and Directors'); INSERT INTO `soc_codes` VALUES (442, 27, 2020, 'Athletes, Coaches, Umpires, and Related Workers'); INSERT INTO `soc_codes` VALUES (443, 27, 2021, 'Athletes and Sports Competitors'); INSERT INTO `soc_codes` VALUES (444, 27, 2022, 'Coaches and Scouts'); INSERT INTO `soc_codes` VALUES (445, 27, 2023, 'Umpires, Referees, and Other Sports Officials'); INSERT INTO `soc_codes` VALUES (446, 27, 2030, 'Dancers and Choreographers'); INSERT INTO `soc_codes` VALUES (447, 27, 2031, 'Dancers'); INSERT INTO `soc_codes` VALUES (448, 27, 2032, 'Choreographers'); INSERT INTO `soc_codes` VALUES (449, 27, 2040, 'Musicians, Singers, and Related Workers'); INSERT INTO `soc_codes` VALUES (450, 27, 2041, 'Music Directors and Composers'); INSERT INTO `soc_codes` VALUES (451, 27, 2042, 'Musicians and Singers'); INSERT INTO `soc_codes` VALUES (452, 27, 2090, 'Miscellaneous Entertainers and Performers, Sports and Related Workers'); INSERT INTO `soc_codes` VALUES (453, 27, 2099, 'Entertainers and Performers, Sports and Related Workers, All Other'); INSERT INTO `soc_codes` VALUES (454, 27, 3000, 'Media and Communication Workers'); INSERT INTO `soc_codes` VALUES (455, 27, 3010, 'Anouncers'); INSERT INTO `soc_codes` VALUES (456, 27, 3011, 'Radio and Television Anouncers'); INSERT INTO `soc_codes` VALUES (457, 27, 3012, 'Public Address System and Other Anouncers'); INSERT INTO `soc_codes` VALUES (458, 27, 3020, 'News Analysts, Reporters and Correspondents'); INSERT INTO `soc_codes` VALUES (459, 27, 3021, 'Broadcast News Analysts'); INSERT INTO `soc_codes` VALUES (460, 27, 3022, 'Reporters and Correspondents'); INSERT INTO `soc_codes` VALUES (461, 27, 3030, 'Public Relations Specialists'); INSERT INTO `soc_codes` VALUES (462, 27, 3031, 'Public Relations Specialists'); INSERT INTO `soc_codes` VALUES (463, 27, 3040, 'Writers and Editors'); INSERT INTO `soc_codes` VALUES (464, 27, 3041, 'Editors'); INSERT INTO `soc_codes` VALUES (465, 27, 3042, 'Technical Writers'); INSERT INTO `soc_codes` VALUES (466, 27, 3043, 'Writers and Authors'); INSERT INTO `soc_codes` VALUES (467, 27, 3090, 'Miscellaneous Media and Communication Workers'); INSERT INTO `soc_codes` VALUES (468, 27, 3091, 'Interpreters and Translators'); INSERT INTO `soc_codes` VALUES (469, 27, 3099, 'Media and Communication Workers, All Other'); INSERT INTO `soc_codes` VALUES (470, 27, 4000, 'Media and Communication Equipment Workers'); INSERT INTO `soc_codes` VALUES (471, 27, 4010, 'Broadcast and Sound Engineering Technicians and Radio Operators'); INSERT INTO `soc_codes` VALUES (472, 27, 4011, 'Audio and Video Equipment Technicians'); INSERT INTO `soc_codes` VALUES (473, 27, 4012, 'Broadcast Technicians'); INSERT INTO `soc_codes` VALUES (474, 27, 4013, 'Radio Operators'); INSERT INTO `soc_codes` VALUES (475, 27, 4014, 'Sound Engineering Technicians'); INSERT INTO `soc_codes` VALUES (476, 27, 4020, 'Photographers'); INSERT INTO `soc_codes` VALUES (477, 27, 4021, 'Photographers'); INSERT INTO `soc_codes` VALUES (478, 27, 4030, 'Television, Video, and Motion Picture Camera Operators and Editors'); INSERT INTO `soc_codes` VALUES (479, 27, 4031, 'Camera Operators, Television, Video, and Motion Picture'); INSERT INTO `soc_codes` VALUES (480, 27, 4032, 'Film and Video Editors'); INSERT INTO `soc_codes` VALUES (481, 27, 4090, 'Miscellaneous Media and Communication Equipment Workers'); INSERT INTO `soc_codes` VALUES (482, 27, 4099, 'Media and Communication Equipment Workers, All Other'); INSERT INTO `soc_codes` VALUES (483, 29, 0, 'Healthcare Practitioners and Technical Occupations'); INSERT INTO `soc_codes` VALUES (484, 29, 1000, 'Health Diagnosing and Treating Practitioners'); INSERT INTO `soc_codes` VALUES (485, 29, 1010, 'Chiropractors'); INSERT INTO `soc_codes` VALUES (486, 29, 1011, 'Chiropractors'); INSERT INTO `soc_codes` VALUES (487, 29, 1020, 'Dentists'); INSERT INTO `soc_codes` VALUES (488, 29, 1021, 'Dentists, General'); INSERT INTO `soc_codes` VALUES (489, 29, 1022, 'Oral and Maxillofacial Surgeons'); INSERT INTO `soc_codes` VALUES (490, 29, 1023, 'Orthodontists'); INSERT INTO `soc_codes` VALUES (491, 29, 1024, 'Prosthodontists'); INSERT INTO `soc_codes` VALUES (492, 29, 1029, 'Dentists, All Other Specialists'); INSERT INTO `soc_codes` VALUES (493, 29, 1030, 'Dietitians and Nutritionists'); INSERT INTO `soc_codes` VALUES (494, 29, 1031, 'Dietitians and Nutritionists'); INSERT INTO `soc_codes` VALUES (495, 29, 1040, 'Optometrists'); INSERT INTO `soc_codes` VALUES (496, 29, 1041, 'Optometrists'); INSERT INTO `soc_codes` VALUES (497, 29, 1050, 'Pharmacists'); INSERT INTO `soc_codes` VALUES (498, 29, 1051, 'Pharmacists'); INSERT INTO `soc_codes` VALUES (499, 29, 1060, 'Physicians and Surgeons'); INSERT INTO `soc_codes` VALUES (500, 29, 1061, 'Anesthesiologists'); INSERT INTO `soc_codes` VALUES (501, 29, 1062, 'Family and General Practitioners'); INSERT INTO `soc_codes` VALUES (502, 29, 1063, 'Internists, General'); INSERT INTO `soc_codes` VALUES (503, 29, 1064, 'Obstetricians and Gynecologists'); INSERT INTO `soc_codes` VALUES (504, 29, 1065, 'Pediatricians, General'); INSERT INTO `soc_codes` VALUES (505, 29, 1066, 'Psychiatrists'); INSERT INTO `soc_codes` VALUES (506, 29, 1067, 'Surgeons'); INSERT INTO `soc_codes` VALUES (507, 29, 1069, 'Physicians and Surgeons, All Other'); INSERT INTO `soc_codes` VALUES (508, 29, 1070, 'Physician Assistants'); INSERT INTO `soc_codes` VALUES (509, 29, 1071, 'Physician Assistants'); INSERT INTO `soc_codes` VALUES (510, 29, 1080, 'Podiatrists'); INSERT INTO `soc_codes` VALUES (511, 29, 1081, 'Podiatrists'); INSERT INTO `soc_codes` VALUES (512, 29, 1110, 'Registered Nurses'); INSERT INTO `soc_codes` VALUES (513, 29, 1111, 'Registered Nurses'); INSERT INTO `soc_codes` VALUES (514, 29, 1120, 'Therapists'); INSERT INTO `soc_codes` VALUES (515, 29, 1121, 'Audiologists'); INSERT INTO `soc_codes` VALUES (516, 29, 1122, 'Occupational Therapists'); INSERT INTO `soc_codes` VALUES (517, 29, 1123, 'Physical Therapists'); INSERT INTO `soc_codes` VALUES (518, 29, 1124, 'Radiation Therapists'); INSERT INTO `soc_codes` VALUES (519, 29, 1125, 'Recreational Therapists'); INSERT INTO `soc_codes` VALUES (520, 29, 1126, 'Respiratory Therapists'); INSERT INTO `soc_codes` VALUES (521, 29, 1127, 'Speech-Language Pathologists'); INSERT INTO `soc_codes` VALUES (522, 29, 1129, 'Therapists, All Other'); INSERT INTO `soc_codes` VALUES (523, 29, 1130, 'Veterinarians'); INSERT INTO `soc_codes` VALUES (524, 29, 1131, 'Veterinarians'); INSERT INTO `soc_codes` VALUES (525, 29, 1190, 'Miscellaneous Health Diagnosing and Treating Practitioners'); INSERT INTO `soc_codes` VALUES (526, 29, 1199, 'Health Diagnosing and Treating Practitioners, All Other'); INSERT INTO `soc_codes` VALUES (527, 29, 2000, 'Health Technologists and Technicians'); INSERT INTO `soc_codes` VALUES (528, 29, 2010, 'Clinical Laboratory Technologists and Technicians'); INSERT INTO `soc_codes` VALUES (529, 29, 2011, 'Medical and Clinical Laboratory Technologists'); INSERT INTO `soc_codes` VALUES (530, 29, 2012, 'Medical and Clinical Laboratory Technicians'); INSERT INTO `soc_codes` VALUES (531, 29, 2020, 'Dental Hygienists'); INSERT INTO `soc_codes` VALUES (532, 29, 2021, 'Dental Hygienists'); INSERT INTO `soc_codes` VALUES (533, 29, 2030, 'Diagnostic Related Technologists and Technicians'); INSERT INTO `soc_codes` VALUES (534, 29, 2031, 'Cardiovascular Technologists and Technicians'); INSERT INTO `soc_codes` VALUES (535, 29, 2032, 'Diagnostic Medical Sonographers'); INSERT INTO `soc_codes` VALUES (536, 29, 2033, 'Nuclear Medicine Technologists'); INSERT INTO `soc_codes` VALUES (537, 29, 2034, 'Radiologic Technologists and Technicians'); INSERT INTO `soc_codes` VALUES (538, 29, 2040, 'Emergency Medical Technicians and Paramedics'); INSERT INTO `soc_codes` VALUES (539, 29, 2041, 'Emergency Medical Technicians and Paramedics'); INSERT INTO `soc_codes` VALUES (540, 29, 2050, 'Health Diagnosing and Treating Practitioner Support Technicians'); INSERT INTO `soc_codes` VALUES (541, 29, 2051, 'Dietetic Technicians'); INSERT INTO `soc_codes` VALUES (542, 29, 2052, 'Pharmacy Technicians'); INSERT INTO `soc_codes` VALUES (543, 29, 2053, 'Psychiatric Technicians'); INSERT INTO `soc_codes` VALUES (544, 29, 2054, 'Respiratory Therapy Technicians'); INSERT INTO `soc_codes` VALUES (545, 29, 2055, 'Surgical Technologists'); INSERT INTO `soc_codes` VALUES (546, 29, 2056, 'Veterinary Technologists and Technicians'); INSERT INTO `soc_codes` VALUES (547, 29, 2060, 'Licensed Practical and Licensed Vocational Nurses'); INSERT INTO `soc_codes` VALUES (548, 29, 2061, 'Licensed Practical and Licensed Vocational Nurses'); INSERT INTO `soc_codes` VALUES (549, 29, 2070, 'Medical Records and Health Information Technicians'); INSERT INTO `soc_codes` VALUES (550, 29, 2071, 'Medical Records and Health Information Technicians'); INSERT INTO `soc_codes` VALUES (551, 29, 2080, 'Opticians, Dispensing'); INSERT INTO `soc_codes` VALUES (552, 29, 2081, 'Opticians, Dispensing'); INSERT INTO `soc_codes` VALUES (553, 29, 2090, 'Miscellaneous Health Technologists and Technicians'); INSERT INTO `soc_codes` VALUES (554, 29, 2091, 'Orthotists and Prosthetists'); INSERT INTO `soc_codes` VALUES (555, 29, 2099, 'Health Technologists and Technicians, All Other'); INSERT INTO `soc_codes` VALUES (556, 29, 9000, 'Other Healthcare Practitioners and Technical Occupations'); INSERT INTO `soc_codes` VALUES (557, 29, 9010, 'Occupational Health and Safety Specialists and Technicians'); INSERT INTO `soc_codes` VALUES (558, 29, 9011, 'Occupational Health and Safety Specialists'); INSERT INTO `soc_codes` VALUES (559, 29, 9012, 'Occupational Health and Safety Technicians'); INSERT INTO `soc_codes` VALUES (560, 29, 9090, 'Miscellaneous Health Practitioners and Technical Workers'); INSERT INTO `soc_codes` VALUES (561, 29, 9091, 'Athletic Trainers'); INSERT INTO `soc_codes` VALUES (562, 29, 9099, 'Healthcare Practitioners and Technical Workers, All Other'); INSERT INTO `soc_codes` VALUES (563, 31, 0, 'Healthcare Support Occupations'); INSERT INTO `soc_codes` VALUES (564, 31, 1000, 'Nursing, Psychiatric, and Home Health Aides'); INSERT INTO `soc_codes` VALUES (565, 31, 1010, 'Nursing, Psychiatric, and Home Health Aides'); INSERT INTO `soc_codes` VALUES (566, 31, 1011, 'Home Health Aides'); INSERT INTO `soc_codes` VALUES (567, 31, 1012, 'Nursing Aides, Orderlies, and Attendants'); INSERT INTO `soc_codes` VALUES (568, 31, 1013, 'Psychiatric Aides'); INSERT INTO `soc_codes` VALUES (569, 31, 2000, 'Occupational and Physical Therapist Assistants and Aides'); INSERT INTO `soc_codes` VALUES (570, 31, 2010, 'Occupational Therapist Assistants and Aides'); INSERT INTO `soc_codes` VALUES (571, 31, 2011, 'Occupational Therapist Assistants'); INSERT INTO `soc_codes` VALUES (572, 31, 2012, 'Occupational Therapist Aides'); INSERT INTO `soc_codes` VALUES (573, 31, 2020, 'Physical Therapist Assistants and Aides'); INSERT INTO `soc_codes` VALUES (574, 31, 2021, 'Physical Therapist Assistants'); INSERT INTO `soc_codes` VALUES (575, 31, 2022, 'Physical Therapist Aides'); INSERT INTO `soc_codes` VALUES (576, 31, 9000, 'Other Healthcare Support Occupations'); INSERT INTO `soc_codes` VALUES (577, 31, 9010, 'Massage Therapists'); INSERT INTO `soc_codes` VALUES (578, 31, 9011, 'Massage Therapists'); INSERT INTO `soc_codes` VALUES (579, 31, 9090, 'Miscellaneous Healthcare Support Occupations'); INSERT INTO `soc_codes` VALUES (580, 31, 9091, 'Dental Assistants'); INSERT INTO `soc_codes` VALUES (581, 31, 9092, 'Medical Assistants'); INSERT INTO `soc_codes` VALUES (582, 31, 9093, 'Medical Equipment Preparers'); INSERT INTO `soc_codes` VALUES (583, 31, 9094, 'Medical Transcriptionists'); INSERT INTO `soc_codes` VALUES (584, 31, 9095, 'Pharmacy Aides'); INSERT INTO `soc_codes` VALUES (585, 31, 9096, 'Veterinary Assistants and Laboratory Animal Caretakers'); INSERT INTO `soc_codes` VALUES (586, 31, 9099, 'Healthcare Support Workers, All Other'); INSERT INTO `soc_codes` VALUES (587, 33, 0, 'Protective Service Occupations'); INSERT INTO `soc_codes` VALUES (588, 33, 1000, 'First-Line Supervisors/Managers, Protective Service Workers'); INSERT INTO `soc_codes` VALUES (589, 33, 1010, 'First-Line Supervisors/Managers, Law Enforcement Workers'); INSERT INTO `soc_codes` VALUES (590, 33, 1011, 'First-Line Supervisors/Managers of Correctional Officers'); INSERT INTO `soc_codes` VALUES (591, 33, 1012, 'First-Line Supervisors/Managers of Police and Detectives'); INSERT INTO `soc_codes` VALUES (592, 33, 1020, 'First-Line Supervisors/Managers, Fire Fighting and Prevention Workers'); INSERT INTO `soc_codes` VALUES (593, 33, 1021, 'First-Line Supervisors/Managers of Fire Fighting and Prevention Workers'); INSERT INTO `soc_codes` VALUES (594, 33, 1090, 'Miscellaneous First-Line Supervisors/Managers, Protective Service Workers'); INSERT INTO `soc_codes` VALUES (595, 33, 1099, 'First-Line Supervisors/Managers, Protective Service Workers, All Other'); INSERT INTO `soc_codes` VALUES (596, 33, 2000, 'Fire Fighting and Prevention Workers'); INSERT INTO `soc_codes` VALUES (597, 33, 2010, 'Fire Fighters'); INSERT INTO `soc_codes` VALUES (598, 33, 2011, 'Fire Fighters'); INSERT INTO `soc_codes` VALUES (599, 33, 2020, 'Fire Inspectors'); INSERT INTO `soc_codes` VALUES (600, 33, 2021, 'Fire Inspectors and Investigators'); INSERT INTO `soc_codes` VALUES (601, 33, 2022, 'Forest Fire Inspectors and Prevention Specialists'); INSERT INTO `soc_codes` VALUES (602, 33, 3000, 'Law Enforcement Workers'); INSERT INTO `soc_codes` VALUES (603, 33, 3010, 'Bailiffs, Correctional Officers, and Jailers'); INSERT INTO `soc_codes` VALUES (604, 33, 3011, 'Bailiffs'); INSERT INTO `soc_codes` VALUES (605, 33, 3012, 'Correctional Officers and Jailers'); INSERT INTO `soc_codes` VALUES (606, 33, 3020, 'Detectives and Criminal Investigators'); INSERT INTO `soc_codes` VALUES (607, 33, 3021, 'Detectives and Criminal Investigators'); INSERT INTO `soc_codes` VALUES (608, 33, 3030, 'Fish and Game Wardens'); INSERT INTO `soc_codes` VALUES (609, 33, 3031, 'Fish and Game Wardens'); INSERT INTO `soc_codes` VALUES (610, 33, 3040, 'Parking Enforcement Workers'); INSERT INTO `soc_codes` VALUES (611, 33, 3041, 'Parking Enforcement Workers'); INSERT INTO `soc_codes` VALUES (612, 33, 3050, 'Police Officers'); INSERT INTO `soc_codes` VALUES (613, 33, 3052, 'Transit and Railroad Police'); INSERT INTO `soc_codes` VALUES (614, 33, 9000, 'Other Protective Service Workers'); INSERT INTO `soc_codes` VALUES (615, 33, 9010, 'Animal Control Workers'); INSERT INTO `soc_codes` VALUES (616, 33, 9011, 'Animal Control Workers'); INSERT INTO `soc_codes` VALUES (617, 33, 9020, 'Private Detectives and Investigators'); INSERT INTO `soc_codes` VALUES (618, 33, 9021, 'Private Detectives and Investigators'); INSERT INTO `soc_codes` VALUES (619, 33, 9030, 'Security Guards and Gaming Surveillance Officers'); INSERT INTO `soc_codes` VALUES (620, 33, 9031, 'Gaming Surveillance Officers and Gaming Investigators'); INSERT INTO `soc_codes` VALUES (621, 33, 9032, 'Security Guards'); INSERT INTO `soc_codes` VALUES (622, 33, 9090, 'Miscellaneous Protective Service Workers'); INSERT INTO `soc_codes` VALUES (623, 33, 9091, 'Crossing Guards'); INSERT INTO `soc_codes` VALUES (624, 33, 9092, 'Lifeguards, Ski Patrol, and Other Recreational Protective Service Workers'); INSERT INTO `soc_codes` VALUES (625, 33, 9099, 'Protective Service Workers, All Other'); INSERT INTO `soc_codes` VALUES (626, 35, 0, 'Food Preparation and Serving Related Occupations'); INSERT INTO `soc_codes` VALUES (627, 35, 1000, 'Supervisors, Food Preparation and Serving Workers'); INSERT INTO `soc_codes` VALUES (628, 35, 1010, 'First-Line Supervisors/Managers, Food Preparation and Serving Workers'); INSERT INTO `soc_codes` VALUES (629, 35, 1011, 'Chefs and Head Cooks'); INSERT INTO `soc_codes` VALUES (630, 35, 1012, 'First-Line Supervisors/Managers of Food Preparation and Serving Workers'); INSERT INTO `soc_codes` VALUES (631, 35, 2000, 'Cooks and Food Preparation Workers'); INSERT INTO `soc_codes` VALUES (632, 35, 2010, 'Cooks'); INSERT INTO `soc_codes` VALUES (633, 35, 2011, 'Cooks, Fast Food'); INSERT INTO `soc_codes` VALUES (634, 35, 2012, 'Cooks, Institution and Cafeteria'); INSERT INTO `soc_codes` VALUES (635, 35, 2013, 'Cooks, Private Household'); INSERT INTO `soc_codes` VALUES (636, 35, 2014, 'Cooks, Restaurant'); INSERT INTO `soc_codes` VALUES (637, 35, 2015, 'Cooks, Short Order'); INSERT INTO `soc_codes` VALUES (638, 35, 2019, 'Cooks, All Other'); INSERT INTO `soc_codes` VALUES (639, 35, 2020, 'Food Preparation Workers'); INSERT INTO `soc_codes` VALUES (640, 35, 2021, 'Food Preparation Workers'); INSERT INTO `soc_codes` VALUES (641, 35, 3000, 'Food and Beverage Serving Workers'); INSERT INTO `soc_codes` VALUES (642, 35, 3010, 'Bartenders'); INSERT INTO `soc_codes` VALUES (643, 35, 3011, 'Bartenders'); INSERT INTO `soc_codes` VALUES (644, 35, 3020, 'Fast Food and Counter Workers'); INSERT INTO `soc_codes` VALUES (645, 35, 3021, 'Combined Food Preparation and Serving Workers, Including Fast Food'); INSERT INTO `soc_codes` VALUES (646, 35, 3022, 'Counter Attendants, Cafeteria, Food Concession, and Coffee Shop'); INSERT INTO `soc_codes` VALUES (647, 35, 3030, 'Waiters and Waitresses'); INSERT INTO `soc_codes` VALUES (648, 35, 3031, 'Waiters and Waitresses'); INSERT INTO `soc_codes` VALUES (649, 35, 3040, 'Food Servers, Nonrestaurant'); INSERT INTO `soc_codes` VALUES (650, 35, 3041, 'Food Servers, Nonrestaurant'); INSERT INTO `soc_codes` VALUES (651, 35, 9000, 'Other Food Preparation and Serving Related Workers'); INSERT INTO `soc_codes` VALUES (652, 35, 9010, 'Dining Room and Cafeteria Attendants and Bartender Helpers'); INSERT INTO `soc_codes` VALUES (653, 35, 9011, 'Dining Room and Cafeteria Attendants and Bartender Helpers'); INSERT INTO `soc_codes` VALUES (654, 35, 9020, 'Dishwashers'); INSERT INTO `soc_codes` VALUES (655, 35, 9021, 'Dishwashers'); INSERT INTO `soc_codes` VALUES (656, 35, 9030, 'Hosts and Hostesses, Restaurant, Lounge, and Coffee Shop'); INSERT INTO `soc_codes` VALUES (657, 35, 9031, 'Hosts and Hostesses, Restaurant, Lounge, and Coffee Shop'); INSERT INTO `soc_codes` VALUES (658, 35, 9090, 'Miscellaneous Food Preparation and Serving Related Workers'); INSERT INTO `soc_codes` VALUES (659, 35, 9099, 'Food Preparation and Serving Related Workers, All Other'); INSERT INTO `soc_codes` VALUES (660, 37, 0, 'Building and Grounds Cleaning and Maintenance Occupations'); INSERT INTO `soc_codes` VALUES (661, 37, 1000, 'Supervisors, Building and Grounds Cleaning and Maintenance Workers'); INSERT INTO `soc_codes` VALUES (662, 37, 1010, 'First-Line Supervisors/Managers, Building and Grounds Cleaning and Maintenance Workers'); INSERT INTO `soc_codes` VALUES (663, 37, 1011, 'First-Line Supervisors/Managers of Housekeeping and Janitorial Workers'); INSERT INTO `soc_codes` VALUES (664, 37, 1012, 'First-Line Supervisors/Managers of Landscaping, Lawn Service, and Groundskeeping Workers'); INSERT INTO `soc_codes` VALUES (665, 37, 2000, 'Building Cleaning and Pest Control Workers'); INSERT INTO `soc_codes` VALUES (666, 37, 2010, 'Building Cleaning Workers'); INSERT INTO `soc_codes` VALUES (667, 37, 2011, 'Janitors and Cleaners, Except Maids and Housekeeping Cleaners'); INSERT INTO `soc_codes` VALUES (668, 37, 2012, 'Maids and Housekeeping Cleaners'); INSERT INTO `soc_codes` VALUES (669, 37, 2019, 'Building Cleaning Workers, All Other'); INSERT INTO `soc_codes` VALUES (670, 37, 2020, 'Pest Control Workers'); INSERT INTO `soc_codes` VALUES (671, 37, 2021, 'Pest Control Workers'); INSERT INTO `soc_codes` VALUES (672, 37, 3000, 'Grounds Maintenance Workers'); INSERT INTO `soc_codes` VALUES (673, 37, 3010, 'Grounds Maintenance Workers'); INSERT INTO `soc_codes` VALUES (674, 37, 3011, 'Landscaping and Groundskeeping Workers'); INSERT INTO `soc_codes` VALUES (675, 37, 3012, 'Pesticide Handlers, Sprayers, and Applicators, Vegetation'); INSERT INTO `soc_codes` VALUES (676, 37, 3013, 'Tree Trimmers and Pruners'); INSERT INTO `soc_codes` VALUES (677, 37, 3019, 'Grounds Maintenance Workers, All Other'); INSERT INTO `soc_codes` VALUES (678, 39, 0, 'Personal Care and Service Occupations'); INSERT INTO `soc_codes` VALUES (679, 39, 1000, 'Supervisors, Personal Care and Service Workers'); INSERT INTO `soc_codes` VALUES (680, 39, 1010, 'First-Line Supervisors/Managers of Gaming Workers'); INSERT INTO `soc_codes` VALUES (681, 39, 1011, 'Gaming Supervisors'); INSERT INTO `soc_codes` VALUES (682, 39, 1012, 'Slot Key Persons'); INSERT INTO `soc_codes` VALUES (683, 39, 1020, 'First-Line Supervisors/Managers of Personal Service Workers'); INSERT INTO `soc_codes` VALUES (684, 39, 1021, 'First-Line Supervisors/Managers of Personal Service Workers'); INSERT INTO `soc_codes` VALUES (685, 39, 2000, 'Animal Care and Service Workers'); INSERT INTO `soc_codes` VALUES (686, 39, 2010, 'Animal Trainers'); INSERT INTO `soc_codes` VALUES (687, 39, 2011, 'Animal Trainers'); INSERT INTO `soc_codes` VALUES (688, 39, 2020, 'Nonfarm Animal Caretakers'); INSERT INTO `soc_codes` VALUES (689, 39, 2021, 'Nonfarm Animal Caretakers'); INSERT INTO `soc_codes` VALUES (690, 39, 3000, 'Entertainment Attendants and Related Workers'); INSERT INTO `soc_codes` VALUES (691, 39, 3010, 'Gaming Services Workers'); INSERT INTO `soc_codes` VALUES (692, 39, 3011, 'Gaming Dealers'); INSERT INTO `soc_codes` VALUES (693, 39, 3012, 'Gaming and Sports Book Writers and Runers'); INSERT INTO `soc_codes` VALUES (694, 39, 3019, 'Gaming Service Workers, All Other'); INSERT INTO `soc_codes` VALUES (695, 39, 3020, 'Motion Picture Projectionists'); INSERT INTO `soc_codes` VALUES (696, 39, 3021, 'Motion Picture Projectionists'); INSERT INTO `soc_codes` VALUES (697, 39, 3030, 'Ushers, Lobby Attendants, and Ticket Takers'); INSERT INTO `soc_codes` VALUES (698, 39, 3031, 'Ushers, Lobby Attendants, and Ticket Takers'); INSERT INTO `soc_codes` VALUES (699, 39, 3090, 'Miscellaneous Entertainment Attendants and Related Workers'); INSERT INTO `soc_codes` VALUES (700, 39, 3091, 'Amusement and Recreation Attendants'); INSERT INTO `soc_codes` VALUES (701, 39, 3092, 'Costume Attendants'); INSERT INTO `soc_codes` VALUES (702, 39, 3093, 'Locker Room, Coatroom, and Dressing Room Attendants'); INSERT INTO `soc_codes` VALUES (703, 39, 3099, 'Entertainment Attendants and Related Workers, All Other'); INSERT INTO `soc_codes` VALUES (704, 39, 4000, 'Funeral Service Workers'); INSERT INTO `soc_codes` VALUES (705, 39, 4010, 'Embalmers'); INSERT INTO `soc_codes` VALUES (706, 39, 4011, 'Embalmers'); INSERT INTO `soc_codes` VALUES (707, 39, 4020, 'Funeral Attendants'); INSERT INTO `soc_codes` VALUES (708, 39, 4021, 'Funeral Attendants'); INSERT INTO `soc_codes` VALUES (709, 39, 5000, 'Personal Appearance Workers'); INSERT INTO `soc_codes` VALUES (710, 39, 5010, 'Barbers and Cosmetologists'); INSERT INTO `soc_codes` VALUES (711, 39, 5011, 'Barbers'); INSERT INTO `soc_codes` VALUES (712, 39, 5012, 'Hairdressers, Hairstylists, and Cosmetologists'); INSERT INTO `soc_codes` VALUES (713, 39, 5090, 'Miscellaneous Personal Appearance Workers'); INSERT INTO `soc_codes` VALUES (714, 39, 5091, 'Makeup Artists, Theatrical and Performance'); INSERT INTO `soc_codes` VALUES (715, 39, 5092, 'Manicurists and Pedicurists'); INSERT INTO `soc_codes` VALUES (716, 39, 5093, 'Shampooers'); INSERT INTO `soc_codes` VALUES (717, 39, 5094, 'Skin Care Specialists'); INSERT INTO `soc_codes` VALUES (718, 39, 6000, 'Transportation, Tourism, and Lodging Attendants'); INSERT INTO `soc_codes` VALUES (719, 39, 6010, 'Baggage Porters, Bellhops, and Concierges'); INSERT INTO `soc_codes` VALUES (720, 39, 6011, 'Baggage Porters and Bellhops'); INSERT INTO `soc_codes` VALUES (721, 39, 6012, 'Concierges'); INSERT INTO `soc_codes` VALUES (722, 39, 6020, 'Tour and Travel Guides'); INSERT INTO `soc_codes` VALUES (723, 39, 6021, 'Tour Guides and Escorts'); INSERT INTO `soc_codes` VALUES (724, 39, 6022, 'Travel Guides'); INSERT INTO `soc_codes` VALUES (725, 39, 6030, 'Transportation Attendants'); INSERT INTO `soc_codes` VALUES (726, 39, 6031, 'Flight Attendants'); INSERT INTO `soc_codes` VALUES (727, 39, 6032, 'Transportation Attendants, Except Flight Attendants and Baggage Porters'); INSERT INTO `soc_codes` VALUES (728, 39, 9000, 'Other Personal Care and Service Workers'); INSERT INTO `soc_codes` VALUES (729, 39, 9010, 'Child Care Workers'); INSERT INTO `soc_codes` VALUES (730, 39, 9011, 'Child Care Workers'); INSERT INTO `soc_codes` VALUES (731, 39, 9020, 'Personal and Home Care Aides'); INSERT INTO `soc_codes` VALUES (732, 39, 9021, 'Personal and Home Care Aides'); INSERT INTO `soc_codes` VALUES (733, 39, 9030, 'Recreation and Fitness Workers'); INSERT INTO `soc_codes` VALUES (734, 39, 9031, 'Fitness Trainers and Aerobics Instructors'); INSERT INTO `soc_codes` VALUES (735, 39, 9032, 'Recreation Workers'); INSERT INTO `soc_codes` VALUES (736, 39, 9040, 'Residential Advisors'); INSERT INTO `soc_codes` VALUES (737, 39, 9041, 'Residential Advisors'); INSERT INTO `soc_codes` VALUES (738, 39, 9090, 'Miscellaneous Personal Care and Service Workers'); INSERT INTO `soc_codes` VALUES (739, 39, 9099, 'Personal Care and Service Workers, All Other'); INSERT INTO `soc_codes` VALUES (740, 41, 0, 'Sales and Related Occupations'); INSERT INTO `soc_codes` VALUES (741, 41, 1000, 'Supervisors, Sales Workers'); INSERT INTO `soc_codes` VALUES (742, 41, 1010, 'First-Line Supervisors/Managers, Sales Workers'); INSERT INTO `soc_codes` VALUES (743, 41, 1011, 'First-Line Supervisors/Managers of Retail Sales Workers'); INSERT INTO `soc_codes` VALUES (744, 41, 1012, 'First-Line Supervisors/Managers of Non-Retail Sales Workers'); INSERT INTO `soc_codes` VALUES (745, 41, 2000, 'Retail Sales Workers'); INSERT INTO `soc_codes` VALUES (746, 41, 2010, 'Cashiers'); INSERT INTO `soc_codes` VALUES (747, 41, 2011, 'Cashiers'); INSERT INTO `soc_codes` VALUES (748, 41, 2012, 'Gaming Change Persons and Booth Cashiers'); INSERT INTO `soc_codes` VALUES (749, 41, 2020, 'Counter and Rental Clerks and Parts Salespersons'); INSERT INTO `soc_codes` VALUES (750, 41, 2021, 'Counter and Rental Clerks'); INSERT INTO `soc_codes` VALUES (751, 41, 2022, 'Parts Salespersons'); INSERT INTO `soc_codes` VALUES (752, 41, 2030, 'Retail Salespersons'); INSERT INTO `soc_codes` VALUES (753, 41, 2031, 'Retail Salespersons'); INSERT INTO `soc_codes` VALUES (754, 41, 3000, 'Sales Representatives, Services'); INSERT INTO `soc_codes` VALUES (755, 41, 3010, 'Advertising Sales Agents'); INSERT INTO `soc_codes` VALUES (756, 41, 3011, 'Advertising Sales Agents'); INSERT INTO `soc_codes` VALUES (757, 41, 3020, 'Insurance Sales Agents'); INSERT INTO `soc_codes` VALUES (758, 41, 3021, 'Insurance Sales Agents'); INSERT INTO `soc_codes` VALUES (759, 41, 3030, 'Securities, Commodities, and Financial Services Sales Agents'); INSERT INTO `soc_codes` VALUES (760, 41, 3031, 'Securities, Commodities, and Financial Services Sales Agents'); INSERT INTO `soc_codes` VALUES (761, 41, 3040, 'Travel Agents'); INSERT INTO `soc_codes` VALUES (762, 41, 3041, 'Travel Agents'); INSERT INTO `soc_codes` VALUES (763, 41, 3090, 'Miscellaneous Sales Representatives, Services'); INSERT INTO `soc_codes` VALUES (764, 41, 3099, 'Sales Representatives, Services, All Other'); INSERT INTO `soc_codes` VALUES (765, 41, 4000, 'Sales Representatives, Wholesale and Manufacturing'); INSERT INTO `soc_codes` VALUES (766, 41, 4010, 'Sales Representatives, Wholesale and Manufacturing'); INSERT INTO `soc_codes` VALUES (767, 41, 4011, 'Sales Representatives, Wholesale and Manufacturing, Technical and Scientific Products'); INSERT INTO `soc_codes` VALUES (768, 41, 4012, 'Sales Representatives, Wholesale and Manufacturing, Except Technical and Scientific Products'); INSERT INTO `soc_codes` VALUES (769, 41, 9000, 'Other Sales and Related Workers'); INSERT INTO `soc_codes` VALUES (770, 41, 9010, 'Models, Demonstrators, and Product Promoters'); INSERT INTO `soc_codes` VALUES (771, 41, 9011, 'Demonstrators and Product Promoters'); INSERT INTO `soc_codes` VALUES (772, 41, 9012, 'Models'); INSERT INTO `soc_codes` VALUES (773, 41, 9020, 'Real Estate Brokers and Sales Agents'); INSERT INTO `soc_codes` VALUES (774, 41, 9021, 'Real Estate Brokers'); INSERT INTO `soc_codes` VALUES (775, 41, 9022, 'Real Estate Sales Agents'); INSERT INTO `soc_codes` VALUES (776, 41, 9030, 'Sales Engineers'); INSERT INTO `soc_codes` VALUES (777, 41, 9031, 'Sales Engineers'); INSERT INTO `soc_codes` VALUES (778, 41, 9040, 'Telemarketers'); INSERT INTO `soc_codes` VALUES (779, 41, 9041, 'Telemarketers'); INSERT INTO `soc_codes` VALUES (780, 41, 9090, 'Miscellaneous Sales and Related Workers'); INSERT INTO `soc_codes` VALUES (781, 41, 9091, 'Door-To-Door Sales Workers, News and Street Vendors, and Related Workers'); INSERT INTO `soc_codes` VALUES (782, 41, 9099, 'Sales and Related Workers, All Other'); INSERT INTO `soc_codes` VALUES (783, 43, 0, 'Office and Administrative Support Occupations'); INSERT INTO `soc_codes` VALUES (784, 43, 1000, 'Supervisors, Office and Administrative Support Workers'); INSERT INTO `soc_codes` VALUES (785, 43, 1010, 'First-Line Supervisors/Managers of Office and Administrative Support Workers'); INSERT INTO `soc_codes` VALUES (786, 43, 1011, 'First-Line Supervisors/Managers of Office and Administrative Support Workers'); INSERT INTO `soc_codes` VALUES (787, 43, 2000, 'Communications Equipment Operators'); INSERT INTO `soc_codes` VALUES (788, 43, 2010, 'Switchboard Operators, Including Answering Service'); INSERT INTO `soc_codes` VALUES (789, 43, 2011, 'Switchboard Operators, Including Answering Service'); INSERT INTO `soc_codes` VALUES (790, 43, 2020, 'Telephone Operators'); INSERT INTO `soc_codes` VALUES (791, 43, 2021, 'Telephone Operators'); INSERT INTO `soc_codes` VALUES (792, 43, 2090, 'Miscellaneous Communications Equipment Operators'); INSERT INTO `soc_codes` VALUES (793, 43, 2099, 'Communications Equipment Operators, All Other'); INSERT INTO `soc_codes` VALUES (794, 43, 3000, 'Financial Clerks'); INSERT INTO `soc_codes` VALUES (795, 43, 3010, 'Bill and Account Collectors'); INSERT INTO `soc_codes` VALUES (796, 43, 3011, 'Bill and Account Collectors'); INSERT INTO `soc_codes` VALUES (797, 43, 3020, 'Billing and Posting Clerks and Machine Operators'); INSERT INTO `soc_codes` VALUES (798, 43, 3021, 'Billing and Posting Clerks and Machine Operators'); INSERT INTO `soc_codes` VALUES (799, 43, 3030, 'Bookkeeping, Accounting, and Auditing Clerks'); INSERT INTO `soc_codes` VALUES (800, 43, 3031, 'Bookkeeping, Accounting, and Auditing Clerks'); INSERT INTO `soc_codes` VALUES (801, 43, 3040, 'Gaming Cage Workers'); INSERT INTO `soc_codes` VALUES (802, 43, 3041, 'Gaming Cage Workers'); INSERT INTO `soc_codes` VALUES (803, 43, 3050, 'Payroll and Timekeeping Clerks'); INSERT INTO `soc_codes` VALUES (804, 43, 3051, 'Payroll and Timekeeping Clerks'); INSERT INTO `soc_codes` VALUES (805, 43, 3060, 'Procurement Clerks'); INSERT INTO `soc_codes` VALUES (806, 43, 3061, 'Procurement Clerks'); INSERT INTO `soc_codes` VALUES (807, 43, 3070, 'Tellers'); INSERT INTO `soc_codes` VALUES (808, 43, 3071, 'Tellers'); INSERT INTO `soc_codes` VALUES (809, 43, 4000, 'Information and Record Clerks'); INSERT INTO `soc_codes` VALUES (810, 43, 4010, 'Brokerage Clerks'); INSERT INTO `soc_codes` VALUES (811, 43, 4011, 'Brokerage Clerks'); INSERT INTO `soc_codes` VALUES (812, 43, 4020, 'Correspondence Clerks'); INSERT INTO `soc_codes` VALUES (813, 43, 4021, 'Correspondence Clerks'); INSERT INTO `soc_codes` VALUES (814, 43, 4030, 'Court, Municipal, and License Clerks'); INSERT INTO `soc_codes` VALUES (815, 43, 4031, 'Court, Municipal, and License Clerks'); INSERT INTO `soc_codes` VALUES (816, 43, 4040, 'Credit Authorizers, Checkers, and Clerks'); INSERT INTO `soc_codes` VALUES (817, 43, 4041, 'Credit Authorizers, Checkers, and Clerks'); INSERT INTO `soc_codes` VALUES (818, 43, 4050, 'Customer Service Representatives'); INSERT INTO `soc_codes` VALUES (819, 43, 4051, 'Customer Service Representatives'); INSERT INTO `soc_codes` VALUES (820, 43, 4060, 'Eligibility Interviewers, Government Programs'); INSERT INTO `soc_codes` VALUES (821, 43, 4061, 'Eligibility Interviewers, Government Programs'); INSERT INTO `soc_codes` VALUES (822, 43, 4070, 'File Clerks'); INSERT INTO `soc_codes` VALUES (823, 43, 4071, 'File Clerks'); INSERT INTO `soc_codes` VALUES (824, 43, 4080, 'Hotel, Motel, and Resort Desk Clerks'); INSERT INTO `soc_codes` VALUES (825, 43, 4081, 'Hotel, Motel, and Resort Desk Clerks'); INSERT INTO `soc_codes` VALUES (826, 43, 4110, 'Interviewers, Except Eligibility and Loan'); INSERT INTO `soc_codes` VALUES (827, 43, 4111, 'Interviewers, Except Eligibility and Loan'); INSERT INTO `soc_codes` VALUES (828, 43, 4120, 'Library Assistants, Clerical'); INSERT INTO `soc_codes` VALUES (829, 43, 4121, 'Library Assistants, Clerical'); INSERT INTO `soc_codes` VALUES (830, 43, 4130, 'Loan Interviewers and Clerks'); INSERT INTO `soc_codes` VALUES (831, 43, 4131, 'Loan Interviewers and Clerks'); INSERT INTO `soc_codes` VALUES (832, 43, 4140, 'New Accounts Clerks'); INSERT INTO `soc_codes` VALUES (833, 43, 4141, 'New Accounts Clerks'); INSERT INTO `soc_codes` VALUES (834, 43, 4150, 'Order Clerks'); INSERT INTO `soc_codes` VALUES (835, 43, 4151, 'Order Clerks'); INSERT INTO `soc_codes` VALUES (836, 43, 4160, 'Human Resources Assistants, Except Payroll and Timekeeping'); INSERT INTO `soc_codes` VALUES (837, 43, 4161, 'Human Resources Assistants, Except Payroll and Timekeeping'); INSERT INTO `soc_codes` VALUES (838, 43, 4170, 'Receptionists and Information Clerks'); INSERT INTO `soc_codes` VALUES (839, 43, 4171, 'Receptionists and Information Clerks'); INSERT INTO `soc_codes` VALUES (840, 43, 4180, 'Reservation and Transportation Ticket Agents and Travel Clerks'); INSERT INTO `soc_codes` VALUES (841, 43, 4181, 'Reservation and Transportation Ticket Agents and Travel Clerks'); INSERT INTO `soc_codes` VALUES (842, 43, 4190, 'Miscellaneous Information and Record Clerks'); INSERT INTO `soc_codes` VALUES (843, 43, 4199, 'Information and Record Clerks, All Other'); INSERT INTO `soc_codes` VALUES (844, 43, 5000, 'Material Recording, Scheduling, Dispatching, and Distributing Workers'); INSERT INTO `soc_codes` VALUES (845, 43, 5010, 'Cargo and Freight Agents'); INSERT INTO `soc_codes` VALUES (846, 43, 5011, 'Cargo and Freight Agents'); INSERT INTO `soc_codes` VALUES (847, 43, 5020, 'Couriers and Messengers'); INSERT INTO `soc_codes` VALUES (848, 43, 5021, 'Couriers and Messengers'); INSERT INTO `soc_codes` VALUES (849, 43, 5030, 'Dispatchers'); INSERT INTO `soc_codes` VALUES (850, 43, 5031, 'Police, Fire, and Ambulance Dispatchers'); INSERT INTO `soc_codes` VALUES (851, 43, 5032, 'Dispatchers, Except Police, Fire, and Ambulance'); INSERT INTO `soc_codes` VALUES (852, 43, 5040, 'Meter Readers, Utilities'); INSERT INTO `soc_codes` VALUES (853, 43, 5041, 'Meter Readers, Utilities'); INSERT INTO `soc_codes` VALUES (854, 43, 5050, 'Postal Service Workers'); INSERT INTO `soc_codes` VALUES (855, 43, 5051, 'Postal Service Clerks'); INSERT INTO `soc_codes` VALUES (856, 43, 5052, 'Postal Service Mail Carriers'); INSERT INTO `soc_codes` VALUES (857, 43, 5053, 'Postal Service Mail Sorters, Processors, and Processing Machine Operators'); INSERT INTO `soc_codes` VALUES (858, 43, 5060, 'Production, Planing, and Expediting Clerks'); INSERT INTO `soc_codes` VALUES (859, 43, 5061, 'Production, Planing, and Expediting Clerks'); INSERT INTO `soc_codes` VALUES (860, 43, 5070, 'Shipping, Receiving, and Traffic Clerks'); INSERT INTO `soc_codes` VALUES (861, 43, 5071, 'Shipping, Receiving, and Traffic Clerks'); INSERT INTO `soc_codes` VALUES (862, 43, 5080, 'Stock Clerks and Order Fillers'); INSERT INTO `soc_codes` VALUES (863, 43, 5081, 'Stock Clerks and Order Fillers'); INSERT INTO `soc_codes` VALUES (864, 43, 5110, 'Weighers, Measurers, Checkers, and Samplers, Recordkeeping'); INSERT INTO `soc_codes` VALUES (865, 43, 5111, 'Weighers, Measurers, Checkers, and Samplers, Recordkeeping'); INSERT INTO `soc_codes` VALUES (866, 43, 6000, 'Secretaries and Administrative Assistants'); INSERT INTO `soc_codes` VALUES (867, 43, 6010, 'Secretaries and Administrative Assistants'); INSERT INTO `soc_codes` VALUES (868, 43, 6011, 'Executive Secretaries and Administrative Assistants'); INSERT INTO `soc_codes` VALUES (869, 43, 6012, 'Legal Secretaries'); INSERT INTO `soc_codes` VALUES (870, 43, 6013, 'Medical Secretaries'); INSERT INTO `soc_codes` VALUES (871, 43, 6014, 'Secretaries, Except Legal, Medical, and Executive'); INSERT INTO `soc_codes` VALUES (872, 43, 9000, 'Other Office and Administrative Support Workers'); INSERT INTO `soc_codes` VALUES (873, 43, 9010, 'Computer Operators'); INSERT INTO `soc_codes` VALUES (874, 43, 9011, 'Computer Operators'); INSERT INTO `soc_codes` VALUES (875, 43, 9020, 'Data Entry and Information Processing Workers'); INSERT INTO `soc_codes` VALUES (876, 43, 9021, 'Data Entry Keyers'); INSERT INTO `soc_codes` VALUES (877, 43, 9022, 'Word Processors and Typists'); INSERT INTO `soc_codes` VALUES (878, 43, 9030, 'Desktop Publishers'); INSERT INTO `soc_codes` VALUES (879, 43, 9031, 'Desktop Publishers'); INSERT INTO `soc_codes` VALUES (880, 43, 9040, 'Insurance Claims and Policy Processing Clerks'); INSERT INTO `soc_codes` VALUES (881, 43, 9041, 'Insurance Claims and Policy Processing Clerks'); INSERT INTO `soc_codes` VALUES (882, 43, 9050, 'Mail Clerks and Mail Machine Operators, Except Postal Service'); INSERT INTO `soc_codes` VALUES (883, 43, 9051, 'Mail Clerks and Mail Machine Operators, Except Postal Service'); INSERT INTO `soc_codes` VALUES (884, 43, 9060, 'Office Clerks, General'); INSERT INTO `soc_codes` VALUES (885, 43, 9061, 'Office Clerks, General'); INSERT INTO `soc_codes` VALUES (886, 43, 9070, 'Office Machine Operators, Except Computer'); INSERT INTO `soc_codes` VALUES (887, 43, 9071, 'Office Machine Operators, Except Computer'); INSERT INTO `soc_codes` VALUES (888, 43, 9080, 'Proofreaders and Copy Markers'); INSERT INTO `soc_codes` VALUES (889, 43, 9081, 'Proofreaders and Copy Markers'); INSERT INTO `soc_codes` VALUES (890, 43, 9110, 'Statistical Assistants'); INSERT INTO `soc_codes` VALUES (891, 43, 9111, 'Statistical Assistants'); INSERT INTO `soc_codes` VALUES (892, 43, 9190, 'Miscellaneous Office and Administrative Support Workers'); INSERT INTO `soc_codes` VALUES (893, 43, 9199, 'Office and Administrative Support Workers, All Other'); INSERT INTO `soc_codes` VALUES (894, 45, 0, 'Farming, Fishing, and Forestry Occupations'); INSERT INTO `soc_codes` VALUES (895, 45, 1000, 'Supervisors, Farming, Fishing, and Forestry Workers'); INSERT INTO `soc_codes` VALUES (896, 45, 1010, 'First-Line Supervisors/Managers of Farming, Fishing, and Forestry Workers'); INSERT INTO `soc_codes` VALUES (897, 45, 1011, 'First-Line Supervisors/Managers of Farming, Fishing, and Forestry Workers'); INSERT INTO `soc_codes` VALUES (898, 45, 1012, 'Farm Labor Contractors'); INSERT INTO `soc_codes` VALUES (899, 45, 2000, 'Agricultural Workers'); INSERT INTO `soc_codes` VALUES (900, 45, 2010, 'Agricultural Inspectors'); INSERT INTO `soc_codes` VALUES (901, 45, 2011, 'Agricultural Inspectors'); INSERT INTO `soc_codes` VALUES (902, 45, 2020, 'Animal Breeders'); INSERT INTO `soc_codes` VALUES (903, 45, 2021, 'Animal Breeders'); INSERT INTO `soc_codes` VALUES (904, 45, 2040, 'Graders and Sorters, Agricultural Products'); INSERT INTO `soc_codes` VALUES (905, 45, 2041, 'Graders and Sorters, Agricultural Products'); INSERT INTO `soc_codes` VALUES (906, 45, 2090, 'Miscellaneous Agricultural Workers'); INSERT INTO `soc_codes` VALUES (907, 45, 2091, 'Agricultural Equipment Operators'); INSERT INTO `soc_codes` VALUES (908, 45, 2092, 'Farmworkers and Laborers, Crop, Nursery, and Greenhouse'); INSERT INTO `soc_codes` VALUES (909, 45, 2093, 'Farmworkers, Farm and Ranch Animals'); INSERT INTO `soc_codes` VALUES (910, 45, 2099, 'Agricultural Workers, All Other'); INSERT INTO `soc_codes` VALUES (911, 45, 3000, 'Fishing and Hunting Workers'); INSERT INTO `soc_codes` VALUES (912, 45, 3010, 'Fishers and Related Fishing Workers'); INSERT INTO `soc_codes` VALUES (913, 45, 3011, 'Fishers and Related Fishing Workers'); INSERT INTO `soc_codes` VALUES (914, 45, 3020, 'Hunters and Trappers'); INSERT INTO `soc_codes` VALUES (915, 45, 3021, 'Hunters and Trappers'); INSERT INTO `soc_codes` VALUES (916, 45, 4000, 'Forest, Conservation, and Logging Workers'); INSERT INTO `soc_codes` VALUES (917, 45, 4010, 'Forest and Conservation Workers'); INSERT INTO `soc_codes` VALUES (918, 45, 4011, 'Forest and Conservation Workers'); INSERT INTO `soc_codes` VALUES (919, 45, 4020, 'Logging Workers'); INSERT INTO `soc_codes` VALUES (920, 45, 4021, 'Fallers'); INSERT INTO `soc_codes` VALUES (921, 45, 4022, 'Logging Equipment Operators'); INSERT INTO `soc_codes` VALUES (922, 45, 4023, 'Log Graders and Scalers'); INSERT INTO `soc_codes` VALUES (923, 45, 4029, 'Logging Workers, All Other'); INSERT INTO `soc_codes` VALUES (924, 47, 0, 'Construction and Extraction Occupations'); INSERT INTO `soc_codes` VALUES (925, 47, 1000, 'Supervisors, Construction and Extraction Workers'); INSERT INTO `soc_codes` VALUES (926, 47, 1010, 'First-Line Supervisors/Managers of Construction Trades and Extraction Workers'); INSERT INTO `soc_codes` VALUES (927, 47, 1011, 'First-Line Supervisors/Managers of Construction Trades and Extraction Workers'); INSERT INTO `soc_codes` VALUES (928, 47, 2000, 'Construction Trades Workers'); INSERT INTO `soc_codes` VALUES (929, 47, 2010, 'Boilermakers'); INSERT INTO `soc_codes` VALUES (930, 47, 2011, 'Boilermakers'); INSERT INTO `soc_codes` VALUES (931, 47, 2020, 'Brickmasons, Blockmasons, and Stonemasons'); INSERT INTO `soc_codes` VALUES (932, 47, 2021, 'Brickmasons and Blockmasons'); INSERT INTO `soc_codes` VALUES (933, 47, 2022, 'Stonemasons'); INSERT INTO `soc_codes` VALUES (934, 47, 2030, 'Carpenters'); INSERT INTO `soc_codes` VALUES (935, 47, 2031, 'Carpenters'); INSERT INTO `soc_codes` VALUES (936, 47, 2040, 'Carpet, Floor, and Tile Installers and Finishers'); INSERT INTO `soc_codes` VALUES (937, 47, 2041, 'Carpet Installers'); INSERT INTO `soc_codes` VALUES (938, 47, 2042, 'Floor Layers, Except Carpet, Wood, and Hard Tiles'); INSERT INTO `soc_codes` VALUES (939, 47, 2043, 'Floor Sanders and Finishers'); INSERT INTO `soc_codes` VALUES (940, 47, 2044, 'Tile and Marble Setters'); INSERT INTO `soc_codes` VALUES (941, 47, 2050, 'Cement Masons, Concrete Finishers, and Terrazzo Workers'); INSERT INTO `soc_codes` VALUES (942, 47, 2051, 'Cement Masons and Concrete Finishers'); INSERT INTO `soc_codes` VALUES (943, 47, 2053, 'Terrazzo Workers and Finishers'); INSERT INTO `soc_codes` VALUES (944, 47, 2060, 'Construction Laborers'); INSERT INTO `soc_codes` VALUES (945, 47, 2061, 'Construction Laborers'); INSERT INTO `soc_codes` VALUES (946, 47, 2070, 'Construction Equipment Operators'); INSERT INTO `soc_codes` VALUES (947, 47, 2071, 'Paving, Surfacing, and Tamping Equipment Operators'); INSERT INTO `soc_codes` VALUES (948, 47, 2072, 'Pile-Driver Operators'); INSERT INTO `soc_codes` VALUES (949, 47, 2073, 'Operating Engineers and Other Construction Equipment Operators'); INSERT INTO `soc_codes` VALUES (950, 47, 2080, 'Drywall Installers, Ceiling Tile Installers, and Tapers'); INSERT INTO `soc_codes` VALUES (951, 47, 2081, 'Drywall and Ceiling Tile Installers'); INSERT INTO `soc_codes` VALUES (952, 47, 2082, 'Tapers'); INSERT INTO `soc_codes` VALUES (953, 47, 2110, 'Electricians'); INSERT INTO `soc_codes` VALUES (954, 47, 2111, 'Electricians'); INSERT INTO `soc_codes` VALUES (955, 47, 2120, 'Glaziers'); INSERT INTO `soc_codes` VALUES (956, 47, 2121, 'Glaziers'); INSERT INTO `soc_codes` VALUES (957, 47, 2130, 'Insulation Workers'); INSERT INTO `soc_codes` VALUES (958, 47, 2131, 'Insulation Workers, Floor, Ceiling, and Wall'); INSERT INTO `soc_codes` VALUES (959, 47, 2132, 'Insulation Workers, Mechanical'); INSERT INTO `soc_codes` VALUES (960, 47, 2140, 'Painters and Paperhangers'); INSERT INTO `soc_codes` VALUES (961, 47, 2141, 'Painters, Construction and Maintenance'); INSERT INTO `soc_codes` VALUES (962, 47, 2142, 'Paperhangers'); INSERT INTO `soc_codes` VALUES (963, 47, 2150, 'Pipelayers, Plumbers, Pipefitters, and Steamfitters'); INSERT INTO `soc_codes` VALUES (964, 47, 2151, 'Pipelayers'); INSERT INTO `soc_codes` VALUES (965, 47, 2152, 'Plumbers, Pipefitters, and Steamfitters'); INSERT INTO `soc_codes` VALUES (966, 47, 2160, 'Plasterers and Stucco Masons'); INSERT INTO `soc_codes` VALUES (967, 47, 2161, 'Plasterers and Stucco Masons'); INSERT INTO `soc_codes` VALUES (968, 47, 2170, 'Reinforcing Iron and Rebar Workers'); INSERT INTO `soc_codes` VALUES (969, 47, 2171, 'Reinforcing Iron and Rebar Workers'); INSERT INTO `soc_codes` VALUES (970, 47, 2180, 'Roofers'); INSERT INTO `soc_codes` VALUES (971, 47, 2181, 'Roofers'); INSERT INTO `soc_codes` VALUES (972, 47, 2210, 'Sheet Metal Workers'); INSERT INTO `soc_codes` VALUES (973, 47, 2211, 'Sheet Metal Workers'); INSERT INTO `soc_codes` VALUES (974, 47, 2220, 'Structural Iron and Steel Workers'); INSERT INTO `soc_codes` VALUES (975, 47, 2221, 'Structural Iron and Steel Workers'); INSERT INTO `soc_codes` VALUES (976, 47, 3000, 'Helpers, Construction Trades'); INSERT INTO `soc_codes` VALUES (977, 47, 3010, 'Helpers, Construction Trades'); INSERT INTO `soc_codes` VALUES (978, 47, 3011, 'Helpers--Brickmasons, Blockmasons, Stonemasons, and Tile and Marble Setters'); INSERT INTO `soc_codes` VALUES (979, 47, 3012, 'Helpers--Carpenters'); INSERT INTO `soc_codes` VALUES (980, 47, 3013, 'Helpers--Electricians'); INSERT INTO `soc_codes` VALUES (981, 47, 3014, 'Helpers--Painters, Paperhangers, Plasterers, and Stucco Masons'); INSERT INTO `soc_codes` VALUES (982, 47, 3015, 'Helpers--Pipelayers, Plumbers, Pipefitters, and Steamfitters'); INSERT INTO `soc_codes` VALUES (983, 47, 3016, 'Helpers--Roofers'); INSERT INTO `soc_codes` VALUES (984, 47, 3019, 'Helpers, Construction Trades, All Other'); INSERT INTO `soc_codes` VALUES (985, 47, 4000, 'Other Construction and Related Workers'); INSERT INTO `soc_codes` VALUES (986, 47, 4010, 'Construction and Building Inspectors'); INSERT INTO `soc_codes` VALUES (987, 47, 4011, 'Construction and Building Inspectors'); INSERT INTO `soc_codes` VALUES (988, 47, 4020, 'Elevator Installers and Repairers'); INSERT INTO `soc_codes` VALUES (989, 47, 4021, 'Elevator Installers and Repairers'); INSERT INTO `soc_codes` VALUES (990, 47, 4030, 'Fence Erectors'); INSERT INTO `soc_codes` VALUES (991, 47, 4031, 'Fence Erectors'); INSERT INTO `soc_codes` VALUES (992, 47, 4040, 'Hazardous Materials Removal Workers'); INSERT INTO `soc_codes` VALUES (993, 47, 4041, 'Hazardous Materials Removal Workers'); INSERT INTO `soc_codes` VALUES (994, 47, 4050, 'Highway Maintenance Workers'); INSERT INTO `soc_codes` VALUES (995, 47, 4051, 'Highway Maintenance Workers'); INSERT INTO `soc_codes` VALUES (996, 47, 4060, 'Rail-Track Laying and Maintenance Equipment Operators'); INSERT INTO `soc_codes` VALUES (997, 47, 4061, 'Rail-Track Laying and Maintenance Equipment Operators'); INSERT INTO `soc_codes` VALUES (998, 47, 4070, 'Septic Tank Servicers and Sewer Pipe Cleaners'); INSERT INTO `soc_codes` VALUES (999, 47, 4071, 'Septic Tank Servicers and Sewer Pipe Cleaners'); INSERT INTO `soc_codes` VALUES (1000, 47, 4090, 'Miscellaneous Construction and Related Workers'); INSERT INTO `soc_codes` VALUES (1001, 47, 4091, 'Segmental Pavers'); INSERT INTO `soc_codes` VALUES (1002, 47, 4099, 'Construction and Related Workers, All Other'); INSERT INTO `soc_codes` VALUES (1003, 47, 5000, 'Extraction Workers'); INSERT INTO `soc_codes` VALUES (1004, 47, 5010, 'Derrick, Rotary Drill, and Service Unit Operators, Oil, Gas, and Mining'); INSERT INTO `soc_codes` VALUES (1005, 47, 5011, 'Derrick Operators, Oil and Gas'); INSERT INTO `soc_codes` VALUES (1006, 47, 5012, 'Rotary Drill Operators, Oil and Gas'); INSERT INTO `soc_codes` VALUES (1007, 47, 5013, 'Service Unit Operators, Oil, Gas, and Mining'); INSERT INTO `soc_codes` VALUES (1008, 47, 5020, 'Earth Drillers, Except Oil and Gas'); INSERT INTO `soc_codes` VALUES (1009, 47, 5021, 'Earth Drillers, Except Oil and Gas'); INSERT INTO `soc_codes` VALUES (1010, 47, 5030, 'Explosives Workers, Ordnance Handling Experts, and Blasters'); INSERT INTO `soc_codes` VALUES (1011, 47, 5031, 'Explosives Workers, Ordnance Handling Experts, and Blasters'); INSERT INTO `soc_codes` VALUES (1012, 47, 5040, 'Mining Machine Operators'); INSERT INTO `soc_codes` VALUES (1013, 47, 5041, 'Continuous Mining Machine Operators'); INSERT INTO `soc_codes` VALUES (1014, 47, 5042, 'Mine Cutting and Chaneling Machine Operators'); INSERT INTO `soc_codes` VALUES (1015, 47, 5049, 'Mining Machine Operators, All Other'); INSERT INTO `soc_codes` VALUES (1016, 47, 5050, 'Rock Splitters, Quarry'); INSERT INTO `soc_codes` VALUES (1017, 47, 5051, 'Rock Splitters, Quarry'); INSERT INTO `soc_codes` VALUES (1018, 47, 5060, 'Roof Bolters, Mining'); INSERT INTO `soc_codes` VALUES (1019, 47, 5061, 'Roof Bolters, Mining'); INSERT INTO `soc_codes` VALUES (1020, 47, 5070, 'Roustabouts, Oil and Gas'); INSERT INTO `soc_codes` VALUES (1021, 47, 5071, 'Roustabouts, Oil and Gas'); INSERT INTO `soc_codes` VALUES (1022, 47, 5080, 'Helpers--Extraction Workers'); INSERT INTO `soc_codes` VALUES (1023, 47, 5081, 'Helpers--Extraction Workers'); INSERT INTO `soc_codes` VALUES (1024, 47, 5090, 'Miscellaneous Extraction Workers'); INSERT INTO `soc_codes` VALUES (1025, 47, 5099, 'Extraction Workers, All Other'); INSERT INTO `soc_codes` VALUES (1026, 49, 0, 'Installation, Maintenance, and Repair Occupations'); INSERT INTO `soc_codes` VALUES (1027, 49, 1000, 'Supervisors of Installation, Maintenance, and Repair Workers'); INSERT INTO `soc_codes` VALUES (1028, 49, 1010, 'First-Line Supervisors/Managers of Mechanics, Installers, and Repairers'); INSERT INTO `soc_codes` VALUES (1029, 49, 1011, 'First-Line Supervisors/Managers of Mechanics, Installers, and Repairers'); INSERT INTO `soc_codes` VALUES (1030, 49, 2000, 'Electrical and Electronic Equipment Mechanics, Installers, and Repairers'); INSERT INTO `soc_codes` VALUES (1031, 49, 2010, 'Computer, Automated Teller, and Office Machine Repairers'); INSERT INTO `soc_codes` VALUES (1032, 49, 2011, 'Computer, Automated Teller, and Office Machine Repairers'); INSERT INTO `soc_codes` VALUES (1033, 49, 2020, 'Radio and Telecommunications Equipment Installers and Repairers'); INSERT INTO `soc_codes` VALUES (1034, 49, 2021, 'Radio Mechanics'); INSERT INTO `soc_codes` VALUES (1035, 49, 2022, 'Telecommunications Equipment Installers and Repairers, Except Line Installers'); INSERT INTO `soc_codes` VALUES (1036, 49, 2090, 'Miscellaneous Electrical and Electronic Equipment Mechanics, Installers, and Repairers'); INSERT INTO `soc_codes` VALUES (1037, 49, 2091, 'Avionics Technicians'); INSERT INTO `soc_codes` VALUES (1038, 49, 2092, 'Electric Motor, Power Tool, and Related Repairers'); INSERT INTO `soc_codes` VALUES (1039, 49, 2093, 'Electrical and Electronics Installers and Repairers, Transportation Equipment'); INSERT INTO `soc_codes` VALUES (1040, 49, 2094, 'Electrical and Electronics Repairers, Commercial and Industrial Equipment'); INSERT INTO `soc_codes` VALUES (1041, 49, 2095, 'Electrical and Electronics Repairers, Powerhouse, Substation, and Relay'); INSERT INTO `soc_codes` VALUES (1042, 49, 2096, 'Electronic Equipment Installers and Repairers, Motor Vehicles'); INSERT INTO `soc_codes` VALUES (1043, 49, 2097, 'Electronic Home Entertainment Equipment Installers and Repairers'); INSERT INTO `soc_codes` VALUES (1044, 49, 2098, 'Security and Fire Alarm Systems Installers'); INSERT INTO `soc_codes` VALUES (1045, 49, 3000, 'Vehicle and Mobile Equipment Mechanics, Installers, and Repairers'); INSERT INTO `soc_codes` VALUES (1046, 49, 3010, 'Aircraft Mechanics and Service Technicians'); INSERT INTO `soc_codes` VALUES (1047, 49, 3011, 'Aircraft Mechanics and Service Technicians'); INSERT INTO `soc_codes` VALUES (1048, 49, 3020, 'Automotive Technicians and Repairers'); INSERT INTO `soc_codes` VALUES (1049, 49, 3021, 'Automotive Body and Related Repairers'); INSERT INTO `soc_codes` VALUES (1050, 49, 3022, 'Automotive Glass Installers and Repairers'); INSERT INTO `soc_codes` VALUES (1051, 49, 3023, 'Automotive Service Technicians and Mechanics'); INSERT INTO `soc_codes` VALUES (1052, 49, 3030, 'Bus and Truck Mechanics and Diesel Engine Specialists'); INSERT INTO `soc_codes` VALUES (1053, 49, 3031, 'Bus and Truck Mechanics and Diesel Engine Specialists'); INSERT INTO `soc_codes` VALUES (1054, 49, 3040, 'Heavy Vehicle and Mobile Equipment Service Technicians and Mechanics'); INSERT INTO `soc_codes` VALUES (1055, 49, 3041, 'Farm Equipment Mechanics'); INSERT INTO `soc_codes` VALUES (1056, 49, 3042, 'Mobile Heavy Equipment Mechanics, Except Engines'); INSERT INTO `soc_codes` VALUES (1057, 49, 3043, 'Rail Car Repairers'); INSERT INTO `soc_codes` VALUES (1058, 49, 3050, 'Small Engine Mechanics'); INSERT INTO `soc_codes` VALUES (1059, 49, 3051, 'Motorboat Mechanics'); INSERT INTO `soc_codes` VALUES (1060, 49, 3052, 'Motorcycle Mechanics'); INSERT INTO `soc_codes` VALUES (1061, 49, 3053, 'Outdoor Power Equipment and Other Small Engine Mechanics'); INSERT INTO `soc_codes` VALUES (1062, 49, 3090, 'Miscellaneous Vehicle and Mobile Equipment Mechanics, Installers, and Repairers'); INSERT INTO `soc_codes` VALUES (1063, 49, 3091, 'Bicycle Repairers'); INSERT INTO `soc_codes` VALUES (1064, 49, 3092, 'Recreational Vehicle Service Technicians'); INSERT INTO `soc_codes` VALUES (1065, 49, 3093, 'Tire Repairers and Changers'); INSERT INTO `soc_codes` VALUES (1066, 49, 9000, 'Other Installation, Maintenance, and Repair Occupations'); INSERT INTO `soc_codes` VALUES (1067, 49, 9010, 'Control and Valve Installers and Repairers'); INSERT INTO `soc_codes` VALUES (1068, 49, 9011, 'Mechanical Door Repairers'); INSERT INTO `soc_codes` VALUES (1069, 49, 9012, 'Control and Valve Installers and Repairers, Except Mechanical Door'); INSERT INTO `soc_codes` VALUES (1070, 49, 9020, 'Heating, Air Conditioning, and Refrigeration Mechanics and Installers'); INSERT INTO `soc_codes` VALUES (1071, 49, 9021, 'Heating, Air Conditioning, and Refrigeration Mechanics and Installers'); INSERT INTO `soc_codes` VALUES (1072, 49, 9030, 'Home Appliance Repairers'); INSERT INTO `soc_codes` VALUES (1073, 49, 9031, 'Home Appliance Repairers'); INSERT INTO `soc_codes` VALUES (1074, 49, 9040, 'Industrial Machinery Installation, Repair, and Maintenance Workers'); INSERT INTO `soc_codes` VALUES (1075, 49, 9041, 'Industrial Machinery Mechanics'); INSERT INTO `soc_codes` VALUES (1076, 49, 9042, 'Maintenance and Repair Workers, General'); INSERT INTO `soc_codes` VALUES (1077, 49, 9043, 'Maintenance Workers, Machinery'); INSERT INTO `soc_codes` VALUES (1078, 49, 9044, 'Millwrights'); INSERT INTO `soc_codes` VALUES (1079, 49, 9045, 'Refractory Materials Repairers, Except Brickmasons'); INSERT INTO `soc_codes` VALUES (1080, 49, 9050, 'Line Installers and Repairers'); INSERT INTO `soc_codes` VALUES (1081, 49, 9051, 'Electrical Power-Line Installers and Repairers'); INSERT INTO `soc_codes` VALUES (1082, 49, 9052, 'Telecommunications Line Installers and Repairers'); INSERT INTO `soc_codes` VALUES (1083, 49, 9060, 'Precision Instrument and Equipment Repairers'); INSERT INTO `soc_codes` VALUES (1084, 49, 9061, 'Camera and Photographic Equipment Repairers'); INSERT INTO `soc_codes` VALUES (1085, 49, 9062, 'Medical Equipment Repairers'); INSERT INTO `soc_codes` VALUES (1086, 49, 9063, 'Musical Instrument Repairers and Tuners'); INSERT INTO `soc_codes` VALUES (1087, 49, 9064, 'Watch Repairers'); INSERT INTO `soc_codes` VALUES (1088, 49, 9069, 'Precision Instrument and Equipment Repairers, All Other'); INSERT INTO `soc_codes` VALUES (1089, 49, 9090, 'Miscellaneous Installation, Maintenance, and Repair Workers'); INSERT INTO `soc_codes` VALUES (1090, 49, 9091, 'Coin, Vending, and Amusement Machine Servicers and Repairers'); INSERT INTO `soc_codes` VALUES (1091, 49, 9092, 'Commercial Divers'); INSERT INTO `soc_codes` VALUES (1092, 49, 9093, 'Fabric Menders, Except Garment'); INSERT INTO `soc_codes` VALUES (1093, 49, 9094, 'Locksmiths and Safe Repairers'); INSERT INTO `soc_codes` VALUES (1094, 49, 9095, 'Manufactured Building and Mobile Home Installers'); INSERT INTO `soc_codes` VALUES (1095, 49, 9096, 'Riggers'); INSERT INTO `soc_codes` VALUES (1096, 49, 9097, 'Signal and Track Switch Repairers'); INSERT INTO `soc_codes` VALUES (1097, 49, 9098, 'Helpers--Installation, Maintenance, and Repair Workers'); INSERT INTO `soc_codes` VALUES (1098, 49, 9099, 'Installation, Maintenance, and Repair Workers, All Other'); INSERT INTO `soc_codes` VALUES (1099, 51, 0, 'Production Occupations'); INSERT INTO `soc_codes` VALUES (1100, 51, 1000, 'Supervisors, Production Workers'); INSERT INTO `soc_codes` VALUES (1101, 51, 1010, 'First-Line Supervisors/Managers of Production and Operating Workers'); INSERT INTO `soc_codes` VALUES (1102, 51, 1011, 'First-Line Supervisors/Managers of Production and Operating Workers'); INSERT INTO `soc_codes` VALUES (1103, 51, 2000, 'Assemblers and Fabricators'); INSERT INTO `soc_codes` VALUES (1104, 51, 2010, 'Aircraft Structure, Surfaces, Rigging, and Systems Assemblers'); INSERT INTO `soc_codes` VALUES (1105, 51, 2011, 'Aircraft Structure, Surfaces, Rigging, and Systems Assemblers'); INSERT INTO `soc_codes` VALUES (1106, 51, 2020, 'Electrical, Electronics, and Electromechanical Assemblers'); INSERT INTO `soc_codes` VALUES (1107, 51, 2021, 'Coil Winders, Tapers, and Finishers'); INSERT INTO `soc_codes` VALUES (1108, 51, 2022, 'Electrical and Electronic Equipment Assemblers'); INSERT INTO `soc_codes` VALUES (1109, 51, 2023, 'Electromechanical Equipment Assemblers'); INSERT INTO `soc_codes` VALUES (1110, 51, 2030, 'Engine and Other Machine Assemblers'); INSERT INTO `soc_codes` VALUES (1111, 51, 2031, 'Engine and Other Machine Assemblers'); INSERT INTO `soc_codes` VALUES (1112, 51, 2040, 'Structural Metal Fabricators and Fitters'); INSERT INTO `soc_codes` VALUES (1113, 51, 2041, 'Structural Metal Fabricators and Fitters'); INSERT INTO `soc_codes` VALUES (1114, 51, 2090, 'Miscellaneous Assemblers and Fabricators'); INSERT INTO `soc_codes` VALUES (1115, 51, 2091, 'Fiberglass Laminators and Fabricators'); INSERT INTO `soc_codes` VALUES (1116, 51, 2092, 'Team Assemblers'); INSERT INTO `soc_codes` VALUES (1117, 51, 2093, 'Timing Device Assemblers, Adjusters, and Calibrators'); INSERT INTO `soc_codes` VALUES (1118, 51, 2099, 'Assemblers and Fabricators, All Other'); INSERT INTO `soc_codes` VALUES (1119, 51, 3000, 'Food Processing Workers'); INSERT INTO `soc_codes` VALUES (1120, 51, 3010, 'Bakers'); INSERT INTO `soc_codes` VALUES (1121, 51, 3011, 'Bakers'); INSERT INTO `soc_codes` VALUES (1122, 51, 3020, 'Butchers and Other Meat, Poultry, and Fish Processing Workers'); INSERT INTO `soc_codes` VALUES (1123, 51, 3021, 'Butchers and Meat Cutters'); INSERT INTO `soc_codes` VALUES (1124, 51, 3022, 'Meat, Poultry, and Fish Cutters and Trimmers'); INSERT INTO `soc_codes` VALUES (1125, 51, 3023, 'Slaughterers and Meat Packers'); INSERT INTO `soc_codes` VALUES (1126, 51, 3090, 'Miscellaneous Food Processing Workers'); INSERT INTO `soc_codes` VALUES (1127, 51, 3091, 'Food and Tobacco Roasting, Baking, and Drying Machine Operators and Tenders'); INSERT INTO `soc_codes` VALUES (1128, 51, 3092, 'Food Batchmakers'); INSERT INTO `soc_codes` VALUES (1129, 51, 3093, 'Food Cooking Machine Operators and Tenders'); INSERT INTO `soc_codes` VALUES (1130, 51, 4000, 'Metal Workers and Plastic Workers'); INSERT INTO `soc_codes` VALUES (1131, 51, 4010, 'Computer Control Programmers and Operators'); INSERT INTO `soc_codes` VALUES (1132, 51, 4011, 'Computer-Controlled Machine Tool Operators, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1133, 51, 4012, 'Numerical Tool and Process Control Programmers'); INSERT INTO `soc_codes` VALUES (1134, 51, 4020, 'Forming Machine Setters, Operators, and Tenders, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1135, 51, 4021, 'Extruding and Drawing Machine Setters, Operators, and Tenders, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1136, 51, 4022, 'Forging Machine Setters, Operators, and Tenders, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1137, 51, 4023, 'Rolling Machine Setters, Operators, and Tenders, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1138, 51, 4030, 'Machine Tool Cutting Setters, Operators, and Tenders, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1139, 51, 4031, 'Cutting, Punching, and Press Machine Setters, Operators, and Tenders, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1140, 51, 4032, 'Drilling and Boring Machine Tool Setters, Operators, and Tenders, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1141, 51, 4033, 'Grinding, Lapping, Polishing, and Buffing Machine Tool Setters, Operators, and Tenders, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1142, 51, 4034, 'Lathe and Turning Machine Tool Setters, Operators, and Tenders, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1143, 51, 4035, 'Milling and Planing Machine Setters, Operators, and Tenders, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1144, 51, 4040, 'Machinists'); INSERT INTO `soc_codes` VALUES (1145, 51, 4041, 'Machinists'); INSERT INTO `soc_codes` VALUES (1146, 51, 4050, 'Metal Furnace and Kiln Operators and Tenders'); INSERT INTO `soc_codes` VALUES (1147, 51, 4051, 'Metal-Refining Furnace Operators and Tenders'); INSERT INTO `soc_codes` VALUES (1148, 51, 4052, 'Pourers and Casters, Metal'); INSERT INTO `soc_codes` VALUES (1149, 51, 4060, 'Model Makers and Patternmakers, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1150, 51, 4061, 'Model Makers, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1151, 51, 4062, 'Patternmakers, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1152, 51, 4070, 'Molders and Molding Machine Setters, Operators, and Tenders, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1153, 51, 4071, 'Foundry Mold and Coremakers'); INSERT INTO `soc_codes` VALUES (1154, 51, 4072, 'Molding, Coremaking, and Casting Machine Setters, Operators, and Tenders, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1155, 51, 4080, 'Multiple Machine Tool Setters, Operators, and Tenders, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1156, 51, 4081, 'Multiple Machine Tool Setters, Operators, and Tenders, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1157, 51, 4110, 'Tool and Die Makers'); INSERT INTO `soc_codes` VALUES (1158, 51, 4111, 'Tool and Die Makers'); INSERT INTO `soc_codes` VALUES (1159, 51, 4120, 'Welding, Soldering, and Brazing Workers'); INSERT INTO `soc_codes` VALUES (1160, 51, 4121, 'Welders, Cutters, Solderers, and Brazers'); INSERT INTO `soc_codes` VALUES (1161, 51, 4122, 'Welding, Soldering, and Brazing Machine Setters, Operators, and Tenders'); INSERT INTO `soc_codes` VALUES (1162, 51, 4190, 'Miscellaneous Metalworkers and Plastic Workers'); INSERT INTO `soc_codes` VALUES (1163, 51, 4191, 'Heat Treating Equipment Setters, Operators, and Tenders, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1164, 51, 4192, 'Lay-Out Workers, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1165, 51, 4193, 'Plating and Coating Machine Setters, Operators, and Tenders, Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1166, 51, 4194, 'Tool Grinders, Filers, and Sharpeners'); INSERT INTO `soc_codes` VALUES (1167, 51, 4199, 'Metal Workers and Plastic Workers, All Other'); INSERT INTO `soc_codes` VALUES (1168, 51, 5000, 'Printing Workers'); INSERT INTO `soc_codes` VALUES (1169, 51, 5010, 'Bookbinders and Bindery Workers'); INSERT INTO `soc_codes` VALUES (1170, 51, 5011, 'Bindery Workers'); INSERT INTO `soc_codes` VALUES (1171, 51, 5012, 'Bookbinders'); INSERT INTO `soc_codes` VALUES (1172, 51, 5020, 'Printers'); INSERT INTO `soc_codes` VALUES (1173, 51, 5021, 'Job Printers'); INSERT INTO `soc_codes` VALUES (1174, 51, 5022, 'Prepress Technicians and Workers'); INSERT INTO `soc_codes` VALUES (1175, 51, 5023, 'Printing Machine Operators'); INSERT INTO `soc_codes` VALUES (1176, 51, 6000, 'Textile, Apparel, and Furnishings Workers'); INSERT INTO `soc_codes` VALUES (1177, 51, 6010, 'Laundry and Dry-Cleaning Workers'); INSERT INTO `soc_codes` VALUES (1178, 51, 6011, 'Laundry and Dry-Cleaning Workers'); INSERT INTO `soc_codes` VALUES (1179, 51, 6020, 'Pressers, Textile, Garment, and Related Materials'); INSERT INTO `soc_codes` VALUES (1180, 51, 6021, 'Pressers, Textile, Garment, and Related Materials'); INSERT INTO `soc_codes` VALUES (1181, 51, 6030, 'Sewing Machine Operators'); INSERT INTO `soc_codes` VALUES (1182, 51, 6031, 'Sewing Machine Operators'); INSERT INTO `soc_codes` VALUES (1183, 51, 6040, 'Shoe and Leather Workers'); INSERT INTO `soc_codes` VALUES (1184, 51, 6041, 'Shoe and Leather Workers and Repairers'); INSERT INTO `soc_codes` VALUES (1185, 51, 6042, 'Shoe Machine Operators and Tenders'); INSERT INTO `soc_codes` VALUES (1186, 51, 6050, 'Tailors, Dressmakers, and Sewers'); INSERT INTO `soc_codes` VALUES (1187, 51, 6051, 'Sewers, Hand'); INSERT INTO `soc_codes` VALUES (1188, 51, 6052, 'Tailors, Dressmakers, and Custom Sewers'); INSERT INTO `soc_codes` VALUES (1189, 51, 6060, 'Textile Machine Setters, Operators, and Tenders'); INSERT INTO `soc_codes` VALUES (1190, 51, 6061, 'Textile Bleaching and Dyeing Machine Operators and Tenders'); INSERT INTO `soc_codes` VALUES (1191, 51, 6062, 'Textile Cutting Machine Setters, Operators, and Tenders'); INSERT INTO `soc_codes` VALUES (1192, 51, 6063, 'Textile Knitting and Weaving Machine Setters, Operators, and Tenders'); INSERT INTO `soc_codes` VALUES (1193, 51, 6064, 'Textile Winding, Twisting, and Drawing Out Machine Setters, Operators, and Tenders'); INSERT INTO `soc_codes` VALUES (1194, 51, 6090, 'Miscellaneous Textile, Apparel, and Furnishings Workers'); INSERT INTO `soc_codes` VALUES (1195, 51, 6091, 'Extruding and Forming Machine Setters, Operators, and Tenders, Synthetic and Glass Fibers'); INSERT INTO `soc_codes` VALUES (1196, 51, 6092, 'Fabric and Apparel Patternmakers'); INSERT INTO `soc_codes` VALUES (1197, 51, 6093, 'Upholsterers'); INSERT INTO `soc_codes` VALUES (1198, 51, 6099, 'Textile, Apparel, and Furnishings Workers, All Other'); INSERT INTO `soc_codes` VALUES (1199, 51, 7000, 'Woodworkers'); INSERT INTO `soc_codes` VALUES (1200, 51, 7010, 'Cabinetmakers and Bench Carpenters'); INSERT INTO `soc_codes` VALUES (1201, 51, 7011, 'Cabinetmakers and Bench Carpenters'); INSERT INTO `soc_codes` VALUES (1202, 51, 7020, 'Furniture Finishers'); INSERT INTO `soc_codes` VALUES (1203, 51, 7021, 'Furniture Finishers'); INSERT INTO `soc_codes` VALUES (1204, 51, 7030, 'Model Makers and Patternmakers, Wood'); INSERT INTO `soc_codes` VALUES (1205, 51, 7031, 'Model Makers, Wood'); INSERT INTO `soc_codes` VALUES (1206, 51, 7032, 'Patternmakers, Wood'); INSERT INTO `soc_codes` VALUES (1207, 51, 7040, 'Woodworking Machine Setters, Operators, and Tenders'); INSERT INTO `soc_codes` VALUES (1208, 51, 7041, 'Sawing Machine Setters, Operators, and Tenders, Wood'); INSERT INTO `soc_codes` VALUES (1209, 51, 7042, 'Woodworking Machine Setters, Operators, and Tenders, Except Sawing'); INSERT INTO `soc_codes` VALUES (1210, 51, 7090, 'Miscellaneous Woodworkers'); INSERT INTO `soc_codes` VALUES (1211, 51, 7099, 'Woodworkers, All Other'); INSERT INTO `soc_codes` VALUES (1212, 51, 8000, 'Plant and System Operators'); INSERT INTO `soc_codes` VALUES (1213, 51, 8010, 'Power Plant Operators, Distributors, and Dispatchers'); INSERT INTO `soc_codes` VALUES (1214, 51, 8011, 'Nuclear Power Reactor Operators'); INSERT INTO `soc_codes` VALUES (1215, 51, 8012, 'Power Distributors and Dispatchers'); INSERT INTO `soc_codes` VALUES (1216, 51, 8013, 'Power Plant Operators'); INSERT INTO `soc_codes` VALUES (1217, 51, 8020, 'Stationary Engineers and Boiler Operators'); INSERT INTO `soc_codes` VALUES (1218, 51, 8021, 'Stationary Engineers and Boiler Operators'); INSERT INTO `soc_codes` VALUES (1219, 51, 8030, 'Water and Liquid Waste Treatment Plant and System Operators'); INSERT INTO `soc_codes` VALUES (1220, 51, 8031, 'Water and Liquid Waste Treatment Plant and System Operators'); INSERT INTO `soc_codes` VALUES (1221, 51, 8090, 'Miscellaneous Plant and System Operators'); INSERT INTO `soc_codes` VALUES (1222, 51, 8091, 'Chemical Plant and System Operators'); INSERT INTO `soc_codes` VALUES (1223, 51, 8092, 'Gas Plant Operators'); INSERT INTO `soc_codes` VALUES (1224, 51, 8093, 'Petroleum Pump System Operators, Refinery Operators, and Gaugers'); INSERT INTO `soc_codes` VALUES (1225, 51, 8099, 'Plant and System Operators, All Other'); INSERT INTO `soc_codes` VALUES (1226, 51, 9000, 'Other Production Occupations'); INSERT INTO `soc_codes` VALUES (1227, 51, 9010, 'Chemical Processing Machine Setters, Operators, and Tenders'); INSERT INTO `soc_codes` VALUES (1228, 51, 9011, 'Chemical Equipment Operators and Tenders'); INSERT INTO `soc_codes` VALUES (1229, 51, 9012, 'Separating, Filtering, Clarifying, Precipitating, and Still Machine Setters, Operators, and Tenders'); INSERT INTO `soc_codes` VALUES (1230, 51, 9020, 'Crushing, Grinding, Polishing, Mixing, and Blending Workers'); INSERT INTO `soc_codes` VALUES (1231, 51, 9021, 'Crushing, Grinding, and Polishing Machine Setters, Operators, and Tenders'); INSERT INTO `soc_codes` VALUES (1232, 51, 9022, 'Grinding and Polishing Workers, Hand'); INSERT INTO `soc_codes` VALUES (1233, 51, 9023, 'Mixing and Blending Machine Setters, Operators, and Tenders'); INSERT INTO `soc_codes` VALUES (1234, 51, 9030, 'Cutting Workers'); INSERT INTO `soc_codes` VALUES (1235, 51, 9031, 'Cutters and Trimmers, Hand'); INSERT INTO `soc_codes` VALUES (1236, 51, 9032, 'Cutting and Slicing Machine Setters, Operators, and Tenders'); INSERT INTO `soc_codes` VALUES (1237, 51, 9040, 'Extruding, Forming, Pressing, and Compacting Machine Setters, Operators, and Tenders'); INSERT INTO `soc_codes` VALUES (1238, 51, 9041, 'Extruding, Forming, Pressing, and Compacting Machine Setters, Operators, and Tenders'); INSERT INTO `soc_codes` VALUES (1239, 51, 9050, 'Furnace, Kiln, Oven, Drier, and Kettle Operators and Tenders'); INSERT INTO `soc_codes` VALUES (1240, 51, 9051, 'Furnace, Kiln, Oven, Drier, and Kettle Operators and Tenders'); INSERT INTO `soc_codes` VALUES (1241, 51, 9060, 'Inspectors, Testers, Sorters, Samplers, and Weighers'); INSERT INTO `soc_codes` VALUES (1242, 51, 9061, 'Inspectors, Testers, Sorters, Samplers, and Weighers'); INSERT INTO `soc_codes` VALUES (1243, 51, 9070, 'Jewelers and Precious Stone and Metal Workers'); INSERT INTO `soc_codes` VALUES (1244, 51, 9071, 'Jewelers and Precious Stone and Metal Workers'); INSERT INTO `soc_codes` VALUES (1245, 51, 9080, 'Medical, Dental, and Ophthalmic Laboratory Technicians'); INSERT INTO `soc_codes` VALUES (1246, 51, 9081, 'Dental Laboratory Technicians'); INSERT INTO `soc_codes` VALUES (1247, 51, 9082, 'Medical Appliance Technicians'); INSERT INTO `soc_codes` VALUES (1248, 51, 9083, 'Ophthalmic Laboratory Technicians'); INSERT INTO `soc_codes` VALUES (1249, 51, 9110, 'Packaging and Filling Machine Operators and Tenders'); INSERT INTO `soc_codes` VALUES (1250, 51, 9111, 'Packaging and Filling Machine Operators and Tenders'); INSERT INTO `soc_codes` VALUES (1251, 51, 9120, 'Painting Workers'); INSERT INTO `soc_codes` VALUES (1252, 51, 9121, 'Coating, Painting, and Spraying Machine Setters, Operators, and Tenders'); INSERT INTO `soc_codes` VALUES (1253, 51, 9122, 'Painters, Transportation Equipment'); INSERT INTO `soc_codes` VALUES (1254, 51, 9123, 'Painting, Coating, and Decorating Workers'); INSERT INTO `soc_codes` VALUES (1255, 51, 9130, 'Photographic Process Workers and Processing Machine Operators'); INSERT INTO `soc_codes` VALUES (1256, 51, 9131, 'Photographic Process Workers'); INSERT INTO `soc_codes` VALUES (1257, 51, 9132, 'Photographic Processing Machine Operators'); INSERT INTO `soc_codes` VALUES (1258, 51, 9140, 'Semiconductor Processors'); INSERT INTO `soc_codes` VALUES (1259, 51, 9141, 'Semiconductor Processors'); INSERT INTO `soc_codes` VALUES (1260, 51, 9190, 'Miscellaneous Production Workers'); INSERT INTO `soc_codes` VALUES (1261, 51, 9191, 'Cementing and Gluing Machine Operators and Tenders'); INSERT INTO `soc_codes` VALUES (1262, 51, 9192, 'Cleaning, Washing, and Metal Pickling Equipment Operators and Tenders'); INSERT INTO `soc_codes` VALUES (1263, 51, 9193, 'Cooling and Freezing Equipment Operators and Tenders'); INSERT INTO `soc_codes` VALUES (1264, 51, 9194, 'Etchers and Engravers'); INSERT INTO `soc_codes` VALUES (1265, 51, 9195, 'Molders, Shapers, and Casters, Except Metal and Plastic'); INSERT INTO `soc_codes` VALUES (1266, 51, 9196, 'Paper Goods Machine Setters, Operators, and Tenders'); INSERT INTO `soc_codes` VALUES (1267, 51, 9197, 'Tire Builders'); INSERT INTO `soc_codes` VALUES (1268, 51, 9198, 'Helpers--Production Workers'); INSERT INTO `soc_codes` VALUES (1269, 51, 9199, 'Production Workers, All Other'); INSERT INTO `soc_codes` VALUES (1270, 53, 0, 'Transportation and Material Moving Occupations'); INSERT INTO `soc_codes` VALUES (1271, 53, 1000, 'Supervisors, Transportation and Material Moving Workers'); INSERT INTO `soc_codes` VALUES (1272, 53, 1010, 'Aircraft Cargo Handling Supervisors'); INSERT INTO `soc_codes` VALUES (1273, 53, 1011, 'Aircraft Cargo Handling Supervisors'); INSERT INTO `soc_codes` VALUES (1274, 53, 1020, 'First-Line Supervisors/Managers of Helpers, Laborers, and Material Movers, Hand'); INSERT INTO `soc_codes` VALUES (1275, 53, 1021, 'First-Line Supervisors/Managers of Helpers, Laborers, and Material Movers, Hand'); INSERT INTO `soc_codes` VALUES (1276, 53, 1030, 'First-Line Supervisors/Managers of Transportation and Material-Moving Machine and Vehicle Operators'); INSERT INTO `soc_codes` VALUES (1277, 53, 1031, 'First-Line Supervisors/Managers of Transportation and Material-Moving Machine and Vehicle Operators'); INSERT INTO `soc_codes` VALUES (1278, 53, 2000, 'Air Transportation Workers'); INSERT INTO `soc_codes` VALUES (1279, 53, 2010, 'Aircraft Pilots and Flight Engineers'); INSERT INTO `soc_codes` VALUES (1280, 53, 2011, 'Airline Pilots, Copilots, and Flight Engineers'); INSERT INTO `soc_codes` VALUES (1281, 53, 2012, 'Commercial Pilots'); INSERT INTO `soc_codes` VALUES (1282, 53, 2020, 'Air Traffic Controllers and Airfield Operations Specialists'); INSERT INTO `soc_codes` VALUES (1283, 53, 2021, 'Air Traffic Controllers'); INSERT INTO `soc_codes` VALUES (1284, 53, 2022, 'Airfield Operations Specialists'); INSERT INTO `soc_codes` VALUES (1285, 53, 3000, 'Motor Vehicle Operators'); INSERT INTO `soc_codes` VALUES (1286, 53, 3010, 'Ambulance Drivers and Attendants, Except Emergency Medical Technicians'); INSERT INTO `soc_codes` VALUES (1287, 53, 3011, 'Ambulance Drivers and Attendants, Except Emergency Medical Technicians'); INSERT INTO `soc_codes` VALUES (1288, 53, 3020, 'Bus Drivers'); INSERT INTO `soc_codes` VALUES (1289, 53, 3021, 'Bus Drivers, Transit and Intercity'); INSERT INTO `soc_codes` VALUES (1290, 53, 3022, 'Bus Drivers, School'); INSERT INTO `soc_codes` VALUES (1291, 53, 3030, 'Driver/Sales Workers and Truck Drivers'); INSERT INTO `soc_codes` VALUES (1292, 53, 3031, 'Driver/Sales Workers'); INSERT INTO `soc_codes` VALUES (1293, 53, 3032, 'Truck Drivers, Heavy and Tractor-Trailer'); INSERT INTO `soc_codes` VALUES (1294, 53, 3033, 'Truck Drivers, Light or Delivery Services'); INSERT INTO `soc_codes` VALUES (1295, 53, 3040, 'Taxi Drivers and Chauffeurs'); INSERT INTO `soc_codes` VALUES (1296, 53, 3041, 'Taxi Drivers and Chauffeurs'); INSERT INTO `soc_codes` VALUES (1297, 53, 3090, 'Miscellaneous Motor Vehicle Operators'); INSERT INTO `soc_codes` VALUES (1298, 53, 3099, 'Motor Vehicle Operators, All Other'); INSERT INTO `soc_codes` VALUES (1299, 53, 4000, 'Rail Transportation Workers'); INSERT INTO `soc_codes` VALUES (1300, 53, 4010, 'Locomotive Engineers and Operators'); INSERT INTO `soc_codes` VALUES (1301, 53, 4011, 'Locomotive Engineers'); INSERT INTO `soc_codes` VALUES (1302, 53, 4012, 'Locomotive Firers'); INSERT INTO `soc_codes` VALUES (1303, 53, 4013, 'Rail Yard Engineers, Dinkey Operators, and Hostlers'); INSERT INTO `soc_codes` VALUES (1304, 53, 4020, 'Railroad Brake, Signal, and Switch Operators'); INSERT INTO `soc_codes` VALUES (1305, 53, 4021, 'Railroad Brake, Signal, and Switch Operators'); INSERT INTO `soc_codes` VALUES (1306, 53, 4030, 'Railroad Conductors and Yardmasters'); INSERT INTO `soc_codes` VALUES (1307, 53, 4031, 'Railroad Conductors and Yardmasters'); INSERT INTO `soc_codes` VALUES (1308, 53, 4040, 'Subway and Streetcar Operators'); INSERT INTO `soc_codes` VALUES (1309, 53, 4041, 'Subway and Streetcar Operators'); INSERT INTO `soc_codes` VALUES (1310, 53, 4090, 'Miscellaneous Rail Transportation Workers'); INSERT INTO `soc_codes` VALUES (1311, 53, 4099, 'Rail Transportation Workers, All Other'); INSERT INTO `soc_codes` VALUES (1312, 53, 5000, 'Water Transportation Workers'); INSERT INTO `soc_codes` VALUES (1313, 53, 5010, 'Sailors and Marine Oilers'); INSERT INTO `soc_codes` VALUES (1314, 53, 5011, 'Sailors and Marine Oilers'); INSERT INTO `soc_codes` VALUES (1315, 53, 5020, 'Ship and Boat Captains and Operators'); INSERT INTO `soc_codes` VALUES (1316, 53, 5021, 'Captains, Mates, and Pilots of Water Vessels'); INSERT INTO `soc_codes` VALUES (1317, 53, 5022, 'Motorboat Operators'); INSERT INTO `soc_codes` VALUES (1318, 53, 5030, 'Ship Engineers'); INSERT INTO `soc_codes` VALUES (1319, 53, 5031, 'Ship Engineers'); INSERT INTO `soc_codes` VALUES (1320, 53, 6000, 'Other Transportation Workers'); INSERT INTO `soc_codes` VALUES (1321, 53, 6010, 'Bridge and Lock Tenders'); INSERT INTO `soc_codes` VALUES (1322, 53, 6011, 'Bridge and Lock Tenders'); INSERT INTO `soc_codes` VALUES (1323, 53, 6020, 'Parking Lot Attendants'); INSERT INTO `soc_codes` VALUES (1324, 53, 6021, 'Parking Lot Attendants'); INSERT INTO `soc_codes` VALUES (1325, 53, 6030, 'Service Station Attendants'); INSERT INTO `soc_codes` VALUES (1326, 53, 6031, 'Service Station Attendants'); INSERT INTO `soc_codes` VALUES (1327, 53, 6040, 'Traffic Technicians'); INSERT INTO `soc_codes` VALUES (1328, 53, 6041, 'Traffic Technicians'); INSERT INTO `soc_codes` VALUES (1329, 53, 6050, 'Transportation Inspectors'); INSERT INTO `soc_codes` VALUES (1330, 53, 6051, 'Transportation Inspectors'); INSERT INTO `soc_codes` VALUES (1331, 53, 6090, 'Miscellaneous Transportation Workers'); INSERT INTO `soc_codes` VALUES (1332, 53, 6099, 'Transportation Workers, All Other'); INSERT INTO `soc_codes` VALUES (1333, 53, 7000, 'Material Moving Workers'); INSERT INTO `soc_codes` VALUES (1334, 53, 7010, 'Conveyor Operators and Tenders'); INSERT INTO `soc_codes` VALUES (1335, 53, 7011, 'Conveyor Operators and Tenders'); INSERT INTO `soc_codes` VALUES (1336, 53, 7020, 'Crane and Tower Operators'); INSERT INTO `soc_codes` VALUES (1337, 53, 7021, 'Crane and Tower Operators'); INSERT INTO `soc_codes` VALUES (1338, 53, 7030, 'Dredge, Excavating, and Loading Machine Operators'); INSERT INTO `soc_codes` VALUES (1339, 53, 7031, 'Dredge Operators'); INSERT INTO `soc_codes` VALUES (1340, 53, 7032, 'Excavating and Loading Machine and Dragline Operators'); INSERT INTO `soc_codes` VALUES (1341, 53, 7033, 'Loading Machine Operators, Underground Mining'); INSERT INTO `soc_codes` VALUES (1342, 53, 7040, 'Hoist and Winch Operators'); INSERT INTO `soc_codes` VALUES (1343, 53, 7041, 'Hoist and Winch Operators'); INSERT INTO `soc_codes` VALUES (1344, 53, 7050, 'Industrial Truck and Tractor Operators'); INSERT INTO `soc_codes` VALUES (1345, 53, 7051, 'Industrial Truck and Tractor Operators'); INSERT INTO `soc_codes` VALUES (1346, 53, 7060, 'Laborers and Material Movers, Hand'); INSERT INTO `soc_codes` VALUES (1347, 53, 7061, 'Cleaners of Vehicles and Equipment'); INSERT INTO `soc_codes` VALUES (1348, 53, 7062, 'Laborers and Freight, Stock, and Material Movers, Hand'); INSERT INTO `soc_codes` VALUES (1349, 53, 7063, 'Machine Feeders and Offbearers'); INSERT INTO `soc_codes` VALUES (1350, 53, 7064, 'Packers and Packagers, Hand'); INSERT INTO `soc_codes` VALUES (1351, 53, 7070, 'Pumping Station Operators'); INSERT INTO `soc_codes` VALUES (1352, 53, 7071, 'Gas Compressor and Gas Pumping Station Operators'); INSERT INTO `soc_codes` VALUES (1353, 53, 7072, 'Pump Operators, Except Wellhead Pumpers'); INSERT INTO `soc_codes` VALUES (1354, 53, 7073, 'Wellhead Pumpers'); INSERT INTO `soc_codes` VALUES (1355, 53, 7080, 'Refuse and Recyclable Material Collectors'); INSERT INTO `soc_codes` VALUES (1356, 53, 7081, 'Refuse and Recyclable Material Collectors'); INSERT INTO `soc_codes` VALUES (1357, 53, 7110, 'Shuttle Car Operators'); INSERT INTO `soc_codes` VALUES (1358, 53, 7111, 'Shuttle Car Operators'); INSERT INTO `soc_codes` VALUES (1359, 53, 7120, 'Tank Car, Truck, and Ship Loaders'); INSERT INTO `soc_codes` VALUES (1360, 53, 7121, 'Tank Car, Truck, and Ship Loaders'); INSERT INTO `soc_codes` VALUES (1361, 53, 7190, 'Miscellaneous Material Moving Workers'); INSERT INTO `soc_codes` VALUES (1362, 53, 7199, 'Material Moving Workers, All Other'); INSERT INTO `soc_codes` VALUES (1363, 55, 0, 'Military Specific Occupations'); INSERT INTO `soc_codes` VALUES (1364, 55, 1000, 'Military Officer Special and Tactical Operations Leaders/Managers'); INSERT INTO `soc_codes` VALUES (1365, 55, 1010, 'Military Officer Special and Tactical Operations Leaders/Managers'); INSERT INTO `soc_codes` VALUES (1366, 55, 1011, 'Air Crew Officers'); INSERT INTO `soc_codes` VALUES (1367, 55, 1012, 'Aircraft Launch and Recovery Officers'); INSERT INTO `soc_codes` VALUES (1368, 55, 1013, 'Armored Assault Vehicle Officers'); INSERT INTO `soc_codes` VALUES (1369, 55, 1014, 'Artillery and Missile Officers'); INSERT INTO `soc_codes` VALUES (1370, 55, 1015, 'Command and Control Center Officers'); INSERT INTO `soc_codes` VALUES (1371, 55, 1016, 'Infantry Officers'); INSERT INTO `soc_codes` VALUES (1372, 55, 1017, 'Special Forces Officers'); INSERT INTO `soc_codes` VALUES (1373, 55, 1019, 'Military Officer Special and Tactical Operations Leaders/Managers, All Other'); INSERT INTO `soc_codes` VALUES (1374, 55, 2000, 'First-Line Enlisted Military Supervisor/Managers'); INSERT INTO `soc_codes` VALUES (1375, 55, 2010, 'First-Line Enlisted Military Supervisors/Managers'); INSERT INTO `soc_codes` VALUES (1376, 55, 2011, 'First-Line Supervisors/Managers of Air Crew Members'); INSERT INTO `soc_codes` VALUES (1377, 55, 2012, 'First-Line Supervisors/Managers of Weapons Specialists/Crew Members'); INSERT INTO `soc_codes` VALUES (1378, 55, 2013, 'First-Line Supervisors/Managers of All Other Tactical Operations Specialists'); INSERT INTO `soc_codes` VALUES (1379, 55, 3000, 'Military Enlisted Tactical Operations and Air/Weapons Specialists and Crew Members'); INSERT INTO `soc_codes` VALUES (1380, 55, 3010, 'Military Enlisted Tactical Operations and Air/Weapons Specialists and Crew Members'); INSERT INTO `soc_codes` VALUES (1381, 55, 3011, 'Air Crew Members'); INSERT INTO `soc_codes` VALUES (1382, 55, 3012, 'Aircraft Launch and Recovery Specialists'); INSERT INTO `soc_codes` VALUES (1383, 55, 3013, 'Armored Assault Vehicle Crew Members'); INSERT INTO `soc_codes` VALUES (1384, 55, 3014, 'Artillery and Missile Crew Members'); INSERT INTO `soc_codes` VALUES (1385, 55, 3015, 'Command and Control Center Specialists'); INSERT INTO `soc_codes` VALUES (1386, 55, 3016, 'Infantry'); INSERT INTO `soc_codes` VALUES (1387, 55, 3017, 'Radar and Sonar Technicians'); INSERT INTO `soc_codes` VALUES (1388, 55, 3018, 'Special Forces'); INSERT INTO `soc_codes` VALUES (1389, 55, 3019, 'Military Enlisted Tactical Operations and Air/Weapons Specialists and Crew Members, All Other');