CVR2_CAMPAIGN_DISCLOSURE_CD

Extra information from 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 109,612 rows of data published on Tuesday, Oct. 17, 2017*.

Download latest   13M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

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


BAL_JURIS   String (up to 40)

Ballot measure jurisdiction


BAL_NAME   String (up to 200)

Ballot measure name


BAL_NUM   String (up to 7)

Ballot measure number or letter


CMTE_ID   String (up to 9)

Committee identification number, when the entity is a committee


CONTROL_YN   Integer

Controlled Committee (yes/no) checkbox. Legal values are "Y" or "N".


DIST_NO   String (up to 3)

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


ENTITY_CD   String (up to 3)

Entity code used to identify the type of entity being described with in the record.

Code Definition
ATR Assistant treasurer
BNM Ballot measure's name/title
CAO Candidate/officeholder
COM Committee
CTL Controlled committee
OFF Officer
POF Principal officer
PRO Proponent
RCP Recipient committee
FIL Unknown
PEX Unknown
RDP Unknown
Sources: .CAL Format Layout (Version 1.05.02) (8-9, 23-24), .CAL Format Layout (Version 2.01) (9-11, 32), Map from .CAL Format to Database Table and Fields (32)

ENTY_CITY   String (up to 30)

Entity city


ENTY_EMAIL   String (up to 60)

Entity email address


ENTY_FAX   String (up to 20)

Entity fax number


ENTY_NAMF   String (up to 45)

Entity first name, if an individual


ENTY_NAML   String (up to 200)

Entity name, or last name if an individual


ENTY_NAMS   String (up to 10)

Entity suffix, if an individual


ENTY_NAMT   String (up to 10)

Entity prefix or title, if an individual


ENTY_PHON   String (up to 20)

Entity phone number


ENTY_ST   String (up to 2)

Entity state


ENTY_ZIP4   String (up to 10)

Entity ZIP code


F460_PART   String (up to 2)

Part of 460 cover page coded on ths cvr2 record

Code Definition
3 Part 3: Committee Information
4a Part 4a: Officeholder or Candidate Controlled Committee
4A Part 4a: Officeholder or Candidate Controlled Committee
4b Part 4b: Related Committees Not Included in this Statement
4B Part 4b: Related Committees Not Included in this Statement
5a Part 5a: Officeholder or Candidate Controlled Committee
5A Part 5a: Officeholder or Candidate Controlled Committee
5b Part 5b: Related Committees Not Included in this Statement
5B Part 5b: Related Committees Not Included in this Statement
6 Part 6: Primarily Formed Committee
6a Part 6a: Name of Ballot Measure
6A Part 6a: Name of Ballot Measure
6b Part 6b: Name of Officeholder, Candidate, or Proponent
6B Part 6b: Name of Officeholder, Candidate, or Proponent
7 Part 7: Primarily Formed Committee
Sources: .CAL Format Layout (Version 2.01) (32), .CAL Format Layout (Version 1.05.02) (24), Map from .CAL Format to Database Table and Fields (32)

FILING_ID   Integer · Unique

Unique filing identification number


FORM_TYPE   String (up to 4) · Unique

Name of the source filing form or schedule

Code Definition
F425 Form 425 (Semi-Annual Statement of No Activity (Recipient Committee)): Part 1, Committee Information
F450 Form 450 (Campaign Disclosure Statement, Short Form (Recipient Committee)): Part 3, Committee Information
F460 Form 460 (Campaign Disclosure Statement (Recipient Committee)): Cover Page, Part 2
F465 Form 465 (Supplemental Independent Expenditure Report): Part 5, Filing Officers
Sources: .CAL Format Layout (Version 1.05.02) (23), .CAL Format Layout (Version 2.01) (31)

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
SD Assembly District
se Senate District
F Assembly District
LBC City
CA Statewide
Sources: .CAL Format Layout (Version 1.05.02) (24), .CAL Format Layout (Version 2.01) (33), Map from .CAL Format to Database Table and Fields (35)

JURIS_DSCR   String (up to 40)

Office jurisdiction description


LINE_ITEM   Integer · Unique

Line item number of this record


MAIL_CITY   String (up to 30)

Filer's mailing city


MAIL_ST   String (up to 2)

Filer's mailing state


MAIL_ZIP4   String (up to 10)

Filer's mailing ZIP Code


OFF_S_H_CD   String (up to 1)

Office is sought or held code

Code Definition
S SOUGHT
H HELD
s SOUGHT
F SOUGHT
T HELD
Sources: .CAL Format Layout (Version 1.05.02) (24), .CAL Format Layout (Version 2.01) (34), Map from .CAL Format to Database Table and Fields (35)

OFFIC_DSCR   String (up to 40)

Office sought description


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
CIT State Assembly Person
CTL State Assembly Person
F State Assembly Person
ST State Assembly Person
PAC Unknown
Sources: .CAL Format Layout (Version 1.05.02) (10), .CAL Format Layout (Version 2.01) (12), .CAL Version 2.01 Errata (2)

REC_TYPE   String (up to 4) · Unique

Record Type Value: CVR2

Code Definition
CVR2 Cover, Page 2
Sources: .CAL Format Layout (Version 1.05.02) (23), .CAL Format Layout (Version 2.01) (31), CAL-ACCESS Tables, Columns and Indexes (41), Map from .CAL Format to Database Table and Fields (32)

SUP_OPP_CD   String (up to 1)

Support or opposition code

Code Definition
S SUPPORT
O OPPOSITION
s SUPPORT
o OPPOSITION
Sources: Map from .CAL Format to Database Table and Fields (35), CAL-ACCESS Tables, Columns and Indexes (41)

TITLE   String (up to 90)

Official title of filing officer. Applies to the form 465.


TRAN_ID   String (up to 20)

Permanent value unique to this item


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


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 9 records out of 109,621 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 109,612 Download »
Oct. 16, 2017 109,608 Download »
Oct. 15, 2017 109,608 Download »
Oct. 14, 2017 109,608 Download »
Oct. 13, 2017 109,595 Download »
Oct. 12, 2017 109,592 Download »
Oct. 11, 2017 109,591 Download »
Oct. 10, 2017 109,584 Download »
Oct. 9, 2017 109,582 Download »
Oct. 8, 2017 109,581 Download »
More past downloads »

References

The documents that provided the information on this page.

  • .CAL Format Layout (Version 1.05.02) (p. 23-24)

  • .CAL Format Layout (Version 2.01) (p. 31-34)

  • CAL-ACCESS Tables, Columns and Indexes (p. 8, 41-43)

  • Map from .CAL Format to Database Table and Fields (p. 32-35)