filing

address1

Filer's mailing address line 1.

address2

Filer's mailing address line 2.

amended

Whether the filing is an amendment to a prior report ("Yes"/"No").

amendment

Sequence number of the amendment, when applicable.

beginDate

For LM-21, start of the reporting period (the persuader's fiscal year start).

city

Filer's city.

empLabOrg

Employer or labor organization named on the filing (denormalized from employer).

endDate

For LM-21, end of the reporting period.

file_checksum

Checksum of the cached file (for change detection).

file_path

Local path to the cached file in the scraper's storage layout.

file_status

Scraper status indicator for the file fetch.

filing_url

URL to the filing on the OLMS public disclosure site.

formFiled

Form type — "LM-20" or "LM-21".

originalRptId

rptId of the original filing that this report amends, when applicable.

paperOrElect

Whether the filing was submitted on paper or electronically ("Paper"/"Electronic").

receiveDate

Date OLMS received the filing (ISO 8601, YYYY-MM-DD).

registerDate

Date OLMS registered the filing in its system.

repOrgsCnt

Number of reporting organizations on the filing.

rptId

OLMS report ID. Primary key.

srFilerId

OLMS filer-system identifier (denormalized from filer).

srNum

Foreign key to filer.srNum (the persuader who filed).

state

Filer's state.

yrCovered

Year covered by the report.

zip

Filer's ZIP code.

11,772 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE "filing" (
   [address1] TEXT,
   [address2] TEXT,
   [amended] TEXT,
   [amendment] INTEGER,
   [beginDate] TEXT,
   [city] TEXT,
   [empLabOrg] TEXT,
   [endDate] TEXT,
   [file_checksum] TEXT,
   [file_path] TEXT,
   [file_status] TEXT,
   [filing_url] TEXT,
   [formFiled] TEXT,
   [originalRptId] INTEGER,
   [paperOrElect] TEXT,
   [receiveDate] TEXT,
   [registerDate] TEXT,
   [repOrgsCnt] INTEGER,
   [rptId] INTEGER PRIMARY KEY,
   [srFilerId] INTEGER,
   [srNum] INTEGER REFERENCES [filer]([srNum]),
   [state] TEXT,
   [yrCovered] INTEGER,
   [zip] TEXT
);