Filings for Employers who hire Labor Relation Consultants or Pay Labor Officials
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
10,377 rows
counterparty_contact
city, name, po_box,_bldg,_room_no,_if_any, state, street, zip_code_+_4, activity_id
5,519 rows
counterparty_organization
city, organization, po_box,_bldg,_room_no,_if_any, state, street, zip_code_+_4, activity_id
10,377 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
13,820 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,024 rows
other_address
rptId, city, name, organization, po_box,_bldg,_room_no,_if_any, state, street, title, zip_code_+_4
389 rows
principal_officer
rptId, city, name, po_box,_bldg,_room_no,_if_any, state, street, zip_code_+_4
1,545 rows
reporting_employer
rptId, attention_to, city, employer, po_box,_bldg,_room_no,_if_any, state, street, title, trade_name, zip_code_+_4
2,024 rows
... and 2 hidden tables
Download SQLite DB: lm10.db 17.3 MB