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 - WEBL Candidate Summary (Current Campaigns)

General Description

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.

 

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