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

 

HOME / DETAILED FILES / METADATA DESCRIPTION

Metadata Description

Data Dictionary - Candidate Master File

General Description

This file contains one record for each committee registered with the Federal Election Commission. This includes federal political action committees and party committees, campaign committees for presidential, house and senate candidates, as well as groups or organizations who are spending money for or against candidates for federal office. The file contains basic information about the committees. The ID number the Commission assigned to the committee is first, along with the name of the committee, the sponsor, where appropriate, the treasurer's name and the committee's address. The file also includes information about what type of committee is being described, along with the candidate's ID number if it is a campaign committee.

Information contained in the list

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

Column Name Field Name Position Null? Data Type Description
CAND_ID
Candidate Identification
1 N VARCHAR2(9)
A 9-character alpha-numeric code assigned to a candidate by the Federal Election Commission. The candidate ID for a specific candidate remains the same across election cycles as long as the candidate is running for the same office.
CAND_NAME
Candidate Name
2 Y VVARCHAR2(200)
 
CAND_PTY_AFFILIATION
Party Affiliation
3 Y VARCHAR2(3)
The political party affiliation reported by the candidate.
CAND_ELECTION_YR
Year of Election
4 Y Number(4)
Candidate's election year from a Statement of Candidacy or state ballot list.
CAND_OFFICE_ST
Candidate State
5 Y VARCHAR2(2)

House = state of race

President  = US

Seante = state of race

CAND_OFFICE
Candidate Office
6 Y VARCHAR2(1)

H = House

P = President

S = Seante

CAND_OFFICE_DISTRICT
Candidate District
7 Y VARCHAR2(2)

Congressional district number.

Congressional At Large 00

Senate 00

Presidential 00

CAND_ICI
Incumbent Challenger Status
8 Y VARCHAR2(1)
C = Challenger
I = Incumbent
O = Open Seat is used to indicate an open seat.  Open seats are defined as seats where the incumbent never sought re-election.
CAND_STATUS
Candidate Status
9 Y VARCHAR2(1)
C = Statutory candidate
F = Statutory candidate for future election
N = Not yet a statutory candidate
P = Statutory candidate in prior cycle
CAND_PCC
Principal Campaign Committee
10 Y VARCHAR2(9)
The ID assigned by the Federal Election Commission to the candidate's principal campaign committee for a given election cycle.
CAND_ST1
Mailing Address - Street
11 Y VARCHAR2(34)
Mailing Address - Street
CAND_ST2
Mailing Address - Street2
12 Y VARCHAR2(34)
Mailing Address - Street2
CAND_CITY
Mailing Address - City
13 Y VARCHAR2(30)
Mailing Address - City
CAND_ST
Mailing Address - State
14 Y VARCHAR2(2)
Mailing Address - State
CAND_ZIP
Mailing Address - Zip Code
15 Y VARCHAR2(9)
Mailing Address - Zip Code