Campaign Contribution Data Schema
API Field Name |
Field Type
|
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 |
Campaign Expenditures Data Schema
API Field Name |
Field Type
|
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 |
Comments
Article is closed for comments.