002-import-2011-data.sql

--
-- Prep weekly_earnings table for import
--

DELETE FROM weekly_earnings;

ALTER TABLE weekly_earnings ALTER COLUMN median_weekly_earnings TYPE varchar;

ALTER TABLE weekly_earnings ALTER COLUMN men_median_weekly_earnings TYPE varchar;

ALTER TABLE weekly_earnings ALTER COLUMN women_median_weekly_earnings TYPE varchar;


--
-- Insert 2011 data
--


INSERT INTO "public"."weekly_earnings" ("occupation", "slug", "parent", "total_number_workers", "median_weekly_earnings", "men_number_workers", "men_median_weekly_earnings", "women_number_workers", "women_median_weekly_earnings", "year") VALUES
('Total, full-time wage and salary workers', 'total-full-time-wage-and-salary-workers', '', '100,457', '756', '55,971', '832', '44,486', '684', '2011'),
('Management, professional, and related occupations', 'management-professional-and-related-occupations', '', '39,791', '1,082', '19,267', '1,269', '20,524', '941', '2011'),
('Management, business, and financial operations occupations', 'management-business-and-financial-operations-occupations', 'management-professional-and-related-occupations', '16,061', '1,160', '8,676', '1,370', '7,386', '977', '2011'),
('Management occupations', 'management-occupations', 'management-business-and-financial-operations-occupations', '10,891', '1,237', '6,451', '1,427', '4,440', '1,018', '2011'),
('Chief executives', 'chief-executives', 'management-occupations', '990', '1,963', '745', '2,122', '245', '1,464', '2011'),
('General and operations managers', 'general-and-operations-managers', 'management-occupations', '921', '1,191', '651', '1,319', '270', '972', '2011'),
('Legislators', 'legislators', 'management-occupations', '13', '-', '9', '-', '4', '-', '2011'),
('Advertising and promotions managers', 'advertising-and-promotions-managers', 'management-occupations', '68', '1,164', '28', '-', '40', '-', '2011'),
('Marketing and sales managers', 'marketing-and-sales-managers', 'management-occupations', '891', '1,408', '499', '1,660', '392', '1,127', '2011'),
('Public relations and fundraising managers', 'public-relations-and-fundraising-managers', 'management-occupations', '62', '1,475', '33', '-', '29', '-', '2011'),
('Administrative services managers', 'administrative-services-managers', 'management-occupations', '115', '1,021', '71', '1,170', '44', '-', '2011'),
('Computer and information systems managers', 'computer-and-information-systems-managers', 'management-occupations', '530', '1,579', '392', '1,595', '138', '1,543', '2011'),
('Financial managers', 'financial-managers', 'management-occupations', '1,044', '1,166', '477', '1,504', '567', '991', '2011'),
('Compensation and benefits managers', 'compensation-and-benefits-managers', 'management-occupations', '21', '-', '7', '-', '14', '-', '2011'),
('Human resources managers', 'human-resources-managers', 'management-occupations', '207', '1,331', '58', '1,488', '149', '1,273', '2011'),
('Training and development managers', 'training-and-development-managers', 'management-occupations', '36', '-', '24', '-', '12', '-', '2011'),
('Industrial production managers', 'industrial-production-managers', 'management-occupations', '250', '1,211', '204', '1,245', '45', '-', '2011'),
('Purchasing managers', 'purchasing-managers', 'management-occupations', '183', '1,242', '94', '1,368', '89', '1,026', '2011'),
('Transportation, storage, and distribution managers', 'transportation-storage-and-distribution-managers', 'management-occupations', '229', '882', '196', '861', '33', '-', '2011'),
('Farmers, ranchers, and other agricultural managers', 'farmers-ranchers-and-other-agricultural-managers', 'management-occupations', '98', '800', '81', '855', '17', '-', '2011'),
('Construction managers', 'construction-managers', 'management-occupations', '464', '1,268', '433', '1,325', '31', '-', '2011'),
('Education administrators', 'education-administrators', 'management-occupations', '735', '1,228', '268', '1,532', '467', '1,061', '2011'),
('Architectural and engineering managers', 'architectural-and-engineering-managers', 'management-occupations', '98', '1,914', '91', '1,908', '7', '-', '2011'),
('Food service managers', 'food-service-managers', 'management-occupations', '675', '660', '361', '734', '314', '599', '2011'),
('Funeral service managers', 'funeral-service-managers', 'management-occupations', '8', '-', '4', '-', '5', '-', '2011'),
('Gaming managers', 'gaming-managers', 'management-occupations', '22', '-', '15', '-', '7', '-', '2011'),
('Lodging managers', 'lodging-managers', 'management-occupations', '91', '883', '36', '-', '55', '841', '2011'),
('Medical and health services managers', 'medical-and-health-services-managers', 'management-occupations', '450', '1,252', '125', '1,456', '325', '1,166', '2011'),
('Natural sciences managers', 'natural-sciences-managers', 'management-occupations', '12', '-', '5', '-', '7', '-', '2011'),
('Postmasters and mail superintendents', 'postmasters-and-mail-superintendents', 'management-occupations', '29', '-', '10', '-', '19', '-', '2011'),
('Property, real estate, and community association managers', 'property-real-estate-and-community-association-managers', 'management-occupations', '317', '921', '135', '1,201', '182', '728', '2011'),
('Social and community service managers', 'social-and-community-service-managers', 'management-occupations', '277', '1,045', '81', '1,221', '196', '973', '2011'),
('Emergency management directors', 'emergency-management-directors', 'management-occupations', '5', '-', '4', '-', '1', '-', '2011'),
('Managers, all other', 'managers-all-other', 'management-occupations', '2,050', '1,265', '1,313', '1,406', '737', '1,047', '2011'),
('Business and financial operations occupations', 'business-and-financial-operations-occupations', 'management-business-and-financial-operations-occupations', '5,170', '1,038', '2,225', '1,225', '2,946', '937', '2011'),
('Agents and business managers of artists, performers, and athletes', 'agents-and-business-managers-of-artists-performers-and-athletes', 'business-and-financial-operations-occupations', '25', '-', '12', '-', '13', '-', '2011'),
('Buyers and purchasing agents, farm products', 'buyers-and-purchasing-agents-farm-products', 'business-and-financial-operations-occupations', '7', '-', '5', '-', '2', '-', '2011'),
('Wholesale and retail buyers, except farm products', 'wholesale-and-retail-buyers-except-farm-products', 'business-and-financial-operations-occupations', '130', '882', '68', '928', '62', '849', '2011'),
('Purchasing agents, except wholesale, retail, and farm products', 'purchasing-agents-except-wholesale-retail-and-farm-products', 'business-and-financial-operations-occupations', '226', '1,015', '108', '1,129', '118', '945', '2011'),
('Claims adjusters, appraisers, examiners, and investigators', 'claims-adjusters-appraisers-examiners-and-investigators', 'business-and-financial-operations-occupations', '271', '913', '110', '1,077', '162', '804', '2011'),
('Compliance officers', 'compliance-officers', 'business-and-financial-operations-occupations', '176', '1,125', '98', '1,279', '78', '995', '2011'),
('Cost estimators', 'cost-estimators', 'business-and-financial-operations-occupations', '106', '1,080', '87', '1,117', '19', '-', '2011'),
('Human resources workers', 'human-resources-workers', 'business-and-financial-operations-occupations', '522', '938', '116', '1,053', '406', '912', '2011'),
('Compensation, benefits, and job analysis specialists', 'compensation-benefits-and-job-analysis-specialists', 'business-and-financial-operations-occupations', '53', '893', '13', '-', '39', '-', '2011'),
('Training and development specialists', 'training-and-development-specialists', 'business-and-financial-operations-occupations', '117', '1,059', '53', '1,260', '64', '951', '2011'),
('Logisticians', 'logisticians', 'business-and-financial-operations-occupations', '77', '864', '50', '938', '27', '-', '2011'),
('Management analysts', 'management-analysts', 'business-and-financial-operations-occupations', '458', '1,355', '250', '1,514', '208', '1,174', '2011'),
('Meeting, convention, and event planners', 'meeting-convention-and-event-planners', 'business-and-financial-operations-occupations', '87', '889', '16', '-', '71', '892', '2011'),
('Fundraisers', 'fundraisers', 'business-and-financial-operations-occupations', '56', '1,064', '14', '-', '42', '-', '2011'),
('Market research analysts and marketing specialists', 'market-research-analysts-and-marketing-specialists', 'business-and-financial-operations-occupations', '167', '1,157', '66', '1,446', '101', '1,029', '2011'),
('Business operations specialists, all other', 'business-operations-specialists-all-other', 'business-and-financial-operations-occupations', '238', '991', '88', '1,185', '149', '908', '2011'),
('Accountants and auditors', 'accountants-and-auditors', 'business-and-financial-operations-occupations', '1,383', '1,056', '532', '1,250', '852', '956', '2011'),
('Appraisers and assessors of real estate', 'appraisers-and-assessors-of-real-estate', 'business-and-financial-operations-occupations', '50', '990', '30', '-', '20', '-', '2011'),
('Budget analysts', 'budget-analysts', 'business-and-financial-operations-occupations', '52', '1,174', '22', '-', '30', '-', '2011'),
('Credit analysts', 'credit-analysts', 'business-and-financial-operations-occupations', '21', '-', '9', '-', '12', '-', '2011'),
('Financial analysts', 'financial-analysts', 'business-and-financial-operations-occupations', '63', '1,737', '40', '-', '22', '-', '2011'),
('Personal financial advisors', 'personal-financial-advisors', 'business-and-financial-operations-occupations', '270', '1,239', '173', '1,535', '97', '941', '2011'),
('Insurance underwriters', 'insurance-underwriters', 'business-and-financial-operations-occupations', '108', '970', '44', '-', '64', '939', '2011'),
('Financial examiners', 'financial-examiners', 'business-and-financial-operations-occupations', '7', '-', '2', '-', '5', '-', '2011'),
('Credit counselors and loan officers', 'credit-counselors-and-loan-officers', 'business-and-financial-operations-occupations', '306', '1,024', '147', '1,345', '159', '829', '2011'),
('Tax examiners and collectors, and revenue agents', 'tax-examiners-and-collectors-and-revenue-agents', 'business-and-financial-operations-occupations', '67', '920', '27', '-', '40', '-', '2011'),
('Tax preparers', 'tax-preparers', 'business-and-financial-operations-occupations', '55', '701', '13', '-', '41', '-', '2011'),
('Financial specialists, all other', 'financial-specialists-all-other', 'business-and-financial-operations-occupations', '72', '913', '30', '-', '41', '-', '2011'),
('Professional and related occupations', 'professional-and-related-occupations', 'management-professional-and-related-occupations', '23,730', '1,029', '10,592', '1,211', '13,139', '919', '2011'),
('Computer and mathematical occupations', 'computer-and-mathematical-occupations', 'professional-and-related-occupations', '3,296', '1,305', '2,509', '1,369', '787', '1,126', '2011'),
('Computer and information research scientists', 'computer-and-information-research-scientists', 'computer-and-mathematical-occupations', '19', '-', '17', '-', '2', '-', '2011'),
('Computer systems analysts', 'computer-systems-analysts', 'computer-and-mathematical-occupations', '373', '1,328', '242', '1,410', '132', '1,144', '2011'),
('Information security analysts', 'information-security-analysts', 'computer-and-mathematical-occupations', '45', '-', '38', '-', '7', '-', '2011'),
('Computer programmers', 'computer-programmers', 'computer-and-mathematical-occupations', '411', '1,277', '329', '1,330', '83', '1,238', '2011'),
('Software developers, applications and systems software', 'software-developers-applications-and-systems-software', 'computer-and-mathematical-occupations', '990', '1,558', '812', '1,606', '179', '1,388', '2011'),
('Web developers', 'web-developers', 'computer-and-mathematical-occupations', '117', '1,017', '81', '1,033', '35', '-', '2011'),
('Computer support specialists', 'computer-support-specialists', 'computer-and-mathematical-occupations', '434', '915', '326', '896', '107', '951', '2011'),
('Database administrators', 'database-administrators', 'computer-and-mathematical-occupations', '138', '1,238', '90', '1,470', '48', '-', '2011'),
('Network and computer systems administrators', 'network-and-computer-systems-administrators', 'computer-and-mathematical-occupations', '221', '1,180', '172', '1,243', '49', '-', '2011'),
('Computer network architects', 'computer-network-architects', 'computer-and-mathematical-occupations', '94', '1,441', '81', '1,585', '12', '-', '2011'),
('Computer occupations, all other', 'computer-occupations-all-other', 'computer-and-mathematical-occupations', '282', '1,127', '221', '1,165', '61', '998', '2011'),
('Actuaries', 'actuaries', 'computer-and-mathematical-occupations', '17', '-', '12', '-', '5', '-', '2011'),
('Mathematicians', 'mathematicians', 'computer-and-mathematical-occupations', '2', '-', '1', '-', '1', '-', '2011'),
('Operations research analysts', 'operations-research-analysts', 'computer-and-mathematical-occupations', '116', '1,273', '66', '1,258', '51', '1,326', '2011'),
('Statisticians', 'statisticians', 'computer-and-mathematical-occupations', '30', '-', '17', '-', '13', '-', '2011'),
('Miscellaneous mathematical science occupations', 'miscellaneous-mathematical-science-occupations', 'computer-and-mathematical-occupations', '6', '-', '5', '-', '2', '-', '2011'),
('Architecture and engineering occupations', 'architecture-and-engineering-occupations', 'professional-and-related-occupations', '2,494', '1,315', '2,178', '1,343', '316', '1,140', '2011'),
('Architects, except naval', 'architects-except-naval', 'architecture-and-engineering-occupations', '113', '1,325', '92', '1,351', '21', '-', '2011'),
('Surveyors, cartographers, and photogrammetrists', 'surveyors-cartographers-and-photogrammetrists', 'architecture-and-engineering-occupations', '31', '-', '26', '-', '5', '-', '2011'),
('Aerospace engineers', 'aerospace-engineers', 'architecture-and-engineering-occupations', '134', '1,621', '119', '1,745', '16', '-', '2011'),
('Agricultural engineers', 'agricultural-engineers', 'architecture-and-engineering-occupations', '1', '-', '1', '-', '0', '-', '2011'),
('Biomedical engineers', 'biomedical-engineers', 'architecture-and-engineering-occupations', '12', '-', '10', '-', '2', '-', '2011'),
('Chemical engineers', 'chemical-engineers', 'architecture-and-engineering-occupations', '73', '1,757', '57', '1,885', '16', '-', '2011'),
('Civil engineers', 'civil-engineers', 'architecture-and-engineering-occupations', '335', '1,398', '289', '1,436', '46', '-', '2011'),
('Computer hardware engineers', 'computer-hardware-engineers', 'architecture-and-engineering-occupations', '76', '1,528', '66', '1,546', '10', '-', '2011'),
('Electrical and electronics engineers', 'electrical-and-electronics-engineers', 'architecture-and-engineering-occupations', '283', '1,442', '256', '1,455', '26', '-', '2011'),
('Environmental engineers', 'environmental-engineers', 'architecture-and-engineering-occupations', '36', '-', '26', '-', '10', '-', '2011'),
('Industrial engineers, including health and safety', 'industrial-engineers-including-health-and-safety', 'architecture-and-engineering-occupations', '178', '1,336', '143', '1,356', '34', '-', '2011'),
('Marine engineers and naval architects', 'marine-engineers-and-naval-architects', 'architecture-and-engineering-occupations', '6', '-', '6', '-', '1', '-', '2011'),
('Materials engineers', 'materials-engineers', 'architecture-and-engineering-occupations', '30', '-', '26', '-', '4', '-', '2011'),
('Mechanical engineers', 'mechanical-engineers', 'architecture-and-engineering-occupations', '306', '1,374', '290', '1,399', '16', '-', '2011'),
('Mining and geological engineers, including mining safety engineers', 'mining-and-geological-engineers-including-mining-safety-engineers', 'architecture-and-engineering-occupations', '9', '-', '8', '-', '1', '-', '2011'),
('Nuclear engineers', 'nuclear-engineers', 'architecture-and-engineering-occupations', '23', '-', '20', '-', '2', '-', '2011'),
('Petroleum engineers', 'petroleum-engineers', 'architecture-and-engineering-occupations', '19', '-', '18', '-', '1', '-', '2011'),
('Engineers, all other', 'engineers-all-other', 'architecture-and-engineering-occupations', '310', '1,366', '275', '1,361', '35', '-', '2011'),
('Drafters', 'drafters', 'architecture-and-engineering-occupations', '124', '941', '102', '1,052', '23', '-', '2011'),
('Engineering technicians, except drafters', 'engineering-technicians-except-drafters', 'architecture-and-engineering-occupations', '341', '954', '301', '952', '40', '-', '2011'),
('Surveying and mapping technicians', 'surveying-and-mapping-technicians', 'architecture-and-engineering-occupations', '53', '777', '47', '-', '6', '-', '2011'),
('Life, physical, and social science occupations', 'life-physical-and-social-science-occupations', 'professional-and-related-occupations', '1,043', '1,108', '565', '1,156', '479', '1,038', '2011'),
('Agricultural and food scientists', 'agricultural-and-food-scientists', 'life-physical-and-social-science-occupations', '27', '-', '17', '-', '10', '-', '2011'),
('Biological scientists', 'biological-scientists', 'life-physical-and-social-science-occupations', '103', '1,031', '53', '1,177', '50', '853', '2011'),
('Conservation scientists and foresters', 'conservation-scientists-and-foresters', 'life-physical-and-social-science-occupations', '22', '-', '18', '-', '4', '-', '2011'),
('Medical scientists', 'medical-scientists', 'life-physical-and-social-science-occupations', '141', '1,109', '64', '1,102', '78', '1,127', '2011'),
('Astronomers and physicists', 'astronomers-and-physicists', 'life-physical-and-social-science-occupations', '18', '-', '15', '-', '4', '-', '2011'),
('Atmospheric and space scientists', 'atmospheric-and-space-scientists', 'life-physical-and-social-science-occupations', '7', '-', '6', '-', '1', '-', '2011'),
('Chemists and materials scientists', 'chemists-and-materials-scientists', 'life-physical-and-social-science-occupations', '83', '1,169', '45', '-', '38', '-', '2011'),
('Environmental scientists and geoscientists', 'environmental-scientists-and-geoscientists', 'life-physical-and-social-science-occupations', '86', '1,383', '61', '1,408', '25', '-', '2011'),
('Physical scientists, all other', 'physical-scientists-all-other', 'life-physical-and-social-science-occupations', '133', '1,383', '82', '1,483', '51', '1,167', '2011'),
('Economists', 'economists', 'life-physical-and-social-science-occupations', '20', '-', '12', '-', '8', '-', '2011'),
('Survey researchers', 'survey-researchers', 'life-physical-and-social-science-occupations', '1', '-', '0', '-', '0', '-', '2011'),
('Psychologists', 'psychologists', 'life-physical-and-social-science-occupations', '104', '1,229', '31', '-', '74', '1,244', '2011'),
('Sociologists', 'sociologists', 'life-physical-and-social-science-occupations', '2', '-', '0', '-', '2', '-', '2011'),
('Urban and regional planners', 'urban-and-regional-planners', 'life-physical-and-social-science-occupations', '19', '-', '10', '-', '9', '-', '2011'),
('Miscellaneous social scientists and related workers', 'miscellaneous-social-scientists-and-related-workers', 'life-physical-and-social-science-occupations', '48', '-', '19', '-', '29', '-', '2011'),
('Agricultural and food science technicians', 'agricultural-and-food-science-technicians', 'life-physical-and-social-science-occupations', '13', '-', '7', '-', '6', '-', '2011'),
('Biological technicians', 'biological-technicians', 'life-physical-and-social-science-occupations', '19', '-', '10', '-', '9', '-', '2011'),
('Chemical technicians', 'chemical-technicians', 'life-physical-and-social-science-occupations', '69', '788', '40', '-', '29', '-', '2011'),
('Geological and petroleum technicians', 'geological-and-petroleum-technicians', 'life-physical-and-social-science-occupations', '6', '-', '3', '-', '3', '-', '2011'),
('Nuclear technicians', 'nuclear-technicians', 'life-physical-and-social-science-occupations', '3', '-', '2', '-', '1', '-', '2011'),
('Social science research assistants', 'social-science-research-assistants', 'life-physical-and-social-science-occupations', '1', '-', '1', '-', '0', '-', '2011'),
('Miscellaneous life, physical, and social science technicians', 'miscellaneous-life-physical-and-social-science-technicians', 'life-physical-and-social-science-occupations', '118', '763', '69', '807', '49', '-', '2011'),
('Community and social service occupations', 'community-and-social-service-occupations', 'professional-and-related-occupations', '1,931', '813', '728', '906', '1,202', '772', '2011'),
('Counselors', 'counselors', 'community-and-social-service-occupations', '568', '828', '188', '874', '380', '808', '2011'),
('Social workers', 'social-workers', 'community-and-social-service-occupations', '684', '817', '130', '902', '554', '798', '2011'),
('Probation officers and correctional treatment specialists', 'probation-officers-and-correctional-treatment-specialists', 'community-and-social-service-occupations', '86', '822', '41', '-', '44', '-', '2011'),
('Social and human service assistants', 'social-and-human-service-assistants', 'community-and-social-service-occupations', '105', '597', '21', '-', '83', '597', '2011'),
('Miscellaneous community and social service specialists, including health educators and community health workers', 'miscellaneous-community-and-social-service-specialists-including-health-educators-and-community-health-workers', 'community-and-social-service-occupations', '62', '676', '23', '-', '39', '-', '2011'),
('Clergy', 'clergy', 'community-and-social-service-occupations', '343', '945', '292', '961', '51', '889', '2011'),
('Directors, religious activities and education', 'directors-religious-activities-and-education', 'community-and-social-service-occupations', '34', '-', '10', '-', '25', '-', '2011'),
('Religious workers, all other', 'religious-workers-all-other', 'community-and-social-service-occupations', '50', '654', '24', '-', '26', '-', '2011'),
('Legal occupations', 'legal-occupations', 'professional-and-related-occupations', '1,259', '1,277', '583', '1,758', '676', '1,003', '2011'),
('Lawyers', 'lawyers', 'legal-occupations', '704', '1,774', '462', '1,884', '242', '1,631', '2011'),
('Judicial law clerks', 'judicial-law-clerks', 'legal-occupations', '4', '-', '1', '-', '3', '-', '2011'),
('Judges, magistrates, and other judicial workers', 'judges-magistrates-and-other-judicial-workers', 'legal-occupations', '58', '1,655', '32', '-', '26', '-', '2011'),
('Paralegals and legal assistants', 'paralegals-and-legal-assistants', 'legal-occupations', '338', '824', '52', '884', '286', '813', '2011'),
('Miscellaneous legal support workers', 'miscellaneous-legal-support-workers', 'legal-occupations', '155', '815', '35', '-', '120', '788', '2011'),
('Education, training, and library occupations', 'education-training-and-library-occupations', 'professional-and-related-occupations', '6,518', '919', '1,749', '1,109', '4,769', '869', '2011'),
('Postsecondary teachers', 'postsecondary-teachers', 'education-training-and-library-occupations', '925', '1,209', '526', '1,358', '399', '1,093', '2011'),
('Preschool and kindergarten teachers', 'preschool-and-kindergarten-teachers', 'education-training-and-library-occupations', '532', '606', '13', '-', '519', '603', '2011'),
('Elementary and middle school teachers', 'elementary-and-middle-school-teachers', 'education-training-and-library-occupations', '2,436', '947', '463', '1,022', '1,973', '933', '2011'),
('Secondary school teachers', 'secondary-school-teachers', 'education-training-and-library-occupations', '1,005', '1,015', '431', '1,049', '575', '989', '2011'),
('Special education teachers', 'special-education-teachers', 'education-training-and-library-occupations', '364', '939', '55', '967', '308', '935', '2011'),
('Other teachers and instructors', 'other-teachers-and-instructors', 'education-training-and-library-occupations', '368', '858', '163', '1,105', '205', '739', '2011'),
('Archivists, curators, and museum technicians', 'archivists-curators-and-museum-technicians', 'education-training-and-library-occupations', '38', '-', '12', '-', '26', '-', '2011'),
('Librarians', 'librarians', 'education-training-and-library-occupations', '139', '850', '21', '-', '118', '813', '2011'),
('Library technicians', 'library-technicians', 'education-training-and-library-occupations', '13', '-', '3', '-', '10', '-', '2011'),
('Teacher assistants', 'teacher-assistants', 'education-training-and-library-occupations', '605', '480', '39', '-', '566', '471', '2011'),
('Other education, training, and library workers', 'other-education-training-and-library-workers', 'education-training-and-library-occupations', '94', '982', '23', '-', '71', '979', '2011'),
('Sales and related workers, all other', 'sales-and-related-workers-all-other', 'sales-and-related-occupations', '140', '781', '76', '985', '64', '618', '2011'),
('Arts, design, entertainment, sports, and media occupations', 'arts-design-entertainment-sports-and-media-occupations', 'professional-and-related-occupations', '1,464', '929', '850', '995', '613', '856', '2011'),
('Artists and related workers', 'artists-and-related-workers', 'arts-design-entertainment-sports-and-media-occupations', '56', '1,115', '36', '-', '21', '-', '2011'),
('Designers', 'designers', 'arts-design-entertainment-sports-and-media-occupations', '458', '950', '257', '1,045', '201', '816', '2011'),
('Actors', 'actors', 'arts-design-entertainment-sports-and-media-occupations', '8', '-', '6', '-', '2', '-', '2011'),
('Producers and directors', 'producers-and-directors', 'arts-design-entertainment-sports-and-media-occupations', '105', '1,023', '58', '1,130', '47', '-', '2011'),
('Athletes, coaches, umpires, and related workers', 'athletes-coaches-umpires-and-related-workers', 'arts-design-entertainment-sports-and-media-occupations', '109', '825', '84', '919', '25', '-', '2011'),
('Dancers and choreographers', 'dancers-and-choreographers', 'arts-design-entertainment-sports-and-media-occupations', '6', '-', '3', '-', '3', '-', '2011'),
('Musicians, singers, and related workers', 'musicians-singers-and-related-workers', 'arts-design-entertainment-sports-and-media-occupations', '35', '-', '29', '-', '5', '-', '2011'),
('Entertainers and performers, sports and related workers, all other', 'entertainers-and-performers-sports-and-related-workers-all-other', 'arts-design-entertainment-sports-and-media-occupations', '7', '-', '3', '-', '4', '-', '2011'),
('Announcers', 'announcers', 'arts-design-entertainment-sports-and-media-occupations', '32', '-', '24', '-', '9', '-', '2011'),
('News analysts, reporters and correspondents', 'news-analysts-reporters-and-correspondents', 'arts-design-entertainment-sports-and-media-occupations', '62', '937', '44', '-', '18', '-', '2011'),
('Public relations specialists', 'public-relations-specialists', 'arts-design-entertainment-sports-and-media-occupations', '123', '954', '49', '-', '75', '887', '2011'),
('Editors', 'editors', 'arts-design-entertainment-sports-and-media-occupations', '132', '902', '58', '933', '74', '892', '2011'),
('Technical writers', 'technical-writers', 'arts-design-entertainment-sports-and-media-occupations', '46', '-', '20', '-', '26', '-', '2011'),
('Writers and authors', 'writers-and-authors', 'arts-design-entertainment-sports-and-media-occupations', '85', '918', '42', '-', '43', '-', '2011'),
('Miscellaneous media and communication workers', 'miscellaneous-media-and-communication-workers', 'arts-design-entertainment-sports-and-media-occupations', '47', '-', '15', '-', '32', '-', '2011'),
('Broadcast and sound engineering technicians and radio operators', 'broadcast-and-sound-engineering-technicians-and-radio-operators', 'arts-design-entertainment-sports-and-media-occupations', '79', '857', '73', '872', '6', '-', '2011'),
('Photographers', 'photographers', 'arts-design-entertainment-sports-and-media-occupations', '45', '-', '29', '-', '16', '-', '2011'),
('Television, video, and motion picture camera operators and editors', 'television-video-and-motion-picture-camera-operators-and-editors', 'arts-design-entertainment-sports-and-media-occupations', '27', '-', '22', '-', '5', '-', '2011'),
('Media and communication equipment workers, all other', 'media-and-communication-equipment-workers-all-other', 'arts-design-entertainment-sports-and-media-occupations', '2', '-', '1', '-', '1', '-', '2011'),
('Healthcare practitioners and technical occupations', 'healthcare-practitioners-and-technical-occupations', 'professional-and-related-occupations', '5,725', '995', '1,429', '1,129', '4,296', '965', '2011'),
('Chiropractors', 'chiropractors', 'healthcare-practitioners-and-technical-occupations', '5', '-', '3', '-', '2', '-', '2011'),
('Dentists', 'dentists', 'healthcare-practitioners-and-technical-occupations', '42', '-', '33', '-', '9', '-', '2011'),
('Dietitians and nutritionists', 'dietitians-and-nutritionists', 'healthcare-practitioners-and-technical-occupations', '69', '897', '6', '-', '64', '906', '2011'),
('Optometrists', 'optometrists', 'healthcare-practitioners-and-technical-occupations', '9', '-', '6', '-', '3', '-', '2011'),
('Pharmacists', 'pharmacists', 'healthcare-practitioners-and-technical-occupations', '195', '1,917', '85', '1,998', '110', '1,898', '2011'),
('Physicians and surgeons', 'physicians-and-surgeons', 'healthcare-practitioners-and-technical-occupations', '573', '1,860', '366', '1,935', '206', '1,527', '2011'),
('Physician assistants', 'physician-assistants', 'healthcare-practitioners-and-technical-occupations', '69', '1,220', '24', '-', '44', '-', '2011'),
('Podiatrists', 'podiatrists', 'healthcare-practitioners-and-technical-occupations', '1', '-', '0', '-', '1', '-', '2011'),
('Audiologists', 'audiologists', 'healthcare-practitioners-and-technical-occupations', '14', '-', '4', '-', '10', '-', '2011'),
('Occupational therapists', 'occupational-therapists', 'healthcare-practitioners-and-technical-occupations', '72', '1,189', '10', '-', '62', '1,193', '2011'),
('Physical therapists', 'physical-therapists', 'healthcare-practitioners-and-technical-occupations', '146', '1,322', '59', '1,522', '87', '1,216', '2011'),
('Radiation therapists', 'radiation-therapists', 'healthcare-practitioners-and-technical-occupations', '12', '-', '2', '-', '10', '-', '2011'),
('Recreational therapists', 'recreational-therapists', 'healthcare-practitioners-and-technical-occupations', '10', '-', '3', '-', '7', '-', '2011'),
('Respiratory therapists', 'respiratory-therapists', 'healthcare-practitioners-and-technical-occupations', '126', '997', '53', '966', '73', '1,028', '2011'),
('Speech-language pathologists', 'speech-language-pathologists', 'healthcare-practitioners-and-technical-occupations', '87', '1,075', '3', '-', '84', '1,076', '2011'),
('Exercise physiologists', 'exercise-physiologists', 'healthcare-practitioners-and-technical-occupations', '2', '-', '1', '-', '1', '-', '2011'),
('Therapists, all other', 'therapists-all-other', 'healthcare-practitioners-and-technical-occupations', '83', '885', '19', '-', '64', '869', '2011'),
('Veterinarians', 'veterinarians', 'healthcare-practitioners-and-technical-occupations', '40', '-', '12', '-', '28', '-', '2011'),
('Registered nurses', 'registered-nurses', 'healthcare-practitioners-and-technical-occupations', '2,145', '1,039', '208', '1,081', '1,937', '1,034', '2011'),
('Nurse anesthetists', 'nurse-anesthetists', 'healthcare-practitioners-and-technical-occupations', '26', '-', '16', '-', '10', '-', '2011'),
('Nurse midwives', 'nurse-midwives', 'healthcare-practitioners-and-technical-occupations', '2', '-', '0', '-', '2', '-', '2011'),
('Nurse practitioners', 'nurse-practitioners', 'healthcare-practitioners-and-technical-occupations', '81', '1,461', '11', '-', '69', '1,432', '2011'),
('Health diagnosing and treating practitioners, all other', 'health-diagnosing-and-treating-practitioners-all-other', 'healthcare-practitioners-and-technical-occupations', '5', '-', '3', '-', '2', '-', '2011'),
('Clinical laboratory technologists and technicians', 'clinical-laboratory-technologists-and-technicians', 'healthcare-practitioners-and-technical-occupations', '282', '861', '77', '888', '206', '845', '2011'),
('Dental hygienists', 'dental-hygienists', 'healthcare-practitioners-and-technical-occupations', '61', '986', '3', '-', '59', '992', '2011'),
('Diagnostic related technologists and technicians', 'diagnostic-related-technologists-and-technicians', 'healthcare-practitioners-and-technical-occupations', '273', '981', '82', '1,054', '191', '964', '2011'),
('Emergency medical technicians and paramedics', 'emergency-medical-technicians-and-paramedics', 'healthcare-practitioners-and-technical-occupations', '167', '715', '113', '757', '54', '649', '2011'),
('Health practitioner support technologists and technicians', 'health-practitioner-support-technologists-and-technicians', 'healthcare-practitioners-and-technical-occupations', '374', '644', '91', '682', '283', '632', '2011'),
('Licensed practical and licensed vocational nurses', 'licensed-practical-and-licensed-vocational-nurses', 'healthcare-practitioners-and-technical-occupations', '424', '722', '39', '-', '386', '720', '2011'),
('Medical records and health information technicians', 'medical-records-and-health-information-technicians', 'healthcare-practitioners-and-technical-occupations', '107', '588', '10', '-', '96', '574', '2011'),
('Opticians, dispensing', 'opticians-dispensing', 'healthcare-practitioners-and-technical-occupations', '34', '-', '8', '-', '26', '-', '2011'),
('Miscellaneous health technologists and technicians', 'miscellaneous-health-technologists-and-technicians', 'healthcare-practitioners-and-technical-occupations', '127', '744', '38', '-', '89', '711', '2011'),
('Other healthcare practitioners and technical occupations', 'other-healthcare-practitioners-and-technical-occupations', 'healthcare-practitioners-and-technical-occupations', '63', '870', '41', '-', '22', '-', '2011'),
('Service occupations', 'service-occupations', '', '14,378', '486', '7,387', '551', '6,991', '433', '2011'),
('Healthcare support occupations', 'healthcare-support-occupations', 'service-occupations', '2,190', '487', '290', '521', '1,900', '483', '2011'),
('Nursing, psychiatric, and home health aides', 'nursing-psychiatric-and-home-health-aides', 'healthcare-support-occupations', '1,305', '453', '172', '502', '1,134', '446', '2011'),
('Occupational therapy assistants and aides', 'occupational-therapy-assistants-and-aides', 'healthcare-support-occupations', '12', '-', '1', '-', '11', '-', '2011'),
('Physical therapist assistants and aides', 'physical-therapist-assistants-and-aides', 'healthcare-support-occupations', '54', '665', '22', '-', '32', '-', '2011'),
('Massage therapists', 'massage-therapists', 'healthcare-support-occupations', '34', '-', '6', '-', '28', '-', '2011'),
('Dental assistants', 'dental-assistants', 'healthcare-support-occupations', '191', '579', '7', '-', '184', '582', '2011'),
('Medical assistants', 'medical-assistants', 'healthcare-support-occupations', '314', '522', '21', '-', '293', '518', '2011'),
('Medical transcriptionists', 'medical-transcriptionists', 'healthcare-support-occupations', '44', '-', '2', '-', '43', '-', '2011'),
('Pharmacy aides', 'pharmacy-aides', 'healthcare-support-occupations', '23', '-', '10', '-', '14', '-', '2011'),
('Veterinary assistants and laboratory animal caretakers', 'veterinary-assistants-and-laboratory-animal-caretakers', 'healthcare-support-occupations', '20', '-', '7', '-', '13', '-', '2011'),
('Phlebotomists', 'phlebotomists', 'healthcare-support-occupations', '94', '521', '16', '-', '77', '516', '2011'),
('Miscellaneous healthcare support occupations, including medical equipment preparers', 'miscellaneous-healthcare-support-occupations-including-medical-equipment-preparers', 'healthcare-support-occupations', '98', '487', '26', '-', '72', '480', '2011'),
('Protective service occupations', 'protective-service-occupations', 'service-occupations', '2,798', '757', '2,287', '797', '511', '602', '2011'),
('First-line supervisors of correctional officers', 'first-line-supervisors-of-correctional-officers', 'protective-service-occupations', '41', '-', '30', '-', '11', '-', '2011'),
('First-line supervisors of police and detectives', 'first-line-supervisors-of-police-and-detectives', 'protective-service-occupations', '101', '1,083', '83', '1,109', '18', '-', '2011'),
('First-line supervisors of fire fighting and prevention workers', 'first-line-supervisors-of-fire-fighting-and-prevention-workers', 'protective-service-occupations', '40', '-', '39', '-', '1', '-', '2011'),
('First-line supervisors of protective service workers, all other', 'first-line-supervisors-of-protective-service-workers-all-other', 'protective-service-occupations', '96', '716', '73', '788', '23', '-', '2011'),
('Firefighters', 'firefighters', 'protective-service-occupations', '291', '1,000', '281', '998', '11', '-', '2011'),
('Fire inspectors', 'fire-inspectors', 'protective-service-occupations', '18', '-', '17', '-', '1', '-', '2011'),
('Bailiffs, correctional officers, and jailers', 'bailiffs-correctional-officers-and-jailers', 'protective-service-occupations', '436', '682', '320', '722', '116', '586', '2011'),
('Detectives and criminal investigators', 'detectives-and-criminal-investigators', 'protective-service-occupations', '147', '1,154', '125', '1,192', '22', '-', '2011'),
('Fish and game wardens', 'fish-and-game-wardens', 'protective-service-occupations', '5', '-', '5', '-', '1', '-', '2011'),
('Parking enforcement workers', 'parking-enforcement-workers', 'protective-service-occupations', '5', '-', '3', '-', '2', '-', '2011'),
('Police and sheriff''s patrol officers', 'police-and-sheriffs-patrol-officers', 'protective-service-occupations', '653', '947', '578', '948', '75', '938', '2011'),
('Transit and railroad police', 'transit-and-railroad-police', 'protective-service-occupations', '7', '-', '7', '-', '0', '-', '2011'),
('Animal control workers', 'animal-control-workers', 'protective-service-occupations', '8', '-', '5', '-', '4', '-', '2011'),
('Private detectives and investigators', 'private-detectives-and-investigators', 'protective-service-occupations', '86', '869', '56', '891', '30', '-', '2011'),
('Security guards and gaming surveillance officers', 'security-guards-and-gaming-surveillance-officers', 'protective-service-occupations', '775', '519', '619', '544', '156', '474', '2011'),
('Crossing guards', 'crossing-guards', 'protective-service-occupations', '23', '-', '15', '-', '8', '-', '2011'),
('Transportation security screeners', 'transportation-security-screeners', 'protective-service-occupations', '21', '-', '12', '-', '10', '-', '2011'),
('Lifeguards and other recreational, and all other protective service workers', 'lifeguards-and-other-recreational-and-all-other-protective-service-workers', 'protective-service-occupations', '44', '-', '21', '-', '23', '-', '2011'),
('Food preparation and serving related occupations', 'food-preparation-and-serving-related-occupations', 'service-occupations', '3,930', '409', '2,021', '429', '1,909', '390', '2011'),
('Chefs and head cooks', 'chefs-and-head-cooks', 'food-preparation-and-serving-related-occupations', '299', '580', '245', '601', '53', '502', '2011'),
('First-line supervisors of food preparation and serving workers', 'first-line-supervisors-of-food-preparation-and-serving-workers', 'food-preparation-and-serving-related-occupations', '378', '485', '158', '525', '220', '458', '2011'),
('Cooks', 'cooks', 'food-preparation-and-serving-related-occupations', '1,210', '390', '761', '406', '449', '363', '2011'),
('Food preparation workers', 'food-preparation-workers', 'food-preparation-and-serving-related-occupations', '357', '384', '155', '395', '202', '375', '2011'),
('Bartenders', 'bartenders', 'food-preparation-and-serving-related-occupations', '210', '545', '104', '593', '106', '505', '2011'),
('Combined food preparation and serving workers, including fast food', 'combined-food-preparation-and-serving-workers-including-fast-food', 'food-preparation-and-serving-related-occupations', '161', '387', '46', '-', '114', '385', '2011'),
('Counter attendants, cafeteria, food concession, and coffee shop', 'counter-attendants-cafeteria-food-concession-and-coffee-shop', 'food-preparation-and-serving-related-occupations', '58', '323', '26', '-', '32', '-', '2011'),
('Waiters and waitresses', 'waiters-and-waitresses', 'food-preparation-and-serving-related-occupations', '872', '407', '313', '466', '559', '389', '2011'),
('Food servers, nonrestaurant', 'food-servers-nonrestaurant', 'food-preparation-and-serving-related-occupations', '84', '419', '31', '-', '52', '393', '2011'),
('Dining room and cafeteria attendants and bartender helpers', 'dining-room-and-cafeteria-attendants-and-bartender-helpers', 'food-preparation-and-serving-related-occupations', '119', '383', '77', '392', '42', '-', '2011'),
('Dishwashers', 'dishwashers', 'food-preparation-and-serving-related-occupations', '118', '332', '90', '321', '28', '-', '2011'),
('Hosts and hostesses, restaurant, lounge, and coffee shop', 'hosts-and-hostesses-restaurant-lounge-and-coffee-shop', 'food-preparation-and-serving-related-occupations', '62', '369', '10', '-', '52', '356', '2011'),
('Food preparation and serving related workers, all other', 'food-preparation-and-serving-related-workers-all-other', 'food-preparation-and-serving-related-occupations', '4', '-', '4', '-', '0', '-', '2011'),
('Building and grounds cleaning and maintenance occupations', 'building-and-grounds-cleaning-and-maintenance-occupations', 'service-occupations', '3,339', '465', '2,212', '502', '1,128', '406', '2011'),
('First-line supervisors of housekeeping and janitorial workers', 'first-line-supervisors-of-housekeeping-and-janitorial-workers', 'building-and-grounds-cleaning-and-maintenance-occupations', '179', '646', '113', '756', '67', '488', '2011'),
('First-line supervisors of landscaping, lawn service, and groundskeeping workers', 'first-line-supervisors-of-landscaping-lawn-service-and-groundskeeping-workers', 'building-and-grounds-cleaning-and-maintenance-occupations', '94', '797', '85', '808', '10', '-', '2011'),
('Janitors and building cleaners', 'janitors-and-building-cleaners', 'building-and-grounds-cleaning-and-maintenance-occupations', '1,496', '489', '1,111', '514', '384', '418', '2011'),
('Maids and housekeeping cleaners', 'maids-and-housekeeping-cleaners', 'building-and-grounds-cleaning-and-maintenance-occupations', '751', '399', '114', '473', '638', '392', '2011'),
('Pest control workers', 'pest-control-workers', 'building-and-grounds-cleaning-and-maintenance-occupations', '58', '575', '57', '572', '1', '-', '2011'),
('Grounds maintenance workers', 'grounds-maintenance-workers', 'building-and-grounds-cleaning-and-maintenance-occupations', '761', '425', '732', '424', '29', '-', '2011'),
('Personal care and service occupations', 'personal-care-and-service-occupations', 'service-occupations', '2,121', '453', '578', '562', '1,543', '422', '2011'),
('First-line supervisors of gaming workers', 'first-line-supervisors-of-gaming-workers', 'personal-care-and-service-occupations', '90', '739', '51', '876', '39', '-', '2011'),
('First-line supervisors of personal service workers', 'first-line-supervisors-of-personal-service-workers', 'personal-care-and-service-occupations', '67', '613', '21', '-', '46', '-', '2011'),
('Animal trainers', 'animal-trainers', 'personal-care-and-service-occupations', '16', '-', '9', '-', '7', '-', '2011'),
('Nonfarm animal caretakers', 'nonfarm-animal-caretakers', 'personal-care-and-service-occupations', '82', '419', '22', '-', '60', '417', '2011'),
('Gaming services workers', 'gaming-services-workers', 'personal-care-and-service-occupations', '82', '636', '43', '-', '39', '-', '2011'),
('Motion picture projectionists', 'motion-picture-projectionists', 'personal-care-and-service-occupations', '3', '-', '3', '-', '0', '-', '2011'),
('Ushers, lobby attendants, and ticket takers', 'ushers-lobby-attendants-and-ticket-takers', 'personal-care-and-service-occupations', '9', '-', '3', '-', '6', '-', '2011'),
('Miscellaneous entertainment attendants and related workers', 'miscellaneous-entertainment-attendants-and-related-workers', 'personal-care-and-service-occupations', '66', '424', '35', '-', '31', '-', '2011'),
('Embalmers and funeral attendants', 'embalmers-and-funeral-attendants', 'personal-care-and-service-occupations', '5', '-', '3', '-', '2', '-', '2011'),
('Morticians, undertakers, and funeral directors', 'morticians-undertakers-and-funeral-directors', 'personal-care-and-service-occupations', '16', '-', '12', '-', '3', '-', '2011'),
('Barbers', 'barbers', 'personal-care-and-service-occupations', '29', '-', '25', '-', '4', '-', '2011'),
('Hairdressers, hairstylists, and cosmetologists', 'hairdressers-hairstylists-and-cosmetologists', 'personal-care-and-service-occupations', '282', '453', '23', '-', '259', '440', '2011'),
('Miscellaneous personal appearance workers', 'miscellaneous-personal-appearance-workers', 'personal-care-and-service-occupations', '136', '441', '32', '-', '104', '413', '2011'),
('Baggage porters, bellhops, and concierges', 'baggage-porters-bellhops-and-concierges', 'personal-care-and-service-occupations', '63', '545', '55', '561', '8', '-', '2011'),
('Tour and travel guides', 'tour-and-travel-guides', 'personal-care-and-service-occupations', '9', '-', '6', '-', '3', '-', '2011'),
('Childcare workers', 'childcare-workers', 'personal-care-and-service-occupations', '367', '382', '26', '-', '342', '383', '2011'),
('Personal care aides', 'personal-care-aides', 'personal-care-and-service-occupations', '549', '412', '94', '454', '455', '407', '2011'),
('Recreation and fitness workers', 'recreation-and-fitness-workers', 'personal-care-and-service-occupations', '177', '506', '76', '575', '101', '494', '2011'),
('Residential advisors', 'residential-advisors', 'personal-care-and-service-occupations', '42', '-', '15', '-', '27', '-', '2011'),
('Personal care and service workers, all other', 'personal-care-and-service-workers-all-other', 'personal-care-and-service-occupations', '34', '-', '23', '-', '11', '-', '2011'),
('Sales and office occupations', 'sales-and-office-occupations', '', '22,989', '638', '9,012', '738', '13,977', '602', '2011'),
('Sales and related occupations', 'sales-and-related-occupations', 'sales-and-office-occupations', '9,294', '670', '5,225', '804', '4,069', '549', '2011'),
('First-line supervisors of retail sales workers', 'first-line-supervisors-of-retail-sales-workers', 'sales-and-related-occupations', '2,223', '676', '1,263', '759', '959', '599', '2011'),
('First-line supervisors of non-retail sales workers', 'first-line-supervisors-of-non-retail-sales-workers', 'sales-and-related-occupations', '702', '951', '488', '1,016', '214', '781', '2011'),
('Cashiers', 'cashiers', 'sales-and-related-occupations', '1,343', '383', '381', '411', '962', '373', '2011'),
('Counter and rental clerks', 'counter-and-rental-clerks', 'sales-and-related-occupations', '87', '603', '50', '620', '38', '-', '2011'),
('Parts salespersons', 'parts-salespersons', 'sales-and-related-occupations', '117', '610', '100', '587', '16', '-', '2011'),
('Retail salespersons', 'retail-salespersons', 'sales-and-related-occupations', '1,789', '545', '1,056', '620', '733', '466', '2011'),
('Advertising sales agents', 'advertising-sales-agents', 'sales-and-related-occupations', '202', '893', '90', '961', '112', '772', '2011'),
('Insurance sales agents', 'insurance-sales-agents', 'sales-and-related-occupations', '384', '807', '183', '1,033', '201', '665', '2011'),
('Securities, commodities, and financial services sales agents', 'securities-commodities-and-financial-services-sales-agents', 'sales-and-related-occupations', '222', '1,144', '149', '1,269', '73', '884', '2011'),
('Travel agents', 'travel-agents', 'sales-and-related-occupations', '49', '-', '11', '-', '38', '-', '2011'),
('Sales representatives, services, all other', 'sales-representatives-services-all-other', 'sales-and-related-occupations', '397', '887', '278', '953', '119', '757', '2011'),
('Sales representatives, wholesale and manufacturing', 'sales-representatives-wholesale-and-manufacturing', 'sales-and-related-occupations', '1,091', '991', '829', '1,019', '262', '927', '2011'),
('Models, demonstrators, and product promoters', 'models-demonstrators-and-product-promoters', 'sales-and-related-occupations', '15', '-', '4', '-', '11', '-', '2011'),
('Real estate brokers and sales agents', 'real-estate-brokers-and-sales-agents', 'sales-and-related-occupations', '380', '812', '176', '992', '204', '676', '2011'),
('Sales engineers', 'sales-engineers', 'sales-and-related-occupations', '30', '-', '27', '-', '3', '-', '2011'),
('Telemarketers', 'telemarketers', 'sales-and-related-occupations', '69', '412', '29', '-', '40', '-', '2011'),
('Door-to-door sales workers, news and street vendors, and related workers', 'door-to-door-sales-workers-news-and-street-vendors-and-related-workers', 'sales-and-related-occupations', '55', '526', '35', '-', '20', '-', '2011'),
('Office and administrative support occupations', 'office-and-administrative-support-occupations', 'sales-and-office-occupations', '13,695', '623', '3,787', '668', '9,908', '615', '2011'),
('First-line supervisors of office and administrative support workers', 'first-line-supervisors-of-office-and-administrative-support-workers', 'office-and-administrative-support-occupations', '1,274', '764', '418', '833', '856', '741', '2011'),
('Switchboard operators, including answering service', 'switchboard-operators-including-answering-service', 'office-and-administrative-support-occupations', '29', '-', '4', '-', '25', '-', '2011'),
('Telephone operators', 'telephone-operators', 'office-and-administrative-support-occupations', '38', '-', '7', '-', '30', '-', '2011'),
('Communications equipment operators, all other', 'communications-equipment-operators-all-other', 'office-and-administrative-support-occupations', '6', '-', '4', '-', '3', '-', '2011'),
('Bill and account collectors', 'bill-and-account-collectors', 'office-and-administrative-support-occupations', '178', '608', '48', '-', '130', '597', '2011'),
('Billing and posting clerks', 'billing-and-posting-clerks', 'office-and-administrative-support-occupations', '397', '607', '38', '-', '359', '605', '2011'),
('Bookkeeping, accounting, and auditing clerks', 'bookkeeping-accounting-and-auditing-clerks', 'office-and-administrative-support-occupations', '862', '655', '112', '654', '750', '656', '2011'),
('Gaming cage workers', 'gaming-cage-workers', 'office-and-administrative-support-occupations', '2', '-', '1', '-', '1', '-', '2011'),
('Payroll and timekeeping clerks', 'payroll-and-timekeeping-clerks', 'office-and-administrative-support-occupations', '136', '710', '11', '-', '125', '704', '2011'),
('Procurement clerks', 'procurement-clerks', 'office-and-administrative-support-occupations', '24', '-', '9', '-', '16', '-', '2011'),
('Tellers', 'tellers', 'office-and-administrative-support-occupations', '283', '492', '41', '-', '241', '500', '2011'),
('Financial clerks, all other', 'financial-clerks-all-other', 'office-and-administrative-support-occupations', '64', '793', '16', '-', '48', '-', '2011'),
('Brokerage clerks', 'brokerage-clerks', 'office-and-administrative-support-occupations', '11', '-', '7', '-', '4', '-', '2011'),
('Correspondence clerks', 'correspondence-clerks', 'office-and-administrative-support-occupations', '10', '-', '2', '-', '8', '-', '2011'),
('Court, municipal, and license clerks', 'court-municipal-and-license-clerks', 'office-and-administrative-support-occupations', '74', '763', '14', '-', '60', '738', '2011'),
('Credit authorizers, checkers, and clerks', 'credit-authorizers-checkers-and-clerks', 'office-and-administrative-support-occupations', '47', '-', '13', '-', '34', '-', '2011'),
('Customer service representatives', 'customer-service-representatives', 'office-and-administrative-support-occupations', '1,509', '588', '538', '628', '972', '569', '2011'),
('Eligibility interviewers, government programs', 'eligibility-interviewers-government-programs', 'office-and-administrative-support-occupations', '79', '632', '9', '-', '70', '632', '2011'),
('File clerks', 'file-clerks', 'office-and-administrative-support-occupations', '248', '616', '32', '-', '217', '620', '2011'),
('Hotel, motel, and resort desk clerks', 'hotel-motel-and-resort-desk-clerks', 'office-and-administrative-support-occupations', '86', '423', '33', '-', '53', '416', '2011'),
('Interviewers, except eligibility and loan', 'interviewers-except-eligibility-and-loan', 'office-and-administrative-support-occupations', '121', '546', '21', '-', '99', '551', '2011'),
('Library assistants, clerical', 'library-assistants-clerical', 'office-and-administrative-support-occupations', '49', '-', '12', '-', '38', '-', '2011'),
('Loan interviewers and clerks', 'loan-interviewers-and-clerks', 'office-and-administrative-support-occupations', '110', '706', '17', '-', '93', '696', '2011'),
('New accounts clerks', 'new-accounts-clerks', 'office-and-administrative-support-occupations', '27', '-', '8', '-', '19', '-', '2011'),
('Order clerks', 'order-clerks', 'office-and-administrative-support-occupations', '96', '586', '35', '-', '60', '577', '2011'),
('Human resources assistants, except payroll and timekeeping', 'human-resources-assistants-except-payroll-and-timekeeping', 'office-and-administrative-support-occupations', '45', '-', '5', '-', '40', '-', '2011'),
('Receptionists and information clerks', 'receptionists-and-information-clerks', 'office-and-administrative-support-occupations', '868', '520', '78', '521', '790', '520', '2011'),
('Reservation and transportation ticket agents and travel clerks', 'reservation-and-transportation-ticket-agents-and-travel-clerks', 'office-and-administrative-support-occupations', '80', '649', '33', '-', '47', '-', '2011'),
('Information and record clerks, all other', 'information-and-record-clerks-all-other', 'office-and-administrative-support-occupations', '105', '744', '18', '-', '86', '737', '2011'),
('Cargo and freight agents', 'cargo-and-freight-agents', 'office-and-administrative-support-occupations', '6', '-', '4', '-', '2', '-', '2011'),
('Couriers and messengers', 'couriers-and-messengers', 'office-and-administrative-support-occupations', '164', '744', '145', '785', '19', '-', '2011'),
('Dispatchers', 'dispatchers', 'office-and-administrative-support-occupations', '207', '651', '81', '728', '126', '626', '2011'),
('Meter readers, utilities', 'meter-readers-utilities', 'office-and-administrative-support-occupations', '21', '-', '18', '-', '3', '-', '2011'),
('Postal service clerks', 'postal-service-clerks', 'office-and-administrative-support-occupations', '129', '978', '66', '1,014', '63', '892', '2011'),
('Postal service mail carriers', 'postal-service-mail-carriers', 'office-and-administrative-support-occupations', '303', '979', '205', '1,017', '98', '892', '2011'),
('Postal service mail sorters, processors, and processing machine operators', 'postal-service-mail-sorters-processors-and-processing-machine-operators', 'office-and-administrative-support-occupations', '57', '918', '33', '-', '24', '-', '2011'),
('Production, planning, and expediting clerks', 'production-planning-and-expediting-clerks', 'office-and-administrative-support-occupations', '226', '812', '110', '916', '116', '722', '2011'),
('Shipping, receiving, and traffic clerks', 'shipping-receiving-and-traffic-clerks', 'office-and-administrative-support-occupations', '481', '562', '340', '571', '141', '543', '2011'),
('Stock clerks and order fillers', 'stock-clerks-and-order-fillers', 'office-and-administrative-support-occupations', '992', '492', '655', '488', '337', '501', '2011'),
('Weighers, measurers, checkers, and samplers, recordkeeping', 'weighers-measurers-checkers-and-samplers-recordkeeping', 'office-and-administrative-support-occupations', '60', '596', '32', '-', '28', '-', '2011'),
('Secretaries and administrative assistants', 'secretaries-and-administrative-assistants', 'office-and-administrative-support-occupations', '2,143', '654', '84', '757', '2,059', '651', '2011'),
('Computer operators', 'computer-operators', 'office-and-administrative-support-occupations', '116', '724', '59', '853', '56', '651', '2011'),
('Data entry keyers', 'data-entry-keyers', 'office-and-administrative-support-occupations', '280', '595', '49', '-', '231', '597', '2011'),
('Word processors and typists', 'word-processors-and-typists', 'office-and-administrative-support-occupations', '109', '599', '10', '-', '99', '594', '2011'),
('Desktop publishers', 'desktop-publishers', 'office-and-administrative-support-occupations', '1', '-', '1', '-', '0', '-', '2011'),
('Insurance claims and policy processing clerks', 'insurance-claims-and-policy-processing-clerks', 'office-and-administrative-support-occupations', '236', '660', '39', '-', '197', '647', '2011'),
('Mail clerks and mail machine operators, except postal service', 'mail-clerks-and-mail-machine-operators-except-postal-service', 'office-and-administrative-support-occupations', '79', '521', '38', '-', '41', '-', '2011'),
('Office clerks, general', 'office-clerks-general', 'office-and-administrative-support-occupations', '794', '604', '121', '712', '673', '594', '2011'),
('Office machine operators, except computer', 'office-machine-operators-except-computer', 'office-and-administrative-support-occupations', '31', '-', '11', '-', '20', '-', '2011'),
('Proofreaders and copy markers', 'proofreaders-and-copy-markers', 'office-and-administrative-support-occupations', '7', '-', '1', '-', '6', '-', '2011'),
('Statistical assistants', 'statistical-assistants', 'office-and-administrative-support-occupations', '12', '-', '4', '-', '8', '-', '2011'),
('Office and administrative support workers, all other', 'office-and-administrative-support-workers-all-other', 'office-and-administrative-support-occupations', '387', '679', '101', '792', '286', '645', '2011'),
('Natural resources, construction, and maintenance occupations', 'natural-resources-construction-and-maintenance-occupations', '', '9,965', '732', '9,574', '740', '391', '515', '2011'),
('Farming, fishing, and forestry occupations', 'farming-fishing-and-forestry-occupations', 'natural-resources-construction-and-maintenance-occupations', '775', '430', '625', '445', '150', '371', '2011'),
('First-line supervisors of farming, fishing, and forestry workers', 'first-line-supervisors-of-farming-fishing-and-forestry-workers', 'farming-fishing-and-forestry-occupations', '38', '-', '35', '-', '3', '-', '2011'),
('Agricultural inspectors', 'agricultural-inspectors', 'farming-fishing-and-forestry-occupations', '23', '-', '11', '-', '12', '-', '2011'),
('Animal breeders', 'animal-breeders', 'farming-fishing-and-forestry-occupations', '3', '-', '2', '-', '1', '-', '2011'),
('Graders and sorters, agricultural products', 'graders-and-sorters-agricultural-products', 'farming-fishing-and-forestry-occupations', '85', '379', '32', '-', '53', '363', '2011'),
('Miscellaneous agricultural workers', 'miscellaneous-agricultural-workers', 'farming-fishing-and-forestry-occupations', '565', '419', '488', '427', '77', '370', '2011'),
('Fishers and related fishing workers', 'fishers-and-related-fishing-workers', 'farming-fishing-and-forestry-occupations', '13', '-', '13', '-', '0', '-', '2011'),
('Hunters and trappers', 'hunters-and-trappers', 'farming-fishing-and-forestry-occupations', '1', '-', '1', '-', '0', '-', '2011'),
('Forest and conservation workers', 'forest-and-conservation-workers', 'farming-fishing-and-forestry-occupations', '8', '-', '4', '-', '4', '-', '2011'),
('Logging workers', 'logging-workers', 'farming-fishing-and-forestry-occupations', '39', '-', '39', '-', '0', '-', '2011'),
('Construction and extraction occupations', 'construction-and-extraction-occupations', 'natural-resources-construction-and-maintenance-occupations', '5,031', '717', '4,937', '718', '95', '612', '2011'),
('First-line supervisors of construction trades and extraction workers', 'first-line-supervisors-of-construction-trades-and-extraction-workers', 'construction-and-extraction-occupations', '482', '992', '467', '1,001', '15', '-', '2011'),
('Boilermakers', 'boilermakers', 'construction-and-extraction-occupations', '18', '-', '18', '-', '0', '-', '2011'),
('Brickmasons, blockmasons, and stonemasons', 'brickmasons-blockmasons-and-stonemasons', 'construction-and-extraction-occupations', '96', '710', '95', '706', '1', '-', '2011'),
('Carpenters', 'carpenters', 'construction-and-extraction-occupations', '737', '630', '727', '630', '10', '-', '2011'),
('Carpet, floor, and tile installers and finishers', 'carpet-floor-and-tile-installers-and-finishers', 'construction-and-extraction-occupations', '110', '579', '109', '581', '1', '-', '2011'),
('Cement masons, concrete finishers, and terrazzo workers', 'cement-masons-concrete-finishers-and-terrazzo-workers', 'construction-and-extraction-occupations', '59', '651', '59', '651', '0', '-', '2011'),
('Construction laborers', 'construction-laborers', 'construction-and-extraction-occupations', '862', '586', '846', '587', '15', '-', '2011'),
('Paving, surfacing, and tamping equipment operators', 'paving-surfacing-and-tamping-equipment-operators', 'construction-and-extraction-occupations', '19', '-', '18', '-', '0', '-', '2011'),
('Pile-driver operators', 'pile-driver-operators', 'construction-and-extraction-occupations', '1', '-', '1', '-', '0', '-', '2011'),
('Operating engineers and other construction equipment operators', 'operating-engineers-and-other-construction-equipment-operators', 'construction-and-extraction-occupations', '345', '809', '343', '809', '2', '-', '2011'),
('Drywall installers, ceiling tile installers, and tapers', 'drywall-installers-ceiling-tile-installers-and-tapers', 'construction-and-extraction-occupations', '101', '507', '100', '509', '1', '-', '2011'),
('Electricians', 'electricians', 'construction-and-extraction-occupations', '542', '857', '539', '855', '3', '-', '2011'),
('Glaziers', 'glaziers', 'construction-and-extraction-occupations', '40', '-', '40', '-', '0', '-', '2011'),
('Insulation workers', 'insulation-workers', 'construction-and-extraction-occupations', '41', '-', '39', '-', '2', '-', '2011'),
('Painters, construction and maintenance', 'painters-construction-and-maintenance', 'construction-and-extraction-occupations', '266', '544', '249', '555', '17', '-', '2011'),
('Paperhangers', 'paperhangers', 'construction-and-extraction-occupations', '2', '-', '2', '-', '0', '-', '2011'),
('Pipelayers, plumbers, pipefitters, and steamfitters', 'pipelayers-plumbers-pipefitters-and-steamfitters', 'construction-and-extraction-occupations', '417', '851', '406', '853', '11', '-', '2011'),
('Plasterers and stucco masons', 'plasterers-and-stucco-masons', 'construction-and-extraction-occupations', '13', '-', '13', '-', '0', '-', '2011'),
('Reinforcing iron and rebar workers', 'reinforcing-iron-and-rebar-workers', 'construction-and-extraction-occupations', '5', '-', '5', '-', '0', '-', '2011'),
('Roofers', 'roofers', 'construction-and-extraction-occupations', '143', '523', '141', '520', '3', '-', '2011'),
('Sheet metal workers', 'sheet-metal-workers', 'construction-and-extraction-occupations', '107', '805', '104', '805', '3', '-', '2011'),
('Structural iron and steel workers', 'structural-iron-and-steel-workers', 'construction-and-extraction-occupations', '66', '870', '66', '870', '0', '-', '2011'),
('Solar photovoltaic installers', 'solar-photovoltaic-installers', 'construction-and-extraction-occupations', '2', '-', '2', '-', '0', '-', '2011'),
('Helpers, construction trades', 'helpers-construction-trades', 'construction-and-extraction-occupations', '50', '469', '47', '-', '3', '-', '2011'),
('Construction and building inspectors', 'construction-and-building-inspectors', 'construction-and-extraction-occupations', '54', '906', '52', '919', '2', '-', '2011'),
('Elevator installers and repairers', 'elevator-installers-and-repairers', 'construction-and-extraction-occupations', '30', '-', '30', '-', '0', '-', '2011'),
('Fence erectors', 'fence-erectors', 'construction-and-extraction-occupations', '32', '-', '32', '-', '0', '-', '2011'),
('Hazardous materials removal workers', 'hazardous-materials-removal-workers', 'construction-and-extraction-occupations', '25', '-', '24', '-', '1', '-', '2011'),
('Highway maintenance workers', 'highway-maintenance-workers', 'construction-and-extraction-occupations', '96', '708', '94', '711', '2', '-', '2011'),
('Rail-track laying and maintenance equipment operators', 'rail-track-laying-and-maintenance-equipment-operators', 'construction-and-extraction-occupations', '8', '-', '8', '-', '0', '-', '2011'),
('Septic tank servicers and sewer pipe cleaners', 'septic-tank-servicers-and-sewer-pipe-cleaners', 'construction-and-extraction-occupations', '9', '-', '9', '-', '0', '-', '2011'),
('Miscellaneous construction and related workers', 'miscellaneous-construction-and-related-workers', 'construction-and-extraction-occupations', '28', '-', '28', '-', '0', '-', '2011'),
('Derrick, rotary drill, and service unit operators, oil, gas, and mining', 'derrick-rotary-drill-and-service-unit-operators-oil-gas-and-mining', 'construction-and-extraction-occupations', '42', '-', '42', '-', '0', '-', '2011'),
('Earth drillers, except oil and gas', 'earth-drillers-except-oil-and-gas', 'construction-and-extraction-occupations', '17', '-', '17', '-', '0', '-', '2011'),
('Explosives workers, ordnance handling experts, and blasters', 'explosives-workers-ordnance-handling-experts-and-blasters', 'construction-and-extraction-occupations', '10', '-', '10', '-', '0', '-', '2011'),
('Mining machine operators', 'mining-machine-operators', 'construction-and-extraction-occupations', '70', '1,022', '69', '1,010', '1', '-', '2011'),
('Roof bolters, mining', 'roof-bolters-mining', 'construction-and-extraction-occupations', '12', '-', '12', '-', '0', '-', '2011'),
('Roustabouts, oil and gas', 'roustabouts-oil-and-gas', 'construction-and-extraction-occupations', '18', '-', '17', '-', '1', '-', '2011'),
('Helpers--extraction workers', 'helpers-extraction-workers', 'construction-and-extraction-occupations', '8', '-', '8', '-', '0', '-', '2011'),
('Other extraction workers', 'other-extraction-workers', 'construction-and-extraction-occupations', '49', '-', '49', '-', '0', '-', '2011'),
('Installation, maintenance, and repair occupations', 'installation-maintenance-and-repair-occupations', 'natural-resources-construction-and-maintenance-occupations', '4,159', '806', '4,013', '807', '146', '751', '2011'),
('First-line supervisors of mechanics, installers, and repairers', 'first-line-supervisors-of-mechanics-installers-and-repairers', 'installation-maintenance-and-repair-occupations', '327', '947', '306', '936', '21', '-', '2011'),
('Computer, automated teller, and office machine repairers', 'computer-automated-teller-and-office-machine-repairers', 'installation-maintenance-and-repair-occupations', '237', '811', '215', '812', '22', '-', '2011'),
('Radio and telecommunications equipment installers and repairers', 'radio-and-telecommunications-equipment-installers-and-repairers', 'installation-maintenance-and-repair-occupations', '139', '898', '127', '883', '12', '-', '2011'),
('Avionics technicians', 'avionics-technicians', 'installation-maintenance-and-repair-occupations', '16', '-', '15', '-', '2', '-', '2011'),
('Electric motor, power tool, and related repairers', 'electric-motor-power-tool-and-related-repairers', 'installation-maintenance-and-repair-occupations', '26', '-', '25', '-', '0', '-', '2011'),
('Electrical and electronics installers and repairers, transportation equipment', 'electrical-and-electronics-installers-and-repairers-transportation-equipment', 'installation-maintenance-and-repair-occupations', '7', '-', '7', '-', '0', '-', '2011'),
('Electrical and electronics repairers, industrial and utility', 'electrical-and-electronics-repairers-industrial-and-utility', 'installation-maintenance-and-repair-occupations', '15', '-', '14', '-', '1', '-', '2011'),
('Electronic equipment installers and repairers, motor vehicles', 'electronic-equipment-installers-and-repairers-motor-vehicles', 'installation-maintenance-and-repair-occupations', '14', '-', '14', '-', '0', '-', '2011'),
('Electronic home entertainment equipment installers and repairers', 'electronic-home-entertainment-equipment-installers-and-repairers', 'installation-maintenance-and-repair-occupations', '32', '-', '30', '-', '2', '-', '2011'),
('Security and fire alarm systems installers', 'security-and-fire-alarm-systems-installers', 'installation-maintenance-and-repair-occupations', '44', '-', '44', '-', '0', '-', '2011'),
('Aircraft mechanics and service technicians', 'aircraft-mechanics-and-service-technicians', 'installation-maintenance-and-repair-occupations', '143', '988', '139', '990', '4', '-', '2011'),
('Automotive body and related repairers', 'automotive-body-and-related-repairers', 'installation-maintenance-and-repair-occupations', '107', '624', '107', '625', '1', '-', '2011'),
('Automotive glass installers and repairers', 'automotive-glass-installers-and-repairers', 'installation-maintenance-and-repair-occupations', '11', '-', '10', '-', '0', '-', '2011'),
('Automotive service technicians and mechanics', 'automotive-service-technicians-and-mechanics', 'installation-maintenance-and-repair-occupations', '653', '714', '645', '718', '8', '-', '2011'),
('Bus and truck mechanics and diesel engine specialists', 'bus-and-truck-mechanics-and-diesel-engine-specialists', 'installation-maintenance-and-repair-occupations', '286', '801', '286', '802', '1', '-', '2011'),
('Heavy vehicle and mobile equipment service technicians and mechanics', 'heavy-vehicle-and-mobile-equipment-service-technicians-and-mechanics', 'installation-maintenance-and-repair-occupations', '182', '822', '179', '822', '3', '-', '2011'),
('Small engine mechanics', 'small-engine-mechanics', 'installation-maintenance-and-repair-occupations', '32', '-', '31', '-', '1', '-', '2011'),
('Miscellaneous vehicle and mobile equipment mechanics, installers, and repairers', 'miscellaneous-vehicle-and-mobile-equipment-mechanics-installers-and-repairers', 'installation-maintenance-and-repair-occupations', '73', '463', '71', '463', '2', '-', '2011'),
('Control and valve installers and repairers', 'control-and-valve-installers-and-repairers', 'installation-maintenance-and-repair-occupations', '25', '-', '24', '-', '1', '-', '2011'),
('Heating, air conditioning, and refrigeration mechanics and installers', 'heating-air-conditioning-and-refrigeration-mechanics-and-installers', 'installation-maintenance-and-repair-occupations', '281', '793', '279', '795', '1', '-', '2011'),
('Home appliance repairers', 'home-appliance-repairers', 'installation-maintenance-and-repair-occupations', '27', '-', '23', '-', '4', '-', '2011'),
('Industrial and refractory machinery mechanics', 'industrial-and-refractory-machinery-mechanics', 'installation-maintenance-and-repair-occupations', '425', '868', '415', '870', '10', '-', '2011'),
('Maintenance and repair workers, general', 'maintenance-and-repair-workers-general', 'installation-maintenance-and-repair-occupations', '359', '758', '347', '756', '11', '-', '2011'),
('Maintenance workers, machinery', 'maintenance-workers-machinery', 'installation-maintenance-and-repair-occupations', '34', '-', '31', '-', '3', '-', '2011'),
('Millwrights', 'millwrights', 'installation-maintenance-and-repair-occupations', '57', '892', '56', '897', '1', '-', '2011'),
('Electrical power-line installers and repairers', 'electrical-power-line-installers-and-repairers', 'installation-maintenance-and-repair-occupations', '111', '1,116', '111', '1,116', '0', '-', '2011'),
('Telecommunications line installers and repairers', 'telecommunications-line-installers-and-repairers', 'installation-maintenance-and-repair-occupations', '192', '915', '185', '926', '7', '-', '2011'),
('Precision instrument and equipment repairers', 'precision-instrument-and-equipment-repairers', 'installation-maintenance-and-repair-occupations', '62', '898', '52', '914', '10', '-', '2011'),
('Wind turbine service technicians', 'wind-turbine-service-technicians', 'installation-maintenance-and-repair-occupations', '2', '-', '2', '-', '0', '-', '2011'),
('Coin, vending, and amusement machine servicers and repairers', 'coin-vending-and-amusement-machine-servicers-and-repairers', 'installation-maintenance-and-repair-occupations', '29', '-', '27', '-', '1', '-', '2011'),
('Commercial divers', 'commercial-divers', 'installation-maintenance-and-repair-occupations', '1', '-', '1', '-', '0', '-', '2011'),
('Locksmiths and safe repairers', 'locksmiths-and-safe-repairers', 'installation-maintenance-and-repair-occupations', '17', '-', '17', '-', '1', '-', '2011'),
('Manufactured building and mobile home installers', 'manufactured-building-and-mobile-home-installers', 'installation-maintenance-and-repair-occupations', '7', '-', '7', '-', '0', '-', '2011'),
('Riggers', 'riggers', 'installation-maintenance-and-repair-occupations', '15', '-', '12', '-', '3', '-', '2011'),
('Signal and track switch repairers', 'signal-and-track-switch-repairers', 'installation-maintenance-and-repair-occupations', '5', '-', '5', '-', '0', '-', '2011'),
('Taxi drivers and chauffeurs', 'taxi-drivers-and-chauffeurs', 'transportation-and-material-moving-occupations', '207', '553', '178', '576', '29', '-', '2011'),
('Helpers--installation, maintenance, and repair workers', 'helpers-installation-maintenance-and-repair-workers', 'installation-maintenance-and-repair-occupations', '18', '-', '17', '-', '1', '-', '2011'),
('Other installation, maintenance, and repair workers', 'other-installation-maintenance-and-repair-workers', 'installation-maintenance-and-repair-occupations', '149', '671', '137', '718', '12', '-', '2011'),
('Production, transportation, and material moving occupations', 'production-transportation-and-material-moving-occupations', '', '13,333', '609', '10,730', '651', '2,603', '485', '2011'),
('Production occupations', 'production-occupations', 'production-transportation-and-material-moving-occupations', '7,058', '605', '5,241', '667', '1,817', '483', '2011'),
('First-line supervisors of production and operating workers', 'first-line-supervisors-of-production-and-operating-workers', 'production-occupations', '654', '888', '530', '929', '124', '665', '2011'),
('Aircraft structure, surfaces, rigging, and systems assemblers', 'aircraft-structure-surfaces-rigging-and-systems-assemblers', 'production-occupations', '19', '-', '13', '-', '7', '-', '2011'),
('Electrical, electronics, and electromechanical assemblers', 'electrical-electronics-and-electromechanical-assemblers', 'production-occupations', '148', '521', '75', '591', '73', '449', '2011'),
('Engine and other machine assemblers', 'engine-and-other-machine-assemblers', 'production-occupations', '30', '-', '25', '-', '4', '-', '2011'),
('Structural metal fabricators and fitters', 'structural-metal-fabricators-and-fitters', 'production-occupations', '33', '-', '31', '-', '1', '-', '2011'),
('Miscellaneous assemblers and fabricators', 'miscellaneous-assemblers-and-fabricators', 'production-occupations', '758', '519', '473', '566', '285', '479', '2011'),
('Bakers', 'bakers', 'production-occupations', '125', '448', '63', '471', '63', '416', '2011'),
('Butchers and other meat, poultry, and fish processing workers', 'butchers-and-other-meat-poultry-and-fish-processing-workers', 'production-occupations', '281', '504', '215', '515', '66', '479', '2011'),
('Food and tobacco roasting, baking, and drying machine operators and tenders', 'food-and-tobacco-roasting-baking-and-drying-machine-operators-and-tenders', 'production-occupations', '7', '-', '5', '-', '3', '-', '2011'),
('Food batchmakers', 'food-batchmakers', 'production-occupations', '63', '554', '35', '-', '28', '-', '2011'),
('Food cooking machine operators and tenders', 'food-cooking-machine-operators-and-tenders', 'production-occupations', '17', '-', '12', '-', '5', '-', '2011'),
('Food processing workers, all other', 'food-processing-workers-all-other', 'production-occupations', '104', '534', '78', '544', '25', '-', '2011'),
('Computer control programmers and operators', 'computer-control-programmers-and-operators', 'production-occupations', '70', '770', '65', '781', '5', '-', '2011'),
('Extruding and drawing machine setters, operators, and tenders, metal and plastic', 'extruding-and-drawing-machine-setters-operators-and-tenders-metal-and-plastic', 'production-occupations', '11', '-', '9', '-', '2', '-', '2011'),
('Forging machine setters, operators, and tenders, metal and plastic', 'forging-machine-setters-operators-and-tenders-metal-and-plastic', 'production-occupations', '5', '-', '4', '-', '1', '-', '2011'),
('Rolling machine setters, operators, and tenders, metal and plastic', 'rolling-machine-setters-operators-and-tenders-metal-and-plastic', 'production-occupations', '9', '-', '7', '-', '2', '-', '2011'),
('Cutting, punching, and press machine setters, operators, and tenders, metal and plastic', 'cutting-punching-and-press-machine-setters-operators-and-tenders-metal-and-plastic', 'production-occupations', '92', '591', '78', '608', '15', '-', '2011'),
('Drilling and boring machine tool setters, operators, and tenders, metal and plastic', 'drilling-and-boring-machine-tool-setters-operators-and-tenders-metal-and-plastic', 'production-occupations', '5', '-', '4', '-', '1', '-', '2011'),
('Grinding, lapping, polishing, and buffing machine tool setters, operators, and tenders, metal and plastic', 'grinding-lapping-polishing-and-buffing-machine-tool-setters-operators-and-tenders-metal-and-plastic', 'production-occupations', '60', '643', '57', '641', '3', '-', '2011'),
('Lathe and turning machine tool setters, operators, and tenders, metal and plastic', 'lathe-and-turning-machine-tool-setters-operators-and-tenders-metal-and-plastic', 'production-occupations', '15', '-', '15', '-', '0', '-', '2011'),
('Milling and planing machine setters, operators, and tenders, metal and plastic', 'milling-and-planing-machine-setters-operators-and-tenders-metal-and-plastic', 'production-occupations', '3', '-', '3', '-', '0', '-', '2011'),
('Machinists', 'machinists', 'production-occupations', '393', '755', '377', '767', '16', '-', '2011'),
('Metal furnace operators, tenders, pourers, and casters', 'metal-furnace-operators-tenders-pourers-and-casters', 'production-occupations', '19', '-', '18', '-', '1', '-', '2011'),
('Model makers and patternmakers, metal and plastic', 'model-makers-and-patternmakers-metal-and-plastic', 'production-occupations', '4', '-', '3', '-', '1', '-', '2011'),
('Molders and molding machine setters, operators, and tenders, metal and plastic', 'molders-and-molding-machine-setters-operators-and-tenders-metal-and-plastic', 'production-occupations', '47', '-', '35', '-', '12', '-', '2011'),
('Multiple machine tool setters, operators, and tenders, metal and plastic', 'multiple-machine-tool-setters-operators-and-tenders-metal-and-plastic', 'production-occupations', '3', '-', '3', '-', '0', '-', '2011'),
('Tool and die makers', 'tool-and-die-makers', 'production-occupations', '61', '920', '59', '930', '2', '-', '2011'),
('Welding, soldering, and brazing workers', 'welding-soldering-and-brazing-workers', 'production-occupations', '461', '679', '426', '695', '36', '-', '2011'),
('Heat treating equipment setters, operators, and tenders, metal and plastic', 'heat-treating-equipment-setters-operators-and-tenders-metal-and-plastic', 'production-occupations', '5', '-', '4', '-', '1', '-', '2011'),
('Layout workers, metal and plastic', 'layout-workers-metal-and-plastic', 'production-occupations', '8', '-', '7', '-', '1', '-', '2011'),
('Plating and coating machine setters, operators, and tenders, metal and plastic', 'plating-and-coating-machine-setters-operators-and-tenders-metal-and-plastic', 'production-occupations', '15', '-', '13', '-', '2', '-', '2011'),
('Tool grinders, filers, and sharpeners', 'tool-grinders-filers-and-sharpeners', 'production-occupations', '6', '-', '6', '-', '0', '-', '2011'),
('Metal workers and plastic workers, all other', 'metal-workers-and-plastic-workers-all-other', 'production-occupations', '356', '561', '275', '583', '81', '517', '2011'),
('Prepress technicians and workers', 'prepress-technicians-and-workers', 'production-occupations', '30', '-', '14', '-', '16', '-', '2011'),
('Printing press operators', 'printing-press-operators', 'production-occupations', '186', '613', '155', '646', '31', '-', '2011'),
('Print binding and finishing workers', 'print-binding-and-finishing-workers', 'production-occupations', '13', '-', '7', '-', '6', '-', '2011'),
('Laundry and dry-cleaning workers', 'laundry-and-dry-cleaning-workers', 'production-occupations', '115', '412', '52', '447', '64', '386', '2011'),
('Pressers, textile, garment, and related materials', 'pressers-textile-garment-and-related-materials', 'production-occupations', '37', '-', '13', '-', '24', '-', '2011'),
('Sewing machine operators', 'sewing-machine-operators', 'production-occupations', '112', '403', '28', '-', '84', '398', '2011'),
('Shoe and leather workers and repairers', 'shoe-and-leather-workers-and-repairers', 'production-occupations', '8', '-', '7', '-', '1', '-', '2011'),
('Shoe machine operators and tenders', 'shoe-machine-operators-and-tenders', 'production-occupations', '2', '-', '1', '-', '1', '-', '2011'),
('Tailors, dressmakers, and sewers', 'tailors-dressmakers-and-sewers', 'production-occupations', '46', '-', '13', '-', '33', '-', '2011'),
('Textile bleaching and dyeing machine operators and tenders', 'textile-bleaching-and-dyeing-machine-operators-and-tenders', 'production-occupations', '4', '-', '4', '-', '0', '-', '2011'),
('Textile cutting machine setters, operators, and tenders', 'textile-cutting-machine-setters-operators-and-tenders', 'production-occupations', '6', '-', '4', '-', '2', '-', '2011'),
('Textile knitting and weaving machine setters, operators, and tenders', 'textile-knitting-and-weaving-machine-setters-operators-and-tenders', 'production-occupations', '8', '-', '2', '-', '6', '-', '2011'),
('Textile winding, twisting, and drawing out machine setters, operators, and tenders', 'textile-winding-twisting-and-drawing-out-machine-setters-operators-and-tenders', 'production-occupations', '19', '-', '8', '-', '11', '-', '2011'),
('Extruding and forming machine setters, operators, and tenders, synthetic and glass fibers', 'extruding-and-forming-machine-setters-operators-and-tenders-synthetic-and-glass-fibers', 'production-occupations', '2', '-', '2', '-', '0', '-', '2011'),
('Fabric and apparel patternmakers', 'fabric-and-apparel-patternmakers', 'production-occupations', '5', '-', '2', '-', '2', '-', '2011'),
('Upholsterers', 'upholsterers', 'production-occupations', '34', '-', '30', '-', '4', '-', '2011'),
('Textile, apparel, and furnishings workers, all other', 'textile-apparel-and-furnishings-workers-all-other', 'production-occupations', '15', '-', '9', '-', '5', '-', '2011'),
('Cabinetmakers and bench carpenters', 'cabinetmakers-and-bench-carpenters', 'production-occupations', '42', '-', '41', '-', '1', '-', '2011'),
('Furniture finishers', 'furniture-finishers', 'production-occupations', '11', '-', '9', '-', '2', '-', '2011'),
('Model makers and patternmakers, wood', 'model-makers-and-patternmakers-wood', 'production-occupations', '1', '-', '1', '-', '0', '-', '2011');
INSERT INTO "public"."weekly_earnings" ("occupation", "slug", "parent", "total_number_workers", "median_weekly_earnings", "men_number_workers", "men_median_weekly_earnings", "women_number_workers", "women_median_weekly_earnings", "year") VALUES
('Sawing machine setters, operators, and tenders, wood', 'sawing-machine-setters-operators-and-tenders-wood', 'production-occupations', '31', '-', '30', '-', '1', '-', '2011'),
('Woodworking machine setters, operators, and tenders, except sawing', 'woodworking-machine-setters-operators-and-tenders-except-sawing', 'production-occupations', '17', '-', '15', '-', '2', '-', '2011'),
('Woodworkers, all other', 'woodworkers-all-other', 'production-occupations', '10', '-', '8', '-', '2', '-', '2011'),
('Power plant operators, distributors, and dispatchers', 'power-plant-operators-distributors-and-dispatchers', 'production-occupations', '53', '1,091', '52', '1,085', '1', '-', '2011'),
('Stationary engineers and boiler operators', 'stationary-engineers-and-boiler-operators', 'production-occupations', '93', '855', '92', '851', '1', '-', '2011'),
('Water and wastewater treatment plant and system operators', 'water-and-wastewater-treatment-plant-and-system-operators', 'production-occupations', '75', '780', '70', '788', '5', '-', '2011'),
('Miscellaneous plant and system operators', 'miscellaneous-plant-and-system-operators', 'production-occupations', '37', '-', '34', '-', '3', '-', '2011'),
('Chemical processing machine setters, operators, and tenders', 'chemical-processing-machine-setters-operators-and-tenders', 'production-occupations', '66', '853', '52', '947', '14', '-', '2011'),
('Crushing, grinding, polishing, mixing, and blending workers', 'crushing-grinding-polishing-mixing-and-blending-workers', 'production-occupations', '94', '659', '82', '702', '12', '-', '2011'),
('Cutting workers', 'cutting-workers', 'production-occupations', '69', '518', '55', '540', '13', '-', '2011'),
('Extruding, forming, pressing, and compacting machine setters, operators, and tenders', 'extruding-forming-pressing-and-compacting-machine-setters-operators-and-tenders', 'production-occupations', '31', '-', '28', '-', '3', '-', '2011'),
('Furnace, kiln, oven, drier, and kettle operators and tenders', 'furnace-kiln-oven-drier-and-kettle-operators-and-tenders', 'production-occupations', '11', '-', '11', '-', '0', '-', '2011'),
('Inspectors, testers, sorters, samplers, and weighers', 'inspectors-testers-sorters-samplers-and-weighers', 'production-occupations', '608', '675', '396', '792', '212', '541', '2011'),
('Jewelers and precious stone and metal workers', 'jewelers-and-precious-stone-and-metal-workers', 'production-occupations', '14', '-', '7', '-', '7', '-', '2011'),
('Medical, dental, and ophthalmic laboratory technicians', 'medical-dental-and-ophthalmic-laboratory-technicians', 'production-occupations', '68', '612', '34', '-', '34', '-', '2011'),
('Packaging and filling machine operators and tenders', 'packaging-and-filling-machine-operators-and-tenders', 'production-occupations', '259', '455', '120', '505', '139', '421', '2011'),
('Painting workers', 'painting-workers', 'production-occupations', '111', '602', '99', '608', '12', '-', '2011'),
('Photographic process workers and processing machine operators', 'photographic-process-workers-and-processing-machine-operators', 'production-occupations', '24', '-', '10', '-', '13', '-', '2011'),
('Semiconductor processors', 'semiconductor-processors', 'production-occupations', '4', '-', '3', '-', '1', '-', '2011'),
('Adhesive bonding machine operators and tenders', 'adhesive-bonding-machine-operators-and-tenders', 'production-occupations', '10', '-', '4', '-', '6', '-', '2011'),
('Cleaning, washing, and metal pickling equipment operators and tenders', 'cleaning-washing-and-metal-pickling-equipment-operators-and-tenders', 'production-occupations', '13', '-', '9', '-', '3', '-', '2011'),
('Cooling and freezing equipment operators and tenders', 'cooling-and-freezing-equipment-operators-and-tenders', 'production-occupations', '3', '-', '3', '-', '0', '-', '2011'),
('Etchers and engravers', 'etchers-and-engravers', 'production-occupations', '7', '-', '4', '-', '2', '-', '2011'),
('Molders, shapers, and casters, except metal and plastic', 'molders-shapers-and-casters-except-metal-and-plastic', 'production-occupations', '21', '-', '15', '-', '6', '-', '2011'),
('Paper goods machine setters, operators, and tenders', 'paper-goods-machine-setters-operators-and-tenders', 'production-occupations', '31', '-', '23', '-', '8', '-', '2011'),
('Tire builders', 'tire-builders', 'production-occupations', '17', '-', '16', '-', '1', '-', '2011'),
('Helpers--production workers', 'helpers-production-workers', 'production-occupations', '45', '-', '40', '-', '6', '-', '2011'),
('Production workers, all other', 'production-workers-all-other', 'production-occupations', '652', '579', '502', '612', '151', '483', '2011'),
('Transportation and material moving occupations', 'transportation-and-material-moving-occupations', 'production-transportation-and-material-moving-occupations', '6,275', '614', '5,489', '634', '786', '490', '2011'),
('Supervisors of transportation and material moving workers', 'supervisors-of-transportation-and-material-moving-workers', 'transportation-and-material-moving-occupations', '208', '761', '170', '773', '38', '-', '2011'),
('Aircraft pilots and flight engineers', 'aircraft-pilots-and-flight-engineers', 'transportation-and-material-moving-occupations', '93', '1,461', '89', '1,466', '4', '-', '2011'),
('Air traffic controllers and airfield operations specialists', 'air-traffic-controllers-and-airfield-operations-specialists', 'transportation-and-material-moving-occupations', '40', '-', '35', '-', '5', '-', '2011'),
('Flight attendants', 'flight-attendants', 'transportation-and-material-moving-occupations', '52', '791', '14', '-', '38', '-', '2011'),
('Ambulance drivers and attendants, except emergency medical technicians', 'ambulance-drivers-and-attendants-except-emergency-medical-technicians', 'transportation-and-material-moving-occupations', '9', '-', '9', '-', '0', '-', '2011'),
('Bus drivers', 'bus-drivers', 'transportation-and-material-moving-occupations', '310', '608', '188', '645', '122', '579', '2011'),
('Driver/sales workers and truck drivers', 'driver-sales-workers-and-truck-drivers', 'transportation-and-material-moving-occupations', '2,439', '705', '2,337', '712', '102', '511', '2011'),
('Motor vehicle operators, all other', 'motor-vehicle-operators-all-other', 'transportation-and-material-moving-occupations', '28', '-', '26', '-', '1', '-', '2011'),
('Locomotive engineers and operators', 'locomotive-engineers-and-operators', 'transportation-and-material-moving-occupations', '43', '-', '42', '-', '2', '-', '2011'),
('Railroad brake, signal, and switch operators', 'railroad-brake-signal-and-switch-operators', 'transportation-and-material-moving-occupations', '6', '-', '6', '-', '0', '-', '2011'),
('Railroad conductors and yardmasters', 'railroad-conductors-and-yardmasters', 'transportation-and-material-moving-occupations', '48', '-', '45', '-', '3', '-', '2011'),
('Subway, streetcar, and other rail transportation workers', 'subway-streetcar-and-other-rail-transportation-workers', 'transportation-and-material-moving-occupations', '14', '-', '12', '-', '2', '-', '2011'),
('Sailors and marine oilers', 'sailors-and-marine-oilers', 'transportation-and-material-moving-occupations', '23', '-', '23', '-', '0', '-', '2011'),
('Ship and boat captains and operators', 'ship-and-boat-captains-and-operators', 'transportation-and-material-moving-occupations', '35', '-', '35', '-', '0', '-', '2011'),
('Ship engineers', 'ship-engineers', 'transportation-and-material-moving-occupations', '6', '-', '6', '-', '0', '-', '2011'),
('Bridge and lock tenders', 'bridge-and-lock-tenders', 'transportation-and-material-moving-occupations', '7', '-', '7', '-', '0', '-', '2011'),
('Parking lot attendants', 'parking-lot-attendants', 'transportation-and-material-moving-occupations', '46', '-', '40', '-', '5', '-', '2011'),
('Automotive and watercraft service attendants', 'automotive-and-watercraft-service-attendants', 'transportation-and-material-moving-occupations', '42', '-', '40', '-', '2', '-', '2011'),
('Transportation inspectors', 'transportation-inspectors', 'transportation-and-material-moving-occupations', '32', '-', '28', '-', '5', '-', '2011'),
('Transportation attendants, except flight attendants', 'transportation-attendants-except-flight-attendants', 'transportation-and-material-moving-occupations', '13', '-', '5', '-', '8', '-', '2011'),
('Other transportation workers', 'other-transportation-workers', 'transportation-and-material-moving-occupations', '15', '-', '14', '-', '1', '-', '2011'),
('Conveyor operators and tenders', 'conveyor-operators-and-tenders', 'transportation-and-material-moving-occupations', '5', '-', '2', '-', '3', '-', '2011'),
('Crane and tower operators', 'crane-and-tower-operators', 'transportation-and-material-moving-occupations', '63', '739', '62', '736', '1', '-', '2011'),
('Dredge, excavating, and loading machine operators', 'dredge-excavating-and-loading-machine-operators', 'transportation-and-material-moving-occupations', '37', '-', '37', '-', '0', '-', '2011'),
('Hoist and winch operators', 'hoist-and-winch-operators', 'transportation-and-material-moving-occupations', '5', '-', '3', '-', '2', '-', '2011'),
('Industrial truck and tractor operators', 'industrial-truck-and-tractor-operators', 'transportation-and-material-moving-occupations', '491', '562', '456', '556', '35', '-', '2011'),
('Cleaners of vehicles and equipment', 'cleaners-of-vehicles-and-equipment', 'transportation-and-material-moving-occupations', '230', '465', '206', '458', '25', '-', '2011'),
('Laborers and freight, stock, and material movers, hand', 'laborers-and-freight-stock-and-material-movers-hand', 'transportation-and-material-moving-occupations', '1,260', '509', '1,085', '520', '175', '416', '2011'),
('Machine feeders and offbearers', 'machine-feeders-and-offbearers', 'transportation-and-material-moving-occupations', '32', '-', '27', '-', '5', '-', '2011'),
('Packers and packagers, hand', 'packers-and-packagers-hand', 'transportation-and-material-moving-occupations', '300', '397', '135', '396', '165', '397', '2011'),
('Pumping station operators', 'pumping-station-operators', 'transportation-and-material-moving-occupations', '26', '-', '26', '-', '0', '-', '2011'),
('Refuse and recyclable material collectors', 'refuse-and-recyclable-material-collectors', 'transportation-and-material-moving-occupations', '58', '541', '56', '580', '3', '-', '2011'),
('Mine shuttle car operators', 'mine-shuttle-car-operators', 'transportation-and-material-moving-occupations', '1', '-', '0', '-', '1', '-', '2011'),
('Tank car, truck, and ship loaders', 'tank-car-truck-and-ship-loaders', 'transportation-and-material-moving-occupations', '3', '-', '2', '-', '0', '-', '2011'),
('Material moving workers, all other', 'material-moving-workers-all-other', 'transportation-and-material-moving-occupations', '45', '-', '42', '-', '3', '-', '2011');

