lm10

Employers must file Form LM-10 annual reports to disclose financial dealings with a union or officer or with a labor relation consultant.

Data source: OLMS website, scraped

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

9,949 rows

counterparty_contact

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

5,298 rows

counterparty_organization

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

9,949 rows

expenditure

amount, date, kind, activity_id

27,682 rows

filer

filerType, srFilerId, srNum, companyName, companyCity, companyState

5,550 rows

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

13,708 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

1,912 rows