Hubble by Deck
Searchโ€ฆ
candidate keyword 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 keywords used in proximity to mentions of candidates. Each row represents usage of a single keyword that was used in proximity to a single candidate over a given time period (usually a month). This table includes counts going back to 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 start
The beginning of the time window associated with a given term's usage in proximity to a given candidate.
date end
The end of the time window associated with a given term's usage in proximity to a given candidate.
term
A word or short phrase used in mentions of a given candidate during a given time window in Aylien's media database.
count
The number of times a given term was mentioned in proximity to a given candidate in a given date range.

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"
}
]
Export as PDF
Copy link
On this page
Schema
Example entry