california_warn_expanded_2020-03-16: 2875

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
2875 Oracle America, Inc. ['10 and 12 Twin Dolphin Drive', '100, 200, 300, 350, 400, 500, 600 Oracle Parkway, 401 & 501 Island Parkway', 'Redwood City', ', CA', ' 94065'] Redwood City 255 5/21/19 Employer did not State   NOVA Consortium (North Santa Clara), Employment De 3/22/19 Layoff Employer did not State Employer did not State {'Applications Developer 2': 1, 'Applications Developer 3': 4, 'Applications Developer 4': 3, 'Applications Developer 5': 5, 'Business Analyst 2-Ops': 1, 'Business Analyst 4-Ops': 3, 'Data Scientist 4': 1, 'Graphics Designer 3-Mkt': 3, 'IT Business Implementation Analyst 3': 1, 'IT Manager': 3, 'IT Security Analyst 4': 1, 'IT Snr Director': 1, 'IT Snr Manager': 2, 'Market Research Analyst 2': 1, 'Market Research Analyst 4': 2, 'Marketing Comm / PR Manager': 1, 'Marketing Comm / PR Specialist 2': 1, 'Marketing Comm / PR Specialist 3': 5, 'Marketing Comm / PR Specialist 4': 7, 'Marketing Comm / PR Specialist 5': 3, 'Marketing Research Director': 1, 'Marketing Research Manager': 1, 'Marketing Research Snr Manager': 2, 'Product Manager/Strategy 3-ProdDev': 2, 'Product Manager/Strategy 4-ProdDev': 9, 'Product Manager/Strategy 5-ProdDev': 4, 'Product Marketing Analyst 3': 2, 'Product Marketing Analyst 4': 2, 'Product Marketing Analyst 5': 1, 'Product Mgmt/Strategy Director-ProdDev': 7, 'Product Mgmt/Strategy Snr Director-ProdDev': 5, 'Product Mgmt/Strategy Snr Manager-ProdDev': 5, 'Product Mgmt/Strategy VP-ProdDev': 2, 'Program Manager 2-ProdDev': 1, 'Program Manager 5-ProdDev': 2, 'Program Mgmt Sr Director-ProdDev': 2, 'Programmer Analyst 3-IT': 6, 'Programmer Analyst 4-IT': 4, 'Project Manager 2': 1, 'Project Manager 3 - Ops': 2, 'Project Manager 4': 1, 'Project Manager 4 - Ops': 2, 'QA Analyst 3-ProdDev': 2, 'QA Analyst 4-ProdDev': 3, 'QA Analyst 5-ProdDev': 1, 'QA Director-ProdDev': 1, 'QA Snr Manager-ProdDev': 2, 'Software Developer - Architect': 2, 'Software Developer 1': 1, 'Software Developer 2': 7, None: None}