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.

Contributions by individuals file description

The contributions by individuals file contains information for contributions given by individuals. The method used to include contributions in this file has changed over time.

2015 - present: greater than $200

A contribution will be included if:

  • The contribution’s election cycle-to-date amount is over $200 for contributions to candidate committees
  • The contribution’s calendar year-to-date amount is over $200 for contributions to political action committees (PACs) and party committees.

1989 - 2014: $200 and above

A contribution will be included if the reporting period amount is $200 or more.

1975 - 1988: $500 and above

A contribution will be included if the reporting period amount is $500 or more.

The file contains information about the committee receiving the contribution, the report where the contribution is disclosed, the individual giving the contribution, the contribution’s date, amount, and additional information about the contribution (if provided).The end-of-line (EOL) marker is line feed '\n' (LF, 0x0A, 10 in decimal).

Contributions by individuals file format

Column nameField namePositionNullData typeDescriptionExample data
CMTE_IDFiler identification number1NVARCHAR2 (9) A 9-character alpha-numeric code assigned to a committee by the Federal Election Commission C00100005
AMNDT_INDAmendment indicator2YVARCHAR2 (1) Indicates if the report being filed is new (N), an amendment (A) to a previous report or a termination (T) report. N
RPT_TPReport type3YVARCHAR2 (3)Indicates the type of report filed List of report type codes12G
TRANSACTION_PGIPrimary-general indicator4YVARCHAR2 (5) This code indicates the election for which the contribution was made. EYYYY (election plus election year)
P = Primary
G = General
O = Other
C = Convention
R = Runoff
S = Special
E = Recount
P2018
IMAGE_NUMImage number5YVARCHAR2 (11) or VARCHAR2(18)11-digit Image Number Format
YYOORRRFFFF
YY - scanning year
OO - office (01 - House, 02 - Senate, 03 - FEC Paper, 90-99- FEC Electronic)
RRR - reel number
FFFF- frame number

18-digit Image Number Format (June 29, 2015)
YYYYMMDDSSPPPPPPPP
YYYY - scanning year
MM - scanning month
DD - scanning day
SS - source (02 - Senate, 03 - FEC Paper, 90-99 - FEC Electronic)
PPPPPPPP - page (reset to zero every year on January 1)
201810170912345678
TRANSACTION_TPTransaction type6YVARCHAR2 (3)Transaction types 10, 11, 15, 15C, 15E, 15I, 15T, 19, 22Y, 24I, 24T, 20Y and 21Y are included in the INDIV file. Beginning with 2016 transaction types 30, 30T, 31, 31T, 32, 32T, 40T, 40Y, 41T, 41Y, 42T and 42Y are also included in the INDIV file.
For more information about transaction type codes see this list of transaction type codes
30T
ENTITY_TPEntity type7YVARCHAR2 (3)ONLY VALID FOR ELECTRONIC FILINGS received after April 2002. CAN = Candidate
CCM = Candidate Committee
COM = Committee
IND = Individual (a person)
ORG = Organization (not a committee and not a person)
PAC = Political Action Committee
PTY = Party Organization
IND
NAMEContributor/Lender/Transfer Name8YVARCHAR2 (200)Abigail Adams
CITYCity9YVARCHAR2 (30)Braintree
STATEState10YVARCHAR2 (2)MA
ZIP_CODE ZIP code11Y VARCHAR2 (9)02184
EMPLOYEREmployer12YVARCHAR2 (38)Self employed
OCCUPATIONOccupation13YVARCHAR2 (38)Homemaker
TRANSACTION_DTTransaction date (MMDDYYYY)14YDATE10132018
TRANSACTION_AMTTransaction amount15YNUMBER (14,2)1000.00
OTHER_IDOther identification number16YVARCHAR2 (9)For contributions from individuals this column is null. For contributions from candidates or other committees this column will contain that contributor's FEC ID.C00100309
TRAN_IDTransaction ID17YVARCHAR2 (32)ONLY VALID FOR ELECTRONIC FILINGS. A unique identifier associated with each itemization or transaction appearing in an FEC electronic file. A transaction ID is unique for a specific committee for a specific report. In other words, if committee, C1, files a Q3 New with transaction SA123 and then files 3 amendments to the Q3 transaction SA123 will be identified by transaction ID SA123 in all 4 filings.SA11A1A.8317
FILE_NUMFile number / Report ID18YNUMBER (22)Unique report id 1197695
MEMO_CDMemo code19YVARCHAR2 (1)'X' indicates that the amount is NOT to be included in the itemization total. X
MEMO_TEXTMemo text20YVARCHAR2 (100)A description of the activity. Memo Text is available on itemized amounts on Schedules A and B. These transactions are included in the itemization total. Reattributed from John Adams 10/5/18
SUB_IDFEC record number21NNUMBER (19)Unique row ID 1234567891234567891