Department of Labor Office of Foreign Labor Certification
Foreign worker visas (H-1B, H-2A, H-2B, PERM)
Employers' requests to hire foreign workers: job, wage, worksite, and how many workers, with county totals.
Published by Department of Labor Office of Foreign Labor Certification
Finest detail county
Tables 5
Permanent labor certification
Sample of 25 rows out of about 1,425,329
· 33 columns
| id | program | fiscal_year | row_num | case_number | case_status | visa_class | received_date | decision_date | employer_name | employer_city | employer_state | employer_zip | worksite_city | worksite_county | worksite_state | worksite_zip | soc_code | soc_title | naics_code | job_title | crop | workers_requested | workers_certified | wage_from | wage_to | wage_unit | begin_date | sub_row | end_date | county_fips | fips_method | state |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | perm | 2008 | 1 | A-08271-91262 | DENIED | No data | No data | 2008-09-29 | DC GRILL INC T/A DC CAFE | WASHINGTON | DC | No data | WASHINGTON | No data | DC | No data | 35-2014 | No data | No data | UNCLASSIFIED | No data | No data | No data | 10.23 | No data | HR | No data | 0 | No data | 11001 | city | DC |
| 2 | perm | 2008 | 2 | C-07327-98303 | DENIED | No data | No data | 2007-11-29 | NAG INC DBA ENGINEERING SYSTEMS | LOS ANGELES | CA | No data | LOS ANGELES | No data | CA | No data | 19-3051 | No data | No data | UNCLASSIFIED | No data | No data | No data | 54000.00 | No data | YR | No data | 0 | No data | 06037 | city | CA |
| 3 | perm | 2008 | 3 | A-08029-18103 | CERTIFIED | No data | No data | 2008-07-10 | UNION ENTERPRISES, INC. | BALTIMORE | MD | No data | BALTIMORE | No data | MD | No data | 35-1012 | No data | No data | UNCLASSIFIED | No data | No data | No data | 9.80 | No data | HR | No data | 0 | No data | 24510 | city | MD |
| 4 | perm | 2008 | 4 | A-07262-76878 | DENIED | No data | No data | 2007-10-15 | CIVIL CONSTRUCTION, LLC. | CHEVERLY | MD | No data | CHEVERLY | No data | MD | No data | 47-2051 | No data | No data | UNCLASSIFIED | No data | No data | No data | 11.42 | No data | HR | No data | 0 | No data | 24033 | city | MD |
| 5 | perm | 2008 | 5 | A-08273-91603 | DENIED | No data | No data | 2008-09-30 | AMSERA GENERAL BEAUTY MERCHANDISE | TEANECK | NJ | No data | TEANECK | No data | NJ | No data | 99-9999.99 | No data | No data | UNCLASSIFIED | No data | No data | No data | 6.00 | 6.00 | HR | No data | 0 | No data | 34003 | city | NJ |
| 6 | perm | 2008 | 6 | A-08270-90909 | DENIED | No data | No data | 2008-09-29 | EDWARD SIMON | GREAT NECK | NY | No data | GREAT NECK | No data | NY | No data | 37-2012 | No data | No data | UNCLASSIFIED | No data | No data | No data | 8.58 | No data | HR | No data | 0 | No data | 36059 | city | NY |
| 7 | perm | 2008 | 7 | A-07127-34355 | CERTIFIED | No data | No data | 2008-09-29 | BOTCHIE I. CERVANTES | VALLEY STREAM | NY | No data | VALLEY STREAM | No data | NY | No data | 39-9011.01 | No data | No data | UNCLASSIFIED | No data | No data | No data | 9.85 | No data | HR | No data | 0 | No data | 36059 | city | NY |
| 8 | perm | 2008 | 8 | A-06269-63743 | CERTIFIED | No data | No data | 2008-09-26 | CHIQUITA LATINA CORP | EAST HAMPTON | NY | No data | EAST HAMPTON | No data | NY | No data | 51-3011.01 | No data | No data | UNCLASSIFIED | No data | No data | No data | 9.47 | No data | HR | No data | 0 | No data | 36103 | city | NY |
| 9 | perm | 2008 | 9 | A-08256-86411 | DENIED | No data | No data | 2008-09-17 | ARTHUR MURRAY DANCE STUDIO | WHITE PLAINS | NY | No data | WHITE PLAINS | No data | NY | No data | 27-2032 | No data | No data | UNCLASSIFIED | No data | No data | No data | 13.64 | No data | HR | No data | 0 | No data | 36119 | city | NY |
| 10 | perm | 2008 | 10 | A-08136-52468 | DENIED | No data | No data | 2008-09-17 | MARIA DEL ROCIO VILLA GARCIA | HALLANDALE | FL | No data | HALLANDALE | No data | FL | No data | 39-9011 | No data | No data | UNCLASSIFIED | No data | No data | No data | 9.40 | No data | HR | No data | 0 | No data | 12011 | city | FL |
| 11 | perm | 2008 | 11 | A-08255-85973 | DENIED | No data | No data | 2008-09-15 | TRIO ASBESTOS REMOVAL CORP. | COLLEGE POINT | NY | No data | BAYSIDE | No data | NY | No data | 47-2061 | No data | No data | UNCLASSIFIED | No data | No data | No data | 29.50 | No data | HR | No data | 0 | No data | 36081 | city | NY |
| 12 | perm | 2008 | 12 | A-08255-86041 | DENIED | No data | No data | 2008-09-15 | MERVIN DAYAN | OAKHURST | NJ | No data | W. LONG BRANCH | No data | NJ | No data | 39-9021 | No data | No data | UNCLASSIFIED | No data | No data | No data | 10.68 | 11.00 | HR | No data | 0 | No data | No data | No data | NJ |
| 13 | perm | 2008 | 13 | A-08248-84179 | DENIED | No data | No data | 2008-09-08 | RESCOM WINDOWS | MARTINSBURG | WV | No data | MARTINSBURG | No data | WV | No data | 47-2121 | No data | No data | UNCLASSIFIED | No data | No data | No data | 15.99 | No data | HR | No data | 0 | No data | 54003 | city | WV |
| 14 | perm | 2008 | 14 | A-08241-82617 | DENIED | No data | No data | 2008-09-05 | ECONOMY FLEET WASH INC. | MORGANVILLE | NJ | No data | VARIOUS | No data | NJ | No data | 53-7061 | No data | No data | UNCLASSIFIED | No data | No data | No data | 10.00 | No data | HR | No data | 0 | No data | No data | No data | NJ |
| 15 | perm | 2008 | 15 | A-08247-83738 | DENIED | No data | No data | 2008-09-05 | RAELYISSA ANGELINO | BRIGHTON | CO | No data | BRIGHTON | No data | CO | No data | 99-9999.99 | No data | No data | UNCLASSIFIED | No data | No data | No data | 8.00 | No data | HR | No data | 0 | No data | 08001 | city | CO |
| 16 | perm | 2008 | 16 | A-06079-98668 | CERTIFIED | No data | No data | 2008-08-29 | SIT CORP. | MIAMI | FL | No data | MIAMI | No data | FL | No data | 43-5071 | No data | No data | UNCLASSIFIED | No data | No data | No data | 10.00 | No data | HR | No data | 0 | No data | 12086 | city | FL |
| 17 | perm | 2008 | 17 | A-08238-81405 | DENIED | No data | No data | 2008-08-27 | WINSTON CHAMBERS | ROSEDALE | NY | No data | ROSEDALE | No data | NY | No data | 39-9011 | No data | No data | UNCLASSIFIED | No data | No data | No data | 250.00 | No data | WK | No data | 0 | No data | 36081 | city | NY |
| 18 | perm | 2008 | 18 | A-08233-79975 | DENIED | No data | No data | 2008-08-25 | SWEET HILLS STABLES | CENTRAL ISLIP | NC | No data | CENTRL ISLIP | No data | NY | No data | 45-2093 | No data | No data | UNCLASSIFIED | No data | No data | No data | 450.00 | No data | WK | No data | 0 | No data | No data | No data | NY |
| 19 | perm | 2008 | 19 | A-06058-90545 | DENIED | No data | No data | 2008-08-19 | ED ROONEY /CEDRO LTD | FORT WASHINGTON | MD | No data | FORT WASHINGTON | No data | MD | No data | 43-6011 | No data | No data | UNCLASSIFIED | No data | No data | No data | 17.79 | No data | HR | No data | 0 | No data | 24033 | city | MD |
| 20 | perm | 2008 | 20 | A-08220-76620 | DENIED | No data | No data | 2008-08-19 | REDEEMED CHRISTIAN CHURCH | OPA LOCKA | FL | No data | OPA LOCKA | No data | FL | No data | 21-2011 | No data | No data | UNCLASSIFIED | No data | No data | No data | No data | No data | BI | No data | 0 | No data | 12086 | city | FL |
| 21 | perm | 2008 | 21 | A-08228-78997 | DENIED | No data | No data | 2008-08-19 | SUSAN DOUGHERTY | BROOKLYN | NY | No data | BROOKLYN | No data | NY | No data | 37-2012 | No data | No data | UNCLASSIFIED | No data | No data | No data | 9.59 | No data | HR | No data | 0 | No data | 36047 | city | NY |
| 22 | perm | 2008 | 22 | A-06024-78558 | DENIED | No data | No data | 2008-08-13 | TOTAL ENGINEERING, INC. | LANDOVER | MD | No data | LANDOVER | No data | NJ | No data | 41-1011 | No data | No data | UNCLASSIFIED | No data | No data | No data | 21.50 | 23.00 | HR | No data | 0 | No data | No data | No data | NJ |
| 23 | perm | 2008 | 23 | A-08210-73502 | DENIED | No data | No data | 2008-07-29 | EMMANUEL PENTECOSTAL CHURCH | JERSEY CITY | NJ | No data | JERSEY CITY | No data | NJ | No data | 99-9999.99 | No data | No data | UNCLASSIFIED | No data | No data | No data | 400.00 | No data | WK | No data | 0 | No data | 34017 | city | NJ |
| 24 | perm | 2008 | 24 | A-06256-58642 | CERTIFIED | No data | No data | 2008-07-15 | HELEN SALUS | ENGLEWOOD | NJ | No data | ENGLEWOOD | No data | NJ | No data | 39-9099.99 | No data | No data | UNCLASSIFIED | No data | No data | No data | 9.34 | No data | HR | No data | 0 | No data | 34003 | city | NJ |
| 25 | perm | 2008 | 25 | A-08191-68557 | DENIED | No data | No data | 2008-07-10 | PILLARI BROTHERS CONSTRUCTION COMPANY | FARMINGDALE | NJ | No data | FARMINGDALE | No data | NJ | No data | 49-3031 | No data | No data | UNCLASSIFIED | No data | No data | No data | 20.84 | No data | HR | No data | 0 | No data | 34025 | city | NJ |
🔒 Some columns are hidden in this preview for privacy.
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing