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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28096 | 28096 | Pratt And Whitney | Aircraft | Rt 9, Wells Road | North Berwick | ME | 03906 | 0000 | Production | Jet engine parts | Workers | 3724 | 0 | 12/14/1992 | 2/24/1993 | D | LESSINGTON | 12/14/1992 0:00 | 2/24/1993 | 0 | 0 | 0 | Yes | 72 | 230 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 33000 | 33000 | Pratt and Whitney | 415 Washington Ave. | North Haven | CT | 06473 | 0000 | New Haven County | 41.4094127 | -72.8437569 | 3 | Jet Engines and Engine Parts | Company | 3724 | 0 | 11/25/1996 | 12/9/1996 | 3/11/1997 | D | KUSHNER | 12/9/1996 0:00 | 3/11/1997 | 0 | 0 | Yes | 92 | 200 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 33000A | 33000 | A | Pratt and Whitney | 400 Main Street | East Hartford | CT | 06108 | 0000 | Hartford County | 41.7557983 | -72.6308042 | 1 | Jet Engine Parts and Jet Engines | Company | 3724 | 0 | 11/25/1996 | 12/9/1996 | 3/11/1997 | D | KUSHNER | 12/9/1996 0:00 | 3/11/1997 | 0 | 0 | Yes | 200 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 33000B | 33000 | B | Pratt and Whitney | Middletown | CT | 06457 | 0000 | Jet Engine Parts and Jet Engines | Company | 3724 | 0 | 11/25/1996 | 12/9/1996 | 3/11/1997 | D | KUSHNER | 12/9/1996 0:00 | 3/11/1997 | 0 | 0 | Yes | 200 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 33000C | 33000 | C | Pratt and Whitney | Rocky Hill | CT | 06457 | 0000 | Jet Engine Parts and Jet Engines | Company | 3724 | 0 | 11/25/1996 | 12/9/1996 | 3/11/1997 | D | KUSHNER | 12/9/1996 0:00 | 3/11/1997 | 0 | 0 | Yes | 200 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 37080 | 37080 | Pratt and Whitney | Pratt and Whitney Talon | Inwood Road | Rocky Hill | CT | 06067 | 0000 | Production | Repair Jet Engine Parts | Union | 4581 | 0 | 11/4/1999 | 11/15/1999 | 2/25/2000 | D | PATTERSON | 11/15/1999 0:00 | 2/25/2000 | 0 | 0 | 0 | Yes | 102 | 110 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 37080A | 37080 | A | Pratt and Whitney | Advanced Refurbishment | North Haven | CT | 00000 | 0000 | Production | Repair Aircraft Components | Union | 4581 | 0 | 11/4/1999 | 11/15/1999 | 2/25/2000 | D | PATTERSON | 11/15/1999 0:00 | 2/25/2000 | 0 | 0 | 0 | Yes | 110 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 42358 | 42358 | Pratt and Whitney | Tulsa Airfoil Repair Oper | 2201 E. L. Anderson Blvd. | Claremore | OK | 74017 | 0000 | Production | Repair Jet Engine Components | Company | 3724 | 0 | 10/30/2001 | 11/1/2002 | 12/9/2002 | D | SHULTZ | 11/1/2002 0:00 | 12/9/2002 | 0 | 0 | 0 | Yes | 38 | 50 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 75152 | 75152 | Pratt and Whitney | Cheshire Engine Center; United Technologies Corp.; Belcan, Universal, Kelly | 500 Knotter Drive | Cheshire | CT | 06410 | 0000 | New Haven County | 41.551752 | -72.921525 | 5 | Production | Engine Repair | Union | 3599 | 333618 | 2017 | Manufacturing | Other Engine Equipment Manufacturing | 1/11/2011 | 1/31/2011 | 2/25/2011 | CSS-1 | C2 | 1/11/2010 | 2/25/2013 | KELLY | 1/31/2011 0:00 | Jaffe | 2/25/2011 | 3/27/2012 | 0 | 0 | No | Yes | Singapore | 0 | Wayne McCarthy | 25 | 0 | 800 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 75152A | 75152 | A | Pratt and Whitney | United Technologies Corp.; FAR Group and Experimental Test | 400 Main Street | East Hartford | CT | 06108 | 0000 | Hartford County | 41.7557983 | -72.6308042 | 1 | Production | Engine Repair | Union | 3599 | 333618 | 2017 | Manufacturing | Other Engine Equipment Manufacturing | 1/11/2011 | 1/31/2011 | 2/25/2011 | CSS-1 | C2 | 1/11/2010 | 2/25/2013 | KELLY | 1/31/2011 0:00 | Jaffe | 2/25/2011 | 3/27/2012 | 0 | 0 | Yes | Singapore | 0 | Wayne McCarthy | 0 | 70 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 81398 | 81398 | Pratt and Whitney | United Technologies Corporation, Far Group and Experimental Test Group | 400 Main Street, M/S 124-14 | East Hartford | CT | 06108 | 0000 | Hartford County | 41.7557983 | -72.6308042 | 1 | Services | Engine Repair Services | State/AJC | 0 | 333618 | 2017 | Manufacturing | Other Engine Equipment Manufacturing | 3/5/2012 | 3/6/2012 | 3/27/2012 | T-3 | T | MANUEL | 3/6/2012 0:00 | Chen | 3/27/2012 | 0 | 0 | Yes | Yes | 0 | Susan Fracasso | 21 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |