campaign_summary

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 docid\ pki2wftcvogqghoyar1cp and elections docid 9ru8vxd4ditwriowunams 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 person level data – summarizing a campaign's fundraising activity over the course of an election note we consider primary and general election campaigns to be distinct primary campaigns include only fundraising activity up to the primary election date general election campaigns include all fundraising activity up to the general election date – including any fundraising activity from the primary schema column description campaign id unique id associated with a political campaign last updated at the date a campaign's fundraising data was last updated total raised the total amount raised by a campaign itemization count the number of itemized contributions in our database associated with a campaign pct female the share of a campaign’s donors estimated to identify as female pct age 18 to 34 the percent of a campaign’s donors estimated to be between the ages of 18 and 34 pct age 35 to 54 the percent of a campaign’s donors estimated to be between the ages of 35 and 54 pct age 55 plus the percent of a campaign’s donors estimated to be 55 or older pct aapi the percent of a campaign’s donors estimated to identify as an asian american or pacific islander pct black the percent of a campaign’s donors estimated to identify as black pct latinx the percent of a campaign’s donors estimated to identify as having latin american heritage pct white the percent of a campaign’s donors estimated to identify as white