campaign_media_summary

each day, we use the quantexa news api https //aylien com/product/news api and google programmable search api to gather media coverage relevant to the thousands of active campaigns https //decktools gitbook io/hubble by deck/election/campaign in our database this table shows a high level summary of each campaign's coverage schema field description campaign id unique id representing a specific political campaign a campaign is a unique combination of a candidate and an election so for a primary and general election, a single candidate would have two different unique values for campaign id search result count number of search results identified via the google programmable search api for a given campaign in the 250 day window leading up to election day article count number of news articles related to a given candidate published in the 250 day window leading up to election day, as surfaced through data we’ve collected from quantexa https //aylien com/product/news api sentiment index an average of the sentiment associated with each article mentioning a candidate (+1 is completely positive, 0 is neutral, and 1 is completely negative) learn more about how our partners at https //aylien com/blog/using entity level sentiment analysis to understand news content quantexa https //aylien com/product/news api estimate sentiment https //aylien com/blog/using entity level sentiment analysis to understand news content