california_warn_expanded_2020-03-16: 3936

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.

This data as json, copyable

rowid	name	address	city	num_employees_affected	layoff_date	union	union_rep_info	local_workforce_investment_area	date_notice_received	layoff_or_closure	severance	bumping_rights	jobs
3936	McKesson Corporation	['One Post Street', ' San Francisco', ', CA', ' 94104']	San Francisco	329	1/1/20	No		Office of Economic and Workforce Development SF	11/7/19	Closure	Employer did not State	No	{'Admin Assistant I': 1, 'Admin Assistant Ill': 3, 'Administrative Assistant 6': 1, 'Associate Legal Specialist': 1, 'Associate Network Systems Engineer': 1, 'Associate Project Manager': 1, 'Associate Systems Engineer': 1, 'Business Intelligence Analyst': 3, 'Business Process Consultant': 1, 'Business Process Consultant 4': 1, 'Category Manager': 1, 'CDC Sr. Manager, Customer Service': 1, 'CEO, McKesson Europe': 1, 'Chief Counsel': 1, 'Communications Specialist': 2, 'Counsel': 1, 'Data Scientist': 1, 'Director, Accounting': 6, 'Director, Business Development': 2, 'Director, Business Intelligence': 2, 'Director, Business Operations': 1, 'Director, Category Management': 1, 'Director, Communications': 1, 'Director, Compliance & Ethics': 1, 'Director, Contract Administration': 1, 'Director, Events Planning': 2, 'Director, FP&A': 3, 'Director, HR Business Partner': 1, 'Director, HRIS': 1, 'Director, Legal Operations': 2, 'Director, Marketing': 8, 'Director, Product Management': 1, 'Director, Product Portfolio Management': 1, 'Director, Project Management': 1, 'Director, Stock Plan Administration': 1, 'Director, Systems': 8, 'Event Planner': 3, 'Executive Assistant I': 4, 'Financial Analyst': 2, 'Government Relations Specialist': 1, 'Graphic Designer': 1, 'IT Architect': 5, 'Lead Accountant': 9, 'Lead Business Developer': 3, 'Lead Business Intelligence Analyst': 1, 'Lead Business Systems Analyst': 2, 'Lead Data Architect': 1, 'Lead Financial Analyst': 1, 'Lead Information Security Analyst': 3, 'Lead IT Architect': 4, 'Lead IT Project Manager': 1, 'Lead Legal Specialist': 1, 'Lead M&A Analyst': 2, 'Lead Marketing Specialist': 2, 'Lead Pricing Analyst': 1, 'Lead Product Support Rep': 1, 'Lead Software Developer': 1, 'Lead Software Engineer': 2, 'Lead Strategy Analyst': 1, 'Lead Systems Engineer': 5, 'Lead Tax Accountant': 3, 'Lead Treasury Analyst': 1, 'Legal Operations Specialist': 1, 'Legal Specialist': 4, 'Manager, Benefits': 1, 'Manager, Communications': 3, 'Manager, Community Relations': 2, 'Manager, Marketing': 1, 'Managing Chief Counsel': 2, 'Managing Counsel': 3, 'Marketing Coordinator': 1, 'Marketing Management 5': 1, 'Marketing Specialist': 4, 'Principal Business Developer': 1, 'Principal Financial Analyst': 1, 'Principal IT Architect': 2, 'Principal IT Generalist': 1, 'Principal M&A Analyst': 1, 'Principal Product Portfolio Manager': 1, 'Privacy Specialist': 1, 'Product Manager': 1, 'Product Portfolio Manager': 3, 'Project Manager': 3, 'Risk Management Analyst': 1, 'Scrum Master': 1, 'Software Developer': 4, 'Software Engineer': 12, 'Specialist, Client Management': 1, 'Sr. Accountant': 2, 'Sr. Admin Assistant': 10, 'Sr. Associate Business Intelligence Analyst': 1, 'Sr. Associate Event Planner': 1, 'Sr. Associate Financial Analyst': 2, 'Sr. Associate Global Security Specialist': 1, 'Sr. Associate Information Security Analyst': 1, 'Sr. Associate M&A Analyst': 1, 'Sr. Associate Marketing Specialist': 1, 'Sr. Associate Product Portfolio Manager': 1, 'Sr. Associate Project Manager': 1, 'Sr. Associate Software Developer': 2, 'Sr. Auditor': 1, 'Sr. Benefits Analyst': 3, 'Sr. Business Developer': 2, 'Sr. Business Intelligence Analyst': 3, 'Sr. Category Manager': 4, 'Sr. Clinical Programs Analyst': 1, 'Sr. Communications Associate': 1, 'Sr. Communications Specialist': 2, 'Sr. Community Relations Associate': 1, 'Sr. Compensation Analyst': 1, 'Sr. Compensation Consultant': 1, 'Sr. Contracts Administrator': 2, 'Sr. Director, Accounting': 2, 'Sr. Director, Benefits': 1, 'Sr. Director, Business Development': 6, 'Sr. Director, Business Intelligence': 1, 'Sr. Director, Business Operations': 1, 'Sr. Director, Category Management': 1, 'Sr. Director, Client Relationship': 1, 'Sr. Director, Community Relations': 1, 'Sr. Director, Compensation': 1, 'Sr. Director, FP&A': 1, 'Sr. Director, HR Business Partner': 1, 'Sr. Director, Information Security': 1, 'Sr. Director, Legal Operations': 1, 'Sr. Director, Marketing': 5, 'Sr. Director, Organizational Development': 1, 'Sr. Director, Payroll': 1, 'Sr. Director, Pricing': 1, 'Sr. Director, Product Portfolio Management': 2, 'Sr. Director, Real Estate': 1, 'Sr. Director, Risk Management': 1, 'Sr. Director, Systems': 5, 'Sr. Director, Tax Accounting': 1, 'Sr. Director, Treasury': 1, 'Sr. Event Planner': 2, 'Sr. Executive Assistant': 2, 'Sr. Financial Analyst': 4, 'Sr. Government Relations Specialist': 2, 'Sr. Information Security Analyst': 3, 'Sr. IT Architect': 3, 'Sr. IT Generalist': 1, 'Sr. Legal Operations Associate': 1, 'Sr. Legal Operations Specialist': 1, 'Sr. Legal Specialist': 3, 'Sr. Manager, Client Relationship': 1, 'Sr. Manager, Contract Administration': 1, 'Sr. Manager, Events Planning': 1, 'Sr. Manager, FP&A': 2, 'Sr. Manager, Information Security': 1, 'Sr. Manager, Legal Operations': 1, 'Sr. Manager, Project Management': 1, 'Sr. Manager, Regulatory Affairs': 1, 'Sr. Manager, Systems': 1, 'Sr. Marketing Specialist': 11, 'Sr. Product Manager': 3, 'Sr. Product Portfolio Manager': 4, 'Sr. Project Manager': 1, 'Sr. Scrum Master': 4, 'Sr. Software Developer': 7, 'Sr. Software Engineer': 6, 'Sr. Specialist, Client Management': 1, 'Sr. Stock Plan Administrator': 1, 'Sr. Strategy Analyst': 4, 'Sr. Systems Engineer': 1, 'Sr. Tax Accountant': 2, 'Sr. Web Site Admin': 1, 'Stock Plan Administrator': 1, 'Strategy Analyst': 3, 'SVP, CFO - 510757': 1, 'SVP, Internal Audit': 1, 'SVP, Marketing - 290011': 1, 'SVP, National Accounts - 510777': 1, 'SVP, Procurement - 510764': 1, 'SVP, Talent Management': 1, 'SVP, Treasurer': 1, 'Talent Acquisition Coordinator': 1, 'Vice President, Accounting': 2, 'Vice President, Benefits': 1, 'Vice President, Business Operations': 2, 'Vice President, Communications': 2, 'Vice President, Community Relations': 1, 'Vice President, Contract Administration': 1, 'Vice President, FP&A': 1, 'Vice President, HR Business Partner': 2, 'Vice President, Marketing': 4, 'Vice President, Project Management': 2, 'Vice President, Strategy': 1, 'Vice President, Systems': 2, 'Vice President, Treasury': 2, 'VP, Assistant General Counsel - 275576': 1, 'VP, CFO - 290071': 1, 'VP, Compliance': 1, 'VP, Corporate Marketing & Communications': 1, 'VP, GM - 300030': 1, 'VP, Human Resources - 510760': 1, 'VP, Investor Relations': 1, 'VP, Procurement - 300291': 1, 'VP, Technology- 510779': 1, None: None}