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

Labor relation consultants hired by employers to oppose a union drive are required to file reports about their activities to the Department of Labor. These forms are called LM20 and LM21.

This data is gathered nightly from the Office of Labor-Management Standards's Online Public Disclosure Room

Data source: OLMS website, scraped

Custom SQL query

Tables

attachment

rptId, attachment_id, filename, file_description, file_urls

664 rows

contact

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

5,514 rows

employer

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

12,092 rows

filer

srNum, companyName, companyCity, companyState, srFilerId

717 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

10,644 rows

individual_disbursements

expense, name, salary, total, rptId, disbursement_order

284 rows

lm20

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

2,460 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

297 rows

performer

rptId, specific_activity_id, performer_order, city, name, organization, po_box,_bldg,_room_no,_if_any, state, street, zip

3,445 rows

receipts

rptId, receipt_number, amount, city, employer, mailing_address, name, non-cash_payment, po_box,_bldg,_room_no,_if_any, state, street, termination_date, title, trade_name, type_of_payment, zip_code

858 rows

signatures

rptId, signature_number, date, signed, telephone, telephone_number, title

5,514 rows

specific_activity

id, rptId, activity_order, specific_extent_of_performance, specific_nature_of_activity, specific_period_of_performance, specific_subject_employees, specific_subject_labor_orgs

2,513 rows

... and 2 hidden tables

Download SQLite DB: lm20.db 6.5 MB