EFS_FILING_LOG_CD

Logs from the Electronic Filing Subsystem, which accepts and validates electronic filings.

Latest download

The most recent release from CAL-ACCESS, the database that tracks campaign finance and lobbying activity in California politics. It contains 146,813 rows of data published on Tuesday, June 18, 2019.

Download latest   8M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

Information about the 7 fields and the definitions of any abbreviated values.


FILING_DATE   Date (without time) · Unique

Date of filing


FILINGSTATUS   Integer

Status of filing. This field is described in the docs as beingVARCHAR. However, its distinct values are 0, 1, 2 and 7.


VENDOR   String (up to 250) · Unique

Software vendor who submitted the electronic filing


FILER_ID   String (up to 250)

Filer's unique identification number


FORM_TYPE   String (up to 250)

Name of the source filing form or schedule

Code Definition
Form 400: Statement of Organization (Slate Mailer Organization)
Form 401: Campaign Disclosure Statement (Slate Mailer Organization)
Form 402: Statement of Termination (Slate Mailer Organization)
Form 410: Statement of Organization (Recipient Committee)
Form 425: Semi-Annual Statement of No Activity (Recipient Committee)
Form 450: Campaign Disclosure Statement, Short Form (Recipient Committee)
Form 460: Campaign Disclosure Statement (Recipient Committee)
Form 461: Campaign Disclosure Statement (Independent Expenditure Committee & Major Donor Committee)
Form 465: Supplemental Independent Expenditure Report
Form 496: Late Independent Expenditure Report
Form 497: Late Contribution Report
Form 498: Late Payment Report (Slate Mailer Organization)
Form 601: Lobbying Firm Registration Statement
Form 602: Lobbying Firm Activity Authorization
Form 603: Lobbyist Employer or Lobbying Coalition Registration Statement
Form 604: Lobbyist Certification Statement
Form 606: Notice of Termination
Form 607: Notice of Withdrawal
Form 615: Lobbyist Report
Form 625: Report of Lobbying Firm
Form 635: Report of Lobbyist Employer or Report of Lobbying Coalition
Form 645: Report of Person Spending $5,000 or More
BADFORMAT 253 Unknown
form Unknown
Sources: .CAL Format Overview (4-8)

ERROR_NO   String (up to 250)

Most records have a value of "ACCEPTED". Other records include "ERROR"or "BADFORMAT" and a three-digit number.


Forms

The forms that the state uses to collect the information that populates this file.
























Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
June 18, 2019 146,813 Download »
June 17, 2019 146,813 Download »
June 16, 2019 146,813 Download »
June 15, 2019 146,813 Download »
June 14, 2019 146,813 Download »
June 13, 2019 146,813 Download »
June 12, 2019 146,813 Download »
June 11, 2019 146,813 Download »
June 10, 2019 146,813 Download »
June 9, 2019 146,813 Download »
More past downloads »

References

The documents that provided the information on this page.

  • .CAL Format Overview (p. 1-2)

  • CAL-ACCESS Tables, Columns and Indexes (p. 49-50)