S401_CD

Payments and other disclosures made by slate-mailer organizations.

Latest download

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

Download latest   5M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

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

Record Type Value: S401

Code Definition
S401 S401
Sources: .CAL Format Layout (Version 1.05.02) (39), .CAL Format Layout (Version 2.01) (51)

FORM_TYPE   String (up to 7) · Unique

Name of the source filing form or schedule

Code Definition
F401B Form 401 (Campaign Disclosure Statement (Slate Mailer Organization)): Schedule B, Payments Made
F401B-1 Form 401 (Campaign Disclosure Statement (Slate Mailer Organization)): Schedule B-1, Payments Made by Agent or Independent Contractor
F401C Form 401 (Campaign Disclosure Statement (Slate Mailer Organization)): Schedule C, Persons Receiving $1,000 or More
F401D Form 401 (Campaign Disclosure Statement (Slate Mailer Organization)): Schedule D, Candidates and Measures Not Listed on Schedule A
Sources: .CAL Format Layout (Version 1.05.02) (39), .CAL Format Layout (Version 2.01) (51)

TRAN_ID   String (up to 20)

Permanent value unique to this item


AGENT_NAML   String (up to 200)

Agent or independent contractor's last name


AGENT_NAMF   String (up to 45)

Agent or independent contractor's first name


AGENT_NAMT   String (up to 200)

Agent or independent contractor's title or prefix


AGENT_NAMS   String (up to 10)

Agent or independent contractor's suffix


PAYEE_NAML   String (up to 200)

Payee's business name or last name if the payee is an individual


PAYEE_NAMF   String (up to 45)

Payee's first name if the payee is an individual


PAYEE_NAMT   String (up to 10)

Payee's title or prefix if the payee is an individual


PAYEE_NAMS   String (up to 10)

Payee's suffix if the payee is an individual


PAYEE_CITY   String (up to 30)

Payee's city address


PAYEE_ST   String (up to 2)

Payee state address


PAYEE_ZIP4   String (up to 10)

Payee ZIP Code


AMOUNT   Decimal number

Amount (Sched F401B, 401B-1, 401C)


AGGREGATE   Decimal number

Aggregate year-to-date amount (Sched 401C)


EXPN_DSCR   String (up to 90)

Purpose of expense and/or description/explanation


CAND_NAML   String (up to 200)

Candidate/officeholder last name


CAND_NAMF   String (up to 45)

Candidate/officeholder first name


CAND_NAMT   String (up to 10)

Candidate/officeholder title or prefix


CAND_NAMS   String (up to 10)

Candidate/officeholder suffix


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
ltg Lieutenant Governor
OTh Other
att Attorney General
oth Other
tre State Treasurer
con State Controller
boe Board of Equalization Member
sos Secretary of State
sup Superintendent of Public Instruction
H 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


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
SAC Unknown
CT Unknown
ca Unknown
CAL Unknown
OR Unknown
AL Unknown
CA Unknown
10 Unknown
Sources: .CAL Format Layout (Version 1.05.02) (39), .CAL Format Layout (Version 2.01) (52), Map from .CAL Format to Database Table and Fields (77)

JURIS_DSCR   String (up to 40)

Office jurisdiction description


DIST_NO   String (up to 3)

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


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) (39), .CAL Format Layout (Version 2.01) (52)

BAL_NAME   String (up to 200)

Ballot measure name


BAL_NUM   String (up to 7)

Ballot measure number or letter


BAL_JURIS   String (up to 40)

Ballot measure jurisdiction


SUP_OPP_CD   String (up to 1)

Support or opposition code

Code Definition
S SUPPORT
O OPPOSITION
Sources: .CAL Format Layout (Version 1.05.02) (39), .CAL Format Layout (Version 2.01) (52)

MEMO_CODE   String (up to 1)

Memo amount flag


MEMO_REFNO   String (up to 20)

Reference to text contained in the TEXT record


BAKREF_TID   String (up to 20)

Back reference to transaction identifier of parent record


Forms

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


Form 401: Campaign Disclosure Statement (Slate Mailer Organization)

Schedule B, Payments Made

Schedule B-1, Payments Made by Agent or Independent Contractor

Schedule C, Persons Receiving $1,000 or More

Schedule D, Candidates and Measures Not Listed on Schedule A


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 13 records out of 47,207 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 47,194 Download »
Oct. 16, 2017 47,194 Download »
Oct. 15, 2017 47,194 Download »
Oct. 14, 2017 47,194 Download »
Oct. 13, 2017 47,194 Download »
Oct. 12, 2017 47,194 Download »
Oct. 11, 2017 47,194 Download »
Oct. 10, 2017 47,194 Download »
Oct. 9, 2017 47,194 Download »
Oct. 8, 2017 47,194 Download »
More past downloads »

References

The documents that provided the information on this page.

  • .CAL Format Layout (Version 1.05.02) (p. 39)

  • .CAL Format Layout (Version 2.01) (p. 51-52)

  • CAL-ACCESS Tables, Columns and Indexes (p. 123-124)

  • Map from .CAL Format to Database Table and Fields (p. 76-78)