Skip Navigation
Federal Election Commission, United States of America (logo). Link to FEC Home Page
Federal Election Commission
FEC Search

 

HOME / DETAILED FILES / METADATA DESCRIPTION

Metadata Description

Data Dictionary - WEBALL Candidate Summary (All Candidates )

General Description

The all candidate summary file contains one record including summary financial information for all candidates who raised or spent money during the period no matter when they are up for election. This file is similar to the current campaign summary file described above. This file is completely dependent upon summary information reported by the campaign itself. This means that the time period covered by this file may be more recent than for the current version of the post-cycle candidate summary file described below. During the primary election season the period covered may be different for candidates in different states. The cost of this timeliness, though, is that some of the information available here is less precise than for the post-cycle candidate summary file. For example, break-outs by special interest group code are not possible.

When using the all candidates summary file you need to be aware of some possible double counting of activity. Some candidates have more then one committee authorized to raise and spend funds on their behalf. The activity reflected in this file represents the sum of those committees. If they transfer funds back and forth among each other, this activity would be counted twice. Information about “transfers from authorized committees” and “transfers to authorized committees” is included in the file and if there are values in both of these fields it is necessary to subtract these from total receipts and total disbursements to obtain a more accurate value for actual activity.

 

 

Header file and file format information

A comma delimited header file is available for download.

The end-of-line (EOL) marker is line feed '\n' (LF, 0x0A, 10 in decimal). The WEBALL Candidate Summary (All Candidates) File contains the following information:

Column Name Field Name Position Null? Data Type Description
CAND_ID
Candidate Identification
1 N VARCHAR2 (9)

 
CAND_NAME
Candidate Name
2 Y VARCHAR2(200)

 
CAND_ICI
Incumbent Challenger Status
3 Y VARCHAR2(1)

 
PTY_CD
Party Code
4 Y VARCHAR2(1)

 
CAND_PTY_AFFILIATION
Party Affiliation
5 Y VARCHAR2(3)
 
TTL_RECEIPTS
Total Receipts
6 Y Number(14,2)
 
TRANS_FROM_AUTH
Transfers from Authorized Committees
7 Y Number(14,2)
 
TTL_DISB
Total Disbursements
8 Y Number(14,2)
 
TRANS_TO_AUTH
Transfers to Authorized Committees
9 Y Number(14,2)
 
COH_BOP
Beginning Cash
10 Y Number(14,2)
 
COH_COP
Ending Cash
11 Y Number(14,2)
 
CAND_CONTRIB
Contributions from Candidate
12 Y Number(14,2)
 
CAND_LOANS
Loans from Candidate
13 Y Number(14,2)
 
OTHER_LOANS
Other Loans
14 Y Number(14,2)
 
CAND_LOAN_REPAY
Candidate Loan Repayments
15 Y Number(14,2)
 
OTHER_LOAN_REPAY
Other Loan Repayments
16 Y Number(14,2)
 
DEBTS_OWED_BY
Debts Owed By
17 Y Number(14,2)
 
TTL_INDIV_CONTRIB
Total Individual Contributions
18 Y Number(14,2)
 
CAND_OFFICE_ST Candidate State 19 Y VARCHAR2(2  
CAND_OFFICE_DISTRICT
Candidate District
20 Y VARCHAR2(2)
 
SPEC_ELECTION
Special Election Status
21 Y VARCHAR2(1)
 
PRIM_ELECTION
Primary Election Status
22 Y VARCHAR2(1)
 
RUN_ELECTION
Runoff Election Status
23 Y VARCHAR2(1)
 
GEN_ELECTION
General Election Status
24 Y VARCHAR2(1)  
GEN_ELECTION_PRECENT
General Election Percentage
25 Y Number(7,4)  
OTHER_POL_CMTE_CONTRIB
Contributions from Other Political Committees
26 Y Number(14,2)  
POL_PTY_CONTRIB
Contributions from Party Committees
27 Y Number(14,2)  
CVG_END_DT
Coverage End Date
28 Y DATE(MM/DD/YYYY) Through Date
INDIV_REFUNDS
Refunds to Individuals
29 Y Number(14,2)  
CMTE_REFUNDS
Refunds to Committees
30 Y Number(14,2)