InitJobTable.sql

-- choose database
use SkillsIdentifier;

-- create table
CREATE TABLE IF NOT EXISTS Job(
    ID INT UNSIGNED AUTO_INCREMENT,
    ONETSOCCode VARCHAR(20) NOT NULL,
    English VARCHAR(255) NOT NULL,
    French VARCHAR(255) NOT NULL,
    PRIMARY KEY (ID),
    INDEX ix_ONETSOCCode(ONETSOCCode(20)),
    INDEX ix_English(English(255)),
    INDEX ix_French(French(255))
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- insert data
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-1011.00','Chief Executives','Dirigeants');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-1011.03','Chief Sustainability Officers','Responsables du Développement Durable');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-1021.00','General and Operations Managers','Directeurs généraux et des opérations');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-2011.00','Advertising and Promotions Managers','Directeurs des publicités et des promotions');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-2021.00','Marketing Managers','Directeurs Marketing');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-2022.00','Sales Managers','Directeurs commerciaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-2031.00','Public Relations and Fundraising Managers','Relations publiques et gestionnaires de collecte de fonds');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-3011.00','Administrative Services Managers','Directeurs des services administratifs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-3021.00','Computer and Information Systems Managers','Directeur des systèmes informatiques et des ordinateurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-3031.01','Treasurers and Controllers','Trésoriers et contrôleurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-3031.02','Financial Managers, Branch or Department','Directeurs financiers (branche ou département)');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-3051.00','Industrial Production Managers','Gestionnaires de la production industrielle');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-3051.01','Quality Control Systems Managers','Gestionnaires des systèmes de contrôle de qualité');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-3051.02','Geothermal Production Managers','Directeur de production géothermique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-3051.03','Biofuels Production Managers','Directeurs de production de biocarburants');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-3051.04','Biomass Power Plant Managers','Directeurs d''usines de biomass');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-3051.06','Hydroelectric Production Managers','Directeurs de production hydro-électrique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-3061.00','Purchasing Managers','Directeurs des achats');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-3071.01','Transportation Managers','Gestionnaires des transports');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-3071.02','Storage and Distribution Managers','Gestionnaires du stockage et de la distribution');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-3071.03','Logistics Managers','Gestionnaires en logistique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-3111.00','Compensation and Benefits Managers','Gestionnaires de la rémunération et des avantages sociaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-3121.00','Human Resources Managers','Directeurs des ressources humaines');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-3131.00','Training and Development Managers','Responsables de la formation et du développement');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9013.01','Nursery and Greenhouse Managers','Gestionnaires de pépinières et de serres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9013.02','Farm and Ranch Managers','Directeurs d''exploitations agricoles et de ranchs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9013.03','Aquacultural Managers','Gestionnaires de l''aquaculture');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9021.00','Construction Managers','Directeurs de la construction');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9031.00','Education Administrators, Preschool and Childcare Center/Program','Administrateurs de l''éducation, Centre/Programme préscolaire et de garde d''enfants');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9032.00','Education Administrators, Elementary and Secondary School','Administrateurs de l''éducation, école primaire et secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9033.00','Education Administrators, Postsecondary','Administrateurs de l''éducation, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9039.01','Distance Learning Coordinators','Coordinateurs de l''enseignement à distance');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9039.02','Fitness and Wellness Coordinators','Coordinateurs de la condition physique et du bien-être');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9041.00','Architectural and Engineering Managers','Responsables de l''architecture et de l''ingénierie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9041.01','Biofuels/Biodiesel Technology and Product Development Managers','Responsables des technologies et du développement de produits pour les biocarburants et le biodiesel');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9051.00','Food Service Managers','Gestionnaires de services alimentaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9061.00','Funeral Service Managers','Directeurs de services funéraires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9071.00','Gaming Managers','Gestionnaires de jeux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9081.00','Lodging Managers','Gestionnaires de l''hébergement');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9111.00','Medical and Health Services Managers','Gestionnaires de services médicaux et de santé');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9121.00','Natural Sciences Managers','Gestionnaires des Sciences Naturelles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9121.01','Clinical Research Coordinators','Coordinateurs de la recherche clinique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9121.02','Water Resource Specialists','Spécialistes des ressources en eau');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9131.00','Postmasters and Mail Superintendents','Maîtres de poste et les surintendants du courrier');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9141.00','Property, Real Estate, and Community Association Managers','Gestionnaires de biens immobiliers, d''immeubles et d''associations communautaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9151.00','Social and Community Service Managers','Gestionnaires de services sociaux et communautaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9161.00','Emergency Management Directors','Directeurs de gestion des urgences');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9199.01','Regulatory Affairs Managers','Gestionnaires des affaires réglementaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9199.02','Compliance Managers','Gestionnaires de conformité');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9199.03','Investment Fund Managers','Gestionnaires de fonds d''investissement');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9199.04','Supply Chain Managers','Gestionnaires de la chaîne d’approvisionnement');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9199.07','Security Managers','Gestionnaires de sécurité');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9199.08','Loss Prevention Managers','Gestionnaires de prévention de pertes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9199.09','Wind Energy Operations Managers','Directeurs d''exploitation de l''énergie éolienne');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9199.10','Wind Energy Project Managers','Gestionnaires de projets d''énergie éolienne');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('11-9199.11','Brownfield Redevelopment Specialists and Site Managers','Spécialistes sites urbains contaminés réhabilitables et gestionnaires de sites');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1011.00','Agents and Business Managers of Artists, Performers, and Athletes','Agents et directeurs d''entreprises d''artistes, d''interprètes et d''athlètes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1021.00','Buyers and Purchasing Agents, Farm Products','Acheteurs et agents d''achat, produits agricoles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1022.00','Wholesale and Retail Buyers, Except Farm Products','Les acheteurs de gros et de détail, à l''exception des produits agricoles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1023.00','Purchasing Agents, Except Wholesale, Retail, and Farm Products','Agents d''achat, à l''exception du commerce de gros, de détail et de produits agricoles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1031.01','Claims Examiners, Property and Casualty Insurance','Sinistres, Assurance de dommages');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1031.02','Insurance Adjusters, Examiners, and Investigators','Experts, examinateurs et enquêteurs en assurance');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1032.00','Insurance Appraisers, Auto Damage','Évaluateurs Assurance, Dommages Auto');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1041.01','Environmental Compliance Inspectors','Les inspecteurs de la conformité environnementale');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1041.02','Licensing Examiners and Inspectors','Examinateurs et inspecteurs de license');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1041.03','Equal Opportunity Representatives and Officers','Représentants et responsables de l''égalité des chances');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1041.04','Government Property Inspectors and Investigators','Inspecteurs et enquêteurs des biens publics');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1041.06','Coroners','Médecins légistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1041.07','Regulatory Affairs Specialists','Spécialistes des affaires réglementaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1051.00','Cost Estimators','Les estimateurs de coût');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1071.00','Human Resources Specialists','Spécialistes des ressources humaines');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1074.00','Farm Labor Contractors','Entrepreneurs de main-d''œuvre agricole');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1075.00','Labor Relations Specialists','Spécialistes des relations de travail');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1081.00','Logisticians','Logisticiens');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1081.01','Logistics Engineers','Ingénieurs en logistique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1081.02','Logistics Analysts','Analystes en logistique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1111.00','Management Analysts','Analystes de gestion');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1121.00','Meeting, Convention, and Event Planners','Planificateurs de réunions, de congrès et d''événements');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1131.00','Fundraisers','Collecte de fonds');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1141.00','Compensation, Benefits, and Job Analysis Specialists','Spécialistes de la rémunération, des avantages sociaux et de l''analyse des emplois');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1151.00','Training and Development Specialists','Spécialistes de la formation et du développement');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1161.00','Market Research Analysts and Marketing Specialists','Analystes d''études de marché et spécialistes du marketing');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1199.01','Energy Auditors','Auditeurs de l''énergie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1199.02','Security Management Specialists','Spécialistes de la gestion de la sécurité');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1199.03','Customs Brokers','Courtiers en douane');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1199.04','Business Continuity Planners','Planificateurs de la continuité des activités');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1199.05','Sustainability Specialists','Spécialistes de la durabilité');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-1199.06','Online Merchants','Marchands en ligne');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-2011.01','Accountants','Comptables');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-2011.02','Auditors','Auditeurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-2021.01','Assessors','Évaluateurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-2021.02','Appraisers, Real Estate','Évaluateurs, Immobilier');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-2031.00','Budget Analysts','Analystes budgétaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-2041.00','Credit Analysts','Analystes de crédit');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-2051.00','Financial Analysts','Analystes financiers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-2052.00','Personal Financial Advisors','Conseillers financiers personnels');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-2053.00','Insurance Underwriters','Assureurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-2061.00','Financial Examiners','Examinateurs financiers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-2071.00','Credit Counselors','Conseillers en crédit');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-2071.01','Loan Counselors','Conseillers en prêts');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-2072.00','Loan Officers','Agents de prêts');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-2081.00','Tax Examiners and Collectors, and Revenue Agents','Contrôleurs et percepteurs d''impôts et agents des recettes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-2082.00','Tax Preparers','Préparateurs fiscaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-2099.02','Risk Management Specialists','Spécialistes de la gestion des risques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('13-2099.04','Fraud Examiners, Investigators and Analysts','Examinateurs, enquêteurs et analystes en matière de fraude');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1111.00','Computer and Information Research Scientists','Chercheurs en informatique et en information');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1121.00','Computer Systems Analysts','Analystes de systèmes informatiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1121.01','Informatics Nurse Specialists','Infirmières spécialisées en informatique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1122.00','Information Security Analysts','Analystes de la sécurité de l''information');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1131.00','Computer Programmers','Programmeurs informatiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1132.00','Software Developers, Applications','Développeurs de logiciels, applications');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1133.00','Software Developers, Systems Software','Développeurs de logiciels, logiciels de systèmes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1134.00','Web Developers','Développeurs Web');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1141.00','Database Administrators','Administrateurs de la base de données');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1142.00','Network and Computer Systems Administrators','Administrateurs de réseaux et de systèmes informatiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1143.00','Computer Network Architects','Architectes de réseaux informatiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1143.01','Telecommunications Engineering Specialists','Spécialistes en ingénierie des télécommunications');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1151.00','Computer User Support Specialists','Spécialistes de l''assistance aux utilisateurs d''ordinateurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1152.00','Computer Network Support Specialists','Spécialistes du soutien aux réseaux informatiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1199.01','Software Quality Assurance Engineers and Testers','Ingénieurs et testeurs en assurance qualité des logiciels');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1199.02','Computer Systems Engineers/Architects','Ingénieurs/Architectes de systèmes informatiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1199.03','Web Administrators','Les administrateurs Web');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1199.04','Geospatial Information Scientists and Technologists','Scientifiques et technologues de l''information géospatiale');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1199.05','Geographic Information Systems Technicians','Techniciens en systèmes d''information géographique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1199.06','Database Architects','Architectes de la base de données');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1199.08','Business Intelligence Analysts','Analystes de l''intelligence économique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1199.09','Information Technology Project Managers','Chefs de projet en technologies de l''information');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1199.10','Search Marketing Strategists','Stratégistes en marketing de recherche');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1199.11','Video Game Designers','Concepteurs de jeux vidéo');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-1199.12','Document Management Specialists','Spécialistes de la gestion des documents');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-2011.00','Actuaries','Actuaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-2021.00','Mathematicians','Mathématiciens');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-2031.00','Operations Research Analysts','Analystes de la recherche opérationnelle');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-2041.00','Statisticians','Statisticiens');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-2041.01','Biostatisticians','Biostatisticiens');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-2041.02','Clinical Data Managers','Gestionnaires de données cliniques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('15-2091.00','Mathematical Technicians','Techniciens en mathématiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-1011.00','Architects, Except Landscape and Naval','Architectes, sauf paysagistes et navals');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-1012.00','Landscape Architects','Les architectes paysagistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-1021.00','Cartographers and Photogrammetrists','Cartographes et photogrammétristes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-1022.00','Surveyors','Arpenteurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-1022.01','Geodetic Surveyors','Géomètres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2011.00','Aerospace Engineers','Ingénieurs en aérospatiale');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2021.00','Agricultural Engineers','Ingénieurs agronomes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2031.00','Biomedical Engineers','Ingénieurs biomédicaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2041.00','Chemical Engineers','Ingénieurs chimistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2051.00','Civil Engineers','Ingénieurs civils');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2051.01','Transportation Engineers','Ingénieurs des transports');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2061.00','Computer Hardware Engineers','Ingénieurs en matériel informatique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2071.00','Electrical Engineers','Ingénieurs électriciens');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2072.00','Electronics Engineers, Except Computer','Ingénieurs en électronique, sauf en informatique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2072.01','Radio Frequency Identification Device Specialists','Spécialistes des dispositifs d''identification par radiofréquence');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2081.00','Environmental Engineers','Ingénieurs en environnement');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2081.01','Water/Wastewater Engineers','Ingénieurs eau/eaux usées');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2111.01','Industrial Safety and Health Engineers','Ingénieurs en sécurité et santé au travail');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2111.02','Fire-Prevention and Protection Engineers','Ingénieurs en prévention et protection contre les incendies');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2111.03','Product Safety Engineers','Ingénieurs en sécurité des produits');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2112.00','Industrial Engineers','Ingénieurs industriels');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2112.01','Human Factors Engineers and Ergonomists','Ingénieurs en facteurs humains et ergonomes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2121.01','Marine Engineers','Ingénieurs de la marine');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2121.02','Marine Architects','Architectes de la mer');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2131.00','Materials Engineers','Ingénieurs en matériaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2141.00','Mechanical Engineers','Ingénieurs en mécanique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2141.01','Fuel Cell Engineers','Ingénieurs en piles à combustible');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2141.02','Automotive Engineers','Ingénieurs automobiles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2151.00','Mining and Geological Engineers, Including Mining Safety Engineers','Ingénieurs des mines et géologues, y compris les ingénieurs en sécurité minière');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2161.00','Nuclear Engineers','Ingénieurs nucléaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2171.00','Petroleum Engineers','Ingénieurs du pétrole');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2199.01','Biochemical Engineers','Ingénieurs en biochimie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2199.02','Validation Engineers','Ingénieurs de validation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2199.03','Energy Engineers','Ingénieurs en énergie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2199.04','Manufacturing Engineers','Ingénieurs de fabrication');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2199.05','Mechatronics Engineers','Ingénieurs en mécatronique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2199.06','Microsystems Engineers','Ingénieurs en microsystèmes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2199.07','Photonics Engineers','Ingénieurs en photonique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2199.08','Robotics Engineers','Ingénieurs en robotique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2199.09','Nanosystems Engineers','Ingénieurs en nanosystèmes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2199.10','Wind Energy Engineers','Ingénieurs en énergie éolienne');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-2199.11','Solar Energy Systems Engineers','Ingénieurs en systèmes d''énergie solaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3011.01','Architectural Drafters','Dessinateurs d''architecture');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3011.02','Civil Drafters','Rédacteurs civils');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3012.01','Electronic Drafters','Rédacteurs électroniques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3012.02','Electrical Drafters','Rédacteurs électriques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3013.00','Mechanical Drafters','Dessinateurs mécaniques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3021.00','Aerospace Engineering and Operations Technicians','Techniciens d''ingénierie et d''exploitation aérospatiale');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3022.00','Civil Engineering Technicians','Techniciens en génie civil');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3023.01','Electronics Engineering Technicians','Techniciens en génie électronique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3023.03','Electrical Engineering Technicians','Techniciens en génie électrique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3024.00','Electro-Mechanical Technicians','Techniciens en électromécanique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3024.01','Robotics Technicians','Techniciens en robotique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3025.00','Environmental Engineering Technicians','Techniciens en ingénierie environnementale');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3026.00','Industrial Engineering Technicians','Techniciens en génie industriel');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3027.00','Mechanical Engineering Technicians','Techniciens en génie mécanique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3027.01','Automotive Engineering Technicians','Techniciens en génie automobile');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3029.01','Non-Destructive Testing Specialists','Spécialistes des essais non destructifs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3029.02','Electrical Engineering Technologists','Technologues en génie électrique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3029.03','Electromechanical Engineering Technologists','Technologues en génie électromécanique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3029.04','Electronics Engineering Technologists','Technologues en génie électronique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3029.05','Industrial Engineering Technologists','Technologues en génie industriel');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3029.06','Manufacturing Engineering Technologists','Technologues en génie de la fabrication');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3029.07','Mechanical Engineering Technologists','Technologues en génie mécanique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3029.08','Photonics Technicians','Techniciens en photonique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3029.09','Manufacturing Production Technicians','Techniciens de production manufacturière');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3029.12','Nanotechnology Engineering Technicians','Techniciens en ingénierie des nanotechnologies');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3031.01','Surveying Technicians','Techniciens de topographie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('17-3031.02','Mapping Technicians','Techniciens en cartographie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-1011.00','Animal Scientists','Scientifiques animaliers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-1012.00','Food Scientists and Technologists','Scientifiques et technologues de l''alimentation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-1013.00','Soil and Plant Scientists','Scientifiques du sol et des plantes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-1020.01','Biologists','Biologistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-1021.00','Biochemists and Biophysicists','Biochimistes et biophysiciens');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-1022.00','Microbiologists','Microbiologistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-1023.00','Zoologists and Wildlife Biologists','Zoologistes et biologistes de la faune sauvage');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-1029.01','Bioinformatics Scientists','Scientifiques en bio-informatique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-1029.02','Molecular and Cellular Biologists','Biologistes moléculaires et cellulaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-1029.03','Geneticists','Généticiens');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-1031.01','Soil and Water Conservationists','Conservationistes des sols et de l''eau');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-1031.02','Range Managers','Directeurs de gamme');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-1031.03','Park Naturalists','Naturalistes des parcs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-1032.00','Foresters','Forestiers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-1041.00','Epidemiologists','Epidémiologistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-1042.00','Medical Scientists, Except Epidemiologists','Scientifiques médicaux, sauf épidémiologistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-2011.00','Astronomers','Astronomes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-2012.00','Physicists','Physiciens');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-2021.00','Atmospheric and Space Scientists','Scientifiques de l''atmosphère et de l''espace');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-2031.00','Chemists','Chimistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-2032.00','Materials Scientists','Scientifiques des matériaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-2041.00','Environmental Scientists and Specialists, Including Health','Scientifiques et spécialistes de l''environnement, y compris de la santé');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-2041.01','Climate Change Analysts','Analystes du changement climatique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-2041.02','Environmental Restoration Planners','Planificateurs de la restauration de l''environnement');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-2041.03','Industrial Ecologists','Écologistes industriels');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-2042.00','Geoscientists, Except Hydrologists and Geographers','Géoscientifiques, à l''exception des hydrologues et des géographes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-2043.00','Hydrologists','Hydrologues');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-2099.01','Remote Sensing Scientists and Technologists','Scientifiques et technologues en télédétection');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-3011.00','Economists','Économistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-3011.01','Environmental Economists','Économistes de l''environnement');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-3022.00','Survey Researchers','Chercheurs d''enquête');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-3031.01','School Psychologists','Psychologues scolaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-3031.02','Clinical Psychologists','Psychologues cliniques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-3031.03','Counseling Psychologists','Psychologues de l''orientation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-3032.00','Industrial-Organizational Psychologists','Psychologues industriels et organisationnels');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-3039.01','Neuropsychologists and Clinical Neuropsychologists','Neuropsychologues et neuropsychologues cliniques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-3041.00','Sociologists','Sociologues');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-3051.00','Urban and Regional Planners','Aménageurs urbains et régionaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-3091.01','Anthropologists','Anthropologues');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-3091.02','Archeologists','Archéologues');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-3092.00','Geographers','Géographes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-3093.00','Historians','Historiens');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-3094.00','Political Scientists','Politologues');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-3099.01','Transportation Planners','Planificateurs de transport');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-4011.01','Agricultural Technicians','Techniciens agricoles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-4011.02','Food Science Technicians','Techniciens en sciences alimentaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-4021.00','Biological Technicians','Techniciens en biologie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-4031.00','Chemical Technicians','Techniciens en chimie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-4041.01','Geophysical Data Technicians','Techniciens en données géophysiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-4041.02','Geological Sample Test Technicians','Techniciens chargés de tester les échantillons géologiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-4051.01','Nuclear Equipment Operation Technicians','Techniciens d''exploitation des équipements nucléaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-4051.02','Nuclear Monitoring Technicians','Techniciens de surveillance nucléaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-4061.00','Social Science Research Assistants','Assistants de recherche en sciences sociales');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-4061.01','City and Regional Planning Aides','Aides à la planification urbaine et régionale');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-4091.00','Environmental Science and Protection Technicians, Including Health','Techniciens en sciences et protection de l''environnement, y compris la santé');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-4092.00','Forensic Science Technicians','Techniciens en sciences médico-légales');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-4093.00','Forest and Conservation Technicians','Techniciens de la forêt et de la conservation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-4099.01','Quality Control Analysts','Analystes du contrôle de la qualité');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-4099.02','Precision Agriculture Technicians','Techniciens en agriculture de précision');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('19-4099.03','Remote Sensing Technicians','Techniciens en télédétection');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('21-1011.00','Substance Abuse and Behavioral Disorder Counselors','Conseillers en matière de toxicomanie et de troubles du comportement');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('21-1012.00','Educational, Guidance, School, and Vocational Counselors','Conseillers d''éducation, d''orientation, d''école et de formation professionnelle');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('21-1013.00','Marriage and Family Therapists','Thérapeutes du mariage et de la famille');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('21-1014.00','Mental Health Counselors','Conseillers en santé mentale');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('21-1015.00','Rehabilitation Counselors','Conseillers en réadaptation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('21-1021.00','Child, Family, and School Social Workers','Travailleurs sociaux pour l''enfance, la famille et l''école');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('21-1022.00','Healthcare Social Workers','Travailleurs sociaux du secteur de la santé');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('21-1023.00','Mental Health and Substance Abuse Social Workers','Travailleurs sociaux spécialisés dans la santé mentale et la toxicomanie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('21-1091.00','Health Educators','Éducateurs de la santé');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('21-1092.00','Probation Officers and Correctional Treatment Specialists','Agents de probation et spécialistes du traitement correctionnel');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('21-1093.00','Social and Human Service Assistants','Assistants des services sociaux et humains');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('21-1094.00','Community Health Workers','Agents de santé communautaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('21-2011.00','Clergy','Le clergé');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('21-2021.00','Directors, Religious Activities and Education','Réalisateurs, activités religieuses et éducation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('23-1011.00','Lawyers','Avocats');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('23-1012.00','Judicial Law Clerks','Commissaires judiciaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('23-1021.00','Administrative Law Judges, Adjudicators, and Hearing Officers','Juges de droit administratif, arbitres et conseillers-auditeurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('23-1022.00','Arbitrators, Mediators, and Conciliators','Arbitres, médiateurs et conciliateurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('23-1023.00','Judges, Magistrate Judges, and Magistrates','Juges et magistrats');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('23-2011.00','Paralegals and Legal Assistants','Parajuristes et assistants juridiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('23-2091.00','Court Reporters','Rapporteurs de la Cour');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('23-2093.00','Title Examiners, Abstractors, and Searchers','Examinateurs de titres, résumés et chercheurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1011.00','Business Teachers, Postsecondary','Enseignants en commerce, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1021.00','Computer Science Teachers, Postsecondary','Professeurs d''informatique, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1022.00','Mathematical Science Teachers, Postsecondary','Professeurs de sciences mathématiques, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1031.00','Architecture Teachers, Postsecondary','Professeurs d''architecture, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1032.00','Engineering Teachers, Postsecondary','Professeurs d''ingénierie, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1041.00','Agricultural Sciences Teachers, Postsecondary','Enseignants en sciences agricoles, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1042.00','Biological Science Teachers, Postsecondary','Professeurs de sciences biologiques, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1043.00','Forestry and Conservation Science Teachers, Postsecondary','Professeurs de sciences forestières et de conservation, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1051.00','Atmospheric, Earth, Marine, and Space Sciences Teachers, Postsecondary','Enseignants en sciences de l''atmosphère, de la terre, de la mer et de l''espace, niveau postsecondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1052.00','Chemistry Teachers, Postsecondary','Professeurs de chimie, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1053.00','Environmental Science Teachers, Postsecondary','Professeurs de sciences de l''environnement, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1054.00','Physics Teachers, Postsecondary','Professeurs de physique, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1061.00','Anthropology and Archeology Teachers, Postsecondary','Professeurs d''anthropologie et d''archéologie, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1062.00','Area, Ethnic, and Cultural Studies Teachers, Postsecondary','Enseignants des études régionales, ethniques et culturelles, post-secondaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1063.00','Economics Teachers, Postsecondary','Professeurs d''économie, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1064.00','Geography Teachers, Postsecondary','Professeurs de géographie, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1065.00','Political Science Teachers, Postsecondary','Professeurs de sciences politiques, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1066.00','Psychology Teachers, Postsecondary','Professeurs de psychologie, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1067.00','Sociology Teachers, Postsecondary','Professeurs de sociologie, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1071.00','Health Specialties Teachers, Postsecondary','Enseignants des spécialités de la santé, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1072.00','Nursing Instructors and Teachers, Postsecondary','Instructeurs et enseignants en soins infirmiers, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1081.00','Education Teachers, Postsecondary','Enseignants de l''enseignement, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1082.00','Library Science Teachers, Postsecondary','Professeurs de bibliothéconomie, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1111.00','Criminal Justice and Law Enforcement Teachers, Postsecondary','Enseignants en justice pénale et en application de la loi, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1112.00','Law Teachers, Postsecondary','Professeurs de droit, enseignement postsecondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1113.00','Social Work Teachers, Postsecondary','Professeurs de travail social, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1121.00','Art, Drama, and Music Teachers, Postsecondary','Professeurs d''art, d''art dramatique et de musique, niveau postsecondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1122.00','Communications Teachers, Postsecondary','Enseignants en communication, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1123.00','English Language and Literature Teachers, Postsecondary','Professeurs de langue et de littérature anglaises, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1124.00','Foreign Language and Literature Teachers, Postsecondary','Professeurs de langues et de littérature étrangères, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1125.00','History Teachers, Postsecondary','Professeurs d''histoire, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1126.00','Philosophy and Religion Teachers, Postsecondary','Enseignants de philosophie et de religion, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1191.00','Graduate Teaching Assistants','Assistants d''enseignement diplômés');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1192.00','Home Economics Teachers, Postsecondary','Professeurs d''économie domestique, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1193.00','Recreation and Fitness Studies Teachers, Postsecondary','Professeurs de loisirs et d''éducation physique, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-1194.00','Vocational Education Teachers, Postsecondary','Enseignants de l''enseignement professionnel, post-secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-2011.00','Preschool Teachers, Except Special Education','Enseignants du préscolaire, sauf pour l''enseignement spécial');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-2012.00','Kindergarten Teachers, Except Special Education','Enseignants de maternelle, sauf pour l''enseignement spécial');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-2021.00','Elementary School Teachers, Except Special Education','Enseignants du primaire, sauf pour l''enseignement spécial');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-2022.00','Middle School Teachers, Except Special and Career/Technical Education','Enseignants du collège, sauf enseignement spécial et professionnel/technique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-2023.00','Career/Technical Education Teachers, Middle School','Enseignants de l''enseignement professionnel/technique, collège');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-2031.00','Secondary School Teachers, Except Special and Career/Technical Education','Enseignants du secondaire, sauf enseignement spécialisé et professionnel/technique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-2032.00','Career/Technical Education Teachers, Secondary School','Enseignants de l''enseignement professionnel/technique, école secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-2052.00','Special Education Teachers, Kindergarten and Elementary School','Enseignants de l''éducation spéciale, école maternelle et élémentaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-2053.00','Special Education Teachers, Middle School','Enseignants de l''enseignement spécial, collège');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-2054.00','Special Education Teachers, Secondary School','Enseignants de l''enseignement spécial, école secondaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-2059.01','Adapted Physical Education Specialists','Spécialistes de l''éducation physique adaptée');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-3011.00','Adult Basic and Secondary Education and Literacy Teachers and Instructors','Enseignants et instructeurs de l''éducation de base et secondaire des adultes et de l''alphabétisation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-3021.00','Self-Enrichment Education Teachers','Enseignants de l''enseignement de l''auto-enrichissement');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-3099.02','Tutors','Tuteurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-4011.00','Archivists','Archivistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-4012.00','Curators','Conservateurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-4013.00','Museum Technicians and Conservators','Techniciens et conservateurs de musée');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-4021.00','Librarians','Bibliothécaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-4031.00','Library Technicians','Bibliotechniciens');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-9011.00','Audio-Visual and Multimedia Collections Specialists','Spécialistes des collections audiovisuelles et multimédias');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-9021.00','Farm and Home Management Advisors','Conseillers en gestion agricole et domestique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-9031.00','Instructional Coordinators','Coordinateurs pédagogiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-9031.01','Instructional Designers and Technologists','Concepteurs et technologues de l''enseignement');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('25-9041.00','Teacher Assistants','Assistants d''enseignants');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-1011.00','Art Directors','Directeurs artistiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-1012.00','Craft Artists','Artisans d''art');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-1013.00','Fine Artists, Including Painters, Sculptors, and Illustrators','Artistes des beaux-arts, y compris les peintres, les sculpteurs et les illustrateurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-1014.00','Multimedia Artists and Animators','Artistes et animateurs multimédia');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-1021.00','Commercial and Industrial Designers','Concepteurs commerciaux et industriels');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-1022.00','Fashion Designers','Créateurs de mode');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-1023.00','Floral Designers','Designers floraux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-1024.00','Graphic Designers','Concepteurs graphiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-1025.00','Interior Designers','Designers d''intérieur');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-1026.00','Merchandise Displayers and Window Trimmers','Présentoirs de marchandises et coupe-vitres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-1027.00','Set and Exhibit Designers','Concepteurs de décors et d''expositions');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-2011.00','Actors','Acteurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-2012.01','Producers','Producteurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-2012.02','Directors- Stage, Motion Pictures, Television, and Radio','Réalisateurs - Scène, cinéma, télévision et radio');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-2012.03','Program Directors','Directeurs de programmes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-2012.04','Talent Directors','Directeurs de talent');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-2012.05','Technical Directors/Managers','Directeurs et gestionnaires techniques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-2021.00','Athletes and Sports Competitors','Athlètes et compétiteurs sportifs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-2022.00','Coaches and Scouts','Entraîneurs et scouts');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-2023.00','Umpires, Referees, and Other Sports Officials','Arbitres, arbitres et autres responsables sportifs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-2031.00','Dancers','Danseurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-2032.00','Choreographers','Chorégraphes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-2041.01','Music Directors','Directeurs musicaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-2041.04','Music Composers and Arrangers','Compositeurs et arrangeurs de musique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-2042.01','Singers','Chanteurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-2042.02','Musicians, Instrumental','Musiciens, Instrumental');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-3011.00','Radio and Television Announcers','Annonceurs de la radio et de la télévision');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-3012.00','Public Address System and Other Announcers','Système de sonorisation et autres annonceurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-3021.00','Broadcast News Analysts','Analystes de l''information audiovisuelle');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-3022.00','Reporters and Correspondents','Reporters et correspondants');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-3031.00','Public Relations Specialists','Spécialistes des relations publiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-3041.00','Editors','Rédacteurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-3042.00','Technical Writers','Rédacteurs techniques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-3043.04','Copy Writers','Rédacteurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-3043.05','Poets, Lyricists and Creative Writers','Poètes, paroliers et écrivains créatifs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-3091.00','Interpreters and Translators','Interprètes et traducteurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-4011.00','Audio and Video Equipment Technicians','Techniciens en équipement audio et vidéo');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-4012.00','Broadcast Technicians','Techniciens de radiodiffusion');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-4013.00','Radio Operators','Opérateurs radio');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-4014.00','Sound Engineering Technicians','Techniciens du son');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-4021.00','Photographers','Photographes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-4031.00','Camera Operators, Television, Video, and Motion Picture','Caméras, télévision, vidéo et cinéma');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('27-4032.00','Film and Video Editors','Éditeurs de films et de vidéos');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1011.00','Chiropractors','Chiropracteurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1021.00','Dentists, General','Dentistes, général');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1022.00','Oral and Maxillofacial Surgeons','Chirurgiens buccaux et maxillo-faciaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1023.00','Orthodontists','Orthodontistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1024.00','Prosthodontists','Prosthodontistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1031.00','Dietitians and Nutritionists','Diététiciens et nutritionnistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1041.00','Optometrists','Optométristes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1051.00','Pharmacists','Pharmaciens');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1061.00','Anesthesiologists','Anesthésiologistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1062.00','Family and General Practitioners','Médecins de famille et généralistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1063.00','Internists, General','Internistes, général');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1064.00','Obstetricians and Gynecologists','Obstétriciens et gynécologues');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1065.00','Pediatricians, General','Pédiatres, général');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1066.00','Psychiatrists','Psychiatres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1067.00','Surgeons','Chirurgiens');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1069.01','Allergists and Immunologists','Allergistes et immunologistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1069.02','Dermatologists','Dermatologues');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1069.03','Hospitalists','Hospitaliste');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1069.04','Neurologists','Neurologues');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1069.05','Nuclear Medicine Physicians','Médecins en médecine nucléaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1069.06','Ophthalmologists','Ophtalmologues');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1069.07','Pathologists','Pathologistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1069.08','Physical Medicine and Rehabilitation Physicians','Médecine physique et de réadaptation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1069.09','Preventive Medicine Physicians','Médecins de médecine préventive');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1069.10','Radiologists','Radiologues');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1069.11','Sports Medicine Physicians','Médecins du sport');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1069.12','Urologists','Urologues');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1071.00','Physician Assistants','Assistants médicaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1071.01','Anesthesiologist Assistants','Anesthésistes assistants');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1081.00','Podiatrists','Podologues');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1122.00','Occupational Therapists','Ergothérapeutes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1122.01','Low Vision Therapists, Orientation and Mobility Specialists, and Vision Rehabilitation Therapists','Thérapeutes spécialisés dans la basse vision, l''orientation et la mobilité, et les thérapies de réadaptation visuelle');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1123.00','Physical Therapists','Physiothérapeutes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1124.00','Radiation Therapists','Radiothérapeutes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1125.00','Recreational Therapists','Thérapeutes en loisirs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1125.01','Art Therapists','Les art-thérapeutes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1125.02','Music Therapists','Musicothérapeutes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1126.00','Respiratory Therapists','Thérapeutes respiratoires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1127.00','Speech-Language Pathologists','Orthophonistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1128.00','Exercise Physiologists','Physiologistes de l''exercice');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1131.00','Veterinarians','Vétérinaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1141.00','Registered Nurses','Infirmières diplômées');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1141.01','Acute Care Nurses','Infirmières de soins aigus');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1141.02','Advanced Practice Psychiatric Nurses','Infirmières psychiatriques en pratique avancée');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1141.03','Critical Care Nurses','Infirmières de soins intensifs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1141.04','Clinical Nurse Specialists','Infirmières cliniciennes spécialisées');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1151.00','Nurse Anesthetists','Infirmières anesthésistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1161.00','Nurse Midwives','Infirmières sages-femmes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1171.00','Nurse Practitioners','Infirmières praticiennes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1181.00','Audiologists','Audiologistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1199.01','Acupuncturists','Acupuncteurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1199.04','Naturopathic Physicians','Médecins naturopathes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-1199.05','Orthoptists','Orthoptistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2011.00','Medical and Clinical Laboratory Technologists','Technologues de laboratoire médical et clinique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2011.01','Cytogenetic Technologists','Techniciens en cytogénétique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2011.02','Cytotechnologists','Cytotechnologues');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2011.03','Histotechnologists and Histologic Technicians','Histotechniciens et techniciens histologiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2012.00','Medical and Clinical Laboratory Technicians','Techniciens de laboratoire médical et clinique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2021.00','Dental Hygienists','Hygiénistes dentaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2031.00','Cardiovascular Technologists and Technicians','Technologues et techniciens cardiovasculaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2032.00','Diagnostic Medical Sonographers','Échographes médicaux diagnostiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2033.00','Nuclear Medicine Technologists','Technologues en médecine nucléaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2034.00','Radiologic Technologists','Technologues en radiologie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2035.00','Magnetic Resonance Imaging Technologists','Technologues en imagerie par résonance magnétique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2041.00','Emergency Medical Technicians and Paramedics','Techniciens et paramédicaux d''urgence');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2051.00','Dietetic Technicians','Techniciens en diététique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2052.00','Pharmacy Technicians','Techniciens en pharmacie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2053.00','Psychiatric Technicians','Techniciens psychiatriques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2054.00','Respiratory Therapy Technicians','Techniciens en thérapie respiratoire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2055.00','Surgical Technologists','Technologues en chirurgie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2056.00','Veterinary Technologists and Technicians','Technologues et techniciens vétérinaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2057.00','Ophthalmic Medical Technicians','Techniciens en médecine ophtalmique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2061.00','Licensed Practical and Licensed Vocational Nurses','Infirmières auxiliaires et professionnelles diplômées');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2071.00','Medical Records and Health Information Technicians','Techniciens de l''information sanitaire et des Dossiers médicaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2081.00','Opticians, Dispensing','Opticiens, Distributeurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2091.00','Orthotists and Prosthetists','Orthésistes et prothésistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2092.00','Hearing Aid Specialists','Spécialistes des aides auditives');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2099.01','Neurodiagnostic Technologists','Technologues du neurodiagnostic');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2099.05','Ophthalmic Medical Technologists','Techniciens en médecine ophtalmique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2099.06','Radiologic Technicians','Techniciens en radiologie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-2099.07','Surgical Assistants','Assistants chirurgicaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-9011.00','Occupational Health and Safety Specialists','Spécialistes de la santé et de la sécurité au travail');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-9012.00','Occupational Health and Safety Technicians','Techniciens en santé et sécurité au travail');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-9091.00','Athletic Trainers','Entraîneurs athlétiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-9092.00','Genetic Counselors','Conseillers en génétique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('29-9099.01','Midwives','Sages-femmes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('31-1011.00','Home Health Aides','Aides à la santé à domicile');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('31-1013.00','Psychiatric Aides','Aides psychiatriques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('31-1014.00','Nursing Assistants','Infirmières auxiliaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('31-1015.00','Orderlies','Aides-soignants');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('31-2011.00','Occupational Therapy Assistants','Assistants ergothérapeutes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('31-2012.00','Occupational Therapy Aides','Aides à l''ergothérapie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('31-2021.00','Physical Therapist Assistants','Assistants physiothérapeutes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('31-2022.00','Physical Therapist Aides','Aides des physiothérapeutes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('31-9011.00','Massage Therapists','Massothérapeutes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('31-9091.00','Dental Assistants','Assistants dentaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('31-9092.00','Medical Assistants','Assistants médicaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('31-9093.00','Medical Equipment Preparers','Préparateurs d''équipement médical');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('31-9094.00','Medical Transcriptionists','Transcripteurs médicaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('31-9095.00','Pharmacy Aides','Aides pour les pharmacies');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('31-9096.00','Veterinary Assistants and Laboratory Animal Caretakers','Assistants vétérinaires et gardiens d''animaux de laboratoire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('31-9097.00','Phlebotomists','Phlébotomistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('31-9099.01','Speech-Language Pathology Assistants','Assistants orthophoniques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('31-9099.02','Endoscopy Technicians','Techniciens en endoscopie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-1011.00','First-Line Supervisors of Correctional Officers','Superviseurs de première ligne des agents de l''administration pénitentiaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-1012.00','First-Line Supervisors of Police and Detectives','Superviseurs de première ligne de la police et des détectives');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-1021.01','Municipal Fire Fighting and Prevention Supervisors','Superviseurs municipaux de prévention et de lutte contre l''incendie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-1021.02','Forest Fire Fighting and Prevention Supervisors','Superviseurs de la prévention et de la lutte contre les incendies de forêt');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-2011.01','Municipal Firefighters','Pompiers municipaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-2011.02','Forest Firefighters','Pompiers de forêt');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-2021.01','Fire Inspectors','Inspecteurs du feu');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-2021.02','Fire Investigators','Enquêteurs sur les incendies');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-2022.00','Forest Fire Inspectors and Prevention Specialists','Inspecteurs et spécialistes de la prévention des incendies de forêt');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-3011.00','Bailiffs','Huissiers de justice');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-3012.00','Correctional Officers and Jailers','Agents pénitentiaires et prisonniers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-3021.01','Police Detectives','Détectives de police');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-3021.02','Police Identification and Records Officers','Agents d''identification et d''enregistrement de la police');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-3021.03','Criminal Investigators and Special Agents','Enquêteurs criminels et agents spéciaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-3021.05','Immigration and Customs Inspectors','Inspecteurs de l''immigration et des douanes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-3021.06','Intelligence Analysts','Analystes du renseignement');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-3031.00','Fish and Game Wardens','Gardes-chasse et gardes-pêche');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-3041.00','Parking Enforcement Workers','Agents de contrôle du stationnement');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-3051.01','Police Patrol Officers','Patrouilleurs de police');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-3051.03','Sheriffs and Deputy Sheriffs','Shérifs et shérifs adjoints');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-3052.00','Transit and Railroad Police','Police des transports et des chemins de fer');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-9011.00','Animal Control Workers','Travailleurs du contrôle des animaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-9021.00','Private Detectives and Investigators','Détectives et enquêteurs privés');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-9031.00','Gaming Surveillance Officers and Gaming Investigators','Agents de surveillance des jeux et enquêteurs sur les jeux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-9032.00','Security Guards','Les agents de sécurité');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-9091.00','Crossing Guards','Gardes de passage');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-9092.00','Lifeguards, Ski Patrol, and Other Recreational Protective Service Workers','Sauveteurs, patrouilleurs de ski et autres travailleurs des services de protection des loisirs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-9093.00','Transportation Security Screeners','Contrôle de sécurité des transports');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('33-9099.02','Retail Loss Prevention Specialists','Spécialistes de la prévention des pertes dans le commerce de détail');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('35-1011.00','Chefs and Head Cooks','Chefs et cuisiniers en chef');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('35-1012.00','First-Line Supervisors of Food Preparation and Serving Workers','Superviseurs de première ligne des travailleurs chargés de la préparation et du service des aliments');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('35-2011.00','Cooks, Fast Food','Cuisiniers, restauration rapide');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('35-2012.00','Cooks, Institution and Cafeteria','Cuisiniers, institution et cafétéria');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('35-2013.00','Cooks, Private Household','Cuisiniers, Ménage privé');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('35-2014.00','Cooks, Restaurant','Cuisiniers, Restaurant');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('35-2015.00','Cooks, Short Order','Cuisiniers, commande courte');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('35-2021.00','Food Preparation Workers','Travailleurs de la préparation des aliments');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('35-3011.00','Bartenders','Barmans');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('35-3021.00','Combined Food Preparation and Serving Workers, Including Fast Food','Travailleurs chargés de la préparation et du service des aliments, y compris la restauration rapide');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('35-3022.00','Counter Attendants, Cafeteria, Food Concession, and Coffee Shop','Comptoirs, cafétérias, concessions alimentaires et cafés');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('35-3022.01','Baristas','Baristas');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('35-3031.00','Waiters and Waitresses','Serveurs et serveuses');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('35-3041.00','Food Servers, Nonrestaurant','Serveurs de nourriture, Non-restaurant');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('35-9011.00','Dining Room and Cafeteria Attendants and Bartender Helpers','Préposés à la salle à manger et à la cafétéria et aides-barmans');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('35-9021.00','Dishwashers','Lave-vaisselle');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('35-9031.00','Hosts and Hostesses, Restaurant, Lounge, and Coffee Shop','Hôtes et hôtesses, restaurant, salon et café');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('37-1011.00','First-Line Supervisors of Housekeeping and Janitorial Workers','Superviseurs de première ligne des employés de maison et des concierges');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('37-1012.00','First-Line Supervisors of Landscaping, Lawn Service, and Groundskeeping Workers','Superviseurs de première ligne des travailleurs de l''aménagement paysager, du service des pelouses et de l''entretien des terrains');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('37-2011.00','Janitors and Cleaners, Except Maids and Housekeeping Cleaners','Concierges et nettoyeurs, à l''exception des femmes de chambre et des nettoyeurs ménagers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('37-2012.00','Maids and Housekeeping Cleaners','Bonnes et femmes de ménage');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('37-2021.00','Pest Control Workers','Travailleurs de la lutte antiparasitaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('37-3011.00','Landscaping and Groundskeeping Workers','Travailleurs de l''aménagement paysager et du maintien des sols');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('37-3012.00','Pesticide Handlers, Sprayers, and Applicators, Vegetation','Manipulateurs, pulvérisateurs et applicateurs de pesticides, Végétation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('37-3013.00','Tree Trimmers and Pruners','Tailleuses et élagueurs d''arbres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-1011.00','Gaming Supervisors','Superviseurs de jeux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-1012.00','Slot Supervisors','Superviseurs de créneaux horaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-1021.00','First-Line Supervisors of Personal Service Workers','Superviseurs de première ligne des travailleurs des services personnels');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-1021.01','Spa Managers','Directeurs de stations thermales');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-2011.00','Animal Trainers','Dresseurs d''animaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-2021.00','Nonfarm Animal Caretakers','Gardiens d''animaux non agricoles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-3011.00','Gaming Dealers','Marchands de jeux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-3012.00','Gaming and Sports Book Writers and Runners','Rédacteurs et coureurs de livres sur les jeux et le sport');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-3021.00','Motion Picture Projectionists','Projectionnistes cinématographiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-3031.00','Ushers, Lobby Attendants, and Ticket Takers','Huissiers, huissiers de vestibule et receveurs de billets');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-3091.00','Amusement and Recreation Attendants','Préposés aux loisirs et aux divertissements');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-3092.00','Costume Attendants','Costumiers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-3093.00','Locker Room, Coatroom, and Dressing Room Attendants','Vestiaires, vestiaires et vestiaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-4011.00','Embalmers','Embaumeurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-4021.00','Funeral Attendants','Pompes funèbres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-4031.00','Morticians, Undertakers, and Funeral Directors','Pompes funèbres, entrepreneurs de pompes funèbres et entrepreneurs de pompes funèbres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-5011.00','Barbers','Barbiers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-5012.00','Hairdressers, Hairstylists, and Cosmetologists','Coiffeurs, coiffeurs et cosmétologues');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-5091.00','Makeup Artists, Theatrical and Performance','Maquilleurs, théâtre et performance');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-5092.00','Manicurists and Pedicurists','Manucures et pédicures');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-5093.00','Shampooers','Shampooings');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-5094.00','Skincare Specialists','Spécialistes des soins de la peau');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-6011.00','Baggage Porters and Bellhops','Porteurs de bagages et sondeurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-6012.00','Concierges','Concierges');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-7011.00','Tour Guides and Escorts','Guides et accompagnateurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-7012.00','Travel Guides','Guides de voyage');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-9011.00','Childcare Workers','Travailleurs de l''enfance');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-9011.01','Nannies','Nounous');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-9021.00','Personal Care Aides','Aides aux soins personnels');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-9031.00','Fitness Trainers and Aerobics Instructors','Entraîneurs physiques et moniteurs d''aérobic');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-9032.00','Recreation Workers','Travailleurs du secteur des loisirs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('39-9041.00','Residential Advisors','Conseillers résidentiels');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-1011.00','First-Line Supervisors of Retail Sales Workers','Superviseurs de première ligne des travailleurs de la vente au détail');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-1012.00','First-Line Supervisors of Non-Retail Sales Workers','Superviseurs de première ligne des travailleurs du secteur de la vente autre qu''au détail');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-2011.00','Cashiers','Caissiers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-2012.00','Gaming Change Persons and Booth Cashiers','Changement de personnes et de caissiers dans les cabines de jeu');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-2021.00','Counter and Rental Clerks','Commis aux guichets et aux locations');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-2022.00','Parts Salespersons','Vendeurs de pièces détachées');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-2031.00','Retail Salespersons','Vendeurs au détail');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-3011.00','Advertising Sales Agents','Agents de vente de publicité');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-3021.00','Insurance Sales Agents','Agents de vente d''assurances');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-3031.01','Sales Agents, Securities and Commodities','Agents de vente, valeurs mobilières et produits de base');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-3031.02','Sales Agents, Financial Services','Agents commerciaux, services financiers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-3031.03','Securities and Commodities Traders','Négociants en valeurs mobilières et en marchandises');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-3041.00','Travel Agents','Agents de voyage');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-3099.01','Energy Brokers','Courtiers en énergie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-4011.00','Sales Representatives, Wholesale and Manufacturing, Technical and Scientific Products','Représentants commerciaux, commerce de gros et fabrication, produits techniques et scientifiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-4011.07','Solar Sales Representatives and Assessors','Représentants et évaluateurs des ventes de produits solaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-4012.00','Sales Representatives, Wholesale and Manufacturing, Except Technical and Scientific Products','Représentants des ventes, commerce de gros et fabrication, sauf produits techniques et scientifiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-9011.00','Demonstrators and Product Promoters','Démonstrateurs et promoteurs de produits');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-9012.00','Models','Modèles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-9021.00','Real Estate Brokers','Courtiers en immobilier');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-9022.00','Real Estate Sales Agents','Agents de vente de biens immobiliers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-9031.00','Sales Engineers','Ingénieurs commerciaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-9041.00','Telemarketers','Télémarketing');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('41-9091.00','Door-To-Door Sales Workers, News and Street Vendors, and Related Workers','Vendeurs à domicile, vendeurs de journaux et de rue, et travailleurs assimilés');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-1011.00','First-Line Supervisors of Office and Administrative Support Workers','Superviseurs de première ligne des employés de bureau et de soutien administratif');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-2011.00','Switchboard Operators, Including Answering Service','Standardistes, y compris le service de réponse');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-2021.00','Telephone Operators','Opérateurs téléphoniques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-3011.00','Bill and Account Collectors','Encaisseurs de factures et de comptes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-3021.01','Statement Clerks','Commissaires aux déclarations');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-3021.02','Billing, Cost, and Rate Clerks','Commis à la facturation, aux coûts et aux tarifs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-3031.00','Bookkeeping, Accounting, and Auditing Clerks','Commis à la comptabilité, à la comptabilité et à la vérification');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-3041.00','Gaming Cage Workers','Travailleurs des cages de jeu');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-3051.00','Payroll and Timekeeping Clerks','Commis à la paie et à l''emploi du temps');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-3061.00','Procurement Clerks','Commis aux achats');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-3071.00','Tellers','Guetteurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4011.00','Brokerage Clerks','Commis au courtage');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4021.00','Correspondence Clerks','Commis à la correspondance');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4031.01','Court Clerks','Greffiers de la Cour');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4031.02','Municipal Clerks','Greffiers municipaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4031.03','License Clerks','Commis aux licences');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4041.01','Credit Authorizers','Autorisations de crédit');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4041.02','Credit Checkers','Contrôleurs de crédit');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4051.00','Customer Service Representatives','Représentants du service clientèle');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4051.03','Patient Representatives','Représentants des patients');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4061.00','Eligibility Interviewers, Government Programs','Intervieweurs d''éligibilité, programmes gouvernementaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4071.00','File Clerks','Commis au dossier');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4081.00','Hotel, Motel, and Resort Desk Clerks','Commis de bureau des hôtels, motels et centres de villégiature');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4111.00','Interviewers, Except Eligibility and Loan','Intervieweurs, sauf admissibilité et prêt');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4121.00','Library Assistants, Clerical','Assistants de bibliothèque, commis');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4131.00','Loan Interviewers and Clerks','Intervieweurs et commis aux prêts');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4141.00','New Accounts Clerks','Nouveaux Commissaires aux comptes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4151.00','Order Clerks','Commis aux commandes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4161.00','Human Resources Assistants, Except Payroll and Timekeeping','Assistants en ressources humaines, à l''exception de la paie et de la gestion du temps');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4171.00','Receptionists and Information Clerks','Réceptionnistes et Commissaires à l''information');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-4181.00','Reservation and Transportation Ticket Agents and Travel Clerks','Agents de réservation et de transport et commis aux voyages');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-5011.00','Cargo and Freight Agents','Agents de fret et de cargo');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-5011.01','Freight Forwarders','Transitaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-5021.00','Couriers and Messengers','Courriers et messagers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-5031.00','Police, Fire, and Ambulance Dispatchers','Police, pompiers et ambulanciers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-5032.00','Dispatchers, Except Police, Fire, and Ambulance','Dispatchers, sauf police, pompiers et ambulances');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-5041.00','Meter Readers, Utilities','Lecteurs de compteurs, services publics');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-5051.00','Postal Service Clerks','Employés des services postaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-5052.00','Postal Service Mail Carriers','Courriers des services postaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-5053.00','Postal Service Mail Sorters, Processors, and Processing Machine Operators','Trieurs, processeurs et opérateurs de machines de traitement du courrier des services postaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-5061.00','Production, Planning, and Expediting Clerks','Commis à la production, à la planification et à l''expédition');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-5071.00','Shipping, Receiving, and Traffic Clerks','Commis à l''expédition, à la réception et au trafic');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-5081.01','Stock Clerks, Sales Floor','Commis aux stocks, étage des ventes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-5081.02','Marking Clerks','Commis au marquage');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-5081.03','Stock Clerks- Stockroom, Warehouse, or Storage Yard','Commis aux stocks - Entrepôt, magasin ou cour de stockage');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-5081.04','Order Fillers, Wholesale and Retail Sales','Remplisseurs de commandes, vente en gros et au détail');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-5111.00','Weighers, Measurers, Checkers, and Samplers, Recordkeeping','Pesées, mesures, contrôleurs et échantillonneurs, tenue de registres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-6011.00','Executive Secretaries and Executive Administrative Assistants','Secrétaires exécutifs et assistants administratifs exécutifs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-6012.00','Legal Secretaries','Secrétaires juridiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-6013.00','Medical Secretaries','Secrétaires médicaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-6014.00','Secretaries and Administrative Assistants, Except Legal, Medical, and Executive','Secrétaires et assistants administratifs, sauf juridiques, médicaux et exécutifs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-9011.00','Computer Operators','Opérateurs informatiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-9021.00','Data Entry Keyers','Clé de saisie des données');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-9022.00','Word Processors and Typists','Traitements de texte et dactylographie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-9031.00','Desktop Publishers','Éditeurs de logiciels de bureautique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-9041.01','Insurance Claims Clerks','Commis aux réclamations d''assurance');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-9041.02','Insurance Policy Processing Clerks','Commis au traitement des polices d''assurance');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-9051.00','Mail Clerks and Mail Machine Operators, Except Postal Service','Commis au courrier et opérateurs de machines à affranchir, à l''exception du service postal');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-9061.00','Office Clerks, General','Commis de bureau, général');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-9071.00','Office Machine Operators, Except Computer','Opérateurs de machines de bureau, à l''exception des ordinateurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-9081.00','Proofreaders and Copy Markers','Correcteurs et correcteurs de copie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-9111.00','Statistical Assistants','Assistants statistiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('43-9111.01','Bioinformatics Technicians','Techniciens en bio-informatique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('45-1011.05','First-Line Supervisors of Logging Workers','Superviseurs de première ligne des travailleurs forestiers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('45-1011.06','First-Line Supervisors of Aquacultural Workers','Superviseurs de première ligne des travailleurs aquacoles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('45-1011.07','First-Line Supervisors of Agricultural Crop and Horticultural Workers','Superviseurs de première ligne des travailleurs agricoles et horticoles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('45-1011.08','First-Line Supervisors of Animal Husbandry and Animal Care Workers','Superviseurs de première ligne des travailleurs de l''élevage et des soins aux animaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('45-2011.00','Agricultural Inspectors','Inspecteurs agricoles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('45-2021.00','Animal Breeders','Éleveurs d''animaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('45-2041.00','Graders and Sorters, Agricultural Products','Classeurs et trieurs, produits agricoles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('45-2091.00','Agricultural Equipment Operators','Opérateurs de matériel agricole');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('45-2092.01','Nursery Workers','Travailleurs des pépinières');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('45-2092.02','Farmworkers and Laborers, Crop','Travailleurs agricoles et ouvriers, Culture');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('45-2093.00','Farmworkers, Farm, Ranch, and Aquacultural Animals','Travailleurs agricoles, animaux de ferme, d''élevage et aquacoles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('45-3011.00','Fishers and Related Fishing Workers','Pêcheurs et travailleurs du secteur de la pêche');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('45-3021.00','Hunters and Trappers','Chasseurs et trappeurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('45-4011.00','Forest and Conservation Workers','Travailleurs de la forêt et de la conservation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('45-4021.00','Fallers','Bûcheron');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('45-4022.00','Logging Equipment Operators','Opérateurs de matériel d''exploitation forestière');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('45-4023.00','Log Graders and Scalers','Classeurs et mesureurs de grumes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-1011.00','First-Line Supervisors of Construction Trades and Extraction Workers','Superviseurs de première ligne des travailleurs des métiers de la construction et de l''extraction');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-1011.03','Solar Energy Installation Managers','Gestionnaires d''installations d''énergie solaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2011.00','Boilermakers','Chaudronniers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2021.00','Brickmasons and Blockmasons','Bricoleurs et maçons en bâtiment');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2022.00','Stonemasons','Tailleurs de pierre');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2031.01','Construction Carpenters','Charpentiers de construction');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2031.02','Rough Carpenters','Charpentiers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2041.00','Carpet Installers','Installateurs de tapis');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2042.00','Floor Layers, Except Carpet, Wood, and Hard Tiles','Couches de sol, à l''exception des tapis, du bois et des carrelages');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2043.00','Floor Sanders and Finishers','Ponceuses et finisseuses de sols');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2044.00','Tile and Marble Setters','Carreleurs et marbriers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2051.00','Cement Masons and Concrete Finishers','Maçons en ciment et finisseurs de béton');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2053.00','Terrazzo Workers and Finishers','Travailleurs et finisseurs de carlage');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2061.00','Construction Laborers','Travailleurs de la construction');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2071.00','Paving, Surfacing, and Tamping Equipment Operators','Pavage, surfaçage et Bourrage éditique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2072.00','Pile-Driver Operators','Opérateurs de machines pour le pillonage');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2073.00','Operating Engineers and Other Construction Equipment Operators','Ingénieurs d''exploitation et autres construction éditique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2081.00','Drywall and Ceiling Tile Installers','Cloisons sèches et carreleurs de plafond');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2082.00','Tapers','Concierges');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2111.00','Electricians','Électriciens');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2121.00','Glaziers','Vitriers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2131.00','Insulation Workers, Floor, Ceiling, and Wall','Travailleurs de l''isolation, sols, plafonds et murs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2132.00','Insulation Workers, Mechanical','Travailleurs de l''isolation, mécanique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2141.00','Painters, Construction and Maintenance','Peintres, construction et entretien');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2142.00','Paperhangers','Changeur de papier');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2151.00','Pipelayers','Poseurs de canalisations');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2152.01','Pipe Fitters and Steamfitters','Tuyauteries et monteurs de conduites de vapeur');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2152.02','Plumbers','Plombiers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2161.00','Plasterers and Stucco Masons','Plâtriers et stucateurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2171.00','Reinforcing Iron and Rebar Workers','Travailleurs du fer renforcé et des barres d''armature');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2181.00','Roofers','Couvreurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2211.00','Sheet Metal Workers','Tôlerie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2221.00','Structural Iron and Steel Workers','Travailleurs de la sidérurgie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-2231.00','Solar Photovoltaic Installers','Installateurs d''énergie solaire photovoltaïque');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-3011.00','Helpers--Brickmasons, Blockmasons, Stonemasons, and Tile and Marble Setters','Auxiliaires : maçons, briquetiers, tailleurs de pierre, carreleurs et marbriers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-3012.00','Helpers--Carpenters','Aides - Carpentiers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-3013.00','Helpers--Electricians','Aides - Électriciens');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-3014.00','Helpers--Painters, Paperhangers, Plasterers, and Stucco Masons','Aides - Peintres, poseurs de papiers, plâtriers et stucateurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-3015.00','Helpers--Pipelayers, Plumbers, Pipefitters, and Steamfitters','Aides - Pêcheurs, plombiers, tuyauteurs et monteurs de conduites de vapeur');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-3016.00','Helpers--Roofers','Aides - Couvreurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-4011.00','Construction and Building Inspectors','Inspecteurs de la construction et des bâtiments');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-4021.00','Elevator Installers and Repairers','Installateurs et réparateurs d''ascenseurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-4031.00','Fence Erectors','Érecteurs de clôtures');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-4041.00','Hazardous Materials Removal Workers','Travailleurs chargés de l''enlèvement des matières dangereuses');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-4051.00','Highway Maintenance Workers','Travailleurs de l''entretien des routes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-4061.00','Rail-Track Laying and Maintenance Equipment Operators','Opérateurs de matériel de pose et d''entretien des voies ferrées');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-4071.00','Septic Tank Servicers and Sewer Pipe Cleaners','Entretien des fosses septiques et nettoyage des canalisations d''égout');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-4091.00','Segmental Pavers','Paveurs segmentaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-4099.02','Solar Thermal Installers and Technicians','Installateurs et techniciens en énergie solaire thermique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-4099.03','Weatherization Installers and Technicians','Installateurs et techniciens en intempérisation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-5011.00','Derrick Operators, Oil and Gas','Opérateurs de derricks, pétrole et gaz');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-5012.00','Rotary Drill Operators, Oil and Gas','Opérateurs de foreuses rotatives, pétrole et gaz');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-5013.00','Service Unit Operators, Oil, Gas, and Mining','Opérateurs des unités de service, pétrole, gaz et mines');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-5021.00','Earth Drillers, Except Oil and Gas','Foreurs, sauf pour le pétrole et le gaz');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-5031.00','Explosives Workers, Ordnance Handling Experts, and Blasters','Exploitants, experts en manipulation d''engins et dynamiteurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-5041.00','Continuous Mining Machine Operators','Opérateurs de machines d''exploitation minière en continu');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-5042.00','Mine Cutting and Channeling Machine Operators','Opérateurs de machines de découpage et de rainurage des mines');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-5051.00','Rock Splitters, Quarry','Séparateurs de roches, carrière');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-5061.00','Roof Bolters, Mining','Boulons de toit, mines');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-5071.00','Roustabouts, Oil and Gas','Ouvrier, Pétrole et gaz');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('47-5081.00','Helpers--Extraction Workers','Aides - Travailleurs de l''extraction');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-1011.00','First-Line Supervisors of Mechanics, Installers, and Repairers','Superviseurs de première ligne des mécaniciens, installateurs et réparateurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-2011.00','Computer, Automated Teller, and Office Machine Repairers','Réparation d''ordinateurs, de distributeurs automatiques et de machines de bureau');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-2021.00','Radio, Cellular, and Tower Equipment Installers and Repairers','Installateurs et réparateurs d''équipements radio, cellulaires et de tours');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-2021.01','Radio Mechanics','Radio-mécanique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-2022.00','Telecommunications Equipment Installers and Repairers, Except Line Installers','Installateurs et réparateurs d''équipements de télécommunications, à l''exception des installateurs de lignes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-2091.00','Avionics Technicians','Techniciens en avionique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-2092.00','Electric Motor, Power Tool, and Related Repairers','Réparation de moteurs électriques, d''outils électriques et autres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-2093.00','Electrical and Electronics Installers and Repairers, Transportation Equipment','Installateurs et réparateurs de matériel électrique et électronique, de matériel de transport');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-2094.00','Electrical and Electronics Repairers, Commercial and Industrial Equipment','Réparateurs d''équipements électriques et électroniques, d''équipements commerciaux et industriels');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-2095.00','Electrical and Electronics Repairers, Powerhouse, Substation, and Relay','Réparation de matériel électrique et électronique, centrale électrique, sous-station et relais');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-2096.00','Electronic Equipment Installers and Repairers, Motor Vehicles','Installateurs et réparateurs d''équipements électroniques, véhicules automobiles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-2097.00','Electronic Home Entertainment Equipment Installers and Repairers','Installateurs et réparateurs d''équipements électroniques de divertissement à domicile');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-2098.00','Security and Fire Alarm Systems Installers','Installateurs de systèmes de sécurité et d''alarme incendie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-3011.00','Aircraft Mechanics and Service Technicians','Mécaniciens et techniciens d''entretien d''aéronefs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-3021.00','Automotive Body and Related Repairers','Carrossiers et réparateurs de véhicules automobiles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-3022.00','Automotive Glass Installers and Repairers','Installateurs et réparateurs de vitres d''automobiles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-3023.01','Automotive Master Mechanics','Maître en mécanique automobile');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-3023.02','Automotive Specialty Technicians','Techniciens spécialisés dans l''automobile');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-3031.00','Bus and Truck Mechanics and Diesel Engine Specialists','Mécaniciens d''autobus et de camions et spécialistes des moteurs diesel');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-3041.00','Farm Equipment Mechanics and Service Technicians','Mécaniciens et techniciens d''entretien de matériel agricole');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-3042.00','Mobile Heavy Equipment Mechanics, Except Engines','Mécaniciens d''équipement lourd mobile, sauf les moteurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-3043.00','Rail Car Repairers','Réparateurs de wagons');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-3051.00','Motorboat Mechanics and Service Technicians','Mécaniciens et techniciens de service pour bateaux à moteur');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-3052.00','Motorcycle Mechanics','Mécaniciens des motocyclettes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-3053.00','Outdoor Power Equipment and Other Small Engine Mechanics','Équipement motorisé d''extérieur et autres petits moteurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-3091.00','Bicycle Repairers','Réparateurs de vélos');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-3092.00','Recreational Vehicle Service Technicians','Techniciens d''entretien de véhicules de loisirs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-3093.00','Tire Repairers and Changers','Réparateurs et changeurs de pneus');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9011.00','Mechanical Door Repairers','Réparateurs de portes mécaniques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9012.00','Control and Valve Installers and Repairers, Except Mechanical Door','Installateurs et réparateurs de commandes et de soupapes, sauf pour les portes mécaniques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9021.01','Heating and Air Conditioning Mechanics and Installers','Mécaniciens et installateurs de chauffage et de climatisation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9021.02','Refrigeration Mechanics and Installers','Mécaniciens et installateurs en réfrigération');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9031.00','Home Appliance Repairers','Réparateurs d''appareils ménagers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9041.00','Industrial Machinery Mechanics','Mécanique des machines industrielles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9043.00','Maintenance Workers, Machinery','Personnel d''entretien, machines');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9044.00','Millwrights','Les mécaniciens de chantier');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9045.00','Refractory Materials Repairers, Except Brickmasons','Réparateurs de matériaux réfractaires, sauf les maçons');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9051.00','Electrical Power-Line Installers and Repairers','Installateurs et réparateurs de lignes électriques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9052.00','Telecommunications Line Installers and Repairers','Installateurs et réparateurs de lignes de télécommunications');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9061.00','Camera and Photographic Equipment Repairers','Réparateurs d''appareils photo et de matériel photographique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9062.00','Medical Equipment Repairers','Réparateurs de matériel médical');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9063.00','Musical Instrument Repairers and Tuners','Réparateurs et accordeurs d''instruments de musique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9064.00','Watch Repairers','Réparateurs de montres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9071.00','Maintenance and Repair Workers, General','Personnel d''entretien et de réparation, général');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9081.00','Wind Turbine Service Technicians','Techniciens de service pour les éoliennes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9091.00','Coin, Vending, and Amusement Machine Servicers and Repairers','Distributeurs et réparateurs de pièces de monnaie, de distributeurs automatiques et de machines de loisirs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9092.00','Commercial Divers','Plongeurs commerciaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9093.00','Fabric Menders, Except Garment','Fabricants de tissus, sauf vêtements');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9094.00','Locksmiths and Safe Repairers','Serruriers et réparateurs de coffres-forts');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9095.00','Manufactured Building and Mobile Home Installers','Installateurs de bâtiments et de maisons mobiles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9096.00','Riggers','Gréeurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9097.00','Signal and Track Switch Repairers','Réparation des signaux et des aiguillages de voie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9098.00','Helpers--Installation, Maintenance, and Repair Workers','Aides - Personnel d''installation, d''entretien et de réparation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('49-9099.01','Geothermal Technicians','Techniciens en géothermie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-1011.00','First-Line Supervisors of Production and Operating Workers','Superviseurs de première ligne des travailleurs de la production et de l''exploitation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-2011.00','Aircraft Structure, Surfaces, Rigging, and Systems Assemblers','Monteurs de structures, de surfaces, de gréements et de systèmes d''aéronefs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-2021.00','Coil Winders, Tapers, and Finishers','Bobinoirs, cônes et finisseurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-2022.00','Electrical and Electronic Equipment Assemblers','Monteurs d''équipements électriques et électroniques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-2023.00','Electromechanical Equipment Assemblers','Monteurs d''équipements électromécaniques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-2031.00','Engine and Other Machine Assemblers','Monteurs de moteurs et autres machines');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-2041.00','Structural Metal Fabricators and Fitters','Fabricants et installateurs de structures métalliques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-2091.00','Fiberglass Laminators and Fabricators','Lamineurs et fabricants de fibres de verre');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-2092.00','Team Assemblers','Équipe de montage');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-2093.00','Timing Device Assemblers and Adjusters','Monteurs et régleurs de dispositifs de chronométrage');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-3011.00','Bakers','Boulangers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-3021.00','Butchers and Meat Cutters','Bouchers et découpeurs de viande');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-3022.00','Meat, Poultry, and Fish Cutters and Trimmers','Découpeuses et parfumeuses de viande, de volaille et de poisson');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-3023.00','Slaughterers and Meat Packers','Abatteurs et conditionneurs de viande');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-3091.00','Food and Tobacco Roasting, Baking, and Drying Machine Operators and Tenders','Opérateurs de machines de torréfaction, de cuisson et de séchage des aliments et du tabac et appels d''offres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-3092.00','Food Batchmakers','Fabricants de produits alimentaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-3093.00','Food Cooking Machine Operators and Tenders','Opérateurs de machines de cuisson de denrées alimentaires et appels d''offres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4011.00','Computer-Controlled Machine Tool Operators, Metal and Plastic','Opérateurs de machines-outils commandées par ordinateur, métal et plastique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4012.00','Computer Numerically Controlled Machine Tool Programmers, Metal and Plastic','Programmeurs de machines-outils à commande numérique par ordinateur, métal et plastique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4021.00','Extruding and Drawing Machine Setters, Operators, and Tenders, Metal and Plastic','Régleurs, opérateurs et soumissionnaires de machines d''extrusion et d''étirage, métal et plastique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4022.00','Forging Machine Setters, Operators, and Tenders, Metal and Plastic','Forgeurs, opérateurs et soumissionnaires, métal et plastique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4023.00','Rolling Machine Setters, Operators, and Tenders, Metal and Plastic','Régleurs de machines à laminer, opérateurs et soumissionnaires, métal et plastique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4031.00','Cutting, Punching, and Press Machine Setters, Operators, and Tenders, Metal and Plastic','Découpe, poinçonnage et réglage des machines de presse, opérateurs et soumissionnaires, métal et plastique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4032.00','Drilling and Boring Machine Tool Setters, Operators, and Tenders, Metal and Plastic','Régulateurs de machines-outils de forage et d''alésage, opérateurs et soumissionnaires, métal et plastique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4033.00','Grinding, Lapping, Polishing, and Buffing Machine Tool Setters, Operators, and Tenders, Metal and Plastic','Machines-outils de meulage, de rodage, de polissage et de polissage, opérateurs et soumissionnaires, métal et plastique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4034.00','Lathe and Turning Machine Tool Setters, Operators, and Tenders, Metal and Plastic','Régleurs de tours et de machines-outils, opérateurs et soumissionnaires, métal et plastique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4035.00','Milling and Planing Machine Setters, Operators, and Tenders, Metal and Plastic','Régulateurs de machines de fraisage et de rabotage, opérateurs et soumissionnaires, métal et plastique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4041.00','Machinists','Machinistes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4051.00','Metal-Refining Furnace Operators and Tenders','Opérateurs de fours d''affinage des métaux et appels d''offres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4052.00','Pourers and Casters, Metal','Verseurs et roulettes, Métal');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4061.00','Model Makers, Metal and Plastic','Modélistes, métal et plastique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4062.00','Patternmakers, Metal and Plastic','Patronniers, Métal et plastique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4071.00','Foundry Mold and Coremakers','Moules et noyaux de fonderie');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4072.00','Molding, Coremaking, and Casting Machine Setters, Operators, and Tenders, Metal and Plastic','Régleurs de machines de moulage, de noyautage et de coulée, opérateurs et soumissionnaires, métal et plastique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4081.00','Multiple Machine Tool Setters, Operators, and Tenders, Metal and Plastic','Multiples machines-outils, opérateurs et soumissionnaires, métal et plastique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4111.00','Tool and Die Makers','Fabricants d''outils et de matrices');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4121.06','Welders, Cutters, and Welder Fitters','Soudeurs, coupeurs et soudeurs monteurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4121.07','Solderers and Brazers','Soudeurs et brasseurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4122.00','Welding, Soldering, and Brazing Machine Setters, Operators, and Tenders','Régleurs, opérateurs et soumissionnaires de machines à souder, braser et braser');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4191.00','Heat Treating Equipment Setters, Operators, and Tenders, Metal and Plastic','Régleurs, opérateurs et soumissionnaires d''équipements de traitement thermique, métal et plastique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4192.00','Layout Workers, Metal and Plastic','Ouvriers de la mise en page, métal et plastique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4193.00','Plating and Coating Machine Setters, Operators, and Tenders, Metal and Plastic','Régleurs de machines de placage et de revêtement, opérateurs et soumissionnaires, métal et plastique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-4194.00','Tool Grinders, Filers, and Sharpeners','Affûteurs d''outils, limes et affûteuses');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-5111.00','Prepress Technicians and Workers','Techniciens et travailleurs du prépresse');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-5112.00','Printing Press Operators','Opérateurs de presse à imprimer');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-5113.00','Print Binding and Finishing Workers','Travailleurs de la reliure et de la finition d''imprimés');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-6011.00','Laundry and Dry-Cleaning Workers','Blanchisseurs et les nettoyeurs à sec');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-6021.00','Pressers, Textile, Garment, and Related Materials','Pressing, textile, vêtements et matériaux connexes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-6031.00','Sewing Machine Operators','Opérateurs de machines à coudre');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-6041.00','Shoe and Leather Workers and Repairers','Ouvriers et réparateurs de chaussures et de cuir');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-6042.00','Shoe Machine Operators and Tenders','Opérateurs de machines à chaussures et appels d''offres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-6051.00','Sewers, Hand','Égouts, main');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-6052.00','Tailors, Dressmakers, and Custom Sewers','Tailleurs, couturiers et couturières');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-6061.00','Textile Bleaching and Dyeing Machine Operators and Tenders','Opérateurs et soumissionnaires de machines de blanchiment et de teinture des textiles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-6062.00','Textile Cutting Machine Setters, Operators, and Tenders','Régleurs, opérateurs et soumissionnaires de machines de découpe textile');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-6063.00','Textile Knitting and Weaving Machine Setters, Operators, and Tenders','Régleurs, opérateurs et soumissionnaires de machines à tricoter et à tisser');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-6064.00','Textile Winding, Twisting, and Drawing Out Machine Setters, Operators, and Tenders','Machines de bobinage, de retordage et d''étirage de textiles - Régleurs, opérateurs et soumissionnaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-6091.00','Extruding and Forming Machine Setters, Operators, and Tenders, Synthetic and Glass Fibers','Régulateurs de machines d''extrusion et de formage, opérateurs et soumissionnaires, fibres synthétiques et de verre');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-6092.00','Fabric and Apparel Patternmakers','Modélisateurs de tissus et de vêtements');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-6093.00','Upholsterers','Tapissiers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-7011.00','Cabinetmakers and Bench Carpenters','Ébénistes et menuisiers d''établi');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-7021.00','Furniture Finishers','Finisseurs de meubles');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-7031.00','Model Makers, Wood','Modélistes, bois');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-7032.00','Patternmakers, Wood','Patronniers, Bois');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-7041.00','Sawing Machine Setters, Operators, and Tenders, Wood','Régleurs de machines à scier, opérateurs et soumissionnaires, bois');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-7042.00','Woodworking Machine Setters, Operators, and Tenders, Except Sawing','Régleurs de machines à bois, opérateurs et soumissionnaires, sauf pour le sciage');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-8011.00','Nuclear Power Reactor Operators','Opérateurs de réacteurs nucléaires de puissance');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-8012.00','Power Distributors and Dispatchers','Distributeurs et répartiteurs d''électricité');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-8013.00','Power Plant Operators','Opérateurs de centrales électriques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-8021.00','Stationary Engineers and Boiler Operators','Mécaniciens de machines fixes et opérateurs de chaudières');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-8031.00','Water and Wastewater Treatment Plant and System Operators','Opérateurs de stations et de systèmes de traitement de l''eau et des eaux usées');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-8091.00','Chemical Plant and System Operators','Opérateurs d''usines et de systèmes chimiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-8092.00','Gas Plant Operators','Opérateurs d''usines à gaz');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-8093.00','Petroleum Pump System Operators, Refinery Operators, and Gaugers','Opérateurs de systèmes de pompes à pétrole, opérateurs de raffineries et gérants');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-8099.01','Biofuels Processing Technicians','Techniciens en transformation des biocarburants');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-8099.03','Biomass Plant Technicians','Techniciens de la biomasse');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-8099.04','Hydroelectric Plant Technicians','Techniciens de centrales hydroélectriques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9011.00','Chemical Equipment Operators and Tenders','Opérateurs d''équipements chimiques et appels d''offres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9012.00','Separating, Filtering, Clarifying, Precipitating, and Still Machine Setters, Operators, and Tenders','Séparer, filtrer, clarifier, précipiter et caler les machines, les opérateurs et les offres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9021.00','Crushing, Grinding, and Polishing Machine Setters, Operators, and Tenders','Installations, opérateurs et appels d''offres de machines de concassage, de broyage et de polissage');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9022.00','Grinding and Polishing Workers, Hand','Travailleurs du meulage et du polissage, main');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9023.00','Mixing and Blending Machine Setters, Operators, and Tenders','Régulateurs, opérateurs et appels d''offres pour les machines à mélanger');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9031.00','Cutters and Trimmers, Hand','Couteaux et coupeurs à main');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9032.00','Cutting and Slicing Machine Setters, Operators, and Tenders','Régulateurs de machines à couper et à trancher, opérateurs et appels d''offres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9041.00','Extruding, Forming, Pressing, and Compacting Machine Setters, Operators, and Tenders','Extrusion, formage, pressage et compactage Régulateurs de machines, opérateurs et appels d''offres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9051.00','Furnace, Kiln, Oven, Drier, and Kettle Operators and Tenders','Opérateurs de fours, de séchoirs et de bouilloires et appels d''offres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9061.00','Inspectors, Testers, Sorters, Samplers, and Weighers','Inspecteurs, testeurs, trieurs, échantillonneurs et peseurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9071.01','Jewelers','Bijoutiers');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9071.06','Gem and Diamond Workers','Travailleurs des pierres précieuses et des diamants');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9071.07','Precious Metal Workers','Travailleurs des métaux précieux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9081.00','Dental Laboratory Technicians','Techniciens de laboratoire dentaire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9082.00','Medical Appliance Technicians','Techniciens en appareils médicaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9083.00','Ophthalmic Laboratory Technicians','Techniciens de laboratoire ophtalmique');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9111.00','Packaging and Filling Machine Operators and Tenders','Opérateurs de machines d''emballage et de remplissage et appels d''offres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9121.00','Coating, Painting, and Spraying Machine Setters, Operators, and Tenders','Régleurs, opérateurs et soumissionnaires de machines de revêtement, de peinture et de pulvérisation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9122.00','Painters, Transportation Equipment','Peintres, matériel de transport');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9123.00','Painting, Coating, and Decorating Workers','Travailleurs de la peinture, du revêtement et de la décoration');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9141.00','Semiconductor Processors','Processeurs à semi-conducteurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9151.00','Photographic Process Workers and Processing Machine Operators','Opérateurs de procédés photographiques et opérateurs de machines de traitement');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9191.00','Adhesive Bonding Machine Operators and Tenders','Opérateurs de machines de collage et appels d''offres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9192.00','Cleaning, Washing, and Metal Pickling Equipment Operators and Tenders','Opérateurs et soumissionnaires de matériel de nettoyage, de lavage et de décapage des métaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9193.00','Cooling and Freezing Equipment Operators and Tenders','Opérateurs d''équipements de réfrigération et de congélation et appels d''offres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9194.00','Etchers and Engravers','Graveurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9195.03','Stone Cutters and Carvers, Manufacturing','Tailleurs de pierre et sculpteurs, industrie manufacturière');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9195.04','Glass Blowers, Molders, Benders, and Finishers','Souffleurs, mouleurs, cintreuses et finisseurs de verre');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9195.05','Potters, Manufacturing','Potiers, fabrication');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9195.07','Molding and Casting Workers','Travailleurs du moulage et de la coulée');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9196.00','Paper Goods Machine Setters, Operators, and Tenders','Régulateurs, opérateurs et appels d''offres pour les machines à papier');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9197.00','Tire Builders','Fabricants de pneus');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9198.00','Helpers--Production Workers','Aides - Travailleurs de la production');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('51-9199.01','Recycling and Reclamation Workers','Travailleurs du recyclage et de la valorisation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-1011.00','Aircraft Cargo Handling Supervisors','Superviseurs de la manutention des cargaisons d''avions');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-1021.00','First-Line Supervisors of Helpers, Laborers, and Material Movers, Hand','Superviseurs de première ligne des aides, des ouvriers et des déménageurs de matériel, Main');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-1021.01','Recycling Coordinators','Coordinateurs de recyclage');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-1031.00','First-Line Supervisors of Transportation and Material-Moving Machine and Vehicle Operators','Superviseurs de première ligne des conducteurs d''engins et de véhicules de transport et de manutention');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-2011.00','Airline Pilots, Copilots, and Flight Engineers','Pilotes de ligne, copilotes et mécaniciens de bord');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-2012.00','Commercial Pilots','Pilotes commerciaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-2021.00','Air Traffic Controllers','Contrôleurs de la circulation aérienne');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-2022.00','Airfield Operations Specialists','Spécialistes des opérations aéroportuaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-2031.00','Flight Attendants','Agents de bord');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-3011.00','Ambulance Drivers and Attendants, Except Emergency Medical Technicians','Ambulanciers, à l''exception des techniciens médicaux d''urgence');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-3021.00','Bus Drivers, Transit and Intercity','Chauffeurs de bus, transport en commun et interurbain');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-3022.00','Bus Drivers, School or Special Client','Chauffeurs de bus, école ou client spécial');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-3031.00','Driver/Sales Workers','Chauffeur/travailleurs de la vente');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-3032.00','Heavy and Tractor-Trailer Truck Drivers','Conducteurs de poids lourds et de semi-remorques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-3033.00','Light Truck or Delivery Services Drivers','Conducteurs de camion léger ou de services de livraison');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-3041.00','Taxi Drivers and Chauffeurs','Chauffeurs de taxi et chauffeurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-4011.00','Locomotive Engineers','Ingénieurs de locomotive');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-4012.00','Locomotive Firers','Les licenciements de locomotives');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-4013.00','Rail Yard Engineers, Dinkey Operators, and Hostlers','Ingénieurs de gare de triage, opérateurs de restaurant et hôtes');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-4021.00','Railroad Brake, Signal, and Switch Operators','Opérateurs de freins, de signaux et d''aiguillages ferroviaires');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-4031.00','Railroad Conductors and Yardmasters','Chefs de train et chefs de triage');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-4041.00','Subway and Streetcar Operators','Opérateurs de métro et de tramway');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-5011.00','Sailors and Marine Oilers','Marins et pétroliers en mer');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-5021.01','Ship and Boat Captains','Capitaines de navires et de bateaux');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-5021.02','Mates- Ship, Boat, and Barge','Accompagnateurs - navire, bateau et péniche');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-5021.03','Pilots, Ship','Pilotes, navire');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-5022.00','Motorboat Operators','Opérateurs de bateaux à moteur');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-5031.00','Ship Engineers','Ingénieurs navals');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-6011.00','Bridge and Lock Tenders','Appels d''offres pour les ponts et les écluses');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-6021.00','Parking Lot Attendants','Préposés aux parkings');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-6031.00','Automotive and Watercraft Service Attendants','Préposés aux services automobiles et nautiques');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-6041.00','Traffic Technicians','Techniciens de la circulation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-6051.01','Aviation Inspectors','Inspecteurs de l''aviation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-6051.07','Transportation Vehicle, Equipment and Systems Inspectors, Except Aviation','Inspecteurs des véhicules, équipements et systèmes de transport, sauf l''aviation');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-6051.08','Freight and Cargo Inspectors','Inspecteurs du fret et des cargaisons');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-6061.00','Transportation Attendants, Except Flight Attendants','Agents de transport, à l''exception des agents de bord');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-7011.00','Conveyor Operators and Tenders','Opérateurs de transport et appels d''offres');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-7021.00','Crane and Tower Operators','Opérateurs de grues et de tours');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-7031.00','Dredge Operators','Opérateurs de drague');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-7032.00','Excavating and Loading Machine and Dragline Operators','Opérateurs de machines d''excavation et de chargement et de pelles à benne traînante');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-7033.00','Loading Machine Operators, Underground Mining','Opérateurs de machines de chargement, exploitation minière souterraine');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-7041.00','Hoist and Winch Operators','Opérateurs de palans et de treuils');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-7051.00','Industrial Truck and Tractor Operators','Opérateurs de camions et de tracteurs industriels');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-7061.00','Cleaners of Vehicles and Equipment','Nettoyeurs de véhicules et d''équipements');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-7062.00','Laborers and Freight, Stock, and Material Movers, Hand','Travailleurs et déménageurs de marchandises, de stocks et de matériaux, main');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-7063.00','Machine Feeders and Offbearers','Alimentateurs de machines et porteurs');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-7064.00','Packers and Packagers, Hand','Emballeurs et conditionneurs, main');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-7071.00','Gas Compressor and Gas Pumping Station Operators','Opérateurs de compresseurs de gaz et de stations de pompage de gaz');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-7072.00','Pump Operators, Except Wellhead Pumpers','Opérateurs de pompes, à l''exception des pompes de tête de puits');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-7073.00','Wellhead Pumpers','Pompes de tête de puits');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-7081.00','Refuse and Recyclable Material Collectors','Les collecteurs de déchets et de matières recyclables');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-7111.00','Mine Shuttle Car Operators','Opérateurs de navettes minières');
INSERT INTO Job(ONETSOCCode, English, French) VALUES('53-7121.00','Tank Car, Truck, and Ship Loaders','Chargements de wagons-citernes, de camions et de navires');