A comprehensive dataset of top immigration attorneys for H-1B Visa sponsorships in 2025, including salary data, petition trends, and employer insights. Updated annually with the latest trends and employer behavior regarding H-1B visa sponsorship.

This dataset includes data that the Employment and Training Administration's Office of Foreign Labor Certification (OFLC) collected from Labor Condition Applications for Nonimmigrant Workers (LCAs) during previous fiscal years. It includes information on employers, geography, and job details for participants in the LCA program. Historical LCA public disclosure data is available on the OFLC website in the Performance Data section. Data is available as Excel files in aggregate form at https://www.dol.gov/agencies/eta/foreign-labor/performance.

A comprehensive dataset of top petition statuses for H-1B Visa sponsorships in 2025, including salary data, petition trends, and employer insights. Updated annually with the latest trends and employer behavior regarding H-1B visa sponsorship.

Project Description:

1) Data Background

In the Data Mining class, we had the opportunity to analyze data by performing data mining algorithms to a dataset. Our dataset is from Office of Foreign Labor Certification (OFLC). OFLC is a division of the U.S. Department of Labor. The main duty of OFLC is to assist the Secretary of Labor to enforce part of the Immigration and Nationality Act (INA), which requires certain labor conditions exist before employers can hire foreign workers. H-1B is a visa category in the United States of America under the INA, section 101(a)(15)(H) which allows U.S. employers to employ foreign workers. The first step employer must take to hire a foreign worker is to file the Labor Condition Application. In this project, we will analyze the data from the Labor Condition Application.

1.1) Introduction to H1B Dataset

The H-1B Dataset selected for this project contains data from employer’s Labor Condition Application and the case certification determinations processed by the Office of Foreign Labor Certification (OFLC) where the date of the determination was issues on or after October 1, 2016 and on or before June 30, 2017.

The Labor Condition Application (LCA) is a document that a perspective H-1B employer files with U.S. Department of Labor Employment and Training Administration (DOLETA) when it seeks to employ non-immigrant workers at a specific job occupation in an area of intended employment for not more than three years.

1.2) Goal of the Project

Our goal for this project is to predict the case status of an application submitted by the employer to hire non-immigrant workers under the H-1B visa program. Employer can hire non-immigrant workers only after their LCA petition is approved. The approved LCA petition is then submitted as part of the Petition for a Non-immigrant Worker application for work authorizations for H-1B visa status.

We want to uncover insights that can help employers understand the process of getting their LCA approved. We will use WEKA software to run data mining algorithms to understand the relationship between attributes and the target variable.

2)Dataset Information:

a) Source: Office of Foreign Labor Certification, U.S. Department of Labor Employment and Training Administration
b) List Link: https://www.foreignlaborcert.doleta.gov/performancedata.cfm
c) Dataset Type: Record – Transaction Data
d) Number of Attributes: 40
e) Number of Instances: 528,147
f) Date Created: July 2017

3) Attribute List:

The detailed description of each attribute below is given in the Record Layout file available in the zip folder H1B Disclosure Dataset Files.

The H-1B dataset from OFLC contained 40 attributes and 528,147 instances. The attributes are in the table below. The attributes highlighted bold were removed during the data cleaning process.

1) CASE_NUMBER
2)CASE_SUBMITTED
3)DECISION_DATE
4)VISA_CLASS
5)EMPLOYMENT_START_DATE
6)EMPLOYMENT_END_DATE
7)EMPLOYER_NAME
8)EMPLOYER_ADDRESS
9)EMPLOYER_CITY
10)EMPLOYER_STATE
11)EMPLOYER_POSTAL_CODE
12)EMPLOYER_COUNTRY
13)EMPLOYER_PROVINCE
14)EMPLOYER_PHONE
15)EMPLOYER_PHONE_EXT
16)AGENT_ATTORNEY_NAME
17)AGENT_ATTORNEY_CITY
18)AGENT_ATTORNEY_STATE
19)JOB_TITLE
20)SOC_CODE
21)SOC_NAME
22)NAICS_CODE
23)TOTAL_WORKERS
24)FULL_TIME_POSITION
25)PREVAILING_WAGE
26)PW_UNIT_OF_PAY
27)PW_SOURCE
28)PW_SOURCE_YEAR
29)PW_SOURCE_OTHER
30)WAGE_RATE_OF_PAY_FROM
31)WAGE_RATE_OF_PAY_TO
32)WAGE_UNIT_OF_PAY
33)H-1B_DEPENDENT
34) WILLFUL_VIOLATOR
35) WORKSITE_CITY
36)WORKSITE_COUNTY
37)WORKSITE_STATE
38)WORKSITE_POSTAL_CODE
39)ORIGINAL_CERT_DATE
40)CASE_STATUS* - _Class Attribute - To be predicted

3.1) Class Attribute

