FILER_FILINGS_CD

An index that links filers to their filings.

Latest download

The most recent release from CAL-ACCESS, the database that tracks campaign finance and lobbying activity in California politics. It contains 2.2 million rows of data published on Wednesday, April 17, 2019.

Download latest   262M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

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


FILER_ID   Integer · Unique

Filer's unique identification number


FILING_ID   Integer · Unique

Unique filing identification number


PERIOD_ID   Integer

Identifies the period when the filing was recieved.


FORM_ID   String (up to 7) · Unique

Form identification code

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 405: Amendment to Campaign Disclosure Statement
Form 410: Statement of Organization (Recipient Committee)
Form 415: Title Unknown
Form 416: Title Unknown
Form 419: Campaign Disclosure Statement, Long Form (Ballot Measure Committee)
Form 420: Campaign Disclosure Statement, Long Form (Recipient Committee)
Form 425: Semi-Annual Statement of No Activity (Recipient Committee)
Form 430: Title Unknown
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 470: Campaign Disclosure Statement, Short Form (Officeholders and Candidates)
Form 490: Campaign Disclosure Statement, Long Form (Officeholders and Candidates)
Form 495: Supplemental Pre-Election Campaign Statement (Recipient Committee)
Form 496: Late Independent Expenditure Report
Form 497: Late Contribution Report
Form 498: Late Payment Report (Slate Mailer Organization)
Form 501: Candidate Intention Statement
Form 502: Campaign Bank Account Statement
Form 511: Paid Spokesperson Report
Electronic Form 530: Electronic Issue Advocacy Report
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 605: Amendment to Registration, Lobbying Firm, Lobbyist Employer, Lobbying Coalition
Form 606: Notice of Termination
Form 607: Notice of Withdrawal
Form 615: Lobbyist Report
Form 625: Report of Lobbying Firm
Schedule 630: Payments Made to Lobbying Coalitions (Attachment to Form 625 or 635)
Form 635: Report of Lobbyist Employer or Report of Lobbying Coalition
S635-C Schedule 635C: Payments Received by Lobbying Coalitions
Schedule 640: Governmental Agencies Reporting (Attachment to Form 635 or Form 645)
Form 645: Report of Person Spending $5,000 or More
Form 690: Amendment to Lobbying Disclosure Report
Form 700: Statement of Economic Interest
Form 900: Campaign Disclosure Statement (Public employee retirement board candidate)
F111 Unknown
F410 AT Unknown
F410ATR Unknown
F421 Unknown
F440 Unknown
F470S Form 470: Campaign Disclosure Statement, Short Form (Officeholders and Candidates)
F480 Unknown
F500 Unknown
F501502 Forms 501 and/or 502 (Candidate Intention and/or Bank Account Statements)
F555 Unknown
F666 Unknown
F777 Unknown
F888 Unknown
F999 Unknown
Sources: CAL-ACCESS Tables, Columns and Indexes (65)

FILING_SEQUENCE   Integer · Unique

Amendment number where 0 is an original filing and 1 to 999 are amendments


FILING_DATE   Date (without time)

Date the filing entered into the system


STMNT_TYPE   Integer

Type of statement

Code Definition
0 N/A
10001 ORIGINAL/INITIAL
10002 AMENDMENT
10003 TERMINATION
10004 REDESIGNATE THE ACCOUNT FOR FUTURE ELECTION TO THE SAME OFFICE
10005 LOG
10006 LOG/AMENDMENT
10007 AS FILED BY COMMITTEE
Sources: Lookup-Codes-Cd (6)

STMNT_STATUS   Integer

The status of the statement. If the filing has been reviewed or not reviewed.

Code Definition
11001 COMPLETE
11002 INCOMPLETE
11003 NEEDS REVIEW
Sources: Lookup-Codes-Cd (6)

SESSION_ID   Integer

Legislative session identification number


USER_ID   String (up to 12)

User identifier of the PRD user who logged the filing


SPECIAL_AUDIT   Integer

Denotes whether the filing has been audited for money laundering or other special condition.


FINE_AUDIT   Integer

Indicates whether a filing has been audited for a fine


RPT_START   Date (without time)

Starting date for the period the filing represents


RPT_END   Date (without time)

Ending date for the period the filing represents


RPT_DATE   Date (without time)

Date filing received


FILING_TYPE   Integer

The type of filing

Code Definition
0 N/A
22001 Electronic
22006 Cal Online
Sources: FAQ (2)

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
April 17, 2019 2,182,284 Download »
April 16, 2019 2,181,860 Download »
April 15, 2019 2,181,408 Download »
April 14, 2019 2,181,377 Download »
April 13, 2019 2,181,312 Download »
April 12, 2019 2,181,101 Download »
April 11, 2019 2,180,917 Download »
April 9, 2019 2,180,502 Download »
April 8, 2019 2,180,200 Download »
April 7, 2019 2,180,197 Download »
More past downloads »

References

The documents that provided the information on this page.

  • CAL-ACCESS Tables, Columns and Indexes (p. 8, 64-66)