Campaign Finance Data Schema

Hon Lin

Last Updated: March 30, 2022 19:36

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 module'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

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 module'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