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.
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) |
