home / f7

Schema for f7

CREATE TABLE f7(notice_date VARCHAR, initiated_date DATE, employer VARCHAR, employer_street VARCHAR, employer_city VARCHAR, employer_state VARCHAR, employer_zip VARCHAR, employer_representative VARCHAR, employer_representative_phone VARCHAR, employer_representative_title VARCHAR, employer_representative_email VARCHAR, union_name VARCHAR, union_street VARCHAR, union_city VARCHAR, union_state VARCHAR, union_zip VARCHAR, union_representative VARCHAR, union_representative_phone VARCHAR, union_representative_title VARCHAR, union_representative_email VARCHAR, affected_location_city VARCHAR, affected_location_state VARCHAR, affected_location_zip VARCHAR, expiration_date DATE, naics BIGINT, industry VARCHAR, bargaining_unit_size BIGINT, establishment_size BIGINT, notice_submitted_by VARCHAR, category VARCHAR, healthcare_related BIGINT, location_negotiation_city VARCHAR, location_negotiation_state VARCHAR, location_negotiation_zip VARCHAR);

A project of Forest Gregg. Read about project updates on Notes on Labor Data.