TEXT_MEMO_CD

Text memos attached to 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 1.9 million rows of data published on Wednesday, Nov. 14, 2018*.

Download latest   255M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

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


FILING_ID   Integer · Unique

Unique filing identification number


AMEND_ID   Integer · Unique

Amendment identification number. A number of 0 is the original filing and 1 to 999 amendments.


LINE_ITEM   Integer · Unique

Line item number of this record


REC_TYPE   String (up to 4) · Unique

Record Type Value: TEXT

Code Definition
TEXT TEXT
MEMO MEMO
trun Unknown
Unde Under
am Unknown
sele Unknown
Term Unknown
re Unknown
i Unknown
Sources: .CAL Format Layout (Version 1.05.02) (13), .CAL Format Layout (Version 2.01) (16)

FORM_TYPE   String (up to 8) · Unique

Name of the source filing form or schedule

Code Definition
Form 401: Campaign Disclosure Statement (Slate Mailer Organization)
Form 405: Amendment to Campaign Disclosure Statement
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 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
Form 635: Report of Lobbyist Employer or Report of Lobbying Coalition
Form 645: Report of Person Spending $5,000 or More
Schedule 630: Payments Made to Lobbying Coalitions (Attachment to Form 625 or 635)
S635-C Schedule 635C: Payments Received by Lobbying Coalitions
Schedule 640: Governmental Agencies Reporting (Attachment to Form 635 or Form 645)
410 Form 410: Statement of Organization (Recipient Committee)
460 Form 460: Campaign Disclosure Statement (Recipient Committee)
461 Form 461: Campaign Disclosure Statement (Independent Expenditure Committee & Major Donor Committee)
465 Form 465: Supplemental Independent Expenditure Report
496 Form 496: Late Independent Expenditure Report
497 Form 497: Late Contribution Report
497P1 Form 497 (Late Contribution Report): Part 1, Contributions Received
497P2 Form 497 (Late Contribution Report): Part 2, Contributions Made
F401A Form 401 (Campaign Disclosure Statement (Slate Mailer Organization)): Schedule A, Payments Received
F401B Form 401 (Campaign Disclosure Statement (Slate Mailer Organization)): Schedule B, Payments Made
F401B-1 Form 401 (Campaign Disclosure Statement (Slate Mailer Organization)): Schedule B-1, Payments Made by Agent or Independent Contractor
F450P5 Form 450 (Campaign Disclosure Statement, Short Form (Recipient Committee)): Part 5, Payments Made
F461P1 Form 461 (Campaign Disclosure Statement (Independent Expenditure Committee & Major Donor Committee)): Part 1, Name and Address of Filer
F461P2 Form 461 (Campaign Disclosure Statement (Independent Expenditure Committee & Major Donor Committee)): Part 2, Nature and Interests of Filer
F461P5 Form 461 (Campaign Disclosure Statement (Independent Expenditure Committee & Major Donor Committee)): Part 5, Contributions (Including Loans, Forgiveness of Loans, and LoanGuarantees) and Expenditures Made
F465P3 Form 465 (Supplemental Independent Expenditure Report): Part 3, Independent Expenditures Made
F496P3 Form 496 (Late Independent Expenditure Report): Part 3, Contributions > $100 Received
F497P1 Form 497 (Late Contribution Report): Part 1, Contributions Received
F497P2 Form 497 (Late Contribution Report): Part 2, Contributions Made
F498-A Form 498 (Late Payment Report (Slate Mailer Organization)): Part A, Late Payments Attributed To
F498-R Form 498 (Late Payment Report (Slate Mailer Organization)): Part R, Late Payments Received From
F601P2A Form 601 (Lobbying Firm Registration Statement): Part 2, Section A, Lobbyist Employers
F601P2B Form 601 (Lobbying Firm Registration Statement): Part 2, Section B, Subcontracted Clients
F615P1 Form 615 (Lobbyist Report): Part 1, Activity Expenses Paid, Incurred, Arranged or Provided by the Lobbyist
F615P2 Form 615 (Lobbyist Report): Part 2, Campaign Contributions Made or Delivered
F625P2 Form 625 (Report of Lobbying Firm): Part 2, Payments Received in Connection with Lobbying Activity
F625P3A Form 625 (Report of Lobbying Firm): Part 3, Payments Made In Connection With Lobbying Activities, Section A, Activity Expenses
F625P3B Form 625 (Report of Lobbying Firm): Part 3, Payments Made In Connection With Lobbying Activities, Section B, Payments Made
F625P4B Form 625 (Report of Lobbying Firm): Part 4, Campaign Contributions Made
S635 Form 635: Report of Lobbyist Employer or Report of Lobbying Coalition
F635P3B Form 635 (Report of Lobbyist Employer or Report of Lobbying Coalition): Part 3, Payments Made in Connection with Lobbying Activities, Section B, Payments To Lobbying Firms
F635P3C Form 635 (Report of Lobbyist Employer or Report of Lobbying Coalition): Part 3, Payments Made in Connection with Lobbying Activities, Section C, Activity Expenses
F635P4B Form 635 (Report of Lobbyist Employer or Report of Lobbying Coalition): Part 4, Campaign Contributions Made
F645P2A Form 645 (Report of Person Spending $5,000 or More): Part 2, Payments Made this Period, Section A, Activity Expenses
F645P3B Form 645 (Report of Person Spending $5,000 or More): Part 3, Campaign Contributions Made
S497 Form 497: Late Contribution Report
S635C Schedule 635C: Payments Received by Lobbying Coalitions
A Schedule A of any form (e.g., Forms 401 or 460)
A4 Schedule A of any form (e.g., Forms 401 or 460)
A6 Schedule A of any form (e.g., Forms 401 or 460)
B Schedule B of any form (e.g., Forms 401 or 460)
B1 Schedule B, Part 1 of Forms 401 or 460
B2 Schedule B, Part 2 of Forms 401 or 460
B3 Schedule B, Part 3 of Forms 401 or 460
C Schedule C of any form (e.g., Forms 401 or F460)
COMMENTS Possibly comments by FPPC for any form?
CVR Cover page for any form (e.g., Forms 460, 461 or 497)
D Schedule D of any form (e.g., Forms 401, 460 or 461)
DEBTF Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule F, Accrued Expenses (Unpaid Bills)
E Schedule E of any form (e.g., Forms 460, 461 or 465)
EXPNT Expenditures outlined on any form (e.g. Form 460)
F Schedule F of any form (e.g., Form 460)
G Schedule G of any form (e.g., Form 460)
H Schedule H of any form (e.g., Form 460)
H1 Schedule H, Part 1 of any form (e.g., Form 460)
H2 Schedule H2, Part 2 of any form (e.g., Form 460)
H3 Schedule H3, Part 3 of any form (e.g., Form 460)
I Schedule I of any form (e.g., Form 460)
PT5 Part 5 of any form (e.g., Form 461
RCPTB1 Schedule B, Part 1 of any form (e.g., Form 460
RCPTC Schedule C of any form (e.g., Form 460)
RCPTI Schedule I of any form (e.g., Form 460)
SCH A Schedule A of any form (e.g., Form 460)
SF Schedule F of any form (e.g., Form 460)
SPLT A memo that applies to multiple items?
SMRY Summary section of any form (e.g., Form 460)
SUM Summary section of any form (e.g., Form 460)
SUMMARY Summary section of any form (e.g., Form 460)
Sources: .CAL Format Layout (Version 1.05.02) (13), .CAL Format Layout (Version 2.01) (16), Map from .CAL Format to Database Table and Fields (90)

REF_NO   String (up to 20)

Links text memo to a specific record


TEXT4000   String (up to 4000)

Contents of the text memo


Forms

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



























Errata

The raw data provided by the state contains errors in how some values are escaped, quoted and delimited. The result is a small number of records in the latest download were lost when we prepared files for download.

However, only 333 records out of 1,884,443 total rows were lost (you can download them here).

Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
Nov. 14, 2018 1,884,110 Download »
Nov. 13, 2018 1,884,081 Download »
Nov. 12, 2018 1,884,051 Download »
Nov. 11, 2018 1,884,051 Download »
Nov. 9, 2018 1,883,951 Download »
Nov. 8, 2018 1,883,887 Download »
Nov. 7, 2018 1,883,675 Download »
Nov. 6, 2018 1,882,620 Download »
Nov. 5, 2018 1,882,330 Download »
Nov. 4, 2018 1,882,280 Download »
More past downloads »

References

The documents that provided the information on this page.

  • .CAL Format Layout (Version 1.05.02) (p. 13)

  • CAL-ACCESS Tables, Columns and Indexes (p. 14, 133-134)

  • .CAL Format Layout (Version 2.01) (p. 15-16)

  • Map from .CAL Format to Database Table and Fields (p. 89-90)