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.
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. |
[
{
"candidate_id": "40b7f917-c5a7-4aec-9cfb-54a0e218e38d",
"date_start": "2023-01-01",
"date_end": "2023-01-05",
"term": "labor",
"count": "14"
}
]
Last modified 1mo ago