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

Download latest   237M 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
F401 Form 401: Campaign Disclosure Statement (Slate Mailer Organization)
F405 Form 405: Amendment to Campaign Disclosure Statement
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
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
F635 Form 635: Report of Lobbyist Employer or Report of Lobbying Coalition
F645 Form 645: Report of Person Spending $5,000 or More
S630 Schedule 630: Payments Made to Lobbying Coalitions (Attachment to Form 625 or 635)
S635-C Schedule 635C: Payments Received by Lobbying Coalitions
S640 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 319 records out of 1,765,638 total rows were lost (you can download them here).

Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
Oct. 17, 2017 1,765,319 Download »
Oct. 16, 2017 1,765,286 Download »
Oct. 15, 2017 1,765,284 Download »
Oct. 14, 2017 1,765,280 Download »
Oct. 13, 2017 1,765,161 Download »
Oct. 12, 2017 1,765,124 Download »
Oct. 11, 2017 1,765,092 Download »
Oct. 10, 2017 1,764,827 Download »
Oct. 9, 2017 1,764,786 Download »
Oct. 8, 2017 1,764,785 Download »
More past downloads »

References

The documents that provided the information on this page.

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

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

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

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