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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33676 | 33676 | Federal Mogul Corporation | 7346W 400N | Leiters Ford | IN | 46945 | 0000 | Production | Lighting Products for Trucks | Workers | 3647 | 0 | 7/9/1997 | 7/21/1997 | 8/20/1997 | C | 7/9/1996 | 8/20/1999 | HITCHCOCK | 7/21/1997 0:00 | 8/20/1997 | 0 | 0 | 0 | Yes | 30 | 322 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 42072 | 42072 | Federal Mogul Corporation | Microtech, Inc. | 145 North Beacon St. | Brighton | MA | 02135 | 0000 | Suffolk County | 42.3557447 | -71.1454086 | 7 | Production | Friction Products, Automotive Brakes | Union | 3714 | 0 | 8/21/2002 | 9/9/2002 | 11/4/2002 | C | 8/21/2001 | 11/4/2004 | GANNON | 9/9/2002 0:00 | 11/4/2002 | 0 | 0 | 0 | Yes | 56 | 261 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 51867 | 51867 | Federal Mogul Corporation | 7801 Trade Center Ave. | El Paso | TX | 79912 | 0000 | Production | Warehouse, shipping - wiper blades | Company | 3714 | 0 | 5/23/2003 | 5/28/2003 | 6/11/2003 | D | LOPEZ | 5/28/2003 0:00 | 6/11/2003 | 0 | 0 | Yes | 14 | 6 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 59068 | 59068 | Federal Mogul Corporation | Industrial Park, RR 3 Box 1200 | Malden | MO | 63863 | 0000 | Production | Aluminum Pistons | State | 3592 | 0 | 3/21/2006 | 3/22/2006 | 4/25/2006 | C2 | C1 | 3/21/2005 | 4/25/2008 | JHINGORY | 3/22/2006 0:00 | Poole | 4/25/2006 | 1 | 1 | 0 | Yes | India | Emily Modlin | 34 | 346 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 60012 | 60012 | Federal Mogul Corporation | Lighting Division | 325 Sewell Rd. | Sparta | TN | 38583 | 0000 | White County | 35.9455762 | -85.4815445 | 6 | Production | Automotive Miniature Lighting | State | 3647 | 0 | 9/5/2006 | 9/6/2006 | 9/15/2006 | C1 | C1 | 9/5/2005 | 9/15/2008 | COLF | 9/6/2006 0:00 | Kushner | 9/15/2006 | 1 | 1 | 0 | Yes | China | 0 | Libby Burchell;Jim Winningham | 9 | 36 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 60587 | 60587 | Federal Mogul Corporation | Sealing Systems Division | 150 Fisher Avenue | Van Wert | OH | 45891 | 0000 | Van Wert County | 40.8745113 | -84.5970459 | 5 | Production | Oil Seals | Union | 3053 | 0 | 12/11/2006 | 12/13/2006 | 1/8/2007 | C4 | C2 | 12/11/2005 | 1/8/2009 | RICHARDSON | 12/13/2006 0:00 | Poole | 1/8/2007 | 1 | 1 | 0 | Yes | Mexico | 0 | Patrick J. Herman | 26 | 320 | 51 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 61370 | 61370 | Federal Mogul Corporation | 801 South Main Street | Dumas | AR | 71639 | 0000 | Production | Ignition Wire Sets, Bulk Wire, Special Pack, Battery Cable, Booster Cable | State | 3694 | 0 | 4/24/2007 | 4/25/2007 | 6/28/2007 | D3 | D | MENDELSOHN | 4/25/2007 0:00 | Church | 6/28/2007 | 1 | 6 | 0 | Yes | 0 | Billy Vanlandingham | 64 | 82 | 71 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 61395 | 61395 | Federal Mogul Corporation | Systems Protection Group, On-Site Leased Wkrs from Kelly Services | 241 Welsh Pool Road | Exton | PA | 19431 | 0000 | Chester County | 40.0619492 | -75.6449934 | 6 | Production | Protective Sleeving and Heatshields | Union | 3644;2819;3229 | 0 | 4/27/2007 | 4/30/2007 | 5/22/2007 | C5 | C2 | 4/27/2006 | 5/22/2009 | MENDELSOHN | 4/30/2007 0:00 | Church | 5/22/2007 | 1 | 1 | 0 | Yes | Japan, China | 0 | Lewis S. Dopson | 22 | 75 | 114 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 61645 | 61645 | Federal Mogul Corporation | Powertrain Division | 1303 Landon Street, Box 620 | Schofield | WI | 54476 | 0000 | Production | Engine Components, Piston Rings, Seals and Assemblies | Union | 3592 | 0 | 6/7/2007 | 6/8/2007 | 7/31/2007 | CS1 | CU | 6/7/2006 | 7/31/2009 | SCHUETTINGER | 6/8/2007 0:00 | Poole | 7/31/2007 | 1 | 1 | 0 | Yes | 0 | Timothy Stedel | 53 | 130 | 42 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 62398 | 62398 | Federal Mogul Corporation | Wiper Product Division | 402 Royal Road | Michigan City | IN | 46410 | 0000 | LaPorte County | 41.7134026 | -86.8428031 | 1 | Production | Stamped Wiper Components | Company | 3714 | 336399 | 2007 | Manufacturing | Other Motor Vehicle Parts Manufacturing | 11/1/2007 | 11/2/2007 | 11/20/2007 | C4 | C2 | 11/1/2006 | 11/20/2009 | MENDELSOHN | 11/2/2007 0:00 | Church | 11/20/2007 | 1 | 1 | 0 | Yes | Mexico | 0 | Joyce L. Crosby | 18 | 145 | 251 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 70733 | 70733 | Federal Mogul Corporation | Systems Protection Group | 241 Welsh Pool Road | Exton | PA | 19341 | 0000 | Chester County | 40.0619492 | -75.6449934 | 6 | Production | Protective Sleeving Products and Flexible Heatshields | Workers | 3644 | 335932 | 2017 | Manufacturing | Noncurrent-Carrying Wiring Device Manufacturing | 5/22/2009 | 5/29/2009 | 12/4/2009 | CSP-1 | C2 | 5/23/2009 | 12/4/2011 | KENT | 5/29/2009 0:00 | Kushner | 12/4/2009 | 1 | 1 | 0 | Yes | China | 0 | Linda Smith;Patricia Priori;Colleen Bishop | 189 | 0 | 39 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 70780 | 70780 | Federal Mogul Corporation | Powerrain, Seals and Bearings Division | 300 Industrial Park Road SE | Blacksburg | VA | 24060 | 0000 | Montgomery County | 37.1923848 | -80.3975259 | 9 | Production | Engine Bearings, Bushings, Washers for Automotive Markets | Union | 3562 | 332991 | 2017 | Manufacturing | Ball and Roller Bearing Manufacturing | 5/19/2009 | 5/29/2009 | 12/14/2009 | CSP-1 | C2 | 5/19/2008 | 12/14/2011 | MENENDEZ | 5/29/2009 0:00 | Chen | 12/14/2009 | 1 | 1 | 0 | Yes | China | 0 | Phyllis Butterworth;Rhonda Quesenberry;Tommy Epperly | 199 | 0 | 102 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 74857 | 74857 | Federal Mogul Corporation | Leased Workers of Aerotek | 1303 Landon Street, P.O. Box 620 | Schofield | WI | 54476 | 0000 | Marathon County | 44.9117202 | -89.6073913 | 7 | Production | Piston Rings | Union | 3714 | 336312 | 2007 | Manufacturing | Motor Vehicle Gasoline Engine and Engine Parts Manufacturing | 10/15/2010 | 11/10/2010 | 12/17/2010 | CSC | CU | 10/15/2009 | 12/17/2012 | PATTERSON | 11/10/2010 0:00 | Chen | 12/17/2010 | 0 | 0 | Yes | 0 | Timothy Stelzel | 37 | 0 | 193 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |