Hubble by Deck
Search…
⌃K

candidate article count log

Each day, we use the Aylien 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. (Note: we have counts going back to 2008, but the coverage in the Aylien news database improves dramatically beginning in 2015.)

Schema

Field
Description
candidate id
Unique ID maintained by Deck representing a specific person running for a specific office in a specific district, which is kept the same across elections. (So a person running for the same district multiple times, in both primary and general elections, would keep the same candidate_id.)
date
The date that a set of news articles related to a candidate were published.
count total
The total number of news articles related to a given candidate published on a given day, as surfaced through data we’ve collected from Aylien.
count positive
The total 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 Aylien estimate sentiment.)
count neutral
The total 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 Aylien estimate sentiment.)
count negative
The total 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 Aylien estimate sentiment.)
count local
The total 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 Aylien.

Example entry

[
{
"candidate_id": "40b7f917-c5a7-4aec-9cfb-54a0e218e38d",
"date": "2020-07-24",
"count_total": "82",
"count_positive": "19",
"count_neutral": "22",
"count_negative": "41",
"count_local": "2"
}
]