These files contain one record for each campaign. This record contains summary financial information. The summary information contained in these files is completely dependent upon what is 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 "cansum" described below. During the primary election season the period covered may be different for candidates in different states. The cost of this timliness, though, is that some of the information available here is less precise than for "cansum". For example, in "cansum" you can see how much a campaign received from Corporate PACs or Labor PACs, while here there is only one value for the total received from "other political committees." This includes all PAC contributions, but it may also contain contributions from other candidates, and some other types of committees we don't typically think of as PACs. We can't do the full breakdowns until all the information about specific contributions has been entered into the database.
When using these summary files 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 WEBL Candidate Summary (Current Campaigns) 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) |