--
-- Cast wages to int
--

-- Set not enough data cols to 0
UPDATE weekly_earnings SET median_weekly_earnings = NULL WHERE median_weekly_earnings = '-';

UPDATE weekly_earnings SET men_median_weekly_earnings = NULL WHERE men_median_weekly_earnings = '-';

UPDATE weekly_earnings SET women_median_weekly_earnings = NULL WHERE women_median_weekly_earnings = '-';

-- Remove commas from number strings
UPDATE weekly_earnings SET median_weekly_earnings = REPLACE(median_weekly_earnings, ',', '')::numeric;

UPDATE weekly_earnings SET men_median_weekly_earnings = REPLACE(men_median_weekly_earnings, ',', '')::numeric;

UPDATE weekly_earnings SET women_median_weekly_earnings = REPLACE(women_median_weekly_earnings, ',', '')::numeric;

-- Cast wages to int

ALTER TABLE weekly_earnings ALTER COLUMN median_weekly_earnings TYPE int USING median_weekly_earnings::integer;

ALTER TABLE weekly_earnings ALTER COLUMN men_median_weekly_earnings TYPE int USING men_median_weekly_earnings::integer;

ALTER TABLE weekly_earnings ALTER COLUMN women_median_weekly_earnings TYPE int USING women_median_weekly_earnings::integer;


--
-- Populate occupations table
--

INSERT INTO occupations (name, slug, parent_slug_denorm)
SELECT
	occupation,
	slug,
	parent
FROM
	weekly_earnings ON CONFLICT DO NOTHING;

-- Set parent_id
UPDATE
	occupations o1
SET
	parent_id = o2.id
FROM
	occupations o2
WHERE
	o2.slug = o1.parent_slug_denorm;

--
-- Populate gaps table
--
-- Move over weekly_earnings data
INSERT INTO wage_gaps (occupation_id, all_median_weekly_earnings, men_median_weekly_earnings, women_median_weekly_earnings, year)
SELECT
	occupations.id,
	median_weekly_earnings,
	men_median_weekly_earnings,
	women_median_weekly_earnings,
	year
FROM
	weekly_earnings
	INNER JOIN occupations ON weekly_earnings.slug = occupations.slug;

-- Calculate cents_to_dollar
UPDATE
	wage_gaps
SET
	cents_to_dollar = ROUND((women_median_weekly_earnings::numeric * 100) / men_median_weekly_earnings::numeric)
WHERE
	men_median_weekly_earnings IS NOT NULL
	AND women_median_weekly_earnings IS NOT NULL;