COVID_WARN_Notices: pennsylvania_warn_raw: 1,272 rows where sorted by Company

Big Local News is collecting and updating WARN (layoff/furlough) notices from state government sites and is processing the data to make it more useable. So far, we are collecting and updating daily or weekly data from 36 states. A federal law -- the WARN Act (Worker Adjustment and Retraining Notification Act) requires companies with more than 100 employees to give 60 days notice of any layoff, closure or furlough and 17 states have their own similar statutes. This data provides much more granularity into the types of jobs being lost and the companies that are furloughing workers, or that plan to close completely. A key note is that "unforeseen business circumstances" can mean that a company doesn't have to provide 60 days notice. For example, California has lifted that level of notice for its state version, or mini-WARN Act. Nonetheless, even though the advance time limit is flexible, companies still have to submit. Please cite the WARN data as collected by Big Local News. California data can be cited as collected and processed by Stanford journalism student Vanessa Ochavillo. This project includes a general README, a more specific README for California and a more specific file layout README that details the fields by state. Some states are missing but we are working to obtain the data or build scrapers. If you are interested in contributing, please let us know at biglocalnews@stanford.edu.

Data source: Big Local News · About: big-local-datasette

1,272 rows sorted by Company

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link	rowid	Company ▼	City	County	# Affected	Effective Date	Closing or Layoff
626	626	UPDATE	Williamsport	Lycoming	52	4/1/2017-4/14/2017
1216	1216	UPDATE	Philadelphia	Philadelphia	1	6/30/2016	CLOSING
1255	1255	UPDATE	Indiana Mall Indiana	Indiana	**0	WARN RESCINDED (first notice was dated 08/31/2016)
1243	1243	UPDATE Murray American Transportation	Monessen	Westmoreland	0	8/29/2016	LAYOFF
1224	1224	UPDATE CalFrac	Smithfield	Fayette	1	7/20/2016	LAYOFF
735	735	UPDATE Excel Inc. dba DHL Supply Chain	Palmyra	Lebanon	116	beginning 12/8/17 through 2/25/18 (phases)	Layoff
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
519	519	UPDATE American Axle & Manufacturing	Lancaster	Lancaster	10	6/22/2015	CLOSING
518	518	UPDATE Mondelez International	Philadelphia	Philadelphia	228	3/20/2015	CLOSING
981	981	*Constantia- “Colmar Plant”	Colmar	Montgomery	61	November 24, 2019	Closure
924	924	UDPATE TO 10/11/17 WARN Johnson & Johnson	West Chester	Chester	2	June 28 – July 12, 2019	Closure
948	948	UDPATE TO 5/10/19 WARN Akers National Roll Company	Avonmore	Westmoreland	31	7/12/19	Closure
960	960	UDPATE TO 5/10/19 WARN Akers National Roll Company	Avonmore	Westmoreland	31	7/12/19	Closure
943	943	UDPATE TO 5/10/19 WARN Reading Eagle Company	Reading	Berks	81	6/30/19	Closure
976	976	UDPATE TO 7/24/19 WARN True Value Company, LLC	Allentown	Lehigh	165	11/15/19	Closure (Regional Distribution facilities)
900	900	UPDATE TO 1/29/18 WARN Harbison Walker International, Sproul Plant	Claysburg	Blair	14	3/29/19	Closure
983	983	UPDATE TO 10/11/17 WARN Johnson & Johnson	West Chester	Chester	7	December 6 – 20, 2019	Closure
899	899	UPDATE TO 10/11/17 WARN Johnson & Johnson	West Chester	Chester	2	April 19 – May 3, 2019	closure
995	995	UPDATE TO 10/11/17 WARNJohnson & Johnson	West Chester	Chester	6	January 10-24, 2020	Closure
1003	1003	UPDATE TO 10/11/17 WARNJohnson & Johnson	West Chester	Chester	9	March 6 – April 3, 2020	Closure
1010	1010	UPDATE TO 12/2019 WARN Erie Coke Corporation	Erie	Erie	149	staggered separations are continuing through 1/30/20	Closure
898	898	UPDATE TO 3/26/16 WARN Arrow International Incorporated/ Teleflex	Reading	Berks	14	May 3 2019	Layoff
894	894	UPDATE TO 3/26/16 WARN Arrow International Incorporated/ Teleflex	Reading	Berks	59	March 29, 2019	Layoff
980	980	UPDATE TO 6/26/19 WARN Philadelphia Energy Solutions	Philadelphia	Philadelphia	4	November 15, 2019	CLOSURE
991	991	UPDATE TO 8/14/19 WARN ACF Industries LLC	Milton	Northumberland	148	10/15/19 – 12/31/19	Layoff
1001	1001	UPDATE TO 8/14/19 WARNFirstEnergy Generation Corp.	Shippingport	BEAVER	13	February 15, 2020	Closure
1024	1024	UPDATE TO FEBRUARY WARNBowhead Integrated Support Services	Chambersburg	Franklin	7 (April 24); 11 (May 1); 3 (May 3)	4/24/20; 5/1/20; 5/3/20	Layoff
885	885	UPDATE TO JANUARY 29, 2018 WARNHarbison Walker International, Sproul Plant	Claysburg	Blair	38 total	February 15, 2019 (24) and March 29, 2019 (14)	Closure
843	843	UPDATE TO MAY 11, 2018 WARN Medtronic, Inc.	Bala Cynwyd	Montgomery	4	9/22/18	Layoff
951	951	UPDATE TO MAY 24, 2019 WARNLedvance LLC	St Marys	Elk	170	10/25/19	Closure
963	963	UPDATE TO MAY 24, 2019 WARNLedvance LLC	St Marys	Elk	170	10/25/19	Closure
807	807	UPDATE To October 11, 2017 WARN Johnson & Johnson	Wayne	Delaware	41-43	July 13 - 27, 2018	Closure
801	801	UPDATE to December 6, 2017 WARN Arrow International Incorporated,	Reading	Berks	6	6/29/2018	6/29/2018
836	836	UPDATE to December 6, 2017 WARN Arrow International Incorporated, A Teleflex Incorporated Subsidiary	Reading	Berks	1	August 31, 2018	Layoff
764	764	UPDATE to December 6, 2017 WARN ESPA ASSOCIATES, LLC	Coraopolis	Coraopolis, PA 15108	100	March 15, 2018	Closure
786	786	UPDATE to January 18, 2018 WARN	Creighton	Allegheny	18	May 20, 2018	Closure (June 30, 2018)
815	815	UPDATE to January 18, 2018 WARN Pittsburgh Glass Works, LLC	Creighton	Allegheny	6	July 31, 2018	Closure
826	826	UPDATE to January 18, 2018 WARN Pittsburgh Glass Works, LLC	Creighton	Allegheny	34	June 25, 2018	Closure
837	837	UPDATE to January 18, 2018 WARN Pittsburgh Glass Works, LLC	Creighton	Allegheny	118	August 17, 2018	Closure
848	848	UPDATE to January 18, 2018 WARN Pittsburgh Glass Works, LLC	Creighton	Allegheny	5	October 15, 2018	Closure
853	853	UPDATE to January 18, 2018 WARN Pittsburgh Glass Works, LLC	Creighton	Allegheny	2	September 30, 2018	Closure
788	788	UPDATE to January 29, 2018 WARN	Claysburg	Blair	88	beginning April 30, 2018	Closure
800	800	UPDATE to January 29, 2018 WARN Harbison Walker International	Claysburg	Blair	88	June 29, 2018	Closure
822	822	UPDATE to January 29, 2018 WARN Harbison Walker International	Claysburg	Blair	20	July 27, 2018	Closure
871	871	UPDATE to January 29, 2018 WARN Harbison Walker International	Claysburg	Blair	40	December 28, 2018	Closure
844	844	UPDATE to January 29, 2018 WARN Harbison Walker International	Claysburg	Blair	88	7/27/2018	Closure
860	860	UPDATE to January 29, 2018 WARN Harbison Walker International	Claysburg	Blair	10	September 27, 2018	Closure
866	866	UPDATE to January 29, 2018 WARN Harbison Walker International	Claysburg	Blair	10	September 27, 2018	Closure
827	827	UPDATE to January 9, 2017 WARN Dover Corporation	North Wales	Montgomery	1	August 31, 2018	Closure
869	869	UPDATE to January 9, 2017 WARN Dover Corporation	North Wales	Montgomery	1	June 28, 2019	Closure
849	849	UPDATE to June 14, 2018 WARN AT&T	Harrisburg	Dauphin	1	October 20, 2018	Layoff
816	816	UPDATE to May 29, 2018 WARN Worley & Obetz	Manheim	Lancaster	150	June 4, 2018	Closure
798	798	UPDATE to November 28, 2017 WARN GenOn Energy Services	New Florence	Indiana	1	November 1, 2018	Layoff
821	821	UPDATE to October 10, 2017 WARN Johnson & Johnson	Wayne	Delaware	2	August 10, 2018 – August 24, 2018	Closure
802	802	UPDATE to October 11, 2017 WARN Johnson & Johnson	Wayne	Delaware	7	June 29 - July 13, 2018 (4 employees); July 13 - 27, 2018 (3 employees)	Closure
845	845	UPDATE to October 11, 2017 WARN Johnson & Johnson	Wayne	Delaware	3	9/28-10/19/2018	Closure
847	847	UPDATE to October 11, 2017 WARN Johnson & Johnson	Wayne	Delaware	3	October 5 -November 2, 2018	Closure
872	872	UPDATE to October 11, 2017 WARN Johnson & Johnson	Wayne	Delaware	3	December 28, 2018 - January 11, 2019	Closure
322	322	UPDATE	Philadelphia	Philadelphia	86	11/8/2013	PLANT CLOSING
603	603	UPDATE	Philadelphia	Philadelphia	248	5/1/2016	CLOSING
606	606	UPDATE	Philadelphia	Philadelphia	261	3/25/2016	CLOSING
607	607	UPDATE	Philadelphia	Philadelphia	96	3/31/2016	CLOSING
768	768	UPDATE	Allentown	Lehigh	5	March 10, 2018	Closure of Iron Run Distribution Center
772	772	UPDATE	Wayne	Delaware	4	April 6 - 20, 2018 (Phase 3)	Closure
1027	1027	UPDATE	Glenshaw	Allegheny	11	May 1-14, 2020	Closure
1028	1028	UPDATE	Erie	Erie	16	March 3- 16, 2020	Closure
619	619	UPDATE Mondelez International	Philadelphia	Philadelphia	1	4/26/2016	CLOSING
621	621	UPDATE Helomics Inc.	Pittsburgh	Allegheny	125	4/15/2016	LAYOFF
779	779	UPDATE Johnson & Johnson	Wayne	Delaware	4	April 30- May 14, 2018 (1 employee) and June 1-15, 2018 (3 employees)	Closure
755	755	UPDATE Lord & Taylor	Wilkes Barre	Luzerne	202	March 13, 2018; March 30, 2018; April 27, 2018	Layoff
610	610	UPDATE Metso Minerals	York	York	24	3/18/2016	CLOSING
611	611	UPDATE Metso Minerals	York	York	36	3/31/2016	CLOSING
773	773	UPDATE Rodale Payroll, LLC (subsidiary of Hearst Magazines, Inc).	Allentown	Lehigh	35	Jan 9, 2018	Closure of Iron Run Distribution Center
774	774	UPDATE Rodale Payroll, LLC (subsidiary of Hearst Magazines, Inc).	Allentown	Lehigh	8	Jan 9, 2018	Closure of Iron Run Distribution Center
314	314	UPDATE NRG Energy, Inc.	Birdsboro	Berks	43	10/31/2013	PERMANENT LAYOFFS
436	436	UPDATE Bank of America	Pittsburgh	Allegheny	46	7/7/2014	PERMANENT CLOSURE
482	482	UPDATE Bemis Healthcare Packaging	Philadelphia	Philadelphia		1/29/2016	CLOSING
504	504	UPDATE Coyne Textile Services	York	York, Erie	11 in PA	11/30/2015	CLOSING
471	471	UPDATE GE Power & Water	West Mifflin	Allegheny	65	2/28/2014	PLANT CLOSURE
465	465	UPDATE Horsehead	Pittsburgh	Beaver	510	3/1/2014	PLANT CLOSURE
472	472	UPDATE Horsehead	Pittsburgh	Beaver	510	3/1/2014	PLANT CLOSURE
401	401	UPDATE Johnson Controls, Inc.	Waynesboro	Franklin	151	April 7, 2014 through August 15, 2015	PERMANENT LAYOFF
431	431	UPDATE Johnson Controls, Inc.	Waynesboro	Franklin	204	Separation to occur over 18 waves between April 7, 2014, through October 15, 2015	CLOSURE
591	591	UPDATE Lockeheed Martin Space Systems Co.	Newtown	Bucks	57	4/17/2015	CLOSING
368	368	UPDATE Lockheed Martin	Newtown	Bucks	75	1/23/2015	PERMANENT LAYOFF
391	391	UPDATE Lockheed Martin	Newton	Bucks	35	10/31/2014	LAYOFF
398	398	UPDATE Lockheed Martin	Newton	Bucks	23	11/14/2014	LAYOFF
412	412	UPDATE Lockheed Martin	Newtown	Bucks	27	8/28/2014	CLOSURE
420	420	UPDATE Lockheed Martin	Newtown	Bucks	11	9/18/2014	CLOSURE
425	425	UPDATE Lockheed Martin	Newtown	Bucks	14	7/31/2014	LAYOFF
432	432	UPDATE Lockheed Martin	Newtown	Bucks	20	6/27/2014	PLANT CLOSURE
445	445	UPDATE Lockheed Martin	Newtown	Bucks	8	5/30/2014	LAYOFF
464	464	UPDATE Lockheed Martin	Newtown	Bucks	18	4/24/2014	PLANT CLOSURE
576	576	UPDATE Lockheed Martin Space Systems Company	Newtown	Bucks	39	3/13/2015	CLOSING
409	409	UPDATE Louis F. Leeper Company	Pittsburgh	Allegheny	165	Between August 15 and August 22, 2014	PERMANENT LAYOFF
582	582	UPDATE Mondelez Global, LLC	Philadelphia	Philadelphia	55	4/24/2015	CLOSING
570	570	UPDATE Mondelez Global, LLC.	Philadelphia	Philadelphia	72	5/8/2015	CLOSING
572	572	UPDATE Mondelez Global, LLC.	Philadelphia	Philadelphia	100	5/15/2015	CLOSING
443	443	UPDATE NRG Energy, Inc.	Birdsboro	Berks	53	5/30/2014	CLOSURE
463	463	UPDATE NRG Energy, Inc.	Birdsboro	Berks	43	4/15/2014	PERMANENT LAYOFFS

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
);