Campaign finance

campaign_itemizations

We work with partners to gather and process campaign finance data at the state and federal levels. We then match that data to our People﻿ and Elections﻿ datasets so we can make better targeting and messaging recommendations to Matchbook users. For Stacks users, these connections enable numerous additional use cases – such as forecasting and better-informed donor prospecting.
This table includes itemization-level data – typically individual contributions from voters to specfic campaigns, but also including loans, candidate self-funding, and transfers.
Schema
Column
Description
transaction id
Unique ID associated with the itemized contribution
transaction type
The type of transaction described in this record. Options include "direct," "loan," "in-kind," "transfer," "refund," "self-financing," or "other."
transaction date
The date of the transaction in YYYY-MM-DD format
campaign id
Unique ID associated with the campaign receiving an itemized contribution
contributor person id
The unique person_id from People﻿ for the person associated with this transaction. (Note: we will only share this ID if we were able to generate a match with reasonable confidence. Otherwise, this will be NULL but the contributor's unmatched details will remain populated in the other contributor_* columns.)
contributor is individual
Boolean indicating whether the contributor is a person (TRUE) rather than an organization or committee (FALSE).
contributor name first
The first name of the contributor, if available.
contributor name last
The last name of the contributor, if available.
contributor state
The contributor's reported state of residence.
contributor zip
The contributor's reported ZIP code of residence.
contributor industry
The high-level industry associated with the contributor's occupation, if available.
is in kind
Boolean indicating whether this contribution was made in the form of free goods or services (TRUE) rather than being a direct monetary contribution (FALSE).
amount
The cash value (or in the case of in-kind contributions, the cash-equivalent value) of the contribution.
﻿

Column	Description
transaction id	Unique ID associated with the itemized contribution
transaction type	The type of transaction described in this record. Options include "direct," "loan," "in-kind," "transfer," "refund," "self-financing," or "other."
transaction date	The date of the transaction in YYYY-MM-DD format
campaign id	Unique ID associated with the campaign receiving an itemized contribution
contributor person id	The unique person_id from People for the person associated with this transaction. (Note: we will only share this ID if we were able to generate a match with reasonable confidence. Otherwise, this will be NULL but the contributor's unmatched details will remain populated in the other contributor_* columns.)
contributor is individual	Boolean indicating whether the contributor is a person (TRUE) rather than an organization or committee (FALSE).
contributor name first	The first name of the contributor, if available.
contributor name last	The last name of the contributor, if available.
contributor state	The contributor's reported state of residence.
contributor zip	The contributor's reported ZIP code of residence.
contributor industry	The high-level industry associated with the contributor's occupation, if available.
is in kind	Boolean indicating whether this contribution was made in the form of free goods or services (TRUE) rather than being a direct monetary contribution (FALSE).
amount	The cash value (or in the case of in-kind contributions, the cash-equivalent value) of the contribution.

Updated 16 Sep 2024

Campaign finance

campaign_summary