CVR2_SO_CD

Extra information from a statement-of-organization form.

Latest download

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

Download latest   4M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

Information about the 34 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

Type of record. This column will always contain "CVR2".

Code Definition
CVR2 Cover Page; Additional Names & Addresses
Sources: .CAL Format Layout (Version 2.01) (58), Map from .CAL Format to Database Table and Fields (38), .CAL Format Layout (Version 1.05.02) (45), CAL-ACCESS Tables, Columns and Indexes (46)

FORM_TYPE   String (up to 4) · Unique

Form type of the filing the record is included in. This must equal the form_type of the parent filing's cover (CVR) record.

Code Definition
F400 Form 400 (Statement of Organization (Slate Mailer Organization)): Part 3, Individuals Who Authorize Contents Of Slate Mailers
F410 Form 410 (Statement of Organization (Recipient Committee)): Part 4, Type of Committee
Sources: .CAL Format Layout (Version 2.01) (58-59), Map from .CAL Format to Database Table and Fields (38), .CAL Format Layout (Version 1.05.02) (45-46)

TRAN_ID   String (up to 20)

Permanent value unique to this item


ENTITY_CD   String (up to 3)

Entity code of the entity described by the record.

Code Definition
ATH Authorizing individual
ATR Assistant treasurer
BNM Ballot measure's name/title
CAO Candidate/officeholder
COM Committee
CTL Controlled committee
OFF Officer
POF Principal officer
PRO Proponent
SPO Sponsor
BMN Unknown
Sources: .CAL Format Layout (Version 1.05.02) (8-9, 48), .CAL Format Layout (Version 2.01) (9-11, 62), Map from .CAL Format to Database Table and Fields (38)

ENTY_NAML   String (up to 200)

Entity's business name or last name if the entity is an individual


ENTY_NAMF   String (up to 45)

Entity's first name if the entity is an individual


ENTY_NAMT   String (up to 10)

Entity's name prefix or title if the entity is an individual


ENTY_NAMS   String (up to 10)

Entity's name suffix if the entity is an individual


ITEM_CD   String (up to 4)

Section of the Statement of Organization this itemization relates to. See CAL document for the definition of legal values for this column.

Code Definition
ATR Assistant Treasurer (F410)
CAO Candidate/officeholder
CTL Controlled Committee (F410)
P5B Unknown
PFC Primarily Formed Committee Item (F410)
Pfc Primarily Formed Committee Item (F410)
POF Principal Officer (F400, F410
PRO Proponent
SMA Slate Mailer Authorizer (F400)
SPO Sponsored Committee Itemization (F410)
n/a Not Applicable
CON Unknown
CST Unknown
Sources: .CAL Format Layout (Version 1.05.02) (8, 48), .CAL Format Layout (Version 2.01) (10, 62)

MAIL_CITY   String (up to 30)

City portion of the entity's mailing address


MAIL_ST   String (up to 4)

State portion of the entity's mailing address


MAIL_ZIP4   String (up to 10)

Zipcode portion of the entity's mailing address


DAY_PHONE   String (up to 20)

Entity's daytime phone number


FAX_PHONE   String (up to 20)

Entity's fax number


EMAIL_ADR   String (up to 60)

Email address. Not contained in current forms.


CMTE_ID   Integer

Entity's identification number


IND_GROUP   String (up to 90)

Industry group/affiliation 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
Asm State Assembly Person
LEG State Assembly Person
OF State Assembly Person
REP State Assembly Person
05 State Assembly Person
H N/A
PRO N/A
PAC Unknown
Sources: .CAL Format Layout (Version 1.05.02) (10), .CAL Format Layout (Version 2.01) (12), .CAL Version 2.01 Errata (2)

OFFIC_DSCR   String (up to 40)

Office sought description used if the office sought code (OFFICE_CD) equals other (OTH).


JURIS_CD   String (up to 4)

Office jurisdiction code. See CAL document for a list of legal values.

Code Definition
ASM Assembly District
BOE Board of Equalization District
CIT City
CTY County
LOC Local
OTH Other
SEN Senate District
STW Statewide
FED N/A
JR N/A
Sources: .CAL Format Layout (Version 2.01) (63), Map from .CAL Format to Database Table and Fields (39), .CAL Format Layout (Version 1.05.02) (49)

JURIS_DSCR   String (up to 40)

Office jurisdiction description provided if the jurisdiction code (JURIS_CD) equals other (OTH).


DIST_NO   String (up to 4)

Office district number for Senate, Assembly, and Board of Equalization districts.


OFF_S_H_CD   String (up to 1)

Office sought/held code. Legal values are "S" for sought and "H" for held

Code Definition
H HELD
S SOUGHT
Sources: .CAL Format Layout (Version 2.01) (63), Map from .CAL Format to Database Table and Fields (39), .CAL Format Layout (Version 1.05.02) (49), CAL-ACCESS Tables, Columns and Indexes (46)

NON_PTY_CB   String (up to 4)

Non-partisan check-box. Legal values are 'X' and null.


PARTY_NAME   String (up to 200)

Name of party (if partisan)


BAL_NUM   String (up to 7)

Ballot measure number or letter


BAL_JURIS   String (up to 40)

Jurisdiction of ballot measure


SUP_OPP_CD   String (up to 1)

Support or opposition code

Code Definition
O OPPOSITION
S SUPPORT
Sources: .CAL Format Layout (Version 2.01) (64), Map from .CAL Format to Database Table and Fields (40), .CAL Format Layout (Version 1.05.02) (49), CAL-ACCESS Tables, Columns and Indexes (46)

YEAR_ELECT   String (up to 4)

Year of election


POF_TITLE   String (up to 45)

Position/title of the principal officer


Forms

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


Form 400: Statement of Organization (Slate Mailer Organization)

Part 3, Individuals Who Authorize Contents Of Slate Mailers



Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
Oct. 17, 2017 42,846 Download »
Oct. 16, 2017 42,842 Download »
Oct. 15, 2017 42,842 Download »
Oct. 14, 2017 42,842 Download »
Oct. 13, 2017 42,832 Download »
Oct. 12, 2017 42,773 Download »
Oct. 11, 2017 42,772 Download »
Oct. 10, 2017 42,767 Download »
Oct. 9, 2017 42,760 Download »
Oct. 8, 2017 42,758 Download »
More past downloads »

References

The documents that provided the information on this page.

  • .CAL Format Layout (Version 2.01) (p. 62-64)

  • Map from .CAL Format to Database Table and Fields (p. 38-40)

  • .CAL Format Layout (Version 1.05.02) (p. 48-49)

  • CAL-ACCESS Tables, Columns and Indexes (p. 8, 45-46)