COVID_WARN_Notices

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

Custom SQL query

Alaska_warn_raw

Company Name, Location, Notice Date, Layoff Date, Employees Affected, Notes

82 rows

Colorado_warn_raw

Company Name, Layoff Total, Workforce Local Area, WARN Date, Reason for Layoff, WARN Letter, Occupations, Layoff Date(s),

392 rows

Connecticut_warn_raw

WARN_Date, WARN_DATE_Received_processedbybln, Name_of_Affected Company * = layoffs due to the Coronavirus, Location_ of_Layoffs, Number_Affected_Workers, Date_of_Layoffs, Closing, Date_of_Closing, Union...

266 rows

Idaho_warn_raw

Date_letter, Company, Company_address, , City, State, Zip, No_employees, Effective_date...

152 rows

Illinois_warn_raw

COMPANY NAME:, DBA, COMPANY ADDRESS:, CITY, STATE, ZIP:, COMPANY CONTACT:, TELEPHONE:, UNION:, BUMPING RIGHTS:, LOCAL WORKFORCE AREA:...

191 rows

Iowa_warn_raw

Company, Address Line 1, City, County, St., ZIP, Notice Type, Emp #, Notice Date...

352 rows

alabama_warn_raw

Closing or Layoff, Initial Report Date, Planned Starting Date, Company, City, Planned # Affected Employees

910 rows

alaska_warn_processed

Company Name, Location, Location_Processed, Notice Date, Layoff Date_raw, Layoff Date_processed, Employees Affected_raw, Employees Affected_processed, Notes...

46 rows

arizona_warn_processed

Employer, City, Zip, Zip_processed, LWIB Area, Notice Date

400 rows

arizona_warn_raw

, Employer Name, City, Zip, LWIB Area, Notice Date, URL, Affected Employees

524 rows

california_warn_expanded_2020-03-16

name, address, city, num_employees_affected, layoff_date, union, union_rep_info, local_workforce_investment_area, date_notice_received...

5,450 rows

california_warn_raw

Notice Date, Effective Date, Received Date, Company, City, County, Employees, Layoff/Closure

9,629 rows

delaware_warn_raw

, Employer Name, City, Zip, LWIB Area, Notice Date, URL, Affected Employees

68 rows

districtcolumbia_warn_processed

Notice Date, Notice Date_processed, Organization Name, Number of Employees Affected, Effective Layoff Date, Effective Layoff Date_processed, CodeType, Notes

63 rows

districtcolumbia_warn_raw

Notice Date, Organization Name, Number of Employees Affected, Effective Layoff Date, CodeType

106 rows

florida_warn_raw

Company Name, State Notification Date, Layoff Date, Employees Affected, Industry, Attachment

1,808 rows

georgia_warn_raw

ID, Layoff_Code_processedBLN, Company name, City, ZIP, County, State, Est. Impact, LWDA...

3,252 rows

indiana_warn_processed

Company, Company_processed, City, City_Processed, State_processed, Affected Workers, Notice Date, LO/CL Date, NAICS...

752 rows

indiana_warn_raw

Company, City, Affected Workers, Notice Date, LO/CL Date, NAICS, Description of work, Notice Type

816 rows

kansas_warn_raw

, Employer Name, City, Zip, LWIB Area, Notice Date, URL, Affected Employees

837 rows

kentucky_warn_1998-2016_processed

Workforce Area, County, Company Name, Company Address (Location 99-xx), NAICS (SIC in years 98-xx), Employees, Employees_range_low_processed, Employes_range_high_processed, Closure/Layoff...

1,048,546 rows

kentucky_warn_processed

Date Received, Region, County, Company Name, Company Name_processed, Company_name_detail_processed, NAICS Code, Employees, Closure or Layoff?...

966 rows

louisiana_warn_processed

Company_raw, Company_processed, Notice_date_raw, Notice_date_processed, Layoff_date_raw, Layoff_date_processed, Employees_affected_raw, Employees_affected_processed, Industry...

408 rows

louisiana_warn_raw

Company, Notice, Layoff, Employees, Industry, Notes_processed

411 rows

maryland_warn_raw

Notice Date, NAICS Code, Company, Location, WIA Code, Total Employees, Effective Date, Type Code

852 rows

michigan_warn_raw

Date Notice Posted, Company, Closure Type, City, County, Number Affected

556 rows

missouri_warn_raw

DATE RECEIVED, COMPANY NAME, LOCATION, COUNTY, REGION, TYPE, LAYOFF DATE, # AFFECTED

273 rows

montana_warn_raw

Year, Date of Notice, Name of Company, County, Industry, Date of Impact, Number of Employees Affected

20 rows

nebraska_warn_raw

, Date, Company, Jobs Affected, City, Location, Type

1,029 rows

newjersey_warn_raw

COMPANY, CITY, EFFECTIVEDATE, WORKFORCEAFFECTED

350 rows

newmexico_warn_raw

Notice Date, Job Site Name, County, WDA Name, Total Layoff Number, Layoff Date, Received Date, City Name

51 rows

newyork_warn_raw

, notice_title, URL, Date of Notice, Event Number, Rapid Response Specialist, Reason Stated for Filing, Company, County...

4,166 rows

northcarolina_warn_processed

County/Parish, WARN No., Notice Date, Received Date, Effective Date, Company, Layoff/Closure, No. Of Employees, Address...

563 rows

ohio_warn_raw

DateReceived, Company, City/County, Potential NumberAffected, LayoffDate(s), PhoneNumber, Union, Notice ID

372 rows

oklahoma_warn_raw

Employer Name, City, Zip, LWIB Area, Notice Date, URL, Affected Employees

468 rows

oregon_warn_raw

Track #, Notification Date, Layoff Type, Count, Employer, City, Notice

919 rows

pennsylvania_warn_raw

Company, City, County, # Affected, Effective Date, Closing or Layoff

1,272 rows

rhodeisland_warn_raw

WARN Date, Date Received, Company Name, Location Of Layoffs, Number Affected, Effective Date, Closing Yes/No, Union Yes/No, Union Address

86 rows

southdakota_warn_raw

Company, Location, Date, Employees Affected

53 rows

tennessee_warn_raw

Date Notice Posted, Company, County, Affected Workers, Closure/Layoff Date, Notice/Type

354 rows

texas_warn_raw

NOTICE_DATE, JOB_SITE_NAME, COUNTY_NAME, WDA_NAME, TOTAL_LAYOFF_NUMBER, LayOff_Date, WFDD_RECEIVED_DATE, CITY_NAME

1,874 rows

utah_warn_raw

Date of Notice, Company Name, Location, Affected Workers

182 rows

virginia_warn

Company Name, Company Address, Company Address - 2, City/Town, State, Zip, Contact, Contact Phone Number, Ext...

677 rows

washington_warn_raw

Company, Location, Layoff Start Date, # of Workers, Closure Layoff, Type of Layoff, Received Date

1,078 rows

wisconsin_warn_raw

Company, City, AffectedWorkers, NoticeRcvd, NoticeType, LayoffBeginDate, NAICSDescription, County, WDA

529 rows

Download SQLite DB: COVID_WARN_Notices.db 36.4 MB