pennsylvania_warn_raw
Data source: Big Local News · About: big-local-datasette
1,272 rows sorted by rowid descending
This data as json, copyable, CSV (advanced)
Link | rowid ▲ | Company | City | County | # Affected | Effective Date | Closing or Layoff |
---|---|---|---|---|---|---|---|
1272 | 1272 | Cheetah Chassis Corporation | Columbia | Unspecified | 10/31/2016 | ||
1271 | 1271 | BB&T | Allentown | Lehigh/Berks | 241 | 7/15/2016 | LAYOFF |
1270 | 1270 | Union Electric Akers | Avonmore | Westmoreland | 148 | 3/10/2017 | |
1269 | 1269 | Glade Run Lutheran Services | Zelienople | Butler | 97 | 12/16/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 | |
1267 | 1267 | Packers Sanitation Services, Inc. | Hatfield | Montgomery | 151 | 1/06/2017 | |
1266 | 1266 | Packers Sanitation Services, Inc. | Emmaus | Lehigh | 10 | 1/06/2017 | |
1265 | 1265 | Comcast | Lancaster | Lancaster | 78 | 5/17/2017 | |
1264 | 1264 | Quad Graphics | York | York | 193 | 1/15/2017 | |
1263 | 1263 | CEVA Logistics | Lewisberry | York | 173 | 3/31/2017 | |
1262 | 1262 | Express Scripts | Harrisburg | Dauphin | 97 | 1/18/2017 | |
1261 | 1261 | Experience Works (Formerly Green Thumb) | Shamokin | Northumberland | 9 | 12/1/2016 | |
1260 | 1260 | Bimbo Bakeries USA | Sunbury | Northumberland | 67 | 1/27/2017 | |
1259 | 1259 | Broder Bros. Co. d/b/a alphabroder | Philadelphia | Philadelphia | 35 | 1/13/2017 | |
1258 | 1258 | C3i | Pittston | Luzerne | 56 | 12/31/2016 | |
1257 | 1257 | Environmental Reclamation Services LLC | Erie | Erie | 30 | 12/27/2016 | |
1256 | 1256 | OCWEN | Fort Washington | Montgomery | 54 | 10/24/2016 -12/31/2016 | |
1255 | 1255 | **UPDATE** | Indiana Mall Indiana | Indiana | **0 | WARN RESCINDED (first notice was dated 08/31/2016) | |
1254 | 1254 | LifeCare Hospitals of Pittsburgh-Monroeville | Monroeville | Allegheny | 131 | 12/02/2016 | |
1253 | 1253 | TTM | Greensburg | Westmoreland/Allegheny | 205 | 11/30/2016 | |
1252 | 1252 | Sodexo, Inc. | Philadelphia | Philadelphia | 266 | 12/10/2016 | |
1251 | 1251 | Forever 21 Logistics LLC | Mount Joy | Lancaster | 61 | 11/30/2016 | |
1250 | 1250 | AstraZeneca | Fort Washington | Montgomery | 134 | 10/01/2016 | |
1249 | 1249 | HCR ManorCare | Devon | Chester | 124 | 11/17/2016 | |
1248 | 1248 | Packaging Corporation of America(PCA) | Pittsburgh | Allegheny | 51 | 11/11/2016 | |
1247 | 1247 | IBEX Global | Indiana Mall Indiana | Indiana | 79 | 10/31/2016 | |
1246 | 1246 | DST Health Solutions | Harrisburg | Dauphin | 1 | 10/31/2016 | |
1245 | 1245 | Pepsi Beverages Company | Reading | Berks | 94 | 11/06/2016 | |
1244 | 1244 | Caterpillar, Inc. | Houston | Washington | 155 | 10/18/2016 | CLOSING |
1243 | 1243 | **UPDATE** Murray American Transportation | Monessen | Westmoreland | 0 | 8/29/2016 | LAYOFF |
1242 | 1242 | Broder Bros. | Philadelphia | Philadelphia | 143 | 10/10/2016 | CLOSING |
1241 | 1241 | Merck & Co., Inc. | North Wales | Montgomery | 148 | 9/12/2016 | CLOSING |
1240 | 1240 | American Air Filter Company Inc. | Elizabethtown | Lancaster | 90 | 9/15/2016 | CLOSING |
1239 | 1239 | Gordon Food Service | Pottsville | Schuylkill | 120 | 11/5/2016 | CLOSING |
1238 | 1238 | Mondelez International | Philadelphia | Philadelphia | 1 | 9/26/2016 | CLOSING |
1237 | 1237 | Rohrer Corporation | Lewistown | Mifflin | 55 | 10/14/2016 | CLOSING |
1236 | 1236 | Thorley Industries LLC | Pittsburgh | Allegheny | 53 | 6/21/2016 | LAYOFF |
1235 | 1235 | Murray American Energy Corp. | Brave | Greene | 276 | 8/29/2016 | LAYOFF |
1234 | 1234 | Ledvance, LLC | Wellsboro | Tioga | 64 | 9/30/2016 | CLOSING |
1233 | 1233 | Mobilex | Horsham | Montgomery | 63 | 9/26/2016 | CLOSING |
1232 | 1232 | Triumph Interiors LLC | Oakdale | Allgheny | 53 | 3/31/2017 | LAYOFF |
1231 | 1231 | C&J Well Services | Black Lick | Jefferson | 73 | 9/14/2016 | LAYOFF |
1230 | 1230 | Murray American Transportation | Monessen | Westmoreland | 63 | 8/29/2016 | LAYOFF |
1229 | 1229 | Clover (Environmental Reclamation Services, LLC) | Erie | Erie | 65 | 8/26/2016 | LAYOFF |
1228 | 1228 | FedEx Ground | Pittsburgh | Allegheny | 139 | 8/1/2016 | LAYOFF |
1227 | 1227 | HMS Host | Tarentum | Allegheny | 51 | 7/31/2016 | CLOSING |
1226 | 1226 | Koppers Inc. | Clairton | Allegheny | 46 | 8/5/2016 | CLOSING |
1225 | 1225 | KraftHeinz | Lehigh Valley | Lehigh | 341 | 7/31/2016 | CLOSING |
1224 | 1224 | **UPDATE** CalFrac | Smithfield | Fayette | 1 | 7/20/2016 | LAYOFF |
1223 | 1223 | USAA | Philadelphia | Philadelphia | 7 | 7/19/2016 | CLOSING |
1222 | 1222 | Southeast Service Corporation | Philadelphia | Philadelphia | 55 | 6/30/2016 | CLOSING |
1221 | 1221 | Pittsburgh Corning | Port Allegheny | McKean | 80 | 7/11/2016 | CLOSING |
1220 | 1220 | **UPDATE** Prudential Insurance Company of America | Dresher | Montgomery | 0 | 6/27/2016 (New layoff date for 91 employees originally affected. No additional layoffs. See notice posted in February 2016) | LAYOFF |
1219 | 1219 | NuWeld, Inc. | Williamsport | Lycoming | 96 | 5/4/2016 | LAYOFF |
1218 | 1218 | Excel Homes Group, LLC | Liverpool | Perry | 11 | 5/3/2016 | CLOSING |
1217 | 1217 | Excel Homes Group, LLC | Mechanicsburg | Cumberland | 280 | 5/3/2016 | CLOSING |
1216 | 1216 | **UPDATE** | Philadelphia | Philadelphia | 1 | 6/30/2016 | CLOSING |
1215 | 1215 | First Student | Harrisburg | Dauphin | 43 | 6/30/2016 | CLOSING |
1214 | 1214 | Kmart | Uniontown | Fayette | 73 | 7/24/2016 | CLOSING |
1213 | 1213 | Education Management Corporation (EDMC) | Pittsburgh | Allegheny | 222 | 7/4/2016 | LAYOFF |
1212 | 1212 | Sodexo, Inc. | Philadelphia | Philadelphia | 108 | 6/30/2016 | CLOSING |
1211 | 1211 | American Airlines | Moon Township | Allegheny | 1 | 6/30/2016 | CLOSING |
1210 | 1210 | DST Health Solutions | Harrisburg | Dauphin | 107 | 6/30/2016 | CLOSING |
1209 | 1209 | CalFrac Well Services | Smithfield | Fayette | 63 | 6/26/2016 | LAYOFF |
1208 | 1208 | Durham School Services, L.P. | York | York | 88 | 6/7/2016 | CLOSING |
1207 | 1207 | Meadowbrook Meat Co., Inc. | Lancaster | Lancaster | 76 | 6/12/2016 | CLOSING |
1206 | 1206 | NHS Youth Services | Coal Township | Northumberland | unknown | 6/5/2016 | LAYOFF |
1205 | 1205 | Charlotte Russe | Whitehall | Montgomery | No amount listed on WARN | 3/16/20 | Temp Closure, COVID-19 |
1204 | 1204 | Charlotte Russe | Lancaster | Lancaster | No amount listed on WARN | 3/16/20 | Temp Closure, COVID-19 |
1203 | 1203 | Charlotte Russe | Springfield | Lehigh | No amount listed on WARN | 3/14/20 | Temp Closure, COVID-19 |
1202 | 1202 | America's Auto Auction Pennsylvania, Inc | Washington | Washington | 32 | March 17 thru April 30, 2020 | Temp Layoffs COVID – 19 |
1201 | 1201 | America's Auto Auction Pennsylvania, Inc | East Petersburg | Lancaster | 150 | March 17 thru April 30, 2020 | Temp Layoffs COVID – 19 |
1200 | 1200 | America's Auto Auction Pennsylvania, Inc | Mechanicsburg | Cumberland | 213 | March 17 thru April 30, 2020 | Temp Layoffs COVID – 19 |
1199 | 1199 | Kleinfelder | Mechanicsburg | Cumberland | 36 | March 27, 2020 through June 22, 2020 | Temp Layoff COVID - 19 |
1198 | 1198 | JC Penney's and 2 Kohl's Stores | Dauphin - 1, Allegheny - 6, Lancaster - 1, Luzerne - 1, Monroe - 1, Lackawanna - 1, Erie - 2, Fayette - 1, Indiana - 1, Lehigh – 1, Fayette – 1, Montgomery – 1, Bucks – 1, Cambria – 1, Mercer – 2, York – 1, Westmoreland – 1, Cumberland – 1, Butler – 1 | 88 | 3/19/20 through 4/1/20 (dates are fluid) | Temporary Layoff - COVID-19 | |
1197 | 1197 | Veolia Water Technologies, Inc | Moon Township | Allegheny | 29 | June 12, 2020 | Closure |
1196 | 1196 | Veolia Water Technologies, Inc | Moon Township | Allegheny | 49 | March 27, 2020 | Closure |
1195 | 1195 | Oakwood Worldwide LP | Philadelphia, Bucks | 3 | December 30, 2019 | Layoff | |
1194 | 1194 | Musser's Market | Quarryville | Lancaster, Lebanon | 327 | 10/20/19 | Closure |
1193 | 1193 | Morrison Healthcare | Philadelphia | Philadelphia | 250 | 8/30/19 | Closure |
1192 | 1192 | Hallcon | Lehigh, Dauphin, Berks, Montgomery, Northumberland, Lancaster | 84 | July 15, 2019 | Layoff | |
1191 | 1191 | Harriet Carter Gifts, Inc.; Fresh Finds LLC; Wise and Well LLC | Chalfont | Bucks | 202 | 3/29/19 | Closure |
1190 | 1190 | Darrenkamp's | Lancaster, York | 641 | November 3, 2018 | Closure | |
1189 | 1189 | Merakey | Lackawanna, Wayne | 171 | October 28, 2018 | Layoff | |
1188 | 1188 | Sitel | Nashville, TN | Delaware | 2 | 4/6/18 | Layoff |
1187 | 1187 | Transamerica Life Insurance Company | Exton | Chester | 192 | April 14, 2018 | TRANSITION |
1186 | 1186 | Johnson & Johnson | Chester, Delaware | 34 | March 9 - March 23, 2018 (Phase 2) | Closure | |
1185 | 1185 | Johnson & Johnson | Chester, Delaware | 293 | 12/15/2017 | Closure | |
1184 | 1184 | Harley Davidson Motor Company | York | York | 118 | 6/23/17 - 7/21/17 | |
1183 | 1183 | Chestnut Street Venture LP | Philadelphia | Phildelphia | 85 | 3/23/20 | Closure (expected to be temporary in nature but changed to permanent closure due to COVID-19 pandemic) |
1182 | 1182 | 700 Chestnut Restaurant LP | Philadelphia | Phildelphia | 72 | 3/23/20 | Closure (expected to be temporary in nature but changed to permanent due to COVID-19 pandemic) |
1181 | 1181 | The Bunker LLC | Philadelphia | Philadelphia | 113 | March 23, 2020 | Closure (expected to be temporary in nature but became permanent due to COVID-19 pandemic) |
1180 | 1180 | Carpenter Comfort Cushioning Products | Altoona | Blair | 43 | 3/20/2020 | Temporary Layoff due to COVID-19 |
1179 | 1179 | Parc Restaurant Partners, LP d/b/a PARC | Philadelphia | Philadelphia | 263 | March 23, 2020 | Layoffs are permanent due to COVID |
1178 | 1178 | Thirteenth St Restaurant Partnerships, LP dba EL Vez | Philadelphia | Philadelphia | 172 | March, 23 2020 | Layoffs are permanent due to COVID |
1177 | 1177 | Washington Square Restaurant Partners LP | Philadelphia | Philadelphia | 149 | 3/23/20 | Closure (Was initially expected to be temporary but turned into a permanent closure due to COVID-19 pandemic) |
1176 | 1176 | Eighteenth St Restaurant Partners, LP | Philadelphia | Philadelphia | 118 | March 23, 2020 | Layoffs are permanent due to COVID |
1175 | 1175 | Friendly’s Restaurant | Camp Hill | Cumberland | 31 | 3/17/20 through 3/30/20 | Closure (expected to be temporary in nature due to COVID-19 pandemic) |
1174 | 1174 | Select Restaurant Partners LP, d/b/a Pizzeria Stella | Philadelphia | Philadelphia | 42 | 3/23/20 | Layoff (Expected to be permanent in nature due to COVID-19 |
1173 | 1173 | Bierfish Restaurant partners, LP d/b/a/ Frankford Hall | Philadelphia | Philadelphia | 50 | 3/23/20 | Layoff (Expected to be permanent in nature due to COVID-19) |
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 );