indiana_warn_processed
Data source: Big Local News · About: big-local-datasette
752 rows sorted by Description of work
This data as json, copyable, CSV (advanced)
Suggested facets: Notice Type, TAA Certification, Notes
Link | rowid | Company | Company_processed | City | City_Processed | State_processed | Affected Workers | Notice Date | LO/CL Date | NAICS | Description of work ▼ | Notice Type | TAA Certification | Notes | Multiple_locations/statewide |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
520 | 520 | hhgregg | hhgregg | Indianapolis | Indianapolis | IN | 268 | 4/7/17 | 5/31/17 | 443141 | 443141 | Appliance stores | CL | ||
70 | 70 | Color-Box | Color-Box | Indianapolis | Indianapolis | IN | 74 | 1/9/09 | 3/10/09 | 327910 | Abrasive Product Manufacturing | CL | |||
251 | 251 | Kearney & Company, P.C. | Kearney & Company, P.C. | Indianapolis | Indianapolis | IN | 84 | 7/21/11 | 10/1/11 | 541211 | Accountants | CL | |||
205 | 205 | ADCO Products Inc. | ADCO Products Inc. | Evansville | Evansville | IN | 68 | 5/24/10 | 8/6/10 | 325520 | Adhesive Manufacturing | LO | |||
334 | 334 | Briljent, LLC | Briljent, LLC | Indianapolis | Indianapolis | IN | 100-130 | 3/27/13 | 5/31/13 | 611430 | Administrative Management and General Management Consulting Services | LO | |||
241 | 241 | Ditan Distribution | Ditan Distribution | Plainfield | Plainfield | IN | 76 | 4/19/11 | 8/5/11 | 541870 | Advertising Material Distribution Svcs | CL | |||
170 | 170 | International Aerospace Tubes | International Aerospace Tubes | Indianapolis | Indianapolis | IN | 106 | 8/27/09 | 10/28/09 | 33641 | Aerospace Product Manufacturing | CL | |||
173 | 173 | Lockheed Martin | Lockheed Martin | Indianapolis | Indianapolis | IN | 25 | 10/14/09 | 12/12/09 | 33641 | Aerospace product manufacturing | LO | |||
652 | 652 | Indianapolis Marriott East | Indianapolis Marriott East | Indianapolis | Indianapolis | IN | 98 | 3/22/20 | 3/23/20 | 711410 | Agents and Managers for Artists, Athletes, Entertainers, and Other Public Figures | LO | N/A | ||
2 | 2 | Republic Airways | Republic Airways | Indianapolis | Indianapolis | IN | 500 Nationwide | 7/14/08 | 9/10/08 | 481111 | Air Transportation | LO | |||
3 | 3 | American Airlines, Inc. | American Airlines, Inc. | Indianapolis | Indianapolis | IN | 4 | 7/14/08 | 9/5/08 | 481111 | Air Transportation | LO | |||
225 | 225 | Weil-McLain | Weil-McLain | Michigan City | Michigan City | IN | 87 | 11/8/10 | 1/9/11 | 333415 | Air-Conditioning & Warm Air Heating Equipment Manufacturing | LO | |||
439 | 439 | Parker Hannifin Corp. | Parker Hannifin Corp. | New Haven | New Haven | IN | 150 | 7/22/15 | 6/30/16 | 333415 | Air-Conditioning and Warm Air Heating Equipment and Commercial and Industrial Refrigeration Equipment Manufacturing | CL | |||
368 | 368 | Comlux | Comlux | Indianapolis | Indianapolis | IN | 45 | 1/9/14 | 1/17/14 | 336360 | Aircraft seats manufacturing | LO | |||
42 | 42 | Accent Marketing | Accent Marketing | New Albany | New Albany | IN | 164 | 11/20/08 | 1/20/09 | 561499 | All Other Business Support Services | LO | |||
323 | 323 | Suzuki Motor Company | Suzuki Motor Company | Indianapolis | Indianapolis | IN | 1 | 1/14/13 | 3/14/13 | 423990 | All Other Durable Goods Merchant Whls | CL | |||
25 | 25 | Kmart Corporation | Kmart Corporation | Clarksville | Clarksville | IN | 53 | 10/15/08 | 12/18/08 | 452990 | All Other General Merchandise Stores | CL | |||
640 | 640 | Genova Products, Inc. | Genova Products, Inc. | Fort Wayne | Fort Wayne | IN | 116 | 1/28/20 | 2/10/20 | 45231900 | All Other General Merchandise Stores | CL | N/A | ||
641 | 641 | Genova Products, Inc. | Genova Products, Inc. | Rensselaer | Rensselaer | IN | 88 | 1/28/20 | 2/10/20 | 45231900 | All Other General Merchandise Stores | CL | N/A | ||
252 | 252 | Ficosa North AmericaAmended NoticeExhibit AAmended Notice | Ficosa North AmericaAmended NoticeExhibit AAmended Notice | Berne | Berne | IN | 175 | 7/25/11 | 4/30/12 | 442299 | All Other Home Furnishings Stores | LO | |||
300 | 300 | National Government Services | National Government Services | Indianapolis | Indianapolis | IN | 112 | 5/22/12 | 07/20/2012 - 09/28/12 | 524298 | All Other Insurance Related Activities | CL | |||
479 | 479 | Magnetation | Magnetation | Reynolds | Reynolds | IN | 160 | 8/26/16 | 10/25/16 | 212299 | All Other Metal Ore Mining | CL | |||
632 | 632 | Columbian Home Products | Columbian Home Products | Terre Haute | Terre Haute | IN | 82 | 9/30/19 | 12/1/19 | 332999 | All Other Misc. Fabricated Metal Product Manufacturing | CL | N/A | ||
61 | 61 | deflect-o Corporation | deflect-o Corporation | Indianapolis and Fishers | Indianapolis and Fishers | IN | 219 | 12/11/08 | 2/13/09 | 339999 | All Other Miscellaneous | CL | Multiple locations | ||
338 | 338 | Meade Electric Company | Meade Electric Company | Whiting | Whiting | IN | 569 | 4/22/13 | 6/28/13 | 335999 | All Other Miscellaneous Electrical Equipment and Component Manufacturing | LO | |||
458 | 458 | Southwire Company | Southwire Company | Plainfield | Plainfield | IN | 50 | 1/29/16 | 3/31/16 | 332999 | All Other Miscellaneous Fabricated Metal Product Manufacturing | LO | |||
480 | 480 | Stanrail | Stanrail | Gary | Gary | IN | 103 | 8/26/16 | 10/27/16 | 332999 | All Other Miscellaneous Fabricated Metal Product Manufacturing | CL | |||
440 | 440 | Pall Filter Specialists, Inc.Revised (12/2/15) | Pall Filter Specialists, Inc. | Michigan City | Michigan City | IN | 28 | 9/10/15 | 11/15/15 | 333999 | All Other Miscellaneous General Purpose Machinery Manufacturing | CL | Revised (12/2/15) | ||
41 | 41 | Knauf Insulation | Knauf Insulation | Shelbyville | Shelbyville | IN | 65 | 11/19/08 | 1/19/09 | 339999 | All Other Miscellaneous Manufacturing | LO | |||
107 | 107 | Aleris Rolled Products | Aleris Rolled Products | Terre Haute | Terre Haute | IN | 50 | 3/24/09 | 5/23/09 | 339999 | All Other Miscellaneous Manufacturing | CL | |||
143 | 143 | Delta Faucet | Delta Faucet | Greensburg | Greensburg | IN | 265 | 5/27/09 | 7/29/2009 to 1/29/2010 | 339999 | All Other Miscellaneous Manufacturing | LO | |||
167 | 167 | MANN+HUMMEL USA Inc. | MANN+HUMMEL USA Inc. | South Bend | South Bend | IN | 57 | 7/30/09 | 9/30/09 | 339999 | All Other Miscellaneous Manufacturing | CL | |||
202 | 202 | Knauf Insulation GmbH | Knauf Insulation GmbH | Shelbyville | Shelbyville | IN | 100 | 4/7/10 | 6/6/10 | 339999 | All Other Miscellaneous Manufacturing | LO | |||
422 | 422 | Schott GemtronRevised | Schott GemtronRevised | Vincennes | Vincennes | IN | 40 | 2/23/15 | 3/24/15 | 339999 | All Other Miscellaneous Manufacturing | CL | |||
606 | 606 | KGP Telecommunications, LLC | KGP Telecommunications, LLC | Warsaw | Warsaw | IN | 300 | 2/15/19 | 4/17/19 | 339999 | All Other Miscellaneous Manufacturing | LO | N/A | ||
40 | 40 | Modine ManufacturingAmended Notice Amended NoticeAmended NoticeAmended Notice | Modine ManufacturingAmended Notice Amended NoticeAmended NoticeAmended Notice | Logansport | Logansport | IN | 147 | 11/17/08 | 1/23/09-2010 | 336399 | All Other Motor Vehicle Parts | CL | |||
34 | 34 | Fruedenburg-NOK | Fruedenburg-NOK | Scottsburg | Scottsburg | IN | 85 | 11/6/08 | 1/09/09-5/31/09 | 336399 | All Other Motor Vehicle Parts Mfg | CL | |||
35 | 35 | Fruedenburg-NOK | Fruedenburg-NOK | Scottsburg | Scottsburg | IN | 85 | 11/6/08 | 1/09/09-5/31/09 | 336399 | All Other Motor Vehicle Parts Mfg | CL | |||
47 | 47 | Harford Metal Products, Inc | Harford Metal Products, Inc | Hartford City | Hartford City | IN | 38 | 11/21/08 | 1/20/09 | 336399 | All Other Motor Vehicle Parts Mfg | CL | |||
81 | 81 | Dexter Axel | Dexter Axel | Manchester | Manchester | IN | 156 | 1/30/09 | 2/02/2009 to 12/30/2009 | 336399 | All Other Motor Vehicle Parts Mfg | CL | |||
88 | 88 | BorgWarner | BorgWarner | Muncie | Muncie | IN | 750 | 2/11/09 | 4/13/09 | 336399 | All Other Motor Vehicle Parts Mfg | LO | |||
90 | 90 | Navistar | Navistar | Indianapolis | Indianapolis | IN | 1336 | 2/19/09 | 12/31/09 | 336399 | All Other Motor Vehicle Parts Mfg | CL | |||
95 | 95 | Vibracoustic North America (Fruedenburg-NOK) | Vibracoustic North America (Fruedenburg-NOK) | Ligonier | Ligonier | IN | 54 | 2/27/09 | 3/13/09 | 336399 | All Other Motor Vehicle Parts Mfg | LO | |||
103 | 103 | Iceberg Enterprises, LLC | Iceberg Enterprises, LLC | Howe | Howe | IN | 48 | 3/13/09 | 5/12/09 | 326199 | All Other Motor Vehicle Parts Mfg | LO | |||
106 | 106 | Dexter Axle | Dexter Axle | Elkhart | Elkhart | IN | 119 | 3/20/09 | 6/26/09 | 336399 | All Other Motor Vehicle Parts Mfg | CL | |||
110 | 110 | Columbus Components Group, LLC | Columbus Components Group, LLC | Columbus | Columbus | IN | 338 | 3/25/09 | 4/9/09 | 336399 | All Other Motor Vehicle Parts Mfg | LO | |||
133 | 133 | Icon Metal Forming LLC | Icon Metal Forming LLC | Corydon | Corydon | IN | 140 | 5/5/09 | 5/6/09 | 336399 | All Other Motor Vehicle Parts Mfg | LO | |||
156 | 156 | Columbus Components Group, LLC | Columbus Components Group, LLC | Columbus | Columbus | IN | 215 | 6/10/09 | 7/31/09 | 336399 | All Other Motor Vehicle Parts Mfg | CL | |||
165 | 165 | Reiter Automotive | Reiter Automotive | Lowell | Lowell | IN | 130 | 7/23/09 | Prior to the end of 2009 (as stated in the WARN notice) | 33639 | All Other Motor Vehicle Parts Mfg | CL | |||
204 | 204 | Navistar (dba Indpls Casting Corp.) | Navistar (dba Indpls Casting Corp.) | Indianapolis | Indianapolis | IN | 415 | 4/26/10 | 10-Jul | 336399 | All Other Motor Vehicle Parts Mfg. | CL | |||
270 | 270 | Fortis PlasticsCorporate OfficesAmended CorporateAmended CorporateManufacturing FacilitiesAmended Manufacturing | Fortis PlasticsCorporate OfficesAmended CorporateAmended CorporateManufacturing FacilitiesAmended Manufacturing | South Bend | South Bend | IN | 88 | 10/28/11 | 12/23/11 | 326199 | All Other Plastics Prod Manufacturing | CL | |||
302 | 302 | JCIM, LLCAmendedAmended | JCIM, LLCAmendedAmended | Kendallville | Kendallville | IN | 179 | 6/15/12 | 8/31/12 | 326199 | All Other Plastics Prod Manufacturing | CL | |||
357 | 357 | Nyloncraft, Inc. | Nyloncraft, Inc. | Fort Wayne | Fort Wayne | IN | 96 | 10/1/13 | 9/1/14 | 326199 | All Other Plastics Prod Manufacturing | CL | |||
360 | 360 | Fabri-Form, Inc | Fabri-Form, Inc | Pekin | Pekin | IN | 37 | 10/7/13 | 1/1/14 | 326199 | All Other Plastics Prod Manufacturing | CL | |||
373 | 373 | Federal-Mogul | Federal-Mogul | Avilla | Avilla | IN | 95 | 2/11/14 | 10/1/14 | 326199 | All Other Plastics Prod Manufacturing | CL | |||
276 | 276 | Georgia Gulf Corporation (Royal Outdoor Products facility) | Georgia Gulf Corporation (Royal Outdoor Products facility) | Milford | Milford | IN | 60 | 12/14/11 | Mid February 2012 | 326199 | All Other Plastics Product Manufacturing | CL | |||
27 | 27 | Salga Inc. | Salga Inc. | Fremont | Fremont | IN | 83 | 10/21/08 | 12/20/08 | 326199 | All Other Plastics Product Manufacturing | CL | |||
71 | 71 | Holm Industries | Holm Industries | Scottsburg | Scottsburg | IN | 38 | 1/12/09 | 3/16/09 | 326199 | All Other Plastics Product Manufacturing | CL | |||
208 | 208 | Engineered Plastic Components Inc. -dba- Innatech LLC | Engineered Plastic Components Inc. -dba- Innatech LLC | Richmond | Richmond | IN | 75 | 6/29/10 | 8/17/10 | 326199 | All Other Plastics Product Manufacturing | CL | |||
312 | 312 | Ashland Hardware Systems | Ashland Hardware Systems | Lowell | Lowell | IN | 66 | 9/14/12 | 3/31/13 | 326199 | All Other Plastics Product Manufacturing | CL | |||
503 | 503 | PendaForm/Fabriform | PendaForm/Fabriform | Bluffton | Bluffton | IN | 75 | 1/24/17 | 3/25/17 | 326199 | All Other Plastics Product Manufacturing | LO | N/A | ||
504 | 504 | PendaForm/Fabriform | PendaForm/Fabriform | Bluffton | Bluffton | IN | 75 | 1/24/17 | 3/25/17 | 326199 | All Other Plastics Product Manufacturing | LO | |||
613 | 613 | NIBCO, Inc.Revised(5/24/19)(6/7/19)(6/21/19(6/28/19)(7/26/19)(8/9/19)(8/15/19)(8/29/19)(9/13/19)(10/10/19)(11/1/19) | NIBCO, Inc.Revised(5/24/19)(6/7/19)(6/21/19(6/28/19)(7/26/19)(8/9/19)(8/15/19)(8/29/19)(9/13/19)(10/10/19)(11/1/19) | Charlestown | Charlestown | IN | 97 | 5/16/19 | 7/19/19 | 326199 | All Other Plastics Product Manufacturing | CL | N/A | ||
651 | 651 | Mitchell Plastics | Mitchell Plastics | Charlestown | Charlestown | IN | 380 | 3/20/20 | 4/3/20 | 326199 | All Other Plastics Product Manufacturing | LO | N/A | ||
21 | 21 | Southwest Research Institute | Southwest Research Institute | Clinton | Clinton | IN | 92 | 9/23/08 | 1/09/08 â 6/09/10 | 541990 | All Other Professional & Technical Svc | LO | |||
44 | 44 | Bluegreen Corp. | Bluegreen Corp. | Indianapolis | Indianapolis | IN | 92 | 11/20/08 | 1/20/09 | 541990 | All Other Professional & Technical Svc | LO | |||
79 | 79 | Teleperformance USA | Teleperformance USA | Fishers | Fishers | IN | 395 | 1/29/09 | 4/3/09 | 541990 | All Other Professional & Technical Svc | LO | |||
615 | 615 | EDM Americas | EDM Americas | Indianapolis | Indianapolis | IN | 88 | 5/20/19 | 7/31/19 | 541990 | All Other Professional, Scientific, and Technical Services | LO | N/A | ||
630 | 630 | Bayer U.S., LLC | Bayer U.S., LLC | Mishawaka | Mishawaka | IN | 172 | 9/4/19 | 11/8/19 | 541990 | All Other Professional, Scientific, and Technical Services | CL | N/A | ||
87 | 87 | Firestone | Firestone | Noblesville | Noblesville | IN | 238 | 2/10/09 | 6/26/09 | 326299 | All Other Rubber Product Manufacturing | CL | |||
595 | 595 | LGSTX Distribution Services | LGSTX Distribution Services | Indianapolis | Indianapolis | IN | 256 | 9/5/18 | 9/30/18 | 488999 | All Other Support Activities for Transportation | CL | N/A | ||
614 | 614 | Penske Logistics | Penske Logistics | Fort Wayne | Fort Wayne | IN | 80 | 5/18/19 | 7/20/19 | 336999 | All Other Transportation Equipment Manufacturing | CL | N/A | ||
420 | 420 | Huhtamaki | Huhtamaki | Marion | Marion | IN | 38 | 2/13/15 | 4/20/15 | 322299 | All other Converted Paper Product Manufacturing | LO | |||
437 | 437 | Stanrail | Stanrail | Gary | Gary | IN | 88 | 7/14/15 | 10/31/15 | 332999 | All other Miscellaneous Fabricated Metal Product Manufacturing | CL | |||
430 | 430 | Pure Power Technologies Metal Castings | Pure Power Technologies Metal Castings | Indianapolis | Indianapolis | IN | 192 | 4/29/15 | 11/1/15 | 336399 | All other Motor Vehicle Parts Mfg. | CL | |||
435 | 435 | Silgan Plastics CorporationRevised (8/24/15) | Silgan Plastics Corporation | Ligonier | Ligonier | IN | 69 | 6/26/15 | 6/29/15 | 326199 | All other Plastics Products Manufacturing | LO | |||
327 | 327 | Contech Castings LLC | Contech Castings LLC | Pierceton | Pierceton | IN | 80 | 2/21/13 | 2/25/13 | 331521 | Aluminum Die-Casting Foundries | LO | |||
328 | 328 | Contech Castings LLC | Contech Castings LLC | Auburn | Auburn | IN | 128 | 2/21/13 | 2/25/13 | 331521 | Aluminum Die-Casting Foundries | LO | |||
141 | 141 | Altec Aluminum Technologies | Altec Aluminum Technologies | Jeffersonville | Jeffersonville | IN | 60 | 5/22/09 | 7/24/09 | 331316 | Aluminum Extruded Product Manufacturing | LO | |||
284 | 284 | Bon L Manufacturing Co.AmendedUpdatedUpdated | Bon L Manufacturing Co.AmendedUpdatedUpdated | Kentland | Kentland | IN | 146 | 2/1/12 | 4/3/12 | 331316 | Aluminum Extruded Product Manufacturing | CL | |||
411 | 411 | Harvey Industries LLC | Harvey Industries LLC | Wabash | Wabash | IN | 141 | 1/2/15 | 12/31/14 | 331523 | Aluminum die-casting foundries | LO | |||
130 | 130 | American Medical Response Ambulance Service, Inc | American Medical Response Ambulance Service, Inc | Fort Wayne | Fort Wayne | IN | 116 | 5/1/09 | 6/30/09 | 621910 | Ambulance Services | CL | |||
394 | 394 | Rural Metro Corporation | Rural Metro Corporation | Indianapolis | Indianapolis | IN | 84 | 8/18/14 | 8/18/14-12/31/14 | 621910 | Ambulance Services | LO | |||
395 | 395 | Rural Metro CorporationRevised | Rural Metro CorporationRevised | Indianapolis, Anderson, Logansport, Martinsville, and Richmond | Indianapolis, Anderson, Logansport, Martinsville, and Richmond | IN | 277 | 8/18/14 | 8/18/14-12/31/14 | 621910 | Ambulance Services | LO | Multiple locations | ||
542 | 542 | Prompt Ambulance Services | Prompt Ambulance Services | Lake Counties | Lake Counties | IN | 140 | 8/31/17 | 10/29/17 | 621910 | Ambulance Services | CL | N/A | ||
557 | 557 | Care Ambulance | Care Ambulance | Indianapolis | Indianapolis | IN | 82 | 12/8/17 | 2/2/18 | 621910 | Ambulance services, air or ground | CL | N/A | ||
254 | 254 | Caribbean Cove Hotel and Water Park | Caribbean Cove Hotel and Water Park | Indianapolis | Indianapolis | IN | 206 | 8/9/11 | 10/9/11 | 713110 | Amusement & Theme Parks | CL | |||
396 | 396 | Indiana University Cyclotron Operations | Indiana University Cyclotron Operations | Bloomington | Bloomington | IN | 120 | 8/22/14 | 11/25/14 | 334516 | Analytical Laboratory Instrument Manufacturing | CL | |||
516 | 516 | Gordmans, Inc. | Gordmans, Inc. | Clayton | Clayton | IN | 139 | 3/13/17 | 5/12/17 | 448150 | Apparel Accessory Stores | CL | N/A | ||
704 | 704 | Plycem USA LLA dba Allura | Plycem USA LLA dba Allura | Terre Haute | Terre Haute | IN | 83 | 4/3/20 | 6/2/20 | 342122 | Asphalt Shingle and Coating Materials Manufacturing | LO | N/A | ||
707 | 707 | Plycem USA LLA dba Allura | Plycem USA LLA dba Allura | Terre Haute | Terre Haute | IN | 83 | 4/3/20 | 6/2/20 | 342122 | Asphalt Shingle and Coating Materials Manufacturing | LO | |||
337 | 337 | AM General Military Assembly Plant | AM General Military Assembly Plant | Mishawaka | Mishawaka | IN | 387 | 4/19/13 | 12/30/12 | 336112 | Assembly plants, light trucks on chassis of own manufacture | LO | |||
507 | 507 | Harman International IndustriesRevised (5/17/17) | Harman International IndustriesRevised (5/17/17) | Elkhart | Elkhart | IN | 105 | 2/1/17 | 4/5/17 | 334310 | Audio and Video Equipment Manufacturing | LO | N/A | ||
548 | 548 | Harman International IndustriesRevised (11/22/17)Revised (4/20/18) | Harman International IndustriesRevised (11/22/17)Revised (4/20/18) | Elkhart | Elkhart | IN | 88 | 10/16/17 | 12/21/17 | 334310 | Audio and Video Equipment Manufacturing | CL | N/A | ||
549 | 549 | Technicolor | Technicolor | Indianapolis | Indianapolis | IN | 95 | 10/18/17 | 12/17/17 | 334310 | Audio and Video Equipment Manufacturing | LO | Certified 2/22/18 | ||
126 | 126 | Cinram Inc. | Cinram Inc. | Richmond | Richmond | IN | 330 | 4/17/09 | 6/16/09 | 334612 | Audio and Video Meda Reproduction | CL | |||
36 | 36 | Thomson Inc. | Thomson Inc. | Carmel | Carmel | IN | 71 | 11/6/08 | 1/04/08-6/30/09 | 334310 | Audio and Visual Equipment | LO | |||
499 | 499 | United Technologies Electronic Controls | United Technologies Electronic Controls | Huntington | Huntington | IN | 738 | 1/5/17 | 3/8/17 | 334512 | Automatic Environmental Control Manufacturing for Residential, Commercial, and Appliance Use | LO | TAW #91714 - 06/20/2016 | ||
500 | 500 | United Technologies Electronic Controls | United Technologies Electronic Controls | Huntington | Huntington | IN | 738 | 1/5/17 | 3/8/17 | 334512 | Automatic Environmental Control Manufacturing for Residential, Commercial, and Appliance Use | LO | |||
527 | 527 | Carrier | Carrier | Indianapolis | Indianapolis | IN | 632 | 5/19/17 | 12/30/17 | 334512 | Automatic Environmental Control Manufacturing for Residential, Commercial, and Appliance Use | LO | N/A |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [indiana_warn_processed] ( [Company] TEXT, [Company_processed] TEXT, [City] TEXT, [City_Processed] TEXT, [State_processed] TEXT, [Affected Workers] TEXT, [Notice Date] TEXT, [LO/CL Date] TEXT, [NAICS] INTEGER, [Description of work] TEXT, [Notice Type] TEXT, [TAA Certification] TEXT, [Notes] TEXT, [Multiple_locations/statewide] TEXT );