Archived download

The Friday, March 24, 2017 release of CAL-ACCESS database, the government database that tracks campaign finance and lobbying activity in California politics. It was published by state officials at 11:20 a.m. Latest release » Other past releases »

Full archive

The complete package of 80 database tables released by California's Secretary of State, which we have cleaned up and converted into flat files with 0 rows of comma-separated values^*.

Download 129K zip

Alternatively, retrieve with curl.

Coming soon

Simplified files that reshape the source data so it's easy to understand and analyze. Learn more »

Archived files

Our cleaned-up version of each of the 80 CAL-ACCESS database tables released by state officials, grouped by type.

CVR2_CAMPAIGN_DISCLOSURE_CD

CAMPAIGN

Extra information from campaign-disclosure forms. The source file published by the state is empty. Learn more »

Unavailable
CVR2_SO_CD

CAMPAIGN

Extra information from a statement-of-organization form. The source file published by the state is empty. Learn more »

Unavailable
CVR3_VERIFICATION_INFO_CD

CAMPAIGN

Verification information from campaign-disclosure forms. The source file published by the state is empty. Learn more »

Unavailable
CVR_CAMPAIGN_DISCLOSURE_CD

CAMPAIGN

The cover page of campaign-disclosure forms. The source file published by the state is empty. Learn more »

Unavailable
CVR_SO_CD

CAMPAIGN

The cover page for statement-of-organization forms that create or terminate an entity. The source file published by the state is empty. Learn more »

Unavailable
DEBT_CD

CAMPAIGN

Itemized campaign debts. The source file published by the state is empty. Learn more »

Unavailable
EXPN_CD

CAMPAIGN

Itemized campaign expenditures. The source file published by the state is empty. Learn more »

Unavailable
F495P2_CD

CAMPAIGN

Supplemental pre-election campaign statements. The source file published by the state is empty. Learn more »

Unavailable
F501_502_CD

CAMPAIGN

Candidate intention statements. The source file published by the state is empty. Learn more »

Unavailable
LOAN_CD

CAMPAIGN

Itemized campaign loans. The source file published by the state is empty. Learn more »

Unavailable
RCPT_CD

CAMPAIGN

Itemized campaign contributions. The source file published by the state is empty. Learn more »

Unavailable
S401_CD

CAMPAIGN

Payments and other disclosures made by slate-mailer organizations. The source file published by the state is empty. Learn more »

Unavailable
S496_CD

CAMPAIGN

Itemized independent expenditures made in the 90 days before an election. The source file published by the state is empty. Learn more »

Unavailable
S497_CD

CAMPAIGN

Campaign contributions made or received in the 90 days before an election. The source file published by the state is empty. Learn more »

Unavailable
S498_CD

CAMPAIGN

Payments received by slate-mailer organizations in the 90 days before an election. The source file published by the state is empty. Learn more »

Unavailable
ACRONYMS_CD

COMMON

Acronyms and their definitions. The source file published by the state is empty. Learn more »

Unavailable
ADDRESS_CD

COMMON

Addresses drawn from across the system. The source file published by the state is empty. Learn more »

Unavailable
CVR_E530_CD

COMMON

The cover page of Electronic Form 530. The source file published by the state is empty. Learn more »

Unavailable
FILER_ACRONYMS_CD

COMMON

Links acronyms to filers. The source file published by the state is empty. Learn more »

Unavailable
FILER_ADDRESS_CD

COMMON

Links filers and addresses. The source file published by the state is empty. Learn more »

Unavailable
FILER_ETHICS_CLASS_CD

COMMON

Ethics training events for lobbyists. The source file published by the state is empty. Learn more »

Unavailable
FILER_FILINGS_CD

COMMON

An index that links filers to their filings. The source file published by the state is empty. Learn more »

Unavailable
FILER_INTERESTS_CD

COMMON

Links a filer to interest codes. The source file published by the state is empty. Learn more »

Unavailable
FILER_LINKS_CD

COMMON

Links filers to each other. The source file published by the state is empty. Learn more »

Unavailable
FILERNAME_CD

COMMON

A combination of CAL-ACCESS tables created by the state to consolidate filer information. The source file published by the state is empty. Learn more »

Unavailable
FILERS_CD

COMMON

All links and associations to a filer. The source file published by the state is empty. Learn more »

Unavailable
FILER_STATUS_TYPES_CD

COMMON

An undocumented table. The source file published by the state is empty. Learn more »

Unavailable
FILER_TO_FILER_TYPE_CD

COMMON

Links a filer to a set of characteristics that describe the filer. The source file published by the state is empty. Learn more »

Unavailable
FILER_TYPES_CD

COMMON

Lookup table describing filer types. The source file published by the state is empty. Learn more »

Unavailable
FILER_XREF_CD

COMMON

Maps legacy filer identification numbers to current filer identification numbers. The source file published by the state is empty. Learn more »

Unavailable
FILING_PERIOD_CD

COMMON

Metadata for filing periods. The source file published by the state is empty. Learn more »

Unavailable
FILINGS_CD

COMMON

All links and associations to a filing. The source file published by the state is empty. Learn more »

Unavailable
GROUP_TYPES_CD

COMMON

Lookup table for group types. The source file published by the state is empty. Learn more »

Unavailable
HDR_CD

COMMON

Electronic-filing headers with vendor and CalFormat version. The source file published by the state is empty. Learn more »

Unavailable
HEADER_CD

COMMON

Lookup table used to report Form 460 information in the Agency Management System. The source file published by the state is empty. Learn more »

Unavailable
IMAGE_LINKS_CD

COMMON

Links images to filers and accounts. The source file published by the state is empty. Learn more »

Unavailable
LEGISLATIVE_SESSIONS_CD

