candidate_article_count_log

each day, we use the quantexa news api https //aylien com/product/news api to gather articles relevant to the thousands of active campaigns https //decktools gitbook io/hubble by deck/election/campaign in our database this table shows a daily snapshot of data gathered for each candidate schema field description candidate id unique id representing a specific person running for a specific office in a specific district, which is held constant across elections date date that a set of news articles related to a candidate were published count total number of news articles related to a given candidate published on a given day, as surfaced through data we’ve collected from quantexa https //aylien com/product/news api count positive number of news articles published on a given day classified as having positive sentiment toward a given candidate ( 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 ) count neutral number of news articles published on a given day classified as having neutral sentiment toward a given candidate ( 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 ) count negative number of news articles published on a given day classified as having negative sentiment toward a given candidate ( 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 ) count local number of news articles related to a given candidate published in local in district news sources on a given day, as surfaced through data we’ve collected from quantexa https //aylien com/product/news api