pennsylvania_warn_raw
Data source: Big Local News · About: big-local-datasette
1,272 rows sorted by Closing or Layoff
This data as json, copyable, CSV (advanced)
Link | rowid | Company | City | County | # Affected | Effective Date | Closing or Layoff ▼ |
---|---|---|---|---|---|---|---|
623 | 623 | Macy's | Bensalem | Bucks | 184 | 3/6/2017 | |
624 | 624 | Macy’s | Monaca | Beaver | 83 | 3/6/2017 | |
625 | 625 | Technicolor Home Entertainment Services | Olyphant | Lackawanna | 96 | 3/14/2017 | |
626 | 626 | **UPDATE** | Williamsport | Lycoming | 52 | 4/1/2017-4/14/2017 | |
627 | 627 | SBC Building Systems | Ambridge | Beaver | 98 | 4/16/2017 | |
628 | 628 | PaperWorks | Philadelphia | Philadelphia | 147 | 4/14/2017 | |
629 | 629 | Sodexo, Inc., Temple University (Johnson & Hardwick Halls) | Philadelphia | Philadelphia | 454 | 5/12/2017 | |
630 | 630 | CEVA Logistics | Lewisberry | York | 29 | 4/10/2017 | |
631 | 631 | Akers National Roll/ Union Electric Steel | Avonmore | Westmoreland | 157 | 3/31/2017 - 5/26/20174 | |
632 | 632 | Metso Minerals | Canonsburg | Washington | 62 | 3/31/2017 | |
633 | 633 | Metso Minerals | Danville | Montour | 33 | 3/31/2017 | |
655 | 655 | CEVA Logistics | Carlisle | Cumberland | 101 | 5/1/2017 | |
656 | 656 | First Data Resources, LLC/ Remitco LLC | Langhorne | Bucks | 93 | 5/5/17 - 8/31/17 | |
657 | 657 | Kelvion | York | York | 72 | 6/30/2017 | |
658 | 658 | Haband Company LLC | Jessup | Lackawana | 59 | 5/10/17 | |
659 | 659 | Giant Foods | Lancaster | Lancaster | 74 (N. Reservoir); 84 (Fruitville Pike) | 5/18/2017 | |
660 | 660 | INDSPEC Chemical Corporation | Petrolia | Butler | 220 | 5/27/17 - 9/30/17 | |
661 | 661 | Express Scripts (ESI) | Trevose | Bucks | 210 | 5/28/2017 | |
662 | 662 | DME Company | Youngwood | Westmoreland | 61 | 6/7/2017 | |
663 | 663 | Dollar Express #4376 | Edwardsville | Luzerne | 10 | 6/30/2017 | |
664 | 664 | Dollar Express | Allentown | Lehigh | 9 | 6/30/2017 | |
665 | 665 | Dollar Express | Harrisburg | Dauphin | 10 | 6/30/2017 | |
666 | 666 | Dollar Express | Harrisburg | Dauphin | 7 | 6/30/2017 | |
667 | 667 | Dollar Express | Middletown | Dauphin | 10 | 6/30/2017 | |
668 | 668 | Dollar Express | Pittsburgh | Allegheny | 9 | 6/30/2017 | |
669 | 669 | Dollar Express | Pittsburgh | Allegheny | 16 | 6/30/2017 | |
670 | 670 | Dollar Express | East Liberty | Allegheny | 13 | 6/30/2017 | |
671 | 671 | Dollar Express | McKeesport | Allegheny | 5 | 6/30/2017 | |
672 | 672 | Dollar Express | Swissvale | Allegheny | 10 | 6/30/2017 | |
673 | 673 | Dollar Express | Philadelphia | Philadelphia | 7 | 6/30/2017 | |
674 | 674 | Dollar Express | Philadelphia | Philadelphia | 14 | 6/30/2017 | |
675 | 675 | Dollar Express | Philadelphia | Philadelphia | 10 | 6/30/2017 | |
676 | 676 | Dollar Express | Philadelphia | Philadelphia | 12 | 6/30/2017 | |
677 | 677 | Dollar Express | Philadelphia | Philadelphia | 10 | 6/30/2017 | |
678 | 678 | Dollar Express | Yeadon | Delaware | 12 | 6/30/2017 | |
679 | 679 | Dollar Express | Upper Darby | Delaware | 16 | 6/30/2017 | |
680 | 680 | Dollar Express | Lansdowne | Delaware | 7 | 6/30/2017 | |
681 | 681 | Dollar Express | Levittown | Bucks | 7 | 6/30/2017 | |
682 | 682 | Dollar Express | Morrisville | Bucks | 7 | 6/30/2017 | |
683 | 683 | Unilife | York | York | 73 | Immediately, additional layoffs or plant closure by 6/4/17 | |
684 | 684 | Unilife | King of Prussia | Montgomery | 57 | Immediately, additional layoffs or plant closure by 6/4/17 | |
685 | 685 | Conduent Incorporated | Moosic | Lackawanna | 149 | 5/24/17 | |
686 | 686 | DME Company | Youngwood | Westmoreland | 61 | 6/7/17 | |
1184 | 1184 | Harley Davidson Motor Company | York | York | 118 | 6/23/17 - 7/21/17 | |
1245 | 1245 | Pepsi Beverages Company | Reading | Berks | 94 | 11/06/2016 | |
1246 | 1246 | DST Health Solutions | Harrisburg | Dauphin | 1 | 10/31/2016 | |
1247 | 1247 | IBEX Global | Indiana Mall Indiana | Indiana | 79 | 10/31/2016 | |
1248 | 1248 | Packaging Corporation of America(PCA) | Pittsburgh | Allegheny | 51 | 11/11/2016 | |
1249 | 1249 | HCR ManorCare | Devon | Chester | 124 | 11/17/2016 | |
1250 | 1250 | AstraZeneca | Fort Washington | Montgomery | 134 | 10/01/2016 | |
1251 | 1251 | Forever 21 Logistics LLC | Mount Joy | Lancaster | 61 | 11/30/2016 | |
1252 | 1252 | Sodexo, Inc. | Philadelphia | Philadelphia | 266 | 12/10/2016 | |
1253 | 1253 | TTM | Greensburg | Westmoreland/Allegheny | 205 | 11/30/2016 | |
1254 | 1254 | LifeCare Hospitals of Pittsburgh-Monroeville | Monroeville | Allegheny | 131 | 12/02/2016 | |
1255 | 1255 | **UPDATE** | Indiana Mall Indiana | Indiana | **0 | WARN RESCINDED (first notice was dated 08/31/2016) | |
1256 | 1256 | OCWEN | Fort Washington | Montgomery | 54 | 10/24/2016 -12/31/2016 | |
1257 | 1257 | Environmental Reclamation Services LLC | Erie | Erie | 30 | 12/27/2016 | |
1258 | 1258 | C3i | Pittston | Luzerne | 56 | 12/31/2016 | |
1259 | 1259 | Broder Bros. Co. d/b/a alphabroder | Philadelphia | Philadelphia | 35 | 1/13/2017 | |
1260 | 1260 | Bimbo Bakeries USA | Sunbury | Northumberland | 67 | 1/27/2017 | |
1261 | 1261 | Experience Works (Formerly Green Thumb) | Shamokin | Northumberland | 9 | 12/1/2016 | |
1262 | 1262 | Express Scripts | Harrisburg | Dauphin | 97 | 1/18/2017 | |
1263 | 1263 | CEVA Logistics | Lewisberry | York | 173 | 3/31/2017 | |
1264 | 1264 | Quad Graphics | York | York | 193 | 1/15/2017 | |
1265 | 1265 | Comcast | Lancaster | Lancaster | 78 | 5/17/2017 | |
1266 | 1266 | Packers Sanitation Services, Inc. | Emmaus | Lehigh | 10 | 1/06/2017 | |
1267 | 1267 | Packers Sanitation Services, Inc. | Hatfield | Montgomery | 151 | 1/06/2017 | |
1268 | 1268 | Personal Touch Home Health Care of PA, Inc. & Personal Touch Home Aides, Inc. | Personal Touch Home Health Care of | Allegheny, Butler, Lawrence, Beaver | 150 | 1/31/2017 | |
1269 | 1269 | Glade Run Lutheran Services | Zelienople | Butler | 97 | 12/16/2017 | |
1270 | 1270 | Union Electric Akers | Avonmore | Westmoreland | 148 | 3/10/2017 | |
1272 | 1272 | Cheetah Chassis Corporation | Columbia | Unspecified | 10/31/2016 | ||
705 | 705 | Ascena Retail Group, Inc. and its subsidiaries Catherines Stores Corporation | Bensalem | Bucks | 191 | 8/15/2017 | (undetermined) Permanent Layoff |
801 | 801 | *UPDATE to December 6, 2017 WARN* Arrow International Incorporated, | Reading | Berks | 6 | 6/29/2018 | 6/29/2018 |
934 | 934 | *Update to 5/10/19 WARN*Reading Eagle Company | Reading | Berks | 221 | June 6-10, 2019 | Bankruptcy Sale |
171 | 171 | Vincentian Regency | McCandless Township | Allegheny | 62 | 2/17/2013 | CLOSING |
330 | 330 | Citizens Bank | Philadelphia | Philadelphia | 87 | 8/28/2013 | CLOSING |
331 | 331 | Bank of America | Pittsburgh | Allegheny | 209 | 9/30/2013 | CLOSING |
332 | 332 | Arris Solutions, Inc. | State College | Centre | 54 | 8/31/2013 | CLOSING |
334 | 334 | Holiday Inn | Moon Township | Allegheny | 7/18/2013 | CLOSING | |
336 | 336 | Aramark Educational Services, LLC | Pittsburgh | Allegheny | 358 | 8/6/2013 | CLOSING |
338 | 338 | Direct Brands Inc. | Mechanicsburg | Cumberland | 59 | 7/8/2013 | CLOSING |
343 | 343 | Sodexo, Inc. | Easton | Northampton | 170 | 7/1/2013 | CLOSING |
344 | 344 | Honeywell Process Solutions | York | York | 110 | Will start between August 2013 and March 2014 | CLOSING |
345 | 345 | First Transit, Inc. | Philadelphia | Philadelphia | 340 | 5/24/2013 | CLOSING |
346 | 346 | Johnstown Specialty Casting Inc. | Johnstown | Cambria | 60 | 5/31/2013 | CLOSING |
348 | 348 | School Specialty, Inc. | Mount Joy | Lancaster | 148 | 5/13/2013 | CLOSING |
350 | 350 | Vincentian Regency | McCandless Township | Allegheny | 100 | 3/21/2013 | CLOSING |
353 | 353 | Vincentian Regency | McCandless Township | Allegheny | 100 | 3/21/2013 | CLOSING |
360 | 360 | PowerLink Settlement Services, L.P. | Coraopolis | Allegheny | 125 | 4/8/2013 | CLOSING |
367 | 367 | Neovia Logistics Services, LLC | Allentown | Lehigh | 6 | 12/31/2014 | CLOSING |
375 | 375 | Babcock Lumber | Pittsburgh | Allegheny | 50 | 12/31/2014 | CLOSING |
376 | 376 | Holiday Inn | Fort Washington | Montgomery | 59 | 2/27/2015 | CLOSING |
377 | 377 | Zara USA, Inc. | Philadelphia | Philadelphia | 50 | 3/1/2015 | CLOSING |
379 | 379 | Rubbermaid Commercial Products LLC | Pottsville | Schuylkill | 119 | 1/9/2015 | CLOSING |
383 | 383 | Rubbermaid Commercial Products LLC | Pottsville | Schuylkill | 119 | 12/8/2014 | CLOSING |
387 | 387 | Sears Holding Corporation | Tarentum | Allegheny | 82 | 1/18/2015 | CLOSING |
388 | 388 | Sears Holding Corporation | Frackville | Schuylkill | 71 | 1/18/2015 | CLOSING |
390 | 390 | Sears Holding Corporation | King of Prussia | Montgomery | 111 | 1/18/2015 | CLOSING |
392 | 392 | The Baptist Home of Philadelphia Deer Meadows Retirement Community | Philadelphia | Philadelphia | 372 | 11/1/2014 | CLOSING |
400 | 400 | Telerx Marketing, Inc. | Allentown | Lehigh | 156 | November 12 through December 31, 2014 | CLOSING |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [pennsylvania_warn_raw] ( [Company] TEXT, [City] TEXT, [County] TEXT, [# Affected] TEXT, [Effective Date] TEXT, [Closing or Layoff] TEXT );