-
Click the download tab.
The Campaign Finance Data Download page is displayed.
You can access the Campaign Finance Data Download page to download contribution, expenditure, or loan data for import into other applications such as Microsoft Excel or Access. A weekly batch process is run that captures the year-to-date information for the current year. The data is available for each calendar year. The file is downloaded in CSV Comma-Separated Values. A format in which data in a file is separated by a comma. This format is used for importing and exporting data. format.
Below are the file layouts for the various extracts. Each file contains a header row and each column in the file is labeled with the field name. The files are sorted by jurisdiction and Committee name.
|
Field Position |
Field Name |
Description |
|
A |
CO_ID |
(Committee ID) - The alphanumeric ID of the Recipient Committee. |
|
B |
CONTRIBUTION AMOUNT |
The contribution dollar amount. |
|
C |
CONTRIBUTION DATE |
The date the contribution was received. |
|
D |
LAST NAME |
The last name of the Contributor, if individual, or full name of the entity. |
|
E |
FIRST NAME |
The Contributor's first name. |
|
F |
MI |
The Contributor's middle initial. |
|
G |
SUFFIX |
The Contributor's name suffix. |
|
H |
CITY |
The Contributor's city. |
|
I |
STATE |
The Contributor's state. |
|
J |
ZIP |
The Contributor's ZIP code. |
|
K |
EXPLANATION |
A description of the contribution. |
|
L |
RECORD ID |
The internal contribution ID issued by the Secretary of State's office. This ID can be used by elections staff to quickly reference a particular transaction. |
|
M |
FILED DATE |
The date the contribution was filed. |
|
N |
CONTRIBUTION TYPE |
The type of contribution. |
|
O |
RECEIPT TYPE |
The type of receipt. |
|
P |
CONTRIBUTOR TYPE |
The type of Contributor. |
|
Q |
ELECTIONEERING |
This field is populated with YES or blank. |
|
R |
COMMITTEE TYPE |
The type of Committee. |
|
S |
COMMITTEE NAME |
The name of the recipient Committee. |
|
T |
CANDIDATE NAME |
The name of the recipient Candidate if this is a Candidate Committee and a Candidate record is linked to the Committee. |
|
U |
EMPLOYER |
The contributor's employer if provided. |
|
V |
OCCUPATION |
The contributor's occupation if provided. |
|
W |
AMENDED |
Y/N indicator to show if an amendment was filed for this record. |
|
X |
AMENDMENT |
Y/N indicator to show if this record is an amendment to a previously filed record. |
|
Y |
AMENDED RECORD ID |
The record ID of the original record that was amended by this record. |
|
Z |
JURISDICTION |
The jurisdiction name. |
|
AA |
OCCUPATION COMMENTS |
The Contributor’s occupation description if the Contributor's occupation is listed as "Other". This field is used for individual Donors only. |
|
Field Position |
Field Name |
Description |
|
A |
CO_ID |
(Committee ID) - The alphanumeric ID of the Payor Committee or the Candidate if the Candidate does not have a Committee. |
|
B |
EXPENDITURE AMOUNT |
Expenditure Amount. |
|
C |
EXPENDITURE DATE |
Expenditure Date. |
|
D |
LAST NAME |
The Payee's last name, if individual, or full name of an entity. |
|
E |
FIRST NAME |
The Payee's first name. |
|
F |
MI |
The Payee's middle initial. |
|
G |
SUFFIX |
The Payee's name suffix. |
|
H |
CITY |
The Payee's city. |
|
I |
STATE |
The Payee's state. |
|
J |
ZIP |
The Payee's ZIP code. |
|
K |
EXPLANATION |
A description of the expenditure, which must be declared. |
|
L |
RECORD ID |
The internal expenditure ID issued by the Secretary of State's office. This ID can be used by elections staff to quickly reference a particular transaction. |
|
M |
FILED DATE |
The date the expenditure was filed. |
|
N |
EXPENDITURE TYPE |
The type of expenditure. |
|
O |
PAYMENT TYPE |
The type of payment. |
|
P |
DISBURSEMENT TYPE |
The type of disbursement. |
|
Q |
ELECTIONEERING |
This field is populated with YES or blank. |
|
R |
COMMITTEE TYPE |
The type of Committee. |
|
S |
COMMITTEE NAME |
The name of the paying Committee. |
|
T |
CANDIDATE NAME |
The name of the Candidate if this is a Candidate Committee and a Candidate record is linked to the Committee or if the Candidate does not have a Committee. |
|
U |
NOT USED |
|
|
V |
NOT USED |
|
|
W |
AMENDED |
Y/N indicator to show if an amendment was filed for this record. |
|
X |
AMENDMENT |
Y/N indicator to show if this record is an amendment to a previously filed record. |
|
Y |
AMENDED RECORD ID |
The record ID of the original record that was amended by this record. |
|
Z |
JURISDICTION |
The jurisdiction name. |
|
AA |
NOT USED |
|
|
Field Position |
Field Name |
Description |
|
A |
CO_ID |
(Committee ID) - The alphanumeric ID of the Committee that received the loan. |
|
B |
PAYMENT AMOUNT |
The loan's principal payment amount, which may be blank if this record is for the loan origination only. |
|
C |
PAYMENT DATE |
The loan's payment date, which may be blank if this record is for the loan origination only. |
|
D |
NAME |
The source of the loan. |
|
E |
NOT USED |
|
|
F |
NOT USED |
|
|
G |
NOT USED |
|
|
H |
CITY |
City. |
|
I |
STATE |
State. |
|
J |
ZIP |
ZIP Code. |
|
K |
NOT USED |
|
|
L |
RECORD ID |
The internal loan ID issued by the Secretary of State's office. This ID can be used by elections staff to quickly reference a particular transaction. |
|
M |
FILED DATE |
The date the loan was filed. |
|
N |
TYPE |
Indicates if this record is for loan origination (O) or loan payment (P). |
|
O |
LOAN SOURCE TYPE |
The type of loan source. |
|
P |
LOAN AMOUNT |
The dollar amount of the loan. |
|
Q |
LOAN DATE |
The date the loan was received. |
|
R |
COMMITTEE TYPE |
The type of Committee. |
|
S |
COMMITTEE NAME |
The name of the recipient Committee. |
|
T |
CANDIDATE NAME |
The name of the Candidate if this is a Candidate Committee. |
|
U |
INTEREST RATE |
The interest rate of the loan. |
|
V |
INTEREST PAYMENT |
The dollar amount of the interest payment. |
|
W |
AMENDED |
Y/N indicator to show if an amendment was filed for this record. |
|
X |
AMENDMENT |
Y/N indicator to show if this record is an amendment to a previously filed record. |
|
Y |
AMENDED RECORD ID |
The record ID of the original record that was amended by this record. |
|
Z |
JURISDICTION |
The jurisdiction name. |
|
AA |
LOAN BALANCE |
The loan's principal balance. |
To access the Campaign Finance Data Download page:
Click the download tab. If the Download tab isn't visible in the menu bar, click the my admin homepage link near the top of the current page.
The Campaign Finance Data Download page is displayed.
To download campaign finance data:
|
Note: Required fields are indicated by an asterisk * to the right of the label and must be completed. |
In the Download Data section, click the link for the file you want to download.
The File Download dialog box is displayed.
Click the save button.
The Save As dialog box is displayed.
Navigate to the folder where you want to save the file.
Click the save button. 
To view the file in your browser window, click the open button. If you choose to view the file, the file may be slow to open depending on the speed of your network connection and the number of records in the export file.
Excel allows a maximum of 65, 536 rows. If the export file contains more records than Excel can accommodate, a message is displayed stating the file did not load completely. To view the entire file, you must choose to save rather than open the file and then open it in another application such as Microsoft Access.
The file is saved to the location you specified.
Copyright 2014 Quest Information Systems. All Rights Reserved.