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 48,837 rows of data published on Monday, Dec. 10, 2018*.

Download latest   5M 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: 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), .CAL Format Layout (Version 2.01) (58)

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

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 Version 2.01 Errata (2), .CAL Format Layout (Version 1.05.02) (10), .CAL Format Layout (Version 2.01) (12)

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: Map from .CAL Format to Database Table and Fields (39), .CAL Format Layout (Version 1.05.02) (49), .CAL Format Layout (Version 2.01) (63)

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: Map from .CAL Format to Database Table and Fields (39), CAL-ACCESS Tables, Columns and Indexes (46), .CAL Format Layout (Version 1.05.02) (49), .CAL Format Layout (Version 2.01) (63)

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: Map from .CAL Format to Database Table and Fields (40), CAL-ACCESS Tables, Columns and Indexes (46), .CAL Format Layout (Version 1.05.02) (49), .CAL Format Layout (Version 2.01) (64)

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



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 1 records out of 48,838 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. 10, 2018 48,837 Download »
Dec. 9, 2018 48,837 Download »
Dec. 8, 2018 48,837 Download »
Dec. 7, 2018 48,810 Download »
Dec. 6, 2018 48,793 Download »
Dec. 5, 2018 48,787 Download »
Dec. 4, 2018 48,775 Download »
Dec. 3, 2018 48,763 Download »
Dec. 2, 2018 48,763 Download »
Nov. 30, 2018 48,763 Download »
More past downloads »

References

The documents that provided the information on this page.

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

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

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

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