Filings for Employers who hire Labor Relation Consultants or Pay Labor Officials

Annual reports filed by employers under Section 203(a) of the Labor-Management Reporting and Disclosure Act, disclosing financial dealings that bear on labor relations:

  • 8.a — Payments to a labor organization or its officers/agents
  • 8.b — Payments to employees to persuade other employees about organizing or bargaining
  • 8.c — Expenditures meant to interfere with, restrain, or coerce employees in their organizing rights
  • 8.d — Expenditures to gather information on employees' or unions' activities in a labor dispute
  • 8.e — Agreements with labor-relations consultants for anti-union persuasion activities (the employer-side counterpart to the consultant's LM-20 filing)
  • 8.f — Agreements with consultants for information-gathering on labor activities

Form LM-10 is filed by the employer; the matched LM-20 is filed by the consultant. Joining the two via the employer name and approximate dates is the standard analytical workflow.

The data is scraped nightly from the OLMS Online Public Disclosure Room. Organized around a central filing table keyed by rptId; activities are in activity keyed by id with counterparty, contact, and expenditure detail in joined tables.

Data source: OLMS website, scraped

Custom SQL query

Tables

activity

id, 12b_exists, activity_code, activity_type, agencies, counterparty_position, date_of_agreement, explanation, federal_work, form_agreement, no_uei_checkbox, uei, unlisted_agencies, rptId

15,064 rows

counterparty_contact

city, name, po_box,_bldg,_room_no,_if_any, state, street, zip_code_+_4, activity_id

8,459 rows

counterparty_organization

city, organization, po_box,_bldg,_room_no,_if_any, state, street, zip_code_+_4, activity_id

15,064 rows

expenditure

amount, date, kind, activity_id

41,791 rows

filer

filerType, srFilerId, srNum, companyName, companyCity, companyState

5,902 rows

filing

address1, address2, amended, amendment, beginDate, city, empLabOrg, empTrdName, endDate, file_checksum, file_path, file_status, filing_url, formFiled, formLink, oID, paperOrElect, promiseDate, receiveDate, registerDate, repOrgsCnt, rptId, srFilerId, srNum, state, subLabOrg1, subLabOrg2, yrCovered, zip

14,618 rows

lm10

rptId, file_number, formFiled, period_begin, period_through, type_of_organization, records_hosted_at_other_address, records_hosted_with_principal_officer, records_hosted_with_reporting_employer

2,822 rows

organization

promiseDate, oID, rptId, empLabOrg, city, state

33,929 rows

other_address

rptId, city, name, organization, po_box,_bldg,_room_no,_if_any, state, street, title, zip_code_+_4

678 rows

principal_officer

rptId, city, name, po_box,_bldg,_room_no,_if_any, state, street, zip_code_+_4

2,190 rows

reportable_activity

rptId, answer, code, n_responses, question

16,932 rows

reporting_employer

rptId, attention_to, city, employer, po_box,_bldg,_room_no,_if_any, state, street, title, trade_name, zip_code_+_4

2,822 rows

signature

rptId, on_date, signed, telephone_number, title

5,644 rows

... and 1 hidden table

Database schema

Download SQLite DB: lm10.db 24.3 MB