louisiana_warn_processed
Data source: Big Local News · About: big-local-datasette
8 rows where State_processed = "TX"
This data as json, copyable, CSV (advanced)
Suggested facets: Company_processed, Industry, PlaceName_processed, ZipCode_processed
Link | rowid ▼ | Company_raw | Company_processed | Notice_date_raw | Notice_date_processed | Layoff_date_raw | Layoff_date_processed | Employees_affected_raw | Employees_affected_processed | Industry | PlaceName_processed | State_processed | ZipCode_processed | Notes_BLN | Multiple_locations_flag_BLN | Rescinded/Exclude_processed |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14 | 14 | Aegis Mortgage Corporation 3250 Briarpark, Suite 400 Houston, TX 77042 | Aegis Mortgage Corporation | 8/7/07 | 8/7/07 | 10/31/07 | 10/31/07 | 45 | 45 | Sales Financing | Houston | TX | 77042 | |||
51 | 51 | Pride Offshore Inc. 5847 San Felipe Houston, TX 77057 | Pride Offshore Inc. | 2/19/09 | 2/19/09 | 3/1/09 | 3/1/09 | 115 | 115 | Drilling Oil and GasWells | San Felipe Houston | TX | 77057 | |||
84 | 84 | Crossmark Home Improvement Services 5100 Legacy Drive Plano, TX 75024 | Crossmark Home Improvement | 8/27/09 | 8/27/09 | 10/31/09 | 10/31/09 | 1021 | 1021 | Wholesale Trade Agentsand Brokers | Plano | TX | 75024 | |||
245 | 245 | Hercules Offshore 9 Greenway Plaza Ste 2200, Houston Tx 77056 | Hercules Offshore | 11/5/14 | 11/5/14 | 12/31/14 | 12/31/14 | 450 | 450 | Drilling Oil & Gas Wells Alexandria, LA 71306 | Houston | TX | 77056 | |||
254 | 254 | Wingspan Portfolio Advisors,Inc. 4100 Midway, Suite 1110 Carrollton, TX 75007 | Wingspan Portfolio Advisors | 3/3/15 | 3/3/15 | 4/30/15 | 4/30/15 | 193 | 193 | Telephone SolicitationServices | Carrollton | TX | 75007 | |||
270 | 270 | Hercules Offshore 9 Greenway Plaza, Suite 2200 Houston, TX 77056 | Hercules Offshore | 9/22/15 | 9/22/15 | 11/21/15 | 11/21/15 | 50 | 50 | Oilfield | Houston | TX | 77056 | |||
279 | 279 | Noble Drilling, LLC 13135 S. Dairy Ashford, Suite 800 Sugarland TX 77478 | Noble Drilling | 11/25/15 | 11/25/15 | 1/26/15 | 1/26/15 | 130 | 130 | Oilfield | Sugarland | TX | 77478 | |||
330 | 330 | Rowan Companies 2800 Post Oak Blvd. Houston, TX 77056 Update: | Rowan Companies | 5/22/20176/20/2017 | 5/22/17 | 7/21/20178/21/2017 | 7/21/15 | 150+50 | 150 | Oil & Gas | Houston | TX | 77056 | Listed the earliest layoff date, unclear if this is a range for layoff time or an update to a new date., or an additional layoff as there were two numbers listed | Dates and numbers are ambiguous, recommend excluding or doing additioanll reporting |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [louisiana_warn_processed] ( [Company_raw] TEXT, [Company_processed] TEXT, [Notice_date_raw] TEXT, [Notice_date_processed] TEXT, [Layoff_date_raw] TEXT, [Layoff_date_processed] TEXT, [Employees_affected_raw] INTEGER, [Employees_affected_processed] INTEGER, [Industry] TEXT, [PlaceName_processed] TEXT, [State_processed] TEXT, [ZipCode_processed] INTEGER, [Notes_BLN] TEXT, [Multiple_locations_flag_BLN] TEXT, [Rescinded/Exclude_processed] TEXT );