campaign_media_summary

each day, we use the https //aylien com/product/news api and https //developers google com/custom search/v1/overview to gather media coverage relevant to the 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 https //developers google com/custom search/v1/overview 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 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) https //aylien com/blog/using entity level sentiment analysis to understand news content https //aylien com/product/news api https //aylien com/blog/using entity level sentiment analysis to understand news content