Conflict-of-Interest Reports of Union Officers and Employees (Form LM-30)

Reports filed with the Department of Labor by union officers and employees who have a financial interest or dealing that could conflict with their duty to the members they represent. Under Section 202 of the Labor-Management Reporting and Disclosure Act, an officer or employee of a labor organization must file Form LM-30 for any fiscal year in which they (or a spouse or minor child) held or received:

  • Part A — an interest in, or income/payments from, an employer whose employees their union represents;
  • Part B — an interest in a business that deals with such an employer, with the union, or with a union trust;
  • Part C — payments from any other employer (or a labor-relations consultant) that would create a conflict.

The data is scraped nightly from the OLMS Online Public Disclosure Room. The filing table is the index of every filing (keyed by rptId); for filings whose report OLMS serves as HTML, the disclosure entries are parsed into represented_employer_interest, business_interest, and other_employer_payment, with the report's filer-and-union header in report_identity. Older filings are served as PDFs and have an index row only.

Data source: OLMS website, scraped

Custom SQL query

Tables

amendment

rptId, srFilerId, yrCovered, amendment, amended, beginDate, endDate, receiveDate, formFiled, unionName, unionCity, unionState, filing_url

6,729 rows

business_interest

rptId, entry_order, business_name, contact_name, telephone, street, city, state, zip, deals_with, deals_with_name, deals_with_contact_name, deals_with_telephone, deals_with_street, deals_with_city, deals_with_state, deals_with_zip, nature_of_dealings, value_of_dealings, nature_of_interest, amount_of_interest

4,379 rows

filer

srFilerId, srNum, name, suffix, city, state, affAbbr, unionName, unionCity, unionState, detailId

18,160 rows

filing

rptId, srFilerId, amended, amendment, beginDate, endDate, receiveDate, registerDate, formFiled, yrCovered, unionName, unionCity, unionState, filing_url, file_path, file_checksum, file_status

32,314 rows

other_employer_payment

rptId, entry_order, other_employer, contact_name, telephone, street, city, state, zip, entity_type, nature_of_payment, amount

414 rows

report_identity

rptId, filer_name, filer_street, filer_city, filer_state, filer_zip, filer_email, filer_role, filer_position_title, union_name, union_street, union_city, union_state, union_zip, union_file_number

3,135 rows

represented_employer_interest

rptId, entry_order, represented_employer, contact_name, telephone, street, city, state, zip, nature_of_interest, amount

850 rows

... and 1 hidden table

Database schema

Download SQLite DB: lm30.db 9.3 MB