COMMON

Start and end dates for legislative sessions. The source file published by the state is empty. Learn more »

Unavailable
LOOKUP_CODES_CD

COMMON

Definitions for some lookup codes. The source file published by the state is empty. Learn more »

Unavailable
NAMES_CD

COMMON

A collection of names from across the database. The source file published by the state is empty. Learn more »

Unavailable
RECEIVED_FILINGS_CD

COMMON

Undocumented. The source file published by the state is empty. Learn more »

Unavailable
REPORTS_CD

COMMON

Undocumented. The source file published by the state is empty. Learn more »

Unavailable
SMRY_CD

COMMON

Summary totals from filings. The source file published by the state is empty. Learn more »

Unavailable
SPLT_CD

COMMON

Split transaction records used as a child record for a number of forms. The source file published by the state is empty. Learn more »

Unavailable
TEXT_MEMO_CD

COMMON

Text memos attached to electronic filings. The source file published by the state is empty. Learn more »

Unavailable
CVR2_LOBBY_DISCLOSURE_CD

LOBBYING

Extra information from the cover sheets of lobbyist-disclosure form. The source file published by the state is empty. Learn more »

Unavailable
CVR2_REGISTRATION_CD

LOBBYING

Additional names provided on lobbying-registration forms. The source file published by the state is empty. Learn more »

Unavailable
CVR_LOBBY_DISCLOSURE_CD

LOBBYING

The cover page of lobbying-disclosure forms. The source file published by the state is empty. Learn more »

Unavailable
CVR_REGISTRATION_CD

LOBBYING

The cover page of lobbying-registration forms. The source file published by the state is empty. Learn more »

Unavailable
F690P2_CD

LOBBYING

Amendments to lobbying-disclosure filings. The source file published by the state is empty. Learn more »

Unavailable
LATT_CD

LOBBYING

Attachments for lobbying payments. The source file published by the state is empty. Learn more »

Unavailable
LCCM_CD

LOBBYING

Lobbyist campaign contributions. The source file published by the state is empty. Learn more »

Unavailable
LEMP_CD

LOBBYING

Lobbyist employers and subcontracted clients. The source file published by the state is empty. Learn more »

Unavailable
LEXP_CD

LOBBYING

Lobbying activity expenditures. The source file published by the state is empty. Learn more »

Unavailable
LOBBY_AMENDMENTS_CD

LOBBYING

Amendments to lobbyist-registration forms. The source file published by the state is empty. Learn more »

Unavailable
LOBBYING_CHG_LOG_CD

LOBBYING

Log of lobbyist filings compiled for display on the state website. The source file published by the state is empty. Learn more »

Unavailable
LOTH_CD

LOBBYING

Payments to other lobbying firms. The source file published by the state is empty. Learn more »

Unavailable
LPAY_CD

LOBBYING

Payments made or received by lobbying firms. The source file published by the state is empty. Learn more »

Unavailable
BALLOT_MEASURES_CD

INACTIVE

Ballot-measure dates and times. The source file published by the state is empty. Learn more »

Unavailable
CVR_F470_CD

INACTIVE

The cover page for officeholder and candidate short and supplemental forms. The source file published by the state is empty. Learn more »

Unavailable
EFS_FILING_LOG_CD

INACTIVE

Logs from the Electronic Filing Subsystem, which accepts and validates electronic filings. The source file published by the state is empty. Learn more »

Unavailable
FILER_TYPE_PERIODS_CD

INACTIVE

Undocumented. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_CONTRIBUTIONS1_CD

INACTIVE

Deprecated table for the disclosure of campaign contributions made by lobbyists. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_CONTRIBUTIONS2_CD

INACTIVE

Deprecated table for the disclosure of campaign contributions made by lobbyists. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_CONTRIBUTIONS3_CD

INACTIVE

Deprecated table for the disclosure of campaign contributions made by lobbyists. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_EMP_LOBBYIST1_CD

INACTIVE

Deprecated table for the disclosure of lobbyist relationships. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_EMP_LOBBYIST2_CD

INACTIVE

Deprecated table for the disclosure of lobbyist relationships. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_EMPLOYER1_CD

INACTIVE

Deprecated table for the disclosure of lobbyist relationships. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_EMPLOYER2_CD

INACTIVE

Deprecated table for the disclosure of lobbyist relationships. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_EMPLOYER3_CD

INACTIVE

Deprecated table for the disclosure of lobbyist relationships. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_EMPLOYER_FIRMS1_CD

INACTIVE

Deprecated table for the disclosure of lobbyist relationships. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_EMPLOYER_FIRMS2_CD

INACTIVE

Deprecated table for the disclosure of lobbyist relationships. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_EMPLOYER_HISTORY_CD

INACTIVE

Undocumented. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_FIRM1_CD

INACTIVE

Deprecated table for the disclosure of lobbyist relationships. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_FIRM2_CD

INACTIVE

Deprecated table for the disclosure of lobbyist relationships. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_FIRM3_CD

INACTIVE

Deprecated table for the disclosure of lobbyist relationships. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_FIRM_EMPLOYER1_CD

INACTIVE

Deprecated table for the disclosure of lobbyist relationships. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_FIRM_EMPLOYER2_CD

INACTIVE

Deprecated table for the disclosure of lobbyist relationships. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_FIRM_HISTORY_CD

INACTIVE

Undocumented. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_FIRM_LOBBYIST1_CD

INACTIVE

Deprecated table for the disclosure of lobbyist relationships. The source file published by the state is empty. Learn more »

Unavailable
LOBBYIST_FIRM_LOBBYIST2_CD

INACTIVE

Deprecated table for the disclosure of lobbyist relationships. The source file published by the state is empty. Learn more »

Unavailable