S498_CD

Payments received by slate-mailer organizations in the 90 days before an election.

Latest download

The most recent release from CAL-ACCESS, the database that tracks campaign finance and lobbying activity in California politics. It contains 16,248 rows of data published on Tuesday, Sept. 18, 2018*.

Download latest   2M 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: S498

Code Definition
S498 S498
Sources: .CAL Format Layout (Version 1.05.02) (43), .CAL Format Layout (Version 2.01) (56)

FORM_TYPE   String (up to 9) · Unique

Name of the source filing form or schedule

Code Definition
F498-A Form 498 (Late Payment Report (Slate Mailer Organization)): Part A, Late Payments Attributed To
F498-R Form 498 (Late Payment Report (Slate Mailer Organization)): Part R, Late Payments Received From
Sources: .CAL Format Layout (Version 1.05.02) (43), .CAL Format Layout (Version 2.01) (56)

TRAN_ID   String (up to 20)

Permanent value unique to this item


ENTITY_CD   String (up to 3)

Entity code

Code Definition
CAO Candidate/officeholder
COM Committee
IND Individual
OTH Other
RCP Recipient committee
Sources: .CAL Format Layout (Version 1.05.02) (8-9, 43), .CAL Format Layout (Version 2.01) (9-11, 56)

CMTE_ID   String (up to 9)

Committee identification number


PAYOR_NAML   String (up to 200)

Payor's last name or business name


PAYOR_NAMF   String (up to 45)

Payor's first name.


PAYOR_NAMT   String (up to 10)

Payor's Prefix or title.


PAYOR_NAMS   String (up to 10)

Payor's suffix.


PAYOR_CITY   String (up to 30)

Payor's city.


PAYOR_ST   String (up to 2)

Payor's State.


PAYOR_ZIP4   String (up to 10)

Payor's zip code


DATE_RCVD   Date (without time)

Date received


AMT_RCVD   Decimal number

Amount received


CAND_NAML   String (up to 200)

Candidate/officerholder last name


CAND_NAMF   String (up to 45)

Candidate/officerholder first name


CAND_NAMT   String (up to 10)

Candidate/officerholder title or prefix


CAND_NAMS   String (up to 10)

Candidate/officerholder suffix


OFFICE_CD   String (up to 4)

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
oth Other
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)

Description of office sought


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
GOV Statewide
COU County
Sources: .CAL Format Layout (Version 1.05.02) (43), .CAL Format Layout (Version 2.01) (57)

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
H HELD
S SOUGHT
Sources: .CAL Format Layout (Version 1.05.02) (44), .CAL Format Layout (Version 2.01) (57)

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)

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 1.05.02) (43), .CAL Format Layout (Version 2.01) (57)

AMT_ATTRIB   Decimal number

Amount attributed (only if Form_type = 'F498-A')


MEMO_CODE   String (up to 1)

Memo amount flat


MEMO_REFNO   String (up to 20)

Reference text contained in TEXT record


EMPLOYER   String (up to 200)

This field is undocumented


OCCUPATION   String (up to 60)

This field is undocumented


SELFEMP_CB   String (up to 1)

Self-employed checkbox


Forms

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


Form 498: Late Payment Report (Slate Mailer Organization)

Part A, Late Payments Attributed To

Part R, Late Payments Received From


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 2 records out of 16,250 total rows were lost (you can download them here).

Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
Sept. 18, 2018 16,248 Download »
Sept. 17, 2018 16,180 Download »
Sept. 16, 2018 16,180 Download »
Sept. 15, 2018 16,166 Download »
Sept. 14, 2018 16,150 Download »
Sept. 13, 2018 16,106 Download »
Sept. 12, 2018 16,086 Download »
Sept. 11, 2018 16,070 Download »
Sept. 10, 2018 16,066 Download »
Sept. 9, 2018 16,066 Download »
More past downloads »

References

The documents that provided the information on this page.

  • CAL-ACCESS Tables, Columns and Indexes (p. 12, 127-129)

  • .CAL Format Layout (Version 1.05.02) (p. 43-44)

  • .CAL Format Layout (Version 2.01) (p. 56-57)

  • Map from .CAL Format to Database Table and Fields (p. 83-85)