pennsylvania_warn_raw
Data source: Big Local News · About: big-local-datasette
1,272 rows sorted by County
This data as json, copyable, CSV (advanced)
Link | rowid | Company | City | County ▼ | # Affected | Effective Date | Closing or Layoff |
---|---|---|---|---|---|---|---|
169 | 169 | FCI USA, LLC | Mount Union | 175 | 1st Quarter, 2013 | MASS LAYOFF | |
410 | 410 | Herff Jones, Inc. | Gettysburg | Adams | 140 | 10/31/2014 | CLOSURE |
1038 | 1038 | Wyndham Gettysburg | Gettysburg | Adams | 78 | 3/24/20 | Layoff |
1083 | 1083 | *UPDATE*Wyndham Gettysburg | Gettysburg | Adams | 6 | 3/26/20 | temporary layoff- COVID-19 |
1103 | 1103 | Ski Liberty Operating Corporation | Carroll Valley | Adams | 57 | April 6, 2020 | Temp layoff, COVID-19 |
1169 | 1169 | Friendly’s Restaurants | Gettysburg Pa | Adams | 25 | March 17 through March 30, 2020 | Temp Closure due to COVID |
2 | 2 | Federal Reserve Bank of Cleveland | Pittsburgh | Allegheny | 118 | 12/31/2011 | MASS LAYOFF |
22 | 22 | ECI Telecom, Inc. | Pittsburgh | Allegheny | 107 | 1/9/2012 | MASS LAYOFF |
23 | 23 | Federal Reserve Bank of Cleveland | Pittsburgh | Allegheny | 89 | 11/30/2011 | PLANT CLOSING (Update) |
30 | 30 | Healthways, Inc. | Pittsburgh | Allegheny | 57 | 1/16/2012 | PLANT CLOSING |
33 | 33 | Federal Reserve Bank of Cleveland | Pittsburgh | Allegheny | 121 | 11/30/2011 | PLANT CLOSING (Update) |
34 | 34 | Health Dialog Services Corporation | Pittsburgh | Allegheny | 76 | 12/31/2011 | PLANT CLOSING |
74 | 74 | Abraxas Center for Adolescent Females | Pittsburgh | Allegheny | 111 | 10/22/2011 | PLANT CLOSING |
84 | 84 | Federal Reserve Bank of Cleveland | Pittsburgh | Allegheny | 163 | 7/1/2011 | MASS LAYOFF (Update) |
90 | 90 | Federal Reserve Bank of Cleveland | Pittsburgh | Allegheny | 215 | 5/31/2011 | MASS LAYOFF (Update) |
93 | 93 | Share Group | Pittsburgh | Allegheny | N/A | 8/6/2011 | PLANT CLOSING |
120 | 120 | Federal Reserve Bank of Cleveland | Pittsburgh | Allegheny | 226 | 5/31/2011 | MASS LAYOFF & PLANT CLOSING |
127 | 127 | Eckert Seamans Cherin & Mellot, LLC | Pittsburgh | Allegheny | 170 | 6/8/2011 | MASS LAYOFF |
142 | 142 | Sodexo, Inc. | Pittsburgh | Allegheny | 113 | 5/16/2011 | PLANT CLOSING |
167 | 167 | U.S. Steel Tubular Products | McKeesport | Allegheny | 92 | 12/2/2012 | MASS LAYOFF |
170 | 170 | National Real Estate Information Services | Pittsburgh | Allegheny | 215 | 2/15/2013 | PLANT CLOSING |
171 | 171 | Vincentian Regency | McCandless Township | Allegheny | 62 | 2/17/2013 | CLOSING |
175 | 175 | Sears Holdings Corporation | Pittsburgh | Allegheny | 13 | 1/7/2013 | PLANT CLOSING |
185 | 185 | Sears Holdings Corporation | Pittsburgh | Allegheny | 124 | 1/7/2013 | PLANT CLOSING |
186 | 186 | Sears Holdings Corporation | Pittsburgh | Allegheny | 13 | 1/7/2013 | PLANT CLOSING |
194 | 194 | Kmart Corporation | Pittsburgh | Allegheny | 54 | 1/6/2013 | PLANT CLOSING |
199 | 199 | Computershare | Pittsburgh | Allegheny | 156 | 9/30/2012 | PLANT CLOSING |
204 | 204 | Federal Reserve Bank of Cleveland | Pittsburgh | Allegheny | 20 | 10/15/2012 | MASS LAYOFF (UPDATE) |
218 | 218 | Port Authority of Allegheny County | Bridgeville | Allegheny | 518 | 9/1/2012 | Plant Closing/Mass Layoffs |
238 | 238 | Hostess Brands, Inc. | Monroeville | Allegheny | 2 | 7/3/2012 | Plant Closing |
243 | 243 | Hostess Brands, Inc. | Pittsburgh | Allegheny | 3 | 7/3/2012 | PLANT CLOSING |
247 | 247 | Federal Reserve Bank of Cleveland | Pittsburgh | Allegheny | 6 | 5/1/2012 | MASS LAYOFF (Update) |
248 | 248 | JC Penney | Cheswick | Allegheny | 321 | 6/29/2012 | PLANT CLOSING |
251 | 251 | Grubb & Ellis Company | Pittsburgh | Allegheny | 65 | 4/9/2012 | MASS LAYOFF/PLANT CLOSING (Update) |
263 | 263 | Grubb & Ellis Company | Pittsburgh | Allegheny | 65 | 3/25/2012 | Mass Layoff, possible Plant Closure |
267 | 267 | Golden Living Northeast Central Billing Office | Pittsburgh | Allegheny | 33 | 6/1/2012 | PLANT CLOSURE |
271 | 271 | Meadows RaceTrack & Casino | West Mifflin | Allegheny | N/A | 4/1/2012 | PLANT CLOSING |
272 | 272 | Met Life | Pittsburgh | Allegheny | 64 | 3/30/2012 | PLANT CLOSING |
281 | 281 | Federal Reserve Bank of Cleveland | Pittsburgh | Allegheny | 2 | 4/16/2012 | Mass Layoff (Update) |
297 | 297 | Bank of America | Pittsburgh | Allegheny | 8 | 12/22/2013 | PERMANENT LAYOFF |
303 | 303 | Mitsubishi Nuclear Energy System, Inc. | Warrendale Drive | Allegheny | 1 | 12/31/2013 | OFFICE CLOSING |
312 | 312 | General Nutrition Companies, Inc. | Leetsdale | Allegheny | 60 | 10/11/2013 | PLANT CLOSURE |
320 | 320 | American Bridge | Coraopolis | Allegheny | 77 | 12/9/2013 | PERMANENT LAYOFFS |
331 | 331 | Bank of America | Pittsburgh | Allegheny | 209 | 9/30/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 |
350 | 350 | Vincentian Regency | McCandless Township | Allegheny | 100 | 3/21/2013 | CLOSING |
351 | 351 | Consumer - Home Solutions | Pittsburgh | Allegheny | 108 | 3/15/2013 | LAYOFF |
352 | 352 | GBS Global Customer Service; Customer Care Billing | Pittsburgh | Allegheny | 77 | 3/15/2013 | PERMANENT LAYOFF |
353 | 353 | Vincentian Regency | McCandless Township | Allegheny | 100 | 3/21/2013 | CLOSING |
358 | 358 | Secured Lending Services | Pittsburgh | Allegheny | 82 | 4/2/2013 | LAYOFF |
359 | 359 | Exco Resources LLC | Warrendale | Allegheny | 70 | 4/5/2013 | LAYOFF |
360 | 360 | PowerLink Settlement Services, L.P. | Coraopolis | Allegheny | 125 | 4/8/2013 | CLOSING |
369 | 369 | Crothall Healthcare | Wayne | Allegheny | 3 | 1/31/2015 | PERMANENT LAYOFF |
375 | 375 | Babcock Lumber | Pittsburgh | Allegheny | 50 | 12/31/2014 | CLOSING |
387 | 387 | Sears Holding Corporation | Tarentum | Allegheny | 82 | 1/18/2015 | CLOSING |
394 | 394 | UPDATE Bank of America | Pittsburgh | Allegheny | 2 | 10/26/2014 | LAYOFF |
402 | 402 | Transtar Industries, Inc. | McKees Rocks | Allegheny | 136 | 12/31/2014 | PERMANENT LAYOFF |
406 | 406 | Kindred Hospital - North Shore, LLC | Pittsburgh | Allegheny | 23 | 8/31/2014 | PERMANENT CLOSURE |
409 | 409 | *UPDATE* Louis F. Leeper Company | Pittsburgh | Allegheny | 165 | Between August 15 and August 22, 2014 | PERMANENT LAYOFF |
411 | 411 | QBE North America | Coraopolis | Allegheny | 59 | Between November 1 and 15, 2014 | PERMANENT LAYOFF |
422 | 422 | *UPDATE* Pittsburgh Post-Gazette | Pittsburgh | Allegheny | 136 | 8/18/2014 | LAYOFF |
423 | 423 | Kindred Hospital – Pittsburgh-North Shore, LLC | Pittsburgh | Allegheny | 152 | 7/31/2014 | PERMANENT CLOSURE |
428 | 428 | U.S. Steel Tubular Products, Inc. | McKeesport | Allegheny | 183 | 8/3/2014 | LAYOFF |
436 | 436 | *UPDATE* Bank of America | Pittsburgh | Allegheny | 46 | 7/7/2014 | PERMANENT CLOSURE |
437 | 437 | First Student | Monroeville | Allegheny | 79 | 6/30/2014 | LAYOFF |
438 | 438 | Louis F. Leeper Company | Pittsburgh | Allegheny | 165 | 6/26/2014 through 7/10/2014 | LAYOFF |
440 | 440 | Acosta Sales & Marketing | Pittsburgh | Allegheny | 54 | 7/21/2014 | PERMANENT LAYOFF |
441 | 441 | Pittsburgh Post-Gazette | Pittsburgh | Allegheny | 136 | 7/28/2014 | PERMANENT LAYOFF |
452 | 452 | QBE North America | Coraopolis | Allegheny | 59 | 5/9/2014 | PERMANENT LAYOFF |
466 | 466 | Verizon Wireless BGCO | Warrendale | Allegheny | 433 Total, Verizon 229, Telesales 199, HR 5 | 5/8/2014 | CLOSURE |
471 | 471 | *UPDATE* GE Power & Water | West Mifflin | Allegheny | 65 | 2/28/2014 | PLANT CLOSURE |
474 | 474 | Macy's | Pittsburgh | Allegheny | 69 | Between 3/12/2014 and 3/25/2014 | PERMANENT LAYOFF |
488 | 488 | The J. M. Smucker Company | Pittsburgh | Allegheny | 123 | 2/9/2016 | LAYOFF |
492 | 492 | Shenang | Pittsburgh | Allegheny | 168 | 2/15/2016 | CLOSING |
500 | 500 | US Airways (American Airlines) | Moon Township | Allegheny | 5 | 1/16/2016 | CLOSING |
501 | 501 | Trib Total Media, Inc. | McKeesport | Allegheny | 47 | 12/31/2015 | CLOSING |
505 | 505 | *UPDATE* US Airways (American Airlines) | Moon Township | Allegheny | 23 | 1/16/2016 | CLOSING |
513 | 513 | BCSI, LLC | McKeesport | Allegheny | 100 | 11/6/2015 | CLOSING |
537 | 537 | Macy’s | Pittsburgh | Allegheny | 170 | 7/31/2015 | CLOSING |
540 | 540 | Guardian Industries Corp. | Jefferson Hills | Allegheny | 114 | 8/4/2015 | CLOSING |
546 | 546 | US Airways | Corapolis | Allegheny | 600 | 8/22/2015 | CLOSING |
556 | 556 | American Eagle Outfitters | Warrendale | Allegheny | 212 | 6/12/2015 | CLOSING |
558 | 558 | GlaxoSmithKline Consumer Healthcare | Coraopolis | Allegheny | 274 | TBD | CLOSING |
573 | 573 | Bank of America | Pittsburgh | Allegheny | 16 | 5/9/2015 | MASS LAYOFF |
586 | 586 | WesBanco (ESB Bank) | Wexford | Allegheny | 54 (Total, incl. Lawrence Co.) | 4/30/2015 | CLOSING |
592 | 592 | Chevron's Appalachian Michigan Unit | Moon Twp | Allegheny | 162 | 4/2/2015 | LAYOFF |
598 | 598 | Macy's | West Mifflin | Allegheny | 101 | 3/14/2016 | CLOSING |
602 | 602 | IBEX Global | Pittsburgh | Allegheny | 153 | 3/15/2016 | LAYOFF |
614 | 614 | Helomics Inc. | Pittsburgh | Allegheny | 125 | 3/2/2016 | LAYOFF |
621 | 621 | *UPDATE* Helomics Inc. | Pittsburgh | Allegheny | 125 | 4/15/2016 | LAYOFF |
634 | 634 | Port Authority of Allegheny County | Allegheny | 212 | 3/27/2011 | MASS LAYOFF | |
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 | |
688 | 688 | Education Management II, LLC (EDMC) | Pittsburgh | Allegheny | 40-75 | between 6/30/2017 and 8/31/2017 | Permanent Closure |
689 | 689 | Bank of America | Pittsburgh | Allegheny | 112 | 7/2/2017 | Permanent Layoff |
700 | 700 | Kellogg Company | Pittsburgh | Allegheny | 211 | 8/4/2017 - 8/17/2017 | 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 );