Campaign Finance Data Schema

Campaign Contribution Data Schema

API Field Name

Field Type
(example value)

Required?

Notes

filer_id Text
0000001A
Required Unique ID representing a candidate.
filer_name Text
Jane Doe
Required Full name of a candidate. Used in application's search feature.
contributor_name Text
John Doe
Required Full name of the individual or organization who made the contribution.
contributor_type Text
Individual/Organization
Required Used to filter contributions by individuals or organizations.
contributor_address Text
1234 Street City, State Zip Code
Required Full address of contributor to be used for geocoding a location.
contributor_location Point
POINT (longitude latitude)
Required  
amount Number
150 ($)
Required Amount (inUSD) of the contribution.
receipt_date Date & Time
01/31/2020
Required Date the contribution was received. Used as a filter parameter.
election_year Number
2020
Required The election year in which the candidate ran for office. Used as a search parameter.
office Text
Governor, State Senator, etc.
Recommended Name of office that candidate ran for. Used as a search parameter.
jurisdiction Text
King County
Recommended  
party Text
Democrat, Republican, etc.
Recommended  

 

Campaign Expenditures Data Schema

API Field Name

Field Type
(example value)

Required?

Notes

filer_id

Text

NASSC2110

Required Unique ID representing a candidate.
filer_name Text
Jane Doe
Required Full name of a candidate. Used in application's search feature.
election_year Number
2020
Required The election year in which the candidate ran for office. Used as a search parameter.
recipient_name Text
John Doe
Required Full name of the individual or organization who received the payment.
amount Number
150 ($)
Required

Amount (in USD) of the expenditure.

expenditure_date Date & Time
01/31/2020
Required

Date the expenditure was made. Used as a filter parameter.

expenditure_type

Text

Operation and Overhead

Required

Type of expenditure. Used for Expenditure Category chart.

This is calculated based on the Expenditure Code and Description to make more human readable.

expenditure_description

Text

Office Supplies - Office Depot

Recommended

Description of the Expenditure

recipient_address Text
1234 Street City, State Zip Code
Required

Full address of the recipient. Used for uniquely identifying the Top Recipients.

recipient_location Point
POINT (longitude latitude)
Calculated (Optional)  
office Text
Governor, State Senator, etc.
Recommended

Name of office that candidate ran for. Used as a search parameter.

jurisdiction Text
King County
Recommended  
party Text
Democrat, Republican, etc.
Recommended  
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.