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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
52684 | 52684 | PSC Metals, Inc. | Headquarters | 20521 Chagrin Blvd. | Cleveland | OH | 44122 | 0000 | Production | Steel Products | Company | 3312 | 0 | 8/19/2003 | 8/26/2003 | 10/3/2003 | CU | 8/19/2002 | 10/3/2005 | LOPEZ | 8/26/2003 0:00 | 10/3/2003 | 1 | 1 | 0 | Yes | 38 | 6 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 52684A | 52684 | A | PSC Metals, Inc. | Ashland Facility | Ashland | VA | 23005 | 0000 | Production | Steel Products | Company | 3312 | 0 | 8/19/2003 | 8/26/2003 | 10/3/2003 | CU | 8/19/2002 | 10/3/2005 | LOPEZ | 8/26/2003 0:00 | 10/3/2003 | 0 | 0 | Yes | 6 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 52684B | 52684 | B | PSC Metals, Inc. | Beaver Falls Facility | Beaver Falls | PA | 15010 | 0000 | Production | Steel Products | Company | 3312 | 0 | 8/19/2003 | 8/26/2003 | 10/3/2003 | CU | 8/19/2002 | 10/3/2005 | LOPEZ | 8/26/2003 0:00 | 10/3/2003 | 0 | 0 | Yes | 6 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 52684C | 52684 | C | PSC Metals, Inc. | Burns Harbor Facility | Burns Harbor | IN | 46304 | 0000 | Production | Steel Products | Company | 3312 | 0 | 8/19/2003 | 8/26/2003 | 10/3/2003 | CU | 8/19/2002 | 10/3/2005 | LOPEZ | 8/26/2003 0:00 | 10/3/2003 | 0 | 0 | Yes | 6 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 52684D | 52684 | D | PSC Metals, Inc. | Canton Facility | Canton | OH | 44706 | 0000 | Production | Steel Products | Company | 3312 | 0 | 8/19/2003 | 8/26/2003 | 10/3/2003 | CU | 8/19/2002 | 10/3/2005 | LOPEZ | 8/26/2003 0:00 | 10/3/2003 | 0 | 0 | Yes | 6 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 52684E | 52684 | E | PSC Metals, Inc. | Gallatin Facility | Gallatin | TN | 37066 | 0000 | Production | Steel Products | Company | 3312 | 0 | 8/19/2003 | 8/26/2003 | 10/3/2003 | CU | 8/19/2002 | 10/3/2005 | LOPEZ | 8/26/2003 0:00 | 10/3/2003 | 0 | 0 | Yes | 5 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 52684F | 52684 | F | PSC Metals, Inc. | Granite City Facility | Granite City | IL | 62040 | 0000 | Production | Steel Products | Company | 3312 | 0 | 8/19/2003 | 8/26/2003 | 10/3/2003 | CU | 8/19/2002 | 10/3/2005 | LOPEZ | 8/26/2003 0:00 | 10/3/2003 | 0 | 0 | Yes | 5 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 52684G | 52684 | G | PSC Metals, Inc. | St. Louis Facility | St. Louis | MO | 63147 | 0000 | Production | Steel Products | Company | 3312 | 0 | 8/19/2003 | 8/26/2003 | 10/3/2003 | CU | 8/19/2002 | 10/3/2005 | LOPEZ | 8/26/2003 0:00 | 10/3/2003 | 0 | 0 | Yes | 5 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 52684H | 52684 | H | PSC Metals, Inc. | Nashville Facility | Nashville | TN | 37213 | 0000 | Production | Steel Products | Company | 3312 | 0 | 8/19/2003 | 8/26/2003 | 10/3/2003 | CU | 8/19/2002 | 10/3/2005 | LOPEZ | 8/26/2003 0:00 | 10/3/2003 | 0 | 0 | Yes | 5 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 52684I | 52684 | I | PSC Metals, Inc. | Philadelphia Office | Fort Washington | PA | 19034 | 0000 | Production | Steel Products | Company | 3312 | 0 | 8/19/2003 | 8/26/2003 | 10/3/2003 | CU | 8/19/2002 | 10/3/2005 | LOPEZ | 8/26/2003 0:00 | 10/3/2003 | 0 | 0 | Yes | 5 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 52684J | 52684 | J | PSC Metals, Inc. | Chattagooga Facility | Chattanooga | TN | 37408 | 0000 | Production | Steel Products | Company | 3312 | 0 | 8/19/2003 | 8/26/2003 | 10/3/2003 | CU | 8/19/2002 | 10/3/2005 | LOPEZ | 8/26/2003 0:00 | 10/3/2003 | 0 | 0 | Yes | 5 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 52684K | 52684 | K | PSC Metals, Inc. | Chicago Office | Arlington Hgts | IL | 60005 | 0000 | Production | Steel Products | Company | 3312 | 0 | 8/19/2003 | 8/26/2003 | 10/3/2003 | CU | 8/19/2002 | 10/3/2005 | LOPEZ | 8/26/2003 0:00 | 10/3/2003 | 0 | 0 | Yes | 5 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 90242 | 90242 | PSC Metals, Inc. | Staffmark | 4808 South Laurel Road | London | KY | 40744 | 0000 | Laurel County | 37.0692475 | -84.0583891 | 5 | Production | Ferrous and Nonferrous Metals (Scrap Buyer) | Workers | 0 | 423930 | 2017 | Wholesale Trade | Recyclable Material Merchant Wholesalers | 9/13/2015 | 9/14/2015 | 9/8/2016 | C-3 | C1 | 1/1/2014 | 9/8/2018 | OXFORD | 7/6/2016 0:00 | Kinglock | 9/8/2016 | 0 | 0 | Yes | Yes | United Kingdom | 0 | Justin Riley;Frankie Dison;Carter Baker | 360 | 0 | 6 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |