indiana_warn_processed
Data source: Big Local News · About: big-local-datasette
1 row where TAA Certification = "Certified 4/1/18"
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | Company | Company_processed | City | City_Processed | State_processed | Affected Workers | Notice Date | LO/CL Date | NAICS | Description of work | Notice Type | TAA Certification | Notes | Multiple_locations/statewide |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
564 | 564 | Sony DADC US Inc. | Sony DADC US Inc. | Terre Haute | Terre Haute | IN | 375 | 1/16/18 | 3/23/18 | 334614 | Software and Other Pre-recorded Compact Disc, Tape and Recording Reproducing | LO | Certified 4/1/18 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [indiana_warn_processed] ( [Company] TEXT, [Company_processed] TEXT, [City] TEXT, [City_Processed] TEXT, [State_processed] TEXT, [Affected Workers] TEXT, [Notice Date] TEXT, [LO/CL Date] TEXT, [NAICS] INTEGER, [Description of work] TEXT, [Notice Type] TEXT, [TAA Certification] TEXT, [Notes] TEXT, [Multiple_locations/statewide] TEXT );