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,023 rows

counterparty_contact

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

8,418 rows

counterparty_organization

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

15,023 rows

expenditure

amount, date, kind, activity_id

41,559 rows

filer

filerType, srFilerId, srNum, companyName, companyCity, companyState

5,901 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,614 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,818 rows

organization

promiseDate, oID, rptId, empLabOrg, city, state

33,888 rows

other_address

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

670 rows

principal_officer

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

2,187 rows

raw_activity

rptId, 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

1 row

raw_counterparty_contact

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

1 row

raw_counterparty_organization

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

1 row

raw_expenditure

rptId, activity_id, order, amount, date, kind

2 rows

raw_filer

filerType, srFilerId, srNum, companyName, companyCity, companyState

5,900 rows

raw_filing

_key, 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

1 row

raw_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

1 row

raw_organization

promiseDate, oID, rptId, empLabOrg, city, state

1 row

raw_other_address

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

1 row

raw_principal_officer

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

1 row

raw_reportable_activity

rptId, _key, answer, code, n_responses, question

6 rows

raw_reporting_employer

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

1 row

raw_signature

rptId, _key, on_date, signed, telephone_number, title

2 rows

reportable_activity

rptId, answer, code, n_responses, question

16,908 rows

reporting_employer

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

2,818 rows

signature

rptId, on_date, signed, telephone_number, title

5,636 rows

... and 1 hidden table

Database schema

Download SQLite DB: lm10.db 24.7 MB