F501_502_CD

Candidate intention statements.

Latest download

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

Download latest   3M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

Information about the 55 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.


REC_TYPE   String (up to 4)

Record Type

Code Definition
CVR CVR
Sources: CAL-ACCESS Tables, Columns and Indexes (58)

FORM_TYPE   String (up to 4)

Name of the source filing form or schedule

Code Definition
F501 Form 501: Candidate Intention Statement
F502 Form 502: Campaign Bank Account Statement
Sources: CAL-ACCESS Tables, Columns and Indexes (58)

FILER_ID   String (up to 9)

Filer's unique identification number


COMMITTEE_ID   String (up to 9)

Committee identification number


ENTITY_CD   String (up to 9)

Entity code

Code Definition
ATH Authorizing individual
ATR Assistant treasurer
BMC Ballot measure committee
BNM Ballot measure's name/title
CAO Candidate/officeholder
COM Committee
CTL Controlled committee
IND Individual
MDI Major Donor/Ind Expenditure
OFF Officer
OTH Other
POF Principal officer
PRO Proponent
PTY Political Party
RCP Recipient committee
SCC Small Contributor Committee
SMO Slate-mailer organization
SPO Sponsor
TRE Treasurer
8 Unknown
Sources: .CAL Format Layout (Version 1.05.02) (8-9), .CAL Format Layout (Version 2.01) (9-11)

REPORT_NUM   String (up to 3)

Report Number; 000 Original; 001-999 Amended


RPT_DATE   Date (without time)

Date this report is filed


STMT_TYPE   Integer

Type of statement

Code Definition
10001 ORIGINAL/INITIAL
10002 AMENDMENT
10003 TERMINATION
10004 REDESIGNATE THE ACCOUNT FOR FUTURE ELECTION TO THE SAME OFFICE
10005 LOG
10006 LOG/AMENDMENT
10007 AS FILED BY COMMITTEE
Sources: Lookup-Codes-Cd (6)

FROM_DATE   String (up to 32)

Reporting period from date


THRU_DATE   String (up to 32)

Reporting period through date


ELECT_DATE   String (up to 32)

Date of election


CAND_NAML   String (up to 200)

Candidate/officerholder last name


CAND_NAMF   String (up to 45)

Candidate/officerholder first name


CAN_NAMM   String (up to 20)

Candidate/officeholder middle name


CAND_NAMT   String (up to 100)

Candidate/officerholder title or prefix


CAND_NAMS   String (up to 10)

Candidate/officeholder suffix


MONIKER_POS   String (up to 32)

Location of the candidate/officeholder's moniker


MONIKER   String (up to 20)

Candidate/officeholder's moniker


CAND_CITY   String (up to 30)

Candidate/officerholder city


CAND_ST   String (up to 4)

Candidate/officeholder state


CAND_ZIP4   String (up to 10)

Candidate/officeholder zip +4


CAND_PHON   String (up to 20)

Candidate/officeholder phone number


CAND_FAX   String (up to 20)

Candidate/officerholder fax


CAND_EMAIL   String (up to 60)

Candidate/officeholder email address


FIN_NAML   String (up to 200)

Financial institution's business name


FIN_NAMF   String (up to 45)

Unused. Financial institution's first name.


FIN_NAMT   String (up to 100)

Unused. Financial institution's title.


FIN_NAMS   String (up to 32)

Unused. Financial institution's suffix.


FIN_CITY   String (up to 30)

Financial institution's city.


FIN_ST   String (up to 4)

Financial institution's state.


FIN_ZIP4   String (up to 10)

Financial institution's zip code.


FIN_PHON   String (up to 20)

Financial institution's phone number.


FIN_FAX   String (up to 20)

Financial institution's FAX Number.


FIN_EMAIL   String (up to 60)

Financial institution's e-mail address.


OFFICE_CD   Integer

Identifies the office being sought

