Collective Bargaining Notice (F-7) Data since 1997

Notices to Mediation Agencies (Form F-7) filed with the Federal Mediation and Conciliation Service. Under Section 8(d) of the National Labor Relations Act, parties to an expiring private-sector collective-bargaining agreement must notify FMCS at least 30 days before the contract ends (60 days for healthcare establishments); newly-formed bargaining relationships also file an Initial Contract notice. Each row is one notice — naming the employer, the union, the bargaining unit's affected location and size, the industry (NAICS), and the type of notice (Renegotiation, Reopener, Initial Contract, etc.).

Data scraped nightly from the FMCS website. FMCS itself only refreshes its data monthly, so a 1–4 week lag is expected. Some legacy rows have unreliable date fields — see column descriptions.

Data source: Federal Mediation and Conciliation Service, scraped

Custom SQL query

Tables schema

f7

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

524,616 rows

... and 6 hidden tables

Download SQLite DB: f7.db 192.7 MB