COVID_WARN_Notices
Data source: Big Local News · About: big-local-datasette
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
922 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_raw
, Employer Name, City, Zip, LWIB Area, Notice Date, URL, Affected Employees
527 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
10,033 rows
delaware_warn_raw
, Employer Name, City, Zip, LWIB Area, Notice Date, URL, Affected Employees
70 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
107 rows
florida_warn_raw
Company Name, State Notification Date, Layoff Date, Employees Affected, Industry, Attachment
2,012 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
824 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
maryland_warn_raw
Notice Date, NAICS Code, Company, Location, WIA Code, Total Employees, Effective Date, Type Code
505 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
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,268 rows
northcarolina_warn_processed
County/Parish, WARN No., Notice Date, Received Date, Effective Date, Company, Layoff/Closure, No. Of Employees, Address...
563 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
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
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,098 rows
wisconsin_warn_raw
Company, City, AffectedWorkers, NoticeRcvd, NoticeType, LayoffBeginDate, NAICSDescription, County, WDA
536 rows
Download SQLite DB: COVID_WARN_Notices.db 36.6 MB