You have two options. You can do the Easy Search or an Advanced Search.

  1. Easy Search - Use the drop down list to select a company name. These companies are a small subset of names that were pre-selected because they are companies with familiar names. All of these searches have been tested and will return results. This is a great way to get acquainted with the types of companies that are in the database. 

  2. Advanced Search - You can enter search parameters into Job Category, Job Location by City and State, and company name.

Companies are required to enter a numerical code to categorize which job category the H-1B will be. The numerical system used is called the OCC classification system. It is a 3 digit code that is assigned by the employer. You don't see the category code in the search results but it is used to filter the search. 

 

Database Tutorial

 

What is in the Visa Database?

The LCA Database is a searchable table of Labor Condition Applications (LCA) that were obtained from the Department of Labor. For more detail on LCAs go to the FAQs page.

What Kind of  Searches are Available?

How is Job Category Determined?

What is the Enter Number of Records For

You can enter the total number of records returned by the search. If you have a slow modem connection you may want to choose lower numbers to increase the speed at which you obtain results.

 

How Do I Set Up A Search

Clicking the RESET button will set all boxes to "All". 

These query boxes are logically AND'ed together. To get results from only one of the boxes, make sure others are set to "All". 

The Company Name Box searches look for any match in the field. Hint: If  "mas" is entered for Employer Name you will get all companies that contain mas such as REOMAS USA, Inc., Thomas Howell Group, Mastech Corp. 

City Names are a string search that works like the Company Name. If "new" is entered for City you will get all cities that contain new such as New York, Newport, and Newark.

If you have an apostrophe in the name, such as McDonald's, you must use two apostrophes or the search won't work. Enter McDonald''s.

These searches can take awhile if there are many records to be displayed for your query. Be patient, to see the results!!!  

 

This search engine is set up to logically AND each box

(Job Category) AND (State) AND (Company Name)

If every box is set to the default "All" condition, the search engine will return all records in the database in alphabetical order by company name. 

For example:
Job Category = "View All Job Categories"
State = "All States"
Cities = "All Cities"
Company Name = "Search All Companies"

This search will yield all job categories in the database, from every state and city, and from every company.

For example:
Job Category = "Computers, Software, and programming professionals"
State = "All States"
Company Name = "Search All Companies"

This search will narrow the listings to Computers, Software, and programming professionals.

For example:
Job Category = "Computers, Software, and programming professionals"
State = "NM"
Cities = "All Cities"
Company Name = "Search All Companies"

This search will narrow the listings to Computers, Software, and programming professionals jobs that are listed in the state of New Mexico.

For example:
Job Category = "Computers, Software, and programming professionals"
State = "NM"
Cities = "All Cities"
Company Name = "mastech"

This search will narrow the listings to Computers, Software, and programming professionals jobs that are listed in the state of New Mexico, and work for the company Mastech.

 

The first thing you will see on the search page is a synopsis of the search you chose to do. 

Here are The Search Parameters You Chose:
Job Category OCC:     30
Job Location - City:     Search All Cities
Job Location - State:   Search All States
Company Name:          Search All Companies
Records Per Page:      5

Once the search is completed you will see some statistics and the results table.

Total Records Found =100
Page 1 of 20

The Total Records Found is the total number of LCAs that met your search criterion. The Page 1 of ### tells you how many pages you will have to view to see all of the results. You can scroll each page sequentially by going to the bottom of the table and clicking "Next". You can go backwards by clicking "Previous".

Title Visa Name City St #
of Aliens 
Salary $  Pay Rate  Start Date End Date

 

Title   descriptive job title
Visa
This is the type of visa.There are three types of Visas in the database:
    PERM - Permanent green cards
    H-1B - Temporary Professional H-1B
    TEMP - these are H-2B or H-1A visas that are for agricultural or 
                  manufacturing jobs
Name  The name of the Company that filed the LCA
City and State The location of the workplace
# Of Aliens Each LCA can request multiple visas as long as they are for the same job type

Salary $ 

The salary that will the worker will receive
Pay Rate
H Hourly
W Weekly
M Monthly
A Annually
Start Date The day the visa is active. This is approximately the date when the worker starts work
End Date The day the visa expires. The worker will have to go back to his/her country unless the  visa can be renewed.

 

I have periodically added more records to the online database and that is what I refer to as "updates". I will be obtaining more recent data and will put it online, hopefully soon. 

The DOL recently told me that they are being deluged with LCAs and simply can't keep up with them.

Here is a history of the updates. This will be an ongoing effort. Check back occasionally to see if an update has occurred.

Database Update History

Date

Records

10/4/2000 615,135
9/9/2000 310,578
8/13/2000 310,346
8/9/2000 271,224
6/30/2000 240,288
6/10/2000 99,346
6/01/2000 79,177
5/18/1999 69,177
4/23/1999 69,029

 

Assume the DOL entered the data correctly because that is the one thing we can never know for sure. Large companies hire enormous numbers of H-1Bs so they naturally fill out many LCAs for that. Another thing you may be observing is a corporate behavior called "banking". Companies submit an a lot of LCAs so that they can cover future needs. Of course the law says that H-1Bs are to be used to fill empty spots. Obviously banking is another method used to abuse the law. 

 

Why can't I find a known H-1B employer in the Database?

First verify that you have done the search correctly using the help on this page. If you are sure you are doing the search correctly you may want to try different variations of the company name. Here are some examples:  

  • If IBM is listed and "International Business Machines" or "I.B.M." you will not find it by using the company name IBM. Unfortunately companies don't have to state their name using a standard protocol and they often don't. Sometimes you have to be very creative to find it. 

  • Find if a larger corporation owns the company you are searching for. As an example the "San Francisco Chronicle" newspaper has very few listings but their owner Disney has many listings. Disney also owns ABC News and Go.com.

If you have done all of those and still can't find the company in the database there could be several reasons:

  • The H-1B Visa Database that you see online is not complete. At the time of this writing there are over 615,000 records online. I have about another 500,000 that I still need to put online. This data is about 1 year old. The Department labor has several hundred thousand more of them and are getting hundreds per day. They started getting flooded with LCAs a month before the new 195,000 limit was rubber stamped by congress and President Clinton. ShameH1B will continue to update the database. The problem is that this data takes a lot of web server space and more data costs more money as well as more effort to put it online.

  • Not all companies that have H-1Bs on their staff have an LCA. That is because if they hire and H-1B through a bodyshop such as TATA, Mastech, or Wipro, they don't have to have their name listed. As an example, if TATA imports an H-1B and that H-1B is contracted to Microsoft, you will see an LCA for TATA, not Microsoft, in the database. Companies love to use bodyshops because it reduces their accountability for lawsuits and visa disputes.

 
What do the Search Results Mean?
How Often is the Database Updated?

 Is it possible to determine how many visas  are given under H1-B in a year for a particular job category? 

In theory it is possible to determine how many visas are given, but not from this database. Remember an LCA is an application. Once it's approved it is sent to the INS. There is no way to know how many of these LCAs resulted in actual visas from this database. There is a possibility that this could be determined from the INS I-129 database. 

Why do some companies have so many LCAs?

  11/03/00