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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19824 | 19824 | CATERPILLAR, INC. | P.O. BOX 2790 | DAVENPORT | IA | 52809 | 0000 | Production | PARTS FOR ENGINES AND TRACTORS | Unknown | 3531 | 0 | 6/22/1987 | 8/12/1987 | D | GOLDSTEIN | 6/22/1987 0:00 | 8/12/1987 | 0 | 0 | 0 | Yes | 51 | 100 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 19825 | 19825 | CATERPILLAR, INC. | HIGHWAY 67 AND FENNO ROAD | BETTENDORF | IA | 52722 | 0000 | Production | PARTS FOR ENGINES AND TRACTORS | Unknown | 3519 | 0 | 6/22/1987 | 8/11/1987 | D | GOLDSTEIN | 6/22/1987 0:00 | 8/11/1987 | 0 | 0 | 0 | Yes | 50 | 80 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 20825 | 20825 | CATERPILLAR, INC. | HIGHWAY 67 AND FENRO ROAD | BETTENDORF | IA | 52722 | 0000 | Production | COMPONENTS FOR BULLDOZERS TRACTORS | Unknown | 3519 | 0 | 7/25/1988 | 9/19/1988 | D | GOLDSTEIN | 7/25/1988 0:00 | 9/19/1988 | 0 | 0 | 0 | Yes | 56 | 200 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 50949 | 50949 | Caterpillar, Inc. | 2080 Enterprise Dr. NE | Leland | NC | 28451 | 0000 | Production | transmissions for motorgraders | Company | 3714 | 0 | 2/20/2003 | 2/25/2003 | 3/10/2003 | T | GANNON | 2/25/2003 0:00 | 3/10/2003 | 0 | 0 | Yes | 13 | 39 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 51263 | 51263 | Caterpillar, Inc. | Hydraulics & Hydraulic | PO Box 504 | Joliet | IL | 60434 | 0000 | Production | cylinders, valves, pumps and motors | Union | 3593 | 0 | 3/6/2003 | 3/21/2003 | 4/21/2003 | D | ROBERTS | 3/21/2003 0:00 | 4/21/2003 | 0 | 0 | Yes | 31 | 72 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 51459 | 51459 | Caterpillar, Inc. | Caterpillar Global Paving | 9401 85th Ave., North | Brooklyn Park | MN | 55445 | 0000 | Production | double drum rollers | Workers | 3531 | 0 | 4/7/2003 | 4/9/2003 | 5/30/2003 | C1 | 4/7/2002 | 5/30/2005 | CLARK | 4/9/2003 0:00 | 5/30/2003 | 0 | 0 | Yes | 51 | 58 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 51842 | 51842 | Caterpillar, Inc. | Leland Transmission | 2080 Enterprise Dr. | Leland | NC | 28451 | 0000 | Production | transmissions and front wheel loader | Company | 3714 | 0 | 5/12/2003 | 5/21/2003 | 6/6/2003 | C2 | 5/12/2002 | 6/6/2005 | JUNGJOHANN | 5/21/2003 0:00 | 6/6/2003 | 0 | 0 | Yes | 16 | 41 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 65311 | 65311 | Caterpillar, Inc. | 100 NE Adams Street | Peoria | IL | 61602 | 0000 | Peoria County | 40.6917696 | -89.5884418 | 17 | Production | Truck Engines | Union | 0 | 0 | 2/4/2009 | 2/19/2009 | 4/13/2009 | T | T | JOHNSON | 2/19/2009 0:00 | Poole | 4/13/2009 | 1 | 0 | 0 | Yes | 0 | Rick Doty | 53 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 71185 | 71185 | Caterpillar, Inc. | Leased Wkrs From Kroeschell Operations, Inc. | 420 John B. Brooks Road | Pendergrass | GA | 30550 | 0000 | Production | Fuel Systems Components | Workers | 3714 | 336312 | 2007 | Manufacturing | Motor Vehicle Gasoline Engine and Engine Parts Manufacturing | 6/12/2009 | 6/12/2009 | 2/1/2010 | CSP-1 | C2 | 6/12/2008 | 2/1/2012 | FIELDS | 1/28/2010 0:00 | Kushner | 2/1/2010 | 1 | 1 | 0 | Yes | Mexico | 0 | Phillip Alexander;Victor Coca;Randall Studivant, Sr. | 234 | 0 | 105 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 71725 | 71725 | Caterpillar, Inc. | Large Power Systems Division | 14009 Old Galena Road | Mossville | IL | 61552 | 0000 | Production | On-Highway and Off-Highway Diesel Engines | Union | 3519 | 333618 | 2017 | Manufacturing | Other Engine Equipment Manufacturing | 7/6/2009 | 7/17/2009 | 11/2/2009 | CSC | CU | 7/6/2008 | 11/2/2011 | JOHNSON | 7/17/2009 0:00 | Jaffe | 11/2/2009 | 10/4/2011 | 1 | 1 | 0 | No | Yes | 0 | Rick Doty | 108 | 0 | 1388 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 72978 | 72978 | Caterpillar, Inc. | Large Power Systems Division, Cast Metals Organization | 8826 West Rt. 24 | Mapleton | IL | 61547 | 0000 | Production | Engine Block and Head Casts, and Cylinder Liners | Union | 3321 | 331511 | 2017 | Manufacturing | Iron Foundries | 11/3/2009 | 12/1/2009 | 12/15/2009 | CSP-1 | C2 | 11/3/2008 | 12/15/2011 | JOHNSON | 12/1/2009 0:00 | Jaffe | 12/15/2009 | 1 | 1 | 0 | Yes | Mexico | 0 | Rick Doty | 14 | 0 | 338 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 73549 | 73549 | Caterpillar, Inc. | DBA Dyersburg Transmission Facility | 2000 Hoff Road | Dyersburg | TN | 38024 | 0000 | Dyer County | 36.0653862 | -89.3302179 | 8 | Production | Transmissions | Company | 3714 | 336399 | 2007 | Manufacturing | Other Motor Vehicle Parts Manufacturing | 2/22/2010 | 2/23/2010 | 5/21/2010 | CSP-1 | C2 | 2/22/2009 | 5/21/2012 | KELLY | 4/5/2010 0:00 | Jaffe | 5/21/2010 | 1 | 1 | 0 | Yes | United Kingdom | 0 | Rhonda Lee | 87 | 0 | 29 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 82677 | 82677 | Caterpillar, Inc. | IMOD Division | 27th Street & Pershing Road | Decatur | IL | 62526 | 0000 | Macon County | 39.8766148 | -88.9123213 | 13 | Production | Off-Highway Mining Trucks, Scrapers and Graders | State/AJC | 0 | 333120 | 2017 | Manufacturing | Construction Machinery Manufacturing | 4/19/2013 | 4/22/2013 | 5/17/2013 | D-4 | D | JOHNSON | 4/22/2013 0:00 | Jaffe | 5/17/2013 | 0 | 0 | Yes | Yes | 0 | Robert Konzelmann | 25 | 0 | 760 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 83143 | 83143 | Caterpillar, Inc. | Integrated Manufacturing Operations Division, Gregg Staffing | 2045 West Pike Street | Houston | PA | 15342 | 0000 | Washington County | 40.2323931 | -80.2141575 | 14 | Production | Mining Systems and Aftermarket Parts | Workers | 0 | 333131 | 2017 | Manufacturing | Mining Machinery and Equipment Manufacturing | 9/27/2013 | 10/17/2013 | 1/15/2014 | CSP-1 | C2 | 9/27/2012 | 1/15/2016 | PLANTE | 10/17/2013 0:00 | Kinglock | 1/15/2014 | 0 | 0 | Yes | Yes | China | 0 | David Steede;Rick Evans;Paul Campbell | 90 | 0 | 37 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 83241 | 83241 | Caterpillar, Inc. | Integrated Manufacturing Operations Division (IMOD), Guardsmark, Aramark | 1100 Milwaukee Avenue | South Milwaukee | WI | 53172 | 0000 | Milwaukee County | 42.9126718 | -87.8617274 | 4 | Production | Electric and Hydraulic Mining Shovels | Workers | 0 | 333130 | 2017 | Manufacturing | 11/20/2013 | 11/25/2013 | 4/21/2014 | D-4 | D | PLANTE | 11/25/2013 0:00 | Jaffe | 4/21/2014 | 0 | 0 | Yes | Yes | 0 | James Cech;Juan Navas;Jose Perez | 147 | 0 | 370 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 83241A | 83241 | A | Caterpillar, Inc. | Integrated Manufacturing Operations Division (IMOD) | 3073 South Chase Avenue | Milwaukee | WI | 53207 | 0000 | Milwaukee County | 42.9889698 | -87.9120278 | 4 | Production | Electric and Hydraulic Mining Shovels | Workers | 0 | 333130 | 2017 | Manufacturing | 11/20/2013 | 11/25/2013 | 4/21/2014 | D-4 | D | PLANTE | 11/25/2013 0:00 | Jaffe | 4/21/2014 | 0 | 0 | Yes | Yes | 0 | James Cech;Juan Navas;Jose Perez | 0 | 65 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 85077 | 85077 | Caterpillar, Inc. | Integrated Manufacturing Operations Division (IMOD), Volt Workforce Sol. | 4041 Wurno Road | Pulaski | VA | 24301 | 0000 | Pulaski County | 37.06125 | -80.727965 | 9 | Production | Underground Mining Equipment | Union | 0 | 333131 | 2017 | Manufacturing | Mining Machinery and Equipment Manufacturing | 2/18/2014 | 2/19/2014 | 3/13/2016 | D-4 | D | PLANTE | 2/19/2014 0:00 | Jaffe | 5/2/2014 | 0 | 0 | Yes | Yes | 0 | Ronald Dunford | 0 | 256 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 85329 | 85329 | Caterpillar, Inc. | Marine Engine Assembly Operations | 107 Southchase Boulevard | Fountain Inn | SC | 29644 | 0000 | Greenville County | 34.6898716 | -82.2330171 | 3 | Production | Marine Engines | Company | 0 | 333618 | 2017 | Manufacturing | Other Engine Equipment Manufacturing | 5/22/2014 | 5/23/2014 | 6/9/2014 | T1 | T | PLANTE | 5/23/2014 0:00 | Jaffe | 6/9/2014 | 0 | 0 | Yes | Yes | 0 | Belinda Maree | 17 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 85329A | 85329 | A | Caterpillar, Inc. | Logistics Division | 111 Southchase Boulevard | Fountain Inn | SC | 29644 | 0000 | Greenville County | 34.6886604 | -82.2354095 | 3 | Services | Freight Transportation and Logistics | Company | 0 | 484110 | 2017 | Transportation and Warehousing | General Freight Trucking, Local | 5/22/2014 | 5/23/2014 | 6/9/2014 | T1 | T | PLANTE | 5/23/2014 0:00 | Jaffe | 6/9/2014 | 0 | 0 | Yes | Yes | 0 | Belinda Maree | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 85375 | 85375 | Caterpillar, Inc. | Global Mining Sales and Support Division, Pearisburg Rebuild and Repair Ops | 222 Industrial Park Drive | Pearisburg | VA | 24134 | 0000 | Giles County | 37.3182201 | -80.7283372 | 9 | Services | Underground Mining Machinery Repair and Rebuilding Services | Workers | 0 | 811310 | 2017 | Other Services (except Public Administration) | Commercial and Industrial Machinery and Equipment (except Automotive and Electronic) Repair and Maintenance | 6/12/2014 | 6/13/2014 | 3/10/2016 | D-5 | D | PLANTE | 6/13/2014 0:00 | Jaffe | 8/21/2014 | 3/10/2016 | 0 | 0 | Yes | Yes | 0 | Logan Snider;James Fisher;William Price | 0 | 57 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 90251 | 90251 | Caterpillar, Inc. | Large Power Systems Division, A to Z Sheet Metal, Inc., etc. | 3701 State Road 26 East | Lafayette | IN | 47905 | 0000 | Tippecanoe County | 40.4435335 | -86.9766117 | 4 | Production | Large Engines | Workers | 0 | 333120 | 2017 | Manufacturing | Construction Machinery Manufacturing | 8/26/2015 | 9/15/2015 | 11/6/2015 | CSP-1 | C2 | 1/1/2014 | 11/6/2017 | WITHERSPOON | 10/8/2015 0:00 | Webster | 11/6/2015 | 3/9/2017 | 0 | 0 | Yes | Yes | China | 0 | Chris Richardson;Zach Phillippo;Eric Harris | 0 | 411 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 91885 | 91885 | Caterpillar, Inc. | CR Coatings, The Tool & Gage House, Vonachen Services, Inc., etc. | 2200 Channahon Road | Joliet | IL | 60436 | 0000 | Will County | 41.4952163 | -88.1299011 | 11 | Production | Hydraulic Components | Company | 0 | 333120 | 2017 | Manufacturing | Construction Machinery Manufacturing | 6/6/2016 | 6/7/2016 | 8/5/2016 | CSP-1 | C2 | 6/6/2015 | 8/5/2018 | WITHERSPOON | 6/7/2016 0:00 | Chen | 8/5/2016 | 0 | 0 | Yes | Yes | Mexico | 0 | Tamara Holman | 59 | 0 | 316 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 91978 | 91978 | Caterpillar, Inc. | 100 Caterpillar Way | Thomasville | GA | 31792 | 0000 | Thomas County | 30.8373694 | -84.004612 | 8 | Production | Diesel Engine Fuel Systems & Aftertreatment Components | Workers | 0 | 333618 | 2017 | Manufacturing | Other Engine Equipment Manufacturing | 7/1/2016 | 7/5/2016 | 9/27/2016 | CSP-1 | C2 | 7/1/2015 | 9/27/2018 | WITHERSPOON | 7/5/2016 0:00 | Chen | 9/27/2016 | 0 | 0 | Yes | Yes | Mexico | 0 | Bryan Mclendon;Yolanda Johnson;Kelvin Thomas | 84 | 0 | 225 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 92098 | 92098 | Caterpillar, Inc. | Global Information Services Division, Accenture, VCM Consulting, etc. | 812 West Washington Street | East Peoria | IL | 61630 | 0000 | Tazewell County | 40.6761328 | -89.5880913 | 18 | Services | Information Technology Services | Workers | 0 | 541512 | 2017 | Professional, Scientific, and Technical Services | Computer Systems Design Services | 8/2/2016 | 8/10/2016 | 3/22/2017 | D-5 | D | WITHERSPOON | 8/10/2016 0:00 | Chen | 3/22/2017 | 0 | 0 | Yes | Yes | 0 | Bill Keleh;Mike West;Richard Heller | 224 | 0 | 9 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 92850 | 92850 | Caterpillar, Inc. | Industry Solutions and Components | 2301 West Pike Street | Houston | PA | 15342 | 0000 | Washington County | 40.2280109 | -80.2155741 | 14 | Production | Mining Equipment | Company | 0 | 333131 | 2017 | Manufacturing | Mining Machinery and Equipment Manufacturing | 4/27/2017 | 4/28/2017 | 6/16/2017 | T-3 | T | WITHERSPOON | 4/28/2017 0:00 | Chen | 6/16/2017 | 0 | 0 | Yes | Yes | 0 | Alison Allen | 49 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |