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

Suggested facets: amended, amendment, formFiled, paperOrElect, repOrgsCnt, yrCovered, beginDate (date), endDate (date), receiveDate (date), registerDate (date)

Next page

CREATE TABLE filing(address1 VARCHAR, address2 VARCHAR, amended VARCHAR, amendment BIGINT, beginDate DATE, city VARCHAR, empLabOrg VARCHAR, endDate DATE, file_checksum UUID, file_path VARCHAR, file_status VARCHAR, filing_url VARCHAR, formFiled VARCHAR, originalRptId BIGINT, paperOrElect VARCHAR, receiveDate DATE, registerDate DATE, repOrgsCnt BIGINT, rptId BIGINT, srFilerId BIGINT, srNum BIGINT, state VARCHAR, yrCovered BIGINT, zip VARCHAR, PRIMARY KEY(rptId), FOREIGN KEY (srNum) REFERENCES filer(srNum));