EXPN_CD

Itemized campaign expenditures.

Latest download

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

Download latest   979M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

Information about the 54 fields and the definitions of any abbreviated values.


AGENT_NAMF   String (up to 45)

Agent of Ind. Contractor's First name


AGENT_NAML   String (up to 200)

Agent of Ind. Contractor's Last name (Sched G)


AGENT_NAMS   String (up to 10)

Agent of Ind. Contractor's Suffix


AGENT_NAMT   String (up to 10)

Agent of Ind. Contractor's Prefix or Title


AMEND_ID   Integer · Unique

Amendment identification number. A number of 0 is the original filing and 1 to 999 amendments.


AMOUNT   Decimal number

Amount of Payment


BAKREF_TID   String (up to 20)

Back Reference to a Tran_ID of a 'parent' record


BAL_JURIS   String (up to 40)

Ballot measure's jurisdiction


BAL_NAME   String (up to 200)

Ballot Measure Name


BAL_NUM   String (up to 7)

Ballot Number or Letter


CAND_NAMF   String (up to 45)

Candidate's First name


CAND_NAML   String (up to 200)

Candidate's Last name


CAND_NAMS   String (up to 10)

Candidate's Suffix


CAND_NAMT   String (up to 10)

Candidate's Prefix or Title


CMTE_ID   String (up to 9)

