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
Table schema
CREATE TABLE "amendment" (
[rptId] INTEGER PRIMARY KEY,
[srFilerId] INTEGER REFERENCES [filer]([srFilerId]),
[yrCovered] INTEGER,
[amendment] INTEGER,
[amended] TEXT,
[beginDate] TEXT,
[endDate] TEXT,
[receiveDate] TEXT,
[formFiled] TEXT,
[unionName] TEXT,
[unionCity] TEXT,
[unionState] TEXT,
[filing_url] TEXT
);
CREATE INDEX [idx_amendment_srFilerId]
ON [amendment] ([srFilerId]);