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

966 rows sorted by rowid descending

View and edit SQL

Suggested facets: Closure or Layoff?, Notes_processed, Multiple_locations

Link rowid ▲ Date Received Region County Company Name Company Name_processed Company_name_detail_processed NAICS Code Employees Closure or Layoff? Projected Date Trade Notice URL Notes_processed Multiple_locations
966 4/27/20 Bluegrass Fayette Copart Copart   423110 50 Closure 4/27/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000lFvN/E_nV4ZiPQXnnjdzptfU3GYUGocuIOqaU.Y9H1GQf.O0      
965 4/27/20 Cumberlands Pulaski Hendrickson USA Hendrickson USA   336390 179 Layoff 4/27/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000lFy7/Yv5x__FLS4A2m1cTlMmbBkJ72jQVKesqE4aS843KqbM      
964 4/27/20 Statewide Statewide Bloomin' Brands Inc. Bloomin' Brands Inc.   722511 1134 Layoff 3/15/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000lFnJ/4P1OqyziA7PB0Bwl_6nFu_TYtWbVZmItGG0ajc_A4io      
963 4/28/20 South Central Warren Fruit of The Loom Fruit of The Loom   315190 541 Layoff 5/3/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000lHSh/K0STGdn5RioZCNnefjssHgRYhvyegfO5stZN_W4HKGc      
962     Jefferson Philip Morris Philip Morris   field not included 260   field not included field not included NA      
961   field not included Perry Mountain Coals Corporation Star Fire Mine Buckhorn Processing Plant Mountain Coals Corporation Star Fire Mine Buckhorn Processing Plant field not included 10 Layoff field not included field not included NA      
960   Greater Louisville Field not included Martinrea Heavy Stamping Martinrea Heavy Stamping   336399       All other motor vehicle parts Mfg. NA      
959   field not included Warren Kentucky Apparel, L.L.P. Kentucky Apparel, L.L.P.   field not included 61 Layoff field not included field not included NA      
958   Greater Louisville Field not included Ford Motor Company Louisville Assembly Plant Ford Motor Company Louisville Assembly Plant   336112 756   7/21/08 Light truck and utility vehicle mfg. NA      
957   field not included Jefferson Commonwealth General Corp.. Commonwealth General Corp..   field not included 360   field not included field not included NA      
956   TENCO Field not included Cintas Cintas   31252 148 Closure 1/31/09 Work pants NA Route 2 Kendal Springs Road, Owingsville, KY 40360    
955     Henderson Accuride Accuride     18   2/2/01   NA      
954 4/27/20 Green River Hancock Domtar Paper Company LLC Domtar Paper Company LLC   322121 398 Layoff 5/4/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000lG1B/4Fd5SUVur4FncgJi63EeLKzz9wTruSFuhn9yeHQp8b0      
953 4/27/20 Bluegrass Fayette Copart Copart   423110 50 Closure 4/27/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000lFvN/E_nV4ZiPQXnnjdzptfU3GYUGocuIOqaU.Y9H1GQf.O0      
952 4/27/20 Cumberlands Pulaski Hendrickson USA Hendrickson USA   336390 179 Layoff 4/27/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000lFy7/Yv5x__FLS4A2m1cTlMmbBkJ72jQVKesqE4aS843KqbM      
951 4/27/20 Statewide Statewide Bloomin' Brands Inc. Bloomin' Brands Inc.   722511 1134 Layoff 3/15/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000lFnJ/4P1OqyziA7PB0Bwl_6nFu_TYtWbVZmItGG0ajc_A4io   Statewide StatewideA
950 4/24/20 Kentuckiana Works Jefferson Enterprise Rent-A-Car Enterprise Rent-A-Car   532111 104 Layoff 4/30/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000lFRh/UszfPVKKroq1QAKiNquy4pybhgj_l.wWTgrzPpPoae0      
949 4/24/20 Lincoln Trail Grayson County Leggett & Platt, Inc Leggett & Platt, Inc   423210 210 Layoff 4/14/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000lFhk/YXvfnj9glnybML0caPMSROnboavSXn.klKEWtkrTQy8      
948 4/24/20 Kentuckiana Works Jefferson Enterprise Rent-A-Car Enterprise Rent-A-Car   532111 118 Layoff 3/20/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000lFQo/Dd0iim4d5jjd4TYBWh2lMYNeVGc37N7hRYP1WAOvxGA      
947 4/24/20 Bluegrass Fayette EAN Holdings, LLC dba/Enterprise Rent-A-Car/Alamo/National EAN Holdings, LLC dba/Enterprise Rent-A-Car/Alamo/National   532111 102 Layoff 3/20/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000lFDB/kRPBe.4UKGSTGSllBCkX9k7zMUm.j5e7.dzfx1Or6tU      
946 4/23/20 Statewide Statewide Visionworks, Inc. Visionworks, Inc.   446130 269 Layoff 4/4/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000lFAl/oO700mhoM_QHeowhHaKcjxvMIWN0lrbxd1SLp.he9w8      
945 4/20/20 Northern Kentucky Boone BOGE Rubber & Plastics USA LLC BOGE Rubber & Plastics USA LLC   326220 117 Layoff 3/30/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owme/I70OYWW_BMsm.L1gecTbBndG80GLYaujN7Bys19qF0E WARN    
944 4/17/20 Bluegrass Fayette CLARK Material Handling Company CLARK Material Handling Company   33392 55 Layoff 4/15/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owlC/hEdK2CiuQJ0bVuYeIRqwIFPEy53bOvrnmZtKCFG3OTk WARN    
943 4/17/20 Kentuckiana Works Jefferson AVIS BUDGET CAR RENTAL LLC-Louisville AVIS BUDGET CAR RENTAL LLC Louisville 532111 39 Layoff 3/13/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owlW/CYo8uyV1lqLUe_XJLwXgKKbMGcUSOnm2YuFWlCcEjao WARN    
942 4/17/20 Northern Kentucky Boone AVIS BUDGET CAR RENTAL LLC - CVG AVIS BUDGET CAR RENTAL LLC - CVG   532111 51 Layoff 3/13/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owlM/.Zk80i_XFS7aZoaHWgUxXaHRiKaZbtC_7AhdxqU6wug WARN    
941 4/15/20 Bluegrass Clark Leggett & Platt, Inc. Leggett & Platt, Inc.   33791 271 Layoff 3/27/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owe6/AOd4ALEemb0aAShUt5dhhnJlPDFohiL8zcc9JttELyY      
940 4/15/20 Bluegrass Scott Leggett & Platt, Inc. Leggett & Platt, Inc.   337215 151 Layoff 3/27/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owfY/PmJV_yGxFZQyYhZo1Z3JUNNKeymCbhxmj4tTRLPEQdQ      
939 4/15/20 Northern Kentucky Boone Jacobsen|Daniels - CVG Jacobsen|Daniels - CVG   488190 17 Layoff 3/27/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owe1/_JzvIyNP00OZFCdiwLq50NqX4Pv5uhASRmnOON4x7JM      
938 4/14/20 Northern Kentucky Campbell Newport Aquarium LLC Newport Aquarium LLC   712130 88 Layoff 4/20/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owce/l.sHHNbu0GPlyDLBohqkTc6rmr3iMKC.C7bGdM4pAc0      
937 4/14/20 Kentuckianaworks Jefferson GUESS Distribution Center GUESS Distribution Center   423990 230 Layoff 4/2/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owbq/UyrAEX7r.ENTpYJbgJLT8Cg7CPlnvxwl2yKnTp7J72s      
936 4/14/20 Kentuckianaworks Jefferson Glidewell Laboratories-Crown World Dental Lab Glidewell Laboratories-Crown World Dental Lab   339116 151 Layoff 3/27/20 Yes https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owc5/NegKIAQd.3f3pmcw73INUcvkRVIbZTkujR6EIS0ot58      
935 4/14/20 Kentuckianaworks Jefferson Bedding Acquisition LLC-Hollander Sleep Products Bedding Acquisition LLC-Hollander Sleep Products   337910 234 Closure 4/3/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owc0/YfonXN9YuzXLk_UAXU4_FKNeT7YOIM6p5kka_JgwN0Y      
934 4/13/20 Bluegrass Madison Vitro Automotive/Pittsburgh Glass Works Vitro Automotive/Pittsburgh Glass Works   561311 63 Layoff 3/23/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owbl/PeliEutZZle1HuohBNOUPeWObAPJ6.IxcJLQM0pFF0o      
933 4/10/20 Bluegrass Boyle Ephraim McDowell Health Ephraim McDowell Health   62111 510 Layoff 4/10/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owax/gIoDc8Xv49xawkTE2lbcXgud5nCNoJANhlFRxiXKV8c Employees field: See the Document, which referred to 30 % of 1700-plus being placed on temporary short-term furlough    
932 4/8/20 Western Kentucky Christian Jennie Stuart Medical Center Jennie Stuart Medical Center   62211 248 Layoff 4/7/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owai/euBMynNBZ1XxY9GZsxqub51sfACbr_edi4z8.BvNzk8      
931 4/8/20 Northern Kentucky Boone Groupon Goods KY Fulfillment Center Groupon Goods KY Fulfillment Center   488510 92 Layoff 6/7/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owaO/GWTBVMydk_wwkETRK9Ra861k.S_1Cpifx9oY_o5DE2Y      
930 4/7/20 Northern Kentucky Boone Safran Landing Systems Kentucky Safran Landing Systems Kentucky   336413 181 Layoff 4/12/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owYS/48f5c5_B5wyiPJ9Uy_H1cNlwWBdNMLD_pYAS8WUMQM8      
929 4/7/20 Northern Kentucky Boone HMS Host - CVG Airport HMS Host - CVG Airport   72251 260 Layoff 3/17/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owXZ/yTHs5XelOkz__Ev_3i058NYLPt39FknT235h9rtta.I      
928 4/6/20 Statewide Statewide HOOTERS of America LLC HOOTERS of America LLC   722511 293 Layoff 3/16/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owVx/qvIScRk9GM5Elj.GBDk.q4vXbyNWeEoZlek.EdFKUGs      
927 4/6/20 Lincoln Trail Marion Hendrickson Hendrickson   423110 117 Layoff 4/13/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owX0/V6hwrqZ0Qlr_eFlMYEYrZXlE5AKDheKuIEjfBsUaPdQ      
926 4/6/20 Lincoln Trail Hardin Communicare Services - Leitchfield Communicare Services - Leitchfield Leitchfield 623110 16 Layoff 3/20/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owX5/hqgTkrEKeD2diZgwtvYubxlNzxik77T983Z_rFk92oU      
925 4/6/20 Lincoln Trail Washington Communicare and Communicare Services - Springfield Communicare and Communicare Services - Springfield Springfield 623110 16 Layoff 3/20/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owWC/G1vvtarZYPJdOhvrIz1yR8EPnXsOq0_BH2dWoGiRDP4      
924 4/6/20 Lincoln Trail Hardin Communicare and Communicare Services - Radcliff Communicare and Communicare Services - Radcliff Radcliff 623110 17 Layoff 3/20/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owWq/Vfpl8UYl0gbX_iFIJoUfIBUwxuS8TiJTC_7F4sKJFYw      
923 4/6/20 Lincoln Trail Marion Communicare and Communicare Services - Lebanon Communicare and Communicare Services - Lebanon Lebanon 623110 16 Layoff 3/20/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owWg/9p9FS.JQp0PTPMhD3HxrAxxsoxTEr_upxaagBfFMogM      
922 4/6/20 Lincoln Trail Hardin Communicare and Communicare Services - Elizabethtown Communicare and Communicare Services - Elizabethtown Elizabethtown 623110 63 Layoff 3/20/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owW2/m6.18mqxu4V91wnL7oO6sVnlaLN8Ty2M97cFVaRMbUI      
921 4/6/20 Lincoln Trail Hardin Communicare and Communicare Services - Brandenburg Communicare and Communicare Services - Brandenburg Brandenburg 623110 14 Layoff 3/20/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owXA/mAUPSS8QJjeTFI7E27u8VQgWHFFi6LRZfcfzfkHq1Jo      
920 4/6/20 Lincoln Trail Nelson Communicare and Communicare Services - Bardstown Communicare and Communicare Services - Bardstown Bardstown 623110 27 Layoff 3/20/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owW7/vxvDkskTDW8u8rCe_lHYjJe3ywqVHolgywHu7LkriIg      
919 4/6/20 Lincoln Trail Breckinridge Communicare and Communicare Clinic LLC - Hardinsburg Communicare and Communicare Clinic LLC - Hardinsburg Hardinsburg 623110 14 Layoff 3/20/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owWR/145nfIPWN0_U_cemfoWJlEEcFSVIRIo8wdyDtysKwiE      
918 4/6/20 Lincoln Trail Hardin Communicare and Communicare Clinic - Radcliff Communicare and Communicare Clinic - Radcliff Radcliff 623110 17 Layoff 3/20/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owWl/rS8vJCQrLNj0CL7FyoK6cd2Ubo0vr1icry6WlMYbX7U      
917 4/6/20 Lincoln Trail Marion Communicare and Communicare Clinic - Lebanon Communicare and Communicare Clinic - Lebanon Lebanon 623110 16 Layoff 3/20/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owWW/6KnRleJzURSaBY_6FARK03ypKCpBzXNzxwnFAWGUcwk      
916 4/3/20 EKCEP Knox Jackson Warewashing Systems Jackson Warewashing Systems   423440 94 Layoff 4/6/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owVY/2COXMu6Bd1MCYgNNs.Sc62L0asFJOG..KVsIGQuqD5g      
915 4/2/20 Kentuckianaworks Jefferson SCHULTE COMPANIES SCHULTE COMPANIES   721110 133 Layoff 3/16/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owVT/U2oN7sbm_kSzNb7xiYNnrUVaoC_094PGtzzEyvZMQHo      
914 4/2/20 Lincoln Trail Hardin IHG Army Hotels & Holiday Inn Express IHG Army Hotels & Holiday Inn Express   721110 68 Layoff 3/20/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owVi/IMPz0uy5.8DXS8aWGuSQX3cPDNWc6wEkkwZwPlw6wyc      
913 4/2/20 Western Kentucky Christian HUHTAMAKI INC HUHTAMAKI INC   333999 115 Layoff 4/5/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owUa/gQ7KCmO7r.5JxftEeBG61Dp0YG0btnF0QmbfOv3Jqwg      
912 4/1/20 Green River Ohio The Western Kentucky Coal Company The Western Kentucky Coal Company   212111 42 Layoff 6/2/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owVE/C0OZ4Bz9aNkrc9YrcMiSzi1G1WqI2.arpnDnUUJqUr8      
911 4/1/20 Western Kentucky Muhlenberg THE MUHLENBERG COUNTY COAL COMPANY THE MUHLENBERG COUNTY COAL COMPANY   21211 140 Closure 6/2/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owVJ/Dg9.VOc4xZE0CzOT2WBULH9AF2F_W3myXxa4ijm196A      
910 4/1/20 Kentuckianaworks Jefferson Paper Source Paper Source   424110 10 Layoff 3/29/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owQu/m2vDq7l1wLeK_e1Ptqh35ndxEEbdElyIHgPfZOFdJUc      
909 4/1/20 Bluegrass Bourbon MURRAY EQUIPMENT & MACHINE INC MURRAY EQUIPMENT & MACHINE INC   333131 11 Closure 6/2/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owVO/fRo8DiZxbz2baMUvWanGYLiXkNdGw2BDb3YAGYVqjWI      
908 4/1/20 Kentuckianaworks Jefferson Galt House Hotel & Suites Galt House Hotel & Suites   721110 399 Layoff 3/30/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owUB/Q4XhuwPlCqUiegEdy255dEODFtbl._noeWqruyQLy9c      
907 4/1/20 Kentuckianaworks Jefferson Embassy Suites Jefferson Co - Louisville Embassy Suites Jefferson Co - Louisville   541611 62 Layoff 3/30/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owTw/ZCaGJxEMniVjvqFnhoI_lXZxfMOTDOnfnNr.YyZ_aFs      
906 4/1/20 Kentuckianaworks Jefferson Crowne Plaza Hotel Crowne Plaza Hotel   721110 150 Layoff 3/30/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owU1/cmWTeASpvF33aHX13OmKNTSglY1CKyn1mH.iVuE4fs0      
905 4/1/20 Statewide Statewide Cinemark USA Inc. Cinemark USA Inc.   512131 463 Layoff 3/26/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owQQ/GkNpTgbS1O.ynAUO2lRhhohP0a9SFLAzTXhbo.1Jdyw      
904 4/1/20 Kentuckianaworks Jefferson ALJSCO ALJSCO   541611 4 Layoff 3/30/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owUL/QiUorU3I0MCyonZFb9WQqn78BNq1UIJjwP_tw34J1Sw      
903 4/1/20 Kentuckianaworks Jefferson AJS Hotels AJS Hotels   721110 2 Layoff 3/30/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owUQ/kIkf6vaRVWxJL33J4laXNMoRoo4Ps.CEaVYB4.M3PIU      
902 3/31/20 South Central Metcalfe Sumitomo Electric Wiring Systems Edmonton Plant 4 Sumitomo Electric Wiring Systems Edmonton Plant 4   238210 259 Layoff 3/23/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owP8/TWlSpofpJ.4imf9JMRN3NvxzGC9QrUrj8jwGi4dQAOw      
901 3/31/20 Bluegrass Woodford Lakeshore Learning Materials Lakeshore Learning Materials   493110 224 Layoff 4/7/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owOt/nGZIULQU2fkInu1PxDGUoIvwySt323.mFPX6UcMSWrk      
900 3/31/20 Kentuckianaworks Jefferson Dean Dairy Holding LLC Dean Dairy Holding LLC   112990 25 Closure 4/16/20 Yes https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owOo/bRBh1C8YP80dil6LNfT.do3OeOZYXcw6wdqfq3PF8m0      
899 3/31/20 Kentuckianaworks Jefferson CONIFER REVENUE CYCLE SOLUTIONS LLC CONIFER REVENUE CYCLE SOLUTIONS LLC   621999 136 Layoff 5/29/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owPN/jDHwTapPX.yBsZhb3qC7qy.geYOtPuuz3LjGauQ08h8      
898 3/30/20 Northern Kentucky Kenton County Beacon Orthopaedics and Sports Medicine Beacon Orthopaedics and Sports Medicine   621112 22 Layoff 3/28/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owQL/TkMdBFYOwIpwKzYmMUeJtbmWzIaOKmJSkueU1tPkBbI      
897 3/30/20 South Central Warren AMERICAS AUTO AUCTION BOWLING GREEN AMERICAS AUTO AUCTION BOWLING GREEN   425120 0 Layoff 3/17/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owOP/m4hSFftIYaF5iodQ8VE1x2EhPnBsL0DngWDICpc52B4      
896 3/24/20 Northern Kentucky Boone Driven Brands Take 5 Oil Change (5 Locations) Driven Brands Take 5 Oil Change (5 Locations)   811118 12 Layoff 3/22/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owHE/Fw8gLcqpehdezTgGQZvhza_ckYlPC5bs1MJ2PTwLNxQ      
895 3/23/20 Kentuckianaworks Jefferson STEEL CITY POPS LKY LLC STEEL CITY POPS LKY LLC   722511 38 Layoff 3/23/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000owBk/UdXwHzOysa2WEFIwW91sqoNtkgLUhMWGm8epCLwsdJk      
894 3/20/20 Bluegrass Fayette HILTON LEXINGTON DOWNTOWN HOTEL HILTON LEXINGTON DOWNTOWN HOTEL   561110 117 Layoff 3/20/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000ow4P/0C9LAvjzDBy8OnNf4iPYygDc5IXuPmrnoxJIB6FHmIo      
893 3/19/20 Kentuckianaworks Jefferson Trans States Airlines, LLC Trans States Airlines, LLC   488190 46 Closure 4/2/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000ow3v/Uf7QRMDiS2Wn9wh3uL_MjYr73eqzdZ2odrJ71rsyyuw      
892 3/10/20 Kentuckianaworks Jefferson Simpler Postage Inc. Simpler Postage Inc.   561431 32 Closure 5/10/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t00000008NTl/KOM2eb3czyHWnzkINC_qZBGbCu255iXTpZPawIO1BFc      
891 2/25/20 Western Kentucky Hopkins International Automotive Components International Automotive Components   336360 111 Layoff 4/18/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000ihOn/vVgpussISl65lKumOGwpNfwq9FxfUfuN4BGSvEwMKlU      
890 2/21/20 Cumberlands Laurel Conduent Federal Solutions, LLC. Conduent Federal Solutions, LLC.   58121 99 Layoff 4/25/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000ihMD/tt8tewJ511kkosZ5VaFbUX5Y44bRBloyh4qlBeHX_Pc      
889 2/14/20 Northern Kentucky Boone DeliveryForce DeliveryForce   492110 24 Layoff 4/16/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000ihGo/vT0xRvwNGC.dCw3bxMVxUj1bgCv9v1OAltj4EqlilJ4      
888 2/5/20 Northern Kentucky Campbell IPSCO Tubulars (KY), L.L.C. IPSCO Tubulars (KY), L.L.C.   425120 87 Layoff 4/5/20 TBD https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000cRpa/FhXx5qmiMk8LEffcKqwhZD.RPrbCYHQRmDk1TwaTpE0      
887 1/31/20 TENCO Boyd Oour Lady of Bellefonte Hospital, L.L.C. Oour Lady of Bellefonte Hospital, L.L.C.   622000 1226 Closure 3/31/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000cRls/iReAoQajVybKDYSG3.slx51EZwROrWfJQq8Lxz49EB4      
886 1/28/20 Western Kentucky Calloway Murray State University Murray State University   611310 65 Layoff 4/10/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000cRhl/81vkTrMagQ53YxsN0hZ.yuamCTzG76xRwCBp4TcqrH4      
885 1/23/20 Kentuckianaworks Jefferson First America/First Transit First America/First Transit   485999 177 Layoff 3/31/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000cReA/AD52MD3dra9Cw2jscmkx93bzNWHv6VISG8e5YAINi0A      
884 1/16/20 South Central Barren LSC Communications US LSC Communications US   323117 571 Closure 3/16/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000cRUa/980H1AkczTFNoma5sEpvnMR_WgJX7wifiuzbxN.lSNg      
883 1/15/20 Northern Kentucky Grant Grant County Foods LLC Grant County Foods LLC   424480 80 Closure 3/9/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000cRTm/DCB.aAEW9X0uSKH9Kc59ILPw6TDyn_Fbw2a5vAp1Gis      
882 1/15/20 Northern Kentucky Kenton Crosset Company LLC Crosset Company LLC   424990 39 Closure 3/9/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000cRTh/8DdTGF2CXICOiJsIN.OI5_yLrhz4g8I9pvki4h1EC0A      
881 1/13/20 Kentuckianaworks Shelby Ficosa North American Corporation Ficosa North American Corporation   336390 187 Closure 4/1/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000cRLn/GnIT25v05rLrhgFiEW6tjXg7K0wq1O3CgIqQARI5SxM      
880 12/26/19 Green River Ohio The Western Kentucky Coal Company, LLC Genesis Mine The Western Kentucky Coal Company, LLC Genesis Mine   212111 250 Closure 2/24/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000cRBf/TjixJjoS3DhrKgmVkJ3.liz6mpYQEtkDPu3mB0rKzg8      
879 12/19/19 Cumberlands Whitley PAE Visa Support Services (VSS) PAE Visa Support Services (VSS)   561210 425 Layoff 2/28/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000cR9Z/mzgeWCa2sgi0GNtixVIRztL6gsTTp1PgNiTIVyhSC_A      
878 12/9/19 Green River Webster Webster County Coal Dotiki Mine Webster County Coal Dotiki Mine   212112 40 Closure 2/7/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000cR1G/KaUq3yGvNu5Y3ife_6WzDglsbgthQGfBwiXh5kdz3q8      
877 11/19/19 Lincoln Trail Grayson MTD Products Inc MTD Products Inc   444220 279 Closure 1/17/20 TBD https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t00000001KXW/JMtP2rp1cKSoDYYHyZ1DOmdaLonjiWKp6el4LfveHw8      
876 11/15/19 Western Kentucky Christian Ebonite International, Inc. Ebonite International, Inc.   453998 171 Closure 1/14/20 TBD https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t00000001KW9/0lv2u0VurE2WSBVdGd8hm6TbcFYqE0qoy_aOWwzKEOc      
875 11/12/19 Kentuckianaworks Shelby Bekaert Corporation Bekaert Corporation   331222 100 Closure 1/13/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t00000001KSl/tzhNMQshDrc1hZ7dukb.WYGRvQ73NWFAXuejOa8ZKkw      
874 11/4/19 Cumberlands Laurel Nally & Hamilton Enterprises Inc Stinnett Mine -London Nally & Hamilton Enterprises Inc Stinnett Mine -London 212111 9 Layoff 1/1/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t00000001KOo/X2uDR4FH5S3OyrXeygIDWHDwaOeQeqsw5aSkgMG30CQ      
873 11/4/19 EKCEP Bell Nally & Hamilton Enterprises Inc Balkan area Mines and Facilities Nally & Hamilton Enterprises Inc Balkan area Mines and Facilities 212111 97 Layoff 1/1/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t00000001KOP/DIxYr8280eLPOAbjq5Qy.7iWEstk5S7339Xs1AZgG3Q      
872 11/4/19 EKCEP Harlan Nally & Hamilton Enterprises Inc Bailey's Creek, Cranks Creek & Day Branch Mines Nally & Hamilton Enterprises Inc Bailey's Creek, Cranks Creek & Day Branch Mines 212111 38 Layoff 1/1/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t00000001KO0/2zXboZGmgRg0Dl8r3YDiSUQo2R4SKA3KUcZjt02vBTs   Multiple locations  
871 11/4/19 EKCEP Leslie Nally & Hamilton Enterprise Inc Stinnett Mine Nally & Hamilton Enterprise Inc Stinnett Mine 212111 21 Layoff 1/1/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t00000001KOe/.prhulKld3VKHCnGLj093KMsQPcRYabh45iB0NDgl5Q      
870 11/4/19 EKCEP Harlan Nally & Hamilton Enterprise Inc Nally & Hamilton Enterprise Inc   212111 5 Layoff 1/1/20 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t00000001KOj/WCWsBGOkusIruziyuMJznicqsxCQmmFkvW4k4CMkXms      
869 10/29/19 Western Kentucky Christian AECOM AECOM   541310 383 Layoff 12/29/19 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t00000001KJZ/4_R411GmRGsz0BlUVg1GEV7MMFFCvv03ekLw0ONq8oU      
868 9/12/19 Lincoln Trail Nelson INOAC PACKAGING GROUP INC INOAC PACKAGING GROUP INC   326160 72 Layoff 11/12/19 TBD https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000WdT7/B59Pt4u9uexHusdh8dPM916_U5k8OMOCt1LcpM0BxV0      
867 9/5/19 Green River McLean Pennyrile Energy LLC- RiverEdge Mine Pennyrile Energy LLC RiverEdge Mine 212112 169 Closure 11/1/19 No https://kydev.my.salesforce.com/sfc/p/t00000004X3h/a/t0000000WdOP/0FHDmTpwrqWR7HaSOWOKmPcM508Xjffqq7G5KWU4NDQ      

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [kentucky_warn_processed] (
   [Date Received] TEXT,
   [Region] TEXT,
   [County] TEXT,
   [Company Name] TEXT,
   [Company Name_processed] TEXT,
   [Company_name_detail_processed] TEXT,
   [NAICS Code] TEXT,
   [Employees] INTEGER,
   [Closure or Layoff?] TEXT,
   [Projected Date] TEXT,
   [Trade] TEXT,
   [Notice URL] TEXT,
   [Notes_processed] TEXT,
   [Multiple_locations] TEXT,
   [] TEXT
);