RCPT_CD

Itemized campaign contributions.

Latest download

The most recent release from CAL-ACCESS, the database that tracks campaign finance and lobbying activity in California politics. It contains 11.7 million rows of data published on Thursday, Dec. 13, 2018*.

Download latest   2G CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

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


AMEND_ID   Integer · Unique

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


AMOUNT   Decimal number

Amount Received (Monetary, In-kind, Promise)


BAKREF_TID   String (up to 20)

Back Reference to a transaction identifier of a parent record


BAL_JURIS   String (up to 40)

Jurisdiction of ballot measure. Used on the Form 401 Schedule A


BAL_NAME   String (up to 200)

Ballot measure name. Used on the Form 401 Schedule A


BAL_NUM   String (up to 7)

Ballot measure number or letter. Used on the Form 401 Schedule A


CAND_NAMF   String (up to 45)

Candidate/officeholder's first name. Used on the Form 401 Schedule A


CAND_NAML   String (up to 200)

Candidate/officeholder's last name. Used on the Form 401 Schedule A


CAND_NAMS   String (up to 10)

Candidate/officeholder's name suffix. Used on the Form 401 Schedule A


CAND_NAMT   String (up to 10)

Candidate/officeholder's name prefix or title. Used on the Form 401 Schedule A


CMTE_ID   String (up to 9)

Committee Identification number


CTRIB_CITY   String (up to 30)

Contributor's City


CTRIB_DSCR   String (up to 90)

Description of goods/services received


CTRIB_EMP   String (up to 200)

Employer


CTRIB_NAMF   String (up to 45)

Contributor's First Name


CTRIB_NAML   String (up to 200)

Contributor's last name or business name


CTRIB_NAMS   String (up to 10)

Contributor's Suffix


CTRIB_NAMT   String (up to 10)

Contributor's Prefix or Title


CTRIB_OCC   String (up to 60)

Occupation


CTRIB_SELF   String (up to 1)

Self Employed Check-box


CTRIB_ST   String (up to 2)

Contributor's State


CTRIB_ZIP4   String (up to 10)

Contributor's ZIP+4


CUM_OTH   Decimal number

Cumulative Other (Sched A, A-1)


CUM_YTD   Decimal number

Cumulative year to date amount (Form 460 Schedule A and Form 401 Schedule A, A-1)


DATE_THRU   Date (without time)

End of date range for items received


DIST_NO   String (up to 3)

Office District Number (used on F401A)


ENTITY_CD   String (up to 3)

Entity Code describing the contributor

Code Definition
COM Committee
IND Individual
PTY Political Party
OTH Other
RCP Recipient committee
SCC Small Contributor Committee
Com Committee
CAO Candidate/officeholder
BNM Ballot measure's name/title
OFF Officer
0 Unknown
PTH Unknown
RFD Unknown
MBR Unknown
Sources: .CAL Format Layout (Version 1.05.02) (8-9, 29), .CAL Format Layout (Version 2.01) (9-11, 37), Map from .CAL Format to Database Table and Fields (71)

FILING_ID   Integer · Unique

Unique filing identification number


FORM_TYPE   String (up to 9) · Unique

Name of the source filing form or schedule

Code Definition
Electronic Form 530: Electronic Issue Advocacy Report
Form 900: Campaign Disclosure Statement (Public employee retirement board candidate)
F401A Form 401 (Campaign Disclosure Statement (Slate Mailer Organization)): Schedule A, Payments Received
A Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule A, Monetary Contributions Received
A-1 Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule A-1, Contributions Transferred to Special Election Commitee
C Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule C, Non-Monetary Contributions Received
I Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule I, Miscellanous increases to cash
F496P3 Form 496 (Late Independent Expenditure Report): Part 3, Contributions > $100 Received
Sources: .CAL Format Layout (Version 1.05.02) (29), .CAL Format Layout (Version 2.01) (37)

INT_RATE   String (up to 9)

This field is undocumented. The observed values look like filer_ids taken from section 5, cover page 2 of Form 460 (Related Committees Not Included in this Statement).


INTR_CITY   String (up to 30)

Intermediary's City


INTR_CMTEID   String (up to 9)

This field is undocumented


INTR_EMP   String (up to 200)

Intermediary's Employer


INTR_NAMF   String (up to 45)

Intermediary's First Name


INTR_NAML   String (up to 200)

Intermediary's Last Name


INTR_NAMS   String (up to 10)

Intermediary's Suffix


INTR_NAMT   String (up to 10)

Intermediary's Prefix or Title


INTR_OCC   String (up to 60)

Intermediary's Occupation


INTR_SELF   String (up to 1)

Intermediary's self employed check box


INTR_ST   String (up to 2)

Intermediary's state


INTR_ZIP4   String (up to 10)

Intermediary's zip code


JURIS_CD   String (up to 3)

Office jurisdiction code. See the CAL document for the list of legal values. Used on Form 401 Schedule A

Code Definition
ASM Assembly District
BOE Board of Equalization District
CIT City
CTY County
LOC Local
OTH Other
SEN Senate District
STW Statewide
BED Other
CLB Other
COU County
CO Other
SAC Unknown
PER Unknown
SF Unknown
OR Unknown
AL Unknown
4 Unknown
CA Unknown
Sources: .CAL Format Layout (Version 1.05.02) (30), .CAL Format Layout (Version 2.01) (40), Map from .CAL Format to Database Table and Fields (74)

JURIS_DSCR   String (up to 40)

Office Jurisdiction Description (used on F401A)


LINE_ITEM   Integer · Unique

Line item number of this record


MEMO_CODE   String (up to 1)

Memo amount flag (Date/Amount are informational only)


MEMO_REFNO   String (up to 20)

Reference to text contained in a TEXT record


OFF_S_H_CD   String (up to 1)

Office is sought or held code

Code Definition
S SOUGHT
H HELD
Sources: .CAL Format Layout (Version 1.05.02) (30), .CAL Format Layout (Version 2.01) (40), Map from .CAL Format to Database Table and Fields (75)

OFFIC_DSCR   String (up to 40)

Office Sought Description (used on F401A)


OFFICE_CD   String (up to 3)

Identifies the office being sought

Code Definition
APP State Appellate Court Justice
ASM State Assembly Person
ASR Assessor
ATT Attorney General
BED Board of Education
BOE Board of Equalization Member
BSU Board of Supervisors
CAT City Attorney
CCB Community College Board
CCM City Council Member
CON State Controller
COU County Counsel
CSU County Supervisor
CTR Local Controller
DAT District Attorney
GOV Governor
INS Insurance Commissioner
LTG Lieutenant Governor
MAY Mayor
OTH Other
PDR Public Defender
PER Public Employees Retirement System
PLN Planning Commissioner
SCJ Superior Court Judge
SEN State Senator
SHC Sheriff-Coroner
SOS Secretary of State
SPM Supreme Court Justice
SUP Superintendent of Public Instruction
TRE State Treasurer
TRS Local Treasurer
asm State Assembly Person
gov Governor
OTh Other
oth Other
csu County Supervisor
H Unknown
HOU Unknown
ASS Unknown
Sources: .CAL Version 2.01 Errata (2), .CAL Format Layout (Version 1.05.02) (10), .CAL Format Layout (Version 2.01) (12)

RCPT_DATE   Date (without time)

Date item received


REC_TYPE   String (up to 4) · Unique

Record Type Value: CVR

Code Definition
E530 Electronic Form 530: Electronic Issue Advocacy Report
RCPT Receipt
Sources: .CAL Format Layout (Version 2.01) (29), .CAL Format Layout (Version 1.05.02) (37), Map from .CAL Format to Database Table and Fields (71)

SUP_OPP_CD   String (up to 1)

Support or opposition code

Code Definition
S SUPPORT
O OPPOSITION
F Unknown
Sources: .CAL Format Layout (Version 1.05.02) (30), .CAL Format Layout (Version 2.01) (40), Map from .CAL Format to Database Table and Fields (74)

TRAN_ID   String (up to 20)

Permanent value unique to this item


TRAN_TYPE   String (up to 1)

Transaction Type

Code Definition
F Forgiven Loan
I Intermediary
R Returned
T Third Party Repayment
X Transfer
0 Unknown
M Unknown
N Unknown
Sources: .CAL Format Layout (Version 1.05.02) (29), .CAL Format Layout (Version 2.01) (38), Map from .CAL Format to Database Table and Fields (72)

TRES_CITY   String (up to 30)

City portion of the treasurer or responsible officer's street address


TRES_NAMF   String (up to 45)

Treasurer or responsible officer's first name


TRES_NAML   String (up to 200)

Treasurer or responsible officer's last name


TRES_NAMS   String (up to 10)

Treasurer or responsible officer's suffix


TRES_NAMT   String (up to 10)

Treasurer or responsible officer's prefix or title


TRES_ST   String (up to 2)

State portion of the treasurer or responsible officer's address


TRES_ZIP4   String (up to 10)

Zip code portion of the treasurer or responsible officer's address


XREF_MATCH   String (up to 1)

Related item on other schedule has same transaction identifier. 'X' indicates this condition is true


XREF_SCHNM   String (up to 2)

Related record is included on Sched 'B2' or 'F'


Forms

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




Form 460: Campaign Disclosure Statement (Recipient Committee)

Schedule A, Monetary Contributions Received

Schedule A-1, Contributions Transferred to Special Election Commitee

Schedule C, Non-Monetary Contributions Received

Schedule I, Miscellanous increases to cash


Form 496: Late Independent Expenditure Report

Part 3, Contributions > $100 Received



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 110 records out of 11,719,510 total rows were lost (you can download them here).

Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
Dec. 13, 2018 11,719,400 Download »
Dec. 12, 2018 11,719,260 Download »
Dec. 11, 2018 11,719,200 Download »
Dec. 10, 2018 11,719,145 Download »
Dec. 9, 2018 11,719,145 Download »
Dec. 8, 2018 11,719,145 Download »
Dec. 7, 2018 11,719,138 Download »
Dec. 6, 2018 11,719,060 Download »
Dec. 5, 2018 11,716,082 Download »
Dec. 4, 2018 11,715,835 Download »
More past downloads »

References

The documents that provided the information on this page.

  • CAL-ACCESS Tables, Columns and Indexes (p. 13, 118-121)

  • .CAL Format Layout (Version 1.05.02) (p. 29-30)

  • .CAL Format Layout (Version 2.01) (p. 37-41)

  • Map from .CAL Format to Database Table and Fields (p. 71-75)