filing

amended

Whether this filing is an amendment ("Y"/"N").

amendment

Sequence number of the amendment, when applicable.

beginDate

Start of the fiscal year covered (ISO 8601, YYYY-MM-DD).

endDate

End of the fiscal year covered.

file_checksum

Reserved for a cached report document's checksum.

file_path

Reserved for a cached report document (not yet archived).

file_status

Reserved for the report-fetch status.

filing_url

URL to the report on the OLMS public disclosure site.

formFiled

Form type — always "LM-30".

receiveDate

Date OLMS received the filing.

registerDate

Date OLMS registered the filing in its system.

rptId

OLMS report ID. Primary key.

srFilerId

Foreign key to filer.srFilerId.

unionCity

City of that labor organization.

unionName

Labor organization named on the filing (denormalized from filer).

unionState

State of that labor organization.

yrCovered

Year covered by the report.

32,314 rows

✎ View and edit SQL

Suggested facets: amended, amendment, yrCovered, beginDate (date), endDate (date), receiveDate (date), registerDate (date)

Next page

CREATE TABLE filing(rptId BIGINT, srFilerId BIGINT, amended VARCHAR, amendment BIGINT, beginDate DATE, endDate DATE, receiveDate DATE, registerDate DATE, formFiled VARCHAR, yrCovered BIGINT, unionName VARCHAR, unionCity VARCHAR, unionState VARCHAR, filing_url VARCHAR, file_path VARCHAR, file_checksum VARCHAR, file_status VARCHAR, PRIMARY KEY(rptId), FOREIGN KEY (srFilerId) REFERENCES filer(srFilerId));