For the H-1B Dataset our class attribute is ‘CASE_STATUS’. There are 4 categories of Case Status. The values of Case_Status attributes are:

1) Certified
2) Certified_Withdrawn
3) Withdrawn
4) Denied

Certified means the LCA of an employer was approved. Certified Withdrawn means the case was withdrawn after it was certified by OFLC. Withdrawn means the case was withdrawn by the employer. Denied means the case was denied OFLC.

A detailed analysis of H-1B visa sponsorship trends, featuring data on labor certifications, top sponsoring employers, most common job titles, leading immigration law firms, key industries, and geographic distribution. This dataset provides valuable insights into employment-based immigration patterns, helping professionals, employers, and policymakers make informed decisions.

U.S. Department of Labor Employment and Training Administration Office of Foreign Labor Certification Public Disclosure File: Federal Fiscal Year: Reporting Period: H-1B iCERT LCA 2017 October 1, 2016, through September 30, 2017 Important Note: This public disclosure file contains administrative data from employers’ Labor Condition Applications (ETA Forms 9035 & 9035E) and the certification determinations processed by the Department’s Office of Foreign Labor Certification, Employment and Training Administration where the date of the determination was issued on or after October 1, 2016, and on or before September 30, 2017. All data were extracted from the Office of Foreign Labor Certification’s iCERT Visa Portal System; an electronic filing and application processing system of employer requests for H-1B nonimmigrant workers.

A comprehensive dataset of top work states for H-1B Visa sponsorships in 2025, including salary data, petition trends, and employer insights. Updated annually with the latest trends and employer behavior regarding H-1B visa sponsorship.

Context

H-1B visas are a category of employment-based, non-immigrant visas for temporary foreign workers in the United States. For a foreign national to apply for H1-B visa, a US employer must offer them a job and submit a petition for a H-1B visa to the US immigration department. This is also the most common visa status applied for and held by international students once they complete college or higher education and begin working in a full-time position.

The following articles contain more information about the H-1B visa process:

• What is H1B LCA ? Why file it ? Salary, Processing times – DOL
• H1B Application Process: Step by Step Guide

Content

This dataset contains five year's worth of H-1B petition data, with approximately 3 million records overall. The columns in the dataset include case status, employer name, worksite coordinates, job title, prevailing wage, occupation code, and year filed.

For more information on individual columns, refer to the column metadata. A detailed description of the underlying raw dataset is available in an official data dictionary.

Acknowledgements

The Office of Foreign Labor Certification (OFLC) generates program data, including data about H1-B visas. The disclosure data updated annually and is available online.

The raw data available is messy and not immediately suitable analysis. A set of data transformations were performed making the data more accessible for quick exploration. To learn more, refer to this blog post and to the complimentary R Notebook.

Inspiration

• Is the number of petitions with Data Engineer job title increasing over time?
• Which part of the US has the most Hardware Engineer jobs?
• Which industry has the most number of Data Scientist positions?
• Which employers file the most petitions each year?

A comprehensive dataset of top job titles for H-1B Visa sponsorships in 2025, including salary data, petition trends, and employer insights. Updated annually with the latest trends and employer behavior regarding H-1B visa sponsorship.

H-1B visa is a visa in the United States under the Immigration and Nationality Act, section 101(a)(15)(H) that allows U.S. employers to temporarily employ foreign workers in specialty occupations. A specialty occupation requires the application of specialized knowledge and a bachelor’s degree or the equivalent of work experience. (source Wikipedia)

Data

The H-1B Dataset selected for this project contains data from employer’s Labor Condition Application and the case certification determinations processed by the Office of Foreign Labor Certification (OFLC). The Labor Condition Application (LCA) is a document that a perspective H-1B employer files with U.S. Department of Labor Employment and Training Administration (DOLETA) when it seeks to employ non-immigrant workers at a specific job occupation in an area of intended employment for not more than three years. The datasets are from the Department of Labor's website.

A comprehensive dataset of top work cities for H-1B Visa sponsorships in 2025, including salary data, petition trends, and employer insights. Updated annually with the latest trends and employer behavior regarding H-1B visa sponsorship.

A comprehensive dataset of top occupations for H-1B Visa sponsorships in 2025, including salary data, petition trends, and employer insights. Updated annually with the latest trends and employer behavior regarding H-1B visa sponsorship.

A comprehensive dataset of top naics industries for H-1B Visa sponsorships in 2025, including salary data, petition trends, and employer insights. Updated annually with the latest trends and employer behavior regarding H-1B visa sponsorship.

H-1B visa sponsorship trends for Virginia, covering top employers, salary insights, approval rates, and geographic distribution. Explore how work state impacts the U.S. job market under the H-1B program.

H-1B visa sponsorship trends for Teacher, covering top employers, salary insights, approval rates, and geographic distribution. Explore how job title impacts the U.S. job market under the H-1B program.