S497_CD
Campaign contributions made or received 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 965,987 rows of data published on Sunday, Dec. 8, 2019*.
Download latest 155M CSV
Alternatively, retrieve with curl
.
Sample
A few sample rows.
Fields
Information about the 42 fields and the definitions of any abbreviated values.
Unique filing identification number
Amendment identification number. A number of 0 is the original filing and 1 to 999 amendments.
Line item number of this record
Record Type Value: S497
Code | Definition |
---|---|
S497 |
S497 |
Sources: .CAL Format Layout (Version 1.05.02) (41), .CAL Format Layout (Version 2.01) (54) |
Name of the source filing form or schedule
Code | Definition |
---|---|
F497P1 |
Form 497 (Late Contribution Report): Part 1, Contributions Received |
F497P2 |
Form 497 (Late Contribution Report): Part 2, Contributions Made |
Sources: .CAL Format Layout (Version 1.05.02) (41), .CAL Format Layout (Version 2.01) (54) |
Permanent value unique to this item
Entity Code describing the Contributor/Recipient
Code | Definition |
---|---|
BNM |
Ballot measure's name/title |
CAO |
Candidate/officeholder |
CTL |
Controlled committee |
COM |
Committee |
com |
Committee |
IND |
Individual |
OFF |
Officer |
OTH |
Other |
PTY |
Political Party |
RCP |
Recipient committee |
SCC |
Small Contributor Committee |
0 |
Unknown |
Sources: .CAL Format Layout (Version 1.05.02) (8-9, 41), .CAL Format Layout (Version 2.01) (9-11, 54) |
Last name of Contributor/Recipient
First name of Contributor/Recipient
Name title or prefix of Contributor/Recipient
Name suffix of Contributor/Recipient
City address of Contributor/Recipient
State address of Contributor/Recipient
ZIP Code of Contributor/Recipient
Employer of Contributor (populated for some Recipients as well)
Occupation of Contributor (populated for some Recipients as well)
Contributor self-employed checkbox. "X" indicates the contributor is self-employed.
Date of election
Date item received/made
End of date range for items received
Amount received/made
Committee identification number
Candidate/officeholder's last name
Candidate/officeholder's first name
Candidate/officeholder's title or prefix
Candidate/officeholder's suffix
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 |
sen |
State Senator |
Asm |
State Assembly Person |
May |
Mayor |
ASm |
State Assembly Person |
oth |
Other |
csu |
County Supervisor |
Oth |
Other |
H |
Unknown |
S |
Unknown |
OF |
Unknown |
HOU |
Unknown |
LOC |
Unknown |
LEG |
Unknown |
STW |
Unknown |
P |
Unknown |
LTV |
Unknown |
LT |
Unknown |
CTY |
Unknown |
OFF |
Unknown |
REP |
Unknown |
COM |
Unknown |
N/A |
Unknown |
Sources: .CAL Version 2.01 Errata (2), .CAL Format Layout (Version 1.05.02) (10), .CAL Format Layout (Version 2.01) (12) |
Office sought description
Jurisdiction code describing the office being sought
Code | Definition |
---|---|
ASM |
Assembly District |
BOE |
Board of Equalization District |
CIT |
City |
CTY |
County |
LOC |
Local |
OTH |
Other |
SEN |
Senate District |
STW |
Statewide |
asm |
Assembly District |
sen |
Senate District |
cit |
City |
GOV |
Statewide |
MAY |
City |
BSU |
County |
CSU |
County |
SUP |
Statewide |
BED |
Other |
CCB |
Other |
CCM |
Other |
CLB |
Other |
IRV |
City |
Fon |
City |
JRS |
Statewide |
CO |
County |
Riv |
County |
SNE |
Senate District |
83 |
Statewide |
PER |
Unknown |
FED |
Unknown |
CA |
Unknown |
JR |
Unknown |
Sources: .CAL Format Layout (Version 1.05.02) (42), .CAL Format Layout (Version 2.01) (55) |
Office jurisdiction description
District number for the office being sought. Populated for Senate, Assembly, or Board of Equalization races.
Office is sought or held code
Code | Definition |
---|---|
H |
HELD |
S |
SOUGHT |
s |
SOUGHT |
h |
HELD |
F |
UNKNOWN |
T |
UNKNOWN |
Sources: .CAL Format Layout (Version 1.05.02) (42), .CAL Format Layout (Version 2.01) (55) |
Ballot measure name
Ballot measure number
Ballot measure jurisdiction
Memo amount flag
Reference to text contained in TEXT code
This field is undocumented
This field is undocumented
This field is undocumented
Support or opposition code
Code | Definition |
---|---|
O |
OPPOSITION |
S |
SUPPORT |
Sources: Map from .CAL Format to Database Table and Fields (82) |
Forms
The forms that the state uses to collect the information that populates this file.
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 19 records out of 966,006 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. 8, 2019 | 965,987 | Download » | |
Dec. 7, 2019 | 965,975 | Download » | |
Dec. 6, 2019 | 965,695 | Download » | |
Dec. 5, 2019 | 965,141 | Download » | |
Dec. 4, 2019 | 965,055 | Download » | |
Dec. 3, 2019 | 965,028 | Download » | |
Dec. 2, 2019 | 965,015 | Download » | |
Dec. 1, 2019 | 965,015 | Download » | |
Nov. 30, 2019 | 965,015 | Download » | |
Nov. 29, 2019 | 965,009 | Download » | |
More past downloads » |
References
The documents that provided the information on this page.