Raw files - Documentation - California Civic Data Coalition

Campaign files

Name	Description
CVR_SO_CD	The cover page for statement-of-organization forms that create or terminate an entity.
CVR2_SO_CD	Extra information from a statement-of-organization form.
CVR_CAMPAIGN_DISCLOSURE_CD	The cover page of campaign-disclosure forms.
CVR2_CAMPAIGN_DISCLOSURE_CD	Extra information from campaign-disclosure forms.
CVR3_VERIFICATION_INFO_CD	Verification information from campaign-disclosure forms.
DEBT_CD	Itemized campaign debts.
EXPN_CD	Itemized campaign expenditures.
LOAN_CD	Itemized campaign loans.
RCPT_CD	Itemized campaign contributions.
S401_CD	Payments and other disclosures made by slate-mailer organizations.
F495P2_CD	Supplemental pre-election campaign statements.
S496_CD	Itemized independent expenditures made in the 90 days before an election.
S497_CD	Campaign contributions made or received in the 90 days before an election.
S498_CD	Payments received by slate-mailer organizations in the 90 days before an election.
F501_502_CD	Candidate intention statements.

Common files

Name	Description
FILERNAME_CD	A combination of CAL-ACCESS tables created by the state to consolidate filer information.
FILER_FILINGS_CD	An index that links filers to their filings.
FILINGS_CD	All links and associations to a filing.
HDR_CD	Electronic-filing headers with vendor and CalFormat version.
HEADER_CD	Lookup table used to report Form 460 information in the Agency Management System.
SMRY_CD	Summary totals from filings.
CVR_E530_CD	The cover page of Electronic Form 530.
SPLT_CD	Split transaction records used as a child record for a number of forms.
TEXT_MEMO_CD	Text memos attached to electronic filings.
ACRONYMS_CD	Acronyms and their definitions.
ADDRESS_CD	Addresses drawn from across the system.
FILERS_CD	All links and associations to a filer.
FILER_ACRONYMS_CD	Links acronyms to filers.
FILER_ADDRESS_CD	Links filers and addresses.
FILER_ETHICS_CLASS_CD	Ethics training events for lobbyists.
FILER_INTERESTS_CD	Links a filer to interest codes.
FILER_LINKS_CD	Links filers to each other.
FILER_STATUS_TYPES_CD	An undocumented table.
FILER_TO_FILER_TYPE_CD	Links a filer to a set of characteristics that describe the filer.
FILER_TYPES_CD	Lookup table describing filer types.
FILER_XREF_CD	Maps legacy filer identification numbers to current filer identification numbers.
FILING_PERIOD_CD	Metadata for filing periods.
GROUP_TYPES_CD	Lookup table for group types.
IMAGE_LINKS_CD	Links images to filers and accounts.
LEGISLATIVE_SESSIONS_CD	Start and end dates for legislative sessions.
LOOKUP_CODES_CD	Definitions for some lookup codes.
NAMES_CD	A collection of names from across the database.
RECEIVED_FILINGS_CD	Undocumented.
REPORTS_CD	Undocumented.

Lobbying files

Name	Description
CVR_REGISTRATION_CD	The cover page of lobbying-registration forms.
CVR2_REGISTRATION_CD	Additional names provided on lobbying-registration forms.
LOBBY_AMENDMENTS_CD	Amendments to lobbyist-registration forms.
LOBBYING_CHG_LOG_CD	Log of lobbyist filings compiled for display on the state website.
LEMP_CD	Lobbyist employers and subcontracted clients.
CVR_LOBBY_DISCLOSURE_CD	The cover page of lobbying-disclosure forms.
CVR2_LOBBY_DISCLOSURE_CD	Extra information from the cover sheets of lobbyist-disclosure form.
F690P2_CD	Amendments to lobbying-disclosure filings.
LATT_CD	Attachments for lobbying payments.
LEXP_CD	Lobbying activity expenditures.
LCCM_CD	Lobbyist campaign contributions.
LPAY_CD	Payments made or received by lobbying firms.
LOTH_CD	Payments to other lobbying firms.

Inactive files

Name	Description
BALLOT_MEASURES_CD	Ballot-measure dates and times.
CVR_F470_CD	The cover page for officeholder and candidate short and supplemental forms.
FILER_TYPE_PERIODS_CD	Undocumented.
LOBBYIST_CONTRIBUTIONS1_CD	Deprecated table for the disclosure of campaign contributions made by lobbyists.
LOBBYIST_CONTRIBUTIONS2_CD	Deprecated table for the disclosure of campaign contributions made by lobbyists.
LOBBYIST_CONTRIBUTIONS3_CD	Deprecated table for the disclosure of campaign contributions made by lobbyists.
LOBBYIST_EMP_LOBBYIST1_CD	Deprecated table for the disclosure of lobbyist relationships.
LOBBYIST_EMP_LOBBYIST2_CD	Deprecated table for the disclosure of lobbyist relationships.
LOBBYIST_EMPLOYER1_CD	Deprecated table for the disclosure of lobbyist relationships.
LOBBYIST_EMPLOYER2_CD	Deprecated table for the disclosure of lobbyist relationships.
LOBBYIST_EMPLOYER3_CD	Deprecated table for the disclosure of lobbyist relationships.
LOBBYIST_EMPLOYER_FIRMS1_CD	Deprecated table for the disclosure of lobbyist relationships.
LOBBYIST_EMPLOYER_FIRMS2_CD	Deprecated table for the disclosure of lobbyist relationships.
LOBBYIST_EMPLOYER_HISTORY_CD	Undocumented.
LOBBYIST_FIRM1_CD	Deprecated table for the disclosure of lobbyist relationships.
LOBBYIST_FIRM2_CD	Deprecated table for the disclosure of lobbyist relationships.
LOBBYIST_FIRM3_CD	Deprecated table for the disclosure of lobbyist relationships.
LOBBYIST_FIRM_EMPLOYER1_CD	Deprecated table for the disclosure of lobbyist relationships.
LOBBYIST_FIRM_EMPLOYER2_CD	Deprecated table for the disclosure of lobbyist relationships.
LOBBYIST_FIRM_HISTORY_CD	Undocumented.
LOBBYIST_FIRM_LOBBYIST1_CD	Deprecated table for the disclosure of lobbyist relationships.
LOBBYIST_FIRM_LOBBYIST2_CD	Deprecated table for the disclosure of lobbyist relationships.
EFS_FILING_LOG_CD	Logs from the Electronic Filing Subsystem, which accepts and validates electronic filings.