Committee ID (If [COM|RCP] & no ID#, Treas info Req.)


CUM_OTH   Decimal number

Cumulative / 'Other' (No Cumulative on Sched E & G)


CUM_YTD   Decimal number

Cumulative / Year-to-date amount (No Cumulative on Sched E & G)


DIST_NO   String (up to 3)

Office District Number (Req. if Juris_Cd=[SEN|ASM|BOE]


ENTITY_CD   String (up to 3)

Entity Code describing payee

Code Definition
COM Committee
IND Individual
RCP Recipient committee
OTH Other
PTY Political Party
SCC Small Contributor Committee
BNM Ballot measure's name/title
CAO Candidate/officeholder
MBR Member of Associaton
OFF Officer
0 Unknown
PTH Unknown
RFD Unknown
Sources: .CAL Format Layout (Version 1.05.02) (8-9, 31), .CAL Format Layout (Version 2.01) (9-11, 42)

EXPN_CHKNO   String (up to 20)

Check Number (Optional)


EXPN_CODE   String (up to 3)

The type of expenditure

Code Definition
CMP campaign paraphernalia/miscellaneous
CNS campaign consultants
CTB contribution (if nonmonetary, explain)*
CVC civic donations
FIL candidate filing/ballot feeds
FND fundraising events
IKD In-kind contribution (nonmonetary)
IND independent expenditure supporting/opposing others (explain)*
LEG legal defense
LIT campaign literature and mailings
LON loan
MBR member communications
MON monetary contribution
MTG meetings and appearances
OFC office expenses
PET petition circulating
PHO phone banks
POL polling and survey research
POS postage, delivery and messenger services
PRO professional services (legal, accounting)
PRT print ads
RAD radio airtime and production costs
RFD returned contributions
SAL campaign workers salaries
TEL T.V. or cable airtime and production costs
TRC candidate travel, lodging and meals (explain)
TRS staff/spouse travel, lodging and meals (explain)
TSF transfer between committees of the same candidate/sponsor
VOT voter registration
WEB information technology costs (internet, e-mail)
ctb contribution (if nonmonetary, explain)*
ikd In-kind contribution (nonmonetary)
Mon monetary contribution
ofc office expenses
OFc office expenses
Ofc office expenses
Unknown
* Unknown
0 Unknown
001 Unknown
011 Unknown
200 Unknown
401 Unknown
ADV Unknown
ANN Unknown
APR Unknown
AUG Unknown
AUT Unknown
Ban Unknown
BAN Unknown
BOO Unknown
BOX Unknown
C Unknown
CAT Unknown
CC Unknown
CHE Unknown
CIV Unknown
CNT Unknown
CON Unknown
COP Unknown
CRE Unknown
CSN Unknown
CT Unknown
,CT Unknown
.CT Unknown
CTN Unknown
CVD Unknown
DAT Unknown
DEC Unknown
Dem Unknown
DIN Unknown
Don Unknown
DON Unknown
Ear Unknown
EIM Unknown
EMP Unknown
F Unknown
FAX Unknown
FDN Unknown
FED Unknown
FEE Unknown
FIN Unknown
Fun Unknown
FUN Unknown
G Unknown
GEN Unknown
GGG Unknown
GOT Unknown
IEs Unknown
IN- Unknown
Ina Unknown
INK Unknown
INS Unknown
ITE Unknown
JAN Unknown
JUL Unknown
JUN Unknown
KIC Unknown
L Unknown
LEV Unknown
Lit Unknown
LN# Unknown
LOG Unknown
M Unknown
MAI Unknown
Mar Unknown
MAR Unknown
MAY Unknown
MED Unknown
MEE Unknown
MGT Unknown
Mis Unknown
MRB Unknown
NGP Unknown
NON Unknown
NOT Unknown
NOV Unknown
O Unknown
OCT Unknown
.OF Unknown
OFF Unknown
OPE Unknown
OTH Unknown
P Unknown
Pac Unknown
PAI Unknown
PAR Unknown
PAY Unknown
PEN Unknown
PMT Unknown
.PO Unknown
Pos Unknown
PRE Unknown
PRI Unknown
PRP Unknown
R Unknown
.Re Unknown
.RE Unknown
REF Unknown
REI Unknown
RFP Unknown
S Unknown
S-A Unknown
SA Unknown
Sal Unknown
S C Unknown
S.C Unknown
SCU Unknown
SEE Unknown
SEN Unknown
SEP Unknown
S.M. Unknown
SOF Unknown
SWI Unknown
T Unknown
TAX Unknown
TB Unknown
TB, Unknown
TIC Unknown
Tor Unknown
TRA Unknown
TRF Unknown
TRV Unknown
UN Unknown
UTI Unknown
V Unknown
VEN Unknown
-VO Unknown
VOI Unknown
VOY Unknown
WI Unknown
x Unknown
X Unknown
S-6 Unknown
S.M Unknown
S-4 Unknown
SA: Unknown
100 Unknown
RFN Unknown
REN Unknown
003 Unknown
S-1 Unknown
08 Unknown
Sources: .CAL Format Layout (Version 1.05.02) (11), .CAL Format Layout (Version 2.01) (13-14)

EXPN_DATE   Date (without time)

Date of Expenditure (Note: Date not on Sched E & G)


EXPN_DSCR   String (up to 400)

Purpose of expense and/or description/explanation


FILING_ID   Integer · Unique

Unique filing identification number


FORM_TYPE   String (up to 6) · Unique

Name of the source filing form or schedule

Code Definition
F450P5 Form 450 (Campaign Disclosure Statement, Short Form (Recipient Committee)): Part 5, Payments Made
D Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule D, Summary of Expenditures Supporting / Opposing Other Candidates, Measures and Committees
E Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule E, Payments Made
G Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule G, Payments Made by an Agent or Independent Contractor (on Behalf of This Committee)
F461P5 Form 461 (Campaign Disclosure Statement (Independent Expenditure Committee & Major Donor Committee)): Part 5, Contributions (Including Loans, Forgiveness of Loans, and LoanGuarantees) and Expenditures Made
F465P3 Form 465 (Supplemental Independent Expenditure Report): Part 3, Independent Expenditures Made
F900 Form 900: Campaign Disclosure Statement (Public employee retirement board candidate)
Sources: .CAL Format Layout (Version 1.05.02) (31), .CAL Format Layout (Version 2.01) (42)

G_FROM_E_F   String (up to 1)

Back Reference from Sched G to Sched 'E' or 'F'?


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
Cit City
sen Senate District
Sen Senate District
stw Statewide
APP Statewide
ASR County
ATT Statewide
GOV Statewide
LTG Statewide
SOS Statewide
SUP Statewide
TRE Statewide
BSU County
CSU County
ES City
SM City
BED Other
CCB Other
CCM Other
PDR Other
12 Senate District
4 Statewide
8 Statewide
27 Statewide
93 Statewide
98 Statewide
CLB Unknown
PER Unknown
Boa Board of Equalization District
Sta Unknown
STA Unknown
CA Unknown
SAN Unknown
ES Unknown
CON Unknown
LA Unknown
LBC Unknown
OR Unknown
SB Unknown
WES Unknown
BM Unknown
(Lo Unknown
(Ci Unknown
vty Unknown
OC Unknown
SM Unknown
ASS Unknown
JR Unknown
O Unknown
ADM Unknown
SAC Unknown
US Unknown
J Unknown
LOS Unknown
IRV Unknown
CO Unknown
JRS Unknown
NEV Unknown
IB Unknown
A Unknown
Ass Unknown
SD Unknown
D Unknown
SEC Unknown
SC Unknown
RB Unknown
GEN Unknown
CC Unknown
FED Unknown
FM Unknown
R Unknown
Sources: .CAL Format Layout (Version 1.05.02) (32), .CAL Format Layout (Version 2.01) (44)

JURIS_DSCR   String (up to 40)

Office Jurisdiction Description (Req. if Juris_Cd=[CIT|CTY|LOC|OTH]


LINE_ITEM   Integer · Unique

Line item number of this record


MEMO_CODE   String (up to 1)

Memo Amount? (Date/Amount are informational only). For Form 460 filings, this indicates the record is a sub-item and its amount is included in another item reported on the filing.


MEMO_REFNO   String (up to 20)

Reference to text contained in a TEXT record.


OFF_S_H_CD   String (up to 1)

Office is sought or held code

Code Definition
H HELD
S SOUGHT
s SOUGHT
h HELD
A UNKNOWN
a UNKNOWN
8 UNKNOWN
O UNKNOWN
Sources: .CAL Format Layout (Version 1.05.02) (32), .CAL Format Layout (Version 2.01) (44)

OFFIC_DSCR   String (up to 40)

Office Sought Description (Req. if Office_Cd=OTH)


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
Cou County Counsel
sen State Senator
AtT Attorney General
May Mayor
Sen State Senator
asm State Assembly Person
gov Governor
Gov Governor
LA Unknown
HOU Unknown
LAD Unknown
11A Unknown
001 Unknown
BM Unknown
AS1 Unknown
ASS Unknown
73 Unknown
CIT Unknown
HSE Unknown
LT Unknown
CTY Unknown
STA Unknown
GO Unknown
CO Unknown
A Unknown
PAC Unknown
REP Unknown
OFF Unknown
SE Unknown
031 Unknown
COM Unknown
ASB Unknown
OT Unknown
NAT Unknown
CC Unknown
SWE Unknown
FED Unknown
STE Unknown
H Unknown
DA Unknown
S Unknown
AS Unknown
OF Unknown
LEG Unknown
STW Unknown
ST Unknown
PRE Unknown
/S Unknown
U S Unknown
O Unknown
8 Unknown
C:S Unknown
Sources: .CAL Format Layout (Version 1.05.02) (10), .CAL Format Layout (Version 2.01) (12), .CAL Version 2.01 Errata (2)

PAYEE_CITY   String (up to 30)

Payee City


PAYEE_NAMF   String (up to 45)

Payee's First name


PAYEE_NAML   String (up to 200)

Payee's Last name


PAYEE_NAMS   String (up to 10)

Payee's Suffix


PAYEE_NAMT   String (up to 10)

Payee's Prefix or Title


PAYEE_ST   String (up to 2)

State code


PAYEE_ZIP4   String (up to 10)

Zip+4


REC_TYPE   String (up to 4) · Unique

Record Type Value: EXPN

Code Definition
EXPN Expense
Sources: .CAL Format Layout (Version 1.05.02) (31), .CAL Format Layout (Version 2.01) (42)

SUP_OPP_CD   String (up to 1)

Support or opposition code

Code Definition
O OPPOSITION
S SUPPORT
s SUPPORT
o OPPOSITION
H UNKNOWN
N UNKNOWN
X UNKNOWN
Y UNKNOWN
Sources: .CAL Format Layout (Version 1.05.02) (32), .CAL Format Layout (Version 2.01) (44)

TRAN_ID   String (up to 20)

Permanent value unique to this item


TRES_CITY   String (up to 30)

Treasurer City


TRES_NAMF   String (up to 45)

Treasurer's First name (Req if [COM|RCP] & no ID#)


TRES_NAML   String (up to 200)

Treasurer's Last name (Req if [COM|RCP] & no ID#)


TRES_NAMS   String (up to 10)

Treasurer's Suffix


TRES_NAMT   String (up to 10)

Treasurer's Prefix or Title


TRES_ST   String (up to 2)

Treasurer State


TRES_ZIP4   String (up to 10)

Treasurer ZIP+4


XREF_MATCH   String (up to 1)

X = Related item on other Sched has same Tran_ID


XREF_SCHNM   String (up to 2)

Related item is included on Sched 'C' or 'H2'


Forms

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



Form 460: Campaign Disclosure Statement (Recipient Committee)

Schedule D, Summary of Expenditures Supporting / Opposing Other Candidates, Measures and Committees

Schedule E, Payments Made

Schedule G, Payments Made by an Agent or Independent Contractor (on Behalf of This Committee)


Form 461: Campaign Disclosure Statement (Independent Expenditure Committee & Major Donor Committee)

Part 5, Contributions (Including Loans, Forgiveness of Loans, and LoanGuarantees) and Expenditures Made


Form 465: Supplemental Independent Expenditure Report

Part 3, Independent Expenditures Made



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 459 records out of 5,832,053 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 5,831,594 Download »
Oct. 16, 2017 5,831,467 Download »
Oct. 15, 2017 5,831,467 Download »
Oct. 14, 2017 5,831,467 Download »
Oct. 13, 2017 5,831,189 Download »
Oct. 12, 2017 5,831,063 Download »
Oct. 11, 2017 5,830,955 Download »
Oct. 10, 2017 5,830,730 Download »
Oct. 9, 2017 5,830,577 Download »
Oct. 8, 2017 5,830,576 Download »
More past downloads »

References

The documents that provided the information on this page.

  • .CAL Format Layout (Version 1.05.02) (p. 31-32)

  • .CAL Format Layout (Version 2.01) (p. 42-44)

  • CAL-ACCESS Tables, Columns and Indexes (p. 8, 53-56)

  • Map from .CAL Format to Database Table and Fields (p. 45-48)