Reports filed with the Department of Labor by "persuaders" — labor-relations consultants whom employers hire to dissuade workers from joining or supporting a union. Under Section 203 of the Labor-Management Reporting and Disclosure Act, persuaders must file two forms with the DOL Office of Labor-Management Standards:

LM-20 (Agreement and Activities Report) — within 30 days after entering into an agreement to perform persuader activities. Names the employer that hired them, the agreement terms, the people who will do the work, and the specific activities planned.
LM-21 (Receipts and Disbursements Report) — annually, reporting the persuader's receipts from clients and how the money was spent.

The data is scraped nightly from the OLMS Online Public Disclosure Room. Filings are organized around a central filing table keyed by rptId; related tables describe the employer that hired the persuader, the people performing the work, the specific activities described, and (for LM-21s) the persuader's financials.

Data source: OLMS website, scraped

Queries

New LM20 Filings

Tables

attachment

rptId, attachment_id, filename, file_description, file_urls

937 rows

contact

city, ein, name, organization, po_box,_bldg,_room_no,_if_any, state, street, title, zip_code, rptId, contact_type

7,770 rows

employer

rptId, empLabOrg, empTrdName, city, state, termDate, amount

13,535 rows

filer

srNum, companyName, companyCity, companyState, srFilerId

787 rows

filing

address1, address2, amended, amendment, beginDate, city, empLabOrg, endDate, file_checksum, file_path, file_status, filing_url, formFiled, originalRptId, paperOrElect, receiveDate, registerDate, repOrgsCnt, rptId, srFilerId, srNum, state, yrCovered, zip

11,772 rows

individual_disbursements

expense, name, salary, total, rptId, disbursement_order

350 rows

lm20

rptId, amended, date_fiscal_year_ends, direct, indirect, city, date_entered_into, ein, name, organization, po_box,_bldg,_room_no,_if_any, state, street, zip_code, notes, written_agreement, type_of_person

3,454 rows

lm21

rptId, fees_for_professional_services, loans_made, officer_and_administrative_expenses, other_disbursements, publicity, total_disbursements_(sum_of_items_8-13), total_disbursements_to_officers_and_employees, period_begin, period_through, Employer Name, Trade Name, If any, Amount, Purpose, City, Name, Organization, P.O. B, B, Room N, if any, Street, Title, ZIP code, total_disbursements

431 rows

... and 1 hidden table

Database schema

Download SQLite DB: lm20.db 8.9 MB

Filings for Activity of Labor Relations Consultants (Anti-union consultants)

Custom SQL query