Code Definition
0 N/A
30001 PRESIDENT
30002 GOVERNOR
30003 LIEUTENANT GOVERNOR
30004 SECRETARY OF STATE
30005 CONTROLLER
30006 TREASURER
30007 ATTORNEY GENERAL
30008 SUPERINTENDENT OF PUBLIC INSTRUCTION
30009 MEMBER BOARD OF EQUALIZATION
30010 OXNARD HARBOR COMMISSIONER
30011 CITY CONTROLLER
30012 STATE SENATE
30013 ASSEMBLY
30014 INSURANCE COMMISSIONER
30015 JUDGE
30016 BOARD MEMBER
30017 TAX COLLECTOR
30018 TRUSTEE
30019 SUPERVISOR
30020 SHERIFF
30021 CORONER
30022 MARSHALL
30023 CITY CLERK
30024 SCHOOL BOARD
30025 HARBOR COMMISSIONER
30026 DISTRICT ATTORNEY
30027 COUNTY CLERK
30028 AUDITOR
30029 MAYOR
30030 CITY ATTORNEY
30031 DEMOCRATIC COUNTY CENTRAL COMMITTEE
30032 TOWN COUNCIL
30033 ASSESSOR
30034 CITY TREASURER
30035 CITY COUNCIL
30036 COMMISSIONER
30037 REPUBLICAN COUNTY CENTRAL COMMITTEE
30038 DIRECTOR
30039 DIRECTOR OF ZONE 7
30040 COMMUNITY COLLEGE BOARD
30041 POLICE CHIEF
30042 CHIEF OF POLICE
30043 CENTRAL COMMITTEE
30044 BOARD OF EDUCATION
30045 BOARD OF DIRECTORS
30046 COLLEGE BOARD
30047 BART BOARD DIRECTOR
30048 BOARD OF TRUSTEES
30049 IRRIGATION
30050 WATER BOARD
30051 COMMUNITY PLANNING GROUP
30052 BOARD OF SUPERVISORS
30053 SUPERIOR COURT JUDGE
30054 DISTRICT ATTORNEY/PUBLIC DEFENDER
30055 MEASURE
30056 CITY PROSECUTOR
30057 SUPREME COURT JUDGE
30058 PUBLIC EMPLOYEES RETIREMENT BOARD
30059 APPELLATE COURT JUDGE
50001 Ag
50002 Assembly
50003 Assessor
50004 Assessor/Clerk/Recorder
50005 Assessor/County Clerk/Recorder
50006 Assessor/Recorder
50007 Associate Justice
50008 Auditor
50009 Auditor/Controller
50010 Auditor/Controller/Clerk/Recorder
50011 Auditor/Controller/Recorder
50012 Auditor/Controller/Treasurer/Tax Collector
50013 Auditor/Recorder
50014 Board Member
50015 Board Of Director
50016 Board Of Supervisor
50017 Boe
50018 Chief Justice
50019 City
50020 City Attorney
50021 City Auditor
50022 City Clerk
50023 City Council
50024 City Of Los Angeles
50025 City Of South El Monte
50026 City Prosecutor
50027 City Treasurer
50028 Clerk/Auditor
50029 Clerk/Record/Public Admin
50030 Clerk/Recorder
50031 Clerk/Recorder/Registar
50032 Clerk/Recorder/Registrar
50033 Commissioner
50034 Controller
50035 Costa Mesa
50036 Council Member
50037 County Clerk
50038 County Clerk/Auditor
50039 County Clerk/Auditor/Controller
50040 County Clerk/Recorder
50041 County Clerk/Recorder/Assessor
50042 County Clerk/Recorder/Public Admin
50043 Democratic County Central Committee
50044 Director
50045 District Attorney
50046 District Attorney/Public Administrator
50047 Gccc
50048 Governor
50049 Harbor Commissioner
50050 Ic
50051 Irrigation Dist
50052 Judge
50053 Justice
50054 Legislature
50055 Lieutenant Governor
50056 Mayor
50057 N/A
50058 Placentia
50059 Public Administrator
50060 Public Administrator/Guardian
50061 Rent Stabilization Board
50062 Republican Central Committee
50063 San Francisco Dccc
50064 Sanger
50065 School Board
50066 Secretary Of State
50067 Senator
50068 Sheriff
50069 Sheriff/Coroner
50070 Sheriff/Coroner/Marshall
50071 Sheriff/Coroner/Public Administrator
50072 Solana Beach
50073 Superintendent
50074 Supervisor
50075 Supt Of Schools
50076 Tax Collector
50077 Town Council
50078 Treasurer
50079 Treasurer/Tax Collector
50080 Treasurer/Tax Collector/Clerk
50081 Treasurer/Tax Collector/Public Administrator
50082 Treasurer/Tax Collector/Public Administrator/County Clerk
50083 Treasurer/Tax Collector/Recorder
50084 Trustee
50085 Weed Recreation Board Member
Sources: Lookup-Codes-Cd (20-22)

