Welcome to Guest Worker Visas, Version 4.0, developed by Virgil Bierschwale, a Displaced American Software Developer and Navy Veteran.
Help Support My Work | VAERS Data | Browse VAERS Data | Stem Workers United
Employers by City State | Secondary Employers by City State | Immigration Attorneys by City State | Jobs Sent To Other Countries | Jobs Offshored By Employer
Search for Employer | Search for Secondary Employer | What do they get paid by company? | What do they get paid by Salary?
Browse by State | Browse by State Secondary Employer | Browse City State by SOC CODE
Jobs Sent Offshore by STATE and YEAR
TAWSUFF | TAW | Suffix | WorkerGroupName | SecondName | StreetAddress | City | State | Zip | ZipPlus4 | County_Long | Latitude | Longitude | Congressional District_Short | WorkerGroupType | Product | Service | Petitioner | SIC | NAICSCode | NAICSCodeYear | NAICSTitle2 | NAICSTitle6 | PetitionDate | InstDate | DetDate | InvDetCode | DetCode | ImpactDate | ExpirationDate | LastInvestigator | CASLastAssignmentonInitialInvestigation | CertifyingOfficerLastName | CASFirstDecisionDate | MostRecentUpdate | AtaaAppl | AtaaCert | AtaaRevised | DisplayPDF | DisplayText | Countries | Reqrecon2 | PetitionerName | PetitionersUnion | AllegationText | RequestforAmendment | AllegationofCompanyImports | AllegationofCustomerImports | AllegationofDownstreamProducer | AllegationofSecondarSupplier | AllegationofShift | AllegationofITC | AllegedITCNumber | AllegedITCTitle | AllegedITCFRNDate | InvDays | EstWorkers | EstWorkers1 | NumberofInvestigatorsonInitialInvestigation | WGInitialInvestigationCount | WGAmendmentInvestigationCount | WGCorrectionInvestigationCount | WGApplicationforReconsiderationInvestigationCount | WGReconsiderationInvestigationCount | WGRemandInvestigationCount | WGStatutoryReconsiderationInvestigationCount |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
92659 | 92659 | LedVance LLC | OSRAM Sylvania Inc., Lamp Division, Remedy, Manpower and Aerotek | 900 Tyrone Pike | Versailles | KY | 40383 | 0000 | Woodford County | 38.0477462 | -84.7500328 | 6 | Production | Fluorescent Lamps | Company | 0 | 335110 | 2017 | Manufacturing | Electric Lamp Bulb and Part Manufacturing | 2/20/2017 | 2/21/2017 | 4/21/2017 | CSP-1 | C2 | 2/20/2016 | 4/21/2019 | HLAVACEK | 2/21/2017 0:00 | Chen | 4/21/2017 | 0 | 0 | Yes | Yes | China | 0 | Michael McNulty | 59 | 0 | 45 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 93407 | 93407 | LEDVANCE LLC | Eastern Distribution Center (EDC), LEDVANCE GMBH, Manpower | 2460 Brodhead Road | Bethlehem | PA | 18020 | 0000 | Northampton County | 40.6777761 | -75.3612257 | 7 | Services | Warehousing, Repack, and Distribution Services | Company | 0 | 493110 | 2017 | Transportation and Warehousing | General Warehousing and Storage | 1/5/2018 | 1/8/2018 | 2/15/2018 | SSS | CU | 1/5/2017 | 2/15/2020 | MANUEL | 1/8/2018 0:00 | Kinglock | 2/15/2018 | 0 | 0 | Yes | Yes | 0 | Cindy Cortinovis;Jeffery Williams | 38 | 0 | 25 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 94755 | 94755 | LEDVANCE LLC | OSRAM Sylvania, LEDVANCE Gmbh, Manpower, Wortman Controls, etc. | 835 Washington Street | Saint Mary's | PA | 15857 | 0000 | Elk County | 41.4471318 | -78.5579225 | 15 | Production | Incandescent, Halogen and LED lamps | Company | 0 | 335110 | 2017 | Manufacturing | Electric Lamp Bulb and Part Manufacturing | 4/25/2019 | 4/25/2019 | 5/22/2019 | CSP-1 | C2 | 7/27/2019 | 5/22/2021 | MANUEL | 4/25/2019 0:00 | Kinglock | 5/22/2019 | 0 | 0 | Yes | Yes | India | 0 | Cindy Cortinovis | 27 | 0 | 215 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 95055 | 95055 | LEDVANCE LLC | Manpower Inc., Connected Systems Partners | 200 Ballardvale Street | Wilmington | MA | 01887 | 0000 | Middlesex County | 42.586776 | -71.1584054 | 6 | Services | Payroll, Finance, Supply Chain, R&D, IT, Project Management, etc. | Company | 0 | 327212 | 2017 | Manufacturing | Other Pressed and Blown Glass and Glassware Manufacturing | 8/7/2019 | 8/8/2019 | 9/25/2019 | CSS-1 | C2 | 8/7/2018 | 9/25/2021 | MANUEL | 8/8/2019 0:00 | Kinglock | 9/25/2019 | 0 | 0 | Yes | Yes | China | 0 | Michael Amthor | 48 | 0 | 32 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 95658 | 95658 | LEDVANCE LLC | LEDVANCE Holdings, LLC | 2460 Brodhead Road | Bethlehem | PA | 18020 | 0000 | Northampton County | 40.6777761 | -75.3612257 | 7 | Services | Warehousing/Distribution and Related Support (Management and IT) | Company | 0 | 493110 | 2017 | Transportation and Warehousing | General Warehousing and Storage | 2/5/2020 | 2/6/2020 | 6/11/2020 | CDP | CD | 2/16/2020 | 6/11/2022 | HOWARD | 2/6/2020 0:00 | Kinglock | 6/11/2020 | 0 | 0 | Yes | Yes | India | 0 | Michael F. Amthor | 126 | 0 | 53 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 96765 | 96765 | LEDVANCE LLC | Headquarters | 200 Ballardvale St | Wilmington | MA | 01887 | 1074 | Middlesex County | 42.586776 | -71.1584054 | 6 | Services | back off functions not limited to finance, human resources, and information technology services | Company | 0 | 327212 | 2017 | Manufacturing | Other Pressed and Blown Glass and Glassware Manufacturing | 3/3/2021 | 3/4/2021 | 3/31/2021 | CSS-1 | C2 | 9/26/2021 | 3/31/2023 | Manuel | 3/4/2021 10:36 | Kinglock | 3/31/2021 | 0 | 0 | Yes | Yes | China | 0 | Michael Amthor | US employees in back office jobs are being laid off as that work is being moved to Mexico and China. Finance, Compliance, HR, Supply Chain and Packaging have been are schedule to be eliminated through October. Review is ongoing to identify other opportun | No | No | No | No | No | No | No | 27 | 0 | 55 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |