CVR_CAMPAIGN_DISCLOSURE_CD

The cover page of campaign-disclosure forms.

Latest download

The most recent release from CAL-ACCESS, the database that tracks campaign finance and lobbying activity in California politics. It contains 401,067 rows of data published on Tuesday, Oct. 17, 2017*.

Download latest   121M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

Information about the 87 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.


AMENDEXP_1   String (up to 100)

Amendment explanation line 1


AMENDEXP_2   String (up to 100)

Amendment explanation line 2


AMENDEXP_3   String (up to 100)

Amendment explanation line 3


ASSOC_CB   String (up to 4)

Association Interests info included check-box. Legal values are 'X' and null.


ASSOC_INT   String (up to 90)

Description of association interests


BAL_ID   String (up to 9)

.CAL format to db tables doc says: "Not Used-AMS KDE"


BAL_JURIS   String (up to 40)

Ballot measure jurisdiction


BAL_NAME   String (up to 200)

Ballot measure name


BAL_NUM   String (up to 4)

Ballot measure number or letter


BRDBASE_YN   String (up to 1)

Broad Base Committee (yes/no) check box. Legal values are 'Y' or 'N'.


BUS_CITY   String (up to 30)

Employer/business address city


BUS_INTER   String (up to 40)

Employer/business interest description


BUS_NAME   String (up to 200)

Name of employer/business. Applies to the form 461.


BUS_ST   String (up to 2)

Employer/business address state


BUS_ZIP4   String (up to 10)

Employer/business address ZIP Code


BUSACT_CB   String (up to 10)

Business activity info included check-box. Valid values are 'X' and null


BUSACTVITY   String (up to 90)

Business activity description


CAND_CITY   String (up to 30)

Candidate/officeholder city


CAND_EMAIL   String (up to 60)

Candidate/officeholder email. This field is not contained on the forms.


CAND_FAX   String (up to 20)

Candidate/officeholder fax. This field is not contained on the forms.


CAND_ID   String (up to 9)

.CAL format to db tables doc says: "Not Used-AMS KDE"


CAND_NAMF   String (up to 45)

Candidate/officeholder first name


CAND_NAML   String (up to 200)

Candidate/officeholder's last name. Applies to forms 460, 465, and 496.


CAND_NAMS   String (up to 10)

Candidate/officeholder's name suffix


CAND_NAMT   String (up to 10)

Candidate/officeholder's prefix or title


CAND_PHON   String (up to 20)

Candidate/officeholder phone


CAND_ST   String (up to 4)

Candidate/officeholder's state


CAND_ZIP4   String (up to 10)

Candidate/officeholder's ZIP Code


CMTTE_ID   String (up to 9)

Committee ID (Filer_id) of recipient Committee who's campaign statement is attached. This field applies to the form 401.


CMTTE_TYPE   String (up to 1)

Type of Recipient Committee. Applies to the 450/460.

Code Definition
C Candidate or officeholder controlled committee
P Candidate or officeholder primarily formed committee
B Ballot-measure committee
G General-purpose committee
Sources: .CAL Format Layout (Version 2.01) (24), Map from .CAL Format to Database Table and Fields (10), .CAL Format Layout (Version 1.05.02) (19)

CONTROL_YN   Integer

Controlled Committee (yes/no) check box. Legal values are 'Y' or 'N'.


DIST_NO   String (up to 4)

District number for the office being sought. Populated for Senate, Assembly, or Board of Equalization races.


ELECT_DATE   Date (without time)

Date of the General Election


EMPLBUS_CB   String (up to 4)

Employer/Business Info included check-box. Legal values are 'X' or null. Applies to the Form 461.


EMPLOYER   String (up to 200)

Employer. This field is most likely unused.


ENTITY_CD   String (up to 4)

The entity type of the filer. These codes vary by form type.

Code Definition
BMC Ballot measure committee
CAO Candidate/officeholder
COM Committee
CTL Controlled committee
IND Individual
MDI Major Donor/Ind Expenditure
OTH Other
PTY Political Party
RCP Recipient committee
SCC Small Contributor Committee
SMO Slate-mailer organization
Sources: .CAL Format Layout (Version 2.01) (9-11, 22), Map from .CAL Format to Database Table and Fields (6), .CAL Format Layout (Version 1.05.02) (8-9, 18)

FILE_EMAIL   String (up to 60)

Filer's email address


FILER_CITY   String (up to 30)

Filer's city


FILER_FAX   String (up to 20)

Filer's fax


FILER_ID   String (up to 15)

Filer's unique identification number


FILER_NAMF   String (up to 45)

Filer's first name, if an individual


FILER_NAML   String (up to 200)

The committee's or organization's name or if an individual the filer's last name.


FILER_NAMS   String (up to 10)

Filer's suffix, if an individual


FILER_NAMT   String (up to 10)

Filer's title or prefix, if an individual


FILER_PHON   String (up to 20)

Filer phone number


FILER_ST   String (up to 4)

Filer state


FILER_ZIP4   String (up to 10)

Filer ZIP Code


FILING_ID   Integer · Unique

Unique filing identification number


FORM_TYPE   String (up to 4)

Name of the source filing form or schedule

Code Definition
F401 Form 401: Campaign Disclosure Statement (Slate Mailer Organization)
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)
F511 Form 511: Paid Spokesperson Report
F900 Form 900: Campaign Disclosure Statement (Public employee retirement board candidate)
Sources: .CAL Format Layout (Version 1.05.02) (18), .CAL Format Layout (Version 2.01) (22)

FROM_DATE   Date (without time)

Reporting period from date


JURIS_CD   String (up to 3)

Office jurisdiction code

Code Definition
ASM Assembly District
BOE Board of Equalization District
CIT City
CTY County
LOC Local
OTH Other
SEN Senate District
STW Statewide
sen Senate District
Gov Statewide
ATT Statewide
CON Statewide
GOV Statewide
SOS Statewide
SPM Statewide
46 Assembly District
55 Assembly District
BSU County
CSU County
DAT County
SHC County
MAY City
CCM City
APP Other
BED Other
SCJ Other
SD Other
OC County
AD Assembly District
CA Unknown
F Unknown
Sources: .CAL Format Layout (Version 2.01) (28-29), Map from .CAL Format to Database Table and Fields (13), .CAL Format Layout (Version 1.05.02) (21-22)

JURIS_DSCR   String (up to 40)

Office Jurisdiction description if the field JURIS_CD is set to city (CIT), county (CTY), local (LOC), or other (OTH).


LATE_RPTNO   String (up to 30)

Identifying Report Number used to distinguish multiple reports filed during the same filing period. For example, this field allows for multiple form 497s to be filed on the same day.


MAIL_CITY   String (up to 30)

Filer mailing address city


MAIL_ST   String (up to 4)

Filer mailing address state


MAIL_ZIP4   String (up to 10)

Filer mailing address ZIP Code


OCCUPATION   String (up to 60)

Occupation. This field is most likely unused.


OFF_S_H_CD   String (up to 1)

Office is sought or held code

Code Definition
S SOUGHT
H HELD
s SOUGHT
h HELD
F UNKNOWN
O UNKNOWN
Sources: .CAL Format Layout (Version 1.05.02) (21), .CAL Format Layout (Version 2.01) (28)

OFFIC_DSCR   String (up to 40)

Office sought description if the field OFFICE_CD is set to other (OTH)


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
Gov Governor
Sen State Senator
LOC Community College Board
LEG State Senator
REP State Assembly Person
Mem Other
CIT State Assembly Person
PAC Unknown
F Unknown
COM Unknown
Sources: .CAL Format Layout (Version 1.05.02) (10), .CAL Format Layout (Version 2.01) (12)

OTHER_CB   String (up to 1)

Other entity interests info included check-box. Legal values are 'X' and null.


OTHER_INT   String (up to 90)

Other entity interests description


PRIMFRM_YN   String (up to 1)

Primarily Formed Committee (yes/no) checkbox. Legal values are 'Y' or 'N'.


REC_TYPE   String (up to 4)

Record Type Value: CVR

Code Definition
CVR Cover Page
Sources: .CAL Format Layout (Version 2.01) (22), Map from .CAL Format to Database Table and Fields (6), .CAL Format Layout (Version 1.05.02) (18), CAL-ACCESS Tables, Columns and Indexes (25)

REPORT_NUM   String (up to 3)

Amendment number, as reported by the filer Report Number 000 represents an original filing. 001-999 are amendments.


REPORTNAME   String (up to 3)

Attached campaign disclosure statement type. Legal values are 450, 460, and 461.

Code Definition
450 Form 450: Campaign Disclosure Statement, Short Form (Recipient Committee)
460 Form 460: Campaign Disclosure Statement (Recipient Committee)
461 Form 461: Campaign Disclosure Statement (Independent Expenditure Committee & Major Donor Committee)
Sources: .CAL Format Layout (Version 1.05.02) (15, 20), .CAL Format Layout (Version 2.01) (19, 26)

RPT_ATT_CB   String (up to 4)

Committee Report Attached check-box. Legal values are 'X' or null. This field applies to the form 401.


RPT_DATE   Date (without time)

Date this report was filed, according to the filer


RPTFROMDT   Date (without time)

Attached campaign disclosure statement - Period from date.


RPTTHRUDT   Date (without time)

Attached campaign disclosure statement - Period through date.


SELFEMP_CB   String (up to 1)

Self employed check-box. CAL format to db tables doc says: "Not Used-AMS KDE"


SPONSOR_YN   Integer

Sponsored Committee (yes/no) checkbox. Legal values are 'Y' or 'N'.


STMT_TYPE   String (up to 2)

Type of statement

Code Definition
PE Pre-Election (F450, F460)
QT Quarterly Stmt (F450,F460)
SA Semi-annual (F450, F460)
SE Supplemental Pre-elect (F450, F460, F495)
SY Special Odd-Yr. Campaign (F450, F460)
S1 Semi-Annual (Jan1-Jun30) (F425)
S2 Semi-Annual (Jul1-Dec31) (F425)
TS Termination Statement (F450, F460)
pe Pre-Election (F450, F460)
qt Quarterly Stmt (F450,F460)
sa Semi-annual (F450, F460)
se Supplemental Pre-elect (F450, F460, F495)
sy Special Odd-Yr. Campaign (F450, F460)
ts Termination Statement (F450, F460)
** Amendment
1 Unknown
2 Unknown
CA Unknown
MD Unknown
NA Unknown
PR Unknown
QS Unknown
S Unknown
x Unknown
YE Unknown
Sources: .CAL Format Layout (Version 2.01) (23), Map from .CAL Format to Database Table and Fields (7), .CAL Format Layout (Version 1.05.02) (18)

SUP_OPP_CD   String (up to 1)

Support or opposition code

Code Definition
S SUPPORT
O OPPOSITION
s SUPPORT
o OPPOSITION
Sources: .CAL Format Layout (Version 2.01) (28), Map from .CAL Format to Database Table and Fields (14), .CAL Format Layout (Version 1.05.02) (21), CAL-ACCESS Tables, Columns and Indexes (28)

THRU_DATE   Date (without time)

Reporting period through date


TRES_CITY   String (up to 30)

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


TRES_EMAIL   String (up to 60)

Treasurer or responsible officer's email


TRES_FAX   String (up to 20)

Treasurer or responsible officer's fax number


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_PHON   String (up to 20)

Treasurer or responsible officer's phone number


TRES_ST   String (up to 2)

Treasurer or responsible officer's state


TRES_ZIP4   String (up to 10)

Treasurer or responsible officer's ZIP Code


Forms

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






Form 461: Campaign Disclosure Statement (Independent Expenditure Committee & Major Donor Committee)

Part 1, Name and Address of Filer

Part 2, Nature and Interests of Filer


Form 465: Supplemental Independent Expenditure Report

Part 1, Committee/Filer Information

Part 2, Name of Candidate or Measure Supported or Opposed


Form 496: Late Independent Expenditure Report

Part 1, List Only One Candidate or Ballot Measure






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 12 records out of 401,079 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 401,067 Download »
Oct. 16, 2017 401,028 Download »
Oct. 15, 2017 401,028 Download »
Oct. 14, 2017 401,023 Download »
Oct. 13, 2017 400,970 Download »
Oct. 12, 2017 400,937 Download »
Oct. 11, 2017 400,913 Download »
Oct. 10, 2017 400,873 Download »
Oct. 9, 2017 400,854 Download »
Oct. 8, 2017 400,851 Download »
More past downloads »

References

The documents that provided the information on this page.

  • .CAL Format Layout (Version 2.01) (p. 22-30)

  • Map from .CAL Format to Database Table and Fields (p. 6-14)

  • .CAL Format Layout (Version 1.05.02) (p. 18-22)

  • CAL-ACCESS Tables, Columns and Indexes (p. 7, 25-29)