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.

Operating expenditures file description

The operating expenditures file contains information about disbursements disclosed on FEC reports, including operating expenditures reported on:

  • Form 3, Line 17 for House and Senate committees
  • Form 3P, Line 23 for Presidential committees
  • Form 3X, Lines 21(a)(i), 21(a)(ii), and 21(b) for PAC and Party committees

For electronic filing committees, operating expenditures are available from the 2004 election cycle to the present.

For paper filing committees, operating expenditures are available starting October 2005 through the present.

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

Operating expenditures file format

Column nameField namePositionNullData typeDescriptionExample data
CMTE_IDFiler identification number1NVARCHAR2 (9)Identification number of committee filing report. 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. A
RPT_YRReport year 3YNumber(4)2018
RPT_TPReport type4YVARCHAR2 (3)Indicates the type of report filed. List of report type codes12G
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)
201810170912341234
LINE_NUMLine number 6YIndicates FEC form line number

17
FORM_TP_CDForm type 7YVARCHAR2 (8)Indicates FEC Form3
SCHED_TP_CDSchedule type8YVARCHAR2 (8) Schedule B - Itemized disbursements SB
NAMEContributor/Lender/Transfer Name9YVARCHAR2 (200) XYZ Printing
CITYCity10YVARCHAR2 (30) Alexandria
STATE State11Y VARCHAR2 (2)  VA
ZIP_CODEZIP code12YVARCHAR2 (9) 22201
TRANSACTION_DTTransaction date (MMDDYYYY)13YDATE  05112018
TRANSACTION_AMTTransaction amount14YNUMBER (14,2)  512.34
TRANSACTION_PGIPrimary general indicator15YVARCHAR2 (5) P2018
PURPOSEPurpose16YVARCHAR2 (100) Printing yard signs
CATEGORYDisbursement category code 17YVARCHAR2 (3)001-012 and 101-107 006
CATEGORY_DESCDisbursement Category Code Description 18YVARCHAR2 (40)List of Disbursement Category Codes and their meaningCampaign materials
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 Schedule B. These transactions are included in the itemization total. Credit card payment – AmEx 5/1/18
ENTITY_TPEntity type 21YVARCHAR2 (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
ORG
SUB_ID FEC record number22NNUMBER (19)Unique row ID 1234567891234567891
FILE_NUM File number/report ID 23YNUMBER (7) Unique report id 1197685
TRAN_ID Transaction ID24VARCHAR2 (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.SB17.4326
BACK_REF_TRAN_ID Back reference transaction ID 25YVARCHAR2 (32) ONLY VALID FOR ELECTRONIC FILINGS. Used to associate one transaction with another transaction in the same report (using file number, transaction ID and back reference transaction ID). For example, a credit card payment and the subitemization of specific purchases. The back reference transaction ID of the specific purchases will equal the transaction ID of the payment to the credit card company. SB17.8690