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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
53322 | 53322 | John Crane, Inc. | 815 Payne Dr. | Vandalia | IL | 62471 | 0000 | Production | axle seals | Company | 3714 | 0 | 10/22/2003 | 10/23/2003 | 11/12/2003 | C2 | 10/22/2002 | 11/12/2005 | ADAMOPOULOS | 10/23/2003 0:00 | 11/12/2003 | 1 | 1 | 0 | Yes | 20 | 102 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 55732 | 55732 | John Crane, Inc. | McAllen Warehouse | 2705 Ebony Ave. | McAllen | TX | 78501 | 0000 | Production | warehouse & distribute mechanical seals | Company | 3714 | 0 | 9/8/2004 | 10/4/2004 | 10/29/2004 | D1 | D | GANNON | 10/4/2004 0:00 | Kushner | 10/29/2004 | 1 | 2 | 0 | Yes | Mexico | Guadalupe Gonzales | 25 | 17 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 75137 | 75137 | John Crane, Inc. | 50 Sharpe Drive | Cranston | RI | 02920 | 0000 | Providence County | 41.7415267 | -71.4546247 | 2 | Production | Mechanical Seal Devices | Company | 3053 | 339991 | 2017 | Manufacturing | Gasket, Packing, and Sealing Device Manufacturing | 1/24/2011 | 1/25/2011 | 2/15/2011 | CSP-1 | C2 | 1/24/2010 | 2/15/2013 | JOHNSON | 2/9/2011 0:00 | Jaffe | 2/15/2011 | 0 | 0 | Yes | Mexico | 0 | Raymond Morrissette | 21 | 0 | 33 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 81083 | 81083 | John Crane, Inc. | Business Information Services Division, Smiths Group PLC | 6400 West Oakton Street | Morton Grove | IL | 60053 | 0000 | Cook County | 42.0264697 | -87.7939388 | 9 | Services | Information Technology (IT) Services | Workers | 0 | 561110 | 2017 | Administrative and Support and Waste Management and Remediation Services | Office Administrative Services | 11/14/2011 | 11/15/2011 | 2/7/2012 | CSS-1 | C2 | 2/13/2010 | 2/7/2014 | WITHERSPOON | 11/15/2011 0:00 | Chen | 2/7/2012 | 0 | 0 | Yes | Yes | India | 0 | Roger Mohring;Desta Elliott;Boris Stuhl | 84 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 92427 | 92427 | John Crane, Inc. | Smith Group | 16290 Shoemaker Avenue | Cerritos | CA | 90703 | 0000 | Los Angeles County | 33.8838087 | -118.0541475 | 38 | Production | Mechanical Seals | State/AJC | 0 | 339991 | 2017 | Manufacturing | Gasket, Packing, and Sealing Device Manufacturing | 11/16/2016 | 11/17/2016 | 3/10/2017 | C-8 | C1 | 11/16/2015 | 3/10/2019 | WITHERSPOON | 11/17/2016 0:00 | Chen | 3/10/2017 | 0 | 0 | Yes | Yes | 0 | Tina Chen | 113 | 0 | 10 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |