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
Suggested facets: yrCovered, amendment, amended, beginDate, endDate, beginDate (date), endDate (date), receiveDate (date)
Table schema
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));