OFFIC_DSCR   String (up to 80)

Office sought description


AGENCY_NAM   String (up to 200)

Agency name


JURIS_CD   Integer

Office jurisdiction code

Code Definition
0 N/A
40501 LOCAL
40502 STATE
40503 COUNTY
40504 MULTI-COUNTY
40505 CITY
40507 SUPERIOR COURT JUDGE
Sources: Lookup-Codes-Cd (19-20)

JURIS_DSCR   String (up to 30)

Office jurisdiction description


DIST_NO   String (up to 4)

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


PARTY   String (up to 200)

Political party


YR_OF_ELEC   Integer

Year of election


ELEC_TYPE   Integer

Election type

Code Definition
0 N/A
3001 GENERAL
3002 PRIMARY
3003 RECALL
3004 SPECIAL ELECTION
3005 OFFICEHOLDER
3006 SPECIAL RUNOFF
3007 UNKNOWN
Sources: Lookup-Codes-Cd (3-4)

EXECUTE_DT   Date (without time)

Execution date


CAN_SIG   String (up to 200)

Candidate signature


ACCOUNT_NO   String (up to 32)

Account number


ACCT_OP_DT   Date (without time)

Account open date


PARTY_CD   Integer

Party code

Code Definition
0 N/A
16001 DEMOCRATIC
16002 REPUBLICAN
16003 GREEN PARTY
16004 REFORM PARTY
16005 AMERICAN INDEPENDENT PARTY
16006 PEACE AND FREEDOM
16007 INDEPENDENT
16008 LIBERTARIAN
16009 NON PARTISAN
16010 NATURAL LAW
16011 UNKNOWN
16012 NO PARTY PREFERENCE
16013 AMERICANS ELECT
16014 UNKNOWN
16020 PEACE AND FREEDOM
Sources: Lookup-Codes-Cd (10-11)

DISTRICT_CD   Integer

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

Code Definition
0 N/A
17001 01
17002 13
17003 24
17004 35
17005 46
17006 57
17007 68
17008 79
17009 02
17010 05
17011 04
17013 06
17014 07
17015 08
17016 19
17017 10
17018 11
17019 12
17020 14
17021 15
17022 16
17023 17
17024 18
17026 20
17027 21
17028 22
17029 23
17030 25
17031 26
17032 27
17033 28
17034 29
17035 30
17036 31
17037 32
17038 33
17039 34
17040 36
17041 37
17042 38
17043 39
17044 40
17045 41
17046 42
17047 43
17048 44
17049 45
17050 47
17051 48
17052 49
17053 50
17054 51
17055 52
17056 53
17057 54
17058 55
17059 56
17060 03
17061 59
17062 60
17063 61
17064 62
17065 63
17066 64
17067 65
17068 66
17069 67
17070 69
17071 70
17072 71
17073 72
17074 73
17075 74
17076 75
17077 76
17078 77
17079 78
17080 80
17081 09
17090 58
17012 Unknown
17082 Unknown
17025 Unknown
Sources: Lookup-Codes-Cd (11-13)

ACCEPT_LIMIT_YN   Integer

This field is undocumented


DID_EXCEED_DT   Date (without time)

This field is undocumented


CNTRB_PRSNL_FNDS_DT   Date (without time)

This field is undocumented


Forms

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




Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
Oct. 17, 2017 16,053 Download »
Oct. 16, 2017 16,053 Download »
Oct. 15, 2017 16,053 Download »
Oct. 14, 2017 16,053 Download »
Oct. 13, 2017 16,053 Download »
Oct. 12, 2017 16,053 Download »
Oct. 11, 2017 16,049 Download »
Oct. 10, 2017 16,049 Download »
Oct. 9, 2017 16,044 Download »
Oct. 8, 2017 16,044 Download »
More past downloads »

References

The documents that provided the information on this page.

  • CAL-ACCESS Tables, Columns and Indexes (p. 8, 57-59)