lm_data

address_type

Address-type code (FK to ar_erds_codes); in this snapshot all rows are 201 = mailing address.

adr_id

Address record ID within OLMS.

aff_abbr

Affiliate/parent organization abbreviation (e.g. "AFL-CIO", "SEIU").

amended

Whether this filing is an amendment.

amendment

Amendment sequence number (0 for the original filing, 1 for the first amendment, etc.).

assets_pledged

Whether assets are pledged.

build_num

Building number portion of the union's mailing address.

city

City of the union's mailing address.

constitution_bylaw

Whether the union has a constitution and bylaws on file.

contingent

Whether there are contingent liabilities.

desig_name

Designation name.

desig_num

Designation number (the local's number).

desig_suf

Designation suffix.

desiq_pre

Designation prefix for the local (e.g. "Local", "Branch"). The "desiq" spelling (rather than "desig") is the column name as published by OLMS in their bulk-download column metadata, preserved as-is by the scraper.

est_date

Date the union was established.

f_num

OLMS file number identifying the union.

form_type

Form variant filed — "LM-2" (large unions, ≥$250k receipts), "LM-3" (medium), "LM-4" (small), or "LM-5" (terminal report filed when the union dissolves).

fye

Fiscal-year-end month (1–12). Foreign key to ar_erds_codes (code_type = "FYE_CODE").

hardship

Whether the union claimed financial hardship.

has_extended_loan_credit

Whether the union extended loan credit.

has_liquidated_liabilities

Whether liquidated liabilities are reported.

has_liquidated_receivables

Whether liquidated receivables are reported.

has_property_change

Whether there was a change in property.

has_subsidiary

Whether the union has a subsidiary organization (duplicate of subsidiary; OLMS form has two related fields).

has_trust

Whether the union has trust funds.

mail_firstname

First name on the union's mailing address.

mail_lastname

Last name on the union's mailing address.

maximum_bond

Maximum amount of the fidelity bond carried by the union.

members

Total membership count reported.

mod_date

Timestamp of the last modification to this filing's OLMS record.

mod_id

Numeric modification ID assigned by OLMS.

next_election

Date of the next scheduled officer election.

num_attachments

Number of attachments to the filing.

outside_audit

Whether the financials were audited by an outside auditor.

pac_funds

Whether the union has political action committee funds.

pd_covered_from

Start of the period covered by this filing (ISO 8601, YYYY-MM-DD).

pd_covered_to

End of the period covered by this filing.

receive_date

Date OLMS received the filing (timestamp with time component).

record_kept

Where the union's records are kept ("T" — at the union's address, "F" — at another address; blank when unspecified).

register_date

Date OLMS registered the filing.

rpt_id

OLMS report ID. Primary key.

shortage

Whether the filing notes a financial shortage.

state

Two-letter US Postal Service state abbreviation.

street_adr

Street address (street name and number combined or just street name when build_num is set separately).

subsidiary

Whether the union has a subsidiary organization.

term_date

Date the union terminated, if applicable.

terminate

Whether the union is being terminated.

ttl_assets

Total assets reported (dollars).

ttl_disbursements

Total disbursements reported (dollars).

ttl_liabilities

Total liabilities reported (dollars).

ttl_receipts

Total receipts reported (dollars).

union_name

Reporting union's name as it appears on the filing.

unit_name

Local or sub-unit name within the union.

voice

Phone number of the union.

yr_covered

Calendar year that the reporting period falls within (typically equals the year of pd_covered_to).

zip

ZIP code of the union's mailing address.

615,332 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE "lm_data" (
   [union_name] TEXT NOT NULL,
   [aff_abbr] TEXT NOT NULL,
   [f_num] INTEGER NOT NULL,
   [fye] INTEGER REFERENCES [ar_erds_codes]([code]),
   [unit_name] TEXT,
   [est_date] TEXT,
   [term_date] TEXT,
   [shortage] TEXT,
   [maximum_bond] INTEGER,
   [pd_covered_from] TEXT,
   [pd_covered_to] TEXT,
   [constitution_bylaw] TEXT,
   [terminate] TEXT,
   [ttl_assets] INTEGER,
   [subsidiary] TEXT,
   [desiq_pre] TEXT,
   [desig_num] INTEGER,
   [desig_suf] TEXT,
   [desig_name] TEXT,
   [ttl_liabilities] INTEGER,
   [ttl_receipts] INTEGER,
   [ttl_disbursements] INTEGER,
   [members] INTEGER,
   [register_date] TEXT,
   [amended] TEXT,
   [hardship] TEXT,
   [has_trust] TEXT,
   [pac_funds] TEXT,
   [outside_audit] TEXT,
   [has_property_change] TEXT,
   [assets_pledged] TEXT,
   [contingent] TEXT,
   [next_election] TEXT,
   [has_liquidated_liabilities] TEXT,
   [has_extended_loan_credit] TEXT,
   [has_liquidated_receivables] TEXT,
   [has_subsidiary] TEXT,
   [num_attachments] INTEGER,
   [rpt_id] INTEGER PRIMARY KEY NOT NULL,
   [yr_covered] INTEGER,
   [amendment] INTEGER NOT NULL,
   [receive_date] TEXT,
   [adr_id] INTEGER NOT NULL,
   [address_type] INTEGER NOT NULL REFERENCES [ar_erds_codes]([code]),
   [mail_firstname] TEXT,
   [mail_lastname] TEXT,
   [build_num] TEXT,
   [street_adr] TEXT,
   [city] TEXT,
   [state] TEXT,
   [zip] TEXT,
   [voice] TEXT,
   [mod_date] TEXT,
   [mod_id] INTEGER,
   [record_kept] TEXT,
   [form_type] TEXT NOT NULL
);