Processed files
Definitions, record layouts and data dictionaries for the processed data files released by the California Civic Data Coalition. Recommended for beginners and regular use.
Campaign files
Tidied up campaign-finance filings generated by our processing system
| Name | Description |
|---|---|
| Form460Filing | The most recent version of each Form 460 filing by recipient committees. |
| Form460FilingVersion | Every version of each Form 460 (Campaign Disclosure Statement) filing by recipient committees. |
| Form460ScheduleAItem | Monetary contributions received by campaign filers. |
| Form460ScheduleAItemVersion | Every version of each monetary contribution received by a campaign filer. |
| Form460ScheduleASummary | The summary data included with the most recent version a Schedule A attachment to a Form 460 filing. |
| Form460ScheduleASummaryVersion | The summary data included with each version of a Schedule A attachment to a Form 460 filing. |
| Form460ScheduleB1Item | Loans received and loan payments by campaign filers. |
| Form460ScheduleB1ItemVersion | Every version of each loan received or loan payment made by a campaign filer. |
| Form460ScheduleB2Item | Guarantees of loans and lines of credit received by campaign filers. |
| Form460ScheduleB2ItemOld | Repayments on loans/forgiven loans received by campaign filers circa 2001. |
| Form460ScheduleB2ItemVersion | Every version of each guarantee of a loan/line of credit to a campaign filer. |
| Form460ScheduleB2ItemVersionOld | Every version of each repayment/forgiveness of a loan to a campaign filer circa 2001. |
| Form460ScheduleCItem | Nonmonetary contributions received by campaign filers. |
| Form460ScheduleCItemVersion | Every version of each nonmonetary contribution received by a campaign filer. |
| Form460ScheduleCSummary | The summary data included with the most recent version a Schedule C attachment to a Form 460 filing. |
| Form460ScheduleCSummaryVersion | The summary data included with each version of a Schedule C attachment to a Form 460 filing. |
| Form460ScheduleDItem | Payments in support or opposition of other candidates and ballot measures. |
| Form460ScheduleDItemVersion | Every version of each payment supporting/opposing another candidate/ballot measure. |
| Form460ScheduleEItem | Payments made by campaign filers. |
| Form460ScheduleEItemVersion | Every version of each payment made by a campaign filer. |
| Form460ScheduleESubItem | Sub-items of payments made by campaign filers. |
| Form460ScheduleESubItemVersion | Every version of each sub-item of a payment by a campaign filer. |
| Form460ScheduleESummary | The summary data included with the most recent version a Schedule E attachment to a Form 460 filing. |
| Form460ScheduleESummaryVersion | The summary data included with each version of a Schedule E attachment to a Form 460 filing. |
| Form460ScheduleFItem | Accrued expenses of campaign filers. |
| Form460ScheduleFItemVersion | Every version of each accrued expense of a campaign filer. |
| Form460ScheduleGItem | Payments made by on behalf of campaign filers. |
| Form460ScheduleGItemVersion | Every version of each payment made on behalf of a campaign filer. |
| Form460ScheduleH2ItemOld | Repayments on loans/forgiven loans made by campaign filers circa 2001. |
| Form460ScheduleH2ItemVersionOld | Every version of each repayment/forgiveness of a loan by a campaign filer circa 2001. |
| Form460ScheduleHItem | Loans made by campaign filers to other recipients. |
| Form460ScheduleHItemVersion | Every version of each loan made by a campaign filer another recipient. |
| Form460ScheduleIItem | Miscellaneous cash increases to the coffers of campaign filers. |
| Form460ScheduleIItemVersion | Every version of each miscellaneous cash increase for a campaign filer. |
| Form461Filing | The most recent version of each Form 461 filing by independent expenditure or major donor committees. |
| Form461FilingVersion | Every version of each Form 461 filing by independent expenditure or major donor committees. |
| Form461Part5Item | Payments made by Form 461 filers. |
| Form461Part5ItemVersion | Every version of each payment made by a Form 461 filing. |
| Form496Filing | The most recent version of each Schedule 496 filing by campaign filers. |
| Form496FilingVersion | Every version of each Schedule 496 filing by a campaign filer. |
| Form496Part1Item | Late independent expenditures made by campaign filers. |
| Form496Part1ItemVersion | Every version of each late independent expenditures made by campaign filers. |
| Form496Part2Item | Late independent expenditures made by campaign filers. |
| Form496Part2ItemVersion | Every version of each late independent expenditure made by a campaign filer. |
| Form496Part3Item | Monetary contributions of greater than $100 from the Form 496's Part 3. |
| Form496Part3ItemVersion | Every version of monetary contributions of greater than $100 from the Form 496's Part 3. |
| Form497Filing | The most recent version of each Schedule 497 filing by campaign filers. |
| Form497FilingVersion | Every version of each Schedule 497 filing by a campaign filer. |
| Form497Part1Item | Late contributions received by campaign filers. |
| Form497Part1ItemVersion | Every version of each late contribution received by a campaign filer. |
| Form497Part2Item | Late contributions made by campaign filers. |
| Form497Part2ItemVersion | Every version of each late contribution made by a campaign filer. |
| Form501Filing | The most recent version of each Form 501 filing by a candidate. |
| Form501FilingVersion | Every version of each Form 501 (Candidate Intention Statement) filing by candidates. |
Relational files
Processed elections data in Open Civic Data format ready to load into a database.
| Name | Description |
|---|---|
| BallotMeasureContest | A contest in which voters select from among options proposed in a ballot measure. |
| BallotMeasureContestIdentifier | Upstream identifiers of a BallotMeasureContest. |
| BallotMeasureContestOption | An option voters may choose in a BallotMeasureContest. |
| BallotMeasureContestSource | Source used in assembling a BallotMeasureContest. |
| Candidacy | A person seeking election to hold a specific public office for a term. |
| CandidacySource | Source used in assembling a Candidacy. |
| CandidateContest | A contest among candidates seeking election to one or more public offices. |
| CandidateContestPost | A public office (i.e., Post) at stake in a CandidateContest. |
| CandidateContestSource | Source used in assembling a CandidateContest. |
| Division | A political geography, which may have multiple boundaries over its lifetime. |
| Election | A collection of political contests set to be decided on the same date within a Division. |
| ElectionIdentifier | Upstream identifiers of a Election. |
| ElectionSource | Source used in assembling a Election. |
| Jurisdiction | A Jurisdiction represents a logical unit of governance. |
| Membership | A relationship between a Person and an Organization, possibly including a Post. |
| Organization | A group of people, typically in a legislative or rule-making context. |
| OrganizationIdentifier | Upstream identifiers of an Organization. |
| OrganizationName | Alternate or former name for an Organization. |
| Person | An individual that has served in a political office. |
| PersonIdentifier | Upstream identifier for a Person. |
| PersonName | Alternate or former name of a Person. |
| Post | A position in an organization that exists independently of the person holding it. |
| RetentionContest | A contest where voters vote to retain or recall a current office holder. |
| RetentionContestIdentifier | Upstream identifiers of a RetentionContest. |
| RetentionContestOption | An option voters may choose in a RetentionContest. |
| RetentionContestSource | Source used in assembling a RetentionContest. |
Flat files
Simple, all-in-one election files for those who want to skip the SQL.
| Name | Description |
|---|---|
| Ballot measures | Every ballot measure. |
| Candidates | Every candidate for a public office. |
| Recall measures | Every recall measure. |