candidate_keyword_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 rolling count of keywords associated with specific candidates in 90 day windows 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 start the beginning of the time window associated with this candidate + keyword pair date end the end of the time window associated with this candidate + keyword pair term a specific keyword identified in coverage of a candidate count number of news articles about the given candidate published in the given time window mentioning the given term