skip navigation
Here's how you know US flag signifying that this is a United States Federal Government website

An official website of the United States government

Here's how you know

Dot gov

Official websites use .gov
A .gov website belongs to an official government organization in the United States.


Secure .gov websites use HTTPS
A lock ( ) or https:// means you've safely connected to the .gov website. Share sensitive information only on official, secure websites.

Candidate master file description

The candidate master file contains basic information for each candidate, including:

  • Candidates who have filed a Statement of Candidacy (Form 2) for the upcoming election

  • Candidates who have active campaign committees without regard to election year

  • Candidates who are referenced as a part of a draft committee or a nonconnected committee that registers as supporting or opposing a particular candidate

The file shows the candidate's identification number, candidate’s name, party affiliation, election year, office state, office sought, district, incumbent/challenger status, status as a candidate, name of the candidate’s principal campaign committee, and address. The end-of-line (EOL) marker is line feed '\n' (LF, 0x0A, 10 in decimal).

Candidate master file format

Column nameField namePositionNullData typeDescriptionExample data
CAND_IDCandidate identification1NVARCHAR2(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.H8VA01233
CAND_NAMECandidate name2YVARCHAR2(200)Martha Washington
CAND_PTY_AFFILIATIONParty affiliation3YVARCHAR2(3) The political party affiliation reported by the candidateNON
CAND_ELECTION_YRYear of election4YNumber(4)Candidate's election year from a Statement of Candidacy or state ballot list2018
CAND_OFFICE_STCandidate state5YVARCHAR2(2) House = state of race
President = US
Senate = state of race
CAND_OFFICECandidate office6YVARCHAR2(1) H = House
P = President
S = Senate
CAND_OFFICE_DISTRICTCandidate district7YVARCHAR2(2) Congressional district number
Congressional at-large 00
Senate 00
Presidential 00
CAND_ICIIncumbent challenger status8YVARCHAR2(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_STATUSCandidate status9YVARCHAR2(1)C = Statutory candidate
F = Statutory candidate for future election
N = Not yet a statutory candidate
P = Statutory candidate in prior cycle
CAND_PCCPrincipal campaign committee10YVARCHAR2(9) The ID assigned by the Federal Election Commission to the candidate's principal campaign committee for a given election cycle. C00100005
CAND_ST1 Mailing address - street11Y VARCHAR2(34)Mailing address - street1001 George Washington Hwy
CAND_ST2Mailing address - street212YVARCHAR2(34)Mailing address - street2Suite 100
CAND_CITYMailing address - city13YVARCHAR2(30)Mailing address - cityAlexandria
CAND_STMailing address - state 14YVARCHAR2(2)Mailing address - stateVA
CAND_ZIPMailing address - ZIP code15YVARCHAR2(9)Mailing address - ZIP code22201