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,311 rows

✎ View and edit SQL

Next page

CREATE TABLE "filing" (
   [rptId] INTEGER PRIMARY KEY,
   [srFilerId] INTEGER REFERENCES [filer]([srFilerId]),
   [amended] TEXT,
   [amendment] INTEGER,
   [beginDate] TEXT,
   [endDate] TEXT,
   [receiveDate] TEXT,
   [registerDate] TEXT,
   [formFiled] TEXT,
   [yrCovered] INTEGER,
   [unionName] TEXT,
   [unionCity] TEXT,
   [unionState] TEXT,
   [filing_url] TEXT,
   [file_path] TEXT,
   [file_checksum] TEXT,
   [file_status] TEXT
);
CREATE INDEX [idx_filing_srFilerId]
    ON [filing] ([srFilerId]);