skip navigation
Here's how you know US flag signifying that this is a United States Federal Government website

An official website of the United States government

Here's how you know

Dot gov

Official websites use .gov
A .gov website belongs to an official government organization in the United States.


Secure .gov websites use HTTPS
A lock ( ) or https:// means you've safely connected to the .gov website. Share sensitive information only on official, secure websites.

All candidates file description

The all candidates file contains summary financial information for each candidate who raised or spent money during the period, regardless of when they are up for election.

The file has one record per candidate and shows information about the candidate, total receipts, transfers received from authorized committees, total disbursements, transfers given to authorized committees, cash-on-hand totals, loans and debts, and other financial summary information. The end-of-line (EOL) marker is line feed '\n' (LF, 0x0A, 10 in decimal).

Data timing

This file is completely dependent on summary information reported by the campaign. The time period covered by this file may be more recent than other data files (like the post-cycle candidate summary file). During the primary election season, the period covered may be different for candidates in different states, depending on their primary dates. Since the data is timelier, some of the information in this file is less precise than information in the post-cycle candidate summary file. For example, breakouts by special interest group code are not possible.

Double-counted financial activity

A candidate’s financial summary may have double-counted financial activity. If a candidate has more than one committee authorized to raise and spend funds on their behalf, the activity in this file combines these committees. If the committees transfer funds back and forth to each other, this activity would be counted twice. Information about “transfers to authorized committees” and “transfers from authorized committees” is included in the file. If there are values in both of these fields, subtract these from the total receipts and total disbursements for a more accurate value of the candidate’s total activity.

All candidates file format

Column nameField namePositionNullData typeDescriptionExample data
CAND_ID Candidate identification1NVARCHAR2 (9)H8VA01233
CAND_NAMECandidate name2YVARCHAR2(200)Martha Washington
CAND_ICIIncumbent challenger status3YVARCHAR2(1)I
TTL_RECEIPTSTotal receipts6YNumber(14,2)345,456.34
TRANS_FROM_AUTHTransfers from authorized committees7YNumber(14,2)4000.00
TTL_DISBTotal disbursements8YNumber(14,2)175645.21
TRANS_TO_AUTHTransfers to authorized committees9YNumber(14,2)0.00
COH_BOPBeginning cash10YNumber(14,2)845901.23
COH_COP Ending cash11Y Number(14,2)915671.43
CAND_CONTRIBContributions from candidate12YNumber(14,2)500.00
CAND_LOANSLoans from candidate13YNumber(14,2)250000.00
OTHER_LOANSOther loans14YNumber(14,2)0.00
CAND_LOAN_REPAYCandidate loan repayments15YNumber(14,2)100000.00
OTHER_LOAN_REPAYOther loan repayments16YNumber(14,2)0.00
DEBTS_OWED_BYDebts owed by17YNumber(14,2)250.00
TTL_INDIV_CONTRIBTotal individual contributions18YNumber(14,2)450000.00
CAND_OFFICE_DISTRICTCandidate district20YVARCHAR2(2)01
SPEC_ELECTIONSpecial election status21YVARCHAR2(1)Election result data included in 1996-2006 files only.W
PRIM_ELECTIONPrimary election status22YVARCHAR2(1)Election result data included in 1996-2006 files only.L
RUN_ELECTIONRunoff election status23YVARCHAR2(1)Election result data included in 1996-2006 files only.L
GEN_ELECTIONGeneral election status24YVARCHAR2(1)Election result data included in 1996-2006 files only.W
GEN_ELECTION_PRECENTGeneral election percentage25YNumber(7,4)Election result data included in 1996-2006 files only.63.2
OTHER_POL_CMTE_CONTRIBContributions from other political committees26YNumber(14,2)200000.00
POL_PTY_CONTRIBContributions from party committees27YNumber(14,2)200000.00
CVG_END_DTCoverage end date 28YDATE(MM/DD/YYYY)Through date 10/19/2018
INDIV_REFUNDSRefunds to individuals29YNumber(14,2)4000.00
CMTE_REFUNDSRefunds to committees30YNumber(14,2)100.00