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.0 million rows of data published on Tuesday, Oct. 17, 2017.

Download latest   240M 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
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)
F405 Form 405: Amendment to Campaign Disclosure Statement
F410 Form 410: Statement of Organization (Recipient Committee)
F415 Form 415: Title Unknown
F416 Form 416: Title Unknown
F419 Form 419: Campaign Disclosure Statement, Long Form (Ballot Measure Committee)
F420 Form 420: Campaign Disclosure Statement, Long Form (Recipient Committee)
F425 Form 425: Semi-Annual Statement of No Activity (Recipient Committee)
F430 Form 430: Title Unknown
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
F470 Form 470: Campaign Disclosure Statement, Short Form (Officeholders and Candidates)
F490 Form 490: Campaign Disclosure Statement, Long Form (Officeholders and Candidates)
F495 Form 495: Supplemental Pre-Election Campaign Statement (Recipient Committee)
F496 Form 496: Late Independent Expenditure Report
F497 Form 497: Late Contribution Report
F498 Form 498: Late Payment Report (Slate Mailer Organization)
F501 Form 501: Candidate Intention Statement
F502 Form 502: Campaign Bank Account Statement
F511 Form 511: Paid Spokesperson Report
E530 Electronic Form 530: Electronic Issue Advocacy Report
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
F605 Form 605: Amendment to Registration, Lobbying Firm, Lobbyist Employer, Lobbying Coalition
F606 Form 606: Notice of Termination
F607 Form 607: Notice of Withdrawal
F615 Form 615: Lobbyist Report
F625 Form 625: Report of Lobbying Firm
S630 Schedule 630: Payments Made to Lobbying Coalitions (Attachment to Form 625 or 635)
F635 Form 635: Report of Lobbyist Employer or Report of Lobbying Coalition
S635-C Schedule 635C: Payments Received by Lobbying Coalitions
S640 Schedule 640: Governmental Agencies Reporting (Attachment to Form 635 or Form 645)
F645 Form 645: Report of Person Spending $5,000 or More
F690 Form 690: Amendment to Lobbying Disclosure Report
F700 Form 700: Statement of Economic Interest
F900 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
Oct. 17, 2017 2,014,070 Download »
Oct. 16, 2017 2,013,880 Download »
Oct. 15, 2017 2,013,874 Download »
Oct. 14, 2017 2,013,847 Download »
Oct. 13, 2017 2,013,674 Download »
Oct. 12, 2017 2,013,510 Download »
Oct. 11, 2017 2,013,264 Download »
Oct. 10, 2017 2,013,091 Download »
Oct. 9, 2017 2,012,978 Download »
Oct. 8, 2017 2,012,971 Download »
More past downloads »

References

The documents that provided the information on this page.

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