amendment

amended

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

amendment

Sequence number of this version within the chain (0 = original).

beginDate

Start of the fiscal year covered.

endDate

End of the fiscal year covered.

filing_url

URL to this version's report.

formFiled

Form type — "LM-30".

receiveDate

Date OLMS received this version.

rptId

OLMS report ID of this version. Primary key.

srFilerId

Foreign key to filer.srFilerId.

unionCity

City of that labor organization.

unionName

Labor organization named on this version.

unionState

State of that labor organization.

yrCovered

Year covered (shared across the chain).

6,729 rows

✎ View and edit SQL

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

Next page

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