Collective Bargaining Notice (F-7) Data since 1997

Daily refreshed data on bargaining notices from fmcs.gov. Data is updated nightly at about 10:00 pm Eastern, though the FMCS ony updates their data monthly.

Data source: Federal Mediation and Conciliation Service, scraped

Custom SQL query

Tables

f7

id, notice_date, initiated_date, employer, employer_street, employer_city, employer_state, employer_zip, employer_representative, employer_representative_phone, employer_representative_title, employer_representative_email, union_name, union_street, union_city, union_state, union_zip, union_representative, union_representative_phone, union_representative_title, union_representative_email, affected_location_city, affected_location_state, affected_location_zip, expiration_date, naics, industry, bargaining_unit_size, establishment_size, notice_submitted_by, category, healthcare_related, location_negotiation_city, location_negotiation_state, location_negotiation_zip

549,553 rows

... and 7 hidden tables

Download SQLite DB: f7.db 202.3 MB