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, Oct. 17, 2017.

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
F400 Form 400: Statement of Organization (Slate Mailer Organization)
F401 Form 401: Campaign Disclosure Statement (Slate Mailer Organization)
F402 Form 402: Statement of Termination (Slate Mailer Organization)
F410 Form 410: Statement of Organization (Recipient Committee)
F425 Form 425: Semi-Annual Statement of No Activity (Recipient Committee)
F450 Form 450: Campaign Disclosure Statement, Short Form (Recipient Committee)
F460 Form 460: Campaign Disclosure Statement (Recipient Committee)
F461 Form 461: Campaign Disclosure Statement (Independent Expenditure Committee & Major Donor Committee)
F465 Form 465: Supplemental Independent Expenditure Report
F496 Form 496: Late Independent Expenditure Report
F497 Form 497: Late Contribution Report
F498 Form 498: Late Payment Report (Slate Mailer Organization)
F601 Form 601: Lobbying Firm Registration Statement
F602 Form 602: Lobbying Firm Activity Authorization
F603 Form 603: Lobbyist Employer or Lobbying Coalition Registration Statement
F604 Form 604: Lobbyist Certification Statement
F606 Form 606: Notice of Termination
F607 Form 607: Notice of Withdrawal
F615 Form 615: Lobbyist Report
F625 Form 625: Report of Lobbying Firm
F635 Form 635: Report of Lobbyist Employer or Report of Lobbying Coalition
F645 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
Oct. 17, 2017 146,813 Download »
Oct. 16, 2017 146,813 Download »
Oct. 15, 2017 146,813 Download »
Oct. 14, 2017 146,813 Download »
Oct. 13, 2017 146,813 Download »
Oct. 12, 2017 146,813 Download »
Oct. 11, 2017 146,813 Download »
Oct. 10, 2017 146,813 Download »
Oct. 9, 2017 146,813 Download »
Oct. 8, 2017 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)