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.

SSL

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-committee linkage file description

The candidate-committee linkage file contains information linking the candidate's information to information about his or her committee. 

This file shows the candidate’s identification number, candidate’s election year, FEC election year, committee identification number, committee type, committee designation, and a linkage identification number. The end-of-line (EOL) marker is line feed '\n' (LF, 0x0A, 10 in decimal).

Candidate-committee linkage 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_ELECTION_YRCandidate election year2NNUMBER (4)Candidate's election year2018
FEC_ELECTION_YRFEC election year3NNUMBER (4)Active 2-year period 2018
CMTE_IDCommittee identification4YVARCHAR2 (9)A 9-character alpha-numeric code assigned to a committee by the Federal Election Commission. The committee ID for a specific committee always remains the same. C00100005
CMTE_TPCommittee type5YVARCHAR2 (1)List of committee type codesH
CMTE_DSGNCommittee designation6YVARCHAR2 (1)A = Authorized by a candidate
B = Lobbyist/Registrant PAC
D = Leadership PAC
J = Joint fundraiser
P = Principal campaign committee of a candidate
U = Unauthorized
A
LINKAGE_IDLinkage ID7NNUMBER (12) Unique link ID 123456789012