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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40345A | 40345 | A | Bombardier Transportation | 1501 Lebanon Church Road | Pittsburgh | PA | 00000 | 0000 | Production | Transit Cars, Transit Propulsion Systems | Company | 3743 | 0 | 10/29/2001 | 11/13/2001 | 12/27/2001 | D | WORDEN | 11/13/2001 0:00 | 12/27/2001 | 0 | 0 | 0 | Yes | 50 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 40345B | 40345 | B | Bombardier Transportation | 2001 Lebanon Road | Pittsburgh | PA | 00000 | 0000 | Production | Transit Cars, Transit Propulsion Systems | Company | 3743 | 0 | 10/29/2001 | 11/13/2001 | 12/27/2001 | D | WORDEN | 11/13/2001 0:00 | 12/27/2001 | 0 | 0 | 0 | Yes | 50 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 41025 | 41025 | Bombardier Transportation | 1501 Lebanon Church Rd. | Pittsburgh | PA | 15236 | 0000 | Production | Propulsion systems for transit vehicles | Workers | 3743 | 0 | 2/6/2002 | 3/11/2002 | 6/21/2002 | C | 2/6/2001 | 6/21/2004 | BUNDY | 3/11/2002 0:00 | 6/21/2002 | 0 | 0 | 0 | Yes | 102 | 170 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 55656 | 55656 | Bombardier Transportation | Propulsion Division | 1501 Lebanon Church Rd. | Pittsburgh | PA | 15236 | 0000 | Production | propulsion equipment | Company | 5088 | 0 | 9/8/2004 | 9/23/2004 | 11/1/2004 | C2 | C1 | 6/22/2004 | 11/1/2006 | LAZANEO | 9/23/2004 0:00 | Church | 11/1/2004 | 12/7/2004 | 0 | 0 | 0 | Yes | Roberta Thomas;Buddy Lepky;Grego Peters | 39 | 57 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 55656A | 55656 | A | Bombardier Transportation | Total Transit Systems (TTS) Division | Pittsburgh | PA | 15236 | 0000 | Production | automated transit systems | Company | 4173 | 0 | 9/8/2004 | 9/23/2004 | 11/1/2004 | C2 | C1 | 6/22/2004 | 11/1/2006 | LAZANEO | 9/23/2004 0:00 | Church | 11/1/2004 | 12/7/2004 | 0 | 0 | 0 | Yes | Roberta Thomas;Buddy Lepky;Grego Peters | 25 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 62639 | 62639 | Bombardier Transportation | Propulsion Division, Including Adecco | 1501 Lebanon Church Road | Pittsburgh | PA | 15236 | 0000 | Allegheny County | 40.3466795 | -79.9570848 | 18 | Production | Propulsion Equipment and Automated Transit Systems | Workers | 5088;4173 | 423860 | 2017 | Wholesale Trade | Transportation Equipment and Supplies (except Motor Vehicle) Merchant Wholesalers | 12/31/2007 | 1/7/2008 | 3/27/2008 | C2 | C1 | 12/31/2006 | 3/27/2010 | JOHNSON | 1/7/2008 0:00 | Kushner | 3/27/2008 | 5/22/2008 | 1 | 1 | 0 | Yes | Japan | 0 | Celeste Linkhauer;Dawn R. Smoyer;Christine M. Bittner | 80 | 221 | 28 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 62639A | 62639 | A | Bombardier Transportation | Total Transit Systems Division, Adecco | 1501 Lebanon Church Road | Pittsburgh | PA | 15236 | 0000 | Allegheny County | 40.3466795 | -79.9570848 | 18 | Production | Propulsion Equipment and Automated Transit Systems | Workers | 5088;4173 | 423860 | 2017 | Wholesale Trade | Transportation Equipment and Supplies (except Motor Vehicle) Merchant Wholesalers | 12/31/2007 | 1/7/2008 | 3/27/2008 | C2 | C1 | 12/31/2006 | 3/27/2010 | JOHNSON | 1/7/2008 0:00 | Kushner | 3/27/2008 | 5/22/2008 | 1 | 1 | 0 | Yes | Japan | 0 | Celeste Linkhauer;Dawn R. Smoyer;Christine M. Bittner | 222 | 28 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 73379 | 73379 | Bombardier Transportation | Bombardier Mass Transit, Leased Workers form Eastern Technical Services | 71 Wall Street | Plattsburgh | NY | 12901 | 0000 | Clinton County | 44.677122 | -73.469598 | 21 | Production | Commuter Rail Trains | Company | 4111 | 485111 | 2017 | Transportation and Warehousing | Mixed Mode Transit Systems | 1/26/2010 | 1/28/2010 | 7/30/2010 | CSP-1 | C2 | 1/26/2009 | 7/30/2012 | ABUSHAWISH | 2/18/2010 0:00 | Chen | 7/30/2010 | 1 | 0 | 0 | Yes | 0 | Alain Aumais | 183 | 0 | 210 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |