Media

candidate_article_count_log

Each day, we use the Quantexa News API to gather articles relevant to the thousands of active campaigns 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.

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 Quantexa estimate sentiment.)

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 Quantexa estimate sentiment.)

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 Quantexa estimate sentiment.)

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.