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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
70739 | 70739 | Chrysler Group LLC | Newark Assembly Plant | 555 South College Avenue | Newark | DE | 19713 | 0000 | Production | Chrysler Aspen and Dodge Durango | Union | 3711 | 336112 | 2017 | Manufacturing | Light Truck and Utility Vehicle Manufacturing | 5/28/2009 | 5/29/2009 | 9/1/2009 | D-4 | D | KENT | 5/29/2009 0:00 | Church | 9/1/2009 | 1 | 6 | 0 | Yes | 0 | Larry Dixon | 95 | 0 | 1032 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 70784 | 70784 | Chrysler Group LLC | Kenosha Engine Plant, Chrysler LLC, Caravan Knight Syncreon | 5555 30th Ave. | Kenosha | WI | 53143 | 0000 | Production | V-6 Automobile Engines | Union | 3714 | 336312 | 2007 | Manufacturing | Motor Vehicle Gasoline Engine and Engine Parts Manufacturing | 5/27/2009 | 5/29/2009 | 9/2/2009 | C-8 | C1 | 5/27/2008 | 9/2/2011 | KENT | 5/29/2009 0:00 | Church | 9/2/2009 | 3/2/2011 | 1 | 1 | 0 | Yes | 0 | Glenn Stark | 96 | 0 | 315 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 71049 | 71049 | Chrysler Group LLC | Formerly Known as Chrysler LLC, Warren Office Building | 6565 East Eight Mile Road | Warren | MI | 48091 | 0000 | Macomb County | 42.4518577 | -83.037153 | 9 | Services | Engineering and Other Tasks in Support of Automobile Manufacturing | Workers | 3711 | 336111 | 2017 | Manufacturing | Automobile Manufacturing | 5/27/2009 | 6/8/2009 | 3/19/2010 | CSS-1 | C2 | 5/27/2008 | 3/19/2012 | KENT | 6/8/2009 0:00 | Jaffe | 3/19/2010 | 4/6/2010 | 1 | 1 | 0 | Yes | 0 | Mario Hardy;MurLidar Ramakrishnan;Wendy Morales | 284 | 0 | 19 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 71136 | 71136 | Chrysler Group LLC | Chrysler LLC, Conner Ave. Assembly, Aerotek, etc | 2000 Conner Ave. | Detroit | MI | 48234 | 0000 | Production | Dodge Viper sports cars and V-10 engines | Union | 3711 | 336111 | 2017 | Manufacturing | Automobile Manufacturing | 5/27/2009 | 6/10/2009 | 9/17/2009 | C-8 | C1 | 5/27/2008 | 9/17/2011 | KENT | 6/10/2009 0:00 | Church | 9/17/2009 | 3/4/2010 | 1 | 1 | 0 | Yes | Finland | 0 | Thomas Cleland | 99 | 0 | 8 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 71584 | 71584 | Chrysler Group LLC | fka Chrysler LLC, Quality Egineering Center | 2021 Executive Hills Blvd. | Auburn Hills | MI | 48236 | 0000 | Services | Engineering Services | State | 3711 | 336111 | 2017 | Manufacturing | Automobile Manufacturing | 6/15/2009 | 7/8/2009 | 3/10/2010 | C-8 | C1 | 6/15/2008 | 3/10/2012 | KENT | 7/8/2009 0:00 | Jaffe | 3/10/2010 | 1 | 1 | 0 | Yes | 0 | Timothy Ross | 245 | 0 | 28 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |